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 |
|
GordonG
Starting Member
7 Posts |
 Posted - 2005-08-18 : 12:46:20
|
| I have an unusual problem. I am using VB.Net 2003 and sqlexpress using .NET dataset to insert records into an timecards table. After inserting several records I tried a 'Select * from timecards' and the inserted records where not selected. if I 'select * from timecards order by employee' ( or any other field) the inserted records are selected! The table was created by an Access Upsize command.I used Express Manager ( XM ) to try the select statements. That is how I isolated the problem. Even using a "Select * from timecards where employee = 'test' " returns the inserted test records. I found that if I use a WHERE or ORDER BY clause in the SELECT statement to .fill the .net dataset, all records are returned. I am familiar with DB2 but I am a newbie at VB.NET and MSSQLAny suggestions?Thanks!GordonG |
|
|
GordonG
Starting Member
7 Posts |
Posted - 2005-08-22 : 17:17:14
|
| This issue has been resolved. Please refer to New to SQL forum where the original thread was.Thanks |
 |
|
|
|
|
|
Select * from table does not return all records