[web2py] Re: mssql legacy tables reference

it WORKS now :-) I was playing with it and suddenly it is OK. I dont know what it was, I believe " vs ' these are working definitions: db.define_table("Mjesta", Field ("PostanskiBroj", "integer",notnull=True,unique=True), Field

[web2py] Re: mssql legacy tables reference

what if you don't use requires=IS_EMPTY() ? On Friday, October 3, 2014 8:52:12 AM UTC+2, Alen Cerovic wrote: > > is there any resolution to this, any ideas, or are there plans to make it > work in future? > > Dana ponedjeljak, 29. rujna 2014. 12:26:11 UTC+2, korisnik Alen Cerovic > napisao je: >

[web2py] Re: mssql legacy tables reference

is there any resolution to this, any ideas, or are there plans to make it work in future? Dana ponedjeljak, 29. rujna 2014. 12:26:11 UTC+2, korisnik Alen Cerovic napisao je: > > Hi pn, I am expecting dropdown list of Mjesta when I add/edit record in > Partneri > tried putting 'requires' Field

[web2py] Re: mssql legacy tables reference

Hi pn, I am expecting dropdown list of Mjesta when I add/edit record in Partneri tried putting 'requires' Field ('Mjesto','reference Mjesta.PostanskiBroj',requires=IS_NOT_EMPTY *()) *but n

[web2py] Re: mssql legacy tables reference

I just asked if the primary key is integer yet the answer was in front of me, except I don't know if it is an identity field. Because your primary key may look like a standard web2py id field, perhaps you can use the 'id' parameter instead of 'primarykey' -- Resources: - http://web2py.com - ht

[web2py] Re: mssql legacy tables reference

Is the legacy primary key an integer or even better an auto - incrementing integer? -- 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 mes

[web2py] Re: mssql legacy tables reference

Can you provide some clarification on what behavior are you expecting but not seeing when you create the reference? For example, are you able to create entries in the 'Partneri' table that refer keys not in the 'Mjesta' table? A quick workaround would be to put in a 'requires' lambda into the f

[web2py] Re: mssql legacy tables reference

tried 'reference Mjesta' - no error but also nothing happens 'reference PostanskiBroj' - Query Not Supported: 'DAL' object has no attribute 'PostanskiBroj' I did not dive in source code but is it difficult to make references between legacy tables reliable. From my perspective it is very importan

[web2py] Re: mssql legacy tables reference

'reference Mjesta.PostanskiBroj'* should be *'reference PostanskiBroj' *but I would not swear by references for legacy keyed tables.* On Thursday, 25 September 2014 11:58:21 UTC-5, Alen Cerovic wrote: > > Hi, > > I am totaly new to web2py, actually started yesterday :) > I am trying to work with