Hi

I have written this code , it is giving me value -1 . Table has no record , it should not give 0 if no record exists.

rscompany.Open "select * from owner", cnn1, adOpenDynamic, adLockOptimistic, adCmdText

I am using SQL Database.

Thanks