OraFAQ Forum: Forms » Deleting Record and Update Sequence

Home » Developer & Programmer » Forms » Deleting Record and Update Sequence

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

Deleting Record and Update Sequence [message #401878]

Wed, 06 May 2009 15:12

jolly_makkar
Messages: 63
Registered: March 2008

Member

Hi,

I got one block ,which got two column ..like S.No and Name..
Suppose i got 5 names there ,all with S.No ..I want to delete third record .
3rd wil b deleted now i have names with serial numer

Quote:

1 name1
2 name2
4 name4
5 name5

but how can i make after deleting 3rd record O/P shud b

Quote:

1 name1
2 name2
3 name4
4 name5

Thanks

Report message to a moderator

Re: Deleting Record and Update Sequence [message #401916 is a reply to message #401878]

Thu, 07 May 2009 00:14

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

In a LOOP?

However, is it necessary to do that? What do you use the "S.No" column for? If it is just to make your form "look pretty", then I suppose you don't have to store it into the database but populate during query execution using an appropriate :SYSTEM variable.

Because, if you DO store it in the database, is it referenced by another columns (i.e. it may be a primary key used in referential integrity constraint(s)). In that case, it is out of question to modify its value.

So ... do you really want to do that?

Report message to a moderator

Re: Deleting Record and Update Sequence [message #401988 is a reply to message #401916]

Thu, 07 May 2009 03:54

jolly_makkar
Messages: 63
Registered: March 2008

Member

Hi ,

Actually i was doing Seating system,in that i wanted to delete seat.Its Solved now ,i made cursor "for update" ..on post delete its working fine.

Thanks

Report message to a moderator

Previous Topic:	calling a report through forms
Next Topic:	FRM-10142 HTTP listener is not running....

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 15:31:30 CDT 2024