How about:

TOTAL_FALTANTE <> 0

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Jose Gomez" <desarrollo@...>
Newsgroups: egroups.ibobjects
To: <IBObjects@yahoogroups.com>
Sent: Monday, November 26, 2001 11:02 AM
Subject: Re: [IBO] Column unknown


> I have narrowed the problem... it's the filter in the IBOQuery, when
> Filtered=True I get this error... the filter expression is (TOTAL_FALTANTE
> <> 0)
>
> I have tryed:
> 'TOTAL_FALTANTE' <> 0
> [TOTAL_FALTANTE] <> 0 (as delphi's help says)
> "TOTAL_FALTANTE" <> 0
> "TOTAL_FALTANTE <> 0"
> etc. etc. with no luck.
>
> ""Jose Gomez"" <desarrollo@...> wrote in message
> news:9tsq70$kav$1@......
> > Hi, I'm having a wierd problem.
> >
> > I have an IBOQuery that when I open it I get the "Column unknown
> > TOTAL_FALTANTE" error, if I prepare the query first I do get the error,
> but
> > then I can open it with no problems.
> >
> > A partial fix is that I trapped this error with:
> > try
> > Query.prepare;
> > except
> > end;
> > Query.ParamByName(...)
> > Query.Open;
> >
> > Here's the SQL:
> > SELECT Pedidos.Pedido , Pedidos.Cliente , PedidosD.Producto,
> >
> > sum( PedidosD.Cantidad ) as Total_Solicitado ,
> > um( PedidosD.Cantidad_Surtida ) as Total_Surtido ,
> >
> > sum( ( PedidosD.Cantidad - PedidosD.Cantidad_Surtida ) ) as
Total_Faltante
> >
> > FROM Pedidos INNER JOIN PedidosD ON ( Pedidos.Pedido = PedidosD.Pedido )
> >
> > WHERE (( Pedidos.Cancelada ='F' ) AND ( Pedidos.Cliente LIKE :Cliente )
> AND
> > ( PedidosD.Producto LIKE :Producto ) AND
> >
> > (( Pedidos.Fecha_Requerida_Entrega BETWEEN :FIni AND :FFin ) OR
> > Pedidos.Fecha_Requerida_Entrega IS NULL )))
> >
> > GROUP BY Pedidos.Pedido, Pedidos.Cliente , PedidosD.Producto;