General information
Category:
ActiveX controls in VFP
Title:
View Parameters with ADO in a CursorAdapter.
Environment versions
Network:
Windows 2003 Server
We currently use ODBC, but we want to mve to ADO for our data connection. We are using Cursor Adapters with ODBC connection. Using View Parameters "?VP_cID" works just fine in a SQL statement or in a call to a stored procedure.
But now, we have been testing with ADO, and it seems that this will no longer work.
I know I need to use the ADODB.COMMAND object to add parameters, but exactly how am I going to get that work with a Cursor Adapter? Do I assign my DataSource to the ADODB.Command object or leave it with the ADODB.CONNECTION object?
TIA
Mark
YOu can disregard this message, I found my blunder...
Thanks
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only