Multiple Recordsets?

Results 1 to 3 of 3

Thread: Multiple Recordsets?

  1. #1
    Svacas Guest

    Default Multiple Recordsets?

    Hello everyone. This should be a relatively simple question... I&#039ve got an input form that has several (3) dynamic drop-down lists that are populated by queries on tables in my Oracle database. My question is this: Is it better dim a RecordSet for each drop-down list individually, or should I just dim one and close and reuse the same one over and over for each list? I&#039ve currently got 3 seperate RecordSets opening each one separately.<BR><BR>Any comments would be appreciated.

  2. #2
    Join Date
    Dec 1969

    Default RE: Multiple Recordsets?

    the best way would be to open three recordsets at one hit, use GetRows() on each, then close them, along with the connection, then write the dropdowns afterwards<BR><BR> has a tutorial on getRows<BR><BR>j

  3. #3
    Svacas Guest

    Default RE: Multiple Recordsets?

    Thanks for the prompt response. I&#039ll look into it. :)<BR>

Posting Permissions

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