×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Add a table to a DDF

Add a table to a DDF

Add a table to a DDF

(OP)
I have a lot of tables created in a Btrieve database format, i have installed Pervasive PSQL 9 ...

can anyone tell me how to 'import' my old data, or to add the tables to a DDF so that i can access them through the pervasive database, rather than direct from the file?

Thanks

RE: Add a table to a DDF

If the file definition is missing from the DDF file then you can try BtSearch at www.nssdd.com to help you analyze the structure and build the DDF files.  Once you have the DDF files you can create an ODBC connection and extract your data or BtSearch will also export to CSV or dbase formats.

Gil

RE: Add a table to a DDF

(OP)
the trouble is that the files were created by our accounting package (TasBooks) and i don't have much clue as to the structure ...

i am on the server with the files, in fact the tables are in the same directory as the DDF files ... brand new database ...

I just want the database to pick up the files i've got.

Also, i created a table with the pervasive tools using the Pervasive PSQL Control center in the same directory, using the btrieve maintenance utility, but that failed to be added to the system.

is there no tool that comes with the server software that will allow me to do this?  Do i have to pay for a seperate add on just to get the data, which is sitting on the disk in the correct format, to be recognised by the DDF files?

I was wondering about using the ActiveX control DDFAddTable, but am unsure how to do this, and whether this would help at all anyway.

RE: Add a table to a DDF

Just to confirm your DDF files with your data you can take a look at BtSearch32.  It will allow you to select one directory for your data and one for your DDF files.

Also you might copy the DDF files to where the data that you want to view is stored then use the Pervasive control panel to add the table to the list in the control panel.  

Gil

RE: Add a table to a DDF

(OP)
*

Also you might copy the DDF files to where the data that you want to view is stored then use the Pervasive control panel to add the table to the list in the control panel.  

*

how would i do this? i haven't found a way off adding existing tables yet, any help would be really appreciated.

Jon

RE: Add a table to a DDF

After you open the control panel you should see an icon with Pervasive.SQL Engines.  Double Click and you should see your computer which is hosting Pervasive V9.  Double click again.  Now you have Databases Engine, Databases Client.  Double click databases Engine.  You should see the Demodata icon.  If you right-click and select New Database.  Give it a name and navigate to the directory where your data and DDF files are located (Must be same directory).  click Next and Finish and it should add the Icon with the name you assigned.  Double click and it will open your tables.

Hope that helps.

Gil

RE: Add a table to a DDF

(OP)
Umm ... i don't have DDF files already, just btrieve tables, do i need a tool like btsearch in order to create them?

doesn't the database have any way of doing this itself?

RE: Add a table to a DDF

Quote:

doesn't the database have any way of doing this itself?
No, the database doesn't know the record structure of the Btrieve files. You (or the developer of the application) need to create the definitions within the DDFs.  

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com

RE: Add a table to a DDF

As Mirtheil pointed out Btrieve files do not contain the record structure within the files.  That is why the external DDF files are required.  DDF files are in themeselves Btrieve files.  These then contain the field structures so that ODBC or other 3-rd party can access your data.  

And BtSearch32 will help you analyze the structure and build the DDF files.

Gil

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close