update Valentina DB

[Beatrice Engemann]

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?



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


> On 1/11/05 9:22 PM, "Beatrice Engemann" <Beatrice.Engemann at gmx.de> wrote:
>
> > I don`t understand this command sqlexecute.
> >
> > UPDATE T SET f1 = 5, f2 = 6 WHERE f1 > 10
> >
> > Have you a better example?
>
> Then better you please describe WHAT YOU NEED?
> What is your task? Exactly.
>
>
> > ----- Original Message -----
> > From: "Ruslan Zasukhin" <sunshine at public.kherson.ua>
> > To: <valentina at lists.macserve.net>
> > Sent: Tuesday, January 11, 2005 7:50 PM
> > Subject: Re: update Valentina DB
> >
> >
> >> On 1/11/05 7:12 PM, "Beatrice Engemann" <Beatrice.Engemann at gmx.de>
wrote:
> >>
> >> Hi Beatrice,
> >>
> >>> i want to update Valentina DB for Director withoit a Valentina Server.
> >>>
> >>> I want to update Valentina DB with a .txt File.
> >>>
> >>> For example:
> >>>
> >>>         insert into 'Artikel' values (RecID, '13642874','5',0);
> >>
> >> Hmm, you say you want update, but show example of INSERT command?
> >>
> >>> But valentina does update Record for one Record
> >>>
> >>>         updateRecord(gCursor)
> >>>
> >>>  How can an update be realized for several records?
> >>
> >> You have this way
> >>
> >>     db.SqlExecute( "UPDATE T SET f1 = 5, f2 = 6 WHERE f1 > 10 " )
> >>
> >> This will update several records.
> >>
> >> Is this what you need ?
>
> --
> 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
>