General information
Category:
Coding, syntax & commands
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.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only