Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by mrderekg

  1. mrderekg

    DLOOKUP type mismatch with date fields

    Works perfectly! And thanks for the reference to Allen Browne's page, I'll check it out so I understand this better. Thanks so much, Derek
  2. mrderekg

    DLOOKUP type mismatch with date fields

    I believe I understand the # symbols as denoting dates but why the Format? Thanks, Derek
  3. mrderekg

    DLOOKUP type mismatch with date fields

    I'm using the following code to populate 2 text boxes with the fiscal year and week. The code runs on the After_Update event of an unbound text box called txtAuditDate which is formatted as Short Date and uses a date picker. tblFiscalWeeks is a cross-reference table that has the fiscal year...
  4. mrderekg

    Spooled file staying in OPN status

    That works perfectly! Thanks very much. I had a feeling it was something small and simple. Thanks, Derek
  5. mrderekg

    Spooled file staying in OPN status

    Sorry, I should have thought to post the code the first time. * SET CONNECTIONS TO EXTERNALLY DESCRIBED FILES F*RPRT00 O E DISK FRPRT01PR O E PRINTER *...
  6. mrderekg

    Spooled file staying in OPN status

    I'm trying to do some simple label printing using ILE RPG with an embedded SQL statement. The program compiles without errors and when I run it, the spooled file stays in OPN status unless I use a CLOSE statement in the file after the WRITE. If I use the CLOSE statement, the program runs fine...

Part and Inventory Search

Back
Top