Another issue that could be improved in the DCU
Setup (Windows 10 system):
=> folder that contains the data dictionary files, and a prefixdb prefix file
=> in the dictionary, each logical table name is associated with data/physical as the physical pathname
=> folder that contains the ProvideX data files
When using the DCU, the prefix file entry is created as DATA\PHYSICAL
(since the key has the uppercase option set)
Therefore, if you do something like :
PREFIX FILE "prefixdb"
OPEN (nn) TABLE "logical"
ProvideX translates logical
(as set in the dictionary)
And thus does not find the entry in the PREFIX FILE and does not open the SQL table but rather the keyed file
Two possible solutions :
- Either create the PREFIX FILE entry the same as in the dictionary
- Or create 2 entries (DATA/PHYSICAL and DATA\PHYSICAL)