I cant' reproduce this.
Please post your table definitions.
On Mar 5, 8:49 pm, Joaquin Orbe <joaquino...@gmail.com> wrote:
> Update: I've tried SQLite and it's the same problem:
>
> <class 'sqlite3.OperationalError'>(near ")": syntax error)
>
> > locals
> > query : 'INSERT INTO my_table() VALUES ();'
>
> Any kind of help will be appreciated.
>
> Joaquin.
>
> On Sat, Mar 5, 2011 at 3:09 PM, Joaquin Orbe <joaquino...@gmail.com> wrote:
> > Hi all,
>
> > I have a strange behaviour in appadmin trying to insert a record. It
> > happens with all my tables except for auth's (auth_user, auth_group,
> > etc). This is the error message:
>
> > <class 'pyodbc.ProgrammingError'>(('42000', "[42000] [Microsoft][ODBC
> > SQL Server Driver][SQL Server]Incorrect syntax near ')'. (102)
> > (SQLExecDirectW)"))
>
> > I tried to understand the ticket created and could find this at
> > gluon\dal.py in insert at line 717:
> > locals
> > query : 'INSERT INTO my_table() VALUES ();'
>
> > Does it means it created an empty query?
>
> > I'm on win7, python 2.6, web2py 1.92.1 from sources.
>
> > Thanks in advance,
> > Joaquin.
>
>
