RE: ValueList ALWAYS in same order as records in query?

2005-03-07 Thread Andy Ousterhout
Right. But the plan was to use ListFindNoCase(ValueList, value)) to ID the row, then use array notation to retrieve info. Should this be more effieicent then running a query or loop? The code sure looks cleaner, more readible. -Original Message- From: Dave Watts > Will the results from

RE: ValueList ALWAYS in same order as records in query?

2005-03-06 Thread Dave Watts
> Will the results from ValueList(query.Column) always list the > values in the same order as the records in the query? Yes, it will list the column values in the same order. > Can I use the results of a ListFind on the ValueList to index > into the query? Presumably, but why go through all th

RE: ValueList ALWAYS in same order as records in query?

2005-03-06 Thread Adrian Lynch
I'd guess yes. If the resultset is ordered then I reckon it'll be the same list every time. Why not run a test, take your sample query, create the list yourself, compare it to a ValueList() version many many times and flag if it doesn't match. Ade -Original Message- From: Andy Ousterhout