Unless Paradox has a RECNO() function, that won't work.
What you need to remember is that VFP will send the SQL statement to Paradox. It will NOT execute in VFP, but will execute in Paradox, so the statement *must* be something that Paradox will understand.
>Hi all,
>
>
> I have'nt be able to find a similar function that can report back a integer of the current record number in a paradox database.
>
>
>TEXT TO .SELECTCMD NOSHOW TEXTMERGE PRETEXT 15
> SELECT HDBK, Hid , HDOCNO, HAMOUNT, STR( HDOCDATE ) AS 'DATEDOC',CREATEDBY,
> STR(Createdon) AS 'createdon' , hremint , RECNO() AS nrec FROM <<.TABLES>>
> WHERE HDBK IN (<<Vp_in>>)
> ENDTEXT
>
>
>who can help me ?
>
>
>thank in advance.
>
>
>bernhart
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer