Gary Kjos
garykjos at gmail.com
Fri Aug 19 13:01:53 CDT 2005
Hi Jim, I think not an empty string but a single space character surrounded by the appropriate quotation marks is what I would use. Hex 40 is EBCDIC for a space. ASCII space is hex 20. Evidently the space it originally contained got stripped as part of a "trim" trailing spaces that the file transfer did for you - which you would have preferred in this case that it hadn't done. Give it a space and you should be good to go. Gary On 8/19/05, Hale, Jim <Jim.Hale at fleetpride.com> wrote: > I imported tables into Access from the AS400 using IBM's client Access ODBC > driver. I updated the tables in Access, emptied the tables on the AS400 and > uploaded the Updated Access data to the AS400 via an append query (the AS400 > tables were linked via the ODBC driver). This worked fine except for one > table. The table came from the AS400 with blank fields. When I tried to > upload it back the AS400 puked saying I was trying to place nulls in the > field. The AS400 guys tell me the AS400 does not have nulls, that the field > is really a blank (hex 40?). How can I change my query so that the AS400 > will accept it? Use an empty string? Use the ASC equivalent of hex 40? TIA > > Jim Hale > > *********************************************************************** > The information transmitted is intended solely for the individual or > entity to which it is addressed and may contain confidential and/or > privileged material. Any review, retransmission, dissemination or > other use of or taking action in reliance upon this information by > persons or entities other than the intended recipient is prohibited. > If you have received this email in error please contact the sender and > delete the material from any computer. As a recipient of this email, > you are responsible for screening its contents and the contents of any > attachments for the presence of viruses. No liability is accepted for > any damages caused by any virus transmitted by this email. > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > > -- Gary Kjos garykjos at gmail.com