insert record parameter binding

[Bart Pietercil]

On 14-feb-07, at 12:39, Ruslan Zasukhin wrote:

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

Off course I remember seeing something about that problem

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

Noted


>
> Last line as:
>
>     db.SqlExecute( query, myArray )
>
> See V4RB/Examples/SQL_way/Binding


OK found it, one small thing remains unclear:
  when you use values(?,?,?) this means order as found in binded  
Array, when you use values(:1,:3,:2) you know that bindArray is in  
wrong order? Is that the difference?

Thx

Bart