Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Help with Order By in a Union
Message
 
 
To
06/05/2009 10:45:20
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01397707
Message ID:
01398191
Views:
70
>Inconsistency, maybe, as other things were done to make internal SQL behave in a TSQL-like manner. So this would be wrong if you have TSQL glasses on - or TSQL was wrong if you have VFP glasses on.
>
>If this was the only difference between the two, I might have put that somewhere on the list of warnings, gotchas and other things that make you waste time and slap forehead more often than normal. But given that there are so many other differences (like the awkward way TSQL deals with date arithmetic, the mandatory =1 when checking whether a logical field is true, but then being unable to calculate with those bits unless casted, and then the huge difference in syntax when it comes to quotation marks, apostrophes and square brackets...), this one doesn't worry me much.

You couldn't compare a 'logical column' in TSQL to anything because TSQL doesn't have logical data type. The closest one is bit but it's numeric.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform