[web2py] Re: Need a little help with DAL

2012-07-18 Thread Aurelijus Useckas
This worked! thnx a lot ;) On Tuesday, July 17, 2012 2:00:37 PM UTC+3, Anthony wrote: > > Note, SQLite cannot drop fields -- see > http://web2py.com/books/default/chapter/29/6#Fixing-broken-migrations. How > about if you create a fresh database (i.e., delete everything from the > databases fold

[web2py] Re: Need a little help with DAL

2012-07-17 Thread Anthony
Note, SQLite cannot drop fields -- see http://web2py.com/books/default/chapter/29/6#Fixing-broken-migrations. How about if you create a fresh database (i.e., delete everything from the databases folder and start from scratch)? On Tuesday, July 17, 2012 6:27:52 AM UTC-4, Aurelijus Useckas wrote:

[web2py] Re: Need a little help with DAL

2012-07-17 Thread Aurelijus Useckas
I've tried to erase all fields, but still with no success :( yep, SQLite On Tuesday, July 17, 2012 11:15:02 AM UTC+3, Anthony wrote: > > Are you using SQLite? Did you initially forget to define "workers" as an > integer field, enter some data, and then convert it to an integer field? > What happ

[web2py] Re: Need a little help with DAL

2012-07-17 Thread Anthony
Are you using SQLite? Did you initially forget to define "workers" as an integer field, enter some data, and then convert it to an integer field? What happens if you start with a fresh db? Anthony On Tuesday, July 17, 2012 3:55:35 AM UTC-4, Aurelijus Useckas wrote: > > Yes, it really acts like

[web2py] Re: Need a little help with DAL

2012-07-17 Thread Aurelijus Useckas
Yes, it really acts like str. I'm using the nightly build 1.99.7 dev. Could it be because of dev? here's all of the db definition: db.define_table('company', Field('title', label='Pavadinimas', unique=True), Field('CEO', label='Generalinis dir.'), Field('code', 'integer', label='Įmon

[web2py] Re: Need a little help with DAL

2012-07-16 Thread pbreit
Looks like it is comparing them as strings. As others noted, need to see code. --

[web2py] Re: Need a little help with DAL

2012-07-16 Thread Anthony
Can you send your exact code? On Monday, July 16, 2012 8:35:15 AM UTC-4, Aurelijus Useckas wrote: > > Hi, > > I have declared a table 'company' and the Field 'workers' which expects > the number of workers in the company: > > db.define_table('company', > (...) > Field('workers', 'integer'),

[web2py] Re: Need a little help with DAL

2012-07-16 Thread Niphlod
I can't reproduce the error. What db engine are you using and what web2py version are you running ? On Monday, July 16, 2012 2:35:15 PM UTC+2, Aurelijus Useckas wrote: > > Hi, > > I have declared a table 'company' and the Field 'workers' which expects > the number of workers in the company: >