Power Objects problem

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 Received on Thu Mar 14 1996 - 00:00:00 CET