Tim,
This is a MS SQL server database and it queries just fine using a static
timestamp value, as shown below:
Begin SQL
SELECT RecordID, Mach_ID, Energy_1, Energy_2, Energy_3
FROM DMM_TTX_HISTORIAN
WHERE TimeStamp >= '04/06/2018 07:58:00 AM'
AND TimeStamp <= '04/06/2018 09:01:00 AM'
INTO :al_temp1, :at_temp1, :ar_temp1, :ar_temp2, :ar_temp3
End SQL
If I run that query I get 4 records returned, which is correct, so I know the
query if fine.
My problem is now trying to make the static timestamp values being queried on
dynamic.
Steve
-----Original Message-----
From: Timothy Penner [mailto:[email protected]]
Sent: Tuesday, July 10, 2018 1:44 PM
To: [email protected]; '4D iNug Technical' <[email protected]>
Subject: RE: SQL Statement Assistance
There may be multiple things wrong here;
First, is your field actually named TimeStamp?
If so, this is a SQL Reserved word and shouldn’t be used as a field identifier.
Let's start with that first.
-Tim
**********************************************************************
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]
**********************************************************************
