Designer 6i and RDBv7.1

From: adam <aweber_at_hutapokoj.com.pl>
Date: Thu, 21 Mar 2002 11:13:48 +0100
Message-ID: <a7cblf$a81$1_at_news.tpi.pl>

Hi!
I have problem with INSERT statment syntax in forms generated from Oracle Designer 6i for ORACLE Rdb v.7.1datebase.

FRM-40508: ORACLE error unable to INSERT record. ORA-00900: invalid SQL statement

Generated INSERT syntax:

     INSERT INTO <tablename> <alias table> (fieldname) VALUES (value);

is not valid for Oracle RDB, <alias table> is not acceptable for RDB databse.
Is it possible to change it in Designer ? Received on Thu Mar 21 2002 - 11:13:48 CET