Re: Error in TQuery

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

Article #1053

Back to borland.public.cppbuilder.database.multi-tier Previous Next

#1053

From: 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?

Technical Details

Message-ID: <397762D2.FE2B6309@SpamIsLame.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <39765b83@dnews>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fcd2b,1077edc9bd115542
X-Google-Attributes: gidfcd2b,public
From: Steve Pietrykoski <steve@SpamIsLame.com>
Subject: Re: Error in TQuery
Date: 2000/07/20
Message-ID: <397762D2.FE2B6309@SpamIsLame.com>
X-Deja-AN: 648804910
Content-Transfer-Encoding: 7bit
References: <39765b83@dnews>
X-Accept-Language: en
Content-Type: text/plain; charset=us-ascii
X-Trace: 20 Jul 2000 13:24:24 -0800, 209.101.165.21
Organization: Artisan Software, LLC
MIME-Version: 1.0
Newsgroups: borland.public.cppbuilder.database.multi-tier

Reply to Parent Message