Error in TQuery

Thread View: borland.public.cppbuilder.database.multi-tier

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Sam S. Firouz Wed, 19 Jul 2000 00:00

#1051

Author: Sam S. Firouz
Date: Wed, 19 Jul 2000 00:00

8 lines
999 bytes

I am trying to execute a SQL statment like :
select * from tblusersubtypecode where chrusersubtypecode in (select
distinct chrusersubtypecode from tblvalidtypes where chrusertypecode = 'DS')

it works fine if I try to execute it frm inside the "SQL Explorer". But when
I try to open the TQuery with this statment in the SQL property it trwos an
Exception with the message "Capability not supported".
Does anyone know what I am doing wrong?

Re: Error in TQuery

#1053

Author: Steve Pietrykoski
Date: Thu, 20 Jul 2000 00:00

16 lines
1229 bytes

I'm going to guess that your query has RequestLive set to true.  Certain
syntax, like IN, is not available for live queries.

Steve Pietrykoski


"Sam S. Firouz" wrote:
> 
> I am trying to execute a SQL statment like :
> select * from tblusersubtypecode where chrusersubtypecode in (select
> distinct chrusersubtypecode from tblvalidtypes where chrusertypecode = 'DS')
> 
> it works fine if I try to execute it frm inside the "SQL Explorer". But when
> I try to open the TQuery with this statment in the SQL property it trwos an
> Exception with the message "Capability not supported".
> Does anyone know what I am doing wrong?

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads