Aaron
|
| Posted: 06/28/2002, 7:15 AM |
|
I have a Question/Problem. I have a table called builder, with a field holding the primary key of the SalesRep. The SalesRep table has seperate First and Last name fields. I would like to be able to show a concatenated field with the first and last names of the sales reps in the Builder Grid form. Does anyone have an idea of how to do this within Code Charge, without having to edit the code. I am using JSP and have no problem editing the code, but then when I make a change in CodeCharge and regenerate I have to go back into the code and reapply the changes I had made.
Thanks,
|
|
|
 |
Chris K.
|
| Posted: 06/28/2002, 11:10 AM |
|
You could either specify custom SQL query that selects concatenated fields as as an alias (SELECT concat(firstname,' ',lastname) AS fullname FROM ....), or could write Before Show event that sets column value as concatenation of two hidden fields with first and last name. Event handlers are preserved during generation, so no reapply would be needed.
|
|
|
|
www.labs4.com
|
| Posted: 06/28/2002, 5:34 PM |
|
I just replied to the same question here http://www.gotocode.com/disc_viewt.asp?mid=5587& and it wasn't the first time, why don't you search the forum first before asking?
Josef
|
|
|
|
|
