I would recommend making a 5th application that has the XUserName and XPassword set on it and in the On Application Open event, Do a simple XLookup to each of those 4 applications.

-Ray

Hi Ray,

I made a database Manager.db which calls up reports from other databases based on the entered parameters. 

At the day end, our main database I-2021v2.db and each location's Sold databases imports the text files from each location when they are opened.  I have a password setup on the main database to avoid accidental deletes. The Mass Updates in each database is done by a Command Button command.

Can the Imports and Mass Updates be done from the Manager database like doing the reports and if so, what commands do I use?

Hi Ray,

Below is the programming for the DELIVERED button.

Is there a way to integrate in the start up instead of needing to press the command button after the files are imported.


var vTmp1 as Int
var vTmp2 as Int
var vList as String
var vChoice as Int

var vTmp as Int
var vChoice1 as String
vChoice1 = "PENDING"

     If @Mode() = 1
     {
           vTmp = @SelectTreeItem("Search Update Menu!Search (F7)")
     }
     If @Mode() = 2
     {
           //vList = @SpecCommand(6, 1, "")
           //vList = "Current Spec;" + vList
           //PopupSelectPosition(4, @XPos(ThisElement), @YPos(ThisElement))
           //vChoice = @PopupMenu(vList, "SELECT A SPEC")
           If vChoice1 <> ""
           {
                 If vChoice1 <> "Current Spec"
                 {
                       vList = @SpecCommand(0, 1, vChoice1)
                 }
                 vList = @SpecCommand(2, 1, vChoice1)
           }
     }
                     
vTmp1 = @LoadMassUpdateSpec("DELCMP-LKUP")

If vTmp1 = 1  Then RunMassUpdateSpec()

vTmp2 = @LoadRetrieveSpec("DELIVERED")
@save

If @Mode() = 2 Then vlist = @SpecCommand(2, 1, "DELIVERED")
@save
                     
vTmp1 = @LoadMassUpdateSpec("UNPOSTTOSRSOLD")

If vTmp1 = 1  Then RunMassUpdateSpec()

CreateAProcess("C:\Sesame2\DELANT.BAT")
ExitSesame()