Results 1 to 14 of 14
  1. #1
    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.

  2. #2
    Join Date
    Dec 2001
    Posts
    1,075
    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.

  3. #3
    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?

  4. #4
    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.

  5. #5
    Join Date
    Dec 2001
    Posts
    1,075
    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.

  6. #6
    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?

  7. #7
    Join Date
    Dec 2001
    Posts
    1,075
    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.

  8. #8
    Join Date
    Dec 2001
    Posts
    1,075
    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.

  9. #9
    Join Date
    Dec 2001
    Posts
    1,075
    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.

  10. #10
    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.

  11. #11
    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.

  12. #12
    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

  13. #13
    Join Date
    Dec 2001
    Posts
    1,075
    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.

  14. #14
    Join Date
    Nov 2012
    Posts
    10
    Thanks a lot for your help. I really appreciate it.

Posting Permissions

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