Hi, I'm running llblgen 2.5 w/ C# and trying to create a dynamic query where some of the fields are empty placeholders that will later be populated by the business logic layer. An example:

SELECT a.name, a.subTotal, 0 as total FROM Budget a

As you can see in the above, the "total" column is simply 0, relying on code to define this value later on. I tried defining fields but can't seem to figure out how to create an empty field.

Thanks!

Hello,

Maybe you could simply add a column to the resulting datatable, or even better, useprojection to fill a business object of yours.

Thank you for the reply. I ended up just adding columns to the dataTable. The problem is that asp.net doesn't make this easy, as I can not insert columns at a specific index, just append. I didn't want to project b/c 1.) I'm not too familiar with it, and 2.) I'm using several methods that are passing the DataTable type.

Thanks for the reply