Justin,
Thanks...
I've done that multiple times and nada. The error being returned by the driver
is that it says you can't convert an "ntext" to "timestamp":
Error Desc = Error #206 (Operand type clash: ntext is incompatible with
datetim)
I did not design the SQL database and don't really have any control over it,
just need to find a way to query on both date and time.
Thanks!
Steve
-----Original Message-----
From: Justin Will [mailto:[email protected]]
Sent: Tuesday, July 10, 2018 2:50 PM
To: [email protected]; 4D iNug Technical <[email protected]>
Subject: RE: SQL Statement Assistance
Steve
Try removing the single quotes in your text variable assignment and retry your
initial example.
Justin
**********************************************************************
4D Internet Users Group (4D iNUG)
FAQ: http://lists.4d.com/faqnug.html
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:[email protected]
**********************************************************************
