update Valentina DB
Beatrice Engemann
Beatrice.Engemann at gmx.de
Tue Jan 11 20:22:00 CST 2005
I don`t understand this command sqlexecute.
UPDATE T SET f1 = 5, f2 = 6 WHERE f1 > 10
Have you a better example?
----- 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
>
More information about the Valentina
mailing list