LiveCode/Valentina - SQL INSERT with bindings returns error

[wtng]

Friends,

 

BACKGROUND: I have 4 entry fields (name is prefix with ef..) on a livecode
stack and an ADD button. Database/Table/Field references all done and stable
in card script.

 

When I enter:

 

   put field efCode into tArray[1]

   put field efCost into tArray[2]

   put field efDescription into tArray[3]

   put field efPrices into tArray[4]

      

   get VDatabase_SqlExecute (mDatabase, "INSERT INTO pricelist (code, cost,
description, prices) VALUES (:1,:2, :3, :4);", tArray)

 

 

This fails with the error:  "7004 Using clause required for dynamic
parameters."

I did not expect this as the V4Rev reference does not have 'USING' in this
function's syntax.

 

Have I missed something?

 

Sincerely

Ng Wee Tong

Livecode 4.6.4

Valentina 4.9.1

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20120627/4a0fd98a/attachment.html>