Hi Paul,

> I have this query connected to a grid
> select s.rec,s.shipment,s.whs,s.pid,s.qty,s.alloc,w.description
> from (warehouses w left outer join shipment_allocations s
> on s.whs=w.ref and s.shipment=:shipment and s.pid=:pid)

I can sort of see what you are doing here. You want all the
warehouses regardless of shipment allocation, but you want to
filter what shipment allocations get displayed.

Notice that one of the things you have here are fields and
parameters with the same name! This is normally OK, but when
IBO is matching output parameters for editsql etc how does it
know whether you want the pid field or the pid parameter?
(Indeed, which do you want?)

In IBO I suggest that it is good practice to keep your param
names different to your field names, that way you can see more
clearly the results of what IBO is going through its various
SQL automation.

I suggest a selectable stored procedure. One of the tricks
that you can do with a selectable stored procedure is to
return one or more of the input parameters as a field value.
Having returned such a value it becomes useable as a field in
IBO's automatic matching for editsql etc.

--
Geoff Worboys
Telesis Computing