Sep 20, 2013; 03:15
DigitEL@Gmail
[FMPro] SQLtimestampFind
Greetings >
FMP11
A bit of a snag... I have a script grab the LastRunTimeStamp in FM, go to an SQL table generated using the ActualTechnologies plugin and perform a find on the TimeStamp field for records greater than the LastRunTS, but instead I get the following:
9/20/2013 2:47:44 AM from FM LastRunTimeStamp
But sets the field in SQL with the period and asterisk and thus finds all records...
9/20/2013 2:47:44.* AM
Fields on both sides are formatted as TimeStamp.
Any ideas why this is happening and how to correct it?
BTW the Find is using a variable for the FM data.
TIA
--
ForNow
DigitEL
#############################################################
This message is sent to you because you are subscribed to
the mailing list FMPro
FMPro@lists.lassosoft.com
To unsubscribe, E-mail to: <FMPro-unsubscribe@lists.lassosoft.com>
Send administrative queries to <FMPro-request@lists.lassosoft.com>
Sep 26, 2013; 10:19
DigitEL @ Shaw
Re: [FMPro] SQLtimestampFind