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 

- 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 

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

Reply via email to