Monday, February 20, 2012

Is my object variable empty?

Hallo!

I got an object variable. I used it in a “Recordset destination”.

How can I proof if it is empty?

Isnull(@.[Benutzer::MyVar]) does not work!

One thing you can do is to shred through it and pop up a message with each value.

http://www.sqlis.com/59.aspx

|||

I decided to use a count (Countrow) while populating my recordset. Then I can have access to the variable just like @.[Benutzer::Count] > 0 ? true : false

Smile|||Good idea.|||Remember to mark a post as answered, even if you are the one who answered it...

No comments:

Post a Comment