I can program the number of days between today and a date in an element of the form and put it into another element.
But this will calculate only when I click on the element and just does it for that particular record.
What I want is a program that calculates the above number of days for every record in the database each time I enter the database in search mode and puts the answers in the corresponding elements of each and every record.

Sounds interesting.
Can I do an automatic mass update each time the application starts?
How would I program that?
Eduardo

I dont think you want to spend the time needed to run a mass update each time you open the database. There are several other options to do what you want, but you may want to consider:

On Form Entry, have the number of days calculated. This way, the 'math' is only performed when you are viewing that record. (it happens instantly).

Also, if you arent using that LE in searches or in xlookups, you can free up some 'overhead' in your database by making that LE 'unbound'. Your 'math' will still be performed, and visible in the LE, but it wont be saved to database each time you close the form....thereby keeping your database as efficient as possible. (If you prefer for that LE available for searches or lookups, then you should leave it 'bound'.)

ALso, if you only wanting this LE for 'searches', you should not try to 'maintain' the 'number of days' LE field, just use a programmed retrieve in the date field. You can even get fancy with the @promptforuserinput in the 'On Retrieve spec open' slot. THis will ask the user how many days they are looking for, and will use the response in the programmed retrieve.

Tell us how it goes.

Steve

On the Menu Tree under the Navigation Folder is a Save Record Choice.

-Ray

Thanks.
There is also a convenient Shift F10 that saves and closes.

Ray, I have noticed that the Save Record command on the Menu Tree under the Navigation Folder is not working.
The only way I can save a record after the programmed On Form Entry is using the Shift-F10 command which takes me out.
I believe this is a bug.

Ray,

THANK YOU for pointing out that Sesame 'reloads' the form after saving. This may explain a LOT of my issues (I had been saving a record in the middle of some extensive programming such as @createnewrecord, @formfieldvalue, etc.)

I'll take a closer look at my "On Form Entry" programming now.

Is there a way to save without reloading the form?

Thank you, again!

Steve

Ray - Thanks!

Etejeira - I have this program in a command button that saves changes and advances to the next record:

var nn as int

nn = @selecttreeitem("Add data menu!Navigation!Advance Record (F10)")

Just FYI.

Steve