Pulling blank values using varRecords 1

[elpico]

Hi all,

Some of the data in my db table can be blank, but when that is the case I am having problems loading them in as values using the varRecords option.

varRecords = rst.getRows(rst.RecordCount)

For intJ = 0 to UBound(varRecords, 2)
site = varRecords(0, intj)
env = varRecords(1, intj)
next intj

Sometime my env value is empty, but I'm getting a Error number 94 null value error when this happens - Any idea how I can load blank values in?

Thanks,
e.

 

[PHV]

Take a look at the Nz function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[elpico]

Thanks - works perfectly!