Re: Filemaker 7 ODBC Select
Ok, this seems to be what the problem was...
UPDATE FMTable SET Date1 = { D '2004-01-01' } WHERE ID = 5
For some reason, if i had FM 7 developer open (so i could see the
chagnes to the data in the table), that statement set the date field to
?. Why the same format worked when the data was inserted is beyond
me...but using that date format for an update doesn't work.
The solution was to use DATE '2004-01-04'
Andy
.
Relevant Pages
- Re: Information Store - Can I wipe the priv1.edb file?
... >>>Thanks Andy, I've just tried that, but it won't create the new files, do ... >>>know of any reason why?? ... there's plenty there for me to check out! ... Prev by Date: ...
(microsoft.public.exchange.admin) - Re: How long on tourist Visa ??
... > ANDY ... They probably had B2's, difficult to get if you can otherwise use a VWP, ... but possible for that reason, especially if you are obviously retired. ... Prev by Date: ...
(misc.immigration.usa) - Re: RAND 2005 Personality Week 2
... I'm going to vote for him as well - and for ... exactly the same reason. ... Andy ... Prev by Date: ...
(rec.arts.marching.drumcorps) - So, what is Mandy Moore up to these days?
... I don't think she's released a CD or movie since the breakup with ... Is Andy the reason for her fall-off...? ... Prev by Date: ...
(rec.sport.tennis) - Re: Why it do dat?
... combined inertia would eventually slow the earth's rotation, ... that's the main reason we have to switch to Daylight ... Anytime man interfere's with the environment, some provision has ... Andy in Eureka, Texas ...
(soc.senior.issues) |
|
