Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Seen a GOOD CA lately?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows XP
Database:
MS SQL Server
Miscellaneous
Thread ID:
00980530
Message ID:
00980582
Views:
34
Thanks, I will give it a try.

Glenn


>Did you try:
>
>SelectCmd = "select 1 AS EXP, 10 AS EXP1, ...
>or
>
>SelectCmd = "select 1 EXP, 10 EXP1, ...
>
>
>
>>OK, I give up! What am I missing? I have a databasse on a remote SQL Server which I am trying to query using a CA. I created a CA class in a classlibrary, and subsequently used the builder to configure the class for use. When I do use it, there seems to be problems when mapping the SQL data to a VFP cursor. I have tried with both UseCursorSchema True and False. Still "No Cigar"
>>
Previous
Reply
Map
View

Click here to load this message in the networking platform