Updating image-datafields - eVB

Updating image-datafields - eVB

Post by Volker Warbend » Fri, 04 May 2001 18:23:00


Hallo,

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 updating
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

Best regards

Volker

 
 
 

1. SQL Server CE - eVB - image-datafield

Hallo,

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

Volker

2. Wanted oracle Developers/One stop Resource for IT Professionals

3. Text and Image data with EVB

4. Identity Field, numbers jumping up

5. How to get an GIF file into an ODBC-SQL Server Image datafield (BLOB)

6. use DTS to import ever-changing Excel file?

7. 16-bit API interface

8. Newbie: ADO question, updating datafields

9. updating record with improper datafield

10. Help! insert(update,delete) image data into image

11. Help!!! insert(update,delete) image data into image

12. Help! insert(update,delete) image data into image