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
Ok, OK. Feature request sent…
Currently an object field's dirty flag only gets set if the object field itself
SAVE RECORD[MyTable] //The field's dirty flag is set and the new value is saved.
I do not need the directory listing itself. I need the size of the directory
I need to check the size of directory being copied to insure that there is free
space before starting the copy.
files are easy :)
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
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 <
> the built-in progress bar was retied in Internet Command 64-bits, no
> progress bar is shown.
the built-in progress bar was retied in Internet Command 64-bits, no progress
bar is shown.
The 4D IC 64-bit version for OS X does not display a progress bar when
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
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
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
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
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?
> if <>x_Quote+$Path ends with a directory symbol,
> double-quoting the string isn't enough,
> the directory symbol is also an escape
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
> Le 1 nov. 2017 à 21:16, David Adams via 4D_Tech <firstname.lastname@example.org> 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
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.
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)
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
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
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;
> 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
What about comparing hashes?
> Am 31.10.2017 um 21:40 schrieb David Witton via 4D_Tech
> Does anyone have a suggestion on how to proceed?
Software & IT-Consulting
Member of the german
> So, if you want to officially request such a change, it needs to go on
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,
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?
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
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
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;
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.
On Wed, Nov 1, 2017 at 10:13 AM, Tim Nevels via 4D_Tech <
> 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
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
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
What I didn't do is quit and restart 4D - after that the code
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 email@example.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
➢ 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)
> 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
> 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
As described in tech tip 76725;
Feature requests are handled on the 4D Forums:
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
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?
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
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:
Thanks - after I posted, I caught that and corrected, but still get the
On Wed, Nov 1, 2017 at 10:06 AM, Milan Adamov via 4D_Tech <
> No “:” in front of $arrCount?
> Sent from my iPad
> > On Nov 1, 2017, at 17:04, David Witton via
No “:” in front of $arrCount?
Sent from my iPad
> On Nov 1, 2017, at 17:04, David Witton via 4D_Tech <firstname.lastname@example.org>
> Here's a SQL block that throws Error code: 1427, Nested Begin/End SQL not
> Begin SQL
> SELECT Athena.First_Name, Athena.Last_Name,
Here's a SQL block that throws Error code: 1427, Nested Begin/End SQL not
SELECT Athena.First_Name, Athena.Last_Name, Athena.DOB, Count(*) as recCount
Group by Athena.First_Name,Athena.Last_Name,Athena.DOB
HAVING Count (*)>1
One of the things others have mentioned, but have not really expounded
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
> Le 1 nov. 2017 à 02:46, Tim Nevels via 4D_Tech <email@example.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
> Le 31 oct. 2017 à 21:40, David Witton via 4D_Tech <firstname.lastname@example.org> 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
> Le 31 oct. 2017 à 21:47, Kirk Brooks via 4D_Tech <email@example.com> a
> écrit :
> 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
On Wed, Nov 1, 2017 at 2:17 AM, Keisuke Miyako via 4D_Tech <
> to explicitly indicate that the object has been modified, just use the line
YEs, I use wrapper around SAVE RECORD, so can put there
Mail list logo