| Subject | RE: [IBO]Error returned due to slack syntax in 4.7.16 |
|---|---|
| Author | Kevin Stanton |
| Post date | 2007-02-24T06:46:35Z |
Thank God I'm still on 4.2.Gb! :-) Just kidding Jason!
_____
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
Of Jason Wharton
Sent: Friday, February 23, 2007 10:17 PM
To: IBObjects@yahoogroups.com
Subject: RE: [IBO]Error returned due to slack syntax in 4.7.16
Helen,
Yes, you precisely understand. Even with Firebird 1.5 and all other
Interbase, etc. relation alias is now the standard when they are used. If I
don't get them from the server I parse them out of the SQL. That's why this
required a lot more work now than I anticipated because I wanted to keep
everything uniform. Having it the defacto way for things to be handled
makes for a little bit (I know, for some a lot) of migration pain but then
this is a dead issue and I won't have to carry the overhead of it being any
other way. It's a judgment call I made with the long-term consistency and
health of the product.
Obviously I didn't make this as clear as I should have because you never
seem to miss a beat. I'm glad we are resolving this.
Regards,
Jason
s.com/docs/IBO_47_Migration.pdf
_____
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
Of Jason Wharton
Sent: Friday, February 23, 2007 10:17 PM
To: IBObjects@yahoogroups.com
Subject: RE: [IBO]Error returned due to slack syntax in 4.7.16
Helen,
Yes, you precisely understand. Even with Firebird 1.5 and all other
Interbase, etc. relation alias is now the standard when they are used. If I
don't get them from the server I parse them out of the SQL. That's why this
required a lot more work now than I anticipated because I wanted to keep
everything uniform. Having it the defacto way for things to be handled
makes for a little bit (I know, for some a lot) of migration pain but then
this is a dead issue and I won't have to carry the overhead of it being any
other way. It's a judgment call I made with the long-term consistency and
health of the product.
Obviously I didn't make this as clear as I should have because you never
seem to miss a beat. I'm glad we are resolving this.
Regards,
Jason
> -----Original Message-----[mailto:IBObjects@yahoogrou <mailto:IBObjects%40yahoogroups.com> ps.com]On
> From: IBObjects@yahoogrou <mailto:IBObjects%40yahoogroups.com> ps.com
> Behalf Of Helen Borrie<http://www.ibobjects.com/docs/IBO_47_Migration.pdf>
> Sent: Friday, February 23, 2007 3:44 PM
> To: IBObjects@yahoogrou <mailto:IBObjects%40yahoogroups.com> ps.com
> Subject: RE: [IBO]Error returned due to slack syntax in 4.7.16
>
>
> At 08:37 AM 24/02/2007, Jason wrote:
> >Helen,
> >
> > > http://www.ibobject
s.com/docs/IBO_47_Migration.pdf
> >[Non-text portions of this message have been removed]
> >Please be sure to include mention of the need to change
> property settings
> >from table names to relation alias names when they are used.
> For example,
> >if a query were:
> >
> > select a.mycol1, a.mycol2
> > from mytable a
> >
> >The Keylinks would have to be changed from:
> >
> > MYTABLE.MYCOL1
> >
> >to:
> >
> > A.MYCOL1
> >
> >
> >If a relation alias is used it must now be used in all the
> property settings
> >of IBO.
>
> OK, I have added that but I'm not certain that it is wholly
> correct. Are you saying that you have made this general, regardless
> of the ODS of the database the app is connecting to? i.e. that IBO
> needs the aliases, even if the SPB does not return the alias?
>
> Helen