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 connected my iphone to itunes today and I deleted all the songs from itunes, didn't realize that it had the voice memos also. Now after I synced, I don't see my voice memos on itunes but they are present on my iphone. I just created a new voice [More]
Hi All, I have an LabVIEW project I have developed in a Windows environment.  I can create an Application (.exe) using the Build Specification -> Application Builder which works fine on the development platform. I now want to distribute the applicati [More]
Ok I just got an Ipod nano for my birthday and I can not install iTunes. This is the error that pops up. Could not set file security for file 'C:\documents and settings\All Users\ Application Data\Apple Computer\itunes\sc info\'. Error: 112. Verify t [More]
Hellow Fellow LabVIEW Lovers, I thought this subject was easy with LV2009, somehow I cannot find the property for the "tab page label font size", yes, i also looked with the "pages" ref array from the tab ref, also no luck. Could someo [More]
I want to use a variable I have created when I call a certain function. It appears that I may be going about it the wrong away. Can someone take a look at this and tell me if it's possible or maybe how to achieve the result I'm trying for? It would b [More]
Hi! Following problem: I have a large jsp File. During execution of this File the server generates a html File which will be displayed, if there are no errors. But if an error occurs it will be displayed which the line number of the generated file. B [More]
I ran Secunia PSI. It said I needed to update my Adobe Flash Player. I downloaded the uninstaller from Adobe first and ran it, and then installed the most recent player. When I go to the test page it says I have the most recent version. However, unde [More]
To all, After -reluctantly- "upgrading" from Acrobat Pro 7 to Pro X I find this new version absolutely maddening. Pro 7's features were easy to find in the tool bar. Now in Pro X everything is "dumbed down" with everything "nested [More]
Oops, that was Lightroom 5Cloud License allows 2 activations http://www.adobe.com/legal/licenses-terms.html -Install on a 2nd computer http://forums.adobe.com/thread/1452292?tstart=0 -Windows or Mac does not matter... 2 on the same operating system, [More]
I've just spent the last week trying to resolve a problem, and now I'm stumped again. My entire Adobe CS3 Creative Suite stopped working last week. Each application would open fine, then crash when I opened a file. All other applications worked fine. [More]