defncopy for old servers
John Kendall <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
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.
*** 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