Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Convert rows into columns
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Convert rows into columns
Miscellaneous
Thread ID:
00797678
Message ID:
00797678
Views:
58
Hi y'all.
I need to obtain a cursor with one column for each row corresponding to a code in a master tabla, let me explain further..
There is a parent table and a child table, both have a field called "cedula" which i use to join them, the chilt table has another fiel called "curso" which contains the code of an item, what i need is to obtain a cursor with the following structure:

cedula,curso1,curso2,curso3,curso4......cursoN

I made a program that works with macro substitution and creating N cursors which i join at the end, but i think there must be a better way..

Is that possible?? how??

Thanks in advance.

jonamart@cantv.net
Next
Reply
Map
View

Click here to load this message in the networking platform