Toad World® Forums

Problem Report: String Format Error when filtering Plans or Packages


#1

When I try to filter Plans or Packages (“SIN10%”) I get the always the following error message:

Toad Beta 6.1.0.51 - String Error.jpeg


#2

Hi Martin,

We were unable to reproduce the issue on our subsystems.

Can you please find DateTime data type formatting you are using?

You can find it under Tools->Options->Environment->Grid under?

Are you using some custom format or a predefined one?

Thanks

Zdenek


#3

BTW, this happens in many other places as well:

  • Aliases

  • Auxilary Tables

  • Distinct Types

  • Procedures

  • MQTables

  • Sequences

  • Triggers

and manybe others.

So this makes the product just unuseful…


#4

Hi Martin,

Thank you for clear description and valuable feedback.

We were able to reproduce the issue and created TDB-2017. The fix of “f” format string and also date time localization will be fixed in next beta drop.

Zdenek


#5

Hi Martin,

For your current beta version, if you still want to use “f” format for date times, there is following workaround you can use:

instead of selecting “f” format from the combobox of predefined formats, please check custom format and into custom format text box type following format string:

dddd, dd MMMM yyyy HH:mm:ss

This will prevent all the exceptions to occur.

Hope it helps

Zdenek


#6

Hi Zdenek

I used:

So I tried different patterns and it seems that this is the only one, that’s not working. Also the “Full date/time with secons pattern (F)”

is working, but the names of the days and months are not displayed in German as they should.

This all wored fine in Version 6.0.

Thanks

Martin

“Zdenek.Sohnel” —09.06.2015 13:41:13—RE: Problem Report: String Format Error when filtering Plans or Packages Reply by Zdenek.Sohnel H

Von: “Zdenek.Sohnel” bounce-ZdenekSohnel@toadworld.com

An: toaddb2beta@toadworld.com,

Datum: 09.06.2015 13:41

Betreff: RE: [Toad for IBM DB2 - Beta Discussion Forum] Problem Report: String Format Error when filtering Plans or Packages


RE: Problem Report: String Format Error when filtering Plans or Packages

Reply by Zdenek.Sohnel
Hi Martin,

We were unable to reproduce the issue on our subsystems.

Can you please find DateTime data type formatting you are using?

You can find it under Tools->Options->Environment->Grid under?

Are you using some custom format or a predefined one?

Thanks

Zdenek

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from Toad for IBM DB2 - Beta notifications altogether.

Toad for IBM DB2 - Beta Discussion Forum

Flag this post as spam/abuse.

Disclaimer: The contents of this email and any attachment thereto are intended exclusively for the attention of the addressee(s). The email and any such attachment(s) may contain information that is confidential and protected on the strength of professional, official or business secrecy laws and regulations or contractual obligations. Should you have received this email by mistake, you may neither make use of nor divulge the contents of the email or of any attachment thereto. In such a case, please inform the email’s sender and delete the message and all attachments without delay from your systems.

You can find our e-mail disclaimer statement in other languages under http://www.baloise.ch/email_disclaimer