Link to home
Start Free TrialLog in
Avatar of MidWestGirl
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
Avatar of GJParker
GJParker
Flag of United Kingdom of Great Britain and Northern Ireland image

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
Avatar of GJParker
GJParker
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Mike McCracken
Mike McCracken

I believe this tool can help solve your problem

http://www.milletsoftware.com/visualcutBenefit.htm

mlmcc