>>>I am trying to gather new buffered records (in my current data session) with a select statement. The browse statement allows me to do so. Is the same possible with a select statement, if so can someone tell me how.
>>
>>
>>Wallace
>>
>>I have not done this & think it is dangerous to some extent (mainly because I have never heard of it).
>>
>>It may be able to be done by looking for recs with a negative number. Buffered recs have a negative record number until saved.
>>
>>Where recno() < 0
>>
>>You can try it but I have no guarenties.
>>
>>Tom
>>
>Wallace,
>I have tried this... and failed. The select statement always returns the same thing as OLDVAL() for existing records and appended records do not exist to the SELECT command. I have been able to justify this behavior (in my mind) by recognizing that if I were using remote data (i.e. SQL Server) that the data simply would not be there to query. Frankly, I prefer the SELECT command to work the same for both local and remote tables. Furthermore, I find that I am usually not willing to pay the performance price when I execute a SELECT command. My work-around (when I have needed it) has been SCAN or DO WHILE. These situations do in fact return RECNO() < 0.

Dean

So you say SCAN will work in this situation & not SELECT? Kool! Thats one for the memory bank!

Thanks
Tom