Hi Clive, > On May 16, 2019, at 14:06, Clive Wilson via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Has anybody done a ShipWorks integration into 4D server. > > I’m trying to get it read & write using v17r4 & ODBC 64Bit. > It recognizes the server and a select works & downloads the whole table. > But the server is rejecting “where” queries. >
It sounds like you are querying your 4D database from ShipWorks using the 4D ODBC driver. A couple of questions/comments: - Can you provide any details on the “reject” error you’re seeing? Without seeing your complete select statement it’s hard to know what might be happening. - Have you been successful querying with a where clause from another tool, such as MSQuery or RazorSQL? It that may be a dedicated query tool maybe easier to debug. Tom Benedict ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************