SQLite

[magi6162]

If optimize compiler I got error when run the program:
Impossible cast of objects of type System.DBNull on type
System.String

if not optimize compile all ok

Why?

I use bppc 6.30

best regards

[Erel]

It is probably because you got null values in your database.
You can use the IsNull keyword to check for null values.

[Allan]

Erel,

I am loading a table w/ cmd.ExecuteTable("tbl1",0) and it puts the nulls in the table columns.

Sub tbl1_SelectionChanged (ColName, Row)
if isnull(tbl1.Cell(ColName,Row)) then tFld.Text="" else tFld.Text = tbl1.Cell(ColName,Row)

Causes 'Specified Cast is Invalid' Error
Is there a way to detect the Nulls?

[Erel]

You can replace the Nulls with some other value.
See this thread: Specified cast is not valid (last post)