mushin
Programmer
- Oct 4, 2000
- 49
I wrote a report using a date in my select stmt and all was well. When I made that date a parameter in CR and let it generate the sql stmt I get:
SELECT
TIME_BLOCK1."start_date", TIME_BLOCK1."start_tick", TIME_BLOCK1."end_tick", TIME_BLOCK1."activity_description", TIME_BLOCK1."group_code"
FROM
"ADMIN"."TIME_BLOCK" TIME_BLOCK1
WHERE
TIME_BLOCK1."start_date" = {d '1900-01-01'}
The system crashes each time (Dr.Watson). What is CR doing
with this {d '1900-01-01') stuff ?
If I write a test qry in sql I use '2001-01-01' and get good results.....How do I get CR to generate a good format ?
SELECT
TIME_BLOCK1."start_date", TIME_BLOCK1."start_tick", TIME_BLOCK1."end_tick", TIME_BLOCK1."activity_description", TIME_BLOCK1."group_code"
FROM
"ADMIN"."TIME_BLOCK" TIME_BLOCK1
WHERE
TIME_BLOCK1."start_date" = {d '1900-01-01'}
The system crashes each time (Dr.Watson). What is CR doing
with this {d '1900-01-01') stuff ?
If I write a test qry in sql I use '2001-01-01' and get good results.....How do I get CR to generate a good format ?