[web2py] Re: dal

you would have to add a new constraint at the database level like this: query="ALTER TABLE %s ADD CONSTRAINT %s UNIQUE (amcno,unitid);" %(tablename,constraintname) result=db.executesql(query) here a postgresql example to set the new constraint in a controller: def setconstraint

[web2py] Help with building query functions in a web app - links to tutorials etc

Hi there everyone! I'm new to Web2py, i'm really enjoying using the framework so far. I am trying to rebuild a legacy database. I want to produce a web app that can query data from multiple tables using drop down boxes e.g. locations, species etc.. I want to be able to select info using drop

[web2py] Sponsoring a web2py to android recipe

Hello, I needed help to connect android to web2py and couldnt find any documentation online, i'm wondering if it is possible to pay someone to write a working recipe that has all the steps and code that are needed to connect and interact with web2py through an android native application. The re

[web2py] Re: dal

Additionally, to enforce the constraint with form submissions, you can do something like this: https://groups.google.com/d/msg/web2py/CRPySzABQTk/8jylUabyFTQJ. Anthony On Saturday, April 29, 2017 at 8:47:55 AM UTC-4, Pierre wrote: > > you would have to add a new constraint at the database level

Re: [web2py] Access DB2/400 from IBM i (AS/400) PASE environment

This topic is very important. Having web2py running in a top tech ibm machine is worthy of notice.Any help on this ... PLEASE Anyone know if there is a quick way to tell the DAL to ignore the case of the table/field names when connecting? Enviado a partir do meu smartphone Samsung Galaxy.