Home » Developer & Programmer » Forms » Deleting Record and Update Sequence
Deleting Record and Update Sequence [message #401878] Wed, 06 May 2009 15:12 Go to next message
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
Re: Deleting Record and Update Sequence [message #401916 is a reply to message #401878] Thu, 07 May 2009 00:14 Go to previous messageGo to next message
Littlefoot
Messages: 20891
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?
Re: Deleting Record and Update Sequence [message #401988 is a reply to message #401916] Thu, 07 May 2009 03:54 Go to previous message
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
Previous Topic: calling a report through forms
Next Topic: FRM-10142 HTTP listener is not running....
Goto Forum:
  


Current Time: Sun Dec 04 22:57:13 CST 2016

Total time taken to generate the page: 0.19432 seconds