Re: Communicating With BLE Devices

[JasonH via 4D_Tech]

Speaking of Arduino's, for school I had to buy a starter kit for my son.  He
won't actually need it for another month or two, but of course I immediately
busted it out and started playing with it (so I can help him with his school
work when they get to working on them )

It's been fun working through the exercises.  One of the things you can do
is write back to the computer via a serial port.  The Arduiono IDE has a
serial port monitor you can use to interact with the stream, but I wondered
if 4D could too.

I started a test 4D database, and in short order had it talking to the
Arduino over the serial port.  I didn't have any particular goal in mind,
but there are thousands of devices that can easily interface with the
Arduino, which then can pretty easily talk to 4D. 



--
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: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: 4D v16.2 false record locks

[Alan Tilson via 4D_Tech]

Hey John,
How did you end up in Hawaii?
Alan

On Wed, Oct 4, 2017 at 10:02 PM, John Baughman via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> I am going to chime in here with a recent real world experience.
>
> A while back I posted to the NUG a problem that I was having with external
> data storage using custom mode. When the data was updated and properly
> saved to the external data folder, the field continued to display the old
> version of the data until the server or standalone 4D was restarted. This
> was a show stopper for me upgrading a client to v16.
>
> I called tech support and after uploading a sample db demonstrating the
> problem was told that it was in fact a bug and a bug case was opened for
> it. This bug existed in 16.1 and R4 beta.
>
> I then called Tracy, my sales rep, and asked her to expedite the bug.
>
> A couple of weeks ago I received a message from 4D TS saying the bug was
> fixed in the latest nightly build of 16.1. I confirmed the fix, but noted
> that it was still broken in R4 beta. TS acknowledged this and said that the
> fix would not show up in the R releases until R5.
>
> 16.2 was released and as expected no bug.
>
> Today R4 was released and voila the bug has been fixed.
>
> Now in the context of this thread, this appears to be an anomaly? It does
> say to me that 4D does heavily prioritize the bugs in their bug list. For
> example, you might have noticed that in 16.2 the issue with the Design
> Environment not remembering the open windows from the last session has been
> fixed. Not so in R4. Interesting, yes?
>
> For me personally, I am not one to complain. I may be naive, but I trust
> that the folks working on 4D are doing the best they can. Sure there could
> be improvements, but I am one to live with what I got and be patient for
> what is yet to come.
>
> I understand the frustrations, but that is my 2 cents worth.
>
> John
>
>
>
>
>
> > On Oct 4, 2017, at 7:21 AM, David Adams via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> >
> >> If you have a bug that you really want fixes:  you need to work with
> Tech
> > Support.  If you don’t: then it’s just wishful thinking.
> >
> > I have done this. It's a bug that 4D should care about *way* more than
> me.
> > It crashes the server. Easily Submitted to tech support with a demo
> > database, etc.
> >
> > It is NOT MY FAULT that 4D doesn't fix properly reported bugs. It is NOT
> > OUR FAULT. It is their fault.
> >
> > I'm getting tired of hearing from people that someone bugs aren't being
> > fixed because we're somehow mysteriously doing it wrong. I also
> appreciate
> > that I'm one of the very people that spit out that line over, and over
> > again down the years on this list.
> >
> > Here's a list of positions that I can no longer accept on face value:
> >
> > "We aren't documenting that because it might change."
> > This is silly in the extreme. Every piece of software might change, lots
> of
> > them say "This might change in a future version." Even 4D says this
> clearly
> > in their docs. So when you hear that line, it's an excuse for something
> > else - who knows what.
> >
> > "It isn't Tech Support's job to report bugs."
> > Of course it is.
> >
> > "You have to <> to get you bug fixed."
> > 1. It's not my bug, it's THEIR bug. They're not doing me a favor.
> > 2. Jumping through the hoops makes no particular impact that I can see.
> >
> > "Feature requests should be submitted through the appropriate section of
> > the forums where there is open voting."
> > True. Does this get feature requests implemented? Not as far as I can
> tell.
> > (Well, I did see one - but it was from Rob and he's got a special
> > relationship with 4D.) My cynical interpretation is that the feature
> > request forum exists to stop people complaining about missing features.
> >
> > Your mileage may vary.
> > **
> > 4D Internet Users Group (4D iNUG)
> > FAQ:  http://lists.4d.com/faqnug.html
> > Archive:  http://lists.4d.com/archives.html
> > Options: http://lists.4d.com/mailman/options/4d_tech
> > Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> > **
>
> John Baughman
> Kailua, Hawaii
> (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: http://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: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com

Re: 4D v16.2 false record locks

[Alan Tilson via 4D_Tech]

sorry, meant to send this directly to John!
Alan

On Wed, Oct 11, 2017 at 11:09 PM, Alan Tilson  wrote:

> Hey John,
> How did you end up in Hawaii?
> Alan
>
> On Wed, Oct 4, 2017 at 10:02 PM, John Baughman via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
>
>> I am going to chime in here with a recent real world experience.
>>
>> A while back I posted to the NUG a problem that I was having with
>> external data storage using custom mode. When the data was updated and
>> properly saved to the external data folder, the field continued to display
>> the old version of the data until the server or standalone 4D was
>> restarted. This was a show stopper for me upgrading a client to v16.
>>
>> I called tech support and after uploading a sample db demonstrating the
>> problem was told that it was in fact a bug and a bug case was opened for
>> it. This bug existed in 16.1 and R4 beta.
>>
>> I then called Tracy, my sales rep, and asked her to expedite the bug.
>>
>> A couple of weeks ago I received a message from 4D TS saying the bug was
>> fixed in the latest nightly build of 16.1. I confirmed the fix, but noted
>> that it was still broken in R4 beta. TS acknowledged this and said that the
>> fix would not show up in the R releases until R5.
>>
>> 16.2 was released and as expected no bug.
>>
>> Today R4 was released and voila the bug has been fixed.
>>
>> Now in the context of this thread, this appears to be an anomaly? It does
>> say to me that 4D does heavily prioritize the bugs in their bug list. For
>> example, you might have noticed that in 16.2 the issue with the Design
>> Environment not remembering the open windows from the last session has been
>> fixed. Not so in R4. Interesting, yes?
>>
>> For me personally, I am not one to complain. I may be naive, but I trust
>> that the folks working on 4D are doing the best they can. Sure there could
>> be improvements, but I am one to live with what I got and be patient for
>> what is yet to come.
>>
>> I understand the frustrations, but that is my 2 cents worth.
>>
>> John
>>
>>
>>
>>
>>
>> > On Oct 4, 2017, at 7:21 AM, David Adams via 4D_Tech <
>> 4d_tech@lists.4d.com> wrote:
>> >
>> >> If you have a bug that you really want fixes:  you need to work with
>> Tech
>> > Support.  If you don’t: then it’s just wishful thinking.
>> >
>> > I have done this. It's a bug that 4D should care about *way* more than
>> me.
>> > It crashes the server. Easily Submitted to tech support with a demo
>> > database, etc.
>> >
>> > It is NOT MY FAULT that 4D doesn't fix properly reported bugs. It is NOT
>> > OUR FAULT. It is their fault.
>> >
>> > I'm getting tired of hearing from people that someone bugs aren't being
>> > fixed because we're somehow mysteriously doing it wrong. I also
>> appreciate
>> > that I'm one of the very people that spit out that line over, and over
>> > again down the years on this list.
>> >
>> > Here's a list of positions that I can no longer accept on face value:
>> >
>> > "We aren't documenting that because it might change."
>> > This is silly in the extreme. Every piece of software might change,
>> lots of
>> > them say "This might change in a future version." Even 4D says this
>> clearly
>> > in their docs. So when you hear that line, it's an excuse for something
>> > else - who knows what.
>> >
>> > "It isn't Tech Support's job to report bugs."
>> > Of course it is.
>> >
>> > "You have to <> to get you bug fixed."
>> > 1. It's not my bug, it's THEIR bug. They're not doing me a favor.
>> > 2. Jumping through the hoops makes no particular impact that I can see.
>> >
>> > "Feature requests should be submitted through the appropriate section of
>> > the forums where there is open voting."
>> > True. Does this get feature requests implemented? Not as far as I can
>> tell.
>> > (Well, I did see one - but it was from Rob and he's got a special
>> > relationship with 4D.) My cynical interpretation is that the feature
>> > request forum exists to stop people complaining about missing features.
>> >
>> > Your mileage may vary.
>> > **
>> > 4D Internet Users Group (4D iNUG)
>> > FAQ:  http://lists.4d.com/faqnug.html
>> > Archive:  http://lists.4d.com/archives.html
>> > Options: http://lists.4d.com/mailman/options/4d_tech
>> > Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
>> > **
>>
>> John Baughman
>> Kailua, Hawaii
>> (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: http://lists.4d.com/mailman/options/4d_tech
>> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
>> **
>>
>
>

Re: Min/Max for Date Fields in 4D

[Timothy Penner via 4D_Tech]

No, SQL does not work with the selection.

I missed that requirement when I read the original post but I see it now.

-Tim


Sent from my Verizon, Samsung Galaxy smartphone




 Original message 
From: Alan Tilson 
Date: 10/11/17 6:05 PM (GMT-08:00)
To: 4D_Tech <4d_tech@lists.4d.com>
Cc: Timothy Penner 
Subject: RE: Min/Max for Date Fields in 4D

Hello Timothy,
Great idea, but can this work on the current selection?
Thanks,
Alan

sent from my Note 4


On Oct 11, 2017 8:32 PM, "Timothy Penner via 4D_Tech" 
<4d_tech@lists.4d.com> wrote:
What about SQL?  It works for me (only tested v16)...

// find the Min
C_DATE($blankDate)
C_DATE($foundDate)
Begin SQL
SELECT MIN(DateField)
FROM SomeTable
WHERE DateField <> :$blankDate
INTO :$foundDate;
End SQL


// find the MAX
C_DATE($foundDate)
Begin SQL
SELECT MAX(DateField)
FROM SomeTable
INTO :$foundDate;
End SQL


-Tim



**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://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: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

RE: Min/Max for Date Fields in 4D

[Alan Tilson via 4D_Tech]

Hello Timothy,
Great idea, but can this work on the current selection?
Thanks,
Alan

sent from my Note 4


On Oct 11, 2017 8:32 PM, "Timothy Penner via 4D_Tech" <4d_tech@lists.4d.com>
wrote:

What about SQL?  It works for me (only tested v16)...

// find the Min
C_DATE($blankDate)
C_DATE($foundDate)
Begin SQL
SELECT MIN(DateField)
FROM SomeTable
WHERE DateField <> :$blankDate
INTO :$foundDate;
End SQL


// find the MAX
C_DATE($foundDate)
Begin SQL
SELECT MAX(DateField)
FROM SomeTable
INTO :$foundDate;
End SQL


-Tim



**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://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: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Communicating With BLE Devices

[Keisuke Miyako via 4D_Tech]

it seems the cross platform libraries are all cross-mobile-platforms.

couldn't find anything for desktop windows and macos.

https://developer.apple.com/documentation/corebluetooth?language=objc
https://developer.apple.com/library/content/samplecode/TemperatureSensor/Introduction/Intro.html

https://msdn.microsoft.com/en-us/library/windows/hardware/ff536585(v=vs.85).aspx
https://github.com/Microsoft/Windows-universal-samples/tree/master/Samples/BluetoothLE

do you have a specific peripheral in mind?

or an arduino, such as

https://punchthrough.com/bean/docs/guides/everything-else/downloads/

2017/10/12 7:54、Cannon Smith via 4D_Tech 
<4d_tech@lists.4d.com> のメール：
Is anyone aware of a way to communicate with a Bluetooth Low Energy device from 
4D?
It needs to work on both platforms. Perhaps a plugin that I’m not aware of?


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

RE: Min/Max for Date Fields in 4D

[Timothy Penner via 4D_Tech]

What about SQL?  It works for me (only tested v16)...

// find the Min
C_DATE($blankDate)
C_DATE($foundDate)
Begin SQL
SELECT MIN(DateField)
FROM SomeTable
WHERE DateField <> :$blankDate
INTO :$foundDate;
End SQL


// find the MAX
C_DATE($foundDate)
Begin SQL
SELECT MAX(DateField)
FROM SomeTable
INTO :$foundDate;
End SQL


-Tim



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

Re: Min/Max for Date Fields in 4D

[Jeffrey Kain via 4D_Tech]

It probably depends on what the server is doing, and the load it’s under, etc..

> On Oct 11, 2017, at 6:55 PM, Alan Tilson via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> It seems that sorting the table is faster than using an array, even after
> returning the selection to it's original order, only taking a few ticks on
> 55k records!

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

Re: ​NB: Pre-emptive mode hassle

[steve simpson via 4D_Tech]

On Wed, Oct 11, 2017 at 3:00 PM,
​
Tim Nevels wrote:

> ​[snip]
>
>
> I sure can. Remember when C_OBJECT variables were introduced? There were
> several developers here that talked about completely overhauling all their
> code to eliminate process and interprocess variables and replace all of it
> with object variables. Code was working fine. They just wanted to use this
> cool new variable type.
> ​[snip]
>
> I do a lot of UI work with 4D. I love doing UI work. Windows and dialog
> boxes that users deal with all day every day. So 4D is great for a lot of
> the work that I do.
> ​[snip]​
>

​+1
_
Steve Simpson
Cimarron Software
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Print From Web Area

[Kirk Brooks via 4D_Tech]

Cannon,
If the web area isn't using the WebKit it's rendered using whatever the
system browser is. I think that would mean that browser would be used to
print it as well but I haven't really tested that.

On Wed, Oct 11, 2017 at 2:58 PM, Cannon Smith via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Hi All,
>
> If I generate a report in HTML and show it in a web area on a form, is
> there a way I can request that it be printed in exactly the same way as if
> it was in Safari or Firefox and printed from there?
>
> Thanks.
>
> --
> Cannon.Smith
> Synergy Farm Solutions Inc.
> Hill Spring, AB Canada
> 403-626-3236
> 
> 
>
>
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **




-- 
Kirk Brooks
San Francisco, CA
===

*The only thing necessary for the triumph of evil is for good men to do
nothing.*

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

Re: Updater v16

[Sujit Shah via 4D_Tech]

So if I include a complete build (using the build application command for
example) the updater will replace the files in the application folder from
the update folder?


On Thu, 12 Oct 2017 at 9:38 am, Keisuke Miyako via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> the page links to SET UPDATE FOLDER
>
> http://doc.4d.com/4Dv16R4/4D/16-R4/SET-UPDATE-FOLDER.301-3317772.en.html
>
> which links to the page about automatic update feature
>
>
> http://doc.4d.com/4Dv16R4/4D/16-R4/Automatic-updating-of-server-or-single-user-applications.300-3330296.en.html
>
> when used outside of the context of autoupdating, the RESTART 4D command
> simply restarts 4D.
>
> > 2017/10/11 8:11、Sujit Shah via 4D_Tech <4d_tech@lists.4d.com> のメール：
> > What does this magical "updater" actually do? what files must be included
> > in the update for it to work. Sorry its not immediately clear.
>
>
>
>
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

-- 

xxx
"There must be ingenuity as well as intention, strategy as well as
strength. "
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Min/Max for Date Fields in 4D

[Alan Tilson via 4D_Tech]

Hello everyone,
It seems that sorting the table is faster than using an array, even after
returning the selection to it's original order, only taking a few ticks on
55k records!
Below is my code should anyone else come across this. I tried it Execute on
Server but the method didn't see the current selection.
Thanks to everyone!
Alan

$pField:=$1
$pTable:=Table(Table($pField))
LONGINT ARRAY FROM SELECTION($pTable->;arCurSelRecs)
ORDER BY($pTable->;$pField->;>)
If (Defined ($2))

$pDate_min:=$2
$pDate_min->:=$pField->

End if
If (Defined ($3))

$pDate_max:=$3
LAST RECORD($pTable->)
$pDate_max->:=$pField->

End if
CREATE SELECTION FROM ARRAY($pTable->;arCurSelRecs)

On Wed, Oct 11, 2017 at 6:39 PM, Alan Tilson  wrote:

> Arnaud,
> Max & Min don't work for date fields or date arrays it seems. I get values
> like 5.67746e+17? Is there a way to translate this to a date?
> Thanks,
> Alan
>
>
> On Wed, Oct 11, 2017 at 6:36 PM, Arnaud de Montard via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
>
>>
>> > Le 11 oct. 2017 à 23:30, Alan Tilson via 4D_Tech <4d_tech@lists.4d.com>
>> a écrit :
>> >
>> > Greetings everyone,
>> >
>> > Is there a way to get the earliest and latest dates from a selection of
>> > records similar to using Min/Max for numerical data?
>>
>> $max_d:=Max([aTable]aDate)
>> $min_d:=Min([aTable]aDate)
>>
>> Or what am I missing here?
>>
>> --
>> Arnaud de Montard
>>
>>
>>
>> **
>> 4D Internet Users Group (4D iNUG)
>> FAQ:  http://lists.4d.com/faqnug.html
>> Archive:  http://lists.4d.com/archives.html
>> Options: http://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: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Communicating With BLE Devices

[Cannon Smith via 4D_Tech]

Is anyone aware of a way to communicate with a Bluetooth Low Energy device from 
4D? It needs to work on both platforms. Perhaps a plugin that I’m not aware of?

(Note that BLE devices communicate in a completely different way than classic 
Bluetooth devices.)

Thanks for any pointers.

--
Cannon.Smith
Synergy Farm Solutions Inc.
Hill Spring, AB Canada
403-626-3236




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

Re: Min/Max for Date Fields in 4D

[Alan Tilson via 4D_Tech]

Arnaud,
Max & Min don't work for date fields or date arrays it seems. I get values
like 5.67746e+17? Is there a way to translate this to a date?
Thanks,
Alan


On Wed, Oct 11, 2017 at 6:36 PM, Arnaud de Montard via 4D_Tech <
4d_tech@lists.4d.com> wrote:

>
> > Le 11 oct. 2017 à 23:30, Alan Tilson via 4D_Tech <4d_tech@lists.4d.com>
> a écrit :
> >
> > Greetings everyone,
> >
> > Is there a way to get the earliest and latest dates from a selection of
> > records similar to using Min/Max for numerical data?
>
> $max_d:=Max([aTable]aDate)
> $min_d:=Min([aTable]aDate)
>
> Or what am I missing here?
>
> --
> Arnaud de Montard
>
>
>
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://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: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Updater v16

[Keisuke Miyako via 4D_Tech]

the page links to SET UPDATE FOLDER

http://doc.4d.com/4Dv16R4/4D/16-R4/SET-UPDATE-FOLDER.301-3317772.en.html

which links to the page about automatic update feature

http://doc.4d.com/4Dv16R4/4D/16-R4/Automatic-updating-of-server-or-single-user-applications.300-3330296.en.html

when used outside of the context of autoupdating, the RESTART 4D command simply 
restarts 4D.

> 2017/10/11 8:11、Sujit Shah via 4D_Tech <4d_tech@lists.4d.com> のメール：
> What does this magical "updater" actually do? what files must be included
> in the update for it to work. Sorry its not immediately clear.




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

Re: Min/Max for Date Fields in 4D

[Arnaud de Montard via 4D_Tech]

> Le 11 oct. 2017 à 23:30, Alan Tilson via 4D_Tech <4d_tech@lists.4d.com> a 
> écrit :
> 
> Greetings everyone,
> 
> Is there a way to get the earliest and latest dates from a selection of
> records similar to using Min/Max for numerical data?

$max_d:=Max([aTable]aDate)
$min_d:=Min([aTable]aDate)

Or what am I missing here?

-- 
Arnaud de Montard 



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

Re: v12 Web Areas

[Keisuke Miyako via 4D_Tech]

the web area on windows v12 uses an old (comparable to IE7) control,
which, unlike v13 and later, does not even benefit from the latest security 
patches available on the system.
public web sites (or even modules such as jquery) that do not support IE7 may 
refuse to run on the v12 web area.

> 2017/10/11 19:01、David Weinberg via 4D_Tech <4d_tech@lists.4d.com> のメール：
> Anyone seen anything similiar? Is three now a compatability problem with 4D
> v12 Web Areas?




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

Re: Is Table Number Valid Cannot Validate New Temporary Table

[Keisuke Miyako via 4D_Tech]

perhaps you could take advantage of the "execute on server" method to make sure 
the functions are called on the server side.
(Get last table number, GET MISSING TABLE NAMES)
the request log is the best way to confirm,
but perhaps an update to the structure is not necessarily pushed to all clients 
immediately.

> 2017/10/11 23:52、Mark Scardigno via 4D_Tech <4d_tech@lists.4d.com> のメール：
>
> See output below (I trimmed it for obvious reasons). It reports the temporary 
> table as a missing table (And I’m not sure why I have 5 missing since I’m 
> using CREATE TABLE IF NOT EXISTS each time).
>
> Also, this only happens when compiled, client/server.




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

Print From Web Area

[Cannon Smith via 4D_Tech]

Hi All,

If I generate a report in HTML and show it in a web area on a form, is there a 
way I can request that it be printed in exactly the same way as if it was in 
Safari or Firefox and printed from there?

Thanks.

--
Cannon.Smith
Synergy Farm Solutions Inc.
Hill Spring, AB Canada
403-626-3236




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

Re: Min/Max for Date Fields in 4D

[Alan Tilson via 4D_Tech]

Hello David,
I'd rather not sort the selection since it's generally already sorted.
But I could do this, although it seems like a lot of overhead compared to
the min/max functions:

Longint array from selection
order by(date field;>)
$Date_min:=date field
Last record
$Date_mix:=date field
create selection from array

Is that something like what you are proposing?
Thanks!
Alan

On Wed, Oct 11, 2017 at 5:47 PM, David Ringsmuth 
wrote:

> Alan,
>
>
>
> Sort the selection by the Date field, take the first Date, and then goto
> selected record (table;records in selection(table)), and get that Date.
>
>
>
> This avoids loading much, except the date field sort.
>
>
>
> Hth!
>
>
>
> David Ringsmuth
>
>
>
> *From: *Alan Tilson via 4D_Tech <4d_tech@lists.4d.com>
> *Sent: *Wednesday, October 11, 2017 4:30 PM
> *To: *4D iNug Technical <4d_tech@lists.4d.com>
> *Cc: *Alan Tilson 
> *Subject: *Min/Max for Date Fields in 4D
>
>
>
> Greetings everyone,
>
>
>
> Is there a way to get the earliest and latest dates from a selection of
>
> records similar to using Min/Max for numerical data?
>
>
>
> I have sorted the data and captured the first and last dates but this seems
>
> rather a lot of work to get this info.
>
>
>
> I believe that I have also used Selection To Array to capture the dates in
>
> the array and then sorted the array.
>
>
>
> Surely there is something I've overlooked?
>
>
>
> Currently using v13.6.
>
>
>
> Thanks,
>
> Alan Tilson
>
> **
>
> 4D Internet Users Group (4D iNUG)
>
> FAQ:  http://lists.4d.com/faqnug.html
>
> Archive:  http://lists.4d.com/archives.html
>
> Options: http://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: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

RE: Min/Max for Date Fields in 4D

[David Ringsmuth via 4D_Tech]

Alan,

Sort the selection by the Date field, take the first Date, and then goto 
selected record (table;records in selection(table)), and get that Date.

This avoids loading much, except the date field sort.

Hth!

David Ringsmuth

From: Alan Tilson via 4D_Tech
Sent: Wednesday, October 11, 2017 4:30 PM
To: 4D iNug Technical
Cc: Alan Tilson
Subject: Min/Max for Date Fields in 4D

Greetings everyone,

Is there a way to get the earliest and latest dates from a selection of
records similar to using Min/Max for numerical data?

I have sorted the data and captured the first and last dates but this seems
rather a lot of work to get this info.

I believe that I have also used Selection To Array to capture the dates in
the array and then sorted the array.

Surely there is something I've overlooked?

Currently using v13.6.

Thanks,
Alan Tilson
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://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: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Min/Max for Date Fields in 4D

[Alan Tilson via 4D_Tech]

Douglas,
Thank you for responding.
I believe Scan Index works on all the records in a Table, not on the
Current Selection? What I'm looking for is a way to easily extract the
earliest and latest dates contained in a field in a selection of records.
Any other ideas?
Thanks again,
Alan


On Wed, Oct 11, 2017 at 5:36 PM, Douglas von Roeder via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Alan:
>
> If the field's indexed, how about Scan index?
>
> --
> Douglas von Roeder
> 949-336-2902
>
> On Wed, Oct 11, 2017 at 2:30 PM, Alan Tilson via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
>
> > Greetings everyone,
> >
> > Is there a way to get the earliest and latest dates from a selection of
> > records similar to using Min/Max for numerical data?
> >
> > I have sorted the data and captured the first and last dates but this
> seems
> > rather a lot of work to get this info.
> >
> > I believe that I have also used Selection To Array to capture the dates
> in
> > the array and then sorted the array.
> >
> > Surely there is something I've overlooked?
> >
> > Currently using v13.6.
> >
> > Thanks,
> > Alan Tilson
> > **
> > 4D Internet Users Group (4D iNUG)
> > FAQ:  http://lists.4d.com/faqnug.html
> > Archive:  http://lists.4d.com/archives.html
> > Options: http://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: http://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: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Min/Max for Date Fields in 4D

[Douglas von Roeder via 4D_Tech]

Alan:

If the field's indexed, how about Scan index?

--
Douglas von Roeder
949-336-2902

On Wed, Oct 11, 2017 at 2:30 PM, Alan Tilson via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Greetings everyone,
>
> Is there a way to get the earliest and latest dates from a selection of
> records similar to using Min/Max for numerical data?
>
> I have sorted the data and captured the first and last dates but this seems
> rather a lot of work to get this info.
>
> I believe that I have also used Selection To Array to capture the dates in
> the array and then sorted the array.
>
> Surely there is something I've overlooked?
>
> Currently using v13.6.
>
> Thanks,
> Alan Tilson
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://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: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Min/Max for Date Fields in 4D

[Alan Tilson via 4D_Tech]

Greetings everyone,

Is there a way to get the earliest and latest dates from a selection of
records similar to using Min/Max for numerical data?

I have sorted the data and captured the first and last dates but this seems
rather a lot of work to get this info.

I believe that I have also used Selection To Array to capture the dates in
the array and then sorted the array.

Surely there is something I've overlooked?

Currently using v13.6.

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

Re: Making LOG EVENT thread-safe

[David Adams via 4D_Tech]

Hey John, we ended up testing different things, I didn't ever get too far
into the memory side. (Thanks for that, good to know.) I retested again
last night and I can kill 4D from entirely legal code. I'll show you at
dinner, if you like. There is a *concurrency bug*.

I'm not convinced that everyone at 4D fully grasps the nature of a
concurrency bug and they're definitely not grasping their importance. It's
an existential bug. What's going on should be *impossible*. I don't mean
rare (it is rare, but not that rare.) There's a _reason_ I've reported this
bug and have been going on about it. When do I normally do that? I don't.
And it is extremely unlikely that I ever will again. There's a margin in
doing so, but it's pretty much all negative margin ;-)

They should email Laurent E., he understands concurrency perfectly and
should appreciate the situation. Plus, I think this feature set comes from
him. It's possible Engineering will discover that it's a highly specific
and localized bug, not a more generalized bug - let's hope so. But there is
*no* way for us to know that on the outside. I could keep probing to get a
better sense of the shape of the bug, but that's a massive misuse of my
time. I've got real work to do. So, no logging to files via a worker in 4D
for me :( I think that I can still use normal processes to do a
record-based passthrough, but that's a very different performance
proposition entirely. (There's no way that I can use that approach for the
Web logs, I've killed 4D before that way...not doing it again.)
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Making LOG EVENT thread-safe

[John Baughman via 4D_Tech]

One thing I forgot to mention/ask…

David’s test routine runs significantly faster with 32-bit 4D than it does with 
64-bit 4D. Any ideas as to why this might be the case?

To refresh memories as to what the test is doing…

For ($1;1;10)
  $prsNum:=New Process(“TestProcess”.0;”TestProcess”)
end for 

//TestProcess method
For ($1;1;100)
  CALL WORKER(“LogWorker”;“LogWorker_Write”;$i)

end for 

//LogWorker
  SEND PACKET(Log_DocRef;$1+Char(Carriage return))

So the test is calling the worker 10 million times. Since nearly all of the 
calls are going into the worker queue, I believe it is the for loops that are 
executing more slowly with 64-bit 4D. The interaction with the file, SEND 
PACKET, appears to be plodding along at the same pace. 

> On Oct 11, 2017, at 6:46 AM, John Baughman  wrote:
> 
> Got an email from Timothy Penner yesterday pointing out that in his testing 
> of this issue he has concluded that the crash occurs because 4D is being 
> pushed past it’s memory limits. That is if run using the 32bit version of 4D. 
> Tim suggested that we run the test using the 64 bit version of 4D.
> 
> Running the test using 64-bit 4D v16 R4, the test does not crash. Thanks Tim!
> 
> I think this explains everything. Running with 32 bit 4D in a 64 bit OS I 
> think we have a 4 GB memory limit which I think would be easily reached as 
> the worker queue goes over 2.1 million calls.
> 
> With 4D 64-bit I think we have a 16 TB memory limit… no problem running the 
> test up to 100 million calls in the queue.
> 
> My conclusion: 
> 
> 1. There is no queue limit that we know of except those dictated by memory 
> constraints.
> 2. There is no bug or memory leak.
> 3. We still need a way to monitor the queue size especially if a worker is 
> expected to be flooded with calls.
> 
> It was interesting watching the test run to it’s end, as the test completes 
> in a relatively short period of time, but the text file continues to build 
> for several hours as the worker continues to consume it’s queue.
> 
> John
> 
>> On Oct 8, 2017, at 8:42 PM, John Baughman  wrote:
>> 
>> 
>>> On Oct 8, 2017, at 5:53 PM, David Adams via 4D_Tech <4d_tech@lists.4d.com> 
>>> wrote:
>>> 
>>> Oh, I forgot to say earlier about John's finding of ~2.1M messages being a
>>> kind of breaking point...that number may not be replicable in other tests.
>>> You might find a different number. The payloads in my scratch database are
>>> quite small. For all I know, if you made the payloads 10x bigger, you would
>>> crash with ~210K messages. I won't be testing this myself.
>> 
>> Why not test this. I added a bit of text to the log entry with the 2 million 
>> calls set to run...
>> 
>> $text:=“”  No crash. Only an index number is being logged, ie, 1, 2, 3, etc.
>> $text:=“j”*16  No problem
>> $text:=“j”*32 Crashes near the end
>> 
>> Here is the kicker. If I am running interpreted with the Runtime Explorer 
>> open it crashes very early and the Runtime Explorer throws an array range 
>> error on occasion before 4D crashes. Sometimes with $text:=“j”*32 set it 
>> actually completes, but if I try to open the Runtime Explorer, 4D crashes.
>> 
>> Now I ‘m thinking maybe it’s not the worker queue limit per say but a memory 
>> leak associated with the worker and/or it’s queue.
>> 
>> John
>> 
>> 
>> 
>> 
>> John Baughman
>> Kailua, Hawaii
>> (808) 262-0328
>> john...@hawaii.rr.com
>> 
>> 
>> 
>> 
>> 
> 
> John Baughman
> Kailua, Hawaii
> (808) 262-0328
> john...@hawaii.rr.com

John Baughman
Kailua, Hawaii
(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: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: NB: Pre-emptive mode hassle

[Tim Nevels via 4D_Tech]

On Oct 11, 2017, at 10:40 AM, David Adams wrote:

> If you don't mind and are on the forums, would you mind putting in a
> feature request? And, for what it's worth, it would be super weird if they
> *hadn't* thought of this. The languages they write in have all kinds of
> compiler pre-processing instrucxtions and compiler macros.

Nobody likes when someone says “what’s wrong with you? You are a weirdo for not 
thinking of this.”  Who knows the minds of 4D Engineers? I’m just trying to be 
nice and give them the benefit of the doubt. (I know that’s not your style, but 
it’s mine.)

David, you are going to catch a lot more flies with honey than with vinegar. 
Give it a try you are going to find it really does work. 

Who do you want to talk to or listen to? A “nice guy” or an “angry man shaking 
his fist”. 

>> I would suggest something like this:
>> //%C-   to turn off compiling code
>> SET TEXT TO PASTEBOARD($stuff_t)
>> //%C+   to turn on compiling code
>> That’s how you do it with range checking using //%R- and //%R+.
> 
> Nice! I was thinking of how you turn off warnings (look at
> Compiler_Suppress_Warnings in our source if you don't know that one), but
> your way is vastly better. It's actually a really exciting feature request
> the way you have it, submit it!

Done. 

> Compiler directive to turn off compiling code

http://forums.4d.com/Post/FR/21136869/1/21136931#21136931

> 
> Sent on : Today - 11:27 AM
> I would like a compiler directive like we have for range checking that you 
> can use to turn off compiling of code so that you can mix thread safe and non 
> thread safe code in a method.
> 
> Example:
> 
> //%C- to turn off compiling code
> SET TEXT TO PASTEBOARD($stuff_t)
> //%C+ to turn on compiling code
> 
> That way when the compiler checks to see if a method is allowed to run as 
> preemptive it can skip over everything bracketed by "//%C-" and "//%C+". 
> 
> Good use is for debugging code that you only need when running interpreted. 
> But there are other good uses for a feature like this.


>> Too many developers go crazy when 4D adds some new features and get it in 
>> their head they MUST
>> rewrite everything to use the new features. That’s not perspective. I think 
>> “nice, another tool
>> in the toolbox that I can use for something new when I get the chance."
> 
> Honestly, I can't remember anyone I've met like that. Plenty of people dive
> in to check out a new featureabout 6-12 months after they're
> introduced. I doubt a lot of people are trying to use preemptive mode. Or,
> if they are, they're not saying anything here.

I sure can. Remember when C_OBJECT variables were introduced? There were 
several developers here that talked about completely overhauling all their code 
to eliminate process and interprocess variables and replace all of it with 
object variables. Code was working fine. They just wanted to use this cool new 
variable type. 

Also trying to justify reducing the size of the process variable table. 
Supposedly having 1 - 10 object variables was far superior to 100 process 
variables. Who the hell cares if your process variable table is 1MB in size 
when everyone has over 4,000MB to work with? And don’t try to say “it will save 
time starting new processes”. Really? By how much real world time? By 4ms? Can 
any human notice a decrease in time by that much? 

And if you really think about it, a C_OBJECT variable most likely takes up more 
space in memory than a C_TEXT or C_LONGINT or C_BOOLEAN. You know, with all the 
extra overhead that a C_OBJECT has to manage to provide the fast lookup and 
access to properties. 

There is no such thing as a free lunch. It may look on the surface to have 
savings, but under the hood — and we don’t know how it is implemented under the 
hood — they is most likely a price for using this new variable type. 

>> I'd love to hear from other people that are using preemptive processes
>> regarding things they found that are good, bad, surprising, exciting, and
>> me'h.
>> 
>> CALL FORM. CALL FORM. CALL FORM. That’s the most useful new command I’ve 
>> found.
> 
> Yes, it solves a lot of problems that I don't have ;-) I'm just not into
> complicated 4D GUI work by choice. 

I do a lot of UI work with 4D. I love doing UI work. Windows and dialog boxes 
that users deal with all day every day. So 4D is great for a lot of the work 
that I do. 

Isn’t it interesting that 4D became so useful and popular because it provided a 
great way to build very nice user interfaces to database solutions. I never 
realized you don’t care about UI stuff and actively avoid it. It explains a 
lot. You are a code monster and backend database monster. If 4D is not 
advancing the language and the database you think it is sitting still. Too bad 
they can’t seem to advance both with equal speed. 

And by the way, your 4D Method presentation example database had a very nice 
UI. Beautiful. So you do have talent or good taste there, in my opinion.

Tim

Re: Making LOG EVENT thread-safe

[John Baughman via 4D_Tech]

Got an email from Timothy Penner yesterday pointing out that in his testing of 
this issue he has concluded that the crash occurs because 4D is being pushed 
past it’s memory limits. That is if run using the 32bit version of 4D. Tim 
suggested that we run the test using the 64 bit version of 4D.

Running the test using 64-bit 4D v16 R4, the test does not crash. Thanks Tim!

I think this explains everything. Running with 32 bit 4D in a 64 bit OS I think 
we have a 4 GB memory limit which I think would be easily reached as the worker 
queue goes over 2.1 million calls.

With 4D 64-bit I think we have a 16 TB memory limit… no problem running the 
test up to 100 million calls in the queue.

My conclusion: 

1. There is no queue limit that we know of except those dictated by memory 
constraints.
2. There is no bug or memory leak.
3. We still need a way to monitor the queue size especially if a worker is 
expected to be flooded with calls.

It was interesting watching the test run to it’s end, as the test completes in 
a relatively short period of time, but the text file continues to build for 
several hours as the worker continues to consume it’s queue.

John

> On Oct 8, 2017, at 8:42 PM, John Baughman  wrote:
> 
> 
>> On Oct 8, 2017, at 5:53 PM, David Adams via 4D_Tech <4d_tech@lists.4d.com 
>> > wrote:
>> 
>> Oh, I forgot to say earlier about John's finding of ~2.1M messages being a
>> kind of breaking point...that number may not be replicable in other tests.
>> You might find a different number. The payloads in my scratch database are
>> quite small. For all I know, if you made the payloads 10x bigger, you would
>> crash with ~210K messages. I won't be testing this myself.
> 
> Why not test this. I added a bit of text to the log entry with the 2 million 
> calls set to run...
> 
> $text:=“”  No crash. Only an index number is being logged, ie, 1, 2, 3, etc.
> $text:=“j”*16  No problem
> $text:=“j”*32 Crashes near the end
> 
> Here is the kicker. If I am running interpreted with the Runtime Explorer 
> open it crashes very early and the Runtime Explorer throws an array range 
> error on occasion before 4D crashes. Sometimes with $text:=“j”*32 set it 
> actually completes, but if I try to open the Runtime Explorer, 4D crashes.
> 
> Now I ‘m thinking maybe it’s not the worker queue limit per say but a memory 
> leak associated with the worker and/or it’s queue.
> 
> John
> 
> 
> 
> 
> John Baughman
> Kailua, Hawaii
> (808) 262-0328
> john...@hawaii.rr.com 
> 
> 
> 
> 
> 

John Baughman
Kailua, Hawaii
(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: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: v12 Web Areas

[Ortwin Zillgen via 4D_Tech]

> I have tried the same 4D and html in v16 and I get the map to show but
> stragely, with both Google Maps and Leaflet, I get the map but the markers
> are not added to it. I have also tried a demo database from this years 4D
> World Tour, which shows the map in the 4D web area but not the markers. 
> 
> Anyone seen anything similiar? Is three now a compatability problem with 4D
> v12 Web Areas? 


suppose your JavaScript is faulty.

I learned to love the WebKit-Debugger for that purpose


Afaik webarea uses the system-rendering engine which is some subset of an older 
IE, even on Windows 10. Just checked: V12 does not support inclusion of WebKit 
engine.



Regards
O r t w i n  Z i l l g e n
-
   
 
member of developer-network 

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

Re: How can a component get a pointer to a host form (dynamic) variable?

[Jim Dorrance via 4D_Tech]

No, the pointer is nil. I finally execute a host process that executes a
component process that returns the picture to the host to be copied to a
host form var. There must be a simpler way:(


On Wed, Oct 11, 2017 at 5:49 PM, Jeremy Roussak via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Can’t the pointer be passed from the host as a parameter to the method in
> the host which draws the picture? Just a thought.
>
>
> Jeremy Roussak
> j...@mac.com
>
>
>
> > On 11 Oct 2017, at 14:06, Jim Dorrance via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
> >
> > Thanks.
> >
> > I just want to copy a SVG picture created in a component ( using lots of
> > data only available in the subform) to the host form.
> >
> > On Wed, Oct 11, 2017 at 2:21 PM, Jeremy Roussak via 4D_Tech <
> > 4d_tech@lists.4d.com> wrote:
> >
> >> Jim,
> >>
> >> I do it via a callback routine in the host. To make things easy, the
> >> component creates several methods in the host the first time it’s used.
> >>
> >> Jeremy
> >>
> >> Jeremy Roussak
> >> j...@mac.com
> >>
> >>
> >>
> >>> On 11 Oct 2017, at 13:02, Jim Dorrance via 4D_Tech <
> 4d_tech@lists.4d.com>
> >> wrote:
> >>>
> >>> How can a component method get a pointer to a host form (dynamic)
> >> variable?
> >>>
> >>> --
> >>> Jim Dorrance
> >> **
> >> 4D Internet Users Group (4D iNUG)
> >> FAQ:  http://lists.4d.com/faqnug.html
> >> Archive:  http://lists.4d.com/archives.html
> >> Options: http://lists.4d.com/mailman/options/4d_tech
> >> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> >> **
> >
> >
> >
> >
> > --
> > Jim Dorrance
> > jim.dorra...@gmail.com
> > 4...@dorrance.eu
> > www.4d.dorrance.eu
> >
> > PS: If you know of anyone that needs an experienced 4D programmer to add
> > energy and experience to their team, please let me know. I have
> > experience in many areas. Reasonable rates. Remote or Paris only.
> > **
> > 4D Internet Users Group (4D iNUG)
> > FAQ:  http://lists.4d.com/faqnug.html
> > Archive:  http://lists.4d.com/archives.html
> > Options: http://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: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
>



-- 
Jim Dorrance
jim.dorra...@gmail.com
4...@dorrance.eu
www.4d.dorrance.eu

PS: If you know of anyone that needs an experienced 4D programmer to add
energy and experience to their team, please let me know. I have
experience in many areas. Reasonable rates. Remote or Paris only.
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: How can a component get a pointer to a host form (dynamic) variable?

[Jeremy Roussak via 4D_Tech]

Can’t the pointer be passed from the host as a parameter to the method in the 
host which draws the picture? Just a thought.


Jeremy Roussak
j...@mac.com



> On 11 Oct 2017, at 14:06, Jim Dorrance via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Thanks.
> 
> I just want to copy a SVG picture created in a component ( using lots of
> data only available in the subform) to the host form.
> 
> On Wed, Oct 11, 2017 at 2:21 PM, Jeremy Roussak via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> 
>> Jim,
>> 
>> I do it via a callback routine in the host. To make things easy, the
>> component creates several methods in the host the first time it’s used.
>> 
>> Jeremy
>> 
>> Jeremy Roussak
>> j...@mac.com
>> 
>> 
>> 
>>> On 11 Oct 2017, at 13:02, Jim Dorrance via 4D_Tech <4d_tech@lists.4d.com>
>> wrote:
>>> 
>>> How can a component method get a pointer to a host form (dynamic)
>> variable?
>>> 
>>> --
>>> Jim Dorrance
>> **
>> 4D Internet Users Group (4D iNUG)
>> FAQ:  http://lists.4d.com/faqnug.html
>> Archive:  http://lists.4d.com/archives.html
>> Options: http://lists.4d.com/mailman/options/4d_tech
>> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
>> **
> 
> 
> 
> 
> -- 
> Jim Dorrance
> jim.dorra...@gmail.com
> 4...@dorrance.eu
> www.4d.dorrance.eu
> 
> PS: If you know of anyone that needs an experienced 4D programmer to add
> energy and experience to their team, please let me know. I have
> experience in many areas. Reasonable rates. Remote or Paris only.
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://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: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Post Key command not working in converted 4Dv16 database - SOLVED

[Ken Daniel via 4D_Tech]

All, I finally solved my problem. All I had to do was check* Unicode Mode*
in Design > Database Settings > Compatibility. Thanks very much to everyone
for their suggestions and help. :-) Ken


*P.S. Ultimately it was Vance Villanueva from 4D Tech Support that helped
me solve the problem. He prepared a screencast showing me that post key
worked using my database and I noticed during the screencast a message
popped up warning that the database must be used in Unicode mode in order
to be opened and asking to temporarily switch to Unicode mode. I had never
seen that message before and that's what lead me to check the Unicode Mode
in my database.*

On Mon, Oct 9, 2017 at 9:41 AM, Ken Daniel  wrote:

> Koen & Steve, thanks for the tip, but in this case I am using POST
> KEY(Character code(".");Command key mask) and had the shortcut of Ctrl .
> assigned to a button. It only fails to work in this one converted database.
> I've converted another database to v16 for a different application and it
> works fine. I've compared the two databases and can't discern any
> difference. In another test, if I execute POST KEY (Character Code("a")), I
> can see it populate a variable field with the letter "a", but it just won't
> execute the code assigned to the button with that shortcut. Ken
>
> On Mon, Oct 9, 2017 at 9:07 AM, Koen Van Hooreweghe via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
>
>> Hi Ken,
>>
>> What particular shortcut are you using?
>> Also check the case of the character you are using, as Stephen pointed
>> out. In v14 I discovered a bug when running the command POST KEY(Character
>> code("A");Command key mask). This was fine in v13 and earlier, but crashes
>> v14, v15 and v16.
>> My report got bug number ACI0093238 in july 2015, but as I just tested in
>> v16.2 it has not been fixed yet.
>>
>> On the other hand the code should be: POST KEY(Character
>> code(“a");Command key mask), which works fine in v14 and later.
>>
>> IIRC in compiled mode it seemed to be working, but 4D would crash a bit
>> later.
>>
>> Kind regards,
>> Koen
>>
>
> On Mon, Oct 9, 2017 at 8:38 AM, Stephen J. Orth  com> wrote:
>
>> Ken,
>>
>> If I recall correctly, I ran into an issue due to case sensitivity.  Make
>> sure the case of the assigned letter is the same as how you are using it in
>> the command.
>>
>>
>> Steve
>>
>>
>
>>
>> > Op 8 okt. 2017, om 15:21 heeft Ken Daniel via 4D_Tech <
>> 4d_tech@lists.4d.com> het volgende geschreven:
>> >
>> > All, I'm having a problem with the Post Key command not working in a
>> > database converted from 4Dv14 to v16. Post Key works fine in 4Dv14, and
>> > works in 4Dv15 and even in a newly created database in v16, but not in
>> my
>> > converted database. I've tried resetting the Preferences and Database
>> > Settings to Factory Settings and changing event actions, but nothing has
>> > worked. Anyone have any suggestions as to what the problem may be?
>> Thanks,
>>
>>
>>
>> 
>> Compass bvba
>> Koen Van Hooreweghe
>> Kloosterstraat 65
>> 9910 Knesselare
>> Belgium
>> tel +32 495 511.653
>>
>> **
>> 4D Internet Users Group (4D iNUG)
>> FAQ:  http://lists.4d.com/faqnug.html
>> Archive:  http://lists.4d.com/archives.html
>> Options: http://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: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Is Table Number Valid Cannot Validate New Temporary Table

[Mark Scardigno via 4D_Tech]

Miyako,

One of the problems is that 'Get Last Table Number’ doesn’t acknowledge the new 
temporary table at all, but the Util_GetTableNum function does.

For example, after I create the temporary table, Util_GetTableNum returns table 
number 51. But then when 'Is Table Number Valid’ fails in my code, I log using 
the following method and 'Last Table Number' gives me 48.

See output below (I trimmed it for obvious reasons). It reports the temporary 
table as a missing table (And I’m not sure why I have 5 missing since I’m using 
CREATE TABLE IF NOT EXISTS each time).

Also, this only happens when compiled, client/server.

ARRAY TEXT(asTables;Get last table number)
If (Get last table number>0)
For ($vlTables;Size of array(asTables);1;-1)
If (Is table number valid($vlTables))
SEND PACKET(MyLogDoc;Char(13)+String($vlTables;"00 ")+Table name($vlTables))
Else 
SEND PACKET(MyLogDoc;Char(13)+String($vlTables)+" *Deleted*")
End if 
End for 
End if 

ARRAY TEXT($arrMissingTables;0)
GET MISSING TABLE NAMES($arrMissingTables)
$SizeArray:=Size of array($arrMissingTables)
If ($SizeArray#0)
For ($i;1;$SizeArray)
If (Find in array(asTables;$arrMissingTables{$i})=-1)
SEND PACKET(MyLogDoc;Char(13)+$arrMissingTables{$i}+" *Missing*")
End if 
End for 
End if 

//**Output*//
48 Table48
…
…
02 Table2
01 Table1
TempTable_4dt *Missing*
TempTable_4dt *Missing*
TempTable_4dt *Missing*
TempTable_4dt *Missing*
TempTable_4dt *Missing*

Regards,
Mark

> On Oct 10, 2017, at 12:12 PM, Keisuke Miyako via 4D_Tech 
> <4d_tech@lists.4d.com > wrote:
> 
> why not simply use Get last table number?
> 
> and you don't really need to use SQL to get a table pointer from name, just 
> do something like...
> 
> C_POINTER($p)
> $name:="Table_1"
> $formula:=""
> PROCESS 4D TAGS($formula;$formula;->$p)

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

v12 Web Areas

[David Weinberg via 4D_Tech]

Hi All, 

I have a system that is still using 4D v12. I am trying to add a map to Web
Area. I had it working at the end of last year as a proof of concept. Now
however, despite the HTML working directly in a browser, I am unable to get
the JavaScript to run. I just get a blank window. This is on a Windows 10 PC
with Chrome Version 61.0.3163.100, Microsoft Edge 40.15063.0.0 and IE
11.608.15063.0. 

I have tried the same 4D and html in v16 and I get the map to show but
stragely, with both Google Maps and Leaflet, I get the map but the markers
are not added to it. I have also tried a demo database from this years 4D
World Tour, which shows the map in the 4D web area but not the markers. 

Anyone seen anything similiar? Is three now a compatability problem with 4D
v12 Web Areas? 

Thanks, 

David

p.s. Sorry if this is a duplicate post, I posted via Nabble and I'm not sure
if it worked the first time.



--
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: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: How can a component get a pointer to a host form (dynamic) variable?

[Jim Dorrance via 4D_Tech]

Thanks.

I just want to copy a SVG picture created in a component ( using lots of
data only available in the subform) to the host form.

On Wed, Oct 11, 2017 at 2:21 PM, Jeremy Roussak via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Jim,
>
> I do it via a callback routine in the host. To make things easy, the
> component creates several methods in the host the first time it’s used.
>
> Jeremy
>
> Jeremy Roussak
> j...@mac.com
>
>
>
> > On 11 Oct 2017, at 13:02, Jim Dorrance via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
> >
> > How can a component method get a pointer to a host form (dynamic)
> variable?
> >
> > --
> > Jim Dorrance
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **




-- 
Jim Dorrance
jim.dorra...@gmail.com
4...@dorrance.eu
www.4d.dorrance.eu

PS: If you know of anyone that needs an experienced 4D programmer to add
energy and experience to their team, please let me know. I have
experience in many areas. Reasonable rates. Remote or Paris only.
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: How can a component get a pointer to a host form (dynamic) variable?

[Jeremy Roussak via 4D_Tech]

Jim,

I do it via a callback routine in the host. To make things easy, the component 
creates several methods in the host the first time it’s used.

Jeremy

Jeremy Roussak
j...@mac.com



> On 11 Oct 2017, at 13:02, Jim Dorrance via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> How can a component method get a pointer to a host form (dynamic) variable?
> 
> -- 
> Jim Dorrance
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

How can a component get a pointer to a host form (dynamic) variable?

[Jim Dorrance via 4D_Tech]

How can a component method get a pointer to a host form (dynamic) variable?

-- 
Jim Dorrance
jim.dorra...@gmail.com
4...@dorrance.eu
www.4d.dorrance.eu

PS: If you know of anyone that needs an experienced 4D programmer to add
energy and experience to their team, please let me know. I have
experience in many areas. Reasonable rates. Remote or Paris only.
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**