Here's an example of a simple file export using OWS and SQL data. This sample uses a CSV structure but any structure and layout could be used.

I have included saving the file to a server folder, but at the moment there is an error with this part which I'm short of time to look into so if anyone else identifies this please let me know. The file download for saving works fine.

DOWNLOAD CONFIGURATION

I am including my finished product (minus the security) which adds, edits, and deletes 7 columns in a DB table and writes to a CSV file each time there is a change.

I made some changes to the example.

• Moved the query and file fuctions to the OnLoad portion so that they run when the save, and delete fuctions are used.
• Removed the time stamp from the file name because it was throwing an error. If you know how to format the time so that it does not use special charaters I will add that back in.

Sample App

Thanks for your help, it would have taken many days of trial and error without your code.

Not sure which example you are pulling from but David's example doesn't include the "s

You can format the output however you want. Look at David's example, line 7. His CSV_Data Action is being defined as [RoleID,GetRoles],[RoleName,GetRoles],[Description,GetRoles]. (no quotes) If you want /don't want quotes, you just format accordingly.