SQL command in javascript

[phoebeching]

Hi, Good Day,

strSQL1=("SELECT tra.*, eng.FULLNAME FROM TBLTRANS.DBF AS tra, ");
strSQL1=strSQL1.concat("TBLENG.DBF AS eng ");
strSQL1=strSQL1.concat("WHERE tra.USERNAME=eng.USERNAME AND ");
strSQL1=strSQL1.concat("tra.STATUS='Approved'");

When I test on the database, it works. When I remove the last row of the sql, it works too...
Can someone tell what's wrong on the above java code when I add in the last row? Thanks in advanced.

[mickscool]

They have written it in RED:
(JAVA not JAVASCRIPT)

That means this is a java specific forum not javascript.

[agent_x91]

Post your question in the JavaScript forum.