Re: data format problem in MS Access
| From: | Teodor Cimpoesu | Date: | Fri, 07 Jul 2000 15:48:03 +0000 |
| Subject: | Re: data format problem in MS Access | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-952@lists.php.net to get a copy of this message | ||
Hi Vojt?ch!
On Fri, 07 Jul 2000, Vojt?ch Dvo?ák wrote:
> 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?
WHERE RANumber = 6280 ?
-- teodor