Another odd thing is that the date picker control behaves differently
to a plain variable edit control. Hitting delete on a date picker will
actually set the variable to null (which is what should happen). For
now I'll probably go with this. But since I don't use them on any of
my other forms, it'll seem a bit out of place from a user perspective.
Guess I'll submit it, unless anyone else has any bright ideas.
Thanks
Lucas
van der Zwaag, Frank wrote:
I am with you on that one. I encountered problems when loading data
containing date fields from an ASCII file. The dates load as null if the
date input and output date formats (rbengine.cfg) differ. I only
discovered this two days ago. May need to do some more investigation and
then report the exact nature of the problem to Razzak. My workaround for
the time being is to keep the two formats in sync.
Frank
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Lucas
Edwards
Sent: Friday, 16 September 2005 11:51 a.m.
To: RBG7-L Mailing List
Subject: [RBG7-L] - Variable Dates
Hi all
I recently upgraded to 7.1FRC12 (from a much earlier release) and it
"seems" that variable date fields are behaving differently. If I have a
simple form based on a dummy table, with one date field (vdate) defined
in the form as vdate = .vdate, then from the R:prompt:
set var vdate date = '16/09/2005'
edit using dummyform
The form pops up with vdate = 16/09/2005 as expected. But if I try to
delete it, it won't let me.
I can change it to a different date, no problem.
If I enter an incorrect date like 66/66/2005, then it always reverts
back to the last correct date entered (I've obviously missed this one,
but when did this change?).
I first thought the form I was working on was somehow corrupt, but have
since gone back and checked existing forms and they all behave the same
way.
So then I thought my config settings must be wrong (the installer
overwrote rbengine.cfg), but I've been through the settings one by one
and I can't find anything out of the ordinary (see below).
Btw, it's only date fields. Integer and text fields behave normally.
Help!
Lucas
AUTOCOMM OFF
AUTOCONV ON
AUTORECO OFF
AUTOROWV OFF
AUTOSYNC OFF
AUTOUPGR ON
COMPATIB ON
;============================================================
; Displays
;============================================================
ERROR ON
MESSAGES ON
BELL OFF
INSERT ON
ZERO OFF
HEADINGS ON
CLEAR ON
AUTOSKIP OFF
REVERSE ON
CASE OFF
ECHO OFF
RULES ON
ESCAPE ON
AND ON
SCRATCH TMP
SORT OFF
LAYOUT ON
ANSI ON
WRAP ON
EQNULL OFF
OLDLINE ON
MANOPT OFF
INTENSIT OFF
FEEDBACK OFF
WALKMENU OFF
SORTMENU ON
SERVER ON
LOOKUPS 50
QUALCOLS 10
;============================================================
; Chars
;============================================================
MANY='%'
SINGLE='_'
PLUS='+'
QUOTES='''
SEMI=';'
LINEEND='^'
DELIMIT=','
BLANK=' '
IDQUOTES='`'
;============================================================
; Misc
;============================================================
NULL -0-
WIDTH 79
LINES 20
FILES 200
TOLERANC 0.
NOTE_PAD 10
;============================================================
; Format
;============================================================
DATE FORMAT DD/MM/YYYY
DATE SEQUENCE DDMMYY
DATE YEAR 30
DATE CENTURY 19
TIME FORMAT HH:MM AP
TIME SEQUENCE HHMM
CURRENCY $ PREFIX 2 B
;============================================================
; Colors
;============================================================
COLOR GRAY ON BLACK
MENU BLACK ON GRAY
DIALOG BLACK ON CYAN
FIRST RED ON GRAY
EXPLODE OFF
;============================================================
; Launch on Startup
;============================================================
MENU
OPTIONS -T2
EDITOR OFF
TABSIZE 8
;============================================================
; Printer File
;============================================================
PRINTER
;============================================================
; Misc
;============================================================
;============================================================
; Multi , Transaction
;============================================================
MULTI ON
STATICDB OFF
NAME RBG71Runtime
VERIFY COLUMN
ROWLOCKS ON
FASTLOCK OFF
WAIT 4
INTERVAL 5
REFRESH 0
TRANSACT OFF
MAXTRANS 201
MDI OFF
AUTODROP OFF
INDEXONL ON
____________________________________________________________________
CAUTION - This message may contain privileged and confidential
information intended only for the use of the addressee named above.
If you are not the intended recipient of this message you are hereby
notified that any use, dissemination, distribution or reproduction
of this message is prohibited. If you have received this message in
error please notify Air New Zealand immediately. Any views expressed
in this message are those of the individual sender and may not
necessarily reflect the views of Air New Zealand.
_____________________________________________________________________
For more information on the Air New Zealand Group, visit us online
at http://www.airnewzealand.com
_____________________________________________________________________