How to Use sort property

[Saiful]

How do you use the Sort property of the ADO Recordset? Any example.

I wish to sort on two column fields. Say AParam first then followed by ASequence.

How do my Sort statement looks like assuming my recordset is RS.

RS.Sort ???

rgds,
Saiful

[Erwin]

Try this

strSort = Fieldname1 & Fieldname2 & " ASC"
AdoRS.Recordset.Sort = strSort

Erwin


"Saiful" <md-saifulamri_omar@hp.com> schreef in bericht
news:39ae6763$1@news.devx.com...
>
> How do you use the Sort property of the ADO Recordset? Any example.
>
> I wish to sort on two column fields. Say AParam first then followed by
ASequence.
>
> How do my Sort statement looks like assuming my recordset is RS.
>
> RS.Sort ???
>
> rgds,
> Saiful

[dhruvesh]

read "ADO tutorial" in microsoft MSDN help for VB



"Saiful" <md-saifulamri_omar@hp.com> wrote:
>
>How do you use the Sort property of the ADO Recordset? Any example.
>
>I wish to sort on two column fields. Say AParam first then followed by ASequence.
>
>How do my Sort statement looks like assuming my recordset is RS.
>
>RS.Sort ???
>
>rgds,
>Saiful