Is Empty - true, but records really exists
Posted: 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.
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.