View Single Post

   
  #7 (permalink)  
Old 04-08-2008, 06:17 PM
Hans Kramer
 
Posts: n/a
Default Re: Sybase Query Tree

On Fri, 17 Feb 2006 15:04:45 +0100, Rob Verschoor wrote:

> "Hans Kramer" <noms@xs4all.nl> wrote in message
> newsan.2006.02.17.12.29.15.49500@xs4all.nl...
>> On Fri, 17 Feb 2006 13:04:37 +0100, Rob Verschoor wrote:
>>
>> > I don't think you can implement that sort of check with 100% certainty

> if
>> yep, tough cookie!
>>
>> > you assume the syscomments text could be modified. In any case, the
>> > query tree would not be unique: different stored procs could well have
>> > the same query tree.

>> Okay, if that's the case then it looks my effort is doomed! Unless you
>> mean that a different stored procedure could be defined the same and
>> thus produce the same query tree. I wouldn't care about that. I only
>> care that the stored procedure I will call hasn't been "patched" with
>> for instance an extra delete, insert or whatever statement!
>>
>> I will try to retrieve the "hidden" column from the CT lib calls and
>> experiment a bit... it is Friday anyway!
>>
>>

> Don't bother... you can't. When I said 'hidden' that was more to
> illustrate the concept -- not suggesting you could 'find' it in anyway...


Bummer :-)

Hans.
>
> Rob V.


Reply With Quote