Re: Populate detail block from view in Forms 4.5

Tracy,

Views do have rowid's, and there is no restriction about having a detail block based on a view.

Something else is causing your invalid column error. Perhaps a control item mistakenly has the Base Table property set to "True".

Hope this helps.

Todd Owers

Tracey Berukoff <"<tlberukoff>"_at_boco.co.gov> wrote in article <340C5E94.1625_at_boco.co.gov>...
> I have two blocks in my app. One is based on a table, one is based on a
> view which joins 3 tables. I created a relation between these two
> tables so the view becomes the detail block. The join condition is
> where table.id = view.id.
> The problem is, when Forms attempts to populate the detail block, the
> SQL it executes is SELECT field a, field b, row_id from view....
>
> I get an invalid column error because, as far as I can tell, views don't
> have row_id's. How can I alter the default SQL that Forms is executing
> to populate my detail block? Any assistance appreciated.
>
> Tracey
>
Received on Tue Sep 02 1997 - 00:00:00 CEST