2. PHPRunner General questions
  3. [SOLVED]  Using CONCAT -ed Values in another table
This topic is locked
[SOLVED]

 Using CONCAT -ed Values in another table

 		4/26/2011 1:14:36 AM
PHPRunner General questions
A
 angelcause author

I have created a query in SQL, but when i want to retrieve the values of ccfull by lookup wizard from Individual tableto Training Table another table, i cant because the ccfull value is not visible in the lookup wizardlookup table of Individual Table.
SELECT

Id,

Name,

FName,

HomeAdd,

Bmisid,

SchoolName,

SchoolAdd,

Class,

DoB,

Gender,

DesgCC,

CCName,

CCID,

currentdate,

joingdate,

Guardian Contact,

fullsiteaddress,

concat(Bmisid, '-', SchoolName, '/', CCID, '-', CCName) AS ccfull

FROM individualinfo
G
 		Grissom 4/27/2011

Hi,
it should work when you leave the query in its regular status like this

SELECT

Id,

Name,

FName,

HomeAdd,

Bmisid,

SchoolName,

SchoolAdd,

`Class`,

DoB,

Gender,

DesgCC,

CCName,

CCID,

currentdate,

joingdate,

`Guardian Contact`,

fullsiteaddress,

ccfull

FROM individualinfo


and simply add the concat(Bmisid, '-', SchoolName, '/', CCID, '-', CCName) in the Edit as dialog of the ccfull properties as a custom expression. At least that's the way I did it and it works fine.
Best regards,

Chris