Frank,
That thought had occurred to me after I sent this message, but I hadn't
had a chance to test it until now.
I tried the nested CONCATs, per Drew's message, with the single quotes
and it does work now. In fact, I went back and tried the CONCAT_WS
function again and it also works with single quotes around the first
argument (delimiter string). CONCAT_WS produces the same result, but
is simpler than the nested CONCATs for my application.
I thought I read as much as I could find about Base, but I don't
remember any of these formats. Is this documented somewhere and if so,
can you tell me where?
Although this workaround isn't pretty (i.e., data is not displayed in
nicely spaced columns), it does present all the data I need to allow me
to proceed with converting my forms and reports to Base.
Thanks to everyone for all the help.
Girvin
Frank Schönheit - Sun Microsystems Germany wrote:
Hi Girvin,
4. Looking in my MySQL manual, I discovered the CONCAT_WS function,
which is supposed to insert a specified delimiter string between each
field. However, Base objected, stating that it was an unrecognized
field. I tried `,` , `-` and even `|`, but I got the same error no
matter what I used as a delimiter string.
...
5. I then tried Drew's suggestion of nested CONCAT functions. This
also does not work. I get a similar failure as in the CONCAT_WS
function. Base complains about the use of ` ` as the first field of
the CONCAT function.
You should use ' (the single quote character), not `:
The latter is MySQL's quoting character for identifiers, that is,
whatever you enclose in it, will be interpreted (by MySQL as well as
Base) as a identifier, in the given context, as a column name.
The single quote character, on the other hand, is used to identify a
string literal, and this is what you need here.
Ciao
Frank
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
