Hmmm... I think your model is wrong...
You can't use a compute on a reference field..
What you are trying to do exactly?
Why you need to concatenate thing? For representation purpose?
I think I really can help you what you need is easy but I can't understand
your goal from the model you posted...
Richard
On Thu, Jul 11, 2013 at 4:12 PM, greenpoise <danel.sega...@gmail.com> wrote:
> 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 <abas...@gmail.com> 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 web2py+un...@googlegroups.com.
>>>> For more options, visit
>>>> https://groups.google.com/**groups/opt_out<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 web2py+unsubscr...@googlegroups.com.
> 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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
