>>Hi all,
>>I have a table that is buffered I am adding a record to it and then want to run an SQL statement against it before I do a TableUpdate. The query does not return this new record. Is there a way to get the query to see this record before a TableUpdate is called?
>>
>>Thanks in advance
>>Stephen Kuhn
>
>I don't think so... but, what are you trying to accomplish? I assume you want to show the user the records that will be saved?
>
>How about if you filter the view for recno() < 0 ?
>
>BOb

Actually, that is backward... you want to filter out all but the new records...

set filter to recno()>0

Also, you can set a filter based on the reulst of GetFldState, so you can also show records that have had changes.

BOb