Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
scottm
Starting Member
2 Posts |
 Posted - 2009-07-09 : 09:39:48
|
| I created a table in SQL 2005 and pointed a .Net script to it. The script allows me to add and view records but not Edit and Update. The script works fine when I point to other tables. I know it is something in the table I am doing wrong, but not sure. I also can't get an ASP script to work as well when I point to the table. Here is what the table is:ID intAconym Varchar(50)Term Varchar (150)CurrentState (550)FutureState (550) |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2009-07-09 : 11:24:37
|
| What errors are being returned (by your error handler)If you're not catching errors is there anything in your event log? If it works on other tables just not this one then I'm guessing it is a permission issue.Be One with the OptimizerTG |
 |
|
|
scottm
Starting Member
2 Posts |
Posted - 2009-07-09 : 13:27:43
|
| Im not getting any errors. Also I re-created the table and added data. It seemed to work until I copy and paste data. For some reason then it stopped. |
|
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2009-07-09 : 13:47:40
|
| Sounds like your statement is simply not finding any qualifying rows. Trap the statement using Sql Profiler. Then paste the statement into a query window and try execing it there. Either your statement isn't what you expect or your data isn't what you think it is. ie: leading spaces are included or something. That could be typcial of pasted values.Be One with the OptimizerTG |
|
|
|
|
|
|
Having Edit/Delete problems with .net to the DB