Home » Developer & Programmer » Forms » find base table related to items
find base table related to items [message #617185] Wed, 25 June 2014 16:07 Go to next message
rkhatiwala
Messages: 136
Registered: April 2007
Senior Member
oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production

Hi,

i just got to work on forms 6i, and cannot find to which table is the text_item related to? I can see the column_name, but how to find the table name that this column belongs to. In toad, when i searched, there are 4 tables that has this column. Out of these 4 tables, which table is this column related to? In property palette also no table name, database item is Yes.

Thanks,
Reshma
Re: find base table related to items [message #617207 is a reply to message #617185] Thu, 26 June 2014 02:41 Go to previous messageGo to next message
cookiemonster
Messages: 10846
Registered: September 2008
Location: Rainy Manchester
Senior Member
items map to columns. Datablocks map to tables (or views, or occasionally other things). So what's the data source of the datablock?
Re: find base table related to items [message #617260 is a reply to message #617207] Thu, 26 June 2014 09:34 Go to previous messageGo to next message
rkhatiwala
Messages: 136
Registered: April 2007
Senior Member
Thanks for the reply.
Re: find base table related to items [message #617279 is a reply to message #617260] Thu, 26 June 2014 12:51 Go to previous messageGo to next message
Lalit Kumar B
Messages: 1850
Registered: May 2013
Location: World Wide on the Web
Senior Member
Your reply is no where close to an answer to what CM suggested. If you got your issue reaolved then please post it for the sake of other folks searching this forum for a solution, else, please reply to what has been asked. It will ultimately help you. Isn't it?
Re: find base table related to items [message #617289 is a reply to message #617279] Thu, 26 June 2014 15:48 Go to previous message
Littlefoot
Messages: 19321
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
In my opinion, there's nothing rkhatiwala should add to what Cookiemonster already said. He could repeat CM's words. Why? Because, anyone who knows just a little bit about Forms knows what to do (i.e. check datablock's data source). It is a table whose name is ... well, whatever it is. Doesn't really matter.
Previous Topic: max value in oracle forms detail block
Next Topic: Call_Form issue
Goto Forum:
  


Current Time: Mon Jul 28 16:41:08 CDT 2014

Total time taken to generate the page: 0.14291 seconds