I've a REALSQLDataBase and during a select call, I sometimes get the
RecordSet back as Nil after hundreds of records have returned
successfully.
I was under the impression that the recordset should return a count
of 0 if there were no matches to the select rather than being Nil
(which I assume implies that the SELECT totally failed).
The SQLSelect statement is is a simple:
rs = theDB.SQLSelect("SELECT * from paths where pathname = '" +
thePath + "'"
The thePath variable is a properly processed ShellPath string (as it
works 'most' of the time on the same SELECT). As stated, this
usually succeeds and succeeds on the same data request 3-5 times and
then fails on one.
What should I be looking for that could cause the RecordSet to be Nil?
Thanks,
Tim
--
Tim Jones
[EMAIL PROTECTED]
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives:
<http://support.realsoftware.com/listarchives/lists.html>
