The answer is - probably both. We've test translated a few hundred databases and have not seen any problems translating Q&A databases that have no corruption. Corrupt databases, on the other hand, can give Sesame real grief on translation. Of course Sesame should not "crash" - no matter how corrupt the Q&A database, but clearly - in your case - there is some condition that it is not anticipating.

Have you contacted Lantica's customer support? If so, have you sent in the database in the condition that causes Sesame to "close down"? If it is purely a case of corruption in the Q&A database, customer support can probably help you get it in shape for translation. And in any case, we would like the opportunity to fix whatever is causing Sesame to shut down.

Lantica technical support can be reached at:
http://www.lantica.com/Support/support_request_form.html

In this case, a Table report will serve better than Freeform.

1. In the Group Body, place a Value Box bound to State. Using the Property Editor, set it's Visible property to No. By default, it will be named LE0.
2. In the Group Body, place a Value Box bound to City. By default, it will be named LE1.
3. In the Group Header, place an Unbound Value Box. By default, it will be named LE2.
4. Click on the column title where it says "Group Body". The Report Section Properties dialog will appear. From the Break Element dropdown, choose LE0. Leave the Break Value set to 0. Click OK.
5. From the Commands, choose Program Layout. From the Element dropdown, choose LE2. Use the following programming statement:

LE2 = LE0

From the File menu, select Close Programming Editor.
6. Save your report.

This should do what you want, except for a bug where the first State value will not appear. This is because it is trying to print the first Group Header before it has the actual record values. Development will be looking into this.


Quote:

You don't have to close the Design Tab before going to Preview. You do have to save, in order to see your changes, but you can leave the Design Tab open.

Yes, we absolutely do want your crashing database.  Between the holidays and shipping the orders, it may be a few days until they ask you for the database files. 

The solution is likely to be to strip out the reports one by one until you find the corrupted one, or to use one of John Dow's tools to check the reports for corruption. Regardless, development would like to have the database. We can't fix the corruption in Q&A, but we may be able to catch the crash condition.

OK, the crashing file is in the mail!

Frances

There's several ways to quote what someone has said previously.  If you look in the upper right area of a message you'll see the word Quote as an icon/link.  Clicking on that will put the entire message in a quote in a reply message.  You can edit out the parts you don't want.

Another way, that I'm using now is to first use whatever method you are used to using to "copy" text from a message. (Either right highlight, right-click, copy, or highlight, Ctrl-C).  Then click on the Reply link at the top of the message to open a reply window (which is what I'm in now).

Next, look in the Add YABBC tags area above the reply window, and look at the icons.  The 2nd to last icon on the 2nd row (has a blue arrow) is the "insert quote" icon.  Move your mouse over the icons to get descriptive text to show up.

I click on that icon and get HTML start and stop syntax for quoting.  I then place a space in between these, and do a "paste" of the text I previously copied.  As so:

Quote:


You can preview your message to see if you have what you want, and refresh the preview as often as needed.

John Dow's web site is linked on the Resources for converting to Sesame in the Q&A window on www.lantica.com. ; This link is:
   http://www.johntdow.com/

Good news is that your database showed up on my desk and I was able to translate it. The problem is in the reports. In several of the reports there are derived columns in which the heading is blank. By excluding these reports, or filling in the heading, you should be able to translate.

The bug in the translator that makes it have such a fit on blank headings has been fixed. The fix will be available in the next release of Sesame.