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