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