>Did you specify different names for alias property for your CAs ?
>
>Also, completely forgot - you need to call CA.CursorFill() method in form's Load.
>
>>>>I am updating my application with mysql backend . I have used my dbf tables in DE . Now i am trying to create CA with same name. I have problem in my some forms which have more than one CA. CA adapter is in the DE but when i load the form and check the data session, there is no table.(if i have two ca. only one table is in the datasession)
>>>
>>>Can you post some of the code in these CAs and form's Load?
>>
>>
>>Auto open CA:
>>
>>*** Setup code: DO NOT REMOVE
>>if not pemstatus(This, '__VFPSetup', 5)
>> This.AddProperty('__VFPSetup', 1)
>> This.Init()
>>endif
>>*** End of Setup code: DO NOT REMOVE
>>ini:
>>
>>*** Setup code: DO NOT REMOVE
>>local llReturn
>>do case
>> case not pemstatus(This, '__VFPSetup', 5)
>> This.AddProperty('__VFPSetup', 0)
>> case This.__VFPSetup = 1
>> This.__VFPSetup = 2
>> case This.__VFPSetup = 2
>> This.__VFPSetup = 0
>> return
>>endcase
>>set multilocks on
>>llReturn = dodefault()
>>*** End of Setup code: DO NOT REMOVE
>>
>>*** Setup code: DO NOT REMOVE
>>if This.__VFPSetup = 1
>> This.__VFPSetup = 2
>>endif
>>return llReturn
>>*** End of Setup code: DO NOT REMOVE
>>
>>
>>I have nothing in load. because i am only trying if my cursor Adapter is working.
Nomi:when i use dsn, all CA are present in DS. but when i use connection handle:
goge=SQLSTRINGCONNECT("Driver={MySQL ODBC 5.1 Driver};Server=localhost;charset=UTF8;Database=school;User=root; Password=;Option=3;")
my problem is same:is string is true
my