Column aliases

Posts   
 
    
w3stfa11
User
Posts: 13
Joined: 01-Jul-2010
# Posted on: 22-Jul-2010 16:59:41   

This is probably really simple, but I'm unable to find the solution.

What's the best way to do something like this in llblgen?

select acct.Firstname + ' ' + acct.Lastname as FullName from acct

llblgen 2.6 SQL Server 2008

Thanks

MTrinder
User
Posts: 1461
Joined: 08-Oct-2008
# Posted on: 22-Jul-2010 17:37:34   
w3stfa11
User
Posts: 13
Joined: 01-Jul-2010
# Posted on: 22-Jul-2010 20:03:12   

MTrinder wrote:

http://www.llblgen.com/documentation/2.6/Using%20the%20generated%20code/gencode_expressionsaggregates.htm#expressions

Field Expressions are what you are looking for.

Matt

Thank you, Matt.

Btw, it looks like there's a small typo there (under both self-servicing and adapter code)

(OrderDetailsFields.UnitPrice * OrderDetailsFields.Quantity)), 3);

That '3' should be a '2'

MTrinder
User
Posts: 1461
Joined: 08-Oct-2008
# Posted on: 22-Jul-2010 21:28:24   

Good spot simple_smile

We'll update the documentation.

Matt