I'm getting a very strange error here. I'm loading data into a series of
arrays using the GetRows method of the recordset. All works for most of
the SQL statements, however one, which is very simple, is causing me
grief. Basically I'm getting the same data, just ordered by different
fields, so I have one SQL statement which uses one field in the order by
clause (which works and returns an array with some 40,000+ records in),
and an almost identical statement, the only difference being it orders
by a different field. The second one fails when I call GetRows(), giving
me the JET database error "Record is deleted". Both report the same
number of records in RecordCount property before the GetRows() call.
Anyone come across this before? I can post code if necessary, although
it's all pretty standard - I haven't initially because it's split across
several functions and is a little fiddly.
Thanks in advance.
Dan
[Non-text portions of this message have been removed]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
