Results 1 to 1 of 1

Thread: sorting dynaset

  1. #1
    Join Date
    Mar 2004

    Unanswered: sorting dynaset


    i have a recordset opened as dynaset

    i want to find specific records, since a dynaset doesn´t allow the index property, i sort this recordset with :

    pRstGrb.Sort = "gbnr, klnr, stdat"
    Set pRstGrb = pRstGrb.OpenRecordset

    later on in the procedure i have to find another record, and repeat a sorting, like this

    pRstGrb.Sort = "klnr, stdat"
    Set pRstGrb = pRstGrb.OpenRecordset

    during execution, after some time, i get an error "nesting to deep", which is an result of the multiple sorting statements, not by do while, for-next etc.

    what´s wrong ?

    memory probs ?

    Last edited by emiel; 10-20-04 at 10:01.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts