It worked when I specified single prymarykey. It's kind of make sense but
why it worked previously and not working current?
db.PDTFF.FFKNCD.requires=IS_NULL_OR(IS_IN_DB(db,db.TDMKNP00.KNKNCD,'%(KNKNNM)s'))
*After*
# Area 2 Master
db.define_table('TDMKNP00',
Field('KNCTCD', length=3),
Field('KNKNCD', length=2),
Field('KNKNNM', length=30),
primarykey=['KNKNCD'])
*Before*
# Area 2 Master
db.define_table('TDMKNP00',
Field('KNCTCD', length=3),
Field('KNKNCD', length=2),
Field('KNKNNM', length=30),
primarykey=['KNCTCD','KNKNCD'])
On Friday, October 19, 2012 3:48:53 PM UTC-5, Omi Chiba wrote:
>
> It looks this line failed. Here I simply edit the record provided by
> user's select.
>
> form = SQLFORM(db.PDTFF,record)
>
>
> On Friday, October 19, 2012 3:27:53 PM UTC-5, Omi Chiba wrote:
>>
>> My app was working fine with Version 1.99.2. I upgrade to Version 2.1.1
>> and it shows this error.
>> I'm using DB2 for my database. PDTFF is new table defined by web2py so it
>> has id field but the others are existing and doesn't have id field.
>>
>> *Traceback (most recent call last):*
>> File "C:\web2py\gluon\restricted.py", line 209, in restricted
>> exec ccode in environment
>> File "C:/web2py/applications/fedex/controllers/default.py", line 205,
>> in <module>
>> File "C:\web2py\gluon\globals.py", line 187, in <lambda>
>> self._caller = lambda f: f()
>> File "C:\web2py\gluon\tools.py", line 2838, in f
>> return action(*a, **b)
>> File "C:/web2py/applications/fedex/controllers/default.py", line 116,
>> in next
>> form = SQLFORM(db.PDTFF,record)
>> File "C:\web2py\gluon\sqlhtml.py", line 1038, in __init__
>> inp = self.widgets.options.widget(field, default)
>> File "C:\web2py\gluon\sqlhtml.py", line 226, in widget
>> options = requires[0].options()
>> File "C:\web2py\gluon\validators.py", line 2500, in _options
>> options = self.other.options()
>> File "C:\web2py\gluon\validators.py", line 484, in options
>> self.build_set()
>> File "C:\web2py\gluon\validators.py", line 471, in build_set
>> records = self.dbset(table).select(*fields, **dd)
>> File "C:\web2py\gluon\dal.py", line 8726, in __call__
>> query = self.db._adapter.id_query(query)
>> File "C:\web2py\gluon\dal.py", line 631, in id_query
>> return table._id != None
>> File "C:\web2py\gluon\dal.py", line 7636, in __getitem__
>> return ogetattr(self, str(key))
>> AttributeError: 'Table' object has no attribute '_id'
>>
>> *Function argument list*
>> (self=<Table TDMKNP00 (KNCTCD,KNKNCD,KNKNNM)>, key='_id')
>>
>> *Model*
>> # coding: utf8
>>
>> # Employee info table on HELPDESK
>> dbh.define_table('tbluser',
>> Field('name', length=255),
>> Field('location', length=255),
>> Field('emailaddress', length=255))
>>
>> # Dept Master
>> db.define_table('TDMBUP01',
>> Field('BUSEC1', length=3),
>> Field('BUBURK', length=12),
>> primarykey=['BUSEC1'])
>>
>> # Country Master
>> db.define_table('TDMCNP00',
>> Field('CNCNCD', length=3),
>> Field('CNCNNM', length=30),
>> primarykey=['CNCNCD'])
>>
>> # Area 2 Master
>> db.define_table('TDMKNP00',
>> Field('KNCTCD', length=3),
>> Field('KNKNCD', length=2),
>> Field('KNKNNM', length=30),
>> primarykey=['KNCTCD','KNKNCD'])
>>
>> # Purchase Order
>> db.define_table('SDTH2P01',
>> Field('H2DNO', length=8),
>> Field('H2TRD1', 'integer'),
>> Field('H2JJDN', length=8),
>> Field('H2JJGN', 'integer'),
>> Field('H2JDNO', length=8),
>> Field('H2JGNO', 'integer'),
>> Field('H2JCSC', length=3),
>> Field('H2HSKB', length=1),
>> Field('H2KSM', length=3),
>> Field('H2PRCD', length=15),
>> Field('H2PRKJ', length=50),
>> Field('H2TRS', 'integer'),
>> Field('H2HZS', 'integer'),
>> primarykey=['H2DNO'])
>>
>> # Open FedEx Purchase Order
>> db.define_table('SDTH2PF1',
>> Field('H2DNO', length=8),
>> Field('H2TRD1', 'integer'),
>> Field('H2JJDN', length=8),
>> Field('H2JJGN', 'integer'),
>> Field('H2JDNO', length=8),
>> Field('H2JGNO', 'integer'),
>> Field('H2JCSC', length=3),
>> Field('H2HSKB', length=1),
>> Field('H2KSM', length=3),
>> Field('H2PRCD', length=15),
>> Field('H2PRKJ', length=50),
>> Field('H2TRS', 'integer'),
>> Field('H2HZS', 'integer'),
>> primarykey=['H2DNO'])
>>
>> # Received Order
>> db.define_table('SDTJ2P00',
>> Field('J2DNO', length=8),
>> Field('J2GNO', 'integer'),
>> Field('J2TSCD',length=8),
>> Field('J2TSK1',length=35),
>> Field('J2TSK2',length=35),
>> Field('J2TSPE',length=22),
>> Field('J2ODA1',length=30),
>> Field('J2ODA2',length=30),
>> Field('J2ODA7',length=20),
>> Field('J2KNCD',length=2),
>> Field('J2CNCD',length=3),
>> Field('J2OYUB',length=10),
>> Field('J2OTEL',length=20),
>> Field('J2KYSC',length=12),
>> Field('J2NSD','integer'),
>> primarykey=['J2DNO','J2GNO'])
>>
>> # FedEx Request Output file
>> db.define_table('PDTFF',
>> Field('FFDNO', length=8, label='HJ#'),
>> Field('FFTRD', 'date', label="Requested"),
>> Field('FFJCSC', length=3, label="Dept"),
>> Field('FFBURK', length=12, label="Dept Name"),
>> Field('FFJDNO', length=8, label="JJ#"),
>> Field('FFJGNO', 'integer', label="JJ line#"),
>> Field('FFJJDN', length=8, label="J# (JP)"),
>> Field('FFJJGN', 'integer', label="J line# (JP)"),
>> Field('FFACCT', length=9, label="FedEx Acct #"),
>> Field('FFCUST', length=30, label="Company Name"),
>> Field('FFNSD', 'date',label="Delivery Due"),
>> Field('FFPRCD', length=15,label="Product Code"),
>> Field('FFPRKJ', length=50,label="Part Number"),
>> Field('FFTRS', 'integer',label="Quantity"),
>> Field('FFTSK1',length=35,label="Name 1"),
>> Field('FFTSK2',length=35,label="Name 2"),
>> Field('FFTSPE',length=22,label="Attn:"),
>> Field('FFODA1',length=30,label="Address 1"),
>> Field('FFODA2',length=30,label="Adderss 2"),
>> Field('FFODA7',length=20,label="City"),
>> Field('FFKNCD',length=2,label="State"),
>> Field('FFCNCD',length=3,label="Country"),
>> Field('FFOYUB',length=10,label="Zip"),
>> Field('FFOTEL',length=20,label="Phone"),
>> Field('FFKYSC',length=12,label="Customer Order#"),
>> Field('FFSPCL','boolean',label="Special Instruction"),
>> Field('FFJPKB','boolean',label="JP Confirmed"),
>> Field('FFRMKS',length=128,label="Remarks"),
>> Field('FFCUSR',length=128,label="Created by"),
>> Field('FFCDAT','datetime',label="Created on"),
>> Field('FFUUSR',length=128,label="Updated by"),
>> Field('FFUDAT','datetime',label="Updated on"),
>> )
>>
>> db.PDTFF.FFDNO.writable = False
>> db.PDTFF.FFTRD.writable = False
>> db.PDTFF.FFTRD.requires=IS_DATE(format='%m/%d/%y')
>> db.PDTFF.FFJCSC.writable = False
>> db.PDTFF.FFBURK.writable = False
>> db.PDTFF.FFJDNO.writable = False
>> db.PDTFF.FFJGNO.writable = False
>> db.PDTFF.FFJJDN.writable = False
>> db.PDTFF.FFJJGN.writable = False
>> db.PDTFF.FFPRCD.writable = False
>> db.PDTFF.FFPRKJ.writable = False
>> db.PDTFF.FFACCT.requires=[IS_NOT_EMPTY(),IS_UPPER(),IS_LENGTH(9,9,error_message='enter
>>
>> 9 characters'),IS_UPPER()]
>> db.PDTFF.FFCUST.requires=[IS_NOT_EMPTY(),IS_LENGTH(30,1),IS_UPPER()]
>> db.PDTFF.FFNSD.requires=IS_DATE(format='%m/%d/%y',error_message='enter
>> date as mm/dd/yy')
>> db.PDTFF.FFTRS.requires=IS_INT_IN_RANGE(1,99999999,error_message='Cannot
>> exceed 99,999,999')
>>
>> db.PDTFF.FFTSK1.requires=[IS_NOT_EMPTY(),IS_LENGTH(35,1),IS_UPPER()]
>> db.PDTFF.FFTSK2.requires=IS_NULL_OR([IS_LENGTH(35,1),IS_UPPER()])
>> db.PDTFF.FFTSPE.requires=IS_NULL_OR([IS_LENGTH(22,1),IS_UPPER()])
>> db.PDTFF.FFODA1.requires=[IS_NOT_EMPTY(),IS_LENGTH(30,1),IS_UPPER()]
>> db.PDTFF.FFODA2.requires=IS_NULL_OR([IS_LENGTH(30,1),IS_UPPER()])
>> db.PDTFF.FFODA7.requires=[IS_NOT_EMPTY(),IS_LENGTH(20,1),IS_UPPER()]
>> # Dropdown list from Area 2 Master
>>
>> db.PDTFF.FFKNCD.requires=IS_NULL_OR(IS_IN_DB(db,'TDMKNP00.KNKNCD','%(KNKNNM)s'))
>> db.PDTFF.FFOYUB.requires=[IS_NOT_EMPTY(),IS_LENGTH(20,1),IS_UPPER()]
>> # Dropdown list from Country Master
>> db.PDTFF.FFCNCD.requires=IS_IN_DB(db,'TDMCNP00.CNCNCD','%(CNCNNM)s')
>> db.PDTFF.FFOTEL.requires=[IS_NOT_EMPTY(),IS_LENGTH(20,1),IS_UPPER()]
>> db.PDTFF.FFKYSC.requires=[IS_NOT_EMPTY(),IS_LENGTH(12,1),IS_UPPER()]
>> db.PDTFF.FFJPKB.writable = False
>> db.PDTFF.FFRMKS.requires=IS_NULL_OR([IS_LENGTH(128,1),IS_UPPER()])
>> db.PDTFF.FFCUSR.writable = False
>> db.PDTFF.FFCDAT.writable = False
>> db.PDTFF.FFCDAT.requires=IS_DATETIME(format='%m/%d/%y %H:%M:%S')
>> db.PDTFF.FFUUSR.writable = False
>> db.PDTFF.FFUDAT.writable = False
>> db.PDTFF.FFUDAT.requires=IS_DATETIME(format='%m/%d/%y %H:%M:%S')
>>
>> *Controller*
>> def next():
>> keyHJ = request.args(0) or redirect(URL('index'))
>> record = db.PDTFF(db.PDTFF.FFDNO==keyHJ)
>>
>> hj = db.SDTH2P01(db.SDTH2P01.H2DNO==keyHJ)
>>
>> # Get information from purcharse order transaction
>> db.PDTFF.FFDNO.default = hj.H2DNO.strip()
>> db.PDTFF.FFPRCD.default = hj.H2PRCD.strip()
>> db.PDTFF.FFPRKJ.default = hj.H2PRKJ.strip()
>> db.PDTFF.FFTRS.default = int(hj.H2TRS)
>> db.PDTFF.FFJJDN.default = hj.H2JJDN.strip()
>> db.PDTFF.FFJJGN.default = hj.H2JJGN
>> db.PDTFF.FFJDNO.default = hj.H2JDNO.strip()
>> db.PDTFF.FFJGNO.default = hj.H2JGNO
>> db.PDTFF.FFJCSC.default = hj.H2JCSC.strip()
>>
>> # Get Dept name
>> if hj.H2JCSC<>"":
>> bu = db.TDMBUP01(db.TDMBUP01.BUSEC1==hj.H2JCSC)
>> db.PDTFF.FFBURK.default = bu.BUBURK.strip() or None
>>
>> key1 = hj.H2JDNO
>> key2 = hj.H2JGNO
>>
>> jj = db.SDTJ2P00((db.SDTJ2P00.J2DNO==key1) &
>> (db.SDTJ2P00.J2GNO==key2))
>>
>> # Get Received Order information if exist
>> if jj <> None:
>> db.PDTFF.FFKYSC.default = jj.J2KYSC.strip()
>> db.PDTFF.FFTSK1.default = jj.J2TSK1.strip()
>> db.PDTFF.FFTSK2.default = jj.J2TSK2.strip()
>> db.PDTFF.FFTSPE.default = jj.J2TSPE.strip()
>> db.PDTFF.FFODA1.default = jj.J2ODA1.strip()
>> db.PDTFF.FFODA2.default = jj.J2ODA2.strip()
>> db.PDTFF.FFODA7.default = jj.J2ODA7.strip()
>> db.PDTFF.FFKNCD.default = jj.J2KNCD.strip()
>> db.PDTFF.FFOYUB.default = jj.J2OYUB.strip()
>> db.PDTFF.FFCNCD.default = jj.J2CNCD.strip()
>> db.PDTFF.FFOTEL.default = jj.J2OTEL.strip()
>>
>> import datetime
>> y = int(str(jj.J2NSD)[0:4])
>> m = int(str(jj.J2NSD)[4:6])
>> d = int(str(jj.J2NSD)[6:8])
>> db.PDTFF.FFNSD.default = datetime.date(y, m, d)
>>
>> # Login User and current date
>> user = dba.auth_user(auth.user_id)
>> db.PDTFF.FFCUSR.default = user.username.upper()
>> db.PDTFF.FFCDAT.default = request.now
>> db.PDTFF.FFTRD.default = request.now.date
>>
>> # Form editable or readonly
>> if record == None and hj.H2HZS>0: # New entry
>> form = SQLFORM(db.PDTFF,record)
>> form.vars.FFUUSR = user.username.upper()
>> form.vars.FFUDAT = request.now
>>
>> if request.vars.FFSPCL == 'on': # Automatically set JP Checked if
>> not Special Instruction
>> form.vars.FFJPKB = False
>> else:
>> form.vars.FFJPKB = True
>>
>> elif record <> None and record.FFJPKB<>True and hj.H2HZS>0: # Update
>> when JP Chcked is unchcked
>> # Only editable by Admin
>> if auth.has_membership(role = 'admin'):
>> db.PDTFF.FFJPKB.writable = True
>>
>> form = SQLFORM(db.PDTFF,record)
>> form.vars.FFUUSR = user.username.upper()
>> form.vars.FFUDAT = request.now
>>
>> elif record <> None and record.FFJPKB==True and hj.H2HZS>0 and
>> auth.has_membership(role = 'admin'): # Update when JP Chcked is chcked.
>> Only Admin can edit the form
>> db.PDTFF.FFJPKB.writable = True
>> form = SQLFORM(db.PDTFF,record)
>> form.vars.FFUUSR = user.username.upper()
>> form.vars.FFUDAT = request.now
>>
>> else:
>> form = SQLFORM(db.PDTFF,record, readonly=True) # Read only
>>
>> if form.process(onvalidation=spcheck).accepted:
>> session.flash = 'Form accepted'
>> redirect(URL(request.args(1)))
>> elif form.errors:
>> response.flash = 'Form has errors'
>> return dict(form=form)
>>
>>
>>
>>
>>
>>
>>
--
