> IBO 4.2lb, native IB_ components.
> Hi, I want to create a procedure that tests all my queries to see if
> I've some mistake in them before my customer will do ;)
> So I loop through all my datamodule and prepare the query. I would
> like also to try all the OrderingItemsNo allowed, but I don't know how
> to loop in them, since OrderingItemsNo can be negative...
> How can I test all the OrderingItemsNo a query allows?

Not really an IBO problem. I presume Delphi? and I use Builder

Just check the number of lines in OrderingItems and then set
OrderingItemsNo from -ve count through to count.

Presume you are simply looking for this failing. I tend to
do this sort of testing in the IDE, by checking that I can
select assending and descending on each of the columns I
expect in OrderingItems. That way I know exactly what is
causing a problem.

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services