Additions: We have a directory structure with root for central files and subdirectories for each company number. In the past, we couldn't find an easy solution to connect with ODBC. Some messages of today from Steve Blank and others give us the following idea. Structure (SHOPN=Root. 000,001,...,999 = company number.)
The tables are flexible defined with %FIRMA% stored in Locical Names and the company (Firma) can be selected in Magic.
Write a start program to correct the data location in file.ddf
As each table name has a well defined prefix, we know which table is at root and which at company subdirectory. The start program is called after each change of the company number.
If the prefix is 'N' and if not done before
> update fileloc (in file.ddf) to CompanyNo&'\'&fileloc
Deletions: We have a directory structure with root for central files and subdirectories for each company number. In the past, we don't found an easy solution to connect with ODBC. Some messages of today from Steve Blank and others give us the following idea.Structure (SHOPN=Root 000,001,...,999 = company number)
The tables are flexible defined with %FIRMA% stored in Locical Names and the company (Firma) can selected in Magic.
Write a start programme to correct the data location in file.ddf
As each table name has a well defined prefix, we know witch table is at root and witch at company subdirectory. The start programme is called after each change of the company number.
If the prefix is 'N' and if not done before
Additions: second draft
Prefix 'T' = Root for all companies
Prefix 'N' = File stored in company subdirectory
If the prefix is 'N' and if not done before
Additions: As each table name has a well defined prefix, we know witch table is at root and witch at company subdirectory. The start programme is called after each change of the company number.
Prefix 'N' = Subdirectory (company company number 000 - 999)
Draft function
Deletions: PervasiveODBCchangeLocation
As the table names has an well defined prefix, we know witch table is at root and witch at company subdirectory. The start programme is called after each change of the company number.
Prefix 'N' = Subdirectory (company number 000 - 999)
Additions: (oh oh - this is not easy for me to explain in english. Please correct all my spelling!)
The tables are flexible defined with %FIRMA% and can selected.
Create Pervasives DDFs to access in Magic.
Write a start programme to correct the data location in file.ddf
As the table names has an well defined prefix, we know witch table is at root and witch at company subdirectory. The start programme is called after each change of the company number.
Example:
Prefix 'T' = Root
Prefix 'N' = Subdirectory (company number 000 - 999)
If the prefix is 'T'
We have a directory structure with root for central files and subdirectories for each company number. In the past, we don't found an easy solution to connect with ODBC. Some messages of today from Steve Blank and others give us the following idea.
Structure (SHOPN=Root 000,001,...,999 = company number)
