Is Empty - true, but records really exists

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Shurik

Is Empty - true, but records really exists

Post by Shurik » Thu 11 May 2006 14:54

Hi!
I am using SDAC (3.55.2.21) for SQL Server 2000.
My SQL:
SELECT *
FROM sysobjects
WHERE name = :name
AND type = 'U'

Profiler:
exec sp_executesql N'SELECT *
FROM sysobjects
WHERE name = @P1
AND type = ''U''', N'@P1 nvarchar(15)', N'Table1'

Query Analizer:
data exists

But prop IsEmpty = true, Recordcount = 0
What is truble?
Thanks.

Shurik

Re: Is Empty - true, but records really exists

Post by Shurik » Thu 11 May 2006 15:21

Shurik wrote:Hi!
I am using SDAC (3.55.2.21) for SQL Server 2000.
My SQL:
SELECT *
FROM sysobjects
WHERE name = :name
AND type = 'U'

Profiler:
exec sp_executesql N'SELECT *
FROM sysobjects
WHERE name = @P1
AND type = ''U''', N'@P1 nvarchar(15)', N'Table1'

Query Analizer:
data exists

But prop IsEmpty = true, Recordcount = 0
What is truble?
Thanks.
Sorry. I am stupid. All works :)

Post Reply