Re: ORDA and 4D selections

Hi Chuck, You can use the command USE ENTITY SELECTION to convert the resulting entity selection to a current selection of that corresponding table. https://doc.4d.com/4Dv17/4D/17.1/USE-ENTITY-SELECTION.301-4179710.en.html

Re: Count in Text

Not sure what you are really asking for. I think you have to roll your own in any case if you have text as follows: $string:="this is a test of the find in string. in case you missed the point." To find "the" There are multiple ways, one is to parse the text into arrays based up words and find

Re: Hierarchical Listbox Row with leading Icon (like hierarchical list)

Hi Kirk, I wouldn’t miss it! Good to know. Tks, John… > From: Kirk Brooks mailto:lists.k...@gmail.com>> > > Hey John, > If you can make it to the World Tour JPR has a v17 listbox demo that does > this. ** 4D Internet Users

Re: ORDA and 4D selections

Thanks I knew it was there but couldn’t find it. Sometimes I wish we still only had 100s of commands instead of what we have Regards Chuck Sent from my iPhone > On Apr 9, 2019, at 2:36 PM, ericklui678 via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Hi Chuck, > > You can use the command USE

Re: ORDA and 4D selections

“There are simply too many notes.” -- Douglas von Roeder 949-336-2902 On Tue, Apr 9, 2019 at 12:01 PM cjmiller--- via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Thanks I knew it was there but couldn’t find it. Sometimes I wish we still > only had 100s of commands instead of what we have > >

relation names

Hi All, On page 192 of the desgn reference. It states Relations created via SQL The appearance of relations is different when they have been generated via SQL (square shaped connectors): OK I see that but see no way of creating the relations. Can anyone advise If I can not do this I want to

ORDA and 4D selections

Hi all, is there any way to perform a query using ORDA and create a current selection or set from the result. Thanks and regards Chuck -- - Chuck Miller Voice: (617) 739-0306 Fax: (617) 232-1064

Re: Count in Text

thanks all -pm On Tue, Apr 9, 2019 at 9:44 PM Keith Culotta via 4D_Tech < 4d_tech@lists.4d.com> wrote: > That is true. If it's not a character count that is needed, this would > break words. DISTINCT VALUES, GET TEXT KEYWORDS, and Count in array would > help in that case. > > > On Apr 9, 2019,

Re: Count in Text

...and this. It's probably slower than using Position, but I'd have to test to be sure. (3 Lengths and 1 Replace string) C_LONGINT($count;$len1;$len2;$lenFind) $string:="This message and any attached documents contain information which maybe confidential, subject to privilege or exempt from

Re: Count in Text

That will not work, as you would also change then, therefore etc. I did not think it 100% through, but putting in an array would solve the problem as you could see if position = search word and only increment when iot did. You would also have to decide is The = the etc Regards Chuck On Tue, Apr

Count in Text

Hi Is there a 4D command that will count the number of occurences of character, in string thanks -pm ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options:

Re: Collection of JSON Arrays to a Flat Array

Sortof nevermind. It’s actually crazy easy with nested for each loops. I’m really liking these for each loops! ARRAY REAL($aAllLessons;0) For each ($thisLessonArray;$oLessons) For each ($thisLesson;$thisLessonArray) APPEND TO ARRAY($aAllLessons;$thisLesson) End for each End for each Sannyasin

Re: ORDA and 4D selections

Chuck, There is no reason to use ORDA if you need a regular selection. Just use the classic 4D query commands. On Tue, Apr 9, 2019 at 2:27 PM Charles Miller via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Hi all, > > is there any way to perform a query using ORDA and create a current > selection or

RE: Error connecting to 4D Server

Keith White We first saw many of these symptoms with v16R6 using the new network layer ... using v16R6 with the new network layer, we did get mass disconnections occurring and also seeing the Admin window changing the Accept/Reject by itself.  So after a mass disconnection, new

Collection of JSON Arrays to a Flat Array

Aloha, Is there an easy way to make an collection of JSON arrays into a single flat array using the new ORDA collection commands? Here’s a screenshot of the data: https://www.dropbox.com/s/mmjrxfn4t2umejh/collectiontoarray.png?dl=0 If there’s no easy way, I can loop through and manually do it,

v17 Print Settings in a form's Property List

I'm running v17.1 in a Windows 10 client/server environment. In the Design environment, when I click on the Print Settings button in a form's Property List, I get a Print dialog, not the usual Print Settings (Page Setup) dialog. Is that a bug or a feature?

Re: v17 Print Settings in a form's Property List

I think this is the new (64-bit) behaviour for dialType:0 https://doc.4d.com/4Dv17/4D/17.1/PRINT-SETTINGS.301-4179613.en.html that said, the Design Reference is a bit vague on this point https://doc.4d.com/4Dv17/4D/17.1/Printing-a-form.300-4201214.en.html "A Print Setup dialog box appears,

RE: Error connecting to 4D Server

Stephen J. Orth: > What we get are the multiple errors that started this thread, where already > connected clients simply can no longer talk to the server. Either you get > the -10002/3/4 error message, or the one that is happening mostly is the > "non-blocking" error. I encounter those from

Re: LEP - hide console?

Hi Pat, Call SET ENVIRONMENT VARIABLE("_4D_OPTION_HIDE_CONSOLE";"true") before calling LEP HTH Bruno ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options:

MAXIMUM NUMBER REACHED

hi all, In one application I use 4D V12 on Windows. I have 16 available simultaneous connections but sometimes, after the seventh client connected, during the eighth connection I have the message that says " maximum connections number reached ". Someone have a solution? Thanks Ferdinando

Re: Hierarchical Listbox Row with leading Icon (like hierarchical list)

Hey John, If you can make it to the World Tour JPR has a v17 listbox demo that does this. On Mon, Apr 8, 2019 at 8:55 PM John J Foster via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Hi All, > > I’m trying to duplicate the look and feel (in as much as it’s possible) of > a hierarchical list but

RE: Error connecting to 4D Server

Bernd, Hello... Yes, we are aware that this is potentially network related, but try explaining that to a customer and not have them think your pointing fingers, or passing the blame. The biggest issue is we are getting these errors from a Client that is running on the Server. Steve

Re: Hierarchical Listbox Row with leading Icon (like hierarchical list)

Hey Doug, I have a simple hierarchical list of for example different kinds of charts (pie, bar, scatter, etc.): Company name at level 1 Charts at level 2 (there will be one or more) Another column at level 2 but hidden. I’d like to have a company icon displayed at level 1 I’d like a different

Re: LEP - hide console?

So simple! thanks guys. On Tue, 9 Apr 2019 at 11:39, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> wrote: > Hi Pat, > > Did you try calling SET ENVIRONMENT VARIABLE with the > _4D_OPTION_HIDE_CONSOLE option? It works with normal batch windows... not > sure about PowerShell windows. > > >

Re: Error connecting to 4D Server

Steve: I agree with you 100%. It does not matter that we are right, if the client and their ‘network / hardware experts’ are telling them we are at fault. I have shown in person the problems on the network or on the servers. Absolute obvious problems. I have documented them with written

RE: LEP - hide console?

SET ENVIRONMENT VARIABLE("_4D_OPTION_HIDE_CONSOLE";"true") And see: https://doc.4d.com/4Dv17/4D/17.1/LAUNCH-EXTERNAL-PROCESS.301-4178683.en.html 9. To launch a command with the current directory and without displaying the console: SET ENVIRONMENT

LEP - hide console?

So I now have a Powershell script which converts a Word document to PDF. Unfortunately it briefly shows the Powershell console window when it starts the script, which is rather ugly and I would prefer not to inflict it upon my users. Is there any way to prevent it from appearing? Here's my LEP

Re: LEP - hide console?

Hi Pat, Did you try calling SET ENVIRONMENT VARIABLE with the _4D_OPTION_HIDE_CONSOLE option? It works with normal batch windows... not sure about PowerShell windows. https://doc.4d.com/4Dv15/4D/15.6/SET-ENVIRONMENT-VARIABLE.301-3817570.en.html Jeff > On Apr 9, 2019, at 5:34 AM, Pat Bensky