Re: STRSQL request gives CPF4802

[CRPence <CRPbottle@xxxxxxxxx>]

David FOXWELL wrote:
> Actually, I had a date of birth in the select.
>
> I get the message that the date is smaller than the minimum 
> permitted, and ++++++++ is displayed. If I take the date of
> birth out of the select, the problem doesn't occur.
>
> However, if I look at the client with runqry, I see 07.03.1930
> as the birthdate.
>
> It gets curiouser and curiouser.

  Query/400 reporting honors the DATFMT() of the column for 
presentation, whereas the STRSQL reporting honors the DATFMT() 
specified either on the STRSQL command or that modified setting 
using F13=Services within a STRSQL session.  RUNQRY & WRKQRY have no 
equivalent of the DATFMT() specification in STRSQL that can be used 
to override the preferred presentation for all date data type values 
in a report.

Regards, Chuck