If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Pervasive.SQL > Access Lytech Chiro 2000 DAT files through Pervasive

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 04-06-07, 18:59
joveyboy joveyboy is offline
Registered User
 
Join Date: Apr 2007
Posts: 2
Access Lytech Chiro 2000 DAT files through Pervasive

Does anyone know how to access Lytech Chiro 2000 DAT files through Pervasive?

I have the DDF files and the list of tables are created.
But when I click on the tables, Pervasive cannot find the files.
No sure if I need to be looking for some other file type in the Lytech Chiro folder.

I am trying to export information to map it into another program.
Reply With Quote
  #2 (permalink)  
Old 04-07-07, 10:26
mirtheil mirtheil is offline
Registered User
 
Join Date: Dec 2001
Posts: 1,026
If you get a "file not found" type error opening a table, you've probably got hard coded paths in the DDFs.
Do you get results if you double click on the "X$FILE" table in the Pervasive Control Center? If so, check the table you are trying to open that gives the error and look at the "XF$LOC" field. Does it have just a file name or does it have a path and file name? If it's got a path and file name, you'll need to make sure the DDF and the data files are in the proper paths. ANother option would be to copy the DDFs and data files to another directory and remove the paths from the DDFs. You can do that using the PCC manually or you can use a third party tool (like my DDF Path Fixer at http://www.mirtheil.com/pathfixer.asp).
__________________
Mirtheil Software
Certified Pervasive Developer
Certified Pervasive Technician
Custom Btrieve/VB development
http://www.mirtheil.com
I do not answer questions by email. Please post on the forum.
Reply With Quote
  #3 (permalink)  
Old 04-09-07, 14:00
joveyboy joveyboy is offline
Registered User
 
Join Date: Apr 2007
Posts: 2
Talking

mirtheil,

Thank you!! That pointed me to the corresponding definitions of the tables. I was able to rename the DAT file to the difinition and then open it as a table.
i.e. Patient = LC01.DAT...
Rename Office05.DAT to LC01.DAT
Launch PPC and now the Patient table is available after loading....
Export to CSV...
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On