Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem to create CA
Message
From
09/07/2010 01:58:10
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Database:
MySQL
Application:
Desktop
Miscellaneous
Thread ID:
01471920
Message ID:
01471958
Views:
28
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform