retrieve deleted record
-
You can Create a Trigger into DB with following select query select * from deleted deleted is a logical table which store data temprirory into it. but it is only for while whn next delete or other statements will fire. and also mind it is not select Image,ntext or other data type which store a large amount of data. hope tht will help you......
Deepak Smile a Lots,Its Costs Nothing
my database is ms-access,i tried the query , u provided.it is giving an error message the microsoft jet engine cannot find the input table or query deleted. Make sure it exist or it's name is spelled correctly.
Sonia Gupta Soniagupta1@yahoo.co.in Yahoo messengerId-soniagupta1 Love is Friendship and Friendship is Love....
-
You can Create a Trigger into DB with following select query select * from deleted deleted is a logical table which store data temprirory into it. but it is only for while whn next delete or other statements will fire. and also mind it is not select Image,ntext or other data type which store a large amount of data. hope tht will help you......
Deepak Smile a Lots,Its Costs Nothing
-
You can Create a Trigger into DB with following select query select * from deleted deleted is a logical table which store data temprirory into it. but it is only for while whn next delete or other statements will fire. and also mind it is not select Image,ntext or other data type which store a large amount of data. hope tht will help you......
Deepak Smile a Lots,Its Costs Nothing
Do I need to create Trigger in DB? But what If want to get previous deleted record Actually yesterday I deleted one company record from database and now I need to get back. Thanks Pathan
---------------------------------------------------
-
my database is ms-access,i tried the query , u provided.it is giving an error message the microsoft jet engine cannot find the input table or query deleted. Make sure it exist or it's name is spelled correctly.
Sonia Gupta Soniagupta1@yahoo.co.in Yahoo messengerId-soniagupta1 Love is Friendship and Friendship is Love....
As per as concern about your reply i dont know about the MS-Access.I had to solve it in SQl Server and create a Audit Trail through this particular query.or write # before the deleted....... :)
Deepak Smile a Lots,Its Costs Nothing
-
Do I need to create Trigger in DB? But what If want to get previous deleted record Actually yesterday I deleted one company record from database and now I need to get back. Thanks Pathan
---------------------------------------------------
Just go through the following code for trigger it is only works on For DELETE or After,Insted,Before Create TRIGGER TR_Delete_Package ON Package for DELETE AS Begin if((select Count(*) from deleted) > 0) Begin -- if BEGIN /* --------------- Declaration of variable ------*/ End -- Trigger :)
Deepak Smile a Lots,Its Costs Nothing
-
As per as concern about your reply i dont know about the MS-Access.I had to solve it in SQl Server and create a Audit Trail through this particular query.or write # before the deleted....... :)
Deepak Smile a Lots,Its Costs Nothing
in sql server too it is not poviding the result
Sonia Gupta Soniagupta1@yahoo.co.in Yahoo messengerId-soniagupta1 Love is Friendship and Friendship is Love....
-
Just go through the following code for trigger it is only works on For DELETE or After,Insted,Before Create TRIGGER TR_Delete_Package ON Package for DELETE AS Begin if((select Count(*) from deleted) > 0) Begin -- if BEGIN /* --------------- Declaration of variable ------*/ End -- Trigger :)
Deepak Smile a Lots,Its Costs Nothing
i was checking for triggers in the sql server 2000. i diid not find any options there for the triggers to create a new one.
Sonia Gupta Soniagupta1@yahoo.co.in Yahoo messengerId-soniagupta1 Love is Friendship and Friendship is Love....
-
in sql server too it is not poviding the result
Sonia Gupta Soniagupta1@yahoo.co.in Yahoo messengerId-soniagupta1 Love is Friendship and Friendship is Love....
Just go through the following code for trigger it is only works on For DELETE or After,Insted,Before Create TRIGGER TR_Delete_Package ON Package for DELETE AS Begin if((select Count(*) from deleted) > 0) Begin -- if BEGIN /* --------------- Declaration of variable ------*/ End -- Trigger
Deepak Smile a Lots,Its Costs Nothing
-
You can Create a Trigger into DB with following select query select * from deleted deleted is a logical table which store data temprirory into it. but it is only for while whn next delete or other statements will fire. and also mind it is not select Image,ntext or other data type which store a large amount of data. hope tht will help you......
Deepak Smile a Lots,Its Costs Nothing
dcjoshi2 wrote:
select * from deleted
is "deleted" mean your table name? if u use that query..SQL will recognize deleted as a table, if u dont have a table name deleted in your database it will output an error message:confused::confused::confused:
Kind Regards, Tomi
-
Hi friends I have a bit problem here I want to get back all deleted record of database How do i preform this task? If it is possibel then plz help me out. Thanks Pathan
---------------------------------------------------
Imran Khan Pathan wrote:
I want to get back all deleted record of database
You can't
Imran Khan Pathan wrote:
How do i preform this task?
Currently deleted records you can't revert back, but you can solve this problem for future by adding
IsDeleted(it's a column name, can be changed to any name) column to the table. When user asks for deletion, don't delete from table, just change this IsDeleted column value. When fetching the data you need fetch only rows which are having IsDeleted value 'no'.
-
Imran Khan Pathan wrote:
I want to get back all deleted record of database
You can't
Imran Khan Pathan wrote:
How do i preform this task?
Currently deleted records you can't revert back, but you can solve this problem for future by adding
IsDeleted(it's a column name, can be changed to any name) column to the table. When user asks for deletion, don't delete from table, just change this IsDeleted column value. When fetching the data you need fetch only rows which are having IsDeleted value 'no'.
My dear Navaneeth I have just read many articles and blogs and it is possible. Just wait.............................. Best regard Pathan
---------------------------------------------------