V4MD : new question SQL insert into picture

[Ruslan Zasukhin]

on 10/29/03 10:45, Martin Kloss at martin.kloss at gmx.de wrote:

> At 07:00 29.10.2003, you wrote:
>> mySql = "UPDATE rdInventory SET fd_Image=:1 WHERE fd_Code=:2"
>> myValues = "[" & member( fd_Code,2 )
>> myValues2 = "," & fd_Code & "]"
>> db.SqlExecute(mySql, myValues & myValues2)
> 
> Hi Ricky,
> 
> you need to use a Lingo list for binding, not a string
> that looks like a list:
> 
> mySql = "UPDATE rdInventory SET fd_Image=:1 WHERE fd_Code=:2"
> myValues = [member( fd_Code,2 ), fd_Code]
                        ^^^^^^^^^^^^^^^^^^^^^^^

Martin, this must be LIST OF STRINGS and/or cast member that have pictures.

So I think more correct:

 myValues = [member( fd_Code,2 ), fd_Code as string ]



> db.SqlExecute(mySql, myValues)
> 
> That should do the trick.
> Oh wait, I think binding for conditions is not supported yet,
> so the "WHERE fd_Code=:2" is not possible, or is it Ruslan?

Correct. Binding on conditions not work yet

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------