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 _____________________________________________________________________
