Unfortunately, I have not found anything right on point and being new to this I was hoping for some input The structure of the sql table and foxpro table are the same.
I simply want to put the foxpro data into the sql table as easily as possible.
Do you load ALL customers ALL orders and ALL orderitems to display or print a certain order? In VFP you might have been used to opening all these tables and navigate to the specific data of one order, but that doesn't apply to an SQL Server database.
You can still use cursors instead of tables and reuse all the code you have to navigate to data, but you also only retrieve the portion of the data needed.
It includes a feature-complete cross platform implementation of the Visual Fox Pro scripting language and database engine.
However, I am running up against the 2gb limit and from a prior post it was suggested to use sqlexec() instead of table update.
The update command seems to go column by column and since there are a lot of columns, I would rather not do that unless I have to. Use foxprotablename SCATTER MEMVARsqlexec(connectionstring, 'insert into sqltablename from memvar')Thanks for any thoughts. What SQLEXEC() does is it sends a command to a back-end database, typically SQL Server, Oracle, My SQL or something similar.
The command is the second parameter (the INSERT command in your example).
Additionally, Python, PHP and Java Script are seamlessly integrated on top of the Lianja database engine, allowing you to build custom UI sections and custom UI gadgets in Visual Fox Pro, Java Script, PHP or Python and make full use of the power of this high performance database engine with local cursors and complete SQL and no SQL database support.
To facilitate the development of custom UI sections and gadgets, Lianja comes with a cross-platform, UI independent application framework called the Lianja UI Framework.