One big comment here. Do not use SELECT or SQL commands on buffered data!!!

If you have added or changed any data to a buffered view (and have not issued tableupdate) then a select command on that view will only return ORIGINAL DATA and will not SEE any new records and will see deleted records. The select acts only on the original data and not any of the changes.

Needless to say, I now do SCANS on buffered tables when I know I may have added or deleted data and have yet to commit my changes.


>ccommand = 'COPY TO ' + cfilename + ' FOR ' + THIS.cflagfield
>&ccommand
>
>SELECT 0
>USE (cfilename) ALIAS tmp1
>ccommand = 'SELECT *,RECNO(ctblname) AS flagrecno FROM tmp1,' + ;
> ctblname + ' WHERE tmp1.' + THIS.ckeyfield + '=' + ctblname + ;
> '.' + THIS.ckeyfield + ' AND tmp1.'+ THIS.cseqfield + '=' + ;
> ctblname + '.' + THIS.cseqfield + ;
> ' INTO CURSOR mycursor'
>&ccommand
>
>I have these commands to select records that are flagged from the buffer (table buffering mode). The RECNO doesn't seem to return the correct number. What is the problem and any idea how to overcome this?
>
>Thanks in advance.