Re: JOINs in Oracle Forms?

Thanks for the help. I got further now but have a new problem: empty results.

I finally learned how to make use of the :SYSTEM.LAST_QUERY variable to see what was (allegedly) sent. The problem is that it *contradicts* the results that SQL*Plus give me.

Many times FORMS returns no records dispite pasting the exact SQL in SQL*Plus and having it work there. I even rebooted to make sure there is nothing floating in cache that the other does not see.

For example, a "browse" window lists a bunch of rows. When the user double-clicks on a row, it brings up a detail form. I have the double-click event alter the WHERE_CLAUSE property of the detail block to bring up that one record (generally using an ID of some sort). It works on *some* of the records, but not all. I cannot see a difference between the records it works on and the records it does not.

The :SYSTEM.LAST_QUERY shows what is expected (resembling: ....WHERE foo_ID = 'A742') and works fine in SQL*Plus. I don't know why Forms says that the query returned no results for some records. The same record shows on the browse form, but why can't the detail form see it? This cannot be attributed to any mismatch between SQL*Plus (in this case) because Forms *also* shows the record on the browse form.

Could it be that having two different blocks referencing the same table causes it to get confused? I disabled editing on the browse form.

>
> The error message "FRM-40505: ORACLE error: unable to perform query"
> is not very helpful as a debug message but it is not meant to be, it
> is only a warning to end users. To access a more detailed message
> there is a function called "display error". This can be called by
> pressing shift+F1 for client server or shift+ctrl+E for a webforms
> app. This will bring a grey box into the middle of the screen with
> details of the sql statement that failed if applicable.
>
> Also you mention that you have to keep re-aligning items when some
> unknown behaviour occurs. Could it be that you were re-sizing a frame
> on a canvas at the time? To avoid forms automatically re-jigging? your
> items there is a property on all frames called "update layout" which
> should be set to locked.
>
> Hope this helps and hope I've not missed the point too much.
>
> Steve E.

Thanks, -Tmind- Received on Tue Feb 05 2002 - 01:26:18 CET