Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Uniqueness of Index Violation via Seek()?
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00049857
Message ID:
00050162
Views:
23
>I haven't explicitly set Row Buffering, However I am using Visual
>Maxframe Professional and it may have. I was wondering if there is
>some command in VFP that will clear the Buffer so that I can move
>the record pointer without comitting the changes. Would it make
>sense to issue TableRevert() right before issuing the seek()?...Or
>is this a bad programming practice?
>I have included the code I am working with:
>
>Thanks,
>
>Paul Acton

Paul, VMF defaults each form to Optimistic Buffering and each table to Form Default. This means that you will have ROW buffering for every control except grids. Grids will default to TABLE buffering (don't as, this is a VFP decision, not VMF).

Therefore, as you move the record pointer in your SEEK, you'll fire a tableupdate(). Dave's suggestion of USE...AGAIN... to use your file as a lookup is excellent.

Also, if you've never written to an HTML site before you may not know you can show all of your code in non-proportional font with the PRE command. Look at my code with the REPLY button and you'll see.
Place     Code     Here
In        Columns  Now
(Now if I made a mistake, I'll sure look stupid, won't I? :-) ) Anyway, it makes your code easier to read because the HTML will remove all your leading spaces.

HTH
Barbara
Barbara Paltiel, Paltiel Inc.
Previous
Reply
Map
View

Click here to load this message in the networking platform