Ok..I started playing around with an empty and smaller database for the
sake of speed. This is what I have:
db.define_table('supplier',
Field('suppliercode'),
Field('suppliername'),
format='%(suppliercode)s')
db.supplier.suppliercode.requires =
IS_NOT_IN_DB(db,db.supplier.suppliercode)
db.supplier.suppliername.requires =
IS_NOT_IN_DB(db,db.supplier.suppliername)
db.define_table('series',
Field('supplier','reference supplier'),
Field('seriesname'),
Field('seriesdescription'))
db.series.supplier.requires = IS_IN_DB(db,db.supplier.id,'%(suppliername)s')
db.define_table('product',
Field('series', 'reference series'),
Field('supplier', 'reference series',compute=lambda row:
db.series(row.series).supplier),
Field('supptile', 'reference supplier',compute=lambda row:
db.series(row.series).supplier),
Field('tilename'))
db.product.series.requires =
IS_EMPTY_OR(IS_IN_DB(db,db.series.id,'%(seriesname)s'))
I want to concatenate/compute db.product.supptile with db.product.tilename
..Is is possible?? .
On Thursday, July 11, 2013 11:50:07 AM UTC-7, Anthony wrote:
>
> Oops, sorry, I read that wrong -- thought it was a "represent" function
> rather than a "compute" function. Yes, not sure you want to store a value
> other than the db.series.id value in a reference field for db.series.
>
> Anthony
>
> On Thursday, July 11, 2013 2:39:39 PM UTC-4, Richard wrote:
>>
>> But in this case you don't have the id of the referenced record as
>> relation key... I am not sure it's what you want. But you question is
>> really vague so difficult to answer correctly to your I think :P
>>
>> Richard
>>
>>
>> On Thu, Jul 11, 2013 at 2:21 PM, Anthony <[email protected]> wrote:
>>
>>> On Thursday, July 11, 2013 1:21:11 PM UTC-4, greenpoise wrote:
>>>
>>>> I think I saw some light in here! this did the trick for me:
>>>>
>>>> Field('supplier', 'reference supplier',compute=lambda row: db.series(
>>>> row.series).supplier**),
>>>>
>>>
>>> Should be the same as:
>>>
>>> lambda row: row.series.supplier
>>>
>>> assuming row.series is a reference field referring to db.series.
>>>
>>> Anthony
>>>
>>> --
>>>
>>> ---
>>> 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.
>>>
>>>
>>>
>>
>>
--
---
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.
