This bit "configuration where :ConfigurationID" doesn't make sense. Perhaps
"where configurationid = :configurationid" might work better
-Kerry S
----- Original Message -----
From: Derricutt, Mark <[EMAIL PROTECTED]>
To: Multiple recipients of list database <[EMAIL PROTECTED]>
Sent: Friday, October 08, 1999 11:00 AM
Subject: [DUG-DB]: Error: Cannot find object
> I've got a strange problem, I have a query that runs fine in database
> desktop, but when I try it from a TQuery component, it crashes with the
> error "cannot find object".
>
> The query is thus:
>
> select
> count(*) as PointCount
> from
> PointAttributes
> where
> Point = :Point and
> configurationid =
> (
> select
> configurationid
> from
> configuration
> where
> startdate = (
> select
> MAX(startdate)
> from
> configuration
> where
> startdate <= (
> select startdate from
> configuration where :ConfigurationID
> )
> )
> )
>
> In database desktop I'm replacing the params with values and it works, I'm
> assuming I can't use parameters in a subquery/subsubquery? Is this a bug
in
> Delphi's TQuery parser that could be added to the wish list?
>
>
> --
> Mark Derricutt, He that brings forth electronic life.
> Getting jiggy with Front Line Assembly, Bill Leeb, Friends and Company -
> Cryogenic Studios
>
>
> --------------------------------------------------------------------------
-
> New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
