Visual code queries

link

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