Hi pn, I am expecting dropdown list of Mjesta when I add/edit record in
Partneri
tried putting 'requires' Field
<http://127.0.0.1:8000/examples/global/vars/Field>('Mjesto','reference
Mjesta.PostanskiBroj',requires=IS_NOT_EMPTY
<http://127.0.0.1:8000/examples/global/vars/IS_NOT_EMPTY>*()) *but no
dropdown
Dana nedjelja, 28. rujna 2014. 20:29:50 UTC+2, korisnik pn napisao je:
> 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
> field definition in the Partneri table. This way you can define your own
> custom rules.
>
> On Saturday, September 27, 2014 2:51:31 AM UTC-4, Alen Cerovic wrote:
>>
>> 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 important
>> as many web projects does not start from scratch.
>>
>> Dana subota, 27. rujna 2014. 08:01:22 UTC+2, korisnik Massimo Di Pierro
>> napisao je:
>>
>>> '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 legacy mssql database and having problems in
>>>> referencing two legacy keyed tables
>>>>
>>>> db.define_table('Mjesta',
>>>> Field <http://127.0.0.1:8000/examples/global/vars/Field>(
>>>> 'PostanskiBroj','integer',notnull=True,unique=True),
>>>> Field <http://127.0.0.1:8000/examples/global/vars/Field>('Naziv'),
>>>> primarykey=['PostanskiBroj'],
>>>> migrate=False)
>>>>
>>>> db.define_table('Partneri',
>>>> Field <http://127.0.0.1:8000/examples/global/vars/Field>('Sifra',
>>>> 'integer'),
>>>> Field <http://127.0.0.1:8000/examples/global/vars/Field>('Naziv'),
>>>> Field
>>>> <http://127.0.0.1:8000/examples/global/vars/Field>('Mjesto','reference
>>>> Mjesta.PostanskiBroj'),
>>>> primarykey=['Sifra'],
>>>> migrate=False)
>>>>
>>>> no errors but field Partneri.Mjesto does not reference
>>>> Mjesta.PostanskiBroj
>>>>
>>>> What am I doing wrong?
>>>>
>>>>
--
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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
