![]() ![]() LcDSNLess="DRIVER=Lianja ODBC Driver SERVER= DATABASE=southwind U id=someuser Pwd=somepassword"Ĥ) I got all records (2154 ?) from order_details table in Lianja console in 11ms. If I use a connection string instead of a pre defined data source name, Sqlstringconnect takes more time than Sqlconnect("ODBC"). Is there a way to do this in Lianja ?ģ) When I connect from vfp through ODBC to lianja server it takes more time to connect than other databases like MS SQL / Oracle. How can I create/save 'temporay tables' in lianja like in MS SQL server (created by # and #) ? Some of my current vfp prgs create multiple vfp cursors and then I display multiple reports in sequence like first summary report (based on vfp cursor1) and then detail report (based on vpf cursor 2). The objective is to provide these reports from Lianja cloud to our remote users. ![]() I want to convert these prgs to Lianja stored procedure so that I can rebuild/convert these reports in Lianja. I have vfp prg files which process some data and finally produces some cursors for vfp reports. How can I direct Lianja Sql server to execute my dbo files if corresponding prg files are missing ?Ģ) > to to get multiple result sets issue two sqlexec() calls. ? SQLEXEC(lnconn,"call sp_GetOrderDetails()")Ĭonnectivity error: File 'sp_GetOrderDetails.prg' does not exist 1) I renamed my prg file to some other name and now when I tried again I got this error.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |