
SQL-Select on buffered tables
Since nobody more experienced than I answered, I'll give it a shot.
I think 1 is by design - changes are not permanent until committed.
Two work arounds come to mind. (I'm guessing you want to do some validation
as a group prior to committing changes.)
a. If you copy to a temporary table for your condition, the changed records
will be copied, not the original. You can then use this table however you
choose.
b. Alternately, you can wrap everything in a transaction, and if you
validation fails, you can rollback your changes.
HTH Dorothy
Quote:
> Hello,
> 1) can anybody tell me why vfp's select-sql ignores new-records on a
> buffered table?
> 2) is there a backdoor?
> As I know a new record in a buffered table recieves a RecNo()<0. If you
make
> a select on it, those records will not appear...
> SELECT * FROM <bufferedtable> WHERE .T.
> >Alexander Lagler
> ---------------------------------
> >Softwaresysteme GTLDATA GmbH
> >Radetzkystra?e 4
> >9020 Klagenfurt
> >AUSTRIA
> ---------------------------------
> >+43 (0)463 - 51 58 88 - 21