Wouldn't be nice if FM provided a SQL function to fetch some data as a csv formatted list.

Example :

SQLCommand ("SELECT a, b, c FROM myTable WHERE myTable::a = 1"; mySeparator)

Would return a list looking like this :

col_a;col_b_;col_c¶

col_a;col_b_;col_c¶

col_a;col_b_;col_c¶

...

Why would this need to be a SQL function? I believe you can get the described result using a custom function.

How to do this using SQL?

Edited August 25, 200916 yr by Guest

How to do this using SQL?

I didn't say do this using SQL. I said you can do this using a Filemaker custom function, for example:

http://www.briandunning.com/cf/309

Thanks, the function is very interesting! But still, the SQL function is more universal and allows conditionnal expression.

You can add a condition to the custom function, if you like. In any case, Filemaker is not a SQL database, and there would be little sense in trying to make it respond to SQL commands (though I believe there is a plugin that does that).

I know it's possible using ODBC connection, but it's not embedded in FM.