-* -SET &BEG1 = '20081201'; -SET &END1 = '20081231'; -* -SET &BEGDT = EDIT(20081201,'9999/99/99') |''| '00:00:00'; -SET &ENDDT = EDIT(20081231,'9999/99/99') |''| '23:59:59'; -* -TYPE 2008/12/01 00:00:00 . . . . . . 2008/12/31 23:59:59 2008/12/01 00:00:00 . . . . . . 2008/12/31 23:59:59 -* -* JOIN CLEAR * -* Here, I have a WHOLE BUNCH of JOINs -RUN -* TABLE FILE WHATEVER BY RESULT_DATE WHERE RESULT_DATE GE '2008/12/01 00:00:00' LE '2008/12/31 23:59:59'; IF RECORDLIMIT EQ 15 END -RUN -EXIT 0 ERROR AT OR NEAR LINE 33 IN PROCEDURE ADHOCRQ FOCEXEC * (FOC015) THE TEST VALUE IS LONGER THAN THE FIELD FORMAT LENGTH: 2008/12/01 00:00:00 0 ERROR AT OR NEAR LINE 33 IN PROCEDURE ADHOCRQ FOCEXEC * (FOC280) COMPARISON BETWEEN COMPUTATIONAL AND ALPHA VALUES IS NOT ALLOWED (FOC009) INCOMPLETE REQUEST STATEMENT BYPASSING TO END OF COMMAND -* -SET &BEG1 = '20081201'; -SET &END1 = '20081231'; -* -SET &BEGDT = EDIT(20081201,'9999/99/99') |''| '00:00:00'; -SET &ENDDT = EDIT(20081231,'9999/99/99') |''| '23:59:59'; -* -TYPE 2008/12/01 00:00:00 . . . . . . 2008/12/31 23:59:59 2008/12/01 00:00:00 . . . . . . 2008/12/31 23:59:59 -* -* JOIN CLEAR * -* Here, I have a WHOLE BUNCH of JOINs -RUN -* TABLE FILE WHATEVER BY RESULT_DATE WHERE RESULT_DATE GE '2008/12/01 00:00:00' LE '2008/12/31 23:59:59'; IF RECORDLIMIT EQ 15 END -RUN -EXIT 0 ERROR AT OR NEAR LINE 33 IN PROCEDURE ADHOCRQ FOCEXEC * (FOC015) THE TEST VALUE IS LONGER THAN THE FIELD FORMAT LENGTH: 2008/12/01 00:00:00 0 ERROR AT OR NEAR LINE 33 IN PROCEDURE ADHOCRQ FOCEXEC * (FOC280) COMPARISON BETWEEN COMPUTATIONAL AND ALPHA VALUES IS NOT ALLOWED (FOC009) INCOMPLETE REQUEST STATEMENT BYPASSING TO END OF COMMAND
-* TABLE FILE WHATEVER BY RESULT_DATE IF RECORDLIMIT EQ 3 END -RUN .... Here is a little report: RESULT_DATE 2000/03/28 00:00:00 2000/03/29 00:00:00 2000/03/30 00:00:00
Frank | |
prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7 |
WHERE RESULT_DATE GE '2008/12/01 00:00:00' LE '2008/12/31 23:59:59';is not a valid shortcut for FROM-TO or GE and LE selection
WHERE RESULT_DATE GE DT('2008/12/01 00:00:00') AND RESULT_DATE LE DT('2008/12/31 23:59:59');
WHERE RESULT_DATE GE DT('2008-12-01 00:00:00') AND RESULT_DATE LE DT('2008-12-31 23:59:59');
Frank | |
prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7 |
quote:WHERE RESULT_DATE GE DT('2008/12/01 00:00:00') AND RESULT_DATE LE DT('2008/12/31 23:59:59');