The case of the disappearing export field

September 12, 200322 yr

I'm doing an export of some 36 fields from a FM (Developer 6) DB and 3 related FM DB's. I'm putting the export in a script. I've got one field that's driving me bananas - it keeps disappearing from the export list.

I performed the file export, create the field list, - works fine, everythings there.

I openned the script, clicked on the export statement, clicked done and told it to replace the export.

I ran the script and this one field (from one of the related files) didn't show up. I ran it again and checked the export field list, and it wasn't there.

So I did the file export bit, and the field wasn't there either. Many, many tries and no luck. It'll export the field the first time, but then it disappears again. I can manually insert the field in the list during the export and it works, but, again, it's gone afterwards.

I finally tried just the field that was giving me problems all by itself. It vanished.

I went to still another DB that was related to the DB that had the missing field and tried exporting the problem field from there - same thing - it went 'poof' after the export.

I went to the DB the field is in and did the file export thingy and it didn't disappear.

I'm exporting 5 fields from this file and only this one is a problem. The problem field is a calculation (so is one of the fields that works). Stored, unstored, indexed, unindexed make no difference - I tried them all.

Help!!