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 12:46:58

Cetin Basoz
Engineerica Inc.
Izmir, Turquie

01/04/2005 12:43:16

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:

01000736

Vues:

>>>>
>>Fabio,
>>I didn't install and play with VFP9 yet.
>>In my book it's a BUG. Too bad you lost the war there:(
>>I didn't have time to read to whole thread to see "why it's not a bug". So my point stands for me:
>>It is a BUG:)
>>
>>Hope might help for a fix.
>>Cetin
>
>Cetin,
>
>Just curious, but how does SQL Server handle this?
>
>Regards,

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

Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad

Répondre

Fil

Voir

Click here to load this message in the networking platform