concate the fields

Posts   
 
    
altaf_sami
User
Posts: 7
Joined: 02-Jun-2008
# Posted on: 13-Aug-2008 09:34:36   

hello,

I want to concate the two same datatype fields please guide me that how can i do in llblgen.

Like this,

select filed1 + field2 from table where id = 222 thanks. confused

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 13-Aug-2008 09:44:41   
David Elizondo | LLBLGen Support Team
Walaa avatar
Walaa
Support Team
Posts: 14993
Joined: 21-Aug-2005
# Posted on: 13-Aug-2008 09:58:20   

Use a dynamic list defining a field with an expression to concatenate 2 fields or a DBfunctionCall that performs the same task.

e.g.

ResultsetFields fields = new ResultsetFields(1);
fields.DefineField(new EntityField2("storyname", (CustomerFields.Field1 + CustomerFields.Field1)), 0);
altaf_sami
User
Posts: 7
Joined: 02-Jun-2008
# Posted on: 13-Aug-2008 10:37:59   

thank you very much for guiding me.