I need to check if a row is null 1

[jjmew]

I am overriding the Fetch function in the content part. I have this :

Dim row as AcDataRow
Set row = Super::Fetch( )


I need to know wheter row is null or not. How I can do that? i have try if row=Null .... that doest compile.


Please help me

 

[gazolba]

Try isnull() function
This is documented in the Actuate manuals - which you should have access to

 

[jjmew]

Thanks for your help. I already try the IsNull function but i doesnt compile becouse it says that the only kind of variable that you can use is variant. I am using a AcDataRow variable and that is the problem

 

[gazolba]

From Actuate manual:

If row is Nothing Then
...
End If

This will only happen at the end of file.

Maybe you could test one column of the row for null, a column that is normally set to some value?

 

[actuate5]

Hi Folks Gazolba is right, I am posting a very simple code for so anyone can get help in future.

Function Fetch ()

Dim row as AcDataRow
Set row = Super::Fetch( )

If row Is Nothing Then
Exit Function
End If

MyGlobalVariable1 = row.Variable1
MyGlobalVariable2 = row.Variable2

Set Fetch = row

Exit Function

This is just an example not a tested code.

hope this helps.