Export current record

[technoranger]

I've searched and come up empty....but it seems like it should be easy. I need to export to an xml file, but only the current record. The export (no dialog) script I have now is exporting the first of 54 records no matter which record I am on.

[Fenton]

Export (records) always exports the found set. To export 1 record you need to have a found set of 1. There's a few ways to do this. It's also convenient to use a New Window, so you don't mess with the current found set of your records. I suggest this because you say 8 Advanced for this post (please update your profile from 6 if you've updated your app).

Low rent method:

New Window

Show All Records

Omit Record

Show Omitted Only

Export

Close Window (current window)

The reason I say "low rent" is because, in a (very) high-volume situation, another user might create a record in the split second after Show Omitted Only, and it would be added to your found set (since you didn't specifically omit it, FileMaker doesn't want you to feel left out -); at least that's my understanding. Unlikely, but possible.

Politically correct method:

New Window

Set global to unique ID

Commit Record

Go To Related Record [ self_global-to-ID::ID, show only related ]

Export

Close Window

[comment]

Another "politically correct" method (courtesy of -Queue-):

Show All Records

Omit Record

Show Omitted

Loop

Exit Loop If [Get(FoundCount) = 1]

Go to Record/Request/Page [Last]

Omit Record

End Loop