| Author |
can't get delete to work
|
heath carlough
Ranch Hand
Joined: Feb 01, 2003
Posts: 34
|
|
Dunno why everything else is running smoothly(insert/update/select) but when I try to delete a row, it seems to fail but no exceptions are thrown. ANy reason why this could be happening?? any thoughts at all?? I can delete at the sqlplus prompt but not thru jdbc
|
 |
Amol Desai
Ranch Hand
Joined: Jan 29, 2003
Posts: 82
|
|
Hi, The information provided by u is insufficient for anyone to help you.You need to post the code
|
 |
Tina Coleman
Ranch Hand
Joined: Dec 12, 2001
Posts: 150
|
|
|
Does the user account you're using within your program have delete rights?
|
 |
Jamie Robertson
Ranch Hand
Joined: Jul 09, 2001
Posts: 1879
|
|
are you by chance using MSAccess? If you are, there is a known bug while inserting/deleting. Just do a trivial select to the table after you insert/delete a row and it should magically appear ( kind of like a kickstart! ). If you are not using MSAccess, you should post the code snippet giving you the problems. Make sure you are committing the delete as well. Jamie
|
 |
 |
|
|
subject: can't get delete to work
|
|
|