Hello All, I am having the following problem to which I found a simple solution, but am interested in understanding why it occurs in the first place. Here is the issue: 1. Pull in a table from a shared server. 2. Select all variables. 3. Filter on a Numeric variable (0,1) 4. Receive this error: ERROR: CLI prepare error: ERROR: Cannot convert 'INT4' to 'BOOL' 5. Solution: First run a query in which I select all variables without filtering. Then run the original query and filter on the numeric variable. No error returned and the new table is properly filtered. Why does this occur? Thanks in advance, James
... View more