Print Page | Close Window

sql syntax

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=4419
Printed Date: 29 Apr 2024 at 12:42am


Topic: sql syntax
Posted By: crystalME
Subject: sql syntax
Date Posted: 01 Oct 2008 at 8:39am
i am running a very simple query in a crystal report -
 
SELECT 'date'
FROM 'xsale_out'
 
i tried
 
SELECT 'date'
FROM 'xsale_logs'.'xsale_out'
 
but this doesnt work either.
 
i keep getting a syntax error
 
pl advice
 
thanks


Replies:
Posted By: ezeney
Date Posted: 02 Oct 2008 at 9:33pm
Type your sql statements without single quotation marks.

Posted By: crystalME
Date Posted: 03 Oct 2008 at 5:40am
I did ! Didnt work .... the reason I tried it with the single quotes is because in one of the crsystal reports i went into the menu and 'viewed the query ' as generated by CR for that report and noticed it was using single quotes in this manner....

ur views ...

Posted By: Savan
Date Posted: 04 Oct 2008 at 12:16am
check this
 
SELECT xsale_out.date FROM xsale_logs.xsale_out


-------------
Thanks
Savan


Print Page | Close Window