Check theDB.Error and theDB.ErrorMessage. My guess: you have illegal
characters in the path. Probably single quotes within the path that throw
SQL off. Do something like that: rs = theDB.SQLSelect("SELECT * from paths
where pathname = '" + thePath.ReplaceAll("'", "''") + "'"
Math
On 2/21/07, Tim Jones <[EMAIL PROTECTED]> wrote:
>
> 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?
>
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives:
<http://support.realsoftware.com/listarchives/lists.html>
