update Valentina DB

Ruslan Zasukhin sunshine at public.kherson.ua
Tue Jan 11 21:29:01 CST 2005


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




More information about the Valentina mailing list