sqlite empty inserts

[Peter Otten]

sapsi wrote:

[please don't top-post]

> Thank you for the tip, you're absolutely right.I;m getting an
> exception  that the name must not be null. However, this is some debug
> output
> --- logging.debug(" %s %s %s" %  (vdbname, foldername,where_query))
> OUTPUT: TestVDB test_b title regexp 'tit'
> --- print  vdbname.__class__,
> foldername.__class__,where_query.__class__
> OUTPUT: <type 'str'> <type 'str'> <type 'str'>
> 
> --- self.cursor.execute( "insert into __saved_query__(vdb_name,
> query_table_name, query) values (?,?,?)", (vdbname,
> foldername,where_query))
> 
> OUTPUT: __saved_query__.vdb_name may not be NULL
> 
> I honestly don't get it!. Why should this occur?

Because vbdname is None?

Seriously, it's hard for us to tell what's going on without the relevant
code. If you don't provide enough context you are on your own.

Peter