If column 0 is your identity column, you may see the new value already in the row. Both message box calls display the value. This method is imperfect, but because most SQL Server 2000 CE applications are completely single-user, the syntax is workable. For example, when you perform an RDA Push , and there is an error, the row with the error is returned to your RDA Push with the Tracking Error Table and is removed from the table where the error occurred. In the tracking table, RDA gives you the data that was in your table in addition to the error that occurred.
Errors can occur in many ways on a Push .
The error message informs you that you must add these constraints to your CE database and retry the record. There is currently no direct Win32 mechanism through which you can create a SQL Server 2000 CE database on the desktop computer and then use it on the device. However, you can create the database in the desktop emulation environment or on a Microsoft Windows CE device, and then copy the database to a Win32-based computer. Then, copy the database to other Windows CE devices, as needed. Database engines can take a fair amount of memory, and it is best not to leak memory.