LLBL Gen Pro v 2.6/SQL Server 2008/.net 3.5/Self Servicing

I need to extract values for some of the SQL Server global variables (like @@VERSION). Can this be done via LLBL? Thank you

Do you need to extract these independant of any query? Or retrieved along some queries?

You can have either a database function that return these variables and use DBFunctionCalls within a DynamicList to retrieve them.

Or a Stored Procedure, and map it to SPCall in LLBLGen.

Hi Walaa,

Some place I will do independent but i may have to retrieve it along some query too. I tried to add a new EntityField calling DbFunction for global variable but the query seem to ignore that particular EntityFiled because when I look at SQL Profiler, it does not have column (containing global variable) in SELECT clause of query.

Can you show an example using DynamicList? Hopefully that will help me determine what I may be missing.

Actually using DbFunction seem to append paranthesis with the global variable name @@VERSION which SQL Server does not seem to like

This is how I am setting up DbFunction in code

DbFunctionCall FCall = new DbFunctionCall("@@VERSION", new object[0]);

below is the query that is been triggered that give me error from SQL Server

SELECT DISTINCT @@VERSION() AS VersionNo, ClientName FROM Client

I have also tried below without any luck.

DbFunctionCall FCall = new DbFunctionCall("@@VERSION", null);

Any ideas how to tell LLBL not to add paranthesis here?

Maybe my words were not clear, sorry. I meant you should have a database function that returns the parameter required. Then use a DBFunctionCall for it.

Got you. No worries