Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Proper cursor buffering
Message
From
02/02/1999 16:41:17
 
 
To
02/02/1999 15:43:21
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00183097
Message ID:
00183170
Views:
15
Thanks Jim for replying. My understanding was that since I'm setting table buffering, any changes to any record should be reflected in the GETFLDSTATE(-1) function (shouldn't it?). As far as what I'm doing, let me be little more specific.

I have a table that stores the costs that have been defined for an item for particular customer. Costs are not fixed to an item but depends on customer and item. Now, what I'm doing is when a user decides to "edit" the costs for a customer, I want to display in a grid ALL the items with costs that have been previously defined. Thus, this is the sequence of bringing up this form:
1. Create a cursor that holds all items available.
2. Update the cursor with costs that have been previously defined.
3. Issue =CURSORSETPROP("Buffering",5,"cMycursor") to buffer the cursor.
4. Present the cursor data to the user for editing via Grid on a form.
5. Let the user edit the data (edit/define new costs).
6. Save the data if changes have been made (GETFLDSTATE(-1))

The problem is, after changing the costs on few new items, calling GETFLDSTATE(-1) is returning no changes being made. Since some records have been changed, shoulnd't GETFLDSTATE() return that it did?

>John,
>
>How do you "...make changes to the data... initially - using replace or depending on Form ControlSource or some other means? Does the record pointer get moved before you issue GETFLDSTATE() first time?
>
>Perhaps the act of changing those records that you initially did REPLACE on moves the record pointer?
>
>Good luck,
>
>Jim N
It's "my" world. You're just living in it.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform