Re: Forms : changing "column name" for data block items

....
> >
> > It´s IMPOSSIBLE to make a block based in 2 tables. Your options
are :

> Well... not impossible, but not something you would normally do in a
> day's work.

I said impossible using a common database-block (in default forms funcionality). If you take to youself the task of query, then the possibilities are almost endless : you can construct a dinamic recordgroup,  you can use DBMS_SQL (or NDS if in Oracle 8i), but it can be cumbersome at least (you will need to worry about record-fetching, block-feeding, queries, etc).

> .. but Forms 6 permits
> you to create a block based on a stored procedure, too.

Yeah, having a stored-proc based-block can be a good solution : you will need to write in some extent, BUT you can use all the default forms capabilities (mainly qbe, record-locking, record-paging in the blocks, etc).

[]s

       Chiappa

Sent via Deja.com
http://www.deja.com/ Received on Thu Jan 11 2001 - 12:26:25 CET