4D Doc Center : SQL

4D v13.4

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 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