Difference between revisions of "Imported Visual FoxPro Files"
Yvonne.milne (Talk | contribs) |
Yvonne.milne (Talk | contribs) |
||
| Line 1: | Line 1: | ||
''Under Construction'' | ''Under Construction'' | ||
=See Also= | =See Also= | ||
| − | [[Accordion Behavior]], [[Building Lianja Mobile business database Apps]], [[Command Line Switches]], [[Guide to the Data Workspace (Video)|Data workspace]], [[File Extensions]], [[Importing Visual FoxPro Databases and Tables]], [[Importing Visual FoxPro Files]], [[:Category:Lianja_Cloud_Server#Server_side_procedures|Lianja Cloud Server: Server side procedures]], [[:Category:Lianja SQL Server|Lianja SQL Server]], [[:Category:NoSQL Commands|NoSQL commands]], [[:Category:SQL|SQL commands]], [[Visual FoxPro Server Pages|Visual FoxPro Server Pages (.rsp)]] | + | [[Accordion Behavior]], [[Building Lianja Mobile business database Apps]], [[Command Line Switches]], [[Guide to the Data Workspace (Video)|Data workspace]], [[File Extensions]], [[Importing Visual FoxPro Databases and Tables]], [[Importing Visual FoxPro Files]], [[:Category:Lianja_Cloud_Server#Server_side_procedures|Lianja Cloud Server: Server side procedures]], [[:Category:Lianja SQL Server|Lianja SQL Server]], [[JavaScript built-in Lianja/VFP functions]], [[:Category:NoSQL Commands|NoSQL commands]], [[:Category:SQL|SQL commands]], [[Visual FoxPro Server Pages|Visual FoxPro Server Pages (.rsp)]] |
=Overview= | =Overview= | ||
Revision as of 10:50, 24 March 2017
Under Construction
Contents
See Also
Accordion Behavior, Building Lianja Mobile business database Apps, Command Line Switches, Data workspace, File Extensions, Importing Visual FoxPro Databases and Tables, Importing Visual FoxPro Files, Lianja Cloud Server: Server side procedures, Lianja SQL Server, JavaScript built-in Lianja/VFP functions, NoSQL commands, SQL commands, Visual FoxPro Server Pages (.rsp)
Overview
This article explains how imported Visual FoxPro databases, tables, programs, forms and class libraries can be used in your Lianja Apps.
For information on how to import Visual FoxPro files, see:
Databases and Tables
After importing Visual FoxPro databases and tables, the new files will be located in a sub-directory of lianja\data\ with the same name as the database.
Click here for file extension descriptions.
The imported database and tables are in Lianja native format, so can be viewed and modified in the Data workspace, bound to controls in Apps and used with commands, functions and SQL statements.
For a closer look at the new database and tables, open them in the Data workspace or from the Lianja/VFP command window (Console workspace, system menu or App Inspector):
open database recipes list database
Note that when Lianja imports Visual FoxPro tables, it also recreates production .cdx index tags in a .dbx file. To view just the indexes for a particular table, use the list indexes command.
use recingrd list indexes
If specific index tags are no longer required for use in Lianja, they can be deleted using the delete tag command. To remove all tags, use the nodbx keyword on the use command:
use recingrd nodbx
Since the database and tables are in Lianja native format, they cannot be opened directly from Visual FoxPro. The NoSQL copy to command and the SQL select statement can be used to save Lianja data in a variety of export formats. Alternatively, the Lianja ODBC Driver allows access to Lianja data via the Lianja SQL Server.
Programs, Forms and Class Libraries
Desktop Apps
Calling Directly
Embedding in Lianja Pages
Using Lianja Standard Sections
Web/Mobile Apps
