Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: CopyRecords command in reverse order

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    Feb 2009
    Location
    Kungsbacka, Sweden
    Posts
    841

    Default CopyRecords command in reverse order

    Hi!

    Is it possible to use CopyRecords to copy records by recnum descending.

    I am creating a program that will "auto-repair" a .dat file if corrupted by first copy by recnum in ascending order when it fails in descending order.

    Is there by any chanse a definition of how the DAT file is built? If the datfile is corrupted it would be nice to edit the position where the error is and keep a lot of data.
    Most of the time there is a lenght issue and if i can correct it with a hex-editor it would be great.

    /Martin
    Martin Arvidsson, Data Martin i Kungsbacka AB

    I have six locks on my door all in a row. When I go out, I lock every other one. I figure no matter how long somebody stands there picking the locks, they are always locking three.

  2. #2
    Join Date
    Feb 2009
    Location
    Stuart, FL
    Posts
    5,321

    Default Re: CopyRecords command in reverse order

    problem with using DF code to do this is that most times the runtime will not be able to open the files or read through them

    we have an application in C# that reads and repairs DataFlex DAT files
    Michael Salzlechner
    StarZen Technologies, Inc
    http.://www.starzen.com

    IT Director at Balloons Everywhere

    Development Blog
    http://www.salzlechner.com/dev

    DataFlex Package Manager (aka Nuget for DataFlex)
    http://windowsdeveloper.com/dfPackage

  3. #3
    Join Date
    Feb 2009
    Location
    Kungsbacka, Sweden
    Posts
    841

    Default Re: CopyRecords command in reverse order

    Quote Originally Posted by starzen View Post
    problem with using DF code to do this is that most times the runtime will not be able to open the files or read through them

    we have an application in C# that reads and repairs DataFlex DAT files
    Hi! I know you have, i did respond to your email i got but did not receive any answer But I can not hire you for every time it happens because first of all there is a time-difference between Sweden and the (US, think thats where your company is situated) and when the problem occours i need to adress it right away.
    Martin Arvidsson, Data Martin i Kungsbacka AB

    I have six locks on my door all in a row. When I go out, I lock every other one. I figure no matter how long somebody stands there picking the locks, they are always locking three.

  4. #4
    Join Date
    Nov 2008
    Location
    Round Rock, TX
    Posts
    8,850

    Default Re: CopyRecords command in reverse order

    How often does this happen? If it's a frequent issue, then something else is wrong and you should look into solving the underlying issue.

  5. #5
    Join Date
    Feb 2009
    Location
    Kungsbacka, Sweden
    Posts
    841

    Default Re: CopyRecords command in reverse order

    Quote Originally Posted by Dennis Piccioni View Post
    How often does this happen? If it's a frequent issue, then something else is wrong and you should look into solving the underlying issue.

    Running in network and they refuse to use oplocks beacause, they run updates at the hospital.
    Martin Arvidsson, Data Martin i Kungsbacka AB

    I have six locks on my door all in a row. When I go out, I lock every other one. I figure no matter how long somebody stands there picking the locks, they are always locking three.

  6. #6
    Join Date
    Feb 2009
    Location
    Queens, NY, NY
    Posts
    7,429

    Default Re: CopyRecords command in reverse order

    Then it's REALLY time for an SQL back end.

    How hard can it be?

    :-)

    MM
    Michael Mullan.
    Danes Bridge Enterprises.

    ++++++++++++++++++++++++++++
    There is just today. Tomorrow is a concept
    that is mostly theoretical. -- GM Wylie
    ++++++++++++++++++++++++++++

  7. #7
    Join Date
    Feb 2009
    Location
    Kungsbacka, Sweden
    Posts
    841

    Default Re: CopyRecords command in reverse order

    Quote Originally Posted by Michael Mullan View Post
    Then it's REALLY time for an SQL back end.

    How hard can it be?

    :-)

    MM
    Problem is that its in vdf7, and they do not allow an upgrade of the system at the moment 😩
    Martin Arvidsson, Data Martin i Kungsbacka AB

    I have six locks on my door all in a row. When I go out, I lock every other one. I figure no matter how long somebody stands there picking the locks, they are always locking three.

  8. #8
    Join Date
    Feb 2009
    Location
    Queens, NY, NY
    Posts
    7,429

    Default Re: CopyRecords command in reverse order

    Yep. That's a problem for sure.

    Time to increase the support costs X 100 to make maintaining more painful than the upgrade.

    MM
    Michael Mullan.
    Danes Bridge Enterprises.

    ++++++++++++++++++++++++++++
    There is just today. Tomorrow is a concept
    that is mostly theoretical. -- GM Wylie
    ++++++++++++++++++++++++++++

  9. #9
    Join Date
    Feb 2009
    Location
    Kungsbacka, Sweden
    Posts
    841

    Default Re: CopyRecords command in reverse order

    Quote Originally Posted by Michael Mullan View Post
    Yep. That's a problem for sure.

    Time to increase the support costs X 100 to make maintaining more painful than the upgrade.

    MM
    Yes, I know and they know. They are in a process where they are not allowed to do any major upgrades other than maintaining, so I am kind of locked
    Martin Arvidsson, Data Martin i Kungsbacka AB

    I have six locks on my door all in a row. When I go out, I lock every other one. I figure no matter how long somebody stands there picking the locks, they are always locking three.

  10. #10
    Join Date
    Sep 2016
    Location
    São Paulo - Brazil
    Posts
    682

    Default Re: CopyRecords command in reverse order

    Quote Originally Posted by MrHalland View Post
    Running in network and they refuse to use oplocks beacause, they run updates at the hospital.
    Just like you, I go through this tied hands situation, where the swap of the embedded into SQL stays, for the coming year. . . next year . . . next year.

    I have not activated the oplocks, and BD Dataflex works very well, but if you are using the compressed mode I noticed from last year, that because more users are using Windows 10 the bank became more sensitive to corruption due to crash energy or CTRL + ALT + DEL, then I chose a split of the DBs, easing the load of the number of registers, that although it was 240 Kb in the .VLD (Registrations of 16 Kb), its unpacking was impossible since it exceeded 4 GB.

    Best Regards

Page 1 of 2 12 LastLast

Posting Permissions

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