Acumatica odbc

[steff22]

I established a connection with acumatica using the C-data odbc. Anytime I try pulling out records from the Childs table in acumatica, a SQLExecute error appears which forces me to use where clause. Since I want all records out of the table, using a where clause would limit my records?

What is the best way to go about this error? Is anyone familiar with such error 

[Qiu]

@steff22 

From the error message, it seems that you have where clause.

Did you test your SQL query outside of Alteryx?

[steff22]

Yes, i tested the SQL query and there was no error.

I also did not include any where clause in the query.