Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Newbie question on CA
Message
From
15/07/2010 14:53:34
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:
01472606
Views:
58
>>>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.

I forgot to say:
-Create a connection
-Open tables node
-Open a new code window (modi comm)
-Drag & drop a table from data explorer on to that code window
-Run the code that VFP has written
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform