Open Query - Syntax Error

Posted by Ashley Davis on 09-May-2017 12:08

Hi There,

I'm new to this, I'm not even sure I'm in the right place or not. 

I am trying to create a query and am receiving a Syntax Error that I don't understand, can anyone help?

Syntax Error in Query: FOR last rm-credh NO-LOCK WHERE 
OPEN QUERY requires EACH after FOR, and EACH or FIRST or LAST in subsequent record phrases. (3222)

Thank you,

Ashley

Posted by Brian K. Maher on 09-May-2017 12:38

Hi Ashley,
 
Change FOR to FOR EACH.
 
Brian

All Replies

Posted by Brian K. Maher on 09-May-2017 12:38

Hi Ashley,
 
Change FOR to FOR EACH.
 
Brian

This thread is closed