Parameter setting as ? only on Win 2000 machines [message #88663] |
Mon, 13 January 2003 00:14 |
prakash
Messages: 24 Registered: October 2001
|
Junior Member |
|
|
Hi All,
We have this Peculiar Problem happening only on Win 2000 machines.
In the Report, we are allowing user to give Start Date Range and End Date Range. Its Fetching the Records, but when viewed SQL Query from SHOW SQL Query it shows something like this.
SELECT
field1,field2
FROM
some_table
WHERE
some_table.DtTm >= ?
some_table.DtTm <= ?
Also If Both Start Date Range and End Date Range are same then query is Formed like below.
SELECT
field1,field2
FROM
some_table
WHERE
some_table.DtTm = ?
But The Same Report Works fine in WinNT (giving Correct Queries and getting correct results).
Crystal Version 8.5
Could Anybody here know what could be causing this Problem only for Win2000 machines and solution if any?
Thank you.
|
|
|
|