OraFAQ Forum: Forms » Temporary table in forms 4.5

Home » Developer & Programmer » Forms » Temporary table in forms 4.5

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

Temporary table in forms 4.5 [message #175013]

Wed, 31 May 2006 07:16

orate
Messages: 16
Registered: September 2005

Junior Member

Is it possible to create a temporary table in forms 4.5 and then use it in an sql query like
select ...
from A, B, temporary_table T
where ...
?

Report message to a moderator

Re: Temporary table in forms 4.5 [message #175020 is a reply to message #175013]

Wed, 31 May 2006 07:38

Maaher
Messages: 7065
Registered: December 2001

Senior Member

You shouldn't create database objects through Forms. Create a global temp table on the database and use that in your Form.

MHE

Report message to a moderator

Re: Temporary table in forms 4.5 [message #175038 is a reply to message #175013]

Wed, 31 May 2006 08:32

Rehan Mirza
Messages: 67
Registered: July 2004
Location: Pakistan

Member

Hay Maaher you are absolutly wrong use forms_dll package for creating database object

Best regards
R E H A N M I R Z A

Report message to a moderator

Re: Temporary table in forms 4.5 [message #175055 is a reply to message #175038]

Wed, 31 May 2006 09:34

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Rehan Mirza wrote on Wed, 31 May 2006 15:32

Hay Maaher you are absolutly wrong use forms_dll package for creating database object

No, I am not: I am totally against on the fly creation of database objects. I didn't say that it wasn't possible, I said that it was something you should avoid. I NEVER had to create tables from Forms. Never. Oracle isn't made for a 'dynamic' data model. Wink

I think it's bad/sad programming altogether. Humor me and try to convince me of the opposite Very Happy

MHE

Report message to a moderator

Re: Temporary table in forms 4.5 [message #175245 is a reply to message #175055]

Thu, 01 June 2006 07:00

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

Senior Member
Account Moderator

Maarten is right, you don't need that sort of temporary table, use a package table or have a predetermined table into which you store records for a short period of time.

David

Report message to a moderator

Previous Topic:	list item & radio groups
Next Topic:	Diffrent actions in Tab & Enter Key

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 09:43:11 CDT 2024