[web2py] Re: Parent - Child (multiple rows / grid) form development

Thanks for correcting this Dave. (Will have to read up on components). Peter -- 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 messa

[web2py] Re: Parent - Child (multiple rows / grid) form development

On Tuesday, July 11, 2017 at 7:07:56 PM UTC-7, Peter wrote: > > Hi Ramesh, > > I return a crud.read() for the invoice header and a separate query output > for the invoice lines. > > Note that the crud interface is deprecated, and isn't getting maintenance (possible exception for security fixes)

[web2py] Re: Parent - Child (multiple rows / grid) form development

Hi Ramesh, I return a crud.read() for the invoice header and a separate query output for the invoice lines. My approach is to store all Invoice Header info in a separate table on Invoice creation. (This is to ensure that an exact copy invoice can be reproduced at any later date and is not affe

[web2py] Re: FOREIGN KEY constraint failed

On Tuesday, July 11, 2017 at 2:39:46 PM UTC-7, Scheme Lab wrote: > > I think the filename ends with .sqlite doesnt it? > That's the actual database (if you're using sqlite3). The dot-table files are part of pydal, with schema information used by the driver, etc, and are present for any databa

[web2py] Re: wizard database URL ignored by default models/0.py

On Tuesday, July 11, 2017 at 11:45:38 AM UTC-7, Scheme Lab wrote: > > Another thing: the wizard does not ask for, or create, certain settings > that are required by the code in models/db.py. so one cannot simply load > those settings and bind all values below: > > if not request.env.web2py_runt

[web2py] Re: Parent - Child (multiple rows / grid) form development

On Monday, July 10, 2017 at 9:15:08 PM UTC-7, Ramesh Meda wrote: > > Dave, Thank you and appreciated. But, my question was about forms and not > database. How could one develop a page that has one invoice row and > multiple item rows... > Like Stifan, I would use ajax/load/component stuff.

[web2py] Re: FOREIGN KEY constraint failed

I think the filename ends with .sqlite doesnt it? On Wednesday, July 5, 2017 at 3:07:46 AM UTC-4, Dave S wrote: > > > > On Tuesday, July 4, 2017 at 11:34:11 PM UTC-7, mostwanted wrote: >> >> Hey Santi, how do i go about doing that, deleting all the tables in the >> database backup folder? >> > >

[web2py] Foreign key constraint is incorrectly formed

Hello, I used the wizard for web2py to create an application. Initially web2py deployed to SQLite because of a bug in web2py where it uses AppConfig() to access the database instead of Storage . But after pointing web2py to my MySQL da

[web2py] Re: web2py 2.15.1 is OUT

One new feature is that in modern browsers (that support FormData), web2py Ajax components now support file uploads out of the box (no need for third-party plugins). Anthony On Monday, July 10, 2017 at 5:40:08 PM UTC-4, Massimo Di Pierro wrote: > > It took a year. Thanks to everybody who contri

Re: [web2py] web2py 2.15.1 is OUT

But 2.16.* would be good as support python3 is a major version... We could make things even more confusing by stating that web2py python3 supporting release will be web2py 3.00.* Imagine with all the web3py discussions haha! Just kidding, but I think version 3 is a good idea for this achievement,

Re: [web2py] web2py 2.15.1 is OUT

You right, my bad... On Tue, Jul 11, 2017 at 3:39 PM, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > The one released yesterday is 2.15.1. The next one will be 2.15.2. (2.16.2 > was a typo). > > > On Tuesday, 11 July 2017 11:11:58 UTC-5, Paolo wrote: >> >> There is a bit of confusion re

Re: [web2py] web2py 2.15.1 is OUT

No confusion : mdipierro R-2.15.1 Massimo's talk about releasing another version soon which will be 2.16.something Richard On Tue, Jul 11, 2017 at 12:11 PM, Paolo wrote: > There i

Re: [web2py] web2py 2.15.1 is OUT

The one released yesterday is 2.15.1. The next one will be 2.15.2. (2.16.2 was a typo). On Tuesday, 11 July 2017 11:11:58 UTC-5, Paolo wrote: > > There is a bit of confusion regarding release version, which one is > correct 2.15.* or 2.16.*? > The main features are python3/pypy3 support, perform

[web2py] Re: wizard database URL ignored by default models/0.py

Another thing: the wizard does not ask for, or create, certain settings that are required by the code in models/db.py. so one cannot simply load those settings and bind all values below: if not request.env.web2py_runtime_gae: #

[web2py] wizard database URL ignored by default models/0.py

I am using the stable source code version of web2py. I created an application via the wizard and specified a MySQL database URI at that time. Now, 2 days later, I went looking for my data and realized it is in storage.sqlite... why? Because the automatically-created models/db.py attempts to co

[web2py] Re: How to use FORM, INPUT to create a field with dropdown list?

Anthony, I just tested it again, form.widget.fieldname WORKS with _readonly. Earlier i had 'total' field defined in Field() with writable=True, somehow it didn't like it when i set this field _readonly= True. Thank you so much (also to Peter and Villas)! (I changed the test table to invoice) I

Re: [web2py] web2py 2.15.1 is OUT

There is a bit of confusion regarding release version, which one is correct 2.15.* or 2.16.*? The main features are python3/pypy3 support, performance improvements, few core fixes On Tuesday, July 11, 2017 at 2:13:52 PM UTC+2, Massimo Di Pierro wrote: > > check. I am sure there will be a 2.16.2

[web2py] Re: DAL pg8000 adapter and JSON type

pydal uses text for json fields if you're using pg8000 because pg8000 didn't use to support json. If you change to psicopg2 you need to convert the field manually as you did and then use psicopg2 consistently. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://g

[web2py] Re: How to use FORM, INPUT to create a field with dropdown list?

Hi Anthony, Sorry I was on another issue, took me away for 2 weeks from below matter. Actually i have no issue using SQLFORM, SQLFORM.factory, now I tried custom widget, it works well with dropdown box for customer field. The real goal is I have a field "total" in the quotation, its value d

Re: [web2py] web2py 2.15.1 is OUT

check. I am sure there will be a 2.16.2 soon. ;-) On Tuesday, 11 July 2017 06:20:35 UTC-5, Ricardo Pedroso wrote: > > I reported an issue (https://github.com/web2py/web2py/issues/1672) > with the 2.15.0b1 that still exists in 2.15.1 > > I think it was this pydal commit: > > https://github.com/w

Re: [web2py] web2py 2.15.1 is OUT

I reported an issue (https://github.com/web2py/web2py/issues/1672) with the 2.15.0b1 that still exists in 2.15.1 I think it was this pydal commit: https://github.com/web2py/pydal/commit/fedd0c75ff1f84ce863a8785b31c762d9c3e55af#diff-68220c912f02a03fd8bce58415479334R1642 Ricardo On 7/10/17, Massim

[web2py] Re: XMLHttpRequest error

Passed this issue I got to the same, after implementing that example above I put the views that I want on their right places all works ok until here. But now I face another problem. In those views I use a portlet with a scroller div, using this plugin: *jquery-slimscroll*. But in those views t

[web2py] Re: Parent - Child (multiple rows / grid) form development

in form side, everything in 1 page i usually use web2py load components: first component is an sqlform.factory() to select the invoice_items second component is a view for for invoice_item and third component is sqlform that rever to invoice_header ref: http://web2py.com/books/default/chapter/29/