AnsweredAssumed Answered

Find Dialog Shows negative values, and never finishes...

Question asked by twelvetens on Jan 7, 2016
Latest reply on Jan 8, 2016 by twelvetens

I'm querying a MySQL database over ODBC, using the ExecuteSQL function.

 

The query itself seems fine, and the table I'm querying is not massive (maybe 500 records or so) and the data shouldn't be particularly volatile, i.e it won't be changing much as I'm querying it.

 

When I try the query out in the Data Viewer, I never get a result, instead it just seems to loop through lots of find requests,  and never finishes. It also shows some weird dialogs where it states that it's finding "-1" records....

 

Screen Shot 2016-01-07 at 15.52.08.png

What's up here? Am I dong this wrong? I'm structuring the ExecuteSQL query the same way I always do?...

Outcomes