I keep getting a run-time error on this piece of code to print a report
from an application. Here's the code---->
ReportString = "Due From: " + string(StartD) + " To: " +
String(EndD).
FilterString =
"Not(in-list(OrderDTL.ProdCode,'STK1','STK2','STK3','STK4','STK5','STK6'
,'STK7','STK8','STK9','STKA','2410','STKB',
'STKC','STKD','STKE','STKF','STKG','STKH','STKI','STKJ','STKK','STKL','S
TKM','STKN','SAMP')) AND OrderRel.Reqdate >= " + String(StartD) + " and
OrderRel.Reqdate <= " + String(EndD) + " and OrderRel.OpenRelease =
Yes".
RUN aderb\_printrb(
"v:\vantage\ud\shipping.prl", /* RB-REPORT-LIBRARY
*/
"Weekly Shipping Report", /* RB-REPORT-NAME */
"", /*
RB-DB-CONNECTION */
"O", /*
RB-INCLUDE-RECORDS */
FilterString, /* RB-FILTER */
"", /*
RB-MEMO-FILE */
Here's the error it's generating----->
RB-FILTER contains an error at offset 170: syntax error
I've been through this code a million times today and can't find a
syntax error maybe a new set of eyes will see the problem.
Thanks,
Darren Mann
IT Manager
Miller Products Co.
1015 N. Main St.
Osceola, IA 50213
Ph. 641-342-2103
Fax 641-342-3222
[Non-text portions of this message have been removed]
from an application. Here's the code---->
ReportString = "Due From: " + string(StartD) + " To: " +
String(EndD).
FilterString =
"Not(in-list(OrderDTL.ProdCode,'STK1','STK2','STK3','STK4','STK5','STK6'
,'STK7','STK8','STK9','STKA','2410','STKB',
'STKC','STKD','STKE','STKF','STKG','STKH','STKI','STKJ','STKK','STKL','S
TKM','STKN','SAMP')) AND OrderRel.Reqdate >= " + String(StartD) + " and
OrderRel.Reqdate <= " + String(EndD) + " and OrderRel.OpenRelease =
Yes".
RUN aderb\_printrb(
"v:\vantage\ud\shipping.prl", /* RB-REPORT-LIBRARY
*/
"Weekly Shipping Report", /* RB-REPORT-NAME */
"", /*
RB-DB-CONNECTION */
"O", /*
RB-INCLUDE-RECORDS */
FilterString, /* RB-FILTER */
"", /*
RB-MEMO-FILE */
Here's the error it's generating----->
RB-FILTER contains an error at offset 170: syntax error
I've been through this code a million times today and can't find a
syntax error maybe a new set of eyes will see the problem.
Thanks,
Darren Mann
IT Manager
Miller Products Co.
1015 N. Main St.
Osceola, IA 50213
Ph. 641-342-2103
Fax 641-342-3222
[Non-text portions of this message have been removed]