Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Updating Records in an MS SQL CE Database
Message
From
25/05/2009 23:59:20
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Updating Records in an MS SQL CE Database
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01401914
Message ID:
01401914
Views:
138
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."
Next
Reply
Map
View

Click here to load this message in the networking platform