Home » Developer & Programmer » Forms » HOW TO create a temp table or a record group at run time
HOW TO create a temp table or a record group at run time [message #225052] Fri, 16 March 2007 15:08 Go to next message
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!
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 Go to previous messageGo to next message
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
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 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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:
  


Current Time: Thu Dec 08 12:23:23 CST 2016

Total time taken to generate the page: 0.09142 seconds