Database APP

[khalik]

hi

may look long but very simple...
i have a table customer (ID , Name)
users A,B, C

all 3 user retrive data.

A has updated the name filed
after some time B updates the name

now the Point is the App should prompt the user that the record is been updated .. ask to retrive
how will the app know that the record is been updated

and if the user C sit for long time the system should prompt that the data been change from the last retival...

any idea tip tricks any thing
welcome

thanks

[wrack]

Every time a record is updated or added it updates a perticular field in master database.

In the application itself there is a timer and it checks for that field every 5 or 10 seconds. ( Depends how updated info u need )

If it founds that the special field is updated then it passes a message box to users.

This is in case if your application isn't client-server...

Haven't done much work with client-server...

Cheers...

[khalik]

thanks wrack

mine is a client server....
what u suggest can work out for the C i dont think it will be good checking the database with a timer

in case of user B only prompts at time he tries to updates... he was bit late than A


any thing more

[wrack]

I told b4 that I am not using this in Client-server but you can do this aswell...

Put a code in client app that sends notification to server that the record is been updated or added...

Then server sends that message in MSGBOX format asking YES to UPDATE their current instance of APP and NO to exit the dialogue box...

Hope I am on a right track...

[khalik]

if i got straight ..
once the data been updated all the users should be prompted for refresh the data....

my APP is multi screen
dont u feel it will be diff to keep track of all screen data... when updated...

it sound good but hard to implement...

[wrack]

if it's not too secret...

[khalik]

Originally posted by wrack
if it's not too secret...

i dont have the code my boss asked me to implement it
so i was looking for how it can be done....

i thought of maintain timestamp in every record and once the record is retrive store it in a table
and when the record update check if the time stamp is same if not prompt the users that record is change.....

but the problem in this case is all my fields are not that imp. all the time it prompts me.. say that i can't maintain diff timestamp for diff fields...

it all u idea and mine i have .....

[wrack]

From personal experience TIMER is more efficient than TIME STAMP...

I have an app and believe me it's huge...

One part of it stores the Request For Service from client and it's details.

When there is 1 day remaining it checks the database and tell the enginee in a POPUP every 5 minute that you have a JOB to do...

As far as I remember why don't you use CALLBACK in VB...

Hope this will help...

[khalik]

i agree with u but that will be a case of job list.. where u need to check and popup the user...

what i am talking about the data been changed or not..

may be i am not clear....

when user change the data the system has to check if any updation done after the data is retrive.....

[wrack]

my friend,

if you expand my concept then I am sure that it will work...

besides why don't u use CALLBACK...