You stated that you were updating an image-datafield. IS BEMERKUNG an image-datafield? What is contained in mlText?
In a FAQ for SQL 2000 CE addition the question of:
How do I store images on the SQL Server 2000 CE Database is answered:
...look at GetChunk and AppendChunk on the recordset Objects in ADOCE. You can use an array of bytes inside the variant through ADOCE C++. You need to make sure you are using an updateable cursor. It must be a base table cursor so that the AddNew function call works correctly.
There is a microsoft.public.sqlserver.ce newsgroup that might better answer your question with actual experience.
> I need some help.
> I have written a small application with eVB to work against a SQLServer CE
> database. Retriving the data works well. But updating misses when using
> image-datafields . Whats wrong?
> gsIDDoc = "6787655434987"
> gsSQL = "update AUFTRAGSSTAND set BEMERKUNG = '" & mlText & "' " & _
> "where AUFTRAGSSTAND.ID_DOK = '" & CStr(gsIDDoc) & "'"
> goADOcn.Execute (gsSQL)
> Errortext: An error was encountered while running this program:
> The command contained on or more errors