Query Error In Toad Data Point 5.7

I recently upgraded to 5.7 when is was pushed to me from my technology department. 5.7 has a flaw that makes it unusable unless there is a workaround to fix it. When one pulls data and has a reasonable limiter, like 1000 records, it works fine. But if one pulls back the 1000 records and then wants to then see ‘all’ records by changing the limiter to 'all' it throws an ‘invalid character in path’ error and stops the query. This happens in both Query Builder and Editor. There is nothing wrong with the data as the exact same query works in Toad 5.3 and in Teradata Sql Studio.

Hey Jim, sorry that you're experiencing this issue... I just did a quick search in the Quest Knowledge Base for TDP and didn't see any articles addressing this symptom.

Assuming that nothing has changed between executing the query in TDP 5.3 and 5.7 (e.g. connection credentials hasn't changed, database config hasn't changed, etc.) then you'll need to pass this to the Quest Support team:

https://support.quest.com/create-service-request