Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Mike Yearwood
  Where is Mike Yearwood?
 Toronto
 Canada
 Mike Yearwood
 To: Alan Tuscano
  Where is Alan Tuscano?
 Manila
 Philippines
 Alan Tuscano
 Tags
Subject: RE: Order clause Invalid
Thread ID: 268692 Message ID: 268703 # Views: 33 # Ratings: 0
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Wednesday, July 14, 2010 5:49:45 AM         
   


> >
> >
> > Maybe because of this line?
> >
> >
Select C.Code as InstCode from Bank ;

> >
> > Should be:
> >
> >
Select C.Code as InstCode from Bank C ;   && you haven't created an alias for Bank

> >
> > Also with alias, although it will work using A, B, C..... I prefer using T1, T2, T3..... If you use A, B, C.... what would happen if you reach M? Mdot rule will take over and VFP will treat m.Myfield not as tablename.fieldname but variable Myfield.
> >
> >
> >
> > http://www.junblogs.com/
> > http://weblogs.foxite.com/sandstorm36/default.aspx
> > http://www.coderisland.com/forum/viewforum.php?f=10
>
> Ahhhh... I see, Still sleepy with the Luzon wide black out last nite due to typhoon "Basyang".
> Also, Thank you for the Tip on Aliases.. your right there, as M has a reserve function in VFP.
>
> Thank you.. Thank You Jun.
>
>
> Alan
> Ad Majorem Dei Gloriam.

You can use aliases, but T1, T2, T3 are not readable either. Abbreviate!

Mike Yearwood
Microsoft MVP Visual FoxPro 2008, 2009
We have enough youth. We need a fountain of smart!
There may be many ways to skin a cat, but there are very few right ways to do it.

ENTIRE THREAD

Order clause Invalid Posted by Alan Tuscano @ 7/14/2010 3:25:54 AM
RE: Order clause Invalid Posted by Jun Tangunan @ 7/14/2010 3:33:10 AM
RE: Order clause Invalid Posted by Alan Tuscano @ 7/14/2010 4:51:20 AM
RE: Order clause Invalid Posted by Mike Yearwood @ 7/14/2010 5:49:45 AM
RE: Order clause Invalid Posted by Cetin Basoz @ 7/14/2010 11:46:05 AM
RE: Order clause Invalid Posted by Anders Altberg @ 7/14/2010 1:24:47 PM
RE: Order clause Invalid Posted by Christian Tabligan @ 7/14/2010 2:34:37 PM
RE: Order clause Invalid Posted by Samir H. @ 7/14/2010 3:21:51 PM
RE: Order clause Invalid Posted by Tamar Granor @ 7/14/2010 10:22:25 PM
RE: Order clause Invalid Posted by Christian Tabligan @ 7/15/2010 2:15:16 AM