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, I´m developing a site, ( www.gen-studio.com/avelart2 ), and I´m using a swf to display a set of thumbs that when clicked show an item and its description on the browser, those items might be images or video, everything works fine with the images. [More]
Hi, maybe I'm just missing something, but I find that that the new version is a let down. It's slow as ever and the appstore page is totally cluttered. There's so much talk of the endless number of applications that have been developed for the iphone [More]
I am not sure why or what happened but for the last two days every time I attempt to listen to any music I am limited to only two songs. I have tried multiple things but nothing is working. The only way for me to get more songs to play is to complete [More]
So I just got the iPhone 4 (not 4S) and i upgraded it to iOS5 and i have iTunes 10. Everything was fine, but out of nowhere sometimes when I sync new songs it pushes all of my artists down out of alphabetical order, making half of my "B" artists [More]
upon trying to run new installed FireFox I get a window showing next message Error on switching in renew: NS_ERROR_UNEXPECTED, Component returned failure code: 0x8000ffff (NS_ERROR_UNEXPECTED) [nsIPrefBranch.getCharPref] on my new Laptop running 7 (I [More]
I am building a Web application and packaging it into an EAR file then deploying it into 9.1 WebLogic server. I have an issue that is happening when I activate the changes at deployment time but this one is when it's trying to compile the JSP code, a [More]
I am playing around with flowing text around an irregular object (an image). The text is one text box, situated so it runs on both side of the object. Currently it runs as one column, interrupted as necessary by the blocking object. I would like the [More]
hi..... i want to know all about process for cost of goods sold,cost of manufacture,cost of production. Thanks & Regards Rekha sharmaFor frozen standard cost (both legal frozen standard and profit center standard), maintaining planning costing sheets [More]
I moved the user directory to a second hd. Inside the user settings (right-click on the username) i maintained the new path. OS X confirmed it and shows the standard home icon to the new directory, but every new file or directory will be saved to the [More]
When I play my music that I imported from CDS into iTunes, the audio seems like it plays too fast. I've tried the following: - reinstalling iTunes 8 - installing older versions of iTunes - deleting iTunes plug-ins I've tried everything. When is apple [More]