insert record parameter binding

[Ruslan Zasukhin]

On 14/2/07 1:16 PM, "Bart Pietercil" <bart.pietercil at gmail.com> wrote:

Hi Bart,

> When using Realbasic, the array I need to send with the insert sql is
> of type string or should I use type Variant ?

I remember it is strings.

We was not able implement VARIANT on some problems of RB SDK.
 
> Not really clear on the wiki, if I may say so :-)

TIP: any issues related to docs can be reported into Mantis :-)
        each project in Mantis contains category "Docs".


> INSERT INTO tbl1 ( fldLong, fldString ) VALUES ( :1, :2 )
> binded WITH { "2", "NULL" }

This is pseudo-code!!
 
> Can I in RB say something like
> 
> Dim myArray() as String
> 
> myArray.Append("somevalue")
> myArray.Append("anothervalue")
> 
> insert into myTable(field1,field2) VALUES (:1,:2) binded with myArray

Last line as:

    db.SqlExecute( query, myArray )

See V4RB/Examples/SQL_way/Binding

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]