BUTIL -save -Auto Increment 1

[paulcpdi]

Hi,

I'm working with btrieve files that store Daily call logs.
I would like to combine the files together - BUT...

the structure includes a 'auto increment' field that when I try to do a 'butil -save' - then 'butil -load' or 'butil -copy'
I get a error 5 - duplicate key. - Thats happening because the auto increment field has the same numbers in each file.

Now if I could somehow force the 'butil -save to change the auto increment field to a '0' that should force the butil -load to auto increment the field when it gets added.

Is that possible?? - Of is there another tool that might be able to do that.

Thanks!

Paul

 

[grnelson]

Your not going to be able to get bUtil to do that. And since auto-increment fields are unique you could not just go thru and change them all to zero either. You will have to create a custom program to merge the two files.

 

[paulcpdi]

Thanks for the info.

I created a custom program that does that.
regards,
Paul