Digital Workshop

Hi,
I have built a database with some 452 different queries along 250 pages. All is working fine...
I know that to disengage the database it is better to add the endquery action to a button or to a page when you exit the pub.
My question is this: is there any possibility to apply a general action that will close the the queries? even is in scripting mode? I can't go page by page producing buttons that close different queries, it will take me ages. I rather have one command to globally close all the queries when this button is click (it will be add to a "EXIT" button in the pub so at any time and at any page the customers is and decides to leave the pub, all the queries will be closed)
Please help!
German

Hello German,

What do you mean with: "endquery action"?
I'm using databases in Opus for years and I never read about this action.

Kind regards,

Hi Oscar,
Thanks for replying to my post. When Opus communicates with a database via queries uses memory from your system and if you have a lot of queries going on at different times and on different pages of your publication there is a risk of slowing the pub and even of crashing it. Believe me, it has happened to me.
So the best way of avoid this is to add a End Query Action to one button in your page (this is what I do most of the time), preferable to the exit button since this exit button is reproduced in every page in my publications so if the customers wants to leave at any point the can do it and by adding this action I am making sure that Opus disengage the database and therefore, release memory used while the pub is open. If you do not do this, the database remains engaged, just watch the behaviour of your databases without this action.
The problem is that in large databases with a lot of queries I have to apply many times the same End Query Action to the same buttons for as many queries are running in a particular page in the background. Sometimes I am running up to 14 queries extracting data from all different fields from different tables on the same database to present them inside the Opus Pub and this is why I want to see if it is possible to add a global End Query Action that will close "all the queries running" in one go, rather that the option of creating as many End Query Action as per the number of queries running in a particular page. I hope this makes sense.
Cheers mate
German

Hi German,

Ok I understand. But I never found a script in Opus to end a query. Does this exist and I don't know about it or is this something for the wish list?

If it exists probably you can use a while statement like:

var n=0
while (n<20)
{
db[n].EndQuery()
n++
}

db should be an array variable you use to execute the query.
This way you can Stop the queries db[0]......db[19]

Best regards,

Maybe a option to close the DSN and reconnect?

var DB = new Database(“DSN=My.dsn;”)
var dbConn = myDB.Connect(“MyName”, password)


dbConn.Close
Set dbConn = Nothing

Br

Jim