Ado Recordset

Results 1 to 3 of 3

Thread: Ado Recordset

  1. #1
    Join Date
    Dec 1969

    Default Ado Recordset

    I never usually have to deal with anything like this as usually i use arrays, but can someone tell me how, when i have a recordse, i can move to a particular record?<BR><BR>I&#039;m using a client-side cursor (I&#039;m actually doing this in VB), and i want to find the record whose primary key (colId) is, for example, "12345".<BR><BR>is there anyway to do this without starting at BOF and moving through the recordset testing for the condition??<BR><BR>cheers<BR><BR>cp

  2. #2
    Join Date
    Dec 1969

    Default So just select that record then

    select *<BR>from table<BR>where colID = 12345

  3. #3
    Join Date
    Dec 1969

    Default That was my first thought too

    If you have to find it in a recordset(with multiple records), I think you&#039;re stuck moving through the recordset and testing each value until it matches yours. <BR><BR>Pretty much the same way you would with an array too.

Posting Permissions

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