Hello,
I've been digging for documentation on OpenBD's query-of-query
syntax. I'm attempting to port an app from CFMX7 to OpenBD 7, and
receiving an error message on a query-of-query that uses several cast
calls (e.g., CAST(data_intStatus AS CHAR)). CFMX7 supports this
syntax, but OpenBD does not appear to:
The following error was produced: Encountered "cast" at line 12,
column 9. Was expecting one of: "*" ... "[" ... <IDENTIFIER> ...
<INTEGER_LITERAL> ... <FLOATING_POINT_LITERAL> ... "count" ...
"avg" ... "sum" ... "min" ... "max" ... "(" ... "+" ... "-" ...
"?" ... <STRING_LITERAL> ... "upper" ... "lower" ...
Neither the wiki nor the OpenBD docs seem to contain any references to
STRING_LITERAL. Is there somewhere else I should be looking to see
usage and syntax of the expected arguments, or is there a way to get
CAST to work in QoQs, or a relatively straightforward syntax change
(one can hope!)?
cheers,
-ben
--
tag/function ref: http://www.openbluedragon.org/manual/
mailing list - http://groups.google.com/group/openbd?hl=en
