Re: UUID version 4 needed

[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.

Otherwise you get the wrong answer.

See: https://en.wikipedia.org/wiki/Universally_unique_identifier#Encoding

> On Jul 6, 2018, at 10:05 AM, Piotr Chabot Stadhouders via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Has this something to do with byte swapping or something? 

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
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: Any way to determine how a field's data storage is set?

[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) text_switch_size
2) outside_blob

When present, the attribute "text_switch_size" indicates the data size above 
which the data will be stored outside of the record, either inside or outside 
of the data file. 

When present, “outside_blob" indicates the data will be stored outside of the 
data file.

I believe this storage location information applies only to the behavior of new 
records.

Also, it seems that if “text_switch_size” is zero, it's absent from the XML 
export. And if “outside_blob” is false, it too is absent from the XML export.

Does this help?

- Jeremy French

> On Jul 7, 2018, at 11:43 AM, JOHN BAUGHMAN via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Outside the data file/In data file/in record... 
> 
> ...would like to know specifically which option is selected in the structure.

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Relative SET EXTERNAL DATA PATH on external disk

[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 R6” 
is the database folder.

If I set the path using to SET EXTERNAL DATA PATH to…

“...:Patient_Image_Library:_09719:Initial:_09719_Initial_3.jpg”

Now GET EXTERNAL DATA returns…

“Macintosh 
HD:...:Patient_Image_Library:_09719:Initial:_09719_Initial_3.jpg”

Which of course fails miserably. 

Is my relative path incorrect? Docs say that a relative path should work no 
matter where the database might be moved to or renamed. Perhaps not so true if 
moved to an external drive?

John Baughman
1331 Auwaiku Street
Kailua, Hawaii  96734
(808) 262-0328
john...@hawaii.rr.com


**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
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: UUID version 4 needed

[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
https://docs.microsoft.com/en-us/windows/desktop/api/combaseapi/nf-combaseapi-cocreateguid

I just looked at the source to the Win32API plug-in, and it's calling 
UuidCreate. 4D must be calling one of the other variations.

https://github.com/OrchardSoftware/4D-Win32API/blob/master/Source%20Code/Visual%20C%2B%2B%20Project/4DPlugin.c

(See line 1762)



--
Jeffrey Kain
jeffrey.k...@gmail.com




> On Jul 7, 2018, at 1:16 PM, npdennis via 4D_Tech <4d_tech@lists.4d.com> wrote:
> 
> If I use the same code on Windows 8 I get one that does not look like version 
> 4:
> 
>   06CEFE7DB60C7847884A346274C254DB

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
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: Any way to determine how a field's data storage is set?

[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
1331 Auwaiku Street
Kailua, Hawaii  96734
(808) 262-0328
john...@hawaii.rr.com
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
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: UUID version 4 needed

[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:

06CEFE7DB60C7847884A346274C254DB

Neil


--
Neil Dennis
4D Developer since 1990


GreaText - Designing Software for the Way You Work
716 East 1850 N
North Ogden, UT 84414

mailto:npden...@greatext.com
http://www.greatext.com/

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
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: Any way to determine how a field's data storage is set?

[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: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
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: Cannot delete if related many issue

[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 see/test this by watching/adjusting the cache, and/or 
watching disk usage. 
- alternatively, maybe for some (unexplainable) reason 4D is NOT using the 
index(es) and/or relation directly and doing a sequential search on each 
related table.  
-- you might be able to test this by using test data which has a small number 
of records in the related tables, and then add more and more seeing if the 
deletion slows down (linearly?).

Chip

> Arnaud,
> I use Delete Related records a fair amount usually without any issues.
> However, as John suggests, the sorts of records that may be deleted this
> way are usually limited to linking records, prefs and things like that.
> 
> It can be frustrating when a record fails to delete for no known reason
> only to find, eventually, Deletion Control was to blame because some record
> had a relation to some other record that was locked. I don't recall the
> error message when that happens but I think it doesn't necessarily tell you
> where the record that prevented deletion is.
> 
> On Sat, Jul 7, 2018 at 4:20 AM Arnaud de Montard via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> 
>> ​...
>> 
> 
> The deleted records had no "sons". Searching if there are sons with
>> QUERY(sons;foreign key=primary key) takes a few milliseconds. MSC says
>> everything's OK. 4D v14r5.
>> 
> ​Do any of the 'sons' rec​ords have empty foreign key fields?

Hell is other people 
 Jean-Paul Sartre
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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

[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 requires testing a specific record field. 

I would like to know specifically which option is selected in the structure.

Thanks,

John


John Baughman
1331 Auwaiku Street
Kailua, Hawaii  96734
(808) 262-0328
john...@hawaii.rr.com

> On Jul 7, 2018, at 4:54 AM, JOHN BAUGHMAN via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> 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 the beta is 
> solid enough for deployment, or should I wait until you are out of beta?
> 
>   I want to thank you for continuing your commitment to QPix. It has been 
> perhaps the most reliable and useful plug-in that I have deployed and your 
> support over the years has been great. I look forward to working with the new 
> version.
> 
> Thanks,
> 
> John
> 
> 
> John Baughman
> 1331 Auwaiku Street
> Kailua, Hawaii  96734
> (808) 262-0328
> john...@hawaii.rr.com
> 
>> On Jul 7, 2018, at 1:27 AM, Danis Georgiadis via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>> 
>> 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,
>> 
>> - Escape Tech
>> 
>> ~~~
>> 
>> 
>> About Q2Pix
>> ===
>> 
>> Q2Pix is the first of a new generation of 4D Extensions. We no longer call 
>> them "plug-ins" because they are more than that. The architecture of these 
>> new products comprises 4D plug-ins, components, frameworks, open-source 
>> libraries; they work with the latest 4D versions; they make extensive use of 
>> modern 4D features such as subforms, objects and JSON.
>> 
>> 
>> Key features
>> 
>> 
>> - Full 32/64-bit, 4D v16/64 or later recommended.
>> - QuickTime-free.
>> - Exposes an object model.
>> - Document-based programming interface.
>> - A rich viewer widget with menubar, toolbar and sidebar written in pure 4D.
>> - Full support of XMP metadata.
>> - A generic XMP data editor written in pure 4D.
>> - Extensive PDF support.
>> - Extensive acquisition capabilities: TWAIN, ImageCapture, WIA.
>> - Batteries included: no third-party stuff to install.
>> 
>> Product page: 
>> Beta download: 
>> 
>> Beta 2 news
>> ===
>> 
>> Plug-in fixes:
>> 
>> * Plug-in area crash under v17 on macOS.
>> * Wrong path names of acquired images on Windows.
>> * Minor memory leaks.
>> 
>> New features:
>> 
>> * In auto-zoom mode the plug-in area can now stretch/enlarge the image.
>> * Scrollbars auto-hide as appropriate. This behavior and individual 
>> scrollbar visibility can be controlled via the area properties.
>> * Added the following effect filters:
>> + Brightness
>> + Contrast (macOS only, atm)
>> + GaussianBlur
>> + Invert
>> 
>> In the components:
>> 
>> * ImgDlog_GetEffect presents an effect dialog with a preview and returns the 
>> selected filter name and parameters.
>> * ImgArea_ApplyEffect presents an effect dialog and applies the selected 
>> filter to image in the area (live preview).
>> * The Image Control widget supports the effect dialog via the ImgCmd_Effect 
>> handler method. The default widget configuration includes this option under 
>> the Image menu.
>> * Minor fixes.
>> 
>> Added to the docs:
>> 
>> * Raster Image Filters in the Programming guide.
>> * Raster Filter Reference in the Reference section.
>> * Various fixes.
>> 
>> ~~~
>> 
>> **
>> 4D Internet Users Group (4D iNUG)
>> FAQ:  http://lists.4d.com/faqnug.html
>> 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)
> FAQ:  http://lists.4d.com/faqnug.html
> 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: Cannot delete if related many issue

[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 records?

* just in case :)(-> = relation, letter = table)
A -> B -> C -> D -> A

> Arnaud,
> I use Delete Related records a fair amount usually without any issues.
> However, as John suggests, the sorts of records that may be deleted this
> way are usually limited to linking records, prefs and things like that.
> 
> It can be frustrating when a record fails to delete for no known reason
> only to find, eventually, Deletion Control was to blame because some record
> had a relation to some other record that was locked. I don't recall the
> error message when that happens but I think it doesn't necessarily tell you
> where the record that prevented deletion is.
> 
> On Sat, Jul 7, 2018 at 4:20 AM Arnaud de Montard via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> 
>> ​...
>> 
> 
> The deleted records had no "sons". Searching if there are sons with
>> QUERY(sons;foreign key=primary key) takes a few milliseconds. MSC says
>> everything's OK. 4D v14r5.
>> 
> ​Do any of the 'sons' rec​ords have empty foreign key fields?

Hell is other people 
 Jean-Paul Sartre
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
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: UUID version 4 needed

[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 
> 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 it 
> "the wrong way"?
> Or is there an explanation for this?
> 
> Gr,
> 
> Piotr
> 
>> -Oorspronkelijk bericht-
>> Van: Chip Scheide <4d_o...@pghrepository.org>
>> Verzonden: vrijdag 6 juli 2018 18:02
>> Aan: 4D iNug Technical <4d_tech@lists.4d.com>
>> CC: Piotr Chabot Stadhouders 
>> Onderwerp: RE: UUID version 4 needed
>> 
>> after just a bit of google-fu
>> I found this php routine to generate a UUID. Since, in principle 4D 
>> supports
>> php... maybe you can just generate your own.
>> 
>> if (!function_exists('com_create_guid')) {
>>   function com_create_guid() {
>> return sprintf( '%04x%04x-%04x-%04x-%04x-%04x%04x%04x',
>> mt_rand( 0, 0x ), mt_rand( 0, 0x ),
>> mt_rand( 0, 0x ),
>> mt_rand( 0, 0x0fff ) | 0x4000,
>> mt_rand( 0, 0x3fff ) | 0x8000,
>> mt_rand( 0, 0x ), mt_rand( 0, 0x ), mt_rand( 0, 0x )
>> );
>>   }
>> }
>> 
>> source:
>> https://helloacm.com/how-to-create-uuid-in-php/
>> 
>> also there is a bunch of discussion on StackOVerflow regarding generating a
>> UUID, in various languages, and platforms
>> 
>> 
>> On Fri, 6 Jul 2018 15:33:48 +, Piotr Chabot Stadhouders via 4D_Tech
>> wrote:
>>> Hi,
>>> 
>>> The Win32API command sys_GetGUID does return a version 4 UUID
>>> 
>>> So on Windows :
>>> Win32API generates a version 4 UUID --> 13th hex digit is a 4
>>> 4D v16 does not generate a version 4 UUID --> 15th hex digit is a 4
>>> 
>>> 
 -Oorspronkelijk bericht-
 Van: Dennis, Neil 
 Verzonden: vrijdag 6 juli 2018 16:25
 Aan: Piotr Chabot Stadhouders ; 4D iNug
 Technical <4d_tech@lists.4d.com>
 Onderwerp: RE: UUID version 4 needed
 
> And in fact, my 4D generated UUID is rejected by the web service,
> saying it
 isn't a 4 version UUID
 
 Very possible, it has been a while since I looked into it and I was
 going off of my
 fuzzy memory.
 
 Neil
 
 
 
 
 --
 
 
 Privacy Disclaimer: This message contains confidential information and is
 intended only for the named addressee. If you are not the named addressee
 you should not disseminate, distribute or copy this email. Please
 delete this
 email from your system and notify the sender immediately by replying
 to this
 email.  If you are not the intended recipient you are notified that
 disclosing,
 copying, distributing or taking any action in reliance on the
 contents of this
 information is strictly prohibited.
 
 The Alternative Investments division of UMB Fund Services provides a
 full range
 of services to hedge funds, funds of funds and private equity
 funds.  Any tax
 advice in this communication is not intended to be used, and cannot
 be used, by
 a client or any other person or entity for the purpose of (a)
 avoiding penalties
 that may be imposed on any taxpayer or (b) promoting, marketing, or
 recommending to another party any matter addressed herein.
>>> 
>> 
>> **
>>> 4D Internet Users Group (4D iNUG)
>>> FAQ:  http://lists.4d.com/faqnug.html
>>> Archive:  http://lists.4d.com/archives.html
>>> Options: https://lists.4d.com/mailman/options/4d_tech
>>> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
>>> 
>> 
>> **
>> ---
>> Gas is for washing parts
>> Alcohol is for drinkin'
>> Nitromethane is for racing
> 

Hell is other people 
 Jean-Paul Sartre
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
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: [ANN] Q2Pix 1.0b2 available

[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 the beta is solid 
enough for deployment, or should I wait until you are out of beta?

I want to thank you for continuing your commitment to QPix. It has been 
perhaps the most reliable and useful plug-in that I have deployed and your 
support over the years has been great. I look forward to working with the new 
version.

Thanks,

John


John Baughman
1331 Auwaiku Street
Kailua, Hawaii  96734
(808) 262-0328
john...@hawaii.rr.com

> On Jul 7, 2018, at 1:27 AM, Danis Georgiadis via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> 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,
> 
> - Escape Tech
> 
> ~~~
> 
> 
> About Q2Pix
> ===
> 
> Q2Pix is the first of a new generation of 4D Extensions. We no longer call 
> them "plug-ins" because they are more than that. The architecture of these 
> new products comprises 4D plug-ins, components, frameworks, open-source 
> libraries; they work with the latest 4D versions; they make extensive use of 
> modern 4D features such as subforms, objects and JSON.
> 
> 
> Key features
> 
> 
> - Full 32/64-bit, 4D v16/64 or later recommended.
> - QuickTime-free.
> - Exposes an object model.
> - Document-based programming interface.
> - A rich viewer widget with menubar, toolbar and sidebar written in pure 4D.
> - Full support of XMP metadata.
> - A generic XMP data editor written in pure 4D.
> - Extensive PDF support.
> - Extensive acquisition capabilities: TWAIN, ImageCapture, WIA.
> - Batteries included: no third-party stuff to install.
> 
> Product page: 
> Beta download: 
> 
> Beta 2 news
> ===
> 
> Plug-in fixes:
> 
> * Plug-in area crash under v17 on macOS.
> * Wrong path names of acquired images on Windows.
> * Minor memory leaks.
> 
> New features:
> 
> * In auto-zoom mode the plug-in area can now stretch/enlarge the image.
> * Scrollbars auto-hide as appropriate. This behavior and individual scrollbar 
> visibility can be controlled via the area properties.
> * Added the following effect filters:
>  + Brightness
>  + Contrast (macOS only, atm)
>  + GaussianBlur
>  + Invert
> 
> In the components:
> 
> * ImgDlog_GetEffect presents an effect dialog with a preview and returns the 
> selected filter name and parameters.
> * ImgArea_ApplyEffect presents an effect dialog and applies the selected 
> filter to image in the area (live preview).
> * The Image Control widget supports the effect dialog via the ImgCmd_Effect 
> handler method. The default widget configuration includes this option under 
> the Image menu.
> * Minor fixes.
> 
> Added to the docs:
> 
> * Raster Image Filters in the Programming guide.
> * Raster Filter Reference in the Reference section.
> * Various fixes.
> 
> ~~~
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> 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)
FAQ:  http://lists.4d.com/faqnug.html
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: UUID version 4 needed

[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.  But that’s the extent of my deep UUID knowledge.. :)

> On Jul 7, 2018, at 9:12 AM, Piotr Chabot Stadhouders via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> 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 it "the wrong 
> way"?
> Or is there an explanation for this?
> 
> Gr,
> 
> Piotr
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
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: UUID version 4 needed

[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 this code:

repeat
ASSERT(Generate UUID[[13]]="4")
until(windows alt down)

v14r5, v15r5, v16r5, v17: assert is always true. 

-- 
Arnaud de Montard

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
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: Cannot delete if related many issue

[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 as deleted.

Therefore I cannot comment on the feature other than what is in the manual. 

Jody

> On Jul 7, 2018, at 5:20 AM, Arnaud de Montard via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> 
>> 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 shark teeth, unable to connect and 
>> so on. Finally we had to kill the server. After setting Deletion Control to 
>> "none", DELETE SELECTION becomes instantaneous. The deleted records had no 
>> "sons". Searching if there are sons with QUERY(sons;foreign key=primary key) 
>> takes a few milliseconds. MSC says everything's OK. 4D v14r5. 
>> 
>> Does someone have noticed issues with Deletion Control as "Cannot delete if 
>> related many"?
> 
> No answer… 
> No one uses deletion control? 
> 
> -- 
> Arnaud de Montard 

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
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: UUID version 4 needed

[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 it "the wrong 
way"?
Or is there an explanation for this?

Gr,

Piotr

> -Oorspronkelijk bericht-
> Van: Chip Scheide <4d_o...@pghrepository.org>
> Verzonden: vrijdag 6 juli 2018 18:02
> Aan: 4D iNug Technical <4d_tech@lists.4d.com>
> CC: Piotr Chabot Stadhouders 
> Onderwerp: RE: UUID version 4 needed
> 
> after just a bit of google-fu
> I found this php routine to generate a UUID. Since, in principle 4D supports
> php... maybe you can just generate your own.
> 
> if (!function_exists('com_create_guid')) {
>   function com_create_guid() {
> return sprintf( '%04x%04x-%04x-%04x-%04x-%04x%04x%04x',
> mt_rand( 0, 0x ), mt_rand( 0, 0x ),
> mt_rand( 0, 0x ),
> mt_rand( 0, 0x0fff ) | 0x4000,
> mt_rand( 0, 0x3fff ) | 0x8000,
> mt_rand( 0, 0x ), mt_rand( 0, 0x ), mt_rand( 0, 0x )
> );
>   }
> }
> 
> source:
> https://helloacm.com/how-to-create-uuid-in-php/
> 
> also there is a bunch of discussion on StackOVerflow regarding generating a
> UUID, in various languages, and platforms
> 
> 
> On Fri, 6 Jul 2018 15:33:48 +, Piotr Chabot Stadhouders via 4D_Tech
> wrote:
> > Hi,
> >
> > The Win32API command sys_GetGUID does return a version 4 UUID
> >
> > So on Windows :
> > Win32API generates a version 4 UUID --> 13th hex digit is a 4
> > 4D v16 does not generate a version 4 UUID --> 15th hex digit is a 4
> >
> >
> >> -Oorspronkelijk bericht-
> >> Van: Dennis, Neil 
> >> Verzonden: vrijdag 6 juli 2018 16:25
> >> Aan: Piotr Chabot Stadhouders ; 4D iNug
> >> Technical <4d_tech@lists.4d.com>
> >> Onderwerp: RE: UUID version 4 needed
> >>
> >>> And in fact, my 4D generated UUID is rejected by the web service,
> >>> saying it
> >> isn't a 4 version UUID
> >>
> >> Very possible, it has been a while since I looked into it and I was
> >> going off of my
> >> fuzzy memory.
> >>
> >> Neil
> >>
> >>
> >>
> >>
> >> --
> >>
> >>
> >> Privacy Disclaimer: This message contains confidential information and is
> >> intended only for the named addressee. If you are not the named addressee
> >> you should not disseminate, distribute or copy this email. Please
> >> delete this
> >> email from your system and notify the sender immediately by replying
> >> to this
> >> email.  If you are not the intended recipient you are notified that
> >> disclosing,
> >> copying, distributing or taking any action in reliance on the
> >> contents of this
> >> information is strictly prohibited.
> >>
> >> The Alternative Investments division of UMB Fund Services provides a
> >> full range
> >> of services to hedge funds, funds of funds and private equity
> >> funds.  Any tax
> >> advice in this communication is not intended to be used, and cannot
> >> be used, by
> >> a client or any other person or entity for the purpose of (a)
> >> avoiding penalties
> >> that may be imposed on any taxpayer or (b) promoting, marketing, or
> >> recommending to another party any matter addressed herein.
> >
> 
> **
> > 4D Internet Users Group (4D iNUG)
> > FAQ:  http://lists.4d.com/faqnug.html
> > Archive:  http://lists.4d.com/archives.html
> > Options: https://lists.4d.com/mailman/options/4d_tech
> > Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> >
> 
> **
> ---
> Gas is for washing parts
> Alcohol is for drinkin'
> Nitromethane is for racing
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

[ANN] Q2Pix 1.0b2 available

[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,

- Escape Tech

~~~


About Q2Pix
===

Q2Pix is the first of a new generation of 4D Extensions. We no longer call them 
"plug-ins" because they are more than that. The architecture of these new 
products comprises 4D plug-ins, components, frameworks, open-source libraries; 
they work with the latest 4D versions; they make extensive use of modern 4D 
features such as subforms, objects and JSON.


Key features


- Full 32/64-bit, 4D v16/64 or later recommended.
- QuickTime-free.
- Exposes an object model.
- Document-based programming interface.
- A rich viewer widget with menubar, toolbar and sidebar written in pure 4D.
- Full support of XMP metadata.
- A generic XMP data editor written in pure 4D.
- Extensive PDF support.
- Extensive acquisition capabilities: TWAIN, ImageCapture, WIA.
- Batteries included: no third-party stuff to install.

Product page: 
Beta download: 

Beta 2 news
===

Plug-in fixes:

* Plug-in area crash under v17 on macOS.
* Wrong path names of acquired images on Windows.
* Minor memory leaks.

New features:

* In auto-zoom mode the plug-in area can now stretch/enlarge the image.
* Scrollbars auto-hide as appropriate. This behavior and individual scrollbar 
visibility can be controlled via the area properties.
* Added the following effect filters:
  + Brightness
  + Contrast (macOS only, atm)
  + GaussianBlur
  + Invert

In the components:

* ImgDlog_GetEffect presents an effect dialog with a preview and returns the 
selected filter name and parameters.
* ImgArea_ApplyEffect presents an effect dialog and applies the selected filter 
to image in the area (live preview).
* The Image Control widget supports the effect dialog via the ImgCmd_Effect 
handler method. The default widget configuration includes this option under the 
Image menu.
* Minor fixes.

Added to the docs:

* Raster Image Filters in the Programming guide.
* Raster Filter Reference in the Reference section.
* Various fixes.

~~~

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
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: Cannot delete if related many issue

[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 shark teeth, unable to connect and so on. 
> Finally we had to kill the server. After setting Deletion Control to "none", 
> DELETE SELECTION becomes instantaneous. The deleted records had no "sons". 
> Searching if there are sons with QUERY(sons;foreign key=primary key) takes a 
> few milliseconds. MSC says everything's OK. 4D v14r5. 
> 
> Does someone have noticed issues with Deletion Control as "Cannot delete if 
> related many"?

No answer… 
No one uses deletion control? 

-- 
Arnaud de Montard 





**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**