>Appreciated everyone's help the last time I sent a message. I haven't responded to other questions yet as I'm still a beginner!!
>
>Using VFP 5.0 I have several tables in the dataenvironment of a pageframe. I need to validate between several of the pages and would like to use the buffered data from one or more of the tables in the validation. I have the buffermode set to optimistic. How do I use the buffered data?
>
>Thanks.
>Linda
First of all, I guess you have Dataenvironment of Form not Pageframe. Generally, data validation based on RI triggers and/or record/field level rules (it doesn't require buffering). You can find in manual in what order these rules applied. Buffered data assumes that you will use tableupdate()/tablerevert() function for save/cancel purposes. Remember that OptimisticRow buffering will apply 'mild' tableupdate() any time you move pointer and this can cause problems in multi-page form if let say you switch pages and move pointers in related tables. I used to have OptimisticRow buffering for Master file, and OptimisticTable for Look-ups, and I wouldn't recommend to use buffering at all if you didn't get much VFP experience yet.
Edward Pikman
Independent Consultant