srbenavrbe
asked on
sort records of table
How do you sort the table after open (asc/desc) and how do you
filter records?
Example :I want to display customerID of only those customers
who are 'sane'. Those 'not sane' we leave out....he,
Can filter be done in object inspector (on the dataset)??
filter records?
Example :I want to display customerID of only those customers
who are 'sane'. Those 'not sane' we leave out....he,
Can filter be done in object inspector (on the dataset)??
one more thing, replace the field customerID of the filter with the appropriate field.
for sorting you need an index on the field in the needed order
(means one for asc and one for desc) and set the indexname-property
easier would be a query with an order by clause as dataset
meikl ;-)
(means one for asc and one for desc) and set the indexname-property
easier would be a query with an order by clause as dataset
meikl ;-)
ASKER
how do you sort records on afteropen of the table ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
and set the Filtered property to True.