Solution: User has DATABASE RETENTION: ON set in his INI file.

In the past few hours I have had a number of applications demonstrating the same problem.

Using 2.0.3

Using Designer, Database Manager, Manage Layouts, I had to rename a number of reports.
I then reconciled from DSR to DB.  Was then trying to Merge Application and getting message that could not happen because names already existed.  This happened many times, I finally started saving as a new application vs. reconciling and that worked OK.  I finally looked at the "reconciled DB files and saw that the new  report names were not happening.

And while on the topic, could really use a tool to Remove All Reports vs. having to select each one individually to add to the batch process.  Would be good to be able to make multiple selections, but as a minimum the option to Delete All Reports would be a great addition.  I can understand why you can't do that for renaming, but deletion is much different.

Thanks for listening.

That sounds like the scenario.  And it may also explain the "locked" records from another post.  Here was the process:

Load File A.DSR
Merge File B.DB, get error message
Load File B.DSR, rename reports
Reconcile File B.DB
Load File A.DSR
Merge FileB.DB, still get error message.
Check FileB.DB, file names not changed
Check FileB.DSR, file names were changed, but apparently did not reconcile.
Reconcile FileB.DSR to FileB.DB, cannot do, file is locked.
Use admin to unlock FileB.DB, cannot do.
Use sunlock to unlock FileB.DB, cannot do.
Try to rename/move FileB.DB, can to with FileB.dat, but not with FileB.DB, is locked
Use FileB.DSR to Save as new application FileC.DB
Open FileA.DSR
Merge FileC.DB, success!

========================
Also NECESSARYl would be the name(s) of duplicate forms/reports to show up in the log.

My main application has about 12 databases with hundreds of reports, scores in each database.  When getting error on merge, I need to manually compare all reports in master and merge databases, took many hours to do this.  And when I missed one or more report dupes, I had to repeat the steps above, many times waiting 10 mins or more for each process to complete.  Log should show "Database|ReportName" for each conflicting name.

And, as noted earlier, a tool to delete all reports would be helpful.

Bob_Hansen wrote on Oct 8^th, 2007 at 4:55pm:


I'll see what we can do about that but I think that currently once it finds a name that is duplicated it just gives that message. It does not look to see if other names are duplicated. So it would only give one form or report name per merge. Not sure about that, but I believe that is how it works.

Quote:


If you need to do this again rather than going through by hand to check the names you could use the new Sbasic Commands

@ListDatabases()
@ListReportsByDatabase() 

To get a listing of reports by database or just

@ListApplicationReports() 

to get all the report names. Then a little loop to compare the results of one app to the results of another and you have all your names. I'd write it so you could just run it in a single record Mass Update. and save the code so you can use it in the future.

Quote:


I'll get that written up as a feature request.

-Ray

Bob_Hansen wrote on Oct 10^th, 2007 at 9:01pm:


You'd want to use @FindStringArray() and not @Instr() as @Instr() would return true even if the report name was found as part of a longer name. For example if a Report was just named "New", @Instr would return true if there was another report named "Newark Building Supplies"

-Ray