Re: [Squirrel-sql-users] MS SQL select from a function with an option (recompile) hint

[Gerd W. <ger...@t-...>]

Sorry I can't reproduce your problem.
If  you send an example script I'll give it another try.

Anyway I' don't believe I could do much about it. It sounds pretty much 
like RDBMS / JDBC driver specific problem.

Gerd


Am 23.05.19 um 17:31 schrieb Alex Malmyguine:
> If I run a select statement against a table valued function and include OPTION(RECOMPILE) and leave "Limit rows" checked off, the query fails with the following error:
> 
> Error: Invalid state, the Connection object is closed.
> SQLState:  HY010
> ErrorCode: 0
> 
> It runs fine w/o row limiting.
> The select statements which do not query from a function work fine with the option with or w/o row limiting.
> 
> Thanks,
> Alex
> 
> 
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>