Creating the MSysConf Table

Create the MSysConf table in each remote database you want to work with. When you create the table, give all users of your application permission to use the SELECT statement on this table; the system administrator is the only person who needs permission to use INSERT, UPDATE, and DELETE statements. If your remote database is case-sensitive, you must type the table name and field names exactly as they appear in the following table.

Field name Data type Allows Null?
Config Any valid server data type that corresponds to a 2-byte integer No
chValue VARCHAR(255) Yes
nValue Any valid server data type that corresponds to a 4-byte integer Yes
Comments VARCHAR(255) Yes