Re: Creating Tables by running a method

2018-06-22 Thread Jody Bevan via 4D_Tech
Pat: We have rarely used a trigger, but it is an important thing to know in going into it. Thanks for telling me. At least I will not spend a week trying to get a trigger into a table I have created this way. One never knows what they will be doing, or need in the future. Life has certainly

Re: v13+ open multiple methods windows stacked

2018-06-22 Thread Douglas von Roeder via 4D_Tech
Chip: The command Window list fills an array of window references. The command Window process returns the process for a given window reference. You could iterate through the window references that belong to the design process and move them, as desired. To determine which windows are method

Re: Creating Tables by running a method

2018-06-22 Thread Pat Bensky via 4D_Tech
One gotcha with creating tables this way is that you cannot add triggers. That may not be important for you but it's worth knowing ... Pat On Fri, 22 Jun 2018 at 19:11, Randy Engle via 4D_Tech <4d_tech@lists.4d.com> wrote: > Just in case you "really" want to use SQL to create the index: > >

Re: v13+ open multiple methods windows stacked

2018-06-22 Thread Chip Scheide via 4D_Tech
Thanks all for the ideas. Chip > Chip: > > The command Window list fills an array of window references. > > The command Window process returns the process for a given window reference. > > You could iterate through the window references that belong to the design > process and move them, as

Re: Creating Tables by running a method

2018-06-22 Thread Jody Bevan via 4D_Tech
Randy: Thanks so much for this. Giving me two ways - 4D and SQL. I am going to work on some code and interface for doing this. Jody > On Jun 22, 2018, at 12:09 PM, Randy Engle via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Jody, > > You can set/create an index in 4D Code > >

Re: v13+ open multiple methods windows stacked

2018-06-22 Thread Jody Bevan via 4D_Tech
Chip: I do not know of a way to do this automatically. I have done it a long time ago using code - code I don’t have anymore. We control the opening position of every window so writing this is not that hard (likely you know that already - sorry). Jody > On Jun 22, 2018, at 3:19 PM, Chip

v13+ open multiple methods windows stacked

2018-06-22 Thread Chip Scheide via 4D_Tech
is there a way to open multiple method windows, and have them stack, one over the over (plus a small offset) Mac version if it matters Thanks Chip --- Gas is for washing parts Alcohol is for drinkin' Nitromethane is for racing

Re: v13+ open multiple methods windows stacked

2018-06-22 Thread Wayne Stewart via 4D_Tech
// // Project Method: Util_ResizeWindows // Resizes and stacks all design mode windows // Created by Wayne Stewart (2018-06-22) // wa...@4dsupport.guru //

Re: WP Get selection

2018-06-22 Thread Pat Bensky via 4D_Tech
Hey John, Yes ... I replaced both the WP object and the toolbar subform and now it works OK! Thanks Pat On Fri, 22 Jun 2018 at 16:44, John Baughman via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Are you using the write-like toolbar? > > I had this problem and solved it by recreating the form

RE: Dot notation

2018-06-22 Thread Vance Villanueva via 4D_Tech
Hi Pat, In looking at the code, are any of the "$" not initialized or set? If I just try to run this code in a method: $0:=New object("Range";$wpRange;"Font";$font;"Family";$fontFamily;"Size";$fontSize) I can get that error if I don't load anything in the "$". Regards, Vance Villanueva

RE: Creating Tables by running a method

2018-06-22 Thread Randy Engle via 4D_Tech
Jody, You can set/create an index in 4D Code ARRAY POINTER($fieldPtrArr;1) $fieldPtrArr{1}:=->[Facility]Facility_Name CREATE INDEX([Facility];$fieldPtrArr;Standard BTree index;"FacilityNameIDX") // composite

Re: RIP Sujit Shah

2018-06-22 Thread Chuck Miller via 4D_Tech
Also, not sure I ever met him, but my thoughts and prayers are with his family Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064

RE: Creating Tables by running a method

2018-06-22 Thread Randy Engle via 4D_Tech
Just in case you "really" want to use SQL to create the index: $statement_t:="" $statement_t:=$statement_t+"CREATE INDEX "+$index_Name $statement_t:=$statement_t+" " // Need a space $statement_t:=$statement_t+"ON "+$tableName_t+" ("+$fieldName+")" //example: $statement_t:="CREATE INDEX

Re: WP Get selection

2018-06-22 Thread John Baughman via 4D_Tech
Are you using the write-like toolbar? I had this problem and solved it by recreating the form from scratch. Copy everything from the old form except the toolbar sub form and 4D Write Pro area then add the sub form and area as you would normally. I could not get Write Pro to work properly

Creating Tables by running a method

2018-06-22 Thread Jody Bevan via 4D_Tech
I know that this feature has been around for a long time ~ 4D 2011. I am now using 16R6. I now have a method that creates a table with the fields I want added. The challenge I am having is setting indexes (and index types), as well as Primary Keys. I looked in the Knowledge Base for code

RE: RIP Sujit Shah

2018-06-22 Thread Adriano Cisternino via 4D_Tech
RIP Sujit, you will be missed! Adriano -Original Message- From: Graham Langley via 4D_Tech [mailto:4d_tech@lists.4d.com] Sent: Friday, 22 June 2018 10:29 PM To: 4d_tech@lists.4d.com Cc: Graham Langley Subject: Re: RIP Sujit Shah I knew Sujit well, he was a customer (Lightning) and

WP Get selection

2018-06-22 Thread Pat Bensky via 4D_Tech
Further to my earlier post regarding the 4Dwrite toolbar ... I discovered that I was using an older version of the demo database. So I got the latest one and copied the necessary elements from the demo db over to my db. Now I get an error message on calling *WP Get selection:* $wpRange:=*WP Get

Re: RIP Sujit Shah

2018-06-22 Thread Doug Cottrill via 4D_Tech
Never met him, but always appreciated his contributions to this list and the 4D Community. He will be missed. DKC > On Jun 22, 2018, at 7:50 AM, Jörg Knebel via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > >> On 22 Jun 2018, at 21:13 AEST, Wayne Stewart via 4D_Tech >> <4d_tech@lists.4d.com>

XSLT APPLY TRANSFORMATION Replacement

2018-06-22 Thread Douglas Cryer via 4D_Tech
Hi there, I have a client who has just hit a problem with a deprecated command _o_XSLT APPLY TRANSFORMATION Seems to be two issues. One the command is deprecated and two the command returns a message that it cannot be executed on server. Does anybody have a viable direct replacement for this

Re: Port 80 Security Scanning - e.g. Qualys

2018-06-22 Thread Robert ListMail via 4D_Tech
Randy, how about running a Pfsense firewall? You could run it bare metal or VM. However the network should already have these protections. Will you need a special version of MS word that has a built in firewall? No! Rob Sent from my iPhone > On Dec 4, 2017, at 12:11 PM, Randy Engle via

Re: XSLT APPLY TRANSFORMATION Replacement

2018-06-22 Thread Keisuke Miyako via 4D_Tech
the command is not supported on 4D Server 64-bit for Mac and 4D 64-bit for Windows. http://doc.4d.com/4Dv16R4/4D/16-R4/o-XSLT-APPLY-TRANSFORMATION.301-3317052.en.html http://doc.4d.com/4Dv16R4/4D/16-R4/Changing-from-32-bit-versions-to-64-bit-versions.300-3330500.en.html

Re: XSLT APPLY TRANSFORMATION Replacement

2018-06-22 Thread Koen Van Hooreweghe via 4D_Tech
Hi Doug, Al always, the Miyako well full of plugin magic: https://github.com/miyako/4d-plugin-xslt Kind regards, Koen > Op 22 jun. 2018, om 10:04 heeft Douglas Cryer via 4D_Tech > <4d_tech@lists.4d.com> het volgende geschreven: > > I have a client who has just hit a problem with a deprecated

Re: RIP Sujit Shah

2018-06-22 Thread Jörg Knebel via 4D_Tech
> On 22 Jun 2018, at 21:13 AEST, Wayne Stewart via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > I just heard today that Sujit Shah has just died. What a bloody loss. > He was a lovely man and one of nature’s true gentlemen. And he was a very close personal friend of mine who visit me only a

RIP Sujit Shah

2018-06-22 Thread Wayne Stewart via 4D_Tech
Hi, I just heard today that Sujit Shah has just died. Probably only known to Australasian developers although he did post to the iNug. He was a lovely man and one of nature’s true gentlemen. ———- From Mrs Darshana Shah and Rhea Shah It is with much regret that I wish to inform friends and

Re: RIP Sujit Shah

2018-06-22 Thread Balinder Walia via 4D_Tech
RIP Sujit sad news! On Fri, 22 Jun 2018 at 12:51, Milan Adamov via 4D_Tech <4d_tech@lists.4d.com> wrote: > RIP, it was his birthday just few weeks ago. > > Milan > > Sent from my iPad > > > On Jun 22, 2018, at 13:13, Wayne Stewart via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > > > > Hi, > > > >

Re: RIP Sujit Shah

2018-06-22 Thread Milan Adamov via 4D_Tech
RIP, it was his birthday just few weeks ago. Milan Sent from my iPad > On Jun 22, 2018, at 13:13, Wayne Stewart via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Hi, > > I just heard today that Sujit Shah has just died. Probably only known to > Australasian developers although he did post to

Dot notation

2018-06-22 Thread Pat Bensky via 4D_Tech
I'm trying to use the 4DWrite-like toolbar with Write Pro. It uses dot notation to reference the WP object. For example: $fontStyle:=GetSelectionInfo // creates a range object In GetSelectionInfo: *$0*:=*New object*("Range";$wpRange;"Font";$font

Re: XSLT APPLY TRANSFORMATION

2018-06-22 Thread Douglas Cryer via 4D_Tech
Miyako and Koen, Many thanks. The plugin works brilliantly as a direct replacement. Re: but if it is a command you "never use or know much about" why is it even being called..? I often get asked by clients to look at code that has been written by someone else decades ago. Usually the

Re: RIP Sujit Shah

2018-06-22 Thread Graham Langley via 4D_Tech
I knew Sujit well, he was a customer (Lightning) and was a great help to the product. I will miss him!! Rest in Peace my good man. X -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 4D Internet Users