SQL function...

[El_Pablo]

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¶

...

[comment]

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

[El_Pablo]

How to do this using SQL?

Edited August 25, 2009 by Guest

[comment]

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

[El_Pablo]

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

[comment]

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).

[El_Pablo]

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