Hi, Erwin

Can you explain your problem more clear? I'd like to know type of database, command text and error message.

>Hi evrybodey,
>
>we build some components that use ADO Command objects.
>h etables we probe are getting bigger and bigger, thats why we want to be able to get a selection from the tables and not the whole table.
>
>Curently the ADO Command looks like;
>
>'select * from tablename'
>
>We have tried to insert the 'where' clause, but that did not work.