Error syncing table valued function

Posts   
 
    
g.smeets
User
Posts: 9
Joined: 06-Jan-2020
# Posted on: 24-Apr-2020 20:22:32   

Error: 'Table valued function 'Foo' caused an exception during resultset retrieval. Its resultsets (if any) probably aren't determined in full: Operand type clash: NULL is incompatible with Bar'

I'm not quite sure how I can solve this error. Any suggestions?

update: Hmm, it might have to do with the fact that it has a table valued parameter.

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39752
Joined: 17-Aug-2003
# Posted on: 24-Apr-2020 23:44:04   

You give very little info to work on, to be honest simple_smile

Frans Bouma | Lead developer LLBLGen Pro
g.smeets
User
Posts: 9
Joined: 06-Jan-2020
# Posted on: 25-Apr-2020 16:23:59   

Am I correct in assuming you have no support yet for table valued parameters? We've had this discussion on twitter before. You were thinking of adding support after finishing the NET Core 3.x work.

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39752
Joined: 17-Aug-2003
# Posted on: 26-Apr-2020 09:52:40   

there are no support for table valued parameters. we did look at supporting it but it required an existing table definition which was cumbersome to come by, so we postponed it (as it was cumbersome to define the parameter)

Frans Bouma | Lead developer LLBLGen Pro
arn
User
Posts: 3
Joined: 27-Sep-2023
# Posted on: 27-Sep-2023 11:29:08   

Hi,

I have encountered this error when adding table value function in the designer.

Error: 'The table valued function '_DocumentStore_Template.dbo.fn_VendorFile_ListFolder' has been removed because it has no valid resultset.'

Can someone please help?

Thanks & Regards,

Arn

Attachments
Filename File size Added on Approval
Capture.JPG 157,976 27-Sep-2023 11:29.47 Approved
arn
User
Posts: 3
Joined: 27-Sep-2023
# Posted on: 27-Sep-2023 12:34:57   

Never mind!

casting HierarchyID SQL data type to nvarchar(4000) resolve issue.

arn wrote:

Hi,

I have encountered this error when adding table value function in the designer.

Error: 'The table valued function '_DocumentStore_Template.dbo.fn_VendorFile_ListFolder' has been removed because it has no valid resultset.'

Can someone please help?

Thanks & Regards,

Arn