Re: defncopy for old servers
[email protected] (Christos Zoulas)
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Organization | Astron Software |
| Message-ID | <[email protected]> |
On Apr 14, 12:01am, [email protected] (John Kendall) wrote: -- Subject: [freetds] defncopy for old servers | | The defncopy app has one bit of SQL in it that uses an ANSI join. This makes it fail on pre-ASE 12.0. To get it to work with my old servers i need to patch it each time I download the latest FreeTDS. | | Since the SQL89 inner joins are still considered fine, I was wondering if this patch could be applied. Then it will work for all servers out-of-the-box. | Why did you remove the 'as' keyword? christos | | *** defncopy.c-orig Mon Feb 29 12:00:00 2016 | --- defncopy.c Wed Apr 13 16:14:57 2016 | *************** | *** 211,220 **** | static const char query[] = " select cast(c.text as text)" | #endif /* MicrosoftsDbLib */ | ", number " | ! " from syscomments as c" | ! " join sysobjects as o" | ! " on o.id = c.id" | ! " where o.name = '%s'" | " and o.uid = user_id('%s')" | " and o.type not in ('U', 'S')" /* no user or system tables */ | " order by c.number, c.colid" | --- 211,220 ---- | static const char query[] = " select cast(c.text as text)" | #endif /* MicrosoftsDbLib */ | ", number " | ! " from syscomments c," | ! " sysobjects o" | ! " where o.id = c.id" | ! " and o.name = '%s'" | " and o.uid = user_id('%s')" | " and o.type not in ('U', 'S')" /* no user or system tables */ | " order by c.number, c.colid" | | | | | | Thanks for considering this. | | John | | | _______________________________________________ | FreeTDS mailing list | [email protected] | http://lists.ibiblio.org/mailman/listinfo/freetds -- End of excerpt from John Kendall