USE DATABASE
This command allows to a Valentina Server Client to set some database to be active. 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 ... ;" )