DB Null's DplxWebForm

Hi

I've trying to create a PDF invoice from an SQL database using a ASP.NET web application.

I've copied the Invoice example and have problems with the Freight value! It is mostly set to NULL within our database and I get an IndexOutOfRange exception when the field is returned. Delete the field in the designer, save the file and it works!

I've tried using the following to stop the NULL

IIF(IsNull(FreightAmount),"Test1","Test2")

But it still has the same issue.

Cheers

Dave

Hello Dave,

You should be able to display the fields having null values without any problem. Please try using the latest build of our product. You can get the latest build from our CustomerArea by logging in using your current serial number. If you are still having a problem then please send over the dplx file and the code you are using to our Support Team so that they can look into it further.

Thanks,
ceTe Software Support Team.

Hi

Thanks for the quick response. Looks like it was down to "_" (underscores) in my table column names. I've added alises for each column in the SELECT and got it working.

Cheers

Dave