[V4MD] UPDATE picture field

Martin Kloss martin.kloss at gmx.de
Fri Sep 12 12:20:54 CDT 2003


Hi,

I'm currently doing all INSERT and UPDATE calls with
binding, so all values get automatically escaped and I don't
have to worry about a thing. That's very nice, BUT it
doesn't seem to work with picture or media fields.

The following simplified statement fails with error 628

UPDATE data SET chapter_ptr = :1, pict = :2 WHERE RecID = 2

(values are: [2, member('pict').picture] )

I'm not doing it exactly like this, but in essence it's what
happens. The member is there and it doesn't matter if
I'm using the member ref itself or the member(n).picture property.

Ruslan, you said that the values in the binded array are
expected to be strings, but how does that work with picture / media
fields then?

I don't want to update / insert the record and then separately
insert / update the picture field with a "setPicture()" call, that
seems a little redundant.

Again, let me pitch for finally supporting the "image" property
for picture fields. Ruslan, any news on that one?

Martin.




More information about the Valentina mailing list