[Firebird-net-provider] Issue with timestamp comparison?

[JS.staff <jsp...@ec...>]

Are there any known issues with comparing equality of timestamps?? with
.NET datetime values.
=20
I've got a table with a PK made up of int 'numberpk', varchar(20)
'textpk' and a timestamp 'whenstarted'.
=20
I do something like : select max(whenstarted) from mytable where
numberpk =3D @num and textpk =3D @text
=20
This correctly returns a datetime into .net.
=20
Then I do: select * from mytable where numberpk =3D @num and textpk =3D
@text and whenstarted =3D @valuefromlastquery
=20
Although the first query returns a value, the second sometimes fails to
return a row! Possibly some precision failure in the conversion between
FB timestamps and .NET datetimes????
=20
A test case is difficult to provide, because if I type the date into the
record again, the problem goes away!
=20
Thanks,
=20
John