Re: 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.
>>
>>
>
> Why did you remove the 'as' keyword?
>
> christos
The 'as' keyword doesn't work with my older servers; and leaving out the 'as' keyword works with current servers.
John
>
>> *** 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