Capability Not supported.....why not? 
Author Message
 Capability Not supported.....why not?

the following sql :

            where UsebyName = :name and
                       PayEntity = :payentity and
                       TaxType = :taxtype and
                       StateID in ("" ,:stateid) and
                       FilingEntity in ( "" ,:filingentity ) and
                       datediff(dd, getdate(),ExpirationDate) > 0

when it is added into a Tquery and opened, produces the error message
"Capability Not Supported".

This is a BDE error is it not?

This sql should be passing right through to my Sybase backend, which
should easily handle it.

I set SQLQueryMode=SERVER in my TDatabase to try and make sure it
wasn;t trying to interpret the sql locally, but I am still getting the
same error.

Has anyone else run into this situation?

Any help would be very much appreciated!

Sun, 27 Jun 1999 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. SQL error - capability not supported...Why ?

2. Capability Not Supported Error

3. capability not supported

4. Error: 'Capability not supported'

5. capability not supported

6. Capability Not Supported, Delphi 4, Oracle 8

7. "capability not supported" w/MSAccess DB

8. Capability not supported - runtime only???

9. capability not supported

10. SQL capability not supported

11. BDE: Capability not supported token: NESTED SELECT (when using Paradox files, works with Interbase)

12. A Query and Capability not supported error


Powered by phpBB® Forum Software