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 |
|
bidyut
Starting Member
2 Posts |
 Posted - 2005-08-23 : 22:37:24
|
| I am facing a problem of invisible data. I have developed a ASP based application in my local laguage and data is entered from 8 clients. Now I have found that in a particular table in the SQL Server very few data is not visible if I see from the SQL query analyzer. But if I go the application and try to enter the data again it gives a message that the data already exist and next time if i see it from query analyzer the data is displayed. Please help.Bidyut Rn. Gohain |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2005-08-24 : 06:50:46
|
| Post the ddl and sample query used to read from the table....and identify the columns with the 'invisible data'....(it's a new one for us!!!) |
 |
|
|
bidyut
Starting Member
2 Posts |
Posted - 2005-08-25 : 00:47:50
|
| As Andrew Murphy asked I am using IIS 5 and SQL Server 7 for my application. The simple query used to fetch the data from the table c_basic is select * from c_basic where vlcode='18010101001'. I have notice that the complete row is not displayed not few columns.BidyutBidyut Rn. Gohain |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2005-08-25 : 04:15:10
|
| 1. you missed this bit..."Post the ddl"2. what happens when you execute "select * from c_basic where vlcode like '18010%'?3. Do you get an "0/1/more rows selected" message in QA?4. Is there a possibility you have 2 c_basic tables?? one called dbo.c_basic + one c_basic??? |
|
|
|
|
|
|
Invisible Data