Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to get the result using Commandtext
Message
From
06/12/2004 08:30:17
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
How to get the result using Commandtext
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000 SP4
Network:
Windows 2000 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
00967133
Message ID:
00967133
Views:
46
Dear All,

I created a command object using cMmd = CREATEOBJECT('ADODB.COMMAND')
funtion, and retrive data from mytable using cMmd .CommandText = 'Select * from Mytabel' method, is working fine, but how can i see the query result ?
i just add one line after like
Select Mytable
brow
gives the error that 'Alias Mytable is Not Found'
i need this result is in a table form, because after that i want to
index and seek the values in this table.
OR if i m using Recordset commands can i see the results?
but i do'nt know how to use these commnds, please help me
anybody knows abt it

with Thanks and regards
Abdulla
Next
Reply
Map
View

Click here to load this message in the networking platform