|
----- Original Message ----- From: "Al Mac" <macwheel99@xxxxxxxxxxx>
To: "SSA's BPCS ERP System" <bpcs-l@xxxxxxxxxxxx> Sent: Wednesday, June 21, 2006 12:41 PM Subject: Re: [BPCS-L] update statement
I suggest you carefully examine how * the field TXIDTE is defined in file ATX * the field APIRDT is defined in file APH it sounds to me, from the error message you shared, that APH.APIRDT supports null values while TTX.TXIDTE does not. Dates in many versions of BPCS support non-date content such as all zeros and all nines. It may be that some date fields in some versions of BPCS, or in some modifications, support contents that are not supported in other date fields designed by other programmers.Hello, I would like to update one field in ATX file and I try to use SQL. The SQL statement is following: UPDATE ITSKCTST83/ATX SET ATX.TXIDTE = (SELECT APH.APIRDT FROM ITSKCTST83/APH WHERE ATX.TXVNDR=APH.APVNDR AND ATX.TXINV = APH.APINV AND APH.PHDCYR = ATX.TXDCYR AND ATX.TXDCPX = APH.PHDCPX AND ATX.TXDCSQ = APH.PHDCSQ AND ATX.TXCOMP = APH.APCMPY) but I receive message: Null values not allowed in column or variable TXIDTE could anybody explain it and how to resolve it? Thanks in advance Jarek -- This is the SSA's BPCS ERP System (BPCS-L) mailing list To post a message email: BPCS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/bpcs-l or email: BPCS-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/bpcs-l. Delivered-To: macwheel99@xxxxxxxxxxx-- This is the SSA's BPCS ERP System (BPCS-L) mailing list To post a message email: BPCS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/bpcs-l or email: BPCS-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/bpcs-l. Delivered-To: daniel.warthold@xxxxxxxxxxxx
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.