Sitemap

Amicuk Programming Answers

Table autoheightrows breaks with a nowrap column

-0001-11-30   Views:0

Advertisement

ADF JDEV 11.1.1.3.0 I have a table w/ autoheightrows set, e.g.,       <af:table value="#{bindings.PoRequisitionLinesAllVO11.collectionModel}"                 var="row" rows="#{bindings.PoRequisitionLinesAllVO11.rangeSize}"

ADF JDEV 11.1.1.3.0
I have a table w/ autoheightrows set, e.g.,
      <af:table value="#{bindings.PoRequisitionLinesAllVO11.collectionModel}"
                var="row" rows="#{bindings.PoRequisitionLinesAllVO11.rangeSize}"
                emptyText="#{bindings.PoRequisitionLinesAllVO11.viewable ? 'No data to display.' : 'Access Denied.'}"
                fetchSize="#{bindings.PoRequisitionLinesAllVO11.rangeSize}"
                rowBandingInterval="1" id="t5" contentDelivery="immediate" width="100%"
                autoHeightRows="#{bindings.trLineCount.inputValue}"
                columnStretching="column:c41" visible="true">where #{bindings.trLineCount.inputValue} = the # of rows being returned (btw, the issue I'm going to describe also happens w/ a hard coded numeric value).
One of the columns that holds Notes has the attribute noWrap = false
<af:column sortProperty="Notes" sortable="true"
                   headerText="#{bindings.PoRequisitionLinesAllVO11.hints.Notes.label}"
                   id="c41" noWrap="false">
          <af:outputText value="#{row.Notes}" id="ot56"/>
        </af:column>If the data in the column is short enough that it doesn't require wrapping, the autoheights works properly. If the content is long enough where wrapping occurs, the autoheight breaks - the height of the table seems to be about +20% height than the value set.
Ideas?

The replay answer
Advertisement
You could use the COPY feature once your second table is created:
DROP TABLE one
DROP TABLE two
CREATE TABLE one
(n NUMBER
,l LONG)
INSERT INTO one
VALUES
(1
,'123'
CREATE TABLE two
(n NUMBER
,l LONG)
COPY FROM apps/[email protected] TO apps/[email protected] APPEND two USING SELECT * FROM one
SELECT * FROM one
SELECT * FROM two
null

Go to See the other 3 answers

Table autoheightrows breaks with a nowrap column

Category:DefaultRelease time:-0001-11-30Views:130

ADF JDEV 11.1.1.3.0 I have a table w/ autoheightrows set, e.g.,       <af:table value="#{bindings.PoRequisitionLinesAllVO11.collectionModel}"                 var="row" rows="#{bindings.PoRequisitionLinesAllVO11.rangeSize}"[More]

How to handle a repeating table in FrameMaker 8 with varying columns

Category:DefaultRelease time:2015-10-11Views:130

Hello, I have a unstructred FrameMaker 8 table question that I hope someone can answer for me. I have a RTF document that I have brought into FrameMaker 8. The table came into FrameMaker without any major problems. From FrameMaker 8, I now have to ap[More]

In MS Word, it is possible to prevent tables from breaking at page breaks.  So, if a table, when populated with data gets too big for the spae allotted on one page, the table will move in its entirety, to the next page. Can this be done in "Pages"?

Category:DefaultRelease time:2015-10-11Views:130

I am trying to figure out ow to prevent tables from breaking along a row when there is a page break in "Pages".  This is done in MS Word by going under Table properties under "Rows".   I have a document with small three row tables and[More]

How to apply Table level Break in the WEBi Report

Category:DefaultRelease time:-0001-11-30Views:130

Hi, How we can apply the table level break in the WebI Report. I know a bit bt i dont know its right or wrong.. Initally we normally create a table(with the values(which has 2rows(1: for naming  and 2: for associating the object with it at down of it[More]

JTable Problem (table does not show rows and columns)

Category:DefaultRelease time:-0001-11-30Views:130

Hi All, What the table is suppose to do. - Load information from a database - put all the values in the first column - in the second column put combobox (cell editor with numbers 1-12) - the 3rd column put another combobox for something else - the 4t[More]

While defining a columnar table, what is the purpose of column store type

Category:DefaultRelease time:2015-10-11Views:130

Hi folks I have two questions related to columnar table definition. 1. What is the purpose of column store type. While defining a columnar table, what is the purpose of column store type (STRING ,CS_FIXEDSTRING,CS_INT etc) , when I define a table usi[More]

Find duplicate values in a table based on combination of two columns.

Category:DefaultRelease time:2015-10-11Views:130

In table which have millions of records - I have a Table B under Schema A and i have to find the duplicate records in a table. My Table B uses the combination of columns to identify the unique values. Scenario is something like this- One SV_Id can ha[More]

Spatial index creation for table with more than one geometry columns?

Category:DefaultRelease time:2015-10-11Views:130

I have table with more than one geometry columns. I'v added in user_sdo_geom_metadata table record for every column in the table. When I try to create spatial indexes over geometry columns in the table - i get error message: ERROR at line 1: ORA-2985[More]

Download int table into csv file with each column in separate column in csv

Category:DefaultRelease time:2015-10-11Views:130

Hi All, I want to download the data in internal table to CSV file. but each column in the table should come as separate column in csv format.   CALL FUNCTION 'GUI_DOWNLOAD'     EXPORTING       FILENAME                = GD_FILE       FILETYPE         [More]

Check 2 tables(Table A and Table B) and figure out new columns present in Table A and add these new columns to Table B

Category:DefaultRelease time:2015-10-11Views:130

How to check 2 tables(Table A and Table B) and figure out new columns present in Table A and add these new columns to Table b. DDL- Create table A ( A INT, B INT,C VARCHAR(2) Create table B A INT, B INT Any advice on the best approach or method to ac[More]

Which table stores the value of status column in leave request.

Category:DefaultRelease time:-0001-11-30Views:130

Which table stores the value of status column in leave request.If i give pernr ,absence type and date how would i get the status Thanks Bala DuvvuriHi, PTREQ_ACTOR      -              Request Participant PTREQ_ATTABSDATA    -           Request Data f[More]

Hot
HI, We are having a database which for NOT OLTP process. That is OLAP DB. Operation on that DB is only Select and (Incremental Insert - FOR DWH ) not Update/Delete and we are performing ROLAP operations in that DB. By Default SQL Server DB isolation [More]
Hi, I am trying to import default-modeling-workspace-gs.ear and default-process-workspace-gs.ear into Webcenter spaces. It is getting failed with the following error :: No handlers could be found for services with IDs: oracle.webcenter.doclib oracle. [More]
Hello! I tried to connect to a wlan network (Name) and entered a wrong wep key. After i found out how to change the wep key i realised that i had more networks (Name01, Name02). I still can`t connect to my initial network as the wep key is still inco [More]
Evening. I am looking to purchasing a Mac book Pro for my next 4 years at college. I was wondering if I would be able to set-up the Mac Book Pro so it's display could be used as a monitor. Could I hook up say, an Xbox 360, to the Mac and use the disp [More]
Dear legends, I have a doubt that if i work on single DB with single Listener it works fine.. but after that i created another DB using the same listener.. Now what's the prob is in EM i can access both the DB's but while in case of CMD am listening [More]
Hi Do you people have good URLs where they explain how to connect MS Access properly with Java? I need also some help to execute the updates from the database with Java and to get the data from database to use in java, preferably with good examples. [More]
Hi, I have a doubt, I need to buy 4 Switches Cisco 3750-X, but 2 with UTP/RJ-45 Ports, and 2 with STP capability. My question is, for example, Can I stack 2 WS-C3750X-48T-E and 2 WS-C3750X-24S-E??Disclaimer The Author of this posting offers the infor [More]
Have removed all apple components and tried to reinstall itunes Getting error message Service "Aplle mobile Device" failed to start. Verify that you have suffiecnet privileges to start sytem sevices??? I have had no problem with itunes priviousl [More]
hello, I know how to embed a YouTube video into muse. Is there a way I can embed the channel so it can automatically show the most recent video that has been posted. Is this possible to do? Thanks Ben.Hi Ben You can try the steps shown here : http:// [More]
Hi, I am unable to install Visio 2013 trial period on my Windows 7 64 bit laptop. After its downloaded by the download manager and I clicked on Launch, its asking to burn to a disc. the extension of the file is showing as .img. Can anyone assist me t [More]