Hi,

hopefully a simple question, but one which I can't track down an answer for.

I have created a dynamic list and want to add a field that just has a constant for a value, e.g. in the select statement it appears as

SELECT 0 AS DummyField, ... other fields .. FROM ....

how do I do this using fields.DefineField ? As a dirty workaround I am subtracting one field from another using an expression.

fields.DefineField(new EntityField("DummyField", ProductFields.StatusId - ProductFields.StatusId), 0);

What I was hoping for was something along the lines of

fields.DefineField(new EntityField("DummyField", 0), 0);

Thanks in advance,

Darren

Hi Darren. Pasted from LLBLGenPro Help - Using the generated code - Field expressions and aggregates

The different types of expressions you can produce are:

Field Field ExOp Field Field ExOp Value Field ExOp Expression Value ExOp Field Value ExOp Expression Expression ExOp Field Expression ExOp Expression Expression ExOp Value

So I think is no an obvious way to do that

You can also add a column to the datatable and add the value there.

Of course!

Thanks Frans, sometimes you look so closely at something you forget the bigger picture!

Darren