Link to home
Start Free TrialLog in
Avatar of kennethan
kennethan

asked on

Data Type of Character in FoxPro and VB datatype

My program code,

objCms.Find "code = " & strCode

objcms is recordset reading from FoxPro dbf file. "code" field in dbf table is characters(6) datatype. And strCode in VB is string datatype. The system gives an error message saying "Type mismatch..". How can I solve this type mismatch problem?
Avatar of Dxpert
Dxpert
Flag of United States of America image

Are you sure that the Data Type for the field "CODE" is "Character", it seems to me that it is a "Numeric" field.
..also, just make sure that strCode is a character string.
ASKER CERTIFIED SOLUTION
Avatar of TimCottee
TimCottee
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of kennethan
kennethan

ASKER

Adjusted points from 15 to 20