Jim,
There are other ways to distribute updates.
I have a client with a multi user environment with 5 PCs and 1 server.
You can do the same thing on a workgroup too!
On the Server (where the database is located):
create a table called UpdateStatus
The table contains PC name, PC Mac Address, New Version Build, Update Status
(1 has been updated 0 has not) and Update File ID.
create a table called UpdateFiles
The table contains Update File ID (autonumber), Update File Name, Update
File (varbit), New Version Build and password.
Create a form UpdateFiles
Select and upload the update file
cut and paste the password and New version Build from the email into the
UpdateFiles form
Upon saving and before exit
Reset the Update Status to 0 and change the Update File ID for all machines
in the UpdateStatus table
create local folder on each PC - C:\RBTI\UPDATES
Upon login or startup on the PC
Check PC Mac Address between FileStatus table and local PC
If a match then continue
If no match alerts user that the PC is not registered and contact admin
Check for update files in local folder (C:\RBTI\UPDATES|
If files present then delete and continue
check for update (Update Status - is it 0?)
If 0 run update routine
If 1 compare New Version Build vs local (cval('build'))
If build match then no update required continue with application startup
If build no match then run update routine
Update routine
Alert user update routine has started
download the Update File from the database to local update folder
(c:\RBTI\UPDATES)
place the password into the clip board (SET CLIPBOARD .vPassword)
update the Update Status table reset Update Status to 1 update was started
launch update file
exit rbase
paste the password
use the standard setting
The user only needs to know how to paste the password, click continue and
change nothing.
Works well with little issue.
Another way
define a share C:\ drive on each PC
Define on the Server a logical drive for each PC's c:\ drive share
Then on the Server you have the Update file
Run the update file but change the drive letter to match the defined logical
drive
You can push the update to the PC's
I did this one first but too many conflicts can occur with this method.
Plus it takes a lot more time.
I know there are many other ways to do it too!
I remote access this client and ftp the files up to the server.
I run my admin remotely.
Just some food for thought!
Best Regards,
Oma Cox
O.C. Services Inc.
P.O. Box 5485
Brandon, MS 39047
662.820.7599
601.992.6785
www.ocservicesinc.com
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Jim Belisle
Sent: Tuesday, May 27, 2008 7:45 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Updates
Razzak,
The other users of 7.6 here at the company are trying to download the
updates for the most recent version of 7.6. Once the download comes and
it asks if you want to save them, does it matter where you save the
download? Also one person did save it to the same folder as the EXE
file but now does not know how to get the update in RBASE itself. What
comes next?
On another subject, will making a report in the updated version of 7.6
make it unusable in the earlier version of 7.6? I ask this because the
report we made while I was with you will not work on the other machines
here at the office. It comes up with the error ppReport1 Disable Trace:
Property Disable Trace Does Not Exist. What does this mean?
Jim
