Problem with DateTimes and SQL Server 2000

[Chris Gin <Chris_Gin@CARDLINK.CO.NZ>]

Hi,

We are in the process of migrating our SQR programs from Unix/Sybase to
NT/SQL Server 2000. We have come across one serious problem which causes SQR
to GPF.

It seems that if we execute a stored procedure containing a datetime field
in the result set, SQR crashes.

Interestingly, it only happens if the &variable is declared as a datetime in
SQR - if we declare it as a char(), then it seems to work even if the
procedure still returns a datetime.

ie. This fails

execute do=print_data get_accounts into &account_no int, &start_date
datetime

but this works

execute do=print_data get_accounts into &account_no int, &start_date
char(20)


We are using SQR 6.1.3 with SQL Server 2000 running on Windows 2000. The
unix version we were using was version 4.3.2.2.

Does anyone have any ideas on what's causing this?

Thanks,
Chris