[dba-users] 2.0.3 SQL View and Query parser

[Jahn, Ray \(R.\)]

Issues:
* string concatenation || in Select statements
* host variables and paramenters in Where criteria

Does OO Base use different codes to parse
SQL statements about View and Query?

Ray

Reference:
www.openoffice.org/issues/show_bug.cgi?id=59211
string concatenation || in Query section

 -----

Select "column 01" || ' add-on string'
>From   "table 01";

    working in View  creation (Table section)
not working in Query creation

 -----

Select "column 01"
>From   "table 01"
Where  "table 01"."column 01" Like :xx_host_variable;

not working in View  creation (Table section)
    working in Query creation

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]