General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>Hi Friends,
>
>Can somebody suggest me the best way to avoid TABLEUPDATE clashes.
>
>At present I'm using Pvt data Sessions, enabled buffering to each tables, type 5. (Optimistic table buffering)
>
>I'm updateing the table as soon as a record is entered into the system. However sometimes it returns False, for Tableupdate() command. At present I'm not checking this status, but I found out when there was some problem in Data.
>
>Can somebody suggest how to over come this problem. What are the ways to ensure smooth Tableupdate activities??
>
>I'll be highly oblidge if any suggestion are given on this.
>
>TIA
Well, for starters you should check the value that the tableupdate returns in the program. If the tableupdate fails, you'll want to in code determine to the best of your knowledge why, in a case structure, then inform the user that the update failed. You'll probably want to look into transactions to see if this is something that you'll want to use.
HTH
Dan
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