update Valentina DB

[Ruslan Zasukhin]

On 1/12/05 1:50 AM, "Beatrice Engemann" <Beatrice.Engemann at gmx.de> wrote:

> why?  are there different possibilities without VServer?

Why you think that Vserver 1.x can do this ?
It also require separate SQlExecute calls.

> I wanted to use a simple text file as updates.
> With which instructions can one otherwise converted?

You mean that you have TEXT FILE with many INSERT statements ?

You can self in LOOP read query by query (searcing for ;)
And do each query with SqlExecute()

If I not mistake this feature present in the viSQL utility


> ----- Original Message -----
> From: "Ruslan Zasukhin" <sunshine at public.kherson.ua>
> To: <valentina at lists.macserve.net>
> Sent: Wednesday, January 12, 2005 12:37 AM
> Subject: Re: update Valentina DB
> 
> 
>> On 1/12/05 12:55 AM, "Beatrice Engemann" <Beatrice.Engemann at gmx.de> wrote:
>> 
>>> Thanks, but  Valentina makes this only for one record.
>>> I have tries these with "And" to connect,  nevertheless Valentina makes
> only
>>> one record. how can I at one time put on several records with the
>>> instruction?
>> 
>> You mean with single SQL command?
>> 
>> In SQL92 this is made with such syntax
>> 
>>     INSERT ....   ; INSERT .... ; INSERT ....
>> 
>> But this is not supported in Valentina 1.x
>> 
>> 
>> So you need do several SqlExecute() calls.
>> 

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