RE: v13 - how to get directory path on server from client
Chip,
The parameter 3 is for the "4D Client database folder"
For which doesn't exist on 4D Server
That said, using a method whose attribute is Execute On Server, works great for
something like this.
$folder:=EOS_Get_4D_Folder (Active 4D Folder)
*
// EOS_Get_4D_Folder
C_LONGINT($1)
C_TEXT($0)
$0:=Get 4D folder($1)
*
Or use something fancy like Kirk's soloution.
;-)
Randy Engle
XC2 Software LLC
-Original Message-
From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Chip Scheide
Sent: Wednesday, August 17, 2016 12:52 PM
To: 4D iNug Technical <4d_tech@lists.4d.com>
Subject: v13 - how to get directory path on server from client
I tried:
method1
<>Directory_path:=get 4d folder(3)
method2
execute on server("method1";12345)
get process variable(<> Directory_path;$Server_path)
but the variable $Server_path is blank.
Thanks
Chip
**
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: v15.3 and Windows 2016 Server
Hi Miyako, Thanks for the info. My client is asking if our system will run on 2016 Server It sounds like, "very likely" in compatible mode. And yes, of course we will upgrade to 15.4 as soon as available. Meanwhile I'll tell my client, er... uhhh... OK. ;-) Randy Engle XC2 Software LLC -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Keisuke Miyako Sent: Wednesday, February 08, 2017 3:22 PM To: 4D iNug Technical <4d_tech@lists.4d.com> Subject: Re: v15.3 and Windows 2016 Server Windows Server 2016 became generally available on October 12, 2016. https://en.wikipedia.org/wiki/Windows_Server_2016 4D v15.3 was released on November 17, 2016 but certification includes running the software for at least 21 days in production, after passing all the automated unit tests and manual tests, so v15.3 simply could not have been certified for WS2016 because of the timing. v15.3 is "compatible", that is, it should work, but 4D has higher standard for "certified", so I would recommend making plans to upgrade to v15.4 as soon as it becomes available. ** 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: v15.3 and Windows 2016 Server
Zach, Many, many thanks! Randy Engle XC2 Software LLC -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Zach Vogt Sent: Wednesday, February 08, 2017 5:48 PM To: 4d_tech@lists.4d.com Subject: RE: v15.3 and Windows 2016 Server Hi Randy, We're running v15.3 on Windows Server 2016 in a development environment for a couple months now and have had no issues to speak of. So far it has been smooth sailing and bug free for our purposes. Thanks, Zach Vogt ** 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: v15.3 and Windows 2016 Server
Hi Tim, Yes, I saw the post about this. Very timely! Tandy Randy Engle XC2 Software LLC -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Timothy Penner Sent: Thursday, February 09, 2017 9:14 AM To: 4D iNug Technical <4d_tech@lists.4d.com> Subject: RE: v15.3 and Windows 2016 Server Randy. Get 15.4 today: http://blog.4d.com/4d-v15-4-macos-10-12-sierra-and-windows-server-2016-certified/ -Tim ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com ** ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
RE: Get FileFrom Pasteboard - On Drop Database Method Only?
Miyako, Clearly, I was being a bozo. Below solution works just fine. =*-) Randy Engle XC2 Software LLC -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Keisuke Miyako Sent: Sunday, August 21, 2016 4:39 PM To: 4D iNug Technical <4d_tech@lists.4d.com> Subject: Re: Get FileFrom Pasteboard - On Drop Database Method Only? you need to have an object that can process the "On Drop" form event, perhaps an invisible button, to catch a drop onto a form. to handle multiple files/folders, keep incrementing the index to you pass to "Get file from pasteboard" until you get an empty string. > 2016/08/22 8:29、Randy Engle <4d.l...@xc2.us> のメール： > > I want to be able to drag a picture file from a desktop folder, and know the > name of the file that I dropped. > (or better, multiple file names) > I really need to have my users drop this somewhere on a form. ** 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: Things I wish I'd known when I started programming
Kirk, Great reminders! Always good to use "Beginner's Mind" ;-) Randy Engle XC2 Software LLC * ** 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: Sending data between 4D servers
Guy, Yes, it's old fashioned, but I'm a big fan of using SOAP. Works great across a WAN. Very reliable. Of course the receiving DB needs to be open to Web services. Pack the field into a BLOB or JSON object and send 'em! Unpack on the other side. Randy Engle XC2 Software LLC -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Guy Algot Sent: Wednesday, September 07, 2016 11:30 PM To: 4D iNug Technical <4d_tech@lists.4d.com> Subject: Sending data between 4D servers Given v15s current tickle trunk of features, what would be a good way to send data between servers across the WAN? In the past, I’ve done it by bundling up the data in a BLOB and dropping it on a secure FTP site. Any better, faster, stronger methods one prefers? Thanks. Later, Guy -- Guy Algot, Solutions Specialist Edmonton, Alberta (780) 974-8538 hardware, installation, training, support, programming, internet specializing in 4th Dimension =-= =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= "Microsoft is a cross between the Borg and the Ferengi. Unfortunately, they use Borg to do their marketing and Ferengi to do their programming." -- Simon Slavin ** 4D Internet Users Group (4D iNUG) 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: Windows 10: Plugin Error, unless Run as Administrator
Randy, Thanks. This is what I expected. Will try it out. (will need customer's IT to do this, no doubt) Randy Engle XC2 Software LLC -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Randy Jaynes Sent: Thursday, October 06, 2016 10:09 AM To: 4D iNug Technical <4d_tech@lists.4d.com> Subject: Re: Windows 10: Plugin Error, unless Run as Administrator I would check the permissions on the actual demo folder. Despite the logged in user having full Admin privileges, the security permissions on the folder itself may be “off” and need to be specifically set to FULL CONTROL for all the users. I’ve had this happen when copying a folder from 1 Windows machine to another and have to reset permissions for the folder on the new computer’s copy. Randy -- Randy Jaynes Senior Programmer and Customer Support http://printpoint.com • (845) 359-0298 • PrintPoint, Inc • 57 Ludlow Lane • Palisades, NY 10964 > On Oct 6, 2016, at 12:33 PM, Randy Engle <4d.l...@xc2.us> wrote: > > Chuck, > > Thanks for the note. > > Demo folder is at the root of C > > e.g. > > C:\Demo_Folder > > Randy Engle > XC2 Software LLC > > > -Original Message- > From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of > Charles Miller > Sent: Thursday, October 06, 2016 9:26 AM > To: 4D iNug Technical <4d_tech@lists.4d.com> > Subject: Re: Windows 10: Plugin Error, unless Run as Administrator > > On Thu, Oct 6, 2016 at 11:24 AM, Randy Engle <4d.l...@xc2.us> wrote: > >> To any Windows 10 aficionados. >> >> We have a potential customer that we sent a demo to. >> >> When they try to run it, they get a plug-in license error. >> >> However, if they "Run as Administrator" they don't get this error. >> >> Clearly this is some kind of permissions issue. >> Though, the user says: "I have access to everything"... >> Anyone seen this, and better yet, know what the configuration is on >> windows (10) that would cause this and what to do about it? >> >> This is 4D 15.2, Compiled/Runtime >> >> Many thanks, >> >> Randy Engle >> XC2 Software LLC >> > > Make sure demo is not placed in applications folder. Like on Macs and Apple > Microsoft is bettering down the hatches. > > Regards > > Chuck > > > ** > 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 **
Windows 10: Plugin Error, unless Run as Administrator
To any Windows 10 aficionados. We have a potential customer that we sent a demo to. When they try to run it, they get a plug-in license error. However, if they "Run as Administrator" they don't get this error. Clearly this is some kind of permissions issue. Though, the user says: "I have access to everything"... Anyone seen this, and better yet, know what the configuration is on windows (10) that would cause this and what to do about it? This is 4D 15.2, Compiled/Runtime Many thanks, Randy Engle XC2 Software LLC ** 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: Windows 10: Plugin Error, unless Run as Administrator
Chuck, Thanks for the note. Demo folder is at the root of C e.g. C:\Demo_Folder Randy Engle XC2 Software LLC -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Charles Miller Sent: Thursday, October 06, 2016 9:26 AM To: 4D iNug Technical <4d_tech@lists.4d.com> Subject: Re: Windows 10: Plugin Error, unless Run as Administrator On Thu, Oct 6, 2016 at 11:24 AM, Randy Engle <4d.l...@xc2.us> wrote: > To any Windows 10 aficionados. > > We have a potential customer that we sent a demo to. > > When they try to run it, they get a plug-in license error. > > However, if they "Run as Administrator" they don't get this error. > > Clearly this is some kind of permissions issue. > Though, the user says: "I have access to everything"... > Anyone seen this, and better yet, know what the configuration is on > windows (10) that would cause this and what to do about it? > > This is 4D 15.2, Compiled/Runtime > > Many thanks, > > Randy Engle > XC2 Software LLC > Make sure demo is not placed in applications folder. Like on Macs and Apple Microsoft is bettering down the hatches. Regards Chuck ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
RE: v13 moving to v15
Chip, Among others, these are obsolete Need to be replaced C_String C_Integer Array String Array Integer Font Number Enable Button Disable Button GRAPH TABLE Randy Engle XC2 Software LLC -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Chip Scheide Sent: Wednesday, August 24, 2016 1:57 PM To: 4D iNug Technical <4d_tech@lists.4d.com> Subject: v13 moving to v15 any functionality issues? anything (other then UUID/PKs) that would require work to get a functioning v13 system working on v15? no plugins Thanks ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com ** ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
RE: v13 - C/S getting web server started
Chip, Is it possible that something else is running that is using Port 80? Randy Engle XC2 Software LLC -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Chip Scheide Sent: Wednesday, October 12, 2016 1:38 PM To: 4D iNug Technical <4d_tech@lists.4d.com> Subject: v13 - C/S getting web server started I can not get the web server started. I have the database setting "start web server on startup" turned on. http server - stopped I have created a method with the command Web Start Server, and run it via Execute on server http server - stopped How do I get the web server to start? Thanks Chip ** 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: How to determine if a SET exists?
Kirk,
It's not 100% what you are looking for, but I'm pretty sure you can do a
"Records in Set"
$0:=Records in Set("MySet")
If the set does not exist, it will return 0.
Of course this is also true if the set exists with zero records in it. ;-)
Randy Engle
XC2 Software LLC
-Original Message-
From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Kirk Brooks
Sent: Tuesday, October 18, 2016 7:35 AM
To: 4D iNug Technical <4d_tech@lists.4d.com>
Subject: How to determine if a SET exists?
Hi all,
Is there a way to determine if a set exists? So far the only thing I've come up
with requires keeping track of them as they are created. This is OK but
unverifiable.
It would be nice to have the equivalent of the 'Is a list' function.
**
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: Miyako's Excel Component vs. Pluggers XL Plugin
Miyako's plug in is just great for simple projects. I highly recommend it! Rob Laveau's Plugin is when you need to get serious and take control of everything in the spreadsheet. Pluggers XL plugin is all I use now. ;-) Randy Engle XC2 Software LLC -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Keisuke Miyako Sent: Monday, October 24, 2016 6:20 PM To: 4D iNug Technical <4d_tech@lists.4d.com> Subject: Re: Miyako's Excel Component vs. Pluggers XL Plugin that is a ridiculous comparison. the plugin from Pluggers is far far superior. the component is just showcasing how 4D can run scripts and pass arguments via environment variables. that's all. in production, you shouldn't even be using the component methods procedurally, you should prepare your own script (hopefully the component can serve as a starting point) that does the job in one call. > 2016/10/25 4:22、David Rose <drose...@gmail.com> のメール： > Has anyone compared the performance of the component vs. the Pluggers plugin? ** 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 **
-50 Error
Some of our users are reporting receiving Error # -50. No other info I'm not finding this error code anywhere. Anybody know what this error is about? This happens on Client (Windows 4D v13.6) Randy Engle XC2 Software LLC ** 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: -50 Error
Hi Tim, Many thanks for the note. The problem is appearing on v13.6 We are trying to upgrade all of our customers to our current version (v15.2), it will just take some time. Thanks Randy Engle XC2 Software LLC -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Timothy Penner Sent: Tuesday, October 25, 2016 10:13 AM To: 4D iNug Technical <4d_tech@lists.4d.com> Subject: RE: -50 Error Hi Randy, There was a recent bug fix in v15.x for an issue that occurred at login and would produce error -50: Fixed bugs v15.2 build 204924(Released on 2016-10-13) ACI0095490 : 4D Clients tries to connect to 4D Server with a -50 Runtime Error. Hope that helps, -Tim ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com ** ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
RE: -50 Error
Tim, Good thinking on that one! Will give it a try! Randy Engle XC2 Software LLC -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Timothy Penner Sent: Tuesday, October 25, 2016 11:26 AM To: 4D iNug Technical <4d_tech@lists.4d.com> Subject: RE: -50 Error Hi Randy, If I remember correctly, the bug I referenced occurred both with Client-Server Encryption enabled as well as with it disabled, but the issue was much easier to reproduce with it enabled So if you are using Client-Server Encryption, maybe you can try disabling it to see if it reduces the frequency of the error. -Tim ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com ** ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Modify Style Sheets Programmatically?
I'm pretty sure this has been asked before, with a negative answer: I've looked again, but can't find anything, Any way to modify a style sheet programmatically, for form objects? (we can do this in 4D Write Style sheets) Thanks Randy Engle XC2 Software LLC ** 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: Query editor in v15 - Specified Module Not Found
Miyako, Many, many thanks for this! However, Upon starting my DB, I get: "The specified module could not be found" Got any ideas about this? Thanks Randy Engle XC2 Software LLC ** 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: Zipping a datafile - wow
Good Morning Kirk, Glad to see you're not slacking off. ;-) I typically see a zipped data file to be about 10% of the unzipped file (Assuming no pictures, etc) Randy Engle XC2 Software LLC -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Kirk Brooks Sent: Sunday, December 11, 2016 8:29 AM To: 4D iNug Technical <4d_tech@lists.4d.com> Subject: Zipping a datafile - wow I just had occasion to make a .zip of a v15 datafile. The database was stopped for some maintenance and I decided to grab a copy quick(ish)ly. The uncompressed, freshly compacted, datafile is 4.5 gigs. The .zip file is 375 mb. That's a hell of a compression ratio. Or looked at another way, 4D blocks off a hell of a sparse matrix for the datafile. It may have been like this for a long time and I just noticed but that's really surprising. The datafile doesn't contain much in the way of graphics which don't compress - just lots of numbers and strings. The 4D backup of the same file is a little over 1 gig. I zipped it and got a 747 mb file - about twice as large as the first .zip file. -- Kirk Brooks San Francisco, CA === ** 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: SETS from Server to Client
Much better than "way cool" Reduced the size of the blob I was getting from server by 90%! (4121 octets to 409) !!! Thanks! Randy Engle XC2 Software LLC -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Keisuke Miyako Sent: Monday, January 09, 2017 4:38 PM To: 4D iNug Technical <4d_tech@lists.4d.com> Subject: Re: SETS from Server to Client we recommend you review the scope of sets. "Visibility of Sets" http://doc.4d.com/4Dv16/4D/16/Sets.300-3037049.en.html you should notice that in most cases you shouldn't have to explicitly transfer sets over the network, as long as you pick the right scope. but if you must, take a look at commands like CREATE SET FROM ARRAY http://doc.4d.com/4Dv16/4D/16/CREATE-SET-FROM-ARRAY.301-3037050.en.html BOOLEAN ARRAY FROM SET http://doc.4d.com/4Dv16/4D/16/BOOLEAN-ARRAY-FROM-SET.301-3036782.en.html VARIABLE TO BLOB http://doc.4d.com/4Dv16/4D/16/VARIABLE-TO-BLOB.301-3036353.en.html BLOB TO VARIABLE http://doc.4d.com/4Dv16/4D/16/BLOB-TO-VARIABLE.301-3036360.en.html > 2017/01/10 9:31、Randy Engle <4d.l...@xc2.us> のメール： > > Any ideas for something easier. > No doubt it's really simple... I've just forgotten how. ** 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 **
SETS from Server to Client
I must be having a brain meltdown, or maybe not...
I have a "SET" on the server
I want to use that SET on the client
There's gotta be an easier way:
(Ultra pseudocode below)
On Server
1. Set is created on the server
2. SAVE SET ("SETNAME";"DOCNAME")
3. DOCUMENT TO BLOB("DOCNAME";LeBlob)
On Client
4. Client gets the blob from the server
(small handful of ways to do this, e.g. GET PROCESS VARIABLE, and some
other methods...)
5. BLOB TO DOCUMENT("DOCNAME"; LeBlob)
6. LOAD SET([Table];"SETNAME";"DOCNAME")
Seems like a lot of work, just to get a SET
Any ideas for something easier.
No doubt it's really simple... I've just forgotten how.
i.e. how to pass the blob with the set, without having to SAVE/LOAD document...
or maybe not...
Thanks!
Randy Engle
XC2 Software LLC
**
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: EXECUTE ON SERVER Attribute - Is there similar for single-user?
Kirk, Spoken like a true artist! Yep... that's what I figured. Thanks! ;-) Randy Engle XC2 Software LLC -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Kirk Brooks Sent: Sunday, December 04, 2016 10:21 AM To: 4D iNug Technical <4d_tech@lists.4d.com> Subject: Re: EXECUTE ON SERVER Attribute - Is there similar for single-user? Hey Randy, There's nothing directly equivalent because EOS lets us use two different machines. In single user there's no other machine and no twined process to run something in synchronously. Launching a separate process locally, pausing the current process and so on is good enough in a lot of cases. If you're looking for a solution that lets you manage different selections of the same table it's probably the best. Other options require a bit of rethinking what the ultimate goal of the task is. If the process needs to update a given record but calculating that data requires changing the current selection or current record, which is where EOS is so cool, you can flip things around: collect the relevant data into a c-object then do the calculations (clobbering current record and related records and such), updating the c-obj, and when it's done reload the original record (reestablish any related records) and update it from the c-obj. This sort of thing is really fast in single user and avoids the complexity of managing multiple processes for what might be a pretty easy task. On Sun, Dec 4, 2016 at 9:11 AM, Randy Engle <4d.l...@xc2.us> wrote: > Maybe I'm just being a dope and this already exists. > > Any wise shoves in the right direction would be graciously appreciated > -- Kirk Brooks San Francisco, CA === ** 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: EXECUTE ON SERVER Attribute - Is there similar for single-user?
Tim, Thanks for the input. Appreciated! Randy Engle XC2 Software LLC -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Tim Nevels Sent: Sunday, December 04, 2016 4:19 PM To: 4d_tech@lists.4d.com Subject: RE: EXECUTE ON SERVER Attribute - Is there similar for single-user? On Dec 4, 2016, at 12:36 PM, Randy Engle wrote: > In some cases, I need to Query on the same table as the current record to > find something. > Don't want to change the current record, or current selection.. Based on what you have described, I’d just do a SQL query to get what I needed. It doesn’t change the current record or current selection. It is fast and easy. One of the primary reasons for using EOS is to eliminate network I/O. The server does all the work and can access data from the data cache. So in single user, in your situation where you want to wait for the operation to finish before moving on, you don’t need to start a new process. A lot of overhead with starting new process and interprocess communication. If all you need is to keep the current record and current selection in a table, then use Begin/End SQL in the method to get the job done. Quick and simple way to handle the situation. 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: EXECUTE ON SERVER Attribute - Is there similar for single-user?
Hi Neil, Thanks for the note. In some cases, I need to Query on the same table as the current record to find something. Don't want to change the current record, or current selection.. ;-) Randy Engle XC2 Software LLC -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Neil Dennis Sent: Sunday, December 04, 2016 10:17 AM To: 4D iNug Technical <4d_tech@lists.4d.com> Subject: Re: EXECUTE ON SERVER Attribute - Is there similar for single-user? > Any wise shoves in the right direction would be graciously appreciated If you need to wait for the other process to finish why not stick the code in the same process? Once case I can see is that I use a similar technique for modifying records outside of a transaction when the method is inside of a transaction. However I use process variables and the SET PROCESS VARIABLE command instead of using process state. // Calling process fDone:=false $l:=new process(“DoSomethingCool”;0;”SomethingCool”;current process) Repeat delay process (current process;5) until (fDone) //Something Cool Process ... Do something cool … then SET PROCESS VARIABLE ($1;fDone;True) // $1 = calling process number, set the fDone in that process to true Delay process($1;0) // Un-delay the calling process However with the new SUSPEND TRANSACTION command http://docs.4d.com/4Dv15R5/4D/15-R5/SUSPEND-TRANSACTION.301-2937406.en.html <http://docs.4d.com/4Dv15R5/4D/15-R5/SUSPEND-TRANSACTION.301-2937406.en.html> (4D v15r4 and above) It will be much easier to do something like this SUSPEND TRANSACTION // Do something cool outside of transaction RESUME TRANSACTION -- Neil Dennis 4D Developer since 1990 GreaText - Designing Software for the Way You Work 716 East 1850 N North Ogden, UT 84414 mailto:npden...@greatext.com http://www.greatext.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: EXECUTE ON SERVER Attribute - Is there similar for single-user?
Kirk, Cool. Thanks, Randy Engle XC2 Software LLC -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Kirk Brooks Sent: Sunday, December 04, 2016 2:34 PM To: 4D iNug Technical <4d_tech@lists.4d.com> Subject: Re: EXECUTE ON SERVER Attribute - Is there similar for single-user? Neil's suggestions are really spot on. I was thinking about situations where you would be doing a lot of actual data manipulation. Otherwise there really is a remarkable amount you can accomplish without clobbering your current selection. I know a lot of guys are apprehensive about using SQL, 'cause a lot of us use 4D in the first place to avoid it. But it can be simple. Let's say I want to lookup a client email: // Client_get_email(id)->email $clientId:=$1 $email:="" Begin SQL SELECT emailField FROM CLIENTS WHERE Id = :$clientId INTO :$email; End SQL $0:=$email Find in field is also really useful and doesn't change the selection or current record. On Sun, Dec 4, 2016 at 1:04 PM, Randy Engle <4d.l...@xc2.us> wrote: > > In some cases, I need to Query on the same table as the current > > record > to find something. > > Don't want to change the current record, or current selection.. > > Some of these cases can use set query destination, if you only need a > record count or a set of records or SQL if you need values, or cut > named selection use named selection (very fast) to restore a > selection. I have used all three. There are very few places anymore > that I really need the overhead of spawning a new process and trying > to time them together. In fact, I can’t think a a single reason to do > so once you are using 4D v15r4 or above. > -- Kirk Brooks San Francisco, CA === ** 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: EXECUTE ON SERVER Attribute - Is there similar for single-user?
Cannon, Many thanks for sending this. Randy Engle XC2 Software LLC -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Cannon Smith Sent: Monday, December 05, 2016 6:08 AM To: 4D iNUG Technical <4d_tech@lists.4d.com> Subject: Re: EXECUTE ON SERVER Attribute - Is there similar for single-user? Hi Randy, I created a feature request for this after talking to Jerome at a Summit a few years ago. I always forget how to get a public facing link from the forums, but hopefully one of these two will work for you: <http://forums.4d.fr/Post/EN/6721490/1/6721491#6721491> <http://forums.4d.fr/Post/EN/6721490/0/0/> -- Cannon Smith Synergy Farm Solutions Inc. Hill Spring, AB Canada 403-626-3236 <can...@synergyfarmsolutions.com> > On Dec 4, 2016, at 10:11 AM, Randy Engle <4d.l...@xc2.us> wrote: > > The EOS method attribute is a wonderful thing! > > However, for single user systems, I would like to see similar behavior ** 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 **
4DWritePro - Tab Positions - Set Programmatically
I'm just now getting my toes wet in 4DWritePro. Currently using 4D 15.3 (Windows) But have looked at the demos in the v15 "r" releases. I see a lot of promise for this new 4DWrite, (despite the current user interface to be unusable by our customers) So, I'm seeing what I can do with this programmatically. The one item I'm stumped with is being able to set multiple "Tab" positions on the document The purpose is to get a row/column type result, with multiple columns, all lining up nice and neatly. With the columns set where I want them to be. ;-) I know doubt need to think of this an entirely new way, but that is eluding me at the moment) Any shoves in the right direction would be graciously appreciated. Randy Engle XC2 Software LLC ** 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: Question about storing data outside of datafile
Hi Chuck, Yes, we let 4D decide where to place the files. Yes, we include this folder in the backup. The detriment came if we need to do a manual copy of the folder holding the blobs. Mucho Tiempo! Randy Engle XC2 Software LLC Did you let 4D decide where to place these files or did you control them. Could you not in either case add a folder for 4D to include in backups. I have one customer where there are more than 500,000 pictures and drawings stored in data file. It would be great to store them outside, but for security reasons (outside access) and moving files between different locations make this impossible Right now we have two copies of data file running on two different servers and data gets moved between when changes are made. We also have another 5 servers as well as many single user versions. Regards Chuck -- - Chuck Miller Voice: (617) 739-0306 Fax: (617) 232-1064 Informed Solutions, Inc. Brookline, MA 02446 USA Registered 4D Developer Providers of 4D, Sybase & SQL Sever connectivity http://www.informed-solutions.com - This message and any attached documents contain information which may be confidential, subject to privilege or exempt from disclosure under applicable law. These materials are intended only for the use of the intended recipient. If you are not the intended recipient of this transmission, you are hereby notified that any distribution, disclosure, printing, copying, storage, modification or the taking of any action in reliance upon this transmission is strictly prohibited. Delivery of this message to any person other than the intended recipient shall not compromise or waive such confidentiality, privilege or exemption from disclosure as to this communication. ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com ** ** 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: Question about storing data outside of datafile
Hi Kirk, My understanding is that the external data will not be loaded, until it is "needed", e.g. Record is loaded (e.g input form) or programmatically loaded. However, we found that storing blobs in external file had detrimental effects in certain cases. If you've got 1000s and 1000s of blobs, these are all stored as individual files on disk. When copying these files (e.g. doing a manual backup), it takes vastly longer than if the blobs are stored in the data file. We put everything back into the data file. Copying the files was a nightmare. FYI This is on Windows Might work differently on Mac Also, we previously stored all BLOBs in a separate related table, so we were sure they weren't loaded until specifically requested programmatically. However, this was quite awhile back, but we just never changed it. Randy Engle XC2 Software LLC I haven't used the 'store outside of datafile' option (text, object, picture fields) very often. I'm wondering about how 4D manages loading the records across the network. I know that if I query a table from a client and then load or display the selection of records the record data gets pulled down from the server to the client. Thus it's generally faster to use EOS to do the searching on the server and only have to load the specific records required. I'm wondering if 4D is optimized to not download the externally stored data unless it's required? ** 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: ALP Formatting at cell level
Hi Phil, I seem to recall that ALP 10 requires 4D v16. Is this the case? Thanks Randy Engle XC2 Software LLC ** 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: Entry Field questions
Piotr, I don't know if it's the "Easy" way, but I use On Getting/On Losing Focus to change backgrounds, etc during data entry. e.g. Pseudo Code Case of : (Form event=On Getting Focus) $foregroundColor:=00x00FF // Blue $backgroundColor:=00x0000` Yellow OBJECT SET RGB COLORS($object_Ptr->;$foregroundColor;$backgroundColor) : (Form event=On Losing Focus) $foregroundColor:=00x` Black $backgroundColor:=00x00FF` White OBJECT SET RGB COLORS($object_Ptr->;$foregroundColor;$backgroundColor) End case Randy Engle XC2 Software LLC -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Piotr Chabot Stadhouders via 4D_Tech Sent: Tuesday, March 21, 2017 11:26 AM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Piotr Chabot Stadhouders <p.stadhoud...@timeff.com> Subject: Entry Field questions Hi, I have 2 questions about entry fields : 1. Although I know the best answer on forehand (Use system behavior), is there an (easy) way to customize entry fields (fields and variables). For example rounded borders, yellow background when having focus instead of blue border? 2. What is the best way to prevent users to copy / paste values with crlf in it? Thanks in advance, Piotr ** 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 **
DDOS Attack simulator
A customer has "requested" us to do our own security scan of our web application. (Using 4D Web Server v15.4/Windows... currently) I'm a raw newbie at this stuff, so please be gentle. ;-) They apparently did a security scan and said that our site "breaks" after 11 minutes. They aren't being very forthcoming with the results of that report except above. FYI, I'm dealing with the IT dept of a major city. They don't seem to be completely reasonable and have their "ways" of doing things Only that they think we should do our own scan so "solve" the problem. Subscribing to one of these security scanning services seems to be very expensive, and they do a LOT more than what we need. So What say y'all? 1. Do you know of a good security scanning service that doesn't empty your bank account 2. I downloaded and am trying out "LOIC" to emulate a DDOS attack Do you know of anything better? 3. To "remediate" the problem, I've made some changes in the Web Structure Settings a. set maximum concurrent web process to a much smaller number than 32000 (128/256/512/1024) (It looks like this might be the best thing to do) Number of hits per hour/minute/second should be minimal in a live situation I'm think max hits/minute at peak time might be 100-200 b. Turned off automatic session management Not sure if this will affect things positively or otherwise. 4. Any and all information regarding the above will be accepted with much gratitude! Many thanks, Randy Engle XC2 Software LLC ** 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: DDOS Attack simulator
Neil, I can probably operate on the basis that my customer will want to test this without a firewall... I just need to be prepared for everything. ;-O Randy Engle XC2 Software LLC > Any and all information regarding the above will be accepted with much > gratitude! I thought most firewall routers will stop a DDos attack before it hits your 4D server. Was this not the case for you or are you testing without a firewall? Neil ** 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: DDOS Attack simulator
So... back to my original question: Anybody know a security scanning service that doesn't break the bank? Or a tried and true simulator that I can use to test. I've been using "LOIC" (Low Orbit Ion Cannon) However, my app seems to handle this no problem. Been running from 2 different systems for an hour. Lobweb.txt file is growing... status of all calls are "200" I need to know how to "break" it, so I can prevent it. Any more input on this? Thanks Randy Engle XC2 Software LLC ** 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: DDOS Attack simulator
Hi Tim, RE: Didn’t v15R5 also cure the crashing during those scans?" Thanks for chiming in. I'm not finding any reference to crashing during scans in the v15R5 release notes/bug fixes. Did I miss something? Randy Engle XC2 Software LLC ** 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 v15r5 vs 16
OK... so I'm a little dense with understanding the "R" releases yet. Does v16 have goodies that 15 R5 doesn't? - vice versa Is v16 ready for prime time? v15 R5 ready for prime time? Randy Engle XC2 Software LLC ** 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 v15r5 vs 16
Yes, thanks, I'll need to read this ... "again" 3rd time's a charm. ;-) Randy Engle XC2 Software LLC -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Timothy Penner via 4D_Tech Sent: Friday, March 24, 2017 10:25 AM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Timothy Penner <tpen...@4d.com> Subject: RE: 4D v15r5 vs 16 The following post from Thomas Maul describes the process for the R releases and why the bug fixes from .x may not be in the R release (sometimes the R release can be up to 3 months behind the .x release in terms of bug fixes): http://forums.4d.fr/Post/EN/19187580/2/19195248#19195248 I encourage everyone to read that post above. -Tim ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com ** ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
RE: DDOS Attack simulator
Tim, Most appreciated! Randy Engle XC2 Software LLC -Original Message- From: Timothy Penner [mailto:tpen...@4d.com] Sent: Friday, March 24, 2017 11:03 AM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Randy Engle <4d.l...@xc2.us> Subject: RE: DDOS Attack simulator > Anybody know a security scanning service that doesn't break the bank? Nessus used to have a community edition that was able to get gotten and used for free in non-commercial environments... it looks like they renamed this option to "Nessus Home" https://www.tenable.com/products/nessus/nessus-plugins/obtain-an-activation-code Here is a large list of vulnerability scanners online: http://sectools.org/tag/vuln-scanners/ -Tim Timothy Penner Technical Services Engineer 4D Inc 95 S. Market Street, Suite #240 CA 95113 San Jose United States Telephone : +1-408-557-4600 Standard : +1-408-557-4600 Fax : +1-408-271-5080 Email : tpen...@4d.com Web : www.4D.com ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
RE: 4D v15r5 vs 16
Scott, Thanks for the info. I'm using 15.4 currently. Seems I had some prob. With 15 r5 also. Just don't remember what it was. Randy Engle XC2 Software LLC -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Scott Staley via 4D_Tech Sent: Friday, March 24, 2017 10:23 AM To: 4d_tech@lists.4d.com Cc: Scott Staley <isbo...@gmail.com> Subject: Re: 4D v15r5 vs 16 Randy, I've had several issues with both 15 R5 and v16 (I don't have access to 16 HF2) and am therefore currently using v15r4 (which is certified for most systems). I don't remember all the issues but I know I had several problems with menu management. ** 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: DDOS Attack simulator - Some Results
Got some "movement" on this, though not a complete solution. Using a DDOS Simulator (LOIC) Using 4D v15.4 (Windows) 4D Server crashed, actually the entire machine froze completely after 8-10 minutes While it was running, 4D was running at about 90%+ of memory, until kaboom. Needed to physically turn off machine No mouse, no keyboard, nada. Ooooh very bad! Changed to 15r5 4D ran at about 50% Didn't crash after 20 minutes (about 1,000,000 hits) Quickly went back to normal in a few seconds after stopping flooding. But I'd like to keep this from happening at all. Yes, we could put a proxy/firewall in the way. But I need to make the Cybersecurity guys feel all warm and fuzzy about our product. Any ideas what could be done in 4D alone. Steve O's idea of stopping the web server was good, except that I'm not seeing these attacks go through ON WEB CONNECTION, so there's nothing to trap for. 4D does put them in the logweb.txt file though. I appreciate all of your previous and future input. Randy Engle XC2 Software LLC ** 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: DDOS Attack simulator - Some Results
Tim, Very helpful. Many thanks! Randy Engle XC2 Software LLC -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Timothy Penner via 4D_Tech Sent: Friday, March 24, 2017 7:46 PM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Timothy Penner <tpen...@4d.com> Subject: Re: DDOS Attack simulator - Some Results I think for something like LOIC (or any DDOS) you will need to implement some sort of firewall protection. It is very likely the actual request being sent to the web server is malformed, which could explain why you are getting 5xx errors in the weblog. From what i see online the best way to mitigate a Low Orbit Ion Cannon DDOS attack is with a firewall that is programmed to detect it: See more here: https://www.trustwave.com/Resources/SpiderLabs-Blog/LOIC-DDoS-Analysis-and-Detection/ -Tim ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com ** ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
4D Server - Not letting go of users
If a client/user does a force quit (i.e. Task Manager), Their user account on 4D Server persists, and takes up a license. I used to think that these would fall off in a short amount of time, but I found some that were 2-3 days old. Of course, if server is restarted, all is fine. This is Windows Server 2012 4D Server 15.3 (Maybe 15.4 fixes this, I haven't checked.) Anybody else experience this? Thanks Randy Engle XC2 Software LLC ** 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 Server - Not letting go of users
Hi Lahav, Thanks for the note. I'm pretty sure we are using the legacy network layer But I'll check. Thanks Randy Engle XC2 Software LLC -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of lists via 4D_Tech Sent: Thursday, March 16, 2017 12:30 PM To: Randy Engle via 4D_Tech <4d_tech@lists.4d.com> Cc: lists <li...@xsitra.com> Subject: RE: 4D Server - Not letting go of users Hi Randy, I see this quite a bit, and it has something to do with the new network layer. I have reported it to tech support, but never really saw the issues resolved. The problem goes away if I use the legacy network layer. Cheers, Lahav ** 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 Server - Not letting go of users
Bob, Yes! This is what I'm referring to. How come, why for? What can we do? Anybody got an idea? Thanks Randy Engle XC2 Software LLC -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of bob.miller--- via 4D_Tech Sent: Thursday, March 16, 2017 12:05 PM To: 4d_tech@lists.4d.com Cc: bob.mil...@parker.com Subject: Re: 4D Server - Not letting go of users RE> If a client/user does a force quit (i.e. Task Manager) Just yesterday I had a problem where we had some 'license count exceeded' messages - very rare - and I noticed that we had people who were logged in for days. Some had force-quit and others had simply closed their remote desktop sessions, but 4D Server never released them. This is with Windows v15r4. Bob Miller Chomerics, a division of Parker Hannifin Corporation ** 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: Larry Sharpe
Lee, Thanks for passing this along. He will be missed. I'm very glad that I got the opportunity to work with him on some projects and get to know him. Randy Engle XC2 Software LLC -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Lee Hinde via 4D_Tech Sent: Wednesday, March 15, 2017 2:17 PM To: 4D iNug Tech <4d_tech@lists.4d.com> Cc: Lee Hinde <leehi...@gmail.com> Subject: Larry Sharpe Larry passed away last week.. Obit here: http://www.mtdemocrat.com/obituaries/larry-sharpe/ <http://www.mtdemocrat.com/obituaries/larry-sharpe/> ** 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 SQL Implementation
Hi Tim, Thanks for the reminder about Bobby Tables. This reminds me of a still existing issue, when accessing 4D via ODBC. I found that I can call a DROP TABLE from various ways with a SQL editor. I seem to be missing a way to keep them from successfully calling this command, except to not let them have ODBC access in the first place. We have our system set to not allow INSERTS and UPDATES, but DROP TABLE still works if they have ODBC access. Any hot tips to prevent this? I'm a SQL newbie, so maybe I'm missing something obvious. Thanks Randy Engle XC2 Software LLC -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Timothy Penner via 4D_Tech Sent: Monday, April 17, 2017 9:01 AM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Timothy Penner <tpen...@4d.com> Subject: RE: 4D SQL Implementation > Using strings built into queries is prone to sql injection if the query has > any input from the users and is considered a deadly sin in most cases. Here is a good example describing why you should never concatenate data into a SQL statement; you should always use parameterized queries instead. http://bobby-tables.com/ http://bobby-tables.com/about -Tim ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
RE: 4D 15.4 HF1 (windows) - crashes when run as service
Hi Tim, Thanks for the detailed info. Appreciated. Will try all of the above. The only plugins that were changed were 4D plugins (Write/Internet/ODBC/Pack) But I'll test everything. Randy Engle XC2 Software LLC -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Timothy Penner via 4D_Tech Sent: Tuesday, March 07, 2017 3:11 PM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Timothy Penner <tpen...@4d.com> Subject: RE: 4D 15.4 HF1 (windows) - crashes when run as service Hi Randy, > Anyone else notice this? Not me; I tested 4D Server 32/64 bits v15.4HF1 on Windows 10 using non-interactive service. I tested with a brand new blank database - does it crash for you with a brand new blank database? If it is only your database that is crashing on startup then I would suggest: 1) Isolate the plugin to narrow it down, make sure the crash doesn’t depend on a plugin: http://kb.4d.com/assetid=77256 2) If it is related to a plugin notify the plugin developer. 3) If it isn't related to a plugin then use 4D singleuser to enable the debug log in human readable (v13) format on the first line of On Server Startup and then launch it as a service and check the log after it crashes to see the last item it tried to execute. Open a case on TAOW (taow.4d.com) for further assistance. -Tim ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com ** ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
4D Client/Remote as Web Server
I know this topic has been addressed before, but I'd like to hear what y'all are doing about this. We need to provide a solution where the web server is in the DMZ and the database server is behind the firewall. We know 4D remote can be used for this... no problem there. But what about when the machine goes down and restarts? We know that are a few 3rd party solutions for setting up an application as a service, e.g. "AlwaysUp" Like to hear what other alternatives any of you have implemented to make sure 4DRemote as Web server is always operational. Many thanks! Randy Engle 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: Missing Pict - 64bit Removes pictures from library
FYI; Been messing with 64bit v16r4 Found that most (not all) of my PICTURE LIBRARY pictures went south. If I open the app in the 32 bit version, they are all still there. So... what Christian said below, is more than a "good idea" Not looking forward to redoing all of these pictures into the resources folder and then finding all references to them. Arrrgghhh! Randy Engle, Director XC2 Software LLC – XC2LIVE! mailto: randy.en...@xc2software.com PH: 800.761.4999 – 415.456.9200 -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Christian Sakowski Sent: Thursday, January 26, 2017 6:29 AM To: 4D iNug Technical <4d_tech@lists.4d.com> Subject: Re: Missing Pict > SET PICTURE TO LIBRARY($vpPict;$vPictRef;$vPictName) FYI: Never use the library anymore. It's obsolete since v11. You have to use the Resources-Folder. ** 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/Remote as Web Server
Hi Justin, Many thanks! Good innovative ideas! Randy Engle XC2 Software LLC – XC2LIVE! -Original Message- From: Justin Will [mailto:jw...@willwerks.com] Sent: Friday, August 11, 2017 7:43 PM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Randy Engle <4d.l...@xc2.us> Subject: RE: 4D Client/Remote as Web Server Randy, I have 4D Client running as a web server on windows. I have the client write a text file every 45 seconds or so to disk. I then have a batch script that runs every minute and looks for that file and deletes it. If the file is not found it kills the 4D task and restarts 4D Client. I also have software the monitors a page on the site and if the page is unavailable for more than a couple minutes starts sending emails and text messages etc so that someone can check it out. Thanks Justin Will ** 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 **
Get Info from a 4D Client - aka Interclient communication
Hey smart guys! Maybe I'm just being a dope, but I'm not coming up with an easy solution: I need to get some info from a specific 4D Client instance In this particular case, I've got the web server running on the client, and I want to know if the web server is in fact running. The best I've come up with is: EXECUTE ON CLIENT, and have the target client create a record in my [Intersystem_Message] Table with the info I need. Then wait a few ticks and query for that record and read the info. Or have the Target client do an EXECUTE ON CLIENT back to the calling client. Seems rather clunky. Would love to have a similar function as the "Execute on Server" attribute, only for a specific client. But that's probably too much to ask... I'm probably missing something ridiculously obvious. I'm sure at least some of you brilliant lads have come up with a cool solution for this. Love to hear about it. Thanks! Randy Engle XC2 Software LLC – XC2LIVE! PS: ANNOUNCEMENT!!! SUMMIT VINOFEST!!! I'm not one to wait until the last minute, so At next year's 4D Summit (April 2018) Yet one more time, there will be the Summit "Vinofest" I've booked a suite, so we won't be trying to cram in 20 people in a small hotel room. (And maybe we won't have security show up to kick everyone out!) To all of you who have shown up in the past, and all of you who would like to indulge this next time, you're invited! Will be on Monday April 2 (evening of the meet and greet event) Details to follow in the future. ** 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: Get Info from a 4D Client - aka Interclient communication
John, Thanks for the tip. Will consider! Randy Engle, Director XC2 Software LLC – XC2LIVE! Maybe just SET PROCESS VARIABLE(-1;<>webServerInfoObject) to put the information on the server. Then a process on the server can monitor it or you can use a different client to read it using GET PROCESS VARIABLE. John DeSoi, Ph.D. > On Aug 13, 2017, at 8:18 PM, Randy Engle via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I need to get some info from a specific 4D Client instance > > In this particular case, I've got the web server running on the client, and I > want to know if the web server is in fact running. > > The best I've come up with is: ** 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: Get Info from a 4D Client - aka Interclient communication
Hi Kirk,
Cool. Thanks.
This gave me some good ideas!
Randy Engle
XC2 Software LLC – XC2LIVE!
-Original Message-
From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Kirk Brooks
via 4D_Tech
Sent: Monday, August 14, 2017 8:24 AM
To: 4D iNug Technical <4d_tech@lists.4d.com>
Cc: Kirk Brooks <lists.k...@gmail.com>
Subject: Re: Get Info from a 4D Client - aka Interclient communication
Randy,
You could have a background process on 4D server that periodically pings the
web server. Or makes an http call to it. I use a service to monitor server
status that relies on this approach. This will also raise a flag if the server
is un-available for some reason even if it is running.
But if 4D server is walled off from the internet I'd use Execute on client and
Web is server running
<http://doc.4d.com/4Dv15/4D/15.4/WEB-Is-server-running.301-3275028.en.html>.
But that requires you to know which client is running it. Maybe there are more
than one? Using a table, like you're doing already, isn't such a terrible idea.
But you could also do the same thing with variables and avoid the SET VARIABLE
issues by using execute on server.
Let's say this loop is running in a background process on a client:
$webInfo:=JSON Parse("{}")
OB SET($webInfo;"machine";Current machine)
While(not($done))
OB SET($webInfo;"timestamp";Timestamp)
OB SET($webInfo;"running";WEB Is server running)
If(WEB Is server running)// optional info
... // IP, # processes, ...
End if
WEB_update_monitor($webInfo)
DELAY PROCESS(Current process;300)
End while
WEB_update_monitor executes on server :
// WEB_update_monitor
<>webInfo_obj:=$1
And on the server you have some monitor process running that looks at
<>webInfo_obj and acts accordingly.
If more than one client might be involved I'd use an object array but the
mechanics are the same.
On Sun, Aug 13, 2017 at 6:18 PM, Randy Engle via 4D_Tech <
4d_tech@lists.4d.com> wrote:
> In this particular case, I've got the web server running on the
> client, and I want to know if the web server is in fact running.
>
> --
Kirk Brooks
San Francisco, CA
===
*The only thing necessary for the triumph of evil is for good men to do
nothing.*
*- Edmund Burke*
**
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
**
User environment "List of Tables" Stuck - Arrrgghhh!!!
Just today in the last hour or two: When viewing user environment, display the "List of Tables" It appears in the middle of the screen, small squarish window. Can't move it, can't enlarge it. Cant' scroll through list. Can select displayed tables, nothing else "List of Tables" menu item has no effect. Also, property list for any form is in the same state. Exactly Same location as Table List window, can't move it, resize it. Happens with any 4D DB, Created a new one. Used another instance of 4D Restarted machine, threw out "window bounds" (This is v15r5 - Windows - been using this for a few months, no problem) Chanted Krishna, did the hokey-pokey, etc. Currently re-installing. WTF ??? Any ideas, voodoo? Thanks Randy Engle 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: User environment "List of Tables" Stuck - TeamViewer - Yech!
I seem to have found the culprit!: TeamViewer A client wanted me to use this to access his system remotely. I was previously considering buying TeamViewer for our support (over Webex). What a giant PITB! Randy Engle XC2 Software LLC – XC2LIVE! -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Randy Engle via 4D_Tech Sent: Thursday, July 13, 2017 7:58 PM To: '4D iNug Technical' <4d_tech@lists.4d.com> Cc: Randy Engle <4d.l...@xc2.us> Subject: User environment "List of Tables" Stuck - Arrrgghhh!!! Just today in the last hour or two: When viewing user environment, display the "List of Tables" It appears in the middle of the screen, small squarish window. Can't move it, can't enlarge it. Cant' scroll through list. Can select displayed tables, nothing else "List of Tables" menu item has no effect. Also, property list for any form is in the same state. Exactly Same location as Table List window, can't move it, resize it. Happens with any 4D DB, Created a new one. Used another instance of 4D Restarted machine, threw out "window bounds" (This is v15r5 - Windows - been using this for a few months, no problem) Chanted Krishna, did the hokey-pokey, etc. Currently re-installing. WTF ??? Any ideas, voodoo? Thanks Randy Engle 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 ** ** 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: R3 Windows 32bit server?
The question posed to me when I asked was: "Why do you want a 32bit server? 64bit is far superior" There's not many, but there's a few 32bit servers out there... Randy Engle 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: Saturday, July 8, 2017 6:05 PM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: John Baughman <john...@hawaii.rr.com> Subject: Re: R3 Windows 32bit server? Thanks Randy, Any idea why it is not included in the in the download from the download page at 4d.com <http://4d.com/>? Maybe an oversight? Thanks again, John > On Jul 8, 2017, at 10:14 AM, Randy Engle via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > John, > > http://download.4d.com/Products/Current/4D_16R3/installers/4D_Server_v16_R3_Windows_32-bit.exe > > > Randy Engle > 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: Saturday, July 8, 2017 12:42 PM > To: 4d_tech@lists.4d.com > Cc: John Baughman <john...@hawaii.rr.com> > Subject: R3 Windows 32bit server? > > When I download the 32bit full installer I am only getting 4D. Is there an R3 > 32bit server for windows? > ** > 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 ** ** 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: R3 Windows 32bit server?
John, http://download.4d.com/Products/Current/4D_16R3/installers/4D_Server_v16_R3_Windows_32-bit.exe Randy Engle 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: Saturday, July 8, 2017 12:42 PM To: 4d_tech@lists.4d.com Cc: John Baughman <john...@hawaii.rr.com> Subject: R3 Windows 32bit server? When I download the 32bit full installer I am only getting 4D. Is there an R3 32bit server for windows? ** 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 Database Server Hardware recommendation
Brad, We are recommending Dell XEON E5-26xx servers Powerful enough for most applications 16GB RAM SSD Drive is always great, especially PCIe. E.g. Samsung 960 Pro Randy Engle XC2 Software LLC – XC2LIVE! -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Perkins, Bradley D via 4D_Tech Sent: Wednesday, July 12, 2017 10:02 AM To: 4d_tech@lists.4d.com Cc: Perkins, Bradley D <bperk...@lanl.gov> Subject: 4D Database Server Hardware recommendation A customer needs to replace aging Windows server hardware. I haven't spec'd any Windows server hardware in a long time and am looking for recommendations. The primary use is to host 4D Server. This isn't a large database, but does need to run near 24/7/365. The are currently running 4D v15.* They'll want Dell. Server needs to be rack-mounted. Lower cost is fine. These are replacing R610 models bought in 2010. They'll also have to upgrade from Windows Server 2008 r3 to some version of Windows Server 2012. Are there any things I should be aware of related to that? What models are people using recently for 4D Server deployments? Thanks, Brad Perkins ** 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: User environment "List of Tables" Stuck - TeamViewer - Yech!
Tim, Cool. Thanks! Randy Engle, Director XC2 Software LLC – XC2LIVE! -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Timothy Penner via 4D_Tech Sent: Friday, July 14, 2017 1:38 PM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Timothy Penner <tpen...@4d.com> Subject: RE: User environment "List of Tables" Stuck - TeamViewer - Yech! I think disabling the "QuickConnect" option in TeamViewwer will correct the issue. Here is a document put out by Sage.com regarding their Timeslips application and this issue: https://support.na.sage.com/selfservice/viewContent.do?externalId=30978=1 -Tim ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com ** ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
RE: Experience with FTSY Sync Code//Speed up Sync Code
Douglas, Synching is a wonderful thing. Most users think it's a magic bullet. ;-) Yes, it does have some "considerations" Randy Engle XC2 Software LLC -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Douglas von Roeder via 4D_Tech Sent: Tuesday, April 25, 2017 10:01 AM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Douglas von Roeder <dvonroe...@gmail.com> Subject: Re: Experience with FTSY Sync Code//Speed up Sync Code Randy: Good summary. This code is slightly more efficient on the transfer because it packs multiple records into a given BLOB but after reading your posting, this issue could be compounded by lack of server processing power. "Just gotta make sure the client "syncs" often." At times, some users dump thousands of records so perhaps the server's getting overwhelmed. Given that the computing resources used by the server to *de*code all those BLOB's will be in the ballpark of the sum of the resources that all of the standalones used to *en*code all of that data, if the standalones don't "synch early, synch often", that's going to put a significant load on the server machine. The more complex the encode/decode, the worse things are for the server. And it the server's underpowered, large intermittent synch sessions will exacerbate the situation. Maybe one way to look at this is that this is an inverse "distributed processing" situation - a single server has to reverse all of the processing that's been done by N client workstations. -- Douglas von Roeder 949-336-2902 On Tue, Apr 25, 2017 at 8:40 AM, Randy Engle via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Hi Douglas, > > I've been using Web Services (SOAP) for quite some time with our > Synchronization module. > I only pack the fields that have changed (or all if new record) Send > an array of field numbers, and text array of string(values) Pack it > all into a blob. > Send 1 record per web service call. > Seems fast enough for our purposes. 5-10+ records per second, > depending upon record size and network. > Just gotta make sure the client "syncs" often. > > Randy Engle > XC2 Software LLC > > -Original Message- > From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of > Douglas von Roeder via 4D_Tech > Sent: Monday, April 24, 2017 6:26 PM > To: 4D iNug Technical <4d_tech@lists.4d.com> > Cc: Douglas von Roeder <dvonroe...@gmail.com> > Subject: Experience with FTSY Sync Code//Speed up Sync Code > > Anyone here have experience with Brad Weber's "FTSY Sync" code? > > The code in question was written almost 20 years ago to synchronize > records between standalones and a client server system, and I know > that is was used by a couple of companies inclduing Husqvarna in North > Carolina. > > One aspect of the code that's challenging is that the V11+ code (the "new" > code) could no longer use 4D Open so the design was changed to pack > field data into BLOB's. The BLOB's contain metadata for every field > including the field number, the field type, the data length, etc. > > When the synch records are unpacked, the metadata is used to move > sequentially through the BLOB, converting each byte range back to its > native 4D type using BLOB to text, BLOB to real, BLOB to longint, etc. > > My suspicion is that this method of encoding/decoding is contributing > to poor performance* for updating records and I'm hoping that someone > has resolved this issue. > > > > The underlying question is how much faster/slower would it be to > encode/decode data using an alternative method? > > A much more simple alternative is to use a "field ID" (String(Table > number;"000")+ the ID (a string)" as the tag/property name and use OB > Get/Set(property;data;field type) to deal with the data. > > This approach would eliminate a significant amount of code, no > question, but what would be the impact on performance? > > Comments, thoughts, and questions appreciated. > > > *this is a V13 system so I can't use Pause index > > > > ** > 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_tec
RE: Experience with FTSY Sync Code//Speed up Sync Code
Hi Douglas, I've been using Web Services (SOAP) for quite some time with our Synchronization module. I only pack the fields that have changed (or all if new record) Send an array of field numbers, and text array of string(values) Pack it all into a blob. Send 1 record per web service call. Seems fast enough for our purposes. 5-10+ records per second, depending upon record size and network. Just gotta make sure the client "syncs" often. Randy Engle XC2 Software LLC -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Douglas von Roeder via 4D_Tech Sent: Monday, April 24, 2017 6:26 PM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Douglas von Roeder <dvonroe...@gmail.com> Subject: Experience with FTSY Sync Code//Speed up Sync Code Anyone here have experience with Brad Weber's "FTSY Sync" code? The code in question was written almost 20 years ago to synchronize records between standalones and a client server system, and I know that is was used by a couple of companies inclduing Husqvarna in North Carolina. One aspect of the code that's challenging is that the V11+ code (the "new" code) could no longer use 4D Open so the design was changed to pack field data into BLOB's. The BLOB's contain metadata for every field including the field number, the field type, the data length, etc. When the synch records are unpacked, the metadata is used to move sequentially through the BLOB, converting each byte range back to its native 4D type using BLOB to text, BLOB to real, BLOB to longint, etc. My suspicion is that this method of encoding/decoding is contributing to poor performance* for updating records and I'm hoping that someone has resolved this issue. The underlying question is how much faster/slower would it be to encode/decode data using an alternative method? A much more simple alternative is to use a "field ID" (String(Table number;"000")+ the ID (a string)" as the tag/property name and use OB Get/Set(property;data;field type) to deal with the data. This approach would eliminate a significant amount of code, no question, but what would be the impact on performance? Comments, thoughts, and questions appreciated. *this is a V13 system so I can't use Pause index ** 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: Missing Pict - 64bit Removes pictures from library
Frijoles Frio! Thanks Randy Engle, Director XC2 Software LLC – XC2LIVE! mailto: randy.en...@xc2software.com PH: 800.761.4999 – 415.456.9200 -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Keith Culotta via 4D_Tech Sent: Wednesday, August 9, 2017 12:35 PM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Keith Culotta <k...@compdim.com> Subject: Re: Missing Pict - 64bit Removes pictures from library This was a big help with the Picture Library. Run it from a version of 4D that still supports the old format. http://kb.4d.com/assetid=76775 <http://kb.4d.com/assetid=76775> Keith - CDI ** 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: Missing Pict - 64bit Removes pictures from library
I really appreciate how so many of you chimed in so quickly on this topic! Many, many thanks to all! 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: Unable to Compile - Crash - looking for ideas - SOLVED
Thanks to Miyako and Jeff for chiming in. Found a misnamed variable. We preventing any compilation task. Disaster averted. Whew! 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 Compile - Crash - looking for ideas
Hi Miyako Thanks for the tip Will try! 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: Sunday, August 20, 2017 5:36 PM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Keisuke Miyako <keisuke.miy...@4d.com> Subject: Re: Unable to Compile - Crash - looking for ideas maybe you could run METHOD GET CODE on all methods just to see if all methods are accessible. if it really comes down to that, I guess you could run METHOD SET CODE on all methods too. or, you could trash (helps if the trash is empty) some methods to exclude them from the compiler. compilation would likely fail due to missing methods, but at least it should be able to complete its task. then you can restore those methods you hid in the trash. > 2017/08/21 9:21、Randy Engle via 4D_Tech <4d_tech@lists.4d.com> のメール： > Any great ideas about how to find this elusive error? ** 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 Compile - Crash - looking for ideas
I've done a fair bit of work since my last compile. Now unable to Compile, Check syntax, Generate Typing. Crashes before finishing. About 1/2 - 3/4 the way through No Errors displayed. Arrgghhh!!! Tried repairing structure. I imagine there's some offending piece of code in here that the compiler really doesn't like. Runs fine uncompiled. At least all that I've tested. Windows 10, 4D v15r5 Any great ideas about how to find this elusive error? 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 Compile - Crash - looking for ideas
Jeff, Thanks, will try! 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: Sunday, August 20, 2017 5:23 PM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Jeffrey Kain <jeffrey.k...@gmail.com> Subject: Re: Unable to Compile - Crash - looking for ideas Change your compiler options? Maybe it will flag an error. Also maybe trash your .4DIndy file ** 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: Win32API - sys_LogonUser vs 4D Single-Sign on
We have a few customers using Win32API sys_logonuser with seeming success. Anyone have good brief description of what might be in 4D's single-sign on that is different/better, more functions, etc. Thanks Randy Engle XC2 Software LLC -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of William Ford Sent: Wednesday, January 11, 2017 5:26 AM To: 4D iNug Technical <4d_tech@lists.4d.com> Subject: Win32API 8.1.2 Release Win32API version 8.1.2 is available now on GitHub. Changes in this version: Bug Fixes * Fixed an issue with sys_GetCommandLine that caused it not to work under 4D v15. * Fixed an issue with gui_GetOpenFileName and guiGetSaveFileName that could cause them to not work unless the optional 8th parameter was passed in. The parentWindow parameter has been moved to the 9th parameter and a new optional 8th parameter, windowReferenceType, has been added. For more information, see the documentation. Changes * Added a constant for Windows Server 2016, OS_SERVER2016, which has a value of 1001. You can download this and previous versions from GitHub: https://github.com/OrchardSoftware/4D-Win32API/releases William Ford Software Engineer Orchard Software Corporation ** 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 **
Understanding 4D Server - Processes Tab - Web Process
4D Server Processes Tab I'm seeing lots of "Web Process" processes listed. (80+) - State - "Waiting for Event" I know that there is not that many people on the web to this app. What makes these processes disappear? (Besides killing 4D Server) Is it OK that there's lots of these seems not if they are not in use. Gracious Thanks to all! Randy Engle 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 **
v15.4 to v15r5 gotcha - WP Area
Just a small item, but it took a fair bit of time to sleuth it. Here is the code I had in v15.4 (Windows) Worked just fine $span:=""+$text+"" Moved to v15r5 Did not recognize, font-weight or font-size Had to change the "single-quotes" in the code above to Double Quotes in order for all to be recognized. $span:=""+$text+"" Maybe this can help somebody save some time and headeache. Randy Engle XC2 Software LLC ** 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: Write.4dbase Component ???
Miyako, Much appreciated! Randy Engle XC2 Software LLC -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Keisuke Miyako via 4D_Tech Sent: Friday, May 26, 2017 12:08 AM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Keisuke Miyako <keisuke.miy...@4d.com> Subject: Re: Write.4dbase Component ??? Hello, it might be an early edition of this component: https://github.com/miyako/4d-component-write-converter originally a 2011 Summit presentation http://kb.4d.com/assetid=76535 > 2017/05/26 10:05、Randy Engle via 4D_Tech <4d_tech@lists.4d.com> のメール： > Write.4dbase ** 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 **
Write.4dbase Component ???
I seem to have this in my components folder Write.4dbase I don't recall how it got there, but I think it's been there for awhile. It looks like it's got some interesting code in it that might be useful. However, I don't think I've ever used it. Anybody familiar with this component? Any info on it? There's no name in the code as to who wrote it. Randy Engle XC2 Software LLC ** 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 **
What prevents Web Server from Starting?
I think I must be going bonkers I can start the 4D Web Server with 5 data files, all exact same structure. However, in 1 data file, can't start it, in any fashion, using command or menu item in design. Tried different ports, etc. No workie Go back to one of the other data files, works fine, any port. Go back to the foobar one, no workie. Whiskey Tango Foxtrot!!! Checked the dosage on my meds, just to make sure... ;-) What would prevent the web server from starting? Randy Engle XC2 Software LLC ** 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: What prevents Web Server from Starting?
As per usual, I was being a meatball. Figured it out egg on my face. ;-) Randy Engle XC2 Software LLC *** ** 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: What prevents Web Server from Starting?
Just to make things interesting: I tried this: OK:=0 WEB START SERVER ` OK = 1 !!! But doesn't actually seem to be running. Randy Engle XC2 Software LLC -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Randy Engle via 4D_Tech Sent: Friday, May 19, 2017 12:01 PM To: '4D iNug Technical' <4d_tech@lists.4d.com> Cc: Randy Engle <4d.l...@xc2.us> Subject: What prevents Web Server from Starting? I think I must be going bonkers I can start the 4D Web Server with 5 data files, all exact same structure. However, in 1 data file, can't start it, in any fashion, using command or menu item in design. Tried different ports, etc. No workie Go back to one of the other data files, works fine, any port. Go back to the foobar one, no workie. Whiskey Tango Foxtrot!!! Checked the dosage on my meds, just to make sure... ;-) What would prevent the web server from starting? Randy Engle XC2 Software LLC ** 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 **
v16x centipedes, trilobites and various other arthropods
I'm just now trying to get our product working with v16. V16.1 didn't work at all. Foobared ALP Didn't recognize clicks in alp area except "outside" of all columns (i.e. on empty area) So now trying to work with 16.2 and 16r4 Fun so far: Item #1 I've got a loop running that opens an input dialog. When the dialog is closed, the process gets hidden (HIDE PROCESS), but the window stays open. If I double click on another item in my output form (ALP Area), it resumes the process and loops back to open the dialog again. Opening the dialog the first time, no problem. Second time: as soon as it hits the DIALOG command, smash, crash, boom. Consistently... Arggh!!! If Iaunch the "looping" process again, first time no problem. Second time, kaboom! This has been working for years in prev versions (most prev version is v15r5) Item #2 Something screwball with copy from the method editor and then paste into the "Find In Design" dialog. Takes 2 Ctrl-V's to paste in. Not a show stopper, very annoying Item #3 HIDE PROCESS Someone reported on this a few months back. Under some conditions, HIDE PROCESS will stop the continuation of code in the process Acts like a "PAUSE PROCESS" SHOW PROCESS or BRING TO FRONT will "Resume" the processing This occurs in my same "Loop" discussed above. FYI, this is all Windows Anyone have anything similar? Insights? I'm in the middle of rewriting my "Dialog Loop", to work around this, but I'm concerned where else it may rear its head. 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: read from a MS SQL server with 4D
Ferdinando, W3 Schools is a good source of examples: https://www.w3schools.com/sql/ Randy Engle, Director XC2 Software LLC – XC2LIVE! -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of stardata.info via 4D_Tech Sent: Wednesday, September 13, 2017 5:28 AM To: 4d_tech@lists.4d.com Cc: stardata.info <stard...@stardata.info> Subject: read from a MS SQL server with 4D I all, I need to read from a MS SQL server with 4D. Someone can give a link with examples. Thanks /Ferdinando/ ** 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: v16x centipedes, trilobites and various other arthropods
I'm using ALP v10.0b10 beta So, working fine in 16.2 and 16r4 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: Wednesday, September 13, 2017 9:56 AM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Jeffrey Kain <jeffrey.k...@gmail.com> Subject: Re: v16x centipedes, trilobites and various other arthropods Which version of ALP? We migrated to 16.2 with ALP 9.4 and it works fine (Mac, 32-bit clients), other than if ALP has the focus, the next click outside the ALP is lost. It's a bug in 4D 16.2 (fixed in R4 I guess) -- 4D isn't sending ALP a deactivate event. -- Jeffrey Kain jeffrey.k...@gmail.com > On Sep 13, 2017, at 12:07 PM, Randy Engle via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I'm just now trying to get our product working with v16. > > V16.1 didn't work at all. Foobared ALP Didn't recognize clicks in alp > area except "outside" of all columns (i.e. on empty area) ** 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: v16x centipedes, trilobites and various other arthropods
Kirk, Thanks. Yes. I'm only running in 32bit (for now) In v16.2 and 16r4, ALP clicks and events work as advertised (32bit) Just not in 16.1 Randy Engle, Director XC2 Software LLC – XC2LIVE! -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Kirk Brooks via 4D_Tech Sent: Wednesday, September 13, 2017 9:30 AM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Kirk Brooks <lists.k...@gmail.com> Subject: Re: v16x centipedes, trilobites and various other arthropods Randy, I believe ALP for v16 is will only run 32 bit. On Wed, Sep 13, 2017 at 9:07 AM, Randy Engle via 4D_Tech < 4d_tech@lists.4d.com> wrote: > I'm just now trying to get our product working with v16. > > V16.1 didn't work at all. Foobared ALP Didn't recognize clicks in alp > area except "outside" of all columns (i.e. > on empty area) > > -- Kirk Brooks San Francisco, CA === *The only thing necessary for the triumph of evil is for good men to do nothing.* *- Edmund Burke* ** 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: 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: Image Export to Excel
Dougie I agree. XL from pluggers is not free, but it "is" the industrial grade plugin for EXCEL. Take control, get the job done. Randy Engle, Director XC2 Software LLC – XC2LIVE! -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Douglas von Roeder via 4D_Tech Sent: Wednesday, August 30, 2017 9:03 AM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Douglas von Roeder <dvonroe...@gmail.com>; Douglas Cryer <jdcr...@telekinetix.com> Subject: Re: Image Export to Excel Dougie: One of the best kept secrets of the 4D plugin world — the XL Plugin from Pluggers. Here's the text from a page from the manual" "xlBookAddPicture Syntax xlBookAddPicture( book ; picture ) → pictureID Parameters Name book → picture → pictureID ← Description Type longint picture longint Adds a picture to the workbook and returns its ID. This ID can then be used to place the picture repeatedly on a worksheet (see xlSheetSetPicture). The ID is a value from 1 to n, where n is the number of pictures in the workbook. The picture must be one of the following types: • PNG • JPEG • TIFF • EMF • WMF • DIB" Per the Pluggers site, it works with OS X 10.9 and higher, Windows XP and higher, and 4D V11 through 16 both 32 bit and 64 bit. At 600€ it's over my "impulse buy" limit but all of the functions that I've used have worked well. The docs and the demo are spartan but enough to get you started. When I ran into something that I could not figure out, Rob replied quickly and was very helpful. -- Douglas von Roeder 949-336-2902 On Wed, Aug 30, 2017 at 4:52 AM, Douglas Cryer via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Miyako, > > Thank you for your reply a while back... > > On 19 Jul 2017, at 20:00, 4d_tech-requ...@lists.4d.com wrote: > > > > the component was meant to be a simple demonstration of how one can > > call > AppleScript and VBA from 4D. > > it was never meant to be an "out of the box" kind of production tool. > > > > if possible, you should consider writing your own script rather than > using the component "as is". > > calling those segmented commands is going to be extremely slow and > inefficient. > > > > Google "AppleScript excel insert image" or "VBA excel insert image" > > you should find lots of examples. > > I was a little surprised at the response but understand it. I > believed that you had written the component to fill a woeful gap in > 4D’s capability to communicate to the most widely used spreadsheet and > reporting tool in the western world. I also think you did rather a good job > at it. > > So when you say it was a simple demonstration I was surprised. I did > google inserting images but on the VB side I could not really figure > out which articles were useful and which were dead ends. I did not > get as far as the AppleScript side. > > I previously spent days doing VB/Apple script for communicating to > Outlook (just getting account data and sending emails) and that really > challenged me as I do not work with these languages on a daily basis. > > I will ask again before I go and spend days on this, has anyone else > extended Miyako's library to insert an image from 4D into Excel? > > Regards, Dougie > ** > 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: Love 4D's math interpretation...
As a very young lad, probably my 5th grade math class, "Always put group arguments in parentheses" Whether it's a bug or not in 4D... there's other things to spend time on... 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 Compile - Crash - looking for ideas - SOLVED
Hi Jody, I went through all of my methods that I'd changed in the last 3 days (fortunately, I commented changes with a datestamp!) About 100 methods. Looked at each line of code FINALLY found the culprit Method_Something(->variable1;"something else") Where in the above line, the "1" at the end of the variable was a mistake. So this faux variable was not typed at all. Syntax Check, Generate Typing, Compiler didn't trap the error. 4D just quit. Took me about 3 hours of sleuthing... Compile often!!! Randy Engle, Director XC2 Software LLC – XC2LIVE! -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Jody Bevan via 4D_Tech Sent: Monday, August 21, 2017 6:06 AM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Jody Bevan <jody.be...@gmail.com> Subject: Re: Unable to Compile - Crash - looking for ideas Randy: Keep us posted. That is a scary one. Jody Bevan ARGUS Productions Inc. Developer Argus Productions Inc. <https://www.facebook.com/ArgusProductions/> ** 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: Unable to Compile - Crash - looking for ideas - SOLVED
Hi Randy, Yes, from here on, I've changed the "typing" to "All Variables are typed" Thanks! Randy Engle, Director XC2 Software LLC – XC2LIVE! -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Randy Jaynes via 4D_Tech Sent: Monday, August 21, 2017 8:49 AM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Randy Jaynes <ra...@printpoint.com> Subject: Re: Unable to Compile - Crash - looking for ideas - SOLVED Randy, I would also recommend changing the settings from Generate Typing to All Variables are typed This gives you control over the typing of your variables, and the line you point out would have kicked out a compiler error about the unknown ‘variable1’ in your line of code. 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 > On Aug 21, 2017, at 11:42 AM, Randy Engle via 4D_Tech <4d_tech@lists.4d.com > <mailto:4d_tech@lists.4d.com>> wrote: > > Hi Jody, > > I went through all of my methods that I'd changed in the last 3 days > (fortunately, I commented changes with a datestamp!) > > About 100 methods. > Looked at each line of code > > FINALLY found the culprit > > Method_Something(->variable1;"something else") > > Where in the above line, the "1" at the end of the variable was a mistake. > > So this faux variable was not typed at all. > > Syntax Check, Generate Typing, Compiler didn't trap the error. > 4D just quit. ** 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/Remote as Web Server - One more item
So all is working great with Client as Web Server... on my system. I just needed to copy the "Web/HTML" folder to the wonderfully obscure location: C:\Users\\AppData\Local\\ Easy Schmezey! Right? What a PITB. We have several customers that want to have Client as the web server. So when having our customers install this, I'd like to come up with a way that installs the "web/html" folder (and SSL cert files) into this location when 4D client synchronizes from the server. I suppose I could put these files/folders into the Client folder, and then on startup of the client, copy into the above User/AppData Folder But, what if I make changes in the "Web/HTML" folder (e.g. HTML files), then customer would have to get a new copy of client with the updated Web Folder. Hmmm. Need to get the Web/HTML folder from the server, as that is the one that gets updated regularly. All input graciously welcome! 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: 4D Client as Web Server - How to monitor
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 (would require a "Delay" until received info) 3. Have the Web Server client continually loop (every minute or so) And 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 4. Do an HTTP Get on the Web Server Client NOTE: OK if the web server is running If web server not running, there is a long delay before HTTP get returns with the status code. So, not an option Any other ideas from the 4D Brainiacs? 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: 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
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: 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: 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 **
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 **
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: 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 **
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: 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: 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 **
