This post is confusing and void of information we need to help you.

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

-- We may not have it all together --
-- But together we have it all --

----- Original Message -----
From: "Virtual Memory" <virtual@...>
To: "IBO" <IBObjects@yahoogroups.com>
Sent: Tuesday, December 03, 2002 11:53 AM
Subject: [IBO] selects stayed


> After converting my BDE's application for IBO some selects stayed much
slowwer.
>
> Am I sending select and the properties specified in the component
TIBOQuery to see where am being mistaken?
>
>
> SELECT DISTINCT
>
> P.L010_CODIGO_BASE,
>
> P.L010_CODIGO,
>
> P.L010_CODIGO_SIMILARIDADE,
>
> P.L010_DESCRICAO,
>
> SUM(L.L250_QTD_ATUAL - L.L250_QTD_RESERVA) AS L010_DISPONIVEL
>
> FROM
>
> L010 P
>
> LEFT JOIN L250 L
>
> ON (P.L010_CODIGO = L.L250_L010_CODIGO)
>
> WHERE
>
> (P.L010_CODIGO_BASE LIKE :PRD1 OR
>
> P.L010_CODIGO LIKE :PRD2 OR
>
> P.L010_DESCRICAO LIKE :PRD3) AND
>
> (((L.L250_L305_CODIGO = 'A' ) OR
>
> (L.L250_L305_CODIGO = 'P' AND L.L250_DATA_ENTRADA <= :SEG_VEN AND
>
> L.L250_DATA_ENTRADA > :PRDL) OR
>
> (L.L250_L305_CODIGO IS NULL)) AND (L.L250_QTD_ATUAL >= 0 OR
L.L250_QTD_ATUAL IS NULL)) AND
>
> (L.L250_QTD_RESERVA >= 0 OR L.L250_QTD_RESERVA IS NULL)
>
> GROUP BY
>
> P.L010_CODIGO_BASE,
>
> P.L010_CODIGO,
>
> P.L010_CODIGO_SIMILARIDADE,
>
> P.L010_DESCRICAO
>
>
> Flavio Macedo :.