A Shortcut C++ Definition

The setQueryFrom member function allows you to define an IliSQLTable that has only one database table. Here is an example:

IlvDisplay* display;

...

// Create the IliSQLTable object.

IliSQLTable* sqlTbl = new IliSQLTable(display);

sqlTbl->lock();

// Define its session.

IliSQLSession* session;

session = new IliSQLSession(“oracle”, “scott/tiger@orasrv”);

sqlTbl->setSQLSession(session);

// Define the IliSQLTable object.

IliSQLTableRef tblRef(“EMP”, “SCOTT”);

sqlTbl->setQueryFrom(tblRef);

The setQueryFrom member function reads the schema of the given database table and defines the IliSQLTable object accordingly.

Version 6.3