Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to write this SQL Statement?
Message
 
 
To
02/01/2003 20:17:14
F Bilo
Bilo Office
Fuyang, China
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00737372
Message ID:
00737588
Views:
17
The problem sounds like you want to transpose the metrics. For this purpose, you can use VFPXTab program or Download FastXTab from Downloads section here.

>OK, let me think, will this be more clear? :
>
>ID    fieldname      fieldvalue
>_________________________________
>1     Name           fbilo
>1     sex            Male
>2     Name           Raole.craft
>2     sex            Female
>...
>
>and i need trasform this into :
>
>Name           sex
>______________________
>fbilo          Male
>Raole.craft    female
>
>Thanks!
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform