SQL

Home

4D v20.1

SQL

Constant	Type	Value	Comment
SQL all records	Longint	-1
SQL asynchronous	Longint	1	0 = Synchronous connection (default value), 1 (or value other than 0) = Asynchronous connection
SQL charset	Longint	100	Text encoding used for requests sent to external sources (via the SQL pass-through). The modification is carried out for the current process and the current connection. Possible values: MIBEnum identifier (see note 2) or value -2 (see note 3) By default: 106 (UTF-8)
SQL connection timeout	Longint	5	Maximum timeout awaiting response when executing the SQL LOGIN command. This value must be set before opening the connection in order to be taken into account Possible values: time in seconds By default: no timeout
SQL data chunk size	Longint	6	Size of data chunk to be sent to the server. This option is mainly useful with Sybase ODBC driver which does not support actual data chunk. Setting a value greater than the default one allows larger data to be sent at a time. Value: size in bytes By default: 8000
SQL max data length	Longint	3	Maximum length of data returned
SQL max rows	Longint	2	Maximum number of rows in resulting group (used for previews)
SQL On error abort	Longint	1	In the event of an error, 4D immediately stops script execution.
SQL On error confirm	Longint	2	In the event of an error, 4D displays a dialog box describing the error and allowing the user to interrupt or continue script execution.
SQL On error continue	Longint	3	In the event of an error, 4D ignores it and continues script execution.
SQL param in	Longint	1
SQL param in out	Longint	2	Usable only in the context of an SQL stored procedure (in-out parameter defined in the stored procedure)
SQL param out	Longint	4	Usable only in the context of an SQL stored procedure (out parameter defined in the stored procedure)
SQL query timeout	Longint	4	Maximum timeout awaiting response when executing the SQL EXECUTE command. Values: time in seconds By default: no timeout
SQL use access rights	String	SQL_Use_Access_Rights	Used to restrict the access rights to be applied during execution of the SQL commands of the script. When you use this attribute, you must pass 0 or 1 in attribValue: attribValue = 1: 4D uses the access rights of the current 4D user. attribValue = 0 (or attribute not specified): 4D does not restrict access, the Designer rights are used.
SQL_INTERNAL	String	;DB4D_SQL_LOCAL;
System data source	Longint	2
User data source	Longint	1