RE: STRSQL request gives CPF4802

[David FOXWELL <David.FOXWELL@xxxxxxxxx>]

Hi Dennis, you're early!

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.

> -----Message d'origine-----
> De : midrange-l-bounces@xxxxxxxxxxxx 
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] De la part de Dennis Lovelady
> Envoyé : jeudi 12 novembre 2009 11:49
> À : 'Midrange Systems Technical Discussion'
> Objet : RE: STRSQL request gives CPF4802
>
> > I'm joining 3 tables, clients, addresses and clientadresses 
> to get the 
> > clients living in a town.
> >
> > What determines the order of the select?
> > They seem to be mostly in the order of the fields in the select.
>
> The ORDER BY clause (which is missing from your text) 
> determines the order.
>
> > If I pagedown then pageup again I get :
> > Opération de lecture impossible pour le membre CLIENTS. (C 
> I) Is this 
> > a bug? I can't reply to the message!
>
> Guessing: "Operation cannot be done for member CLIENTS."
>
> Press F1 or HELP on the message for help.  Then let us know 
> more details from that help.
>
> Regards,
>
> Dennis Lovelady
> http://www.linkedin.com/in/dennislovelady
> --
> "Never do card tricks for the boys you play poker with."
>         -- American Proverb