update Valentina DB

[Beatrice Engemann]

Thanks, but  Valentina makes this only for one record.
I have tries these with "And" to connect,  nevertheless Valentina makes only
one record. how can I at one time put on several records with the
instruction?





----- Original Message -----
From: "Ruslan Zasukhin" <sunshine at public.kherson.ua>
To: <valentina at lists.macserve.net>
Sent: Tuesday, January 11, 2005 9:18 PM
Subject: Re: update Valentina DB


> 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
> -------------------------------------------------------------
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>