About: Query Data Source Columns [message #590602] |
Fri, 19 July 2013 11:09 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/176546.gif) |
tiepmr
Messages: 3 Registered: December 2012 Location: Vietnam
|
Junior Member |
![tiepmr](/forum/theme/orafaq/images/yahoo.png)
|
|
Hello everyone,
I'm new to Oracle Forms 10g.
When I create a data block based on a table using Data Block Wizard, the block's Query Data Source Columns property is automatically populated with column definition entries corresponding to the columns of the base table.
I tried making changes to these entries, for example by changing the data types to wrong data types or even deleting them, and I found that those changes had no effect on the block at all. The form was still working as I wanted.
Please explain what is exactly the role of the block's Query Data Source Columns property.
Thank you very much.
p.s: The F1 key help says "The Query Data Source Columns property is valid only when the Query Data Source Type property is set to Table, Sub-query, or Procedure". So, please explain in each context of Query Data Source Type.
Thank again.
[Updated on: Fri, 19 July 2013 20:36] Report message to a moderator
|
|
|
|
Re: About: Query Data Source Columns [message #590684 is a reply to message #590644] |
Mon, 22 July 2013 01:55 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
I never paid attention to it when data source type is "table". These properties (query data source type/name/columns/arguments) are usedwhen you create a block based on a stored procedure whose (IN) OUT argument is an associative array. Data block wizard creates a block easily if it is based on a table, but - for a procedure - you have to create all items, specify their datatypes and lengths, supply possible procedure arguments - all that manually.
I found two messages (I posted previously) that illustrate that, such as type and procedure creation example and procedure body. (I *think* I posted a complete walkthrough some time ago, but can't find that any more. On the other hand, maybe I didn't post it ... can't tell for sure, sorry. I hope Google will teach you how to do that - base a block on a procedure, I mean).
|
|
|