If all of these applications are identical, you may be better served using one application and placing a "client" element on the form, and using a query to work on each client in turn.

If all of these applications are identical you can use the "Export All to Text File" and the "Import from Text File" options in the File pulldown menu in the programming editor to export your programming from the master application and import it into each of the copy applications. In any case, do not use MSWord, it is not an ASCII text editor and may be munging your code. It is not made for *any* kind of programming and should not be used for ASCII data. Use a text editor instead of a word processor.

If all of these applications are identical in design, but different in data, you can simply reconcile to the others from the master DSR file, without having to cut and paste any code at all.

Do your XLookups have the filename of the application in them? If so, replace these with @Fn so they will work in any application even if it has a different name.

If you use @XLookup instead of using XLookup, you can return the value to a variable and check its value (and the value of @Error) before you assign the value to an element and overwrite the existing value. If the there is a choice between using a function and a subroutine, that are otherwise identical, always use the function and return the value to a variable.

Thank you both for your quick responce and ideas.  Although I can not reconcile some of the data straight to another database for a few changed cannot be unchanged, but the programming should be the same.  I backed up all my files, exported all programming data to text file.  I opended another database in Designer and deleted all programming.  Saved, and the imported programming from text file.  Saved, and reconciled with the .db file.  When I opened it to try it, I was still getting the same results.

I don't think that @FN applies to my @XLookup s.  I am having something looked up from outside of this application.  That way one application holds the same data for dozens of applications to access.  For Example:

vlook = @XlookupSourceList("data\worksheet.db",ThisElement, "worksht!work sheet", "DESC1;DESC2;DESC3;DESC4;DESC5;DESC6;DESC7;DESC8;DESC9;DESC10;DESC11;DESC12;DESC13;F0038;F0043;F0048;Procedure")
 

And

vemp = @XLookup("data\empno.db", ThisElement, "empno!Employee No.", "Employee Name")
 

That is odd.  The one looking up the worksht database says NO.
The one looking up EmpNo, shows nothing at all. and gets removed on the save.

var vemp as string

vemp = @XLookup("data\empno.db", ThisElement, "empno!Employee No.", "Employee Name")
writeLn(@Error)
Calibrated by Technician0 = vemp
 

This is the complete code that is in EmpNo Element Programming on Element Change.  I enter in a number for example "53" and it should put "James Jones" in Calibrated by Technician0 textbox.  Nothing happens to Calibrated by Technician0 and when i save record, EmpNo textbox that had "53" in it disappears.

Well that was exactly it.  Now that gives me one more thing to check first.  Thank You.

Calibrate1 wrote on Sep 28^th, 2006 at 5:46pm:



Elements aren't bound to elements. They are bound to a field in the underlying database. The element and the field may have the same name, but they are not the same thing.

In Designer, click the EmpNo element to select it.
On the Property Editor, go to the Other Tab.
From the Bound To dropdown, choose the field name whose data you want to see in the EmpNo element.
Click the Set button next to Bound To.
Check the Other Tab in the Property Viewer to make sure EmpNo is Bound To the correct field.
Save the Layout.
Reconcile to the correct db.

It can't. Although, I'm not sure what you mean by a "text" file. I suspect that, with all the different copies of your database floating around, you are not using the copy you think you're using.

If you are running client-server, you may be accidentally using a local copy sometimes, and another copy on the server at other times.

If not, you may simply have multiple copies of your database in different folders.

I've also seen cases where someone had a misconfigured backup program that was carefully overwriting their day's work every day with an earlier backup copy.

If you can't figure out which copy of which database youare using, your best bet is probably to contact Support at this point. The immediacy of a telephone is a big help wih this type of troubleshooting.
http://www.lantica.com/Company/contact.html

BOBSCOTT wrote on Sep 29^th, 2006 at 2:23pm:


If your server has that application loaded, copying over its file would be a bad thing to do. Imagine if you had a file open in MSWord and while it was loaded you copied over that .doc file. MSWord is likely to overwrite your changes on the next save, at the very least.

If you are copying a design copy into your production environment - always place the design copy in a safe directory (where you know it is not being accessed by the server).

[quote author=The Cow link=1159446976/0#17 date=1159540229
If your server has that application loaded, copying over its file would be a bad thing to do. Imagine if you had a file open in MSWord and while it was loaded you copied over that .doc file. MSWord is likely to overwrite your changes on the next save, at the very least.

If you are copying a design copy into your production environment - always place the design copy in a safe directory (where you know it is not being accessed by the server).
[/quote]


I am confused (I know, nothing new)

If no users are logged on and only the System database is showing in the application open window (actually mine usually shows System Database and US Zip Codes) but my application is not showing in the open application window, doesn’t this mean my application is not loaded?

The steps I always use to update changes are:

I use save as when no other users are on the system to create my files to reconcile.
I copy my newly created files to my development machine.
I use Sdesigner to reconcile my files.
I move my current dat and db files from my server to a directory I call previous.
I rename my newly reconciled files on my development machine to the correct name.
I copy the dat and db files to my Sesame\data directory on my server

I thought when someone logs into the application my new changes would be active, It only has changes if I completely stop Sesame server and restart it.

Calibrate1 – Sorry I did not mean to Hi-Jack your post!

Quote:


Actually the Sesame Server will list an application that is loaded by an X command. It will be listed as the path given to the X command until that application is loaded by an actual client and then the application title will be displayed instead of the path.

Quote:


This is correct. If an application shows up on the list of Open Applications then the only way to re-load it from the Hard drive is to restart the Sesame Server.

-Ray

BOBSCOTT wrote on Sep 29^th, 2006 at 2:54pm:


Yes that means that at that point in time your application is not loaded on the Sesame Server

Quote:


In a perfect world with perfect users those steps would work fine. I just followed those steps here with Customers and the new changes were picked up when the client re-opened the app after I changed it and put it back. The thing is that a Client could connect at any time and open the old application, loading it into memory on the server, and be working on it while you move the files around. One of the main reasons that we recommend that the Sesame Server is shut down during a Reconcile, Save As, File Transfer, in a multi-user environment is to be sure that no user can connect and open those files during that process.

But anyways those steps should work as long as the application is not currently open by the Sesame Server. If the load of the application after you put the files back in the correct directory is almost instant, with a large app, then the app was probably already loaded into memory on the Sesame Server.

-Ray