Re: Write Pro view mode

2019-10-28 Thread Keisuke Miyako via 4D_Tech
this feature was introduced in 17 R5: WP SET VIEW PROPERTIES( wpDoc | ( * ; "zoneWrite") ; prefWritePro) WP Get view properties( wpDoc | ( * ; "zoneWrite")) -> prefWritePro see also: http://forums.4d.fr/Post/FR/18150033/1/18150034 http://forums.4d.fr/Post/FR/18134916/1/18134917

Write Pro view mode

2019-10-28 Thread Mitchell Shiller via 4D_Tech
Hi, Is there a way to procedurally change the view mode of a 4D Write Pro area. I’m using 4D 17R6. I have a widget on a page which is displayed in Page mode. I want to be able to procedurally hide or show the toolbars. Thanks Mitch Sent from my iPad

Re: MySQL connection from 4D

2019-10-28 Thread Jeffrey Kain via 4D_Tech
Are you sure it's version 3? According to Wikipedia that version dates back to the 1990s... :) Jeff > On Oct 28, 2019, at 11:40 AM, Nigel Greenlee via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > Hi > > Does anyone know if 4D is able to connect to a MySQL server running version > 3x?

Re: SV: OPEN DATA FILE gets endless loop

2019-10-28 Thread Chip Scheide via 4D_Tech
Carl, Are you aware that once you point a 4D Database to a datafile - it remembers that data file? So... Open database -> where is my data file Point database to data file -> OK I'm happy! startup completes. You never have to do this again, unless you want to change data files. Chip On Mon,

SV: OPEN DATA FILE gets endless loop

2019-10-28 Thread wangel--- via 4D_Tech
Thanks for your response Jeremy. You have made it clear to me that OPEN DATA FILE first closes the database and then reopen it with the wanted datafile and then repeat that unless something stops it. I tried with $dataPath:="" which obviously was not a particularly brilliant idea. I think I

Re: MySQL connection from 4D

2019-10-28 Thread Tom Benedict via 4D_Tech
The fact that it doesn’t require that you set up an ODBC Source on each machine you want to use it on is easily worth the price. Just pass it a connection string and you’re on your way. Tom Benedict > On Oct 28, 2019, at 12:49, Jim Labos - infobase via 4D_Tech > <4d_tech@lists.4d.com> wrote:

Re: MySQL connection from 4D

2019-10-28 Thread Jim Labos - infobase via 4D_Tech
My suggestion is to try the demo of Pluggers myConnect plugin to try and connect. It will at least help you find the correct syntax or protocol to connect. We have been using it for years with no problem. It's one of those plugins that is worth every penny. For the price it may be worth buying

Re: Cache flushing did not complete... best practice

2019-10-28 Thread Jeffrey Kain via 4D_Tech
Or use a mirror. Highly recommended if the database is important... > On Oct 28, 2019, at 12:59 PM, JPR via 4D_Tech <4d_tech@lists.4d.com> wrote: > > The only 100% accurate way is to restart from the Backup file (made by 4D) > and integrate the current log file(s). This is the only way to be

RE: Cache flushing did not complete... best practice

2019-10-28 Thread JPR via 4D_Tech
[JPR] Hi Justin, Tim's explanation is the good one. When 4D starts flushing the cache, it writes a flag into the .4DD file, and clears it when the flush is complete. Here are some answers: > Are you sure the marker is stored in the data file? Yes, I do. > If I restore a backup from Time

Re: MySQL connection from 4D

2019-10-28 Thread Tom Benedict via 4D_Tech
One other bit of info is that the mySQL database I’m connecting to is version 8.0.17. Sorry I don’t have any experience with version 3.x. Tom Benedict > On Oct 28, 2019, at 09:11, Tom Benedict via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > The only thing I can add is to make sure your ODBC

Re: MySQL connection from 4D

2019-10-28 Thread Tom Benedict via 4D_Tech
The only thing I can add is to make sure your ODBC Driver, ODBC Data Source Administrator and 4D all match with respect to 32bit or 64 bit. I am connecting to a mySQL DB using 4D Native (SQL LOGIN) via mySQL ODBC 8.0 Unicode Driver and 4D v17R4. All 64 bit. HTH, Tom Benedict > On Oct 28,

Re: MySQL connection from 4D

2019-10-28 Thread Nigel Greenlee via 4D_Tech
Jeff Indeed i did look at that(-its overkill for what i need) but it does say on there it works for Mysql V4 and up-hence why i am wondering of 4D in itself won’t connect to and older version. Thanks Nigel > On 28 Oct 2019, at 15:54, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> > wrote:

Re: MySQL connection from 4D

2019-10-28 Thread Jeffrey Kain via 4D_Tech
If you don't get anywhere with SQL LOGIN (which should work, given the right driver settings), Pluggers Software sells the MyConnect plug-in which works perfectly and is very fast/reliable. https://www.pluggers.nl/product/myconnect-plugin/ We've been using it for many years performing crucial

MySQL connection from 4D

2019-10-28 Thread Nigel Greenlee via 4D_Tech
Hi I am pretty sure other people are connecting to MySQL from 4D so i am hoping someone can advise me on where my problems may lie. Pre-amble:— I want to connect to the database of an Asterisk Telephone server. We have established that the database is accessible on the network and using