Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Evaluating a populated grid before tableupdate
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00215419
Message ID:
00215577
Views:
28
Nick,
You can add any code you want before you call the tableupdate(). Just put the code into your command update button. If you're using a framework or a wizard which provides these buttons, go to the CLICK() method of the button, add your code and then the DODEFAULT() command (for VFP5, VFP3 will need to use the :: syntax to call the parent code).

You will not need to update the grid unless you want your users to see the changes. A tableupdate() is done on the cursor/table/view NOT on the displayed values. So if your code scans the view, changes the data in the field shown in column 2 and then does the TableUpdate() you should get just what you need.

HTH
Barbara

>I am populating a grid on my form by requerying a local view. What I want to do is take all the values from column1 and evaluate those values. Based on what type of values avaliable, I want to insert a value in column2. My column1 will contain dates, the user will go and delete the dates. After the user hits command update button, I want to see which dates were no delete and insert a flag value into column2. Is there a way to evaluate the values from column1 in an array or something, and then add my flag values before I do a tableupdate. If so, should the grid have to be repopulated with my added flag values and then do a tableupdate. Help appreicated.
>
>nick
Barbara Paltiel, Paltiel Inc.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform