Exception occured in Microsoft JET Database Engine, Cannot update '[FILED]'; field not updateable

[Qia.sky]

I want to Update OLE Object as binary format, But when I use SQL query like this below,some error come out then the executive occur
UPDATE Accounts SET PictureSignture=? WHERE ID=?

Error info:
Exception occured in Microsoft JET Database Engine, Cannot update 'PictureSignture'; field not updateable.. in ADO Command Execute.vi->Test.vi

I attach my example, so you can help me.

thanks in advance

Qia

[Wiebe@CARYA]

"Qia.sky" <x@no.email> wrote in message news:1154851807068-400819@exchange.ni.com...
I want to Update OLE Object as binary format, But when I use SQL query like this below,some error come out then the executive occur UPDATE Accounts SET PictureSignture=? WHERE ID=?Error info:Exception occured in Microsoft JET Database Engine, Cannot update 'PictureSignture'; field not updateable.. in ADO Command Execute.vi->Test.viI attach my example, so you can help me.thanks in advanceQia



Update.zip:
http://forums.ni.com/attachments/ni/170/199352/1/Update.zip



The PictureSignature is a OLE object. You are trying to insert an array of unsigned bytes. I think that will never work. You need to find a way to create an OLE object so you can insert that, or change the type of the PictureSignature to memo. That you can also use the normal VI's to insert the data.


Also note that the picture you get from the "Read JPG File.vi" is a native LV data structure. If you intent to use the data in other environments, it won't be very usefull. If you just use it in LV, it's OK.


Regards,


Wiebe.

[Qia.sky]

How can I Create an OLE object in LV?
and I don't find the way of create memo in LV, because I found there are only Binary string,and Date/time type, haven't memo type.

I'v try a lot of method, but this proble still make me uneasy.

Qia

[Wiebe@CARYA]

"Qia.sky" <x@no.email> wrote in message news:1154968812548-401191@exchange.ni.com...
How can I Create an OLE object in LV? and I don't find the way of create memo in LV, because I found there are only Binary string,and Date/time type, haven't memo type.I'v try a lot of method, but this proble still make me uneasy.Qia


If you change the type of the record in excel to memo, you should be able to write a (binary) string, or U8 array to it from LabVIEW.


I have no idea how to create an OLE object in LabVIEW. There is a lot of general information about storing OLE objects, but not a lot of source code. General advice is to store the pictures on disk, and put a reference/path in the database.


This link could be of some help: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=196910&SiteID=1 (esp. http://support.microsoft.com/default.aspx?scid=kb;EN-US;210486 ), but you'll have to convert the basic code to LabVIEW.


It describes how to store files, in general, in a database, not just pictures.


Regards,


Wiebe.