Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Build memo with SELECT command
Message
From
28/05/2003 09:24:18
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00793424
Message ID:
00793460
Views:
24
Hi Sergey,

this is the problem,

i need to build, before the effective select, a pivot structured table in order to force the select to construct a result with the correct fields.

I need build a array(nFields,3) for fields,

and uses

CREATE CURSOR resultSchema FROM ARRAY ArrayName

and

only now I can execute one tricked select :
SELECT * FROM resultSchema
UNION ALL
mySelect

You he seems acceptable ?

Fabio
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform