| how to integrate excel with forms [message #445572] |
Tue, 02 March 2010 11:05  |
nastyjillu
Messages: 211
Registered: February 2009
|
Senior Member |
|
|
Hi,
how to integrate exel with oracle forms ? so that it looks like a detail block.
and how to change the number of records displayed in a detail block at run time?
if i give 20 in text item and if i click on a button then the detail block should display 20 records.
in set_block_property there is no property for records_displayed. but in get_block_property we have it.
thanks
jillu
|
|
|
|
| Re: how to integrate excel with forms [message #445573 is a reply to message #445572] |
Tue, 02 March 2010 11:17  |
cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
You can't set records_displayed programatically. Form Builder help does tell you that.
The fact that you can reference it it get_block_property proves nothing. If you compare the property list for get and set (at both block and item level) you'll find that there are several properties that you can get but not set.
As for the excell question - no idea, hopefully someone else will know.
|
|
|
|
|
|
|
|
|
|
|
|
| Re: how to integrate excel with forms [message #445756 is a reply to message #445721] |
Wed, 03 March 2010 21:54 |
nastyjillu
Messages: 211
Registered: February 2009
|
Senior Member |
|
|
i understtod the concept of external tables, but its almost same as a detail block based on a table.
but i want to show the EXCEL in the FORM as a detail block. see the attached image. the detail block with many rows and columns should be an EXCEL.
-- jillu
CM: deleted attached image at OPs request.
[Updated on: Thu, 04 March 2010 08:30] by Moderator Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
