I have Sesame set up in a retail environment with 4 locations.  The main location  has multiple computers in a network.  The other 3 locations are standalone single computers, but have Sesame Servers set up on them.

Everything is working well, but I have a dilemma with our Inventory database.  All changes and edits occur at the Main location.  The other locations are sent a copy of that database at the end of the day and sometimes through the day.

To do this, I must connect to the remote computers and Unload the inventory database so it can be copied over.  Then I reconnect using the File Transfer.  This is fine for me, but if someone else has to do it, it will be a problem.

On the Server setup, the inventory remains Loaded after it is closed, but not in standalone. I cannot open the inventory in standalone if it is already loaded through the Server.

Any ideas how to make this simpler?

Hi Ray,

I am slowly getting the hang of this.
I made a batch file that uses the command line below for different databases.

c:
cd\Sesame2
cd Program
sesame.exe -command DESKTOP-029G63D  hello UNLOAD "INVENTORY"
sesame.exe -command DESKTOP-029G63D  hello UNLOAD "SOLD NG"

COPY X:\INVENT.DB C:\SESAME2\DATA\INVENT.DB
COPY X:\INVENT.DAT C:\SESAME2\DATA\INVENT.DAT
COPY X:\NG\SOLDNG.DB C:\SESAME2\DATA\SOLDNG.DB
COPY X:\NG\SOLDNG.DAT C:\SESAME2\DATA\SOLDNG.DAT

CD\SESAME2\UTILITIES\LANTICA
SUNLOCK C:\SESAME2\DATA\INVENT.DB
SUNLOCK C:\SESAME2\DATA\SOLDNG.DB

exit

The one problem I encountered that if a database is not loaded, I get a warning popup from Sesame which pauses the batch file.  In the example above it would be the SOLDNG database. I must hit the enter key to continue the batch file. 

Is there a way to shut off the warning?

Ray,

"-warn_none" won't do it?

The Cow wrote on May 14^th, 2021 at 1:11am:


Nope.