Re: HELP ON FOOTER FORMULA

Hi Andrea, Work fine. Thanks Ferdinando Il 08/02/2021 19:32, Andrea ha scritto: Hi Ferdinando, One Way is to write, on variable name, in the footer cell a variable name where you set your costume value. Andrea Il giorno 08 feb 2021, alle ore 16:43, stardata.info via 4D_Tech <4d_tech

Re: Help Tips for list boxes?

Thanks folks! OBJECT SET HELP TIP works well but I'll check out AJUL_Tip Lab as well to see what it offers. Pat On Wed, 4 Sep 2019 at 12:18, Maurice Inzirillo - AJAR via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Hi Pat, > > We provide exactly such example with AJUI_Tip Lab. > > https://www.evernot

Re: Help Tips for list boxes?

Hi Pat, We provide exactly such example with AJUI_Tip Lab. https://www.evernote.com/l/AAPYpGcG1exNDY7HOq_qwIAgubsNVYzbrSA AJUI_Tip is free. To know more about it and download Doc, Component and Lab : https://ch-fr.4d.com/aj-suite Don’t hesitate to ask if any questions. Best regards, Mauric

Re: Help Tips for list boxes?

Yeah I have 1 window which I hide/show and move based on the object I'm displaying the help for. I also have a feature which allows me to enter/update the help tip text as I or my users are using the app. Adam Bevan Developer & CEO, Argus Productions Inc.

Re: Help Tips for list boxes?

Hi Adam, yeah ... I was thinking of doing that. Do you have one window for the help tip which you hide and show was required, or create a new one each time? Pat On Tue, 3 Sep 2019 at 17:50, Adam Bevan via 4D_Tech <4d_tech@lists.4d.com> wrote: > AJUI_Tip looks nice but it requires a picture obje

Re: Help Tips for list boxes?

AJUI_Tip looks nice but it requires a picture object on every page on every form you want it to work. I instead use a window in a new process and call it on mouse enter and leave. Similar result. as well, my custom help tips don't disappear after 5 seconds. Adam Bevan Developer & CEO, Argus Produ

Re: Help Tips for list boxes?

Pat, Perhaps you can create custom help tips with SVG overlays? You could also try using AJUI_Tip or just take a look at it for some inspiration: https://ch-fr.4d.com/ajuitip It may be worth checking out the 4D KnowledgeBase or 4D Blog too for possible options? Regards, Narinder Chandi, Tool

Re: Help LEP macOS to open the Emoji viewer

4D Tech mailing list wrote > it seems the code > > CGEventPost(kCGHIDEventTap, e); > > cancels the pressed state of control, option, fn, command (but not shift) > implicitly. > > I've changed the code to support a combination of modifiers. > > https://github.com/miyako/4d-plugin-virtual-key >

Re: Help LEP macOS to open the Emoji viewer

thanks for your informative reply. I've tried your plugin, but it seems that the plugin only accepts one modifier key. This code opens (only with debugger) the macOS Spotlight and close spotlight after you step over "POST VIRTUAL KEY" $modifiers:=Command key mask+Control key mask kVK_Space:=0x00

Re: Help LEP macOS to open the Emoji viewer

4D Tech mailing list wrote > P.S. > > to post keystrokes programmatically > > https://github.com/miyako/4d-plugin-virtual-key > > to do it the proper way (it seems, not tested) > > https://developer.apple.com/documentation/appkit/nsapplication/1428455-orderfrontcharacterpalette?language=objc M

Re: Help LEP macOS to open the Emoji viewer

P.S. to post keystrokes programmatically https://github.com/miyako/4d-plugin-virtual-key to do it the proper way (it seems, not tested) https://developer.apple.com/documentation/appkit/nsapplication/1428455-orderfrontcharacterpalette?language=objc

Re: Help LEP macOS to open the Emoji viewer

which version of macOS? the code is not allowed in Terminal on Mojave; osascript is not allowed to send keystrokes (1002) https://www.reddit.com/r/MacOS/comments/9lwlsv/script_editor_not_allowed_to_send_keystrokes/ on top of that, to grant automation to 4D, you must have a specific key info.pl

Re: Help->v11 to v17 Upgrade or New?

On Oct 23, 2018, at 2:00 PM, Tom Benedict wrote: > Dani Beaubien writes: >> >> I use the external git client for diffs against historical commits and I use >> the >> Code Analysis component for diffs between what is in the 4D structure >> compares against the last export to the external folder.

Re: Help->v11 to v17 Upgrade or New?

Dani Beaubien writes: > >I use the external git client for diffs against historical commits and I use >the >Code Analysis component for diffs between what is in the 4D structure >compares against the last export to the external folder. We did a similar thing based on Thomas Maul's MethodHistory c

Re: Help->v11 to v17 Upgrade or New?

4D Tech mailing list wrote > I am not uploading directly from 4D. I thought about implementing that but > decided against it since 4D is going that direction them selves. Waiting > to see what they come up with. I understood the same from teh Summit. Anyway, there is an existing module in QS_Tool

Re: Help->v11 to v17 Upgrade or New?

Folks, I would like to suggest you (if you haven’t already) check out a paid product from the Foundation Shell App Store by Robert Livingston for a 4D database solution to storing the text from all your methods and object methods automatically. ArchiveMethod

Re: Help->v11 to v17 Upgrade or New?

I am not uploading directly from 4D. I thought about implementing that but decided against it since 4D is going that direction them selves. Waiting to see what they come up with. My workflow is to use the Code Analysis component to export all my code, 4D Structure and form properties (gathered

Re: Help->v11 to v17 Upgrade or New?

Robert, What I was dropping not-so-subtle hints about is working out the interface for the GitHub API, which I found - unwelcoming, to support exporting directly to GitHub from 4D and allowing me to pull from it as well. All the tools for this are already in 4D, it's just a matter of working out th

Re: Help->v11 to v17 Upgrade or New?

Kirk, I think any mechanism that can export 4D code as text (plain text, JSON, XML, etc) can be used via GitHub to at least manage method changes. So, with the new v17r3 we have a native way to share the entire structure which will allow us to use version control. However, the limitations seem t

Re: Help->v11 to v17 Upgrade or New?

Hi Kirk, 4D Tech mailing list wrote > Did I just hear you say something about uploading direct from 4D into > GitHub... 🙄 It is not what I understood. He used GitHub to manage his version. But, if you're right, I'm also very interested by this ;-) - Patrick EMANUEL ---

Re: Help->v11 to v17 Upgrade or New?

Dani, On Fri, Oct 19, 2018 at 8:22 AM Dani Beaubien via 4D_Tech < 4d_tech@lists.4d.com> wrote: > I have been using GitHub to track changes on the exported code. I have > projects that go back years that are in GitHub. Did I just hear you say something about uploading direct from 4D into GitHub..

Re: Help->v11 to v17 Upgrade or New?

In this situation, I use Code Analysis is to find out what code has changed due to the upgrade to a newer version of 4D. Here is an example. I am moving a structure from v16 to v17 and I want to know all the changes that occur. In v16, I use the Code Analysis component to export all the methods.

Re: Help->v11 to v17 Upgrade or New?

About QS_Toolbox, the one I really know, there is a bunch of tools in the Structure Analysis part. It works from V15 to V17, but nothing has been added since V16R6. QS_Toolbox performed very few update for you. Its goal is to identify wha

Re: Help->v11 to v17 Upgrade or New?

Patrick or Dani, how might your tool help identify what needs to change? R Sent from my iPhone > On Oct 19, 2018, at 2:09 AM, Patrick Emanuel via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > Some tools can help you like QS_Toolbox from me or CodeAnalysis from Dani > Beaubien for example, and th

Re: Help->v11 to v17 Upgrade or New?

4D Tech mailing list wrote > So, there are more than 700 lines of code with the deprecated “_o_” > prefix. Perhaps I could make a lot of that go away via Search/Replace (a > feature that I normally don’t use). Some tools can help you like QS_Toolbox from me or CodeAnalysis from Dani Beaubien for e

Re: Help->v11 to v17 Upgrade or New?

It was Dani! Yeah, 4D is awesome at this stuff. We get upgrades old, old versions all the time and our current structure just opens these old data files, and 4d does its magic to uid them, unicode them, de'subtable them. no problem. > On Oct 18, 2018, at 2:19 PM, Robert ListMail via 4D_Tec

Re: Help->v11 to v17 Upgrade or New?

Okay, I can’t find it now but someone said, "hey pop it into v17 and see if it works…" or something like that. Well, I did just that and without any changes it compiled (after toggling unicode on) and I created a built server and client and ran a few tests. Yes, as I recall, I did fix all of the

Re: Help->v11 to v17 Upgrade or New?

Robert, I am just taking on a project for a similar situation: v11 to v17. I haven't had a chance to really dive into the code yet so I'm not really sure what's there but at this point the client's intention is to essentially keep the database on 'palliative care' for the next 1 to 2 years when the

Re: Help->v11 to v17 Upgrade or New?

> Le 17 oct. 2018 à 21:45, Robert ListMail via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > [...] > > Also, the client originally said the new database would not have to migrate > data forward from the old system and now they are wanting to have the data > too. Most of the I write the new

RE: Help->v11 to v17 Upgrade or New?

If in doubt I would vote for a rewrite, even more if the old application is poor designed. We struggle from time to time with problems caused by using legacy 4D code. E.g. sometimes there were assumptions made in the past regarding performance they are nowadays simply wrong and are causing now

Re: Help->v11 to v17 Upgrade or New?

sdale > via 4D_Tech > Sent: Wednesday, October 17, 2018 1:11 PM > To: 4D iNug Technical <4d_tech@lists.4d.com> > Cc: Spencer Hinsdale > Subject: Re: Help->v11 to v17 Upgrade or New? > > > 4D automatically converts Subtables. This should not be a problem. > **

Re: Help->v11 to v17 Upgrade or New?

At some point, v18(?), 4D will completely drop support for subtables. as I understand: a simple conversion to the current version will allow all the functions of existing subtables to continue working -- without -- any change to code. As noted by Tim Penner, but typo-ed :), this applies to a SIN

RE: Help->v11 to v17 Upgrade or New?

> The rest of the conversion needs to be done by the developer and consists of > replacing the subtable commands and redrawing the relationship line. This is > not automatic. See more here: http://livedoc.4d.com/4Dv17/help/Title/en/page3607.html#1693868 What we mean by “change the code everywh

RE: Help->v11 to v17 Upgrade or New?

ts.4d.com> Cc: Spencer Hinsdale Subject: Re: Help->v11 to v17 Upgrade or New? 4D automatically converts Subtables. This should not be a problem. ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html

Re: Help->v11 to v17 Upgrade or New?

4D automatically converts Subtables. This should not be a problem. > On Oct 17, 2018, at 12:45 PM, Robert ListMail via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > I have an old v11 database running on Windows that’s not particularly > well-designed and where there are more than a few subtables

Re: Help->v11 to v17 Upgrade or New?

This is a very hard question to give any advice on. There are a lot of factors that could affect the decision. Things to consider: - Complexity of the structure (# of tables, forms, methods, etc) - Are there any old style 4D extensions used? - Are there any plugins that are no longer supported? -

Re: Help?

You can skip the on startup code via a 4dlink file as described here: http://kb.4d.com/assetid=76553 -Tim Sent from my Verizon, Samsung Galaxy smartphone Original message From: Kenneth Geiger via 4D_Tech <4d_tech@lists.4d.com> Date: 9/10/18 4:55 PM (GMT-08:00) To: 4D iNug

Re: Help?

Ken: This is why with ALL our code, we have right near the very beginning of our code the following: If(Caps Lock Down) Trace End if Of course this does not work in compiled mode. Many many years ago I learned the lesson like you did. This is now standard code. Jody > On Sep 10, 2018, at 8:

Re: Help?

Hi Randy, Ingo, & Tim, Thanks for your suggestions. I’ve recovered from my faux pax and have added the “Trace” back-door to all of my projects. Again, thanks much!!! Ken Sent from my iPhone > On Sep 11, 2018, at 5:45 AM, Tim Nevels via 4D_Tech <4d_tech@lists.4d.com> > wrote: > >> On Sep 11

RE: Help?

On Sep 11, 2018, at 2:29 AM, Randy Engle wrote: > Started my app, held down alt key. > Dialog: Open Data File > Click OK > "Immediately" held down Shift-ALT-Right Mouse > Selected "Application Process" to trace > > Hit trace in first line of code on ON STARTUP Method.This is the first 3 > line

Re: Help?

One of the first code lines in the "On Startup" of every project is the method "TRACE_": //PM: TRACE_ //Erstellt am 09.03.2000 um 16:10:44 Uhr von IngoWolf If (Not(Is compiled mode)) If ((Shift down) & (Macintosh control down | Windows Ctrl down)) TRACE End i

Re: Help?

Hi Randy, After many tries, the dialog to select the process to trace just disappears too fast. Fortunately, I been blessed (cursed) with almost total recall so I’ve just about completed re-coding what I lost. Thanks again, Ken > On Sep 10, 2018, at 6:53 PM, Randy Engle via 4D_Tech <4d_tech@

Re: Help?

Hi Randy, When I do this, I do see the small window to select a process to trace…but, it goes away almost instantly. I’ll try a while longer. Thanks anyway, Ken > On Sep 10, 2018, at 6:53 PM, Randy Engle via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Ken, > > I just tested this. > > FYI

RE: Help?

Ken, I just tested this. FYI, I'm using Windows 4D v16r6 Started my app, held down alt key. Dialog: Open Data File Click OK "Immediately" held down Shift-ALT-Right Mouse Selected "Application Process" to trace Hit trace in first line of code on ON STARTUP Method. Let me know if this works Ra

Re: Help?

No. I put an “Open Window” in a method that runs at startup (not in the “OnStartup” Method). This window opens on top of the app and I then need to quit the app using Task Manager. Not a huge deal - only about 4-hours down the tube. > On Sep 10, 2018, at 6:24 PM, Randy Engle via 4D_Tech <4d_tec

RE: Help?

Did you do something to make it open in "compiled mode" Randy Engle -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Kenneth Geiger via 4D_Tech Sent: Monday, September 10, 2018 4:57 PM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Kenneth Geiger Subject:

RE: Help please - Compiling

Hi Chip, You declare the longint var as "$sze", then use "$Size" which is undeclared. As far as the error on the sort array, the ascending operator is optional and is the default value anyway, omitting it does compile without an issue. However, if you need the sort to be Descending, this workar

Re: Help please - Compiling

Hi Chip, I"m using v17HF1 and it does not compile on the last sort. This does: C_POINTER($1;$Handle) C_TEXT($formula) C_LONGINT($i;$2;$Sort_Column;$3;$Direction;$Sze) $Handle:=$1 $Direction:=$2 $Sort_Column:=$3 `errutl_Start $Sze:=Size of array($Handle->) C_Pointer($a;$b;$c) If ($Si

Re: Help please - Compiling

Hi Chip, Typo? $Sze:=Size of array($Handle->) If ($Size<=12) $Sze is defined, $Size not. HTH Koen > Op 17 aug. 2018, om 17:18 heeft Chip Scheide via 4D_Tech > <4d_tech@lists.4d.com> het volgende geschreven: > > $Sze:=Size of array($Handle->) > > If ($Size<=12) Compa

Re: Help with SQL login

Chuck Re: SQL LOGIN(“IP:ipaddress:port:ssl”;"user”;"Userpassword";*) That did it. Thanks! Steve > On 9 May 2018, at 21:50, Charles Miller via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Try adding the port to ip address and I always connect using IP not DB so > connection would look like 19

Re: Help with SQL login

Try adding the port to ip address and I always connect using IP not DB so connection would look like 192.168.5.12:19812 Regards Chuck On Wed, May 9, 2018 at 4:47 PM, Stephen Shaw via 4D_Tech < 4d_tech@lists.4d.com> wrote: > > > Chuck > > Thanks for answering > > SQL is running and shows the a

Re: Help with SQL login

Chuck Thanks for answering SQL is running and shows the active connection when the code is run from the client I have just copied the code to a single user database and I am on the same network and subnet Steve > On 9 May 2018, at 21:24, Chuck Miller via 4D_Tech <4d_tech@lists.4d.com> > w

Re: Help with SQL login

Are you sure that 1. SQL server is running 2. you are trying to connect to same place Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064 mailto:cjm

Re: Help with Regex

Fair point, if you’re sure there will always be six digits. \d{6} will work, too. Jeremy Roussak j...@mac.com > On 30 May 2017, at 00:19, Robert Livingston wrote: > > JR's solution works Some would argue that more specifically alluding to the > six digits is more robust in case some slig

Re: Help with Regex

JR's solution works Some would argue that more specifically alluding to the six digits is more robust in case some slightly mis-titled file exists. Therefore ^SP_\d\d\d\d\d\d ^SP_INS_\d\d\d\d\d\d iPhone RRL > On May 29, 2017, at 11:45 AM, Jeremy Roussak via 4D_Tech > <4d_tech@lists.4d.com

Re: Help with Regex

On May 29, 2017, at 9:00 PM, Jeremy Roussak wrote: > “SP_[0-9]*” will match the first lot, and “SP_INS_[0-9]*” will match the rest. > > But it might be quicker to do the second batch first, matching the names > simply to “SP_INS_@“ and removing them from the list when they’re done, then > re-sc

Re: Help with Regex

Tim - > On May 29, 2017, at 3:00 PM, 4d_tech-requ...@lists.4d.com wrote: > > Subject: Help with Regex If you have flexibility to process file names on Mac & outside of 4D… http://renamer.com David Eddy Babson Park, MA ***

Re: Help with Regex

On Mon, May 29, 2017 at 8:29 PM, Tim Nevels via 4D_Tech < 4d_tech@lists.4d.com> wrote: > $regexPattern_t:="what do I put here" > with a timi little bit of playing, $regexPattern_t:="SP_(\\D{3}|)(?>_|)(\\d{2})(\\d{2})(\\d{2})" catches prefix (INS) without "_". -- Peter Bozek *

Re: Help with Regex

On Mon, May 29, 2017 at 8:29 PM, Tim Nevels via 4D_Tech < 4d_tech@lists.4d.com> wrote: > $regexPattern_t:="what do I put here" > Tim, Try SP_(\D{3}_|)(\d{2})(\d{2})(\d{2}) with properly escaped backslashes, it means regexPattern_t:="SP_(\\D{3}_|)(\\d{2})(\\d{2})(\\d{2})" This should catch for

Re: Help with Regex

Tim, “SP_[0-9]*” will match the first lot, and “SP_INS_[0-9]*” will match the rest. But it might be quicker to do the second batch first, matching the names simply to “SP_INS_@“ and removing them from the list when they’re done, then re-scanning for “SP_@“ to do the rest. Just a thought. Regula

Re: Help needed with php script to zip files SOLVED, with working example

Hi All, I was able to solve the problem I was having yesterday to zip an array of files using a call to a php script. Here is an example you can use. Enjoy! Michael If (False) // METHOD: Php_ZipFiles // AUTHOR: MFERGUSON WITH BIG HELP FROM DAVID WALSH'S PHP SCRIPT // COMMENTS: TAKES