RE: Wierd Access obnomolies

I would have thought so too, but Access puts them in for me...


-----Original Message-----
From: Nick Cranham [mailto:hkf1@xxxxxxxxxxxxxx]
Sent: 31 March 2004 12:35
To: myodbc@xxxxxxxxxxxxxxx
Subject: RE: Wierd Access obnomolies


Chris,
I'm no expert, but if the field is decimal, don't you need to use numeric
values, i.e. no quote marks (').

NickHK

> -----Original Message-----
> From: Chris Tate-Davies [mailto:chris.tatedavies@xxxxxxxxxx]
> Sent: Wednesday, March 31, 2004 7:07 PM
> To: myodbc@xxxxxxxxxxxxxxx
> Subject: Wierd Access obnomolies
>
>
> Hi there, I have an Access 97 database with some linked tables from mySQL
> (4.0.18.nt)
>
> One of the fields in one of the tables is a decimal (8,4) field with some
> currencies in, and when I do the following query I get some matches:
>
> select * from schedules where amount = '0';
>
> But, if I use this query it affects no records:
>
> update schedules set amount = '20' where amount = '0';
>
> What is the difference between an update and an insert when it comes down
to
> the WHERE clause????
>
> thanks, Chris
>
>       Chris Tate-Davies Tel: 01608 647 651
>       Technical Manager Email: chris.tatedavies@xxxxxxxxxx
>       CETA Limited Web: www.ceta.co.uk
>
> ---
> Incoming mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.624 / Virus Database: 401 - Release Date: 15-Mar-04
>
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.624 / Virus Database: 401 - Release Date: 15-Mar-04


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:
http://lists.mysql.com/myodbc?unsub=chris.tatedavies@xxxxxxxxxx


-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@xxxxxxxxxxx