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

[Ruslan Zasukhin]

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