Modifying ddfs

If you are using a CREATE TABLE statement, you can add the "USING" and the "IN DICTIONARY" clauses to specify existing files. The USING clause allows you to specify the actual filename. For example, CREATE TABLE table USING 'file.btr' (F1 char(10)).
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

Can you supply an example of this that I can mimic?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

"A fine is a tax for doing wrong. A tax is a fine for doing well.
" - unknown

Sure. Here's an example of a Create that uses both options I describe:
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