Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2009

    Unanswered: Non standard db file names

    Hello All.

    I have a legacy system using dozens of pervasive files.
    An example of one of the files is &CUSTOMER.001

    The files are currently being accessed via the BTRIEVE api using
    transactional commands (readfirst, readnext, etc...)

    I want to make enhancements by adding on a new system that
    accesses the files using SQL. I am using the DDF builder to create an OEM
    data store.

    DDF builder generates an error when I try to assign the file to a the CUSTOMER table. DDF bulder does not like the '&' on the front of the file name. If I rename &CUSTOMER.001 to qCUSTOMER.001 I have no problem however in doing so the file is now not compatable with my legacy system.

    Is there a way to get pervasive to accept the '&' as part of the file name?

    Any help is appreciated.


  2. #2
    Join Date
    Dec 2001
    Provided Answers: 6
    I would suggest using a CREATE TABLE statement with a USING clause. This worked for me in a quick test:
    CREATE TABLE customer USING '&customer.001' (f1 char(10))
    Add an IN DICTIONARY clause to prevent the engine from recreating the Btrieve file:
    CREATE TABLE customer IN DICTIONARY USING '&customer.001' (f1 char(10))
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    I do not answer questions by email. Please post on the forum.

  3. #3
    Join Date
    Jan 2009
    Thanks Mirtheil. That took care of the problem.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts