SYS(8005) - Microsoft SQL Server Compact Edition support

Top Previous Next

Provides additional support for the Microsoft SQL Server Compact Edition that have no native counterparts in the language and cannot be accessed through SQLEXEC()

Syntax

SYS( 8005, cCommand, cConnectionString )

Parameters

cCommand

Specifies one of the commands from the list. All commands are case insensitive, but cannot be abbreviated:

Command	Description
Update	Updates the database to the current version of the database engine. If the database already is at the current version, SYS(3005) returns immediately.
Create	Creates a new, empty database with the name speciefied in the connection string.

cConnectionString

Specifies the location of the database as well as additional options. A basic connection string requires the Data Source setting:

"Data Source=Northwind.sdf"

On mobile devices you should specify the full path to the database, since many mobile devices do not support current directories. While Guineu simulates those for regular xBase statements, Guineu does not alter any connection string to adjust path names.

Return value

Returns a string indicating the name of the current engine. If you don't pass a second parameter, Guineu returns the state without changing it.