Re: ANN: Hopper (stored procedure debugger), version 1.0.1 released

2012-06-22 Thread Martijn Tonies
Hello Jan, Can you PLEASE note in your listing when a product is Microsloth-only? While you're at it, can you PLEASE note it prominently on your website? I looked through your product description and saw no specific requirements beyond what databases were supported. It wasn't until I tried

Re: Need Query Help

2012-06-22 Thread Shawn Green
On 6/22/2012 12:18 AM, Anupam Karmarkar wrote: Thanks Rick for your reply, Here i am asking about logic to perpare query or whole query itself. A set-based approach to doing the basic task is to convert your set of start/stop times into duration values. The timediff() function mentioned

RE: Triggers and column names

2012-06-22 Thread Rick James
Suggest using a script to read information_schema and construct the TRIGGER. After all, the fields are not going to change from one invocation of the trigger to the next, so don't have the dynamic code inside the trigger. -Original Message- From: Hal?sz S?ndor [mailto:h...@tbbs.net]

Re: Triggers and column names

2012-06-22 Thread Gael Martinez
Rick, That is what I ended up doing, a loop reading the description of the table in shell :) Regards Gael On Fri, Jun 22, 2012 at 6:54 PM, Rick James rja...@yahoo-inc.com wrote: Suggest using a script to read information_schema and construct the TRIGGER. After all, the fields are not going