No problem Bill. I still refer to your and David’s SQL book almost monthly.
Claudine
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of
Bill Downall
Sent: Friday, May 25, 2018 1:31 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Blank date value
So sorry. I
So sorry. I jumped in to the middle of the conversation, and missed the
main details.
(sent from Moto Z)
On Fri, May 25, 2018, 8:34 AM karentellef via RBASE-L <
rbase-l@googlegroups.com> wrote:
> Bill: She's saying that NULL date values are displaying like that in a
> form.
>
> Claudine: does
Thanks Paul. I believe my misapplying date formatting (formatting in two
places for the same field) may be responsible for this…
Claudine
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of
Paul C. Buckley
Sent: Friday, May 25, 2018 12:55 PM
To: rbase-l@googlegroups.c
I removed the date display format for that field in the tables tab and the
display format for non-text values on the DBEdit field and that removes the
phantom entry. Yeah!
Perhaps I don’t clearly understand what the Tables tab Display Format means. I
have two other date fields formatted to mm/
Claudine,
Just as a test you might try this, not knowing the complexity of this form, you
might create a new form based on the same table/view and do a control-A – copy
all from the original and paste it into the new form. It won’t bring all the
form settings and any variables you may have d
Furthermore, I recreated the DBEdit field on the form with no change. However,
I created a test form based on the same table and that date value is indeed
NULL so that clearly points to my form. I’ll continue playing with it and
report my findings. Probably something I’m unaware of doing wron
Yes Karen. This is a phantom value. All the NULL rows show this in the form
but the table shows NULL values. If I click on it while in the form, it
vanishes…
My settings:
BLANK
DELIMIT ,
LINEEND ^
SEMI;
QUOTES '
PLUS+
SINGLE _
MANY%
IDQUOTES`
[cid:
Bill: She's saying that NULL date values are displaying like that in a form.
Claudine: does the database see them as null? If you did a select where
datecol is null, do they show up?
Karen
-Original Message-
From: Bill Downall
To: rbase-l
Sent: Fri, May 25, 2018 7:1
Claudine,
If you can write a WHERE clause that finds all the bad dates, you should be
able to write an UPDATE that fixes them.
Are all the wrong dates off by exactly a century? If not, you will have to
make your WHERE clause more complicated, and do this more than once.
SELECT datecolumn FROM ta
9 matches
Mail list logo