4D v14.3

SQL

Home

 
4D v14.3
SQL

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  
 
PROPERTIES 

Product: 4D
Theme: List of constant themes

 
SEE ALSO 

GET DATA SOURCE LIST
SQL EXECUTE SCRIPT
SQL SET OPTION
SQL SET PARAMETER

 
ARTICLE USAGE

4D Language Reference ( 4D v12.4)
4D Language Reference ( 4D v11 SQL Release 6)
4D Language Reference ( 4D v14 R3)
4D Language Reference ( 4D v14 R2)
4D Language Reference ( 4D v13.5)
4D Language Reference ( 4D v14.3)
4D Language Reference ( 4D v14 R4)