Anthony's example is great. Anyway, I would recommend replacing this:
def index():
return dict(grid=SQLFORM.grid(db.person, user_signature=False))
with this:
@auth.requires_login()
def index():
return dict(grid=SQLFORM.smartgrid(db.person))
user_signature=False will expose all data to users of the system without
requiring a registration/password. Apart for security implications, that
will prevent versioning and auditing database changes.
On Sunday, 16 February 2014 15:24:55 UTC-6, jimbo wrote:
>
> Anthony that is really good, very impressive and just what I want! From
> memory that so far actually seems to be both simpler and better than what
> MS Access would offer.
>
> A lot of people and companies could make good use of web2py as a database,
> Especially small businesses and charities etc. I need to do a bit more
> delving and get myself up to speed hopefully. However those precise
> instructions are a base for progress, thanks to both yourself and Neo for
> your time.
>
> I will leave this open for a few more days in case anybody else has
> something to add. Many thanks. Jimmy.
>
> On Saturday, 15 February 2014 14:35:49 UTC, jimbo wrote:
>>
>> Hi I am thinking of using web2py for a small database instead of MS
>> Access. It is for a charity and would have only several hundred records of
>> employees and a table for clients. It would run on a local network with
>> probably only two computers using it. The usual name, address , tel no. and
>> some certificate and photo. It would avoid licence fees for a start and I
>> think easier to use via a browser
>>
>> I know a little about Access but very basic. Are there any simple
>> examples of where I could start, or some web2py appliance available?
>>
>> If any you can help or have something I can look at I would be very
>> grateful. It's as much a learing thing for myself as I know virtually
>> nothing aobut DB's.
>>
>>
>> Thanks, Jim
>>
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
