More than 2 columns as PK [message #358406] |
Tue, 11 November 2008 02:41 |
vishal gupta
Messages: 111 Registered: March 2001
|
Senior Member |
|
|
Hi,
I am working on APEX 3.2 and creating a Tabular Form based on a table which has 4 columns as part of the PK.
But , when I am trying to create the Tabular form ,I am able to see only two columns as PK in the Wizard.
Can't we have more than two columns as PK while creating Tabular Form ?
Can anyone suggest any workarounds for this ?
regards
|
|
|
Re: More than 2 columns as PK [message #358481 is a reply to message #358406] |
Tue, 11 November 2008 09:32 |
dr.s.raghunathan
Messages: 540 Registered: February 2008
|
Senior Member |
|
|
hi,
Quote: |
any workarounds for this
|
1. very feable memory. concatenate the column using pipe and try to give it in single column provided all columns are varchar2
2. create two separate regions / pages . pass the parameters to apex page columns (p15_ ... ) better if it is two separate pages.
on the detail page write before header process that will fetch required recrods of previous page selection.
i may be touching my nose on the round about the way there may be some other simple solutions. Till someone suggests, you can play around.
i achieved for three columns
yours
dr.s.raghunathan
|
|
|