How to add a calculated field/column to a browse box?

Hi

I'm embarrased to ask this, but here goes.

I am wanting to add a local data variable into a browse box, but
clearly I need to enter some data into that local variable for each
row of the browse. I cannot figure where to do this, or within which
embed point.

For example, lets say I have a FirstName data field and a Surname data
field. If I want to display the 2 fields concatenated (e.g. John
Smith) within a single column for this row, how woudl I do it?

Thanks

mavenmind@gmail.com wrote:
> Hi
>
> I'm embarrased to ask this, but here goes.
>
> I am wanting to add a local data variable into a browse box, but
> clearly I need to enter some data into that local variable for each
> row of the browse. I cannot figure where to do this, or within which
> embed point.
>
> For example, lets say I have a FirstName data field and a Surname data
> field. If I want to display the 2 fields concatenated (e.g. John
> Smith) within a single column for this row, how woudl I do it?
>
> Thanks
>
On setqueuerecord embeds of this browse, put code: clip(FirstName)&'
'&clip(Surname). Just be sure that column for this variables have enough
spaces for displaying...

You can also use a legacy embed.
First, set up your local variable. Insert the variable into your
browse as needed.
Next, go to the embeds for your browse.
Click on the red icon with the yellow foot at the top (Show Legacy
Embeds).
Under the embed "Browser, Format an element of the queue," put in
your code to set the local variable.
Example:
Loc:szDisplayName = prem:szFirstName & ' ' & prem:szSurname
This will set the value of the local variable for each element of the
queue.
HTH


On Aug 11, 2:37 pm, mavenm...@gmail.com wrote:
> Hi
>
> I'm embarrased to ask this, but here goes.
>
> I am wanting to add a local data variable into a browse box, but
> clearly I need to enter some data into that local variable for each
> row of the browse. I cannot figure where to do this, or within which
> embed point.
>
> For example, lets say I have a FirstName data field and a Surname data
> field. If I want to display the 2 fields concatenated (e.g. John
> Smith) within a single column for this row, how woudl I do it?
>
> Thanks

Many thanks to both of you. I'll have a look. The coding is straight
forward, I was just battling to find a suitable embed point. I'll try
it and see how it goes. I don't recall seeing the SetQueueRecord
embed, but I'll look again, other wise, I'll try the legacy embed
point.

Thanks
Mavenmind