Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: sql syntax Post Reply Post New Topic
Author Message
crystalME
Newbie
Newbie


Joined: 30 Sep 2008
Online Status: Offline
Posts: 8
Quote crystalME Replybullet Topic: sql syntax
    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
IP IP Logged
ezeney
Newbie
Newbie
Avatar

Joined: 05 Sep 2008
Location: United States
Online Status: Offline
Posts: 14
Quote ezeney Replybullet Posted: 02 Oct 2008 at 9:33pm
Type your sql statements without single quotation marks.

Edited by ezeney - 02 Oct 2008 at 9:33pm
IP IP Logged
crystalME
Newbie
Newbie


Joined: 30 Sep 2008
Online Status: Offline
Posts: 8
Quote crystalME Replybullet 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 ...
IP IP Logged
Savan
Senior Member
Senior Member
Avatar

Joined: 14 Dec 2007
Location: India
Online Status: Offline
Posts: 162
Quote Savan Replybullet Posted: 04 Oct 2008 at 12:16am
check this
 
SELECT xsale_out.date FROM xsale_logs.xsale_out
Thanks
Savan
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.047 seconds.