Italiano
Instant Developer Foundation Documentation
  • Visual Code reference

Visual code queries

link

Introduction

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