Delete

hi
i have a stored procedure for Delete with following code
Even though i delete thru UI the delete procedure gets called but when i
again open my UI i find the record that is being deleted.
could u please eloborate especially what that ROWSTATUS | 0x890
mean and also probable reasons for not deleting
UPDATE C_SetupDet
set RowStatus = RowStatus | 0x890
WHERE GUID = @.GUID
thanks and regards
MadhaviHi Madhu
The question is not very clear. Are you really trying to delete or are you
updating?
The query that you gave here is updating a value
the Hexa decimal value 0x890 is actually 888 or 100010001000
as per the code here you are using the OR operation on the column value.
You might be better aware of the business logic involved here
Please let me know if you have any concerns
thanks and regards
Chandra
"madhavi" wrote:

> hi
> i have a stored procedure for Delete with following code
> Even though i delete thru UI the delete procedure gets called but when i
> again open my UI i find the record that is being deleted.
> could u please eloborate especially what that ROWSTATUS | 0x890
> mean and also probable reasons for not deleting
> UPDATE C_SetupDet
> set RowStatus = RowStatus | 0x890
> WHERE GUID = @.GUID
> thanks and regards
> Madhavi
>
>|||hi
Actually the Record is not deleted but instead a flag variable is set 1
which indicates that that record is deleted and it should not be visible in
the User Interface(UI)
thanks and regards
Madhavi
"Chandra" <Chandra@.discussions.microsoft.com> wrote in message
news:708E0CD0-6FDF-469C-8F1A-E67036B8D083@.microsoft.com...
> Hi Madhu
> The question is not very clear. Are you really trying to delete or are you
> updating?
> The query that you gave here is updating a value
> the Hexa decimal value 0x890 is actually 888 or 100010001000
> as per the code here you are using the OR operation on the column value.
> You might be better aware of the business logic involved here
> Please let me know if you have any concerns
> thanks and regards
> Chandra
>
> "madhavi" wrote:
>
i