JOINs in Oracle Forms?

From: Topmind <topmind_at_technologist.com>
Date: 28 Jan 2002 21:55:19 -0800
Message-ID: <4e705869.0201282155.7ab4bfe4_at_posting.google.com>

[Quoted] I need to populate a multi-record read-only form (aka "grid" equiv) from an SQL with a JOIN in it. The simplest way seems to be via a View, but I have to go thru the DBA for that and it is a bit of red tape.

It seems others have had difficulty doing the same thing in messages a few years old here. Is there any new feature to do this? The Help mentions a FROM clause lookup of some kind, but I can't find any syntax examples.

Why are the simplist things a bear in Forms? Does it get better with practice, or is Forms just outdated? I can't seem to figure out Oracle's design philosophy for this tool. It seems *random* so far. Odd limitations with odd error messages and odd triggers at odd times.

Thanks in advance, -T- Received on Tue Jan 29 2002 - 06:55:19 CET