Who's On?

	Membership:
	Latest: John Bonin
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5270

	People Online:
	Visitors: 395
	Members: 0
	Total: 395

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1375
Roger French	1315
mark.cook	1244

ODBC Connection problem.

3 Replies

0 Subscribed to this topic

22 Subscribed to this forum

Sort:

Author

Messages

jjcyeshua

Veteran Member Send Private Message

Posts: 49

9/12/2007 10:17 PM

Hello.. I need help. I am having problem creating sql expression). When i tried creating an sql command, it works perfectly, but when i just create sql expressions thats when i get the error message.. Also when I use sql command to pull all the data that I need, the report runs very..very..very slow…. Please help… Thanks

Error in compiling SQL Expression:
Database Connector Error: '42000:[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'select'.[Database Vendor Code:156]'.

Thanks

John Henley

Posts: 3351

9/13/2007 1:23 PM

Hi Jonathan,
The SQL Expression is not a full SELECT / SQL statement. It's just a replacement for a formula, where instead of Crystal doing the processing after retrieving the data, you're forcing the database to do the processing BEFORE returning the results to Crystal. An example would be a MONTH(datefield) function.

Take a look at slide 32 of this presentation:
https://www.lawsonguru.co...0Crystal.pdf#search="sql expressions"

jjcyeshua

Veteran Member Send Private Message

Posts: 49

9/13/2007 10:52 PM

Thanks.. John.. do you happen to know where i can find a resource on crystal sql expression syntax.

John Henley

Posts: 3351

9/13/2007 11:40 PM

See if this explains it for you:
http://www.ml-crystal.com.../sql-expressions.htm