I am trying to retrieve data from our ODS Database and hold it as XML. This is a copy of the error
-GOTO L_EXIT ; -L_EXIT SET GRAPHSERVURL=http://xxxxx.xxxxxxx.xxx:xxxx/ibi_apps/IBIGraphServlet SET GRAPHENGINE=GRAPH53 -INCLUDE mrheader -* mr header include start -* mr as NOT html -SET &FOCEXURL=/ibi_apps/WFServlet?IBIF_webapp=/ibi_apps&IBIC_server=EDASERVE&IBIWF_msgviewer=OFF&IBIAPP_app=baseapp ods_common ods_student plus_sis sql_student& | '&' | 'IBIMR_drill=X,studentx/studentx.htm' | '&'; -OLAP ON SET FOCEXURL='/ibi_apps/WFServlet?IBIF_webapp=/ibi_apps&IBIC_server=EDASERVE&IBIWF_msgviewer=OFF&IBIAPP_app=baseapp ods_common ods_student plus_sis sql_student&&IBIMR_drill=X,studentx/studentx.htm&' -OLAP OFF -* mr header include end -* -INCLUDE ADHOCRQ TABLE FILE ODSST_COURSE_CATALOG PRINT SUBJECT SUBJECT_DESC COURSE_NUMBER TITLE_LONG_DESC COURSE_TEXT_NARRATIVE BY COURSE_IDENTIFICATION HEADING "" FOOTING "" WHERE ACADEMIC_YEAR_DESC EQ '2009-2010'; WHERE RECORDLIMIT EQ 100 ON TABLE SET PAGE-NUM OFF ON TABLE NOTOTAL ON TABLE HOLD FORMAT XML ON TABLE SET STYLE * UNITS=IN, SQUEEZE=ON, ORIENTATION=PORTRAIT, $ TYPE=REPORT, GRID=OFF, FONT='TIMES NEW ROMAN', SIZE=10, $ ENDSTYLE END 0 NUMBER OF RECORDS IN TABLE= 100 LINES= 100 0 ERROR AT OR NEAR LINE 29 IN PROCEDURE ADHOCRQ FOCEXEC * (FOC702) THE OPTION SPECIFIED IS NOT AVAILABLE WITH TEXT FIELDS:
I cannot figure out where I am going wrong with this one.This message has been edited. Last edited by: Kerry,
Developer Studio 7.7.02 Windows XP Pro SP3 and Windows 7 64bit all output
March 05, 2010, 11:58 AM
GinnyJakes
quote:
(FOC702) THE OPTION SPECIFIED IS NOT AVAILABLE WITH TEXT FIELDS:
I think that is pretty clear. Comment out the text field and see if it works. If yes, then you'll have to convert your text field to an alpha.