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