USE DATABASE
This command allows to a Valentina Server Client to set some database to be active. But the database must be opened before on behalf of the current connection. This is REQUIRED if you are using the following methods of Valentina interface:
Valentina.SqlQuery() Valentina.SqlExecute() Valentina.SqlSelect()
If you are using methods of VDatabase interface then SQL commands go to this database directly.
To choose the MASTER database of a Valentina Server you can use:
USE DATABASE master
Syntax
USE [DATABASE] db_name
Arguments
- db_name - the name of database to become active.
Examples
Example
USE DATABASE accounts
Example
USE master
Example
REALbasic example:
Valentina.SqlQuery( "USE DATABASE accounts" ) Valentina.SqlSelect( "SELECT * FROM tblAccount ... ;" )