Switch to: V9V8V7V6V5

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 ... ;" )