Welcome! Log In Create A New Profile

Advanced

Query name and indirection

Posted by John Marrone 
John Marrone
Query name and indirection
May 11, 2009 04:08PM
Hi All

I don't know if this can be done. I have tried to do this different ways. Here is some code

<code>
Procedure ReExecQuery(qry is string)
HCancelDeclaration(qry)
HExecuteQuery(qry, hQueryDefault + hModifyFile ,Cur.RaceID)
RETURN

I have to do this call a lot on different query's. But using {qry} does not work. And if I try to do this ie: qry is Query it doesn't work because there is no query type. Maybe this can't be done. If someone has done this I would be grateful if you would shall the knowledge.
M. Beaven
Re: Query name and indirection
May 11, 2009 07:39PM
John,

While I haven't tested specifically for a query, I am using indirection in the following syntax for files:

{sNameOfFile,indFile} where sNameOfFile is a string.

Perhaps this will also work for queries.

HTH-

Marc
Peter H.
Re: Query name and indirection
May 11, 2009 09:45PM
Hi,

You can also declare your query variable as a Data Source type which is more elegant.

Cheers,

P.
Author:

Your Email:


Subject:


Spam prevention:
Please, enter the code that you see below in the input field. This is for blocking bots that try to post this form automatically. If the code is hard to read, then just try to guess it right. If you enter the wrong code, a new image is created and you get another chance to enter it right.
Message: