Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
WHERE clause not working on ADO CursorAdapter.SelectCmd
Message
From
26/10/2005 17:43:33
Perretier Thierry
Montrouge, France
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: WHERE clause not working on ADO CursorAdapter.SelectCmd
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows 2000 SP4
Network:
Windows 2000 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01062244
Message ID:
01062430
Views:
15
This message has been marked as the solution to the initial question of the thread.
Hi,
You must pass a ado command object to cursorfill function.


oadapter.AddProperty("oCommand",CreateObject("adodb.command"))
oadapter.oCommand.activeConnection = loConnDataSource

oadapter.AddProperty("clid")
oadapter.clid = "2019"

oadapter.SelectCmd = [select * from ror WHERE clid = ?this.clid]

IF not oadapter.CursorFill(,,,oadapter.oCommand)
ERROR message()
ENDIF
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform