Geoff Worboys wrote:

> Hi Paul,
>

[snip]

>
> 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.
>

This is a piece of extremely valuable information. I remember it took me
lots of pain to realize what messed my parameter input fields up. I
could not imagine that IBO would re-use the field definitions for the
parameter controls. IMO it should go directly into the FAQ!!

Regards,

/Dany