We created a report in 5.0 that had some manual entries in the SQL window. Essentially, we were accessing the TempDB space of a Sybase DB. Once we upgraded to 5.0.1, we now receive this message when trying to execute our 5.0 report:
The only authorized SQL command is “SELECT”.(QPF0001) The error message explains that you cannot even place a comment before the ìSelect statementîÖ…
We have executed the same SQL Block outside of BO without an issue, so I’m pretty sure it isn’t a DB issue.
Has anyone else had this error message or is this a ëfixí in 5.0.1?
I have already verified the connection is not the problem. ODBC settings are UPDATE and when using a CREATE or INSERT statement outside of Business Objects with this same ODBC connection, it works fine.
Is there something in Supervisor which allows additional commands besides SELECT?
I have, to the best of my knowledge, confirmed that it is not a Sybase issue. Even in the “Free Hand SQL” window, I receive the same error message, where in the past this querying option was extremely flexible. The only change that I’m aware of in terms of environment is from 5.0 to 5.0.1…
SELECT in BO besides through
Free-Hand SQL? Is there an option in Designer or Query or Supervisor?
Hopefully answering the 7 or so mails on the subject…
In Supervisor, under the options for BusinessObjects, look at the Query Technique section. There is a command ‘Restrict SQL to “Select” only’. This is the default setting.
I haven’t thought how you would use any other command except through free-hand SQL but this should control that as well.
Regards
Jonathan
Project Leader
Group Medical, Regulatory and Product Strategy IS.