Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Select query how to add fake column with id field with i
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00935666
Message ID:
00935668
Vues:
16
Is it what uou mean:
SELECT RECNO() as _id,* from yourtable into cursor cursname


>Please is it possible to get a fake id column in the cursor
>
>I have the table abc
>
>it does'nt have the id field in it(means does'nt have a field with id's(1,2,3,4,5 ...etc)
>
>i want to fill the cursor with id and then the table abc's data
>
>this id field i need to generate it via the select query. if i get 10 records with this query then in the id field it should show(1,2,3,4,5,6,7,8,9,10)
>
>and the the whole result of the query i will fill it to the cursor and show on the form.
>
>Please if anybody knows how to do this, can you please help.
>
>Thank you very much.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform