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

Hi,

[Quoted] [Quoted] My problem is *NOT* to change the table on wich block is based. My problem [Quoted] is that column names in my tables are *NOT* the sames. Sample :

TABLE A :
  ID NUMBER(8)
  CODE CHAR(10)
  DESIG VARCHAR2(50) TABLE B :
  ID NUMBER(8)
  REF CHAR(10)
  LABEL VARCHAR2(50) [Quoted] [Quoted] I want to create a block that can be base on both Table A and Table B. How can I ?

[Quoted] [Quoted] Aleksandr Kononov <AKononov_at_pptk.energo.ru> a écrit dans le message : 93f0n9$i58$1_at_nnrp1.deja.com...
> If you have identical tables the easyest way is to use
> Set_Block_Property( 'YourBlock', QUERY_DATA_SOURCE_NAME, 'TableName' );
>
> Regards,
> Aleksandr Kononov
>
> In article <93c6ac$7en$1_at_wanadoo.fr>,
> "Jérôme PERRET" <jperret_at_freesurf.fr> wrote:
> > Hi,
> >
> > I'm using Forms 6i.
> >
> > I want to create a block based on a table whose name is a parameter
 of my
> > form. These tables contains the same columns but they are not same
 named.
> > How can I deal with this ? It seems not to be possible to use
> > SET_ITEM_PROPERTY to change the "column name" of my items. I did not
 found
> > the way to dynamicly create the items ...
> >
> > Does anyone know how to deal with that ?
> >
> > Thanks
> > Jerome
> >
> >
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Tue Jan 09 2001 - 15:02:37 CET