Nov 15, 2002 #1 gdlh Programmer Jun 20, 2002 2 0 0 US Two of our applications sometimes 'lose' the first record in a SQL table, but there is no DELETE statement used !!! Any ideas as to why we 'lose' a record
Two of our applications sometimes 'lose' the first record in a SQL table, but there is no DELETE statement used !!! Any ideas as to why we 'lose' a record
Nov 15, 2002 #2 teh215 MIS Jul 2, 2002 56 0 0 US Not off of the top of my head. What does the code look like to return the recordset? Rob Upvote 0 Downvote
Nov 15, 2002 Thread starter #3 gdlh Programmer Jun 20, 2002 2 0 0 US Basically SELECT * FROM tablename !!! the record is 'lost' at some undetermined time, and when the SELECT is run again, the first record is lost - sometimes !! Upvote 0 Downvote
Basically SELECT * FROM tablename !!! the record is 'lost' at some undetermined time, and when the SELECT is run again, the first record is lost - sometimes !!