Re: QuickBooks / PowerShell Question for John Baughman
Ken: Agreed. John was a good egg. -- Douglas von Roeder 949-910-4084 On Sun, Mar 5, 2023 at 7:46 PM Ken Eyring via 4D_Tech <4d_tech@lists.4d.com> wrote: > I am so sorry to hear that. John was a really nice person, always very > helpful. > > Thank you for letting me know. > > Ken > > > > On 03/05/23 5:03 PM, Douglas von Roeder via 4D_Tech wrote: > > Ken: > > > > John passed away > > < > https://www.dignitymemorial.com/obituaries/kaneohe-hi/john-baughman-10298943 > > > > a few years ago. > > > > -- > > Douglas von Roeder > > 949-910-4084 > > > > > > On Sun, Mar 5, 2023 at 9:47 AM Ken Eyring via 4D_Tech < > 4d_tech@lists.4d.com> > > wrote: > > > >> A couple of years ago, John Baughman provided me with some code that > >> replaced Myles Wakeman's QuickBooks 4D plugin. I got it to work in my > >> office environment, but when I finally went to deploy the new code at my > >> customer's location - I received an error that appears to be related to > >> PowerShell - which his code is dependent upon. > >> > >> I tried to reach out to John directly, but an email to his previous > >> email address was rejected. Does anyone know how I can get a hold of > him? > >> > >> Thanks, > >> Ken > >> ** > >> 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: QuickBooks / PowerShell Question for John Baughman
Ken: John passed away <https://www.dignitymemorial.com/obituaries/kaneohe-hi/john-baughman-10298943> a few years ago. -- Douglas von Roeder 949-910-4084 On Sun, Mar 5, 2023 at 9:47 AM Ken Eyring via 4D_Tech <4d_tech@lists.4d.com> wrote: > A couple of years ago, John Baughman provided me with some code that > replaced Myles Wakeman's QuickBooks 4D plugin. I got it to work in my > office environment, but when I finally went to deploy the new code at my > customer's location - I received an error that appears to be related to > PowerShell - which his code is dependent upon. > > I tried to reach out to John directly, but an email to his previous > email address was rejected. Does anyone know how I can get a hold of him? > > Thanks, > Ken > ** > 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: Calculate values of arrays...
"> Finally, the reason I need to drop this list forever. Sajonara." *Definitely* not from "How to win friends and influence people". -- Douglas von Roeder 949-910-4084 On Mon, Nov 1, 2021 at 2:07 PM Jörg Knebel via 4D_Tech <4d_tech@lists.4d.com> wrote: > > > > On 02 /11 /2021, at 07:23, THOMAS BENEDICT via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > > > > Finally, the reason I need to drop this list forever. > > Sajonara. > ** > 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: Calculate values of arrays...
Jorg: At times, some of your replies come across as "perhaps having been put a different way" and, of course, this is coming from someone who falls in the exact same category. Overall, however, I don't find them offensive in the least. -- Douglas von Roeder 949-910-4084 On Mon, Nov 1, 2021 at 2:06 PM Jörg Knebel via 4D_Tech <4d_tech@lists.4d.com> wrote: > > > > On 02 /11 /2021, at 07:14, Jörg Knebel via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > > > Hi All, > > > >> On 02 /11 /2021, at 07:09, Douglas von Roeder via 4D_Tech < > 4d_tech@lists.4d.com <mailto:4d_tech@lists.4d.com>> wrote: > >> > >> Perhaps the best approach would be for you to try the command and see if > >> you get the desired result. > > > > I’m sorry guys, it was just to late yesterday… > > … and I haven’t had my first coffee yet meaning I’m still in > Self-Devence-Mode… ;-) > > ** > 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: Calculate values of arrays...
There's no difference in how an array is populated - it's a list of values in memory. Perhaps the best approach would be for you to try the command and see if you get the desired result. -- Douglas von Roeder 949-910-4084 On Mon, Nov 1, 2021 at 1:02 PM Jörg Knebel via 4D_Tech <4d_tech@lists.4d.com> wrote: > > > > On 02 /11 /2021, at 06:57, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > > >>> You do know what an ARRAY is? > > Did you go look at the page? > > > You sure it works with ARRAYs NOT filled by a selection? > > ** > 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: Search & menu questions
4D has supported cross table queries since the introduction of the SQL
engine in V11.
Given a table of sales reps ("Managers") and a Territories table (not my
table name convention) that have a many to many table ManagerToTerritory,
the following code will find the territories for a given manager:
QUERY([Territories]; [Managers]ID=$managerID_T)
You can also use Query by formula. That command is very flexible and very
fast. Paraphrasing Thomas Maul on the Forum some years ago, you should be
using QbF if your search has two or more clauses.
The syntax is very SQL-like:
QUERY BY FORMULA([Proposals]; ([Proposals]ID=[Line_Items]Proposal_ID) &
(([Line_Items]Product_Code=$productCode_T)))
QUERY BY FORMULA([Proposals]; ([Documents]Tablenumber=22) &
([Documents]Record_ID=[Proposals]ID))
Add code like this to see how 4D is handling the query:
DESCRIBE QUERY EXECUTION(True)
*QRY_QueryPlanToClipboard*
DESCRIBE QUERY EXECUTION(False)
The code for *QRY_QueryPlanToClipboard*
//
//User name (OS): dvonroeder
//Date and time: 08/21/14, 17:01:30
//
//Method: QRY_QueryPlanToClipboard
//
C_TEXT($plan_T; $path_T)
$plan_T:="Query Plan"+Char(13)+Get last query plan(Description in text
format)
$path_T:="Query Path"+Char(13)+Get last query path(Description in text
format)
SET TEXT TO PASTEBOARD($plan_T+Char(13)+Char(13)+$path_T)
--
Douglas von Roeder
949-910-4084
On Sat, Oct 30, 2021 at 12:20 AM Jörg Knebel via 4D_Tech <
4d_tech@lists.4d.com> wrote:
>
>
> > On 29 /10 /2021, at 10:24, Stephane Potvin via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> >
> > Main table is client information, linked table for services provided.
>
> Beside the super duper modern cool way to get a result what about the
> solid old way:
>
> $DateServiced:=Add to date(current date(*);-1;0;0) // or value entered by
> a user
>
> QUERY ([Services]LastServicedDate<=$DateServiced)
> RELATE ONE SELECTION([Services];[Clients])
>
> Your description about the menus is a knew one to me - sorry.
>
> HTH
>
> Cheers
> Jörg
> **
> 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: Calculated column in ALP v9 [SOLVED]
David: You're welcome. There's a lot in ALP now — wait till you see V11. :-) -- Douglas von Roeder 949-910-4084 On Wed, Oct 20, 2021 at 12:21 PM David Rose via 4D_Tech < 4d_tech@lists.4d.com> wrote: > That's it! Thanks, Doug. > --- > I use the ALP 9.9.5 docs in PDF format. Look at the command > "AL_AddCalculatedColumn" > and then click the link on that page to get to "Calculated columns" > Douglas von Roeder > > > ** > 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: Calculated column in ALP v9
David:
I use the ALP 9.9.5 docs in PDF format. Look at the command
"AL_AddCalculatedColumn"
and then click the link on that page to get to "Calculated columns"
--
Douglas von Roeder
949-910-4084
On Tue, Oct 19, 2021 at 1:15 PM David Rose via 4D_Tech <4d_tech@lists.4d.com>
wrote:
> I am converting some older ALP code in a v17 database to the modern code.
> In the old code, if you have an area that is displaying fields, and you
> have a calculated column you would do this:
>
> $Error:=AL_SetFields ($Area_l;$TableNumber_i;4;1;0) //specifies the col
> as a calculated one
>
> Then this:
> AL_SetCalcCall ($Area_l;4;"MyCalcCallMethod")
>
> In the new code we set the fields like this:
>
> ARRAY POINTER(aPtr;4)
> aPtr{1}:=->[Vendors]ID
> aPtr{2}:=->[Vendors]Last_Name
> aPtr{3}:=->[Vendors]First_Name
> aPtr{4}:=?? (see below)
>
> $err:=AL_SetObjects ($Area_l;ALP_Object_Columns;aPtr)
>
> And the callback method like this:
> AL_SetColumnTextProperty ($Area_l;4;ALP_Column_Callback;"MyCalcCallMethod
> ")
>
> I didn't see in the docs what you assign to the aPtr array element for the
> calculated column. If I size the aPtr array to 3, then set a callback
> method for column 4, I get an error.
> Ditto if I size the array to 4 but don't assign anything to the 4th
> element.
>
> Pls advise.
> TIA,
> David
>
> **
> 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: STRANGE LIST BOX MESSAGES 4d WIEV PRO LICENCE REQUIRED
IIRC, that feature was made available in list boxes as one of a series of enhancements that were added from 4D View Pro. [time passes - Google does its thing] It was in a blog posting - https://blog.4d.com/pro-list-box-features-are-now-free/ -- Douglas von Roeder 949-910-4084 On Tue, Oct 19, 2021 at 1:14 AM stardata.info via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Solved. > > The issue appares when un listbox settings the option " Automatic Row > Height " is active. > > Thanks > > Ferdinando > > Il 18/10/2021 21:00, 4d_tech-requ...@lists.4d.com ha scritto: > > Hi All, > > > > I use 4D V16 on window. > > > > In one layout, i use two list box one based on records selection and > > anoter based on arrays > > > > In 4D Server if in the listbox based on array, when i insert one row in > > the 5 arrays contained in the list box, i have a red message in the list > > box area with this message " 4d wIEV PRO LICENCE REQUIRED " > > > > The same in stand alone application work well. > > > > Someone know solutions? > > > > 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: Compiled Structure does not Match Data
The WEDD was a stretch - I know it officially went away but I've seen anomalies in structure files from waay back. "the structure file is itself a database and "Resources" is one of its internal tables. the error is effectively saying that the structure file can not be modified." Thanks for clarifying that. I'm the lucky stiff that had a corrupted table and, when I contacted TS they had to do some research on that. Of course, it does make sense that 4D would have to have its own database internally but let's not kid ourselves - we all know that what happens inside 4D is actually magic. :-) -- Douglas von Roeder 949-910-4084 On Tue, Oct 5, 2021 at 6:09 PM Keisuke Miyako via 4D_Tech < 4d_tech@lists.4d.com> wrote: > The structure and data files do not correspond to each other. The data > file cannot be opened with this structure." > That's a holdover from when 4D used the "WEDD" resource but that went away > after 2004. > > the WEDD resource was indeed a token that was used to match a structure > file to a data file, > by default it was empty but it could be edited with 4D Customizer Plus. > a UUID is used since v11 as an internal signature to check that the data > file corresponds to the structure file. > > the structure file is itself a database and "Resources" is one of its > internal tables. > the error is effectively saying that the structure file can not be > modified. > ** > 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: Compiled Structure does not Match Data
Peter: "The structure and data files do not correspond to each other. The data file cannot be opened with this structure." That's a holdover from when 4D used the "WEDD" resource but that went away after 2004 (?). [time passes] Yup, mind like a steel trap <https://www.mail-archive.com/4d_tech@lists.4d.com/msg15520.html>…rusty. ;-) "Cannot delete record in table Resources of Database…" Do you have a table named "Resources"? -- Douglas von Roeder 949-910-4084 On Tue, Oct 5, 2021 at 3:53 PM Peter Adam via 4D_Tech <4d_tech@lists.4d.com> wrote: > I apolitically;ogise for asking a question related to v13 but my client > has been tardy in accepting an upgrade. > > However before making the move I have had to make some changes to the v13 > DB and something that has been modified without issue for many years now > is failing when I compile and merge it. > > I compile and merge the structure with its datafile, no problems reported. > > I then launch the compiled server point it at the datafile that has just > been used in the compiling process and i get the message > The structure and data files do not correspond to each other. The data > file cannot be opened with this structure. > > > When I click the close button on the dialog, I then get an error dialog, > Cannot delete record in table Resources of Database… > > and the details list a lot of Cannot save record… and the key line seems > to be Wrong header. > > All this is happening on Windows 10. > > Suggestions? > > > > > Cheers, > > Peter Adam > Adam, Zievert & Associates P/L > > e: peter.a...@me.com > Skype Phone: +61 3 9016 379 > t: +61 3 9836 3539 > m: 0419 552 462 > www.adamzievert.com.au > > > > ** > 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: "Search References" Behavior Change
Dave: I'm using 18R6 and am seeing the same behavior. I don't know how to change it so I need to find where a project method is called, I use Find in design. Another unexpected behavior is to Ctrl/Cmd - K when a member function is selected. Instead of displaying the method, 4D does a Find in design. My work around is to put the member function next to it as a comment. $proc_O.*PROCO_CallForm*() //PROCO_CallForm Two steps forward, one step back. "old behavio*u*r back?" - so you're drinking warm beer now? ;-) -- Douglas von Roeder 949-910-4084 On Mon, Sep 13, 2021 at 11:47 AM Dave Nasralla via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Hey all, > > In the past, I would right-click a method name and select "Search > References" and I would get a list of literal references to that exact > method. Now, when I do that, I get more of a text search of the > database. > > For example: If I right click on the method name "Post_Data", I'll get > hits for: > - WS_Post_Data > - \\ Post_Data is a method for doing > - UT_Post_Data_Method3 > > Has anyone else seen this? Is there a way to get the old behaviour back? > > Thanks, > > dave > > -- > David Nasralla > Clean Air Engineering > ** > 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: Plugin XLS II issues (maybe ? )
Ernie: If that's version 1.0 of the plugin and you've gone from 32 bit to 64 bit, that could be the issue. The current version of the plugin is 1.1.2 - try downloading the newer version. Or, if you're using 64 bit V17, try switching to a 32 bit version and see if it clears up. The error message *is* strange, no question. -- Douglas von Roeder 949-910-4084 On Mon, Aug 2, 2021 at 8:20 PM eachilgers via 4D_Tech <4d_tech@lists.4d.com> wrote: > Hi all, > 4D v17.5 mac/pc > I use for 3 simple spreadsheet creation in a program that is upgraded from > V15 to v17 the plugin XLS II.bundle. > Yes I know this is possible with v17R series but I have not dedicated time > and effort to switch to 4D View Pro. (coming from 4D view v13-v15) > > Last week I start getting the error message and I have no idea what to do > with this: > > The executable could not be loaded. > > License or privilege error (XLS II (1.0)) > > > Can anybody inform me how to solve this. > At the beginning of the year I had no problems. > > ernie hilgers(aruba) > ** > 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: OK to Run 4D V13.5 on Windows 2016?
Justin: Glad to hear that it's a good combination. The production server lasted 8 years and failed a couple of weeks ago so 13.5 is now running on a Win 7 machine. Moving to a 2016 Server on a VM is a much better solution! Thank you for your reply. -- Douglas von Roeder 949-910-4084 On Wed, Jul 14, 2021 at 5:27 PM Justin Will wrote: > I've been running a fairly large 13.6 system on Win 2016 for about a year > without issue. > > Thanks > Justin Will > ** 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: OK to Run 4D V13.5 on Windows 2016?
Randy: Thanks for the laugh…and the info! -- Douglas von Roeder 949-910-4084 On Wed, Jul 14, 2021 at 11:55 AM Randy Engle wrote: > Douglas > > My steel trap memory suggests that combination was used a lot by our > customers > > Randy > > > Sent from my iPad > > > On Jul 14, 2021, at 11:25 AM, Douglas von Roeder via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > > > > A V13.5 application needs to be moved from its current machine and a VM > > that’s running Windows Server 2016 is available. > > > > I’d appreciate hearing from developers who used that combination - is > V13.5 > > compatible with Windows 2016 Server? > > > > Thanks. > > > > -- > > Douglas von Roeder > > 949-910-4084 > > ** > > 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 **
OK to Run 4D V13.5 on Windows 2016?
A V13.5 application needs to be moved from its current machine and a VM that’s running Windows Server 2016 is available. I’d appreciate hearing from developers who used that combination - is V13.5 compatible with Windows 2016 Server? Thanks. -- Douglas von Roeder 949-910-4084 ** 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 scanning
Milan: Thank you for correcting me on this. I haven't used Miyako's plugin but I have used QPix a few times over the years and it's an excellent product. -- Douglas von Roeder 949-910-4084 On Fri, Jun 18, 2021 at 2:16 AM Milan Adamov via 4D_Tech < 4d_tech@lists.4d.com> wrote: > > > > On 17 Jun 2021, at 19:04, Douglas von Roeder via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > > > > I checked escape.gr <http://escape.gr/> and hmplugins.com < > http://hmplugins.com/> for their scanner/TWAIN plugins and > > it looks like those products aren't available any longer. > > > Dannis and Christos moved the company to Bulgaria (they still live in > Greece), as I can see Q2Pix can work with scanners: > > https://escapetech.eu/q/q2pix.html > > Milan > > ** > 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: 4D scanning
Peter: I checked escape.gr and hmplugins.com for their scanner/TWAIN plugins and it looks like those products aren't available any longer. If you search for "miyako" at Github you'll get a list of his repositories. -- Douglas von Roeder 949-910-4084 On Thu, Jun 17, 2021 at 8:55 AM Peter Mew via 4D_Tech <4d_tech@lists.4d.com> wrote: > Hi > I havent done any of this for a while so Im a bit! rusty. > I looking to download Miyakos twain plug in, Where do I find it? or is > there a better plugin that will capture scans and work with 4D v13 mac and > PC preferably free > thanks > -pm > ** > 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: Base64 Image
Randy: "I find that it’s harder to find issues on the forum. There’s only a few listed at a time and you have to scroll around or search." Good point. The software does *some* searching for you in that it lists message threads that it thinks are similar but it seems that the old Forum had better search functionality. I don't use the search features much. The big win for me on the new forum was attachments. "Both have their values, but I will keep watching and responding here." Agree completely. -- Douglas von Roeder 949-910-4084 On Fri, Jun 4, 2021 at 11:32 AM Randy Kaempen wrote: > Doug, > > On Jun 4, 2021, at 12:55 PM, Douglas von Roeder > wrote: > > I don't see it that way at all. I think the new Forum is valuable and a > significant improvement over the previous forum. I'm glad that there are > multiple places where people discuss 4D. > > > I find that it’s harder to find issues on the forum. There’s only a few > listed at a time and you have to scroll around or search. > > The nice thing about the email list is that the issues show up as they > happen. They are current issues and sometimes pressing ones. You don’t > have to search for anything. > > Both have their values, but I will keep watching and responding here. > > > Randy Kaempen > Intellex Corporation > > ** 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: Base64 Image
Randy: I don't see it that way at all. I think the new Forum is valuable and a significant improvement over the previous forum. I'm glad that there are multiple places where people discuss 4D. -- Douglas von Roeder 949-910-4084 On Fri, Jun 4, 2021 at 9:59 AM Randy Kaempen via 4D_Tech < 4d_tech@lists.4d.com> wrote: > I agree guys. I don’t think the new forum is a useful. > > I’m still here. :-) > > > Randy Kaempen > Intellex Corporation > > ** > 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: 4D Server
Miguel: "I've got a 4D server using 100% of the CPU even though I've restricted it to use a minimum CPU through the database parameters." Laurent Esnault has stated in at least one Summit that the sliders for that setting do not function. Even though you're using a command, not the GUI, it would not surprise me if the Set database parameter for that function is also INOP. "Any Ideas on why 4D Server went wild?" What values display in the Processes tab? -- Douglas von Roeder 949-910-4084 On Wed, Apr 28, 2021 at 7:52 AM Miguel Gonzalez via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Hello there, > > I've got a 4D server using 100% of the CPU even though I've restricted > it to use a minimum CPU through the database parameters. > > The version is 12.6 and is running on Windows server 2016 and 2019. > I know that they are not compatible but this has been running normally > for a long time and the problem arose about two weeks ago on a Friday. > The same problem appears in two different installations. > If you look at the processes running noone is doing it 100% or near that. > > Any Ideas on why 4D Server went wild? > > > Thank you for any thoughts. > > -- > Miguel Gonzalez > AcuBase Ltd. > ** > 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 do you get a Vertical Splitter's Horizontal 'Move' Resizing Attribute to work?
Dave: There are a few moving pieces to this (pardon the pun). Create a rectangular text area, A and duplicate it to create text area B. Place them 20 pixels apart and align them vertically. Move them together so that A is 10 points from the left border of the form. A is set to grow horizontally B is set to move horizontally Create a splitter "splitter" that is 5 points wide. Splitter lies vertically between A and B and is set to grow horizontally. Place a Cancel or OK button below the bottom of the text area and place the left margin of the button 80 pixels from the left margin of the form. Locating the button there will leave a blank area that will allow B to move. Run the form. -- Douglas von Roeder 949-910-4084 On Wed, Apr 28, 2021 at 9:54 AM Dave Nasralla via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Hey All, > > Maybe you can't do this, but imagine you have two text boxes side by > side with a vertical splitter between them. When pull the window > wider, I'd like the text box on the left to grow, and the splitter and > text box on the right to move. > > (If I have only a vertical on a form with the Horizontal Resizing > option set to Move - it just won't! If I set the Vertical Resizing > option to Move to moves just fine up and down. Side to side seems to > fail) > > I've tried on v17.4 and v18.4 on Mac. > > dave > > -- > David Nasralla > Clean Air Engineering > ** > 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: LDAP Implementation
Steve: Perhaps this will point you in the right direction - Tom Swenson wrote an LDAP component which was really handy prior to 4D building LDAP into 4D. When he posted a message here on the NUG in 11/19, his email address was - swen...@mit.edu -- Douglas von Roeder 949-910-4084 On Thu, Jan 21, 2021 at 12:52 PM Stephen J. Orth via 4D_Tech < 4d_tech@lists.4d.com> wrote: > We have a large customer who is asking us about SSO and using their LDAP > server to achieve this. Has anyone accomplished this, and if so, would be > willing to share any information? I know very little about LDAP and have > been doing as much reading as I can, but I’m sure there are smart ways to > accomplish this, and also not smart ways. > > I’m also looking for any insights, tips, etc…to save me from pulling out > what little hair I have remaining! > > Thanks in advance! > > Best, > > Steve > > * > Stephen J. Orth > The Aquila Group, Inc. Office: (608) 834-9213 > P.O. Box 690 Mobile: (608) 347-6447 > Sun Prairie, WI 53590 > > E-Mail: s.o...@the-aquila-group.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: Lost autocomplete for constants
Bob: Hello - good to hear from you. I hit the same issue when working with that very same version. The only thing I could do to "fix" the problem was to uncheck the three checkboxes in Preferences/Options/Suggestions, click OK to save the changes and then reset the checkboxes. Re. constants - a lot of developers use 4D Pop from the 4D website. We still can't create constants using the server so I just update the file by hand. Below is a stub of the file. In BBEdit, I save it as an XML file, UTF-8 Unicode file with BOM using Windows (CRLF). http://www.4d.com/d4-ns;> 13.2 (30) __Contact_Type __Query CONTACTTYPE_Administrative CONTACTTYPE_Equipment CONTACTTYPE_Primary CONTACTTYPE_Mechanical QUERY_Selection QUERY_Table -- Douglas von Roeder 949-910-4084 On Mon, Jan 18, 2021 at 11:34 AM Bob Finnerty via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Hi Folks > > Using 4D 18 r4 windows. Working great until recently; then suddenly lost > the ability to autocomplete constants - both 4D and custom - in the method > editor. Commands, methods & macros still autocomplete. Constants tokenize > properly when full name entered. > > Any idea what's up & how to fix? > > And BTW, anyone point me to the xlf definition for a constants file (or > have a blank)? > > Thanks loads > > -- > Bob Finnerty > *Exodus Software* > ** > 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: Designer Password Question
Ken: Chuck pointed out that you didn't have access as designer (I just skimmed the email yesterday), rather you have access "to the design environment". The empty U file is worth a try but as Thomas implies, perhaps there's no significant downside to leaving the current situation as is. I've been working on an application for almost 20 years for a programmer client and I don't log in as "designer". Until now, I've never even looked at U and I've discovered that I have zero access there. I do have full access to the code and forms and can even convert it to a project (I cancelled *that* operation) so, if you've got that level of access, perhaps "do nothing" is appropriate. -- Douglas von Roeder 949-910-4084 On Mon, Jan 18, 2021 at 9:54 AM Douglas von Roeder wrote: > Ken: > > You might be able to remove all users and groups by logging in as designer > and importing an empty users and groups file. > > -- > Douglas von Roeder > 949-910-4084 > > > On Sun, Jan 17, 2021 at 4:24 PM Kenneth Geiger via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > >> Hi All, >> >> I recently “inherited” a 4D v12 (Windows) database. The original >> developer has forgotten the Designer Password. But, fortunately, he had >> enabled the settings to allow the Administratror to access the design >> environment and the customer had that password. So, I’ve been able to make >> the changes that the customer wanted. But, I really hate to leave this >> system the way it is. My question is…is there a way to reset the Designer >> Password? Or, is there a way to delete ALL the passwords and start over? >> >> Regards, >> >> Ken Geiger >> SW Colorado >> ** >> 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: Designer Password Question
Ken: You might be able to remove all users and groups by logging in as designer and importing an empty users and groups file. -- Douglas von Roeder 949-910-4084 On Sun, Jan 17, 2021 at 4:24 PM Kenneth Geiger via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Hi All, > > I recently “inherited” a 4D v12 (Windows) database. The original developer > has forgotten the Designer Password. But, fortunately, he had enabled the > settings to allow the Administratror to access the design environment and > the customer had that password. So, I’ve been able to make the changes that > the customer wanted. But, I really hate to leave this system the way it is. > My question is…is there a way to reset the Designer Password? Or, is there > a way to delete ALL the passwords and start over? > > Regards, > > Ken Geiger > SW Colorado > ** > 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: Managing 4D Write Pro licenses
To resolve any confusion, "resource" = a "thing" not a "Resource" as in the Classic Mac OS. In this case, it's a license to use 4D WP. -- Douglas von Roeder 949-910-4084 On Wed, Jan 13, 2021 at 1:55 PM Douglas von Roeder wrote: > David: > > If only user group "X" has access to a resource, it would seem to be a bug > if someone not in that group could access that resource. > > Perhaps a call to 4D tech support could provide clarification. > > -- > Douglas von Roeder > 949-910-4084 > > > On Wed, Jan 13, 2021 at 1:39 PM David Rose via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > >> Douglas, >> Whether or not we restrict access to 4D Write via the method you >> suggested, the first user who logs on after a reboot grabs the 4D Write >> license whether that user actually uses 4D Write or not. >> David >> >> > Message: 12 >> > Date: Wed, 13 Jan 2021 10:37:32 -0800 >> > From: Douglas von Roeder >> > >> > David: >> > >> > While it's true that 4D WP is not a plugin, access to 4D WP is >> controlled in the same manner as the plugin — either on an individual user >> basis or by creating a group and granting access to that group. >> > >> > With that in mind, you might be able to either move the user into a >> group that has access to 4D WP with the Change current user command or move >> them into the "4DWP" group using Set user properties. >> > Douglas von Roeder >> > 949-910-4084 >> >> > On Wed, Jan 13, 2021 at 8:30 AM David Rose via 4D_Tech < >> 4d_tech@lists.4d.com> >> > wrote: >> >> > We have a 4D Server v17R6 database running in a Windows-only >> environment. >> > We have a single 4D Write Pro license. Only one out of our dozen or so >> > users uses 4D Write Pro. Now that 4D Write is no longer a plug-in, we >> > have a problem managing access to that license. When 4D Server is >> > launched, the first user to log in grabs the license. Is there any way >> to prevent this? >> > David Rose >> > >> >> >> ** >> 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: Managing 4D Write Pro licenses
David: If only user group "X" has access to a resource, it would seem to be a bug if someone not in that group could access that resource. Perhaps a call to 4D tech support could provide clarification. -- Douglas von Roeder 949-910-4084 On Wed, Jan 13, 2021 at 1:39 PM David Rose via 4D_Tech <4d_tech@lists.4d.com> wrote: > Douglas, > Whether or not we restrict access to 4D Write via the method you > suggested, the first user who logs on after a reboot grabs the 4D Write > license whether that user actually uses 4D Write or not. > David > > > Message: 12 > > Date: Wed, 13 Jan 2021 10:37:32 -0800 > > From: Douglas von Roeder > > > > David: > > > > While it's true that 4D WP is not a plugin, access to 4D WP is > controlled in the same manner as the plugin — either on an individual user > basis or by creating a group and granting access to that group. > > > > With that in mind, you might be able to either move the user into a > group that has access to 4D WP with the Change current user command or move > them into the "4DWP" group using Set user properties. > > Douglas von Roeder > > 949-910-4084 > > > On Wed, Jan 13, 2021 at 8:30 AM David Rose via 4D_Tech < > 4d_tech@lists.4d.com> > > wrote: > > > We have a 4D Server v17R6 database running in a Windows-only environment. > > We have a single 4D Write Pro license. Only one out of our dozen or so > > users uses 4D Write Pro. Now that 4D Write is no longer a plug-in, we > > have a problem managing access to that license. When 4D Server is > > launched, the first user to log in grabs the license. Is there any way > to prevent this? > > David Rose > > > > > ** > 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: Managing 4D Write Pro licenses
David: While it's true that 4D WP is not a plugin, access to 4D WP is controlled in the same manner as the plugin — either on an individual user basis or by creating a group and granting access to that group. With that in mind, you might be able to either move the user into a group that has access to 4D WP with the Change current user command or move them into the "4DWP" group using Set user properties. -- Douglas von Roeder 949-910-4084 On Wed, Jan 13, 2021 at 8:30 AM David Rose via 4D_Tech <4d_tech@lists.4d.com> wrote: > We have a 4D Server v17R6 database running in a Windows-only environment. > We have a single 4D Write Pro license. Only one out of our dozen or so > users uses 4D Write Pro. Now that 4D Write is no longer a plug-in, we have > a problem managing access to that license. When 4D Server is launched, the > first user to log in grabs the license. Is there any way to prevent this? > David Rose > > ** > 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
Ben: "4/4 in D flat, naturally." :-) -- Douglas von Roeder 949-910-4084 On Thu, Dec 10, 2020 at 1:06 PM Ben Kershaw via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Douglas von Roeder wrote: > > >One of our 4D musicians needs to make a blues song out of this. > > I play bass & piano, but haven’t written anything original. Maybe now’s > the time: > > “Record locking woes” > “My index dun left me” > “My old code got no Class” > “Everything seems OK” > > 4/4 in D flat, naturally. > > Hmmm… > > Regards, > Ben > ** > 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
One of our 4D musicians needs to make a blues song out of this. -- Douglas von Roeder 949-910-4084 On Wed, Dec 9, 2020 at 12: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: IP address problem
"This can't be multihoming as I only have one address" Understood. "So the question now is where does 4D get IP address to show on the server admin window?" If a computer has only one IP address, there's no need to create a UI to allow a user to select an IP address - it just shows up. That thought led my "inquiring minds want to know" mind to wonder - "How is multi-homing handled?" -- Douglas von Roeder 949-910-4084 On Thu, Jun 4, 2020 at 10:52 AM Charles Miller via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Hi All, > This can't be multihoming as I only have one address > > > On Thu, Jun 4, 2020 at 1:49 PM Douglas von Roeder via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > > > Chuck: > > > > Good question. How is multi-homing handled? > > > > The web server can listen on multiple IP addresses but I've never seen > > anything that discusses how the application/data server handles that. > > > > -- > > Douglas von Roeder > > 949-910-4084 > > > > > > On Thu, Jun 4, 2020 at 7:47 AM Chuck Miller via 4D_Tech < > > 4d_tech@lists.4d.com> wrote: > > > > > OK I guess some more info may help. It seems that if I have a server > that > > > I run at client with their IP address scheme and then run same > structure on > > > server in my office it shows as broadcasting on more than one IP > address. > > > So the question now is where does 4D get IP address to show on the > server > > > admin window? I think this might be part of the problem. I am going to > post > > > this on the new forum as well with some screen shots > > > > > > 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 Jun 4, 2020, at 7:20 AM, Chuck Miller via 4D_Tech < > > > 4d_tech@lists.4d.com> wrote: > > > > > > > > Thanks for input. I will address each below your response > > > > > > > > Sent from my iPhone > > > > > > > >> On Jun 4, 2020, at 1:44 AM, Chip Scheide <4d_o...@pghrepository.org > > > <mailto:4d_o...@pghrepository.org>> wrote: > > > >> > > > >> Chuck, > > > >> There are 2 ways to resolve this, and using both is probably best. > > > >> (following assumes DHCP) > > > >> > > > >> 1 - put a battery on the computer (server) so that when power goes > down > > > during tests the computer does not turn off. > > > >> 1a - if this is already the case (it should be if it is a server) > and > > > IP addresses are being changed on the server then there is a switch in > the > > > network who's battery has failed - and Enterprise IT should track it > and > > > fix it ( might need to enter a ticket) > > > >> > > > > There is a UPS. Indeed the machine and server never went down > > > > > > > > > > > >> 2 - talk with the IT/network people, give them the server's MAC ID > > > (network card ID) and request a fixed IP address server through DHCP > > > >> Notes on #2 : the network admin can assign a specified IP address > to a > > > specific MAC address, which is assigned via DHCP, then regardle
Re: IP address problem
Chuck: Good question. How is multi-homing handled? The web server can listen on multiple IP addresses but I've never seen anything that discusses how the application/data server handles that. -- Douglas von Roeder 949-910-4084 On Thu, Jun 4, 2020 at 7:47 AM Chuck Miller via 4D_Tech < 4d_tech@lists.4d.com> wrote: > OK I guess some more info may help. It seems that if I have a server that > I run at client with their IP address scheme and then run same structure on > server in my office it shows as broadcasting on more than one IP address. > So the question now is where does 4D get IP address to show on the server > admin window? I think this might be part of the problem. I am going to post > this on the new forum as well with some screen shots > > 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 Jun 4, 2020, at 7:20 AM, Chuck Miller via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > > > > Thanks for input. I will address each below your response > > > > Sent from my iPhone > > > >> On Jun 4, 2020, at 1:44 AM, Chip Scheide <4d_o...@pghrepository.org > <mailto:4d_o...@pghrepository.org>> wrote: > >> > >> Chuck, > >> There are 2 ways to resolve this, and using both is probably best. > >> (following assumes DHCP) > >> > >> 1 - put a battery on the computer (server) so that when power goes down > during tests the computer does not turn off. > >> 1a - if this is already the case (it should be if it is a server) and > IP addresses are being changed on the server then there is a switch in the > network who's battery has failed - and Enterprise IT should track it and > fix it ( might need to enter a ticket) > >> > > There is a UPS. Indeed the machine and server never went down > > > > > >> 2 - talk with the IT/network people, give them the server's MAC ID > (network card ID) and request a fixed IP address server through DHCP > >> Notes on #2 : the network admin can assign a specified IP address to a > specific MAC address, which is assigned via DHCP, then regardless of power > outage, server reboot, etc and generally the time off the network, the IP > address of the computer does not change. > > This is the setup. Indeed the IP is manual. > >> > >> and BTW > >> - MAC is a network card term and refers to the network card's ID > >> - Mac(intosh) is an Apple Computer Co. computer. > >> > >> DHCP with manual address usually means that the IP address has been > assigned by specific computer Admin, rather than network admin. The IP > address assigned this way can (and appears to) conflict with the DHCP > server assigning addresses. > >> This is because, as I understand it, the DHCP server does not 'know' > about the manual address. > > The address is permanent and was assigne by network folks > > > > > > > > > >> > >> Quickly: > >> DHCP hands out IP addresses in a specified range xxx.xxx.xxx.1 - 255. > the range can be restricted, say xxx.xxx.xxx.100 - 200. > >> and/or the DHCP server can hand out specific IP addresses to specified > MAC address, and random to all others. > >> Where I was working, IT did all of this. > >> Servers, and other devices which required that IP address NOT change > over time, (requested to be fixed), were assigned in the range 1- 30, 31 - > 220 were for network attached devices (computers, tablets etc), and 220 - > 254 were for reserved for printers. > >> However, ALL addresses were assigne
Re: IP address problem
Chuck: Changed IP address on a server? Very not good. Is it possible that, after the outage, the server rebooted and assigned it a default IP address? I've seen some hosts using a 74.x address if it can't get one from the DHCP server but that changes as soon as it can communicate with the DHCP server. "DHCP with manual address" is an option I've never used - if you're assigning the IP address manually then what else is the DHCP providing? For computers that need a persistent IP address, I assign values manually. The IP address assigned outside of the range of IP addresses reserved for the DHCP server. For DNS, if there's not one on the LAN, I use 8.8.8.8 and 8.8.4.4. -- Douglas von Roeder 949-910-4084 On Wed, Jun 3, 2020 at 11:37 AM Chuck Miller via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Hi All, > > We have a built Client server v 16.x running on a MAC > > Network set up is > DHCP with manual address > > This has been working till about 6n months ago. > > The hospital seems to test power outages on fairly regular basis. When > they do change over to emergency power > > The network pane in system preferences loses all except the IP address and > her we go > > The 4D server running starts listening on a different IP address. Has > anyone ever seen this before. Tech support is telling me to switch to > manual address. > > I have run and used this setup at many other customers > > Thanks and 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. > > ** > 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: Pluggers XL_Plugin Format Question
Ken: Lahav’s example should get you on the right track and Kirk’s advice is well taken. Rob has been very helpful answering my questions on the plugin. "I'm taking a look at buying the Pluggers XL_Plugin and most of my test went very quickly. Looks like a spectacular plugin." I agree. The XL Plugin is an excellent product. -- Douglas von Roeder 949-910-4084 On Thu, May 28, 2020 at 3:57 AM Ken Eyring via 4D_Tech <4d_tech@lists.4d.com> wrote: > Awesome, thank you! > > > > On 05/28/20 1:46 AM, lists via 4D_Tech wrote: > > Ken, > > > > You build the format and assign the different attributes to it (one of > which can be the locked flag, a font etc). > > > > $ YourDefinedFormat:=xlBookAddFormat ($xlBook) > > $font:=xlBookAddFont ($xlBook) > > xlFormatSetFont ($YourDefinedFormat;$font) > > xlFontSetName ($font;"Arial") > > xlFontSetSize ($font;10) > > xlFormatSetLocked( $YourDefinedFormat; 1 ) > > > > Then, when you assign a cell value, you also assign the format as in: > > > > xlSheetSetCellNumber ($sheet;$row;$col;$cellData;$YourDefinedFormat) > > > > HTH > > > > Lahav > > > ** > 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: Pluggers XL_Plugin Format Question
Ken: I haven’t used that particular format but I suspect that it is used like the other formats. If you haven’t created formats, check the code in the demo. It’s not extensive but, if you hold your head just right, things will make sense. At the moment, I’m away from a computer but I’ll post some code in the AM. On Wed, May 27, 2020 at 6:03 PM Ken Eyring via 4D_Tech <4d_tech@lists.4d.com> wrote: > I'm taking a look at buying the Pluggers XL_Plugin and most of my test > went very quickly. Looks like a spectacular plugin. > > It was real easy to open a spreadsheet and insert values into specific > cells. > > I ran into some confusion though, when I tried to set a cell's format, > e.g. to Locked, or change the font name or font size, etc... > > Here are the instructions for xlFormatSetLocked, but I'm not sure what > to pass in: > > xlFormatSetLocked( format ; locked ) > → longint → integer > Sets the locked protection property: 1 - true, 0 - false. > > I expected to define a sheet, row and column to identify the cell I > wanted to set the format for - but I don't see how to define which cell > I want to affect. > > If someone wouldn't mind sending a simple snippet of code that shows how > to set a specific cell's format using this plugin I would really > appreciate it. > > Thanks, > Ken > > ** > 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 > ** -- -- Douglas von Roeder 949-910-4084 ** 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: Object notation replacement for use of Self in a script — v18
Jim: "This is pretty much the same way you enumerate in reverse order in the other languages I use.” Thank you for posting that. I brought this up on the Forum a while back and I even brought it up in a tech support call but…nada. Interesting thread - https://forums.4d.com/Post/EN/34415270/1/34415271#34415271 A sage suggesting .reverse, as you have, and another steering the poster toward a For loop. Reminds me of: “Less filling! "Tastes great!” I’ll go with .reverse -- Douglas von Roeder 949-910-4084 On Fri, May 1, 2020 at 5:41 PM James Crate via 4D_Tech <4d_tech@lists.4d.com> wrote: > On Apr 30, 2020, at 9:36 PM, Douglas von Roeder via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > > > > Another WTF is that you can’t iterate from the end of a collection to the > > start. You can reorder the collection and then run a For each loop but > > that’s a complete kludge. > > For each ($item;$collection.reverse()) > // do some stuff > End for each > > This is pretty much the same way you enumerate in reverse order in the > other languages I use. > > Jim Crate > > ** > 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: Object notation replacement for use of Self in a script
Aparajita: "Absolutely. In fact it is more complete than most implementations, you can specify and begin and end index for ordered collections.” Sorry for the confusion. I was referring to 4D implementation, not A4D. -- Douglas von Roeder 949-910-4084 On Fri, May 1, 2020 at 10:10 PM Aparajita Fishman via 4D_Tech < 4d_tech@lists.4d.com> wrote: > > "Don’t be so quick to complain; you finally got ‘for each’ 10 years after > > the rest of the world (including Active4D).” > > Good point. So…you’re thinking that the feature set is complete? > > Absolutely. In fact it is more complete than most implementations, you can > specify and begin and end index for ordered collections. > > > > "I don’t know of a single language (and I have used at least 6) where > ‘for > > each’ is reversible.” > > This could be 4D’s chance to be a trendsetter! > > I don’t think it's worth it. Iterating in reverse is not a common > operation. > > > > it’s funny that we have such a handy looping construct yet I have write > > code to init and update my own index. > > If you need an index in a ‘for each’ loop, you should actually be using an > indexed ‘for’ loop. That’s the point of having ‘for each’ separate from > ‘for’: 90% of the time you don’t need the index and ‘for each’ is more > concise, but when you need an index a for loop increments it for you. > > - Aparajita > > ** > 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: Object notation replacement for use of Self in a script
Aparajita: "Don’t be so quick to complain; you finally got ‘for each’ 10 years after the rest of the world (including Active4D).” Good point. So…you’re thinking that the feature set is complete? "I don’t know of a single language (and I have used at least 6) where ‘for each’ is reversible.” This could be 4D’s chance to be a trendsetter! "Indexed loops haven’t gone away and have their uses.” No doubt. I have to use them often when working with collections. Frankly, it’s funny that we have such a handy looping construct yet I have write code to init and update my own index. How about using “++" to increment? -- Douglas von Roeder 949-910-4084 On Fri, May 1, 2020 at 1:32 PM Aparajita Fishman via 4D_Tech < 4d_tech@lists.4d.com> wrote: > > >> Another WTF is that you can’t iterate from the end of a collection to > the > >> start. You can reorder the collection and then run a For each loop but > >> that’s a complete kludge. > > Don’t be so quick to complain; you finally got ‘for each’ 10 years after > the rest of the world (including Active4D). I don’t know of a single > language (and I have used at least 6) where ‘for each’ is reversible. > Indexed loops haven’t gone away and have their uses. > ** > 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: Object notation replacement for use of Self in a script — v18
"If we could at least get the DATA SOURCE of the object that is using object notation as its data source, it would be nice:” Feature request time! Back in 2018 (way back then!), I asked to be able to get the table number for a entity selection and got the equivalent of “Why would you want to do that?!". Lo and behold, it showed up a few R releases later. Another WTF is that you can’t iterate from the end of a collection to the start. You can reorder the collection and then run a For each loop but that’s a complete kludge. Dollars to doughnuts, 4D will eventually add a parameter to the For each so that we don’t have to use that workaround. As Tim Nevels is wont to say (paraphrasing) “This just the beginning - have patience!" -- Douglas von Roeder 949-910-4084 On Thu, Apr 30, 2020 at 6:22 PM Chris Belanger via 4D_Tech < 4d_tech@lists.4d.com> wrote: > I thoroughly enjoy using object notation and the Form. object. That is why > I want a way to continue to use it to designate the data source of form > objects. > I have read and re-read Keisuke’s comment, and there are aspects I do not > comprehend. I thought that the attachment between form object and data > source object is an integral relationship and I can’t see how using the > form object to obtain its underlying data source [an attribute of an > object] is so bad. > And I am trying to understand the counsel: > > > > "I would focus my use of object notation to areas where classic > > code could not go, not spaces already occupied by classic code." > > > Not to mean any disrespect to Keisuke. He is one of the brightest 4D > programmers around. > But somehow this goes over my head. It is too philosophical to comprehend; > almost metaphysical. When I examine code that Keisuke creates, it is > elegant. I am confused as to how he would actually accomplish what we have > been discussing in an object script — would he use ‘classic 4D’ on some > screen elements, and not on others? > I do not want to resort to a mixture of ‘classic’ and object notation. > In the ‘perfect implementation’, within an object’s script: > > This.value := Pretty_Format(This.value) // or something like this > > “This” would give you access to the data source (being as it is basically > an attribute of an object, like Form.en_This.Company.Name). > > I understand that it creates some potential for confusion in the case of > something like: > Form.en_This.Company.Name > > In that this is actually an entity attribute. Perhaps the coder would > somehow start trying to extrapolate other attributes from its entity (i.e. > “owner"). > While one can traverse down the path (eg. Form[en_This][Company][Name] ) > one cannot traverse up the path as in: > > Let $attribute = Form.en_This.Company.Name // i.e. that is what > $attribute is; pseudo-code > $attribute.owner is Form.en_This.Company // hypothetical > code > ( applied to Form.en_This.Company.Name giving Form.en_This.Company > [in this case, an entity] ) > > > If we could at least get the DATA SOURCE of the object that is using > object notation as its data source, it would be nice: > But: > OBJECT Get data source ( *; $objName ) returns Nil for form objects (dot > notation) because it returns a pointer. > > > So it seems the only way to get the ’simple script’ is to do something > like hard-coding: > $temp:=Pretty_Format(Form.en_This.Company.Name) // so we don’t > ’touch’ an attribute unnecessarily, triggering a save condition > If (Form.en_This.Company.Name # $temp) // if the formatting > would change the value > Form.en_This.Company.Name:= $temp > End if > And propagate it all over the place. > > — Chris > > > > On Apr 30, 2020, at 6:23 PM, lists via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > > > Doug, > > > > Just for discussion sake, I'd say that a good portion of long > established systems have 100% of their space already occupied by classic > code > > > > The use of the Form object offers so much that I am resigned to let go > of some generic code, not happy, but willing to pay that price. > > > > Lahav > > > > -Original Message- > > From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Douglas von > Roeder via 4D_Tech > > Sent: Thursday, April 30, 2020 5:51 PM > > To: 4D iNug Technical <4d_tech@lists.4d.com> > > Cc: Douglas von Roeder > > Subject: Re: Object notation replacement for use of Self in a script — > v18 > > > > Randy: > > > > "If there is such an issue trying to get object values to work right, > what’s the reason to use the
Re: Object notation replacement for use of Self in a script — v18
"Just for discussion sake, I'd say that a good portion of long established systems have 100% of their space already occupied by classic code….” Couldn’t agree more! As the average age of installed base of programmers decreases, the % of “classic” code in production systems will drop (hat’s the audience that will use ORDA + OOP in 4D) "The use of the Form object offers so much that I am resigned to let go of some generic code, not happy, but willing to pay that price.” Agreed. If change wasn’t an inherent part of all facets of life, life would have stopped at the amoeba. -- Douglas von Roeder 949-910-4084 On Thu, Apr 30, 2020 at 5:23 PM lists via 4D_Tech <4d_tech@lists.4d.com> wrote: > Doug, > > Just for discussion sake, I'd say that a good portion of long established > systems have 100% of their space already occupied by classic code > > The use of the Form object offers so much that I am resigned to let go of > some generic code, not happy, but willing to pay that price. > > Lahav > > -Original Message- > From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Douglas von > Roeder via 4D_Tech > Sent: Thursday, April 30, 2020 5:51 PM > To: 4D iNug Technical <4d_tech@lists.4d.com> > Cc: Douglas von Roeder > Subject: Re: Object notation replacement for use of Self in a script — v18 > > Randy: > > "If there is such an issue trying to get object values to work right, > what’s the reason to use them at all?” > The new language is extremely powerful and I found it quite easy to pick > up (mostly). The fact that it doesn’t give us 100% backward compatibility > is not unexpected. > > "I know everyone is all excited about object notation, but it’s not > mandatory. Why should we even consider using it if doesn’t do what we > need? I’m sure there are some areas where it’s useful, but it sounds like > there’s a lot where it isn’t. Am I missing something” > “[doing everything that] we need” is a pretty high bar, wouldn’t you > agree? For me, I’ve been using ObjectTools + constructors since the late > 90’s, biding my time for 4D to adopt objects/object notation/OOP. At this > point, I’ll take what I can get. > > While I was quite not-happy with this particular limitation (I have forms > with hundreds of fields that use Object name that are used with Object get > pointer), I think the last paragraph of Miyako’s posting, above, is sound > advice - "I would focus my use of object notation to areas where classic > code could not go, not spaces already occupied by classic code." > > -- > Douglas von Roeder > 949-910-4084 > > > On Thu, Apr 30, 2020 at 3:03 PM Randy Kaempen via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > > > > > > On Apr 30, 2020, at 4:43 PM, lists via 4D_Tech > > > <4d_tech@lists.4d.com> > > wrote: > > > > > > OK, based on this design, we are back to using variables (or dynamic > > variables) for data entry of anything that needs any kind of > > processing done to it after an entry, having to load the values to > > these data entry objects when loading the form, and copying the values > > back when we want to save any user changes. > > > > > > OR > > > > > > We can use the Form.XXX notation to gain the advantage of that new > > > nifty > > option, but lose the generic coding ability. > > > > > > I'd say it's a choice, but the lack of the ability to address an > > > object > > from within generically definitely seems to be a glaring omission... > > > > If there is such an issue trying to get object values to work right, > > what’s the reason to use them at all? > > > > I know everyone is all excited about object notation, but it’s not > > mandatory. Why should we even consider using it if doesn’t do what we > > need? I’m sure there are some areas where it’s useful, but it sounds > > like there’s a lot where it isn’t. Am I missing something? > > > > > > Randy Kaempen > > Intellex Corporation > > > > ** > > 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: Object notation replacement for use of Self in a script — v18
Randy: "If there is such an issue trying to get object values to work right, what’s the reason to use them at all?” The new language is extremely powerful and I found it quite easy to pick up (mostly). The fact that it doesn’t give us 100% backward compatibility is not unexpected. "I know everyone is all excited about object notation, but it’s not mandatory. Why should we even consider using it if doesn’t do what we need? I’m sure there are some areas where it’s useful, but it sounds like there’s a lot where it isn’t. Am I missing something” “[doing everything that] we need” is a pretty high bar, wouldn’t you agree? For me, I’ve been using ObjectTools + constructors since the late 90’s, biding my time for 4D to adopt objects/object notation/OOP. At this point, I’ll take what I can get. While I was quite not-happy with this particular limitation (I have forms with hundreds of fields that use Object name that are used with Object get pointer), I think the last paragraph of Miyako’s posting, above, is sound advice - "I would focus my use of object notation to areas where classic code could not go, not spaces already occupied by classic code." -- Douglas von Roeder 949-910-4084 On Thu, Apr 30, 2020 at 3:03 PM Randy Kaempen via 4D_Tech < 4d_tech@lists.4d.com> wrote: > > > On Apr 30, 2020, at 4:43 PM, lists via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > > > OK, based on this design, we are back to using variables (or dynamic > variables) for data entry of anything that needs any kind of processing > done to it after an entry, having to load the values to these data entry > objects when loading the form, and copying the values back when we want to > save any user changes. > > > > OR > > > > We can use the Form.XXX notation to gain the advantage of that new nifty > option, but lose the generic coding ability. > > > > I'd say it's a choice, but the lack of the ability to address an object > from within generically definitely seems to be a glaring omission... > > If there is such an issue trying to get object values to work right, > what’s the reason to use them at all? > > I know everyone is all excited about object notation, but it’s not > mandatory. Why should we even consider using it if doesn’t do what we > need? I’m sure there are some areas where it’s useful, but it sounds like > there’s a lot where it isn’t. Am I missing something? > > > Randy Kaempen > Intellex Corporation > > ** > 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: Multple windows within the same process
Pat: The asterisk was added to the Dialog command in V12. That was all well and good but the developer had to get creative to communicate with a given window within a process because Call process was picked up by the frontmost window in a process. The “Call form” command (late V15) allows us to run code in the context of a given window making it very easy to update specific windows, regardless of how they were opened. If you’re working in a multi window environment, it’s easy to do “real time updates” by messaging processes so that they can refresh the data that they’re displaying. -- Douglas von Roeder 949-910-4084 On Wed, Apr 29, 2020 at 4:19 PM Chuck Miller via 4D_Tech < 4d_tech@lists.4d.com> wrote: > workers > > > > 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 Apr 29, 2020, at 7:17 PM, Pat Bensky via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > > > > Maybe it was in a dream ... but I'm sure I recall reading something > about a > > new feature (v17) that allows more than one window to be open within a > > process. But now I can't find that info. Did I imagine it? > > Pat > > ** > 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: Object notation replacement for use of Self in a script — v18
I drank deeply from the “dynamic variables” Koolaid well with the release of V12. As soon as I started working with Form.foo, I ran headlong into the issue described above. The email thread "One Set of Code for Form Object Populated Forms as well as Field-Based Detail View Forms” may shed some light on the topic. -- Douglas von Roeder 949-910-4084 On Wed, Apr 29, 2020 at 10:15 AM lists via 4D_Tech <4d_tech@lists.4d.com> wrote: > OK, so can we get a real example of how to replace the *old* way with the > new? In a case where there are several entry objects: > > Form.Name > Form.Address > Form.Note > > I want to enforce a proper uppercase/lowercase on all three, so in the old > days I created an object, set the method to "UpperLower(self)", duplicated > it three times, change the object name and I'm done. For simplicity sake, > lets say that UpperLower simply do $1->:=Uppercase($1->). > > How would you do the same while using object notation instead of a > variable, dynamic or not? > > Thanks, > > Lahav > > > -Original Message- > From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Keisuke Miyako > via 4D_Tech > Sent: Wednesday, April 29, 2020 10:14 AM > To: 4D iNug Technical <4d_tech@lists.4d.com> > Cc: Keisuke Miyako > Subject: Re: Object notation replacement for use of Self in a script — v18 > > my feeling is that generic coding is very much possible in object > notation, but we need to accept that the approach is different. > > if you prefer to use pointers such as "Self", I think it's best to avoid > object notation, at least if your goal is to make the code generic. > > it's not a defect of object notation, > but the way to write generic code is different. > > if you want to make your code generic in object notation, I think you need > to fully commit. > > what I mean by that, is that you need to think of objects and classes, > properties and methods. > > basically, instead of > > doIt(Self) > > you would write > > $obj.doIt() > > where the doIt() formula works on "This". > > in my opinion, to take full advantage of object notation, it is pretty > much mandatory to use > > This > Signal > Formula > Form > > extensively, as well as > > Storage > New shared object > New shared collection > > strategically. > > simply replacing interprocess/process variables with object notation, may > semantically look like object based coding, but at that level you may be > losing major advantages of classic code, while not gaining much from what > the new way of coding has to offer. > > > On Apr 29, 2020, at 14:55, Chris Belanger via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > > And v18r3 does not even have a solution to this in its documentation. > > ** > 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 **
Re: replace obsolete plugins
Chuck: API Pack is freely downloadable from the web site, though Rob (finally) has started asking for a donation. -- Douglas von Roeder 949-910-4084 On Fri, Apr 24, 2020 at 10:51 AM Charles Miller via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Ok just found api pack from pluggers and am asking for upgrade. > > Regards > Chuck > > On Fri, Apr 24, 2020 at 1:37 PM Charles Miller > wrote: > > > There is no Ali pack for 17 that I can find. Do you know where I can find > > it? > > > > Regards > > > > Chuck > > > > > > On Fri, Apr 24, 2020 at 1:36 PM Douglas von Roeder via 4D_Tech < > > 4d_tech@lists.4d.com> wrote: > > > >> API Pack works with versions of 4D as far back as 6.7 so you can just > swap > >> out the version that you’ve got for the current version = zero code. > >> > >> If the ZIP plugin isn’t compatible with V17, I think Miyako has a plugin > >> that does ZIP. Lacking that, you could fire up something with > AppleScript > >> or LEP. > >> > >> 4D Pack - I thought all of the functionality of 4D Pack had been rolled > in > >> to 4D. What functionality do you need to replace from 4D Pack? > >> > >> -- > >> Douglas von Roeder > >> 949-910-4084 > >> > >> > >> On Fri, Apr 24, 2020 at 10:16 AM Charles Miller via 4D_Tech < > >> 4d_tech@lists.4d.com> wrote: > >> > >> > Hi All, > >> > Environment 4D v17 > >> > > >> > I have a db which uses the following 3 plugins > >> > 4D pack > >> > API Pack > >> > zip > >> > > >> > What I am looking for is anyone who has replaced any of commands in > >> > API pack with native 4D. I think I can deal with the rest > >> > > >> > Regards > >> > > >> > Chuck > >> > -- > >> > > >> > > >> > - > >> > 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 Server connectivity > >> > https://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) > >> > 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 > >> ** > > > > -- > > > > > - > > 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 Server connectivity > > https://www.informed-solutions.com > > > > > - > > This message and any
Re: replace obsolete plugins
API Pack works with versions of 4D as far back as 6.7 so you can just swap out the version that you’ve got for the current version = zero code. If the ZIP plugin isn’t compatible with V17, I think Miyako has a plugin that does ZIP. Lacking that, you could fire up something with AppleScript or LEP. 4D Pack - I thought all of the functionality of 4D Pack had been rolled in to 4D. What functionality do you need to replace from 4D Pack? -- Douglas von Roeder 949-910-4084 On Fri, Apr 24, 2020 at 10:16 AM Charles Miller via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Hi All, > Environment 4D v17 > > I have a db which uses the following 3 plugins > 4D pack > API Pack > zip > > What I am looking for is anyone who has replaced any of commands in > API pack with native 4D. I think I can deal with the rest > > Regards > > Chuck > -- > > - > 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 Server connectivity > https://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) > 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: NTK 32K limit in TCP Receive
Jeff: Anecdotally, 4D IC is based on PDM’s Internet Tools which dates back to the early 90’s (PDM was started by a few of the original ACI employees from the 80’s). Quite a bit of the code was updated but perhaps that’s one item that’s not been up to speed…er, size. -- Douglas von Roeder 949-910-4084 On Thu, Apr 9, 2020 at 1:28 PM Jeffrey Kain via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Nope, it's for real. > > Easy enough to loop, etc.. But it's a bit of an anachronism in a modern > plug-in like NTK. > > > On Apr 9, 2020, at 4:24 PM, Ben Kershaw via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > > > >> Why? :) > >> "The bufferSize parameter indicates the maximum number of bytes to > read. If it is omitted or set to 0, the plugin will use the maximum size > for a text variable (32000 bytes).” > > > > Have you tested it to make sure it’s not just a documentation error? > > ** > 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: Image Export Issues
Robert: Agreed. My condolences, Robert. -- Douglas von Roeder 949-910-4084 On Fri, Apr 3, 2020 at 6:29 AM Cannon Smith via 4D_Tech < 4d_tech@lists.4d.com> wrote: > So sorry to hear about your wife, Robert. I can’t imagine how tough that > is for you. > > -- > Cannon Smith > > > On Apr 2, 2020, at 10:56 PM, Robert McKeever via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > > > > So, to all, thank you. I needed a success - my wife of almost 39 years > passed away from a long battle (10 years or more) with Vascular Dementia. > My soulmate. > > ** > 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: Worker and UI
Jeremy: "When Jenner was dithering about vaccination, he was told “Don’t think; try the experiment”.” Great quote. "I may yet run foul of some hidden gremlin which bares its fangs when 4D19 appears, but I tried the experiment and thus far it works like a dream.” Oh, ye of little faith! Glad that it worked out. -- Douglas von Roeder 949-910-4084 On Sat, Mar 28, 2020 at 9:31 AM Jeremy Roussak via 4D_Tech < 4d_tech@lists.4d.com> wrote: > When Jenner was dithering about vaccination, he was told “Don’t think; try > the experiment”. > > I may yet run foul of some hidden gremlin which bares its fangs when 4D19 > appears, but I tried the experiment and thus far it works like a dream. > > Step 1: at startup, call the worker to get things set up (mostly just > opening a window, miles offscreen, containing a VP area and use DIALOG > (…;*) to show it and let it initialise itself). > > Step 2: when required, call the worker to load data into the > pre-initialised VP area, work on it, open a window and display it in a form > which allows for user interaction. When the form is closed, the worker > hangs around waiting for the next usage and the window containing the VP > area is still open. > > Thanks for all the input. > > Jeremy > ** > 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: Worker and UI
Peter: I’ve been using Call worker to display a large ALP Area - 3k to 30k rows and 115 columns. The UI supports a palette that communicates with all of the windows and the windows communicate with each other so that when a value is changed in one window, Call form is used to initiate the update of the display in the other windows. Some of the windows are array-based AreaList Pro areas, others use AreaList Pro displaying records. "But will try to do a simple test database to check it out.” Sounds like a good idea. -- Douglas von Roeder 949-910-4084 On Fri, Mar 27, 2020 at 2:19 PM Peter Bozek wrote: > > > On Fri, Mar 27, 2020 at 9:14 PM Douglas von Roeder > wrote: > >> Peter: >> >> "My understanding of a worker is a process that can (potentially) run on >> different core or processor - what means, communicating with other >> processes with messages only, limited ability to share data, no >> interprocess variables, no GET / SET PROCESS VARIABLE and no UI.” >> I don’t see anything that indicates that the means by which a process is >> created impacts whether or not that process runs preemptively. Most UI >> commands are not preemptive. >> > > I believe that above commands cannot be used with workers even if worker > does not run preemptive method. > > >> "However, thinking about it, as user process is a worker, and it should >> be able to display UI, collaborative workers may be able to display UI.” >> Process 1 will display UI in V18, compiled. >> >> "But all 4D examples of worker's code use CALL FORM to display UI, so I >> would not try to display UI from a worker." >> Call form is a means of communicating with a form. It doesn’t tie back to >> how a process is invoked. >> > > In the examples, worker never displays UI, rather uses CALL FORM to > display its status in form displayed in another process. As I understand > it, it is not just because examples wanted to demonstrate communication > between worker and another process, but a feature of worker - it needs > another process to display UI. But will try to do a simple test database to > check it out. > > Peter Bozek > > ** 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: Worker and UI
Peter: "My understanding of a worker is a process that can (potentially) run on different core or processor - what means, communicating with other processes with messages only, limited ability to share data, no interprocess variables, no GET / SET PROCESS VARIABLE and no UI.” I don’t see anything that indicates that the means by which a process is created impacts whether or not that process runs preemptively. Most UI commands are not preemptive. "However, thinking about it, as user process is a worker, and it should be able to display UI, collaborative workers may be able to display UI.” Process 1 will display UI in V18, compiled. "But all 4D examples of worker's code use CALL FORM to display UI, so I would not try to display UI from a worker." Call form is a means of communicating with a form. It doesn’t tie back to how a process is invoked. The fact that a given command can be used to create a preemptive process doesn’t mean that it can’t be used to launch a process that supports a user interface. The New process command can also run code in a preemptive process. -- Douglas von Roeder 949-910-4084 On Fri, Mar 27, 2020 at 12:30 PM Peter Bozek wrote: > > > On Fri, Mar 27, 2020 at 8:01 PM Douglas von Roeder > wrote: > >> Peter: >> >> "Worker cannot display anything.” >> Why do you say that? >> > > My understanding of a worker is a process that can (potentially) run on > different core or processor - what means, communicating with other > processes with messages only, limited ability to share data, no > interprocess variables, no GET / SET PROCESS VARIABLE and no UI. > > However, thinking about it, as user process is a worker, and it should be > able to display UI, collaborative workers may be able to display UI. But > all 4D examples of worker's code use CALL FORM to display UI, so I would > not try to display UI from a worker. > > Peter Bozek > > ** 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: Worker and UI
Peter: "Worker cannot display anything.” Why do you say that? -- Douglas von Roeder 949-910-4084 On Fri, Mar 27, 2020 at 11:50 AM Peter Bozek via 4D_Tech < 4d_tech@lists.4d.com> wrote: > On Fri, Mar 27, 2020 at 5:29 PM Jeremy Roussak via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > > > v18.1, Mac > > > > What can a worker process do by way of UI? Are there any restrictions? > > > > I am not sure what you want to achieve, but yes, there is a restriction: no > UI for worker. None. Worker cannot display anything. > > Peter Bozek > ** > 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: Worker and UI
I’ve used Call worker with the dialog command. Call worker seems to be "yet another way" to open a process but it doesn’t return a process ID. Similar to New process, you can name the process and pass parameters. If you’re closing the dialog and want the process to terminate, just call Kill worker after the Dialog or Close window command. -- Douglas von Roeder 949-910-4084 On Fri, Mar 27, 2020 at 9:29 AM Jeremy Roussak via 4D_Tech < 4d_tech@lists.4d.com> wrote: > v18.1, Mac > > What can a worker process do by way of UI? Are there any restrictions? > > Situation: I have a task which takes a while to set up but which, once set > up, runs swiftly, perhaps quite often. At present, I just wait for the > setup to complete, but while it’s only a few seconds, it’s boring. > Initialisation involves opening a window offscreen, containing a View Pro > area for use in importing Excel spreadsheets. Getting data involves > importing the spreadsheet and extracting and analysing the data, and is > very fast. > > So, I thought this might do. At startup, CALL WORKER to get the window > opened (using DIALOG(…; *). > > When data import is wanted, CALL WORKER with the path to the spreadsheet. > The worker then does the “getting data” bit of the task. > > It then has to pass the data back to the waiting caller, which may then > show it in a dialog. If before calling the worker, the caller has opened a > window, there’s no problem: the worker can use CALL FORM. But sometimes, > there will be no data to display and it will look ugly if the window opens > and then closes. > > One solution would be for the caller process to be hidden until it has > data to show in the window, and then to call SHOW PROCESS on itself. > > But it might be easier if the worker process simply did the display > itself, if it opened the window and interacted with the user, avoiding the > need to pass anything back to the caller. The caller could simply issue the > CALL WORKER message and exit. > > Is there any objection to that method of doing things? The documentation > doesn’t suggest that workers can’t have a UI. Maybe I’m stretching the use > of a worker process past that which was intended. > > Any thoughts, or indeed comments on the idiocy of my thinking and my > foolishness in having missed an obviously easy solution, gratefully > received. > > Jeremy > > PS: why does it take 4D nearly 3 seconds between showing a form after a > call to DIALOG, a form which has no form method and contains only a View > Pro area, and the On VP Ready event? > ** > 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: Use Named Selection Unexpectedly Loads First Record of Named Selection
Thanks to all for the responses.
While trying to resolve an issue with locked records, I watched my routine
for handling named selections function. When the named selection was
created I “had no current record” because no record was visible in the
debugger. When Use named selection executed, the record became visible in
the debugger. That wasn’t what I had expected because I thought the record
had been unloaded.
Typically, I want to restore a selection with the current record (loaded).
In this situation, I want to make sure that it’s not loaded so I was
surprised when it showed up in the debugger.
--
Douglas von Roeder
949-910-4084
On Fri, Mar 13, 2020 at 6:43 AM kculotta via 4D_Tech <4d_tech@lists.4d.com>
wrote:
> An unloaded record can still be the current record.
>
> also
>
> ALL RECORDS([RecipeRec]) // has current record
> LAST RECORD([RecipeRec]) // has current record
> NEXT RECORD([RecipeRec]) // no current record
> .
> .
> .
> USE NAMED SELECTION("ASD") // no current record
>
> > On Mar 13, 2020, at 8:05 AM, Chip Scheide via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> >
> > and I would read into that - IF there is no selected record, the command
> will load the First Record
> >
> > Chip
> >
> >
> >> Hi Douglas
> >>
> >>
> >> Doc says:
> >> When you create a named selection, the current record is “remembered”
> by the
> >> named selection. USE NAMED SELECTION retrieves the position of this
> record
> >> and makes the record the new current record; this command loads the
> current
> >> record.
> >>
> >> In your example, the first record is the "current record". So for me, it
> >> works like it should be.
> >>
> >> Patrick
> >>
> >>
> >>
> >> -
> >> Patrick EMANUEL
> >>
>
> **
> 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: Use Named Selection Unexpectedly Loads First Record of Named Selection
Keith:
Thank you for confirming that.
--
Douglas von Roeder
949-910-4084
On Thu, Mar 12, 2020 at 1:49 PM kculotta via 4D_Tech <4d_tech@lists.4d.com>
wrote:
> It works just as you described in v18 Mac too.
> If you put NEXT RECORD after ALL RECORDS, that second record is later
> restored.
>
> Keith - CDI
>
> > On Mar 12, 2020, at 3:10 PM, Douglas von Roeder via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> >
> > 4D 17R6 on Windows.
> >
> > ALL RECORDS([People])
> > //Lots of records in the current selection
> > //There is a current record
> >
> > UNLOAD RECORD([People])
> > //Lots of records in the current selection
> > //There is no current record
> >
> > COPY NAMED SELECTION([People];"ASD")
> > //Lots of records in the current selection
> > //There is no current record
> >
> > QUERY([People];[People]SSAN="8675309”)
> > //No record found
> > //There is no current selection
> > //There is no current record
> >
> > USE NAMED SELECTION("ASD”)
> > //Lots of records in the current selection
> > //There is a current record
> >
> > CLEAR NAMED SELECTION("ASD")
> > //Lots of records in the current selection
> > //There is a current record
> >
> > I wasn’t expecting a Use named selection to load a record.
> >
> > Has anyone else experienced this? It is reproducible?
> >
> > --
> > Douglas von Roeder
> > 949-910-4084
> **
> 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: Multi-Select Dropdown Menu
Tim: "But the UI would not be so great. User clicks, the popup menu is displayed, they select an item to set or remove the check mark next to it, the popup menu goes away, repeat. If you are usually only selecting one item at a time that might work.“ Exactly, a popup driven UI would require multiple trips and that’s a non-starter and it’s a shame that 4D doesn’t have a widget that supports multi-select. I’ve got a popup window “class” that I’ve been using for some years but, for the sake of interface consistency, I want something that has the same look and feel as a 4D dropdown menu. If I can't make use of Olivier’s code I'll reuse the UI that has three grids on one small form so that it works somewhat like the two grids in Font DA Mover. -- Douglas von Roeder 949-910-4084 On Thu, Mar 5, 2020 at 12:34 PM Tim Nevels via 4D_Tech <4d_tech@lists.4d.com> wrote: > On Mar 5, 2020, at 2:00 PM, Douglas von Roeder wrote: > > > I appreciate the suggestions and, like every one else here, I *have* > gotten > > into the habit of writing code to fill in the gaps in 4D’s feature set. > In > > this case, I’d like to avoid creating another widget though, Jody, to > your > > point, creating one UI that "does it all” would be a tidy solution. > > > > The grid in question is big (dozens of thousands of rows and just over 80 > > columns) and I’ve got two data entry widgets - 4D dropdown > > menus/hierarchical menus and a window that allows the user to create > > multi-segment configuration strings. I’m not keen on introducing "yet > > another" interface item but that might be my only option. > > You could simulate a multi-select drop-down menu by creating a dynamic > popup menu that has check marks next to each item that you select. But the > UI would not be so great. User clicks, the popup menu is displayed, they > select an item to set or remove the check mark next to it, the popup menu > goes away, repeat. If you are usually only selecting one item at a time > that might work. > > But if the user would like to click, select 2 or more items and then have > the popup menu go away then you are going to have to open a window with a > widget in that window and have an “OK” button or a window close box. Then > the user can select as many items in the list as they want and then make > the window go away and save their selections. > > I would use window type “Pop up form window” and put a listbox > edge-to-edge in that window with an OK button at the bottom of the window. > When you open a window like and use the DIALOG command it will > automatically close the window and disappear if the user clicks outside of > the window bounds. "Pop up form window” also has no window boarders. User > knows when they see the OK button that when they click it changes are saved. > > So the UI would be: > > - user clicks a cell > - the Pop up form window appears with a listbox inside with 2 columns: > checkbox and description and OK button at the bottom > - user clicks checkboxes, scrolls the listbox if necessary and when done > clicks the OK button > - or if the user is just wanting to look at the currently selected items, > they can click the OK button, or just click anywhere outside the window and > the widget disappears. > > All your logic to save selections is inside the OK button. > > And if you want, you can turn off all the lines and borders for the list > box and with no scrollbars and no OK button it looks like just a stack of > checkboxes the user can turn on or off. All save logic is stored in the > checkbox column method of the listbox. When user clicks somewhere else on > the form the widget disappears. Each time they click a checkbox you save > that change. It’s a modal dialog box that isn’t really modal. No OK, Cancel > or window close box. You’ll know its actually a window, but the users > probably won’t. > > You wanted suggestions… > > 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: Multi-Select Dropdown Menu
Olivier: Thank you for posting that. I’ve downloaded a copy and will “take it for a spin”. -- Douglas von Roeder 949-910-4084 On Thu, Mar 5, 2020 at 12:15 PM Olivier Flury via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Not sure if it will address your problem... > > I have created some custom popups and also a multi selection tool. > > It is still 4D v16 and my selectors/popups are array based. The demo shows > the dropdown in action with a 60 000 row address set: > > Run the method "UI_Test" - compiled mode is better, parsing the 60 000 > rows file is not very fast in interpreted mode... (but once in memory it's > blazing fast). The popup supports multi string search e.g. "Paul Den" > > It's part of my tools component, source is included and it's free: > > https://flury-software.ch/a-swiss-army-knife-for-4d/ > > Olivier > > -Ursprüngliche Nachricht- > Von: 4D_Tech <4d_tech-boun...@lists.4d.com> Im Auftrag von Douglas von > Roeder via 4D_Tech > Gesendet: Donnerstag, 5. März 2020 19:47 > An: 4D iNug Technical <4d_tech@lists.4d.com> > Cc: Douglas von Roeder > Betreff: Re: Multi-Select Dropdown Menu > > I appreciate the suggestions and, like every one else here, I *have* > gotten into the habit of writing code to fill in the gaps in 4D’s feature > set. In this case, I’d like to avoid creating another widget though, Jody, > to your point, creating one UI that "does it all” would be a tidy solution. > > The grid in question is big (dozens of thousands of rows and just over 80 > columns) and I’ve got two data entry widgets - 4D dropdown > menus/hierarchical menus and a window that allows the user to create > multi-segment configuration strings. I’m not keen on introducing "yet > another" interface item but that might be my only option. > > Decisions, decisions… > > -- > Douglas von Roeder > 949-910-4084 > > > On Thu, Mar 5, 2020 at 7:46 AM Jody Bevan via 4D_Tech < > 4d_tech@lists.4d.com> > wrote: > > > Doug: > > > > Many years ago we recognized a few limitations of popups. Therefore > > over about a year we reworked our popup code, and also the interface > > that indicates a popup. > > > > The first thing we did was we never used a popup object built in by > > 4D. We created our own object that our user base learned was a popup. > > Then we could use an invisible button over top of the custom graphic. > > Therefore in the button we could decide what we wanted for the > > specific interface at that site, for that user, for that specific item. > > > > Doing this then as Keisuke Miyako says, you could present a > > multi-select listbox to what the user thinks of as a specialized popup. > > > > > > > On Mar 4, 2020, at 6:28 PM, Douglas von Roeder via 4D_Tech < > > 4d_tech@lists.4d.com> wrote: > > > > > > I’d like to create a UI that supports selecting multiple values > > > without > > the > > > menu closing. > > > > > > With the exception of using a web area, is there anyway to do this in > 4D? > > > > > > -- > > > Douglas von Roeder > > > 949-910-4084 > > > > > > ** > > > 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 > ** > > ** > 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: dropbox api
Mike: Tim Nevels posted some code here last year. You might be able to find it searching the archives or maybe send him an email. -- Douglas von Roeder 949-910-4084 On Thu, Mar 5, 2020 at 11:59 AM Mike Kerner via 4D_Tech < 4d_tech@lists.4d.com> wrote: > is anyone working with dropbox via 4D? how? > > -- > On the first day, God created the heavens and the Earth > On the second day, God created the oceans. > On the third day, God put the animals on hold for a few hours, >and did a little diving. > And God said, "This is good." > ** > 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: Multi-Select Dropdown Menu
I appreciate the suggestions and, like every one else here, I *have* gotten into the habit of writing code to fill in the gaps in 4D’s feature set. In this case, I’d like to avoid creating another widget though, Jody, to your point, creating one UI that "does it all” would be a tidy solution. The grid in question is big (dozens of thousands of rows and just over 80 columns) and I’ve got two data entry widgets - 4D dropdown menus/hierarchical menus and a window that allows the user to create multi-segment configuration strings. I’m not keen on introducing "yet another" interface item but that might be my only option. Decisions, decisions… -- Douglas von Roeder 949-910-4084 On Thu, Mar 5, 2020 at 7:46 AM Jody Bevan via 4D_Tech <4d_tech@lists.4d.com> wrote: > Doug: > > Many years ago we recognized a few limitations of popups. Therefore over > about a year we reworked our popup code, and also the interface that > indicates a popup. > > The first thing we did was we never used a popup object built in by 4D. We > created our own object that our user base learned was a popup. Then we > could use an invisible button over top of the custom graphic. Therefore in > the button we could decide what we wanted for the specific interface at > that site, for that user, for that specific item. > > Doing this then as Keisuke Miyako says, you could present a multi-select > listbox to what the user thinks of as a specialized popup. > > > > On Mar 4, 2020, at 6:28 PM, Douglas von Roeder via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > > > > I’d like to create a UI that supports selecting multiple values without > the > > menu closing. > > > > With the exception of using a web area, is there anyway to do this in 4D? > > > > -- > > Douglas von Roeder > > 949-910-4084 > > ** > > 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 **
Multi-Select Dropdown Menu
I’d like to create a UI that supports selecting multiple values without the menu closing. With the exception of using a web area, is there anyway to do this in 4D? -- Douglas von Roeder 949-910-4084 ** 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: ALP Documentation Link?
Tom: The main page for ALP is here: https://www.e-node.net/en/P1/AreaList-Pro.html About half way down the page is the header “Documentation” and which has links to documentation for ALP V10 in the form of wiki entries, as well as a link to the PDF docs which cover up to version 9.9.x, and there’s also a link to release notes for the current version. Error codes for AL_AddColumn? If you “find for" “AL_AddColumn”, there’s a link to “Result Code” in the paragraph following the first highlighted instance of that command. Clicking on that link takes you to page 277 which lists the 13 values that can be returned by the command. The most common error values that I’ve seen are 3 (invalid area reference) or, when using arrays, a code of 9 which means that the arrays that you passed differ in size. 0 is your friend. Feel free to contact me off line if you don’t want to post the issue here on the NUG or you can contact tech support via the eNode forum. Advantages to using the eNode forum - the folks at eNode are very helpful and you might find that the issue that’s got you stumped has already been discussed. -- Douglas von Roeder 949-910-4084 On Tue, Mar 3, 2020 at 4:28 AM Tom Benedict via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Not sure why I can’t find it right now, but I’m looking for a URL that > will take me to AreaListPro documentation. I’m having trouble navigating > the eNode website and keep running into dead ends. > > If anyone can send me a link I’d appreciate it. Right now I don’t think it > matters what version. I’m just looking for an explanation of the error > codes returned by the AL_AddColumn command. > > Thanks, > > Tom Benedict > ** > 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: View Pro - How to protect a sheet
Scott: Good luck with that. Let us know how it turns out. -- Douglas von Roeder 949-910-4084 On Mon, Jan 27, 2020 at 9:34 PM Scott Staley via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Doug, > > Thanks for the advice. I've used excel since it was created back in about > 1984/85 but wasn't familiar with the underlying file structure of a current > excel file. Just opened one with BBEdit. A lot more to it than I > thought. > I'll see if I can figure out in the file structure where the protection > info > is stored and see if I can do anything with it. I would rather avoid a > separate plugin for this one issue. View Pro is somewhat surprisingly > working very well for what I need. > > > > -- > 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 > ** ** 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: View Pro - How to protect a sheet
Scott: The Excel plugin from Pluggers has a command *xlSheetSetProtected* which you could use to update the workbook after it’s been created using 4D VP. As an alternative, an Excel workbook is a handful of files bundled up in a folder. You might be able to do a diff on a protected workbook vs one that is not protected and then write some code to change the value. It most likely that you can’t change the value to not-protected but you *might* be able to get away with changing the value to protected. -- Douglas von Roeder 949-910-4084 On Mon, Jan 27, 2020 at 4:52 PM Scott Staley via 4D_Tech < 4d_tech@lists.4d.com> wrote: > The subject pretty much says it all. Anyone know how to tell View Pro to > programmatically protect a sheet. > > fyi... I basically have an excel template that I import into View Pro and > then populate with data and save it back as an excel file. The excel file > is then given to others that populate other parts of the sheet. I would > like to turn the sheet protection on so that the data populated by 4D and > any other protected cells are not accidentally modified. If I protect the > sheet in excel, than I can't use 4D to populate the protected cells. I > generate several hundred files so I don't want to do it manually. > > I'm using 4D v17 R6 > > Thanks in advance for any suggestions... > > > > -- > 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 > ** ** 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 and SAP
Jody: I’ve been doing 4D <==> SAP using web services for over a decade. Once the folks on the SAP side get things set up, it’s quick and extremely reliable. -- Douglas von Roeder 949-910-4084 On Thu, Jan 2, 2020 at 10:39 AM Jody Bevan via 4D_Tech <4d_tech@lists.4d.com> wrote: > 1. Have any of you created interfaces to SAP? > - send it data > - get data from it > > I may have the opportunity to manage an IT team. The company uses SAP. If > I know that I can connect with 4D to get data out, or into SAP that will > open up a familiar opportunity to me. > > Otherwise… I could be learning a whole new world. > > Thanks > > Jody Bevan > ** > 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: maximum number of record
Christian: Thank you for posting that link. Hmm, *only* 1 billion… -- Douglas von Roeder 949-910-4084 On Fri, Dec 13, 2019 at 12:29 PM Christian Sakowski via 4D_Tech < 4d_tech@lists.4d.com> wrote: > > a longint value for record numbers - (2^64)-1 > > The C_LONGINT is 2^32 which is 4 billion. Signed 2 billion. > Starting with v11 (alias 4D 2007), i guess internally the addressable is > 128 bit! Now you can calculate the technical limit of each resource :-) > > As i said, the „artificial“ limit is 1.000.000.000: > > https://doc.4d.com/4Dv18/4D/18/4D-Database-capabilities.300-4575575.en.html > -- > > Grüße/Regards, > [heubach-media] | Christian Sakowski > christian.sakow...@heubach-media.de > Tel: +49/(0)40/41 455 455 > > > > > > > Am 13.12.2019 um 16:26 schrieb Chip Scheide via 4D_Tech < > 4d_tech@lists.4d.com>: > > > > someone else will correct me if I am wrong, but I believe it is ~2 > > billion. > > a longint value for record numbers - (2^64)-1 > > > > Chip > > On Fri, 13 Dec 2019 16:13:35 +0100, stardata.info via 4D_Tech wrote: > >> Hi All, > >> > >> In one my application in 4D V13.4 on Windows, i have in one table > >> over of 8.000.000 records. > >> > >> What is the maximum number of records that 4D V13.4 can manage? > >> > >> Thanks > >> > >> Ferdinando > >> > >> ** > >> 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 > >> ** > > We have done so much, with so little, for so long; > > We are now qualified to anything with nothing > > - unknown > > ** > > 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 **
Re: maximum number of record
2 billion per table On Fri, Dec 13, 2019 at 7:21 AM Tom Benedict via 4D_Tech < 4d_tech@lists.4d.com> wrote: > I’ve had systems where tables had 10 million records in ‘wide’ (200+ > fields) tables. And over 50,000,000 in ‘narrow’ (10 fields) tables. That > was under v13.x. I think you should be fine. Of course you must only do > indexed queries. > > HTH, > > Tom Benedict > > > On Dec 13, 2019, at 07:13, stardata.info via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > > > > Hi All, > > > > In one my application in 4D V13.4 on Windows, i have in one table over > of 8.000.000 records. > > > > What is the maximum number of records that 4D V13.4 can manage? > > > > Thanks > > > > Ferdinando > > > > ** > > 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 > ** -- -- Douglas von Roeder 949-910-4084 ** 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 **
Collections Issue
*C_COLLECTION*($coll_C)
$coll_C:=*New collection*("Curly";"Moe";"Larry")
*C_TEXT*($name_T)
*For each* ($name_T;$coll_C;0;2)
*ALERT*($name_T)
*End for each*
results in alerts for “Curly”, “Moe”, and “Larry".
*For each* ($name_T;$coll_C;0;2)
*ALERT*($name_T)
*End for each*
results in alerts for “Curly” and “Moe”. That’s expected because the docs
state “end is excluded”.
*For each* ($name_T;$coll_C;2;0)
*ALERT*($name_T)
*End for each*
results in no alerts. That’s not expected.
How does one iterate backwards through a collection? I realize that I can
reverse the collection and iterate forward through it but there’s
no contraindication to iterating backward.
--
Douglas von Roeder
949-910-4084
**
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: How to lookup a value within an object within an object
Tom:
Cannon’s OBJ_Module is a good enhancement to the native 4D commands.
--
Douglas von Roeder
949-910-4084
On Fri, Oct 25, 2019 at 1:58 PM Tom Benedict via 4D_Tech <
4d_tech@lists.4d.com> wrote:
> I’m new to objects. I have an object which holds a range of keys and
> values. Some of the values are objects. I figured I could just use the OB
> Get command with dot notation to reference a key in a nested object, but
> that doesn’t seem to be supported.
>
> Here’s my example:
>
> C_OBJECT(myObject)
>
> myObject :=
> "{
> "id": "evt_1FXWZKGX5QBs0BzAQsOMqk3f",
> "object": "event",
> "created": 1572024442,
> "data": {
> "object": {
> "object": "charge",
> "amount": 4275,
> "billing_details": {
> "address": {
> "city": "Burien",
> "postal_code": "98166",
> "state": "WA"
> },
> "name": "Willy Wonka",
> },
> "type": "charge.succeeded"
> }"
>
> If I want to get the value of:
>
> myObject.data.object.billing_details.address.postal_code
>
> I have to use:
>
> OB Get(OB Get(OB
> Get(myObject;"data");"object");”billing_details");”address");”postal_code”)
>
> rather than:
>
> OB Get(myObject;data.object.billing_details.address.postal_code)
>
> I see that Cannon created a dot notation component some years ago. Is that
> the only ‘easy’ way to do this or have I missed something?
>
> Thanks,
>
> Tom Benedict
>
> **
> 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: Foundation Shell
James: I hope that works out. Please keep us posted. Foundation is part of the 4D ecosystem and it would be good to know its status. -- Douglas von Roeder 949-910-4084 On Wed, Oct 2, 2019 at 2:39 PM James Wright wrote: > Thanks Douglas, > > I've reached out to Walt. > > Best > > James. > > On Wed, 2 Oct 2019 at 20:59, Douglas von Roeder > wrote: > >> James: >> >> Sorry to see that the website is no longer active. >> >> The only email address that I’ve got for Walt is Foundation Walt < >> w...@foundationshell.com>. >> >> If Foundation is no longer available on a commercial basis, perhaps Walt >> would provide you with a license at no charge. >> >> -- >> Douglas von Roeder >> 949-910-4084 >> >> >> On Wed, Oct 2, 2019 at 5:16 AM James Wright via 4D_Tech < >> 4d_tech@lists.4d.com> wrote: >> >>> Hi Folks, >>> >>> Looking to start a new desktop project (Who would've thought!). In the >>> past >>> I used Foundation Shell, it was awesome. >>> >>> I noticed the site isn't active anymore, can anyone recommend an >>> alternative? Or do I have to roll my own? >>> >>> v17. >>> >>> Thanks >>> >>> James. >>> >>> -- >>> [image: logo] >>> *James Wright* C.T.O.*, Drag and Drop* >>> Tel: 08000 43 22 12 | Suite 6/7 Chichester House, 45 Chichester Road, >>> Southend-on-Sea, Essex SS1 2JU >>> supp...@draganddrop.co.uk | www.ezadspro.co.uk | www.draganddrop.co.uk >>> ** >>> 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 >>> ** >> >> > > -- > [image: logo] > *James Wright* C.T.O.*, Drag and Drop* > Tel: 08000 43 22 12 | Suite 6/7 Chichester House, 45 Chichester Road, > Southend-on-Sea, Essex SS1 2JU > supp...@draganddrop.co.uk | www.ezadspro.co.uk | www.draganddrop.co.uk > ** 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: Foundation Shell
James: Sorry to see that the website is no longer active. The only email address that I’ve got for Walt is Foundation Walt < w...@foundationshell.com>. If Foundation is no longer available on a commercial basis, perhaps Walt would provide you with a license at no charge. -- Douglas von Roeder 949-910-4084 On Wed, Oct 2, 2019 at 5:16 AM James Wright via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Hi Folks, > > Looking to start a new desktop project (Who would've thought!). In the past > I used Foundation Shell, it was awesome. > > I noticed the site isn't active anymore, can anyone recommend an > alternative? Or do I have to roll my own? > > v17. > > Thanks > > James. > > -- > [image: logo] > *James Wright* C.T.O.*, Drag and Drop* > Tel: 08000 43 22 12 | Suite 6/7 Chichester House, 45 Chichester Road, > Southend-on-Sea, Essex SS1 2JU > supp...@draganddrop.co.uk | www.ezadspro.co.uk | www.draganddrop.co.uk > ** > 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: FYI: 4D-Objects - Embedded Objects --> Save as file
Auto correct…
“your code”
On Mon, Sep 23, 2019 at 6:41 PM Douglas von Roeder
wrote:
> I haven’t tried your. Ode but dotted notation is case sensitive. Could
> that be the issue?
>
> On Mon, Sep 23, 2019 at 6:35 PM Jörg Knebel via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
>
>> G’day,
>>
>> I tried the following (pseudo code):
>>
>> Create an object
>> Fill the object with some stuff
>>
>> Create another object and filled it with stuff including a picture
>>
>> Put the second object into the first.
>>
>> JSON Stringify($MyGreatObj)
>>
>> Save objectText to file
>>
>> Opened the file in BBEdit:
>> {
>> "Para1": "2019-09-24",
>> "Para2": 36170,
>> "ActivationCode": "activationCode",
>> "Embeded": {
>> "SomePict": "[object Picture]",
>> "someText": "TestText",
>> "aRealNumber": 3.1415926535898
>> }
>> }
>>
>> NOW
>>
>> $ObjText := Document To Text
>>
>> $TestObject:=JSON Parse($ObjText)
>>
>>
>> $TestText:=$TestObject.Embeded.sometext
>>
>> TestPict:=$TestObject.Embeded.somePict
>>
>> Both variables are EMPTY!
>>
>>
>> * Next STEP
>>
>>
>> $EmbeddedObj:=$TestObject.Embeded
>>
>> $TestText:=$EmbeddedObj.sometext
>>
>>
>> $EmbeddedObj contains the object but $TestText is empty again.
>>
>> The picture is a total lost!
>>
>>
>> So, I think 4D-Objects need more time (another 25 years?) to catch up
>> with ObjectTools…
>>
>> A command like OB To BLOB would be a nice point to start.
>>
>> My 2¢
>>
>> Cheers
>> Jörg
>> **
>> 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
>> **
>
> --
> --
> Douglas von Roeder
> 949-910-4084
>
--
--
Douglas von Roeder
949-910-4084
**
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: FYI: 4D-Objects - Embedded Objects --> Save as file
I haven’t tried your. Ode but dotted notation is case sensitive. Could
that be the issue?
On Mon, Sep 23, 2019 at 6:35 PM Jörg Knebel via 4D_Tech <
4d_tech@lists.4d.com> wrote:
> G’day,
>
> I tried the following (pseudo code):
>
> Create an object
> Fill the object with some stuff
>
> Create another object and filled it with stuff including a picture
>
> Put the second object into the first.
>
> JSON Stringify($MyGreatObj)
>
> Save objectText to file
>
> Opened the file in BBEdit:
> {
> "Para1": "2019-09-24",
> "Para2": 36170,
> "ActivationCode": "activationCode",
> "Embeded": {
> "SomePict": "[object Picture]",
> "someText": "TestText",
> "aRealNumber": 3.1415926535898
> }
> }
>
> NOW
>
> $ObjText := Document To Text
>
> $TestObject:=JSON Parse($ObjText)
>
>
> $TestText:=$TestObject.Embeded.sometext
>
> TestPict:=$TestObject.Embeded.somePict
>
> Both variables are EMPTY!
>
>
> * Next STEP
>
>
> $EmbeddedObj:=$TestObject.Embeded
>
> $TestText:=$EmbeddedObj.sometext
>
>
> $EmbeddedObj contains the object but $TestText is empty again.
>
> The picture is a total lost!
>
>
> So, I think 4D-Objects need more time (another 25 years?) to catch up with
> ObjectTools…
>
> A command like OB To BLOB would be a nice point to start.
>
> My 2¢
>
> Cheers
> Jörg
> **********
> 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
> **
--
--
Douglas von Roeder
949-910-4084
**
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: Silent Failure when Constructing an Object
Narinder: Very strange behavior and not easy to track down. If you can reproduce it, that’s something that should get into the bug system to get fixed. Good luck with that. -- Douglas von Roeder 949-910-4084 On Fri, Sep 20, 2019 at 1:18 PM Narinder Chandi via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Douglas, > > Thanks for testing. OK, so I tested in isolation and in fact the code > errors correctly. > > So, I realised that my actual scenario was that the code is called in a > method from On Web Connection. I can set a breakpoint at the offending line > but the debugger aborts at the next line of code after the one that should > trigger a syntax error and code execution ceases. In fact I tried to create > a deliberate syntax error and still see that no syntax error is displayed > and code execution ceases. Not sure if this is a bug or behaviour by > design? Possibly the error is returned to the client making the request but > in my case it's an external service making the request and I can't see the > response the service receives other than the fact it appears to fail. > > Regards, > > Narinder Chandi, > ToolBox Systems Ltd. > > I am available for new consulting opportunities… > http://4d.1045681.n5.nabble.com/ANN-4D-Developer-Available-td5765443.html > -- > > -Original Message- > From: Douglas von Roeder > Date: Friday, 20 September 2019 at 19:20 > To: 4D Tech Mailing List <4d_tech@lists.4d.com> > Cc: Narinder Chandi <4dtechmailingl...@toolbox.uk.com> > Subject: Re: Silent Failure when Constructing an Object > > Narinder: > I just ran the code you posted on 17R4 (Mac and Windows) and I’m > getting an error message - “Object or a Collection expected” > > After the code completes execution, has 4D created .bar dynamically? > > -- > Douglas von Roeder > 949-910-4084 > > > > > > > > > On Fri, Sep 20, 2019 at 11:02 AM Narinder Chandi via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > > > So, I am writing some code and using C_OBJECT. Using the following > contrived object as an example: > > C_OBJECT($object) > $object:=New object > $object.foo:=New object > $object.foo.foo1:="foo1" > $object.foo.foo2:="foo2" > $object.bar:=New object > $object.bar.bar1:="bar1" > $object.bar.bar2:="bar2" > > The code executes as expected. Sometimes I might accidentally forget > to initialise a nested object - it happens! So, if I replace the above with: > > C_OBJECT($object) > $object:=New object > $object.foo:=New object > $object.foo.foo1:="foo1" > $object.foo.foo2:="foo2" > $object.bar.bar1:="bar1" > $object.bar.bar2:="bar2" > > i.e. I forget "$object.bar:=New object" then the code will silently > fail. Can somebody tell me why the interpreter does not raise an error in > this situation? This was tested with 17.1 and 17.2 on Mac and the behaviour > was the same (i.e. silent code failure) in both versions. > > In the docs for C_OBJECT: > https://doc.4d.com/4Dv17/4D/17.3/C-OBJECT.301-4621707.en.html > it states: > "Important: The C_OBJECT command does not create an object named > variable. If you want to access the properties of the object itself using > object notation, you must first initialize it using the New object command, > otherwise a syntax error is returned (see example)." > > That doesn't seem to be the case - no syntax error is raised and the > code also compiles?! Can somebody point out what I am missing here? Thanks. > > Regards, > > Narinder Chandi, > ToolBox Systems Ltd. > > I am available for new consulting opportunities… > > http://4d.1045681.n5.nabble.com/ANN-4D-Developer-Available-td5765443.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 > ** > > > > > > ** > 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: Silent Failure when Constructing an Object
Narinder: I just ran the code you posted on 17R4 (Mac and Windows) and I’m getting an error message - “Object or a Collection expected” After the code completes execution, has 4D created .bar dynamically? -- Douglas von Roeder 949-910-4084 On Fri, Sep 20, 2019 at 11:02 AM Narinder Chandi via 4D_Tech < 4d_tech@lists.4d.com> wrote: > So, I am writing some code and using C_OBJECT. Using the following > contrived object as an example: > > C_OBJECT($object) > $object:=New object > $object.foo:=New object > $object.foo.foo1:="foo1" > $object.foo.foo2:="foo2" > $object.bar:=New object > $object.bar.bar1:="bar1" > $object.bar.bar2:="bar2" > > The code executes as expected. Sometimes I might accidentally forget to > initialise a nested object - it happens! So, if I replace the above with: > > C_OBJECT($object) > $object:=New object > $object.foo:=New object > $object.foo.foo1:="foo1" > $object.foo.foo2:="foo2" > $object.bar.bar1:="bar1" > $object.bar.bar2:="bar2" > > i.e. I forget "$object.bar:=New object" then the code will silently fail. > Can somebody tell me why the interpreter does not raise an error in this > situation? This was tested with 17.1 and 17.2 on Mac and the behaviour was > the same (i.e. silent code failure) in both versions. > > In the docs for C_OBJECT: > https://doc.4d.com/4Dv17/4D/17.3/C-OBJECT.301-4621707.en.html > it states: > "Important: The C_OBJECT command does not create an object named variable. > If you want to access the properties of the object itself using object > notation, you must first initialize it using the New object command, > otherwise a syntax error is returned (see example)." > > That doesn't seem to be the case - no syntax error is raised and the code > also compiles?! Can somebody point out what I am missing here? Thanks. > > Regards, > > Narinder Chandi, > ToolBox Systems Ltd. > > I am available for new consulting opportunities… > http://4d.1045681.n5.nabble.com/ANN-4D-Developer-Available-td5765443.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 > ** ** 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: Debug Application Process Window missing toolbar
Paul: Hold down the Shift key before invoking the debugger window. More info in this knowledgebase article <https://kb.4d.com/assetid=78092>. -- Douglas von Roeder 949-910-4084 On Thu, Sep 19, 2019 at 3:31 AM Charles Miller via 4D_Tech < 4d_tech@lists.4d.com> wrote: > I would delete the file. It will recreate itsel next launch > > On Thu, Sep 19, 2019 at 3:19 AM Koen Van Hooreweghe via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > > > Hi Paul, > > > > There is some 4D prefs file 4ddebugger.json which might contain faulty > > values. I don't know exactly where to find it on Windows, but on Mac its > > home/Library/Application Support/4D/4D Window Bounds > > v17/runtime/[projectForm]/4ddebugger.json. > > > > See also: https://forums.4d.com/Post/EN/16299793/1/16299794 > > > > HTH > > Koen > > > > > Op 19 sep. 2019, om 04:20 heeft Paul Ringsmuth via 4D_Tech < > > 4d_tech@lists.4d.com> het volgende geschreven: > > > > > > 4Dv17R5 > > > Windows 10 under VirtualBox > > > > > > The toolbar is missing in the Debug Application Process Window except > > for a couple of pixels. > > > > > > I can’t find a way to get it back. Any suggestions? > > > > > > Paul Ringsmuth > > > pringsm...@charter.net <mailto:pringsm...@charter.net> > > > > > > > > > > > > > Compass bvba > > Koen Van Hooreweghe > > Kloosterstraat 65 > > 9910 Aalter > > Belgium > > tel +32 495 511.653 > > > > ** > > 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 > > ** > > -- > > - > 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 Server connectivity > https://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) > 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 **
Use Query Plan for Programmatic Execution of Query
Is there a way use the query plan to execute a query? -- Douglas von Roeder 949-910-4084 ** 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: Can an attribute be removed from an object?
OB Remove On Fri, Aug 23, 2019 at 8:57 PM Chris Belanger via 4D_Tech < 4d_tech@lists.4d.com> wrote: > I want to be able to remove attributes from an object. (Not just nullify > them). > > Example: > > $en_Rec is an ‘entity’ [Record] > obj is an OBJECT field for this record > $en_Rec.obj refers to that field > > Now some attributes are defined/set for this object > $en_Rec.obj.name:=“this” > $en_Rec.obj.userDisplay:=true > $en_Rec.obj.userEnter:=true > > Later I want to change object field (OBJ) > I add two attributes: > $en_Rec.obj.privDisplay:=“All" > $en_Rec.obj.privEnter:=“Designer" > > this is to make the display / entry privilege more specific than a simple > boolean > > but I want to delete the two attributes from this object now: > $en_Rec.obj.userDisplay:=null > $en_Rec.obj.userEnter:=null > > > > Is this the way to remove attributes from an object? (i.e. setting the > value to null?) Seems that the attribute stays, but is now ‘null’. > > > Thanks > ** > 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 > ** -- -- Douglas von Roeder 949-910-4084 ** 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: Drag n drop (between processes)
Chip:
Here’s some ALP code that uses that command - it might give you some ideas…
*Case of*
*:* ($formEvent_L=On Drop)
*Case of*
*:* ($currentObjectName_T="Lock_CustomerName”)
*C_BLOB*($blob_X)
*GET PASTEBOARD DATA*("net.e-node.alp.object";$blob_X)
*If* (OK=1)
*C_LONGINT*($eList)
$eList:=*BLOB to longint*($blob_X;Native byte ordering)
*C_LONGINT*($row_L)
$row_L:=*AL_GetAreaLongProperty* ($eList;ALP_Area_DragSrcRow)
$text_T:=*AL_GetAreaTextProperty* ($eList;ALP_Area_Name)
*Case of*
*:* ($eList=eLineItem)
*GOTO SELECTED RECORD*([Line Items];$row_L)
*OBJ_GPBN* ($currentObjectName_T)->:=[Line Items]Product Name
*UNLOAD RECORD*([Line Items])
*:* ($text_T="theOne_List_eList_01")
*C_TEXT*($id_T)
$id_T:=*AL_GetCellTextProperty* ($eList;$row_L;1;ALP_Cell_Value)
*OBJ_GPBN* ($currentObjectName_T)->:=*AL_GetCellTextProperty*
($eList;$row_L;2;ALP_Cell_Value)
*PROC_FormEvent_Set* ($h_;On Data Change)
*PROPOSALS_FC* ($h_)
*End case*
*End if*
*End case*
*End case*
--
Douglas von Roeder
949-910-4084
On Mon, Aug 12, 2019 at 2:39 PM Douglas von Roeder
wrote:
> Chip:
>
> Check out the docs for “Managing Pasteboards”. I’ve used this feature only
> with ALP but ALP uses the same drag and drop events that 4D does so there
> will be some overlap.
>
> 4 bytes could well be a longint representing the process ID where the drag
> was initiated - that’s a WAG. The bigger payload could be a BLOB of a fair
> amount of text or perhaps a record that was put into the clipboard when the
> On drag sequence started.
>
> Have you checked the knowlegebase or perhaps looked in the Summit
> materials?
>
> --
> Douglas von Roeder
> 949-910-4084
>
>
> On Mon, Aug 12, 2019 at 2:06 PM Chip Scheide via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
>
>> I am dragging and dropping 1 or more records from 1 process onto a
>> listbox in a second process.
>>
>> I see that I can use the pasteboard to mange the data during this
>> action.
>>
>> However(dragging 1 record)
>> I am looking at the data types returned by GET PASTEBOARD DATA TYPE
>> com.4d.private.pid & com.4d.private.Form.Object -- neither of these
>> makes much sense to me.
>>
>> By using GET PASTEBOARD DATA i get a blob which is either
>> 4 bytes (com.4d.private.pid)
>> or
>> 524 bytes (com.4d.private.object.form)
>>
>> I do not know what to do with either of these blocks of data... can
>> someone point me in the right direction.
>>
>> The drop area is allowed to accept data from 5 different tables.
>> I need to be able to differentiate which table the data is from, &
>> which record(s) were dropped.
>>
>> Once I have which ever of the above data types hand, what do I do with
>> them to extract the needed information.
>>
>> Thanks
>> Chip
>>
>> ---
>> Gas is for washing parts
>> Alcohol is for drinkin'
>> Nitromethane is for racing
>> **
>> 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: Drag n drop (between processes)
Chip: Check out the docs for “Managing Pasteboards”. I’ve used this feature only with ALP but ALP uses the same drag and drop events that 4D does so there will be some overlap. 4 bytes could well be a longint representing the process ID where the drag was initiated - that’s a WAG. The bigger payload could be a BLOB of a fair amount of text or perhaps a record that was put into the clipboard when the On drag sequence started. Have you checked the knowlegebase or perhaps looked in the Summit materials? -- Douglas von Roeder 949-910-4084 On Mon, Aug 12, 2019 at 2:06 PM Chip Scheide via 4D_Tech < 4d_tech@lists.4d.com> wrote: > I am dragging and dropping 1 or more records from 1 process onto a > listbox in a second process. > > I see that I can use the pasteboard to mange the data during this > action. > > However(dragging 1 record) > I am looking at the data types returned by GET PASTEBOARD DATA TYPE > com.4d.private.pid & com.4d.private.Form.Object -- neither of these > makes much sense to me. > > By using GET PASTEBOARD DATA i get a blob which is either > 4 bytes (com.4d.private.pid) > or > 524 bytes (com.4d.private.object.form) > > I do not know what to do with either of these blocks of data... can > someone point me in the right direction. > > The drop area is allowed to accept data from 5 different tables. > I need to be able to differentiate which table the data is from, & > which record(s) were dropped. > > Once I have which ever of the above data types hand, what do I do with > them to extract the needed information. > > Thanks > Chip > > --- > Gas is for washing parts > Alcohol is for drinkin' > Nitromethane is for racing > ** > 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: [Tip]Set Query Destination
Chip: When Set query limit and Set query destination came out, I ran into the situation where queries “stopped working” because I had forgotten to add the code to reset them. To avoid that, I made it a practice to type the “reset” code *before* I type the code to change the destination or limit from their normal settings. -- Douglas von Roeder 949-336-2902 On Fri, Jun 21, 2019 at 6:50 AM Chip Scheide via 4D_Tech < 4d_tech@lists.4d.com> wrote: > [Tl;DR] at end > > This command is your friend - and - your foe! :) > > Yesterday I spent a significant amount of time trying to track down a > compiled/built app crash, but did/does not happen interpretedly. > > The crash happened only occasionally, after placing alerts and asserts, > I determined that the crash was happening in a utility method which was > doing a query. A method which, in the running code, had already been > called repeatedly - without - issue. > Since the method which was doing the query had been called repeatedly > -before- the crash, I was perplexed as to what the issue was. > After some more poking and prodding, it appeared that the crashing only > occurred in the utility method, after a specific method (X) was called. > Looking at X and watching it execute (interpretedly) provided no > obvious clue as what the cause was. > After staring at the code, and running both interpretedly and built > many more times it finally dawned on me what the issue was... > Set Query Destination > > In method X I was doing some work looking for duplicate data, and in so > doing I was loping over a code that looked like this: > Set Query Destination(Into variable;$Local) > > Set Query destination(Into current selection) > > Set Query Destination(Into variable;$Local) > > You might see the issue now... > It turns out I never returned the query destination back to Current > Selection. > To make the problem even more challenging, the utility method where the > query was crashing was in a component. > > Interpretedly, 4D was happy to create and type the local any time a > query was executed after query destination was left into a local > variable but... Needless to say compiled/built 4D DID NOT LIKE > THAT! :) > > [TL;DR] > -- always -- reset your query destinations :) > Chip > --- > Gas is for washing parts > Alcohol is for drinkin' > Nitromethane is for racing > ** > 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: Dot Notation in Legacy 4D Code
Narinder: That’s correct - it you’re using dotted notation, you’ll have to clean up the old code. The good news is features in newer versions make that much easier. The Find in design feature is much faster and far more flexible. Once you run a query and the results window opens, you can delete items from the list if you wish, you can drag and drop the content into a method window and then right click to open the methods (or Ctrl K), and you can “Replace in content” from the popup menu on the gears icon in the lower left. -- Douglas von Roeder 949-336-2902 On Thu, Jun 20, 2019 at 10:06 AM Narinder Chandi via 4D_Tech < 4d_tech@lists.4d.com> wrote: > S, I suspected this would be the case but just seeking confirmation... > > I am working with a 4D database that has made extensive use of dot in > table, variable and project names (not of my doing btw!), e.g. > [my.table.name] > my.process.variable > my.project.method > > Converting the database to v17 and enabling the compatibility option "Use > object notation to access object properties" the database still passes > compilation. However, numerous interpreter errors occur when using any > database functionality. I thinks it's clear that all prior dot usage will > have to be totally eliminated?? Urg... > > Regards, > > Narinder Chandi, > ToolBox Systems Ltd. > -- > > > > ** > 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: Developing Using Selector Methods
ot;+String([Proposals]F030_OptionsDiscountRate*100)+"%"
End case
$h_:=PROC_FormEventValues_Clear ($h_)
: ($formEvent_L=On Mouse Leave)
Case of
: ($currentObjectName_T="PROP_Selected_OptnDiscountRateT")
OBJ_GPBN ("PROP_Selected_OptnDiscountRateT")->:=""
End case
$h_:=PROC_FormEventValues_Clear ($h_)
Else
Case of
: ($formEvent_L=On Clicked)
Case of
: ($focusObject_P=(OBJ_GPBN ("PREF_ShowLineNumberscb")))
PrefsPut ("PREF_ShowLineNumberscb";String(OBJ_GPBN
("PREF_ShowLineNumberscb")->=1))
: ($focusObject_P=(->bAccept))
gDirtyRec_Set (True)
: ($currentObjectName_T="@installBy@")
: ($formEvent_L=On Outside Call)
: ($formEvent_L=On Unload)
: ($formEvent_L=On Load)
End case
End case
End case
In order to reduce coupling, there are very few process variables and the
vast majority of the data is passed in the Object. That’s even easier with
C_Object and dotted notation.
Working with this approach, I do wish that QCP was still available but, as
you’ve detailed, it’s no longer available. It its stead, I’ve come to learn
to use the Find function and to use Ctrl/Cmd-L to navigate through the
code.
This approach does result in large methods which would be catastrophic if a
method were to be corrupted. That seems to be a thing of the past,
fortunately, but that situation can be avoided by frequent backups or using
source code repository.
If you were an advocate of the selector method approach, you’ll take to the
form controller. As Kirk mentions, it’s a very useful approach and I’ve
overcome my conceptual concerns by viewing the FC approach as a being a
flexible dispatcher method so I’ve convinced myself that I’m not violating
the “a method should have one clearly defined purpose” guideline.
--
Douglas von Roeder
949-336-2902
On Thu, Jun 20, 2019 at 7:48 AM Narinder Chandi via 4D_Tech <
4d_tech@lists.4d.com> wrote:
> I'm wondering, who out there is still actively developing using selector
> methods?
>
> For a long time now (way back since v6, perhaps even before that...) I
> have tended to encapsulate all of my code into Project Methods such that
> Form and Object level methods consist of nothing more than a Case...End
> Case block of Form Events that then then call an appropriate Project
> Method. We all pretty much work at some time or another with legacy code
> that usually has no conventions whatsoever. Any new code I add to such a
> codebase will follow the selector method convention.
>
> Do you still adhere to the selector method philosophy or have you moved
> onto an alternative 4D programming style? If so, can you describe it and
> why you have found it a better approach than selector methods? It's easy to
> stick with old ways and not adapt to better approaches so I'm interested to
> learn and explore better techniques within 4D.
>
> One of the reasons I am asking this question is that many years ago there
> was the wonderful QuickCode Pro plugin written by Aparajita which sadly
> ceased working with 4D v6, I think. As I recall, prior to that Aparajita
> had privileged access to the 4D source code to enable QCP to work its magic
> but at some point that access was rescinded and QCP sadly reached EOL. QCP
> was perfect for navigating selector methods using the Case tool as this
> technique often results in large methods.
>
> With 4D 2003, I started to write my own QCP toolbar replacement using
> native 4D, at the time using the DynamicStructure plugin (that too has
> disappeared now I think) and some other tricks to read and parse method
> source code. With newer versions of 4D some new possibilities have opened
> up and I am considering re-visiting this project in theory without needing
> to rely on any external plugins. Does anybody already have something like
> this that that they have written for their own use? Would anybody be
> interested in such a 4D component?
>
> Thanks for your thoughts and input.
>
> Regards,
>
> Narinder Chandi,
> ToolBox Systems Ltd.
> --
>
>
>
> **
> 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: v13 - Volume desktop build - windows
Chip: You mean you missed one of the 3 bazillion settings!? :-) -- Douglas von Roeder 949-336-2902 On Fri, Jun 14, 2019 at 2:14 PM Chip Scheide <4d_o...@pghrepository.org> wrote: > Duh! > > Thanks > Chip > On Fri, 14 Jun 2019 14:11:43 -0700, Douglas von Roeder wrote: > > Chip: > > > > In the Build window, you have to specify the file path to the volume > > desktop application. > > > > -- > > Douglas von Roeder > > 949-336-2902 > > > > > > On Fri, Jun 14, 2019 at 2:09 PM Chip Scheide via 4D_Tech < > > 4d_tech@lists.4d.com> wrote: > > > >> I am trying to build an application for use on Windows. > >> > >> - I have a v13 Dev Pro license (recognized by 4D) > >> - I have a v13 Unlimited desktop license (recognized by 4D) > >> - The license manager shows both licenses > >> - the license manager information matches my Mac version (different #s > >> obviously) > >> - The licenses are attached in the 'build' dialog. > >> - the build dialog shows Dev Pr as master, and unlit desktop as > >> subordinate > >> > >> When building I get an error 'unable to find 4D volume desktop' > >> > >> Any Ideas?? > >> > >> Thanks > >> Chip > >> --- > >> Gas is for washing parts > >> Alcohol is for drinkin' > >> Nitromethane is for racing > >> ** > >> 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 > >> ** > --- > Gas is for washing parts > Alcohol is for drinkin' > Nitromethane is for racing > ** 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: v13 - Volume desktop build - windows
Chip: In the Build window, you have to specify the file path to the volume desktop application. -- Douglas von Roeder 949-336-2902 On Fri, Jun 14, 2019 at 2:09 PM Chip Scheide via 4D_Tech < 4d_tech@lists.4d.com> wrote: > I am trying to build an application for use on Windows. > > - I have a v13 Dev Pro license (recognized by 4D) > - I have a v13 Unlimited desktop license (recognized by 4D) > - The license manager shows both licenses > - the license manager information matches my Mac version (different #s > obviously) > - The licenses are attached in the 'build' dialog. > - the build dialog shows Dev Pr as master, and unlit desktop as > subordinate > > When building I get an error 'unable to find 4D volume desktop' > > Any Ideas?? > > Thanks > Chip > --- > Gas is for washing parts > Alcohol is for drinkin' > Nitromethane is for racing > ** > 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: Active4D/ObjectTools with 4D 32-bit
Brian: Could the error message that reads “QLM (1.2.1)” be generated by the QPix License Manager. That’s an image manipulation plugin from the folks at Escape - has that been used in the app at some time? [time passes] Are you still using Free? :-) -- Douglas von Roeder 949-336-2902 On Fri, May 24, 2019 at 8:44 AM Brian Campbell [lists] via 4D_Tech < 4d_tech@lists.4d.com> wrote: > We plan to have 32-bit clients for the next 6-12 months, running v16. > > I am actually encountering an error trying to launch v16.5 Server, 64-bit, > on 64-bit Windows 2012r2. Any call to an OT method, including the register > method, generates an error: > > Incompatible version. You need to upgrade your plugin. > License or privilege error. (ObjectTools (v5.0r1)) > > Even if I disable OT methods on the server, every time a 32-bit Mac client > connects, the server hangs with a dialog: > > Incompatible version. You need to upgrade your plugin. > License or privilege error. (QLM (1.2.1)) > > Launching 32-bit Server has no issues. Removing the ObjectTools.bundle from > plugins of course generates errors for Command not Found, but none of these > error. > > Please advise! We are anxious to get our app into v16 64-bit Server. > > -Brian > > On Mon, Dec 10, 2018 at 12:55 PM Aparajita Fishman via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > > > Hi, > > > > Just wondering how many Active4D or ObjectTools users out there *must* > use > > 32-bit 4D on macOS for the foreseeable future. > > > > I need to know how much longer I need to support 32-bit versions of my > > plugins on macOS. > > > > Many thanks, > > > > - Aparajita > > > > > > ** > > 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 **
Re: Error Can't load component "Foundation_560.4DC".
John: A couple things come to mind. The version of Foundation that I’m using with V17 is 5.7. I think 5.6 will work with the exception with how images display in the toolbar. Walt will be the best source of info on that. I have hit issues with components when they’re compiled only for 32-bit. It could be a long shot but open the source code version of Foundation, compile for both 32 and 64-bit, and then build the component. That could do the trick but, as I see it, that’s solving symptoms. The underlying issue is getting the right version of Foundation and I think 5.7 is the one that you need. [back to lurk mode so I can carry on with my house-moving chores] -- Douglas von Roeder 949-336-2902 On Mon, May 20, 2019 at 2:57 PM JOHN BAUGHMAN via 4D_Tech < 4d_tech@lists.4d.com> wrote: > I am trying to upgrade a v13 database to v17 and am taking it first to > v14. I am working on a Mac but it is deployed on Windows 10. I have it > upgraded on the Mac with everything working including the PKUID fields. > > I plan to test each upgrade step in Windows. After moving the v14 upgrade > over to my Windows 10 VM I get the following error when opening the > database with 4D Server v14.6 (64bit)… > > Error Can't load component "Foundation_560.4DC”. > Error code: -10510 Can't load component "Foundation_560.4DC". > component: '4DRT' task -3, name: 'Client Manager’ > Error code: 6 Could not find compiled runtime information while > loading database or component "Foundation_560". component: '4dcm' task -3, > name: 'Client Manager' > > It works fine with the interpreted version of Foundation. I tried building > the compiled version in windows and still get the error. > > I can deploy interpreted, but wondering if why I am getting the error > compiled. > > Thanks > > John > > > > John Baughman > Kailua, Hawaii > (808) 262-0328 > john...@hawaii.rr.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: 4D Write Pro: License or privilege error
John: "And "$wpDoc:=WP New” generates the same error.” OK, understood. That’s an error because it should be returning a 4DWP object. My question about passing an empty BLOB stems from the docs which indicate that you can’t pass a parameter that doesn’t have content. I suspect that would give an error other than 9949. -- Douglas von Roeder 949-336-2902 On Tue, May 14, 2019 at 5:14 PM John J Foster wrote: > Hi Doug, > > Yes the BLOB is empty. > > I upgraded a client from 4D 2012 (windows) to 4D v17. However in the v12 > version the 4D Write docs were still being saved in a picture field. The 4D > Write Pro migration tools specifically is designed too handle converting > those Write pictures to Write Pro objects. OT so I thought! > > But it’s receiving a picture field and returning no BLOB to give to the 4D > Write Pro doc. > > So… > > John... > > > When I look at the docs for WP New, $1 is a optional parameter. If passed > as a BLOB, the content of the BLOB should be either a 4D Write Pro document > or a 4D Write document. It doesn’t appear that an empty BLOB is acceptable > as a parameter. I might have missed it in the earlier email but is your > $blob contain a document or is it just an empty BLOB? > > -- > Douglas von Roeder > 949-336-2902 > > > On Tue, May 14, 2019 at 4:41 PM John J Foster via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > >> Hi Pat, >> >> Yes $blob has been defined in each method. >> >> And "$wpDoc:=WP New” generates the same error. >> >> John… >> >> > >> > Has $blob been defined? >> > Do you get the error if you call: >> > >> > $wpDoc:=WP New >> >> ** >> 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 Write Pro: License or privilege error
John: When I look at the docs for WP New, $1 is a optional parameter. If passed as a BLOB, the content of the BLOB should be either a 4D Write Pro document or a 4D Write document. It doesn’t appear that an empty BLOB is acceptable as a parameter. I might have missed it in the earlier email but is your $blob contain a document or is it just an empty BLOB? -- Douglas von Roeder 949-336-2902 On Tue, May 14, 2019 at 4:41 PM John J Foster via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Hi Pat, > > Yes $blob has been defined in each method. > > And "$wpDoc:=WP New” generates the same error. > > John… > > > > > Has $blob been defined? > > Do you get the error if you call: > > > > $wpDoc:=WP New > > ** > 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: Managing 4D Server as a service
John: I see that Tim surfaced this in another thread. -- Douglas von Roeder 949-336-2902 On Fri, May 10, 2019 at 1:20 PM Douglas von Roeder wrote: > John: > > I have one system that’s a built app that runs as a service. Maybe this > applies to your situation. > > When I put out a new structure, I launch the app by choosing the .exe, do > a right mouse and select “Run as administrator”, select the datafile, and > let the app launch. Once it’s running, I launch the built client app, > ensure that the update runs, and then quit the client app. That sequence > ensures that the server has the data file path, that it can respond to > requests, that it can serve the new code, and that the client can update > and connect. > > Next step is to quit 4D Server, start the service running, and log into it > with the built client app. > > I realize that the built server/client is a little different but maybe > launching the server manually would help in your situation. > > -- > Douglas von Roeder > 949-336-2902 > > > On Fri, May 10, 2019 at 1:04 PM JOHN BAUGHMAN via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > >> Well, last night I tried to start the service on the client’s production >> machine and I could not get it to work. >> >> After registering the service from 4D server, I tried starting the >> service from the Service Manager and it indicated that it had started up >> but I was unable to establish a connection using a 4D client. On my VM >> Interactive Services takes a while to show up in the task bar after a >> restart, but it eventually does. On the production server, it never makes >> an appearance. So I have no other way to see it the server is running >> properly. >> >> I then restarted the computer with the service set to start >> automatically. Again I was unable to establish a connection with 4D Client. >> I tried both manually and automatically a few times without success. Each >> time I tried to start up 4D Server normally and on at least one occasion 4D >> asked if I wanted to open the database in Read Only mode, which tells me >> the service had opened the datafile. On other tries, I was able to open the >> database normally. >> >> A couple of other things to note. >> 1. A year or so ago I was investigating the ins and outs of >> running as a service on this same machine and I was able to get everything >> to work. >> >> 2. I have the service 4D’s Application Server listening on port >> 19816 as I have another 4D server running a different database on the same >> box opened normally (not as a service) listening on port 19813. It only >> opens after the Admin user logs in. They both work fine together when both >> are opened normally. >> >> 3. The service 4D is also running a web server which respond to >> requests from a Xojo WebApp running on the same machine. Those requests >> fail when 4D Server is supposedly >> running as a service. >> >> 5. Finally of note is that when the Xojo WebApp is opened as a >> Service it will not open as it unexpectedly quits on startup. All of this, >> Xojo and 4D Server work just fine on my VM and all worked fine a year ago >> when I first started researching things on the production machine. The >> folks at Xojo suggest that my WebApp may be trying to access a file that >> the service does not have access to. Tonight I will be trying to get the >> Xojo service to work with no file access queries in the WebApps startup >> events. >> >> I think that the inability to start both the Xojo WebApp and 4D as >> services is related and may be encountering an issue with the OS, which may >> have different updates than my VM. The production machine has been >> religiously updated by windows over the year,, my VM not so much. >> >> Any suggestions? >> >> Thanks, >> >> John >> >> ** >> 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: Managing 4D Server as a service
John: I have one system that’s a built app that runs as a service. Maybe this applies to your situation. When I put out a new structure, I launch the app by choosing the .exe, do a right mouse and select “Run as administrator”, select the datafile, and let the app launch. Once it’s running, I launch the built client app, ensure that the update runs, and then quit the client app. That sequence ensures that the server has the data file path, that it can respond to requests, that it can serve the new code, and that the client can update and connect. Next step is to quit 4D Server, start the service running, and log into it with the built client app. I realize that the built server/client is a little different but maybe launching the server manually would help in your situation. -- Douglas von Roeder 949-336-2902 On Fri, May 10, 2019 at 1:04 PM JOHN BAUGHMAN via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Well, last night I tried to start the service on the client’s production > machine and I could not get it to work. > > After registering the service from 4D server, I tried starting the service > from the Service Manager and it indicated that it had started up but I was > unable to establish a connection using a 4D client. On my VM Interactive > Services takes a while to show up in the task bar after a restart, but it > eventually does. On the production server, it never makes an appearance. So > I have no other way to see it the server is running properly. > > I then restarted the computer with the service set to start automatically. > Again I was unable to establish a connection with 4D Client. I tried both > manually and automatically a few times without success. Each time I tried > to start up 4D Server normally and on at least one occasion 4D asked if I > wanted to open the database in Read Only mode, which tells me the service > had opened the datafile. On other tries, I was able to open the database > normally. > > A couple of other things to note. > 1. A year or so ago I was investigating the ins and outs of > running as a service on this same machine and I was able to get everything > to work. > > 2. I have the service 4D’s Application Server listening on port > 19816 as I have another 4D server running a different database on the same > box opened normally (not as a service) listening on port 19813. It only > opens after the Admin user logs in. They both work fine together when both > are opened normally. > > 3. The service 4D is also running a web server which respond to > requests from a Xojo WebApp running on the same machine. Those requests > fail when 4D Server is supposedly > running as a service. > > 5. Finally of note is that when the Xojo WebApp is opened as a > Service it will not open as it unexpectedly quits on startup. All of this, > Xojo and 4D Server work just fine on my VM and all worked fine a year ago > when I first started researching things on the production machine. The > folks at Xojo suggest that my WebApp may be trying to access a file that > the service does not have access to. Tonight I will be trying to get the > Xojo service to work with no file access queries in the WebApps startup > events. > > I think that the inability to start both the Xojo WebApp and 4D as > services is related and may be encountering an issue with the OS, which may > have different updates than my VM. The production machine has been > religiously updated by windows over the year,, my VM not so much. > > Any suggestions? > > Thanks, > > John > > ** > 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: RRe: 4D 17.1 network issues
Allan: " the client connections to 4D Server v17 are flakey and not as good as they've been in the past :-(“ That’s my impression, as well. (To clarify, the posting was under my name but was for a client who, at the time, was subscribed via the digest.) Looking back over the 10+ years since V11, that version (which I’ve dubbed “4D Vista”) did set the low water mark but the dot releases of V11 went a long way to cleaning things up. I didn’t use V11, opting to join the fray with V12. The system my client was describing was started in V6, IIRC. It was moved to 2004, then V12/13 and then V15. V15 was a very solid version, with this issue arising only with V17R3. Networking is a topic that has come up on the 4D Forum over the years and the position that Thomas Maul seems to be that the code, as far as they are able to determine, is functioning as they expect so these are edge conditions that they’re not able to resolve. Thomas has indicates that 4D does want to resolve the issues so, if there is a way that the behaviors can be reproduced, they want to know about it. That's my interpretation of the message threads on the Forum over the years. -- Douglas von Roeder 949-336-2902 On Mon, Apr 29, 2019 at 6:56 PM Allan Udy (Golden Micro) wrote: > > From: Douglas von Roeder > > To: 4D iNug Technical <4d_tech@lists.4d.com> <4d_tech@lists.4d.com> > Subject: Re: 4D 17.1 network issues > > I can confirm this same issue on v17r3 on Windows 64 bit client and server > running Windows Server 12r2 Datacenter. In addition, the server will > refuse connection until somebody touches the server admin window at which > point it will accept connections again. > > > Doug, for some months we've been having on-going issues with v17R3 server > (on Windows Server 12) autonomously set the 'Reject New Connections' button > on the Application Server page of the Server Admin window (so that it now > reads 'Accept New Connections'). > > When this happens we've found the only way that clients can reconnect > again is if we restart the 4D server. > > Having said all of this, we haven't seen the issue for a couple of weeks, > and that 'could' be related to changing back to the Legacy Network Layer -- > not confirmed yet. > > We've also had other Client disconnection issues where the 'New > Connections' button has not magically be changed, but client apps still > cannot connect. All in all our experience is that in some regards the > client connections to 4D Server v17 are flakey and not as good as they've > been in the past :-( > > Cheers, > Allan Udy > > Golden Micro Solutions Ltd, Blenheim, New Zealand > http://www.golden.co.nz <http://www.golden.co.nz> > > ** 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: Custom Form Events
Chris:
"I prefer to reduce the number of Project Methods”
My thoughts about programming were strongly influenced by McConnell and a
few others. None of them discuss limiting the number of methods. Their
focus is on when and why to create a method and how those routines
interact. If reducing the number of methods is a desired attribute of code,
how do you know when you’ve got the right number?
"this same logic must be performed whenever City or Province changes.”
That’s sounds a lot like On data change in the GUI or using the Old
function in a trigger. Using the form controller approach, I put code in
each active object, Alternatively, you can put the code in the form method
but I ran into issues with not being able to trap events from tab controls
correctly so I decided to put code in each active object.
Here’s the code from an object:
C_LONGINT($formEvent_L)
$formEvent_L:=Form event
Case of
: ($formEvent_L=On Clicked) | ($formEvent_L=On Double Clicked)
PROC_FormEventValues_Assign (PROC_Object)
PROC_TablePtr_Set (PROC_Object;->[Ledger])
DISBURSEMENT_FC (PROC_Object)
End case
That code is put in place by a macro - all I have to do is change the
events to which it responds. PROC_Object is a process variable (gotta have
one).
The code in _Assign:
C_OBJECT($O_;$1)
$O_:=$1
//OB Set is blowing up when assigned a nil pointer
//PROC_FocusObjectPtr_Set ($O_;OBJ_FocusPtr_Return )
PROC_FocusObjectName_Set ($O_;OBJ_FocusName_Return )
PROC_CurrentObjectPtr_Set ($O_;OBJ_CurrentPtr_Return )
PROC_CurrentObjectName_Set ($O_;OBJ_CurrentName_Return )
PROC_FormEvent_Set ($O_;Form event)
PROC_gTablePtr_Set ($O_;gTablePtr_Get )
PROC_CurrentFormPage_Set ($O_;FORM Get current page)
C_TEXT($FB0521)
//dvonroeder 20170201 {0521}
PROC_CurrentFormTable_Set ($O_;Current form table)
PROC_CurrentFormName_Set ($O_;Current form name)
That is then passed to a form controller method which reads the values in
the object and then dispatches the code.
Here’s the example code for the form controller
C_LONGINT($formEvent_L)
$formEvent_L:=PROC_FormEvent_Get ($O_)
C_TEXT($currentObjectName_T)
$currentObjectName_T:=PROC_CurrentObjectName_Get ($O_)
Case of
: ($formEvent_L=On Clicked)
: ($formEvent_L=On Mouse Enter)
: ($formEvent_L=On Load)
: ($formEvent_L=On Selection Change)
End case
PROC_FormEventValues_Clear ($O_)
Kirk’s presentation at the Summit showed using Form event inside the FC -
my preference is to pass a parameter. My argument is that using Form event
inside the FC increases the level of coupling. I have similar reservations
about the use of Form. but I do accept that it is called a “*form*
controller”, so there’s that…
This code pattern has worked quite well for me but I haven’t rethought
things in light of ORDA or dotted notation.
This does create large methods but they’re dispatcher methods, basically,
and it does supports the basic tenets of good procedural programming,
including the idea that a method should perform one specific function.
What strikes me about the approach that it sounds like you’re taking is
that you’re moving in the direction of larger method to satisfy a desire
for fewer methods. What’s the goal there?
--
Douglas von Roeder
949-336-2902
On Wed, Apr 24, 2019 at 9:37 PM Chris Belanger via 4D_Tech <
4d_tech@lists.4d.com> wrote:
> Hi Kirk,
>
> to explain what I want to have ‘custom events’ for, I think Justin Carr’s
> comment on this thread gives some good reason — to do processing after an
> on LOAD that cannot be done during that event since many objects on the
> form do not exist at the time of on load.
> In my efforts to create as generic of a system as possible (which OBJECTS
> help greatly in), some objects in a Form do not ‘exist’ during ON LOAD; but
> I need to initialize structures BEFORE the form starts operating and only
> at the initialization stage (on Load).
>
> Once 4D **finally** makes it possible to programmatically get/set all the
> listBox properties in a collection/entity selection-based listbox
> (particularly data source, current item, current item position, selected
> items) then I would be in position to make use of that information in the
> custom event that would run immediately after ON LOAD (as Justin described).
>
>
> Another use for it that I have not explored yet is to have a chunk of code
> that gets run under several different circumstances, but which I don’t want
> to make a dedicated Project Method for it.
> I prefer to reduce the number of Project Methods while, of course,
> creating ones that make logical sense (as they can be called in several
> places in my code). But you understand that as a programmer.
>
> One simple instance I want to experiment on — which, of course, is
> trivial, is:
>
> I have three fields (actually object attributes)
> City
> Province (or State)
> FullCityName
>
> FullCityName is computed from City
Re: 4D 17.1 network issues
A client of mine has hit this very issue. He writes: >> In addition to the dropped connections, it has also been reported 4D will freeze up for a brief period and become unresponsive, then after about 15-20 seconds will begin responding again. No problems like this reported with 16.4 on the same network.<< I can confirm this same issue on v17r3 on Windows 64 bit client and server running Windows Server 12r2 Datacenter. In addition, the server will refuse connection until somebody touches the server admin window at which point it will accept connections again. -- Douglas von Roeder 949-336-2902 On Wed, Apr 24, 2019 at 10:39 AM John DeSoi via 4D_Tech < 4d_tech@lists.4d.com> wrote: > It is a link-local address (see > https://en.wikipedia.org/wiki/Link-local_address), sometimes called > self-assigned. There is nothing wrong with DHCP. As I mentioned in the > previous message, you get this for WiFi on the Mac when Wifi is not > connected or marked as inactivated. Seems strange, but hopefully it does > not impact anything. > > John DeSoi, Ph.D. > > > > On Apr 24, 2019, at 11:28 AM, Peter Bozek wrote: > > > > 169.x.x.x seems like a self-assigned address, could it be you have some > problem with DHCP? > > ** > 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: Engined App
Chip: That’s a licensing issue. I checked a few years back and the price was $3k. -- Douglas von Roeder 949-336-2902 On Wed, Apr 24, 2019 at 9:43 AM Chip Scheide via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Can the 'splash' on exit of an engined application be removed? > > Chip > --- > Gas is for washing parts > Alcohol is for drinkin' > Nitromethane is for racing > ** > 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: Setting to not Open Methods into One Window
Jeff: Well, I appreciate you doing the sleuthing and it does appear that this feature has had a checkered history in OS X. One of the options was to use the setting from System Prefs. I wasn't familiar with that so I did some Goolging and, from what I was able to find, there was a feature in macOS Sierra under the Dock settings. But of course - a setting to control tabs falls under in Dock category. I'm using 10.11 and 10.13 and not able to find the setting in those OS's. Hmm, a bit more digging and, apparently, it's back in the Dock settings in 10.14. <https://support.apple.com/en-ca/guide/mac-help/use-tabs-in-windows-mchla4695cce/mac> Agreed, it does seem rather strange. Fortunately, there's a way to toggle it but, given that it was hit and miss in OS X itself, I wonder how long it will stick around. -- Douglas von Roeder 949-336-2902 On Tue, Apr 23, 2019 at 8:38 PM Jeffrey Kain wrote: > It’s a strange setting. I couldn’t find it either and ended up posting a > question too. > > So bizarre! > > > On Apr 23, 2019, at 10:57 PM, Douglas von Roeder > wrote: > > > > Jeffrey: > > > > You mean the one labeled “Window tabbing (macOS only)”? :-) > > > > I simply did not see it. > ** 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: Setting to not Open Methods into One Window
Jeff: That’s what I was expecting but I don’t see a setting that allows me to shut it off. Which “tab” would it be under? -- Douglas von Roeder 949-336-2902 On Tue, Apr 23, 2019 at 3:08 PM Jeffrey Kain via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Use tabbed windows setting in 4D prefs? > > > On Apr 23, 2019, at 6:03 PM, Douglas von Roeder via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > > > > Using V17R3 64-bit on the Mac and methods are opening in the main window. > > > > Is there a was to change this behavior? > ** > 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 **
Setting to not Open Methods into One Window
Using V17R3 64-bit on the Mac and methods are opening in the main window. Is there a was to change this behavior? -- Douglas von Roeder 949-336-2902 ** 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: Custom Form Events
Chris: IIRC, it was Olivier DesChanels who published that. You might drop him a line - he’s on the Forum. -- Douglas von Roeder 949-336-2902 On Tue, Apr 23, 2019 at 8:40 AM Douglas von Roeder wrote: > Chris: > Could well be Set timer(-1) - that was on the 4D forum a few years back. I > haven’t tried approach, personally. > > -- > Douglas von Roeder > 949-336-2902 > > > On Tue, Apr 23, 2019 at 8:24 AM Chris Belanger via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > >> Douglas, that is an ingenious way to facilitate it. I suppose one could >> use a Form object (Form.myEvent) to specify the ‘event’ to perform. >> But it seems that SET TIMER(-1) is what needs to be done [trigger as soon >> as possible] and then SET TIMER(0) disables the triggering? >> >> — Chris >> >> > On Apr 23, 2019, at 9:19 AM, Douglas von Roeder via 4D_Tech < >> 4d_tech@lists.4d.com> wrote: >> > >> > Chris: >> > >> > Set timer (0) and then catch it in On timer. >> > >> > -- >> > Douglas von Roeder >> > 949-336-2902 >> > >> > >> > On Tue, Apr 23, 2019 at 8:17 AM Chris Belanger via 4D_Tech < >> > 4d_tech@lists.4d.com> wrote: >> > >> >> I have been using New formula too. >> >> In the context of ORDA-based forms, I have set up Form.onSave(), >> >> Form.onLoad(), Form.onNew() etc. I like it because the code for record >> >> selection and change can be generic with these ’nubs’. >> >> I wish that one did not have to create a project method [for other than >> >> the most rudimentary use] to use ’New Formula’, but still it is a >> great new >> >> feature. >> >> >> >> In any case, back to my question about form events. Is the only >> mechanism >> >> to do an ‘Outside Call’ with POST OUTSIDE CALL? What have you found >> that >> >> works, if anything. >> >> >> >> >> >>> On Apr 23, 2019, at 9:05 AM, Keisuke Miyako via 4D_Tech < >> >> 4d_tech@lists.4d.com> wrote: >> >>> >> >>> I think the future is to use New formula. >> >>> >> >>> it is like a function pointer in other languages, >> >>> it allows the callee to invoke a callback function at a later time. >> >>> >> >>> https://blog.4d.com/new-formula-more-power-behind-simplicity/ >> >>> >> >>> alternatively, one could say that CALL FORM is like a custom form >> event. >> >>> >> >>> regarding subforms, >> >>> CALL SUBFORM CONTAINER can only convert an event in the subform >> context >> >>> to another event in the host's context, >> >>> it does not generate a new event. >> >>> >> >>> 2019/04/23 23:32、Chris Belanger via 4D_Tech <4d_tech@lists.4d.com >> >> <mailto:4d_tech@lists.4d.com>>のメール: >> >>> >> >>> I remember — but cannot find again — some documentation that talked >> >> about using negative-numbered values for events to facilitate custom >> >> events. However, I seem to remember it only was in the context of >> subforms. >> >>> >> >>> >> >>> >> >>> ** >> >>> 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 >> > ** >> >> ** >> 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: Custom Form Events
Chris: Could well be Set timer(-1) - that was on the 4D forum a few years back. I haven’t tried approach, personally. -- Douglas von Roeder 949-336-2902 On Tue, Apr 23, 2019 at 8:24 AM Chris Belanger via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Douglas, that is an ingenious way to facilitate it. I suppose one could > use a Form object (Form.myEvent) to specify the ‘event’ to perform. > But it seems that SET TIMER(-1) is what needs to be done [trigger as soon > as possible] and then SET TIMER(0) disables the triggering? > > — Chris > > > On Apr 23, 2019, at 9:19 AM, Douglas von Roeder via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > > > > Chris: > > > > Set timer (0) and then catch it in On timer. > > > > -- > > Douglas von Roeder > > 949-336-2902 > > > > > > On Tue, Apr 23, 2019 at 8:17 AM Chris Belanger via 4D_Tech < > > 4d_tech@lists.4d.com> wrote: > > > >> I have been using New formula too. > >> In the context of ORDA-based forms, I have set up Form.onSave(), > >> Form.onLoad(), Form.onNew() etc. I like it because the code for record > >> selection and change can be generic with these ’nubs’. > >> I wish that one did not have to create a project method [for other than > >> the most rudimentary use] to use ’New Formula’, but still it is a great > new > >> feature. > >> > >> In any case, back to my question about form events. Is the only > mechanism > >> to do an ‘Outside Call’ with POST OUTSIDE CALL? What have you found that > >> works, if anything. > >> > >> > >>> On Apr 23, 2019, at 9:05 AM, Keisuke Miyako via 4D_Tech < > >> 4d_tech@lists.4d.com> wrote: > >>> > >>> I think the future is to use New formula. > >>> > >>> it is like a function pointer in other languages, > >>> it allows the callee to invoke a callback function at a later time. > >>> > >>> https://blog.4d.com/new-formula-more-power-behind-simplicity/ > >>> > >>> alternatively, one could say that CALL FORM is like a custom form > event. > >>> > >>> regarding subforms, > >>> CALL SUBFORM CONTAINER can only convert an event in the subform context > >>> to another event in the host's context, > >>> it does not generate a new event. > >>> > >>> 2019/04/23 23:32、Chris Belanger via 4D_Tech <4d_tech@lists.4d.com > >> <mailto:4d_tech@lists.4d.com>>のメール: > >>> > >>> I remember — but cannot find again — some documentation that talked > >> about using negative-numbered values for events to facilitate custom > >> events. However, I seem to remember it only was in the context of > subforms. > >>> > >>> > >>> > >>> ** > >>> 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 > > ** > > ** > 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: Custom Form Events
Chris: Set timer (0) and then catch it in On timer. -- Douglas von Roeder 949-336-2902 On Tue, Apr 23, 2019 at 8:17 AM Chris Belanger via 4D_Tech < 4d_tech@lists.4d.com> wrote: > I have been using New formula too. > In the context of ORDA-based forms, I have set up Form.onSave(), > Form.onLoad(), Form.onNew() etc. I like it because the code for record > selection and change can be generic with these ’nubs’. > I wish that one did not have to create a project method [for other than > the most rudimentary use] to use ’New Formula’, but still it is a great new > feature. > > In any case, back to my question about form events. Is the only mechanism > to do an ‘Outside Call’ with POST OUTSIDE CALL? What have you found that > works, if anything. > > > > On Apr 23, 2019, at 9:05 AM, Keisuke Miyako via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > > > > I think the future is to use New formula. > > > > it is like a function pointer in other languages, > > it allows the callee to invoke a callback function at a later time. > > > > https://blog.4d.com/new-formula-more-power-behind-simplicity/ > > > > alternatively, one could say that CALL FORM is like a custom form event. > > > > regarding subforms, > > CALL SUBFORM CONTAINER can only convert an event in the subform context > > to another event in the host's context, > > it does not generate a new event. > > > > 2019/04/23 23:32、Chris Belanger via 4D_Tech <4d_tech@lists.4d.com > <mailto:4d_tech@lists.4d.com>>のメール: > > > > I remember — but cannot find again — some documentation that talked > about using negative-numbered values for events to facilitate custom > events. However, I seem to remember it only was in the context of subforms. > > > > > > > > ** > > 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 **
