Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Newbie question on CA
Message
 
 
To
15/07/2010 14:48:01
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01472577
Message ID:
01472605
Views:
40
>>Hi,
>>
>>I am working on a very simple use of CA (CursorAdapter) and have a newbie question. What method of the CA do I call to send the update to the data source (SQL Server)? For example, I set values of the properties to the CA, get the cursor (calling CursorFill), change values of one or more fields of the records in the cursor. Now I want to update the SQL Server table. How? TIA.
>
>Tableupdate() but you need to make sure that you also set your datasource as updatable otherwise tableupdate() wouldn't do anything.
>One simple way to get started is to use:
>
>
DO HOME() + "DataExplorer.app"
>
>and check the code generated.
>PS: Use ADO datasource and not ODBC if you would use MS SQL.
>
>Cetin

Thank you. Yes, I am using ADO datasource.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform