https://bugs.documentfoundation.org/show_bug.cgi?id=95542
Bug ID: 95542
Summary: Help file on parameter queries confusing and wrong
Product: LibreOffice
Version: unspecified
Hardware: Other
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: LibreOffice
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: l...@ptoye.com
The text at https://help.libreoffice.org/Common/Query_Design#Parameter_queries
is rather confusing and on occasions it seems to be wrong.
This is the first time that the concept of "variable" has been introduced, but
it is not defined anywhere. Is it meant to mean that an SQL variable is created
and assigned a value?
The square bracket notation does not work, but without an example it's
difficult to see what the author meant (translation problem?). Certainly
putting << =[Prompt] >> (without the angle brackets) in the "criterion" row of
a query design doesn't work.
As it currently works, the text after the colon is not the variable name, but
the prompt which is output by LO. Or is this also the name of an SQL variable?
The comment about placeholders is a bit too terse. One can assume that the
comma in the example is not a literal (but "and" might be clearer), but just
what constitutes a "special character"? "Such as..." shouldn't really appear in
a technical document. And the last line of the section uses the word
"placeholder" in a completely different context.
I would be willing to help clean up this text but don't have editing rights.
The help wiki doesn't seem to have a "register" option - probably a good idea
to stop amateurs like myself from messing up the system :)
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
