At the beginning of the month, I had sent out this question.
I have still not been able to resolve the problem.
Up until three weeks ago, the only time the date column updated on my
forms/reports was when I would make changes to the form.
This would be the fifth column while looking at the forms in the DB
explorer.
Since then the date time always updates every time I open the DB.
This only happens on this particular DB.
My other two DB are just fine as is the sample DB.
I did an unload/reload. No problems.
The only two boxes checked on my Form designer settings are:
use compression and show action designer hints.
Below is the DAT I use to open the DB.
DISCONNECT
-- clear scratch files
SET ERROR MESSAGE 2077 OFF
CLEAR VAR vChkFile
SET VAR vChkFile INTEGER = NULL
SET VAR vChkFile = (CHKFILE('C:\TEMP'))
IF vChkFile <> 1 THEN
MD C:\TEMP
ENDIF
SET SCRATCH C:\TEMP
SET ERROR MESSAGE 2262 OFF
SET ERROR MESSAGE 2926 OFF
SET ERROR MESSAGE 2077 OFF
ERASE C:\Temp\*.$$$
SET ERROR MESSAGE 2926 ON
SET ERROR MESSAGE 2262 ON
SET ERROR MESSAGE 2077 ON
SET QUOTES=NULL
SET QUOTES='
SET DELIMIT=NULL
SET DELIMIT=','
SET LINEEND=NULL
SET LINEEND='^'
SET SEMI=NULL
SET SEMI=';'
SET PLUS=NULL
SET PLUS='+'
SET SINGLE=NULL
SET SINGLE='_'
SET MANY=NULL
SET MANY='%'
SET IDQUOTES=NULL
SET IDQUOTES='`'
set files 200
set staticdb Off
set fastlock Off
{set staticdb on
set fastlock on
set qualcols 10
connect dbName}
set messages on
set error messages on
set multi on
set zero on
set trace off
SET Walkmenu on
set null -0-
set date for mm/dd/yyyy
set date seq mmddyyyy
set currency '$' pref 2 b
-- connect to database
CONNECT labor
RETURN
The CFG file has these settings
AUTOCOMM OFF
AUTOCONV ON
AUTORECO OFF
AUTOROWV OFF
AUTOSYNC OFF
AUTOUPGR ON
COMPATIB ON
ERROR ON
MESSAGES ON
BELL ON
INSERT ON
ZERO ON
HEADINGS ON
CLEAR ON
AUTOSKIP OFF
REVERSE ON
CASE OFF
SHORTNAM OFF
ECHO OFF
WINAUTH OFF
UINOTIF ON
RULES ON
ESCAPE ON
AND ON
SCRATCH ON
RBADMIN OFF
TRACE OFF
SORT OFF
LAYOUT OFF
ANSI ON
WRAP ON
EQNULL OFF
OLDLINE ON
MANOPT OFF
INTENSIT OFF
FEEDBACK OFF
PROGRESS OFF
ONELINE OFF
FIXED OFF
SELMARGIN 0
TIMEOUT 0
WRITECHK OFF
WINBEEP OFF
WHILEOPT ON
PASSTHROUGH OFF
INDEXONLY ON
FASTFK OFF
EOFCHAR ON
DEBUG OFF
WALKMENU ON
SORTMENU ON
SERVER ON
LOOKUPS 50
QUALCOLS 10
NAMEWIDTH 18
NULL -0-
WIDTH 79
LINES 20
FILES 200
TOLERANC 0.
NOTE_PAD 10
MULTI ON
STATICDB OFF
NAME USER20131219121818
VERIFY COLUMN
ROWLOCKS ON
FASTLOCK OFF
WAIT 4
INTERVAL 5
REFRESH 0
TRANSACT OFF
MAXTRANS 201
MDI ON
AUTODROP OFF
RECYCLE OFF
Any suggestions on where to look would be appreciated.
James Belisle
Making Information Systems People Friendly Since 1990
