🚀 go-pugleaf

I am having trouble switching between BDE and ADO.  This query works with
Tquery but not with ADOQuery. Why?  What do I need to change to get it to
work?


SELECT DISTINCT Al.BoxName, Ch.Product, Al.ChannelID, Al.AlarmType,
Al.AlarmLevel, Al."TimeStamp", Al.Quality
 From  AlarmLog Al
   INNER JOIN WebChannel WCH
   ON  (WCH.ChannelID = Al.ChannelID)
   FULL OUTER JOIN Channel Ch
   ON  (Ch.ChannelID = Al.ChannelID)
   INNER JOIN WebCustomer WCR
   ON  (WCR.CustomerID = WCH.CustomerID) , Box B
  WHERE (WCR.LoginID = "adopt") AND (Al."TimeStamp" > '11/29/2000 11:35:24
AM')
   AND (Al.BoxID LIKE B.BoxID)
 ORDER BY Al."TimeStamp" DESC


I was able to fix things up to the WHERE command can anyone help?

WHERE AlarmLog."TimeStamp" > '11/29/2000 11:35:24 AM'


Thanks for any help,



Steve