General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
I have an app that will be running on a network with 100 plus users. Using VFP 6.0. I have a table that holds hours worked by each user. I have created a pview and then a form with a grid based on the pview. First will this support multiple users with out conflicts? The parameters for the view is a combination of badge number, weekending date, and job number charged too. I have put code in the DoubleClick event of a grid header to add a new entry. Do I append blank to the view or the original table? Then a method runs that removes grid recordsource, closesTables, sets parameters, OpenTables, set the grid recordsource. On the lost focus of the cloumn textbox I do = TABLEUPDATE(.T.). If I doubleclick the header, type in my new job number, then try to doubleclick the header again I get an update conflict. If I move the cursor out of the textbox first I don't get the error. Maybe I am doing this all wrong?
Next
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