General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
John,
You haven't said what goes on while the table is being "held hostage." If it's just some sort of report you could make a snapshot of the data by copying it. If you're doing multiple updates, wrap them in transactions.
>Hi.,
> I have couple of forms used for custom setting for supervisor. These forms only allowed to be run in ONE of the workstations in netowrk. Once these forms launched, nobody are allowed to update the table.
> In the situation above, is it good to use FLOCK to lock the table from form.INIT until the form released? Or, do you have any other suggestion?
>
>Thank you
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only