On Server Open Connection Database Method - User Name

Is there a way to get the User Name in the On Server Open Connection Database Method On Server Open Connection Database Method $1 Longint [in]User ID number used internally by 4D Server to identify users GET USER LIST userNumbers Longint array

Menu Bar Associated with Form

Is there a way to programmatically get the Menu Bar associated with a form? FORM GET PROPERTIES does not appear to return the associated Menu Bar. The Menu Bar and other parameters of the form are shown in the Form Properties dialog. Thanks, P.S. We have new phone numbers and extensions -- P

Prevent Client from Sleeping

To: 4d_tech@lists.4d.com From: Jim Medlen Company:Functional Devices, Inc. Subject:Prevent Client from Sleeping Date: Wednesday, August 7, 2019 Looking for ideas or thoughts on generating an event that will prevent the client machine from sleeping? I am trying to prev

Query by Formula Join vs. Comparison

I am trying to do a Query Selection By Formula that links two tables by the filed ItemNum with the condition that the value of a field in the first table does not equal a value in the second table. When I look at the ResultPlan there is a Join on the Price fields even when I used the # compari

Query by Formula Count of Records in Related Table

Is there a way to search using Query by formula and Records in selection ? In other words is it possible to query for records that have no related records or greater than X etc. Thanks, Jim Medlen Computer & Information Systems Functional Devices, Inc. j.med...@functionaldevices.com phone (765

Subject: Re: Amazon EDIFACT/X12 Gateway

Peter, We have an account with OpenText an EDI VAN (Value Added Network) We use their software to Send and receive EDI documents. The incoming EDI Documents are then parsed by 4D and internal records are created We create EDI formate text files as return documents that are exported from 4D to a

Formula as Variable

Is there a way to pass a formula into a method as a variable ? vtFormula:="([ItemDiscounts]BasePrice*(1-([ItemDiscounts]PerCentDiscount*0.01)))" vtSort:="<" ORDER BY FORMULA([ItemDiscounts];Execute text(vtFormula);vtSort) Thanks, Jim Medlen This email was transmitted on 100 percent recycled el

SQL TRIM

I am trying to learn to use SQL in 4D. I wrote the code below to try a test using the TRIM function. I have rewritten this several times but it throws a general parsing error every time. C_TEXT(vText) vText:=" sql Text! " Begin SQL SELECT TRIM(BOTH FROM :VTEXT) INTO :vText ; End

Re: Mojave, dark mode and v17

From: 4D_Tech <4d_tech-boun...@lists.4d.com> on behalf of "4d_tech-requ...@lists.4d.com" <4d_tech-requ...@lists.4d.com> Reply-To: <4d_tech@lists.4d.com> D

2 Factor Authentication

Does anyone know of a method, plugin or component to implement 2 factor authentication ? I am interested in using 2 factor authentication and generating the OTP key URI to be used with Authenticator apps available for smart phones. https://mattrubin.me/authenticator/ https://mattrubin.me/ Th

Alternating Background Colors in a List form

Is there a way to have alternating background colors for a List Form ? Thanks, Jim Medlen Computer & Information Systems Functional Devices, Inc. j.med...@functionaldevices.com phone (765) 883-5538 x 428 fax (765) 883-4262 http://www.functionaldevices.com This email was transmitted on 100 perce

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

Re: Sort Tables and Fields in QR editor

Sujit, The 4D Method to look at is SET FIELD TITLES // ### jwm ### 20171205_1658 // Alphabetically sort Field Names for 4D dialogs vi2:=Get last table number For (vi1;1;vi2) ARRAY TEXT(atFieldNames;0) ARRAY LONGINT(aiFieldNumbers;0) GET FIELD TITLES(Table(vi1)->;atFieldNames;aiFieldNu

USB Communication

Is there a way to communicate via USB directly from 4D v15 ? We have Serial communication set up with traditional serial port COM2 for an external scale. Most scales now com with USB and I have been asked to see if I can update our 4D application to communicate with the scale via USB. Thanks,

Call Chain

Inside the error handling method set by ON ERR CALL is there a way to access the CALL CHAIN similar to GET LAST ERROR STACK so that the Error method could log which method generated the Error? Is there a way to identify the Method that generated the Error? Thanks, Jim Medlen Computer & Inform

Quick Report Sort Field Names

Is there a way to tell the Quick Report Editor to sort the list of Field Names Alphabetically ? The List of fields for the Master Table is sorted by Field number and I was wondering if there was any way to sort the list Alphabetically. Thanks, Jim Medlen Computer & Information Systems Functio

Drop Down Menu Form Event

What is the best Form Event to use with a Drop Down Menus on a form ? Is it better to use On Clicked or On Data Change ? Does On Clicked cause multiple form events when used with a Drop down Menu ? (when opening the menu and when selecting a choice from the menu) Thanks, Jim Medlen Computer

Re: FootRunner

The link that I have used in the past comes back with a 404 Error http://www.footprints-inc.com/FRGold/Docs/index.php Here are the email addresses of two gentlemen that I was talking to about debugging with FootRunner a few months ago. Scott Gelvin E-mail: sc...@footprints-inc.com Philip Ket

Re: 4D Remote hanging at 3am after upgrading to Hi Sierra.

One thing you might try is changing the time that the script runs. If the the script runs successfully at 2:00 AM and the computer hangs at 3:00 AM then the problem is probably not the script. If the computer hangs at the new scheduled time for the script and not 3:00AM then that would lead me

RE: Working 4Dv15 Windows

We had an issue upgrading from v13 to v15 with the MESSAGE command not displaying text on Windows clients. We submitted a bug report and were told it would be fixed in future versions of 4D. The resolution was to wrap methods using the MESSAGE command with SET DATABASE PARAMETER(Direct2D Status

Re: [offish]Volume of mail

I am relatively new to this list so I do not have a perspective on past history but I read the emails every day and have found the list extremely helpful. I have posted a few questions and received helpful advice. I find it much easier to keep up on the mailing list vs. remembering to browse th

How to clear the Menu Bar

What is the best way to Clear or reset the menu bar to prevent multiple menus ? I do not see a Clear or Reset Menu Bar option. I am getting multiple menus displayed when more than one form is open with different Associated Menu Bars. Case: The Form for Orders is open with Menu #3 and I open a m

Re: An efficient printing approach

We use the plugin SuperReport Pro to create similar complex reports. http://www.e-node.net/redir/EN/produit_id_63/SuperReport-Pro.html Thanks, Jim Medlen Computer & Information Systems Functional Devices, Inc. j.med...@functionaldevices.com phone (765) 883-5538 x 428 fax (765) 883-4262 http:/

Max Password Length

What is the maximum Length of a 4D Password ? Thanks, Jim Medlen Computer & Information Systems Functional Devices, Inc. j.med...@functionaldevices.com phone (765) 883-5538 x 428 fax (765) 883-4262 http://www.functionaldevices.com This email was transmitted on 100 percent recycled electrons

Re: Generating Random Numbers

Tim, Thanks for the help. I think that my method was based on your original tech note http://kb.4d.com/assetid=76055 I found the PHP command mt_rand which generates a random number using Mersenne Twister. This function was recommended on several web pages regarding random number generators. U

Generating Random Numbers

Is the 4D Random function considered a good random number generator ? Is there a better 4D function for generating a random number ? I am currently using vi1:=(Random%35)+1 to make a random selection of lower case letters or numbers. I concatenate 8 characters to build a ³random² password which

OBJECT SET EVENTS

Can Form Events for an object be permanently changed via a method ? Is it possible to write a method that will loop through all forms and clear the On Clicked event for every instance of a specific variable permanently ? (incomplete method as an example idea) FORM GET NAMES(atForm_Names) For(

Re: How to detect EOL character in text file (James Crate)

<>vCR:=Char(13) <>vLF:=Char(10) <>vCRLF:=Char(13)+Char(10) vText:=Replace string(vText;<>vCRLF;<>vCR) vText:=Replace string(vText;<>vLF;<>vCR) When parsing text I replace Carriage Return + Line Feed with Carriage Return Then replace Line Feed with carriage return. Then the Line endings are a

Missing Edit Menu

In 4D v13.6 when executing a method from a Menu Item the Menu Bar would have four menus: the Apple Menu, the 4D Menu, the Edit Menu and the Help Menu. In 4D v15.4 when executing a method from a Menu Item the Menu Bar has three menus: the Apple Menu, the 4D Menu, and the Help Menu. The Edit Menu

2017 World Tour Component

Trying to use the PICT_Convert.4dbase from the 2017 World Tour I placed the component in the components folder for 4D v15.4 and received an Error Can¹t load component ³PICT_Convert.4DB Disk NbPart. Type Name Media Type Speed Total Size Description * Name

OffsetCursor / Highlight in Dialog in 4D v13 OS X 10.12

In 4D v13.6 running on OS X 10.12 there is an odd visual behavior with the REQUEST dialog. The cursor in the dialog is visually offset by approximately two character spaces and if the text is highlighted the Highlight color is shifted to the right as well. Has anyone else seen this and is there

Re: 4D Server/4D Client runs just fine in a good VM

Re: 4D Server/4D Client runs just fine in a good VM What VM software and configuration are recommended as an eveironment for 4D client? I am using Parallels on Mac OS X to host a VM running Windows 10 to test the 4D v15 client for an upcoming upgrade from 4D v13 to 4D v15. I am experiencing s

Rebuild Structure File

Is there a way to export all forms and methods from a 4D structure file and import them into a new structure file. We have a Structure file that has been upgraded through multiple versions of 4D that has issues that I do not see when I create a new structure file. The issues are primarily relat