SQL Server 2000 CE Edition...
Database
1
Posts
1
Posters
0
Views
1
Watching
-
I have a simple CE.NET application running on a embedded machine running Windows CE.NET 4.2 and SQL Server 2000 CE Edition 2.0. In this application I am using a standard SqlCeCommand object to run the following query:
UPDATE tblschedules SET tblschedules.result = ( CASE WHEN EXISTS ( SELECT * FROM tblscheduledetails WHERE tblscheduledetails.schedule = tblschedules.id AND tblscheduledetails.result = 1 ) THEN 1 ELSE 0 END )The query results in a "A native exception occured" just as soon as I do a ExecuteNonQuery() on the object. The query itself runs without problems when running it from the CE Query Analizer. Does anybody have an idea what might be the problem? We are the all singing, all dancing crap of the world. - Tyler Durden