index | search | no replies | posting guidelines | help

login | register

Index » Products » ASP Report Wizard v2

search this forum:

:: Disaply SQL Statement being used by the wizard :: (10) Post a New Message | Post a Reply
Sep 19 2005, 8:13 PM	Disaply SQL Statement being used by the wizard Post a Reply
MindTelligent since: May 10, 2005 from: El Dorado Hills, CA	Is it posssible to display the SQL statement being used by the wizard? (We need this for debugging purposes)
Sep 20 2005, 8:50 AM	Re: Disaply SQL Statement being used by the wizard Post a Reply
ghost from: Washington, DC	The reason we have not given the option to display the SQL statement is because it might cause a serious security breach if not turned off in production (especially when you are using features like HiddenSqlFilters within your reporting application). To reduce this rish we could just display on the SELECT fields and table names. Will this help in your debugging? ------------------------- Ghost
Sep 20 2005, 2:22 PM	Re: Disaply SQL Statement being used by the wizard Post a Reply
MindTelligent since: May 10, 2005 from: El Dorado Hills, CA	This will not solve the debugging issue. Is there a way we can display the SQL statement. To remind the developers to turn this off in the production environment, we can always bring up a message in the message box saying something like "SQL Switch is turned on, we recommended to turn this off in the production environment" Thanks for your help Thanks
Sep 20 2005, 3:11 PM	Re: Disaply SQL Statement being used by the wizard Post a Reply
ghost from: Washington, DC	We will add this option by the next minor release thanx! ------------------------- Ghost
Sep 24 2005, 9:58 AM	Re: Disaply SQL Statement being used by the wizard Post a Reply
ghost from: Washington, DC	This feature has been added though it is still in beta  that is why I did not anounce it in the news forum. You can display the prepared SQL statement used by the report wizard by setting the DisplayPreparedSqlCommand property to True as follows: objWiz.DisplayPreparedSqlCommand = True ------------------------- Ghost
Sep 26 2005, 9:06 AM	Re: Disaply SQL Statement being used by the wizard Post a Reply
MindTelligent since: May 10, 2005 from: El Dorado Hills, CA	Thanks for all your help!!!
Oct 2 2005, 4:59 PM	Re: Disaply SQL Statement being used by the wizard Post a Reply
MindTelligent since: May 10, 2005 from: El Dorado Hills, CA	We tried the latest version and get the message This property DisplayPreparedSqlCommand is only available in the licensed version. We have a licensed version of the software and have included the license key in the default asp file. Please help
Oct 3 2005, 10:04 AM	Re: Disaply SQL Statement being used by the wizard Post a Reply
ghost from: Washington, DC	Is the domain on which you are using this property the licensed domain? ------------------------- Ghost
Oct 3 2005, 3:51 PM	Re: Disaply SQL Statement being used by the wizard Post a Reply
MindTelligent since: May 10, 2005 from: El Dorado Hills, CA	Yes it is. In the header bar of the browser still says "Free version"
Oct 4 2005, 5:42 AM	Re: Disaply SQL Statement being used by the wizard Post a Reply
whichman from: Laurel, MD	Well, if it says free version it means that the license key has not been set. Either your current domain is different from the licensed domain or your license key property was not weel set. Make sure you set your license key property before you initialize your connection string. ------------------------- Master of the Game
Pages: (1)   [1]

search this forum: