Hi,

I have a problem when trying to convert a bit into an int when fetching a dynamic list.

My field is defined as follow:

 fields.DefineField(MyTableFields.MyIntCol, 1,AggregateFunction.Sum);
fields[1].ExpressionToApply =  new DbFunctionCall("Convert(INT,{0})", new object[] { MyTableFields.MyIntCol});

The generated sql doesn't looks like this:

SUM(Convert(INT,{0})([dbo].[MyTable].[MyIntCol])) AS [MyIntCol] 

I would have expect the {0} to be replaced by dbo].[MyTable].[MyIntCol]. Obviously this code doesn't work.

Your help will be much appreciated.

cheers,

Xav

Which LLBLGen Pro runtime library version are you using?

Would you please try the following instead:

fields.DefineField(MyTableFields.MyIntCol, 1);
fields[1].ExpressionToApply = new DbFunctionCall("SUM(Convert(INT,{0}))", new object[] {MyTableFields.MyIntCol});

Hi,

Thanks but I already tried that and it doesn't work

SUM(Convert(INT,{0}))([dbo].[MyTable].[MyIntCol]) AS [MyIntCol] 

For the version : see thread header => 2.0.0.0

Any other thoughts?

Cheers

Xav

Constants in DBFunctionCalls was not yet supported in v.2.0 If possible please port your code to v2.6, won't take long toport your code, and it's free upgrade.

Btw, check the following thread to know how to get the runtime library version (for future usage): http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=7722