| Data block [message #453164] |
Tue, 27 April 2010 08:45  |
cestsourire
Messages: 7
Registered: April 2010
|
Junior Member |
|
|
Hi,
My problem consists in setting dynamically a data block related to the item chosen by the user.
So I ask if it is possible, in forms 10g, to base dynamically a data block with different tables having different columns.
If it is not possible, have you please other alternative to solve this problem.
Thank you.
Best regard.
|
|
|
|
| Re: Data block [message #453165 is a reply to message #453164] |
Tue, 27 April 2010 08:56  |
cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
|
Not directly no. Best bet is to base the block on a procedure, but I'd question any requirement that means the form is querying completely different tables based on a value. Wouldn't it be easier to use multiple forms?
|
|
|
|
| Re: Data block [message #453183 is a reply to message #453164] |
Tue, 27 April 2010 13:01 |
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
|
Senior Member |
|
|
|
Why not have all the blocks in the form, each with their own canvas and then jump to the corresponding canvas based on the "item" chosen by the user, but I do admit, the question is very vague.
|
|
|
|
|
|
| Re: Data block [message #453199 is a reply to message #453195] |
Tue, 27 April 2010 17:16 |
cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
Littlefoot wrote on Tue, 27 April 2010 20:59Perhaps you could investigate use of SET_BLOCK_PROPERTY built-in and its DML_DATA_TARGET_NAME and QUERY_DATA_SOURCE_NAME properties.
Since the column lists differ I doubt that's going to work.
|
|
|
|
| Re: Data block [message #453239 is a reply to message #453199] |
Wed, 28 April 2010 00:40 |
 |
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
|
Absolutely. Yesterday evening I missed "different tables + different columns". Sorry.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
