Look At the dictionary
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Rod Hills Sent: Friday, December 03, 2004 8:47 AM To: [EMAIL PROTECTED] Subject: [U2] uvodbc truncating field I've wrote a small program to return a record set of part numbers and part descriptions. Then I wrote a data query under MS Excel and ran the SQL process as follows- { CALL "TALKTOME" (19) } I get 2 columns returned, the first being the part numbers, but for some reason the part descriptions are being chopped at 8 characters. Here is the subroutine- 0001 SUBROUTINE TALKTOME(CPN) 0002 OPEN "ITMMST" TO IM ELSE GOTO 99 0003 EXECUTE "SELECT ITMMST = '":CPN:"]'" 0004 MOREDATA=1 0005 DARRAY="" 0006 LOOP 0007 READNEXT ITMKEY ELSE MOREDATA=0 0008 WHILE MOREDATA 0009 READ IM.REC FROM IM,ITMKEY ELSE GOTO 99 0010 PNBR=IM.REC<1> 0011 DESC=IM.REC<2> 0012 IF DARRAY <> "" THEN DARRAY := @FM 0013 DARRAY := PNBR:@TM:DESC 0014 REPEAT 0015 SELECTN DARRAY TO 9 0016 ST=SQLExecDirect(@HSTMT, "SELECT F1,F2 FROM @TMP SLIST 9 ORDER BY 1") 0017 RETURN 0018 99: 0019 PRINT "ERROR IN OPEN OR READ FOR ITMMST" 0020 RETURN 0021 END I am using the technique described in the UCI documentation for Universe 10.0.16. It is discussed in chapter 6. Anyone have any ideas what would cause this? Thanks in advance -- Rod Hills ------- 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/
