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

[Quoted] Sorry, I didn't uderstand your problem clear from the first post.

You must create a block based on a stored procedure (not a table). An additional procedures are needed to insert, update, delete and lock too.

By this way you can switch your block between tables in question.

Hope this is what you want.

Regards,
Aleksandr Kononov

In article <93f5n3$3j9$1_at_wanadoo.fr>,   "Jérôme PERRET" <jperret_at_freesurf.fr> wrote:
> Hi,
>
> My problem is *NOT* to change the table on wich block is based. My
 problem
> 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)
>
> I want to create a block that can be base on both Table A and Table
 B. How
> can I ?
>
> 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/
>
>

Sent via Deja.com
http://www.deja.com/ Received on Thu Jan 11 2001 - 13:15:20 CET