Frank Schönheit - Sun Microsystems Germany wrote:
Hello Barbara,
When I tried this as a query, that didn't work either:
SQL Status: 00000
Error code: -155
Statement does not generate a result set
Just as explanation, as you already found your way:
This message says you executed the statement in the query designer. The
designer is intended for SELECT commands, that is, commands which return
data to display and maybe edit. An "administrative" command (it depends
on the definition of "administrative" whether the online help is right
with its claim) as yours does not produce any data - thus their
execution might even succeed, but as soon as OOo asks the database
engine for the resulting data, you will get the above error.
Ciao
Frank
Thanks for the explanation, Frank. This modality is pretty confusing for
somebody who's used to "update queries" from that other program! Maybe
the doc should all make it clear that the Designer is only for SELECT
commands (nothing else produces a result set, right?), and the Tools |
SQL option is for all the rest. The examples included for that all
looked truly administrative, be nice if it mentioned UPDATE. The term
"administrative" is easily misunderstood, it brings to mind "something
only the database administrator is supposed to do" and has the
implication of being separate from the actual content of the data.
Interestingly, the Designer would save the invalid form of the command
(the TRIM with missing parameters) but neither of the valid ones, and
the valid versions did not have any effect there either from Edit | Run
query or via direct SQL.
Now I think it's time for me to go back through all this, submit any
RFEs/bug reports that aren't already there, and post a summary with all
the reference numbers that apply to the things I've run into. It'll
probably take a while to get to it, though. Should the addition of
leading and trailing blanks for copies from Writer be considered a bug,
or is changing that an RFE?
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
