Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Convert rows into columns
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00797678
Message ID:
00797873
Vues:
21
Try xtab program.

Aashish

>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
--
--
Aashish Sharma
Tele Nos: +1-201-490-5405
Mobile: +91-9821053938
E-Mail:
aashish@aashishsharma.com
write2aashish@gmail.com

You better believe in yourself... if you don't, who else will ?
TODAY is a gift, that's why it's called PRESENT
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform