OraFAQ Forum: Forms » HOW TO create a temp table or a record group at run time

Home » Developer & Programmer » Forms » HOW TO create a temp table or a record group at run time

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

HOW TO create a temp table or a record group at run time [message #225052]

Fri, 16 March 2007 15:08

qewani
Messages: 51
Registered: December 2005
Location: uaq

Member

i have a a tabular form and i dont want to allow the user entering duplicate
records while he is in insert mode and the inserted records are new and not exsisting in the database.

so i want to know how to create a temp table or a record group at run time to hold the inserted valuse and compare if they are exsiting in previous rows or no.

please help!

Report message to a moderator

Re: HOW TO create a temp table or a record group at run time [message #225216 is a reply to message #225052]

Mon, 19 March 2007 03:28

Madhu_bala
Messages: 16
Registered: January 2007
Location: Chennai, Now at Saudi Ara...

Junior Member

Hai,
To create a record_group at runtime, just go to the property palette and make the property as static for query.
May b it will help u

Report message to a moderator

Re: HOW TO create a temp table or a record group at run time [message #225683 is a reply to message #225052]

Tue, 20 March 2007 23:56

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

Senior Member
Account Moderator

Have a look at http://www.orafaq.com/forum/m/201107/67467/?srch=create+record+group#msg_201107
and
http://www.orafaq.com/forum/m/147107/67467/?srch=validate+master+detail+record+group#msg_147107

David

Upd: Added second link.

[Updated on: Wed, 21 March 2007 00:30]

Report message to a moderator

Previous Topic:	Calling a parameterised report from forms and emailing automatically
Next Topic:	Query in detail block

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 22:19:05 CST 2025