Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
RECNO() in a sql expression of cursoradapter (Paradox )
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2008
Divers
Thread ID:
01457797
Message ID:
01457848
Vues:
90
>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

Does Paradox have identity field? In SQL Server you can use ROW_NUMBER() function for this purpose, you may need to investigate available things in Paradox.
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform