data format problem in MS Access
| From: | Vojtěch Dvořák | Date: | Fri, 07 Jul 2000 13:19:05 +0000 |
| Subject: | data format problem in MS Access | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-937@lists.php.net to get a copy of this message | ||
Hi,
I have a problem with very basic thing.
When I will use this statement: "SELECT RANumber, DateCall, ProductType,
ModelNumber
FROM TabTest
WHERE RANumber like '6280' "
Everything works fine if "RANumber" is in Text format in MS Access. When I
change "RANumber" to Number format it gives me this message: "ODBC Error:
22005: [Microsoft][ODBC Microsoft Access 97 Driver] Data type mismatch in
criteria expression."
Ok, I can change format type of this column in my database, but isn't there
any other solution?
Thanks
Vojtech