Opening a verify log

2018-10-29 Thread Robert McKeever via 4D_Tech
4D v16.3, Mac OS 10.11.6. I was trying to create a form in V16 that exists in V15. Went to add a plug-in area and it crashed. So, I opened again, and copied the plug-in area from a different existing form. Then I ran a structure verify. There are anomalies. This is generally bad news. So, I

Re: v13 - UUID COLLISION!!! [observation]

2018-10-29 Thread Chip Scheide via 4D_Tech
according to Wikipedea: the number of random version 4 UUIDs which need to be generated in order to have a 50% probability of at least one collision is 2.71 quintillion, This number is equivalent to generating 1 billion UUIDs per second for about 85 years, and a file containing this

RE: v13 - UUID COLLISION!!!

2018-10-29 Thread Chip Scheide via 4D_Tech
no - the new record is a related record added via a double click on a listbox. The code being used has been in operation for years. it works/worked else where. I am working though trying to figure out what has happened. 4D is throwing an error about a duplicated (unique) value. after checking

RE: v13 - UUID COLLISION!!!

2018-10-29 Thread Stephen J. Orth via 4D_Tech
Chip, Did you duplicate a record? Steve * Stephen J. Orth The Aquila Group, Inc. Office: (608) 834-9213 P.O. Box 690 Mobile: (608) 347-6447 Sun Prairie, WI

RE: v13 - UUID COLLISION!!!

2018-10-29 Thread Dennis, Neil via 4D_Tech
>UUID value ="E092AB501E1D41F5A5D15B56E835D2EE" >this value appears to be duplicated in my database! Is the field set to auto generate? Was a record exported and imported? Neil -- Privacy Disclaimer: This message contains confidential information and is intended only for the named

v13 - UUID COLLISION!!!

2018-10-29 Thread Chip Scheide via 4D_Tech
UUID value ="E092AB501E1D41F5A5D15B56E835D2EE" this value appears to be duplicated in my database! ideas? thoughts? Chip --- Gas is for washing parts Alcohol is for drinkin' Nitromethane is for racing ** 4D Internet

Re: SQL Convert problem

2018-10-29 Thread Charles Miller via 4D_Tech
Try cast. Chuck On Mon, Oct 29, 2018 at 12:37 PM vagelis fallias via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Hello, > I have the following statement from an external application to 4D via ODBC >var_SelectQuery = "select workorder, > convert(prodstartdate,SQL_VARCHAR), prodstarttime,

SQL Convert problem

2018-10-29 Thread vagelis fallias via 4D_Tech
Hello, I have the following statement from an external application to 4D via ODBC    var_SelectQuery = "select workorder, convert(prodstartdate,SQL_VARCHAR), prodstarttime, planstarttime from workorders  where workorder > 278000" this used to work in v 6.8 but not in v16, it crashes. The problem

Re: Setting up an entity / collection listbox in code

2018-10-29 Thread Kirk Brooks via 4D_Tech
Jeremy, Jeremy French outlines the steps you need to follow. I would add a couple of ideas expanding on his post if you have multiple listboxes in a form. The first is simply adopt a custom of putting all the listboxes in a single object of the parent form. So I might have: Form.LB.A... Which

Re: Setting up an entity / collection listbox in code

2018-10-29 Thread Jeremy French via 4D_Tech
> It’s great to be able to make generic listboxes and set them up entirely in > code. It’s easy for array-based and selection-based listboxes, but can it be > done for entity/collection boxes? Yes. It's even more easy using collections. > In other words, are there LISTBOX SET xx calls to

Re: SOAP over HTTPS

2018-10-29 Thread Keisuke Miyako via 4D_Tech
included in 4D 2004 is an older (0.9.8 or thereabouts) version of OpenSSL, so it is not capable of elevating to TLS 1.2 which is the default minimum for v17. https://blog.4d.com/more-security-for-your-4d-server/ of course you could lower the security level but that's probably the wrong way to

Re: v16R6 Crashing on Compile

2018-10-29 Thread Keith White via 4D_Tech
>What exactly constitutes a token in a method? Is it every "word" in the code? Tokens - I don't have a definitive list but I think 4D Commands, 4D Functions, Constants, Table names, Field Names. Variable names are not tokenised as far as I know, which is why we got the problem after

Setting up an entity / collection listbox in code

2018-10-29 Thread Jeremy Roussak via 4D_Tech
It’s great to be able to make generic listboxes and set them up entirely in code. It’s easy for array-based and selection-based listboxes, but can it be done for entity/collection boxes? In other words, are there LISTBOX SET xx calls to identify the names of the variables unique to

[ANN] hmCal 8.1 available for 4D v16 and v17

2018-10-29 Thread Christian Sakowski via 4D_Tech
hmCal is a plug-in developed by heubach media (www.hmplugins.com), Hamburg, Germany for 4D. With version 8.1 of hmCal we continually integrate new features and improve stability and integrity in 4D. This version of hmCal is certified for 4D v16 and 4D v17! hmCal 8 contains new functions and

Re: SOAP over HTTPS

2018-10-29 Thread Douglas Cryer via 4D_Tech
Keisuke and Lutz, Thank you again for your comments. I have now worked out what is not working... I was dumb enough to think that all SOAP clients would be equal. In fact when I tried from SOAPUI the HTTTPS call worked fine. When I tried from 4D v17 the HTTPS call also worked fine. My

RE: SOAP over HTTPS

2018-10-29 Thread Epperlein, Lutz (agendo) via 4D_Tech
Sorry, I was bit too fast with my answer. Especially about the configuration of the web service on the side of 4D. This was my from remembering of using a 4D web service for testing purposes in the past. At this time we built this test service as a mockup of another external web service, that

Re: SOAP over HTTPS

2018-10-29 Thread Douglas Cryer via 4D_Tech
Keisuke and Lutz, Thank you for your comments. Lutz said: "is not only necessary to access the endpoint with https:// you have to offer the service as a https:// service, e.g. you have to adjust the settings in 4D to modify the wsdl in the proper way." This sounds like the key, so I will look