SQL Table Function support needed

Is there a feature you'd like us to add? Post it here.

SQL Table Function support needed

Postby glittle on Wed Aug 08, 2007 4:26 pm

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
glittle
Lurker
 
Posts: 4
Joined: Wed Aug 08, 2007 3:54 pm

Postby mike.griffin on Thu Aug 09, 2007 12:13 pm

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. 8)
User avatar
mike.griffin
Site Admin
 
Posts: 3290
Joined: Sat Apr 03, 2004 6:10 am
Location: Indianapolis, IN

Postby justin.greenwood on Thu Aug 09, 2007 6:09 pm

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)
User avatar
justin.greenwood
Site Admin
 
Posts: 441
Joined: Sat Apr 03, 2004 6:10 am
Location: Indianapolis, IN


Return to Enhancements

Who is online

Users browsing this forum: No registered users and 1 guest

cron