>>>>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]
>>
>
>
>I have a question regarding CA.
>
>Right now, since I am a newbie, I am creating the CA as I need on the DE of the form, but... What if I need exactly the same CA in other form?
>
>do I have to creat it everytime I need it? is there any way to store it on the DATABASE DBC and then Add it to the DE?
I generally write my CA's as a prg based class, and then instanciate the class in the load event of a form or whereever needed.
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________