LiveCode/Valentina - SQL INSERT with bindings returns error

[Mike Bonner]

Sorry, was replying to another message and seem to have accidently wiped
out the question text.  Sec and I'll add the question to it.


Here is the original. Sorry, I shouldn't answer things this early in the
morning. (This Was from wtng)

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

**

On Wed, Jun 27, 2012 at 5:39 AM, Ruslan Zasukhin <
ruslan_zasukhin at valentina-db.com> wrote:

> On 6/27/12 2:27 PM, "Mike Bonner" <bonnmike at gmail.com> wrote:
>
> Hi Mike,
>
> I have not catch.
>
> Examples works fine.
> You complain on docs?
>
> What is wrong ?
>
>
> > You might look in this folder Documents\Paradigma
> > Software\V4REV_4\Examples\SQL_way\Bind (your user documents folder) and
> check
> > out the bind example stack that is there.
> >
> > The only thing I notice is you have a trailing semicolon in your code.
> Don't
> > know if thats the problem but the examples don't have it so its worth a
> check.
> >
> > The example itself works like a charm so it's worth digging through it.
>
> --
> 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]
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20120627/976b271b/attachment-0001.html>