Sorry that was just a typo it should naturally be :

SELECT * FROM RV_20021002_2MVSMB WHERE Filmkopiid = ?

--- In IBObjects@y..., Helen Borrie <helebor@t...> wrote:
> At 02:09 PM 02-10-02 +0000, you wrote:
> >Hi,
> >
> >I am trying to use ClientDataset's with TIBOQuery and is changing
> >then CDS.CommandText and opening the CDS. My original SQL looks
like
> >this :
> >
> >SELECT * RV_20021002_2MVSMB WHERE Filmkopiid = ?
>
> where is your FROM clause?
>
> select <columnlist | *>
> FROM <tablename>
> where...
>
> Helen