BuildCriteria: Invalid Data Type

[jgoodman00]

Ok, I am attempting to use this, to parse a criteria string:
strWhere = strWhere & strJoinType & (BuildCriteria(strField, strFieldType, strExpression))
This works fine, until it encounters a varchar datatype (ADO.DataTypeEnum = adVarChar or 200). At this point it errors, stating 'Invalid Data Type'.

An example of the contents of the BuildCriteria string are as follows:
BuildCriteria("NewFenceType","200","GP24&quot

I have also tried assigning strFieldType as an Integer, but it makes no difference.

If I use the query designer grid I get no error.

James Goodman MCP

http://www.james-goodman.co.uk

 

[beetee]

My guess is that the BuildCriteria function has not kept up with additional datatypes.

You can probably make a VBA wrapper function that maps adVarChar into some complimentary type and then calls BuildCriteria.