try this rs=theDB.SQLSelect(SELECT rowid as rowid,* from paths where pathname.....
jules Le 22 févr. 07 à 07:51, [EMAIL PROTECTED] a écrit : > Message: 19 > Date: Wed, 21 Feb 2007 19:55:07 -0700 > From: Tim Jones <[EMAIL PROTECTED]> > Subject: What could cause a Recordset to return Nil? > To: REALbasic NUG <[email protected]> > Message-ID: <[EMAIL PROTECTED]> > Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed > > 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] > > > C'est par le bien-faire que se crée le bien-être proverbe chinois _______________________________________________ Unsubscribe or switch delivery mode: <http://www.realsoftware.com/support/listmanager/> Search the archives: <http://support.realsoftware.com/listarchives/lists.html>
