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 > open and edit btrieve .DAT file

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
Join Date: Nov 2012
Posts: 10
open and edit btrieve .DAT file

Hello,

I don't know much about this old database. I just need to change the suit number in a .DAT file. Can anyone please help me how to open and edit that DAT file?

Thanks in Advance.
Reply With Quote
  #2 (permalink)  
Old
Registered User
 
Join Date: Dec 2001
Posts: 1,069
Editing a Btrieve file requires a Pervasive PSQL engine or a Btrieve engine that can open the file. You would also need a tool that can open the file like the FUnction Executor. You'd then need to change the "suit number." You'd need to know where in the file (byte offset) and which record you need to change. You could then change it and update the record.
If, however, you have DDFs for the data file you can use the Pervasive Control Center or ODBC tools to issue a SQL statement.
Make sure to work on a backup so you don't screw up the original file.
If you can't, or don't want to do this, I'm sure there are Btrieve developers that might be able to do it for a fee.
__________________
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
Registered User
 
Join Date: Nov 2012
Posts: 10
Thanks a lot for your quick reply. I don't have the DDF file, only the DAT file. Is there any free software available to open DAT file and edit it? I found few tools by googling, but could not figure out how to edit DAT file. I also don't know any Btrieve developers who could help me. I will check if there are any PSQL Engine or Btrieve engine available for free. So I need both PSQL Engine/Btrieve Engine and Function Executor?
Reply With Quote
  #4 (permalink)  
Old
Registered User
 
Join Date: Nov 2012
Posts: 10
Thanks a lot for your quick reply. I don't have the DDF file, only the DAT file. Is there any free software available to open DAT file and edit it? I found few tools by googling, but could not figure out how to edit DAT file. I also don't know any Btrieve developers who could help me. I will check if there are any PSQL Engine or Btrieve engine available for free. So I need both PSQL Engine/Btrieve Engine and Function Executor?

Last edited by sbdk; 11-24-12 at 20:20.
Reply With Quote
  #5 (permalink)  
Old
Registered User
 
Join Date: Dec 2001
Posts: 1,069
There are no Btrieve / Pervasive engines available for free. There never have been and never will be. If the program that is generating the data file you want to change still runs, there is an engine.
Yes, you need both an engine and a tool to modify the table.
I've been developing with Btrieve for over 17 years.
__________________
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
  #6 (permalink)  
Old
Registered User
 
Join Date: Nov 2012
Posts: 10
Thanks for the information. The data file contains the office address and it is being used by a program. So if I understand correctly, the engine should be in that program folder and tools for modifying table should be purchased, right?
Reply With Quote
  #7 (permalink)  
Old
Registered User
 
Join Date: Dec 2001
Posts: 1,069
It might be in the same directory, and it may not. If the app is a DOS app, look for BTRIEVE.EXE or BREQUEST.EXE or BREQNT.EXE. If it's a Windows app, look for W32MKDE.EXE or W3DBSMGR.EXE. For the tools, you should look for WBEXEC32.EXE or WBEXEC.EXE. If you have a Btrieve / Pervasive installed engine, you should have the tools too.

Of course, the best solution is to change this data using the program that generated it.
__________________
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
  #8 (permalink)  
Old
Registered User
 
Join Date: Dec 2001
Posts: 1,069
The procedure is the same regardless of the version of Btrieve. THe tool might (and probably is) different. For example, Btrieve 5.10 for DOS came with BSIM.EXE. Btrieve 6.15 for Windows (16 bit) had WBEXEC.EXE. 32 Bit versions of Btrieve / PSQL have WBEXE32.EXE.

Looking at a DAT file will not tell you which program generated it.
__________________
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
  #9 (permalink)  
Old
Registered User
 
Join Date: Dec 2001
Posts: 1,069
The procedure is the same regardless of the version of Btrieve. THe tool might (and probably is) different. For example, Btrieve 5.10 for DOS came with BSIM.EXE. Btrieve 6.15 for Windows (16 bit) had WBEXEC.EXE. 32 Bit versions of Btrieve / PSQL have WBEXE32.EXE.

Looking at a DAT file will not tell you which program generated it.
__________________
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
  #10 (permalink)  
Old
Registered User
 
Join Date: Nov 2012
Posts: 10
Is there any way to know which program has generated that DAT file? It seems to be a very old DOS software. Also if the engine and tool is there, could you please tell the procedures to edit that DAT file.
Reply With Quote
  #11 (permalink)  
Old
Registered User
 
Join Date: Nov 2012
Posts: 10
Could you please look into the files of the program and let me know if that particular DAT file can be modified or not. I could upload into skydrive and send you the link.
Reply With Quote
  #12 (permalink)  
Old
Registered User
 
Join Date: Nov 2012
Posts: 10
here is the link to the files of that program. The CO.DAT file needs to be changed. https://skydrive.live.com/redir?resi...H_Rr-wsNkoIihs
Reply With Quote
  #13 (permalink)  
Old
Registered User
 
Join Date: Dec 2001
Posts: 1,069
The CO.DAT that I saw in the file is not a Btrieve file. It appears to be a Clarion file. Clarion had two file options. One was Btrieve and the other was a Clarion specific file format. It looks like yours is a Clarion file. Unfortunately, I'm not familiar with Clarion and don't know if you can update the file outside of the original application.
__________________
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
  #14 (permalink)  
Old
Registered User
 
Join Date: Nov 2012
Posts: 10
Thanks a lot for your help. I really appreciate it.
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