Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select query how to add fake column with id field with i
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00935666
Message ID:
00935668
Views:
18
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.
Previous
Reply
Map
View

Click here to load this message in the networking platform