Re: Closing a window with another application in focus

[Bernd Fröhlich via 4D_Tech]

Jeffrey Kain:

> On macOS - some of the windows in my application will close if I click on the 
> close box while another application has the focus, but others don't.
> 
> Does anyone know what the secret is for this? They all close fine if 4D is 
> the frontmost application - even if other 4D windows are on top I can close 
> non-focused window with a single click to the close box.


I read about a a "click through" property (a long time ago and not connected to 
4D).
If that is not set, then the first click into a window brings it to the front 
and the second click has the desired outcome.
If it is set, then one click does both.
Not sure if that was per window or per program or if 4D even supports it.
Maybe something to do with the window type (composite vs. non composite)?

Sorry, that may be not much help, but that´s all I remember.

Greetings from Germany,
Bernd Fröhlich
**
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: v17 built client on windows a few issues

[John DeSoi via 4D_Tech]

> On Feb 6, 2019, at 11:15 AM, Chuck Miller via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I am using v17.2 64 bit client. On a variety of windows machines, entering a 
> enter from extended keyboard is causing volume desktop has stopped working 
> and of course 4D just quits. Anyone else having these issues. 

I think you mean 17R2? As far as I know 17.0 is still the latest mainline 
version released the middle of last year. I'm hoping 17.1 comes out soon and 
solves issues with macOs 10.14 Mojave among other issues. But full credit to 4D 
for increasing quality of .0 releases.

> 
> Also ins Reading quick report documentation the normal menus are not there so 
> we can not sort columns. I am sure this one is some setting I do not 
> understand

Quick Reports is rewritten (as a component?) in 64 bit implementations and has 
a lot of feature differences from previous 32 bit versions. You are probably 
not missing a setting that will make it work like the previous version.

John DeSoi, Ph.D.

**
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: How to display read-only input form

[Keisuke Miyako via 4D_Tech]

DIALOG is quite capable of handling input / output forms, as long as you have 
activated the "make fields enterable in dialog" compatibility setting (since 
v2004).

there is no need to use F. SET INPUT or F. SET OUTPUT.

a list type subform or selection based listbox have their own input form 
defined in their property list, which is independent of the current input form 
(F. Get input). what is more, you can always FILTER EVENT the On Double Clicked 
event and do something else.

for example, you can have a 5 page dialog (=project form) with a list type 
subform or listbox on page 1.

the double click event could switch to pages 2, 3, 4, or 5 depending on the 
context by filtering the event and issuing a F. GOTO PAGE.

the current page is effective your current input form.

> 2019/02/07 6:31、Jim Crate via 4D_Tech <4d_tech@lists.4d.com>のメール:
>
> I thought about using DIALOG, but that would require specifying the input 
> form name in a variable higher up the call chain, because while we can use 
> FORM SET INPUT to set the input form for a table, there is no accompanying 
> "Form Get Input” command that I can find. I know this could probably be 
> plugged into form storage instead of a process variable in V17, but I’m not 
> on v17 yet and logically that’s not much different than using a process 
> variable, we’re still introducing a separate place to store some data that we 
> should be able to get the same way we specify 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: How to display read-only input form

[Kirk Brooks via 4D_Tech]

Jim,
If the table is in read only mode you can use any form you want and the
user can't edit the data.
I'd just put the table in read only and use DIALOG with the input form.

On Wed, Feb 6, 2019 at 1:32 PM Jim Crate via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> Is there a convenient way to mimic the ease of DISPLAY SELECTION / MODIFY
> SELECTION to allow read/only or read/write access when using a listbox? Is
> DIALOG the only option?
>
tl:dr

Yep but call it 'best' option.

You didn't say which version of 4D we're talking about but it sounds like
an old one so I'm going to assume you're working in v15 at least. If it's
earlier than that it's probably not worth the effort to re-work it. You
know, you _could_ drop a Tesla drive train into an '92 Impala with a lot of
work and money. Or you could fix your '92 Impala with parts from another
'92 Impala. Chip is right about using variables. I did that in v13. It's
tedious, takes pages of code and is hard to change. Put the effort into
convincing the client to upgrade. So-

Make a form and display it using DIALOG in a new process. The form contains
a listbox. In v15 it could be named selection based or array based. Doesn't
really matter - just avoid selection based. Why? Because the idea is to
have a persistent list of records selected by the user. The actual
selection may change based on what the user does in the detail form. In v17
it could be an entity selection instead.

Feel free to add a quick search box above the listbox for the user to find
records quickly on a small set (like 1) criteria with the option for a more
involved query.
Depending on the type of data this list can be pretty concise or it may be
larger. If the records are fairly concise think about having the input form
right there on the dialog. This could be a subform or you could add the
fields directly. The user clicks on a record in the list and you load the
record. I like to include a button that toggles between READ ONLY and READ
WRITE. Default to read only. The uses can click around the list and records
pop up. If they need to edit something toggle the record to READ WRITE.

The advantage of a subform is you can easily swap the table you're looking
at (the listbox doesn't really care) and simply set a different subform to
the subform object.

If this is a converted database check the compatibility settings regarding
displaying fields in dialogs. For newer versions this already baked in.

Alternatively you could also pop the user selected record into a new
process for editing. This makes it easy to let the user open multiple
records from the same table in multiple windows.

OK, this crazy talk - you want to go old school: show a list and double
click to open the input form.
Fine, take all that input stuff off the dialog and add some more fields to
it. For the On double click event you toggle the table into READ WRITE,
load the record and then display it in the input form using DIALOG again.
There's nothing wrong with Modify record but DIALOG is more flexible
precisely because it's ambivalent to read write state. If the record is
locked the user can't change anything.

I've been using this approach in v15 databases for years now and it
generalizes easily to v17+. In fact it's really much easier to implement in
v17 than the old school Modify Selection approach, in my opinion.

I realize I've thrown out a lot of options here. The thing is they are all
based on a fairly small set of principles and techniques. That's what's so
cool - you have all that flexibility from using DIALOG, a listbox and some
processes.

-- 
Kirk Brooks
San Francisco, CA
===

What can be said, can be said clearly,
and what you can’t say, you should shut up about

*Wittgenstein and the Computer *
**
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: How to display read-only input form

[Keith Culotta via 4D_Tech]

I have simulated that effect with code like this:

If (Read only state([Docs])) & (Form event=On After Edit)
vContent:=[Docs]Content
End if 

Where vContent is editable (no entry filter).

Keith - CDI

> On Feb 6, 2019, at 3:31 PM, Jim Crate via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Also, is there a way to make a field non-enterable but allow text to be 
> copied?
> 
> Jim Crate

**
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: How to display read-only input form

[Chuck Miller via 4D_Tech]

Sure on load use command

Object set enterable(*;”@“;false)// This will set all fields and variables to 
non enterable

You will have to use Object set enabled for Check Boxes, Radio button etc. 
These can not be done as above as it will set all to disabled

You could also do a start transaction on form, only have a cancel button and 
cancel transaction in that. I think option one is better

I would also set background color to illustrate that stuff can not be entered

Regards


Chuck

 Chuck Miller Voice: (617) 739-0306
 Informed Solutions, Inc. Fax: (617) 232-1064   
 mailto:cjmillerinformed-solutions.com 
 Brookline, MA 02446 USA Registered 4D Developer
   Providers of 4D and Sybase connectivity
  http://www.informed-solutions.com  

This message and any attached documents contain information which may be 
confidential, subject to privilege or exempt from disclosure under applicable 
law.  These materials are intended only for the use of the intended recipient. 
If you are not the intended recipient of this transmission, you are hereby 
notified that any distribution, disclosure, printing, copying, storage, 
modification or the taking of any action in reliance upon this transmission is 
strictly prohibited.  Delivery of this message to any person other than the 
intended recipient shall not compromise or waive such confidentiality, 
privilege or exemption from disclosure as to this communication. 

> On Feb 6, 2019, at 4:31 PM, Jim Crate via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> From a listbox view, I’d like to open the input form for a record but not 
> allow the user to change any info. I tried using DISPLAY RECORD instead of 
> MODIFY RECORD, but it just displays the form and immediately closes. If I set 
> the table to read only before loading the record, MODIFY RECORD just shows an 
> alert complaining that the record is locked, and doesn’t show the input form. 
> So I set the form fields to be not enterable, but while text can be selected, 
> it can’t be copied. 
> 
> I thought about using DIALOG, but that would require specifying the input 
> form name in a variable higher up the call chain, because while we can use 
> FORM SET INPUT to set the input form for a table, there is no accompanying 
> "Form Get Input” command that I can find. I know this could probably be 
> plugged into form storage instead of a process variable in V17, but I’m not 
> on v17 yet and logically that’s not much different than using a process 
> variable, we’re still introducing a separate place to store some data that we 
> should be able to get the same way we specify it.
> 
> Is there a convenient way to mimic the ease of DISPLAY SELECTION / MODIFY 
> SELECTION to allow read/only or read/write access when using a listbox? Is 
> DIALOG the only option?
> 
> Also, is there a way to make a field non-enterable but allow text to be 
> copied?

**
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: How to display read-only input form

[Keith Culotta via 4D_Tech]

Can you call Modify Record with code either lock and reload the record(s), or 
disable entry for all objects?

Keith - CDI

> On Feb 6, 2019, at 3:31 PM, Jim Crate via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> From a listbox view, I’d like to open the input form for a record but not 
> allow the user to change any info. I tried using DISPLAY RECORD instead of 
> MODIFY RECORD, but it just displays the form and immediately closes. If I set 
> the table to read only before loading the record, MODIFY RECORD just shows an 
> alert complaining that the record is locked, and doesn’t show the input form. 
> So I set the form fields to be not enterable, but while text can be selected, 
> it can’t be copied. 
> 
> I thought about using DIALOG, but that would require specifying the input 
> form name in a variable higher up the call chain, because while we can use 
> FORM SET INPUT to set the input form for a table, there is no accompanying 
> "Form Get Input” command that I can find. I know this could probably be 
> plugged into form storage instead of a process variable in V17, but I’m not 
> on v17 yet and logically that’s not much different than using a process 
> variable, we’re still introducing a separate place to store some data that we 
> should be able to get the same way we specify it.
> 
> Is there a convenient way to mimic the ease of DISPLAY SELECTION / MODIFY 
> SELECTION to allow read/only or read/write access when using a listbox? Is 
> DIALOG the only option?
> 
> Also, is there a way to make a field non-enterable but allow text to be 
> copied?
> 
> Jim Crate
> 
> **
> 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
> **

**
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: How to display read-only input form

[Chip Scheide via 4D_Tech]

the only solution I found was:
variables.

Built the form with variables. - variable are enterable. User can tab 
through the variables, copy text, and even change the data - but the if 
they change the data it reverts to the original value(s)

with this idea in mind, object methods, or form method:

Case of 
:(on data change) // I was lazy - and just reassigned everything
  reassign original value to variable
   or
  reassign all variables the underlying record data
end case

On Wed, 6 Feb 2019 13:31:19 -0800, Jim Crate via 4D_Tech wrote:
> 
> Also, is there a way to make a field non-enterable but allow text to 
> be copied?
---
Gas is for washing parts
Alcohol is for drinkin'
Nitromethane is for racing 
**
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
**

How to display read-only input form

[Jim Crate via 4D_Tech]

From a listbox view, I’d like to open the input form for a record but not allow 
the user to change any info. I tried using DISPLAY RECORD instead of MODIFY 
RECORD, but it just displays the form and immediately closes. If I set the 
table to read only before loading the record, MODIFY RECORD just shows an alert 
complaining that the record is locked, and doesn’t show the input form. So I 
set the form fields to be not enterable, but while text can be selected, it 
can’t be copied. 

I thought about using DIALOG, but that would require specifying the input form 
name in a variable higher up the call chain, because while we can use FORM SET 
INPUT to set the input form for a table, there is no accompanying "Form Get 
Input” command that I can find. I know this could probably be plugged into form 
storage instead of a process variable in V17, but I’m not on v17 yet and 
logically that’s not much different than using a process variable, we’re still 
introducing a separate place to store some data that we should be able to get 
the same way we specify it.

Is there a convenient way to mimic the ease of DISPLAY SELECTION / MODIFY 
SELECTION to allow read/only or read/write access when using a listbox? Is 
DIALOG the only option?

Also, is there a way to make a field non-enterable but allow text to be copied?

Jim Crate

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

v17 built client on windows a few issues

[Chuck Miller via 4D_Tech]

Hi All,

I am using v17.2 64 bit client. On a variety of windows machines, entering a 
enter from extended keyboard is causing volume desktop has stopped working and 
of course 4D just quits. Anyone else having these issues. 

Also ins Reading quick report documentation the normal menus are not there so 
we can not sort columns. I am sure this one is some setting I do not understand

Thanks and regards

Chuck

 Chuck Miller Voice: (617) 739-0306
 Informed Solutions, Inc. Fax: (617) 232-1064   
 mailto:cjmillerinformed-solutions.com 
 Brookline, MA 02446 USA Registered 4D Developer
   Providers of 4D and Sybase connectivity
  http://www.informed-solutions.com  

This message and any attached documents contain information which may be 
confidential, subject to privilege or exempt from disclosure under applicable 
law.  These materials are intended only for the use of the intended recipient. 
If you are not the intended recipient of this transmission, you are hereby 
notified that any distribution, disclosure, printing, copying, storage, 
modification or the taking of any action in reliance upon this transmission is 
strictly prohibited.  Delivery of this message to any person other than the 
intended recipient shall not compromise or waive such confidentiality, 
privilege or exemption from disclosure as to this communication. 

**
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 Selection from SQL Query

[Randy Engle via 4D_Tech]

Miyako

Many thanks again!
Works like a charm!

Took a couple of passes to see the "Double Underline" in the virtual field:  
__ROW_ID

I'm going to take a W.A.G. that this is what QUERY BY SQL command is doing 
behind the scenes.

Not sure how I'm going to use this, but I think it might come in handy at some 
point.

Thanks again,

Randy Engle,

-Original Message-
From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Keisuke Miyako via 
4D_Tech
Sent: Tuesday, February 5, 2019 4:30 PM
To: 4D iNug Technical <4d_tech@lists.4d.com>
Cc: Keisuke Miyako 
Subject: Re: 4D Selection from SQL Query

alternatively, I guess we can SELECT __ROW_ID == record number (not all tables 
have a primary key).

https://doc.4d.com/4Dv17/4D/17/Replication-via-SQL.300-3786654.en.html
https://doc.4d.com/4Dv17/4D/17/CREATE-SELECTION-FROM-ARRAY.301-3729926.en.html

2019/02/06 3:31、Randy Engle via 4D_Tech 
<4d_tech@lists.4d.com>のメール:

If you really need it, it would be a two step process. Step one Begin sql  
select primary_key form table where (some criteria) into :$primaryKeyArray end 
sql



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

**
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: QPix License Install Issues...

[Tom Benedict via 4D_Tech]

Thanks for the response Bob.

I received a response from Christos at EscapeTech and evidently the QPix 
license is sensitive to the structure name which may have been changed. The 
client is working to re-install the license keys now.

Tom Benedict

> On Feb 5, 2019, at 23:13, Robert McKeever via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> What OS and what version of 4D?
> 
> Yes, I’ve seen it with one client. V15 with an older Mac OS. You just have to 
> re-install his license.
> 
> The roll-back (which we never did) seems odd. What does the license manager 
> say is installed?
> 
>> On Feb 5, 2019, at 9:15 PM, Tom Benedict via 4D_Tech <4d_tech@lists.4d.com> 
>> wrote:
>> 
>> Anyone out there with QPix 3.7 License experience? I’m asking because I just 
>> took over a project for a client whose app uses QPix and I made some minor 
>> edits to code other than QPix then compiled and built a .4DC and delivered 
>> it to them. When they installed it (drag and drop) they got a QPix license 
>> error on startup saying there were "no seats available”. When they ‘rolled 
>> back’ to the previous .4DC there is no QPix license error. I’ve reviewed the 
>> QPix documentation around license installation and there appears to be a 
>> developer key that is installed in the structure file and licenses which are 
>> installed on the server in the 4D folder. Is there also a Deployment Key 
>> which needs to be in the structure? Do I need to install a key each time I 
>> build a new .4DC? Can anyone shed any light on this?
>> 
>> I’ve reached out to escapetech.eu for support, but thought I’d post here in 
>> case someone has a quick answer.
>> 
>> Thanks,
>> 
>> Tom Benedict
>> **
>> 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
>> **
> 
> _
> Bob McKeever  http://www.mswl.com 
> McKeever's Software Wizardry
> Port Coquitlam, B.C.
> bobmckee...@mac.com
> 
> 
> 
> 
> **
> 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
> **

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