update Valentina DB

[Ruslan Zasukhin]

On 1/11/05 9:57 PM, "Beatrice Engemann" <Beatrice.Engemann at gmx.de> wrote:

> my Problem:
> 
> for example script in Director:
> 
> myCursor = db.query("INSERT INTO Artikel (ArtikelNr,Name, Beschreibung)
> VALUES ('136428744', 'Fleece','bla bla bla', Null);")
> 
> UpdateRecord(myCursor)
> 
> Valentina Error 2 Why?

Because this is absolutely not correct.

1) Db.query -- we have no such function.

    We have SqlExecute()

  db.SqlExecute( "INSERT INTO Artikel (ArtikelNr,Name, Beschreibung)
       VALUES ('136428744', 'Fleece','bla bla bla', Null)" )


2) SqlExecute() do NOT returns cursor.
    You have execute one INSERT. Was added one record to a table.
    why you expect cursor ???


3) UpdateRecord(myCursor) -- this is not needed.






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