Re: Standalone application connection to 4D Server

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

Re: v13+ LEP permision issues.

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

Re: Standalone application connection to 4D Server

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

RE: v13+ LEP permision issues.

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

Re: Picture Buttons in v16

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,

Re: Picture Buttons in v16

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

Re: Help with SQL login

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

Re: Help with SQL login

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

Re: Help with SQL login

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> >

Re: Help with SQL login

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

RE: Standalone application connection to 4D Server

> 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

RE: Picture Buttons in v16

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

Help with SQL login

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: FN call issues

> 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

> 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

Re: Picture Buttons in v16

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

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

Re: Picture Buttons in v16

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

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

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

Re: Default Font ? 4D 15.4 & Windows 10

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

Default Font ? 4D 15.4 & Windows 10

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