On Server Open Connection Database Method - User Name

[Jim Medlen via 4D_Tech]

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   [in]Corresponding 
unique user ID numbers
These two User IDs appear to be unrelated ???

[ServerLog]UserName is always assigned “UNKNOWN"


  // On Server Open Connection Database Method
C_LONGINT($0;$1;$2;$3)
  // Create a [ServerLog] record
CREATE RECORD([ServerLog])
  //  [ServerLog]UniqueID  set to Auto Increment
  // Save the Log Date and Time
[ServerLog]DateSignOn:=Current date
[ServerLog]TimeSignOn:=Current time
[ServerLog]dtSignOn:=jDateTimeEnter
  // Save the connection information
[ServerLog]UserID:=$1
[ServerLog]ConnectionID:=$2

ARRAY TEXT($atUserNames;0)
ARRAY LONGINT($aiUserNumbers;0)

GET USER LIST($atUserNames;$aiUserNumbers)

$vi1:=Find in array($aiUserNumbers;[ServerLog]UserID)
If ($vi1>0)
[ServerLog]UserName:=$atUserNames{$vi1}
Else
[ServerLog]UserName:="UNKNOWN"
End if

SAVE RECORD([ServerLog])
  // Returns no error so that the connection can continue
$0:=0





Confidentiality Notice:
The information transmitted is intended only for the person or entity to which 
it is addressed and may contain information that is confidential, subject to 
copyright, or constitutes a trade secret. If you are not the intended 
recipient, you are hereby notified that your access is unauthorized, and any 
review, dissemination, distribution or copying of this message including any 
attachments is strictly prohibited. If you are not the intended recipient, 
please reply to the sender and permanently delete the original and any copy, 
including printed copies, of this message and any attachments.
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Menu Bar Associated with Form

[Jim Medlen via 4D_Tech]

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 -- Please update your records.

Jim Medlen
Computer & Information Systems
Functional Devices, Inc.
j.med...@functionaldevices.com<mailto:j.med...@functionaldevices.com>

Main:   (765) 883-5538 x 5735
Direct: (765) 416-6835
FAX:(765) 883-7505

http://www.functionaldevices.com

This email was transmitted on 100 percent recycled electrons

[https://www.functionaldevices.com/www/wp-content/uploads/2019/06/E2596-Made-in-the-U.S.A-Email-Signature.png]<https://www.functionaldevices.com/?utm_source=Email_medium=Email%20Signature_term=USA_content=E2596>

Confidentiality Notice:
The information transmitted is intended only for the person or entity to which 
it is addressed and may contain confidential and/or privileged material. If the 
reader of this message is not the intended recipient, you are hereby notified 
that your access is unauthorized, and any review, dissemination, distribution 
or copying of this message including any attachments is strictly prohibited. If 
you are not the intended recipient, please contact the sender at (800) 888-5538 
and permanently delete the original and any copy including printed copies of 
this e-mail and any attachments. Upon failure to comply with these terms the 
recipient agrees to pay any costs or damages including Attorney's fees and 
consents to service in Howard County, Indiana.
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Prevent Client from Sleeping

[Jim Medlen via 4D_Tech]

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 prevent clients from Sleeping when connected to a 4D server.

The POST KEY and POST EVENT both say "Its effect is as if the user actually 
entered a character on the keyboard.”

but these events do not prevent the screen saver from activating.

It appears that the OS does not see this as a user event.


Thanks,

Jim Medlen

Computer & Information Systems
Functional Devices, Inc.
j.med...@functionaldevices.com<mailto:j.med...@functionaldevices.com>

Main:   (765) 883-5538 x 5735
Direct: (765) 416-6835
FAX:(765) 883-7505

http://www.functionaldevices.com

This email was transmitted on 100 percent recycled electrons

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Query by Formula Join vs. Comparison

[Jim Medlen via 4D_Tech]

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 # comparison.

How do I define a comparison vs a join ?


C_TEXT($vResultPlan;$vResultPath)
DESCRIBE QUERY EXECUTION(True) //analysis mode

Query Selection by Formula([ItemDiscounts];\
( ([ItemDiscounts]ItemNum=[Items]ItemNum) \
& ([ItemDiscounts]BasePrice#[Items]PriceB) \
& ([Items]PriceA#0)))

$vResultPlan:=Get last query plan(Description in text format)
ConsoleMessage("vResultPlan\r"+$vResultPlan)
$vResultPath:=Get last query path(Description in text format)
ConsoleMessage("vResultPath\r"+$vResultPath)

DESCRIBE QUERY EXECUTION(False) //End of analysis mode


vResultPlan
Join on Table : Items  :  ItemDiscounts.ItemNum = Items.ItemNum & 
ItemDiscounts.BasePrice = Items.PriceB
Items.PriceA != 0
vResultPath
Join on Table : Items  :  ItemDiscounts.ItemNum = Items.ItemNum & 
ItemDiscounts.BasePrice = Items.PriceB
Items.PriceA != 0   (3247 records found in 4 ms)
--> 4030 records found in 22 ms

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Query by Formula Count of Records in Related Table

[Jim Medlen via 4D_Tech]

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) 883-5538 x 428
fax (765) 883-4262
http://www.functionaldevices.com

This email was transmitted on 100 percent recycled electrons

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Subject: Re: Amazon EDIFACT/X12 Gateway

[Jim Medlen via 4D_Tech]

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 folder on the client machine.
Those EDI documents are then sent by the OpenText EDI software.

EDI Documents are structured Text documents with guidelines and rules for each 
transaction document.
They are fairly complex but once you are familiar with the formatting it is 
relatively straight forward.

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

On Jan 4, 2019, at 6:39 AM, Peter Jakobsson via 4D_Tech 
<4d_tech@lists.4d.com<mailto:4d_tech@lists.4d.com>> wrote:
Hi
A very happy new year everybody.
I have an ERP running at a customer site who is a big Amazon suppler (i.e. they 
sell products/services TO Amazon). Amazon want them to submit sales invoices 
via their EDIFACT (or X12) gateway.
I’m a bit out of my depth here as I haven’t done any EDI stuff before, although 
I have quite a lot of experience with interfaces in general - ftp, http, etc. 
Where to start !? Does anyone have experience of this that could point out the 
basics or direct me to some useful docs ?
The comms protocol is AS2 so it would seem that the actual connection is done 
over http. I presume it’s then a case of formatting the documents and sending 
them as an http attachment, but that’s as far as I’ve got so far.
Any tips welcome.
Best Regards
Peter


**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Formula as Variable

[Jim Medlen via 4D_Tech]

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 electrons

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

SQL TRIM

[Jim Medlen via 4D_Tech]

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 SQL
ALERT(vText)
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Mojave, dark mode and v17

[Jim Medlen via 4D_Tech]

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>
Date: Tuesday, November 13, 2018 at 3:00 PM
To: <4d_tech@lists.4d.com>
Subject: 4D_Tech Digest, Vol 138, Issue 25

I went through the 4D preferences for Methods Styles and colors and set up a 
Dark Theme set of colors.

The only thing is that 4D does not allow me to change the Highlight color, so 
the system applies a light colored highlight to light text on a black 
background unless I go to System preferences and change the highlight color.

I’m slightly surprised there’s been no response to this from anyone at 4D. Dark 
mode is a pleasant environment in which to write code and it’s curious that 4D 
seems not to support it.

Jeremy


On 6 Nov 2018, at 08:31, Jeremy Roussak via 4D_Tech 
<4d_tech@lists.4d.com> wrote:
Is there a way of getting applications built in v17 - and indeed v17 itself - 
to honour dark mode?
Jeremy

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

2 Factor Authentication

[Jim Medlen via 4D_Tech]

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/

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


**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Alternating Background Colors in a List form

[Jim Medlen via 4D_Tech]

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 percent recycled electrons




**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Default Font ? 4D 15.4 & Windows 10

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

It began after the most recent windows software update.

Any suggestions would be helpful.


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




**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Sort Tables and Fields in QR editor

[Jim Medlen via 4D_Tech]

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;aiFieldNumbers)

SORT ARRAY(atFieldNames;aiFieldNumbers;>)

SET FIELD TITLES(Table(vi1)->;atFieldNames;aiFieldNumbers;*)

End for 


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


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>
Date:  Thursday, February 15, 2018 at 9:53 AM
To:  <4d_tech@lists.4d.com>
Subject:  4D_Tech Digest, Vol 129, Issue 26

Message: 6
Date: Thu, 15 Feb 2018 10:14:50 +
From: Sujit Shah <sujit...@gmail.com>
To: 4D iNug Technical <4d_tech@lists.4d.com>
Subject: Sort Tables and Fields in QR editor
Message-ID:

Call Chain

[Jim Medlen via 4D_Tech]

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




**
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/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Drop Down Menu Form Event

[Jim Medlen via 4D_Tech]

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




**
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/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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

[Jim Medlen via 4D_Tech]

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 to look closer at the script.

We have had issues with writing files to folders where the permissions
would not
allow 4D to access a file in Read Write unless we changed the owner or
permissions
on the folder.

Good Luck.



**
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/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

RE: Working 4Dv15 Windows

[Jim Medlen via 4D_Tech]

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;Direct2D Software)  // Enable
Direct2D fixes message bug with Windows client

// previous code or method

SET DATABASE PARAMETER(Direct2D status;Direct2D Hardware)


We were told the issue had to do with the removal of Direct 2D support

I edit and compile using a Mac so I do not know if it effected the Editor.
>
>Hi All,
>
>I am in the midst of converting 4D Windows-based application from v11 to
>v15 and encountered a strange issue.
>
>When editing a method under v15, all the text are jumbled up.
>I tested with creating a new method, not just methods carried over from
>the past and the effect is the same.
>
>For example, typing a string like " [filename]fieldname := ³.  Once the
>assignment operator is keyed in, the text gets overlaid over the
>beginning characters of the string, making the entire string of text
>illegible.
>
>The text renders well when running under the Mac version.
>It¹s also ok when using a Mac client to access the 4D Server running
>under Windows.
>
>Does anyone know what is the cause and how to rectify this.  Thanks.
>
>
>Regards,
>Ronnie
>Tarawerkz


**
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/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: [offish]Volume of mail

[Jim Medlen via 4D_Tech]

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
the forum looking for current issues and questions.

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


On 10/6/17, 5:07 AM, "4d_tech-boun...@lists.4d.com on behalf of
4d_tech-requ...@lists.4d.com" <4d_tech-boun...@lists.4d.com on behalf of
4d_tech-requ...@lists.4d.com> wrote:

>On 5 oct. 2017, at 18:52, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com>
>wrote:
>I know that many of you have been on this list for a long time, as have
>I.
>I have noticed, over the past couple of years, that the volume of email
>on this list has dropped - a lot -. It used to be, that if I was out of
>the office, or whatever, and unable/unwilling to check email for 1 or
>more days, I could expect to see ~100 emails/day from this list. While
>I have not done an actual count, I believe that currently this list
>sees, on average about 100 emails a week.
>While this might be a good thing (less bugs to report/talk about etc),
>I find it troubling in that it likely reflects a significantly
>diminished use of the 4D product.
>Thoughts, Anyone?
>Chip
>---
>Gas is for washing parts
>Alcohol is for drinkin'
>Nitromethane is for racing


**
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/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

How to clear the Menu Bar

[Jim Medlen via 4D_Tech]

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
modal dialog for printing which has Menu #6 When I close the
modal dialog for printing I now have both Menu # 3 and Menu
# 6 displayed.



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



**
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/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: An efficient printing approach

[Jim Medlen via 4D_Tech]

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://www.functionaldevices.com
This email was transmitted on 100 percent recycled electrons



On 6/30/17, 3:00 PM, "4d_tech-boun...@lists.4d.com on behalf of
4d_tech-requ...@lists.4d.com" <4d_tech-boun...@lists.4d.com on behalf of
4d_tech-requ...@lists.4d.com> wrote:

>An efficient printing approach


**
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/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Max Password Length

[Jim Medlen via 4D_Tech]

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




**
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/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Generating Random Numbers

[Jim Medlen via 4D_Tech]

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.

Using vbOK:=PHP Execute("";"mt_rand";vi1;1;36) in place of
vi1:=(Random%35)+1 works well.

It is fast and has not created any collisions with existing passwords in
initial testing.

vText:=""
vtSet:="abcdefghijklmnopqrstuvwxyz0123456789"

For (vi2;1;8)
  //vi1:=(Random%35)+1
vbOK:=PHP Execute("";"mt_rand";vi1;1;36)  // Mersenne 
Twister
vText:=vText+vtSet[[vi1]]
End for 


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



Confidentiality Notice:
The information transmitted is intended only for the person or entity
to which it is addressed and may contain confidential and/or
privileged material. If the reader of this message is not the intended
recipient, you are hereby notified that your access is unauthorized,
and any review, dissemination, distribution or copying of this message
including any attachments is strictly prohibited. If you are not the
intended recipient, please contact the sender at (800) 888-5538 and
permanently delete the original and any copy including printed copies
of this e-mail and any attachments.





On 6/26/17, 12:54 PM, "Timothy Penner" <tpen...@4d.com> wrote:

>> Is the 4D Random function considered a good random number generator ?
>
>It's OK, it produces a 15-bit random number between 1 and 32,767.
>If you need numbers above 32,767 you can use this:
>http://kb.4d.com/assetid=7
>
>If the built in command doesn't meet your need then you can use PHP (like
>David said).
>
>There is also this plugin: https://github.com/miyako/4d-plugin-PRNG
>
>> I concatenate 8 characters to build a ³random² password which then has
>>to meet a few simple rules.
>
>I wrote this tech tip 7 years ago, maybe it will help:
>http://kb.4d.com/assetid=76055
>
>-Tim PENNER
>
>
>Timothy Penner
>Technical Services Engineer
>
>4D Inc
>95 S. Market Street, Suite #240
>CA 95113 San Jose
>United States
>
>Telephone : +1-408-557-4600
>Standard :  +1-408-557-4600
>Fax :   +1-408-271-5080
>Email : tpen...@4d.com
>Web :   www.4D.com
>
>


**
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/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Generating Random Numbers

[Jim Medlen via 4D_Tech]

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 then has to
meet a few simple rules.

contains a number
contains a lower case letter
No Double characters
Not 3 or more consecutive numbers
The password must be unique.


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



**
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/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

OBJECT SET EVENTS

[Jim Medlen via 4D_Tech]

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(vi1;1;Size of Array(atForm_Names))
 FORM LOAD([tableName]; atForm_Names{vi1})
 ARRAY LONGINT(MyEvents;0)
 Append to Array(MyEvents;On Clicked)
 OBJECT SET EVENTS("srKeyword";MyEvents;Disable events others unchanged)
FORM UNLOAD
End for



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



**
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/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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

[Jim Medlen via 4D_Tech]

<>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 all Carriage Returns.

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




**
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/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Missing Edit Menu

[Jim Medlen via 4D_Tech]

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 is Missing. The ability to copy and paste from the clipboard
is missing.

Is there a way to Enable the Edit Menu when executing a method from a Menu
Item?

Is there a default menu definition that defines which menus are displayed by
default?

Is this a bug in 4D v15.4 ?


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




**
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/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

2017 World Tour Component

[Jim Medlen via 4D_Tech]

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
* NameBSD_ID  Disk_IDNumPart.   Writable
Total Size  FileSystem


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




**
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/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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

[Jim Medlen via 4D_Tech]

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 a work around?

I am in the process of upgrading from v13 but was wondering if there was a
work around
until the upgrade is completed.


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




**
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/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: 4D v13 on Sierra

[Jim Medlen]

An issue that I am aware of is that on Sierra when copying and pasting
into a form field it looks as if there is an additional space after the
highlighted text which is not there. Another way to describe it is that
the curser is not positioned immediately after the text and floats the
distance of a space or half space to the right of the text. Once users
are aware of the issue they simply ignore it.

Jim Medlen


On 1/10/17, 3:00 PM, "4d_tech-boun...@lists.4d.com on behalf of
4d_tech-requ...@lists.4d.com" <4d_tech-boun...@lists.4d.com on behalf of
4d_tech-requ...@lists.4d.com> wrote:

>Is anyone developing in 4D v13 on Sierra - specifically, 10.12.2?  If so,
>are there any issues to be aware of?


**
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/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Easy Key Combination to Open the Explorer

[Jim Medlen]

As mentioned ctrl-k (command-k) opens a method also ctrl-l (command+l)
opens a form.


Is there a key combination that will find / open / goto an object on a
form ?



On 10/12/16, 1:24 PM, "4d_tech-boun...@lists.4d.com on behalf of
4d_tech-requ...@lists.4d.com" <4d_tech-boun...@lists.4d.com on behalf of
4d_tech-requ...@lists.4d.com> wrote:

>There *is* a very easy way to open the Explorer using Ctrl-k - place the
>insertion point on an empty row of text in the method editor, press
>Ctrl-k,
>and 4D opens the Explorer.


**
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/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**