SQL Server Timestamp field reading as WideString

[teri 0]

Hello -

 

I wrote an application that uses a TFDQuery to retrieve data from a SQL Server. A few of the fields in the query are typed as TSQLTimeStampField. Everything works beautifully when I run the application, either from within the Delphi IDE or as a standalone app.

 

However, when my colleague, who needs to use the application, tries to run it, she gets the following error.

 

 

 

We're using version 2019 of SQL Server, and the data field in the SQL table is typed as DateTime2(0).

 

I tried changing CollectionTime's field type to WideString then DateTime, but each threw Debugger Exceptions.

 

I'm at a loss as to how to remedy this. Any suggestions?

 

Teri

Edited October 19, 2023 by teri
Added information