A
Ana
Hi,
I've a dialog form which interacts with a stored procedure to select a range
of dates. A command moves the data to a report, in theory, but it's not
working.
SELECT dbo.CLAIMS.CLAIM_ID, dbo.CLAIMS.NAME,
dbo.CLAIMS.DATE_IN,
dbo.CLAIMS.SALESMAN_ID
FROM dbo.CLAIMS
WHERE (dbo.CLAIMS.CLAIM_ID = @Salesman) AND
(CAST(dbo.CLAIMS,DATE_IN AS datetime) BETWEEN @D_Start AND @D_End)
The dates are stored in yyyymmdd format for which -> CAST.
The report is blank (no info and no errors), however, when using the Query
Analyzer, the script works fine. Of course, replacing the variables (@) with
fixed data.
What am I doing wrong?
TIA
Ana
I've a dialog form which interacts with a stored procedure to select a range
of dates. A command moves the data to a report, in theory, but it's not
working.
SELECT dbo.CLAIMS.CLAIM_ID, dbo.CLAIMS.NAME,
dbo.CLAIMS.DATE_IN,
dbo.CLAIMS.SALESMAN_ID
FROM dbo.CLAIMS
WHERE (dbo.CLAIMS.CLAIM_ID = @Salesman) AND
(CAST(dbo.CLAIMS,DATE_IN AS datetime) BETWEEN @D_Start AND @D_End)
The dates are stored in yyyymmdd format for which -> CAST.
The report is blank (no info and no errors), however, when using the Query
Analyzer, the script works fine. Of course, replacing the variables (@) with
fixed data.
What am I doing wrong?
TIA
Ana