BDE Replaces Data Altered in Clipper

[Pontelo]

I have 2 tables being user by clipper and delphi at same time.
It´s order and items order tables. I alter in clipper, suppose, items from order no. 10. In delphi i alter, let´s say, items from order no. 20. When i close the table from delphi, every alterations made in clipper were rolled back.
I use table1.Append , alter data, and table1.Post at the end.
Why the other records are all rolled back ?
Thank You !

 

[hilfy]

Part of the way that desktop databases (like the xBase that you're using) work is that they load the whole table into memory on the workstation. So, you're actually working with a local copy of the table. Something that you can do to help prevent some of this from the Delphi side is to call table1.refresh prior to every append, edit, or delete. That way you're working with the most recent data. Also, look at your BDE configuration - is LocalShare set to True? I know this works with Paradox data, but I think it may also help with xBase data as well.

-Dell

 

[Pontelo]

Bingo !
LocalShare was False and did the mess.
Setting to True I could work with Clipper and Delphi at
same time. Next week I will put the module in production
and then we´ll see if really there´s no conflict like index corruption ans so on.
Thank You Hilfy !