[web2py] Re: Insert blank record crashes in sqlite

[Jim Karsten]

Here are two possible solutions, both for gluon.dal.py: 

class BaseAdapter(ConnectionPool): 

def insert(self,table,fields): 
if not fields: 
raise SyntaxError, 'No fields to insert' 
query = self._insert(table,fields) 
... 
return rid 

or 

class SQLiteAdapter(BaseAdapter): 

def insert(self,table,fields): 
if not fields: 
raise SyntaxError, 'No fields to insert' 
return BaseAdaptor.insert(self, table, fields) 

The first will affect all dbengines. The second is SQLite specific but there 
may be other dbengines that would benefit from that fix as well.