Syntax error on SQL Expression

[tigerjade]

I have a SQL expression I'm trying to create, but when I check it, I'm getting the error "Syntax Error or Access Violation".

(SELECT Alias1."allMonth0" FROM History as Alias1 WHERE DATEPART(dd, Alias1."histDate") = DATEPART(dd, {?EndDate}) AND DATEPART(mm, Alias1."histDate") = DATEPART(mm, {?EndDate}) AND DATEPART(yy, Alias1."histDate") = DATEPART(yy, {?EndDate}))

Can anyone tell me why I'm getting this error?

Thanks!

tigerjade


"Always code as if the person who ends up maintaining your code will be a violent psychopath who knows where you live." -- Martin Golding

 

[vidru]

Looks like you're trying to use one of your parameter fields ({?EndDate}) in the SQL expression - that's not allowed.

Is the result for display, or is this something you're using in the record selection formula? If it's for display, perhaps you can use a subreport to get the intended allMonth0 value from your History table.

-dave

 

[tigerjade]

Thanx, Dave! That was indeed-y the problem. Actually, the expression is part of me trying to figure out how to get this data to display like I want it to; now I know it won't work.

Thanks!

tigerjade

"Always code as if the person who ends up maintaining your code will be a violent psychopath who knows where you live." -- Martin Golding