search

MadeiraData / sql-clr-ics

Send Calendar Event / Appointment Invitations (iCal formatted file) from within SQL Server using a CLR stored procedure
https://git.madeiradata.com/sql-clr-ics/
MIT License
9 stars 1 forks source link

Add missing nullability checks during data retrieval #23

Open EitanBlumin opened 1 year ago

EitanBlumin commented 1 year ago

Several data retrieval calls could potentially throw an error if the data column is NULL. A nullability check should be added to avoid this and/or create an informative error message.

https://github.com/MadeiraData/sql-clr-ics/blob/dea8c46c0cc7591d3e7872c0a096bb497eea492a/sql_clr_ics/clr_send_ics_invite.cs#L140

EitanBlumin commented 1 year ago

Hi @twells-fi , please try checking version 2.4 which I committed here:

https://github.com/MadeiraData/sql-clr-ics/blob/v2.4/sql_clr_ics/sql_clr_ics_install.sql

Let me know if it works better for you.