Projectwise BS1192 template

In ProjectWise the Project Properties Project Number is an alpha numeric field.

 

When using the BS1192 template attributes to filter rows from the lkp_fi_attributes database table using the project number as the criteria against the tables o_projectno field, if the project number has characters in the returned results will be empty.  This is because the o_projectno field type is set as an integer.  Is it possible to change the o_projectno type to a varchar without affecting any other parts of the BS1192 template, i.e. stored procedures?

Parents Reply Children
No Data