FreeTDS Development Group

[christos AT zoulas.com (Christos Zoulas)]

On Apr 14, 12:01am, john AT capps.com (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
| FreeTDS AT lists.ibiblio.org
| http://lists.ibiblio.org/mailman/listinfo/freetds
-- End of excerpt from John Kendall