Does the dictionary in question have an SQL type assigned as INTEGER or INT (attribute 8 of the D or I type dict, 6 of an A type)? If so, change it to NUMERIC.
Brutzman, Bill wrote: >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/ >--- >[This E-mail scanned for viruses by Declude Virus] ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
