lbseong
asked on
SQL comparision probelm?
I have to select the database dta to compare with other maskedit box..if the data from the table is use by other user then i cant delete the maskedit data..
eg..
table:
name user
aa test
bb test1
cc test2
dd
ee
if i want to delete aa,i cant delete it cause it is use by test, but if i want to delete dd,ee, i can cause it didnt use by other..
so how to do the caompare and do the delete thing..the sql command..and also the procedure pls..thanks.
eg..
table:
name user
aa test
bb test1
cc test2
dd
ee
if i want to delete aa,i cant delete it cause it is use by test, but if i want to delete dd,ee, i can cause it didnt use by other..
so how to do the caompare and do the delete thing..the sql command..and also the procedure pls..thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
accept jsweby's comment as answer
Please leave any comments here within the next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
Thanks,
geobul
EE Cleanup Volunteer
I will leave a recommendation in the Cleanup topic area that this question is:
accept jsweby's comment as answer
Please leave any comments here within the next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
Thanks,
geobul
EE Cleanup Volunteer
This old question needs to be finalized -- accept an answer, split points, or get a refund. For information on your options, please click here-> http:/help/closing.jsp#1
EXPERTS:
Post your closing recommendations! No comment means you don't care.