Re: [Warning] Settings properties values on object field by object notation

Thanks to TIm and Brian for responding here, always appreciated. There is no lack of clarity from 4D that the official channel is to post on the forums. Before that, it was bugs.4d.fr. That's always been clear. Heck, I can't even count the number of times I said that on this list over the years.

Re: [Warning] Settings properties values on object field by object notation

Ok, OK. Feature request sent… —— Currently an object field's dirty flag only gets set if the object field itself is referenced... OB SET([MyTable]MyObjectField;"property";"newValue") SAVE RECORD[MyTable] //The field's dirty flag is set and the new value is saved.

Re: v13 - LEP and MS-DOS command line

Thanks again. Why? I do not need the directory listing itself. I need the size of the directory for copying. I need to check the size of directory being copied to insure that there is free space before starting the copy. files are easy :) > Dir >

Re: FTP_Progress

Looks like we need to roll our own progress bar by a) Getting the file size on host/client b) monitoring the file size of download or upload on host/client for receive and send.. On Thu, Nov 2, 2017 at 2:21 PM, Sujit Shah wrote: > Thanks but how do we monitor the

Re: FTP_Progress

Thanks but how do we monitor the download? How will I know that the download is complete? On Thu, Nov 2, 2017 at 2:16 PM, Keisuke Miyako via 4D_Tech < 4d_tech@lists.4d.com> wrote: > the built-in progress bar was retied in Internet Command 64-bits, no > progress bar is shown. > >

Re: FTP_Progress

the built-in progress bar was retied in Internet Command 64-bits, no progress bar is shown. http://doc.4d.com/4Dv15/4D/15/4D-Internet-Commands-64-bit-version-for-OS-X.300-2048298.en.html quote: Progress bar The 4D IC 64-bit version for OS X does not display a progress bar when executing

Re: Web Preferences Change on 15.5

I forgot to mention that it appears the settings are unchanged from the original default settings (like from a new database), on my web server. On Wed, Nov 1, 2017 at 9:17 PM, Doug Hall wrote: > I didn't notice this happening on 4D 15.4, but it seems that now, when I >

Web Preferences Change on 15.5

I didn't notice this happening on 4D 15.4, but it seems that now, when I replace my structure on my 4D Server machine, the web preferences (in the Database Settings menu option) change on my 4D Remote (web server) machine. I used to only have to change the default web user, since my development

Re: [Warning] Settings properties values on object field by object notation

I think I understand the logic and emotion from all sides of this thread. I want to try and clarify (repeat?) a couple discussion points so this can end up being a constructive thread, and not just a user group chat that doesn’t get the attention it deserves. There are a lot of strong

Re: v13 - LEP and MS-DOS command line

Dir https://technet.microsoft.com/en-us/library/cc755121(v=ws.11).aspx LEP http://doc.4d.com/4Dv16R5/4D/16-R5/LAUNCH-EXTERNAL-PROCESS.301-3481371.en.html stdOut can be text or BLOB, the encoding is UTF-16LE on Windows if you pass BLOB (and if the command line program is Unicode). I guess on an

Re: v13 - LEP and MS-DOS command line

Thanks! I look at that tomorrow So... I Should expect LEP to return a directory listing (given the command is written correctly) in $LEP_Output? > Hello, > > if <>x_Quote+$Path ends with a directory symbol, > double-quoting the string isn't enough, > the directory symbol is also an escape

Re: [Warning] Settings properties values on object field by object notation

I think the “standard behaviour” answer is a mistake on the part of 4D, and I hope they will reconsider their stand on this. As others have said, “Target:=value“ should always mean the target gets changed to the value. Anything else is “non-standard behaviour”. It may be tricky to make it

Re: Working with a 64 bit Integer in an object

> Le 1 nov. 2017 à 21:16, David Adams via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > I know it's a field type, but can you touch it with anything other than SQL? I'm wondering since a while about this: 64 bit is 128/2, 128 is a uuid, a uuid can be managed in langage as hexadecimal string

Re: open gmail in browser from 4D

how about OPEN URL("https://mail.google.com/;) you could analyse the absolute path to reach a particular folder, but they could change at any time. and if the user is not already logged in to Google on their browser, they'd be redirected anyway.

Re: v13 - LEP and MS-DOS command line

Hello, if <>x_Quote+$Path ends with a directory symbol, double-quoting the string isn't enough, the directory symbol is also an escape prefix, so you have an open-ended escaped-double quote if that makes any sense. for a more robust (that is, than just surrounding the string with double quotes)

RE: [Warning] Settings properties values on object field by object notation

On Nov 1, 2017, at 4:01 PM, Timothy Penner wrote: > I am sorry if you do not see the information I am providing as helpful. I > sincerely feel bad for the people who have been bitten by this bug and I am > trying to help the situation by asking the doc team to update the docs, and > also at

Re: SQL error

that explains the fact that a restart of 4D fixed the issue! On Wed, 1 Nov 2017 16:10:46 -0500, Richard Wright via 4D_Tech wrote: > I’ve seen Nested Begin/End SQL errors when a previous statement did > not complete. If you get an error and then abort the code it’s left > open and the next time

RE: SQL error

May I kindly suggest reading a basic primer on SQL. > Date: Wed, 1 Nov 2017 17:15:01 + > From: Timothy Penner > > I think you have multiple issues with this SQL Statement. > > I don’t think you can select a COUNT(*) along with other fields in the same > SQL Statement; >

RE: [Warning] Settings properties values on object field by object notation

> Does 4D realize that *officially* ignoring their customers isn't exactly an > example of great customer service. I am not ignoring customers; I am responding. I am directing people in the right direction, the direction of the official channels... My intent is to help the customers get better

Re: identify duplicates

What about comparing hashes? > Am 31.10.2017 um 21:40 schrieb David Witton via 4D_Tech > <4d_tech@lists.4d.com>: > Does anyone have a suggestion on how to proceed? Reiner Kief Software & IT-Consulting Weinbergstrasse 45 63853 Moemlingen Germany www.kief-online.de Member of the german

Re: [Warning] Settings properties values on object field by object notation

> So, if you want to officially request such a change, it needs to go on the forums. Does 4D realize that *officially* ignoring their customers isn't exactly an example of great customer service. I tried the forums for about six months, I don't think I got _any_ information from 4D Engineering,

Re: Working with a 64 bit Integer in an object

Yeah, if 4D isn't working, try NTK. In either case, if you can get at the value as raw text then you'll be able to find text --> 64-bit conversion code. The question in 4D at that point is how to store it. I know it's a field type, but can you touch it with anything other than SQL?

RE: [Warning] Settings properties values on object field by object notation

Hi Tim, We have official channels for reporting issues, feature requests, and bugs. - Requests for help/answers are handled through taow.4d.com - Feature requests are handled through forums.4d.com - Bugs are also handled through the forums but partners can get help filing the bug via taow.4d.com

Working with a 64 bit Integer in an object

Is it possible to work with a 64 bit integer that's being returned to me in an object from an HTTP call? I can't seem to avoid it being turned into "-1.502644539978e+18". I also have a POST that requires me to pass back the 64-bit int value. I would use 4D or NTK for the object handling if it made

RE: [Warning] Settings properties values on object field by object notation

On Nov 1, 2017, at 2:00 PM, Timothy Penner wrote: >> It is good we are having this discussion because this will lead to a >> change/solution to this issue. > > This discussion would more constructive if it took place on the Feature > Request forum. > > As described in tech tip 76725; > { >

Re: SQL error

Hi all I have noted in the past that fn calls fail when you have an existing method turn it into fn call and r5un unless you restart. If you create a new method and mark as fn no restart is needed. Regards Chuck

Re: [Warning] Settings properties values on object field by object notation

Tim, On Wed, Nov 1, 2017 at 10:13 AM, Tim Nevels via 4D_Tech < 4d_tech@lists.4d.com> wrote: > On Nov 1, 2017, at 11:04 AM, Keisuke Miyako wrote: > > > like a global preference, to the effect of > > > > "Call OB Copy implicitly when performing object assignments" > > > > it is an interesting

open gmail in browser from 4D

Hi All 4d Version 15.x. I want to be able to open a new mail message when company uses google mail in a browser window. Google hosts their domain. Has anyone done this. I need a solution for macs and windows. Has anyone done this. I have tried open URL and it only opens Mail on my mac. Not

Re: SQL error

Tim Aside from the missing colon - which had been corrected - I also believe the statement is valid, since it's working in another method in the DB. To eliminate copy and past errors, I retyped the SQL block, but still got the error. What I didn't do is quit and restart 4D - after that the code

Re: [Warning] Settings properties values on object field by object notation

On 11/1/17, 2:08 PM, "4D_Tech on behalf of Tom Swenson via 4D_Tech" <4d_tech-boun...@lists.4d.com on behalf of 4d_tech@lists.4d.com> wrote: ➢ And, yes, I too was told that the engineers were leaning to declaring this as standard behavior. Why? I have not a clue. Ooops, I was just

Re: [Warning] Settings properties values on object field by object notation

➢ And, yes, I too was told that the engineers were leaning to declaring this as standard behavior. Why? I have not a clue. ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive:

RE: SQL error

> I think you have multiple issues with this SQL Statement. I was wrong. I didn’t fully understand the SQL statement at the time of my last reply, upon further inspection it seems the SQL is valid (apart from the missing : in the variable reference). There must be something else wrong, like

RE: [Warning] Settings properties values on object field by object notation

> It is good we are having this discussion because this will lead to a > change/solution to this issue. This discussion would more constructive if it took place on the Feature Request forum. As described in tech tip 76725; { Feature requests are handled on the 4D Forums:

RE: SQL error

I think you have multiple issues with this SQL Statement. I don’t think you can select a COUNT(*) along with other fields in the same SQL Statement; Count returns a number, not an array. While the fields return an array. In addition to that, what is 'HAVING Count(*) > 1' supposed to do? And

Re: [Warning] Settings properties values on object field by object notation

On Nov 1, 2017, at 11:04 AM, Keisuke Miyako wrote: > like a global preference, to the effect of > > "Call OB Copy implicitly when performing object assignments" > > it is an interesting point of view, > to frame it as an issue of the assignment operator being different, > as opposed to how

Re: identify duplicates

Here is a strategy I have used since V6 to enforce a semi-informal primary key for records in an important file. Another parameter was added when our business changed a few years ago. I think you could make it work for your task: C_BOOLEAN($0;$DupExists) C_TEXT($2;$3;$Value1;$Value2)

Re: SQL error

Milan Thanks - after I posted, I caught that and corrected, but still get the same error. On Wed, Nov 1, 2017 at 10:06 AM, Milan Adamov via 4D_Tech < 4d_tech@lists.4d.com> wrote: > No “:” in front of $arrCount? > > Milan > > Sent from my iPad > > > On Nov 1, 2017, at 17:04, David Witton via

Re: SQL error

No “:” in front of $arrCount? Milan Sent from my iPad > On Nov 1, 2017, at 17:04, David Witton via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Here's a SQL block that throws Error code: 1427, Nested Begin/End SQL not > allowed. > > Begin SQL > SELECT Athena.First_Name, Athena.Last_Name,

SQL error

Here's a SQL block that throws Error code: 1427, Nested Begin/End SQL not allowed. Begin SQL SELECT Athena.First_Name, Athena.Last_Name, Athena.DOB, Count(*) as recCount from Athena Group by Athena.First_Name,Athena.Last_Name,Athena.DOB HAVING Count (*)>1 into :$arrFld1,:$arrFld2,:$arrFld3,

Re: identify duplicates

One of the things others have mentioned, but have not really expounded upon... What constitutes a duplicate? For an individual field this can be complex, for multiple fields... For some data types (numerics) a duplicate is easy to define 2 = 2 = 2 = 2 (integer/long integer) For others (text) it

Re: [Warning] Settings properties values on object field by object notation

> Le 1 nov. 2017 à 02:46, Tim Nevels via 4D_Tech <4d_tech@lists.4d.com> a écrit > : > > The real “sloppy” part is that this was not documented with a big red flag > saying something like “object fields don’t work like other fields so if you > do this … it does not work the same as if you do

Re: identify duplicates

> Le 31 oct. 2017 à 21:40, David Witton via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > I'm looking for a strategy to identify duplicate records in a table - that > is, records for which 3 fields are identical across two or more records - > or in another case, where a single field is not

Re: pointers to arrays

> Le 31 oct. 2017 à 21:47, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > Peter, > This is easy to do with local arrays and dynamic variables. It looks like > you only need to build text arrays. You can declare a local array, ARRAY > TEXT($aText2d;0;0). Then you can resize this

Re: [Warning] Settings properties values on object field by object notation

On Wed, Nov 1, 2017 at 2:17 AM, Keisuke Miyako via 4D_Tech < 4d_tech@lists.4d.com> wrote: > > to explicitly indicate that the object has been modified, just use the line > > [myTable]myObjectField:=[myTable]myObjectField > YEs, I use wrapper around SAVE RECORD, so can put there