OraFAQ Forum: Forms » know which tables in which form

Home » Developer & Programmer » Forms » know which tables in which form

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

know which tables in which form [message #141803]

Wed, 12 October 2005 04:24

emadbsb
Messages: 334
Registered: May 2005
Location: egypt

Senior Member

hii
thx all for yr past answers
i want to know the table for example "aaa"
used in which forms in my database

is there a way to know this
thx

[Updated on: Wed, 12 October 2005 04:42]

Report message to a moderator

Re: know which tables in which form [message #141951 is a reply to message #141803]

Wed, 12 October 2005 20:06

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

What version of Forms and Database are you running?

David

Report message to a moderator

Re: know which tables in which form [message #141998 is a reply to message #141951]

Thu, 13 October 2005 02:12

emadbsb
Messages: 334
Registered: May 2005
Location: egypt

Senior Member

i user oracle 8.1.7
forms 6i

Report message to a moderator

Re: know which tables in which form [message #142002 is a reply to message #141998]

Thu, 13 October 2005 02:22

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Have a look at FormsTool at http://www.orcl-toolbox.com/download.asp. It has facilities to extract SQL from forms. Your problem is that blocks can be based on procedures and you have to look at the procedures to see which tables are used.

I was going to suggest converting your FMB files to FMT files and searching them for 'block' markers and getting the table name that way. This works for 4.5 but 6i may be dfouble byte character set and therefore not in ASCI (English) output. If 9i then you could convert to XML and 'read' the 'block' tag.

Alternatively, have a look at FormGreg at http://www.aug10.com/. This also can extract block and SQL information.

David

Report message to a moderator