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
**
