Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
Highlighted
Copper Elite Contributor
Posts: 39
Registered: ‎04-14-2009

Bug when assigning multiple serial numbers on add/edit account asset screen

Just been burnt by the this,

 

In version 7.5.4 System:Add Edit Account Asset, lines 101 to 103 the parameters for defining the fields are the wrong way round resulting in the fields max length always been 32 characters

 

objRS.Fields.Append "ACTUALID", adVarChar, adFldIsNullable, 64 'DNL
objRS.Fields.Append "PRODUCTNAME", adVarChar, adFldIsNullable, 64 'DNL
objRS.Fields.Append "SERIALNUMBER", adVarChar, adFldIsNullable, 80 'DNL

 

should be

 

objRS.Fields.Append "ACTUALID", adVarChar, 64, adFldIsNullable 'DNL
objRS.Fields.Append "PRODUCTNAME", adVarChar, 64, adFldIsNullable 'DNL
objRS.Fields.Append "SERIALNUMBER", adVarChar, 80, adFldIsNullable 'DNL

 

the adFldIsNullable constant is 20 in hex ie 32 in decimal hence the limit

 

 

it now makes me think there may be more hidden bugs like this in the scripts

 

 

Highlighted
Gold Super Contributor
Posts: 3,087
Registered: ‎03-19-2009

Re: Bug when assigning multiple serial numbers on add/edit account asset screen

You can bet there are more.. 

--
RJ Ledger - rjledger@rjlSystems.net +1 603.369.3047 x101

".. Innovators in Mobility - Experts in Workflow Automation..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html