Which error did you get? Was it one line or two line?

-Ray

Your going to have to revert to your backup.

You said you got the message when you went to save. Could you give me the exact wording of the message?

-Ray

No need to reconcile every ten minutes. Just if you ever get that message again, Do not close Sdesigner. Open Preview Mode, Click File->Save as and Save it under a new name. this will create a backup of the DSR file with all the changes that you have made.

Thoughts on the file locking are an external program trying to use it such as a Virus Scan or other such software.

-Ray

Quote:


Reconciling every ten minutes is not a very good idea no matter how drunk you are.

If you are having problems, you should be making backups and copies - the opposite of a reconcile. Unless you are working on an application that is client/server and has other users using it while you are designing, you do not ever have to reconcile, you can simply "Save As New" instead and rename files as needed. Save away the old version first. Put it in a directory out of the way. Consider numbering the file names. That way you can always go back to a known good.

If you reconcile from a DSR that is giving you trouble, you are essentially sharing that trouble with the DB file your are reconciling to.

Ray wrote:
Quote:

Hmmm.  I'll have to keep an eye on that.  One other program I had running TSR is a defragmenter.  I've disabled it.

Mark wrote:
Quote:

This was the first problem, but it was a doozy.

Quote:

This sounds like a good plan, but you have to save the DSR first before you can save as a new application - and that's where my crash occurred.  At least I don't think there's any way to "Save As" a DSR.  There's no such option under the File menu or in the designer commands.  If I'm wrong, please someone teach me how to do it.

Bob wrote:
Quote:

(Snip amazingly comprehensive saving/backup procedure.)  Yikes, you're a kook.  I'd be lost in all those files.
Quote:

I think you mentioned this last Saturday at the SANE meeting, but it sounded very complex and advanced and I spaced out on the details.  Can you email me specifics of this technique?  Thanks.

Quote:


You create a backup of a DSR file by entering Preview Mode. On the File menu you will see a Save As option. That is how you backup a DSR file.

What Mark is saying is if you are a single user system, you really don't need to reconcile. What you do is
Open Sdesigner
Select Your DB file
Save it as a DSR file
Make Your Changes
Backup your original DB file
Save the DSR file as a new Application Selecting your DB file and selecting Yes to Overwrite

When you create the DSR file it is created with all the user records that the DB file has. As long as you are the only one adding records or changing them, your DSR file will have the exact same data as your DB file. This means that instead of reconciling, which can take a while, you can simply Save as a New Application and save over your DB file as the Data in them is the same. Even if you get the Message that says one of the Designer files is set to be read-only, you can still save it as a new DB and your changes will be there. But as with Reconcile it is recommended that you make a backup of your DB and DAT files, before saving over them with the DSR file.

-Ray

For Version Control:
1.  Create a Global Static Variable
Save all changes. Close all Design tabs.
From Design Menu tab:
Click on Application/Application Property Manager.
Click on button for "Program Application"
In the program Editor add a line something like this"

GlobalValue("gsVersion","Reconciled to FileName4.DSR - 08/11/06") 

Test Program to make sure no typing errors.
Close Editor.
Click on button to Save Changes.

2.  Use the Global Variable to show the latest version:
Enter the following program line any where in your programming tat you want to show the version:

var vVersion as String
vVersion = @GlobalValue("gsVersion") 

You can use this on Forms, Reports, Merge documents, Mass Updates, DataDictionary, etc.
You can put it in an element that is only visible under certain conditions or for specific persons.
You can use this to make sure users have the latest version by comparing this against dates/other values/ etc.