Quinn,
VFP has a limit of 255 chars for string literals. Your SQL statement is longer than that. Try splitting the command. Something like this:
lcSql = "SELECT Fields... " + " FROM ..." + " WHERE ..."
=SqlExec(this.liconnect, lcSql)
HTH
>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.
Daniel