John Baird
Coatesville, Pennsylvanie, États-Unis
Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
>>>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..
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement