× 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.





The date fields in the databse have a value(not NULL/BLANK and SHARE(*YES) is mentioned on the OVRDBF command. The date values are still being retrievd as NULL/BLANK.

Any suggestions.....> Subject: RE: Date fields not being retrieved> Date: Mon, 7 Jul 2008 10:11:18 -0400> From: jarnold@xxxxxxxxxxxxxxxxxxxxxxxxxx> To: rpg400-l@xxxxxxxxxxxx> > Are there blank date values in the data?> > > John Arnold> (301) 354-2939> > > -----Original Message-----> From: rpg400-l-bounces@xxxxxxxxxxxx> [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of derek gonsalves> Sent: Monday, July 07, 2008 9:34 AM> To: rpg> Subject: Date fields not being retrieved> > > Hi ,> > I have a printer file Program Test. > Records for this program are selected with OPNQRYF> > OVRDBF FILE(ABC)> > OPNQRYF FILE(ABC) QRYSLT(SELECT WHERE DATE1 > '2006-07-01'> > CALL PGM(TEST) .> > All the date fields are being retrieved as Blanks.Other field values are> being retrieved correctly.> The Program is compiled with the CVTOPT *DATETIME.> > Any suggestions as to why the date fields are being retrieved as Blanks?> > > Thanks> Derek> _________________________________________________________________> Use video conversation to talk face-to-face with Windows Live Messenger.> http://www.windowslive.com/messenger/connect_your_way.html?ocid=TXT_TAGL> M_WL_Refresh_messenger_video_072008> --> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing> list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe,> unsubscribe, or change list options,> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l> or email: RPG400-L-request@xxxxxxxxxxxx> Before posting, please take a moment to review the archives at> http://archive.midrange.com/rpg400-l.> > -- > This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list> To post a message email: RPG400-L@xxxxxxxxxxxx> To subscribe, unsubscribe, or change list options,> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l> or email: RPG400-L-request@xxxxxxxxxxxx> Before posting, please take a moment to review the archives> at http://archive.midrange.com/rpg400-l.>
_________________________________________________________________
It’s a talkathon – but it’s not just talk.
http://www.imtalkathon.com/?source=EML_WLH_Talkathon_JustTalk

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.