Delete Query [modified]
-
Hi, In my application i have a database table which my client can access, now if he deletes any particular row from it i have to know the updation but when he is deleting the next row is coming up with out showing any gap in between the row. Im using VB with SQL Server 2000 how to show empty cell space when we delete a particular row from a table in sql server?Please help me -- modified at 6:23 Wednesday 14th November, 2007
-
Hi, In my application i have a database table which my client can access, now if he deletes any particular row from it i have to know the updation but when he is deleting the next row is coming up with out showing any gap in between the row. Im using VB with SQL Server 2000 how to show empty cell space when we delete a particular row from a table in sql server?Please help me -- modified at 6:23 Wednesday 14th November, 2007
Hi Sivaram, As far as i know, you can't have deleted tuple/row showing in any DBMS, not only in MS SQL Server. If you want to achieve this, you can use triggers (after or before, depends on the implementation). And you may also will like to use virtual table named "Deleted". Regards, Adeel
Do rate the reply, if it helps or even if it doesnot, because it helps the members to know, what solved the issue. Thanks.
-
Hi Sivaram, As far as i know, you can't have deleted tuple/row showing in any DBMS, not only in MS SQL Server. If you want to achieve this, you can use triggers (after or before, depends on the implementation). And you may also will like to use virtual table named "Deleted". Regards, Adeel
Do rate the reply, if it helps or even if it doesnot, because it helps the members to know, what solved the issue. Thanks.
Hi Adeel, Thanx 4 ur reply, Actually the client is deleting from front end i.e VB and here i can see it through database table only, im not able to know which one he has deleted as i need to keep track of the data. when he delete any value from front end can i get a blank space on tat particular row without the next row updating the deleted row. pls do help me
-
Hi Adeel, Thanx 4 ur reply, Actually the client is deleting from front end i.e VB and here i can see it through database table only, im not able to know which one he has deleted as i need to keep track of the data. when he delete any value from front end can i get a blank space on tat particular row without the next row updating the deleted row. pls do help me
No. You might want to consider some kind of deletion flag as a field in the row, so you can know that this record had existed, but has now been deleted.
-
Hi, In my application i have a database table which my client can access, now if he deletes any particular row from it i have to know the updation but when he is deleting the next row is coming up with out showing any gap in between the row. Im using VB with SQL Server 2000 how to show empty cell space when we delete a particular row from a table in sql server?Please help me -- modified at 6:23 Wednesday 14th November, 2007
Why not, rather that deleting the row, update the row and set every column to NULL with the exception of the Id column?
Steve Jowett ------------------------- Sometimes a man who deserves to be looked down upon because he is a fool, is only despised only because he is an 'I.T. Consultant'
-
Why not, rather that deleting the row, update the row and set every column to NULL with the exception of the Id column?
Steve Jowett ------------------------- Sometimes a man who deserves to be looked down upon because he is a fool, is only despised only because he is an 'I.T. Consultant'
hi You can create a back up table and write a trigger on the original Table from which u r client is deleting data.In trigger u wite the code to insert the deleting data in to a backup table.You will get the deleted data from the table "Deleted".U can use this to insert into back up table.Dont forget to insert the datetime at which the data is deleted.. Regards Joe