table aliases

[fiona cosgrove]

Thanks Ruslan,

here is my code that calls the cursor. I have included
two versions, the first has the ORDER By within it and
the second does not. The second one works.

-------------
1) code with ORDER By in the sql string
------------
set gDatabase = new(xtra "vdatabase")
    
  DatabasePath = string(the moviepath & fulltext.vdb")

   
  openDatabase(gDatabase, dbpath)
  
    kReadWrite = 3 
    kserver = 2
    
    
 sqlstringS = string(" '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' ")
    

 set gCursorRelevance = new(xtra "vCursor",
getRef(gSrchDb), sqlstring, Kserver, kreadWrite)
   
----------------
2) code Without the ORDER BY in the sql string, this
works
----------------
set gDatabase = new(xtra "vdatabase")
    
  DatabasePath = string(the moviepath & fulltext.vdb")

   
  openDatabase(gDatabase, dbpath)
  
    kReadWrite = 3 
    kserver = 2
    
    
 sqlstringS = string(" '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' '")
    

 set gCursorRelevance = new(xtra "vCursor",
getRef(gSrchDb), sqlstring, Kserver, kreadWrite)
   
------------
The error always happens when Ive included the ORDER
BY at the end of the string.

--
Fiona


--- Ruslan Zasukhin <sunshine at public.kherson.ua>
wrote: > On 3/17/04 5:32 PM, 
> 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
>
-------------------------------------------------------------
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina 


	
	
		
___________________________________________________________
Yahoo! Messenger - Communicate instantly..."Ping" 
your friends today! Download Messenger Now 
http://uk.messenger.yahoo.com/download/index.html