-
SQL Database Servers Connectivity
-
- Migrating Applications to Client-Server
- Configuring the Date Mapping for SAMs
- Defining Numeric Fields with Decimals
- Defining Tables in Zim
- Indexing Virtual Fields
- Flagging Objects for the SQL Server
- SQL Views
- SQL Table Subsets
- Uniquely Identifying the Compiled Application
- SQL Table "Owners"
- Naming Differences between Zim and SQL
- Caveats
-
ODBC Driver Connectivity
-
Zim Integrated Server (ZIS)
-
ZIM and DDE Services
-
ZimWeb
Flagging Objects for the SQL Server
If the Zim application already exists, then some modifications to the data dictionary definitions for EntitySets and data relationships must be performed. Specifically, the field “EntType” in the data dictionary EntitySet “EntitySets” and/or the field “RelType” in the data dictionary entity set “Relationships” must be flagged as residing on the SQL server. These fields should be set to the name associated with the server access module and the objects must be re-created.
If the application is to be developed for execution against a pre-existing SQL server database then it is likely that the table definitions have been loaded into the Zim data dictionary from the SQL server. The “EntType” fields should be set to the name associated with the server access module being used, and the objects recreated. Take advantage of Zim’s ability to access local data objects.
0 out Of 5 Stars
5 Stars | 0% | |
4 Stars | 0% | |
3 Stars | 0% | |
2 Stars | 0% | |
1 Stars | 0% |