>Thanks for the reply Hank,
>
>I watched your video from last May on Lianja and was very impressed. Is there another video out there showing a more in depth walk through of Foxpro under the hood (secret sauce) within the Lianja IDE ? Also I assume you can't use Foxpro visually within the environment only stick the code in an event. How do go about connecting remotely to MySQL ?
>Code a SQLStringConnect in an event as well ? You can't add a database within the IDE ?
>
>Guess these are typical forum questions ?
>
>
>Don

You access MySQL through virtual tables. These act like readwrite cursors in Lianja.

That said, Lianja SQL Server is enterprise ready (and used in banking/financial institutions because of its stability and security) and has the advantage that stored procedures can be written in VFPish, including SEEK)() and a keymatch(), which doesn't change the record pointer. Blazing fast RI with little hit on the backend server; even less if installed on Linux, as tempfs will keep the most-used indexes in memory (and Lianja refreshes the index if the underlying table has changed since being loaded).

Have you watched the videos available on the Lianja site? They are extremely well done.

There will be additional sources made available both from Lianja and from us (ProSysPlus). It's all coming together.

thanks,

Hank