Primary Key in 4Dv15

2017-10-24 Thread Ronnie Teo via 4D_Tech
Hi All, Need to seek some advice in converting a client’s database from v11 to v15. For one of the tables, 4D reported that the primary key contains NULL values upon conversion or that the primary key contains duplicate values. The primary key was defined to be a UUID-type value. So if some

Re: SVG add object question

2017-10-24 Thread Ortwin Zillgen via 4D_Tech
> A nice solution! Just to be sure, it was to use ".svg" rather than "svg"? added some pictures for comparison Regards O r t w i n Z i l l g e n -

Re: Tip: Exporting to a target folder in a package

2017-10-24 Thread David Adams via 4D_Tech
Have you tried Select document? It lets you navigate inside of packages. As far as code goes, you can do whatever you like with a package. I've just been doing that week, doing post-build cleanup. If I remember correctly, the path is something like: ...your long

Tip: Exporting to a target folder in a package

2017-10-24 Thread Peter Jakobsson via 4D_Tech
Hi I have XLIFF applications that generate stuff like custom constants and language resources. Unfortunately, if you use 4D’s desktop navigation commands like “Create Document(“”)” or Select Folder and the like, to allow the user (me !) to locate the target folder for the export, it doesn’t

Re: Tip: Exporting to a target folder in a package

2017-10-24 Thread Koen Van Hooreweghe via 4D_Tech
Hi Peter, Select folder allows you to navigate into a package if you add the Package open constant as ‘options’, third parameter. Same for Select document fourth parameter. HTH Koen > Op 24 okt. 2017, om 12:29 heeft Peter Jakobsson via 4D_Tech > <4d_tech@lists.4d.com> het volgende geschreven:

Re: Primary Key in 4Dv15

2017-10-24 Thread Kirk Brooks via 4D_Tech
Ronnie, You can use the Generate UUID command to fill or regenerate a the key fields. On Tue, Oct 24, 2017 at 2:49 AM, Ronnie Teo via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Hi All, > > Need to seek some advice in converting a client’s database from v11 to v15. > > For one of the tables, 4D

Re: v13 - Renaming a Directory via code.

2017-10-24 Thread James Crate via 4D_Tech
On Oct 20, 2017, at 5:40 PM, Tim Nevels via 4D_Tech <4d_tech@lists.4d.com> wrote: > > On Oct 20, 2017, at 4:30 PM, Chip Scheide <4d_o...@pghrepository.org> wrote: > >>> $command_t:="mv "+GetPOSIXfilePath ($folderPath_t)+" >> had trouble here - >> apparently 4D's (v13) Convert path system to

Re: Primary Key in 4Dv15

2017-10-24 Thread Peter Bozek via 4D_Tech
On Tue, Oct 24, 2017 at 11:49 AM, Ronnie Teo via 4D_Tech < 4d_tech@lists.4d.com> wrote: > > > Need to seek some advice in converting a client’s database from v11 to v15. > > For one of the tables, 4D reported that the primary key contains NULL > values upon conversion or that the primary key

Re: Tip: Exporting to a target folder in a package

2017-10-24 Thread Chuck Miller via 4D_Tech
Why would you let users put stuff in resources folder. The problem is if you are on client server client adds to resource folder how do you get document to server when you next deliver version to client resource gets overwritten when connecting to a new version Chuck Sent from my iPhone >

Re: Primary Key in 4Dv15

2017-10-24 Thread Chuck Miller via 4D_Tech
If you are not too far along I would consider not using 4Ds built in method to create these keys. I and others have posted code to do this. Second you can check tables to ignore primary keys but that means data will not be backed up for those tables Regards Chuck Sent from my iPhone > On

Re: Tip: Exporting to a target folder in a package

2017-10-24 Thread Kirk Brooks via 4D_Tech
Peter, You know Chuck is right - letting user's store stuff in Resources is problematic. I'm working on something right now where I came across this. In my case I'm letting users created button icons. Such files can only be referenced by buttons only when they are in the Resources folder. But the

Re: Primary Key in 4Dv15

2017-10-24 Thread Arnaud de Montard via 4D_Tech
> Le 24 oct. 2017 à 11:49, Ronnie Teo via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > Hi All, > > Need to seek some advice in converting a client’s database from v11 to v15. I follow what others said: generate the unique key _before_ v15, even if it means a 2-steps migration (v11 ->

Re: Tip: Exporting to a target folder in a package

2017-10-24 Thread Peter Jakobsson via 4D_Tech
> On 24 Oct 2017, at 12:39, David Adams via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Have you tried Select document? It lets you navigate inside of packages. > On 24 Oct 2017, at 12:48, Koen Van Hooreweghe via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > Select folder allows you to

RE: Need Plugin Replacement - Miyako's HTML Converter - Windows 10

2017-10-24 Thread Randy Engle via 4D_Tech
Hi Miyako, Thanks again for providing the link to the new plugin. However, On startup, I receive an alert from "Windows Defender" "Windows Defender SmartScreen prevented an unrecognized app from starting Running this app might put your PC at risk" The "offending" app is wkhtmltox_4d.exe Is

RE: Need Plugin Replacement - Miyako's HTML Converter - Windows 10

2017-10-24 Thread Randy Engle via 4D_Tech
Miyako, Many, Many Thanks! I was hoping there was an updated version, but I just didn't seem to be able to find it. Thanks! Randy Engle, Director XC2 Software LLC – XC2LIVE! -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Keisuke Miyako via

Re: Need Plugin Replacement - Miyako's HTML Converter - Windows 10

2017-10-24 Thread Keisuke Miyako via 4D_Tech
your mention of openssl made me suspicious, sounds like you are using a pretty old version of wkhtmltopdf https://github.com/miyako/4d-plugin-html-converter nowadays I prefer link ssleay (openssl) statically, as opposed to a dll. (there are still ways to figure out the version, but it sounds

Need Plugin Replacement - Miyako's HTML Converter - Windows 10

2017-10-24 Thread Randy Engle via 4D_Tech
We've been using Miyako's HTML Converter plugin for quite a while. We mostly use it to convert HTML to PDF docs Works great except: 1. Has an outdated version of OpenSSL (that US government agencies don't like) 2. Plays havoc on Windows 10 displaying graphics/buttons/menus etc.

Re: Primary Key in 4Dv15

2017-10-24 Thread Chuck Miller via 4D_Tech
Sorry I disagree create new key fields in v15 with empty data file just don't use built in stuff roll your own. Then when you open real data file all will work as expected. You can not make type of uuid before v15 as far as I know Regards Chuck Sent from my iPhone > On Oct 24, 2017, at 6:22

The connection for this process has been disrupted or the connection could not be established

2017-10-24 Thread David Ringsmuth via 4D_Tech
The “Semaphore” function is crashing 4D Remote’s connection to 4D Server. While(Semaphore("MySemaphore";300)) // ←- this line crashes // more coding here  End while 4D Remote v15.4 Built 32bit on OSX 10.9.5 4D Server v15.4 Built 32bit on OSX 10.9.5 8GB Ram Core 2 Duo The Client-Server

Re: Primary Key in 4Dv15

2017-10-24 Thread Ronnie Teo via 4D_Tech
Hi Arnaud, Thanks for your reply. I think my mistake was in not launching the v15 structure with an empty data file first because it converted a test data file well. Before v15, it was a mix of field types, some tables had an alpha string, some had long integers, some tables need not have