Re: ShipWorks ODBC integration
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 **
Compatibility with Widows 10 v1809
I have reports of compatibility issues with windows 10 v1809. It appears that 4D is attempting to write an IP address to the CSC folder, one of windows system folders. This is when launching the 4D v13 client. v13 running on a Windows 10 v1709 client works fine. Any suggestions about what to try? Cheers, Peter Adam Adam, Zievert & Associates P/L e: peter.a...@me.com Skype Phone: +61 3 9016 379 t: +61 3 9836 3539 m: 0419 552 462 www.adamzievert.com.au ** 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 **
Re: v17 64Bit Label Format Numbers
The good news is that you can enter this into the field on the label: String([Inventory]Sell1;"$###,##0.00"). The bad news is that it seems only one label from the selection will print when that is on the form :( Keith - CDI > On May 16, 2019, at 5:25 PM, Clive Wilson via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Switching to v17 64Bit with the new Label editor. > > We print out price tickets in real numbers. We used to be able to set the > number format in the label eg. “$#,##0.00” . > Has this feature bean removed in the new “improved” label editor ? > > > Clive Wilson > (386) 235-6442 > cliv...@gmail.com > > > > ** > 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 > ** ** 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 **
v17 64Bit Label Format Numbers
Switching to v17 64Bit with the new Label editor. We print out price tickets in real numbers. We used to be able to set the number format in the label eg. “$#,##0.00” . Has this feature bean removed in the new “improved” label editor ? Clive Wilson (386) 235-6442 cliv...@gmail.com ** 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 **
ShipWorks ODBC integration
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. Thanks Clive Wilson (386) 235-6442 cliv...@gmail.com ** 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 **
Re: Migrating 4D Write Pictures to 4D Write Pro Objects
Hi Armin, Thanks I’ll give it a try. Appreciate, John… > On May 16, 2019, at 12:00 PM, 4d_tech-requ...@lists.4d.com wrote: > > John, change the codec and it works > > The component has an error on this line and you have to change the Codec to > 4pct > > PICTURE TO BLOB($1;$blob;".4pct") > > Regards Armin ** 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 **
