Fixed: Re: v16 List Box Set Enterable not working?

2018-01-22 Thread Lloyd SIgler via 4D_Tech
Okay, it works as expected when you make area ‘Enterable’ in Property List. No requirement to to put it in the “On Before Data Entry”. Evidently, v14 allowed overriding that setting in code, which I personally prefer since it eliminates the need to add code to make it unenterable. Lloyd > O

RE: Web Services Using HTTPS

2018-01-22 Thread Randy Engle via 4D_Tech
Steve, For starters, you will need an SSL Certificate Pascal from QualitySSL is very responsive and helpful. He's in Denmark but keeps late hours. Randy Engle, Director XC2 Software LLC – XC2LIVE! -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Stephe

RE: Web Services Using HTTPS

2018-01-22 Thread Stephen J. Orth via 4D_Tech
Yes, I want to publish a web service that someone can subscribe to using HTTPS (instead of HTTP). I will also need to be able to return information back the same way. I'm trying to educate myself on using HTTPS, as I've never had to use it before. Best, Steve -Original Message- From

Re: 4D SQL Question

2018-01-22 Thread Arnaud de Montard via 4D_Tech
> Le 22 janv. 2018 à 18:48, Jim Dorrance via 4D_Tech <4d_tech@lists.4d.com > > a écrit : > > [...]Is there a clever way to select nothing into a Listbox so that an > empty listbox with all the columns defined? I could then fill the > listbox "manually". What I do now

Re: Web Services Using HTTPS

2018-01-22 Thread Keisuke Miyako via 4D_Tech
you mean, you want to publish SOAP web services from 4D (and not consume one) ? all the principles for setting up the web server applies; certificate, redirection, etc. http://doc.4d.com/4Dv16/4D/16.3/Using-TLS-Protocol.300-3652280.en.html 2018/01/23 6:43、Stephen J. Orth via 4D_Tech <4d_tech@l

Web Services Using HTTPS

2018-01-22 Thread Stephen J. Orth via 4D_Tech
Maybe I’m just missing it, but where would I find information on using HTTPS with web services, and what is required compared to using HTTP? I have a customer who is requesting HTTPS and we have always done straight HTTP. Thanks in advance! Steve *

Re: v16 List Box Set Enterable not working?

2018-01-22 Thread Lloyd Sigler via 4D_Tech
I will try that approach, but seems that the code 'should' work since the row and column are specified. Makes cleaner code to deal with it all in one place, in this case I have a boolean that gets ‘checked’ if we are paying an invoice, and it then ‘unlocks’ the ‘amount’ in that row and puts cur

RE: ACI0097488 Mem Leak not fixed in 16R5

2018-01-22 Thread Timothy Penner via 4D_Tech
Small clarification: > This optimization is available in v16.x.above 219029 (the first nightly build > after 16.3). The part about it being the first nightly build after v16.3 was wrong. -Tim ** 4D Internet Users Group (4D i

RE: ACI0097488 Mem Leak not fixed in 16R5

2018-01-22 Thread Timothy Penner via 4D_Tech
ACI0097488 is not a memory leak. ACI0097488 is a about the memory that is used during the backup and then released back to the system as inactive memory. The macOS would typically turn this inactive memory to file cache, and a situation could arise where the OS reported that there was no free m

ACI0097488 Mem Leak not fixed in 16R5

2018-01-22 Thread Joe Dombroski via 4D_Tech
I am assuming that the memory leak is not fixed in 16R5. Correct? Joe Dombroski ** 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/ma

RE: v16R and v16

2018-01-22 Thread Timothy Penner via 4D_Tech
> I’m not a partner and don’t get R releases, which I accept means I’ll have to > wait. I’m just wondering for how long. It is true that partners get licenses that grant them access to the R-release. However, you don’t *need* to be a partner to get the R-release! You just need to use a license

Re: 4D SQL Question

2018-01-22 Thread Jeffrey Kain via 4D_Tech
Just make sure you have no object fields in that table, or 4D will give you a runtime error and fail. -- Jeffrey Kain jeffrey.k...@gmail.com > On Jan 22, 2018, at 1:30 PM, Keisuke Miyako via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > Not so dissimilar from your idea but you could do > > B

Re: 4D SQL Question

2018-01-22 Thread Keisuke Miyako via 4D_Tech
Not so dissimilar from your idea but you could do Begin SQL SELECT * FROM [myTable] LIMIT 0 into LISTBOX :myListbox; End SQL ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d

Re: dot notation object

2018-01-22 Thread Jim Dorrance via 4D_Tech
Oooops... Thanks On Mon, Jan 22, 2018 at 5:12 PM, Keisuke Miyako via 4D_Tech < 4d_tech@lists.4d.com> wrote: > yes, but the syntax would look like: > > $nTable:=$oParameters[kOParam_Requested_nTableNumber] > > see > > http://doc.4d.com/4Dv16R4/4D/16-R4/Using-object-notation- > preview.300-3303773.

Re: Capture Image on Tablet

2018-01-22 Thread Douglas Cryer via 4D_Tech
OK We did manage to get the web page image capture method working but had to downgrade all the components to 32bit so they would run on the tablet. It runs really slow so we will need to play with it a little to find how best to use it but it is at least an option to loading files manually. Tha

Re: v16 List Box Set Enterable not working?

2018-01-22 Thread Chip Scheide via 4D_Tech
Kirk, this idea is needed/use when working with drag n drop. something like (all code off the top of my head, if I have the accept or reject value wrong - I apologize: // Drop destination object method c_longint($0) case of :(form event = on drag over) if (Dropping data is valid in this context

Re: 4D SQL Question

2018-01-22 Thread Jim Dorrance via 4D_Tech
While you are on the subject... I am a big fan of: $tSQL:="SELECT * FROM "+$tTableName+" INTO : "+$tLBox Because it creates dynamic Listbox columns automatically. Is there a clever way to select nothing into a Listbox so that an empty listbox with all the columns defined? I could then fill the

RE: 4D SQL Question

2018-01-22 Thread Stephen J. Orth via 4D_Tech
Lee, Thanks... I also found a "BETWEEN" condition, so I'm thinking this is also a possibility. Best, Steve -Original Message- From: Lee Hinde [mailto:leehi...@gmail.com] Sent: Monday, January 22, 2018 11:17 AM To: s.o...@the-aquila-group.com; 4D iNug Tech <4d_tech@lists.4d.com> Subj

Re: 4D SQL Question

2018-01-22 Thread Lee Hinde via 4D_Tech
DELETE FROM users WHERE id in [1,2.3]; would delete the three users with one of those ids (or none at all, if the ids didn’t exist.) DELETE FROM users WHERE last_name=“Smith”; would delete all users with the last_name of Smith. > On Jan 22, 2018, at 9:06 AM, Stephen J. Orth via 4D_Tech > <4d_

4D SQL Question

2018-01-22 Thread Stephen J. Orth via 4D_Tech
SQL newbie here... What is the correct syntax for deleting a number rows in a SQL database? Is it possible to use a 4D array which contains the values used by the WHERE clause? Or, do we have to delete each row individually? Thanks! Steve * Step

Re: Going to the Summit Training, does it worth it?

2018-01-22 Thread Kirk Brooks via 4D_Tech
I agree it's worthwhile. Many of you will recall this hasn't always been my quietly held opinion. The biggest thing that changed? I actually started going to them. The biggest benefits for me personally have been making personal connections with people in the company and other developers. On the

Re: v16 List Box Set Enterable not working?

2018-01-22 Thread Kirk Brooks via 4D_Tech
The link Miyako included to the section on Managing Entry does actually talk about this. (I confess I hadn't read it very carefully before now myself.) You use OBJECT SET ENTERABLE to manage the enterability of the 'object' which is the listbox column. To control the enterability of an individual

Re: dot notation object

2018-01-22 Thread Keisuke Miyako via 4D_Tech
yes, but the syntax would look like: $nTable:=$oParameters[kOParam_Requested_nTableNumber] see http://doc.4d.com/4Dv16R4/4D/16-R4/Using-object-notation-preview.300-3303773.en.html the example to follow is employee.name:="Smith" $vName:=employee["name"] > 2018/01/22 23:14、Jim Dorrance via 4D_

Re: v16 List Box Set Enterable not working?

2018-01-22 Thread Jim Crate via 4D_Tech
On Jan 21, 2018, at 10:41 PM, 4d--- via 4D_Tech <4d_tech@lists.4d.com> wrote: > > The following works fine in v14, but in v16 doesn’t work. Is this a known > issue?? > > OBJECT SET ENTERABLE(ar_invBalance{$row};True) > EDIT ITEM(ar_invBalance;$row) I tried EDIT I

Re: Capture Image on Tablet

2018-01-22 Thread Douglas Cryer via 4D_Tech
Tim and Timothy, Thanks for the information. I thought it was going to be the solution as it works really well on a Windows 10 desktop with a plugin USB web cam. However, we have not been able to get it to recognise a tablets built in cameras. We have tried updating the js source code but no

Re: Going to the Summit Training, does it worth it?

2018-01-22 Thread Ortwin Zillgen via 4D_Tech
> Summarised here what my customers will > pay me for in 2018. sorry the link should have been this one O r t w i n Z i l l g e n -

Re: v16R and v16

2018-01-22 Thread Neil Dennis via 4D_Tech
> Are you suggesting it might be better to skip updating to and deploying v16 > and wait for v17? Nope, there are tons of cool things in v16 :) I didn’t wait, 4D keeps getting gooder and gooder (yes I just said gooder) :) Neil Sent from my iPhone > On Jan 22, 2018, at 7:09 AM, Jim Dorrance via

Re: Creating .docx files

2018-01-22 Thread Pat Bensky via 4D_Tech
Oh wow ... I'm going to give phpword a try. thanks for the suggestion. On 21 January 2018 at 20:47, Dani Beaubien via 4D_Tech <4d_tech@lists.4d.com > wrote: > +1 for phpword. I have been using for the last few months and it is fast > and works very well. > > Dani > > > ***

dot notation object

2018-01-22 Thread Jim Dorrance via 4D_Tech
Hi, Can I use a 4D custom constant with dot notation, eg instead of $nTable:=*OB Get*($oParameters;kOParam_Requested_nTableNumber;Is longint) $nTable:=$oParameters.kOParam_Requested_nTableNumber -- Jim Dorrance jim.dorra...@gmail.com 4...@dorrance.eu www.4d.dorrance.eu PS: If you know of an

Re: v16R and v16

2018-01-22 Thread Jim Dorrance via 4D_Tech
Are you suggesting it might be better to skip updating to and deploying v16 and wait for v17? On Mon, Jan 22, 2018 at 1:45 PM, npdennis via 4D_Tech <4d_tech@lists.4d.com> wrote: > Anything in the R releases are included in the next major version of 4D so > features in 16R2 will be in the first 17

Re: v16R and v16

2018-01-22 Thread npdennis via 4D_Tech
> There’s a new command (LISTBOX SET PROPERTY) that I’ve been anticipating for > years; it was introduced in v16R2, apparently, but isn’t in v16.3 > > I’m not a partner and don’t get R releases, which I accept means I’ll have to > wait. I’m just wondering for how long. Anything in the R release

Re: v16R and v16

2018-01-22 Thread Jeremy Roussak via 4D_Tech
Douglas, Yes, I know about ALP, but I have quite a bit of time and effort invested in list boxes, which fulfil most of my requirements. What interested me was not a bug fix but a newly-introduced feature. I get the impression from your reply that it won’t be until v17 (or v18, or whatever it’s

Re: Going to the Summit Training, does it worth it?

2018-01-22 Thread Ortwin Zillgen via 4D_Tech
@JPR thanks for sharing. Lots of technicalities to enjoy us developers. Anything our customers will appreciate and pay us for, because they see it, feel it or enjoy the speed-improvement? Summarised here what my customers will pay me for in 2018. Regards