Re: V19 Issues

[Keisuke Miyako via 4D_Tech]

you need to open database settings, compatibility, and activate "save method in 
unicode"

https://discuss.4d.com/t/bug-de-compilation/23267

it seems very few developers are using this list.
only 2 or 3 users have posted in the last couple of years.
the majority of the community discussion has moved to the forums.
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: CONVERT BLOB

[Keisuke Miyako via 4D_Tech]

you must specify the byte value of $vBlob for the correct answer.

it is not a syntax problem.
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: Field calculations

[Keisuke Miyako via 4D_Tech]

or maybe have an array and make the data source of each checkbox

a{1}, a{2}, and so on.

then Count in array.
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: Modern 4D Skills...

[Keisuke Miyako via 4D_Tech]

there is a brand-new training course that features ORDA, project mode and 
panel-based user interface.

https://us.4d.com/training/online-training/build-your-first-4d-application-orda-project-mode

after the webinar you get a workbook, demo project and an 8-part video.

Did you ever get info on your request?
Alan

For those seasoned developers of 4D v2 -> v16, before the days of ORDA,
that want to start programming new projects (or enhancing old projects)
with the current 4D best practices, is there a document that contrasts the
old and new ways of accomplishing common tasks and where the benefit of the
new way is stated? What’s the recommended way to get up top speed on the
new 4D goodness? :)
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: [QUAR] EXCEL CSV conversion

[Keisuke Miyako via 4D_Tech]

let me be more specific:

in my work when I only need to extract values from XLSX, I just use this:

https://github.com/miyako/4d-plugin-xlsxio

xlsx or xls?

**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: [QUAR] Re: EXCEL CSV conversion

[Keisuke Miyako via 4D_Tech]

do you expect xlsx r xls?
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: How to convert date to integer or vice versa

[Keisuke Miyako via 4D_Tech]

triggers!

https://doc.4d.com/4Dv19R5/4D/19-R5/Triggers.300-5831495.en.html

Can you help with the proper method to do so.

**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: How to Sort with Quick Report V17.5

[Keisuke Miyako via 4D_Tech]

the last time I used Quick Report was v2003 so this information might be trash,

but isn't there an option to sort in the contextual menu when you click a 
column?
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: Choice list in a list box

[Keisuke Miyako via 4D_Tech]

if you want to populate the list with values different to the original list 
defined in toolbox

you need to use the command

https://doc.4d.com/4Dv19/4D/19.1/OBJECT-SET-LIST-BY-REFERENCE.301-5653488.en.html

make sure you clear the list when you exit the form.

Where i must populate the choice list?


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

Fwd: Built app in v18 can't find data file

[Keisuke Miyako via 4D_Tech]

https://discuss.4d.com/t/data-file-open-order-bug/14037/2

TL;DR

you might want to check the latest deployment options:

- the build key "dataFilePath"
- new deployment architecture
- the "default data" feature
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: [SPAM] Image from print form

[Keisuke Miyako via 4D_Tech]

you can do that with any command line program that does PDF to image.

there is no need to do it with 4D code.

just use LAUNCH EXTERNAL PROCESS.

I need to convert in image file only one page.
I need to assing a path and name to the image file.

**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: [SPAM] Re: Finding duplicates

[Keisuke Miyako via 4D_Tech]

correction: 

I meant to say, you can't fix records one by one if there are duplicates 
remaining in the database.

> you can't assign a new value to the first found duplicate because it is a 
> duplicate nonetheless.
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: [SPAM] Image from print form

[Keisuke Miyako via 4D_Tech]

if you print to PDF in a single print job, you get a PDF with multiple pages.
if you want each page to be converted to an image file such as PNG or JPEG or 
TIFF,
there are command line tools for that.

you can LAUNCH EXTERNAL PROCESS to invoke the external program.l

2022/03/19 4:26、stardata.info via 4D_Tech 
<4d_tech@lists.4d.com>のメール:

I need that when I print one document, the content of the document goes into 
one image with one name.
One possible solution is that I create a pdf file and after convert the pdf 
file into one image.

**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: [SPAM] Re: Finding duplicates

[Keisuke Miyako via 4D_Tech]

I don't feel like I have enough information to write a code snippet, 
but here are a few thoughts:

1.

I suppose you are aware of DISTINCT VALUES.
but if you suspect that the indexes are somehow corrupt, 
you can no longer trust the command either.

2.

the duplicates could be null.
by definition, you can't index null because it is the absence of a value.
you need to scan all records to know which records are null.
however you can tell that there are multiple nulls if the field is unique and 
there are more records than the number of distinct values plus one.

3. 

instead of Find in array,
you can sort the data set and Find in sorted array.
it is faster.

4. 

prevention is better than treatment.
you can set appropriate field attributes,
set an index,
use Find in field,
to avoid duplicates in the first place.
of course you can always get duplicates after switching data files.
sometimes you might have to disable field constraints in order to fix the 
problem.
for example, if a unique field has more than 3 duplicates,
you can't assign a new value to the first found duplicate because it is a 
duplicate nonetheless.
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: [SPAM] Image from print form

[Keisuke Miyako via 4D_Tech]

you want to conver pdf to picture?
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: Finding duplicates

[Keisuke Miyako via 4D_Tech]

I think you need to be more specific:

what do you mean by "duplicate"
what do you mean by "work the way I want"

I am looking for a simple a method to find duplicates.
A method that would show only the duplicates if they exist or return a message 
if there are no such duplicates.
I already looked in the 4D doc but found nothing that wakers the way I want.
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: [SPAM] Image from print form

[Keisuke Miyako via 4D_Tech]

this command was added in v12.2

https://doc.4d.com/4Dv19R3/4D/19-R3/FORM-SCREENSHOT.301-5583051.en.html

but you must take into account that a screenshot is for displaying on screen.
your listbox, text, shape primitives with all show as bitmap with low 
resolution.

I use 4D V16 on windows.

I need to create an image from a 4d form that contains titles and more
than one list box.

Instead, of creating a pdf document, I need to create an image.

**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: Head-Scratcher!

[Keisuke Miyako via 4D_Tech]

you might want to try v17 32-bit or SET PRINT OPTION + legacy printing layer 
and see if that makes a difference. 

also it would be useful to collect more specific information about the error.
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: Can't Save Record Mandatory field is null

[Keisuke Miyako via 4D_Tech]

you can "export structure" and parse the xml.

I cannot find a way to search for fields with "Reject NULL Values" set to
true. Surely this must be possible, so can someone please let me know how
to do it?

**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: Current User and 4D User on Server Are Different

[Keisuke Miyako via 4D_Tech]

the current user alias is recorded in the journal.

https://blog.4d.com/who-did-what-store-user-aliases-in-the-journal/

2) What gets recorded in the journal file?

**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: Web Service "items" Declaration

[Keisuke Miyako via 4D_Tech]

if your data type is not a simple array or scalar variable
you might have to use

Is DOM reference

or

Is XML

https://doc.4d.com/4Dv18/4D/18.4/SOAP-DECLARATION.301-5232871.en.html


after all, SOAP DECLARATION converts classic 4D commands such as C_TEXT or 
ARRAY TEXT to WSDL.

anything you can't define as a parameter or return value in 4D can't be 
converted automatically to a web service,

that said, you can already create your own web service REST/SOAP API without 
using any of the SOAP commands.

the SOAP feature was created when 4D didn't really have XML commands.

’m not finding any clues
in the documentation.

**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: Problem moving SSL cert to a new Amazon server

[Keisuke Miyako via 4D_Tech]

isn't the certificate issued for a specific domain or IP address?

Any idea what the cause might be?

**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: Odd Runtime Error in Design

[Keisuke Miyako via 4D_Tech]

you can literally Google "RUNTIME_EXPLORER_HDL" and find ACI0101576

> Error when executing the method "RUNTIME_EXPLORER_HDL (runtime)" at line 
> number 239

**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: Compiled Structure does not Match Data

[Keisuke Miyako via 4D_Tech]

The structure and data files do not correspond to each other. The data
file cannot be opened with this structure."
That's a holdover from when 4D used the "WEDD" resource but that went away
after 2004.

the WEDD resource was indeed a token that was used to match a structure file to 
a data file,
by default it was empty but it could be edited with 4D Customizer Plus.
a UUID is used since v11 as an internal signature to check that the data file 
corresponds to the structure file.

the structure file is itself a database and "Resources" is one of its internal 
tables.
the error is effectively saying that the structure file can not be modified.
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: Compiled Structure does not Match Data

[Keisuke Miyako via 4D_Tech]

that will happen if you upgrade a structure file, then upgrade its data file, 
and try to use the 2 files.

that is not allowed.

you must either migrate both the structure and the data to v11+ at the same 
time, or
use the already upgraded v11+ structure file to migrate the pre-v11 data file, 
or
place the catalog file generated during the initial migration next to the data 
file when performing the 2nd migration for data.

the way it works is that during a migration to v11+, a new UUID is assigned to 
the structure file and its data file.
that means if you perform a migration more than once, each file will have a 
different UUID assigned.
when you open a pre-v11 data file using a post-v11 structure file, the data 
file will inherit its UUID from the structure file so there no problem.
you have a problem when the files are converted independent of each other.
to explicitly assign a UUID that was issue during an earlier migration  you 
must place the catalog file next to the data file.

if you still have the data file that is not converted yet, you can use the 
desired structure file or a catalog file to assign the same UUID.
if you have already made significant changed and a retry is not an option, you 
are in trouble.

I made a simple tool to directly over write the UUID but it is a last resort.

https://github.com/miyako/4d-utility-uuid-manager

The structure and data files do not correspond to each other. The data file 
cannot be opened with this structure.

**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: Import from an Excell files

[Keisuke Miyako via 4D_Tech]

does view pro really support xls?

I thought it only accepted xlsx.
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: "Search References" Behavior Change

[Keisuke Miyako via 4D_Tech]

what you explain might already be corrected in ACI0101890 (v19 and R2)

it has been described as 

ACI0101890  [Design mode] Method: selected part of a method name no more 
searched for edition (whole name searched)

before the fix, there was a difference between right-clicking a token with or 
without the whole text selected.

> Has anyone else seen this? Is there a way to get the old behaviour back?

**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: "Search References" Behavior Change

[Keisuke Miyako via 4D_Tech]

I was not part of the decision making process, 
honestly, I was unaware that such changes were made.

but suppose you do

$aMethod:=Formula(a_project_method($pointerA;$pointerB))

in one place, then

$ctx.aMethod:=$aMethod

in another,

then, say

DIALOG("a_form";$ctx)

and 

Form.aMethod() // what is this?

what is the expectation for a command+K on the member function?

it seems very hard to associate a member method to its formula,
it could be an expression, a method with statically bound parameters, etc.
it could change over time, it could be a component method, 
it could be defined differently at runtime, depending on the control flow.
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: Duplicate Primary Key

[Keisuke Miyako via 4D_Tech]

yes, the previous suggestion might be just fine,
but SQL seems better for several reasons

- the primary key could be integer 64-bits which is not handled in the other 
example
- all records+order by creates 2 current selections in the other example, none 
in this one
- clean code, the intent is apparent

in both cases the assumption is that no other process is actively adding 
records 
(no need to code explicitly, you are running maintenance and it is a one shot 
operation)

> I would not do this. I would
> begin sql
> Select MAX ([table].[field])
> from
> [table]
> into
> :$max
> end sql

**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: Duplicate Primary Key

[Keisuke Miyako via 4D_Tech]

tou can bump the sequence number generator for a table with set database 
parameter.
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: Run v15.4 in demo mode

[Keisuke Miyako via 4D_Tech]

by the way, evaluation licenses are only issued for the latest version.

the last version that had a "demo mode" with restrictions on the number of new 
records and tables was v2003.
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: Run v15.4 in demo mode

[Keisuke Miyako via 4D_Tech]

the partner program should include licenses for all versions going back to the 
version that was current at the time of joining the program, if membership has 
been renewed continuously.

did you check "my licenses" online?


**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: setting row and cell color in entity selection listboxes

[Keisuke Miyako via 4D_Tech]

for clarification:

the reason for using the Form object, as in Form.meta, is to be memory 
efficient.
if you only have 3 possible paint patterns, it would be more efficient to 
create the objects in advance:

e.g.

$meta:=New collection(New object;New object;New object;New object;New 
object;New object)
$meta[0].stroke:=selected_stroke  //"#ff"
$meta[0].fill:=selected_fill_blue  //"#61778e"
$meta[1].stroke:=selectable_stroke  //"automatic"
$meta[1].fill:=unselected_fill  //-1
$meta[2].stroke:=unselected_stroke_dark_red  //"#ff6600"
$meta[2].fill:=unselected_fill  //-1
$meta[4].stroke:=selected_stroke  //"#ff"
$meta[4].fill:=selected_fill_dark_red  //"#bd967d"
$meta[3].stroke:=unselectable_stroke  //"#d3d3d3"
$meta[3].fill:=unselected_fill  //-1
$meta[5].stroke:=selected_stroke  //"#ff"
$meta[5].fill:=selected_fill_grey  //"#a3a3a3"
Form.meta:=$meta

then you can select and return the appropriate meta in your meta expression 
method.

of course, you can always return a new object like

$0:=new object(“stroke”;”orange”)

which is not incorrect, it is just not optimised.
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: setting row and cell color in entity selection listboxes

[Keisuke Miyako via 4D_Tech]

 I activated on display detail.

activating On Display Detail is optional. it is not required for Meta Exp. to 
work.

 but your Color method is wrong.

you basically need as many meta objects as the number of different colour 
combinations to display at the same time.
in your code you have just one meta (Form.meta) so you have a palette of one.
meta objects don't stick on screen, if you assign a new value to Form.meta it 
will change all cells that lookup the same meta.

2021/08/10 23:43、Michael Ferguson via 4D_Tech 
<4d_tech@lists.4d.com>のメール:
I set Form.meta as the meta info expression in the listbox.On display detail I 
called my color method which returns an object to the on display event.

**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: setting row and cell color in entity selection listboxes

[Keisuke Miyako via 4D_Tech]

the meta expression is evaluated during the On Display Detail event.

that would be all the rows visible on screen, plus a cache of rows prefetched 
for vertical scroll.

typically that would be the same number as the rows visible on screen.

how to bind:

you create a project method, then enter that method name in the property list.

> Thank you Miyako. That was helpful. However the documentation does not 
> illustrate the context in which the row coloring method is called. Would the 
> method be added to the column expression? Otherwise, I don’t see a way to 
> “bind” it to the listbox or a listbox column.

**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: setting row and cell color in entity selection listboxes

[Keisuke Miyako via 4D_Tech]

if you are looking for practical examples:

https://blog.4d.com/display-a-collection-in-a-listbox/

every essential feature since v16 has a featured blog post, often with a video 
and/or sample code.
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: New Online Manuals

[Keisuke Miyako via 4D_Tech]

its a github repo.

https://github.com/4d/docs

you can fork it.
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: v18 Background Image / Win32API

[Keisuke Miyako via 4D_Tech]

the plugin only has a Windows64 folder

https://github.com/OrchardSoftware/4D-Win64API/tree/master/Win64API.4dbase/Plugins/Win64API.bundle/Contents

so it is not for 32-bit.
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: 4D scanning

[Keisuke Miyako via 4D_Tech]

the minimum version is v17.

v16 and earlier does not support object/collection plugin parameters.

it would have to be rewritten to use JSON text instead.

2021/06/24 20:03、Peter Mew via 4D_Tech 
<4d_tech@lists.4d.com>のメール:
Thanks for the detailed instructions. I got led astray by the dmg file
showing "no mountable file systems" the zip unpacks fine.
can you tell me which is the last version to work with 4D v13.6

**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: Communicating with external electronics

[Keisuke Miyako via 4D_Tech]

maybe it is using ActiveX

https://en.wikipedia.org/wiki/ActiveX

the script could be invoking another OCX component that does the actual heavy 
lifting. just a guess.

2021/06/24 7:56、nug via 4D_Tech 
<4d_tech@lists.4d.com>のメール:
The scripts, and (as far as I can tell) all the software is in-house and 
proprietary.

**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: v18 Background Image / Win32API

[Keisuke Miyako via 4D_Tech]

the plugin replaces the background by intercepting the PAINT event for the MDI 
window.

4D is Altura-free since v17

https://blog.4d.com/complete-windows-64-bit-product-line-is-now-altura-free/

which drastically changes how (or if at all) plugins can "hack" the GUI.

I think it might just be better to migrate the application to SDI mode if you 
don't like the MDI window.

https://doc.4d.com/4Dv18/4D/18/SDI-mode-on-Windows.300-4575510.en.html

2021/06/24 7:38、Ben Sokal via 4D_Tech 
<4d_tech@lists.4d.com>のメール:
Since Win32API now seems to be obsolete, how can we easily set the background 
image ala gui_LoadBackground? I tried the Miyako replacement on github at 
https://github.com/miyako/4D-Win32API/releases/tag/8.3.v18 but it did not seem 
to work (I think the command ran but the background did not change). How have 
you handled setting a background image change after upgrading 4D to latest 
versions?
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: Communicating with external electronics

[Keisuke Miyako via 4D_Tech]

I suppose the scripts are written in Python or some other language.

the script language is probably not important. 
I imagine it is published as a "language neutral" sample code,
not as a Software Development Kit or middleware.

you might even be able to translate it to native 4D for HTTP or RS-232C, 
NTK for TCP, UDP, etc. 
I would not recommend Internet Commands for new development.

it is more important to know the communication protocol for the device.

> 2021/06/24 7:18、nug via 4D_Tech <4d_tech@lists.4d.com>のメール:
> I would need to be able to communicate (from windows 10) to an external 
> electronic board.
> running 'scripts' (do not know if the scripts will exist (LEP) or will need 
> to be written (4D).
> I would need to run these scripts, to run tests on another piece of 
> electronics
> 4D --> board --> electronic device
> device --> return results of tests to board --> to 4D
> I have not done this type of device manipulation in the past.
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: 4D scanning

[Keisuke Miyako via 4D_Tech]

you can click on "Releases" and select a release by tag

https://github.com/miyako/4d-plugin-twain-v2/releases/tag/3.4.0

also there is a prebuilt binary, preinstalled in the sample DB when you get the 
source repository.

also you can unarchive the .zip or .dmg that comes with the source repository.

---

there are several ways to communicate with a scanner

ICA the standard on Mac and WIA is the new standard on Windows.
some hardware vendors may not provide a TWAIN driver for Windows.
I am unaware of any TWAIN scanners for Mac.

2021/06/24 6:26、Peter Mew via 4D_Tech 
<4d_tech@lists.4d.com>のメール:
Id quite like to try Miyakos Twain PlugIn 4d-plugin-twain-v2
How do I get a Binary for this. Ive been to Git Hub but cant see any way to
just download the plug in.

**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: HTML attachment in an email from 4D V17 mac/pc

[Keisuke Miyako via 4D_Tech]

I would focus on the email source (MIME) rather than code in 4D.

if the email client forever downloading (it probably isn't)

I suspect base64 is broken. 
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: 4d Graph 8 series limit

[Keisuke Miyako via 4D_Tech]

I think at this point the GRAPH command is a lost cause.

instead, you really use the web area.
after all, it is more than 50% of the total app size (no kidding).
chart.js is well documented and easy to use.

> 2021/05/15 0:23、Andrea via 4D_Tech <4d_tech@lists.4d.com>のメール:
> I need to draw a graph for a period of 7 days data, but each day should have 
> 18 bars.
> 4D stops at 8 bars.
> Anyone knows how to solve the 8 series limit with 4D bar Graph?

**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: Miyako's plugin vs CryptoKey

[Keisuke Miyako via 4D_Tech]

doc here

https://developer.4d.com/docs/en/API/CryptoKeyClass.html

CryptoKey was added in v18 R4
it's a class, you need to be in project mode
it's a generic crypto tool but designed specifically for JWT tokens

in other words, the hash function is not a standalone feature;
you can not hash any arbitrary data, you can only hash a CryptoKey instance 

supported encryption algorithms: 

ES256, ES384 and ES512 (ECDSA)
RS256, RS384, RS512 (RSA)
PS256, PS384 (PEM)

supported digest algorithms: 

SHA256, SHA384, SHA512

notice HS@is not supported.

---

for hash there is Generate digest but again, no HMAC

https://doc.4d.com/4Dv17/4D/17.5/Generate-digest.301-5255934.en.html
 

**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: 4D Server

[Keisuke Miyako via 4D_Tech]

there should be a "factory settings" button to erase the settings for good.

2021/04/29 17:20、Miguel Gonzalez via 4D_Tech 
<4d_tech@lists.4d.com>のメール:
That's why I've used the database parameter so I can decrease those values.

**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: 4D Server

[Keisuke Miyako via 4D_Tech]

yes, the sole purpose of the CPU priority pane in database settings 
is so that you can unset whatever configuration (high, low, doesn't matter)
that is stored in the structure file. using "set database parameter" 
to adjust the settings can only make the scheduler work harder 
for no gain in performance. 

if I remember correctly, 
the setting had utility on MacOS (7 to 9, not X) 
to make 4D Server run a little less slow.
it generally has detrimental effect on version > 2003.
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: v17.5 Explorer Window - how to delete prefs

[Keisuke Miyako via 4D_Tech]

you can also open the Explorer holding down the shift key.
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: [4D v18.3; Mac {10.13.6} + {10.15.7}] LEP-voodoo

[Keisuke Miyako via 4D_Tech]

actually the database kind doesn't matter, there is nothing to do for the 
structure file or project.

it is the app that needs to be notarised.

the rules discussed so far are common to all apps, nothing is specific to 4D.
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: [4D v18.3; Mac {10.13.6} + {10.15.7}] LEP-voodoo

[Keisuke Miyako via 4D_Tech]

info.plist and entitlements are 2 different entities.

the com.apple.security.device.camera key needs to be in entitlements, not 
info.plist.
info.plist is where you add NSCameraUsageDescription.

if you use a code editor to edit either plist file,
you might want to "plutil -convert xml1" to normalise the file first.
in general, using a tool other than Xcode will invalidate the plist file.

but again, all of that is done automatically in the GitHub example I shared 
earlier.
you just have added your Apple Developer password to keychain for it to work.

https://miyako.github.io/2019/06/17/notarization.html
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: [4D v18.3; Mac {10.13.6} + {10.15.7}] LEP-voodoo

[Keisuke Miyako via 4D_Tech]

the "--primary-bundle-id" you pass to "xcrun altool" is actually unrelated to 
the app's bundle id; it can be any string and it does not have to unique.

2021/03/25 11:31、James Crate via 4D_Tech 
<4d_tech@lists.4d.com>のメール:
just assumed notarization would require a different bundle ID. I guess the 
combination of bundle ID + developer ID would still be unique, but I guess I 
just assumed that Apple wouldn’t let that happen.

**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: [4D v18.3; Mac {10.13.6} + {10.15.7}] LEP-voodoo

[Keisuke Miyako via 4D_Tech]

> Does the —deep option actually work anymore? The signing script I use for an 
> app compiled with runtime has to sign every executable component in the built 
> app. 

yes it works.
I use --deep to sign every framework, bundle, plugin from the inside out.
think of it like sealing smaller boxes before putting them inside a larger box 
and then an even larger box.

the problem with --deep is that it might miss a few components in case of a 
complex package
and that you can not customise the signature of each component inside the app 
(their entitlements in particular).

you can try to --deep sign the app in one shot, it may or may not work.

>  have to completely re-sign and notarize a 4D app, which will likely require 
> changing the bundle ID in the info.plist

there is no need to touch the bundle ID for code signing or notarisation.
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: [4D v18.3; Mac {10.13.6} + {10.15.7}] LEP-voodoo

[Keisuke Miyako via 4D_Tech]

like I posted earlier, all the steps are implemented in the example:

https://github.com/miyako/4d-utility-build-application

2021/03/21 15:41、Jörg Knebel via 4D_Tech 
<4d_tech@lists.4d.com>のメール:
Could you offer a step by step explanation because this is all new to me.

**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: [Fun] Special Query ORDA Replacement

[Keisuke Miyako via 4D_Tech]

the general idea is like this:

If (False)  //create sample data
ds.xFieldInfo.all().drop()

$exFieldInfo:=ds.xFieldInfo.new()
$exFieldInfo.TableIDRef:=Table(->[Table_1])
$exFieldInfo.FieldID:=Field(->[Table_1]Field_2)
$exFieldInfo.save()

$exFieldInfo:=ds.xFieldInfo.new()
$exFieldInfo.TableIDRef:=Table(->[Table_1])
$exFieldInfo.FieldID:=Field(->[Table_1]Field_3)
$exFieldInfo.save()

$exFieldInfo:=ds.xFieldInfo.new()
$exFieldInfo.TableIDRef:=Table(->[Table_1])
$exFieldInfo.FieldID:=Field(->[Table_1]Field_4)
$exFieldInfo.save()
End if

vtxtSearch1:="a"
vtxtSearch2:="b"
vtxtSearch3:="c"

$esxFieldInfo:=ds.xFieldInfo.all()

$count:=0
$criteria:=New collection
$params:=New object("attributes";New object;"parameters";New object)
For each ($exFieldInfo;$esxFieldInfo)
$count:=$count+1
$parameter:="vtxtSearch"+String($count)
$searchptr:=Get pointer($parameter)
If (Value type($searchptr->)=Is text)
If ($searchptr->#"")
$attribute:=Field name($exFieldInfo.TableIDRef;$exFieldInfo.FieldID)
$params.attributes[$attribute]:=$attribute
$params.parameters[$parameter]:=$searchptr->
$criterium:=":"+$attribute+" == :"+$parameter
$criteria.push($criterium)
End if
End if
End for each

vptrCurrentTable:=->[Table_1]

$es:=ds[Table name(vptrCurrentTable)].query($criteria.join(" and ");$params)

---

when you call query(),

$criteria would contain

[:Field_2 == :vtxtSearch1,:Field_3 == :vtxtSearch2,:Field_4 == :vtxtSearch3]

$params would contain

{attributes:{Field_2:Field_2,Field_3:Field_3,Field_4:Field_4},parameters:{vtxtSearch1:a,vtxtSearch2:b,vtxtSearch3:c}}

---

for more info see:

https://doc.4d.com/4Dv18/4D/18.4/dataClassquery.305-5233999.en.html
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: [4D v18.3; Mac {10.13.6} + {10.15.7}] LEP-voodoo

[Keisuke Miyako via 4D_Tech]

I’ll use the terminal to sign what ever has to be signed that enables me to 
continue developing:
codesign --deep --force --verbose --sign "” $Path/To/My/Development

the above code unfortunately will not grant access to the camera because it is 
missing 2 critical elements:

1. edit "info.plist" to explain what the app needs the camera for
2. supply an entitlements file that will be embedded in the code signature

for examples see https://github.com/miyako/4d-utility-build-application

in addition, the use of "deep" (sign from the outside in) and "force" 
(over-write existing signature of plugins and frameworks)
can work against your objective. again, the above example shows how to sign 
from the inside out.

4D itself does not need access to the camera in order to fully function,
it is understandable that 4D does not have the permission by default.

it is not just Apple, the world's view on privacy and surveillance has much 
evolved in the past decade.
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: [4D v18.3; Mac {10.13.6} + {10.15.7}] LEP-voodoo

[Keisuke Miyako via 4D_Tech]

I will answer in place of Armin;

yes, it does not matter if you are in development or production, compiled or 
interpreted.
access to the camera requires entitlements, code signature, notarisation, and 
not of the plugin, but of the app (4D) itself.

Since Keisukes Cupturev2-Plugin does not work either on Catalina and 4Dv18,

if you satisfy the aforementioned requirements, the plugin will work on 
Catalina and 4D v18.

2021/03/06 19:36、Jörg Knebel via 4D_Tech 
<4d_tech@lists.4d.com>のメール:
Even if I’m still at the development/debugging state, meaning not compiled and 
not even closed to deployment?

**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: Big Sure Application file returning weird information

[Keisuke Miyako via 4D_Tech]

sounds like your application has been translocated,
running in a sandboxed folder to protect the system.

that happens if you drag and drop
4D, 4D Server, 4D Volume Desktop
out of the mounted disk image to applications.

you should install 4D and 4D Server in applications or one of its subfolders but
Volume Desktop (if you need it) to documents, because it is not an actual app.
(with 18 R5 or macOS before 10.15.5 it is okay to install all under 
applications)

alternatively you can remove all code signature with

xattr -rc (path to app)

even if you allow 4D for GateKeeper

https://download.4d.com/Documents/Products_Documentation/LastVersions/Line_18.3/VIntl/4D_v18_3_HF2_ReleaseNotes.pdf

that doesn't mean you escape sandboxing.

**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: POSITION COMMAND

[Keisuke Miyako via 4D_Tech]

you can also use Split string for processing paths.
it works like Position with * but you don't have to iterate.

https://doc.4d.com/4Dv18/4D/18.4/Split-string.301-5233802.en.html

search character \ into one path.

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

Fwd: Importing PDFs into 4D Win v17R6 - v18 and converting

[Keisuke Miyako via 4D_Tech]

I posted an Xpdf plugin

https://miyako.github.io/2020/04/19/4d-plugin-xpdf.html

but you need to consider that the license is GNU GPL

https://en.wikipedia.org/wiki/Xpdf
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: Lost autocomplete for constants

[Keisuke Miyako via 4D_Tech]

the spec was originally published in the appendix of v13 upgrade reference.

but it might be easier to work off an example.

https://github.com/miyako/4d-plugin-mdi/blob/master/MDI/constants.xlf

I use UUIDs to avoid conflicts with constants from different plugins, 
components, etc.

as you can see, groups and constants are not defined in an XML hierarchy.
they are linked by d4:groupName.

2021/01/19 4:33、Bob Finnerty via 4D_Tech 
<4d_tech@lists.4d.com>のメール:
And BTW, anyone point me to the xlf definition for a constants file (or
have a blank)?
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: PING of life...

[Keisuke Miyako via 4D_Tech]

go to preferences,

select interface,

switch theme to "dark"

https://imgur.com/OLQ6jVg

**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: Remember password

[Keisuke Miyako via 4D_Tech]

Hi

there is a checkbox in database settings / security

Users can change their password
Display User List in Password Dialog Box

deactivating these will give you a different login dialog.

https://doc.4d.com/4Dv18/4D/18/Security-page.300-4575477.en.html

**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: DISPLAY NOTIFICATION

[Keisuke Miyako via 4D_Tech]

isn't there a setting for action centre and notifications in

https://support.microsoft.com/en-us/windows/change-notification-settings-in-windows-10-ddcbbcd4-0a02-f6e4-fe14-6766d850f294

https://support.microsoft.com/en-us/windows/change-notification-and-action-settings-in-windows-10-8942c744-6198-fe56-4639-34320cf9444e

2020/12/14 2:14、stardata.info via 4D_Tech 
<4d_tech@lists.4d.com>のメール:
From some days, in one pc with windows 10 no display windows apparess after 
DISPLAY NOTIFICATION command.
Someone know the settings to check?

**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: Record locking woes

[Keisuke Miyako via 4D_Tech]

If you CUT NAMED SELECTION when there is a loaded current record,
the current selection will be reduced to 0
but the current record will remain loaded (and locked) outside the current 
selection.

2020/12/11 2:38、Alan Tilson via 4D_Tech 
<4d_tech@lists.4d.com>のメール:
there are zero records of this table in the selection but one is locked.

**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: Running AppleScripts from 4D under Catalina

[Keisuke Miyako via 4D_Tech]

it depends on how you implement automation.
are you calling osascript via launch-external-process?

to control the Mail app, normally you need to use 
AEDeterminePermissionToAutomateTarget
https://github.com/miyako/4d-plugin-apple-file-promises/blob/master/apple-file-promises/4DPlugin.cpp

to prompt the "4D is requesting permission to..." dialog and ask for the user's 
permission.
if the user agrees, the app will be added to the list of granted apps in system 
preferences/security/privacy. 

this is only for Apple apps, I think Outlook does't care.
if neither apps are responding, the reason must be something else.

> 2020/12/04 5:30、Peter Adam via 4D_Tech <4d_tech@lists.4d.com>のメール:
> I have an app where when the user wants to send an email from 4D, the program 
> builds an AppleScript to communicate with either Mail or Outlook.
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: MILLISECONDS

[Keisuke Miyako via 4D_Tech]

correction:

LOG EVENT(Into 4D diagnostic log;"some message")

> LOG EVENT(Into 4D commands log;"some message")

**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: MILLISECONDS

[Keisuke Miyako via 4D_Tech]

It depends on what you want to measure and with what level of precision.

computer uptime

TIckcount: ticks
Milliseconds: milliseconds
Get system info (v18) uptime: seconds

application uptime

Get application info (v18) uptime: seconds

time

TImestamp (v17): milliseconds

---

if the unit is right but the starting point is not, I suppose you can subtract 
the delta by storing the anchor value.

---

for logging, you can also take advantage of built-in features.

e.g.

SET DATABASE PARAMETER(Diagnostic log recording;1)
LOG EVENT(Into 4D commands log;"some message")

---

you are kindly reminded that this list is no longer the primary source of 
information for many member of the community.

visit https://discuss.4d.com

**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: SVG Replacement for "GRAPH TABLE"

[Keisuke Miyako via 4D_Tech]

 Hello,

the GRAPH command accepts a picture variable (instead of a graph=4D chart type) 
and produces an SVG graph.
in that capacity, the commands is still supported.

G. TABLE is deprecated but you can create an array based on the current 
selection and pass the data to GRAPH.

https://doc.4d.com/4Dv17/4D/17.4/o-GRAPH-TABLE.301-4883239.en.html

for settings, you can still use GRAPH SETTINGS which accepts lots of parameters

https://doc.4d.com/4Dv17/4D/17.4/GRAPH-SETTINGS.301-4883240.en.html

alternatively you can pass a settings object directly to GRAPH.

https://doc.4d.com/4Dv17/4D/17.4/GRAPH.301-4883241.en.html

2020/11/05 11:11、Kenneth Geiger via 4D_Tech 
<4d_tech@lists.4d.com>のメール:

I’ve inherited an ancient 4D App that was last updated-to 4D v12. My customer 
wants me to make it compatible with modern 4D Versions. I opened it in 4D v15 
and have replaced all the obsolete stuff except for two calls to “GRAPH TABLE”. 
I understand that I need to replace this with SVG. Any direction would be most 
appreciated.
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: Active4D & Java Web Tokens

[Keisuke Miyako via 4D_Tech]

There is a native class for that

https://developer.4d.com/docs/en/API/cryptoClass.html

P.S.

you are kindly invited to visit the new forums:

https://discuss.4d.com

2020/08/27 6:03、Doug Hall via 4D_Tech 
<4d_tech@lists.4d.com>のメール:
Thanks for any help you can provide.

**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: Can't Disable Catalina Prompt "Do you want the Applicaiton "ApplicationName" to accept incoming network connections?

[Keisuke Miyako via 4D_Tech]

developer certificates work similar to HTTPS certificates.

you can obtain a certificate that has Apple has its root authority.
you can also sign an app with a self-signed certificate and let the user add 
you to their local keychain.

2020/08/22 14:22、Chip Scheide via 4D_Tech 
<4d_tech@lists.4d.com>のメール:
if I recall correctly you can not sign/noterize an application without paying 
apple $.

**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: Can't Disable Catalina Prompt "Do you want the Applicaiton "ApplicationName" to accept incoming network connections?

[Keisuke Miyako via 4D_Tech]

I am not 100% sure, but I think macOS GateKeeper (spctl) does not discriminate 
between apps that all share the app ID.

in other words, if a recently downloaded copy of 4D is caught by the system and 
deemed untrustworthy for any reason,
that indictment affects all installed copies of 4D on that computer including 
those that were preciously cleared.

you can search "reset spctl" for more information.


> 2020/08/18 15:27、Bernd Fröhlich via 4D_Tech <4d_tech@lists.4d.com>のメール:
> Any suggestions on what I need to do to get the prompt to stop popping 
> up is greatly appreciated.

**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: Get 4D file(Last backup file) v17.4 returning wrong file path

[Keisuke Miyako via 4D_Tech]

in v18 it is backupHistory.json, I think.

https://doc.4d.com/4Dv18R3/4D/18-R3/Configuration-and-trace-files.300-4919427.en.html

2020/08/19 9:21、Dave Nasralla via 4D_Tech 
<4d_tech@lists.4d.com>のメール:
This makes me think something got corrupt. Do you know where the "Last
backup file" path information is stored?

**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: Get 4D file(Last backup file) v17.4 returning wrong file path

[Keisuke Miyako via 4D_Tech]

sidebar

technically you should move your fresh 4BK file after On Backup Shutdown, not 
during,
because 4D updates the backup history json file following the database event,
and a  missing backup file will trigger a runtime error.
one way to avoid this is to start a new process and wait a little before moving 
the backup.

I can't answer your question about Get 4D file + Last backup file
other than to assume that the information is only updated after On Backup 
Shutdown.

https://doc.4d.com/4Dv18R4/4D/18-R4/Get-4D-file.301-4982837.en.html

2020/08/19 5:44、Dave Nasralla via 4D_Tech 
<4d_tech@lists.4d.com>のメール:
In my "On Backup Shutdown" method I wanted to copy the backup file to
another disk.
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: Can't Disable Catalina Prompt "Do you want the Applicaiton "ApplicationName" to accept incoming network connections?

[Keisuke Miyako via 4D_Tech]

try

xattr -rc {path_to_app}

from Terminal to clear all extended Finder attributes.

2020/08/18 5:11、Randy Kaempen via 4D_Tech 
<4d_tech@lists.4d.com>のメール:
What if you just want to use it on your own computer.

**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: Can't Disable Catalina Prompt "Do you want the Applicaiton "ApplicationName" to accept incoming network connections?

[Keisuke Miyako via 4D_Tech]

Did you code sign and notarise your application?

These are mandatory steps to distribute an app over the internet.

2020/08/18 1:02、Ken Eyring via 4D_Tech 
<4d_tech@lists.4d.com>のメール:
Any suggestions on what I need to do to get the prompt to stop popping up is 
greatly appreciated.

**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: CHANGE LIST VALUES FOR EVERY LISTBOX ROW

[Keisuke Miyako via 4D_Tech]

you can not change the content of a list that is already attached to a listbox 
column.

you need to call

OBJECT SET LIST BY REFERENCE
 or
OBJECT SET LIST BY NAME

if this is an entity selection or collection list box,
you may also need to touch the data source i.e.

form.whatever:=form.whatever

P.S.

you should really consider migrating to discuss.4D.com.

this list is almost inactive.

2020/08/16 17:35、stardata.info via 4D_Tech 
<4d_tech@lists.4d.com>のメール:
Someone has a suggestion?
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: ON MOUSE ENTER

[Keisuke Miyako via 4D_Tech]

Hello,

you can pass the MouseX and MouseY coordinates to LISTBOX GET CELL POSITION
https://doc.4d.com/4Dv18R4/4D/18-R4/LISTBOX-GET-CELL-POSITION.301-4982982.en.html
then you can look up the header direction (0, 1, or 2) that corresponds to the 
column.

P.S. you are invited to join discuss.4D.com!

2020/08/13 0:32、stardata.info via 4D_Tech 
<4d_tech@lists.4d.com>のメール:
I need to know the arrow number of a list box, when the event " On Mouse Enter 
" enter in one row.
Now i use the command OBJECT Get pointer but he not work.
Someone know how i can do?
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: Removing an element from an array within an object

[Keisuke Miyako via 4D_Tech]

OB SET ARRAY creates a collection based on the array and links that collection 
with the object.
Now that we have object notation, there is really no need to use this command 
anymore.
But that is a matter of preference, you can code however way you like.

You can access the collection directly or indirectly.

By that I mean, if you do

$o:=New object
$c:=New collection("one";"two";"three")
$o.c:=$c

$o.c and $c are references to the same collection.

You can

$c:=$c.remove(1)

or

$c:=$o.c.remove(1)

it's the same thing.

---

iNUG will become a deserted town sooner or later, time to join 
discuss.4D.com!



**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: Running v15 Server as a Service in Windows Server 2016

[Keisuke Miyako via 4D_Tech]

did you start the app as administrator?

https://doc.4d.com/4Dv18/4D/18/Registering-a-Database-as-a-Service.300-4672427.en.html

P.S. you are kindly invited to join the new discussion forum!

https://discuss.4d.com/

2020/08/03 20:32、Peter Jakobsson via 4D_Tech 
<4d_tech@lists.4d.com>のメール:
However when I “Register as a Service” (from the File menu in 4D Server) it 
doesn’t seem to appear in the services list in server manager. Are there any 
tricks I am missing?

**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: PDF Documentation

[Keisuke Miyako via 4D_Tech]

Hello!

this is my side project of the week:

https://discuss.4d.com/t/convert-html-documentation-to-pdf/14712

Regards,

2020/07/10 17:32、Paul Dennis via 4D_Tech 
<4d_tech@lists.4d.com>のメール:
It looks like 4D are phasing out PDF documentation which is a shame because
the HTML docs are a mess. Way too much scrolling.

**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: CURSOR POSITION

[Keisuke Miyako via 4D_Tech]

Hello!

I believe it's GET HIGHLIGHT

https://doc.4d.com/4Dv18/4D/18/GET-HIGHLIGHT.301-4505337.en.html

you are kindly invited to join the new community site:

https://discuss.4d.com


> 2020/07/18 19:56、stardata.info via 4D_Tech <4d_tech@lists.4d.com>のメール:
> Someone knows what is the 4d command for know the cursor position into one 
> textual field?

**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: Old 4D Transporter (ResTransporter) or Equivalent

[Keisuke Miyako via 4D_Tech]

..or just use the standard command

mkdir MaBase.WIN
cp LAUNCHAPP MaBase.WIN/ LAUNCHAPP.4DB
cp LAUNCHAPP/..namedfork/rsrc MaBase.WIN/LAUNCHAPP.RSR

we warmly invite you to join the new platform!

https://discuss.4d.com

> 2020/07/05 4:08、Peter Jakobsson via 4D_Tech <4d_tech@lists.4d.com>のメール:
> I can use v15 on High Sierra.

**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: V18 plugins not showing as Notarized?

[Keisuke Miyako via 4D_Tech]

only the plugins pre-installed with the application (inside 4D or 4D Server) 
are notarised.

the folder adjacent to the application are copies for distribution and 
therefore not code signed at all.

> On May 1, 2020, at 12:00, Ronald Rosell via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> Executing codesign --verify -- verbose against 4D InternetCommands.bundle, 
> for example, brings back:
>   /Applications/4D v18.1/Plugins/4D InternetCommands.bundle: code object 
> is not signed at all

**
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: 4D Summit Videos

[Keisuke Miyako via 4D_Tech]

Hello,

the team has just made the demo DB (v18) available for download.

https://events.4d.com/summit2020/session/document-production/

Regards,

> On Apr 23, 2020, at 22:37, Eric Naujock via 4D_Tech <4d_tech@lists.4D.com> 
> wrote:
> Keisuke Miyako's presentation on Document Production managed to get me 
> excited.
> But I cannot find in the V18 or v18R2 documentation more about what he 
> discussed. 

**
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: Object notation replacement for use of Self in a script — v18

[Keisuke Miyako via 4D_Tech]

I can only share how I would design my user interface, 
but in short, I would not have this problem

> (Object get name).prettyFormat()

and here's why.

I see that the form object should either be bound to (=managed automatically by 
4D) 
or divorced from (managed by me) its data source.

the object name is only interesting to me for visibility, enable/disable, etc.
I would have some kind of naming convention to take advantage of the @ 
wildcard, but that's all.

as for the data source, if I wanted to implement some kind of rule on it,
I would do so without the form object.

in other words, I would only use object notation on form objects that do not 
need to use form events.
in my opinion, any form object that do use a form event should not have object 
notation as their data source,
since the event is attached to the form object and not the data source object.
there would be room for programming error if the same data source could be 
manipulated outside the form event.

same with the current item/position/selection property of the collection type 
listbox.
the properties only make sense in the context of zero-coding.
if I want to manage the binding by code, I would keep these properties empty.

classes are coming in 18 R3, but you can already create pseudo-classes by 
writing custom constructors that return an object with prefab properties and 
methods.

until the use of "This" is extended to text inputs and other form objects,
I would not expose object notation (which implies that the target is an object) 
in any of my form objects,
other than for form objects that exist purely for display purposes.

I would focus my use of object notation to areas where classic code could not 
go,
not spaces already occupied by classic code. 

> On May 1, 2020, at 4:54, Chris Belanger via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> (Object get name).prettyFormatHow would that be achieved?

**
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: Object notation replacement for use of Self in a script — v18

[Keisuke Miyako via 4D_Tech]

my feeling is that generic coding is very much possible in object notation, 
but we need to accept that the approach is different.

if you prefer to use pointers such as "Self", 
I think it's best to avoid object notation, 
at least if your goal is to make the code generic.

it's not a defect of object notation, 
but the way to write generic code is different.

if you want to make your code generic in object notation, 
I think you need to fully commit.

what I mean by that, is that you need to think of objects and classes, 
properties and methods.

basically, instead of

doIt(Self)

you would write

$obj.doIt()

where the doIt() formula works on "This".

in my opinion, to take full advantage of object notation, 
it is pretty much mandatory to use 

This
Signal
Formula
Form

extensively, as well as 

Storage
New shared object
New shared collection

strategically.

simply replacing interprocess/process variables with object notation,
may semantically look like object based coding, 
but at that level you may be losing major advantages of classic code,
while not gaining much from what the new way of coding has to offer.

> On Apr 29, 2020, at 14:55, Chris Belanger via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> And v18r3 does not even have a solution to this in its documentation.

**
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: 4D Summit Videos

[Keisuke Miyako via 4D_Tech]

Hello!

first off, you can see from the round orange icon that indeed I am using v18 
LTS and not an R (feature) release.
preparation for publishing the demo is still ongoing, but you will get access 
to the source code soon.

the seemingly "new" commands are just custom object methods defined by 
"Formula".
https://doc.4d.com/4Dv18/4D/18/Formula.301-4505749.en.html

to give an example, if you do

$object:=New object("add";Formula(do_add);"val";0)

and the project method "do_add" does something like

This.val:=This.val+$1

$0:=This

then you can chain methods like:

$object.add(1).add(2).add(3)

you may ask yourself, "since when is there an add() method?" 
but of course, we are entering object-based territory,
so the functionality of an add() method depends on its receiver.

---

although any single line of code can be used to create a formula,
and there are cool things you can do by passing local variables in definition,
as a kind of static properties to the created formula,
I feel the best practice is to always pass a project method with no parameters,
which would make the formula something similar to a "function pointer".
you see, a project method is like a shared object, 
so if you create a formula from a project method, you get a shared formula.
this way you can attach that formula to a shared object, more specifically 
Storage,
which is similar to how classes (watch Laurent Esnault's presentation!) work.

one more thing, 
you can pass a formula that encapsulates a project method on the host to an 
object defined in a component,
and the component can invoke that formula (which is a project method) even if 
the method is not "shared".
the advantage is that you are no longer using string to reference a project 
method (as in EXECUTE METHOD)
you are passing the tokenised method itself.

it makes it easier to encapsulate asynchronous procedures,
where you simply expose an object, 
that exposes a method (formula), 
that optionally takes a callback function (again, a formula).
the object may internally do complex things such as bridging to a cooperative 
process via Signal,
https://doc.4d.com/4Dv18/4D/18/New-signal.301-4505566.en.html
or a method that executes on the server (which requires cooperative mode), 
all of which is transparent to the callee.

but I digress.

the point is, the demo is written using v18 language with no hidden tricks or 
plugins.

> On Apr 23, 2020, at 22:37, Eric Naujock via 4D_Tech <4d_tech@lists.4D.com> 
> wrote:
> 
> Keisuke Miyakos presentation on Document Production managed to get me 
> excited. But I cannot find in the V18 or v18R2 documentation more about what 
> he discussed. Nor doe the command seem to exist in V18.1. Unless I’m missing 
> something.

**
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: On Server Open Connection Database Method - User Name

[Keisuke Miyako via 4D_Tech]

I am not sure if it will solve your specific problem,
but "Get process activity" is more informative than "GET USER LIST"

https://doc.4d.com/4Dv17/4D/17.4/Get-process-activity.301-4882774.en.html

> On Apr 22, 2020, at 3:02, Jim Medlen via 4D_Tech <4d_tech@lists.4d.com> wrote:
> Is there a way to get the User Name in the On Server Open Connection Database 
> Method

**
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: v18r2 — File Object Folder?

[Keisuke Miyako via 4D_Tech]

you could also specify the "fk platform path" constant, if want to start with a 
system path.

https://doc.4d.com/4Dv18/4D/18/File-and-Folder.302-4504493.en.html

> On Apr 22, 2020, at 14:32, Chris Belanger via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Sorry about this post.
> I figured out what my problem was. The problem was from using 4D’s old 
> ’Select folder’ to pick the folder, then Convert path system to POSIX( ).
> When I would try to create a FOLDER( ) from this, it said it didn’t .exist  . 
> It’s because it puts a bunch of %’s in it

**
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: Quick reports not printing to PDF and previewing on macOS with 4D 64-bit versions

[Keisuke Miyako via 4D_Tech]

I could be way off, but...

1. try using OPEN PRINTING JOB, CLOSE PRINTING JOB

https://doc.4d.com/4Dv17/4D/17.4/OPEN-PRINTING-JOB.301-4883314.en.html

or,

2. activate "Legacy printing layer option"

https://doc.4d.com/4Dv17/4D/17.4/SET-PRINT-OPTION.301-4883296.en.html
On Apr 21, 2020, at 22:11, Alberto Bachler via 4D_Tech 
<4d_tech@lists.4d.com> wrote:
I suppose I’m doing something wrong but I can figure it out…
Any clues?

**
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: New Notarization Issues

[Keisuke Miyako via 4D_Tech]

- check if software is signed 

codesign --verify --verbose {path}

- check if software is notarised

spctl --assess --verbose --type install {path}

---

what you describe is normal behaviour for software that is not signed or 
notarised.

https://support.apple.com/en-us/HT202491

> On Apr 22, 2020, at 1:35, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> wrote:
> Any suggestions?

**
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: With v18r2, can 4D display pdf documents?

[Keisuke Miyako via 4D_Tech]

4D v18 is 750 MB. just over half of that size is taken by the embedded CEF web 
area. So it would be a shame not to use it at all other than for the welcome 
dialog.

my understanding is that the Chrome Embedded Framework is using the same PDF 
renderer as Chrome, that is, PDFium, a Google edition of the Foxit render.

https://opensource.google/projects/pdfium

https://www.foxitsoftware.com/blog/foxit-pdf-technology-chosen-for-google-open-source/

note that you can pass a posix path or a system path or an URL to the Web area. 

the difference between posix or system can be determined by the delimiter. but 
the difference between a path or an URL is less obvious, especially if you pass 
a file name. 

the reason you need to append the "file://" protocol, and to use an absolute 
path that begins with a forward slash (which results in a triple slash), is 
that as silly as it sounds, "test.pdf" by itself could be interpreted as an 
internet domain name and therefore ambiguous.

> On Apr 22, 2020, at 1:51, Chris Belanger via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I have never used web areas in 4D so I will need to explore the benefits of 
> it. I notice it can also be used to display .png files and others dragged 
> into that ‘dropZone’ variable object on my form.

**
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: With v18r2, can 4D display pdf documents?

[Keisuke Miyako via 4D_Tech]

with a plugin-in

http://www.pluggers.nl/product/pdf-viewer/

a web thingy

https://mozilla.github.io/pdf.js/

---

I would consider the two above to be your top choices.

I've posted a few convert-to-picture examples, 
but it sounds like you would want to render and display, not rasterise.

https://miyako.github.io/2020/04/19/4d-plugin-xpdf.html
https://miyako.github.io/2020/01/01/4d-plugin-pdfium.html

> On Apr 21, 2020, at 14:14, Chris Belanger via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Is there a way in 4D to display PDF documents? Either natively inside it 
> [with a plug-in, web thingy or otherwise] or by showing in a system pdf 
> viewer?

**
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: Administration window on Server

[Keisuke Miyako via 4D_Tech]

how about using on server startup?

https://doc.4d.com/4Dv17/4D/17.4/On-Server-Startup-Database-Method.301-4899483.en.html

https://doc.4d.com/4Dv17/4D/17.4/OPEN-ADMINISTRATION-WINDOW.301-4882847.en.html

On Apr 21, 2020, at 7:55, Mitchell Shiller via 4D_Tech 
<4d_tech@lists.4d.com> wrote:

I just want the Admin window to open automatically.
Can’t find a database parameter either.

Any ideas?

**
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: HTTP Request when POSTing does not have a response if the HTTP status code # 200

[Keisuke Miyako via 4D_Tech]

that sounds similar to ACI0100045

which was a regression reported and fixed during R6 beta (no problems in 
versions before or after)

it happened, not always, but often with Google API.

restricted URL:

https://forums.4d.com/Post/FR/31950984/1/31950985#319509852361

so I think it could be specific to the endpoints you are using.

> On Apr 18, 2020, at 15:01, Guy Algot via 4D_Tech <4d_tech@lists.4d.com> wrote:
> Can anyone confirm this to be true? I’m using 17.3. Thanks.

**
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: reporting table relations

[Keisuke Miyako via 4D_Tech]

you can also introspect relations by parsing the xml from "export structure"

example:

https://github.com/miyako/4d-utility-structure-to-svg-converter-v2
**
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: Configure 4D server as Windows Service on Windows Server 2016

[Keisuke Miyako via 4D_Tech]

4D Server does not have to run on a server OS.
many users find the option both practical and affordable.
the server side admin window makes perfect sense for those kinds of 
distribution.

for headless deployment,

https://blog.4d.com/headless-4d-applications/

you can either:

1. take advantage of the limited version of the admin window which is available 
on the client side, or

2. publish your own remote admin api using the admin features that are now 
accessible by code,

https://blog.4d.com/customize-the-admin-dialog-with-4d-code/
https://blog.4d.com/build-a-web-based-monitoring-dialog-step-by-step

> On Apr 11, 2020, at 0:06, Tonu Mikk via 4D_Tech <4d_tech@lists.4d.com> wrote:
> How are people configuring a 4D server to run as Windows service so that 
> multiple
> users can have access to the 4D server admin screens?

**
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: Long running reports to disk intermittently disrupted and fail

[Keisuke Miyako via 4D_Tech]

also, don't forget to compress the BLOB. 
text files compact pretty well.

> On Apr 17, 2020, at 7:17, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> Once the file is created you can blob it up and move it back to the client. 
> It will still befaster I bet.

**
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: 4D Server v18.1LTS - Startup Takes 10-15 Minutes

[Keisuke Miyako via 4D_Tech]

first off, I don't have any answers to your questions.

but if I may throw some ideas:

> I have an application I'm trying to convert from 4D v17R6 to v18.1LTS. It is 
> hosted on Windows Server 2016. It was a well-behaved application when running 
> v17R6 with no notable issues. However, now that it has been upgraded and 
> running on v18.1 LTS, it takes 10-15 minutes for the application to start-up 
> in 4D Server. Specifically, from the moment that the database is selected 
> from the Open... menu item until the Server Administration Window appears is 
> between 10 and 15 minutes.

is it possible that the application, for whatever reason, needs to copy all 
your database files to a virtual store?

---

also, windows server by default has a conservative power plan, which prevents 
4D Server from drawing on its full potential.

https://support.microsoft.com/en-us/help/2207548/slow-performance-on-windows-server-when-using-the-balanced-power-plan
https://docs.microsoft.com/en-us/windows-server/administration/performance-tuning/hardware/power/power-performance-tuning

of course, that does not explain why 17 R6 is doing just fine.

---

> The same application opens pretty much instantly when running in single-user 
> mode on my development machine (Windows 10 Pro). So the only difference is 
> host application (4D Server) and OS.

what about the hardware?
more specifically, do you know if the storage is HD or SSD?

> I would rule out the OS being an issue since the same application ran fine on 
> the same host machine and opened with no delay just prior to the upgrade from 
> v17R6 to v18.1LTS.

have you tried to launch 4D Server on your dev. machine, Windows 10 Pro,
to see if the correlation is really linked to the application type?

and just to rule out that the issue is not application specific,
you might want to compare the time with a fresh 4DB.
**
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
**