×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
I have this sql query that has been halting since 9/28/16 during the
crystal report run, it was working fine for over 2 years. The error getting
is this:
'SQL0181 Value in Date, Time, or Timestamp not valid Database vendor code
-181'
I checked against this date IATRND, via a query/400 and see nothing funky.
Is there a way to show me which particular date and order # is the problem?
SELECT
ALL
T01.IAPRT#, T01.IA101, T01.IATRND,T01.IAUSRN,T01.IAPRLC, T01.IARCC1,
T01.IATRT, T01.IARCC2, T01.IARCC3, T01.IARCC4, T01.IARCC5,
T01.IAACTF, T01.IATRNC,
T02.IABMU, T01.IARCC6, T01.IARCC7, T01.IARCC8, T01.IARCC9,
T01.IARC10, T02.IAHCD1, T02.IAHCD2, T02.IAHCD3, T01.IAPTWT,
T01.IARC11,T01.IARC12, T01.IARC13, T01.IARC14, T01.IARC15
FROM ASTDTA.AUDIA T01,
ASTDTA.ICPRTMIA T02
WHERE T01.IAPRT# = T02.IAPRT#
and date(varchar(integer(T01.IATRND/10000)) || '-' ||
varchar(integer(T01.IATRND/100) - integer(T01.IATRND/10000) *
100) || '-' ||
varchar(mod(T01.IATRND, 100))) = current date
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.
midrange.com
