Re: OK to Run 4D V13.5 on Windows 2016?
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 **
Re: Writing 4D Data into an Excel Template
Ron As Pat said Robs plug-in is the go to solution for anything excel On Thu, Aug 13, 2020 at 8:24 PM Tarawerkz via 4D_Tech <4d_tech@lists.4d.com> wrote: > Hi Pat, > > > > Thanks for the mail. Yes, I had written to Rob himself for his opinion > too. > > > > I’m quite sure his plugin would be of great help in this project and have > included it as part of the proposal to the client. > > Thanks again. > > > > Regards, > > Ronnie > > Tarawerkz > > > > > > > > > > ** > > 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 > > ** -- * Randy Engle 415.250.9111 randy.en...@gmail.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 **
Non-Technical Topic: Chicago Summit Vinofest - Monday Mar. 30
Hi my dear 4Ders, Yet, once again, (likely to be the last...alas) My wife Sara and I will be hosting the 4D "Vinofest" in our room on Monday Mar. 30 after 6:00 PM This started years ago, as 2-4 people bringing a bottle of wine or two (Thanks, Jack D.!) to share at the meet and greet event. Over time, this morphed into seeing how many people we could stuff into a regular sized room (28 at last count), until security came at 11:00 PM and threw everyone out. And then we finally booked a suite to handle a larger group. All are welcome. If you would like, bring wine or beer, Pelligrino, Cognac, Sauternes, or whatever to share if you are so moved, by no means required. Food/Snacks/Goodies are always welcome as well It's not a huge space, but big enough to hold a small group for rich conversation, technical/4D or otherwise. Randy Engle Email: randy.en...@gmail.com <mailto:randy.en...@gmail.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 **
Automatic Excel to Text-tab delimited? - Code Sample
Kirk, Rob's plugin + below code should get you what you need: Randy Engle // Method: // EXCEL_TO_TAB_TEXT // // User name (OS): Randy // Date and time: 12/12/2019, 15:33:17 // // Description // bld2770 // // V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^ // V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^ // V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^ C_LONGINT($book) C_LONGINT($sheet) C_LONGINT($startRow) C_LONGINT($count_Rows) C_LONGINT($startCol) C_LONGINT($count_Columns) C_TEXT($documentPath;$1) C_TEXT($text_Value) C_TEXT($packet) C_TIME($doc_Ref) $doc_Ref:=?00:00:00? $documentPath:=$1 //$documentPath:=System folder(Desktop)+"export.xlsx" $CR:=Char(13)+Char(10) Case of : (Test path name($documentPath)=Is a document) $text_doc:=Replace string($documentPath;"xlsx";"txt") $doc_Ref:=Create document($text_doc) End case Case of : ($doc_Ref=?00:00:00?) // Not created Else $book:=xlBookLoadFile ($documentPath) If ($book#0) // Get a reference to the first sheet $sheet:=xlBookGetSheet ($book;1) $startRow:=xlSheetGetFirstRow ($sheet) $count_Rows:=xlSheetGetLastRow ($sheet) $startCol:=xlSheetGetFirstColumn ($sheet) $count_Columns:=xlSheetGetLastColumn ($sheet) Open window(200;200;800;400;4;"Importing") For ($row;1;$count_Rows) $packet:="" For ($column;1;$count_Columns) $text_Value:="" $type:=xlSheetCellType ($sheet;$row;$column) Case of : ($type=xlCellType_Empty) // 0 : ($type=xlCellType_Number) //1 $num_Value:=xlSheetGetCellNumber ($sheet;$row;$column) $text_Value:=String($num_Value) : ($type=xlCellType_String) //2 $text_Value:=xlSheetGetCellText ($sheet;$row;$column) : ($type=xlCellType_Boolean) //3 $bool_Value:=xlSheetGetCellBoolean ($sheet;$row;$column) $text_Value:=String($bool_Value) : ($type=xlCellType_Blank) //4 : ($type=xlCellType_Error) //5 End case $packet:=$packet+$text_Value Case of : ($column=$count_Columns) $packet:=$packet+Char(13)+Char(10) Else $packet:=$packet+Char(9) End case End for SEND PACKET($doc_Ref;$packet) MESSAGE(String($row)+" of "+String($count_Rows)+$CR) End for xlBookRelease ($book) CLOSE WINDOW
RE: 4D Web Server Security
Richard, Just a few thoughts: This is a topic that is very near and dear to me. I don't have it completely handled yet, but getting close. More and more organizations are running cyber scans and getting very, very picky about things RE: If I understand things correctly, the outside world only has access to static pages in the web folder and everything else goes through On Web Connection and it has to pass through On Web Authentication first. The above is not quite true If you have a "Web" folder, that is published by 4D, and you have a file in that folder: foobar.html Someone from the outside can access it without going through on web connection: http://myweb/foobar.html Many people are recommending a "decoy" web folder, and then putting the real McCoy into another folder (outside of the web folder) that gets accessed programmatically. In our case, I'm loading the contents of the file, running PROCESS 4D TAGS, and then publishing using WEB SEND BLOB. This keeps someone's little mits off of the actual file. But this is not enough in many cases with cyber security depts these days. I'm in the process of building a faux "Web Application Firewall" in 4D, that runs in the ON WEB AUTHENTICATION method. Using a 3rd party like Cloudflare can handle some of these items, e.g. DDOS attacks and some of the Firewall stuff. As well, you can put something like Apache or NGINIX in front of your 4D App, and configure the Web Firewall there. However many cyber security depts want to know that your web app is secure without 3rd party stuff. Currently I'm working on building a "White List" of any possbile URLs to our web app. If it ain't in the White List, it doesn't get past ON WEB AUTHENTICATION. I just have to be careful to make sure that I add any new URLs to the White list. These are just a few items that I'm trying, don't know how the next cyber scan will turn out. There are many other 4D folks who can chime in here as well. Randy Engle -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Richard Wright via 4D_Tech Sent: Thursday, November 21, 2019 1:43 PM To: 4d_tech@lists.4d.com Cc: Richard Wright Subject: 4D Web Server Security Anyone care to share their experience and insights as to the security of the 4D Web Server? There’s lots of talk these days about DOS and putting in a DMZ, but what is really necessary in 4D land? If I understand things correctly, the outside world only has access to static pages in the web folder and everything else goes through On Web Connection and it has to pass through On Web Authentication first. Richard Wright DataDomain rwri...@datadomainsoftware.com <mailto:rwri...@datadomainsoftware.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: Web aficionados - Not allow user to access file directly
Hi Kirk, Thanks for the info. Most of our customers are resistant to proxy servers They think that we should be handling all of it. So... I'll need to go to plan "B" Randy Engle -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Kirk Brooks via 4D_Tech Sent: Tuesday, October 1, 2019 8:55 AM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Kirk Brooks Subject: Re: Web aficionados - Not allow user to access file directly Hey Randy, The optimal way to achieve this is to set up the website with a different web server functioning as the node publicly exposed to the internet. That server deals with all the authentication and heavy protection stuff 4D isn't very good at and communicates with your 4D server via API calls. Your 4D server can be locked down to only talk with something coming from a specific IP address (the front facing server) on a specific port. If you can't do that the 4D server will statically serve any pages in the web folder with the one you identify as the index page being the default. If you set the default page to a non-existent page, xxx.html for instance. In this case "The On Web Authentication Database Method is automatically called, regardless of the mode, when a request or processing requires the execution of a 4D method. It is also called when the Web server receives an invalid static URL (for example, if the static page requested does not exist)." https://doc.4d.com/4Dv17R5/4D/17-R5/On-Web-Authentication-Database-Method.300-4127485.en.html So you can intercept and validate using On web auth. If you do nothing in On web auth the request flows to On web connect. I generally deal with the requests there. You can use the scheme of serving web pages stored elsewhere and/or construct the response in code. At this point you are really building and API more than a web server - which I think is a good thing. If you are going to use 4D code to actually construct html pages I really encourage building the html as templates (stored outside the web folder). Use Process 4D tags to populate them with data you develop in code. I find attempting to construct anything more than the most trivial html in 4D code the path to long hours and great unhappiness. On Tue, Oct 1, 2019 at 8:38 AM Randy Engle via 4D_Tech <4d_tech@lists.4d.com> wrote: > Hi Web Experts, > > I don't want the web users to access html files directly, without > going through ON WEB CONNECTION. > > e.g. > > http://myweb/foobar.html > > If "foobar.html" exists in the web folder, Users can put in this in > the address and it will pull up the web page, but will not process the > 4D Tags, etc. > Very, very funky. > > So, I'm probably being a dope, but does anyone know what I can do to > prevent accessing html files directly? > > Gracious thanks > > Randy Engle > > > ** > 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 > ** -- Kirk Brooks San Francisco, CA === What can be said, can be said clearly, and what you can’t say, you should shut up about *Wittgenstein and the Computer * ** 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: Web aficionados - Not allow user to access file directly
Hi Lutz, Thanks for the info! Yes, I've got a copy of "Web Companion" somewhere. Will check it out. Randy Engle -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Epperlein, Lutz (agendo) via 4D_Tech Sent: Tuesday, October 1, 2019 8:49 AM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Epperlein, Lutz (agendo) Subject: AW: Web aficionados - Not allow user to access file directly Use the so-called "Web decoy" technique. Basically you put your html files in another folder outside your html root. Then redirect all requests using ON WEB CONNECTION. For every http request 4D cannot serve directly, it uses ON WEB CONNECTION. This is more elaborated e.g. here: How to skip over HTTP and redirect to HTTPS https://kb.4d.com/assetid=75313 How to skip over HTTP and redirect to HTTPS: Part 2 (The Web decoy folder) https://kb.4d.com/assetid=75753 And there was a book "The Web Companion" by David Adams, it's a bit old now, but the technique remains the same. If you can get a copy ... HTH Regards Lutz -Ursprüngliche Nachricht- Betreff: Web aficionados - Not allow user to access file directly Hi Web Experts, I don't want the web users to access html files directly, without going through ON WEB CONNECTION. e.g. http://myweb/foobar.html If "foobar.html" exists in the web folder, Users can put in this in the address and it will pull up the web page, but will not process the 4D Tags, etc. Very, very funky. So, I'm probably being a dope, but does anyone know what I can do to prevent accessing html files directly? Gracious thanks Randy Engle ** 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 **
Web aficionados - Not allow user to access file directly
Hi Web Experts, I don't want the web users to access html files directly, without going through ON WEB CONNECTION. e.g. http://myweb/foobar.html If "foobar.html" exists in the web folder, Users can put in this in the address and it will pull up the web page, but will not process the 4D Tags, etc. Very, very funky. So, I'm probably being a dope, but does anyone know what I can do to prevent accessing html files directly? Gracious thanks Randy Engle ** 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: [v17.3] - Clear 4D-Oject
Clear Variable (object) ??? Randy Engle -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Jörg Knebel via 4D_Tech Sent: Monday, September 23, 2019 5:02 PM To: 4D Tech Mailing List Technical <4d_tech@lists.4d.com> Cc: Jörg Knebel Subject: [v17.3] - Clear 4D-Oject G’day, Is there a simpler way to clear/destroy a 4D-Object than to loop trough it? I think of something already implemented in ObjectTools - OT Clear(ObjHandle) / OT Clear (All) Thanks 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 ** ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
RE: QUERY WITH ARRAY - SQL Equivalent?
Chuck,
Thanks for the response!
Took a while to get the syntax just right, but what you have below is basically
what I ended up with.
Thanks
Randy Engle
-Original Message-
From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Chuck Miller via
4D_Tech
Sent: Wednesday, September 18, 2019 10:06 AM
To: 4DTechList Tech <4d_tech@lists.4d.com>
Cc: Chuck Miller
Subject: Re: QUERY WITH ARRAY - SQL Equivalent?
Here goes
C_TEXT($INCLUDED_txt)
$INCLUDED_txt:=“(“+String(al_Personnel_ID{1})
for($LOOPL;2;size of array(al_Personnel_ID))
$INCLUDED_txt:= $INCLUDED_txt+”,”+String(al_Personnel_ID{LOOPL})
end for
$INCLUDED_txt:=$INCLUDED_txt+”)"
begin sql
select [Personnel].[field],...
from [Personnel]
where
Personnel]Personnel_ID in :$INCLUDED_txt:
end sql
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 Sep 18, 2019, at 11:44 AM, Randy Engle via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
>
> Hello SQL Afficionados!
>
> I need to get a selection of records, based upon an array of ID numbers.
> (What I want is to end up the arrays... not the selection of records)
>
> e.g.
> QUERY WITH ARRAY([Personnel]Personnel_ID;al_Personnel_ID)
**
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:4d_tech-unsubscr...@lists.4d.com
**
**
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:4d_tech-unsubscr...@lists.4d.com
**
RE: QUERY WITH ARRAY - SQL Equivalent?
Jeff, Many thanks, Yes, I playing with the "IN" function Randy Engle Internet – Hosted – In the Cloud: On-line Backflow Test Entry! XC2Live! - Backflow Program Management Operational Now! – Call for additional information: 800.761.4999 -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Jeffrey Kain via 4D_Tech Sent: Wednesday, September 18, 2019 9:44 AM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Jeffrey Kain Subject: Re: QUERY WITH ARRAY - SQL Equivalent? SELECT ... FROM Table WHERE [ID] in ( comma separated list of IDs ) ID is a reserved word in sql so if that’s the name of your field you need to escape it (I use brackets in 4D). ** 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 **
QUERY WITH ARRAY - SQL Equivalent?
Hello SQL Afficionados! I need to get a selection of records, based upon an array of ID numbers. (What I want is to end up the arrays... not the selection of records) e.g. QUERY WITH ARRAY([Personnel]Personnel_ID;al_Personnel_ID) The above works just great! "Except", that it changes the current selection and current record. Whereas, what I really want is to end up with a half dozen or so arrays from the [Personnel] Table, without touching the current selection/record. I'm using 4D 16r6 (Windows) Anyone know of a SQL function that does this? Or some other method. "Execute on Server" attribute would work, except in many cases these are single-user systems, not client/server. Gracious thanks to all Randy Engle ** 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: 400 Bad Request - Success!
Hi Tim, Setting the Web option: " Web session enable IP address validation" to disabled Seemed to do the trick! Many, many thanks! Randy Engle -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Timothy Penner via 4D_Tech Sent: Friday, June 14, 2019 3:25 PM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Timothy Penner ; Michael McCall ; Randy Engle Subject: RE: 400 Bad Request Is it possible that the IP address of the client(ipad) is changing? The Web Session Management documentation states: "The 4D HTTP server records the IP that started a session. If a Web client located at a different IP address tries to access an existing session, the HTTP 400 error is returned to the client." This can happen when switching between Mobile networks and Wifi (like if an iphone user walks into Wifi reception and continues using the website after their phone automatically switches networks). If needed, this behavior can be changed using the "Web session enable IP address validation" selector of WEB SET OPTION so that the IP Address is not validated. -Tim -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Michael McCall via 4D_Tech Sent: Friday, June 14, 2019 1:34 PM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Michael McCall Subject: RE: 400 Bad Request We have had one client who primarily uses iPads who has reported a similar issue from time to time over the past few years. We've never been able to reproduce it since they have around 200 iPads at times - which we don't - and they also have done some customizations which make it hard to isolate the problem. If anyone does have suggestions as to possible things to check, I'd also be curious. ** 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: 400 Bad Request
Hi Tim, Thanks for the info Re "Web session enable IP address validation" I will try this. FYI We are using "CloudFlare" to prevent DDOS attacks. I'm looking at the logweb.txt. I see pings from Cloudflare with a 400 response Typically followed by a another ping with a 302 response Don't know what to make of this Randy Engle -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Timothy Penner via 4D_Tech Sent: Friday, June 14, 2019 3:25 PM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Timothy Penner ; Michael McCall ; Randy Engle Subject: RE: 400 Bad Request Is it possible that the IP address of the client(ipad) is changing? The Web Session Management documentation states: "The 4D HTTP server records the IP that started a session. If a Web client located at a different IP address tries to access an existing session, the HTTP 400 error is returned to the client." This can happen when switching between Mobile networks and Wifi (like if an iphone user walks into Wifi reception and continues using the website after their phone automatically switches networks). If needed, this behavior can be changed using the "Web session enable IP address validation" selector of WEB SET OPTION so that the IP Address is not validated. -Tim -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Michael McCall via 4D_Tech Sent: Friday, June 14, 2019 1:34 PM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Michael McCall Subject: RE: 400 Bad Request We have had one client who primarily uses iPads who has reported a similar issue from time to time over the past few years. We've never been able to reproduce it since they have around 200 iPads at times - which we don't - and they also have done some customizations which make it hard to isolate the problem. If anyone does have suggestions as to possible things to check, I'd also be curious. ** 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: 400 Bad Request
Hi Jacques, (re your post from 2017) We are having this same problem on our web pages. If is particularly bad on iPhones and iPads. Intermittent on Windows Chrome Did you find any way to resolve it? Much appreciated Randy Engle XC2 Software - XC2LIVE! -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Jacques Chatenay via 4D_Tech Sent: Monday, September 18, 2017 6:43 PM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Jacques Chatenay Subject: 400 Bad Request I have started receiving 400 bad request errors on a website's served by 4D the errors occur using chrome 60.0.3112.116 on android 8.0.0 using firefox on the same device has no problems using chrome 60.0.3112.116 on android 6.0.1 device dose not have any problem I have had reports of this problem on Apple devices however I do not have an apple device to test on I have no problems on windows computers accessing the sites with any browser. Problem seems to be isolated to chrome 60.0.3112.116 on android 8.0.0 and likely apple devices One site that has the problem has http://mcknight-law.com The database is running on v14 R5 I have tested on 16 R3 with the same results Any help would be greatly appreciated J Chatenay Aware Data Services ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com ** ** 4D Internet Users Group (4D iNUG) 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: Compatibility with Widows 10 v1809
Peter I just opened my app with 17r4, both 64 and 32 bit Using Windows 10 Pro v 1809 No problemo Randy Engle XC2 Software - XC2LIVE! - SwiftComply -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Peter Adam via 4D_Tech Sent: Sunday, May 19, 2019 5:39 AM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Peter Adam Subject: Re: Compatibility with Widows 10 v1809 After extensive trouble shooting, all security functions turned off, a v17R4 server will not launch. No screen is displayed nor is any background MIDI screen showing. This is happening on a win 10 Pro v1809 box. Is anyone using this version of Win 10 with 4D v17R4? 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 > On 18 May 2019, at 1:52 pm, Peter Adam via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > V17R4 won’t launch either. prntvpt.dll missing and a bunch of other stuff. > > Any help? > > > Cheers, > > Peter Adam > Adam, Zievert & Associates P/L > > e: peter.a...@me.com <mailto:peter.a...@me.com> Skype Phone: +61 3 > 9016 379 > t: +61 3 9836 3539 > m: 0419 552 462 > www.adamzievert.com.au <http://www.adamzievert.com.au/> > > > >> On 17 May 2019, at 9:06 am, Peter Adam via 4D_Tech <4d_tech@lists.4d.com >> <mailto:4d_tech@lists.4d.com>> wrote: >> >> I have reports of compatibility issues with windows 10 v1809. It appears >> that 4D is attempting to write an IP address to the CSC folder, one of >> windows system folders. >> >> This is when launching the 4D v13 client. >> >> v13 running on a Windows 10 v1709 client works fine. >> >> Any suggestions about what to try? >> >> >> 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) >> Archive: http://lists.4d.com/archives.html >> <http://lists.4d.com/archives.html> >> Options: https://lists.4d.com/mailman/options/4d_tech >> <https://lists.4d.com/mailman/options/4d_tech> >> Unsub: mailto:4d_tech-unsubscr...@lists.4d.com >> <mailto:4d_tech-unsubscr...@lists.4d.com> >> * >> * > > ** > 4D Internet Users Group (4D iNUG) > Archive: http://lists.4d.com/archives.html > <http://lists.4d.com/archives.html> > Options: https://lists.4d.com/mailman/options/4d_tech > <https://lists.4d.com/mailman/options/4d_tech> > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > <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: Unexpected authentication window appears in web area
Peter, Aha. I got it, a WEB AREA! H most peculiar! Randy Engle -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Peter Jakobsson via 4D_Tech Sent: Thursday, April 25, 2019 1:30 PM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Peter Jakobsson Subject: Re: Unexpected authentication window appears in web area Hi Randy Thanks for your reply. Just to clarify, there’s no code involved. It’s simply a web area through which I’m accessing the web. Behaves as expected on the Mac but generates this authentication dialog out of nowhere on Windows. Peter > On 25 Apr 2019, at 22:23, Randy Engle via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Possibly, something is failing in the ON WEB AUTHENTICATION database method. ** 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: Unexpected authentication window appears in web area
Hi Peter, Possibly, something is failing in the ON WEB AUTHENTICATION database method. We have a "blacklist", that if it is on the list, you will get the message you described. Why Windows, not Mac?... dunno. Randy Engle -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Peter Jakobsson via 4D_Tech Sent: Thursday, April 25, 2019 11:22 AM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Peter Jakobsson Subject: Unexpected authentication window appears in web area Hi I have a very simple web area embedded in a 4D form for logging into an authenticated domain. I’m observing different behaviours in Mac and Windows: Mac: works fine. You enter user and password, click the web page submit button and authentication is successful. Next web page appears Windows: On clicking the submit button a small OS type window opens over the form with “User Name” and “Password” fields. It’s in French which makes me think it’s coming from the 4D web area plugin itself Even if the correct user name and password are entered (for a second time) into this “secondary” authentication window, authentication fails. See here for screenshot: https://imgur.com/fQdtNYu Anyone seen this or have any idea as to why this appears ? Regards Peter ** 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: Windows Build - STR# 10135, 18/19 Folders
John, On our system: (Windows 10 4D 17r4) (We are 100% windows, creating new builds 3x week) On Windows, the built app creates a folder: "AppName" This has the "Appname.exe" in it Inside of that folder is another folder: "Database" This holds the .4DC/.4Dindy files Clicking on the .EXE works just fine Don't know about the "appname.4Dbase" folder Something in the buildapp.xml? I'll be glad to look at your buildapp.xml file if you want to send it to me. Randy Engle -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of John J Foster via 4D_Tech Sent: Sunday, March 10, 2019 6:15 AM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: John J Foster Subject: Windows Build - STR# 10135, 18/19 Folders Hey All, I couldn’t find anything in KB that explained this situation. Windows 10 - 4D v17r4 I just noticed that the build of an engined version of my app creates two foldersnamed: STR# 10135, 18 -> Appname.4dbase -> includes the .4DC/.4DIndy files STR# 10135, 19 -> Appname -> includes executable Is this related to the application build XML or JSON file? I haven't had to create a standalone app on windows since DataPulse/StructurePulse 10 years ago. And it looks like I will need both of these folders as part of the “App”. Can they just be renamed and then included in another folder? And isn’t there a way of creating a file (an alias like) where the client will click that and the app will work? I really like to keep them out of these folders. Does an install program on windows manage these pieces as well. If you have experience creating a standalone app on windows I’d appreciate any help. Any time saved is huge at this point. Thanks for your help, 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: Windows app 3-4 times slower
John,
Processor: i3 vs i7
Randy Engle
-Original Message-
From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of John J Foster via
4D_Tech
Sent: Friday, March 8, 2019 12:51 PM
To: 4D iNug Technical <4d_tech@lists.4d.com>
Cc: John J Foster
Subject: Windows app 3-4 times slower
Hi All,
This App is running under both Mac/Windows 4D v17R4...
You might recall, a week ago or so, that I was soliciting help with creating an
engined based 4D App. I figured that part out (although certification later).
What I am finding baffling is how much slower the engine runs on windows versus
on my MacBook Pro. When I say slower I seeing the Mac being 3-4 times faster in
various scenarios.
Part of the speed differentials might be a special plugin that the App uses.
The plugin was created using Xcode for the Mac and Visual Studio (v15 I think)
for windows. I’ll have to create special test to compare and see. The SVG
drawing is slower; the searching in a database seems much slower.
A special search routine, which requires calls to the plugin, took 1 minute 4
seconds on the Mac and the same thing on window took over 4 minutes - compiled.
BTW, the same routine running as source on the Mac took 3 minutes 41 seconds
and on window took 10 minutes and 46 seconds (over twice as slow). Maybe the
windows version of the plugin (there’s both a 32bit and a 64bit) has some other
setting which can optimize it?
FWIW, I have been trying to get by using as much of native 4D as I can and as
little of the plugin as is required. I might have to reconsider this and move
some of this work from 4D into the C++ plugin since calculating in the plugin
it’s so much faster…
On the Mac side:
MacBook Pro (Retina, 15-inch, Mid 2015)
System Version: macOS 10.12.6 (16G1618)
Processor Name:Intel Core i7
Processor Speed: 2.8 GHz
Number of Processors: 1
Total Number of Cores: 4
L2 Cache (per Core): 256 KB
L3 Cache: 6 MB
Memory:16 GB
On Windows:
HP Notebook x64-bassed PC
System Version: Windows 10 Home (10.0.17134)
Processor Name:Intel Core i3-6100U
Processor Speed: 2.30 GHz
Number of Processors: 4 logical
Memory:8 GB {not sure if I can add more?}
My past experience has been that it’s usually slower on the Mac and much faster
on windows. But these are different times. Both the Mac and Windows have
Bitdefender running for security. (It’s probable that there are other programs
running on windows I am unaware of).
This single user standalone app will be marketed to a client base which will
not have necessarily have the fastest equipment. So anything I can do - not
necessarily hardware based - to speed things up will be helpful.
For those of you who work on both modern Macs and Windows what is your
experience in terms of speed comparison?
When I move a database over from a Mac to a windows do I need to throw all the
indexes away and have them rebuilt? {I don’t think so since if it were running
via 4D Server wouldn’t be an issue}
Are there steps you’ve taken that sped things up?
I might have to work with 4D’s profiler and some other test to determine the
bottlenecks. Way too slow!
Thanks for your feedback,
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
**
Windows Server 2019
Anyone tried to run 4D Server (v17.xxx) on Windows Server 2019 I haven't. but we have customers asking. Many thanks Randy Engle ** 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'r run as a service on Windows 2016
Pat, Just to make sure: You've got TCP 19812-19814 ports open in Advanced Windows Firewall inbound rules. Yes? Randy Engle -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Pat Bensky via 4D_Tech Sent: Wednesday, February 27, 2019 8:57 AM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Pat Bensky Subject: Re: Can'r run as a service on Windows 2016 Thanks Jeff. I made that change and now the service appears to be running OK. BUT ... I can't connect to it from a Client. It says Not Responding. I've only tested with a Client running on the same server, but that should work - never had a problem doing that in the past. Makes no difference if I run the Client as Administrator or not. Do I need to change something else as well? Thanks! Pat On Wed, 27 Feb 2019 at 16:06, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> wrote: > We have 4D Server v17 HF3 set up as a service on Windows Server 2016. > I checked the service properties -- the "Log on as:" is set to "Local > System account" and "Allow Service to interact with desktop" is checked. > > I also have FireDaemon installed to make it easy to bounce into the > "session 0" user interface if I need to view the 4D Server user interface. > > > On Feb 27, 2019, at 9:43 AM, Tom Benedict via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > > > > Hi Pat, > > > > I don’t have any experience with running 4D as a Service, but I see > > that > there is a Tech Tip from about 10 years ago which mentions having to > “Run as Administrator” > > > > https://kb.4d.com/assetid=75056 > > > > HTH, > > > > Tom Benedict > > > >> On Feb 27, 2019, at 02:40, Pat Bensky via 4D_Tech > >> <4d_tech@lists.4d.com> > wrote: > >> > >> I'm having a bit of trouble trying to set up our 4D app to run as a > service > >> on a Windows server. > >> > >> The server version is Windows Server 2016 Standard. > >> If I run the app "As Administrator" it starts up OK and we can > >> connect > to > >> it. > >> > >> If I don't start it as Administrator, I get a message that the > >> database > (or > >> one of its segments) is locked. > >> If I try to set it up to run as a service, it doesn't work - in the > >> Services window, it says it's running, but in the Task Manager it > >> says Stopped. I'm guessing this is because when it tries to start > >> the > service, > >> it can't because of the locked data file problem. > > ** > 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 > ** -- * CatBase - Top Dog in Data Publishing tel: +44 (0) 207 118 7889 w: http://www.catbase.com skype: pat.bensky * ** 4D Internet Users Group (4D iNUG) 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: interesting find
I seem to recall that in v1.x of 4D (or v2 when the compiler first showed up), you could practically write in Swahili, and 4D would not complain. Every version since then, 4D has become less "forgiving" (or as Tim Says: "smarter") Randy Engle -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Timothy Penner via 4D_Tech Sent: Wednesday, February 20, 2019 4:31 PM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Timothy Penner Subject: RE: interesting find I have been telling people for years that the compiler gets smarter in each new version. You may have a line of code that you thought was working, but in fact, it shouldn’t have worked at all, and the compiler may not have caught it before, but now it does. This is something I frequently tell people in TS cases dating back multiple versions (I even told people this in v11). -Tim ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com ** ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
RE: Bug in SMTP methods in 4D Internet Commands plugin
Ben
I just tried this out with your code below.
Received both emails including: " Invalid subject containing changed by"
So...
Something else is hokey-pokey.
Randy Engle
-Original Message-
From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Ben Kershaw via
4D_Tech
Sent: Thursday, February 7, 2019 8:06 AM
To: 4d_tech@lists.4d.com
Cc: Ben Kershaw <4d...@bonaire-diver.com>
Subject: Bug in SMTP methods in 4D Internet Commands plugin
I've discovered a bug in the 4D Internet Commands SMTP methods. If the message
subject contains the text "changed by", there won't be any errors returned but
the e-mail will not be sent.
I've tested it on the following versions, all running on macOS 10.13.6
* 4D 16.3HF4 64-bit, 4D Internet Commands 16.3 build 16.224100
* 4D 16.4 64-bit build 16.226553, 4D Internet Commands 16.4 build 16.226553
* 4D 16.4 32-bit build 16.226553, 4D Internet Commands 16.4 build 16.226553
* 4D 17.0 build 17.225365
I've also tested it running under Windows server.
I've tested it on different machines, using different SMTP servers, on
different networks. Same result. I find it hard to believe that having "changed
by" in the message subject would cause the e-mail to not be sent, but my
testing shows otherwise. Still, I've enclosed a small method below, and I'd
appreciate it if others could try it out and let everyone know the result
(you'll need to set the variables for the STMP server, addresses, and
username/password if your SMTP server needs authentication).
This is a weird one. I'm assuming it's caused by some old debugging code that
was left in place, but who knows.
Thanks,
Ben Kershaw
C_TEXT($tSMTPServer;$tEMailFrom;$tEMailTo;$tUserName;$tPassword)
C_LONGINT($lSMTPServerPort;$lMessageID;$lError;$lArrayElement)
$tSMTPServer:=""
$lSMTPServerPort:=25
$tUserName:=""
$tPassword:=""
$tEMailFrom:=""
$tEMailTo:=""
ARRAY TEXT($atSubject;0)
APPEND TO ARRAY($atSubject;"Valid subject") //This will work fine APPEND TO
ARRAY($atSubject;"Invalid subject containing changed by") //This won't return
an error, but the e-mail won't be sent
For ($lArrayElement;1;Size of array($atSubject))
$lMessageID:=0
$lError:=SMTP_New ($lMessageID)
$lError:=SMTP_Host ($lMessageID;$tSMTPServer)
$lError:=SMTP_From ($lMessageID;$tEMailFrom)
$lError:=SMTP_Subject ($lMessageID;$atSubject{$lArrayElement})
$lError:=SMTP_Body ($lMessageID;"This is the message body";2)
$lError:=SMTP_To ($lMessageID;$tEMailTo)
If ($lSMTPServerPort#25)
$lError:=IT_SetPort (2;$lSMTPServerPort)
End if
If ($tUserName#"")
$lError:=SMTP_Auth ($lMessageID;$tUserName;$tPassword)
End if
$lError:=SMTP_Send ($lMessageID)
$lError:=SMTP_Clear ($lMessageID)
End for
**
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 Selection from SQL Query
Miyako Many thanks again! Works like a charm! Took a couple of passes to see the "Double Underline" in the virtual field: __ROW_ID I'm going to take a W.A.G. that this is what QUERY BY SQL command is doing behind the scenes. Not sure how I'm going to use this, but I think it might come in handy at some point. Thanks again, Randy Engle, -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Keisuke Miyako via 4D_Tech Sent: Tuesday, February 5, 2019 4:30 PM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Keisuke Miyako Subject: Re: 4D Selection from SQL Query alternatively, I guess we can SELECT __ROW_ID == record number (not all tables have a primary key). https://doc.4d.com/4Dv17/4D/17/Replication-via-SQL.300-3786654.en.html https://doc.4d.com/4Dv17/4D/17/CREATE-SELECTION-FROM-ARRAY.301-3729926.en.html 2019/02/06 3:31、Randy Engle via 4D_Tech <4d_tech@lists.4d.com<mailto:4d_tech@lists.4d.com>>のメール: If you really need it, it would be a two step process. Step one Begin sql select primary_key form table where (some criteria) into :$primaryKeyArray end sql ** 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 Selection from SQL Query
Miyako, Many thanks! Randy Engle -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Keisuke Miyako via 4D_Tech Sent: Tuesday, February 5, 2019 4:30 PM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Keisuke Miyako Subject: Re: 4D Selection from SQL Query alternatively, I guess we can SELECT __ROW_ID == record number (not all tables have a primary key). https://doc.4d.com/4Dv17/4D/17/Replication-via-SQL.300-3786654.en.html https://doc.4d.com/4Dv17/4D/17/CREATE-SELECTION-FROM-ARRAY.301-3729926.en.html 2019/02/06 3:31、Randy Engle via 4D_Tech <4d_tech@lists.4d.com<mailto:4d_tech@lists.4d.com>>のメール: If you really need it, it would be a two step process. Step one Begin sql select primary_key form table where (some criteria) into :$primaryKeyArray end sql ** 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 Selection from SQL Query
Chuck, Many thanks! ( I hunched that I'd hear from you on this one. ) It is as I expected: ce n'est pas possible Except as you showed in your example (Which has a little bit of merit for what I'm thinking about doing) Thanks! Randy Engle It is not possible. If you really need it, it would be a two step process. Step one Begin sql select primary_key form table where (some criteria) into :$primaryKeyArray end sql query with array([table]primary_key;$primaryKeyArray) Don't know why you would do this except you could build sql where on the fly BTW not creating a selection of records and not loading one is one of the beautiful parts of sql as you do nto need to muck with the current selection -- - 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 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) 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 Selection from SQL Query
For you SQL aficionados I know that I can get a "selection" of 4D records using QUERY BY SQL However as a point of curiosity and interest, is it reasonably easy/possible to get a selection of 4D records when using the other SQL commands e.g. Begin SQL-End SQL SQL EXECUTE Or, am I p...ing into the wind? Thanks! Randy Engle ** 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: XPS Viewer on Windows 10 - Removed in new OS installs -
Miyako, Many thanks. Will get it a try! Randy Engle, -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Keisuke Miyako via 4D_Tech Sent: Wednesday, January 16, 2019 4:23 PM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Keisuke Miyako Subject: Re: XPS Viewer on Windows 10 - Removed in new OS installs - not fully tested but it's open source so feel free to try: https://github.com/miyako/4d-tips-3rd-party-xps-viewer > 2019/01/17 2:42、Randy Engle via 4D_Tech <4d_tech@lists.4d.com>のメール: > Is there anything in the works as a previewer replacement instead of XPS > viewer? ** 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: XPS Viewer on Windows 10 - Removed in new OS installs -
Hi Jim, Thanks for the idea. Don't think MS Print to PDF will substitute as a seamless "Preview" But it's certainly an idea worth entertaining. I've not looked into how much we can configure MS Print/PDF to set the location and name of the document. Randy Engle -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Jim Hays via 4D_Tech Sent: Wednesday, January 16, 2019 11:03 AM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Jim Hays Subject: Re: XPS Viewer on Windows 10 - Removed in new OS installs - Maybe not ideal, but there is Microsoft Print to PDF built in to Windows 10. Jim On Wed, Jan 16, 2019 at 12:42 PM Randy Engle via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Hi 4D! > > MS Strikes again! > > As of 15/Aug/2018 - Windows 10 Build 1803 > > > https://docs.microsoft.com/en-us/windows/deployment/planning/windows-1 > 0-1803-removed-features > > MS is removing XPS Viewer as a standard installation for new > installations of Windows 10, starting with release 1803 Upgrade to > 1803 apparently will not be affected. > > Yes, it can be manually re-installed. > > However many of our customers don’t want to be bothered with this. > > Is there anything in the works as a previewer replacement instead of > XPS viewer? > > > > Thanks! > > Randy Engle > > > ** > 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 **
XPS Viewer on Windows 10 - Removed in new OS installs -
Hi 4D! MS Strikes again! As of 15/Aug/2018 - Windows 10 Build 1803 https://docs.microsoft.com/en-us/windows/deployment/planning/windows-10-1803-removed-features MS is removing XPS Viewer as a standard installation for new installations of Windows 10, starting with release 1803 Upgrade to 1803 apparently will not be affected. Yes, it can be manually re-installed. However many of our customers don’t want to be bothered with this. Is there anything in the works as a previewer replacement instead of XPS viewer? Thanks! Randy Engle ** 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: AWS Experts - Need a little help
Julio, Many thanks! Yes, it took me a while, but I finally figured that out. Randy Engle -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Julio Carneiro via 4D_Tech Sent: Tuesday, January 15, 2019 2:48 AM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Julio Carneiro Subject: Re: AWS Experts - Need a little help Exactly. You need to assign your EC2 VM to a security group that enables the ports 4D requires. > On Jan 14, 2019, at 8:56 PM, Spencer Hinsdale via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > > did you edit Security Groups to add 4D ports 19812 to 19814? > >> On Jan 14, 2019, at 2:15 PM, Randy Engle via 4D_Tech <4d_tech@lists.4d.com> >> wrote: >> >> Spencer, thanks for the tip. >> >> Yes, I'm using the public IP address >> (Same address that I use to connect via RDC) >> >> No workie! >> >> ;-( >> >> Randy Engle >> >> Check that you are using the public ip displayed on the desktop not on >> server admin window... >> >> -- Julio Carneiro jjfo...@gmail.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: AWS Experts - Need a little help
Spencer, thanks for the tip. Yes, I'm using the public IP address (Same address that I use to connect via RDC) No workie! ;-( Randy Engle Check that you are using the public ip displayed on the desktop not on server admin window... ** 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 **
AWS Experts - Need a little help
I'm testing an app on AWS (LightSail Account) I've got a very lightweight app running on 4D Server (v17) Windows running on an instance of AWS. I'm not able to connect 4D Client (from my location) to the 4D Server on AWS I've setup all of the standard firewall items, TCP/UDP, etc, Including turning off the firewall completely. Can't connect, just get the "Connecting ..." message I can connect from a 4D Client installed on the AWS site, no problem. Anyone using AWS and connecting via 4D client to Server. Any special items that I might look at? Many thanks Randy Engle ** 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: ListBox - assign pulldown array ?? a la ALPro for Data Entry
Kirk
Happy new year to you!
Thanks for the tips!
Randy Engle
-Original Message-
From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Kirk Brooks via
4D_Tech
Sent: Monday, December 31, 2018 10:19 AM
To: 4D iNug Technical <4d_tech@lists.4d.com>
Cc: Kirk Brooks
Subject: Re: ListBox - assign pulldown array ?? a la ALPro for Data Entry
Randy,
Here are a couple of methods that are handy working with almost any type of
listbox pre collection based ones.
First is my method for getting the column variable pointers. Greatly simplifies
working with a listbox constructed of dynamic columns. You pass the name of the
listbox and a pointer to a pointer array. The pointer array is populated with
the column vars. Sometimes this is easier than screwing around with the
specific column names to get those pointers. That is useful if you didn't want
to bother with cogent names for the columns in the first place. If the listbox
is in a subform you include the subform name as $3.
// Method: Listbox_get_colVarArray (text; pointer{;text}) // $1 is the listbox
name // $2 is ptr to pointer array // $3 is subform name // Purpose: populate
$2 with colVar pointers
C_TEXT($1)
C_POINTER($2)
C_TEXT($3)
C_POINTER($ptr)
If (Count parameters=3)
$ptr:=OBJECT Get pointer(Object named;$1;$3) Else $ptr:=OBJECT Get
pointer(Object named;$1) End if
ARRAY TEXT($arrColNames;0)
ARRAY TEXT($arrHeaderNames;0)
ARRAY POINTER($arrColVars;0)
ARRAY POINTER($arrHeaderVars;0)
ARRAY BOOLEAN($arrColsVisible;0)
ARRAY POINTER($arrStyles;0)
LISTBOX GET
ARRAYS($ptr->;$arrColNames;$arrHeaderNames;$arrColVars;$arrHeaderVars;$arrColsVisible;$arrStyles)
//
COPY ARRAY($arrColVars;$2->)
Here is an idea I got from seeing ALP code, is really useful and isn't
supported natively: the selected row index. This dates from v13 and works with
array and selection based listboxes. Turns out to be a really useful tool.
// Method: Listbox_get_selectionIndex (text; pointer) -> longint // $1 is the
name of the listbox // $2 is pointer to longint array // $0 is number
selections // Purpose: populate longint array with row numbers of selected rows
// for selection based listboxes array is record number & // $2{0} is table
number
C_TEXT($1)
C_POINTER($2;$LBptr)
C_LONGINT($0)
C_LONGINT($i;$tableNum)
C_TEXT($set;$nameSel)
C_POINTER($id_ptr;$table_ptr)
ARRAY LONGINT($aI;0)
$LBptr:=OBJECT Get pointer(Object named;$1)
Case of
: (Nil($LBptr))
: (Type($LBptr->)=Is longint)// selection or named selection
LISTBOX GET TABLE SOURCE(*;$1;$tableNum;$nameSel;$set)
$table_ptr:=Table($tableNum)
$id_ptr:=Table_get_idFieldPtr ($table_ptr)// method returns pointer to key
field of a table
Case of
: (Records in set($set)=0)
: ($nameSel#"")
USE SET($set)
If (Nil($id_ptr))// get record numbers
SELECTION TO ARRAY($table_ptr->;$aI)
Else
SELECTION TO ARRAY($id_ptr->;$aI)
End if
Else // avoid clobbering the current selection FIRST RECORD($table_ptr->)
While (Not(End selection($table_ptr->))) Case of
: (Not(Is in set($set)))
: (Nil($id_ptr))// get record numbers
APPEND TO ARRAY($aI;Record number($table_ptr->)) Else APPEND TO
ARRAY($aI;$id_ptr->) End case
NEXT RECORD($table_ptr->)
End while
End case
$aI{0}:=$tableNum
: (Type($LBptr->)=Boolean array)// array based LB For ($i;1;Size of
array($LBptr->)) If ($LBptr->{$i}) APPEND TO ARRAY($aI;$i) End if End for
Else
TRACE
End case
//
COPY ARRAY($aI;$2->)
$0:=Size of array($aI)
For collection based listboxes there are better ways of managing the listbox
and the data.
On Sun, Dec 30, 2018 at 3:58 PM Randy Engle via 4D_Tech < 4d_tech@lists.4d.com>
wrote:
> List has been pretty quiet the last few days.
> Anyone alive out there?
>
> I've been using ALPro vs Listbox exclusively since before Listbox existed.
> As such, I've got extremely limited experience/knowledge of it.
>
> So, I've decided to educate myself so at least I know how to put a
> LISTBOX together.
>
> There is a command in ALPro that allows assigning a popup/pull-down
> array to a column, so the user can click the popup and select from
> some given values for entry into a cell.
>
> e.g.
> associatedMenuPtr:=->at_My_Text_Array
> AL_SetColumnPtrProperty
> ($alpArea;$columnNumber;ALP_Column_PopupArray;$associatedMenuPtr)
>
> I've dug around a lot in LISTBox but have not found a similar
> method/command
>
> Does it exist?
>
> Many thanks
>
> Randy Engle
>
>
> **
> 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-unsubs
RE: ListBox - assign pulldown array ?? a la ALPro for Data Entry
Thanks to anyone that read my post. I think I found what I was looking for. Happy New Year! Randy Engle -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Randy Engle via 4D_Tech Sent: Sunday, December 30, 2018 3:58 PM To: '4D iNug Technical' <4d_tech@lists.4d.com> Cc: Randy Engle <4d.l...@xc2.us> Subject: ListBox - assign pulldown array ?? a la ALPro for Data Entry List has been pretty quiet the last few days. Anyone alive out there? I've been using ALPro vs Listbox exclusively since before Listbox existed. As such, I've got extremely limited experience/knowledge of it. So, I've decided to educate myself so at least I know how to put a LISTBOX together. There is a command in ALPro that allows assigning a popup/pull-down array to a column, so the user can click the popup and select from some given values for entry into a cell. e.g. associatedMenuPtr:=->at_My_Text_Array AL_SetColumnPtrProperty ($alpArea;$columnNumber;ALP_Column_PopupArray;$associatedMenuPtr) I've dug around a lot in LISTBox but have not found a similar method/command Does it exist? Many thanks Randy Engle ** 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 **
ListBox - assign pulldown array ?? a la ALPro for Data Entry
List has been pretty quiet the last few days. Anyone alive out there? I've been using ALPro vs Listbox exclusively since before Listbox existed. As such, I've got extremely limited experience/knowledge of it. So, I've decided to educate myself so at least I know how to put a LISTBOX together. There is a command in ALPro that allows assigning a popup/pull-down array to a column, so the user can click the popup and select from some given values for entry into a cell. e.g. associatedMenuPtr:=->at_My_Text_Array AL_SetColumnPtrProperty ($alpArea;$columnNumber;ALP_Column_PopupArray;$associatedMenuPtr) I've dug around a lot in LISTBox but have not found a similar method/command Does it exist? Many thanks Randy Engle ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
RE: Pasting Spreadsheet Data into 4D Records
Alan, If you have lots of spreadsheets to deal with, as Lahav said, Pluggers XL plugin. It's my tool of choice for dealing with Excel at all, both creating and reading. Randy Engle -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of lists via 4D_Tech Sent: Monday, December 24, 2018 10:18 PM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: lists Subject: RE: Pasting Spreadsheet Data into 4D Records Alan, Take a look at XL Plugin from Pluggers (https://www.pluggers.nl/product/xl-plugin/). It is an excellent tool for working with Excel, writing or reading directly. HTH and happy holidays, Lahav -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Alan Tilson via 4D_Tech Sent: Monday, December 24, 2018 12:45 PM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Alan Tilson Subject: Re: Pasting Spreadsheet Data into 4D Records Hello Pat, Koen & Ken, Pat & Ken- Thank you for your response but I'm trying to eliminate (especially manually) creating the text file. I had been thinking of automating the creation of the text files and using import, but... Koen- I hadn't thought of manually (via code) parsing the text data rather than trying to use import commands. That seems worthwhile and not that difficult! I probably should have said that I potentially have hundreds of copy/paste operations to do! Your responses are much appreciated, Alan On Mon, Dec 24, 2018 at 11:37 AM Kenneth Geiger via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Hi Alan, > > Just save your spreadsheet (Excel) as file-type Tab-Delmited-Text (.txt). > Then in 4D, navigate to File…Import…, change the file type to .txt, > select your saved file, select the table into which to import the > data, and then match the data (columns) to the proper field and import it. > > Regards, > > Ken Geiger > > > On Dec 23, 2018, at 5:47 PM, Alan Tilson via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > > > > Greetings everyone, > > > > Is there a way to copy from a spreadsheet like data source and to > > paste directly into 4d while parsing it into table(s) and fields? > > I'm using v17 if that matters. > > > > I thought about saving the data into a text file and then importing > > the text file, but there seem to be unnecessary steps in there! > > > > Thanks, did some searches but didn't find anything, Alan > > > > ** > > 4D Internet Users Group (4D iNUG) > > Archive: http://lists.4d.com/archives.html > > Options: https://lists.4d.com/mailman/options/4d_tech > > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > > > > ** > > ** > 4D Internet Users Group (4D iNUG) > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > ** ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com ** ** 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]: Esoteric method for calculating Excel column references
Kirk, Thanks for the contribution. This will come in handy! Randy Engle -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Kirk Brooks via 4D_Tech Sent: Saturday, December 1, 2018 3:01 PM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Kirk Brooks Subject: [TIP]: Esoteric method for calculating Excel column references I had need to calculate column references for an Excel spreadsheet for columns greater than 26. You know, so you can come up with the reference like: A1:AG1. Fun stuff. Anyway, the scheme for this is deceptive. A -> Z is easy. But A # 0 or 1 strictly. It's tricky. I suspect this is one reason there are functions in Excel specifically for doing this sort of thing. However, we have to write our own. In the event someone else needs this particular bit of code here is a solution I came up with. It could be used in other contexts I suppose. You can set the base to something smaller. Try 3, for example. $chars:="ABCDEFGHIJKLMNOPQRSTUVWXYZ" $number:=2000 $base:=26 $reference:="" If ($number=0) // there is no zero $reference:="" Else While ($number>0) $remainder:=$number%$base $number:=$number\$base If ($remainder=0) // borrow base from number $remainder:=$base $number:=$number-1 End if $reference:=$chars[[$remainder]]+$reference If ($number>0) & ($number<=$base) $reference:=$chars[[$number]]+$reference $number:=0 End if End while End if ALERT($reference) = Posting this in the hope all this nerdy time isn't completely wasted. -- Kirk Brooks San Francisco, CA === *We go vote - they go home* ** 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 - Exporting tab delimited
Chip, Character code for a Soft Return is 11 Randy Engle -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Chip Scheide via 4D_Tech Sent: Tuesday, November 27, 2018 3:51 PM To: benedic...@comcast.net Cc: Chip Scheide <4d_o...@pghrepository.org>; 4d_tech@lists.4d.com Subject: Re: v13 - Exporting tab delimited Thomas & Chuck the intent is to create the export file in such a manner that NO user intervention is required to open the file with the embedded returns. changing the end of row marker will work, but then the user(s) need to know that -- and they won't or they won't remember etc -- after all they are users typing Alt-return is not really an option s the data is already exported... The embedded character is listed as (10)& for line feed, and (13)& for carriage return, however, replacing the return (4D) with either or both of these strings does NOT result in return or line feed in Excel; just the exact characters "(10)&" A bit of experimentation shows that to get the character code to work requires a formal where for example you have =A1+(10)&+B3 any other ideas?? Thanks > Hi Chip, > > The trick with Excel is that it uses a 'soft return' within a cell. > To get that soft-return within Excel you type Alt-Return (on Windows) > or Control-Option-Return (on MacOS). > > I don't remember what the Character Code is for that character, but > that's what you'll need to include in your extract script. I seem to > recall that it is a newline. Google should be able to help you. > > Hope this helps, and sorry it doesn't have more details. > > Tom Benedict > Optum > >> On November 27, 2018 at 2:07 PM Chip Scheide via 4D_Tech >> <4d_tech@lists.4d.com> wrote: >> >> >> I would like to be able to embed a return and/or line feed into >> column in a tab delimited file (opening with Excel). >> > Hell is other people Jean-Paul Sartre ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com ** ** 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 **
Controlling Laptop Camera from 4D
I'm trying to run the camera on my laptop (Dell 7720) - yes - it's Windows I thought that Win32API might be able to do this, but all I can see using TWAIN_GetSources are some scanners on my network. So, apparently, my laptop camera is not a Twain or Wia device. Thought Qpix might do this, but same, all I see are the scanners. Camera on laptop is running, operatational, etc. Anyone know if it is possible to control the on-board camera from within 4D using anything? Thanks Randy Engle ** 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: ODBC Import - 64bit 4D Disabled???
I guess I need to "roll-my-own" dialog for this. Yes? Randy Engle Re: I'm just now noticing that 4D 64bit - Importing via ODBC is disabled (User Environment) This seems to be the case since at least v16 Have I lost my marbles? How come, why for disabled? What other options to get data from another system? (Except to use 32bit 4D) Anyone? Thanks Randy Engle, Director XC2 Software LLC – XC2LIVE! ** 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 **
ODBC Import - 64bit 4D Disabled???
I'm just now noticing that 4D 64bit - Importing via ODBC is disabled (User Environment) This seems to be the case since at least v16 Have I lost my marbles? How come, why for disabled? What other options to get data from another system? (Except to use 32bit 4D) Anyone? Thanks Randy Engle, Director XC2 Software LLC – XC2LIVE! ** 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: CREATE USER Programmatically?
Kirk
You da' man!
Randy Engle, Director
XC2 Software LLC – XC2LIVE!
Internet – Hosted – In the Cloud: On-line Backflow Test Entry!
XC2Live! - Backflow Program Management
Operational Now! – Call for additional information: 800.761.4999
-Original Message-
From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Kirk Brooks via
4D_Tech
Sent: Thursday, November 1, 2018 4:37 PM
To: 4D iNug Technical <4d_tech@lists.4d.com>
Cc: Kirk Brooks
Subject: Re: CREATE USER Programmatically?
Hey Randy,
You're not a dope - it's a non-intuitive. I integrated my user system with the
4D system a couple of years ago. Allows me to keep the really fine-grained
permissions they know and love while letting 4D sweat the login stuff. Plus
gives me a *much* easier way to know who the user is within server side
processes. Anyway here is the key method I use for synicing with the structure:
// Method: User_set_4Dproperties (c-obj) -> text
// $1 is c-obj of params
// $0 is errMsg
// Purpose: manage updating & creating users
// $1 must have an 'action': update / create
// created users are always Administrator owned
// create action:
*C_OBJECT*(*$1*)
*C_TEXT*(*$0*;$errMsg)
*C_LONGINT*($userID;$nbLogin;$groupOwner;$4DuserId)
*C_TEXT*($name;$startup;$password;$action;$errMethod)
*C_DATE*($lastLogin)
$action:=*OB Get*(*$1*;"action")
// everyone should have access to the plugins
*ARRAY LONGINT*($aMembership;1)
$aMembership{1}:=15002 // plugins
*Error_install_handler *("err_log_only")
*Case of *
*: *($action="update") //note: password may be blank
$4DuserId:=*OB Get*(*$1*;"4DuserId";Is longint)
$password:=*OB Get*(*$1*;"password")
$name:=*OB Get*(*$1*;"name")
$startup:=*OB Get*(*$1*;"startupMethod")
$nbLogin:=*OB Get*(*$1*;"numLogin";Is longint)
$lastLogin:=*OB Get*(*$1*;"lastLogin";Is date)
*Case of *
*: *($name="")
$errMsg:="The user name can not be blank."
*: *($4DuserId=0)
$errMethod:="The 4D user number is required for an update."
*Else *
// is this a new password?
*Case of *
*: *($password="")
*: *(*Validate password*($4DuserId;$password)) // not changed
*Else *
// put a note on the user record
*TABLE_SET_readWrite *(->*[USERS]*)
*QUERY*(*[USERS]*;[USERS]db_userNumber=$4DuserId)
*If *(*Not*(*RW_Locked *(->*[USERS]*;->$errMsg)))
// clear the temp PW - if any
[USERS]temp_pw:=""
[USERS]temp_pw_dts:=""
*NOTE_ADD_toField *(->[USERS]Notes;"Changed password";" - ")
*UNLOAD RECORD*(*[USERS]*)
*End if *
*TABLE_RESTORE_readWrite *(->*[USERS]*;*True*)
*End case *
$4DuserId:=*Set user properties*($4DuserId;$name;$startup;$password;$nbLogin
;$lastLogin;$aMembership)
*OB SET*(*$1*;"4DuserId";$4DuserId)
*End case *
*: *($action="create") & (*OB Get*(*$1*;"name")="")
$errMsg:="No user name!"
*: *($action="create") // created by Administrator
*If *(*OB Is defined*(*$1*;"password"))
$password:=*OB Get*(*$1*;"password")
*Else *
$errMsg:="Users must have a password."
*End if *
*If *($errMsg="")
$name:=*OB Get*(*$1*;"name";Is text)
$startup:=*OB Get*(*$1*;"startupMethod";Is text)
$nbLogin:=0
$lastLogin:=!00-00-00!
// note - if the native 4D user editor is open this will hang waiting for it
to close
$4DuserId:=*Set user properties*(-2;$name;$startup;$password;$nbLogin;
$lastLogin;$aMembership)
*If *(*error*#0)
$errMsg:="The 4D user couldn't be created.\r"
*If *(*error*=-9979)
$errMsg:=$errMsg+" '"+$name+"' is already being used. Make a different name."
*Else *
$errMsg:=$errMsg+*4D_get_error_text *(*error*)
*End if *
*Else *
*OB SET*(*$1*;"4DuserId";$4DuserId)
*End if *
*End if *
*Else *
$errMsg:="No valid action for the user update."
*End case *
*Error_install_handler *
// ----
*$0*:=$errMsg
To create a new 4D user I call it like so:
*C_OBJECT*($obj)
*OB SET*($obj;"action";"create")
*OB SET*($obj;"name";$name)
*OB SET*($obj;"password";*Pass_generate_word *(5;2;1;0)) // temp PW
$errMsg:=*User_set_4Dproperties *($obj)
Be sure to take a look at USER TO BLOB and BLOB TO USERS as well.
On Thu, Nov 1, 2018 at 3:48 PM Randy Engle via 4D_Tech <4d_tech@lists.4d.com>
wrote:
> I haven't used "4D Users" in a "long time"
>
> ( I roll my own user system...but 4D Users need it now)
>
> Maybe I'm being a dope (likely), but I'm not seeing a way to create
> users programmatically.
>
> A shove in the right direction would be most appreciated.
>
> Gracious Thanks
>
>
CREATE USER Programmatically?
I haven't used "4D Users" in a "long time" ( I roll my own user system...but 4D Users need it now) Maybe I'm being a dope (likely), but I'm not seeing a way to create users programmatically. A shove in the right direction would be most appreciated. Gracious Thanks Randy Engle, Director XC2 Software LLC – XC2LIVE! ** 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: v17R2
Jeremy, V17R licenses are different than v17 licences I use the xml file to build my apps. When I put in the license numbers, they need to be the license numbers with the "R" in front of them. i.e. you need to re-register you v17(Rx) licenses so the you have license numbers with the R in front of the number. Randy Engle, Director XC2 Software LLC – XC2LIVE! -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Jeremy Roussak via 4D_Tech Sent: Monday, October 15, 2018 12:50 AM To: 4D iNug Technical <4d_tech@lists.4D.com> Cc: Jeremy Roussak Subject: v17R2 My v17 licences show up in the “build application” dialog but are greyed out and when I click “build”, 4D tells me that there are none installed. My maintenance runs to the end of next month, so that shouldn’t be a problem. Is there a known issue with licences in R2, or is it just me? 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: 4D Client as Web Server - Using same 4D Process if web access from diff. machines
Keith, Thanks. Will investigate Randy Engle -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Keith White via 4D_Tech Sent: Friday, September 14, 2018 1:29 PM To: 4d_tech@lists.4d.com Cc: Keith White Subject: Re: 4D Client as Web Server - Using same 4D Process if web access from diff. machines Hi That’s actually normal for a 4D Web Server. You’re not guaranteed to get a new process for each request. Web processes can be reused. I think there is a structure setting to control it when using 4D Remote as a web server, though I forget what it’s called. There is also a setting for 4D Web server to specify the minimum number of processes to keep around for web requests. Either way, you can’t 100% rely on process variables, selections, sets etc to be clean at the start of a web process. Hope that helps Best regards Keith White Synergist Express Ltd, UK 4697775 ** 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 Client as Web Server - Using same 4D Process if web access from diff. machines
Humble request to any that have used 4D Client as the web server: I'm getting "interesting" results when doing this. If a user logs into my web app from machine "A", there are some process variables set such as: User_ID, etc. If someone on machine "B" accesses from the web (No log in, just goes to the "home page") Then, the e.g. User_ID variable is populated from the previous log in. So 4D is using the same process for any access via web. This is not a good thing! Clearly, I'm being a meatball and doing something muy stupido, (or at least I hope that is the case.) These all work as expected: 4D Server 4D Local Mode 4D Volume Desktop Windows 10 - 4D 16r6 Any comments most welcome Randy Engle ** 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: Help?
Ken, I just tested this. FYI, I'm using Windows 4D v16r6 Started my app, held down alt key. Dialog: Open Data File Click OK "Immediately" held down Shift-ALT-Right Mouse Selected "Application Process" to trace Hit trace in first line of code on ON STARTUP Method. Let me know if this works Randy Engle, Director ** 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: Help?
Did you do something to make it open in "compiled mode" Randy Engle -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Kenneth Geiger via 4D_Tech Sent: Monday, September 10, 2018 4:57 PM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Kenneth Geiger Subject: Help? Hi All, I just made a really dumb mistake. Is there some magic key-stroke(s) (Windows 10, 4D v16) to force 4D to Start in the Design Mode? TIA, Ken ** 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 **
Colocation - Recommendations Survey
We are ready to roll out a couple of SaaS/Cloud solutions We have our test server installed at our site, but know that for production, it really needs to be at much more protected/powerbacked facility. We will also "very likely" need access via Citrix/Remote Desktop as besides the web interface, we will also need a standard 4D Client connection. The performance over WAN to the server will most likely not be adequate. It's a relatively complex app with 200+tables. This will be 4D Server v17+ It looks like there's a zillion options out there. I'm looking for recommendations from anyone successfully using these types of services. Gracious thanks Randy Engle, Director XC2 Software LLC – XC2LIVE! ** 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: pdfCreator problem
Keith, Two thumbs up for Armin's plugin. Yes, there is a cost, but eliminates a lot of headaches Randy Engle, Director XC2 Software LLC – XC2LIVE! Keith wrote > Hi all. > We have suddenly struck a problem with pdfCreator v1.7.2 not working > when using a built 4D Client via Remote Desktop Connection access. > It used to work, but started giving problems about a month ago (that's > when we first detected it). > > pdfCreator works just fine when the 4D Client is accessed via Ericom > and the Chrome browser, but not when accessed via Remote Desktop Connection. > In the latter case, the problem manifests itself when the document > that pdfCreator is told to create in the Temp folder in the User > folder doesn't happen, and an error is then generated when the code tries to > access it. > The error can be trapped but the document is needed. > It is not a user permissions problem because the code can write csv > files to the same folder. > > It happens for both 4D v15.2 and v17.0 HF1. > The computer is a cloud server VM running OS is Windows Server 2008 R2 > Datacenter / Service Pack 1. > > Has anyone come across this or something like it? > Thanks, Keith Keith, try this pdf plugin http://www.node.de/indexplug.htm regards Armin ** 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: Web Area display PDF
Hi Jeff, Thanks for posting this Sounds great! >> I have a component that you can drop into any database - 32-bit or 64-bit - >> that will render PDFs using Mozilla's open source PDFjs renderer. >> >> https://1drv.ms/u/s!Akpn2ti2N9ePuQFPa0jiG91YjE2z However, I'm getting a message: "This item might not exist or is no longer available" Randy Engle, Director XC2 Software LLC – XC2LIVE! ** 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: Export text columns containing carriage returns to Excel?
Brad Can I replace the carriage returns in the text fields with a special marker during export? I could replace the Excel cells containing the any carriage return markers with actual returns after import. This is frequently what I need to do: Replace the CR (13), (10), (11) with "///" or somesuch. Then put the CR back after import. Randy Engle -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Perkins, Bradley D via 4D_Tech Sent: Friday, August 3, 2018 10:22 AM To: 4d_tech@lists.4d.com Cc: Perkins, Bradley D Subject: Export text columns containing carriage returns to Excel? I've been asked to provide an export from a legacy 4D system delivered as an .xlsx file. The challenge I'm facing is that this table contains a number of text fields and the customer requires the imported column cells to retain the returns or line feeds in the original text fields. If I do a straight tab-delimited export with carriage returns as the end of line marker, the imported result does not preserve the original row because any returns encountered in the text fields are interpreted as end of row. My other challenge is that I need to do this with out-of-box end user capabilities from a client (v15.4 remote) against a compiled server. I can't install plugins, create new methods, etc. It has been many years since I've had to do this type of thing in 4D. Can I replace the carriage returns in the text fields with a special marker during export? I could replace the Excel cells containing the any carriage return markers with actual returns after import. Thanks, Brad Perkins ** 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: Can't publish on Port 80 - WTF?
Dani, Many thanks. Looks promising Randy Engle, Director XC2 Software LLC – XC2LIVE! -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Dani Beaubien via 4D_Tech Sent: Monday, July 23, 2018 1:32 PM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Dani Beaubien Subject: Re: Can't publish on Port 80 - WTF? This might solve your situation. https://support.microsoft.com/en-us/help/4338824/windows-81-update-kb4338824 <https://support.microsoft.com/en-us/help/4338824/windows-81-update-kb4338824> Dani Beaubien > On Jul 23, 2018, at 1:56 PM, David Conley via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Randy, > > There is a windows service called World Wide Web that runs on port 80. If > that is running, try disabling the service. > > David > >> On Jul 23, 2018, at 2:34 PM, Randy Engle via 4D_Tech <4d_tech@lists.4d.com> >> wrote: >> >> >> So this tells me that something "else" is hogging port 80 What >> other sneaky service/app could this possible be? >> How else to find out what is using Port 80? >> > > ** > 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: Can't publish on Port 80 - WTF? - NOT SOLVED... But working
I Dunno Did a full shutdown (Not just a RESTART) Then cold boot. Now working. Who knows... Thanks for listening. Randy Engle, Director XC2 Software LLC – XC2LIVE! -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Randy Engle via 4D_Tech Sent: Monday, July 23, 2018 12:34 PM To: '4D iNug Technical' <4d_tech@lists.4d.com> Cc: Randy Engle <4d.l...@xc2.us> Subject: Can't publish on Port 80 - WTF? I hate being a dope, but clearly I need to alter my expectations of myself! One machine in our office, our test machine: Can't publish on Port 80 In the past (last week), works no problemo. Works fine on other machines. Testing today... no go. Works fine on other ports (81, 8080, 8081, etc) Windows Server 2012 r2 4D - Windows 16r6 NOTHING (Really!) else running on port 80. (That I can see) Checked Resource Monitor - Nada NetStat - Nope! No Skype Running IIS not running Apache not running Firewall completely turned off Looked for any suspicious services or tasks Restarted machine Chanted Krishna, threw I Ching, smudged room with burning sage, etc. Get error message: "Failed to Create a listening socket" Database cannot be published. "Only one usage of each socket address is normally permitted" So this tells me that something "else" is hogging port 80 What other sneaky service/app could this possible be? How else to find out what is using Port 80? I'm starting the web server using "WEB START SERVER" Tried the structure checkbox: "Launch Web Server at Startup" Same results Also, Same results for Single-User System (Local Mode) OK... I give up, I'm on Candid Camera, right? Randy Engle, Director XC2 Software LLC – XC2LIVE! ** 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 **
Can't publish on Port 80 - WTF?
I hate being a dope, but clearly I need to alter my expectations of myself! One machine in our office, our test machine: Can't publish on Port 80 In the past (last week), works no problemo. Works fine on other machines. Testing today... no go. Works fine on other ports (81, 8080, 8081, etc) Windows Server 2012 r2 4D - Windows 16r6 NOTHING (Really!) else running on port 80. (That I can see) Checked Resource Monitor - Nada NetStat - Nope! No Skype Running IIS not running Apache not running Firewall completely turned off Looked for any suspicious services or tasks Restarted machine Chanted Krishna, threw I Ching, smudged room with burning sage, etc. Get error message: "Failed to Create a listening socket" Database cannot be published. "Only one usage of each socket address is normally permitted" So this tells me that something "else" is hogging port 80 What other sneaky service/app could this possible be? How else to find out what is using Port 80? I'm starting the web server using "WEB START SERVER" Tried the structure checkbox: "Launch Web Server at Startup" Same results Also, Same results for Single-User System (Local Mode) OK... I give up, I'm on Candid Camera, right? Randy Engle, Director XC2 Software LLC – XC2LIVE! ** 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: Creating Tables by running a method
Jody,
Glad to hear of your progress!
Randy Engle, Director
XC2 Software LLC – XC2LIVE!
-Original Message-
From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Jody Bevan via 4D_Tech
Sent: Saturday, June 23, 2018 9:53 AM
To: 4D iNug Technical <4d_tech@lists.4d.com>
Cc: Jody Bevan
Subject: Re: Creating Tables by running a method
Randy:
So I have got this done using all SQL. At the end it would create the indexes
for the first table I created, but then fail for al the next. Eventually I
figured out that the index name (behind the scenes) need to be unique within
the whole database. Therefore I just added a string of the table number into
the middle of the Index name. Tried it at front and that failed.
All these little gotchas. I really didn’t want to sit and read SQL books for a
week that may or may not explain these issues.
Thanks for your help - it is working!!
Pat:
I am using 16R6. I tried creating a trigger in the tables that I created using
SQL. I can go in and write code in the table triggers. They are saved. I didn’t
see if they actually ran though. Maybe 4D resolved this issue.
Thanks all
Now on to having the method write all our standard code around a table that our
shell has.
Jody Bevan
Developer
Argus Productions Inc. <https://www.facebook.com/ArgusProductions/>
+1 587-487-6120
> On Jun 22, 2018, at 3:18 PM, Jody Bevan wrote:
>
> Randy:
>
> Thanks so much for this. Giving me two ways - 4D and SQL. I am going to work
> on some code and interface for doing this.
>
> Jody
>
>> On Jun 22, 2018, at 12:09 PM, Randy Engle via 4D_Tech <4d_tech@lists.4d.com
>> <mailto:4d_tech@lists.4d.com>> wrote:
>>
>> Jody,
>>
>> You can set/create an index in 4D Code
>>
>> ARRAY POINTER($fieldPtrArr;1)
>> $fieldPtrArr{1}:=->[Facility]Facility_Name
>> CREATE INDEX([Facility];$fieldPtrArr;Standard BTree
>> index;"FacilityNameIDX")
>>
>>// composite index
>> ARRAY POINTER($fieldPtrArr;2)
>> $fieldPtrArr{1}:=->[Facility]Service_Address_City
>> $fieldPtrArr{2}:=->[Facility]Service_Address_Zip_Code
>> CREATE INDEX([Facility];$fieldPtrArr;Standard BTree
>> index;"CityZipIDX")
>>
>>
>> Primary Keys - Needs SQL
>>
>> $sql:="ALTER TABLE "+$tableName
>> $sql:=$sql+" "+"ADD PRIMARY KEY ("+$fieldName+")"
>> Begin SQL
>> EXECUTE IMMEDIATE: $sql;
>> End SQL
>>
>>
>>
>> Randy Engle, Director
>> XC2 Software LLC – XC2LIVE!
>>
>
**
4D Internet Users Group (4D iNUG)
FAQ: http://lists.4d.com/faqnug.html
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:4d_tech-unsubscr...@lists.4d.com
**
**
4D Internet Users Group (4D iNUG)
FAQ: http://lists.4d.com/faqnug.html
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:4d_tech-unsubscr...@lists.4d.com
**
RE: Creating Tables by running a method
Just in case you "really" want to use SQL to create the index:
$statement_t:=""
$statement_t:=$statement_t+"CREATE INDEX "+$index_Name
$statement_t:=$statement_t+" " // Need a space
$statement_t:=$statement_t+"ON "+$tableName_t+" ("+$fieldName+")"
//example: $statement_t:="CREATE INDEX CITY_IDX ON ADDRESSES (City)"
Begin SQL
EXECUTE IMMEDIATE :$statement_t;
End SQL
Randy Engle, Director
XC2 Software LLC – XC2LIVE!
-Original Message-
From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Jody Bevan via 4D_Tech
Sent: Friday, June 22, 2018 10:45 AM
To: 4D iNug Technical <4d_tech@lists.4d.com>
Cc: Jody Bevan
Subject: Creating Tables by running a method
I know that this feature has been around for a long time ~ 4D 2011.
I am now using 16R6. I now have a method that creates a table with the fields I
want added.
The challenge I am having is setting indexes (and index types), as well as
Primary Keys.
I looked in the Knowledge Base for code examples but do not see any - hmmm.
I am not a SQL person, so reading the 4D SQL Reference on this is a bigger
challenge to me.
Can anyone pass along a point to example code, or reference for this.
Thanks
Jody Bevan
Developer
Argus Productions Inc. <https://www.facebook.com/ArgusProductions/>
+1 587-487-6120
**
4D Internet Users Group (4D iNUG)
FAQ: http://lists.4d.com/faqnug.html
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:4d_tech-unsubscr...@lists.4d.com
**
**
4D Internet Users Group (4D iNUG)
FAQ: http://lists.4d.com/faqnug.html
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:4d_tech-unsubscr...@lists.4d.com
**
RE: Creating Tables by running a method
Jody,
You can set/create an index in 4D Code
ARRAY POINTER($fieldPtrArr;1)
$fieldPtrArr{1}:=->[Facility]Facility_Name
CREATE INDEX([Facility];$fieldPtrArr;Standard BTree
index;"FacilityNameIDX")
// composite index
ARRAY POINTER($fieldPtrArr;2)
$fieldPtrArr{1}:=->[Facility]Service_Address_City
$fieldPtrArr{2}:=->[Facility]Service_Address_Zip_Code
CREATE INDEX([Facility];$fieldPtrArr;Standard BTree
index;"CityZipIDX")
Primary Keys - Needs SQL
$sql:="ALTER TABLE "+$tableName
$sql:=$sql+" "+"ADD PRIMARY KEY ("+$fieldName+")"
Begin SQL
EXECUTE IMMEDIATE: $sql;
End SQL
Randy Engle, Director
XC2 Software LLC – XC2LIVE!
-Original Message-
From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Jody Bevan via 4D_Tech
Sent: Friday, June 22, 2018 10:45 AM
To: 4D iNug Technical <4d_tech@lists.4d.com>
Cc: Jody Bevan
Subject: Creating Tables by running a method
I know that this feature has been around for a long time ~ 4D 2011.
I am now using 16R6. I now have a method that creates a table with the fields I
want added.
The challenge I am having is setting indexes (and index types), as well as
Primary Keys.
I looked in the Knowledge Base for code examples but do not see any - hmmm.
I am not a SQL person, so reading the 4D SQL Reference on this is a bigger
challenge to me.
Can anyone pass along a point to example code, or reference for this.
Thanks
Jody Bevan
Developer
Argus Productions Inc. <https://www.facebook.com/ArgusProductions/>
+1 587-487-6120
**
4D Internet Users Group (4D iNUG)
FAQ: http://lists.4d.com/faqnug.html
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:4d_tech-unsubscr...@lists.4d.com
**
**
4D Internet Users Group (4D iNUG)
FAQ: http://lists.4d.com/faqnug.html
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:4d_tech-unsubscr...@lists.4d.com
**
RE: issue on windows 10 and 4D 15
Yes, this has been a problem with some users who have display properties set differently. Right click on the EXE, click on "Properties" Click the Compatibility Tab Click on "Change High DPI Settings" Check "Override High DPI scaling behavior" The above will be slightly different, dependent upon the specific version of Windows 10. Easy-Peasy Lemon Squeezy! Randy Engle, Director XC2 Software LLC – XC2LIVE! -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Randy Jaynes via 4D_Tech Sent: Friday, June 15, 2018 6:13 AM To: 4D iNug List <4d_tech@lists.4d.com> Cc: Randy Jaynes Subject: Re: issue on windows 10 and 4D 15 Chuck, We’ve had weird display issues on specific machines when the user has set the display properties to more than 100% or they’ve selected a theme other than the default Windows theme. Randy -- Randy Jaynes Senior Programmer and Customer Support http://printpoint.com <http://printpoint.com/> • 845.687.3741 • PrintPoint, Inc • 57 Ludlow Lane • Palisades, NY 10964 Please send all email contacts to supp...@printpoint.com <mailto:supp...@printpoint.com> > On Jun 15, 2018, at 8:09 AM, Chuck Miller via 4D_Tech <4d_tech@lists.4d.com > <mailto:4d_tech@lists.4d.com>> wrote: > > Hi All, > > I have one windows ten machine where pictures of buttons do not display > properly. They do on all other instances. We have deleting local files, > reinstalling 4D, to no avail. Any ideas out ther greatly appreciated > > Thanks and regards. ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com ** ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Content Security Policy - inline style
I have a particular customer that is able to come up with all kinds of security
snafus on a regular basis.
The latest is causing our web app to be really foobar in Chrome, Firefox, Edge
IE seems to be OK
Anyone care to provide a 1/2 cup of enlightenment to this wondrous, mystical
area.
The error messages in Developer Tools read something like this:
Refused to apply inline style because it violates the following Content
Security Policy directive: "default-src 'self'". Either the 'unsafe-inline'
keyword, a hash ('sha256-Y9v1MZrln1N8aPBY5lmpxYKwFkcp/nyBMMEnn7WFjuw='), or a
nonce ('nonce-...') is required to enable inline execution. Note also that
'style-src' was not explicitly set, so 'default-src' is used as a fallback.
A given web page has many, many of these error messages.
Help! Big points to anyone who can provide anything!
Many thanks
Randy Engle, Director
XC2 Software LLC – XC2LIVE!
**
4D Internet Users Group (4D iNUG)
FAQ: http://lists.4d.com/faqnug.html
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:4d_tech-unsubscr...@lists.4d.com
**
RE: Moving Methods/Forms between structures seems disabled - SOLVED!!!
Makes perfect senseThanks Randy Engle, Director XC2 Software LLC – XC2LIVE! for the record, it is not a 4D thing, any applications running as administrator (console, for example) will not accept drop from an app running on a lesser entitlement. 2018/06/13 7:58、Randy Engle via 4D_Tech <4d_tech@lists.4d.com<mailto:4d_tech@lists.4d.com>> のメール： If you have one of your 4D executables set to "Run as Administrator", you won't be able to "move" objects into it. ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
RE: Moving Methods/Forms between structures seems disabled
Let me ask this another way hopefully someone knows: If I "wanted" to not allow "moving" objects into a structure using the "moving" features of 4D, what setting would I check/uncheck? Thanks to all who entertain this option! Randy Engle, Director XC2 Software LLC – XC2LIVE! ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
RE: Moving Methods/Forms between structures seems disabled
Keisuke, No problemo. Yes, I've been comparing the settings between the two structures. Clearly, I'm missing something. Arrrggghhh! Thanks. Randy Engle, Director XC2 Software LLC – XC2LIVE! I am very sorry that the statement came across as blunt. I meant, compare the settings on structure A versus structure B (which you evidently have already done). > 2018/06/11 11:15、Randy Engle via 4D_Tech <4d_tech@lists.4d.com> のメール： > > Not sure what you are referring to "did you compare"? > Compare what. ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com ** ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
RE: Moving Methods/Forms between structures seems disabled
Yes, The checkbox for: "Prevent drop of data not coming from 4D" Is "Unchecked" Randy Engle, Director XC2 Software LLC – XC2LIVE! -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Keisuke Miyako via 4D_Tech Sent: Sunday, June 10, 2018 7:14 PM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Keisuke Miyako Subject: Fwd: Moving Methods/Forms between structures seems disabled or, at an even more basic level, is external drag and drop allowed in compatibility? http://doc.4d.com/4Dv16R6/4D/16-R6/Compatibility-page.300-3561530.en.html ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com ** ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
RE: Moving Methods/Forms between structures seems disabled
Hi Keisuke, I've been over this page in the docs 10 times, looking for the secret item. Not sure what you are referring to "did you compare"? Compare what. The moving settings look like they are identical in both structures. But, clearly, I'm missing something. Thanks Randy Engle, Director XC2 Software LLC – XC2LIVE! -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Keisuke Miyako via 4D_Tech Sent: Sunday, June 10, 2018 7:04 PM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Keisuke Miyako Subject: Re: Moving Methods/Forms between structures seems disabled did you compare http://doc.4d.com/4Dv16R6/4D/16-R6/Moving-page.300-3561535.en.html > 2018/06/11 10:18、Randy Engle via 4D_Tech <4d_tech@lists.4d.com> のメール： > > I've looked the structure settings but can't find anything that prevents > "moving" > I'm sure it just a checkbox somewhere ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com ** ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
RE: Moving Methods/Forms between structures seems disabled
Julio, Good idea... but that didn't work either. Thanks for the suggestion. Randy Engle, Director XC2 Software LLC – XC2LIVE! -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Julio Carneiro via 4D_Tech Sent: Sunday, June 10, 2018 7:01 PM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Julio Carneiro Subject: Re: Moving Methods/Forms between structures seems disabled For me moving between structures only works if the target structure’s explorer is in Home. So, maybe in your case “B” explorer is not in the Home page, and that prevents moving into it… just an idea hth julio > On Jun 10, 2018, at 10:18 PM, Randy Engle via 4D_Tech <4d_tech@lists.4d.com > <mailto:4d_tech@lists.4d.com>> wrote: > > I must be losing my marbles. > > I have two structures, almost identical. > > I can move objects (methods, forms) from structure A to structure B. > But moving from B to A does not work > (I get a circle with a line through it) > > This is v16r6 > Windows > > I've looked the structure settings but can't find anything that prevents > "moving" > > I'm sure it just a checkbox somewhere > > Randy Engle, Director > XC2 Software LLC – XC2LIVE! > -- Julio Carneiro jjfo...@gmail.com ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com ** ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Moving Methods/Forms between structures seems disabled
I must be losing my marbles. I have two structures, almost identical. I can move objects (methods, forms) from structure A to structure B. But moving from B to A does not work (I get a circle with a line through it) This is v16r6 Windows I've looked the structure settings but can't find anything that prevents "moving" I'm sure it just a checkbox somewhere.... Randy Engle, Director XC2 Software LLC – XC2LIVE! ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Email Errors - Intermittent - Socket Descriptor Error
About half the emails sent from my application have been returning an error and not sent: (Today, about 60 of 120 failed) Error Text: "Specified socket descriptor is not valid for this application [10038]" I've not got a clue what this means Some go through, some don't. "Usually", it's the same email addresses that fail, but not always. These email typically have 2 pdf attachments Windows 2012 Server 4D Server 16r6 Using "SMTP_Send" Internet Commands Port 587 Authenticated User/Password Any help, most appreciated. Randy Engle, Director XC2 Software LLC – XC2LIVE! ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
RE: Web App on iPhone - Returns gobblydygook
Hi Kirk, Thanks for the info Will check it out. Randy Engle, Director XC2 Software LLC – XC2LIVE! -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Kirk Brooks via 4D_Tech Sent: Wednesday, May 16, 2018 10:53 AM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Kirk Brooks <lists.k...@gmail.com> Subject: Re: Web App on iPhone - Returns gobblydygook Hey Randy, So, to recap: 1 - only affects a few iPhone users 2 - you are able to access it with your iPhone First guess is the browser being used. I'm assuming you are using Safari. Maybe they are using Firefox or Chrome. I'd ask about that first. Second would be some sort of add on: add-blocker or such. (I bet this is it) Third is it specific to iPhones on Verizon (doubtful)? I agree the first part is the header suggesting the page gets downloaded. It just doesn't get interpreted correctly. That's happening on the phone and because of something specific to those devices. On Wed, May 16, 2018 at 10:10 AM Randy Engle via 4D_Tech < 4d_tech@lists.4d.com> wrote: > We have an web app (not an app, browser based). > > > > We’ve had a 2 users who are using iPhones (not all, just a couple), > that upon submission of a form, they get return some unfriendly info > on their iPhone screen. > > > > The first section is what looks like the http header > > Then after that is just a bunch of characters. > > Works fine on my iPhone. > > > > Here’s a screen shot of this: > > http://www.xc2software.com/bugz/iPhone_gobbldygook.jpg > > > > Has anyone seen this behavior? > > Got any ideas? > > > > Gracious thanks! > > > > Randy Engle, Director > > XC2 Software LLC – XC2LIVE! > > > > ** > 4D Internet Users Group (4D iNUG) > FAQ: http://lists.4d.com/faqnug.html > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > ** -- Kirk Brooks San Francisco, CA === *We go vote - they go home* ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com ** ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Web App on iPhone - Returns gobblydygook
We have an web app (not an app, browser based). We’ve had a 2 users who are using iPhones (not all, just a couple), that upon submission of a form, they get return some unfriendly info on their iPhone screen. The first section is what looks like the http header Then after that is just a bunch of characters. Works fine on my iPhone. Here’s a screen shot of this: http://www.xc2software.com/bugz/iPhone_gobbldygook.jpg Has anyone seen this behavior? Got any ideas? Gracious thanks! Randy Engle, Director XC2 Software LLC – XC2LIVE! ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Server Administration Window - I must have been dreaming
Was I dreaming or did I see/hear that the server administration window could be customized? Randy Engle, Director XC2 Software LLC – XC2LIVE! ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
RE: Options To Put Data Into Existing Excel Spreadsheets?
Another "plug" for Pluggers XCEL plugin. We use it exclusively. Full control of the spreadsheet. Randy Engle, Director XC2 Software LLC – XC2LIVE! -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Douglas Cryer via 4D_Tech Sent: Tuesday, May 8, 2018 12:15 AM To: 4d_tech@lists.4d.com Cc: Douglas Cryer <jdcr...@telekinetix.com> Subject: Re: Options To Put Data Into Existing Excel Spreadsheets? Allan, Until recently we were using Keisuke's component. Clients were asking for more, in particular images so we looked around and found the Pluggers Plugin. Yes it does mean going from a free option to a paid option but equally it is like going from a 2CV to a Ferrari. It does much more, far faster and far more efficiently. Keisuke himself said that the component was written as an example and he never expected it to be used in production systems. Since adopting the Excel Plugin we have converted many outputs and our clients love it. They have commissioned more reports and we have been able to recoup the cost of the plugin easily within months of purchase. If you still need the component I am sure I can dig you out a copy but I would urge you to either fund the cost of the plugin yourself or get your client to do so. You will not be sorry. Regards, Dougie telekinetix Limited- J. Douglas Cryer Phone : 01234 761759 Mobile : 07973 675 218 2nd Floor Broadway House, 4-6 The Broadway, Bedford MK40 2TE Email : jdcr...@telekinetix.com Web : http://www.telekinetix.com <http://www.telekinetix.com/> ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com ** ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
RE: 64 vs 32 Bit 4D
4DWRITEPro (several items) Quick Report Editor (new version) A few others I think Randy Engle, Director XC2 Software LLC – XC2LIVE! -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Cannon Smith via 4D_Tech Sent: Monday, April 30, 2018 3:34 PM To: 4D iNug Technical <4D_Tech@lists.4D.com> Cc: Cannon Smith <can...@synergyfarmsolutions.com> Subject: 64 vs 32 Bit 4D I’m currently using 4D v16r5, Mac and Windows. I’m using the 64-bit versions across the board. I may need to drop back to 32-bit for clients and standalone for a little while. I can’t seem to remember or find if there are any features (besides the network settings) that are 64-bit only. Does anyone know if there are features I may be forgetting about? Thanks. -- Cannon.Smith Synergy Farm Solutions Inc. Hill Spring, AB Canada 403-626-3236 <can...@synergyfarmsolutions.com> ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com ** ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
64Bit Client Cannot Connect to server - 16r5
We have been deploying our app (Windows Only), using v16r5 We have only been distributing the 32bit Client, as many of our customer still only have 32bit OS Using 64bit solved a problem with 4DWritePro, so for select customers, we plan to make the 64bit Client available. However, in launching the 64bit Client, I'm not able to connect to 4D Server (Server is 64bit) - App is compiled for both 32 and 64 Bit Can't see it in available servers Entering values in the "Custom" tab fail: Receive error: The connection for this process has been disrupted or the connection couldn't be established: Also Error 54 - Socket Write Failed. I'm perplexed. ?!?!?!?!?! Something I'm not doing in the Build for Client?, that is different for 64 vs 32 bit? Any clues, anyone? Many thanks Randy Engle, Director XC2 Software LLC – XC2LIVE! ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
RE: 4D Summit 2018 Comments - Import XML Structure
I tried this from several different angles (16r6) Import XML Structure works like importing records. It doesn't "update" or "merge", just imports new structure elements (Tables) Perhaps Laurent was confused at that moment? Randy Engle, Director XC2 Software LLC – XC2LIVE! -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Patrick Emanuel via 4D_Tech Sent: Tuesday, April 10, 2018 8:44 AM To: 4d_tech@lists.4d.com Cc: Patrick Emanuel <patrickspams-e...@yahoo.fr> Subject: Re: 4D Summit 2018 Comments Hi, >> naming relations is needed to take make the code readable. >Laurent's suggestion is to export the structure in XML, modify all the relation names in the text file, and reimport the structure as XML. It will be faster than to go across the complete graphical structure representation. I've just tried this and get an error message because table already existed (with a version < v17). Does it work started with the v17? Just to know. ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
RE: Thousands of invalid processes - Delay Process issue?
Hi Jeff, I've encountered what I believe is a "DELAY PROCESS" bug as well. In some situations, it behaves in a similar fashion to "PAUSE PROCESS" Difficult to nail down and replicate in a fresh database. Just wanted to let you know that I've seen it also. Had to do a full work around to avoid the problem. Randy Engle, Director XC2 Software LLC – XC2LIVE! -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Jeffrey Kain via 4D_Tech Sent: Sunday, April 8, 2018 7:52 AM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Jeffrey Kain <jeffrey.k...@gmail.com> Subject: Thousands of invalid processes - Delay Process issue? I posted last Saturday that we were hit by the DELAY PROCESS bug in v16 three times in one day - once on each of our two mirrors, and also on our production server in (at least) the stored procedure that generates the journal files. I resumed the mirror process without any problem and let the production server run, but also noticed the usual pattern that 4D had stopped updating its user interface also. Things like the CPU graph on the monitor tab had stopped updating, and the uptime display was wrong. I checked on the server today from the administration window command in 4D Remote, which doesn't stop updating even if the server UI does. There are about 100 users connected with about 600 processes running, but on the Process tab there are over 5600 "Users Processes" and over 1200 "4D Processes" for just 100 users. There are MANY "Reused spare processes" and lots of processes from users who are no longer connected to the server (and users who wouldn't be working on a Sunday anyway). Anyone ever seen anything like this? This is a Windows Server 2012 64-bit running 16.3 HF2. I'm guessing that this all stems from the DELAY PROCESS bug - one thought is that some background cleanup/garbage collection task has stopped working. -- Jeffrey Kain jeffrey.k...@gmail.com ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
4DWritePro... Printing - Font Size Dependent upon Display Settings
This is Windows 10 4D 16R5 Found a most curious "anomaly" in 4DWrite Pro We have a 4DWrite pro area (actually, 2 areas) on a form for printing Depending upon the "Display Setting" scaling, the printed font size is different, hence making printing a rather interesting job of satisfying our customers with a successful, consistent print job. Where "Double_Quote" is a function that returns a double quote "+$text+"" If the display setting is 100%, prints at what looks like 8pt. (Desired) If the display setting is 125%, prints at... well 25% more (10pt) (No fun!) Don't want the font size on the printed doc to change!!! WTF! This is a rather complicated form to print, with two columns of info, "wrapped" , where I'm needing to count the lines printed and print to the alternate WP area when I've reached the max number of lines, and the issue a page break when the second WP area is "full". Got any ideas! Also, thanks to all who made the Vinofest a raging success! Randy Engle, Director XC2 Software LLC – XC2LIVE! ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
RE: Import from Excel
Hi Ferdinando, I second Pat Bensky's suggestions of Rob Laveaux's Pluggers EXCEL Plugin. http://www.pluggers.nl/product/xl-plugin There is a reasonable cost for this plugin, but it provides serious capabilities to work with Excel files. This is what we use exclusively. As well there are some free Excel plugins from Miyako : https://github.com/miyako These are great for some quick Excel features. But if you need real control, Pluggers is it. Randy Engle, Director XC2 Software LLC – XC2LIVE! ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
RE: [SAD NEWS] legendary developer and 4D base-rock Ortwin Zillgen
To All, This year's 4D Summit "Vinofest" (and other beverages, etc), will be dedicated to Ortwin Zillgen! (anybody know his favorite beverage?) Randy Engle, Director XC2 Software LLC – XC2LIVE! ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
RE: 4D 15R5 Feedback
Sujit, Yes, we have intensive SOAP calls into a 4D Windows 15r5 System from numerous locations. Randy Engle, Director XC2 Software LLC – XC2LIVE! Internet – Hosted – In the Cloud: On-line Backflow Test Entry! XC2Live! - Backflow Program Management Operational Now! – Call for additional information: 800.761.4999 -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Sujit Shah via 4D_Tech Sent: Monday, February 26, 2018 6:00 PM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Sujit Shah <sujit...@gmail.com> Subject: 4D 15R5 Feedback We have a database which uses SOAP across several sites in various configurations of C/S, C/S <-> C/S and C/S <-> Standalone. The server crashes randomly (or so it seems) with a MSVCR120.dll crash. We have updated to the latest Visual Studio/ reinstalled etc but the crashing persists. Has anyone had this problem with 4D 15R2? Is there anyone running intensive SOAP operations with 4D 15 R5? TIA -- xxx "There must be ingenuity as well as intention, strategy as well as strength. " ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com ** ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
RE: [SAD NEWS] legendary developer and 4D base-rock Ortwin Zillgen
I never met him personally, but I very much enjoyed and appreciated Ortwin's contributions! Carry on, Ortwin! Into the unknown! Randy Engle, Director XC2 Software LLC – XC2LIVE! Internet – Hosted – In the Cloud: On-line Backflow Test Entry! XC2Live! - Backflow Program Management Operational Now! – Call for additional information: 800.761.4999 -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Herr Alexander Heintz via 4D_Tech Sent: Tuesday, February 27, 2018 3:22 AM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Herr Alexander Heintz <listrea...@heintz.net> Subject: [SAD NEWS] legendary developer and 4D base-rock Ortwin Zillgen Fellow 4D developers, it is with great sadness, that I have to inform you, that Ortwin Zillgen has passed away end of last week. Suddenly, unexpectedly and far to early at the young age of 64. Ortwin was known to many of us for his interesting and innovative ideas for interfaces, anything to do with cartography and mastery of subforms, his garish striped shirts and baggy yellow jacket, but most of all, as an all-around great guy to hang out with and talk of 4d, art, and anything that comes to mind. I have known him for many years and never saw him without that wide friendly grin on his face, I will miss it. 4d tech support all over the world will painfully feel his absence and an urgent need to stock up on staff. He will be missed dearly and we wish him godspeed whichever tricky subform he may be heading to. All the best to y’all and stay safe Alex Heintz PS: I will pass on any condolences from the nug to his family ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com ** ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
RE: ADA Compliance ???
Thanks to all for the ADA Resources! Randy Engle, Director XC2 Software LLC – XC2LIVE! -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Graham Langley via 4D_Tech Sent: Wednesday, January 24, 2018 8:21 AM To: 4d_tech@lists.4d.com Cc: Graham Langley <m...@grahamlangley.co.uk> Subject: Re: ADA Compliance ??? Randy, This you give you a good overview of what’s required; https://www.searchenginejournal.com/ada-compliant-website/200106/ -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com ** ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
ADA Compliance ???
Every week, or so, one of our customers comes up with something that they do/need that I've never heard of before. This weeks winner is a major city in Southern California. (no names mentioned...) They want to know at what "Level" our web product is ADA compliant. I'm aware of ADA compliance when it comes to physical spaces, ramps, bathrooms, etc., but not for software (web pages, specifically) Anybody had the pleasure of handling this one yet? Know of any resources? Thanks Randy Engle, Director XC2 Software LLC – XC2LIVE! ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
RE: Web Services Using HTTPS
Steve, For starters, you will need an SSL Certificate Pascal from QualitySSL is very responsive and helpful. He's in Denmark but keeps late hours. Randy Engle, Director XC2 Software LLC – XC2LIVE! -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Stephen J. Orth via 4D_Tech Sent: Monday, January 22, 2018 3:21 PM To: '4D iNug Technical' <4d_tech@lists.4d.com> Cc: Stephen J. Orth <s.o...@the-aquila-group.com> Subject: RE: Web Services Using HTTPS Yes, I want to publish a web service that someone can subscribe to using HTTPS (instead of HTTP). I will also need to be able to return information back the same way. I'm trying to educate myself on using HTTPS, as I've never had to use it before. Best, Steve -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Keisuke Miyako via 4D_Tech Sent: Monday, January 22, 2018 4:09 PM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Keisuke Miyako <keisuke.miy...@4d.com> Subject: Re: Web Services Using HTTPS you mean, you want to publish SOAP web services from 4D (and not consume one) ? all the principles for setting up the web server applies; certificate, redirection, etc. http://doc.4d.com/4Dv16/4D/16.3/Using-TLS-Protocol.300-3652280.en.html 2018/01/23 6:43、Stephen J. Orth via 4D_Tech <4d_tech@lists.4d.com<mailto:4d_tech@lists.4d.com>> のメール： I have a customer who is requesting HTTPS and we have always done straight HTTP. ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com ** ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com ** ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
RE: Anyone been using R5 for real work?
Jeff, I'm testing with 16r5 Found a problem building with OEM keys, but if you are not OEM, that shouldn't be a problem. Will let you know if we find anything else. Randy Engle, Director XC2 Software LLC – XC2LIVE! -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Jeffrey Kain via 4D_Tech Sent: Friday, January 19, 2018 8:54 AM To: 4d_tech@lists.4d.com Cc: Jeffrey Kain <jeffrey.k...@gmail.com> Subject: Anyone been using R5 for real work? Just wondering how it's going... there's so much new stuff it's tempting to jump on the "R" train. But 16.3 is so extremely solid... ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com ** ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
RE: DELAY PROCESS bug
I might chime in here as well: "Sometimes", under certain conditions, HIDE PROCESS behaves the same as DELAY PROCESS e.g. code should keep executing after HIDE PROCESS, but it gets "delayed" instead. I've not narrowed in down but we are certainly seeing this happen. Are these issues related? Hmmm... maybe/maybe not. Randy Engle, Director XC2 Software LLC – XC2LIVE! ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Creating/Modifying 4DWrite/Pro Documents via Web Page
If anybody has done anything like this, love to hear about it! Our customers want a "complete" web solution. This includes creating and Editing 4DWrite Docs(could be 4DWritePro), from a browser. (No, probably can't do this with 4DWrite/4DWritePro... but maybe...) Or... the equivalent or something close. Need the usual styles/colors/fonts (Tab Stops!!!), etc. Some fancy super-duper javascript thingy? The intention is to be able to do a merge with e.g. a list of customers, and print to a PDF. (This is the easy part) Creating and Editing them in the first place is the fun part. My brain throws a hissy fit when I try to think of how to do this. Any brainiacs out there who've done anything remotely like this? Randy Engle, Director XC2 Software LLC – XC2LIVE! ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
RE: Microsoft Outlook Integration
Tim, I'm pretty sure that Armin Deeg can help you out here. http://node.de/indexplug.htm Randy Engle, Director XC2 Software LLC – XC2LIVE! -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Tim Nevels via 4D_Tech Sent: Friday, December 15, 2017 12:51 PM To: 4d_tech@lists.4d.com Cc: Tim Nevels <timnev...@mac.com> Subject: Microsoft Outlook Integration I have a client that wants to have me integrate his 4D application with Outlook. Basically I need to be able to create an html email, include attachments and send it via his Outlook client on his machine. I know there is a way to turn on some features on the Exchange server to allow sending emails without using the Outlook client, but this cannot be done. Corporate IT refuses to allow this. I am aware that there are some security settings that need to be turned off or disabled to allow an app to control Outlook and send emails with it. I have full control of the Windows 10 PC and can do whatever is needed to turn these off. (IT does not have access to this PC.) I know there have been some plugins that allow doing this kind of thing, but I can’t remember what they are or where to get them. Anybody doing this now and can provide info on how you are doing it? Can anyone provide me a link to where to find a plugin to do this? Tim Tim Nevels Innovative Solutions 785-749-3444 timnev...@mac.com ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com ** ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
RE: Macros - how to insert "<>"
Chip Randy Engle, Director XC2 Software LLC – XC2LIVE! mailto: randy.en...@xc2software.com PH: 800.761.4999 – 415.456.9200 Internet – Hosted – In the Cloud: On-line Backflow Test Entry! XC2Live! - Backflow Program Management Operational Now! – Call for additional information: 800.761.4999 -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Chip Scheide via 4D_Tech Sent: Wednesday, December 13, 2017 2:40 PM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Chip Scheide <4d_o...@pghrepository.org> Subject: Macros - how to insert "<>" i want to have a 4D marco include the following text, but the macro parser chokes. My HTML-fu is not strong :) I believe that the macro parser is choking on the left arrow right arrow, so I need some help in escaping them. ((<>x_Cr*2)+Current method name+<>x_Cr) Thanks! Chip --- Gas is for washing parts Alcohol is for drinkin' Nitromethane is for racing ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com ** ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
RE: AreaList Pro version 10 - The new breakthrough in 4D user interface
Phil, Congrats on getting this out! Randy Engle, Director XC2 Software LLC – XC2LIVE! -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Philippe Ganter via 4D_Tech Sent: Wednesday, December 13, 2017 6:39 AM To: 4D iNug Technical <4d_tech@lists.4D.com> Cc: Philippe Ganter <phgl...@e-node.net> Subject: AreaList Pro version 10 - The new breakthrough in 4D user interface AreaList Pro version 10 has been released. www.e-node.net/alp This version offers 32-bit and 64-bit support for 4D v16 and above. Version 10 also brings tons of new features and tremendous granularity. It fully supports v8 API and v9 API: your existing code should not require any changes. • Direct data display from a MySQL database Set a MySQL server as data source and display its data in AreaList Pro v10 though one single line of code, with hundreds of formatting options available. • Global settings and templates - Global area settings: -> Area = 0 : apply to all areas to be created (defining an area -> “template”) Area = -2 : apply to all existing areas, but not to areas -> to be created Area = -3 : apply to all existing areas in current -> process only - Global column settings: -> Column = 0 : apply to all columns to be created (defining a column -> “template”) in either a specific area, or in area 0, -2 or -3 as -> above Column = -2 : apply to all existing columns in either a -> specific area, or in area -2 or -3 as above for existing areas - Global row settings: -> Row = -2 : apply to all rows in either a specific area, or in area -2 -> or -3 as above for existing areas • New commands - Move a column (AL_MoveColumn) - Duplicate a column (AL_DuplicateColumn) • Grouping columns and headers - Group columns together - Dragging a group of columns - Column group header (above the column individual headers or replacing them) – row and cell properties can be used with Row = -3 - Hierarchy row merged into one cell that goes across several columns • Area display features - Zooming an entire area (smaller or larger display, factor 0.1 to 5) - Display Transposed (rotate rows ↔ columns) – This allows “palette” style interface, with different data types among “rows” - Multi-level break processing (ala PrintList Pro) including in hierarchical lists - Many new “appearance” settings: system, automatic, custom pictures or 10 different OSX/Windows standard themes - Show/hide vertical scrollbar • Column features - Minimum column width for any column(s) - New properties to enable/disable each column's sorting, dragging or resizing - “Use ellipsis” settable for headers, specific columns, individual rows, footers, and even individual cells - Popup entry type is now a column property: 0 = default (depends on data type), 1 = date, 2 = time - Limiting entry string length (length limit is now a column property) - Define a formula instead of a callback for a calculated column • Other cool features - CSV format in Copy / Drag from an area - Named selections as sources - Entry placeholder support - Formatting at cell level: ALP_Cell_Format and ALP_Cell_Flags - Formatting at row level (font, color, alignment, spacing, etc.): ALP_Row_Flags - Show a longint value as picture in Field or Array Display (e.g. “star rating” display) - Access row and cell properties for header and footer (Header: row = 0, Footer: row = -1) • Miscellaneous - Hide row dividers in empty areas (ALP_Area_ShowRowDividers is now 3-state) - Custom picture above vertical scrollbar (old AL_SetHeaderOptions) including callback on mouse down or up - Override row/cell bottom row divider color (set a specific color for the bottom divider of a given row or cell) - ALP_Column_EntryAllowReturn: allow/disallow return in specific columns regardless of the area settings (ALP_Area_EntryAllowReturn) - Single line headers in “grid” mode (i.e. several lines per row, ALP_Area_AltHdrRowsInGrid>1) - Single line footers in “grid” mode (i.e. several lines per row, ALP_Area_FtrRowsInGrid>1) - Drag and move a column (physically reorder the column) even when not running in compatibility mode - New API replacement of AL_SetInterface: appearance + sort indicator properties Best regards, -- Philippe Ganter e-Node forums.e-node.net ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com ** ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Port 80 Security Scanning - e.g. Qualys
Our company and at least one other 4D developer have recently been hit with our customers doing a security scan of our 4D based web applications. In this particular case, they are using a service from "Qualys" that throws everything, including the kitchen sink at our web application. In a lot of these cases, they are running these scans internally, inside of their own network and behind their main firewall. (i.e. protection from mean, rotten, nasty, disgruntled employees that are doing bad things on their network) 4D Web server is not designed to handle many of the reported issues, such as DDOS attacks, "Slow HTTP Headers", etc. The cyber security teams at our customer sites are quite adamant that "we" need to handle all of this stuff. In most cases, saying: "No, we don't handle that, you need to handle it", falls on some pretty deaf ears. These cyber security teams live and breathe for the explicit life purpose of finding security holes, no matter how obscure and unlikely. Basic unquestioned attitude is "We find it, you fix it" period. So, the "answer" is to put a firewall of some sort in front of our web application, i.e. likely on the same machine as our web server application. We don't have the staff resources to invest in the time it might take to get up to speed to handle all of these security issues and implementing a solution using, e.g. NGINX or Apache, or other. So, we are looking for someone who is quite proficient at setting up a solution using the above (preferably NGINIX ?, if this will do the trick), to handle whatever a scan from Qualys can throw at it. If you are that person, or know someone who is, please contact me off-line. Much appreciated. Randy Engle, Director XC2 Software LLC – XC2LIVE! ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
RE: Unable to Unregister/Register Service
Add, Thanks for the info. Will try. Randy Engle, Director XC2 Software LLC – XC2LIVE! mailto: randy.en...@xc2software.com PH: 800.761.4999 – 415.456.9200 Internet – Hosted – In the Cloud: On-line Backflow Test Entry! XC2Live! - Backflow Program Management Operational Now! – Call for additional information: 800.761.4999 -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Add Komoncharoensiri via 4D_Tech Sent: Monday, November 20, 2017 10:36 AM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Add Komoncharoensiri <akomoncharoens...@4d.com> Subject: Re: Unable to Unregister/Register Service Randy, I have not tried it but I can only guess that the attempt was made while the Service was running. Try this, make sure the 4D Server is not running. Run 4D Server with the database manually and try to Unregister then. If you still have a problem then we are definitely dealing with something out of ordinary. Regards, Add On 11/20/17, 10:08 AM, "4D_Tech on behalf of Randy Engle via 4D_Tech" <4d_tech-boun...@lists.4d.com on behalf of 4d_tech@lists.4d.com> wrote: We have a customer that we are trying to update. They can run the server app as an admin, but “Register Current Database as a Service” is disabled. When we try to “Unregister Current Database” or “Unregister all Server Services”, the services list only show the service as “disabled”. I know I’ve seen this before, but don’t remember what we did. Any ideas? Thanks Randy Engle ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com ** ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com ** ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Unable to Unregister/Register Service
We have a customer that we are trying to update. They can run the server app as an admin, but “Register Current Database as a Service” is disabled. When we try to “Unregister Current Database” or “Unregister all Server Services”, the services list only show the service as “disabled”. I know I’ve seen this before, but don’t remember what we did. Any ideas? Thanks Randy Engle ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
RE: Need Plugin Replacement - Miyako's HTML Converter - Windows 10
Hi Miyako, Thanks again for providing the link to the new plugin. However, On startup, I receive an alert from "Windows Defender" "Windows Defender SmartScreen prevented an unrecognized app from starting Running this app might put your PC at risk" The "offending" app is wkhtmltox_4d.exe Is this app needed for anything specific? Or is it needed for all aspects of this plugin? Many thanks Randy Engle, Director XC2 Software LLC – XC2LIVE! ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
RE: Need Plugin Replacement - Miyako's HTML Converter - Windows 10
Miyako, Many, Many Thanks! I was hoping there was an updated version, but I just didn't seem to be able to find it. Thanks! Randy Engle, Director XC2 Software LLC – XC2LIVE! -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Keisuke Miyako via 4D_Tech Sent: Tuesday, October 24, 2017 12:52 PM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Keisuke Miyako <keisuke.miy...@4d.com> Subject: Re: Need Plugin Replacement - Miyako's HTML Converter - Windows 10 your mention of openssl made me suspicious, sounds like you are using a pretty old version of wkhtmltopdf https://github.com/miyako/4d-plugin-html-converter nowadays I prefer link ssleay (openssl) statically, as opposed to a dll. (there are still ways to figure out the version, but it sounds like the inspection is simply looking at the dll's file info) I don't know if the HD issue you report is because the old plugin is using MinGW runtime, not VC, but it is a free plugin based on a free library, I guess if you don't like it, you have to fix it yourself. > 2017/10/25 3:39、Randy Engle via 4D_Tech <4d_tech@lists.4d.com> のメール： > > We've been using Miyako's HTML Converter plugin for quite a while. > > We mostly use it to convert HTML to PDF docs > > Works great except: > > 1.Has an outdated version of OpenSSL (that US government agencies > don't like) > > 2.Plays havoc on Windows 10 displaying graphics/buttons/menus etc. > Requires setting compatibility settings in properties of 4D.exe: > > "Disable display scaling on high DPI settings" > > So what we are mainly looking for is the ability to Convert HTML files > to PDF (Can do this with one line using above plugin) > > The other stuff is good, but not currently using it. > > Miyako? Are you out there? > Any other ideas/solutions? > > Yes, I could write something else, but a quicky replacement would be just > great. ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com ** ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Need Plugin Replacement - Miyako's HTML Converter - Windows 10
We've been using Miyako's HTML Converter plugin for quite a while. We mostly use it to convert HTML to PDF docs Works great except: 1. Has an outdated version of OpenSSL (that US government agencies don't like) 2. Plays havoc on Windows 10 displaying graphics/buttons/menus etc. Requires setting compatibility settings in properties of 4D.exe: "Disable display scaling on high DPI settings" So what we are mainly looking for is the ability to Convert HTML files to PDF (Can do this with one line using above plugin) The other stuff is good, but not currently using it. Miyako? Are you out there? Any other ideas/solutions? Yes, I could write something else, but a quicky replacement would be just great. Many thanks Randy Engle, Director XC2 Software LLC – XC2LIVE! ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
RE: Connect to MS Sql database
You have two options that I know of. 1. ODBC 2. ADO plugin from Rob Laveaux/Pluggers You will, of course, need to write some SQL code and dump any data results into arrays. Randy Engle, Director XC2 Software LLC – XC2LIVE! -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of STARDATA via 4D_Tech Sent: Friday, October 13, 2017 3:29 AM To: 4d_tech@lists.4d.com Cc: STARDATA <stard...@stardata.info> Subject: Connect to MS Sql database Hi everyone, I'm looking for a way to connect 4d to sql server and query it as if it is a 4D database. Can anyone help me? -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com ** ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
RE: 4D Client as Web Server - How to monitor
Hi John, Thanks for info. Yes, something like this seems the best approach Randy Engle, Director XC2 Software LLC – XC2LIVE! -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of John Baughman via 4D_Tech Sent: Wednesday, October 4, 2017 3:28 PM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: John Baughman <john...@hawaii.rr.com> Subject: Re: 4D Client as Web Server - How to monitor At first I thought, hey an excellent place for Call Worker or Call Form. Then after thinking it though decided that would be more complicated then needed. If it were me, I would put an object field in a table, in my case my constants table, and pass the status in that field. Using this field there would be many options to monitoring the status of the web server from any 4D client or 4D server at any time. The field can be updated by the web server client when starting and shutting down itself and/or the web server, making it’s status known to all clients and 4D server in real time without any communications. If, as in your case, you need to periodically check to see if the Web Server is in fact still running or has crashed, you can use EXECUTE ON CLIENT… -- //Web ServerClient On Startup REGISTER CLIENT(“WebServerClient”) Start Web Server C_OBJECT($oWebServerStatus) OB SET($oWebServerStatus;”Status”;”Running”;……more info aa needed) READ WRITE([Constants]) ALL RECORDS([Constants]) //only 1 record in constants table [Constants]oWebServerStatus:= $oWebServerStatus SAVE RECORD([Constants]) UNLOAD RECORD([Constants]) READ ONLY([Constants]) //Client doing the checking READ WRITE([Constants]) ALL RECORDS([Constants]) //only 1 record in constants table OB SET([Constants]oWebServerStatus;”Status”;”Testing”) SAVE RECORD([Constants]) UNLOAD RECORD([Constants]) READ ONLY([Constants]) EXECUTE ON CLIENT(“WebServerClient”;”WebServerStatusMethod”) ALL RECORDS([Constants]) //only 1 record in constants table While (OB GET([Constants]oWebServerStatus;”Status”)=“Testing”) Pause process …. ?maybe not needed? All records([Constants]) //only one record in the constants table. Need this to reflect any changes made by the WebServer Client End While If (OB GET([Constants]oWebServerStatus;”Status”)=“Running”) //Do whatever if running Else //Do whatever if not running End If //Web ServerClient WebServerStatusMethod ALL RECORDS([Constants]) //only 1 record in constants table Case of :(OB GET([Constants]oWebServerStatus;”Status”)=“Testing”) C_OBJECT($oWebServerStatus) Test web server If (web server is running) OB SET($oWebServerStatus;”Status”;”Running”;……more info aa needed) else OB SET($oWebServerStatus;”Status”;”Not Running”;……more info aa needed) End If READ WRITE([Constants]) ALL RECORDS([Constants]) //only 1 record in constants table [Constants]oWebServerStatus:= $oWebServerStatus SAVE RECORD([Constants]) UNLOAD RECORD([Constants]) READ ONLY([Constants] End Case ——— John > On Oct 4, 2017, at 8:41 AM, Randy Engle via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Those of you who have 4D Client acting as web server: > > I've got 4D client working great as a web server. > > Now I like to "know" that the web server is running from another client. > > I'd love to have the same functionality as the Execute on Server attribute > But for a specific client > Not available, that I know of > > I've got a few options that I can think of: > > I'm not enthused about any of them > I'd like to think there's a much easier way. > Hopefully I'm just being dense. > > 1.Get the "Registered Name" of the Web server client > Send an EXECUTE ON CLIENT asking Web client if server is running > Send back an EXECUTE ON CLIENT to the "calling" Client with the results > (would require a "Delay" until received info) > > 2.Get the "Registered Name" of the Web server client > Send an EXECUTE ON CLIENT asking Web client if server is running > Have the client send an object with the web server info using SET > PROCESS VARIABLE to the Server > (or EXECUTE ON SERVER) > Have the original calling client GET PROCESS VARIABLE from server
