Re: Opinion

2020-04-24 Thread Kenneth Geiger via 4D_Tech
Hi Randa, Thanks much for your input. I never did very much with v14 at all. I guess it is time to stat biting the bullet! Regards, Ken > On Apr 24, 2020, at 6:38 PM, Randy Kaempen wrote: > > Ken, > >> On Apr 24, 2020, at 6:41 PM, Kenneth Geiger via 4D_Tech >> <4d_tech@lists.4d.com>

Re: Opinion

2020-04-24 Thread Randy Kaempen via 4D_Tech
Ken, > On Apr 24, 2020, at 6:41 PM, Kenneth Geiger via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > Yes, this is why I’m trying to get their 4D System to point where it will run > on a version of 4D that is happy on Win10. The only reason I mentioned Win7 > is if the consensus were to be that

Re: 4D Friday Happy Hour on ZOOM

2020-04-24 Thread Wayne Stewart via 4D_Tech
Good attendance, thanks Kirk. For all those that didn't attend, you should have. Regards, Wayne On Fri, 24 Apr 2020 at 04:37, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> wrote: > Hey folks, > > I’m hosting a 4D Friday Happy Hour tomorrow on ZOOM: > https://zoom.us/j/91959066132 > >

Re: 4D v18 — Need methodology to

2020-04-24 Thread Chris Belanger via 4D_Tech
Wow! I never knew that. Thanks for explaining, Lahav. — Chris > On Apr 24, 2020, at 4:52 PM, lists via 4D_Tech <4d_tech@lists.4d.com> wrote: > > Chris, > > Just create a regular method, mark it as "Execute on Server" in the method > properties, then call it just like any other method. You can

Re: Opinion

2020-04-24 Thread Kenneth Geiger via 4D_Tech
Thanks Aparajita, Yes, this is why I’m trying to get their 4D System to point where it will run on a version of 4D that is happy on Win10. The only reason I mentioned Win7 is if the consensus were to be that moving from 4D v12 directly to 4D v15 is too big a step, I would move it through v14

Re: Opinion

2020-04-24 Thread Aparajita Fishman via 4D_Tech
> On Apr 24, 2020, at 3:37 PM, 4d_tech-requ...@lists.4d.com wrote: > > I’ve got a Win7 environment Run, don’t walk, and upgrade to Windows 10. Windows 7 is abandoned, unpatched, insecure, and dangerous. Running Windows 7 is a huge welcome mat to hackers and ransomware. Firewalls and security

Re: 4D v18 — Need methodology to

2020-04-24 Thread Tom Benedict via 4D_Tech
Indeed. The "Execute on server” method attribute is very different from the “Execute on server” command. The former says “Run this code on the server and return a value” while the latter starts a stored procedure. Tom Benedict > On Apr 24, 2020, at 15:52, lists via 4D_Tech

Re: Opinion

2020-04-24 Thread Kenneth Geiger via 4D_Tech
Hi Tom, No, it does not use 4D Write. And, yes, I am aware of the 64-bit issue. I’ve just been through this with two of my existing systems and am planning to address this with this system. I will run a 64-bit compatibility audit on it after replace the depreciated-stuff. This client is a

RE: 4D v18 — Need methodology to

2020-04-24 Thread lists via 4D_Tech
Chris, Just create a regular method, mark it as "Execute on Server" in the method properties, then call it just like any other method. You can return anything you want in $0 $myData:=ThisMethodRunOnServer(whatever) Just make sure to check that little box in the ThisMethodRunOnServer Method

Re: Opinion

2020-04-24 Thread Charles Miller via 4D_Tech
You could write code and check each field in each table checking for type. I think field type 7 is a link to a sub table. If desired some ok me in my company can do this part for you as well as the code to unlink and update the data. I have done this before. I might even do this part in 12.

Re: 4D v18 — Need methodology to

2020-04-24 Thread Chris Belanger via 4D_Tech
Hi Olivier, I am looking for SIMPLE, alright. I have looked at ‘execute on server’ but I do not see how it sends anything to the client other than the process number (in $0). What have I missing about it? I used it in the past (when I made a ‘communicator’ subsystem in classic 4D) but it

Re: Opinion

2020-04-24 Thread Kenneth Geiger via 4D_Tech
Hi Chuck, Thanks! I totally agree with you and was anticipating these changes. I have just one really dumb question… In all my years using 4D, I have NEVER used a sub-table. Just how would I recognize if this structure includes and sub-tables? Regards, Ken > On Apr 24, 2020, at 4:12 PM,

Re: Opinion

2020-04-24 Thread Tom Benedict via 4D_Tech
Hi Ken, Does this app use 4D Write? If it does, and if you ever think this app will move beyond v17, you gotta think about 64 bit, if you haven’t already. Also, Chuck mentioned getting pictures converted, but there’s more to 64bit compatibility. Would be good to run a 64 bit compatibility

Re: 4D v18 — Need methodology to

2020-04-24 Thread Chris Belanger via 4D_Tech
Hi Kirk, Thanks for your comments. By the way, I enjoyed your cameo appearance in Intissar’s session on 4D Summit 2020. I agree with ‘getting with it on ORDA’ and leaving the past behind! I regret that I have to resort to ‘classic’ in triggers still; I was hoping 4D would provide a “This.”

Re: Opinion

2020-04-24 Thread Chuck Miller via 4D_Tech
First, I would not use windows 7 at all. I would move to windows 10 Second here are some potential ares of concern that you will need to deal with 1. Are there any sub-tables. If so I would recommend creating new tables and moving data in v 15 2. There are probably obsolete pictures in the db.

Re: Using Document to text ala Receive Packet Was: Receive packet stop character

2020-04-24 Thread JOHN BAUGHMAN via 4D_Tech
I have modified my Document to text wrapper that functions like Receive packet. Not sure if anyone is really interested in this but since I did post the original method I thought it best for me to post the modified version. The new version has 2 uses.. 1. To replace Receive packet as

Opinion

2020-04-24 Thread Kenneth Geiger via 4D_Tech
Hi all, I’m solicitating your opinions. I’ve picked-up a new 4D client. They have an existing 4D system (v12 running on Win7) that has been stagnant for quite e few years. I believe it was originally written under 2004 or maybe even 6.8.5. They’re looking to replace their computers with Win10

Re: replace obsolete plugins

2020-04-24 Thread Douglas von Roeder via 4D_Tech
Chuck: API Pack is freely downloadable from the web site, though Rob (finally) has started asking for a donation. -- Douglas von Roeder 949-910-4084 On Fri, Apr 24, 2020 at 10:51 AM Charles Miller via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Ok just found api pack from pluggers and am asking

Re: replace obsolete plugins

2020-04-24 Thread Charles Miller via 4D_Tech
Ok just found api pack from pluggers and am asking for upgrade. Regards Chuck On Fri, Apr 24, 2020 at 1:37 PM Charles Miller wrote: > There is no Ali pack for 17 that I can find. Do you know where I can find > it? > > Regards > > Chuck > > > On Fri, Apr 24, 2020 at 1:36 PM Douglas von Roeder

Re: replace obsolete plugins

2020-04-24 Thread Charles Miller via 4D_Tech
There is no Ali pack for 17 that I can find. Do you know where I can find it? Regards Chuck On Fri, Apr 24, 2020 at 1:36 PM Douglas von Roeder via 4D_Tech < 4d_tech@lists.4d.com> wrote: > API Pack works with versions of 4D as far back as 6.7 so you can just swap > out the version that you’ve

Re: replace obsolete plugins

2020-04-24 Thread Douglas von Roeder via 4D_Tech
API Pack works with versions of 4D as far back as 6.7 so you can just swap out the version that you’ve got for the current version = zero code. If the ZIP plugin isn’t compatible with V17, I think Miyako has a plugin that does ZIP. Lacking that, you could fire up something with AppleScript or

replace obsolete plugins

2020-04-24 Thread Charles Miller via 4D_Tech
Hi All, Environment 4D v17 I have a db which uses the following 3 plugins 4D pack API Pack zip What I am looking for is anyone who has replaced any of commands in API pack with native 4D. I think I can deal with the rest Regards Chuck --

RE: 4D Friday Happy Hour on ZOOM

2020-04-24 Thread Lo via 4D_Tech
Indeed. Wayne reminded me the other day that this was 4 years ago on the road trip to Portland by sending a picture of the golden gate. Is was great to see you then and I hope to do so again soon. Can't make tonight I'm afraid, but if it works, and you go again... Have fun and I send my best

Re: 4D Friday Happy Hour on ZOOM

2020-04-24 Thread Kirk Brooks via 4D_Tech
Lo! I was thinking about you the other day - recalling you stopping by in '16. On Fri, Apr 24, 2020 at 7:37 AM Lo via 4D_Tech <4d_tech@lists.4d.com> wrote: > Hi Kirk > > Yes, some people are just born one beer below normal. > Plenty of time to get that sorted... > > Love and kisses > Lo > > >

Re: 4D v18 — Need methodology to

2020-04-24 Thread Kirk Brooks via 4D_Tech
Hi Chris, On Fri, Apr 24, 2020 at 1:54 AM Chris Belanger via 4D_Tech < 4d_tech@lists.4d.com> wrote: > • Loading a system document into a BLOB, then using BASE64 ENCODE to store > it in a TEXT field; Out of curiosity why not simply blob the document into a blob field? Even if it's a temporary

RE: 4D Friday Happy Hour on ZOOM

2020-04-24 Thread Lo via 4D_Tech
Hi Kirk Yes, some people are just born one beer below normal. Plenty of time to get that sorted... Love and kisses Lo > Damn - it's that off-by-one problem again... ** 4D Internet Users Group (4D iNUG) Archive:

Re: 4D Friday Happy Hour on ZOOM

2020-04-24 Thread Kirk Brooks via 4D_Tech
Damn - it's that off-by-one problem again... On Thu, Apr 23, 2020 at 10:03 PM Aparajita Fishman via 4D_Tech < 4d_tech@lists.4d.com> wrote: > I may be missing something, but isn’t 3 PM PDT = 6 PM EDT? > > All the best, > > - Aparajita > > > On Apr 23, 2020, at 7:33 PM,

AW: 4D v18 — Need methodology to

2020-04-24 Thread Olivier Flury via 4D_Tech
Maybe too simple for what you need to do, but have a look at the "execute on server" property for project methods. Create a method that is executed on server. It gets as $1 the id of the document you want to display on the client side. The method does everything to fetch the document from the

4D v18 — Need methodology to

2020-04-24 Thread Chris Belanger via 4D_Tech
I have a methodology of allowing clients to transfer documents that are thereafter stored by 4D Server in a ‘LIBRARY’ of system documents it maintains automatically. [these are not stored in the DB, but in a managed folder on disk.] I do this by: • Loading a system document into a BLOB, then

Re: V18 ORDA — What is the Best substitution option for BLOB fields

2020-04-24 Thread Peter Bozek via 4D_Tech
Look at BASE64 ENCODE / DECODE https://doc.4d.com/4Dv17/4D/17.4/BASE64-DECODE.301-4882388.en.html Peter Bozek On Fri, Apr 24, 2020 at 9:05 AM Chris Belanger via 4D_Tech < 4d_tech@lists.4d.com> wrote: > ORDA does not support BLOB fields. So I need a different way of storing > things that would

V18 ORDA — What is the Best substitution option for BLOB fields

2020-04-24 Thread Chris Belanger via 4D_Tech
ORDA does not support BLOB fields. So I need a different way of storing things that would normally be BLOBS as TEXT. (in particular, system DOCUMENTS such as PDFS, JPGS, etc). I am trying to work-around by converting BLOB -> TEXT -> BLOB The key statements to work around the ‘BLOB’ problem