|
Previous
·
Next
|
rogier
|
Date: 12/20/2007 8:04 am · Subject: Prequery in SQL report doesn't work? · Rating: -4
If I use a prequery statement in an SQL report to set a variable, it doesn't work. I use this variable for an asset-id, like so: set @myvar := "(some asset-id)" The SQL report does work without using the prequery. Am i doing something wrong? Does anyone else have this problem? WebGUI version is 7.4.9 Thank you in advance, Rogier
--- (Edited on 12/20/2007 8:05 am [GMT-0600] by rogier) ---
|
| Back to Top |
Rate [ | ]
|
| |
rogier
|
Date: 1/16/2008 3:58 am · Subject: Re: Prequery in SQL report doesn't work? · Rating: -5
I would like to know if i should report it as a bug. Anyone?
--- (Edited on 16-01-2008 10:58 am [GMT+0100] by rogier) ---
|
| Back to Top |
Rate [ | ]
|
| |
colink
|
Date: 1/16/2008 10:46 pm · Subject: Re: Prequery in SQL report doesn't work? · Rating: -7
I would post it as a bug. You've tried to get an answer off the boards, and no one is biting. Probably because not many people use prequery statements.
--- (Edited on 1/16/2008 10:46 pm [GMT-0600] by colink) ---
|
| Back to Top |
Rate [ | ]
|
| |
zzois
|
Date: 5/6/2008 6:21 am · Subject: Re: Prequery in SQL report doesn't work? · Rating: 0
On etcetera you can find discussion thread related to this one:
http://www.webgui.org/etcetera/sql-report-how-to-use-prequery-statements
... and it seems that no one has yet reported a bug. If nobody else is willing (or has the time) to do it, I will... ;-)
--- (Edited on 6-May-2008 13:23 [GMT+0200] by zzois) ---
|
| Back to Top |
Rate [ | ]
|
| |
zzois
|
Date: 5/6/2008 9:36 am · Subject: Re: Prequery in SQL report doesn't work? · Rating: 0
And here it is: http://www.webgui.org/bugs/tracker/sql-report-doesnt-support-use-prequery-statements
--- (Edited on 6-May-2008 16:36 [GMT+0200] by zzois) ---
|
| Back to Top |
Rate [ | ]
|
| |
martink
|
Date: 5/12/2008 10:58 am · Subject: Re: Prequery in SQL report doesn't work? · Rating: 0
You will have to add the SET statement to the allowed keywords for the db link you are using. If you are using the default db link you'll have to create an additional db link (because you cannot change the properties of the default db link) to the webgui db and use that for your query.
The reason that you cannot edit the default db link is that you can crash your webgui site if you set its parameters wrong.
--- (Edited on 2008-05-12 17:58 [GMT+0200] by martink) ---
|
| Back to Top |
Rate [ | ]
|
| |
|
|
Re: OReilly by koen - Sat @ 06:44pm Re: OReilly by JT - Sat @ 12:46pm Re: Glad to be here by Mike_S - Sat @ 09:11am Partner Marketing Goals? by koen - Sat @ 08:15am Re: OReilly by koen - Sat @ 08:07am Re: Glad to be here by koen - Sat @ 08:05am
|
