V4MD : new question SQL insert into picture
Ricky
ricky at babonmultimedia.com
Wed Oct 29 14:00:48 CST 2003
hello ruslan and all,
about dump and load dump in my last question is not a problem anymore.
because i use import/export ODBC tool with MS access. thanks for supportting
me
but now i have difficulties in adding jpg into database
i cannot view the error message because database eat all memories then make
my computer hang
here is my script to add one picture:
on insertpicture
global db
set vc = new( Xtra "VCursor",GetRef(db),"SELECT fd_Code,fd_Image FROM
rdInventory WHERE fd_Code = 'WMK11' ",1,3,2)
set RecCount = GetRecordCount(vc)
set fd_Code = GetField(vc,1 )
if member(fd_Code,2).name <> "" then
mySql = "UPDATE rdInventory SET fd_Image=:1 WHERE fd_Code=:2"
myValues = "[" & member( fd_Code,2 )
myValues2 = "," & fd_Code & "]"
db.SqlExecute(mySql, myValues & myValues2 )
alert valentinaerror()
end if
Please give me suggestion about my mistake...
Thanks in a bunch
Ricky
More information about the Valentina
mailing list