Executes SQL statements from GeneXus Client/Server applications.
SQL [ Sql statement ]
[ SQL statement ]
Statement to be executed. Character.
Objects: Procedure, Transaction, Web Panel
Generators: .NET, .NET Framework, Java, Ruby (up to GeneXus X Evolution 3), Visual FoxPro (up to GeneXus X Evolution 3)
The sentence after the SQL constant will be executed.
A comment will appear in the generated code, indicating that a user SQL statement is being executed.
You can use just a literal:
SQL DELETE FROM CLIENTES
Or you can use variables. These should be between “ [ !” and “! ] ”:
&Role = "MyRole"
SQL SET ROLE TO [!&Role!]
- When using variables, make sure you use basic datatypes (Character, Number, etc), SDTs references are not allowed.
- SQL commands are always executed in the default data store SAC 23118.
- SQL command does not need to specify a semicolon at the end of the command.
- The statement executed cannot return any value, it cannot be processed from the GeneXus side.