Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cursor Field Names Created by SqlTables ()
Message
From
09/04/2002 12:32:07
 
 
To
09/04/2002 11:18:09
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00642663
Message ID:
00642749
Views:
20
>Fernando,
>As a workaround you could use sp_tables :
>
>SQLEXEC(lnHandle,[Use pubs ; Exec sp_tables @table_type = "'TABLE'"],'pubs_tables')

Cetin,

I did perform your sample sqlexec, and it worked, bringing the rigth cursor column names, but I still don't understand what is going on. OTOH this program I'm talking about is a small SPT based utility I use to connect to, see databases' tables, their attributes, browse records, make queries etc, and it works with other DBMS, but not with SQL server (this is the first time I try with it).

Thanks,

Fernando
Previous
Reply
Map
View

Click here to load this message in the networking platform