Re: Power Objects problem

cisco_at_netins.net (Peter Bowers) wrote:

>I have an OPO application that accesses an Oracle Workgroup Server over
>TCP/IP. I copied the tables from the Workgroup Server to a new local
>Blaze database. Whenever I attempt to run the application, I encounter
>the following error which does not occur when accessing Oracle 7:
 

>SES-06000 Database error: SQL-00021: Expecting from, got stringConcat
>FRD-06058:Database error intializing value/translation query for
>"room_lst"
>BAS_00384: Object not found
>BAS_01058: Error compiling source code
>
>The code this is occurring on is in the Translation property:
 

>= select decode(nvl(approval,0),0,' ','*') ||
>rpad(substr(city,1,12),13,' ') || rpad(substr(room_name,1,20),21,' ') ||
>to_char(decode(use_fee,0,NULL,use_fee),'$90.99),id from room order by
>room_name
 

>Are there command incompatibilities between Blaze and Oracle 7? Any
>suggestions, comments are most welcome.
 

>Peter Bowers
>cisco_at_netins.net

Use CONCAT Sql function instead of || and it will work. Thus you query in the tranlation property will become ==>

• select CONCAT(decode(nvl(approval,0),0,' ','*'),| CONCAT(rpad(substr(city,1,12),13,' '), CONCAT(rpad(substr(room_name,1,20),21,' '),| to_char(decode(use_fee,0,NULL,use_fee),'$90.99)))), id from room order by room_name

Hope this helps.
sm Received on Thu Mar 14 1996 - 00:00:00 CET