SQL: ORDER BY clause is invalid

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

SQL: ORDER BY clause is invalid

Message

From

01/04/2005 12:46:58

Cetin Basoz
Engineerica Inc.
Izmir, Turkey

01/04/2005 12:43:16

Jim Winter
Jim Winter Consulting
Hinesburg, Vermont, United States

General information

Forum:

Visual FoxPro

Category:

Other

Title:

Re: SQL: ORDER BY clause is invalid

Environment versions

Visual FoxPro:

VFP 9

OS:

Windows XP SP2

Network:

Novell 5.x

Database:

Visual FoxPro

Miscellaneous

Thread ID:

01000629

Message ID:

01000736

Views:

>>>>
>>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

Map

View

Click here to load this message in the networking platform