Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 364
  • Last Modified:

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
0
MidWestGirl
Asked:
MidWestGirl
  • 2
1 Solution
 
GJParkerCommented:
Access doesn't support running multiple SQL statements in one query, you'll need to use a server databse such as SQL server.
0
 
GJParkerCommented:
Also just noticed the GetDate() function, this is a SQL server function not used in Access so I assume your book example is for SQL Server and not Access
0
 
mlmccCommented:
I believe this tool can help solve your problem

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

mlmcc
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now