I am using sqlexec to access an Oracle database.

= sqlexec(this.liconnect,"select * from wps_mgr.ws_scale_ticket where ;
wps_mgr.ws_scale_ticket.ticket_date between &lcFromDate. and &lcToDate. and ;
wps_mgr.ws_scale_ticket.void_flag <> 'V' and ;
(wps_mgr.ws_scale_ticket.permit_no like 'BC54%-2' or ;
wps_mgr.ws_scale_ticket.permit_no like 'BC66%-2' or ;
wps_mgr.ws_scale_ticket.permit_no like 'BC71%-2')","tictemp")

If I enter the select statement from the oracle command prompt it works fine however from FoxPro it errors out and says command not recongnized. When I try it piece by piece it starts erroring out at the parens. It does not like the nested or. Any suggestions would be appreciated.