Is it at all possible to use Xlookupall in a Q&A database?  If not, is there any workaround?

Thanks!
Blair

Sorry I was a bit terse there. Only the X commands that "read" as opposed to post, and were available in Q&A, support reading .dtf files.

One alternative you might consider, is using sesame as a "real time" translator by using the "-qa" startup switch and starting a copy of sesame from @Shell right before you call XLookupAll. That way, you can keep using the file in Q&A and Sesame will always get the latest data. Something like:

var aa as int
aa = @Shell("Sesame -qa MyFile.dtf")
XlookupAll("MyFile.db", ... etc...)
...
etc

Of course, this would only be okay if the .dtf file is relatively small, otherwise the translation time might be too long for everyday use.

Hi Blair,
I'm Mark - not Ray. I don't know where you can read up on the -qa switch other than the by using the "-help" startup switch:

sesame -help 

It is intended for batch translations. Maybe someone from the tech writing team will chime in.

Could you be more specific? What exactly did you try? If you tried the "-qa" startup switch, Sesame's graphical user interface will not start up. This is intended as a command line utility to translate a series of .dtf files - so it has no user interface. It simply translates the file and leaves the resulting .db and .dat files in the same directory.

So, you should start a command line. Use CD to navigate to the directory where your .dtf files reside (back them up!) and then start Sesame with:

C:\Sesame\Program\sesame -qa YourFile.dtf

It will run for a while and then stop. If you do a "DIR" in that directory you will see two new files: a .db file and a .dat file, with the same file name as your .dtf file.