Sorting recordsets

I create an empty recordset:

' Create an empty recordset for the results
set oRSResults = CreateObject("ADODB.Recordset")
' Define it's structure
with oRSResults
With .Fields
.Append "firstName", adVarChar, 150
.Append "lastName", adVarChar, 150
.Append "orderCount", adBigInt
.Append "accountCount", adBigInt
.Append "firstOrderDate", adDate
.Append "latestOrderDate", adDate
.Append "firstUpdateDate", adDate
.Append "latestUpdateDate", adDate
End With
.Open
end with

I populate it with rows.

I then attempt to sort it using:
oRSResults.sort = "len(firstName) desc"

And this errors telling me that the item can not be found in the collection.
However, I can sort it using "firstName desc" and this works fine.

The recordset has state = 1 and recordCount > 0. Interestingly though,
using VB6's LOCALS window, when I expand the FIELDS property it shows a
Count value of 8 (which is expected), but not the properties of any of the 8
fields.

Any ideas?

Thanks, Griff


.

Relevant Pages

  • Re: Sorting recordsets
    ... > ' Create an empty recordset for the results ... > .Append "accountCount", adBigInt ... > .Append "latestOrderDate", adDate ... > I populate it with rows. ...
    (microsoft.public.data.ado)
  • Re: WHERE 1=2 with performance nightmares
    ... this to get an "initialized" empty recordset which we can append ... You can combine the two to guarantee an empty result set without the ... Delphi/InterBase Weblog: http://blogs.teamb.com/craigstuntz ...
    (borland.public.delphi.non-technical)