[RESOLVED] Quickest way to locate a record within a dataset

[CptCarter]

Hi,

I would like to know what the quickest way is to return the record number of a record within a dataset.

i am trying to locate the record by using a column that will be holding unique data but is not the records primary key.

At the moment i am filling the dataset and then using the rows.count method to get the amount of records. Then using a for i = 0 to count-1 loop to check the condition i am looking for. when it meets the criteria the record number will equal the variable i (where i jump out of the for next loop)allowing me to access that record using dataset.tables(0).rows(i)("fieldname") for the fields within the record

Now whilst this works fine i am currently only dealing with quite small amounts of data and was wondering if there was a better/quicker way of doing it.

Thanks alot