Re: JOINs in Oracle Forms?

[Quoted] Topmind <topmind_at_technologist.com> wrote in message news:4e705869.0201282155.7ab4bfe4_at_posting.google.com...
> 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-

hmmm, you are a Micro$oft developer ? Forms is the coolest !

steps to create From clause query form:

1. select From clause query as datasource for your block
2. Put your select statement in Query Data Source Name property
3. create corresponding items in the block
4. Run y'r form