Главная страница | назад





Article #16409: What does the error 'Token not found'

 Question and Answer Database

FAQ1409C.txt   What does the error 'Token not found'
Category   :Database Issues
Platform    :All
Product    :C++Builder  1.x

Question:
I have a TQuery and TDataSource.  In the TStrings property of 
the TQuery I have 'SELECT * FROM dbo.AnyTable' where dbo is the
database on my SQL server.  When I set active to TRUE I get the
error: 'Token not found. Token :dbo. line number:1'.  
What's wrong?

Answer:
If the RequestLive property is set to true, then enclose the 
owner and tables names in quotes:

   Ex:
   SELECT * FROM "dbo.table"

If request live is false, don't use quotes.

   Ex:
   SELECT * FROM dbo.table

7/2/98 10:32:32 AM
 

Last Modified: 01-SEP-99