table aliases

[Ruslan Zasukhin]

On 3/17/04 5:32 PM, "fiona cosgrove" <fionacosgrove at yahoo.co.uk> wrote:

> Hi Ruslan 
> 
> that was silly of me, I made a typo in my email. The
> field which I am ordering by is now in the SELECT
> statement. Unfortunalty I am still getting a 604
> syntax error. This is the sql:
> 
> 'select wstr_id, wstr_title, ai_count
> from wstr, ai, aw
> where ai_wstr_id = wstr_id and ai_wwrd_id = aw_id and
> aw_word = 'biology' order by ai_count'
> 
> 
> 
> However if I take out the ORDER BY the string works:
> 
> 'select wstr_id, wstr_title, ai_count
> from wstr, ai, aw
> where ai_wstr_id = wstr_id and ai_wwrd_id = aw_id and
> aw_word = 'biology''
> 
> I dont understand why this is happening. I am using
> the sql within director with the v4md xtra.
> 
> However, Both SQL strings work perfectly if I test it
> in ViSql carbon instead of director.
> 
> Could the error possibly be to do with the V4MD xtra?
> 
> We are using the demo version to see if it works with
> our system before we decide to buy it. Is it maybe the
> demo version?

No, this is NOT demo version.
And NO, this is NOT V4MD problem.

Hmm,

May be you write something wrong in code?
Show me how you do query please.

Do you have small Director project and db which you can send to me for test?


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------