SQL Table Function support needed

[glittle]

MS SQL supports \"Inline Table-valued Functions\".

These can be treated like a View, but defined with parameters. You can think of them as a cross between a Stored Procedure and a View.

As such, MyGeneration should list them with all the \"output\" columns, and with all the \"input\" parameters.

Currently, they are listed in the \"Procedures\" listing, but without the output columns. These columns are predefined and immutable, like a View.

Also, these table functions cannot be called like a normal stored procedure. Templates would need to handle them differently. However, the MyMeta browser does not show any properties to distinguish between them. From the browser, I can't tell whether the \"procedure\" is a \"stored procedure\" or a \"table in-line function\".

So, two issues:
- columns are not known for table functions
- table functions are mixed in with stored procedures and not identifiable

Glen

[mike.griffin]

MyGeneration is now open source on SourceForget.net and we are looking for folks to help us enhance MyGeneration, you are most welcome to join and help make MyGeneration better.

[justin.greenwood]

What mike is saying is that we would love to add all kinds of features, but we don't have time to get to them quickly, so we count on the public to contribute. If you want a feature, the best way to get it is post a feature request on sourceforge. (check the homepage for a link)