Playing with basic SQL in FileMaker, I have it return the data I want but not in the format I want.
The first two lines in my script's "Set field" are:
ExecuteSQL ("SELECT InvoiceNum, OrderDate, TotalAmount
This returns the proper data but formatted like:
I am not sure how to have it return a tab delimited format and use proper formatting for dollar amounts with 2 decimal places, as shown below:
12345 2013-09-22 400.10
12346 2013-09-22 299.00
12347 2013-09-22 199.23
I have experimented with || char(9) and ", " , " " and have had no success with the delimination. I have no clue on how to do the 2 decimal point accuracy.
I welcome any direction or examples.