character found after end of sql statement
-
hi everybody I want to execute a query in excel using Microsoft.ACE.OLEDB.12.0 since database is in dbase iv query is
SELECT A.EMPCODE,c.EMPNAME,A.REMCODE,emprem,B.REMSHNA,sum(amt_add*nomnt) as amt ;
from d:\staff\file\fbp11 a, d:\staff\file\reim b, d:\staff\file\empl c where a.remcode = b.remcode and a.empcode = c.empcode ;
and !b.reielg and a.emprem in (select emprem from d:\staff\file\fbp11 where month = '201111') group by emprembut it says "character found after end of sql statement " what could be the problem
-
hi everybody I want to execute a query in excel using Microsoft.ACE.OLEDB.12.0 since database is in dbase iv query is
SELECT A.EMPCODE,c.EMPNAME,A.REMCODE,emprem,B.REMSHNA,sum(amt_add*nomnt) as amt ;
from d:\staff\file\fbp11 a, d:\staff\file\reim b, d:\staff\file\empl c where a.remcode = b.remcode and a.empcode = c.empcode ;
and !b.reielg and a.emprem in (select emprem from d:\staff\file\fbp11 where month = '201111') group by emprembut it says "character found after end of sql statement " what could be the problem
Start with removing the semicolons at the end of each line. A semicolon denotes the end of a statement.
Light moves faster than sound. That is why some people appear bright, until you hear them speak. List of common misconceptions
-
Start with removing the semicolons at the end of each line. A semicolon denotes the end of a statement.
Light moves faster than sound. That is why some people appear bright, until you hear them speak. List of common misconceptions