Re: Modern 4D Skills...

[Alan Tilson via 4D_Tech]

Hey Rob,
Did you ever get info on your request?
Alan

On Wed, Mar 1, 2023 at 3:33 PM Robert ListMail via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> For those seasoned developers of 4D v2 -> v16, before the days of ORDA,
> that want to start programming new projects (or enhancing old projects)
> with the current 4D best practices, is there a document that contrasts the
> old and new ways of accomplishing common tasks and where the benefit of the
> new way is stated? What’s the recommended way to get up top speed on the
> new 4D goodness? :)
>
> Thanks,
>
> Rob
>
> **
> 4D Internet Users Group (4D iNUG)
> New Forum: https://discuss.4D.com
> 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)
New Forum: https://discuss.4D.com
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Recurring “Wrong Header” issue, same table, v17.5, Windows

[Alan Tilson via 4D_Tech]

Hello out there,

I'm not sure if anyone follows this list anymore, but I thought I'd take a
shot!

Every week or so we have what I’ve been calling a data integrity issue
where we start getting errors often including “Wrong header for record in
table WOOp”. Almost always the same table.


The only way I’ve found to fix this is using the “Repair using Tags” or
something to that effect.

What could cause this? Is it possible for an issue with code to create this
situation?

Any ideas would be appreciated!

Alan Tilson
4D v17.5
Windows Server for 4D Server
Windows 7 & 10 for Clients

Hardware guy does not think it is the RAID system…and I'm inclined to agree
since it is almost always on one table.
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: How to Sort with Quick Report V17.5

[Alan Tilson via 4D_Tech]

Actually, there was a Manual Relation that I could turn on using Set Field
Relations so that sorting does now work.
Strangely enough I still had to load the related data with code to get it
to display...
Thank you!
Alan

On Tue, Jul 26, 2022 at 8:38 PM Alan Tilson  wrote:

> Hello Keisuke & Mike,
>
> Thank you for your responses, including the screenshot Mike sent. There is
> a contextual sort which is what I was looking for, but it doesn't work so
> far since I want to sort based on an indirectly related field (somehow I
> thought it would work). I'll just pre-sort the data?
>
> All the best,
> Alan
>
> On Tue, Jul 26, 2022 at 8:05 PM Keisuke Miyako via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
>
>> the last time I used Quick Report was v2003 so this information might be
>> trash,
>>
>> but isn't there an option to sort in the contextual menu when you click a
>> column?
>> **
>> 4D Internet Users Group (4D iNUG)
>> New Forum: https://discuss.4D.com
>> 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)
New Forum: https://discuss.4D.com
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: How to Sort with Quick Report V17.5

[Alan Tilson via 4D_Tech]

Hello Keisuke & Mike,

Thank you for your responses, including the screenshot Mike sent. There is
a contextual sort which is what I was looking for, but it doesn't work so
far since I want to sort based on an indirectly related field (somehow I
thought it would work). I'll just pre-sort the data?

All the best,
Alan

On Tue, Jul 26, 2022 at 8:05 PM Keisuke Miyako via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> the last time I used Quick Report was v2003 so this information might be
> trash,
>
> but isn't there an option to sort in the contextual menu when you click a
> column?
> **
> 4D Internet Users Group (4D iNUG)
> New Forum: https://discuss.4D.com
> 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)
New Forum: https://discuss.4D.com
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

How to Sort with Quick Report V17.5

[Alan Tilson via 4D_Tech]

*Sorry, I meant to change the subject for the previous email!*

Hello everyone,
> Can someone please tell me how to add a sort to Quick Reports v17.5?
> I have an old report that I've duplicated and modified, but I can't figure
> out the sorting.
> At the top, all I see is New/Open/Destination/Preview/Execute then
> Clear/Revert then Header/Footer then Options (basically Page Setup) and
> finally Fields (specifies the fields in the report).
> Then down the left side I see Title/Format/Grand Total.
> This is inside a new report, but I see the same limited features opening
> an old report.
> I opened a new blank report with QR REPORT([SHIPPER_LINE];"
> ";True;True;True) and opened the old report with QR
> REPORT([SHIPPER_LINE];"";True;True;True).
> Any info or thoughts on this situation would be appreciated!
> Alan Tilson
>
>>
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: Quick Report documentation for V17

[Alan Tilson via 4D_Tech]

Hello everyone,
Can someone please tell me how to add a sort to Quick Reports v17.5?
I have an old report that I've duplicated and modified, but I can't figure
out the sorting.
At the top, all I see is New/Open/Destination/Preview/Execute then
Clear/Revert then Header/Footer then Options (basically Page Setup) and
finally Fields (specifies the fields in the report).
Then down the left side I see Title/Format/Grand Total.
This is inside a new report, but I see the same limited features opening an
old report.
I opened a new blank report with QR REPORT([SHIPPER_LINE];"
";True;True;True) and opened the old report with QR
REPORT([SHIPPER_LINE];"";True;True;True).
Any info or thoughts on this situation would be appreciated!
Alan Tilson


On Tue, Jul 26, 2022 at 2:22 PM Alan Tilson  wrote:

> Hello Doug,
> Did you ever find a manual for v17 quick reports? I'm trying to modify a
> report and I can't figure out how to change the sort order?
> Thanks!
> Alan
>
> On Thu, Nov 21, 2019 at 10:55 AM Doug Cottrill via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
>
>> HI all,
>>
>> There used to be a separate 4D Quick Reports User Manual.  There does not
>> seem to be one in V17.  What are folks giving to their users to let them
>> know how to use the quick report editor nowadays?
>>
>> Thanks,
>>
>> DKC
>> **
>> 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)
New Forum: https://discuss.4D.com
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: Quick Report documentation for V17

[Alan Tilson via 4D_Tech]

Hello Doug,
Did you ever find a manual for v17 quick reports? I'm trying to modify a
report and I can't figure out how to change the sort order?
Thanks!
Alan

On Thu, Nov 21, 2019 at 10:55 AM Doug Cottrill via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> HI all,
>
> There used to be a separate 4D Quick Reports User Manual.  There does not
> seem to be one in V17.  What are folks giving to their users to let them
> know how to use the quick report editor nowadays?
>
> Thanks,
>
> DKC
> **
> 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)
New Forum: https://discuss.4D.com
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: Can't Save Record Mandatory field is null

[Alan Tilson via 4D_Tech]

Hello Keisuke,
You make it sound simple, so how do I "parse the xml"?
Open it in a text editor and search for "reject null values"?
Thanks!
Alan

On Wed, Jan 26, 2022 at 6:46 PM Keisuke Miyako via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> you can "export structure" and parse the xml.
>
> I cannot find a way to search for fields with "Reject NULL Values" set to
> true. Surely this must be possible, so can someone please let me know how
> to do it?
>
> **
> 4D Internet Users Group (4D iNUG)
> New Forum: https://discuss.4D.com
> 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)
New Forum: https://discuss.4D.com
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: Can't Save Record Mandatory field is null

[Alan Tilson via 4D_Tech]

Hello again,
I cannot find a way to search for fields with "Reject NULL Values" set to
true. Surely this must be possible, so can someone please let me know how
to do it?
Thank you,
Alan

On Wed, Jan 26, 2022 at 12:26 PM Alan Tilson  wrote:

> Hello Sannyasin,
> I just got bitten by this same issue, so thank you very much for sharing
> the solution.
> We had a field that was accidentally marked to 'Reject null input values'
> over 15 months ago and today it started causing problems!
> But we are back up and running after searching for this issue. I had only
> looked at Mandatory fields previously.
> Much appreciated,
> Alan Tilson
>
> On Wed, Sep 7, 2016 at 4:19 PM Sannyasin Siddhanathaswami <
> sid...@hindu.org> wrote:
>
>> Solved!
>>
>> Tech support found that I had “Reject null input values” on by First Name
>> field! We must have checked that by accident at some point. Unchecking it
>> fixed the issue.
>>
>>
>> --
>> Sannyasin Siddhanathaswami
>>
>> On September 1, 2016 at 11:25:56 PM, Sannyasin Siddhanathaswami (
>> sid...@hindu.org) wrote:
>>
>> Regarding the debug log, I was able to start and stop it from the
>> maintenance tab on the 4D Server administration window. That’s good enough
>> as I didn’t have any other activity at the logging time. Of course, I don’t
>> understand enough of what the log says to see any problem...
>>
>> --
>> Sannyasin Siddhanathaswami
>> **
>> 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)
New Forum: https://discuss.4D.com
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: Can't Save Record Mandatory field is null

[Alan Tilson via 4D_Tech]

Hello Sannyasin,
I just got bitten by this same issue, so thank you very much for sharing
the solution.
We had a field that was accidentally marked to 'Reject null input values'
over 15 months ago and today it started causing problems!
But we are back up and running after searching for this issue. I had only
looked at Mandatory fields previously.
Much appreciated,
Alan Tilson

On Wed, Sep 7, 2016 at 4:19 PM Sannyasin Siddhanathaswami 
wrote:

> Solved!
>
> Tech support found that I had “Reject null input values” on by First Name
> field! We must have checked that by accident at some point. Unchecking it
> fixed the issue.
>
>
> --
> Sannyasin Siddhanathaswami
>
> On September 1, 2016 at 11:25:56 PM, Sannyasin Siddhanathaswami (
> sid...@hindu.org) wrote:
>
> Regarding the debug log, I was able to start and stop it from the
> maintenance tab on the 4D Server administration window. That’s good enough
> as I didn’t have any other activity at the logging time. Of course, I don’t
> understand enough of what the log says to see any problem...
>
> --
> Sannyasin Siddhanathaswami
> **
> 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)
New Forum: https://discuss.4D.com
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: v17.5 Explorer Window - how to delete prefs

[Alan Tilson via 4D_Tech]

Thank you Tom & Keisuke!
I just tried the shift key option being so simple and all, and it worked
perfectly!
Wow!
Alan

On Thu, Apr 22, 2021 at 8:22 PM Keisuke Miyako via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> you can also open the Explorer holding down the shift key.
> **
> 4D Internet Users Group (4D iNUG)
> New Forum: https://discuss.4D.com
> 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)
New Forum: https://discuss.4D.com
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

v17.5 Explorer Window - how to delete prefs

[Alan Tilson via 4D_Tech]

Hello everyone,

I have deleted all the preferences files that I can find but the list pane
in 4d Explorer runs off the bottom of the Explorer window.

Any pointers would be appreciated!

Windows Server 2008 R2 Standard, 4D v17.5 (the same machine that is running
4D Server).

Thanks,
Alan Tilson
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: Copy and Paste

[Alan Tilson via 4D_Tech]

Hello Tom,
Yes, I am using Windows Remote Desktop when this happens. And it does
affect more than just 4d, including copy and paste from the remote session
to my local session and vice versa!
Alan

On Wed, Apr 21, 2021 at 3:16 PM THOMAS BENEDICT via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> I've noticed similar copy issues in RDP sessions. In my experience it has
> not been limited to 4D.
>
> Are you using Microsoft Remote Access for Windows or MacOS? I ask, because
> the MacOS version seems to be more stable and certainly has a better UX
> than the Windows version.
>
> Tom Benedict
>
> > On 04/21/2021 9:40 AM Alan Tilson via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
> >
> >
> > Hello everyone,
> > I've been having this problem in v17.5 where ctrl C does not copy the
> > selected text in a method. Often the right click Copy does work. Aborting
> > and restarting the rdpclip.exe process generally gets it going again.
> > Alan
> >
> > On Tue, Mar 23, 2021 at 2:34 PM Jody Bevan via 4D_Tech <
> 4d_tech@lists.4d.com>
> > wrote:
> >
> > > Ferdinando:
> > >
> > > If you are talking about using the command in the language to to this
> then
> > > - yes that is a known problem. Very frustrating indeed.
> > >
> > > Here is what we did just before each copy or paste and then it always
> > > worked.
> > >
> > > GET WINDOW RECT($vL_WinLeftSide; $vL_WinTopSide; $vL_WinRightSide;
> > > $vL_WinBottomSide; $vL_WindowRef)
> > > SET WINDOW RECT($vL_WinLeftSide; $vL_WinTopSide; $vL_WinRightSide;
> > > $vL_WinBottomSide; $vL_WindowRef)
> > >
> > > Hope this helps you out.
> > >
> > > Jody Bevan
> > >
> > > > On Mar 23, 2021, at 10:56 AM, stardata.info via 4D_Tech <
> > > 4d_tech@lists.4d.com> wrote:
> > > >
> > > > Hi All,
> > > >
> > > > Form some days in my method editor of 4D V16 on Windows, sometimes
> the
> > > commands Copy and Paste not work.
> > > >
> > > > For solve i need to restart windows
> > > >
> > > > Someone know the solution?
> > > >
> > > > Thanks
> > > >
> > > > /Ferdinando/
> > > >
> > >
> > > **
> > > 4D Internet Users Group (4D iNUG)
> > > New Forum: https://discuss.4D.com
> > > 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)
> > New Forum: https://discuss.4D.com
> > 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)
> New Forum: https://discuss.4D.com
> 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)
New Forum: https://discuss.4D.com
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: Copy and Paste

[Alan Tilson via 4D_Tech]

Hello everyone,
I've been having this problem in v17.5 where ctrl C does not copy the
selected text in a method. Often the right click Copy does work. Aborting
and restarting the rdpclip.exe process generally gets it going again.
Alan

On Tue, Mar 23, 2021 at 2:34 PM Jody Bevan via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> Ferdinando:
>
> If you are talking about using the command in the language to to this then
> - yes that is a known problem. Very frustrating indeed.
>
> Here is what we did just before each copy or paste and then it always
> worked.
>
> GET WINDOW RECT($vL_WinLeftSide; $vL_WinTopSide; $vL_WinRightSide;
> $vL_WinBottomSide; $vL_WindowRef)
> SET WINDOW RECT($vL_WinLeftSide; $vL_WinTopSide; $vL_WinRightSide;
> $vL_WinBottomSide; $vL_WindowRef)
>
> Hope this helps you out.
>
> Jody Bevan
>
> > On Mar 23, 2021, at 10:56 AM, stardata.info via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> >
> > Hi All,
> >
> > Form some days in my method editor of 4D V16 on Windows, sometimes the
> commands Copy and Paste not work.
> >
> > For solve i need to restart windows
> >
> > Someone know the solution?
> >
> > Thanks
> >
> > /Ferdinando/
> >
>
> **
> 4D Internet Users Group (4D iNUG)
> New Forum: https://discuss.4D.com
> 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)
New Forum: https://discuss.4D.com
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: Record locking woes

[Alan Tilson via 4D_Tech]

I was just searching for 9906 SQL error threads and I found 4 in gmail, 1
in French at discuss.4d.com and 0 in kb.4d.com. So everything doesn't seem
to be there...
FYI,
Alan

On Mon, Jan 11, 2021 at 2:21 PM Alan Tilson  wrote:

> Well, it is pretty strange.
> I tried turning off this particular automatic relation before the sort but
> that didn't work.
> I had to actually change the relation itself.
> I'd like to build a little test db to see if I can replicate it there...
> but I probably won't.
> I'm glad some of you are still out there... I felt rather strange when I
> realize the emails had basically stopped.
> gmail currently shows that I have 27,619 threads in my 4D folder  8o)
> Alan
>
> On Mon, Jan 11, 2021 at 2:06 PM Neil Dennis  wrote:
>
>>
>> > If anyone is out there...
>> > So is the email list obsolete?
>>
>> A few people are still monitoring, I’m still here because I haven’t
>> turned if off yet. But yes, I consider this email list obsolete.
>>
>> I don’t think that the automatic relations loading a locking a record on
>> a sort is a 4D bug. It has been this way for a while.
>>
>> Neil
>
>
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: Record locking woes

[Alan Tilson via 4D_Tech]

Well, it is pretty strange.
I tried turning off this particular automatic relation before the sort but
that didn't work.
I had to actually change the relation itself.
I'd like to build a little test db to see if I can replicate it there...
but I probably won't.
I'm glad some of you are still out there... I felt rather strange when I
realize the emails had basically stopped.
gmail currently shows that I have 27,619 threads in my 4D folder  8o)
Alan

On Mon, Jan 11, 2021 at 2:06 PM Neil Dennis  wrote:

>
> > If anyone is out there...
> > So is the email list obsolete?
>
> A few people are still monitoring, I’m still here because I haven’t turned
> if off yet. But yes, I consider this email list obsolete.
>
> I don’t think that the automatic relations loading a locking a record on a
> sort is a 4D bug. It has been this way for a while.
>
> Neil
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: Record locking woes

[Alan Tilson via 4D_Tech]

If anyone is out there...
So is the email list obsolete?
Thanks,
Alan

On Mon, Jan 11, 2021 at 1:24 PM Alan Tilson  wrote:

> Hello everyone,
>
> I apologize for not continuing to let you know what was happening
> in my exploration of this issue. I think I found a 4D bug but it could be
> database corruption I suppose.
>
> The record locking was caused by sorting a related many (automatic) table
> within the transaction, where my guess is that the parent record was
> reloaded multiple times.
>
> Changing the relation to manual fixed the problem in the one place where
> it was very repeatable. The other more long-term occasional problem may be
> better but it doesn't seem to be fixed.
>
> I kept tracing through the code that ran on opening the detail form and
> stopping at different places to see if the locking had occurred and it was
> only the sort that caused the problem.
>
> This occurred in v17.4 and v17.5.
>
> Thanks,
> Alan
>
> On Thu, Dec 10, 2020 at 11:42 PM Guy Algot  wrote:
>
>> Alan,
>>
>> Have you tried using ‘Get locked records info’?
>>
>>
>>
>> On Dec 8, 2020, at 1:22 PM, Alan Tilson via 4D_Tech <4d_tech@lists.4d.com>
>> wrote:
>>
>> Hello everyone,
>>
>> I'm having a record locking problem where I cannot understand how the
>> record is staying locked. There is no open transaction and no record stack
>> (Push Record).
>>
>> I simply open a record from a list view and close it. The table is still
>> read-write but the record is unloaded. Load Record can load another record
>> without releasing the locked record.
>>
>> I don't see anything in the trigger code that would keep the record locked
>> and trigger issues discussed here seem to affect related tables, not the
>> main table.
>>
>> Opening another record in the offending process does unlock the locked
>> record, but users report that sometimes this does not work. They have to
>> close the process.
>>
>> 4D v17.4 Client Server, Windows Server 2008 R2 server and client
>>
>> I'm thinking to try going to read-only in the list view to see if that
>> works but I would love to hear some other ideas!
>>
>> Thanks,
>> Alan Tilson
>>
>> On Fri, Aug 29, 2014 at 1:33 AM Justin Leavens 
>> wrote:
>>
>> Ben Kershaw-3 wrote
>>
>> Create a method that calls READ ONLY(*), and set the method to execute on
>> the server. Call this method from your init process method (I’m assuming
>> you have one).
>>
>> If the problem is a trigger loading a record in another table and leaving
>> it locked, this will start all tables in READ ONLY mode, so when the
>> record is loaded it will be in READ ONLY state.
>>
>> If you still have records getting locked, at least you’ll know it has
>> nothing to do with triggers or something running in the servers ‘twin’
>> process.
>>
>>
>> Thanks, Ben. Indeed I found the culprit was a related table being loaded
>> in
>> a trigger and not being unloaded. This resulted in the record being
>> reported
>> locked by the process (yes, I use Chuck's locked record component) yet
>> zero
>> records loaded on the client. And this of course worked differently in
>> client server than it did in single user. Thanks for the tip!
>>
>>
>>
>>
>> Later,
>>
>> Guy
>>
>>
>> --
>>
>> Guy Algot, Solutions Specialist
>>
>> Edmonton, Alberta
>>
>> (780) 974-8538
>>
>>
>> hardware, installation, training, support, programming, internet
>>
>> specializing in 4th Dimension
>>
>> =-= =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
>>
>> "Microsoft is a cross between the Borg and the Ferengi. Unfortunately,
>>
>> they use Borg to do their marketing and Ferengi to do their programming."
>>
>> -- Simon Slavin
>>
>>
>>
>>
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: Record locking woes

[Alan Tilson via 4D_Tech]

Hello everyone,

I apologize for not continuing to let you know what was happening
in my exploration of this issue. I think I found a 4D bug but it could be
database corruption I suppose.

The record locking was caused by sorting a related many (automatic) table
within the transaction, where my guess is that the parent record was
reloaded multiple times.

Changing the relation to manual fixed the problem in the one place where it
was very repeatable. The other more long-term occasional problem may be
better but it doesn't seem to be fixed.

I kept tracing through the code that ran on opening the detail form and
stopping at different places to see if the locking had occurred and it was
only the sort that caused the problem.

This occurred in v17.4 and v17.5.

Thanks,
Alan

On Thu, Dec 10, 2020 at 11:42 PM Guy Algot  wrote:

> Alan,
>
> Have you tried using ‘Get locked records info’?
>
>
>
> On Dec 8, 2020, at 1:22 PM, Alan Tilson via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
>
> Hello everyone,
>
> I'm having a record locking problem where I cannot understand how the
> record is staying locked. There is no open transaction and no record stack
> (Push Record).
>
> I simply open a record from a list view and close it. The table is still
> read-write but the record is unloaded. Load Record can load another record
> without releasing the locked record.
>
> I don't see anything in the trigger code that would keep the record locked
> and trigger issues discussed here seem to affect related tables, not the
> main table.
>
> Opening another record in the offending process does unlock the locked
> record, but users report that sometimes this does not work. They have to
> close the process.
>
> 4D v17.4 Client Server, Windows Server 2008 R2 server and client
>
> I'm thinking to try going to read-only in the list view to see if that
> works but I would love to hear some other ideas!
>
> Thanks,
> Alan Tilson
>
> On Fri, Aug 29, 2014 at 1:33 AM Justin Leavens  wrote:
>
> Ben Kershaw-3 wrote
>
> Create a method that calls READ ONLY(*), and set the method to execute on
> the server. Call this method from your init process method (I’m assuming
> you have one).
>
> If the problem is a trigger loading a record in another table and leaving
> it locked, this will start all tables in READ ONLY mode, so when the
> record is loaded it will be in READ ONLY state.
>
> If you still have records getting locked, at least you’ll know it has
> nothing to do with triggers or something running in the servers ‘twin’
> process.
>
>
> Thanks, Ben. Indeed I found the culprit was a related table being loaded in
> a trigger and not being unloaded. This resulted in the record being
> reported
> locked by the process (yes, I use Chuck's locked record component) yet zero
> records loaded on the client. And this of course worked differently in
> client server than it did in single user. Thanks for the tip!
>
>
>
>
> Later,
>
> Guy
>
>
> --
>
> Guy Algot, Solutions Specialist
>
> Edmonton, Alberta
>
> (780) 974-8538
>
>
> hardware, installation, training, support, programming, internet
>
> specializing in 4th Dimension
>
> =-= =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
>
> "Microsoft is a cross between the Borg and the Ferengi. Unfortunately,
>
> they use Borg to do their marketing and Ferengi to do their programming."
>
> -- Simon Slavin
>
>
>
>
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: Record locking woes

[Alan Tilson via 4D_Tech]

Hello Ben,
Interesting idea.
Tracing this on the server shows that there are zero records of this table
in the selection but one is locked.
And Unload Record doesn't change anything.
Any other ideas? And the Transaction Level is zero.
I do lock all tables at process startup on client and server, but then I
set the active table to Read-Write for most tables. Testing not doing this
and only unlocking the current table when opening a record didn't fix my
problem.
Thanks,
Alan


On Wed, Dec 9, 2020 at 3:55 PM Ben Kershaw via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> Alan Tilson wrote:
>
> >I'm having a record locking problem where I cannot understand how the
> >record is staying locked. There is no open transaction and no record stack
> >(Push Record).
>
> It could be that the process on the server (the one the trigger runs in)
> still has it loaded in a locked state. To test this, create a method with
> the “Execute on Server” attribute set, and call UNLOAD RECORD from that
> method. Call the method from the client when you close the edit window; the
> method will run in (what is known as) the “twin” process on the server and
> free the record.
>
> When a new process starts, all tables are in a read/write state, and any
> records loaded will be locked to other processes/users. I run a standard
> init method for new processes that sets all tables to read only, and also
> runs a method on the server that does the same thing for the “twin” process.
>
> Regards,
> Ben Kershaw
> **
> 4D Internet Users Group (4D iNUG)
> New Forum: https://discuss.4D.com
> 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)
New Forum: https://discuss.4D.com
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: Record locking woes

[Alan Tilson via 4D_Tech]

Hello John,
I am generally relying on the standard built-in warning when opening a
locked record that 4d does, but Locked By does return the locking process,
user, machine, and proc name.
And I am only seeing this so far on client-server.
Thanks,
Alan

On Wed, Dec 9, 2020 at 9:25 AM John DeSoi  wrote:

> Are you using LOCKED BY to determine which user/process has the record
> locked? In version 17 through 18R3 I have seen an intermittent bug where
> Locked returns true but LOCKED BY indicates there is no lock. Only one
> process uses the record, so it should not be locked. But I'm only seeing
> this in single user mode, not client/server.
>
> John DeSoi, Ph.D.
>
>
> > On Dec 8, 2020, at 3:32 PM, Alan Tilson via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> >
> > Well, going to read-only in the list view didn't change anything...
> > But this doesn't happen on all or even most tables...
> > Any ideas?
>
>
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: Record locking woes

[Alan Tilson via 4D_Tech]

Well, going to read-only in the list view didn't change anything...
But this doesn't happen on all or even most tables...
Any ideas?
Alan


On Tue, Dec 8, 2020 at 3:22 PM Alan Tilson  wrote:

> Hello everyone,
>
> I'm having a record locking problem where I cannot understand how the
> record is staying locked. There is no open transaction and no record stack
> (Push Record).
>
> I simply open a record from a list view and close it. The table is still
> read-write but the record is unloaded. Load Record can load another record
> without releasing the locked record.
>
> I don't see anything in the trigger code that would keep the record locked
> and trigger issues discussed here seem to affect related tables, not the
> main table.
>
> Opening another record in the offending process does unlock the locked
> record, but users report that sometimes this does not work. They have to
> close the process.
>
> 4D v17.4 Client Server, Windows Server 2008 R2 server and client
>
> I'm thinking to try going to read-only in the list view to see if that
> works but I would love to hear some other ideas!
>
> Thanks,
> Alan Tilson
>
> On Fri, Aug 29, 2014 at 1:33 AM Justin Leavens  wrote:
>
>> Ben Kershaw-3 wrote
>> > Create a method that calls READ ONLY(*), and set the method to execute
>> on
>> > the server. Call this method from your init process method (I’m assuming
>> > you have one).
>> >
>> > If the problem is a trigger loading a record in another table and
>> leaving
>> > it locked, this will start all tables in READ ONLY mode, so when the
>> > record is loaded it will be in READ ONLY state.
>> >
>> > If you still have records getting locked, at least you’ll know it has
>> > nothing to do with triggers or something running in the servers ‘twin’
>> > process.
>>
>> Thanks, Ben. Indeed I found the culprit was a related table being loaded
>> in
>> a trigger and not being unloaded. This resulted in the record being
>> reported
>> locked by the process (yes, I use Chuck's locked record component) yet
>> zero
>> records loaded on the client. And this of course worked differently in
>> client server than it did in single user. Thanks for the tip!
>>
>>
>>
>> --
>> View this message in context:
>> http://4d.1045681.n5.nabble.com/Record-locking-woes-tp5732498p5732638.html
>> Sent from the 4D Tech mailing list archive at Nabble.com.
>> **
>> See how easy it is to extend your 4D solutions to Web and mobile. New
>> opportunities await you with 4D v14!
>>
>> 4D Internet Users Group (4D iNUG)
>> FAQ:  http://lists.4d.com/faqnug.html
>> 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)
New Forum: https://discuss.4D.com
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: Record locking woes

[Alan Tilson via 4D_Tech]

Hello everyone,

I'm having a record locking problem where I cannot understand how the
record is staying locked. There is no open transaction and no record stack
(Push Record).

I simply open a record from a list view and close it. The table is still
read-write but the record is unloaded. Load Record can load another record
without releasing the locked record.

I don't see anything in the trigger code that would keep the record locked
and trigger issues discussed here seem to affect related tables, not the
main table.

Opening another record in the offending process does unlock the locked
record, but users report that sometimes this does not work. They have to
close the process.

4D v17.4 Client Server, Windows Server 2008 R2 server and client

I'm thinking to try going to read-only in the list view to see if that
works but I would love to hear some other ideas!

Thanks,
Alan Tilson

On Fri, Aug 29, 2014 at 1:33 AM Justin Leavens  wrote:

> Ben Kershaw-3 wrote
> > Create a method that calls READ ONLY(*), and set the method to execute on
> > the server. Call this method from your init process method (I’m assuming
> > you have one).
> >
> > If the problem is a trigger loading a record in another table and leaving
> > it locked, this will start all tables in READ ONLY mode, so when the
> > record is loaded it will be in READ ONLY state.
> >
> > If you still have records getting locked, at least you’ll know it has
> > nothing to do with triggers or something running in the servers ‘twin’
> > process.
>
> Thanks, Ben. Indeed I found the culprit was a related table being loaded in
> a trigger and not being unloaded. This resulted in the record being
> reported
> locked by the process (yes, I use Chuck's locked record component) yet zero
> records loaded on the client. And this of course worked differently in
> client server than it did in single user. Thanks for the tip!
>
>
>
> --
> View this message in context:
> http://4d.1045681.n5.nabble.com/Record-locking-woes-tp5732498p5732638.html
> Sent from the 4D Tech mailing list archive at Nabble.com.
> **
> See how easy it is to extend your 4D solutions to Web and mobile. New
> opportunities await you with 4D v14!
>
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> 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)
New Forum: https://discuss.4D.com
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 Lists Disappearing - Cause Unknown - v17.2

[Alan Tilson via 4D_Tech]

4D suggested that I repair the structure file so I did that after verifying
it where the log file showed a huge list of Lists that were there but were
not referenced by the list manager. The repair went very quickly and now
the structure file is "valid". There were over 300 Lists that were
recovered which I deleted since the actual lists were also there.
Hopefully, this is resolved. Should have thought of a repair myself!
Alan

On Mon, Nov 4, 2019 at 9:53 AM Alan Tilson  wrote:

> Hello Miyako,
> Thank you for responding to my email. However, I don't see how SAVE LIST
> can delete a List? The issue is not that the List Items disappear but that
> whole lists disappear. We go from having over 100 Lists that you can see in
> the List Editor to having maybe 15 which I believe are the ones that are
> regenerated automatically by our system.
> This has only been happening since we updated to v17.2.
> Thanks,
> Alan
>
> On Fri, Nov 1, 2019 at 6:14 PM Keisuke Miyako via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
>
>> CLEAR LIST works on a list in memory.
>>
>> should you not rather search for calls to SAVE LIST
>>
>> ?
>>
>> > 2019/11/02 2:19、Alan Tilson via 4D_Tech <4d_tech@lists.4d.com>のメール:
>> >
>> > At one point I commented out all the Clear List calls in the db and the
>> > issue occurred again!
>>
>>
>>
>>
>> **
>> 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: 4D Lists Disappearing - Cause Unknown - v17.2

[Alan Tilson via 4D_Tech]

Hello Miyako,
Thank you for responding to my email. However, I don't see how SAVE LIST
can delete a List? The issue is not that the List Items disappear but that
whole lists disappear. We go from having over 100 Lists that you can see in
the List Editor to having maybe 15 which I believe are the ones that are
regenerated automatically by our system.
This has only been happening since we updated to v17.2.
Thanks,
Alan

On Fri, Nov 1, 2019 at 6:14 PM Keisuke Miyako via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> CLEAR LIST works on a list in memory.
>
> should you not rather search for calls to SAVE LIST
>
> ?
>
> > 2019/11/02 2:19、Alan Tilson via 4D_Tech <4d_tech@lists.4d.com>のメール:
> >
> > At one point I commented out all the Clear List calls in the db and the
> > issue occurred again!
>
>
>
>
> **
> 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
**

4D Lists Disappearing - Cause Unknown - v17.2

[Alan Tilson via 4D_Tech]

Hello everyone,

We are having a very strange recurring problem where most of our static
lists disappear. I copied them several times from an older db, and then I
developed a way to backup and restore them, but what could be causing this?
At one point I commented out all the Clear List calls in the db and the
issue occurred again!

Then I went back to before this started, restored the db, rolled it forward
integrating the log files (which I suppose could have reintroduced the
problem), went back to the restored structure file, started things back up
and the lists where there...for about 36 hours. This morning they were gone
again.

4D v17.2 Client Server Windows

Any ideas would be appreciated!

Alan Tilson
**
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: Form Issue After Upgrade to v17.1 64-bit from v16R5 32-bit

[Alan Tilson via 4D_Tech]

Hello Jeff,
I have had some broken forms upgrading to v17 that I was not able to fix so
I created new versions of them and the problems went away.
So I would suggest rebuilding your problem form.
Good luck!
Alan

On Tue, May 28, 2019 at 1:05 PM jeff--- via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> After upgrading from v16R5 32-bit to v17.1 64-bit, one of our previously
> working forms is exhibiting a strange behavior.
>
> The On load and On unload form events are being fired repeatedly, causing
> the form objects to appear and then disappear over and over.
>
> Does anyone have a suggestion on how I can debug this?  I’ve tried using
> the SET DATABASE PARAMETER debug log, but it is so verbose I can’t make
> heads or tails out of the output.
>
> --
> Jeff Grann
> SuccessWare, Inc.
>
> **
> 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: Scroll position of display-type subform

[Alan Tilson via 4D_Tech]

The only time I see it change is when I click on a line to select it or
deselect it.
Alan

On Tue, May 14, 2019 at 5:59 PM Alan Tilson  wrote:

> No, it doesn't. Looks like you need to change the current record or
> current selection.
> Alan
>
>- *Records in list*: The current record or the current selection of
>rows is modified in a list form or subform
>
>
> On Tue, May 14, 2019 at 4:41 PM Chip Scheide <4d_o...@pghrepository.org>
> wrote:
>
>> Alan,
>> does the form event: On Selection Change
>> fire during scrolling?
>>
>> Chip
>> On Tue, 14 May 2019 16:04:00 -0400, Alan Tilson wrote:
>> > Chip,
>> > Thank you for your thoughts on this. However, in this case I'm
>> > recalculating the entire list and also I'm not using a listbox, it's a
>> > regular output form.
>> > On Display Detail doesn't fire with scrolling or after using apply to
>> > selection...so I can't create a user set
>> > even tried POST CLICK to create a user set but it happens after
>> everything
>> > runs which doesn't help
>> > anyway, thanks!
>> > Alan
>> >
>> > On Tue, May 14, 2019 at 2:46 PM Chip Scheide <4d_o...@pghrepository.org
>> >
>> > wrote:
>> >
>> >> I think you can save yourself some work.
>> >>
>> >> if you are working on a record (which is displayed) then...
>> >> try this:
>> >> do the recalc
>> >> (you could clear it first)
>> >> ADD the record to the listbox selection set
>> >> use your named selection
>> >>
>> >> I *think* 4D will scroll the display to show the highlighted record.
>> >>
>> >> if not
>> >> you should be able to get the location of that record
>> >> then scroll to that location - the record that was worked on is now
>> >> highlighted so the user can see the result
>> >>
>> >> Chip
>> >>
>> >> On Tue, 14 May 2019 14:22:36 -0400, Alan Tilson wrote:
>> >>> Hello Chip,
>> >>>
>> >>> The issue is how do I determine where the scroll is or which record is
>> >>> displayed first, so that highlight records can do it's thing.
>> >>>
>> >>> So if there is a list of records and I use the scroll wheel to scroll
>> >>> somewhere, then I run some code that recalculates a field 4d doesn't
>> >> update
>> >>> the display. So my workaround is to cut and use a named selection to
>> get
>> >>> the fields updated. But it goes back to the top of the list of records
>> >>> unless there is a record in userset when I can highlight records to
>> get
>> >>> where I want to be.
>> >>>
>> >>> I could clear the user set with the recalc and add the first record to
>> >> hit
>> >>> on display detail back to the userset...
>> >>>
>> >>> then highlight records to scroll down, clear user set, highlight
>> again to
>> >>> clear highlight, might work...
>> >>>
>> >>> I just don't get why 4d diminished the functionality of redraw window
>> to
>> >>> make all this necessary!
>> >>>
>> >>> Alan
>> >>>
>> >>> On Mon, May 13, 2019 at 10:00 AM Chip Scheide <
>> 4d_o...@pghrepository.org
>> >>>
>> >>> wrote:
>> >>>
>> >>>> you could set the highlight row,
>> >>>> then do whatever,
>> >>>> then set the scroll position back
>> >>>> and (if needed) un set the highlight row
>> >>>>
>> >>>> Chip
>> >>>> On Sat, 11 May 2019 10:06:22 -0400, Alan Tilson via 4D_Tech wrote:
>> >>>>> Hello again,
>> >>>>> What I meant if it wasn't clear is can I get this to work with an
>> >> Output
>> >>>>> Form showing a list of records?
>> >>>>> Thanks!
>> >>>>> Alan
>> >>>>>
>> >>>>> On Fri, May 10, 2019 at 5:31 PM Alan Tilson 
>> >>>> wrote:
>> >>>>>
>> >>>>>> If I have selected a record HIGHLIGHT RECORDS works fine, but
>> often I
>> >>>>>> haven't.
>> >>>>>> Alan
>> >>>>>>
>> >>>>>> On Fri, May 10, 2019 at 5:30 PM Alan Til

Re: Scroll position of display-type subform

[Alan Tilson via 4D_Tech]

No, it doesn't. Looks like you need to change the current record or current
selection.
Alan

   - *Records in list*: The current record or the current selection of rows
   is modified in a list form or subform


On Tue, May 14, 2019 at 4:41 PM Chip Scheide <4d_o...@pghrepository.org>
wrote:

> Alan,
> does the form event: On Selection Change
> fire during scrolling?
>
> Chip
> On Tue, 14 May 2019 16:04:00 -0400, Alan Tilson wrote:
> > Chip,
> > Thank you for your thoughts on this. However, in this case I'm
> > recalculating the entire list and also I'm not using a listbox, it's a
> > regular output form.
> > On Display Detail doesn't fire with scrolling or after using apply to
> > selection...so I can't create a user set
> > even tried POST CLICK to create a user set but it happens after
> everything
> > runs which doesn't help
> > anyway, thanks!
> > Alan
> >
> > On Tue, May 14, 2019 at 2:46 PM Chip Scheide <4d_o...@pghrepository.org>
> > wrote:
> >
> >> I think you can save yourself some work.
> >>
> >> if you are working on a record (which is displayed) then...
> >> try this:
> >> do the recalc
> >> (you could clear it first)
> >> ADD the record to the listbox selection set
> >> use your named selection
> >>
> >> I *think* 4D will scroll the display to show the highlighted record.
> >>
> >> if not
> >> you should be able to get the location of that record
> >> then scroll to that location - the record that was worked on is now
> >> highlighted so the user can see the result
> >>
> >> Chip
> >>
> >> On Tue, 14 May 2019 14:22:36 -0400, Alan Tilson wrote:
> >>> Hello Chip,
> >>>
> >>> The issue is how do I determine where the scroll is or which record is
> >>> displayed first, so that highlight records can do it's thing.
> >>>
> >>> So if there is a list of records and I use the scroll wheel to scroll
> >>> somewhere, then I run some code that recalculates a field 4d doesn't
> >> update
> >>> the display. So my workaround is to cut and use a named selection to
> get
> >>> the fields updated. But it goes back to the top of the list of records
> >>> unless there is a record in userset when I can highlight records to get
> >>> where I want to be.
> >>>
> >>> I could clear the user set with the recalc and add the first record to
> >> hit
> >>> on display detail back to the userset...
> >>>
> >>> then highlight records to scroll down, clear user set, highlight again
> to
> >>> clear highlight, might work...
> >>>
> >>> I just don't get why 4d diminished the functionality of redraw window
> to
> >>> make all this necessary!
> >>>
> >>> Alan
> >>>
> >>> On Mon, May 13, 2019 at 10:00 AM Chip Scheide <
> 4d_o...@pghrepository.org
> >>>
> >>> wrote:
> >>>
> >>>> you could set the highlight row,
> >>>> then do whatever,
> >>>> then set the scroll position back
> >>>> and (if needed) un set the highlight row
> >>>>
> >>>> Chip
> >>>> On Sat, 11 May 2019 10:06:22 -0400, Alan Tilson via 4D_Tech wrote:
> >>>>> Hello again,
> >>>>> What I meant if it wasn't clear is can I get this to work with an
> >> Output
> >>>>> Form showing a list of records?
> >>>>> Thanks!
> >>>>> Alan
> >>>>>
> >>>>> On Fri, May 10, 2019 at 5:31 PM Alan Tilson 
> >>>> wrote:
> >>>>>
> >>>>>> If I have selected a record HIGHLIGHT RECORDS works fine, but often
> I
> >>>>>> haven't.
> >>>>>> Alan
> >>>>>>
> >>>>>> On Fri, May 10, 2019 at 5:30 PM Alan Tilson 
> >>>> wrote:
> >>>>>>
> >>>>>>> Hello out there,
> >>>>>>> I cannot get OBJECT GET SCROLL POSITION to work with a list form.
> >>>>>>> OBJECT GET SCROLL POSITION([table]field;scrollPosition) leaves
> >>>>>>> scrollPosition at zero, wherever I have scrolled.
> >>>>>>> Thanks!
> >>>>>>> Alan
> >>>>>>>
> >>>>>>> On Tue, Jun 12, 2018 at 6:31 PM Richard Wright vi

Re: Scroll position of display-type subform

[Alan Tilson via 4D_Tech]

Chip,
Thank you for your thoughts on this. However, in this case I'm
recalculating the entire list and also I'm not using a listbox, it's a
regular output form.
On Display Detail doesn't fire with scrolling or after using apply to
selection...so I can't create a user set
even tried POST CLICK to create a user set but it happens after everything
runs which doesn't help
anyway, thanks!
Alan

On Tue, May 14, 2019 at 2:46 PM Chip Scheide <4d_o...@pghrepository.org>
wrote:

> I think you can save yourself some work.
>
> if you are working on a record (which is displayed) then...
> try this:
> do the recalc
> (you could clear it first)
> ADD the record to the listbox selection set
> use your named selection
>
> I *think* 4D will scroll the display to show the highlighted record.
>
> if not
> you should be able to get the location of that record
> then scroll to that location - the record that was worked on is now
> highlighted so the user can see the result
>
> Chip
>
> On Tue, 14 May 2019 14:22:36 -0400, Alan Tilson wrote:
> > Hello Chip,
> >
> > The issue is how do I determine where the scroll is or which record is
> > displayed first, so that highlight records can do it's thing.
> >
> > So if there is a list of records and I use the scroll wheel to scroll
> > somewhere, then I run some code that recalculates a field 4d doesn't
> update
> > the display. So my workaround is to cut and use a named selection to get
> > the fields updated. But it goes back to the top of the list of records
> > unless there is a record in userset when I can highlight records to get
> > where I want to be.
> >
> > I could clear the user set with the recalc and add the first record to
> hit
> > on display detail back to the userset...
> >
> > then highlight records to scroll down, clear user set, highlight again to
> > clear highlight, might work...
> >
> > I just don't get why 4d diminished the functionality of redraw window to
> > make all this necessary!
> >
> > Alan
> >
> > On Mon, May 13, 2019 at 10:00 AM Chip Scheide <4d_o...@pghrepository.org
> >
> > wrote:
> >
> >> you could set the highlight row,
> >> then do whatever,
> >> then set the scroll position back
> >> and (if needed) un set the highlight row
> >>
> >> Chip
> >> On Sat, 11 May 2019 10:06:22 -0400, Alan Tilson via 4D_Tech wrote:
> >>> Hello again,
> >>> What I meant if it wasn't clear is can I get this to work with an
> Output
> >>> Form showing a list of records?
> >>> Thanks!
> >>> Alan
> >>>
> >>> On Fri, May 10, 2019 at 5:31 PM Alan Tilson 
> >> wrote:
> >>>
> >>>> If I have selected a record HIGHLIGHT RECORDS works fine, but often I
> >>>> haven't.
> >>>> Alan
> >>>>
> >>>> On Fri, May 10, 2019 at 5:30 PM Alan Tilson 
> >> wrote:
> >>>>
> >>>>> Hello out there,
> >>>>> I cannot get OBJECT GET SCROLL POSITION to work with a list form.
> >>>>> OBJECT GET SCROLL POSITION([table]field;scrollPosition) leaves
> >>>>> scrollPosition at zero, wherever I have scrolled.
> >>>>> Thanks!
> >>>>> Alan
> >>>>>
> >>>>> On Tue, Jun 12, 2018 at 6:31 PM Richard Wright via 4D_Tech <
> >>>>> 4d_tech@lists.4d.com> wrote:
> >>>>>
> >>>>>> Thanks, Miyako, that works!
> >>>>>>
> >>>>>>
> >>>>>>> From: Keisuke Miyako 
> >>>>>>> To: 4D iNug Technical <4d_tech@lists.4d.com>
> >>>>>>> Subject: Re: Scroll position of display-type subform
> >>>>>>> Message-ID: <30f1fc18-68d9-4b1b-9413-aba4d7db5...@4d.com>
> >>>>>>> Content-Type: text/plain; charset="utf-8"
> >>>>>>>
> >>>>>>> haven't tried,
> >>>>>>> but I wonder if CONVERT COORDINATES would be smart enough to take
> >> into
> >>>>>> account the scrolled amount of a detail subform.
> >>>>>>>
> >>>>>>>
> >>>>>>
> >> http://doc.4d.com/4Dv16/4D/16.3/CONVERT-COORDINATES.301-3651760.en.html
> >>>>>>>
> >>>>>>>> 2018/06/12 7:37、Richard Wright via 4D_Tech <4d_tech@lists.4d.com>
> >>>>>> のメール：
> >>

Re: Scroll position of display-type subform

[Alan Tilson via 4D_Tech]

Hello again,
What I meant if it wasn't clear is can I get this to work with an Output
Form showing a list of records?
Thanks!
Alan

On Fri, May 10, 2019 at 5:31 PM Alan Tilson  wrote:

> If I have selected a record HIGHLIGHT RECORDS works fine, but often I
> haven't.
> Alan
>
> On Fri, May 10, 2019 at 5:30 PM Alan Tilson  wrote:
>
>> Hello out there,
>> I cannot get OBJECT GET SCROLL POSITION to work with a list form.
>> OBJECT GET SCROLL POSITION([table]field;scrollPosition) leaves
>> scrollPosition at zero, wherever I have scrolled.
>> Thanks!
>> Alan
>>
>> On Tue, Jun 12, 2018 at 6:31 PM Richard Wright via 4D_Tech <
>> 4d_tech@lists.4d.com> wrote:
>>
>>> Thanks, Miyako, that works!
>>>
>>>
>>> > From: Keisuke Miyako 
>>> > To: 4D iNug Technical <4d_tech@lists.4d.com>
>>> > Subject: Re: Scroll position of display-type subform
>>> > Message-ID: <30f1fc18-68d9-4b1b-9413-aba4d7db5...@4d.com>
>>> > Content-Type: text/plain; charset="utf-8"
>>> >
>>> > haven't tried,
>>> > but I wonder if CONVERT COORDINATES would be smart enough to take into
>>> account the scrolled amount of a detail subform.
>>> >
>>> >
>>> http://doc.4d.com/4Dv16/4D/16.3/CONVERT-COORDINATES.301-3651760.en.html
>>> >
>>> >> 2018/06/12 7:37、Richard Wright via 4D_Tech <4d_tech@lists.4d.com>
>>> のメール：
>>> >> I need to get the position of an object on a display-type subform in
>>> global coordinates and the subform may be scrolled.
>>> >
>>>
>>> **
>>> 4D Internet Users Group (4D iNUG)
>>> FAQ:  http://lists.4d.com/faqnug.html
>>> 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: Scroll position of display-type subform

[Alan Tilson via 4D_Tech]

Hello out there,
I cannot get OBJECT GET SCROLL POSITION to work with a list form.
OBJECT GET SCROLL POSITION([table]field;scrollPosition) leaves
scrollPosition at zero, wherever I have scrolled.
Thanks!
Alan

On Tue, Jun 12, 2018 at 6:31 PM Richard Wright via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Thanks, Miyako, that works!
>
>
> > From: Keisuke Miyako 
> > To: 4D iNug Technical <4d_tech@lists.4d.com>
> > Subject: Re: Scroll position of display-type subform
> > Message-ID: <30f1fc18-68d9-4b1b-9413-aba4d7db5...@4d.com>
> > Content-Type: text/plain; charset="utf-8"
> >
> > haven't tried,
> > but I wonder if CONVERT COORDINATES would be smart enough to take into
> account the scrolled amount of a detail subform.
> >
> > http://doc.4d.com/4Dv16/4D/16.3/CONVERT-COORDINATES.301-3651760.en.html
> >
> >> 2018/06/12 7:37、Richard Wright via 4D_Tech <4d_tech@lists.4d.com> のメール：
> >> I need to get the position of an object on a display-type subform in
> global coordinates and the subform may be scrolled.
> >
>
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> 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: Scroll position of display-type subform

[Alan Tilson via 4D_Tech]

If I have selected a record HIGHLIGHT RECORDS works fine, but often I
haven't.
Alan

On Fri, May 10, 2019 at 5:30 PM Alan Tilson  wrote:

> Hello out there,
> I cannot get OBJECT GET SCROLL POSITION to work with a list form.
> OBJECT GET SCROLL POSITION([table]field;scrollPosition) leaves
> scrollPosition at zero, wherever I have scrolled.
> Thanks!
> Alan
>
> On Tue, Jun 12, 2018 at 6:31 PM Richard Wright via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
>
>> Thanks, Miyako, that works!
>>
>>
>> > From: Keisuke Miyako 
>> > To: 4D iNug Technical <4d_tech@lists.4d.com>
>> > Subject: Re: Scroll position of display-type subform
>> > Message-ID: <30f1fc18-68d9-4b1b-9413-aba4d7db5...@4d.com>
>> > Content-Type: text/plain; charset="utf-8"
>> >
>> > haven't tried,
>> > but I wonder if CONVERT COORDINATES would be smart enough to take into
>> account the scrolled amount of a detail subform.
>> >
>> > http://doc.4d.com/4Dv16/4D/16.3/CONVERT-COORDINATES.301-3651760.en.html
>> >
>> >> 2018/06/12 7:37、Richard Wright via 4D_Tech <4d_tech@lists.4d.com>
>> のメール：
>> >> I need to get the position of an object on a display-type subform in
>> global coordinates and the subform may be scrolled.
>> >
>>
>> **
>> 4D Internet Users Group (4D iNUG)
>> FAQ:  http://lists.4d.com/faqnug.html
>> 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: Current time (*) incorrect today on v17?

[Alan Tilson via 4D_Tech]

Wow! And thanks for the info, no rush on 17.1, for this issue at least!
Alan

On Mon, Mar 18, 2019 at 9:50 AM Jeffrey Kain via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Our server disconnected all users and stopped responding at the time of
> the time change in v17.1.  Coincidence?
>
> > On Mar 18, 2019, at 9:42 AM, Alan Tilson via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> >
> > Just wanted to let everyone know that this is still happening in v17.0.
> Does
> > anyone know if it is fixed in v17.1?
>
> **
> 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: Current time (*) incorrect today on v17?

[Alan Tilson via 4D_Tech]

Hello out there,
Just wanted to let everyone know that this is still happening in v17.0. Does
anyone know if it is fixed in v17.1?
Thanks,
Alan



--
Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
**
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: Printing forms modified with Duplicate Object

[Alan Tilson via 4D_Tech]

Actually adding OBJECT GET COORDINATES can make it a relative coordinate
situation, an offset from the original position, easy!
Alan

On Thu, Mar 14, 2019 at 10:55 AM Alan Tilson  wrote:

> This process works and is not as clunky as I'd imagined. Would be great if
> there was an offset option in the print object command but I can now print
> what I want to print!
> Thanks,
> Alan
>
> On Wed, Mar 13, 2019 at 2:51 PM Alan Tilson  wrote:
>
>> Miyako,
>> It looks like you just step through all the objects and offset and print
>> them, so I'm trying that...
>> Alan
>>
>> On Wed, Mar 13, 2019 at 1:16 PM Alan Tilson  wrote:
>>
>>> Hello Miyako,
>>> Ok, I'm back to this project.
>>> Thanks for the info and I'm working with the Print Object command,
>>> trying to anyway.
>>> But it doesn't print subforms...
>>> And you said I need 17R to convert an existing form to JSON...we're
>>> running 17.0.
>>> Any additional advice would be appreciated.
>>> I'll try check out your component db to see how you did the labels.
>>> Thanks,
>>> Alan
>>>
>>> On Wed, Mar 6, 2019 at 7:41 PM Keisuke Miyako via 4D_Tech <
>>> 4d_tech@lists.4d.com> wrote:
>>>
 have you looked into the "Print object" command?

 you don't need to duplicate an object,
 you can print the same object as many times as you like,
 at any position (decimal, not integer positioning)

 with 17R you can define an object (JSON) representation of a form from
 scratch,
 or take an existing form, convert to JSON and add or subtract objects.

 > 2019/03/07 7:40、Alan Tilson のメール:
 > Any ideas would be appreciated!




 **
 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: Printing forms modified with Duplicate Object

[Alan Tilson via 4D_Tech]

This process works and is not as clunky as I'd imagined. Would be great if
there was an offset option in the print object command but I can now print
what I want to print!
Thanks,
Alan

On Wed, Mar 13, 2019 at 2:51 PM Alan Tilson  wrote:

> Miyako,
> It looks like you just step through all the objects and offset and print
> them, so I'm trying that...
> Alan
>
> On Wed, Mar 13, 2019 at 1:16 PM Alan Tilson  wrote:
>
>> Hello Miyako,
>> Ok, I'm back to this project.
>> Thanks for the info and I'm working with the Print Object command, trying
>> to anyway.
>> But it doesn't print subforms...
>> And you said I need 17R to convert an existing form to JSON...we're
>> running 17.0.
>> Any additional advice would be appreciated.
>> I'll try check out your component db to see how you did the labels.
>> Thanks,
>> Alan
>>
>> On Wed, Mar 6, 2019 at 7:41 PM Keisuke Miyako via 4D_Tech <
>> 4d_tech@lists.4d.com> wrote:
>>
>>> have you looked into the "Print object" command?
>>>
>>> you don't need to duplicate an object,
>>> you can print the same object as many times as you like,
>>> at any position (decimal, not integer positioning)
>>>
>>> with 17R you can define an object (JSON) representation of a form from
>>> scratch,
>>> or take an existing form, convert to JSON and add or subtract objects.
>>>
>>> > 2019/03/07 7:40、Alan Tilson のメール:
>>> > Any ideas would be appreciated!
>>>
>>>
>>>
>>>
>>> **
>>> 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: Printing forms modified with Duplicate Object

[Alan Tilson via 4D_Tech]

Miyako,
It looks like you just step through all the objects and offset and print
them, so I'm trying that...
Alan

On Wed, Mar 13, 2019 at 1:16 PM Alan Tilson  wrote:

> Hello Miyako,
> Ok, I'm back to this project.
> Thanks for the info and I'm working with the Print Object command, trying
> to anyway.
> But it doesn't print subforms...
> And you said I need 17R to convert an existing form to JSON...we're
> running 17.0.
> Any additional advice would be appreciated.
> I'll try check out your component db to see how you did the labels.
> Thanks,
> Alan
>
> On Wed, Mar 6, 2019 at 7:41 PM Keisuke Miyako via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
>
>> have you looked into the "Print object" command?
>>
>> you don't need to duplicate an object,
>> you can print the same object as many times as you like,
>> at any position (decimal, not integer positioning)
>>
>> with 17R you can define an object (JSON) representation of a form from
>> scratch,
>> or take an existing form, convert to JSON and add or subtract objects.
>>
>> > 2019/03/07 7:40、Alan Tilson のメール:
>> > Any ideas would be appreciated!
>>
>>
>>
>>
>> **
>> 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
**

Printing forms modified with Duplicate Object

[Alan Tilson via 4D_Tech]

Hello everyone,

Since page subforms cannot be printed I'm attempting to dynamically
generate a form by duplicating object, which is working, but this also
seems to be unprintable? The changes aren't saved to the form and using
DUPLICATE OBJECT in the form method during On Load generates an error
message indication this command cannot be used during printing.

I suppose I can create copies of my geom and vars outside the printable
area and move them as required during printing. Or just hide the ones I
don't need, but there are 2 different layouts that I want to use wherever
they're called for.

Any ideas would be appreciated!

Alan

On Tue, Mar 5, 2019 at 8:11 AM Alan Tilson  wrote:

> Miyako,
> Sorry for a bit of a rant at 4d...
> I suppose I'll try working with hundreds of form objects rather than 40 or
> 50 page forms...
> Should work but if there is something better using Load Form, etc, I'd
> love to hear more.
> Thanks again,
> Alan
>
> On Mon, Mar 4, 2019 at 9:06 PM Alan Tilson  wrote:
>
>> Hello Miyako,
>>
>> That is shocking and undocumented as far as I can tell. And expensive for
>> us since we have invested quite a few hours into this approach.
>>
>> So is it possible to print a form full of page forms using FORM Load and
>> Print Object? If yes, is there an example somewhere?
>>
>> Thanks a bunch for letting me know but it is very strange to have  such a
>> cool feature and not be able to print it!
>>
>> Cheers, Alan
>>
>> On Mon, Mar 4, 2019 at 4:28 PM Keisuke Miyako via 4D_Tech <
>> 4d_tech@lists.4d.com> wrote:
>>
>>> printing is not supported for page subforms.
>>> it's as simple as that.
>>>
>>> the only way to "print" a page subform is to FORM LOAD and Print object.
>>>
>>> I don't understand how 4D picks the table for the page subforms, but it
>>> uses the same output form as before!
>>>
>>>
>>>
>>> **
>>> 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: Printing Page Subforms in Columns/Rows in v17

[Alan Tilson via 4D_Tech]

Miyako,
Sorry for a bit of a rant at 4d...
I suppose I'll try working with hundreds of form objects rather than 40 or
50 page forms...
Should work but if there is something better using Load Form, etc, I'd love
to hear more.
Thanks again,
Alan

On Mon, Mar 4, 2019 at 9:06 PM Alan Tilson  wrote:

> Hello Miyako,
>
> That is shocking and undocumented as far as I can tell. And expensive for
> us since we have invested quite a few hours into this approach.
>
> So is it possible to print a form full of page forms using FORM Load and
> Print Object? If yes, is there an example somewhere?
>
> Thanks a bunch for letting me know but it is very strange to have  such a
> cool feature and not be able to print it!
>
> Cheers, Alan
>
> On Mon, Mar 4, 2019 at 4:28 PM Keisuke Miyako via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
>
>> printing is not supported for page subforms.
>> it's as simple as that.
>>
>> the only way to "print" a page subform is to FORM LOAD and Print object.
>>
>> I don't understand how 4D picks the table for the page subforms, but it
>> uses the same output form as before!
>>
>>
>>
>> **
>> 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: Printing Page Subforms in Columns/Rows in v17

[Alan Tilson via 4D_Tech]

Hello Miyako,

That is shocking and undocumented as far as I can tell. And expensive for
us since we have invested quite a few hours into this approach.

So is it possible to print a form full of page forms using FORM Load and
Print Object? If yes, is there an example somewhere?

Thanks a bunch for letting me know but it is very strange to have  such a
cool feature and not be able to print it!

Cheers, Alan

On Mon, Mar 4, 2019 at 4:28 PM Keisuke Miyako via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> printing is not supported for page subforms.
> it's as simple as that.
>
> the only way to "print" a page subform is to FORM LOAD and Print object.
>
> I don't understand how 4D picks the table for the page subforms, but it
> uses the same output form as before!
>
>
>
> **
> 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: Printing Page Subforms in Columns/Rows in v17

[Alan Tilson via 4D_Tech]

Using print form the page forms don't print at all...

On Mon, Mar 4, 2019 at 4:09 PM Alan Tilson  wrote:

> And I also tried moving the Page Subforms into the header, no change.
>
> On Mon, Mar 4, 2019 at 4:08 PM Alan Tilson  wrote:
>
>> I created a new project form for the Page Subform and copied the objects
>> into it. Same result.
>>
>> On Mon, Mar 4, 2019 at 3:51 PM Alan Tilson  wrote:
>>
>>> I did try changing the Page Subform form to a project form, but the
>>> results are the same.
>>>
>>> I don't understand how 4D picks the  table for the page subforms, but it
>>> uses the same output form as before!
>>>
>>> Ideas?
>>>
>>> Alan
>>>
>>> On Mon, Mar 4, 2019 at 3:25 PM Alan Tilson  wrote:
>>>
 Hello everyone,

 I'm creating a SPC inspection sheet for part dimensions and I'm using a
 page subform for each dimension. I loop through and set the subform object
 values and it looks ok on screen. However, when I print it the subform
 contest are replaced with the output form for the dimensions table.

 The page subforms are laid out in rows and columns, currently
 bassically 5x8.

 Is this not possible?

 Any ideas and/or suggestions would be appreciated!
 Alan Tilson

>>>
**
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: Printing Page Subforms in Columns/Rows in v17

[Alan Tilson via 4D_Tech]

And I also tried moving the Page Subforms into the header, no change.

On Mon, Mar 4, 2019 at 4:08 PM Alan Tilson  wrote:

> I created a new project form for the Page Subform and copied the objects
> into it. Same result.
>
> On Mon, Mar 4, 2019 at 3:51 PM Alan Tilson  wrote:
>
>> I did try changing the Page Subform form to a project form, but the
>> results are the same.
>>
>> I don't understand how 4D picks the  table for the page subforms, but it
>> uses the same output form as before!
>>
>> Ideas?
>>
>> Alan
>>
>> On Mon, Mar 4, 2019 at 3:25 PM Alan Tilson  wrote:
>>
>>> Hello everyone,
>>>
>>> I'm creating a SPC inspection sheet for part dimensions and I'm using a
>>> page subform for each dimension. I loop through and set the subform object
>>> values and it looks ok on screen. However, when I print it the subform
>>> contest are replaced with the output form for the dimensions table.
>>>
>>> The page subforms are laid out in rows and columns, currently bassically
>>> 5x8.
>>>
>>> Is this not possible?
>>>
>>> Any ideas and/or suggestions would be appreciated!
>>> Alan Tilson
>>>
>>
**
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: Printing Page Subforms in Columns/Rows in v17

[Alan Tilson via 4D_Tech]

I created a new project form for the Page Subform and copied the objects
into it. Same result.

On Mon, Mar 4, 2019 at 3:51 PM Alan Tilson  wrote:

> I did try changing the Page Subform form to a project form, but the
> results are the same.
>
> I don't understand how 4D picks the  table for the page subforms, but it
> uses the same output form as before!
>
> Ideas?
>
> Alan
>
> On Mon, Mar 4, 2019 at 3:25 PM Alan Tilson  wrote:
>
>> Hello everyone,
>>
>> I'm creating a SPC inspection sheet for part dimensions and I'm using a
>> page subform for each dimension. I loop through and set the subform object
>> values and it looks ok on screen. However, when I print it the subform
>> contest are replaced with the output form for the dimensions table.
>>
>> The page subforms are laid out in rows and columns, currently bassically
>> 5x8.
>>
>> Is this not possible?
>>
>> Any ideas and/or suggestions would be appreciated!
>> Alan Tilson
>>
>
**
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: Printing Page Subforms in Columns/Rows in v17

[Alan Tilson via 4D_Tech]

I did try changing the Page Subform form to a project form, but the results
are the same.

I don't understand how 4D picks the  table for the page subforms, but it
uses the same output form as before!

Ideas?

Alan

On Mon, Mar 4, 2019 at 3:25 PM Alan Tilson  wrote:

> Hello everyone,
>
> I'm creating a SPC inspection sheet for part dimensions and I'm using a
> page subform for each dimension. I loop through and set the subform object
> values and it looks ok on screen. However, when I print it the subform
> contest are replaced with the output form for the dimensions table.
>
> The page subforms are laid out in rows and columns, currently bassically
> 5x8.
>
> Is this not possible?
>
> Any ideas and/or suggestions would be appreciated!
> Alan Tilson
>
**
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
**

Printing Page Subforms in Columns/Rows in v17

[Alan Tilson via 4D_Tech]

Hello everyone,

I'm creating a SPC inspection sheet for part dimensions and I'm using a
page subform for each dimension. I loop through and set the subform object
values and it looks ok on screen. However, when I print it the subform
contest are replaced with the output form for the dimensions table.

The page subforms are laid out in rows and columns, currently bassically
5x8.

Is this not possible?

Any ideas and/or suggestions would be appreciated!
Alan Tilson
**
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: Epoch time in milliseconds

[Alan Tilson via 4D_Tech]

Hello Miyako,
It seems Timestamp always returns the GMT time zone, correct? So to get a
localized timestamp one would need to adjust the result?
Thanks!
Alan


On Tue, Feb 19, 2019 at 7:32 PM Keisuke Miyako via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> $P_timeString:=String(Current date(*);ISO date GMT;Current time(*))
>
> does this not invoke 2 calls to the server in C/S mode?
>
> would rather use Timestamp
> https://blog.4d.com/timestamp-is-now-available/
>
> or else an "execute on server" rapper.
>
> otherwise, I compared with a plugin call
> https://github.com/miyako/4d-plugin-common-crypto
>
> your code returns the exact value :)
>
>
>
> **
> 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: Query By Formula ([Table]) v17 Loss of Functionality

[Alan Tilson via 4D_Tech]

Hello Tim,

Thanks for clearing that up for me. Sometimes I'm pretty thick!

I really like the ability to copy actual fields from line 1 to line 2!

This option seems to be available in the standard query window, so there
seems to be no reason to have a separate menu item for query by formula?

Thanks,
Alan

On Thu, Jan 17, 2019 at 3:14 PM Tim Nevels via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> On Jan 17, 2019, at 1:57 PM, Alan Tilson wrote:
>
> > I'm not sure what you mean. The window had 2 or 3 boxes per line. The
> first
> > one seems only to allow fields to be entered. The 2nd for non-boolean
> > fields is the comparison box, equals, is different from, etc. The 3rd is
> a
> > value.
> >
> > This is the default query window created from this code: QUERY SELECTION
> BY
> > FORMULA([Table]). It appears to be exactly the same query window as QUERY
> > SELECTION([Table]).
> >
> > If you have something that works please let me know what steps to go
> > through to do it!
> >
> > Ps My understanding is that we cannot send images here. Is that still
> true?
>
> To access the query by formula option in the new query editor you need to
> option-click on the “+” button at the far right of a line. When you do
> that, you get a new query line that allows you to enter a formula. You can
> delete the first line in the query editor with the “-“ button.
>
> An interesting and hidden feature of the new query editor is that you can
> mix field lines and formula lines into a single query.
>
> And no, you cannot send images to this message board. You have to pass a
> link to something like this:
>
>
> https://www.dropbox.com/s/aerxv021dfzllxz/Screen%20Shot%202019-01-17%20at%202.09.45%20PM.PNG?dl=0
>
> 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
> **
**
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: Query By Formula ([Table]) v17 Loss of Functionality

[Alan Tilson via 4D_Tech]

Hello Christian,

I'm not sure what you mean. The window had 2 or 3 boxes per line. The first
one seems only to allow fields to be entered. The 2nd for non-boolean
fields is the comparison box, equals, is different from, etc. The 3rd is a
value.

This is the default query window created from this code: QUERY SELECTION BY
FORMULA([Table]). It appears to be exactly the same query window as QUERY
SELECTION([Table]).

If you have something that works please let me know what steps to go
through to do it!

Thanks,
Alan

Ps My understanding is that we cannot send images here. Is that still true?

On Wed, Jan 16, 2019 at 4:16 PM Christian Sakowski <
christian.sakow...@heubach-media.de> wrote:

> Hi,
>
> have you tried holding „Option“-Key and „+“ so you can enter a formula?
> --
>
> Grüße/Regards,
> [heubach-media] | Christian Sakowski
> christian.sakow...@heubach-media.de
> Tel: +49/(0)40/52 10 59-23
>
>
>
>
> > Am 16.01.2019 um 21:02 schrieb Alan Tilson via 4D_Tech <
> 4d_tech@lists.4d.com>:
> >
> > Hello out there,
> >
> > I just noticed in our v17 system which we upgraded from v13 that the
> system
> > (4D) generated query box for Query By Formula is basically the same box
> > that is for standard queries.
> >
> > I see no way to simply query for Field1 # Field2. I cannot even manually
> > type in Field2 (at least in the case of real fields).
> >
> > I'd love some help getting this to work or confirmation that it is no
> > longer possible.
> >
> > Thanks,
> > Alan
> > **
> > 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
> > **
>
>
> --
> heubach media
> Osterfeldstr. 12-14 | Haus 1 | Eingang Nord
> 22529 Hamburg
> tel: 040 / 52 10 59 - 10 | fax: -99
> mail: i...@heubach-media.de
> home: www.heubach-media.de
> Geschäftsführer|CEO: Matthias Heubach
>
> Mieten Sie Ihre Computer, iPads & Drucker für Ihre Events bei:
> http://www.milo-rental.com
>
> Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte
> Informationen.
> Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich
> erhalten haben,
> informieren Sie bitte sofort den Absender und vernichten Sie diese Mail.
> Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist
> nicht gestattet.
>
> This e-mail may contain confidential and/or privileged information.
> If you are not the intended recipient (or have received this e-mail in
> error)
> please notify the sender immediately and destroy this e-mail.
> Any unauthorized copying, disclosure or distribution of the
> material in this e-mail is strictly forbidden.
>
**
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
**

Query By Formula ([Table]) v17 Loss of Functionality

[Alan Tilson via 4D_Tech]

Hello out there,

I just noticed in our v17 system which we upgraded from v13 that the system
(4D) generated query box for Query By Formula is basically the same box
that is for standard queries.

I see no way to simply query for Field1 # Field2. I cannot even manually
type in Field2 (at least in the case of real fields).

I'd love some help getting this to work or confirmation that it is no
longer possible.

Thanks,
Alan
**
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: REDRAW WINDOW not working v17?

[Alan Tilson via 4D_Tech]

Hello Chip,
Thank you for your response and I must not have been clear in the other
thread. Don't know why the thread got split?
I did try some On Timer approaches but not yours exactly.
But for me HIGHLIGHT RECORDS works by itself as a replacement for REDRAW
WINDOW!
Very simple and apparently pretty efficient.
Cheers!
Alan

On Sun, Jan 6, 2019 at 10:07 AM Chip Scheide <4d_o...@pghrepository.org>
wrote:

> Alan,
> try:
> On Click or On Data change (for your boolean)
>   set timer(1)  or some other small value
>
> in the form method, On Timer
> call process(current process)
> or Call Process(-1)
>
> Chip
> > Hello again Bernd,
> >
> > I tried several other things but never got anything to work other than my
> > original code. I even tried setting a timer and running your code there,
> > but it still didn't redraw each line of the display.
> >
> > Thanks again,
> > Alan
> >
> > On Thu, Jan 3, 2019 at 5:37 AM Alan Tilson  wrote:
> >
> >> Hello Bernd,
> >>
> >> Your solution seemed much more elegant than mine, which was to cut and
> use
> >> a named selection, but for some reason it doesn't work for me. The
> boolean
> >> variable that I'm clicking on goes grey and nothing else changes. If I
> >> click another window and come back the boolean and the rows do update.
> >>
> >> Any ideas about what might be different?
> >>
> >> I tried HIDE WINDOW / SHOW WINDOW which caused a flicker but not a
> redraw
> >> as did HIDE PROCESS / SHOW PROCESS.
> >>
> >> I also tried Open Window / CLOSE WINDOW... didn't work.
> >>
> >> This does work with some side effects, especially if the user has
> scrolled
> >> down...
> >>
> >> CUT NAMED SELECTION(Current form table->;"tempNS")
> >> USE NAMED SELECTION("tempNS")
> >> HIGHLIGHT RECORDS
> >>
> >>
> >> Thanks from North Carolina,
> >> Alan Tilson
> >>
> >> On Thu, Jan 3, 2019 at 2:18 AM Bernd Fröhlich via 4D_Tech <
> >> 4d_tech@lists.4d.com> wrote:
> >>
> >>> Alan Tilson:
> >>>
>  Has anyone had issues with REDRAW WINDOW working differently or not
> >>> working
>  in v17? I have an output form with a boolean variable in the header
> that
>  affects the text color of the fields in each line of output as well as
>  determining which of a few optional fields are displayed. If I call
> >>> REDRAW
>  WINDOW after changing the boolean variable the records list does not
>  change. If I click on another window and come back to the original
> >>> window
>  everything updates.
> 
>  This worked fine in v13.
> 
>  Am I missing something?
> >>>
> >>> 4D V6 or V7 was the last version where REDRAW WINDOW was redrawing the
> >>> whole window, then 4D began to "optimize" the redrawing. Maybe it
> >>> is faster
> >>> now, but it definitely is no longer working as expected.
> >>> My workaround:
> >>>
> >>>   // Methode: RedrawWindow
> >>>   // Angelegt: BF 16.09.03
> >>>   // Objekt: Dienstroutine
> >>>   // Beschreibung: Umgehung für das seit 4D 2003 nicht mehr zuverlässig
> >>> funktionierende Redraw Window
> >>>   // 
> >>>
> >>> C_LONGINT($lLeft;$lTop;$lRight;$lBottom)
> >>>
> >>> GET WINDOW RECT($lLeft;$lTop;$lRight;$lBottom)
> >>> SET WINDOW RECT($lLeft;$lTop;$lRight-1;$lBottom)
> >>> SET WINDOW RECT($lLeft;$lTop;$lRight;$lBottom)
> >>>
> >>>
> >>> Gives a short flicker, but is the only way I know of to actually
> redraw a
> >>> window.
> >>> Maybe someone else has found another solution without the flicker?
> >>>
> >>> Greetings from Germany,
> >>> Bernd Fröhlich
> >>> **
> >>> 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
> > **
> 
> Hell is other people
>  Jean-Paul Sartre
>
**
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: REDRAW WINDOW not working v17?

[Alan Tilson via 4D_Tech]

Hello everyone,
Thank you for your responses and I must not have been clear.
But HIGHLIGHT RECORDS works for me by itself as a replacement for REDRAW
WINDOW!
Very simple and apparently pretty efficient.
Cheers from Asheville, NC, USA!
Alan

On Fri, Jan 4, 2019 at 12:16 PM Robert McKeever via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Have you tried GOTO PAGE(x) where x is the current page number?
>
> > On Jan 3, 2019, at 4:28 PM, Alan Tilson via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> >
> > Hello Keisuke,
> >
> > Windows, 32 & 64 bit, although most of my experience is 64 bit.
> >
> > Yes, I reference the variable in on display detail.
> >
> > For me REDRAW WINDOW was for special cases when you wanted everything
> > reloaded/recalculated. To make is so that it doesn't fire on display
> detail
> > seems pretty strange. What does it do?
> >
> > And YES! HIGHLIGHT RECORDS does work by itself!
> >
> > Much appreciated,
> > Alan Tilson
> >
> >
> >
> > On Thu, Jan 3, 2019 at 7:11 PM Keisuke Miyako via 4D_Tech <
> > 4d_tech@lists.4d.com> wrote:
> >
> >> a few pieces of information would be appreciated:
> >>
> >> - is this Mac or Windows?
> >> - is this 64-bit only?
> >>
> >> I guess you reference the variable in your On Display Detail,
> >> but that event doesn't fire unless the detail area needs to be redrawn
> >> (activated, deactivated, selection changed).
> >>
> >> that was always the premise,
> >> although it sounds like v13 was not optimised enough to not reevaluate
> the
> >> lines after every click event (On Display Detail is very expensive).
> >>
> >> regarding your workaround code,
> >> would not a simple HIGHLIGHT RECORDS(Current form table->;"UserSet";*)
> >> suffice without the named selection stuff?
> >>
> >> 2019/01/03 0:30、Alan Tilson via 4D_Tech <4d_tech@lists.4d.com >> 4d_tech@lists.4d.com>>のメール:
> >> Am I missing something?
> >>
> >>
> >>
> >> **
> >> 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
> > **
>
> _
> Bob McKeever  http://www.mswl.com <
> http://www.mswl.com/>
> McKeever's Software Wizardry
> Port Coquitlam, B.C.
> bobmckee...@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
> **
**
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: REDRAW WINDOW not working v17?

[Alan Tilson via 4D_Tech]

Hello Keisuke,

Windows, 32 & 64 bit, although most of my experience is 64 bit.

Yes, I reference the variable in on display detail.

For me REDRAW WINDOW was for special cases when you wanted everything
reloaded/recalculated. To make is so that it doesn't fire on display detail
seems pretty strange. What does it do?

And YES! HIGHLIGHT RECORDS does work by itself!

Much appreciated,
Alan Tilson



On Thu, Jan 3, 2019 at 7:11 PM Keisuke Miyako via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> a few pieces of information would be appreciated:
>
> - is this Mac or Windows?
> - is this 64-bit only?
>
> I guess you reference the variable in your On Display Detail,
> but that event doesn't fire unless the detail area needs to be redrawn
> (activated, deactivated, selection changed).
>
> that was always the premise,
> although it sounds like v13 was not optimised enough to not reevaluate the
> lines after every click event (On Display Detail is very expensive).
>
> regarding your workaround code,
> would not a simple HIGHLIGHT RECORDS(Current form table->;"UserSet";*)
> suffice without the named selection stuff?
>
> 2019/01/03 0:30、Alan Tilson via 4D_Tech <4d_tech@lists.4d.com 4d_tech@lists.4d.com>>のメール:
> Am I missing something?
>
>
>
> **
> 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: REDRAW WINDOW not working v17?

[Alan Tilson via 4D_Tech]

Hello again Bernd,

I tried several other things but never got anything to work other than my
original code. I even tried setting a timer and running your code there,
but it still didn't redraw each line of the display.

Thanks again,
Alan

On Thu, Jan 3, 2019 at 5:37 AM Alan Tilson  wrote:

> Hello Bernd,
>
> Your solution seemed much more elegant than mine, which was to cut and use
> a named selection, but for some reason it doesn't work for me. The boolean
> variable that I'm clicking on goes grey and nothing else changes. If I
> click another window and come back the boolean and the rows do update.
>
> Any ideas about what might be different?
>
> I tried HIDE WINDOW / SHOW WINDOW which caused a flicker but not a redraw
> as did HIDE PROCESS / SHOW PROCESS.
>
> I also tried Open Window / CLOSE WINDOW... didn't work.
>
> This does work with some side effects, especially if the user has scrolled
> down...
>
> CUT NAMED SELECTION(Current form table->;"tempNS")
> USE NAMED SELECTION("tempNS")
> HIGHLIGHT RECORDS
>
>
> Thanks from North Carolina,
> Alan Tilson
>
> On Thu, Jan 3, 2019 at 2:18 AM Bernd Fröhlich via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
>
>> Alan Tilson:
>>
>> > Has anyone had issues with REDRAW WINDOW working differently or not
>> working
>> > in v17? I have an output form with a boolean variable in the header that
>> > affects the text color of the fields in each line of output as well as
>> > determining which of a few optional fields are displayed. If I call
>> REDRAW
>> > WINDOW after changing the boolean variable the records list does not
>> > change. If I click on another window and come back to the original
>> window
>> > everything updates.
>> >
>> > This worked fine in v13.
>> >
>> > Am I missing something?
>>
>> 4D V6 or V7 was the last version where REDRAW WINDOW was redrawing the
>> whole window, then 4D began to "optimize" the redrawing. Maybe it is faster
>> now, but it definitely is no longer working as expected.
>> My workaround:
>>
>>   // Methode: RedrawWindow
>>   // Angelegt: BF 16.09.03
>>   // Objekt: Dienstroutine
>>   // Beschreibung: Umgehung für das seit 4D 2003 nicht mehr zuverlässig
>> funktionierende Redraw Window
>>   // 
>>
>> C_LONGINT($lLeft;$lTop;$lRight;$lBottom)
>>
>> GET WINDOW RECT($lLeft;$lTop;$lRight;$lBottom)
>> SET WINDOW RECT($lLeft;$lTop;$lRight-1;$lBottom)
>> SET WINDOW RECT($lLeft;$lTop;$lRight;$lBottom)
>>
>>
>> Gives a short flicker, but is the only way I know of to actually redraw a
>> window.
>> Maybe someone else has found another solution without the flicker?
>>
>> Greetings from Germany,
>> Bernd Fröhlich
>> **
>> 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: REDRAW WINDOW not working v17?

[Alan Tilson via 4D_Tech]

Hello Bernd,

Your solution seemed much more elegant than mine, which was to cut and use
a named selection, but for some reason it doesn't work for me. The boolean
variable that I'm clicking on goes grey and nothing else changes. If I
click another window and come back the boolean and the rows do update.

Any ideas about what might be different?

I tried HIDE WINDOW / SHOW WINDOW which caused a flicker but not a redraw
as did HIDE PROCESS / SHOW PROCESS.

I also tried Open Window / CLOSE WINDOW... didn't work.

This does work with some side effects, especially if the user has scrolled
down...

CUT NAMED SELECTION(Current form table->;"tempNS")
USE NAMED SELECTION("tempNS")
HIGHLIGHT RECORDS


Thanks from North Carolina,
Alan Tilson

On Thu, Jan 3, 2019 at 2:18 AM Bernd Fröhlich via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Alan Tilson:
>
> > Has anyone had issues with REDRAW WINDOW working differently or not
> working
> > in v17? I have an output form with a boolean variable in the header that
> > affects the text color of the fields in each line of output as well as
> > determining which of a few optional fields are displayed. If I call
> REDRAW
> > WINDOW after changing the boolean variable the records list does not
> > change. If I click on another window and come back to the original window
> > everything updates.
> >
> > This worked fine in v13.
> >
> > Am I missing something?
>
> 4D V6 or V7 was the last version where REDRAW WINDOW was redrawing the
> whole window, then 4D began to "optimize" the redrawing. Maybe it is faster
> now, but it definitely is no longer working as expected.
> My workaround:
>
>   // Methode: RedrawWindow
>   // Angelegt: BF 16.09.03
>   // Objekt: Dienstroutine
>   // Beschreibung: Umgehung für das seit 4D 2003 nicht mehr zuverlässig
> funktionierende Redraw Window
>   // 
>
> C_LONGINT($lLeft;$lTop;$lRight;$lBottom)
>
> GET WINDOW RECT($lLeft;$lTop;$lRight;$lBottom)
> SET WINDOW RECT($lLeft;$lTop;$lRight-1;$lBottom)
> SET WINDOW RECT($lLeft;$lTop;$lRight;$lBottom)
>
>
> Gives a short flicker, but is the only way I know of to actually redraw a
> window.
> Maybe someone else has found another solution without the flicker?
>
> Greetings from Germany,
> Bernd Fröhlich
> **
> 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: Converting pictures

[Alan Tilson via 4D_Tech]

Seems fixed but I'll need to rerun the check at some point to confirm.
Thanks again everyone!
Alan

On Wed, Jan 2, 2019 at 11:43 AM Alan Tilson  wrote:

> Hello again,
>
> Process works, although I do have to manually rename and reposition the
> images pasted into v17.
>
> Shouldn't take too long...
>
> Alan
>
> On Wed, Jan 2, 2019 at 11:20 AM Alan Tilson  wrote:
>
>> Hello John, Ernie & Chuck,
>>
>> Thank you for your responses. I'm just getting back to this...
>>
>> I have 38 instances I believe of static PICT images in our v17 db. So
>> while I'd love to automate this it is not so big really that I can't just
>> work through it.
>>
>> John - I tried your code but it doesn't work. It runs but when I paste
>> the image back onto the form it is the same .pict image. I suspect that I
>> need to run this in v13 and then paste the results into v17. I'll try that.
>> But I seem to remember that the transparency code needs to run in v17. So
>> maybe I need 2 steps...
>>
>> Ernie - I like the idea of converting my static pictures into library
>> pictures, but I suspect I'll have the same v13/v17 issues. I do have some
>> v13 code to convert the library pictures and some v17 code to set the
>> transparency.
>>
>> Chuck - do you think this would be a v17 component that would simplify
>> this process? I do plan to try the v13/v17 idea first I suppose.
>>
>> Thanks again,
>> Alan
>>
>>
>>
>> On Sun, Dec 30, 2018 at 10:21 PM Chuck Miller via 4D_Tech <
>> 4d_tech@lists.4d.com> wrote:
>>
>>> Yes there is. JPR gave a demo of just the ticket , a component that did
>>> this.
>>>
>>> regards
>>>
>>> chuck
>>>
>>> 
>>>  Chuck Miller Voice: (617) 739-0306
>>>  Informed Solutions, Inc. Fax: (617) 232-1064
>>>  mailto:cjmillerinformed-solutions.com
>>>  Brookline, MA 02446 USA Registered 4D Developer
>>>Providers of 4D and Sybase connectivity
>>>   http://www.informed-solutions.com
>>>
>>> 
>>> This message and any attached documents contain information which may be
>>> confidential, subject to privilege or exempt from disclosure under
>>> applicable law.  These materials are intended only for the use of the
>>> intended recipient. If you are not the intended recipient of this
>>> transmission, you are hereby notified that any distribution, disclosure,
>>> printing, copying, storage, modification or the taking of any action in
>>> reliance upon this transmission is strictly prohibited.  Delivery of this
>>> message to any person other than the intended recipient shall not
>>> compromise or waive such confidentiality, privilege or exemption from
>>> disclosure as to this communication.
>>>
>>> > On Dec 28, 2018, at 2:32 PM, Alan Tilson via 4D_Tech <
>>> 4d_tech@lists.4d.com> wrote:
>>> >
>>> > Hello everyone,
>>> >
>>> > Is there code that can convert static PICT images to PNG, images not
>>> in a
>>> > library?
>>> >
>>> > Thanks,
>>> > Alan
>>>
>>> **
>>> 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: Converting pictures

[Alan Tilson via 4D_Tech]

Hello again,

Process works, although I do have to manually rename and reposition the
images pasted into v17.

Shouldn't take too long...

Alan

On Wed, Jan 2, 2019 at 11:20 AM Alan Tilson  wrote:

> Hello John, Ernie & Chuck,
>
> Thank you for your responses. I'm just getting back to this...
>
> I have 38 instances I believe of static PICT images in our v17 db. So
> while I'd love to automate this it is not so big really that I can't just
> work through it.
>
> John - I tried your code but it doesn't work. It runs but when I paste the
> image back onto the form it is the same .pict image. I suspect that I need
> to run this in v13 and then paste the results into v17. I'll try that. But
> I seem to remember that the transparency code needs to run in v17. So maybe
> I need 2 steps...
>
> Ernie - I like the idea of converting my static pictures into library
> pictures, but I suspect I'll have the same v13/v17 issues. I do have some
> v13 code to convert the library pictures and some v17 code to set the
> transparency.
>
> Chuck - do you think this would be a v17 component that would simplify
> this process? I do plan to try the v13/v17 idea first I suppose.
>
> Thanks again,
> Alan
>
>
>
> On Sun, Dec 30, 2018 at 10:21 PM Chuck Miller via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
>
>> Yes there is. JPR gave a demo of just the ticket , a component that did
>> this.
>>
>> regards
>>
>> chuck
>>
>> 
>>  Chuck Miller Voice: (617) 739-0306
>>  Informed Solutions, Inc. Fax: (617) 232-1064
>>  mailto:cjmillerinformed-solutions.com
>>  Brookline, MA 02446 USA Registered 4D Developer
>>Providers of 4D and Sybase connectivity
>>   http://www.informed-solutions.com
>>
>> 
>> This message and any attached documents contain information which may be
>> confidential, subject to privilege or exempt from disclosure under
>> applicable law.  These materials are intended only for the use of the
>> intended recipient. If you are not the intended recipient of this
>> transmission, you are hereby notified that any distribution, disclosure,
>> printing, copying, storage, modification or the taking of any action in
>> reliance upon this transmission is strictly prohibited.  Delivery of this
>> message to any person other than the intended recipient shall not
>> compromise or waive such confidentiality, privilege or exemption from
>> disclosure as to this communication.
>>
>> > On Dec 28, 2018, at 2:32 PM, Alan Tilson via 4D_Tech <
>> 4d_tech@lists.4d.com> wrote:
>> >
>> > Hello everyone,
>> >
>> > Is there code that can convert static PICT images to PNG, images not in
>> a
>> > library?
>> >
>> > Thanks,
>> > Alan
>>
>> **
>> 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: Converting pictures

[Alan Tilson via 4D_Tech]

Hello John, Ernie & Chuck,

Thank you for your responses. I'm just getting back to this...

I have 38 instances I believe of static PICT images in our v17 db. So while
I'd love to automate this it is not so big really that I can't just work
through it.

John - I tried your code but it doesn't work. It runs but when I paste the
image back onto the form it is the same .pict image. I suspect that I need
to run this in v13 and then paste the results into v17. I'll try that. But
I seem to remember that the transparency code needs to run in v17. So maybe
I need 2 steps...

Ernie - I like the idea of converting my static pictures into library
pictures, but I suspect I'll have the same v13/v17 issues. I do have some
v13 code to convert the library pictures and some v17 code to set the
transparency.

Chuck - do you think this would be a v17 component that would simplify this
process? I do plan to try the v13/v17 idea first I suppose.

Thanks again,
Alan



On Sun, Dec 30, 2018 at 10:21 PM Chuck Miller via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Yes there is. JPR gave a demo of just the ticket , a component that did
> this.
>
> regards
>
> chuck
>
> 
>  Chuck Miller Voice: (617) 739-0306
>  Informed Solutions, Inc. Fax: (617) 232-1064
>  mailto:cjmillerinformed-solutions.com
>  Brookline, MA 02446 USA Registered 4D Developer
>Providers of 4D and Sybase connectivity
>   http://www.informed-solutions.com
>
> 
> This message and any attached documents contain information which may be
> confidential, subject to privilege or exempt from disclosure under
> applicable law.  These materials are intended only for the use of the
> intended recipient. If you are not the intended recipient of this
> transmission, you are hereby notified that any distribution, disclosure,
> printing, copying, storage, modification or the taking of any action in
> reliance upon this transmission is strictly prohibited.  Delivery of this
> message to any person other than the intended recipient shall not
> compromise or waive such confidentiality, privilege or exemption from
> disclosure as to this communication.
>
> > On Dec 28, 2018, at 2:32 PM, Alan Tilson via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> >
> > Hello everyone,
> >
> > Is there code that can convert static PICT images to PNG, images not in a
> > library?
> >
> > Thanks,
> > Alan
>
> **
> 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
**

REDRAW WINDOW not working v17?

[Alan Tilson via 4D_Tech]

Hello,

Has anyone had issues with REDRAW WINDOW working differently or not working
in v17? I have an output form with a boolean variable in the header that
affects the text color of the fields in each line of output as well as
determining which of a few optional fields are displayed. If I call REDRAW
WINDOW after changing the boolean variable the records list does not
change. If I click on another window and come back to the original window
everything updates.

This worked fine in v13.

Am I missing something?

Thanks,
Alan
**
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
**

detecting APPLY TO SELECTION

[Alan Tilson via 4D_Tech]

Happy New Year's Eve!

Is there a way to tell if code is running within APPLY TO SELECTION? I have
code that can run one record at a time and can also be applied a selection
of records. And in some cases when run one at a time there is an Alert or
Confirmation or Request for input, all of which cause an error if executed
within ATS.

Is there a way to avoid this?

I use ATS 550 times in our system, so wrapping it would be a big job...

Thanks,
Alan
**
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: Converting pictures

[Alan Tilson via 4D_Tech]

Hello everyone,

Is there code that can convert static PICT images to PNG, images not in a
library?

Thanks,
Alan

On Tue, Oct 23, 2018 at 4:17 PM Timothy Penner via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Hi Setar,
>
> The v13 code to convert PICT -> PNG is here:
> http://kb.4d.com/assetid=76775
> ^ There is no transparency option in that code.
>
> While the following code was published for v16:
> http://kb.4d.com/assetid=77963
> ^ This one uses the transparency option.
>
> Regarding 4D Pack, it should exist in v16 but it is no longer available in
> newer versions:
> http://livedoc.4d.com/4Dv17/help/Title/en/page3607.html#3188011
> {
> Over the course of different versions, the most useful 4D Pack routines
> were progressively integrated into 4D itself, while those that became
> obsolete were removed. Starting with 4D v16 R2, the 4D Pack plug-in is no
> longer provided in versions of 4D. Refer to the table below to find out the
> replacement solutions available (if any) for 4D Pack routines.
> }
>
> -Tim
>
>
>
> **
> 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: Pasting Spreadsheet Data into 4D Records

[Alan Tilson via 4D_Tech]

Hello Pat, Koen & Ken,
Pat & Ken- Thank you for your response but I'm trying to eliminate
(especially manually) creating the text file. I had been thinking of
automating the creation of the text files and using import, but...
Koen- I hadn't thought of manually (via code) parsing the text data rather
than trying to use import commands. That seems worthwhile and not that
difficult!
I probably should have said that I potentially have hundreds of copy/paste
operations to do!
Your responses are much appreciated,
Alan

On Mon, Dec 24, 2018 at 11:37 AM Kenneth Geiger via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Hi Alan,
>
> Just save your spreadsheet (Excel) as file-type Tab-Delmited-Text (.txt).
> Then in 4D, navigate to File…Import…, change the file type to .txt, select
> your saved file, select the table into which to import the data, and then
> match the data (columns) to the proper field and import it.
>
> Regards,
>
> Ken Geiger
>
> > On Dec 23, 2018, at 5:47 PM, Alan Tilson via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> >
> > Greetings everyone,
> >
> > Is there a way to copy from a spreadsheet like data source and to paste
> > directly into 4d while parsing it into table(s) and fields? I'm using v17
> > if that matters.
> >
> > I thought about saving the data into a text file and then importing the
> > text file, but there seem to be unnecessary steps in there!
> >
> > Thanks, did some searches but didn't find anything,
> > Alan
> > **
> > 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
> **
**
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
**

Pasting Spreadsheet Data into 4D Records

[Alan Tilson via 4D_Tech]

Greetings everyone,

Is there a way to copy from a spreadsheet like data source and to paste
directly into 4d while parsing it into table(s) and fields? I'm using v17
if that matters.

I thought about saving the data into a text file and then importing the
text file, but there seem to be unnecessary steps in there!

Thanks, did some searches but didn't find anything,
Alan
**
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 v16r6 Server not available and other questions

[Alan Tilson via 4D_Tech]

Hello again,

I got the same *ordinal 746 *error opening client v16.3 on the server
machine, fyi.

And the 16.3 server does not show as available from another machine, either.

Thanks,
Alan



On Sun, Jul 15, 2018 at 3:56 PM Alan Tilson  wrote:

> ​Hello everyone,
>
> I am working to upgrade our 4D system from v13.6 to v16r6 and I've gotten
> to the point where it is up and running on 4D server.
>
> First, on the server machine, I tried ​to connect with the 64 bit client
> and I got the message *Server is using legacy network layer, which is not
> compatible with 64-bit clients. *In the 4d docs for v16 it says *Any 4D
> client application, 32-bit or 64-bit, OS X or Windows, can connect to a
> 64-bit version of 4D Server.*
>
> So I installed the 32 bit client on the server machine and I was able to
> connect to the server. I did get an error *The ordinal 746 could not be
> located in the dynamic link library ASINTPPC.dll. *but the client did
> connect and things seem to work normally. Anyone have an idea about how to
> fix this error?
>
> Using the 32 bit client from another machine I don't see the v16 server
> but I do see the v13 server. How can I make the v16 server visible on the
> network?
>
> I'm thinking to try v16.3 but I have no idea how that affects things.
>
> Any tips would really be appreciated!
>
> Alan
>
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
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 v16r6 Server not available and other questions

[Alan Tilson via 4D_Tech]

​Hello everyone,

I am working to upgrade our 4D system from v13.6 to v16r6 and I've gotten
to the point where it is up and running on 4D server.

First, on the server machine, I tried ​to connect with the 64 bit client
and I got the message *Server is using legacy network layer, which is not
compatible with 64-bit clients. *In the 4d docs for v16 it says *Any 4D
client application, 32-bit or 64-bit, OS X or Windows, can connect to a
64-bit version of 4D Server.*

So I installed the 32 bit client on the server machine and I was able to
connect to the server. I did get an error *The ordinal 746 could not be
located in the dynamic link library ASINTPPC.dll. *but the client did
connect and things seem to work normally. Anyone have an idea about how to
fix this error?

Using the 32 bit client from another machine I don't see the v16 server but
I do see the v13 server. How can I make the v16 server visible on the
network?

I'm thinking to try v16.3 but I have no idea how that affects things.

Any tips would really be appreciated!

Alan
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
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: Why won't Help Tip editor accept Carriage Return?

[Alan Tilson via 4D_Tech]

 also for the record, this problem exists in v13.6 in windows as well as
macOS.
the copy & paste solution helps.
closing and reopening the help tips window also generally clears the issue
for a while.
Alan


On Tue, Jun 12, 2018 at 7:48 AM Pat Bensky via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> We manage help tips this way:
> - For each object, select the On Mouse Enter form event
> - We have a Help Tip named "HelpText" which simply contains a variable,
> tHelpText. Select that Help Tip for each object.
> - On the object, populate the tHelpText variable in the On Mouse Enter form
> event.
>
> With this scheme, you can customise your help tips in lots of creative ways
> - e.g. depending on whether the user is on Mac or Windows, what day of the
> week it is, what level of access the user has, or whatever. I also find it
> much easier to manage the tips as you don't have to deal with a long list
> of Help Tips.
>
> Pat
>
> Pat
>
>
> On Tue, 12 Jun 2018 at 06:32, Keisuke Miyako via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
>
> > for the record, problem does not exist for v14 or later.
> >
> > this is basically a compatibility issue between macOS 10.8/9 and 13.6
> > (evidently a regression from 13.5, really sorry about that...),
> > which was released in the first half of 2015.
> >
> > > 2018/06/12 13:22、Dan Ivy via 4D_Tech <4d_tech@lists.4d.com> のメール：
> > >
> > > I agree with Doug about where this is coming from. Also as a workaround
> > I had
> > > success using a text editor to create the help text with carriage
> returns
> > > and then paste it into the 4D help editor. After that 4D seems to allow
> > > returns to be added or deleted from the text displayed in the help
> > editor.
> >
> >
> >
> > **
> > 4D Internet Users Group (4D iNUG)
> > FAQ:  http://lists.4d.com/faqnug.html
> > Archive:  http://lists.4d.com/archives.html
> > Options: https://lists.4d.com/mailman/options/4d_tech
> > Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> > **
>
>
>
> --
> *
> CatBase - Top Dog in Data Publishing
> tel: +44 (0) 207 118 7889
> w: http://www.catbase.com
> skype: pat.bensky
> *
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> 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)
FAQ:  http://lists.4d.com/faqnug.html
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: What Happened to 4D v16 r6?

[Alan Tilson via 4D_Tech]

Hello Timothy,
Thanks for the info so I can relax and keep using r6!
Alan

sent from my Note 4

On Thu, Jul 5, 2018, 6:56 PM Timothy Penner  wrote:

> Hi Alan,
>
> Looks like a snafu with the web site (perhaps the content got rolled
> back?)
>
> We are checking with the team on the website content.
>
> In the meantime, here is a direct link for v16R6:
> http://download.4d.com/Products/Current/4D_v16R6/Installers/
>
> -Tim
>
>
>
>
> Timothy Penner
> Senior Technical Services Engineer
>
> 4D Inc
> 95 S. Market Street, Suite #240
> San Jose,CA 95113
> United States
>
> Telephone: +1-408-557-4600
> Fax:   +1-408-271-5080
> Email: tpen...@4d.com
> Web:   www.4D.com
>
>
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

What Happened to 4D v16 r6?

[Alan Tilson via 4D_Tech]

Hello,

I have been working with v16 r6 for a while and I was going to download it
again on another machine and only r4 is available.

Can someone shed some light on this?

Thanks,
Alan
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
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: Why won't Help Tip editor accept Carriage Return?

[Alan Tilson via 4D_Tech]

Hello Jim & everyone,

I still have this issue with 4D v13.6 in sometimes in Help Tips and
sometimes in text fields.

Has it been resolved somehow?

Thanks!
Alan

On Sun, Nov 6, 2016 at 7:13 PM Jim Labos - infobase 
wrote:

> Sorry for double post. I meant to post to 4D Tech)
>
> The first edit works fine but when I move to another Help Tip the cursor
> will not respond to Carriage Return. I get a system beep instead.
>
> Any clues?
>
> OSX 10.8.5  4D Developer v13.6
>
> Thanks
>
> Jim Labos - infobase
>
>
>
> -
> Jim Labos - infobase
> --
> View this message in context:
> http://4d.1045681.n5.nabble.com/Why-won-t-Help-Tip-editor-accept-Carriage-Return-tp5748437.html
> Sent from the 4D Tech mailing list archive at Nabble.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: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Pointer to field using field name

[Alan Tilson via 4D_Tech]

 Hello everyone and thank you for your thoughts on this,

First I don't ever expect to compile our system since working on it live is
a fundamental requirement of our approach, unless that changes of course...

Secondly I'm actually using dynamic field names since I am using the field
names from the sister table which are by design exactly the same as their
sister field in the primary table. So I am taking the field name from the
sister table and creating a pointer to it's sister (or twin?) field in the
primary table. As long as I keep both field names the same it should work.

Hard coding the link between the various pairs would certainly work and
should be the fastest. However, in this case I'm rather attached to my
generic code where the only thing I have to do to add a field to the
mirroring is to add it to the sister table.

If I can find time today I'll play with the various ideas a bit to see if
there is a speed difference and I may also use a process variable.
Currently I'm actually using $0: "EXECUTE
FORMULA("$0:=->"+$tablefieldname)". But tomorrow I'm heading out of town
for a couple of weeks so the crunch is on!

Cheers,
Alan


On Fri, May 18, 2018 at 7:32 AM, Arnaud de Montard via 4D_Tech <
4d_tech@lists.4d.com> wrote:

>
> > Le 17 mai 2018 à 19:24, Alan Tilson via 4D_Tech <4d_tech@lists.4d.com>
> a écrit :
> >
> > [...]
> > Is there something wrong with this?
> >
> > EXECUTE FORMULA("$pField:=->["+tablename+"]"+fieldname)
> > ​
> > It seems to work and it also seems like it would be fast!
>
> Not sure, it calls the interpreter while a loop does not. Mostly, as Neil
> said, it will fail in compiled mode as EXECUTE FORMULA does not work with
> $local variables:
> <http://doc.4d.com/4Dv16R6/4D/16-R6/EXECUTE-FORMULA.301-3548365.en.html>
>
> In your situation, I'd use any mentioned trick (execute formula, loop
> through fields…) to generate hardcode to paste, something like this:
>   ++
>   $code:=""
>   for($i;1;$fieldCount)
> $source:=getFieldName(table1;$i)
> $target:=getFieldByName(table2;$source)
> $code:=$code+$target+":="+$source+"\r"
>   end for
>   set text to pasteboard($code)  //then paste in the method…
>   ++
> No hidden fields references, surely the fastest.
>
> --
> Arnaud de Montard
>
>
>
>
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> 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)
FAQ:  http://lists.4d.com/faqnug.html
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: Pointer to field using field name

[Alan Tilson via 4D_Tech]

Thank you Koen, Dennis & Chip,

I probably should have said what I was doing...which is that I'm copying
certain fields from a sister table with some of the same field names. So I
step though all the sister table fields and load the values (except for the
first one which is the ID field) into the primary field. So I hate to look
through all the field names looking for the one I'm to fill even though it
probably is fast enough.

Loading the info into arrays seems like a step in the right direction. But
I just thought of another idea...using EXECUTE FORMULA to load the pointer
rather than to use the field value.

Is there something wrong with this?

EXECUTE FORMULA("$pField:=->["+tablename+"]"+fieldname)

​
It seems to work and it also seems like it would be fast!

Alan​


On Thu, May 17, 2018 at 12:49 PM, Chip Scheide <4d_o...@pghrepository.org>
wrote:

> that approach will break if you change the field name, assuming the
> field name is hardcoded.
>
> depending on your needs you can do this (code written in email so...):
>
> this code can be run as needed, at process startup (use process vars),
> or it can be run at database startup (use Interprocess vars)
>
> $Table_number:=table(->[table])
> $Field_Count:=get last field number(->[table])
>
> array text($Field_Names;$field_Count)
> array pointer($Field_ptr;$Field_Count)
> array longint($Field_Number;$Field_Count)
>
> for($i;1;$Field_Count)
>
>   if (is field number valid($table_number;$i))
> $Field_Names{$i}:=field name($Table_number;$i)
> $Field_ptr{$i}:=FIeld($Table_number;$i)
> $Field_Number{$i}:=$i
>   end if
> end for
>
>
> Then where you need to get the pointer
> $loc:=find in array($Field_Names;$Field_name_to_lookup)
>
> if($loc>0)
>   $Specific_field_Pointer:=$Field_ptr{$loc}
> end if
>
>
> On Thu, 17 May 2018 12:19:11 -0400, Alan Tilson via 4D_Tech wrote:
> > ​Hello out there,
> >
> > Is it possible to extract a pointer to a field from the table number or
> > pointer and the field name?
> >
> > I'm loading a field using EXECUTE FORMULA and building the
> > [tablename]fieldname into the formula, which serves my purposes but seems
> > rather awkward!
> >
> > Thanks,
> > Alan ​
> > **
> > 4D Internet Users Group (4D iNUG)
> > FAQ:  http://lists.4d.com/faqnug.html
> > Archive:  http://lists.4d.com/archives.html
> > Options: https://lists.4d.com/mailman/options/4d_tech
> > Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> > **
> ---
> Gas is for washing parts
> Alcohol is for drinkin'
> Nitromethane is for racing
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Pointer to field using field name

[Alan Tilson via 4D_Tech]

​Hello out there,

Is it possible to extract a pointer to a field from the table number or
pointer and the field name?

I'm loading a field using EXECUTE FORMULA and building the
[tablename]fieldname into the formula, which serves my purposes but seems
rather awkward!

Thanks,
Alan ​
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
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: Picture Buttons in v16

[Alan Tilson via 4D_Tech]

Tim,
I did find the Light Grey button in the new form wizard to be quite good,
but our old buttons are much smaller.
Also, how can one delete 200 pictures easily?
Thanks,
Alan

On Wed, May 9, 2018 at 5:08 PM, Alan Tilson  wrote:

> Hello again Tim,
> I agree that our old, sometimes very old, images are rather tired. So
> where does one go to find replacements?
> Alan
>
> On Wed, May 9, 2018 at 3:58 PM, Timothy Penner  wrote:
>
>> Keep in mind that for old PICT images, it is often a better idea to find
>> a more modern replacement rather than to convert them...
>>
>> http://forums.4d.com/Post/EN/18809015/1/18812276#18812218
>> "In most cases they look old - in almost all cases it will be a good idea
>> to find a more modern icon/images/design."
>>
>>
>>
>> -Tim
>>
>>
>>
>>
>> Timothy Penner
>> Senior Technical Services Engineer
>>
>> 4D Inc
>> 95 S. Market Street, Suite #240
>> CA 95113 San Jose
>> United States
>>
>> Telephone : +1-408-557-4600
>> Standard :  +1-408-557-4600
>> Fax :   +1-408-271-5080
>> Email : tpen...@4d.com
>> Web :   www.4D.com
>>
>>
>>
>
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
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: Picture Buttons in v16

[Alan Tilson via 4D_Tech]

Hello again Tim,
I agree that our old, sometimes very old, images are rather tired. So where
does one go to find replacements?
Alan

On Wed, May 9, 2018 at 3:58 PM, Timothy Penner  wrote:

> Keep in mind that for old PICT images, it is often a better idea to find a
> more modern replacement rather than to convert them...
>
> http://forums.4d.com/Post/EN/18809015/1/18812276#18812218
> "In most cases they look old - in almost all cases it will be a good idea
> to find a more modern icon/images/design."
>
>
>
> -Tim
>
>
>
>
> Timothy Penner
> Senior Technical Services Engineer
>
> 4D Inc
> 95 S. Market Street, Suite #240
> CA 95113 San Jose
> United States
>
> Telephone : +1-408-557-4600
> Standard :  +1-408-557-4600
> Fax :   +1-408-271-5080
> Email : tpen...@4d.com
> Web :   www.4D.com
>
>
>
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
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: Picture Buttons in v16

[Alan Tilson via 4D_Tech]

> )+"/"+$picNames_atxt{$indx_L}+" from size "+String(Picture size($libpict))
> CONVERT PICTURE($libpict;"image/jpeg")
> $msg_txt:=$msg_txt+"  to new jpeg size "+String(Picture size($libpict))
> SET PICTURE TO LIBRARY($libpict;$pictomod_aL{
> $loop_L};$picNames_atxt{$indx_L})
> ALERT($msg_txt)
> End for
>
> End if
>
> End if
>
>   //End dev_convertPicLibToJPEG
> 
> 
>  Chuck Miller Voice: (617) 739-0306
>  Informed Solutions, Inc. Fax: (617) 232-1064
>  mailto:cjmillerinformed-solutions.com
>  Brookline, MA 02446 USA Registered 4D Developer
>Providers of 4D and Sybase connectivity
>   http://www.informed-solutions.com
> 
> ------------
> This message and any attached documents contain information which may be
> confidential, subject to privilege or exempt from disclosure under
> applicable law.  These materials are intended only for the use of the
> intended recipient. If you are not the intended recipient of this
> transmission, you are hereby notified that any distribution, disclosure,
> printing, copying, storage, modification or the taking of any action in
> reliance upon this transmission is strictly prohibited.  Delivery of this
> message to any person other than the intended recipient shall not
> compromise or waive such confidentiality, privilege or exemption from
> disclosure as to this communication.
>
> > On May 9, 2018, at 1:23 PM, Alan Tilson via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> >
> > PICTURE LIBRARY LIST(arPicRefs;arPicNames)
> > For ($el;1;Size of array(arPicRefs))
> > $picRef:=arPicRefs{$el}
> > $picName:=arPicNames{$el}
> > GET PICTURE FROM LIBRARY($picRef;$picture)
> > GET PICTURE FORMATS($picture;$arCodecIDs)
> > If ($arCodecIDs{1}=".pict")
> > CONVERT PICTURE($picture;".png")
> > TRANSFORM PICTURE($picture;Transparency;"0x00FF")
> > SET PICTURE TO LIBRARY($picture;$picRef;$picName)
> > End if
> > End for
>
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> 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)
FAQ:  http://lists.4d.com/faqnug.html
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: Picture Buttons in v16

[Alan Tilson via 4D_Tech]

Thank you Sannyasin and Keisuke, for sharing the process in converting the
picture library for v16.
However, my results are not good.
Upon opening our system in v16 and going to Pictures almost everything
displays as a camera wtih a red X across it and .pict underneath the X.
After converting each .pict into .png I get a very small version of the
same image except the .pict seems to have been replaced with .png.
And if I leave out the TRANSFORM PICTURE line it does nothing.
Any ideas would be appreciated!
I am converting from v13 if that makes a difference.
Thanks,
Alan

PICTURE LIBRARY LIST(arPicRefs;arPicNames)
For ($el;1;Size of array(arPicRefs))
$picRef:=arPicRefs{$el}
$picName:=arPicNames{$el}
GET PICTURE FROM LIBRARY($picRef;$picture)
GET PICTURE FORMATS($picture;$arCodecIDs)
If ($arCodecIDs{1}=".pict")
CONVERT PICTURE($picture;".png")
TRANSFORM PICTURE($picture;Transparency;"0x00FF")
SET PICTURE TO LIBRARY($picture;$picRef;$picName)
End if
End for



On Mon, May 29, 2017 at 5:00 AM, Sannyasin Siddhanathaswami via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Thanks Keisuke Miyako!
>
> That’s exactly what I needed.
>
> So I basically do this:
> PICTURE LIBRARY LIST
> loop through each picture and GET PICTURE FROM LIBRARY
> use GET PICTURE FORMATS to detect if it is a PICT
> if the picture is a PICT,
> CONVERT PICTURE to PNG
> TRANSFORM PICTURE to add transparency
> SET PICTURE TO LIBRARY to save it back
>
>
> That’s pretty easy. Thanks again!
>
>
>
> Sannyasin Siddhanathaswami
>
> On May 28, 2017, 10:31 PM -1000, wrote:
>
> I would recommended converting the source pictures inside the library,
> from PICT to PNG.
> there is nothing wrong with using the picture library, you can consider
> resource files in new development.
>
> so, take a 32-bit v16,
> iterate all pictures in your picture library,
> use GET PICTURE FORMATS to detect PICT,
> CONVERT PICTURE to PNG,
> (optionally) TRANSFORM PICTURE to add transparency,
> then save back to the library using the same name/ID.
> **
> 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: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Simple Popup with multiple selection option?

[Alan Tilson via 4D_Tech]

Hey Chip,
Thanks for the tip and the code. I'll give it a shot!
Alan

On Fri, Apr 20, 2018 at 4:18 PM, Chip Scheide <4d_o...@pghrepository.org>
wrote:

> Dialog
>&
> (array) listbox
>
> - populate the listbox with the needed data
> - display using dialog
> on accept, process selected items
>
> selected items are TRUE for the list box row (see below code to count
> how many selected)
>
>   //(m) arylstbx_How_Many_Selected
>   // $1 - pointer - to listbox
>
>   //RETURNS - longint - number of rows selected in an array based
> listbox.  Returns 0 if none selected
>   // ∙ Created 9/6/12 by Chip -
> C_POINTER($1;$Listbox)
> C_LONGINT($0;$How_Many;$Last;$Loc)
>
> $Listbox:=$1
> $Last:=0
>
> Repeat   //check the array of booleans for selected row(s)
> $Loc:=Find in array($Listbox->;True;$Last)
>
> If ($Loc>0)  //something was found
> $How_Many:=$How_Many+1
> $Last:=$Loc+1
> End if
> Until ($Loc<0)
> $0:=$How_Many
>
> On Fri, 20 Apr 2018 16:02:04 -0400, Alan Tilson via 4D_Tech wrote:
> > Hello,
> >
> > Could someone please point me to a simple way to request information in
> the
> > form of a list from which multiple selections may be made? I started to
> > build a new request form  but it seems like this should almost be an
> > automatic function!
> >
> > Any ideas will be appreciated.
> >
> > Thanks,
> > Alan
> > **
> > 4D Internet Users Group (4D iNUG)
> > FAQ:  http://lists.4d.com/faqnug.html
> > Archive:  http://lists.4d.com/archives.html
> > Options: https://lists.4d.com/mailman/options/4d_tech
> > Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> > **
> ---
> Gas is for washing parts
> Alcohol is for drinkin'
> Nitromethane is for racing
>
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Simple Popup with multiple selection option?

[Alan Tilson via 4D_Tech]

Hello,

Could someone please point me to a simple way to request information in the
form of a list from which multiple selections may be made? I started to
build a new request form  but it seems like this should almost be an
automatic function!

Any ideas will be appreciated.

Thanks,
Alan
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
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: Securing ODBC Connections?

[Alan Tilson via 4D_Tech]

Chuck,
Thanks for the info. My user isn't familiar with using Excel & ODBC but
we'll give it a go.
Keisuke,
Thank you for responding. I was wondering about the precise situation that
you discuss, that to trace the connection we must have a functional method.
I did find the 32 bit ODBC driver installer finally, after looking all over
for a place to download it (it is rather hidden!).
So we have the driver connecting to 4D Server ok, but the actual ODBC
connection fails.
And I'll create a receiving method and see what we learn, but this has been
pushed back a bit on the priority list so it may be a few days...
Alan

On Tue, Jan 2, 2018 at 4:35 PM, Keisuke Miyako via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> keep in mind also that an incomplete authentication method will reject the
> connection.
> the code should
>
> 1. explicitly call "change current user" and
> 2. return "true"
>
> http://doc.4d.com/4Dv16R4/4D/16-R4/On-SQL-Authentication-
> database-method.301-3316871.en.html
>
> in other words, an empty "on sql authentication" database method with no
> code would reject the connection.
> by contrast, if the database method does not exist, the connection is
> accepted.
>
> ---
>
> another factor to consider is that the ODBC driver version must match that
> of 4D.
> R releases have a different driver to .x releases.
>
> the architecture (32 or 64-bit) must match that of the client (Access) not
> 4D.
>
> http://doc.4d.com/4Dv16R4/4D/16-R4/4D-ODBC-Driver.100-3454244.en.html
>
> (the OP is about v13 so this point is probably irrelevant)
>
> ---
>
> finally, note that in v13 the full installer of 4D doesn't actually
> install the ODBC driver.
> rather, it installs the installer for ODBC driver (on Windows).
>
> > 2018/01/03 2:10、Chuck Miller via 4D_Tech <4d_tech@lists.4d.com> のメール：
> > If you put a trace in sql authentication method and see what happens.
>
>
>
>
> **
> 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: Securing ODBC Connections?

[Alan Tilson via 4D_Tech]

Hello Chuck & everyone,

One of my users is attempting to connect to 4D Server v13.6 from Access. He
has setup the ODBC driver which seems to work fine, entering a user name
and password and 'connecting' to 4d. However when trying to run a query or
open a 4D table in Access, he gets the following error:

ODBC--call failed.

Server rejected the connection:
00.202. OK

(#0)

​Will creating an On SQL Authentication method solve this problem?

Thanks,
Alan​


On Tue, Jun 6, 2017 at 2:57 PM, Charles Miller via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> You should also have an on sql connection method with log in info
>
> we have code that looks like the following
>
> *SET QUERY DESTINATION*(Into current selection)
>
> *Case of *
>
>
> *: *(*User in group*(ONSQLAuthenUser_txt;" "))
>
> *CHANGE CURRENT USER*("SQL_ReadOnly";"12345")
>
> *: *(*User in group*(ONSQLAuthenUser_txt;"ReadOnly"))
>
> *CHANGE CURRENT USER*(ONSQLAuthenUser_txt;ONSQLAuthUserPW_txt)
>
> *: *(*User in group*(ONSQLAuthenUser_txt;"ReadWrite"))
>
> *CHANGE CURRENT USER*(ONSQLAuthenUser_txt;ONSQLAuthUserPW_txt)
>
> *Else *
>
> *If *(*Not*(*User in group*(ONSQLAuthenUser_txt;"ActiveUsers")))
>
> *C_LONGINT*($Processid_l)
>
> $Processid_l:=*New process*
> ("ut_LogExternalConnects";128*1024;"ONSQLAuthenticate";
> ONSQLAuthenUser_txt;
> ONSQLAuthenIP_txt;ONSQLAuthUserPW_txt;"InactiveUser")
>
> *Else *
>
>
> *End if *
>
> SQL_ConnectionOK_b:=*False*
>
> *End case *
>
> *$0*:=SQL_ConnectionOK_b
>
> *ON ERR CALL*("")
>
>
> Regards
>
>
> Chuck
>
> On Tue, Jun 6, 2017 at 2:53 PM, Timothy Penner via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
>
> > Hi Bob,
> >
> > > This is the source of confusion, from the 4D Design Ref (v15), talking
> > abtout setting types of access to schemas:
> > > "More specifically, if you only assign Read Only type access to one
> > group this will not have any effect since this group as well as all the
> > others will continue to benefit from Read/Write access (assigned to
> >  by default). In order to set a Read Only type access, you
> also
> > need to configure the Read/Write access."
> > > I"m not clear at all about why "this will not have any effect...")
> >
> > Let's say you have a group named Group1.
> > If you assign Group1 to READ ONLY for this Schema, but leave 
> > set to Read/Write access, then Group1 would effectively get Read/Write
> > access because they are included in the Everybody pseudo-group.
> > That is what is meant by the READ ONLY setting would have no effect.
> > If you want Group1 to be READ ONLY then you need to also check the
> > READ/WRITE group to be sure they do not have access.
> >
> > Another way to look at it, is let's assume you have User1 who belongs to
> > both Group1 and Group2.
> > Then you assign Group1 to READ ONLY and Group2 to READ/WRITE for the
> > schema applied to this table.
> > Then you login as User1 whom belongs to both Group1 and Group2.
> > In this situation the User1 would have READ/WRITE.
> >
> > This tech note is a bit old but it may help explain the use of Schemas:
> > http://kb.4d.com/assetid=51814
> >
> > -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
> > **
>
>
>
>
> --
> 
> -
>  Chuck Miller Voice: (617) 739-0306 Fax: (617) 232-1064
>  Informed Solutions, Inc.
>  Brookline, MA 02446 USA Registered 4D Developer
>Providers of 4D, Sybase & SQL Sever connectivity
>   http://www.informed-solutions.com
> 
> -
> This message and any attached documents contain information which may be
> confidential, subject to privilege or exempt from disclosure under
> applicable law.  These materials are intended only for the use of the
> intended recipient. If you are not the intended recipient of this
> transmission, you are hereby notified that any distribution, disclosure,
> printing, copying, storage, modification or the taking of any action in
> reliance upon this transmission is strictly prohibited.  Delivery of this
> message to any person other than the intended recipient shall not
> compromise or waive such confidentiality, privilege or exemption
> from disclosure as to this communication.
> **
> 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: Twin Process for 4D SQL Data Source

[Alan Tilson via 4D_Tech]

Hello Tim,
Thanks for the info. Where do I find pricing for ODBC Pro?
Alan

On Wed, Dec 13, 2017 at 4:20 PM, Timothy Penner  wrote:

> Hi Alan,
>
> > but I couldn't find a place where it is sold for 4d server.
>
> ODBC Pro can be purchased as an expansion when configuring a new server on
> the store:
> https://store.4d.com/us/article/4USE16.shtml
> https://store.4d.com/us/article/4USD16.shtml
>
> ODBC Pro can also be purchased as an addon for an existing server via the
> 'Extend your configuration' on the store:
> https://store.4d.com/us/extendConfigurator.shtml
>
> In case you wanted to see it, here is the product page for ODBC Pro:
> http://www.4d.com/products/4dv16/4dodbcpro.html
>
> Hope that helps!
>
> -Tim
>
>
>
>
>
> Timothy Penner
> Senior Technical Services Engineer
>
> 4D Inc
> 95 S. Market Street, Suite #240
> CA 95113 San Jose
> United States
>
> Telephone : +1-408-557-4600
> Standard :  +1-408-557-4600
> Fax :   +1-408-271-5080
> Email : tpen...@4d.com
> Web :   www.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: Twin Process for 4D SQL Data Source

[Alan Tilson via 4D_Tech]

Chuck,
4D ODBC Pro is still listed on the 4D website for v16 and it says that it
comes with 4D Developer Professional and with Team Developer Professional,
but I couldn't find a place where it is sold for 4d server.
I prefer using the native core 4D functionalities wherever possible, but it
is interesting that ODBC Pro offers cloning of 4D tables as ODBC tables and
vice versa. One of the things I do regularly is to load data from 4d and
theoretically the same data from the SQL Server system and compare it using
arrays to find records that have changed. If this could be done within one
SQL statement that would be great!
I did see the expression *ConnectionID* in the ODBC Pro docs which implies
that several connections could be open.
Thanks,
Alan

On Wed, Dec 13, 2017 at 1:51 PM, Charles Miller via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Hi Alan,
>
> Is there not a command that allows you to switch. I seem to remember
> somethingt like Use Local but could not find it
>
> Regards
>
>
> Chuck
>
> On Wed, Dec 13, 2017 at 1:12 PM, Alan Tilson via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
>
> > Hello Chuck,
> > You are probably right. I just counted 14 logins to the SQL Server in 1
> min
> > 50 sec so I ran a test logging in and out 20 times and this took 2.03
> > seconds.
> > There would have to be some overhead associated with using a separate
> > process so I doubt there would be any gain.
> > It just seems rather clunky to have to login in and out and to not just
> be
> > able to specify which source to use or even to be able to use both
> > simultaneously like Access can do!
> > Thanks,
> > Alan
> >
> >
> > On Wed, Dec 13, 2017 at 12:46 PM, Chuck Miller via 4D_Tech <
> > 4d_tech@lists.4d.com> wrote:
> >
> > > I have not but it seems to me to be a lot of work as you will have to
> get
> > > data/orrays/variables between processes and it would also seem to me
> that
> > > you could choose only one to put in a new process
> > >
> > > Regards
> > >
> > > Chuck
> > >
> > > 
> > > 
> > >  Chuck Miller Voice: (617) 739-0306
> > >  Informed Solutions, Inc. Fax: (617) 232-1064
> > >  mailto:cjmillerinformed-solutions.com
> > >  Brookline, MA 02446 USA Registered 4D Developer
> > >Providers of 4D and Sybase connectivity
> > >   http://www.informed-solutions.com
> > > 
> > > 
> > > This message and any attached documents contain information which may
> be
> > > confidential, subject to privilege or exempt from disclosure under
> > > applicable law.  These materials are intended only for the use of the
> > > intended recipient. If you are not the intended recipient of this
> > > transmission, you are hereby notified that any distribution,
> disclosure,
> > > printing, copying, storage, modification or the taking of any action in
> > > reliance upon this transmission is strictly prohibited.  Delivery of
> this
> > > message to any person other than the intended recipient shall not
> > > compromise or waive such confidentiality, privilege or exemption from
> > > disclosure as to this communication.
> > >
> > > > On Dec 13, 2017, at 12:28 PM, Alan Tilson via 4D_Tech <
> > > 4d_tech@lists.4d.com> wrote:
> > > >
> > > > Hello everyone,
> > > >
> > > > I find myself switching data sources frequently (20 or more times in
> a
> > > few
> > > > minutes-I'll count the number...) back and forth between 4D and my
> > > client's
> > > > MS SQL Server based system. So today I've been contemplating the idea
> > > that
> > > > I might put all my 4D SQL code in a separate process so that my each
> > > > process could stay logged into either 4D/Local or the SQL Server.
> > > >
> > > > Has anyone tried this? If so, please share your thoughts on the
> > benefits
> > > > and complications and even solutions that this approach offers!
> > >
> > > **
> > > 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.

Re: Twin Process for 4D SQL Data Source

[Alan Tilson via 4D_Tech]

Hello Chuck,
You are probably right. I just counted 14 logins to the SQL Server in 1 min
50 sec so I ran a test logging in and out 20 times and this took 2.03
seconds.
There would have to be some overhead associated with using a separate
process so I doubt there would be any gain.
It just seems rather clunky to have to login in and out and to not just be
able to specify which source to use or even to be able to use both
simultaneously like Access can do!
Thanks,
Alan


On Wed, Dec 13, 2017 at 12:46 PM, Chuck Miller via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> I have not but it seems to me to be a lot of work as you will have to get
> data/orrays/variables between processes and it would also seem to me that
> you could choose only one to put in a new process
>
> Regards
>
> Chuck
>
> 
> 
>  Chuck Miller Voice: (617) 739-0306
>  Informed Solutions, Inc. Fax: (617) 232-1064
>  mailto:cjmillerinformed-solutions.com
>  Brookline, MA 02446 USA Registered 4D Developer
>Providers of 4D and Sybase connectivity
>   http://www.informed-solutions.com
> 
> 
> This message and any attached documents contain information which may be
> confidential, subject to privilege or exempt from disclosure under
> applicable law.  These materials are intended only for the use of the
> intended recipient. If you are not the intended recipient of this
> transmission, you are hereby notified that any distribution, disclosure,
> printing, copying, storage, modification or the taking of any action in
> reliance upon this transmission is strictly prohibited.  Delivery of this
> message to any person other than the intended recipient shall not
> compromise or waive such confidentiality, privilege or exemption from
> disclosure as to this communication.
>
> > On Dec 13, 2017, at 12:28 PM, Alan Tilson via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> >
> > Hello everyone,
> >
> > I find myself switching data sources frequently (20 or more times in a
> few
> > minutes-I'll count the number...) back and forth between 4D and my
> client's
> > MS SQL Server based system. So today I've been contemplating the idea
> that
> > I might put all my 4D SQL code in a separate process so that my each
> > process could stay logged into either 4D/Local or the SQL Server.
> >
> > Has anyone tried this? If so, please share your thoughts on the benefits
> > and complications and even solutions that this approach offers!
>
> **
> 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
**

Twin Process for 4D SQL Data Source

[Alan Tilson via 4D_Tech]

Hello everyone,

I find myself switching data sources frequently (20 or more times in a few
minutes-I'll count the number...) back and forth between 4D and my client's
MS SQL Server based system. So today I've been contemplating the idea that
I might put all my 4D SQL code in a separate process so that my each
process could stay logged into either 4D/Local or the SQL Server.

Has anyone tried this? If so, please share your thoughts on the benefits
and complications and even solutions that this approach offers!

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: Min/Max for Date Fields in 4D

[Alan Tilson via 4D_Tech]

Hello everyone,
Arnaud's comments led me to realize that I was testing on a virtual machine
that was part of the real machine that also hosts the virtual machine that
run 4D server. So communications between the 2 are ultra fast, never
needing to utilize the LAN.
So today I tested this on an independent machine that does communicate with
the server over the LAN.

Cold database, 271k records, longint unique field:
DV approach 22 ticks
Sort approach 12 ticks, but the data should have been warmed by first test.

Run #2
DV approach 22 ticks, unchanged
Sort approach 5 ticks, not what I expected!
4D Min/Max functions 16 ticks

Cold index I believe, date field, 271, records
DV approach 3 ticks
Sort approach 3 ticks

Run #2 date field
DV 3 ticks
Sort 4 ticks

All this is being run on an old XP box over the LAN.

So unless someone sees a hole in my testing, it seems the sorting approach
is entirely satisfactory for both unique fields and fields with lots of
recurring values like dates.

Alan

On Thu, Oct 12, 2017 at 7:36 PM, Alan Tilson <alantil...@gmail.com> wrote:

> It is CS actually! All my testing was CS.
> Alan
>
> sent from my Note 4
>
> On Oct 12, 2017 6:40 PM, "Arnaud de Montard via 4D_Tech" <
> 4d_tech@lists.4d.com> wrote:
>
>>
>> > Le 12 oct. 2017 à 22:37, Alan Tilson via 4D_Tech <4d_tech@lists.4d.com>
>> a écrit :
>> >
>> > ​Another interesting point is that with a larger selection of 446.5k
>> > records and a warm database I got:
>> > 3 ticks for DV approach
>> > 6 ticks for the record sorting approach
>>
>> Guessing… Only twice more for the record sorting approach makes me
>> suppose the test is not in C/S but standalone. I wouldn't be surprised by a
>> much greater difference in C/S.
>>
>> --
>> 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: Min/Max for Date Fields in 4D

[Alan Tilson via 4D_Tech]

Arnaud,
Your point finally caused me to realize this morning that my testing has
been on a virtual machine hosted by the same real machine that hosts the
virtual machine that runs 4D Server. So communications between my 4D Client
and 4D Server are ultra fast. I will try to test this on a computer that
utilizes the LAN and post my results.
Thank you for your input!
Alan

On Thu, Oct 12, 2017 at 6:40 PM, Arnaud de Montard via 4D_Tech <
4d_tech@lists.4d.com> wrote:

>
> > Le 12 oct. 2017 à 22:37, Alan Tilson via 4D_Tech <4d_tech@lists.4d.com>
> a écrit :
> >
> > ​Another interesting point is that with a larger selection of 446.5k
> > records and a warm database I got:
> > 3 ticks for DV approach
> > 6 ticks for the record sorting approach
>
> Guessing… Only twice more for the record sorting approach makes me suppose
> the test is not in C/S but standalone. I wouldn't be surprised by a much
> greater difference in C/S.
>
> --
> 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: Min/Max for Date Fields in 4D

[Alan Tilson via 4D_Tech]

It is CS actually! All my testing was CS.
Alan

sent from my Note 4

On Oct 12, 2017 6:40 PM, "Arnaud de Montard via 4D_Tech" <
4d_tech@lists.4d.com> wrote:

>
> > Le 12 oct. 2017 à 22:37, Alan Tilson via 4D_Tech <4d_tech@lists.4d.com>
> a écrit :
> >
> > ​Another interesting point is that with a larger selection of 446.5k
> > records and a warm database I got:
> > 3 ticks for DV approach
> > 6 ticks for the record sorting approach
>
> Guessing… Only twice more for the record sorting approach makes me suppose
> the test is not in C/S but standalone. I wouldn't be surprised by a much
> greater difference in C/S.
>
> --
> 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: Min/Max for Date Fields in 4D

[Alan Tilson via 4D_Tech]

​Another interesting point is that with a larger selection of 446.5k
records and a warm database I got:
3 ticks for DV approach
6 ticks for the record sorting approach
and on a warmed up indexed longint field​
23 ticks for Min then Max, the 4D functions
So our DV approach is faster than the 4D functions I was wishing would work
with date fields...

But the longint field has unique values so I ran the whole test with it,
and found:
34 ticks for the DV approach
8 ticks for the sorting approach
23 ticks again for the Min/Max approach
so the sorting approach seems better for fields that are unique or have
mostly distinct values.

Also, I do have a Cluster B-tree index on the date field...

I should stop now...

Adios,
Alan

On Thu, Oct 12, 2017 at 4:14 PM, Alan Tilson  wrote:

> ​Thank you everyone for your continued input on my question! I was pretty
> satisfied with the sorting approach but distinct values might be an
> interesting approach!
>
> I just ran another test on 240k records first using the approach that
> sorts the records and then using the selection to array approach.​ And the
> sorting process ran in 7 ticks the first time while the s2a process took 99
> ticks with the index loaded. So the sorting approach definitely wins there.
>
> Running again with the data warmed up and changing the sorted S2A to
> unsorted DV, the results are a bit surprising. The sorting approach took 4
> ticks this time and the distinct values approach, drum r, took
> 1 tick to get Min & Max Dates from 240k records!
>
> So I am converting to the DV, no sorting approach!
>
> My code which allows me to extract Min, Max or both:
>
> $pField:=$1
> DISTINCT VALUES($pField->;arDates)
> If (Defined ($2))
>
> $pDate_min:=$2
>
> $pDate_min->:=arDates{1}
>
> End if
> If (Defined ($3))
>
> $pDate_max:=$3
>
> $pDate_max->:=arDates{Size of array(arDates)}
>
> End if
>
>
> The Defined method is just $0:=Not(Undefined($1))
>
> Thanks again, 8o)
> Alan
>
>
> On Thu, Oct 12, 2017 at 4:00 PM, David Adams via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
>
>> On Thu, Oct 12, 2017 at 6:57 AM, Arnaud de Montard via 4D_Tech <
>> 4d_tech@lists.4d.com> wrote:
>>
>> >
>> > It's a solution if the selection is huge (is it?). But sort selection
>> > (I've always found 4d sort is slow), then 2 selection to array, that's 3
>> > server calls, at end. I'd prefer selection to array (1 call), sort
>> array,
>> > read first and last items in array.
>> >
>>
>> Agreed. I'd want to know that there is any optimization needed past FIRST
>> RECORD and LAST RECORD before diving into anything else. And, past that,
>> you would want to balance the cost of pulling more data over the network
>> in
>> once call with pulling tiny bits of data over the network with multiple
>> calls.
>>
>> I suspect this is getting a bit silly, but another idea is to have an
>> method set to "Execute on server" that does the work and packs the results
>> in an object and returns it. Yeah, that might work.
>> **
>> 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]

​Thank you everyone for your continued input on my question! I was pretty
satisfied with the sorting approach but distinct values might be an
interesting approach!

I just ran another test on 240k records first using the approach that sorts
the records and then using the selection to array approach.​ And the
sorting process ran in 7 ticks the first time while the s2a process took 99
ticks with the index loaded. So the sorting approach definitely wins there.

Running again with the data warmed up and changing the sorted S2A to
unsorted DV, the results are a bit surprising. The sorting approach took 4
ticks this time and the distinct values approach, drum r, took
1 tick to get Min & Max Dates from 240k records!

So I am converting to the DV, no sorting approach!

My code which allows me to extract Min, Max or both:

$pField:=$1
DISTINCT VALUES($pField->;arDates)
If (Defined ($2))

$pDate_min:=$2

$pDate_min->:=arDates{1}

End if
If (Defined ($3))

$pDate_max:=$3

$pDate_max->:=arDates{Size of array(arDates)}

End if


The Defined method is just $0:=Not(Undefined($1))

Thanks again, 8o)
Alan


On Thu, Oct 12, 2017 at 4:00 PM, David Adams via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> On Thu, Oct 12, 2017 at 6:57 AM, Arnaud de Montard via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
>
> >
> > It's a solution if the selection is huge (is it?). But sort selection
> > (I've always found 4d sort is slow), then 2 selection to array, that's 3
> > server calls, at end. I'd prefer selection to array (1 call), sort array,
> > read first and last items in array.
> >
>
> Agreed. I'd want to know that there is any optimization needed past FIRST
> RECORD and LAST RECORD before diving into anything else. And, past that,
> you would want to balance the cost of pulling more data over the network in
> once call with pulling tiny bits of data over the network with multiple
> calls.
>
> I suspect this is getting a bit silly, but another idea is to have an
> method set to "Execute on server" that does the work and packs the results
> in an object and returns it. Yeah, that might work.
> **
> 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]

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

[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: 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 <alantil...@gmail.com> 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
**

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: 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 <davidi...@gmail.com>
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 <alantil...@gmail.com>
> *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
**

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: v13.6 - 2 servers same network, how to make it work

[Alan Tilson via 4D_Tech]

Hey Tim,
No, I hadn't seen that page but we were able to accomplish the intentions
of our testing on another machine on the network.
I'll try to go back to see if anything on the list makes a difference!
Thanks,
Alan

On Tue, Sep 19, 2017 at 5:26 PM, Timothy Penner via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Hi Alan,
>
> Did you see this?
>
> Tech Tip: Why can't I see my 4D Server?
> http://kb.4d.com/assetid=76047
>
> -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: v13.6 - 2 servers same network, how to make it work

[Alan Tilson via 4D_Tech]

Hello everyone,
I moved the server to another machine and it seems to be working, for now
at least. Not sure what is going on!
Alan

On Tue, Sep 19, 2017 at 12:40 PM, Alan Tilson  wrote:

> Hello Koen & Douglas,
> Thank you for confirming that I don't need to change the port numbers for
> 2 servers on different machines on the same network. I was "pretty" sure
> that this had worked in the past!
> Also, my attempt at changing the port numbers does seem to have made the
> 2nd server invisible, not showing up in available.
> So I changed the ports back to factory settings, closed & reopened 4d
> server, switched to another (virtual) machine and still the 2nd db is not
> showing up.
> Formerly it was showing up and then there was an error message when people
> tried to log into it to test the changes. They got this message "The
> connection for this process has been disrupted or the connection couldn't
> be established".
> Any ideas would really be appreciated!
> Alan
>
>
> On Tue, Sep 19, 2017 at 12:28 PM, Douglas Cryer via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
>
>> Alan,
>>
>> If you are running the databases on different servers each with their own
>> IP address you should not need to change the ports at all.  In this case,
>> if both are set with the default ports then they will both be visible under
>> available.
>>
>> If you are running two or more servers on the same server/ip address then
>> you must change one of the databases to broadcast on different ports.  The
>> server with the changed ports will not be visible under available to a
>> client that has not itself been customised.
>>
>> Instead you would need to click on the server that is available then go
>> to the custom tab change the name and add the port number to the end of the
>> IP address with a colon at the start such as “:19001”
>>
>> Regards,  Dougie
>> 
>>
>> telekinetix Limited- J. Douglas Cryer
>> Phone : 01234 761759  Mobile : 07973 675 218
>> 2nd Floor Broadway House, 4-6 The Broadway, Bedford MK40 2TE
>> Email : jdcr...@telekinetix.com   Web :
>> http://www.telekinetix.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
**

v13.6 - 2 servers same network, how to make it work

[Alan Tilson via 4D_Tech]

Hello everyone,
I thought I'd done this before but now cannot get it to work.
How do I run 2 4d servers on the same network?
I see where to change 2 port numbers but not 3.
Is that the main thing? I did change the database name...
I can't get the test db to show up under available...
Thanks,
Alan
**
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: v13+ - component method parameters

[Alan Tilson via 4D_Tech]

Chip,
Thanks for the link. I'll try to check it out. Is it your component?
Alan

On Mon, Jun 26, 2017 at 11:13 AM, Chip Scheide <4d_o...@pghrepository.org>
wrote:

> Alan,
> First the specific problem was/is trying to compile (testing database)
> with interpreted component.
> The error provided "Invalid parameter" is not really the correct error
> to generate.
>
> As to your question regarding sets.
> download the (shareware) component.
> https://www.dropbox.com/s/075k0ap7afervs8/Sets_Component_v1.0.zip?dl=0
>
> Basically, you run all your set creation code through the component, it
> tracks everything.
> This makes it possible to ask (and answer!!) questions you could not do
> so before.
> Such as:
> - To which table does a set belong?
> - What set(s) exists for a specified table?
> - Does a set exist?
>
> Chip
>
>
> On Mon, 26 Jun 2017 10:43:52 -0400, Alan Tilson wrote:
> > Hello Chip,
> > Sorry, I don't know the answer to your issues, but I am curious about how
> > you determine what sets if any exist for a table? I thought the only test
> > available was Records in Set()>0?
> > Thanks,
> > Alan
> >
> > On Wed, Jun 21, 2017 at 12:30 PM, Chip Scheide via 4D_Tech <
> > 4d_tech@lists.4d.com> wrote:
> >
> >> Thanks.
> >>
> >> The code runs, interpretably just fine.
> >> I have to re-test, but I think the code runs fine when the component is
> >> compiled and built.
> >>
> >> The method (from original code I posted, and this code posted below) :
> >> utl_sets_whatsets_Validate
> >> does all of this validation and returns a boolean (true - everything is
> >> OK)
> >>
> >> I do not do a parameter count check, in that I believe that 4D is
> >> *supposed* to do that
> >> However, tracing this code, interpretedly it works correctly.
> >>
> >> The problem is when I try to compile the test database. It is when
> >> compiling the test database that I get the invalid parameter errors,
> >> when making calls to (for example, and as previously posted)
> >> utl_sets_What_Sets.
> >>
> >>
> >> code for utl_sets_whatsets_Validate
> >>   //(m) utl_whatsets_Validate
> >>   // $1 - pointer - to a table to determine what, if any sets exist
> >>   // $2 - pointer - to text Array
> >>   // $3 - pointer - to error text
> >>
> >>   //RETURNS - boolean - are parameters valid
> >>   // • Created 06-09-17 by Chip -
> >> C_POINTER($1;$2;$Table;$Array;$3;$Errors)
> >> C_TEXT($Sets;$msg)
> >> C_BOOLEAN($0)
> >>
> >> $Table:=$1
> >> $Array:=$2
> >> $Errors:=$3
> >>
> >> Case of
> >> : (Nil($Table))  //nil table pointer (nil passed, or nothing)
> >>   $msg:="Table pointer is Nil."
> >>
> >> : (Not(utl_type_Is_Table ($Table)))  // pointer passed, but not to a
> >> table
> >>   $msg:="Table pointer does not point to a table."
> >>
> >> : (Nil($Array))  //nil array pointer (nil passed, or nothing)
> >>   $msg:="Array pointer is Nil."
> >>
> >> : (Not(utl_type_Is_An_Array ($Array;"Text")))  // array is not text
> >>   $msg:="Array pointer does not point to an Array."
> >> Else   //everything is OK
> >>   $0:=True
> >> End case
> >>
> >> If (Not(utl_Is_Empty (->$msg)))  // there was an error above
> >> utl_errtxt_Add ($msg)  //add it to the error handler
> >> End if
> >> utl_errtxt_End (Current method name;$Errors)  //report the error
> >>   //End utl_whatsets_Validate
> >>
> >>
> >> On Wed, 21 Jun 2017 17:37:19 +0200, Arnaud de Montard via 4D_Tech wrote:
> >>>
>  Le 21 juin 2017 à 16:38, Chip Scheide via 4D_Tech
>  <4d_tech@lists.4d.com> a écrit :
> 
>  $Table:=$1
>  $Array:=$2
> >>>
> >>> Hi Chip,
> >>> If you trace in the component code, nothing helps?
> >>>
> >>> Some times it helps to "look into the pointer", for example:
> >>>
> >>> case of
> >>>  :(count parameters < 2)
> >>>   //err 1
> >>>  :(not(Ptr_isTable($1)))
> >>>   //err 2
> >>>  :(not(Ptr_isArray($2;is text array)))
> >>>   //err 3
> >>>  else
> >>>   //run method
> >>> end case
> >>>
> >>> --
> >>> Arnaud
> >>>
> >>>
> >>>
> >>> **
> >>> 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
> >>> **
> >> ---
> >> Gas is for washing parts
> >> Alcohol is for drinkin'
> >> Nitromethane is for racing
> >> **
> >> 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
> >> **
> >>
> ---
> Gas is for washing parts
> Alcohol is for drinkin'
> Nitromethane is for racing
>