Hello,
I generated a new simple app through "New Simple Application" and
then changed its db.py to the following:
db = DAL('sqlite://MyDB.sqlite')
db.define_table('estudantes',
# DADOS PESSOAIS
Field('Nome', 'string'),
Field('Pais', 'string'),
Field('Nascimento', 'date'),
Field('Sexo', 'string'),
Field('Email', 'string'))
Well, now every time I try to insert a new entry via appadmin, I get
an Operational Error message:
Traceback (most recent call last):
File "/home/eduardo/web2py/gluon/restricted.py", line 188, in
restricted
exec ccode in environment
File "/home/eduardo/web2py/applications/teste4/controllers/
appadmin.py", line 412, in <module>
File "/home/eduardo/web2py/gluon/globals.py", line 95, in <lambda>
self._caller = lambda f: f()
File "/home/eduardo/web2py/applications/teste4/controllers/
appadmin.py", line 127, in insert
if form.accepts(request.vars, session):
File "/home/eduardo/web2py/gluon/sqlhtml.py", line 1186, in accepts
self.vars.id = self.table.insert(**fields)
File "/home/eduardo/web2py/gluon/dal.py", line 3952, in insert
return self._db._adapter.insert(self,self._listify(fields))
File "/home/eduardo/web2py/gluon/dal.py", line 717, in insert
raise e
OperationalError: near ")": syntax error
What am I missing here?
Eduardo