SYS(8004) - Switch SPT engine

Top  Previous  Next

Switches or returns the current SPT engine.

Syntax

SYS( 8004 [,cEngine] )

Parameters

cEngine

Name of the engine that is used for all subsequent SQLSTRINGCONNECT() operations. The following tables lists valid values:

 

cEngine

Description

odbc

Uses the ODBC driver to connect to a data source. The connection string must be a valid connection string that depends on the ODBC driver. With this engine, Guineu behaves like Visual FoxPro 9.0. Default setting for the desktop version.

compact

Uses the Microsoft SQL Server 2005 Compact database. The connection string must use the DataSource setting that points to a valid SDF file. The compact engine requires the "System.Data.SqlServerCe.dll" library to be either in the application directory or the global assembly cache.

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.