Delete's Value

Has anyone ever had an issue when they try to commit changes back to the database based on a value they enter in a application...the value that u would use (i.e Select * From Customers Where CustomerID = 'value') to get the rest of the value's pertaining to that value you enter gets deleted from the database....its really wierd but i have that problem
[357 byte] By [Tryin2Bgood] at [2007-12-24]
# 1
You mean that rows have been deleted by selecting them ?

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

JensK.Suessmeyer at 2007-10-8 > top of Msdn Tech,SQL Server,Transact-SQL...
# 2
I mean the one value i enter in my form gets deleted all the information from that row stay's except for the search value that i use...
Tryin2Bgood at 2007-10-8 > top of Msdn Tech,SQL Server,Transact-SQL...
# 3

"My form" is not really descriptive enough. Is this a tool issue? Or a SQL issue with code you have written to support a form?

If it is SQL, can you post some of the table structures? If it is the former, I would probably suggest you use profiler to get a view of the queries being sent and try to match that to what you expect to happen.

LouisDavidson at 2007-10-8 > top of Msdn Tech,SQL Server,Transact-SQL...
# 4
How would i use the SQL profiler to see whats being sent...I have not used it before but ill check the net too...thanks
Tryin2Bgood at 2007-10-8 > top of Msdn Tech,SQL Server,Transact-SQL...

SQL Server

Site Classified