shared dbase problem

[Horrid]

I am shareing a dbase between two apps, basically one adds records and the other displays them. I use sendmessage to let the second app when to update. The problem is that the second app always seems to end up with a version of the dbase one step back from the current version.

eg, I add an item, the update command is issued, display updates but nothing shows, I add another item, update is issued and I get the update I should see when the first command is issued, the item I just added isn't visible. If I close the second app and open it again it will display just fine. I currently close the dbase in the second app and open it every time I want to update the display. Any hints as to what might be going on? I haven't done much dbase work but I only need some direction or suggestions.

Thanks

 

[nonguru]

Hi Horrid.
Very likely I have less database experience than you,
but here's my two cents...
It sounds like you need to update from the first app after
adding an item to it, then try displaying in the
second app. Closing the app forces an update to its' data I guess.

This is all just wild speculation. ;-)

What sort of applications are we talking? VB??
It sounds like the sort of thing that could be
handled well with data control and data bound text boxes.

good luck

 

[Horrid]

Aye, I expect it is something like that. I just chucked a timer into the second app and force a refresh every 10 seconds. Seems to be working so might just accept that as a solution.

Major problem is app 1 is really a com dll, a web toolbar to be exact. The second app is a totally separate exe that displays data collected with app 1. App 2 may or may not be open or I would go to the effort of working out how to send the data to app 2 to store and display.

Thanks for your ideas.