I accidentally encountered a problem the other day whereby all the data in my record was wiped out.

This is what I did and I have been able to successfully duplicate this:

1. I was in an existing record, made a slight change to a piece of data but did not hit F10 to save it.

2. I clicked on a tab that has report buttons and selected a particular button and report (doesn't matter which button or report selected)

3. The first message indicates:  " The current record has been changed and has not been committed to the database.  Are you sure you want to close this record?"

If YES is selected, then everything is fine and the report runs.

If NO is selected, a second message appears:  "The current record has been changed and has not been committed to the database.  The operation will automatically commit the record.  Continue ?"

If YES is selected, the data in the record is completely wiped out, the report runs but shows only this record with no information.

If NO is selected, everything is fine and the report does not run.

Can you try this on a test record to determine if this is consistent on your end.

I am afraid that some users will do what I did above but not realize that they have deleted the data in the record.

Thanks,

Louis

Ray:

When I try to make a change, don't save and run a report from the command area, the process works fine.

If I select YES, it saves the record and runs the report.

If I select NO, it does not run nor does it delete the data.

Here is a sample of my code for one of my buttons.  In all cases, my command button brings up a pop up menu.

var vMonth as String      
var vRun as Int
var vSpec as Int
var vRetrieve as String
var vTree as Int

//offer user choice of reports to print

//popup is placed directly over Print Button

PopupSelectPosition(4, @XPos(PAYROLL ADVANCES MTH), @YPos(PAYROLL ADVANCES MTH))

vMonth = @Popupmenu("01-JAN;02-FEB;03-MAR;04-APR;05-MAY;06-JUN;07-JUL;08-AUG;09-SEP;10-OC
T;11-NOV;12-DEC", "Select A Month")

If @LEN(vMonth) = 0
{
     vMonth = "JAN"
}
Else
{
     vMonth = @Right(vMonth, 3)
}
GlobalValue("Report Month", vMonth)

//LOADS RETRIEVE SPEC

vRetrieve = "01-JAN;02-FEB;03-MAR;04-APR;05-MAY;06-JUN;07-JUL;08-AUG;09-SEP;10-OCT;11-NOV;12
-DEC"


If @LEN(vRetrieve) = 0
{
     vRetrieve = "JAN"
}
Else
{
     vRetrieve = @Right(vRetrieve, 3)
}

vSpec = @LoadRetrieveSpec("PAYROLL ADVANCES - " + vMonth)
vRetrieve = @LoadSortSpec("PAYROLL ADVANCES")
vTree = @SelectTreeItem("Search Menu!Search Commands!Retrieve New Results (F10)")


vRun = @SelectTreeItem("Search Update Menu!Results Commands!Reports!Employee!Payroll Advances - Mth (Preview)")

That was simple.  Thank you.

Louis