Visual code queries
linkIntroduction
This chapter describes the various types of queries that can be inserted in programs through Visual Code.
select into variables | used to execute a query and store the data returned in in-memory variables |
select into recordset | used to execute a query and store the entire recordset returned |
update | Used to update the data in a table |
delete | used to delete data from a table |
insert values | used to insert a new row into a table |
insert select | used to insert new rows into a table |
subquery | Used to extract data related to the main query |
union | Adds rows to the result returned by the main query |
joins between tables | Describes how to link the tables in a query |
order by - group by | Describes how to add sorting clauses |
select into collection | Allows a query to be executed and a collection of documents to be loaded |
Changed on: 04/10/2013 / From version: 9.0.3940