| Problem in multi record block..........! [message #262628] |
Mon, 27 August 2007 23:05  |
james_aron
Messages: 32
Registered: July 2007
Location: chennai
|
Member |
|
|
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.
thanks,
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
