MSSQL Inlined table valued functions are not visible in object browser

[expired user #8934]'s profile image [expired user #8934] posted 8 years ago in General Permalink

Hi!

I've noticed that I'm missing a number of functions in the object browser for my MS SQL database. I've checked this thread http://www.heidisql.com/forum.php?t=16493 and I noticed that these functions have type = 'TF' and type_desc = 'SQL_INLINE_TABLE_VALUED_FUNCTION'.

Could you please add this type too?

[expired user #8934]'s profile image [expired user #8934] posted 8 years ago Permalink

Sorry for being persistent, but this looks like a small change, but would be of great help!

ansgar's profile image ansgar posted 8 years ago Permalink

Did you read the other thread down to the bottom?

r4828 includes these table valued functions.

Which HeidiSQL version are you running?

[expired user #8934]'s profile image [expired user #8934] posted 8 years ago Permalink

Well, I think I did read it, yes. The thread is about SQL_TABLE_VALUEDFUNCTION, and my question is about SQLINLINE_TABLE_VALUED_FUNCTION.

Aha, I got what's wrong. In my original post I wrote type = 'TF', while I meant type = 'IF'. So please read my initial post as if I wrote 'IF'.

My HeidiSQL version is 9.3.0.4998 64Bit.

ansgar's profile image ansgar posted 8 years ago Permalink

Ah, in that case, thanks for the clarification. I will check that.

[expired user #8934]'s profile image [expired user #8934] posted 8 years ago Permalink

bump

Code modification/commit from ansgarbecker, 8 years ago, revision 9.3.0.5045
Support inline valued functions on MSSQL. See http://www.heidisql.com/forum.php?t=20186
ansgar's profile image ansgar posted 8 years ago Permalink

r5045 supports these inline valued functions now, and handles them just like other functions.

[expired user #8934]'s profile image [expired user #8934] posted 8 years ago Permalink

Just checked and it works, thanks a lot!

Please login to leave a reply, or register at first.