On Wednesday 22 October 2008 08:52:44 pm Ed Leafe wrote: > On Oct 22, 2008, at 10:46 PM, johnf wrote: > > Does not work. First I added 'alias' in the addFrom in the > > dCursorMixin. But > > that will still not work because the is suppose to use the alias > > too. But of > > course it does not. > > I don't understand what exactly happened here. What do you mean "of > course it does not"? > > -- Ed Leafe
Oh - I guess I should have explained more. When you use an alias you have to use the alias everywhere - including in the where statement. So if one uses "tableName a" - then in the where clause you can not use "tableName.somefield" it has to be "a.somefield". See the other posting in dev. -- John Fabiani _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/[EMAIL PROTECTED]
