Instant Update on Data 1

[lashwarj]

I Have a database where multipal users are connected. I have code that once a year updates a database between a given date range, it them sets a value to .T., after that date range I set it to .F., my updates to not show till the user leaves the database, my code it below.

How do I make it so the first user in doesnt have to exit the app to set the values



IF VDate_Test = .F. AND config_info.ap_update_complete = .T.
REPLACE config_info.ap_update_complete WITH .F.
ENDIF

 

[IRABYY]

lashwarj (IS/IT--Manageme)

after that date range I set it to .F., my updates to not show till the user leaves the database, my code it below.

IF VDate_Test = .F. AND config_info.ap_update_complete = .T.
REPLACE config_info.ap_update_complete WITH .F.
ENDIF

First - one word (command): FLUSH
Put it after the REPLACE command.

Second: is it possible to disconnect all the users for some while when conducting update?

Third: if answer to the above is "No" - try to LOCK() the record before updating.

By my experience, it's better not to have end users working with your data during maintenance procedures.

HTH.



Regards,

Ilya