V4MD : new question SQL insert into picture

[Martin Kloss]

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.

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

Martin.


Martin Kloss

Need music? http://www.selling-sound.com

Like the author? Buy the book at:
http://www.amazon.de/exec/obidos/ASIN/3898422194/lingmmugd

Get your daily dose of Lingo at the LingoPark:
http://www.lingopark.de