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

Thank you for your help.
That is what i thought : we cannot change dynamicly the name of queried columns in a block. That's so bad ;(
I'll see if a stored procedure can do my job

Aleksandr Kononov <AKononov_at_pptk.energo.ru> a écrit dans le message : 93k84k$s61$1_at_nnrp1.deja.com...
> 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 - 15:16:12 CET