insert record parameter binding

[Ruslan Zasukhin]

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

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

Problem not in wrong order.

But :n  is potentially more flexible:

    you can for example reffer the same array value few times:

    values( :1, :1, :2, :1 )


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