John Baird
Coatesville, Pennsylvania, United States
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>>I am trying to insert records into a .net local data table (SQL Compact Edition .sdf File)
>>>
>>>I am using a cursor adapter since these is no ODBC driver for this.
>>>
>>>I can open the table just fine but I cannot get an insert to work. Is it possible to insert into an ADO table?
>>>
>>>This is what is being returned by aerror after the tableupdate()
>>>
>>> ( 1, 1) N 1435 ( 1435.00000000)
>>> ( 1, 2) C "Microsoft Cursor Engine : Multiple-step operation generated errors. Check each status value."
>>
>>
>>John,
>>AFAIK SQL server CE is not updatable via OLEDB using recordsets (unless opened as table direct). MS would think about an update, I don't know if they did or not. Workarounds would be to use separate insert/update commands or use some .Net wrapper activex that uses .Net managed driver.
>>
>>Cetin
>
>I'd rather avoid the .net wrapper in this case. (if forced to go that route, I'll just do the update from .net)
>
>How do you open as "table direct"?
John,
SQLCe does not support batch or multiplestep instructions in crud operations. You have to make single calls until done..
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only