I"m puzzled as to why you would get "nothing or a ?". A question mark result is supposed to indicate a SQL syntax error so you should get that result every time if there is an error in the SQL. Did you try clicking/tabbing into the field when you got that result? (a question mark result can mean that the data in the field cannot be displayed due to the field being too small to show all the data...)
There shouldn't be a syntax error with:
Select * from \"ORDER\"
as the fact that the table name is in quotes will keep this from having issues with the fact that ORDER is a keyword.
If you aren't getting results at all, can you confirm that DateOrdered is defined as a field of type date and not text? Is text specified as the result type for this calculation (assuming you defined a calculation field)?
PS. ExecuteSQL is very new--introduced in FileMaker 12. We didn't have any built in ability to query with SQL prior to this. It definitely could benefit from a Query builder tool that lets you see your query results and to graphically build join clauses.
I had forgotten that the remote JDBC console does not require the "\" before the reserved (table, in this case), variable ORDER.
Thus, Select * from "ORDER" works fine.
Virtual lists are an interesting way to build layouts from SQL queries.
Thanks as always for your reply. :)
Hopefully there will be a nice SQL Console where you can just type in raw SQL for quick data mining in 14.