Subject | Re: [IBO] Strange behaviour of IB_SQL |
---|---|
Author | Jason Wharton |
Post date | 2001-08-16T08:36:52Z |
Yes, as a matter of fact, I just figured out a way to get it to handle
multiple columns in some cases. I convert the comma to a double-pipe so that
each column is just concatenated into a single expression. Thus, it is an
equivalent value. I'm adding a junk delimiter value just to be sure they are
distinct. With strings a possible ambiguity could happen across column
boundaries.
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com
multiple columns in some cases. I convert the comma to a double-pipe so that
each column is just concatenated into a single expression. Thus, it is an
equivalent value. I'm adding a junk delimiter value just to be sure they are
distinct. With strings a possible ambiguity could happen across column
boundaries.
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com
----- Original Message -----
From: "Svein Erling Tysvær" <svein.erling.tysvaer@...>
To: <ibobjects@yahoogroups.com>
Sent: Thursday, August 16, 2001 1:46 AM
Subject: Re: [IBO] Strange behaviour of IB_SQL
> >It would also be nice to know where in IB_SQL you were noticing this. Was
it
> >in the Cursor tab or one of the Query Forms?
>
> Sorry for not pointing out that it was in the Cursor tab (I'm not using
any
> query forms and didn't know it could be anywhere else). According to your
> reply to Nando you have solved this by now, so
>
> Thanks,
> Set