View Single Post
  #1 (permalink)  
Old 03-10-2008, 05:57 PM
skipper skipper is offline
Junior Member
 
Join Date: Dec 2007
Posts: 43
Default Specified cast is not valid

Hello all,
reading a database table with the SQL executeTable command and then accessing each single cell with

myVar=Table1.Cell(Table1.ColName(k),0)

I get the "Specified cast is not valid" error message if the cell contains a "null" value deriving from an empty field in the database.

How to avoid this message? Only providing a default value to the field? or is there any other solution?

Many thanks
Mimmo
Reply With Quote