Virtual Tables - Lianja Cloud Server

Under Construction

See Also

• Introduction to Virtual Tables

• Syntax for the CREATE VIRTUALTABLE and ALTER VIRTUALTABLE Commands

• Properties and Methods of the CursorAdapter Class

• Virtual Tables - Further Configuration and Troubleshooting

• Virtual Tables - Local Development, Remote Deployment

Primary Key

Modify Virtual Table: Primary Key

Virtual tables used with the Lianja Cloud Server must have a unique primary key specified in the virtual table definition.

In the Data Workspace, select the virtual table name then right-click Modify virtual table ... to open the dialog.

Command: alter virtualtable ... keyfieldlist

Or the ALTER VIRTUALTABLE command can also be used.

Note: keyfieldlist and primarykey are synonymous.

Demo App

Creating the cloudlibtest database to run the example_webvirtualtables App ... coming soon.