Yes, it works on sqlite, it doesn't seem to enforce the reference, it asked me to manually type the reference, and when i put in something invalid, it put it as a zero instead of giving me an error in the form. According to the web2py documentation, this should be the default:
reference <table>IS_IN_DB(db,table.field,format) But it's not doing any checks at all apparently. And sqlite doesn't enforce referential integrity anyway. On Thursday, March 22, 2012 10:53:43 AM UTC-7, Anthony wrote: > > Well, it is trying to create the contacts table before it creates the >> customers table. That's the problem. I don't know if that's an issue in the >> DAL or if I just need to re-arrange the statements in my db.py - they are >> correctly ordered in the db.py - it seems that it wants to create the >> association before it actually creates the associated table. Not sure how I >> would test that in SQLite. Is that installed and running already? >> > > Yes, SQLite is included with Python, so no need to install. You don't even > have to create the SQLite db manually -- it will be created automatically > by web2py. I only suggested that to confirm the issue is specific to MSSQL. > > Anthony >
