Database_SetTimeOut

[Ruslan Zasukhin]

on 3/5/04 5:10 PM, Ken Ray at kray at sonsothunder.com wrote:

>>> What is the purpose for Database_SetTimeOut? Does it:
>> It sets query (command) timeout and it is measured in
>> seconds. Default value is 60 seconds. You can set it to
>> greater value before sending to the server a query that can
>> potentially take a long time to complete.
> 
> Thanks for the explanation, Igor, but the docs REALLY need to be changed
> on this one. Not only does it not mention anything about queries (it
> uses the phrases "cursor" and "database connection" instead), but it
> also says the default value is infinity (not 60 seconds).

Ken, you talk about VXCMD docs or about Vserver.pdf?

> So when the 60 seconds are over, does Val get an error coming back, or
> does it just stop the query in progress and move on?

If you do LONG time query, you get error.
You return from SqlExecute() and you can check that error.
And continue as you need.

If you have such long queries you need increase timeout.
The same you can see in AppleScript.

--------------
Interesting, Igor, server also stops execution of this LONG query?
It must stop of course.

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