Kevin,

Will you please provide me a quick sample application of this with a ready
to go database script I can use to create a database and click a button to
load some data, etc.

Also, take what you are sending me and use it from scratch and make sure it
will work prior to sending it to me. By making sure when I look at this it
is ready to go will help me knock this issue out quickly.

Thanks,
Jason

> -----Original Message-----
> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]On
> Behalf Of Kevin Stanton
> Sent: Tuesday, April 19, 2005 8:20 AM
> To: IBObjects@yahoogroups.com
> Subject: RE: [IBO] Query no longer works after upgrading
>
>
>
> Thanks for the info Helen.
>
> There are on-hand numbers in the query - no problem there.
>
>
>
> I've been bitten by the ambiguous field names in queries even
> in FB 1.03 and
> I think I've got them all cleaned up. I don't see any
> problem in the query
> in question other than maybe omitting the S. for 4 columns at the end.
>
>
>
> I also don't have user names in the database itself.
> Something I've looked
> at briefly, but it seems user maintenance is a pain from an
> application and
> I prefer my users no getting into IBO Console or some similar
> tool to add
> users. Maybe IBO 4.5 has something to help out here? I
> would love to have
> the user ids/permissions a part of the database.
>
>
>
> I guess it comes down to, is the following query valid (now and in the
> future):
>
> (is having a parameter part of the select columns ok?)
>
>
>
> SELECT :USERID, T.COMPANY, T.DIVISION, T.ORDERNO, <etc.>
>
> FROM MY TABLE T
>
> WHERE
>
> T.COMPANY = :COMPANY AND T.DIVISION = :DIVISION
>
>
>
>
>
> Thanks again,
>
> Kevin
>
>