Modifying ddfs
Modifying ddfs
(OP)
I have several.btr files that are not included in the ddfs supplied by the vendor. I know the table structure of these files. How do I modify the ddfs to look at these files?
I added a new table in Pervasive 9 control center, but it created a NEW file with a .mkd extension rather than looking atthe existing .btr file.
Any insights appreciated.
I added a new table in Pervasive 9 control center, but it created a NEW file with a .mkd extension rather than looking atthe existing .btr file.
Any insights appreciated.
Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports
www.gainfocus.biz
"A fine is a tax for doing wrong. A tax is a fine for doing well.
" - unknown
RE: Modifying ddfs
The IN DICTIONARY clause tells the engine to only modify the DDFs and won't modify the data file.
Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com
RE: Modifying ddfs
Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports
www.gainfocus.biz
"A fine is a tax for doing wrong. A tax is a fine for doing well.
" - unknown
RE: Modifying ddfs
CREATE TABLE test IN DICTIONARY USING 'test.btr'
(f1 char(10),
f2 char(20),
f3 char(30))
The IN DICTIONARY can also be applied to the CREATE INDEX statement:
CREATE INDEX idxF1 IN DICTIONARY ON test (f1)
The CREATE TABLE will create an entry in the DDFs pointing to "test.btr" but won't overwrite "test.btr".
The CREATE INDEX will create an index entry in the DDF but won't modify the underlying data file.
Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com