ah - so this is an SQL issue - which makes complete sense. MD1 implies a decimal position and INTEGER datatype by definition does not allow decimals. change your SQL data type on this field to DECIMAL,10,1
the real question though is does universe generate this error for non-sql query ? Gerry -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Brutzman, Bill Sent: Friday, May 06, 2005 10:43 AM To: [email protected] Subject: RE: [U2] Integer Conversion Codes The problem happens when I try to run a paragraph with an embedded UniBasic program that uses a data dictionary with an "MD1" in it. The error is... UniVerse/SQL: Conversion "MD1" is incompatible with an INTEGER datatype The paragraph is... >ed VOC SHOW.PRESSES 0001: R 0002: USER.PL 0003: SHOW.PRESSES >ed USER.PL SHOW.PRESSES 0001: PA 0002: * GMS BM RELEASE 1.5 0003: * SHOW.PRESSES - PRINT OR DISPLAY PRESS CODES 0004: CLR 0005: DISPLAY <<@(10,0),F(SYS.CTL,COMPANY.NAME,1),COMPANY.NAME>> 0006: RUN MT.BP PAR.PRINT 0007: DATA (10,4),"SHOW.PRESSES NOW RUNNING", 0008: DATA (10,6),"TIME STARTED: ",+ 0009: DATA TIME 0010: DATA END 0011: * 0012: SORT PRESS BY TONS _ 0013: ID.SUP PRESS_ 0014: CLASS SETUP TONNAGE ALIGNMENT SUBSTITUTES COMMENT _ 0015: HEADING "SHOW.PRESSES_ 0016: _ 0017: <<COMPANY.NAME>>_ 0018: Page 'PLL' Machine Press Codes and Descriptions List 'LL'" _ 0019: DBL.SPC LPTR 0020: * 0021: RUN MT.BP PAR.PRINT 0022: DATA (10,8),"REPORT COMPLETED: ",+ 0023: DATA TIME 0024: DATA END DICT PRESS Type & Field......... Field. Field........ Conversion.. Column......... Output Name.......... Number Definition... Code........ Heading........ Format @ID D 0 PRESS 10L S PRESS D 0 Press 5L S TONS D 2 MD0 Tonnage 4R S ALIGNMENT D 3 Alignment 10L S SUBSTITUTES D 4 Subs 5L S COMMENT D 5 Comment 20L S CLASS D 6 Class 6L S SETUP D 7 MD1 S/U 3R S VALID.ODA D 8 1L S ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
