[VNET] Problem with sql-statement and "binded with"

[SoftIl]

Hi Ruslan,
>    sql = "INSERT INTO auslaufarten (bezeichnung,kennzeichen,key,record_id)
>           VALUES (:1,:2,:3,:4)"
>     db.SqlExecute( sql, params )
Ok, I've got changed my code and now I get an fatal error, if I call
db.SqlExecute.
> And then examples must have such code
That's right, but with the example (Sample2) I get the same fatal error:

/Start----------------

Microsoft Visual C++ Debug Library

Debug Assertion Failed!

Program:  ..\Sample2.exe    (It is your example 2)
File: dbgdel.cpp
Line:52

Expression: _BLOCK_TYPE_IS_VALID(pHead->nBlockUse)

/Ende---------------------

Best regards,
Carsten

----- Original Message ----- 
From: "Ruslan Zasukhin" <sunshine at public.kherson.ua>
To: <valentina at lists.macserve.net>
Sent: Wednesday, October 22, 2003 2:32 PM
Subject: Re: [VNET] Problem with sql-statement and "binded with"


> on 10/22/03 14:30, SoftIl at softil at onlinehome.de wrote:
>
> > Hi,
> > what is wrong:
> > I try this:
> > "INSERT INTO auslaufarten (bezeichnung,kennzeichen,key,record_id) VALUES
> > (:1,:2,:3,:4) binded with
> > {'Hofweide','0','1','e75eb429-6844-4e6a-8730-71779d079eb6'}"
> > and I get an error "The object reference was not fixed to an object
> > authority." in MS Visual Studio and also in Valentina Studio (Errore:
unknown
> > error).
> >
> > If I do that:
> > "INSERT INTO auslaufarten (bezeichnung,kennzeichen,key,record_id) VALUES
> > ('Hofweide','0','1','e75eb429-6844-4e6a-8730-71779d079eb6')"
> > it works.
> >
> > Where is the problem??
>
> Mistake is here:
>
> 1) SQL String MUST NOT HAVE words "bind with"
>     this was pseudo-code in SQL.pdf.
>     Hmm, I need change this, already 3d developer catch this.
>
>
> 2) must be
>
>    sql = "INSERT INTO auslaufarten (bezeichnung,kennzeichen,key,record_id)
>           VALUES (:1,:2,:3,:4)"
>
>
>     db.SqlExecute( sql, params )
>
>
> Carsten, please check our NET examples
> On this.
>
> I do not remember if we have implement this.
> It seems YES.
>
> And then examples must have such code
>
> -- 
> Best regards,
> Ruslan Zasukhin      [ I feel the need...the need for speed ]
> -------------------------------------------------------------
> e-mail: ruslan at paradigmasoft.com
> web: http://www.paradigmasoft.com
>
> To subscribe to the Valentina mail list go to:
> http://lists.macserve.net/mailman/listinfo/valentina
> -------------------------------------------------------------
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>