insert record parameter binding

[Bart Pietercil]

Hi Ruslan,

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

Not really clear on the wiki, if I may say so :-)

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

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


TIA

Bart