Toad World® Forums

Error Message - Input string was not in a correct format

Recently upgraded to Toad Data Point 5.1.0.142. Had lots of queries built with Query Builder and saved and listed in project manager. Now when I open them i get this error.

Input string was not in a correct format. Couldn't store in ColumnOrder. Expected type is Int32. Opening query in editor. Please connect to a database and send the query to Query Builder to be visualized.

When i do this and resave it works. We have many queries and we don't want to have to do this on each one.

Any ideas?

Thanks

Looks like the latest release of TDP 5.2 has fixed this....see this KB article and a link to download the latest version:
https://support.quest.com/toad-data-point/kb/323576/get-input-string-was-not-in-a-correct-format-couldn-t-store-in-columnorder-column-opening-saved-query