Converting SQLite to CSV file from Basic4ppc.

Hi,

How could I convert a SQLite database to CSV file when some columns in the database have null values. while converting gives the error attached.

The syntex used :

WaitCursor(True)
con.BeginTransaction
cmd.CommandText = "select * from kap"
cmd.ExecuteTable("table3",0)
con.EndTransaction
If SaveDialog1.Show <> cCancel Then
Table3.SaveCSV (SaveDialog1.File,",",True)
Msgbox("CSV file has been created")
End If
WaitCursor(False)


regards,

You can use the IFNULL method in your query.
Something like:
Add IFNULL for all problematic columns.