Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Forms 6i Tab Canvas "Irregularities"?

Re: Forms 6i Tab Canvas "Irregularities"?

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Sun, 16 Apr 2006 15:13:39 -0400
Message-ID: <rdSdnVpwRe_0Ct_ZnZ2dnUVZ_uWdnZ2d@comcast.com>

"Dereck L. Dietz" <dietzdl_at_ameritech.net> wrote in message news:4Qu0g.66058$H71.41886_at_newssvr13.news.prodigy.com...
:I have even just now tried to change the code to actually put in the insert
: and update statements and I still get the same results.
:
: I should also state that I have an old form which correctly works. The
only
: difference between the other form and this new one is this:
:
: The original form (which worked) I had a flag which indicated which tab
page
: to go to depending on whether the player was a pitcher or not. This new
: form I no longer have that flag and just default to the batting tab page
for
: everybody and just manually go to the pitching page for pitchers.
:
: I'm at a COMPLETE loss as to why it just won't work now and it doesn't
: display any errors to me either. It just doesn't commit when I enter
: pitcher information without at least one batting record.
:
:

it really does not sound like you are using Forms correctly

you should not need to be putting in insert and update statements (where in the world are you putting them?) -- just base your blocks on the database table, and the select, insert, update, and delete statements get manage for you automatically by forms

also, your previous comment about using the WHERE Clause Block property is the incorrect way to do block coordination -- and in fact, is probably why your new records aren't showing up

i'm guessing you'll find your 'non-committed' records in the database (check via SQL*Plus or some other tool) with no player_id (assuming player_id is a nullable comment, which it sounds like it shouldn't be, as it appears that it likely should be part of a composite primary key)

the correct way to do block coordination is done for you automatically by the wizards -- i don't have time (are a access to a working installation) now to check the specific properties, but if you do a simple test form and generate a master block and then a detail block with the wizards, you'll see how the item properties are set in the detail block's FK to ensure that 1) the detail records are filtered during selection and 2) new detail records include a correct (defaulted) value for the FK

maybe someone else looking at this has forms up and running and can plug in the details on standard block-coordination properties

++ mcs Received on Sun Apr 16 2006 - 14:13:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US