Search: Advanced search
Please enter a keyword or ID
Helix ALM Type Mismatch ODBC Error
When querying in a Microsoft Access database that links to a Helix ALM project with custom fields, the following error is returned:
'Type mismatch in expression'
The CUSTMVAL.CUSTVALUE is a pop-up custom field and was not converted to an integer prior to comparing against the FLDCUSTM.IDRECORD.
To query a pop-up custom field using ODBC, the CUSTVALUE field type must be changed to an integer. The following Access query example shows you how to change the field type.
The example query includes a Cint command in the 'Where' clause. The Cint command changes the CUSTVALUE field in this query to an integer so it can be compared against the IDRECORD field of the FLDCUSTM Table. This query assumes you want information for one custom field.
Check the CUSTMDEF table for the IDRECORD value of the custom field you want to query. Make sure you change the CUSTMVAL.IDCUSTREC field to return the correct custom field.