🚀 go-pugleaf

"Arnie" <none> wrote:
>
>Hi Heinz,
>
>My guess is that the problem is in:
>
>WHERE (tme >= '1138778100' AND tme <= '1138863600') AND (tagName 
>= 'Tag1') ORDER BY tme
>
>Those numbers don't look like any valid date/time format to me. 
>I'd suggest using parameters as you did with the design-time SQL 
>statement.  In fact, I suggest you always use parameters for best 
>efficiency and to make sure you don't have to escape quote 
>characters out of literal strings.
>
>- Arnie 

Hi Arnie,

Thanks for the Feedback! Greatly Appreciated.
I think it'd be nice to pass in parameters to, but with
a changing "WHERE" clause, it seems the TDataModule I have
would get muddled.

I did manage to track down, though not completely understand
why one process works and not the other. More or less,
it's an educated guess.

It came down to the way the DB fields were structured.

The DB Table has fields as strings,
and a VIEW, I "SELECT" from refers to this DB Table.
Strangely, in the view it does Date Mathematics on the string
fields (which is a date in string format), and the final result
is it returns a date (which is correct based on the math). 

The numbers are a calculated date in UTC seconds.

That was what was killing the Query. 
So I type casted the "View" to return the Date as a String, 
and it works fine now. 

I guess it's a DB thing where it is flexible with 
field type conversions with in the database software, and doesn't do the same when it's coming from my code, as it must be a defined type.

Well... at least it works now.

Thanks,
Heinz