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?
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?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Adjusted points from 15 to 20