Input string not in correct format error

[dkienenberger]

Quest: re-reading all of the above, I don't know if anyone made this clear to quest support. This error doesn't happen when you run a query. It happens when you load an existing toad query from a file. If you were to re-build the query from scratch it would run fine. I documented my experience in this post:

Load Errors: Query Builder to be visualized

We have a strange toad file load issue happening. Toad version noted in: 3.1 and 4.3 Database Backend: Oracle We can make a database connection without any issue. We can build new queries and run them without any issues. But starting yesterday afternoon, if we load a query or build a new query, save then re-load it; we see the following errors (types) on loading a saved : Input string was not in a correct format. Couldn't store (table name) in ColumnOrder Column. Expected type is Int32. O…