Home » Developer & Programmer » Forms » Problem in multi record block..........!
Problem in multi record block..........! [message #262628] Mon, 27 August 2007 23:05 Go to next message
Messages: 32
Registered: July 2007
Location: chennai
hi all,
I am working in oracle form 6i,I am creating forms which has the dml operation to perform different action in my form. I have 2 blocks(database item),one block is single record and another is multi-recorded block(contains 6 columns).If i enter value in last column and press tab means,cursor will move to next record and sl.no will automatically generated by the form,like that this will routine inside the block.

My problem is,If simply i click on the block(row) means, sl.no is generating and i pressed save button means,null records is saving in database with sl.no. To over-come this i wrote when-validate-record trigger (block level) and just i took one column and i gave condition like..if that field is null then raise error. If i gave this condition means, i can't re-edit my previous record also if i press cancel or any button means,simply error message is displaying.

please give ur suggestions to over-come this problem.

Re: Problem in multi record block..........! [message #262638 is a reply to message #262628] Mon, 27 August 2007 23:54 Go to previous messageGo to next message
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Press the 'delete' button to delete the 'empty' record and take you back to the previous record.

icon14.gif  Re: Problem in multi record block..........! [message #262645 is a reply to message #262628] Tue, 28 August 2007 00:11 Go to previous message
Messages: 551
Registered: August 2005
Senior Member
Dear its very simple. Dont generate serial number in the base table field instead put a nonbase table field on the form hide the actual field. Generate your temperory serial numbers in that non base table field just to show it to the user.

Place a PRE-INSERT trigger at block level and in that trigger generate your actually serial no.

I m sure your problem will be solved.

Azam Khan
Previous Topic: Forms2NET - ATX Software
Next Topic: creating record group with query problem
Goto Forum:

Current Time: Mon Feb 27 17:08:04 CST 2017

Total time taken to generate the page: 0.22662 seconds