Home » RDBMS Server » Server Administration » Re: Base Table Vs Non-Base Table Blocks
Re: Base Table Vs Non-Base Table Blocks [message #370296] Thu, 12 August 1999 02:08
Prabhakaran.m
Messages: 1
Registered: August 1999
Junior Member
Thank you for answering the question.

After the designing the screen in forms 4.5( base table property is false), we are using the Explict
cursor and getting the value from the database
and displaying it in the corresponding columns.
Even if it is a master detail block.

The advantage is that we have
more controlled validation .

The disadvantage in the method is retrieval of the record is bit slow compared to base table.

When a module using or getting information from more than three tables, we can go for view
but the view will not be helpful for the DML operations.

Please enlighten in this regard (Forms 4.5 only)
Previous Topic: Re: escape / single char wildcard
Next Topic: Re: Join with Subsquery (in operator)
Goto Forum:
  


Current Time: Thu Mar 28 18:51:04 CDT 2024