V4MD : new question SQL insert into picture

[Ruslan Zasukhin]

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

> At 11:37 29.10.2003, you wrote:
>>> 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 ]
> 
> No, you're using RB/VB syntax, this does not work in Lingo,
> my example should be correct.

Yes I know that my syntax can be wrong. :-)

Okay, will not bet with export of Lingo.


 
>>> 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
> 
> But this is planned for 2.0, right?

Yes.

-- 
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
-------------------------------------------------------------