SQL: ORDER BY clause is invalid

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

SQL: ORDER BY clause is invalid

Message

01/04/2005 16:06:37

Jim Nelson
Toronto, Ontario, Canada

01/04/2005 12:57:14

Jim Winter
Jim Winter Consulting
Hinesburg, Vermont, États-Unis

Information générale

Forum:

Visual FoxPro

Catégorie:

Autre

Titre:

Re: SQL: ORDER BY clause is invalid

Versions des environnements

Visual FoxPro:

VFP 9

OS:

Windows XP SP2

Network:

Novell 5.x

Database:

Visual FoxPro

Divers

Thread ID:

01000629

Message ID:

01000845

Vues:

>>>>>>
>>
>>To SQL server it's valid. IOW with a sample from pubs:
>>
>>

>>select distinct au_fname,au_lname, phone, right(phone,4) as PhoneNo
>>  from Authors
>>  order by PhoneNo,Phone
>>

is valid.
>>Cetin
>
>So Microsoft is being pretty inconsistent here.

That's why I'll take this opportunity to mention yet again that VFP's using some field to prototype the field's length for the WHOLE cursor/table is also highly silly AND inconsistent with SQL Server too.

So, to be clear, I vote 2 BUGS/inconsistencies!

cheers
>
>Regards,

Répondre

Fil

Voir

Click here to load this message in the networking platform