Table buffer for alias xxx has uncommitted changes

[tetsuo3030]

I'm running VFP 6.0. I realize this error comes from, in my case, doing a REQUERY() on a table that has uncommitted changes.

Does anyone know of a way to determine whether or not a table or view has uncommitted changes?

 

[craigsboyd]

I'm thinking either trap the error using an ON Error routine... or perhaps OLDVAL(), CURVAL(), and/or GETFLDSTATE() would be of some use to you.

http://www.sweetpotatosoftware.com

 

[thatguy]

Andy Kramek wrote up a nice white paper on table buffering which includes a function to test for changed records in a buffered table.. pretty informative.. check it out..

hth
--frank~

 

[tetsuo3030]

thanks to both of you