MidWestGirl
asked on
Crystal 2008 SQL Command getting error Characters Found Ater End Of SQL Statement
I am working through a tutoriail in my Crystal book on how to update a table to keep track of when a report was last run.
Using Crystal 2008. Trying to insert into an Acesss 2010 table. Below is the statement.
Error Message: Characters found after end of SQL statement.
Anybody know why I am getting this error? Thanks.
INSERT INTO ReportHistory
(ReportName,ReportDate)
VALUES
('Reprot History Subreport', GetDate());
SELECT 1 AS Dummy
Using Crystal 2008. Trying to insert into an Acesss 2010 table. Below is the statement.
Error Message: Characters found after end of SQL statement.
Anybody know why I am getting this error? Thanks.
INSERT INTO ReportHistory
(ReportName,ReportDate)
VALUES
('Reprot History Subreport', GetDate());
SELECT 1 AS Dummy
Access doesn't support running multiple SQL statements in one query, you'll need to use a server databse such as SQL server.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I believe this tool can help solve your problem
http://www.milletsoftware.com/visualcutBenefit.htm
mlmcc
http://www.milletsoftware.com/visualcutBenefit.htm
mlmcc