FRM-30113 errors on Form converted from 4.5 to 5.0

I've got a form, developed using Forms 4.5 (16 bit) running against an Oracle 7 database. It has a master block and 3 detail blocks and is as a 'Query Only' version of another form. It compiles and runs without error in 4.5. Since we plan an upgrade to Forms 5 and Oracle 8, we have several laptops set up with Dev2000 2.1 and PO 8 that we are using to test the conversion process. After opening this form in Forms 5 and letting it convert all the triggers, the PL/SQL compiles without error; but when I run the form in Form Builder, I get three "FRM-30113 Block must have a non-query-only database item" errors, one for each detail block. Forms Runtime then opens properly, the form runs fine and does everything it's meant to do. When the .FMX is opened in Forms Runtime, it works fine, no error messages crop up. I've double checked the block level and item level properties for both the master and all the detail blocks, everything is set Query Only = YES, Insert Allowed = NO, Update Allowed = NO, and the blocks are set Delete Allowed = NO. Setting Query Only = NO causes the form to compile without error, but the detail blocks do not populate; the cure is worse than the disease.

Is this just another of Oracle's silly little quirks, a Forms version of the infamous SQL*Plus "Input truncated to 1 character" message, or am I missing something that will come back to bite me later? Even if the first, is there a way to eliminate the error without defeating the purpose of the Query-Only form (my boss gets VERY nervous over error messages)? In case you are wondering, the original "Insert/Update" version compiles and runs without error in 5.0 after conversion.

Paul Beretta
(just a lowly, lowly developer)

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Nov 13 1999 - 16:23:57 CET