Hello all,
This one I called the "Star Wars Commit"
problem.
How can a file be on the drive before it's even
created?????
[there is *not* a 2 minute delay in the *commit*
you can watch Win Explorer show immediately all 5 files]
Running 2 identical machines
[P200mmx(y2k good),32m,NT4w sp3,MI4.1]
on a network [3Com 3C509B cards 3Com TP4 4port
hub]
These are the field machines at 9-1-1.
Run the below statements from the MapBasic Window
in MI
The file dates on the *local* machine are all
identical [see below] and the the file dates
are different for each of the files on the
*network* machine, which results
in "must rebuild index" error [opening
from either machine]
I have tables where none of the times are the same
but don't have this problem
Here at home
[mine P2-266,128m,NT4w sp4,MI4.5]
[other P100mmx,32m,W95 rA,MI4.1]
[network 3Com 3C509B cards SOHO 5port
hub]
the table can be opened without any errors both
from mine and the other, either across the network
or locally, using MI directly or from my integrated 9-1-1 mapping application [both network
& local].
The work around was to do a *file copy* routine in
the 9-1-1 application [not exactly what I want to do]......
The drive *G:\* is not mapped and accessed through
*Network Neighborhood*
In the 9-1-1 application the connection is through UNC
[\\station1\c-drive\..........\]
As a government organization the answer "get
version 5.5" is *totally unacceptable*.........
We can't afford some 40 copies 2 times a year at
$$$
'====== from MapBasic Window ======
'''Select something
Commit Table Query1 As "E:\MI45\COUNTY\Untitled.TAB" TYPE NATIVE
Charset "WindowsLatin1"
Commit Table Query2 As "G:\Map_ALI\xfr_fail\Untitled.TAB" TYPE
NATIVE Charset "WindowsLatin1"
'====== look at file date/time using Win Explorer/My Computer
#1 local-all the same
Untitled.dat 05/16/1999 09:58
Untitled.id 05/16/1999 09:58
Untitled.ind 05/16/1999 09:58
Untitled.map 05/16/1999 09:58
Untitled.tab 05/16/1999 09:58
#2 netowrk-different
Untitled.dat 05/16/1999 09:58
Untitled.id 05/16/1999 10:00
Untitled.ind 05/16/1999 09:58
Untitled.map 05/16/1999 09:58
Untitled.tab 05/16/1999 10:00
Now open #1 > all is OK
Now open #2 > MI error "Must Rebuild Index
?????" and
the "ind" file is no longer there and you must
"press OK" for
each index in the file
