Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Confused about tableupdate....using view in grid
Message
 
To
17/08/1998 11:37:42
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00127443
Message ID:
00127452
Views:
24
Trisha,

The problem is with your REPLACE statement. When you use REPLACE without a scope, only the current record is replaced. To have the REPLACE affect all the records, use REPLACE ALL as in REPLACE ALL gldent2.noshow WITH grid.noshow

>When I use the following code, only the 1st record in the grid is getting updated. I thought tableupdate would update all the records in the table that correspond with the records in the grid. Do I have to step through the grid a record at a time to accomplish this?
>
>USE gldata\gldent99 IN 0 ALIAS gldent2 AGAIN
>SELECT gldent2
>SET MULTILOCKS ON
>= CURSORSETPROP("Buffering", 5, "gldent2")
>REPLACE gldent2.noshow WITH grid.noshow
>TABLEUPDATE(.T.)
>USE IN gldent2
>
>MTIA :)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform