Please open a ticket pointing to this thread. Will look at it asap.
On Friday, 17 August 2012 17:33:51 UTC-5, Omi Chiba wrote:
>
> I finally figured this should be a bug on the current in trunk version
> ("Version 2.0.0 (2012-08-15 17:30:38) dev")
>
> I can pull the data when the data in primarykey field begin with numeric
> numbers for example 12345 or 1ABCDE (See NG-1,2.jpg)
> but cannot pull the data begin with alphabet like A1234. (See OK-1,2.jpg)
>
>
> # MF - EDI CUSTOMER
> db.define_table('EDMACF00',
> Field('ACDIID', length=5, label="Dist Code"),
> Field('ACNAME', length=20, label="Dist Name"),
> Field('AC855F', length=1, label="PO ACK FLAG"),
> Field('AC856F', length=1, label="ASN FLAG"),
> Field('AC810F', length=1, label="INVOICE FLAG"),
> Field('ACUPFL', length=1, label="OZ UPLOAD FLAG"),
> Field('ACCRBY', length=20, default = auth.user.username.upper() if
> auth.user else None, label="Created by"),
> Field('ACCRDT', 'datetime', default =request.now, label="Created on"),
>
> Field('ACUPBY', length=20, update = auth.user.username.upper() if
> auth.user else None, label="Updated by"),
> Field('ACUPDT', 'datetime', update =request.now, label="Updated on"),
> primarykey=['ACDIID'])
>
> db.EDMACF00.ACDIID.requires=[IS_NOT_EMPTY(),IS_LENGTH(5,1),IS_UPPER()]
> db.EDMACF00.ACNAME.requires=[IS_NOT_EMPTY(),IS_LENGTH(20,1),IS_UPPER()]
> db.EDMACF00.AC855F.requires=IS_IN_SET(['','1'], zero=None)
> db.EDMACF00.AC856F.requires=IS_IN_SET(['','1'], zero=None)
> db.EDMACF00.AC810F.requires=IS_IN_SET(['','1'], zero=None)
> db.EDMACF00.ACUPFL.writable = db.EDMACF00.ACUPFL.readable = False
> db.EDMACF00.ACCRBY.writable = False
> db.EDMACF00.ACCRDT.writable = False
> db.EDMACF00.ACUPBY.writable = False
> db.EDMACF00.ACUPDT.writable = False
>
> # XR - CUSTOMER
> db.define_table('EDXTKF00',
> Field('TKDIID', length=5, label="Dist Code"),
> Field('TKDICD', length=20, label="Dist Office Code"),
> Field('TKTKSC', length=3, label="Dept"),
> Field('TKTKCD', length=8, label="Customer Code"),
> Field('TKDMCD', 'integer', label="Employee Code"),
> Field('TKUPFL', length=1, label="OZ UPLOAD FLAG"),
> Field('TKCRBY', length=20, default = auth.user.username.upper() if
> auth.user else None, label="Created by"),
> Field('TKCRDT', 'datetime', default =request.now, label="Created on"),
>
> Field('TKUPBY', length=20, update = auth.user.username.upper() if
> auth.user else None, label="Updated by"),
> Field('TKUPDT', 'datetime', update =request.now, label="Updated on"),
>
> primarykey=['TKDIID', 'TKDICD'])
>
> db.EDXTKF00.TKDIID.requires=IS_IN_DB(db,db.EDMACF00.ACDIID,'%(ACNAME)s')
> db.EDXTKF00.TKDICD.requires=[IS_NOT_EMPTY(),IS_LENGTH(20,1),IS_UPPER()]
>
> db.EDXTKF00.TKTKSC.requires=IS_IN_SET(['J11','J13','J14','J15','J16','J17'])
>
> db.EDXTKF00.TKTKCD.requires=[IS_NOT_EMPTY(),IS_LENGTH(8,8),IS_UPPER(),IS_IN_DB(db,db.CDMTKL00.TKTSCD)]
> db.EDXTKF00.TKDMCD.requires=[IS_NOT_EMPTY(),IS_INT_IN_RANGE(60000,69999,error_message='Invalid
>
> length'),IS_IN_DB(db,db.CDMSYL00.SYSYCD)]
> db.EDXTKF00.TKUPFL.writable = db.EDXTKF00.TKUPFL.readable = False
> db.EDXTKF00.TKCRBY.writable = False
> db.EDXTKF00.TKCRDT.writable = False
> db.EDXTKF00.TKUPBY.writable = False
> db.EDXTKF00.TKUPDT.writable = False
>
>
> On Friday, August 17, 2012 4:38:00 PM UTC-5, Omi Chiba wrote:
>>
>> Just in case, I changed just like you suggested but I got a same result.
>> I can pull the data from other tables on the same database but I cannot
>> pull the data from this one.... I should be dreaming or getting crazy... :
>> (
>>
>> I first doubt a simple typo but I can't figure out.
>>
>> db.EDXTKF00.TKDIID.requires=IS_IN_DB(db,db.EDMACF00.ACDIID)
>> =>
>> db.EDXTKF00.TKDIID.requires=IS_IN_DB(db,'EDMACF00.ACDIID')
>>
>> On Friday, August 17, 2012 4:20:42 PM UTC-5, villas wrote:
>>>
>>> Specify the field that you wish to appear in the dropdown box
>>> Try what the book says, 'name' is simply the name of the field you wish
>>> to appear:
>>>
>>> db.dog.owner.requires = IS_IN_DB(db, 'person.id', '%(name)s',
>>> zero=T('choose one'))
>>>
>>>
--
