Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Temporary Index
Message
 
To
15/07/2000 15:58:34
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00392917
Message ID:
00392918
Views:
11
>I have a table with task deffinitions. This includes department identifiers. I have a second table which lists customers and all the tasks which are associated wiyh that customer. In a grid I need to be able to view the particular customer and their tasks in department order and also be able to edit and update the data. I can get the resultant grid I need with SQL but then I can't update. Please help.

IF you are using a DBC then you can use an updateable, parameterized view instead of an SQL. Updateable views are really nice. For reliability reasons set your buffer mode to 5-optimistic. Then you can either update one row at a time or multiple rows at a time, depending on how you set the parameters to the TABLEUPDATE command.
Nebraska Dept of Revenue
Previous
Reply
Map
View

Click here to load this message in the networking platform