Add SQL Database to Lianja

[Edwin_pty]

I have a sql database, how I can add to lianja? This database is currently being used by an application developed in VFP

Thanks for your help.

[lianjasupport]

What type of SQL database? MSSQL?

[Edwin_pty]

yes, the same, and contains records of several years and I want to migrate the application.

[barrymavin]

You can just open it as you would in VFP using SQLCONNECT(), SQLEXEC() or CursorAdaptor.

Lianja also lets you specify CONNSTR on the USE command:

use yourtable connstr 'odbc_dsn' where expression


Update: Since this post Lianja has implemented VirtualTables which handle the connection, cursoradaptor and transparent database access for you as if they were local tables. See the CREATE VIRTUALTABLE command in the documentation wiki