RE: STRSQL request gives CPF4802

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