>>I stop using RVs immediately after VFP 8 comes and CAs was here :-)
>>try:
>>

>>OPEN DATABASE C:\sample\Data\myDBC.dbc
>>PUBLIC lnConn
>>lnConn = SQLCONNECT("myConn","sa","myPass")
>>
>>?lnConn     *:returns 1, so the connection succeeded 
>>
>>SELECT 0
>>USE myDBC!myRemoteView  CONNSTRING  lnConn  
>>

>
>I just started using Cursor adapters yesterday and they are a blast!!!!! The only thing is I am telling th Cursor adapter to use a connection handle store in a global var, is this a[proache ok??
>
>also, how do you parameterize a CA? justa as the RV?

Yes, they can use anything for DataSource:

lnSQLHAndler = SQLCONNECT().....


*** In CA Init or any other method:
this.DataSource = m.lnSQLHAndler
....

To make them use parameters just change your SelectCmd property:

this.SelectCmd = [SELECT * FROM YourTable WHERE SomeField = ?m.SomeVariable]