Welcome! Log In Create A New Profile

Advanced

Retrieve SQL-Code from Query

Posted by AndyD 
Forum List Message List New Topic
AndyD
Retrieve SQL-Code from Query
September 04, 2008 10:43AM
Hello,

is there any way to retrieve the SQL Code from a Query? I would like to reuse some code which already exists in some of my Querys for use with HExecuteSQLQuery.

Thanks.

Best regards
Andreas
Reply Quote
Udo
Re: Retrieve SQL-Code from Query
September 04, 2008 01:49PM
Hello Andreas

In WD12 you can use the new property sqlcode.

MySQL is string
mySQL = Myquery..SQLCode


Udo
Reply Quote
AndyD
Re: Retrieve SQL-Code from Query
September 04, 2008 02:32PM
Thank you very much.

Best regards
Andreas
Reply Quote
Newer Topic Older Topic
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: