QueryOpen

Prototype

IntTableHandle:=QueryOpen(Alias,strSQLInstr)

Description

It makes a SQL query on a database and returns the table handle.

Parameters

Alias: Database Alias.

StrSQLInstr: SQL instruction to process.

Returned value

IntTableHandle: integer value corresponding to the handle of the virtual table returned from query.

In strSQL be careful to apostrophe (') and inverted commas (")

Notes

The returned value can be used with the functions operating on tables  (TableClose, TableRecordCount, TableFirst,…).

In strSQL be careful to apostrophe (') and inverted commas (").