Re: 4D v16.4 Built database won't open in Mojave

[Allan Udy via 4D_Tech]

Walt,

Sorry - haven't been reading the NUG for a couple of weeks -- did you 
ever solve this issue?


I had something very similar a few months back with v16 and a client who 
had upgraded his machine to High Sierra -- suddenly the app stopped 
working in a very similar way.


>From memory we had to recompile the app to 64-bit because the machine 
was running with an SSD (instead of a standard hard disk), and when the 
OS update was installed it converted the file system on the SSD to Apple 
File System (*APFS*) -- from our testing this was not 32-bit compatible 
and we were getting 'Can't open database "DatabaseName.4DC"' errors.



Cheers, Allan Udy Golden Micro Solutions Ltd, Blenheim, New Zealand 
http://www.golden.co.nz




4d_tech-requ...@lists.4d.com wrote on 6/11/18 1:36 AM:

From: Walt Nelson
To: Dani Beaubien via4D_Tech<4d_tech@lists.4d.com>
Subject:4D  v16.4 Built database won't open in Mojave


I have built a stand-alone Application v16.4 database on a Mac OS machine 
running High Sierra (10.13.6).

I successfully create an empty datafile and run it on the same High Sierra 
(10.13.6) machine.

I transfer the entire stand-alone built database to a laptop running Mojave 
(10.14).

When opening that database, I get the following error: ‘You cannot open this 
database because the data file (or one of its segments) is locked.’ with an OK 
button.

Click OK. Get a runtime error showing:

ErrorCan't open database “DatabaseName.4DC".

Error code: -10509
Can't open database "DatabaseName.4DC".
component: '4DRT'
task -1, name: 'Application process’




Cheers,
Allan Udy

Golden Micro Solutions Ltd, Blenheim, New Zealand
http://www.golden.co.nz

**
4D Internet Users Group (4D iNUG)
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: Transferring Build Mac Client via Google Drive Web Interface Fails

[Jeremy Roussak via 4D_Tech]

> On 20 Nov 2018, at 15:27, Dave Nasralla via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Is there an easy way to get the file path to the built client and
> server apps for the command line?
> 
Not that I know of. I have it hard-coded, which means that it breaks if I 
fiddle with it. So I don’t.

Jeremy

**
4D Internet Users Group (4D iNUG)
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: TAOW (Mojave and CREATE THUMBNAIL)

[JOHN BAUGHMAN via 4D_Tech]

Thanks Keisuke.

So I must be going to the wrong place to see the bug list. I always end up at 
taow.4d.com but only see my support cases. 

I thought I could search the TAOW for reported issues before reporting my own. 
Is this not the case? If not, how?

Thanks,

John


> On Nov 25, 2018, at 3:00 PM, Keisuke Miyako via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> for reference: ACI0098954
> 
> https://bugs.4d.fr/fixedbugslist?Version=17.0_HF4
> 
> 2018/11/25 18:18、Keisuke Miyako via 4D_Tech 
> <4d_tech@lists.4d.com>のメール:
> it is already registered and fixed in the latest nightly build.
> problem only manifests if the width is a multiple of 4.
> 
> 
> 
> **
> 4D Internet Users Group (4D iNUG)
> 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)
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: One Set of Code for Form Object Populated Forms as well as Field-Based Detail View Forms

[Douglas von Roeder via 4D_Tech]

Miyako:

"it is not a bug."
Thank you for confirming that.

--
Douglas von Roeder
949-336-2902


On Fri, Nov 23, 2018 at 3:35 PM Keisuke Miyako via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> it is not a bug.
>
> the 1st generation of form design in 4D was to bind process variables to
> objects and use variables directly in code.
> the 2nd generation of form design (v12) was to keep the bound variable
> empty and use pointers to reference dynamic variables.
>
> the main difference was in the scope of the variables: process or form.
>
> I think the resulting heavy usage of pointers is rather consequential.
> it is bonus that pointers work in both cases,
> but I don't think that it should be the main focus.
>
> "Form" based design is a total rethink of how to use variables in forms.
> Form is an object, and an object is a reference,
> which drastically reduces the need for pointers.
>
> historically  a pointer can only point to tables, fields, variables and
> arrays.
> it could have been extended to support object properties and collection
> members but that would send the wrong message.
> if you use Form and This, you should never want to use pointers.
> you should think of using object notation consistently in code and form.
>
> this is not to say that "generic" code is discouraged in ORDA.
> you just think of how to be generic in a different way.
>
> it feels counter intuitive coming from classic 4D code,
> but hard-coding object property paths everywhere is the key to writing
> generic and reusable code.
>
>
>
> **
> 4D Internet Users Group (4D iNUG)
> 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)
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: v16.4 Desktop application, Rejected

[Carl Aage Wangel via 4D_Tech]

Thanks Jeffrey and Keisuke,

But I am at a bit of a loss as where to find OpenSSL in 4D and how to update
the libraries (same for jQuery). I have been using 4D since version 1 (or
2?) but have never fiddled with OpenSSL. As I understand it OpenSSL v0.9.8
was part of 4D 2004, so it seems strange that the PHP include in 4D uses
this old version. 

As to jQuery isn't the time and date picker jQuery? 

As mentioned I have no working experience with OpenSSL but as I understand
it, version 1.1.x or 1.0.x are the versions to download.

Regards

Carl Aage Wangel

**
4D Internet Users Group (4D iNUG)
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: 4D Server automatically setting 'Reject New Connections' ?

[Tim Nevels via 4D_Tech]

On Nov 26, 2018, at 3:06 AM, Allan Udy wrote:

> Has anyone else seen 4D Server spontaneously 'dropping' 4D Client 
> connections, and automatically setting the 'Reject New Connections' 
> option in the server Administration window?
> 
> We've seen this with both v16 and v17. Usually when the DBA goes to 
> 'Accept New Connections' in the server admin window, the server app 
> (compiled and merged) will throw up its arms in horror and crash -  "4D 
> Server has stopped working.  Windows can check online for a solution.."
> 
> We'd really like to be able to solve this problem

I’ve seen this happen 1 time on a v17.0 HF1 4D Server application that has been 
running for several months now. One day I got a call from the client that 
people could no longer connect to 4D Server. Existing users were fine, just 
nobody new could connect. I checked the server and found the button had changed 
from “Reject New Connections” to “Accept New Connections”. Nobody clicked the 
button.

I clicked the button to switch it back to allow connections, but it did 
nothing. I tried to quit 4D Server and do a restart and it would no quit. I 
finally had to End Task to restart 4D Server. Then users were able to connect 
again.

So yes, this is a real issue and not just a fluke you are experiencing. 

I am assuming you are using the new network layer, right? My application is and 
I’m guessing it’s another bug/issue related to this. 

Tim

*
Tim Nevels
Innovative Solutions
785-749-3444
timnev...@mac.com
*

**
4D Internet Users Group (4D iNUG)
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: JSON from Google Sheet to Property Object

[Sannyasin Siddhanathaswami via 4D_Tech]

Last email didn’t work right.

I think a Collection might be the way to go with this. If I create a collection 
of objects:
{“ID”:”5912029","First Name”:”Sannyasin”},
{“ID”:”6015906","First Name”:”Mayuran”}

I should be able to access the data very easily.

Sannyasin Siddhanathaswami
On Nov 25, 2018, 11:06 PM -1000, 4D iNug Technical <4d_tech@lists.4d.com>, 
wrote:

{“ID”:”5912029","First Name”:”Sannyasin”},
{“ID”:”6015906","First Name”:”Mayuran”}
**
4D Internet Users Group (4D iNUG)
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: JSON from Google Sheet to Property Object

[Sannyasin Siddhanathaswami via 4D_Tech]

**
4D Internet Users Group (4D iNUG)
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: JSON from Google Sheet to Property Object

[Sannyasin Siddhanathaswami via 4D_Tech]

That makes sense. No wonder I’m confused. :)

But if I convert:
[
[ID,First Name,Last Name],
[5912029,Sannyasin,Siddhanathaswami],
[6015906,Mayuran,Sokkan]
]

to an array of objects:
[
{“ID”:”5912029","First Name”:”Sannyasin”},
{“ID”:”6015906","First Name”:”Mayuran”}
]

Does than mean I can access the “First Name” value by the “ID”? Somehow?

This is kind of like doing a "Selection to JSON”, parsing that into an object, 
then trying to find a “record” in the resulting object.





Sannyasin Siddhanathaswami
On Nov 25, 2018, 10:44 PM -1000, 4D iNug Technical <4d_tech@lists.4d.com>, 
wrote:

you are confusing property names and array positions.

$lastName:=$convertedObject[“ID”][“6015906”][“Last Name”]

this would infer

{"ID":{"6015906":{"Last Name":__here_}}}

if the target is

[
[ID,First Name,Last Name],
[5912029,Sannyasin,Siddhanathaswami],
[6015906,Mayuran,Sokkan]
]

then the notation should be

$convertedObject[2][2] //Sokkan
**
4D Internet Users Group (4D iNUG)
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: JSON from Google Sheet to Property Object

[Keisuke Miyako via 4D_Tech]

you are confusing property names and array positions.

$lastName:=$convertedObject[“ID”][“6015906”][“Last Name”]

this would infer

{"ID":{"6015906":{"Last Name":__here_}}}

if the target is

[
[ID,First Name,Last Name],
[5912029,Sannyasin,Siddhanathaswami],
[6015906,Mayuran,Sokkan]
]

then the notation should be

$convertedObject[2][2] //Sokkan

2018/11/26 17:39、Sannyasin Siddhanathaswami via 4D_Tech 
<4d_tech@lists.4d.com>のメール:

It’s a JSON array of arrays from the Google Sheet that has the headers in the 
first “row” of the array "values[0]”:
[
[ID,First Name,Last Name],
[5912029,Sannyasin,Siddhanathaswami],
[6015906,Mayuran,Sokkan]
]

My goal is to be able to reference this new object by doing something like:
$lastName:=$convertedObject[“ID”][“6015906”][“Last Name”]

I don’t really know what I’m doing. Would that even work?



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

JSON from Google Sheet to Property Object

[Sannyasin Siddhanathaswami via 4D_Tech]

Aloha,

I’m getting my feet wet with v17’s dot notion/objects.

My first use is converting a Google Sheet JSON into something easily 
accessible. I was thinking to a property:value 4D Object.

Does anyone have a utility method that does this?

It’s a JSON array of arrays from the Google Sheet that has the headers in the 
first “row” of the array "values[0]”:
[
[ID,First Name,Last Name],
[5912029,Sannyasin,Siddhanathaswami],
[6015906,Mayuran,Sokkan]
]

My goal is to be able to reference this new object by doing something like:
$lastName:=$convertedObject[“ID”][“6015906”][“Last Name”]

I don’t really know what I’m doing. Would that even work?

Is there an easy way to approach this? If it was just this one Google Sheet, 
I’d probably loop through each array and see if element [0] matched the ID I 
was looking for. If it did, then I would grab element [2]. But this seems like 
the wrong approach.

Any tips or things to research would be greatly appreciated.



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