Crystal Reports sql syntax

Technical Questions
Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions

Topic: sql syntax

Author	Message
crystalME Newbie Joined: 30 Sep 2008 Online Status: Offline Posts: 8	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 Logged

ezeney Newbie Joined: 05 Sep 2008 Location: United States Online Status: Offline Posts: 14	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 Logged

crystalME Newbie Joined: 30 Sep 2008 Online Status: Offline Posts: 8	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 Logged

Savan Senior Member Joined: 14 Dec 2007 Location: India Online Status: Offline Posts: 162	Posted: 04 Oct 2008 at 12:16am
	check this SELECT xsale_out.date FROM xsale_logs.xsale_out
	Thanks Savan
	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.039 seconds.