Toad World® Forums

Using calender function with locale storage does not work

Hello everybody,

I try to store the result set of a query into the local storage. Running the query and doing so manually works flawlessly. Using a script and specify the desired date range manually also works fine. BUT whenever I use a built in calender function, the automation scripst starts and runs until is says “Start saving to Local Storage”. This state then stays forever…that is also the last line in the log file.

Please find below the two lines in question.

Does not work: AND V_PROBENINFOS.completed_on = calendar__gregorian__current_week__

Works: AND V_PROBENINFOS.completed_on BETWEEN to_date(‘2013-04-14 00:00:00’, ‘yyyy/mm/dd hh24:mi:ss’) AND to_date(‘2013-04-20 23:59:59’, ‘yyyy/mm/dd hh24:mi:ss’)

The same behavious in TDP 3.2 and in Beta 3.3 build 1327

Anyone any idea?
Thanks in advanve,
JochenR

Unfortunately, using calendar functions when exporting data in Automation to Local Storage or Toad Intelligence Central is not supported so far. I created CR108618 to add such possibility in the next release.

Sorry for the inconvenience,

Igor.

Thank you for your quick answer and subitting a CR Igor. It’s good to hear that you are continiously improving your product.
JochenR

So how do I respond to this? How do I put an attachment on here

Just simply reply. Attachments and embedded images are supported as well.

– Daniel

From: Debbie Peabody [mailto:bounce-Debbie_Peabody@beta.toadworld.com]

Sent: Thursday, May 09, 2013 3:23 PM

To: toaddatapoint@beta.toadworld.com

Subject: RE: [Toad Data Point - Discussion Forum] Using calender function with locale storage does not work

So how do I respond to this? How do I put an attachment on here

Who are you people?

On Thu, May 9, 2013 at 8:42 PM, Daniel Norwood bounce-Daniel_Norwood@beta.toadworld.com wrote:

Just simply reply. Attachments and embedded images are supported as well.

– Daniel

Click to show quoted text

From: Debbie Peabody [mailto:bounce-Debbie_Peabody@beta.toadworld.com]

Sent: Thursday, May 09, 2013 3:23 PM

To: toaddatapoint@beta.toadworld.com

Subject: RE: [Toad Data Point - Discussion Forum] Using calender function with locale storage does not work

So how do I respond to this? How do I put an attachment on here

heh… that’s what I was wondering.

On May 9, 2013 at 8:26 PM Mickers wrote:

Who are you people?

Click to show quoted text

Me too…just started getting these random emails today.


Sent from Mailbox for iPhone

On Thu, May 9, 2013 at 6:39 PM, Texrat bounce-Texrat@beta.toadworld.com wrote:

heh… that’s what I was wondering.

On May 9, 2013 at 8:26 PM Mickers wrote:

Who are you people?

Click to show quoted text

I think Qwest software (now Dell) is having some listserve issues!


From:
jonking_312

Sent:
‎5/‎9/‎2013 7:50 PM

To:
toaddatapoint@beta.toadworld.com

Subject:
Re: [Toad Data Point - Discussion Forum] Using calender function with locale storage does not work

Me too…just started getting these random emails today.

Sent from
Mailbox
for iPhone

Click to show quoted text

On Thu, May 9, 2013 at 6:39 PM, Texrat bounce-Texrat@beta.toadworld.com wrote:

heh… that’s what I was wondering.

On May 9, 2013 at 8:26 PM Mickers wrote:

Who are you people?

Click to show quoted text

Click to show quoted text

On Thu, May 9, 2013 at 8:42 PM, Daniel Norwood bounce-Daniel_Norwood@beta.toadworld.com wrote:

Just simply reply. Attachments and embedded images are supported as well.

– Daniel

Click to show quoted text

From:
Debbie Peabody [mailto:bounce-Debbie_Peabody@beta.toadworld.com]

Sent: Thursday, May 09, 2013 3:23 PM

To:
toaddatapoint@beta.toadworld.com

Subject: RE: [Toad Data Point - Discussion Forum] Using calender function with locale storage does not work

So how do I respond to this? How do I put an attachment on here