Re: Standalone application connection to 4D Server

2018-05-09 Thread Kirk Brooks via 4D_Tech
You know, this reminds me of when I used to manage restaurants. I'd tell my managers that a place runs better when it's easy to do the right thing and hard to do the wrong thing. So you really want to avoid making it easier to do the wrong things. Because the easier something is to do the more like

Re: v13+ LEP permision issues.

2018-05-09 Thread Keisuke Miyako via 4D_Tech
isn't "Method called on error" executed in the same process as the invoking method? normally the code would only be interested in basic information such as OK, which changes the course of action (ignore, abort, retry). even if more details were available, there is normally not much one can do on

Re: Standalone application connection to 4D Server

2018-05-09 Thread Wayne Stewart via 4D_Tech
Hi​ , ​Just some more clarification on licensing. Not many people read the fine print of the license. A ​ 4D Application Single User (or what many people call ​ engined ​or sponsored version ​)​ can’t ​ connect more than twice per day to write to a data source. It can connect as many times as y

RE: v13+ LEP permision issues.

2018-05-09 Thread Chip Scheide via 4D_Tech
Tim, a bit late but... There are other reasons, but one is: Thread safety :) And while this is NOT an issue in v13, I am writing this code now, I might as well make as much of the code thread safe, and future proof, as is reasonable. Using 4D functions requires wrapping an On Err Call("metho

Re: Picture Buttons in v16

2018-05-09 Thread Alan Tilson via 4D_Tech
Tim, I did find the Light Grey button in the new form wizard to be quite good, but our old buttons are much smaller. Also, how can one delete 200 pictures easily? Thanks, Alan On Wed, May 9, 2018 at 5:08 PM, Alan Tilson wrote: > Hello again Tim, > I agree that our old, sometimes very old, images

Re: Picture Buttons in v16

2018-05-09 Thread Alan Tilson via 4D_Tech
Hello again Tim, I agree that our old, sometimes very old, images are rather tired. So where does one go to find replacements? Alan On Wed, May 9, 2018 at 3:58 PM, Timothy Penner wrote: > Keep in mind that for old PICT images, it is often a better idea to find a > more modern replacement rather

Re: Help with SQL login

2018-05-09 Thread Stephen Shaw via 4D_Tech
Chuck Re: SQL LOGIN(“IP:ipaddress:port:ssl”;"user”;"Userpassword";*) That did it. Thanks! Steve > On 9 May 2018, at 21:50, Charles Miller via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Try adding the port to ip address and I always connect using IP not DB so > connection would look like 19

Re: Help with SQL login

2018-05-09 Thread Charles Miller via 4D_Tech
Try adding the port to ip address and I always connect using IP not DB so connection would look like 192.168.5.12:19812 Regards Chuck On Wed, May 9, 2018 at 4:47 PM, Stephen Shaw via 4D_Tech < 4d_tech@lists.4d.com> wrote: > > > Chuck > > Thanks for answering > > SQL is running and shows the a

Re: Help with SQL login

2018-05-09 Thread Stephen Shaw via 4D_Tech
Chuck Thanks for answering SQL is running and shows the active connection when the code is run from the client I have just copied the code to a single user database and I am on the same network and subnet Steve > On 9 May 2018, at 21:24, Chuck Miller via 4D_Tech <4d_tech@lists.4d.com> > w

Re: Help with SQL login

2018-05-09 Thread Chuck Miller via 4D_Tech
Are you sure that 1. SQL server is running 2. you are trying to connect to same place Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064 mailto:cjm

RE: Standalone application connection to 4D Server

2018-05-09 Thread Timothy Penner via 4D_Tech
> If you use SQL there is no additional licensing needed. This is incorrect; or at least it is misleading... If using SQL, and you do not have an "Unlimited SQL License", then each SQL connection will consume a Client License on the 4D Server. Therefore, if there is no more 4D Client licenses av

RE: Picture Buttons in v16

2018-05-09 Thread Timothy Penner via 4D_Tech
Keep in mind that for old PICT images, it is often a better idea to find a more modern replacement rather than to convert them... http://forums.4d.com/Post/EN/18809015/1/18812276#18812218 "In most cases they look old - in almost all cases it will be a good idea to find a more modern icon/images/

Help with SQL login

2018-05-09 Thread Stephen Shaw via 4D_Tech
Hi all I get an error when using the sql login command from 4D Developer from a stand alone database, but not from a 4D client SQL LOGIN(“4D:DatabaseName”;"user”;"Userpassword";*) If (ok=1) ALERT("Success”) // works on 4d client attached to the database SQL LOGOUT Else

Re: Picture Buttons in v16

2018-05-09 Thread Alan Tilson via 4D_Tech
Hello Tim, The tiny images were just the placeholder images I suppose. When I went through the conversion in v13 and then set the transparency in v16 everything looks normal! And it seems the 0x00FF works both ways. I started without the quotes in my initial effort and then added the quotes to

RE: FN call issues

2018-05-09 Thread Timothy Penner via 4D_Tech
> The function call spawns a process and waits for data to be filled. The > problem is that the process is launched many times even with one call Doesn't the function call get called for each record in the selection. If you only want it to run once, does adding a LIMIT 1 to the sql call help?

Re: Picture Buttons in v16

2018-05-09 Thread Tim Nevels via 4D_Tech
> On May 9, 2018, at 12:23 PM, Alan Tilson wrote: > > Thank you Sannyasin and Keisuke, for sharing the process in converting the > picture library for v16. > However, my results are not good. > Upon opening our system in v16 and going to Pictures almost everything > displays as a camera wtih a red

Re: Picture Buttons in v16

2018-05-09 Thread Alan Tilson via 4D_Tech
Thanks Chuck, Wow, that looks complicated! I did find this code in http://kb.4d.com/assetid=76775 which converts the library to .png in v13: ARRAY LONGINT($PictRef_aL;0) ARRAY TEXT($PictName_aT;0) PICTURE LIBRARY LIST($PictRef_aL;$PictName_aT) $SOA:=Size of array($PictRef_aL) //=

Re: Picture Buttons in v16

2018-05-09 Thread Chuck Miller via 4D_Tech
This is the code we used //Method: dev_convertPicLibToJPEG //Description //convert picture library pictures to JPEG for upgrade to v16 - set transparent background // Parameters // If (User in group(Current user;"Design Access Group")

Re: Picture Buttons in v16

2018-05-09 Thread Alan Tilson via 4D_Tech
Thank you Sannyasin and Keisuke, for sharing the process in converting the picture library for v16. However, my results are not good. Upon opening our system in v16 and going to Pictures almost everything displays as a camera wtih a red X across it and .pict underneath the X. After converting each

Re: Access to Macintosh Accessibility tools from within 4D

2018-05-09 Thread Tom Swenson via 4D_Tech
I believe it was for the Leap Motion controller. _very_ fun plugin. Tom Swenson  > ​I'd check with Miyako. I recall him demoing something he wrote maybe 10 > years ago that allowed 4D to respond to movement. It was cool but I > couldn't think of anything to do with it. > ​ >

Paste (ctrl-v) in textfield doesn't work with focusable listbox

2018-05-09 Thread Piotr Chabot Stadhouders via 4D_Tech
Hi, 4D v16R6 I have a form with a listbox and a textfield When the listbox has the property focusable set, pasting text into the text field via ctrl-v doesn't work (menu item paste DOES work) When I uncheck the focusable property pasting does work Does anybody know about this behavior? I need t

Re: Default Font ? 4D 15.4 & Windows 10

2018-05-09 Thread Jeffrey Kain via 4D_Tech
Sounds like you're not using style sheets. This is what happens in 4D if you assign fonts from the font menu instead of using style sheets in the property list. Could this be the problem? -- Jeffrey Kain jeffrey.k...@gmail.com > On May 9, 2018, at 9:02 AM, Jim Medlen via 4D_Tech <4d_tech@li

Default Font ? 4D 15.4 & Windows 10

2018-05-09 Thread Jim Medlen via 4D_Tech
A very curious issue came up this week on Windows 10 clients. All Fields and variables on a form that do not have a specific Font declared are defaulting to Windings. On the layout the information looks garbled but it is the display font and not the data. Mac clients display the text correctly.