Please enable JavaScript to view this site.

Navigation: Advanced topics > Programming topics > SQLQuery class > Methods

SQLQuery class: deleteField

Scroll Prev Next More

 

Removes the name of the field from the SELECT clause of the current SQL query.

 

Note: SQLQuery class methods are used in the After table initialized event.

Syntax

deleteField field

Arguments

field

the name of the field. Example: "size".

Return value

No return value.

Example

Remove the name of the field from the SELECT clause (the data from the field 'id_sizes' is no longer requested):

 

query.deleteField "id_sizes"

 

Note: use the deleteField function to delete the alias field created by the addField function.

See also:

SQLQuery class: addField

Event: AfterTableInit

SQL tab

About SQLQuery class