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 |