Re: UUID version 4 needed

2018-07-07 Thread Jeremy French via 4D_Tech
Is the version number being decoded correctly? According to Wikipedia, there are several variants of encoding UUIDs: 1) Little-endian 2) Big-endian 3) Mixed-endian To decode the UUID version number, you need to know what encoding variant was used: Little-endian, Big-endian or Mixed-endian.

Re: Any way to determine how a field's data storage is set?

2018-07-07 Thread Jeremy French via 4D_Tech
Hi John, In the exported XML structure, I believe there are 2-attributes whose presence/absence indicate where the field’s data will be stored: 1) in the record. 2) in the data file but outside of the record. 3) in an external file outside of the data file. The 2-XML attributes are: 1)

Relative SET EXTERNAL DATA PATH on external disk

2018-07-07 Thread JOHN BAUGHMAN via 4D_Tech
If my development database is sitting on an external disk, GET EXTERNAL DATA, previously saved using the full path, returns… "T75-TRANS01:OrthoPro_v16 R6:Patient_Image_Library:_09719:Initial:_09719_Initial_3.jpg” Note that T75-TRANS01 is the name of the external drive and "OrthoPro_v16

Re: UUID version 4 needed

2018-07-07 Thread Jeffrey Kain via 4D_Tech
If you look at the MSDN site, there are a a couple of different ways to generate a UUID. I'm pretty sure it's not a bug in Windows but rather 4D calling a different function... :) https://docs.microsoft.com/en-us/windows/desktop/api/rpcdce/nf-rpcdce-uuidcreatesequential

Re: Any way to determine how a field's data storage is set?

2018-07-07 Thread JOHN BAUGHMAN via 4D_Tech
> On Jul 7, 2018, at 6:04 AM, Patrick Emanuel via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > XML export of the structure Ok that will tell me if Outside data file is selected, but nothing about the other 2 options. I can use this even if it does seem a bit cumbersome. Thanks John Baughman

Re: UUID version 4 needed

2018-07-07 Thread npdennis via 4D_Tech
> Is there anybody that can confirm that on WIndows 4D generates it the wrong > way”? If I generate one on Mac OS X, 4D v16.3 I get what looks like version 4: 9D93513FEC514B3DA0FC0894C87C41C6 If I use the same code on Windows 8 I get one that does not look like version 4:

Re: Any way to determine how a field's data storage is set?

2018-07-07 Thread Patrick Emanuel via 4D_Tech
Hi, Explore the XML export of the structure. You'll find what you are looking for. Patrick - Patrick EMANUEL Administrator www.association-qualisoft.eu (Soft1002, Simply Asso & QS_Toolbox) -- Sent from:

Re: Cannot delete if related many issue

2018-07-07 Thread Chip Scheide via 4D_Tech
Arnaud, a couple of other thoughts - are any/all of the related tables very large in record count size? this might be a cache thing... maybe 4D is 'thrashing' loading indexes etc, then having to throw them away for the next table(s) and then loading them again. -- you might be able to

Any way to determine how a field's data storage is set?

2018-07-07 Thread JOHN BAUGHMAN via 4D_Tech
I cannot find a way to do this programmatically. I am referring to Outside the data file/In data file/in record. Get external data path either returns a path or an empty string. The empty string provides a hint in the it is “probably not set to Outside the data file, but is inconclusive and

Re: Cannot delete if related many issue

2018-07-07 Thread Chip Scheide via 4D_Tech
Arnaud, I don't use deletion control either... however, maybe there is a circular relation* and 4D iterates through this relational circle either a fixed (large) number of times, or after some (large) number of iterations through the circle 4D finally finds that there are no related children

RE: UUID version 4 needed

2018-07-07 Thread Chip Scheide via 4D_Tech
my only thought would be that 4D has either a bug in the windows version of UUID generator, or it uses/expects some underlying mechanism at the OS level which is broken. > Hi Chip, Keith, > > Thanks Chip for the tip! > But still, isn't it strange that 4D v16 does generate UUID where on >

Re: [ANN] Q2Pix 1.0b2 available

2018-07-07 Thread JOHN BAUGHMAN via 4D_Tech
Danis, How backward compatible will an existing deployed QPix installation be with Q2Pix? I am upgrading my QPix using client to R6 this weekend in anticipation of a follow on 64bit upgrade which will require upgrading to Q2Pix. How soon do you expect to be out of beta? Do you think

Re: UUID version 4 needed

2018-07-07 Thread Jeffrey Kain via 4D_Tech
Strange in light of what Miyako wrote that 4D just calls through to the OS. I guarantee you that the Win32API plug-in call is an unmodified OS call - maybe that’s your workaround for now? I tested on v17 final candidate Windows 64-bit and saw the same as the others - no ‘4’ in that position.

Re: UUID version 4 needed

2018-07-07 Thread Arnaud de Montard via 4D_Tech
> Le 6 juil. 2018 à 16:05, Piotr Chabot Stadhouders via 4D_Tech > <4d_tech@lists.4d.com> a écrit : > > And in fact, my 4D generated UUID is rejected by the web service, saying it > isn't a 4 version UUID with

Re: Cannot delete if related many issue

2018-07-07 Thread Jody Bevan via 4D_Tech
Arnaud de Montard: Since 4D v2.0.10 I have not used it (probably not in 4D way back then). When we used to permit actual deletions but we handled all record deletions in our code especially for related records that also needed to go. Now we do not permit actual deletions - we just flag records

RE: UUID version 4 needed

2018-07-07 Thread Piotr Chabot Stadhouders via 4D_Tech
Hi Chip, Keith, Thanks Chip for the tip! But still, isn't it strange that 4D v16 does generate UUID where on WIndows the 15th hex digit is a 4 Thanks Keith for testing this on OSX, but unfortunately I need this on both platforms. Is there anybody that can confirm that on WIndows 4D generates

[ANN] Q2Pix 1.0b2 available

2018-07-07 Thread Danis Georgiadis via 4D_Tech
We are excited to announce the availability of Q2Pix 1.0b2, the second public beta release of the modern successor to QPix. Many thanks to our beta testers for their valuable reports and feedback. Hoping you will like Q2Pix as much as we do, we look forward to hearing from you. Kind regards,

Re: Cannot delete if related many issue

2018-07-07 Thread Arnaud de Montard via 4D_Tech
> Le 5 juil. 2018 à 13:12, Arnaud de Montard via 4D_Tech <4d_tech@lists.4d.com> > a écrit : > > I have a database in which Deletion Control is set as in the object for a lot > of relations. Today, deleting 10 records in a table having ~2 billion records > took an incredible time, cache as