printing listboxes

[Chip Scheide via 4D_Tech]

I have code which allows me to print a listbox using Print object.

I dynamically build a listbox for use on screen.
If a user wants to print the listbox, I use the same process to build a 
separate listbox for reporting (as this is generic code for printing 
list boxes).

What I am observing is complex data gathering fails when printing which 
works correctly when displayed.
The code (see below for an example) is placed into the listbox as a 
calculation column, in a selection listbox. 
When the listbox is displayed on screen, the data (description) is 
properly displayed.

However, the same data is NOT printed, the column where the description 
is to be displayed, is empty of any text. Which leads me to believe 
that the calculation in the calculated column is not being executed.

Any Ideas on how to go about getting this to function correctly?


Example calculated column code, the below code is in a method call, and 
is the "calculation" when inserting the calculation column.

QUERY([Lab_Adjustments];[Lab_Adjustments]Adjustment_ID=[Adjustments]Adjustment_ID)
RELATE ONE([Lab_Adjustments]Lab_Inventory_ID)  //gets the laboratory 
inventory record
RELATE ONE([Lab_Inventory]Inventory_Item_ID)  //gets the inventory item 
record
$0:=[Inventory_Items]Description


4D v13
Thanks
Chip
---
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
**

Screen arrangement

[Chip Scheide via 4D_Tech]

In a situation where there are 2 or more screens attached to a computer.
is there any way to determine the screen arrangement? (horizontal, 
vertical, grid)

In a 2 or more horizontal
which screen is main (left, right, other)

In a 2 or more vertical
which screen is main (Top, bottom other)

in a grid (4 or more) with at least 2 vertical and at least 2 
horizontal)
which screen in main?

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

Re: v13 - array listbox column Compiler definition

[Chip Scheide via 4D_Tech]

Hi Jeremy,
I do not want to manipulate the original array(s) as this is in a 
component. I am handling the data blindly, additionally, even if I 
use(d) the source array(s) directly - I still have the same problem.

How do I (compiler) declare the column variable? (in the example below 
Listbox_Column1).

Conceptually...
The incoming data can be any type of data displayable in a listbox. 

Practically...
Due to the context, the most likely data types are Text, or numeric 
(Long or real), and the 2 data types are still not compatible from a 
compiler view point.

What I have done as a workaround - until/if - I find a different way of 
handling this, is to declare the column variable as a Text array, and 
then convert - if necessary - from whatever data type the source is.
Not the most efficient, but it is functional.

Chip

On Fri, 9 Aug 2019 11:06:00 +0200, Jeremy Roussak via 4D_Tech wrote:
> Chip,
> 
> Why do you need to use a copy of the data in the component? Why not 
> just use $HostData-> in the call to LISTBOX INSERT COLUMN? 
> 
> Jeremy
> 
>> On 8 Aug 2019, at 20:59, Chip Scheide via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>> 
>> I have a component.
>> In the component, I have a published (shared) method which opens an 
>> array listbox in its own window.
>> 
>> The data to be shown is passed from the host.
>> I place the data from the host into the listbox using the following 
>> commands
>> LISTBOX INSERT 
>> 
COLUMN(lb_Listbox;1;"obj_Listbox_Column1";Listbox_Column1;"obj_Col_Header";Col_Header)
>> copy array($Host_Data->;listbox_Column1)
>> 
>> How do I declare the array listbox_column1 so that:
>> - the component will compile
>> - the component will not complain once built and used with a host
>> 
>> Thanks for any insight
>> Chip
> **
> 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
> **
---
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
**

v13 - array listbox column Compiler definition

[Chip Scheide via 4D_Tech]

I have a component.
In the component, I have a published (shared) method which opens an 
array listbox in its own window.

The data to be shown is passed from the host.
I place the data from the host into the listbox using the following 
commands
LISTBOX INSERT 
COLUMN(lb_Listbox;1;"obj_Listbox_Column1";Listbox_Column1;"obj_Col_Header";Col_Header)
copy array($Host_Data->;listbox_Column1)

How do I declare the array listbox_column1 so that:
- the component will compile
- the component will not complain once built and used with a host

Thanks for any insight
Chip
---
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
**

Re: Pasting problem

[Chip Scheide via 4D_Tech]

to catch the keystroke without On Event Call:
you could put an invisible button on the form(s)
with cntrl-v as the activator, then use  Get Text From Pasteboard, and 
insert it at the current cursor position

Im not sure if you can catch the contextual menu, but maybe:
with some imaginative use On Mouse Down, selected menu item you cold 
catch the paste action that way too, then use Get Text from Pasteboard

Chip

On Wed, 7 Aug 2019 10:51:45 -0700, William Swann via 4D_Tech wrote:
> Hi All,
> 
> I am having a problem with pasting into text fields or variables on 
> input forms under Windows. The user clicks into or highlights a text 
> area that is already populated. They press either ctrl-v or select 
> paste from the area's contextual menu. The entire existing text block 
> is replaced with only the new text new from the paste event, even 
> though they clicked into a specific point to paste into. This only 
> happens under Windows 7 or 10. Mac clients have never reported this 
> error/problem at all. I have seen it happen while watching users do 
> their work and there it is not a PEBCAK issue (_p_roblem _e_xists 
> _b_etween _c_hair _a_nd _k_eyboard).
> 
> I have toyed a bit with On Event Call and trapping for ctrl-v events 
> and creating a text pasting strategy, but this seems dangerous, 
> especially on a "system" related event that is better handled by 4D 
> and the host OS. The other trepidation is that the  On Event Call is 
> run in a completely different process, adding to the complexity of a 
> solution to trap the event and get the selection from the process 
> containing the text field. Further, I cannot figure out how to trap 
> for the context menu paste event.
> 
> We are using v14.6 for server and client.
> 
> We are moving the system to a more modern version of 4D in a couple 
> of months, but I need to find a fix or workaround until we can get 
> there... Has anyone seen this? It truly is frustrating.
> 
> HELP and thanks!
> 
> Bill Swann
> 
> **
> 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
> **
---
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
**

Re: Prevent Client from Sleeping

[Chip Scheide via 4D_Tech]

Some ideas - none of these tested or tried :)

LEP - and use commands to bring the desktop to the fore and then 4D?
Move mouse to the menu bar, and post a click?

On launch of 4D use LEP to reset screen saver timeout, reset on quit
On launch of 4D use LEP to reset power timeout, reset on quit

LEP to open and then close a desktop window
open an off screen window (in 4D, with a web area), launch a connection 
to a safe url (apple or microsoft).

maybe even just touch the disk... pick a folder (desktop, or your 
database) and Get Document list
write an empty file to some safe location, and delete it.

Chip

On Wed, 7 Aug 2019 17:59:46 +, Jim Medlen via 4D_Tech wrote:
> 
> 
> To: 4d_tech@lists.4d.com
> From:   Jim Medlen
> Company:Functional Devices, Inc.
> Subject:Prevent Client from Sleeping
> Date:   Wednesday, August 7, 2019
> 
> 
>  Looking for ideas or thoughts on generating an event that will 
> prevent the client machine from sleeping?
> 
> I am trying to prevent clients from Sleeping when connected to a 4D server.
> 
> The POST KEY and POST EVENT both say "Its effect is as if the user 
> actually entered a character on the keyboard.”
> 
> but these events do not prevent the screen saver from activating.
> 
> It appears that the OS does not see this as a user event.
> 
> 
> Thanks,
> 
> Jim Medlen
> 
> Computer & Information Systems
> Functional Devices, Inc.
> j.med...@functionaldevices.com
> 
> Main:   (765) 883-5538 x 5735
> Direct: (765) 416-6835
> FAX:(765) 883-7505
> 
> http://www.functionaldevices.com
> 
> This email was transmitted on 100 percent recycled electrons
> 
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
---
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
**

Re: pointer issue

[Chip Scheide via 4D_Tech]

can you rewrite the outer loop (the one that implied in the code you 
supplied) so that you pass a pointer to the array from calling method, 
rather then trying to create the pointer.

Array Real($MetalAmount_1;10)
Array Real($MetalAmount_2;10)
Array Real($MetalAmount_3;10)

for($i;1;3)
  case of
  :($i=1)
$Array_ptr:= -> $MetalAmount_1
  :($i=2)
$Array_ptr:= -> $MetalAmount_2
  etc
  end case
  process_metal_amount($Array_ptr)
end for


On Wed, 7 Aug 2019 13:06:49 -0400, Chuck Miller via 4D_Tech wrote:
> Hi All,
> The following fails 
> $MetalAmount_ptr:=Get pointer("$MetalAmount_"+String($MetalPos_L)+"_aR")
> $MetalAmount_ptr->{$Loop_L}:=$metalFactors_aR{$InnerLoop_L}
> 
> When I changed arrays to process
> $MetalAmount_ptr:=Get pointer("MetalAmount_"+String($MetalPos_L)+"_aR")
> $MetalAmount_ptr->{$Loop_L}:=$metalFactors_aR{$InnerLoop_L}
> 
> 
> It seems even in the same method you can not have a pointer to a 
> local array. I am not sure as to why. Any insight would be 
> appreciated, as I know you can pass a pointer to local (i.e. $) array 
> form method 1 to method 2 and that works. I would guess I could write 
> a method but that seems kind of a worth around
> 
> 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
> **
---
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
**

RE: How do I access a component form from a host

[Chip Scheide via 4D_Tech]

Thanks

I found the problem... my fault.
my host system is using a built version of the component. I was not not 
building after making changes to the component.
Chip

On Tue, 6 Aug 2019 18:52:01 +, Tai Bui wrote:
> Hi,
> 
> It should be available in the drop down for the "List Form" property 
> of a Subform object's property list:
> 
> Scroll down to the "Using a component subform (host database)" 
> section for more details and images:
> 
https://doc.4d.com/4Dv15/4D/15.6/Interaction-between-components-and-host-databases.300-3836723.en.html
> 
> 
> 
> 
> Tai Bui
> Technical Services Engineer
> 
> 4D Inc
> 95 S. Market Street, Suite #240
> San Jose,CA 95113
> United States
> 
> Telephone: +1-408-557-4600
> Fax:   +1-408-271-5080
> Email: t...@4d.com
> Web:   www.4d.com
> 
> -Original Message-
> From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Chip 
> Scheide via 4D_Tech
> Sent: Tuesday, August 06, 2019 10:07 AM
> To: 4D iNug Technical <4d_tech@lists.4d.com>
> Cc: Chip Scheide <4d_o...@pghrepository.org>
> Subject: How do I access a component form from a host
> 
> I have a component form I would like to access from the host.
> 
> In the component I have set the form to: Published as subform in the 
> host database But I do not see how to get access from the host.
> v13.6
> 
> Thanks
> Chip
> 
> ---
> 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
> **
---
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 do I access a component form from a host

[Chip Scheide via 4D_Tech]

I have a component form I would like to access from the host.

In the component I have set the form to: Published as subform in the 
host database
But I do not see how to get access from the host.
v13.6

Thanks
Chip

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

Re: FORMAT NUMBER

[Chip Scheide via 4D_Tech]

if ###,## does not display a blank for 0 you may have to  convert back 
and forth to/from text to get the formatting you want

Chip

On Mon, 5 Aug 2019 23:24:26 +0200, stardata.info via 4D_Tech wrote:
> Sorry i use 4D V16 on Windows.
> 
> I need to display a number in an array real displayed in a list box.
> In column settings of the list box, if I do not insert anything in 
> Display number format, the decimal numbers are correctly displayed, 
> but I have 0 instead of blank.
---
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
**

Re: No Object Auto-Completion for 4D Commands?

[Chip Scheide via 4D_Tech]

and complex searching options:
Find A & B 
or
Find A but # B


On Fri, 2 Aug 2019 10:43:54 -0700, Kirk Brooks via 4D_Tech wrote:
> It can hang on to it for a long time, though.
> I really wish we have a REGEX option for Find in Design.
> 
> On Fri, Aug 2, 2019 at 10:39 AM Tim Nevels via 4D_Tech 
> <4d_tech@lists.4d.com>
> wrote:
> 
>> On Aug 2, 2019, at 12:24 PM, Jeffrey Kain wrote:
>> 
>>> And if you misspell a property (or get the case wrong), it will suggest
>> that to you forever as well.  So don't make a mistake... ever! :)
>> 
>> I don’t think it does it “forever”.The way I understand it works 
>> is every
>> method that you open is scanned for dot notation and it grabs all attribute
>> names and stores them. It remembers until you quit.
>> 
>> Are you seeing it work differently, or are you just having some fun
>> scaring people on Friday. :)
>> 
>> Tim
>> 
>> *
>> Tim Nevels
>> Innovative Solutions
>> 785-749-3444
>> timnev...@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
>> **
> 
> 
> 
> -- 
> 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
> **
---
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
**

Re: No Object Auto-Completion for 4D Commands?

[Chip Scheide via 4D_Tech]

Narinder,
are you asking 4D to 'look inside' of the object for properties, then 
allow those to be used in auto complete?

On Fri, 02 Aug 2019 18:10:09 +0100, Narinder Chandi via 4D_Tech wrote:
> 
> Having used other IDEs, in particular those from JetBrains, 4D still 
> has a ways to go to provide the "expected" behaviours for proper OOP 
> style object property auto-completion. Maybe in the future...
---
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
**

Re: Another validation issue - orphaned method resource

[Chip Scheide via 4D_Tech]

compact the structure?

as to the user group errors - on a copy - try deleting the group and 
recreating it

Chip

On Wed, 31 Jul 2019 10:10:25 -1000, JOHN BAUGHMAN via 4D_Tech wrote:
> I am getting a bunch of warnings in the Check Orphan Methods section 
> that say…
> 
>   Warning: The method resource CC4D of id 19001 is not used anywhere.(0,0)
> 
> Of course with a different id.
> 
> I don’t have any orphaned methods. What is a method resource and how 
> do I get rid of them.
> 
> John
> 
> John Baughman
> Kailua, Hawaii
> (808) 262-0328
> john...@hawaii.rr.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
> **
---
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
**

Re: How to decode this text

[Chip Scheide via 4D_Tech]

Thanks

I tried but I included the UTF and ?= portions which i why it did not 
work.

Chip
On Tue, 30 Jul 2019 14:08:35 -0600, Neil Dennis wrote:
> Just base 64 decode it.
> 
>   RG9lcyB5b3VyIGNvbXBhbnkgb2ZmZXIgaW5zdXJhbuKFvWU/
>  
> Decoded is
> 
>   Does your company offer insuranⅽe?
> 
> Neil
> 
> 
> 
>> On Jul 30, 2019, at 12:28 PM, Chip Scheide via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>> 
>> I am playing with a method to extract the Body of emails to a plain 
>> text file
>> I am using a trash folder which contains a bunch of spam...
>> 
>> When I extract the subject I get the following text (as the subject):
>> =?UTF-8?B?RG9lcyB5b3VyIGNvbXBhbnkgb2ZmZXIgaW5zdXJhbuKFvWU/?=
>> 
>> How do I go about decoding the above line of text.
>> 
>> Thanks
>> Chip
>> ---
>> 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
>> **
> 
> 
---
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 decode this text

[Chip Scheide via 4D_Tech]

I am playing with a method to extract the Body of emails to a plain 
text file
I am using a trash folder which contains a bunch of spam...

When I extract the subject I get the following text (as the subject):
=?UTF-8?B?RG9lcyB5b3VyIGNvbXBhbnkgb2ZmZXIgaW5zdXJhbuKFvWU/?=

How do I go about decoding the above line of text.

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

Re: Creating Hierarchical Listbox

[Chip Scheide via 4D_Tech]

there is a functional example of listbox hierarchical lists in 4Dpop constants 
editor


> Hi
> I havent used this kind of listbox before so a few pointers would be
> gratefully received.
> At the moment my listbox contains 9 columns, some hidden, some not.
> One of the arrays holds information as to whether a row is designated as
> "start" or "end"
> If a row is designated as "Start", columns 1,2,3,4,5,7.9 are populated the
> remaining columns are ""
> if a row is designtaed as "End", columns 6,8,9 are populated the remaining
> columns are ""
> I want the start columns to be the top level, and the end columns to be the
> second level of the hierarchy.
> So I can collapse the rows to show only the top level rows (starts), or
> expand the rows to show the top level rows with the second level rows
> underneath them, sorted in chronological order.
> Start
> End
> Start
> End
> ...
> Is what I'm asking even possible and if so how do I go about it.
> I considered using ListBox Set Row Height and setting the row height to 0,
> so as not to display it. but this command is not available in v13
> thanks for any help
> 
> -pm
> 4D v13.6  Mac OS High Sierra
> **
> 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
> **

Hell is other people 
 Jean-Paul Sartre
**
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: SQL - renaming a field

[Chip Scheide via 4D_Tech]

Good point -
I already simply forgot about trying to rename.

In concept it would not be an issue as I was only going to rename a 
field named 'Unused'
But there were other considerations to renaming that occurred to me 
after I posted.

in sql - if rename works, I do not see a way to redefine the column 
from say text to longint.
I did not try changing the column definition
unused as real  vs  existing data type of text

anyway - that part of the idea is dead.

Thanks!

Chip

On Fri, 26 Jul 2019 13:56:58 -0500, Stephen J. Orth wrote:
> Chip,
> 
> That kind of sucks because doesn't a "drop" destroy data?
> 
> Steve
> 
> -Original Message-
> From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Chip 
> Scheide via 4D_Tech
> Sent: Friday, July 26, 2019 1:46 PM
> To: Tom Benedict 
> Cc: Chip Scheide <4d_o...@pghrepository.org>; 4D iNug Technical 
> <4d_tech@lists.4d.com>
> Subject: Re: SQL - renaming a field
> 
> OK
> 
> Thanks both
> 
> I guess rename is only possible as Drop + Add
> 
> Chip
> 
> 
---
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
**

Re: SQL - renaming a field

[Chip Scheide via 4D_Tech]

OK

Thanks both

I guess rename is only possible as Drop + Add

Chip

On Fri, 26 Jul 2019 11:42:49 -0700, Tom Benedict wrote:
> Maybe 4D’s SQL implementation doesn’t support the RENAME keyword?
> 
> I don’t see it in the docs.. 
> https://doc.4d.com/4Dv16/4D/16/ALTER-TABLE.300-3201314.en.html 
> <https://doc.4d.com/4Dv16/4D/16/ALTER-TABLE.300-3201314.en.html>
> 
> Tom Benedict
> 
>> On Jul 26, 2019, at 11:30, Chip Scheide via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>> 
>> I'm trying to use SQL to rename an existing field
>> $Sql:="Alter table ["+$Table_Name+"] Rename "+"Unused"+" to 
>> "+$Field_Name+";"
>> 
>> When executed I get a parsing error at 'Rename'.
>> 
>> can someone better versed either correct my above syntax, or point out 
>> a way to rename an existing field using SQL, -- preferably without 
>> dropping and then adding.
>> 
>> Thanks
>> Chip
---
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
**

SQL - renaming a field

[Chip Scheide via 4D_Tech]

I'm trying to use SQL to rename an existing field
$Sql:="Alter table ["+$Table_Name+"] Rename "+"Unused"+" to 
"+$Field_Name+";"

When executed I get a parsing error at 'Rename'.

can someone better versed either correct my above syntax, or point out 
a way to rename an existing field using SQL, -- preferably without 
dropping and then adding.

Thanks
Chip

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

Re: Find in Design and Replace

[Chip Scheide via 4D_Tech]

keisuke,
Thanks.
I thought of that, but...

Basically I am modifying 50 or so method calls, and the modification adds 
'Count parameters' as a parameter, this make the method calls aesthetically 
displeasing to me as they are "too long"; so this is a 'One off' instance.

I just did not want to manually add a "\ + Cr" to wrap the code, and I probably 
will not.

It is not a big deal, I was just hoping someone had managed to get either Find 
in design, or find and replace to accept as a replacement character a return.

The '\' character is actually no problem to get inserted, it is the return that 
neither replace service wants to handle.
I did try inserting "\r", but that just inserted those specific characters.  :)

Chip


> I think the best way is to use METHOD GET CODE/METHOD SET CODE,
> and do the replacement using code.
> 
> 4D tends to self-correct backslashed inserted in the middle of a token,
> so you might need to regex your way to find the right insertion point.
> 
>> 2019/07/26 2:57、Chip Scheide via 4D_Tech <4d_tech@lists.4d.com>のメール:
>> 
>> for example I have:
>> very very long line of code
>> 
>> I would like to replace this with
>> very very\
>>  long Line\
>>  of code
> 
> 
> 
> 
> **
> 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
> **

Hell is other people 
 Jean-Paul Sartre
**
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: Error -1 using SQL.

[Chip Scheide via 4D_Tech]

Thanks -
I just found that code in another method I am working with -- copied 
fromsomewhere  :)

Chip

On Thu, 25 Jul 2019 15:43:49 -0400, Chuck Miller via 4D_Tech wrote:
> You can write the code to see if there is already a primary key and 
> not do the alter if there is
> It is one 
> of the hidden sql tables
> 
> Array longint(constraintids_al;0)
> Array longint(tablenumbers_al;0)
> 
> Begin sql
> Select constraints_id, table_id
> From _user_constraints 
> Where constraint_type =‘P’
> Into 
> :constraintids_al,
> :tablenumbers_al;
> End sql
> Regards 
> 
> Chuck 
> 
> Sent from my iPhone
> 
>> On Jul 25, 2019, at 3:16 PM, Chip Scheide via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>> 
>> I am working up a method to set the primary key property on a field.
>> I am using SQL to do this, as it seems the only way.
>> 
>> I have working code, but - I noticed if I try to apply the primary key 
>> property a second time I get a runtime error either 43 or 44 with the 
>> message : Failed to execute ALTER TABLE command.
>> 
>> So... naturally I setup an ON ERR CALL method to catch and report the 
>> problem. However, the error call routine does NOT get either error 43 
>> nor 44, it gets error -1!.
>> 
>> If I remove the ON ERR CALL and generate the error, I get a 4D runtime 
>> error dialog  with error 43 or 44, install ON ERR CALL and get error -1.
>> 
>> Any insights?
>> 
>> Thanks
>> Chip
>> ---
>> 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
>> **
> 
> **
> 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
> **
---
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
**

Re: REATE SELECTION FROM ARRAY

[Chip Scheide via 4D_Tech]

Ferdinando 

to test:
in one process: create (or edit) a record
in a second process: put the record number of the new/edited record 
into an array
and create selection from array 

if you get the error then this is the problem, 
you might be able to catch the error with an On Err Call method.
If you do not get the error - then I would run MSC and repair the data 
file.

Chip

On Wed, 24 Jul 2019 21:42:38 +0200, stardata.info wrote:
> Hi Chip,
> 
> The database is ok.
> 
> Consider that this issue appares when in another process one user add 
> the record that GOTO RECORD must to select.
> 
> After this issue disappares and all work normally.
> 
> I suspect that in some cases these means that the record is locked, 
> because the same record number after some minutes work.
> 
> For this reason i think that the record that give this issue can be locked.
> 
> Thanks
> Ferdinando
> 
> Il 24/07/19 21:31, Chip Scheide ha scritto:
>> Ferdinando,
>>  From the language reference:
>> Error -10503 - Record # is out of range (during GOTO RECORD, or data
>> file needs to be repaired). (see note 3)
>> 
>> Note 3:
>> The error -10503 Record # is out of range generally means that your
>> code (for example, the GOTO RECORD command) is attempting to access a
>> record that no longer exists (or has never existed). In certain more
>> unusual cases, this error may mean that the database needs repairing.
>> 
>> Repair the data file.
>> 
>> Chip
>> On Wed, 24 Jul 2019 21:22:35 +0200, stardata.info via 4D_Tech wrote:
>>> i all,
>>> 
>>> I use CREATE SELECTION FROM ARRAY([table];Array_Record_Number)
>>> command, in a 4D application in V13.2 on windows.
>>> Sometimes I have an error -10503, the record number is correct and
>>> the record exists. Are always a new records created from another
>>> process, is possible that the record that give -10503 is locked?
>>> I done several check but i cannot reproduce the conditions as happen
>>> in the customer installation.
>>> 
>>> Thanks
>>> Ferdinando
>>> 
>>> Il 24/07/19 21:00, 4d_tech-requ...@lists.4d.com ha scritto:
 Send 4D_Tech mailing list submissions to
4d_tech@lists.4d.com
 
 To subscribe or unsubscribe via the World Wide Web, visit
https://lists.4d.com/mailman/listinfo/4d_tech
 or, via email, send a message with subject or body 'help' to
4d_tech-requ...@lists.4d.com
 
 You can reach the person managing the list at
4d_tech-ow...@lists.4d.com
 
 When replying, please edit your Subject line so it is more specific
 than "Re: Contents of 4D_Tech digest..."
 
 
 Today's Topics:
 
  1. Re: PDF Viewer (UKVetDerm)
  2. Re: 4D eMail Editor - full HTML support (Paul Dennis)
  3. Re: Static Pictures to Library Pictures (Tom Benedict)
  4. Re: Static Pictures to Library Pictures (Charles Miller)
  5. Re: Static Pictures to Library Pictures (Chip Scheide)
  6. Re: Static Pictures to Library Pictures (Charles Miller)
 
 
 --
 
 Message: 1
 Date: Wed, 24 Jul 2019 05:47:14 +
 From: UKVetDerm 
 To: 4D iNug Technical <4d_tech@lists.4d.com>
 Subject: Re: PDF Viewer
 Message-ID: 
 Content-Type: text/plain; charset="utf-8"
 
 Hi Koen
 
 Yes I have had an update today directly from Rob and all is well.
 This remains a very good plug-in purchase. Steve
 
 On 23/07/2019, 13:54, "4D_Tech on behalf of Koen Van Hooreweghe via
 4D_Tech" <4d_tech-boun...@lists.4d.com on behalf of
 4d_tech@lists.4d.com> wrote:
 
   Hi Steve,
IIRC I've had some issues with PDF Viewer plugin when
 moving to 4D v17 even on older macOS than Mojave. Rob Lavaux from
 pluggers.nl promptly fixed them. You should contact him to get your
 issues solved. I personally do prefer PDF Viewer instead of picture
 fields or web areas (on mac).
Rob might be on holiday right now, but normally he
 responds pretty quickly.
HTH
   Koen
 > Op 22 jul. 2019, om 21:48 heeft UKVetDerm via 4D_Tech
 <4d_tech@lists.4d.com> het volgende geschreven:
   >
   > Anyone having difficulties with Mac PDF Viewer plugin (2.01)
 with Mojave and v17 (r4 and r5) 64 bit. Can’t decide whether I have
 a bad form or there is a more systemic problem.
  
   Compass bvba
   Koen Van Hooreweghe
   Kloosterstraat 65
   9910 Aalter
   Belgium
   tel +32 495 511.653

 **
   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: REATE SELECTION FROM ARRAY

[Chip Scheide via 4D_Tech]

Ferdinando,
From the language reference:
Error -10503 - Record # is out of range (during GOTO RECORD, or data 
file needs to be repaired). (see note 3)

Note 3:
The error -10503 Record # is out of range generally means that your 
code (for example, the GOTO RECORD command) is attempting to access a 
record that no longer exists (or has never existed). In certain more 
unusual cases, this error may mean that the database needs repairing.

Repair the data file.

Chip
On Wed, 24 Jul 2019 21:22:35 +0200, stardata.info via 4D_Tech wrote:
> i all,
> 
> I use CREATE SELECTION FROM ARRAY([table];Array_Record_Number) 
> command, in a 4D application in V13.2 on windows.
> Sometimes I have an error -10503, the record number is correct and 
> the record exists. Are always a new records created from another 
> process, is possible that the record that give -10503 is locked?
> I done several check but i cannot reproduce the conditions as happen 
> in the customer installation.
> 
> Thanks
> Ferdinando
> 
> Il 24/07/19 21:00, 4d_tech-requ...@lists.4d.com ha scritto:
>> Send 4D_Tech mailing list submissions to
>>  4d_tech@lists.4d.com
>> 
>> To subscribe or unsubscribe via the World Wide Web, visit
>>  https://lists.4d.com/mailman/listinfo/4d_tech
>> or, via email, send a message with subject or body 'help' to
>>  4d_tech-requ...@lists.4d.com
>> 
>> You can reach the person managing the list at
>>  4d_tech-ow...@lists.4d.com
>> 
>> When replying, please edit your Subject line so it is more specific
>> than "Re: Contents of 4D_Tech digest..."
>> 
>> 
>> Today's Topics:
>> 
>> 1. Re: PDF Viewer (UKVetDerm)
>> 2. Re: 4D eMail Editor - full HTML support (Paul Dennis)
>> 3. Re: Static Pictures to Library Pictures (Tom Benedict)
>> 4. Re: Static Pictures to Library Pictures (Charles Miller)
>> 5. Re: Static Pictures to Library Pictures (Chip Scheide)
>> 6. Re: Static Pictures to Library Pictures (Charles Miller)
>> 
>> 
>> --
>> 
>> Message: 1
>> Date: Wed, 24 Jul 2019 05:47:14 +
>> From: UKVetDerm 
>> To: 4D iNug Technical <4d_tech@lists.4d.com>
>> Subject: Re: PDF Viewer
>> Message-ID: 
>> Content-Type: text/plain; charset="utf-8"
>> 
>> Hi Koen
>> 
>> Yes I have had an update today directly from Rob and all is well. 
>> This remains a very good plug-in purchase. Steve
>> 
>> On 23/07/2019, 13:54, "4D_Tech on behalf of Koen Van Hooreweghe via 
>> 4D_Tech" <4d_tech-boun...@lists.4d.com on behalf of 
>> 4d_tech@lists.4d.com> wrote:
>> 
>>  Hi Steve,
>>   IIRC I've had some issues with PDF Viewer plugin when 
>> moving to 4D v17 even on older macOS than Mojave. Rob Lavaux from 
>> pluggers.nl promptly fixed them. You should contact him to get your 
>> issues solved. I personally do prefer PDF Viewer instead of picture 
>> fields or web areas (on mac).
>>   Rob might be on holiday right now, but normally he 
>> responds pretty quickly.
>>   HTH
>>  Koen
>>> Op 22 jul. 2019, om 21:48 heeft UKVetDerm via 4D_Tech 
>> <4d_tech@lists.4d.com> het volgende geschreven:
>>  >
>>  > Anyone having difficulties with Mac PDF Viewer plugin (2.01) 
>> with Mojave and v17 (r4 and r5) 64 bit. Can’t decide whether I have 
>> a bad form or there is a more systemic problem.
>> 
>>  Compass bvba
>>  Koen Van Hooreweghe
>>  Kloosterstraat 65
>>  9910 Aalter
>>  Belgium
>>  tel +32 495 511.653
>>   
>> **
>>  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
>>  **
>> 
>> 
>> --
>> 
>> Message: 2
>> Date: Wed, 24 Jul 2019 00:56:07 -0700 (MST)
>> From: Paul Dennis 
>> To: 4d_tech@lists.4d.com
>> Subject: Re: 4D eMail Editor - full HTML support
>> Message-ID: <1563954967911-0.p...@n5.nabble.com>
>> Content-Type: text/plain; charset=us-ascii
>> 
>> Chuck,
>> We have a template system for email replies so need to view in 4d and auto
>> generate email contents. We import emails via exchange/imap parse the mime
>> results all works ok HTMl is valid but write pro does not open or format
>> correctly at the moment. Thomas Maul confirmed the format needs to xhmtl.
>> Paul
>> 
>> 
>> 
>> --
>> Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
>> 
>> 
>> --
>> 
>> Message: 3
>> Date: Wed, 24 Jul 2019 09:11:30 -0700
>> From: Tom Benedict 
>> To: 4D iNug Technical <4d_tech@lists.4d.com>
>> Cc: Chuck Miller , Ben Sokal
>>  
>> Subject: Re: Static Pictures to Library Pictures
>> Message-ID: <7c0d5b3e-730d-4c71-a899-39e507ad8...@comcast.net>
>> Content-Type: 

Writting code to disk

[Chip Scheide via 4D_Tech]

When exporting 4D code does it matter in what way the text of the code 
is written to disK?
i.e.
- send packet
- variable to blob, blob to document
- text to blob blob to document
etc.

Chip

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

Re: How to Catch Paste Action

[Chip Scheide via 4D_Tech]

Thanks!

I need the timer to trigger the lookup - 
ex: 
Criteria -> Fred  execute lookup on 'Fred'

want to do the same with pasted data 



> Chip,
> 
> Try using On After Edit event in your enterable object. That should 
> work without involving On Timer event. However, you will need to use 
> Get edited text command to get the data.
> 
> HTH,
> Add
> 
> 
> 
> 
> On 7/19/19, 2:59 PM, "4D_Tech on behalf of Chip Scheide via 4D_Tech" 
> <4d_tech-boun...@lists.4d.com on behalf of 4d_tech@lists.4d.com> 
> wrote:
> 
> I have a variable in which the user enters search criteria.
> They can paste from elsewhere also (as it is just text).
> 
> everything works as I want when typing, but nothing happens when the
> user pastes, until they tab or click outside of the entry area.
> 
> I would like to catch the paste action, and set a timer (which is what
> happen with typing), to trigger the search.
> 
> Thanks
> Chip
> 
> Hell is other people
>  Jean-Paul Sartre
> **
> 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
> **

Hell is other people 
 Jean-Paul Sartre
**
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 Catch Paste Action

[Chip Scheide via 4D_Tech]

I have a variable in which the user enters search criteria.
They can paste from elsewhere also (as it is just text).

everything works as I want when typing, but nothing happens when the 
user pastes, until they tab or click outside of the entry area.

I would like to catch the paste action, and set a timer (which is what 
happen with typing), to trigger the search.

Thanks
Chip

Hell is other people 
 Jean-Paul Sartre
**
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: Get System Info vs PLATFORM PROPERTIES

[Chip Scheide via 4D_Tech]

probably just the major version info
Windows : XP, 7, 8, or 10
Mac : 10.9, 10.10, 10.11 ...


so far, for me, I only need to differentiate between platforms, not OSes
so when I need

if (Folder separator = ":") `this is a mac
  do mac stuff
else
  do windows stuff
end if

Chip

On Thu, 18 Jul 2019 15:46:26 +, Keisuke Miyako via 4D_Tech wrote:
> Hello,
> 
> I think the verbose version string is for human consumption,
> for example, to help the end user or support contact identify the 
> running platform.
> 
> I can't think of any situation where the internal build number would 
> be needed in 4D code.
> 
> For osVersion, I think it would help if there was a property that 
> just returned the long int value of the os, ie. osVersioinNumber -> 
> 10.0.14393
> 
> 
> 
> **
> 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
> **
---
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
**

Re: Silly question?

[Chip Scheide via 4D_Tech]

aren't headers an all or nothing thing?
either all headers are visible or all headers are not

There is a design environment setting for headers, and a separate 
setting for visible, BUT there does not appear to be a command (v15) to 
get or set the header visibility as part of the listbox commands.

soo.. I would think that you probably need to set the visibility of ALL 
headers to invisible to get the header row to go away

Chip
On Fri, 12 Jul 2019 16:14:07 +0100, Jeremy Roussak via 4D_Tech wrote:
> This may seem a silly question, but…
> 
> 
> I have a listbox (selection type). It’s in a subform.
> I get the names of the headers using LISTBOX GET ARRAYS into 
> <>headerNames, a text array (it’s a global for debugging only).
> I call OBJECT SET VISIBLE(*;<>headerNames{1};False).
> In the debugger, I can see that OBJECT GET 
> VISIBLE(*;<>headerNames{1}) changes from True to False.
> 
> Yet the listbox is drawn with the headers visible. 
> 
> I drop back into the debugger. OBJECT GET VISIBLE(*;<>headerNames{1}) 
> is still False, yet there the headers are, plainly visible.
> 
> This is generic code; other instances of the subform behave as 
> expected, with the headers visible or not visible as specified. Only 
> this one instance doesn’t behave.
> 
> I’m bewildered! Is there a rational explanation?
> 
> Jeremy
> 
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
---
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
**

Re: Splitter behaviour

[Chip Scheide via 4D_Tech]

Pat,
While I am not using v17, and have not seen this exact behavior...
I have seen similar behavior with Sliders and pushers.

The form resizing issue is related to 1 or more objects being at least 
partially off window to the right.
Once an object over laps, or extends past the right side of the window 
crazy things happen.
Oh.. and 4D tech claims - expected/normal behavior

If the object is visible (like a button or text area) widening the 
window will cause the object to grow - at least geometrically, if not 
exponentially.

The only way I found to deal with this issue was to have code in the On 
ReSize event and for your hierarchical listbox I would also suggest the 
On Expand event which looks at the right most object on the form, and 
compares its position with the window width and grow the window if the 
right most object is <=10 pixels from the edge.

I did this, it sort of worked... most of the time it functioned, but if 
the slider movement was too fast or too large the window resizing code 
would not be called enough/soon enough resulting in the undesired 
behavior anyway.

I looked for code, but I think it is locked up in a v2003 system...


As for the expanded list text ... I would be sure that the alignment 
for the listbox and the column(s) was left and not right.  That might 
help. Also try enabling horizontal scroll bar, that *should* allow you 
to scroll back to the left to view the now expanded text.


On Fri, 12 Jul 2019 15:34:50 +0100, Pat Bensky via 4D_Tech wrote:
> Using v17 r5, Mac
> I have a form with a splitter on it. To the left of the splitter is a
> hierarchical list and two buttons. To the right of the splitter are a
> varying number of objects depending on what's being displayed.
> The properties of the splitter are
> Horizontal sizing: move
> Vertical sizing: grow
> Pusher: true
> 
> So, I want to make the hierarchical list wider as some of its content is
> hidden. I move the splitter to the right a bit. That's fine.
> Now I expand one of the items in the hierarchical list. The expanded list
> it displayed, but the view of the list shifts to the right so that the left
> side of it disappears off the edge of the form. Nothing you do can make it
> return to normal - the only solution is to close the window and open a new
> one.
> 
> Additionally, if I try to resize the window by dragging the bottom right
> corner, instead of making it smaller it makes it bigger! I'm dragging left
> but the window is getting wider! Sometimes it goes really bananas and
> instantly makes the window HUGE.
> 
> This is the sort of thing that drives users crazy!
> 
> Any ideas?
> 
> Pat
> 
> 
> 
> 
> -- 
> *
> CatBase - Top Dog in Data Publishing
> tel: +44 (0) 207 118 7889
> w: http://www.catbase.com
> skype: pat.bensky
> *
> **
> 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
> **
---
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
**

Re: What is wrong with this statement? Corrected

[Chip Scheide via 4D_Tech]

; > there should not be an issue with a valid formula 
> inside set 
> > > brackets
> > > ohh well...
> > > 
> > > Chip
> > > 
> > > 
> > > On Tue, 09 Jul 2019 17:32:10 +0100, Narinder Chandi via 
> > 4D_Tech wrote:
> > > > Does it work if you do use an intermediate value? e.g.
> > > > 
> > > > $value:= $Return_ptr-> {$Item}
> > > > $Result:= $Column1 ->{$value}
> > > > 
> >     >     > Regards,
> > > >  
> > > > Narinder Chandi,
> > > > ToolBox Systems Ltd.
> > > > -- 
> > > > 
> > > > -Original Message-
> > > > From: 4D_Tech <4d_tech-boun...@lists.4d.com> on behalf of 
> > 4D Tech 
> > > > Mailing List <4d_tech@lists.4d.com>
> > > > Reply-To: 4D Tech Mailing List <4d_tech@lists.4d.com>
> > > > Date: Tuesday, 9 July 2019 at 17:16
> > > > To: 4D Tech Mailing List <4d_tech@lists.4d.com>
> > > > Cc: Chip Scheide <4d_o...@pghrepository.org>
> > > > Subject: Re: What is wrong with this statement? Corrected
> > > > 
> > > > My bad -- the correct line of code that is failing is:
> > > > $Result:= $Column1 ->{ $Return_ptr-> {$Item} }
> > > > 
> > > > On Tue, 9 Jul 2019 12:14:37 -0400, Chip Scheide via 
> > 4D_Tech wrote:
> > > > > $Result:= $Column1{ $Return_ptr{$Item} }
> > > > ---
> > > > 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
> > > > 
> > > 
> **
> > > > 
> > > > 
> > > > 
> > **
> > > > 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
> > > > 
> > **
> > > ---
> > > 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
> > > 
> **
> > ---
> > 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
> > 
> **
> > 
> > 
> > **
> > 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
> > **
> ---
> 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
> **
---
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
**

Re: What is wrong with this statement? Corrected

[Chip Scheide via 4D_Tech]

hmm v12...

OK - I tracked it down.

It has to do with Listboxes
a 'normal' array works as expected, however, if the array is a listbox 
column (array based - did not try a selection listbox) then the code 
fails.

For some reason, when referencing the contents of a listbox column the 
value inside the { } can not be an expression (at least in v13). Even a 
simple expression {2+8-6} fails.

Chip



On Tue, 09 Jul 2019 19:32:05 +0100, Narinder Chandi via 4D_Tech wrote:
> That was with 17.2 Mac and I also tested the same code just now with 
> 15.4 Mac and 12.4 Mac successfully too.
> 
> Regards,
>  
> Narinder Chandi,
> ToolBox Systems Ltd.
> -- 
> 
> -Original Message-
> From: 4D_Tech <4d_tech-boun...@lists.4d.com> on behalf of 4D Tech 
> Mailing List <4d_tech@lists.4d.com>
> Reply-To: 4D Tech Mailing List <4d_tech@lists.4d.com>
> Date: Tuesday, 9 July 2019 at 19:16
> To: 4D Tech Mailing List <4d_tech@lists.4d.com>
> Cc: Chip Scheide <4d_o...@pghrepository.org>
> Subject: Re: What is wrong with this statement? Corrected
> 
> what version - it might be that the issue is resolved in a newer 
> version (>v13) then I am working in...
> 
> On Tue, 09 Jul 2019 18:30:33 +0100, Narinder Chandi via 4D_Tech wrote:
> > Chip,
> > 
> > If I interpreted it correctly, I just created this code block based 
> > on your spec. and variable naming:
> > 
> > ARRAY LONGINT(array1;2)
> > array1{1}:=4
> > array1{2}:=2
> > 
> > ARRAY LONGINT(array2;10)
> > C_LONGINT($i)
> > For ($i;1;10)
> >   array2{$i}:=-$i
> > End for
> > 
> > C_POINTER($Return_ptr)
> > C_POINTER($Column1)
> > $Return_ptr:=->array1
> > $Column1:=->array2
> > 
> > C_LONGINT($Item)
> > $Item:=2
> > 
> > C_LONGINT($Result)
> > $Result:=$Column1->{$Return_ptr->{$Item}}
> > TRACE
> > 
> > It doesn't generate an error for me and the debugger shows the 
> > expected values when I execute it. Is my implementation "incorrect"? 
> > ...or there is it down to some other issue??
> > 
> > Regards,
> > Narinder Chandi,
> > ToolBox Systems Ltd.
> > -- 
> > 
> > -Original Message-
> > From: Chip Scheide <4d_o...@pghrepository.org>
> > Date: Tuesday, 9 July 2019 at 17:57
> > To: 4D Tech Mailing List <4d_tech@lists.4d.com>
> > Cc: Narinder Chandi <4dtechmailingl...@toolbox.uk.com>
> > Subject: Re: What is wrong with this statement? Corrected
> > 
> > yes - an intermediate value works, I was more wondering why the 
> > original statement will not work...
> > as it appears to be a perfectly valid statement.
> > 
> > Replacing the array element reference with a simple math 
> formula works. 
> > i.e.
> > Array{2+8-6} 
> > give the value of element 4 (assuming there is one)
> > 
> > there should not be an issue with a valid formula inside set 
> > brackets
> > ohh well...
> > 
> > Chip
> > 
> > 
> > On Tue, 09 Jul 2019 17:32:10 +0100, Narinder Chandi via 
> 4D_Tech wrote:
> > > Does it work if you do use an intermediate value? e.g.
> > > 
> > > $value:= $Return_ptr-> {$Item}
> > > $Result:= $Column1 ->{$value}
> > > 
> > > Regards,
> > >  
> > > Narinder Chandi,
> > > ToolBox Systems Ltd.
> > > -- 
> > > 
> > > -Original Message-
> > > From: 4D_Tech <4d_tech-boun...@lists.4d.com> on behalf of 
> 4D Tech 
> > > Mailing List <4d_tech@lists.4d.com>
> > > Reply-To: 4D Tech Mailing List <4d_tech@lists.4d.com>
> > > Date: Tuesday, 9 July 2019 at 17:16
> > > To: 4D Tech Mailing List <4d_tech@lists.4d.com>
> > > Cc: Chip Scheide <4d_o...@pghrepository.org>
> > > Subject: Re: What is wrong with this statement? Corrected
> > > 
> > > My bad -- the correct line of code that is failing is:
> > 

Re: What is wrong with this statement? Corrected

[Chip Scheide via 4D_Tech]

what version - it might be that the issue is resolved in a newer 
version (>v13) then I am working in...

On Tue, 09 Jul 2019 18:30:33 +0100, Narinder Chandi via 4D_Tech wrote:
> Chip,
> 
> If I interpreted it correctly, I just created this code block based 
> on your spec. and variable naming:
> 
> ARRAY LONGINT(array1;2)
> array1{1}:=4
> array1{2}:=2
> 
> ARRAY LONGINT(array2;10)
> C_LONGINT($i)
> For ($i;1;10)
>   array2{$i}:=-$i
> End for
> 
> C_POINTER($Return_ptr)
> C_POINTER($Column1)
> $Return_ptr:=->array1
> $Column1:=->array2
> 
> C_LONGINT($Item)
> $Item:=2
> 
> C_LONGINT($Result)
> $Result:=$Column1->{$Return_ptr->{$Item}}
> TRACE
> 
> It doesn't generate an error for me and the debugger shows the 
> expected values when I execute it. Is my implementation "incorrect"? 
> ...or there is it down to some other issue??
> 
> Regards,
> Narinder Chandi,
> ToolBox Systems Ltd.
> -- 
> 
> -Original Message-
> From: Chip Scheide <4d_o...@pghrepository.org>
> Date: Tuesday, 9 July 2019 at 17:57
> To: 4D Tech Mailing List <4d_tech@lists.4d.com>
> Cc: Narinder Chandi <4dtechmailingl...@toolbox.uk.com>
> Subject: Re: What is wrong with this statement? Corrected
> 
> yes - an intermediate value works, I was more wondering why the 
> original statement will not work...
> as it appears to be a perfectly valid statement.
> 
> Replacing the array element reference with a simple math formula works. 
> i.e.
> Array{2+8-6} 
> give the value of element 4 (assuming there is one)
> 
> there should not be an issue with a valid formula inside set 
> brackets
> ohh well...
> 
> Chip
> 
> 
> On Tue, 09 Jul 2019 17:32:10 +0100, Narinder Chandi via 4D_Tech wrote:
> > Does it work if you do use an intermediate value? e.g.
> > 
> > $value:= $Return_ptr-> {$Item}
> > $Result:= $Column1 ->{$value}
> > 
> > Regards,
> >  
> > Narinder Chandi,
> > ToolBox Systems Ltd.
> > -- 
> > 
> > -Original Message-
> > From: 4D_Tech <4d_tech-boun...@lists.4d.com> on behalf of 4D Tech 
> > Mailing List <4d_tech@lists.4d.com>
> > Reply-To: 4D Tech Mailing List <4d_tech@lists.4d.com>
> > Date: Tuesday, 9 July 2019 at 17:16
> > To: 4D Tech Mailing List <4d_tech@lists.4d.com>
> > Cc: Chip Scheide <4d_o...@pghrepository.org>
> > Subject: Re: What is wrong with this statement? Corrected
> > 
> > My bad -- the correct line of code that is failing is:
> > $Result:= $Column1 ->{ $Return_ptr-> {$Item} }
> > 
> > On Tue, 9 Jul 2019 12:14:37 -0400, Chip Scheide via 4D_Tech wrote:
> > > $Result:= $Column1{ $Return_ptr{$Item} }
> > ---
> > 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
> > 
> **
> > 
> > 
> > **
> > 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
> > **
> ---
> 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
> **
---
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
**

Re: What is wrong with this statement? Corrected

[Chip Scheide via 4D_Tech]

yes - an intermediate value works, I was more wondering why the 
original statement will not work...
as it appears to be a perfectly valid statement.

Replacing the array element reference with a simple math formula works. 
i.e.
Array{2+8-6} 
give the value of element 4 (assuming there is one)

there should not be an issue with a valid formula inside set 
brackets
ohh well...

Chip


On Tue, 09 Jul 2019 17:32:10 +0100, Narinder Chandi via 4D_Tech wrote:
> Does it work if you do use an intermediate value? e.g.
> 
> $value:= $Return_ptr-> {$Item}
> $Result:= $Column1 ->{$value}
> 
> Regards,
>  
> Narinder Chandi,
> ToolBox Systems Ltd.
> -- 
> 
> -Original Message-
> From: 4D_Tech <4d_tech-boun...@lists.4d.com> on behalf of 4D Tech 
> Mailing List <4d_tech@lists.4d.com>
> Reply-To: 4D Tech Mailing List <4d_tech@lists.4d.com>
> Date: Tuesday, 9 July 2019 at 17:16
> To: 4D Tech Mailing List <4d_tech@lists.4d.com>
> Cc: Chip Scheide <4d_o...@pghrepository.org>
> Subject: Re: What is wrong with this statement? Corrected
> 
> My bad -- the correct line of code that is failing is:
>     $Result:= $Column1 ->{ $Return_ptr-> {$Item} }
> 
> On Tue, 9 Jul 2019 12:14:37 -0400, Chip Scheide via 4D_Tech wrote:
> > $Result:= $Column1{ $Return_ptr{$Item} }
> ---
> 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
> **
> 
> 
> **
> 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
> **
---
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
**

Re: What is wrong with this statement? Corrected

[Chip Scheide via 4D_Tech]

My bad -- the correct line of code that is failing is:
$Result:= $Column1 ->{ $Return_ptr-> {$Item} }

On Tue, 9 Jul 2019 12:14:37 -0400, Chip Scheide via 4D_Tech wrote:
> $Result:= $Column1{ $Return_ptr{$Item} }
---
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
**

What is wrong with this statement?

[Chip Scheide via 4D_Tech]

Given:
-- $Return_ptr is a pointer to a longint array
  --- Array has 2 elements values of (4, 2)
-- $Column1 is a pointer to a different array which has 10 elements
  --- all elements are populated
-- $Item is a longint value as index to the array
-- $Result is a longint variable

(spacing added for clarity)
$Result:= $Column1{ $Return_ptr{$Item} }

4D throws an Error 52
$Return_ptr{$Item} = 4
$Column1 {4} = 100

inserting parenthesis around ( $Return_ptr{$Item} ) does not resolve 
the problem.
Any idea why 4D is choking on this line of code??


Thanks
Chip

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

Re: The set does not exist

[Chip Scheide via 4D_Tech]

The highlight set for a listbox is set in the listbox properties.
If this is empty, then there is no highlight set. If the listbox set name you 
are trying to use does not match the listbox set name property then you are not 
going to get the anwer(s) you expect.

If you want I have an  old demo/source code for list boxes which I'll share, 
send me an email

Chip
> Replying to myself here(!) but I should also have mentioned a third 
> thing to check:
> 
> * have you used the correct name in the $ListBoxName variable?
> * what does $tableNum contain? It should be a valid table number
> * check the contents of $highlightSet - it should be a non-empty string
> 
> Regards,
>  
> Narinder Chandi,
> ToolBox Systems Ltd.
> -- 
> 
> -Original Message-
> From: 4D_Tech <4d_tech-boun...@lists.4d.com> on behalf of 4D Tech 
> Mailing List <4d_tech@lists.4d.com>
> Reply-To: 4D Tech Mailing List <4d_tech@lists.4d.com>
> Date: Saturday, 6 July 2019 at 12:24
> To: 4D Tech Mailing List <4d_tech@lists.4d.com>
> Cc: Narinder Chandi <4dtechmailingl...@toolbox.uk.com>
> Subject: Re: The set does not exist
> 
> Carl,
> 
> Hi. Couple of obvious things to check:
> * have you used the correct name in the $ListBoxName variable?
> * what does $tableNum contain? It should be a valid table number
> 
> Regards,
>  
> Narinder Chandi,
> ToolBox Systems Ltd.
> -- 
> 
> -Original Message-
> From: 4D_Tech <4d_tech-boun...@lists.4d.com> on behalf of 4D Tech 
> Mailing List <4d_tech@lists.4d.com>
> Reply-To: 4D Tech Mailing List <4d_tech@lists.4d.com>
> Date: Saturday, 6 July 2019 at 11:59
> To: 4D Tech Mailing List <4d_tech@lists.4d.com>
> Cc: Carl Aage Wangel 
> Subject: The set does not exist
> 
> Using the following method, I get the error "The set does not 
> exist".
> 
> $ListBoxName:="ListBoxObjectName"
> 
> LISTBOX GET TABLE
> SOURCE(*;$ListBoxName;$tableNum;$namedSelection;$highlightSet)
> 
> USE SET($highlightSet)
> 
> I select records (rows) from the listbox before running the method.
> 
> I obviously have a lack of knowledge. Can anyone guide me in 
> the right
> direction? Can't find anything in 4D Knowledge Base.
> 
> Regards
> 
> Carl
> 
>  
> 
> 
> **
> 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
> **
> 
> 
> **
> 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
> **

Hell is other people 
 Jean-Paul Sartre
**
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: [off]Apple script issue

[Chip Scheide via 4D_Tech]

this one got away - it was supposed to have been deleted - so feel free 
to ignore

sorry :)

On Wed, 3 Jul 2019 15:51:28 -0400, Chip Scheide via 4D_Tech wrote:
> Not been really following...
> 
> Are you creating the PDF?
> if so, then you should be able to create the pdf such that it is 100% 
> (or maybe better 95%) maybe th
> 
> On Wed, 3 Jul 2019 15:23:10 -0400, Chuck Miller via 4D_Tech wrote:
>> Thanks it got me the following:
>> 
>> Open Script Editor, navigate to File > Open Dictionary and select 
>> what you want
>> 
>> It appears that print settings does not list sizing so I am stuck
>> 
>> 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 Jul 3, 2019, at 2:49 PM, Narinder Chandi via 4D_Tech 
>>> <4d_tech@lists.4d.com> wrote:
>>> 
>>> Been a long, long time since I write any AppleScript and I don't 
>>> know what the dictionary for Preview supports but did you try 
>>> passing  "properties {...}" to " without print dialog" - logically 
>>> it doesn't make sense, but it might crazily work?!
>>> 
>>> Another (more hacky) option could be try and post system event 
>>> keystrokes to close the print dialog after "with print dialog"?
>>> 
>>> Regards,
>>> 
>>> Narinder Chandi,
>>> ToolBox Systems Ltd.
>> 
>> **
>> 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
>> **
> ---
> 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
> **
---
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
**

Re: [off]Apple script issue

[Chip Scheide via 4D_Tech]

Not been really following...

Are you creating the PDF?
if so, then you should be able to create the pdf such that it is 100% 
(or maybe better 95%) maybe th

On Wed, 3 Jul 2019 15:23:10 -0400, Chuck Miller via 4D_Tech wrote:
> Thanks it got me the following:
> 
> Open Script Editor, navigate to File > Open Dictionary and select 
> what you want
> 
> It appears that print settings does not list sizing so I am stuck
> 
> 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 Jul 3, 2019, at 2:49 PM, Narinder Chandi via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>> 
>> Been a long, long time since I write any AppleScript and I don't 
>> know what the dictionary for Preview supports but did you try 
>> passing  "properties {...}" to " without print dialog" - logically 
>> it doesn't make sense, but it might crazily work?!
>> 
>> Another (more hacky) option could be try and post system event 
>> keystrokes to close the print dialog after "with print dialog"?
>> 
>> Regards,
>> 
>> Narinder Chandi,
>> ToolBox Systems Ltd.
> 
> **
> 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
> **
---
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
**

Re: OUT OF RANGE

[Chip Scheide via 4D_Tech]

in a multi user system it could be that a different user deleted the 
record

In your logs, a record number is not necessarily enough to ID the 
trouble record.
In your log - write some data specific information - UUID, or some 
other info that is unique to the record, as 4D can/does reuse record 
numbers.

so you can have the situation:
User A loads a selection of records (Including Record 1)
User B deletes record 1
User A does their Selection to Array - the error occurs as Record 1 
does not exist.
User C adds a record to the table - 4D reuses Record 1
you look into your log file and find that Record 1 was the trouble 
record
you look at the data and find that there is a record 1.

Chip


On Wed, 3 Jul 2019 21:06:54 +0200, stardata.info via 4D_Tech wrote:
> No transaction, seems that there is a record not accessible with GOTO 
> RECORD command. Now I trap this error with ON ERR CALL and after I 
> write in the application logs the record numbers contained into the 
> array. So I can see the record number that gives a problem...
> Is strange that after restarting the client, all work normally. If 
> there are a strange record number, he must remain even after the 
> restart of client.
> 
> Il 03/07/2019 21:00, 4d_tech-requ...@lists.4d.com ha scritto:
>> Message: 2
>> Date: Wed, 03 Jul 2019 16:14:45 +0100
>> From: Narinder Chandi<4dtechmailingl...@toolbox.uk.com>
>> To: 4D Tech Mailing List<4d_tech@lists.4d.com>
>> Subject: Re: OUT OF RANGE
>> Message-ID:<9c9a6826-0e58-4fcb-9299-a0e503786...@toolbox.uk.com>
>> Content-Type: text/plain;charset="UTF-8"
>> 
>>>From memory, this error is usually triggered because a record you 
>> are trying to access doesn't exist. You need to look at the context 
>> in which you are trying to create the selection to figure this error 
>> out. Perhaps you are in a transaction?
>> 
>> Regards,
>>   Narinder Chandi,
>> ToolBox Systems Ltd.
>> -- -Original Message- From: 4D_Tech 
>> <4d_tech-boun...@lists.4d.com> on behalf of 4D Tech Mailing List 
>> <4d_tech@lists.4d.com> Reply-To: 4D Tech Mailing List 
>> <4d_tech@lists.4d.com> Date: Wednesday, 3 July 2019 at 16:05 To: 4D 
>> Tech Mailing List <4d_tech@lists.4d.com>, 
>> <4d_tech-requ...@lists.4d.com> Cc: "stardata.info" 
>>  Subject: OUT OF RANGE Hi All, I use 4D V13 
>> on windows in one client server application. In the command CREATE 
>> SELECTION FROM ARRAY sometimes i have one error: The cannot be used 
>> to build the selection Record # is out of range during GOTO 
>> RECORD The customer restart the application and this segnalation 
>> disappares. Someone can explain the reason? Now i trap the 
>> segnalation using ON ERR CALL but i need to understand the reasons. 
>> Thanks /Ferdinando/
> **
> 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
> **
---
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
**

Re: Deleting a record from a listbox

[Chip Scheide via 4D_Tech]

if the sort is based on the listbox headers then the solutions to 
determine which header the listbox is sorted on, and then resort using 
the same header.

if you sort the listbox some other way, and can track the sort criteria 
then you could use that to re-sort after deleting.

I can't be of more help, as I do not generally allow deletion in my 
system

On Wed, 3 Jul 2019 19:05:08 +, Sannyasin Siddhanathaswami via 
4D_Tech wrote:
> Aloha,
> 
> I’m trying to update my "delete selection of records from a listbox" 
> code. I’m trying to keep the sort order so that when someone clicks  
> to delete, the only thing they see is the lines they select, get 
> deleted.
> 
> Here’s the basic code. Of course, deleting a record in this scenario, 
> leaves an empty record in the listbox.
> 
> COPY NAMED SELECTION($tablePtr->;"TempCurrentSet")
> USE SET($highlightSet)
> DELETE SELECTION($tablePtr->)
> USE NAMED SELECTION("TempCurrentSet")
> CLEAR NAMED SELECTION("TempCurrentSet")
> 
> I haven’t been able to figure out how to keep the sort, and get rid 
> of the deleted records (now showing as blank).
> 
> Any ideas?
> 
> 
> 
> Sannyasin Siddhanathaswami
> **
> 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
> **
---
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
**

Re: v13 problem

[Chip Scheide via 4D_Tech]

I just thought of this...
If you can get to the 'user' environment

select a table - 
reduce the selection to 1 record
Apply formula (from record menu)
insert SET USER PROPERTIES()

to change designer password.

Chip
On Mon, 1 Jul 2019 12:37:46 -0400, Chuck Miller via 4D_Tech wrote:
> Hi All,
> 
> I just took over a v13 account and when I log in as administrator, I 
> do not see designer as user. I do not see a splay screen. The plan is 
> to fix known issues nd then move to v17
> 
> Can anyone advise how I might get to the structure as administrator 
> and how I might see the designer user name, so I can change the 
> password
> 
> 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
> **
---
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
**

Re: v13 problem

[Chip Scheide via 4D_Tech]

Chuck,
on Mac: Shift + Option + Command + right click  = interrupt menu (with 
possible option for user/design access)

Does the database have/give the ability to execute code from the 
runtime environment?
if so you try to execute the command to change the designer password 
(Set user properties)
Chip


On Mon, 1 Jul 2019 12:37:46 -0400, Chuck Miller via 4D_Tech wrote:
> Hi All,
> 
> I just took over a v13 account and when I log in as administrator, I 
> do not see designer as user. I do not see a splay screen. The plan is 
> to fix known issues nd then move to v17
> 
> Can anyone advise how I might get to the structure as administrator 
> and how I might see the designer user name, so I can change the 
> password
> 
> 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
> **
---
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
**

Re: v14+ find in design

[Chip Scheide via 4D_Tech]

I was the instigator of this thread  :)

My question was: 
[In which version does] Find in design locate method references in 
object properties?

ex:
Listbox: Font foreground color: my_font_color_selection_method

In v13 Find in design will not locate references to methods which are 
entered into a property field.
At some point (apparently) this ability was added.

My current task: is to integrate a utility component into an existing 
system, replacing method calls in code with component calls, and 
removing the no longer referenced methods.

In some instances, the method(s) being replaced by component calls 
may/are called from object properties (not object methods). 
I found a workaround which is the compiler complains if a method 
referenced in an object property does not exist; so if I just go about 
removing methods as I need, if there is a reference in an object 
property when I compile it will become obvious.

Chip



On Thu, 27 Jun 2019 13:04:56 -0400, Charles Miller via 4D_Tech wrote:
> Make sure you have search in methods and search in forms selected. I
> also never do a case sensitive search
> 
> 
> Regards
> 
> Chuck
> 
> On Thu, Jun 27, 2019 at 1:00 PM Dave Halbert via 4D_Tech
> <4d_tech@lists.4d.com> wrote:
>> 
>> I suspect that I'm not totally understanding the question correctly but
>> if this helps on V15.5 running locally on a Mac
>> 
>> Object method is
>> 
>> Case of
>> : (Form event=On Data Change)
>> 
>> [Stock]DescriptionInv:=Settocaps (->[Stock]DescriptionInv)
>> 
>> End case
>> 
>> 
>> 
>> Using Find in design
>> 
>> Find = Text
>> 
>> Which = contains - entered is = ->[Stock]DescriptionInv
>> 
>> Mod date of parent = indifferent
>> 
>> Folder = Top level
>> 
>> Search Forms and Methods = Yes
>> 
>> Case sensitive = No
>> 
>> 
>> 
>> Result is zero occurrences
>> 
>> 
>> --
>> --
>> The Better Beverage Company
>> 5 Arthur St
>> Edinburgh EH6 5DA
>> 
>> 0131 55 33 121
>> **
>> 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
>> **
> 
> 
> 
> -- 
> 
-
>  Chuck Miller Voice: (617) 739-0306 Fax: (617) 232-1064
>  Informed Solutions, Inc.
>  Brookline, MA 02446 USA Registered 4D Developer
>Providers of 4D, Sybase & SQL Server connectivity
>   https://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
> **
---
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
**

Re: v14+ find in design

[Chip Scheide via 4D_Tech]

Thanks!

anyone else - in between versions??

Thanks
On Wed, 26 Jun 2019 09:44:01 -0700, Tom Benedict wrote:
> Yes. At least they do in v17R4, which I just tested.
> 
> I have a variable on a form where the expression is “Size of 
> array(atMyArray)” and it showed up in Find in Design. I also tried it 
> with an expression which calls a Project Method and it shows up too. 
> 
> Tom Benedict
> 
>> On Jun 26, 2019, at 09:26, Chip Scheide via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>> 
>> Does, v14 or newer versions of 4D support Find in die sign locating 
>> method references which are in object properties?
>> 
>> ex:
>> Listbox - Foregound Line Color -> my_method_to_set_Fore_Color
>> 
>> In the above example does Find in Design locate the call to 
>> 'my_method_to_set_Fore_Color'?
>> 
>> Thanks
>> Chip
>> 
>> ---
>> 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
>> **
> 
> 
---
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
**

v14+ find in design

[Chip Scheide via 4D_Tech]

Does, v14 or newer versions of 4D support Find in die sign locating 
method references which are in object properties?

ex:
Listbox - Foregound Line Color -> my_method_to_set_Fore_Color

In the above example does Find in Design locate the call to 
'my_method_to_set_Fore_Color'?

Thanks
Chip

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

Re: Transferring a DB from Firebird to 4D using RazorSQL on Mac

[Chip Scheide via 4D_Tech]

Jorg,
I tried this search got something that looks useful, but I have no 
clue, maybe you will.
"GDSServerVersion.INVALID_VERSION firebird"  (no quotes)

it says something about format of expected reply.


On Wed, 26 Jun 2019 22:57:09 +1000, Jörg Knebel via 4D_Tech wrote:
> GDSServerVersion.INVALID_VERSION
---
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
**

Re: list box and sort

[Chip Scheide via 4D_Tech]

Chuck,
all of my listbox code was written a while ago.. so I am a bit fuzzy 
but for the predesigned listbox,
as I recall since you are 'stepping around' the native sort function of 
the header button (listbox setting 'sortable', I think this is what is 
causing the header button to not change value.

I think if you explicitly assign the header button the correct value it 
will display properly and you can then count on it for the current 
state (ascending/descending), additionally you do not include under 
what form event you are executing the sort, the sort you are trying to 
implement needs to be done in the ON AFTER SORT event. 

Again as I recall, if you place your sorting code in the header button 
method, or execute it during the ON CLICKED event *your code* runs, 
then 4Ds native sort occurs undoing your sort.

Chip

On Tue, 25 Jun 2019 11:32:32 -0400, Charles Miller via 4D_Tech wrote:
> HI all,
> 
> I have not had this problem before but it must be something dumb I am
> doing. I have listbox 1 where I have columns created through code and
> on header click event. When I enter on header click event I do a
> customer sort on  column 2. The code looks like this
> case of
> : (Form event=On Header Click)
> C_TEXT($nameofObj_txt)
> C_LONGINT($dumTbl_L;$dumFld_L)
> RESOLVE POINTER(Self;$nameofObj_txt;$dumTbl_L;$dumFld_L)
> if(: ($nameofObj_txt="LB_Header2_l")
> If (Self->=1)
> ORDER BY FORMULA([TIN_Inspections];NTI_SortByFormula (Self->);>)
> Else
> ORDER BY FORMULA([TIN_Inspections];NTI_SortByFormula (Self->);<)
> End if
> 
> This works every time the value of LB_Header2_l variable changes as 
> it should
> 
> I have another listbox form where columns not created by code where
> C_TEXT($nameofObj_txt)
> C_LONGINT($dumTbl_L;$dumFld_L)
> RESOLVE POINTER(Self;$nameofObj_txt;$dumTbl_L;$dumFld_L)
> 
> Case of
> 
> : ($nameofObj_txt="LB_Header2_l")
> If (Self->=1)
> ORDER BY FORMULA([TIN_Inspections];NTI_SortByFormula (Self->);>)
> COPY NAMED SELECTION([TIN_Inspections];"NTI_TunnelInspSet")
> 
> Else
> ORDER BY FORMULA([TIN_Inspections];NTI_SortByFormula (Self->);<)
> COPY NAMED SELECTION([TIN_Inspections];"NTI_TunnelInspSet")
> 
> End if
> $0:=-1
> The value of LB_Header2_l never changes so sorting does not work
> Additionally no other sort works either. Any ideas?
> 
> Thanks and regards
> Chuck
> 
> -- 
> 
-
>  Chuck Miller Voice: (617) 739-0306 Fax: (617) 232-1064
>  Informed Solutions, Inc.
>  Brookline, MA 02446 USA Registered 4D Developer
>Providers of 4D, Sybase & SQL Server connectivity
>   https://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
> **
---
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
**

Re: Dialog (;*) question

[Chip Scheide via 4D_Tech]

peter,
depending on what type of progress you need to display..
Progress Component - part of 4D now - will display either a barber pole 
(indeterminate duration) with text above and below, or a progress 
thermometer (defined interation count), again with text above and below.

- Both of these run in their own process, 
- the text can be updated as needed 
- Progress supports (stacked) multiple progress bars, so you can show 
overall progress and sub task progress; or multiple tasks 
simultaneously.
- It is simple to use  :)


pseudo code:
start progress with messages (giving limits if using thermometer)
start task
 loop over  
   do work
   update progress (move thermometer, or change messages)
 end loop
end task
close progress

On Tue, 25 Jun 2019 15:45:11 +0200, Peter Bozek via 4D_Tech wrote:
> I maybe already asked this question, but anyway I am still a bit confused:
> 
> I wanted to use DIALOG with * as an additional parameter, but have problem
> to make it work. I have app that display several info windows - like
> palettes, progress messages, communication statuses etc.Currently, I often
> need 2 processes for each task: one does the work as background task,
> another display it status / progress.  So instead of running a separate
> process for each window, why not to use one process that will display
> whatever windows application wants to display? Or display status from
> inside background process that do communication or lengthy task.
> 
> My original idea was to call
> 
> OPEN FORM WINDOW
> DIALOG(;*)
> PAUSE PROCESS
> 
> but that does not work, as the process execution is "standing" at PAUSE
> PROCESS and no code is executed (and CALL FORM is either not executed or
> window is not redrawn.)
> 
> When I remove PAUSE PROCESS, process ends and DIALOG window is closed.
> 
> According to documentation, it would work of I do
> OPEN FORM WINDOW
> DIALOG(;*)
> DIALOG()
> 
> but that is quite ugly, and would cause some problems, as I want the
> process that calls DIALOG(;*) periodically evaluate which windows are open
> and close itself if none.
> 
> Another possibility is just to open window and call DIALOG(), then call
> DIALOG(;*) from inside the form method of the first DIALOG() form. That
> would (probably) work, form can use On timer event to check what is open,
> open additional dialogs etc. but I do not like the idea either.
> 
> Is there a way how to use DIALOG(;*)  from a process that does not have any
> other window open?
> 
> Regards,
> 
> -- 
> 
> 
> Peter Bozek
> **
> 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
> **
---
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
**

Re: Select document command and .4lbp files

[Chip Scheide via 4D_Tech]

I would try passing the extension (.4lbp)

On Mon, 24 Jun 2019 15:01:34 -0400, jeff--- via 4D_Tech wrote:
> In 4D v17.2 on MacOS 10.14.3, I am attempting to open a 64-bit label 
> format file using Select document. I am passing "com.4d.4d.labelFile" 
> in the fileTypes parameter but all such files are greyed out and 
> disabled.
> 
> --
> Jeff Grann
> SuccessWare, Inc.
> 
> **
> 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
> **
---
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
**

Re: POSIX Path Syntax (How to convert from 4D POSIX to Terminal POSXIX?)

[Chip Scheide via 4D_Tech]

Jermey,
follows code that should resolve your conversion to posix

  //fileutl_Path_Convert_to_Posix
  //$1 - Text - Path to convert

  //Original from JorgeChB via iNug

  //Converts a Mac file path to a Posix form

  //RETURNS - Text - converted path, or empty string if path is empty, 
or error
  // • Created 3/24/15 by Chip - 
  //• Updated 05-17-18 by Chip - added test for empty path
C_TEXT($Path;$Path;$0;$msg)


If (Count parameters>=1)
$Path:=$1

Case of 
: ($Path="")
$msg:="Source Path is empty"
ALERT($msg)

: (Position(Colon_Char;$Path)>0)
$Path:=Replace string($Path;Slash_Char;"__-sLaSh-__")  //'a/b' -> 
'a__-sLaSh-__b'
$Path:=Replace string($Path;Colon_Char;Slash_Char)  //'a:b' -> 'a/b'
$Path:=Replace string($Path;"__-sLaSh-__";Colon_Char)  
//'a__-sLaSh-__b' -> 'a:b'
$Path:=Replace 
string($Path;BackSlash_Char;BackSlash_Char+BackSlash_Char)  //'a\\b' -> 
'a\\b'"
$Path:=Replace string($Path;Space_Char;BackSlash_Char+Space_Char)  //'a 
b' -> 'a\ b'
$Path:=Replace string($Path;"*";BackSlash_Char+"*")  //'a*b' -> 'a\*b'
$Path:=Replace string($Path;"'";BackSlash_Char+"'")  //'a'b' -> 'a\'b'
$Path:=Replace string($Path;"&";BackSlash_Char+"&")  //'a' -> 'a\'
$Path:=Replace string($Path;Quote_Char;BackSlash_Char+Quote_Char)  
//'a"b' -> 'a\"b'
$Path:=Replace string($Path;"(";BackSlash_Char+"(")  //'a(b' -> 'a\(b'
$Path:=Replace string($Path;")";BackSlash_Char+")")  //'a)b' -> 'a\)b'

  //make sure we do not prepend 'Volumes' if it already there
If (Position("/Volumes/";$Path)=0)
$0:="/Volumes/"+$Path
Else 
$0:=$Path
End if 
Else 
$msg:="Posix conversion is only applicable "
$msg:=$msg+"to paths formatted for use on a Macintosh."
ALERT($msg)
End case 
Else 
$msg:="Required parameters (1) not passed."+Cr_Char
$msg:=$msg+"Parameters passed "+String(Count parameters)
ALERT($msg)
End if 
  //End fileutl_Path_Convert_to_Posix  

On Mon, 24 Jun 2019 10:57:14 -0400, Jeremy French via 4D_Tech wrote:
> How do we resolve POSIX file path syntax between 4D and Mac Terminal?
> 
> This Mac system path has a space in the folder name "Final Application":
> Macintosh 
> HD:Users:jeremyfrench:Desktop:test_notarize_01:test_notarize_01_Build:Final 
> Application:test_notarize_01.app:
> 
> 4D's POSIX shows the space in "Final Application" unescaped:
> /Users/jeremyfrench/Desktop/test_notarize_01/test_notarize_01_Build/Final 
> Application/test_notarize_01.app/
> 
> And 4D's escaped POSIX shows the space represented as "%20”, like this:
> 
/Users/jeremyfrench/Desktop/test_notarize_01/test_notarize_01_Build/Final%20Application/test_notarize_01.app/
> 
> Neither 4D syntax (escaped or unescaped) matches Terminal's POSIX syntax.
> 
> Terminal's POSIX shows the space in "Final Application" escaped 
> differently, with a left-slash: "\ "
> /Users/jeremyfrench/Desktop/test_notarize_01/test_notarize_01_Build/Final\ 
> Application/test_notarize_01.app
> 
> QUESTIONS:
> 
> Does Terminal escape only space characters?
> Are there other characters that Terminal escapes with a left-slash?
> Is replacing a space with left-slash-space the only change needed to 
> convert 4D's POSIX to Terminal's POXSIX?
> **
> 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
> **
---
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
**

Re: Drag & drop a file - what am I missing?

[Chip Scheide via 4D_Tech]

Pat,
not using v17 - but yes.

I have never tried picture dropping, but I was unable to get Drag N 
drop to function to a field.

I work around this (and it makes the target easier for the user) by 
using an invisible button which covers a section of the screen so that 
the user can drag n drop anywhere in that area, rather then just on the 
(small?) field.

You can easily place the path into the desired text field after 
validating the drop.
 
Chip
On Fri, 21 Jun 2019 21:16:49 +0100, Pat Bensky via 4D_Tech wrote:
> Using v17 -
> 
> Until now I've implemented drag & drop between objects, for example list
> boxes. No problem.
> But now I want to allow the user to drop a file onto a field and save the
> file's pathname in the field. I cannot get this to work and indeed the docs
> imply that this should only work with variables and objects:
> 
> "For example, it is possible to drag and drop a PNG picture file onto a 4D
> picture field. It is also possible to select text in a word processing
> application and drop it onto a 4D text variable or a list box."
> 
> So you can drop a picture onto a picture FIELD but any other type of file
> (eg .txt) only onto a variable?
> 
> Pat
> -- 
> *
> CatBase - Top Dog in Data Publishing
> tel: +44 (0) 207 118 7889
> w: http://www.catbase.com
> skype: pat.bensky
> *
> **
> 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
> **
---
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
**

[Tip]Set Query Destination

[Chip Scheide via 4D_Tech]

[Tl;DR] at end

This command is your friend - and - your foe!  :)

Yesterday I spent a significant amount of time trying to track down a 
compiled/built app crash, but did/does not happen interpretedly.

The crash happened only occasionally, after placing alerts and asserts, 
I determined that the crash was happening in a utility method which was 
doing a query. A method which, in the running code, had already been 
called repeatedly - without - issue.
Since the method which was doing the query had been called repeatedly 
-before- the crash, I was perplexed as to what the issue was.
After some more poking and prodding, it appeared that the crashing only 
occurred in the utility method, after a specific method (X) was called. 
Looking at X and watching it execute (interpretedly) provided no 
obvious clue as what the cause was. 
After staring at the code, and running both interpretedly and built 
many more times it finally dawned on me what the issue was...
Set Query Destination

In method X I was doing some work looking for duplicate data, and in so 
doing I was loping over a code that looked like this:
Set Query Destination(Into variable;$Local)
 
Set Query destination(Into current selection)
 
Set Query Destination(Into variable;$Local)

You might see the issue now... 
It turns out I never returned the query destination back to Current 
Selection.
To make the problem even more challenging, the utility method where the 
query was crashing was in a component.

Interpretedly, 4D was happy to create and type the local any time a 
query was executed after query destination was left into a local 
variable but... Needless to say compiled/built 4D DID NOT LIKE 
THAT!  :)

[TL;DR] 
-- always -- reset your query destinations  :)
Chip
---
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
**

Re: Window type -724 (more info)

[Chip Scheide via 4D_Tech]

I guess :)  so

Thanks
Chip
> 
> but how they map to 4D constants for Open window is anybody's guess.

Hell is other people 
 Jean-Paul Sartre
**
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: Window type -724 (more info)

[Chip Scheide via 4D_Tech]

I have no idea!  :)

this is a floating window I use for window management.
In my system it contains a listbox with all open windows/processes.

I have been using this for ages. On a Mac.
I was just working with windows version of a 4D app that uses this 
window (same purpose) and it looks like crap because even though there 
is *supposed* to be text in the title area there is nothing, and the 
title area on windows is huuuge (said like our idiot in chief).

I was trying to figure out how I created the window type so I could try 
to modify it for windows to look better.

(to Keith directly - I attached a screen capture of the window)
Chip

On Wed, 19 Jun 2019 14:08:30 -0500, Keith Culotta via 4D_Tech wrote:
> 
> 
> How did you find this window type?  I accidentally created a window 
---
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
**

Re: Window type -724 (more info)

[Chip Scheide via 4D_Tech]

Description of the window that is opened with -724
- It has ONLY a close button
- it is indeed a floating window
- it is resizable
- it has/accepts a window title
- on switching away from 4D the window disappears, only to show up at 
the same location when returning to 4D
- the window title area appears narrower the a standard type 8 window
Thanks again
Chip

On Wed, 19 Jun 2019 14:13:56 -0400, Chip Scheide via 4D_Tech wrote:
> How does this value come about?
> I know the '-' makes it a floating window
> but how is the value 724 generated?
> 
> Thanks
> Chip
> ---
> 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
> **
---
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
**

Window type -724

[Chip Scheide via 4D_Tech]

How does this value come about?
I know the '-' makes it a floating window
but how is the value 724 generated?

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

Re: 17.1 Client and macOS 10.15 Catalina beta 2

[Chip Scheide via 4D_Tech]

IN the mean time - try turning this off
do not know that it will help but
On Wed, 19 Jun 2019 17:48:21 +1000, James Brown via 4D_Tech wrote:
> 
> System Integrity Protection: enabled
---
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
**

Re: what format for an Icon file - windows?

[Chip Scheide via 4D_Tech]

Thanks

On Mon, 17 Jun 2019 16:05:28 +, Keisuke Miyako via 4D_Tech wrote:
> it needs to be an .ico file for windows.
> 
> 2019/06/18 0:52、Chip Scheide via 4D_Tech 
> <4d_tech@lists.4d.com<mailto:4d_tech@lists.4d.com>>のメール:
> does the icon file need to be in a different location for windows?
> 
> 
> 
> **
> 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
> **
---
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
**

what format for an Icon file - windows?

[Chip Scheide via 4D_Tech]

I have a custom icon I am using for a built application on Mac. the 
icon is in a .icns file
When I build the system on windows, I do not get the custom icon.
 
I assume that the icon file needs to be in a different format, what is 
that format?
  or
does the icon file need to be in a different location for windows?
(current location is: next to structure file)

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

Re: “Get Edited Text” after Pasting and “On Menu Selected” form event

[Chip Scheide via 4D_Tech]

also - On Data Change or On Losing Focus

> I am upgrading a database from v14 to v17. 
> 
> In v14, “Get Edited Text” would return the text of a form variable 
> after text was pasted into that variable and the“On Menu Selected” 
> form event  fired. This behavior was undocumented, but it worked. 
> 
> Unfortunately, this does not work anymore in v17, so I wanted to ask 
> what the best way is now to get the entered text immediately after it 
> has been pasted into a variable field and the “On Menu Selected” 
> event has fired?
> 
> 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
> **

Hell is other people 
 Jean-Paul Sartre
**
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: v13 - Volume desktop build - windows

[Chip Scheide via 4D_Tech]

Duh!

Thanks
Chip
On Fri, 14 Jun 2019 14:11:43 -0700, Douglas von Roeder wrote:
> Chip:
> 
> In the Build window, you have to specify the file path to the volume
> desktop application.
> 
> --
> Douglas von Roeder
> 949-336-2902
> 
> 
> On Fri, Jun 14, 2019 at 2:09 PM Chip Scheide via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> 
>> I am trying to build an application for use on Windows.
>> 
>> - I have a v13 Dev Pro license (recognized by 4D)
>> - I have a v13 Unlimited desktop license (recognized by 4D)
>> - The license manager shows both licenses
>> - the license manager information matches my Mac version (different #s
>> obviously)
>> - The licenses are attached in the 'build' dialog.
>> - the build dialog shows Dev Pr as master, and unlit desktop as
>> subordinate
>> 
>> When building I get an error 'unable to find 4D volume desktop'
>> 
>> Any Ideas??
>> 
>> Thanks
>> Chip
>> ---
>> 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
>> **
---
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
**

v13 - Volume desktop build - windows

[Chip Scheide via 4D_Tech]

I am trying to build an application for use on Windows.

- I have a v13 Dev Pro license (recognized by 4D)
- I have a v13 Unlimited desktop license (recognized by 4D)
- The license manager shows both licenses
- the license manager information matches my Mac version (different #s 
obviously)
- The licenses are attached in the 'build' dialog.
- the build dialog shows Dev Pr as master, and unlit desktop as 
subordinate

When building I get an error 'unable to find 4D volume desktop'

Any Ideas??

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

Re: v13+ - support for OpenType &/or TrueType fonts - Windows

[Chip Scheide via 4D_Tech]

Jim,
Thanks, but..

I am trying to get as close as possible to a cross (multi) platform 
appearance as possible, and I have found an Opentype font I like.

However, on windows, 4D v13 does not show all of the font weights 
(bold, light, etc) only a generic font name. Which is why I am asking 
about OpenType and TrueType font support.

CHip

On Wed, 12 Jun 2019 11:05:56 -0400, Jim Hays via 4D_Tech wrote:
> Hi Chip,
> 
> Try Segoe UI on Windows.  It's the system font since Windows 7 I believe -
> usually used for application labels, titles, etc.
> Calibri is the default san serif font for content, as in Word and Excel.
> 
> HTH,
> 
> Jim
> 
> 
> On Wed, Jun 12, 2019 at 9:41 AM Chip Scheide via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> 
>> What is the offical stance on support for OpenType (specifically) and
>> TrueType as well font system on Windows?
>> 
>> I found a font I like that is an OpenType font - Raleway.
>> On a Mac it (in 4D) it functions as I would expect all 9 weights of the
>> font are available for selection in the Style Sheet editor. However, on
>> Windows, after installing the font only the generic 'Raleway' is
>> available.
>> 
>> Looking around the web, I see that this seems to be due to incomplete
>> or no support for OpenType fonts, on an application by application
>> basis.
>> 
>> I noticed this same behavior with a couple of system installed TrueType
>> (I think, the files end with .ttf), trebuchet is an example - there are
>> multiple weights in the fonts folder, but only the 'generic' trebuchet
>> is available for selection.
>> 
>> Does anyone have any info on OpenType support, and/or TrueType support
>> in 4D (versions of 4D and/or Windows).
>> 
>> Thanks
>> Chip
>> ---
>> 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
>> **
> **
> 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
> **
---
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
**

v13+ - support for OpenType &/or TrueType fonts - Windows

[Chip Scheide via 4D_Tech]

What is the offical stance on support for OpenType (specifically) and 
TrueType as well font system on Windows?

I found a font I like that is an OpenType font - Raleway.
On a Mac it (in 4D) it functions as I would expect all 9 weights of the 
font are available for selection in the Style Sheet editor. However, on 
Windows, after installing the font only the generic 'Raleway' is 
available.

Looking around the web, I see that this seems to be due to incomplete 
or no support for OpenType fonts, on an application by application 
basis.

I noticed this same behavior with a couple of system installed TrueType 
(I think, the files end with .ttf), trebuchet is an example - there are 
multiple weights in the fonts folder, but only the 'generic' trebuchet 
is available for selection.

Does anyone have any info on OpenType support, and/or TrueType support 
in 4D (versions of 4D and/or Windows).

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

[please ignore] Re: Fonts on windows

[Chip Scheide via 4D_Tech]

On Tue, 11 Jun 2019 15:32:42 -0400, Chip Scheide via 4D_Tech wrote:
> I am looking for some suggestions for font selection for windows... I 
> know a fruitless and frustrating task...
> 
> I am using (OS X 10.9 and 10.11) Lucida Grande (various sizes from 10 - 
> 12 pt)
> on windows I am using Tahoma (various sizes 10 - 12)
> 
> I am setting the font size on windows 1 pixel smaller then on Mac, and 
> this gives - functional results - but not good.
> 
> Does anyone have suggestions for windows fonts (I am open to OpenType 
> or TrueType fonts)
> I need fonts:
> - for listings (output and related data on entry forms) (10-12 point)
> - for entry forms (11-12 point)
> - for entry form titles (18-22 point, bold -- I'm using Arial or 
> Helvetica)
> - to function (be standardly available) on XP, 7, 8, and 10
> - a bold version that does not look like it was written in crayon
> - that is readable
> 
> 
> Thanks for any help
> Chip
> ---
> 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
> **
---
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
**

Fonts on windows

[Chip Scheide via 4D_Tech]

I am looking for some suggestions for font selection for windows... I 
know a fruitless and frustrating task...

I am using (OS X 10.9 and 10.11) Lucida Grande (various sizes from 10 - 
12 pt)
on windows I am using Tahoma (various sizes 10 - 12)

I am setting the font size on windows 1 pixel smaller then on Mac, and 
this gives - functional results - but not good.

Does anyone have suggestions for windows fonts (I am open to OpenType 
or TrueType fonts)
I need fonts:
- for listings (output and related data on entry forms) (10-12 point)
- for entry forms (11-12 point)
- for entry form titles (18-22 point, bold -- I'm using Arial or 
Helvetica)
- to function (be standardly available) on XP, 7, 8, and 10
- a bold version that does not look like it was written in crayon
- that is readable


Thanks for any help
Chip
---
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
**

Re: Replacing Obsolete Subtable Commands in v15 to v17 Migration

[Chip Scheide via 4D_Tech]

from memory so...

One note:
- I believe existing (v15+) subtable support is one level deep only, I 
do not know if this will/does affect you. 
i.e [parent].substable_level1.subtable_level2... is not supported. 

there is a special link between converted subtables and their parent.
this special linage is NOT replaceable once broken.
The special linkage allows the subtable commands to continue to 
function.

(speaking about 1 subtable)
I believe that if you remove the special link, and replace the subtable 
commands that use it with record level commands you are good to go.

There may be one major exception:
Reports using the subtable data.  It has been along time since I played 
in this area, but again, as I recall any reports using the subtable 
commands will need extensive work. As subtable records load in a much 
different fashion to related tables.

Depending on the subtable structure definition(s) you may also 
want/need to add a primary key for backup/journal purposes.

On Tue, 11 Jun 2019 12:23:20 +0100, Narinder Chandi via 4D_Tech wrote:
> Hi. So, after tackling the replacement of the majority of the 
> obsoleted commands in v15, the remaining ones are in the Subtable 
> commands group (ughhh!). The database I am upgrading has 11 
> Subtables. I have spent some time perusing the archives prior to 
> writing this - a lot of the posts are quite historical, and there are 
> various options discussed in different threads. Having digesting 
> everything, these are the 2 options I am considering:
> 
> 1. Do nothing - Subtables converted to regular tables in v11 and 
> currently working in v15 will continue to work as is in v17 using the 
> obsoleted commands. I view this option as just brushing the problem 
> under the carpet for another day and in the short term serves only to 
> save the client the expense of my consulting time.
> 
> 2. Migrate all data access between Many to One tables to use Record 
> commands in place of the existing Subrecord commands. I envisage this 
> process would be something like:
>   a. Create a new Primary Key (PK) field in the One table (if needed) 
> and add that as a Foreign Key (FK) field in the related Many table 
> (see note * below).
>   b. Iterate over the One table records identifying the existing 
> related Many table records in the previously converted v11 Subtable 
> and update the FK field in each of the related records as required.
>   c. Convert all of the existing obsoleted Subrecords commands to 
> their Record command equivalents.
>   d. Break the relation between the "id_added_by_converter" field in 
> the Many table and the One table.
>   e. As the "id_added_by_converter" field in the Many table and the 
> Subtable field in the One table are no longer required they can be 
> now be removed?
>   f. Test, test and test again!
> 
> Note that there may be other options to 2. above, but ideally I am 
> only looking to leave things as is for now or to completely solve 
> this issue once and for all.
> 
> My question is - does option 2 stack up as an optimal and complete 
> solution? I think there is a less onerous solution that achieves the 
> same end goal based around using the "Get subrecord key" command but 
> I'm not convinced that I should consider that option.
> 
> And finally, since I should give the client all acceptable 
> "solutions", is option 1 a viable option too?
> 
> * since the v15 upgrade (I think) 4D Server has been complaining 
> about missing primary key fields in regards to the Log File so I need 
> to address the issue of missing keys in several tables in any case (I 
> have seen some prior discussion in the archives about this). 
> Personally I would never create a table without a (auto-incrementing) 
> PK but it's a legacy database that pre-dates my involvement...
> 
> Regards,
>  
> Narinder Chandi,
> ToolBox Systems Ltd.
> -- 
> 
> 
> **
> 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
> **
---
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
**

Re: issue with invisible button

[Chip Scheide via 4D_Tech]

is there an accept being posted some how along with a modification of 
the record?
an accept without a modification of the record does not fire validate.

to mark the record as "dirty" so it gets saved when an accept is posted 
in the on load put :
[table]field:=[table]field

Chip
On Fri, 7 Jun 2019 17:37:36 +, Jane Goguen via 4D_Tech wrote:
> Hi all,
> 
> Environment Mac client, 4D version 16.5 built client server and 4D 
> standalone
> 
> I have an invisible button with Enter as a shortcut. If I disable the 
> button and even if I make it invisible and then Hit enter key, the 
> button code does not run (This is expected), but the validate code in 
> the on validate event on form method does run (This is NOT expected). 
> What simply stupid thing am I missing here.
> 
> This is Chuck M sending email from a client email as I have not 
> access to email from here
> 
> 
> Regards
> 
> Chuck and Jane
> 
> 
> 
> 
> 
> This email message and any files transmitted with it contain 
> confidential information intended only for the person(s) to whom this 
> email message is addressed. If you have received this email message 
> in error, please notify the sender immediately by telephone or email 
> and destroy the original message without printing or making a copy.
> **
> 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
> **
---
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
**

Re: Open a v17 data file when Structure is unknown

[Chip Scheide via 4D_Tech]

Jorg,
a couple of things to watch for:
- hidden field(s) - I do not believe these will show up to be exported.
- blobs - they will export, but without knowing what is in them...
 -- encrypted blobs - again they will export, but the data will be useless; and 
I do not believe there is any way to know that the blob is encrypted (from the 
outside without source code).
- related data - you may to have anyway to determine which data are related.
 -- example: in a couple of my systems, 1 table contains data which is related 
to many other tables, there is no explicit relational line drawn between this 
one table and the "related" tables.


Maybe the (new) business owner needs to have a discussion with attorneys

Chip

> Hi Kirk,
> 
> As mentioned in an other post the client has a compiled structure, 
> but the guy the business was bought of refuses to hand over the 
> source code. The funny thing is the business is based on and depends 
> on that application, meaning no application/data no business.
> It is possible to go to the user environment and export all that 
> stuff manually.
> But this is not my problem any more at least for a long time I hope.
> 
> 
>> On 9 Jun 2019, at 01:36 AEST, Kirk Brooks via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>> 
>> In general I think 4D's tightening up of data security is a good thing. Yes
>> it creates headaches when good people do stupid things but on the whole is
>> a better architecture by limiting opportunities for bad people to do bad
>> things by intent.
> 
> I couldn’t agree more. 
> I personally go a step further by not allowing the data to be opened 
> on a different computer even if the structure is a 100% match.
> 
> I like the prospect to be able to encrypt tables/content, as long as 
> it is my choice what table(s) are to be encrypted.
> The idea to do such thing on record level is on my “to do later list” 
> for a while now. 
> 
> Thanks again for all the input.
> 
> Cheers
> Jörg
> **
> 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
> **

Hell is other people 
 Jean-Paul Sartre
**
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: Konstants - trying to determine where it is defined

[Chip Scheide via 4D_Tech]

'K'onstant is.. because I don't remember where/when this started, 
but it was to designate 4D constants from other 'constants' (like maybe 
1, 2 A B etc ??, <>IP_constants ???)

maybe I stated my question incorrectly :)

I know about the xliff files.  I have been heavily modifying 4DPop to 
my own purposes**.
I found a Konstant (a 4D defined one), the constant I am trying to find 
is 'None' (no quotes), but have no idea where it is.
i.e. 4D environment, Field & var typing, etc.


** once I have completed my modifications of 4DPop if the original 
author has no problems with my doing so - I'll release it.
So far:
- each group and constant is given a UUID as an ID -- no duplication of 
IDs
- added the ability to write & save a comment with each constant
- allow drag n drop (load and save changes) of xliff files from 
locations other then the default resource folder
- added sorting of themes/groups
- Allow viewing of all open xliff files without groups/themes (no 
saving) in one list
- activated the gear popup to :
  -- view a selected xliff file with or with out (can't save a change) 
groups\themes
  -- view all open files without groups\themes (no saving changes)
  -- reload a selected xliff file - allows modification external to 
4DPop while viewing in 4DPop (great for consolidating constant xliff 
files)

I might add viewing all open files with groups/themes in one list



BTW - Tai Bui answered my question

On Thu, 30 May 2019 16:43:16 -0400, Jeffrey Kain via 4D_Tech wrote:
> Is a Konstant a Russian version of a constant? :)
> 
> Constants are normally defined in an xliff file in Resources (for a 
> 4D structure), or inside the bundle of a plug-in or component 
> (probably also in Resources).  For example, our application's 
> constants file is named Constants_Sweetwater.xlf and sits in the 
> Resources folder next to the .4DC file.
> 
>> On May 30, 2019, at 4:29 PM, Chip Scheide via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>> 
>> Is there a way to determine where a Konstant is defined?
> 
> **
> 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
> **
---
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
**

RE: Konstants - trying to determine where it is defined

[Chip Scheide via 4D_Tech]

Thanks!

I didn't look in that folder

Chip

On Thu, 30 May 2019 20:44:34 +, Tai Bui wrote:
> 4D's constants?
> I believe its in the xliff located at
> {4D vXX}\{4D, 4D Server, or 4D VD...}\Resources\en.lproj\4D_ConstantsEN.xlf
> 
> I only have INTL installed so the en might be different based on local.
> 
> 
> 
> Tai Bui
> Technical Services Engineer
> 
> 4D Inc
> 95 S. Market Street, Suite #240
> CA 95113 San Jose
> United States
> 
> Téléphone : +1-408-557-4600
> Standard :  +1-408-557-4600
> Fax :   +1-408-271-5080
> Email : t...@4d.com
> Web :   www.4d.com
> 
> 
> 
> 
> 
> -Original Message-----
> From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Chip 
> Scheide via 4D_Tech
> Sent: Thursday, May 30, 2019 1:30 PM
> To: 4D iNug Technical <4d_tech@lists.4d.com>
> Cc: Chip Scheide <4d_o...@pghrepository.org>
> Subject: Konstants - trying to determine where it is defined
> 
> Is there a way to determine where a Konstant is defined?
> 
> v13 if this matters
> 
> Thanks
> 
> ---
> 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
> **
> 
---
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
**

Konstants - trying to determine where it is defined

[Chip Scheide via 4D_Tech]

Is there a way to determine where a Konstant is defined?

v13 if this matters

Thanks

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

Re: I've not seen this before

[Chip Scheide via 4D_Tech]

might also be a mounting issue.
volume might have been mounted, lost connection, and remounted as a 
different letter designation

On Tue, 28 May 2019 16:50:28 -0700, Robert McKeever via 4D_Tech wrote:
> A client reports that Windows did an update last night.
> 
> Today, when importing one of the billing extract files (CSV format), 
> he get the following error from 4D:
> 
> “The volume for a file has been externally altered so that the 
> opened file is no longer valid.”
> 
> Sometimes the radiologists like to edit the file before importing it 
> (I suggest otherwise, but that’s what they like to do). I think the 
> error comes from his having edited the file, and left it open in the 
> editing program before importing it.
> 
> Any other ideas?
> _
> 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
> **
---
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
**

Re: creating a plain text document from within 4D

[Chip Scheide via 4D_Tech]

Plain text document:

$Doc_Ref:=open document($Path;"TEXT")

Send packet($Doc_Ref;$Text_to_Send)

Close document($Doc_Ref)


On Mon, 27 May 2019 16:58:57 -0400, ernest hilgers via 4D_Tech wrote:
> Hi All, 
> 
> I have encountered an issue of which I am not able to find a 
> solutions (blush). 
> 
> And it goes as follows: 
> in a global Text-variable vMessage_t that is also displayed in a 
> window (Dialog)
> a method is entering text (automatically), 
> one line at a time, 
> 
> wish: 
> line1; I am line 1
> line2; I am line 2
> line3; I am line 3
> 
> line4; I am line 4
> line5; I am line 5
> line6; I am line 6
> 
> the dialog-window has a button "Save" that needs to save what's in 
> that text variable vMessage_t 
> (visible to the operator in the dialogwindow) to a plain text document. 
> The idea is, the content of the text file should look like what's 
> seen on screen. 
> 
> I tried "variable to blob", then "blob to document"
> but that will not produce the desired result. not with all kinds of 
> characterset and out/input specifically mentioned (or not).
> 
> result: 
> line1; I am line 1line2; I am line 
> 2line3; I am line 3line4; I am line 4line5; I am 
> line 5line6; I am line 6
> 
> I tried "text to document", same result. 
>   
> if I highlight with the mouse the text in the window, then copy it to 
> the pasteboard
> then it looks like what I want. 
> next, paste it into a new document, it gives the desired result, but 
> it should be possible to let 4D do that. 
> 
> I opened the created document with TextEdit, BBEdit. 
> Using 4D v17 on mac (10.13 / 10.14) (unicode-mode on).
> 
> Hope anyone can tell me where my thinking goes of the rails. 
> 
> Regards. 
> 
> ernie hilgers(aruba)
> **
> 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
> **
---
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
**

Re: Injecting Forms from a component

[Chip Scheide via 4D_Tech]

Thanks!

I did not think it was possible to inject a form into a host, but 
thought I would ask. :)

Chip

On Thu, 23 May 2019 11:27:50 -0500, John DeSoi via 4D_Tech wrote:
> 
> 
>> On May 23, 2019, at 10:26 AM, Chip Scheide via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>> 
>> I expect that you can do the same for table(s) via SQ, I have not tried.
> 
> In addition to SQL, you can also use IMPORT STRUCTURE which is 
> probably better in a lot of ways because you can do things like set 
> trigger properties for the table. I don't think this is possible with 
> SQL. But it is complex if you are doing schema versioning.
> 
>> 
>> Can you inject a form from a component into a host system?
>> if so - how?
> 
> Not possible as far as I know. In theory it will be possible with 
> version 18. With version 17 you can use dynamic forms to some extent, 
> but doubt you can get everything working the same as a form created 
> in the design environment.
> 
> 
> https://doc.4d.com/4Dv17/4D/17.1/Dynamic-Forms.300-4201272.en.html
> 
> 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
> **
---
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
**

Injecting Forms from a component

[Chip Scheide via 4D_Tech]

I know you can inject (copy/install) methods into a host system from a 
component.
I expect that you can do the same for table(s) via SQ, I have not tried.

Can you inject a form from a component into a host system?
if so - how?

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

Re: How can a line of code be separated into multiple lines?

[Chip Scheide via 4D_Tech]

selection to array([table]field1;$Array1;\
[table]field2;$Array2;\
[table]field3;$Array3;\
[table]field4;$Array4)

you use the \ character -- but you need to be careful where you use it.
you need to use it between 'operators'.
after a math operation (+-/*), after a semicolon (is generally the easiest),

you can not use the \ character  before any of the above operators,, or command 
name
$sum := $a + $b \
+ $c + $d
selection\
to array
nor can you split a field reference, nor can you split a variable
[table]\
field
$my_var\
table



> I know this is done, but I have never used it and cannot find the 
> answer myself:
> 
> How can a line of code be separated into two, and still be 
> interpreted by 4D as one line?
> 
> ex. (obviously not practical)
> 
> $all:=$1
> +$2
> +$3
> 
> equivalent:   ($all:=$1+$2+$3
> 
> 
> thanks,
> Chris
> **
> 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
> **

Hell is other people 
 Jean-Paul Sartre
**
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: list box issue

[Chip Scheide via 4D_Tech]

options I can think of:
- make the column enterable then not and hope the screen draws as you 
want
- try F-ing - that is an official programming term! :) - with the 
color/font color options
- make the column enterable using a variable - and return it to the 
underlying value (record?) if changed.
  On data change
my_checkbox:=not (my_checkbox)
  or
my_Checkbox:=[table]value (or calculation)

Chip

On Tue, 14 May 2019 16:32:22 -0400, Chuck Miller via 4D_Tech wrote:
> You are correct it is wrong first time in. Want to keep it that way
> 
> Sent from my iPhone
> 
>> On May 14, 2019, at 3:53 PM, Chip Scheide via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>> 
>> Chuck,
>> you said the column is not enterable - disabled for a check box
>> a disabled check box shows as light grey, and if checked the check is 
>> darker grey
>> 
>> so actually is sounds as if it draws incorrectly the first time in - 
>> appearing blue = enterable
>> 
>> You might be able to change the color (blue) of the disabled check box 
>> - but I have never tried this.
>> 
>> Chip
>> 
>>> On Tue, 14 May 2019 15:37:32 -0400, Charles Miller wrote:
>>> This is sub form so events don’t work the way you think and why would it
>>> work the first time in and only fails when activate happens. I have even
>>> changed to a variable and set during on display detail
>> ---
>> 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
>> **
> 
> **
> 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
> **
---
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
**

Re: Scroll position of display-type subform

[Chip Scheide via 4D_Tech]

Alan,
does the form event: On Selection Change 
fire during scrolling?

Chip
On Tue, 14 May 2019 16:04:00 -0400, Alan Tilson wrote:
> Chip,
> Thank you for your thoughts on this. However, in this case I'm
> recalculating the entire list and also I'm not using a listbox, it's a
> regular output form.
> On Display Detail doesn't fire with scrolling or after using apply to
> selection...so I can't create a user set
> even tried POST CLICK to create a user set but it happens after everything
> runs which doesn't help
> anyway, thanks!
> Alan
> 
> On Tue, May 14, 2019 at 2:46 PM Chip Scheide <4d_o...@pghrepository.org>
> wrote:
> 
>> I think you can save yourself some work.
>> 
>> if you are working on a record (which is displayed) then...
>> try this:
>> do the recalc
>> (you could clear it first)
>> ADD the record to the listbox selection set
>> use your named selection
>> 
>> I *think* 4D will scroll the display to show the highlighted record.
>> 
>> if not
>> you should be able to get the location of that record
>> then scroll to that location - the record that was worked on is now
>> highlighted so the user can see the result
>> 
>> Chip
>> 
>> On Tue, 14 May 2019 14:22:36 -0400, Alan Tilson wrote:
>>> Hello Chip,
>>> 
>>> The issue is how do I determine where the scroll is or which record is
>>> displayed first, so that highlight records can do it's thing.
>>> 
>>> So if there is a list of records and I use the scroll wheel to scroll
>>> somewhere, then I run some code that recalculates a field 4d doesn't
>> update
>>> the display. So my workaround is to cut and use a named selection to get
>>> the fields updated. But it goes back to the top of the list of records
>>> unless there is a record in userset when I can highlight records to get
>>> where I want to be.
>>> 
>>> I could clear the user set with the recalc and add the first record to
>> hit
>>> on display detail back to the userset...
>>> 
>>> then highlight records to scroll down, clear user set, highlight again to
>>> clear highlight, might work...
>>> 
>>> I just don't get why 4d diminished the functionality of redraw window to
>>> make all this necessary!
>>> 
>>> Alan
>>> 
>>> On Mon, May 13, 2019 at 10:00 AM Chip Scheide <4d_o...@pghrepository.org
>>> 
>>> wrote:
>>> 
 you could set the highlight row,
 then do whatever,
 then set the scroll position back
 and (if needed) un set the highlight row
 
 Chip
 On Sat, 11 May 2019 10:06:22 -0400, Alan Tilson via 4D_Tech wrote:
> Hello again,
> What I meant if it wasn't clear is can I get this to work with an
>> Output
> Form showing a list of records?
> Thanks!
> Alan
> 
> On Fri, May 10, 2019 at 5:31 PM Alan Tilson 
 wrote:
> 
>> If I have selected a record HIGHLIGHT RECORDS works fine, but often I
>> haven't.
>> Alan
>> 
>> On Fri, May 10, 2019 at 5:30 PM Alan Tilson 
 wrote:
>> 
>>> Hello out there,
>>> I cannot get OBJECT GET SCROLL POSITION to work with a list form.
>>> OBJECT GET SCROLL POSITION([table]field;scrollPosition) leaves
>>> scrollPosition at zero, wherever I have scrolled.
>>> Thanks!
>>> Alan
>>> 
>>> On Tue, Jun 12, 2018 at 6:31 PM Richard Wright via 4D_Tech <
>>> 4d_tech@lists.4d.com> wrote:
>>> 
 Thanks, Miyako, that works!
 
 
> From: Keisuke Miyako 
> To: 4D iNug Technical <4d_tech@lists.4d.com>
> Subject: Re: Scroll position of display-type subform
> Message-ID: <30f1fc18-68d9-4b1b-9413-aba4d7db5...@4d.com>
> Content-Type: text/plain; charset="utf-8"
> 
> haven't tried,
> but I wonder if CONVERT COORDINATES would be smart enough to take
 into
 account the scrolled amount of a detail subform.
> 
> 
 
 http://doc.4d.com/4Dv16/4D/16.3/CONVERT-COORDINATES.301-3651760.en.html
> 
>> 2018/06/12 7:37、Richard Wright via 4D_Tech <4d_tech@lists.4d.com>
 のメール：
>> I need to get the position of an object on a display-type subform
>> in
 global coordinates and the subform may be scrolled.
> 
 
 
>> **
 4D Internet Users Group (4D iNUG)
 FAQ:  http://lists.4d.com/faqnug.html
 Archive:  http://lists.4d.com/archives.html
 Options: https://lists.4d.com/mailman/options/4d_tech
 Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
 
>> **
>>> 
>>> 
> **
> 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: list box issue

[Chip Scheide via 4D_Tech]

Chuck,
you said the column is not enterable - disabled for a check box
a disabled check box shows as light grey, and if checked the check is 
darker grey

so actually is sounds as if it draws incorrectly the first time in - 
appearing blue = enterable

You might be able to change the color (blue) of the disabled check box 
- but I have never tried this.

Chip

On Tue, 14 May 2019 15:37:32 -0400, Charles Miller wrote:
> This is sub form so events don’t work the way you think and why would it
> work the first time in and only fails when activate happens. I have even
> changed to a variable and set during on display detail
---
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
**

Re: list box issue

[Chip Scheide via 4D_Tech]

On Tue, 14 May 2019 15:28:40 -0400, Charles Miller via 4D_Tech wrote:
> If I change the column to
> allow entry, this issue goes away

Form event = on activated
  set enterable
  set disabled

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

Re: v17R4 infelicities

[Chip Scheide via 4D_Tech]

Not using v17(anything) ... but

1 - exit design when going into application environment
to me means close it up. I would try turning this off

2 - try: -(Form.lastQ.outputVAT) or (-1 * Form.lastQ.outputVAT)

On Tue, 14 May 2019 20:25:57 +0100, Jeremy Roussak via 4D_Tech wrote:
> I’m noticing two irritations with R4.
> 
> 1. If I drop into Design mode from Application, open some method 
> windows, then go back into Application with “exit design when going 
> into application environment” checked, the newly-opened windows are 
> lost when I next drop into Design mode, which is rather tedious. If I 
> “restart interpreted” before going into Application mode, those 
> windows are “locked” and remain open.
> 
> 2. I have some variables whose expressions are properties of Form: 
> Form.lastQ.outputVAT, for example. I want to display some as their 
> negatives; when I set the expression to “-Form.lastQ.outputVAT”, 
> only the - shows up in the form editor. 
> 
> Screenshot here: 
> 
https://www.dropbox.com/s/w4mwp6ogqdh08j0/Screenshot%202019-05-14%2020.25.01.jpg?dl=0
> 
> Are these just me, or should I report them?
> 
> Jeremy
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
---
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
**

Re: Scroll position of display-type subform

[Chip Scheide via 4D_Tech]

I think you can save yourself some work.

if you are working on a record (which is displayed) then...
try this:
do the recalc
(you could clear it first)
ADD the record to the listbox selection set
use your named selection

I *think* 4D will scroll the display to show the highlighted record.

if not
you should be able to get the location of that record
then scroll to that location - the record that was worked on is now 
highlighted so the user can see the result

Chip

On Tue, 14 May 2019 14:22:36 -0400, Alan Tilson wrote:
> Hello Chip,
> 
> The issue is how do I determine where the scroll is or which record is
> displayed first, so that highlight records can do it's thing.
> 
> So if there is a list of records and I use the scroll wheel to scroll
> somewhere, then I run some code that recalculates a field 4d doesn't update
> the display. So my workaround is to cut and use a named selection to get
> the fields updated. But it goes back to the top of the list of records
> unless there is a record in userset when I can highlight records to get
> where I want to be.
> 
> I could clear the user set with the recalc and add the first record to hit
> on display detail back to the userset...
> 
> then highlight records to scroll down, clear user set, highlight again to
> clear highlight, might work...
> 
> I just don't get why 4d diminished the functionality of redraw window to
> make all this necessary!
> 
> Alan
> 
> On Mon, May 13, 2019 at 10:00 AM Chip Scheide <4d_o...@pghrepository.org>
> wrote:
> 
>> you could set the highlight row,
>> then do whatever,
>> then set the scroll position back
>> and (if needed) un set the highlight row
>> 
>> Chip
>> On Sat, 11 May 2019 10:06:22 -0400, Alan Tilson via 4D_Tech wrote:
>>> Hello again,
>>> What I meant if it wasn't clear is can I get this to work with an Output
>>> Form showing a list of records?
>>> Thanks!
>>> Alan
>>> 
>>> On Fri, May 10, 2019 at 5:31 PM Alan Tilson 
>> wrote:
>>> 
 If I have selected a record HIGHLIGHT RECORDS works fine, but often I
 haven't.
 Alan
 
 On Fri, May 10, 2019 at 5:30 PM Alan Tilson 
>> wrote:
 
> Hello out there,
> I cannot get OBJECT GET SCROLL POSITION to work with a list form.
> OBJECT GET SCROLL POSITION([table]field;scrollPosition) leaves
> scrollPosition at zero, wherever I have scrolled.
> Thanks!
> Alan
> 
> On Tue, Jun 12, 2018 at 6:31 PM Richard Wright via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> 
>> Thanks, Miyako, that works!
>> 
>> 
>>> From: Keisuke Miyako 
>>> To: 4D iNug Technical <4d_tech@lists.4d.com>
>>> Subject: Re: Scroll position of display-type subform
>>> Message-ID: <30f1fc18-68d9-4b1b-9413-aba4d7db5...@4d.com>
>>> Content-Type: text/plain; charset="utf-8"
>>> 
>>> haven't tried,
>>> but I wonder if CONVERT COORDINATES would be smart enough to take
>> into
>> account the scrolled amount of a detail subform.
>>> 
>>> 
>> 
>> http://doc.4d.com/4Dv16/4D/16.3/CONVERT-COORDINATES.301-3651760.en.html
>>> 
 2018/06/12 7:37、Richard Wright via 4D_Tech <4d_tech@lists.4d.com>
>> のメール：
 I need to get the position of an object on a display-type subform in
>> global coordinates and the subform may be scrolled.
>>> 
>> 
>> **
>> 4D Internet Users Group (4D iNUG)
>> FAQ:  http://lists.4d.com/faqnug.html
>> Archive:  http://lists.4d.com/archives.html
>> Options: https://lists.4d.com/mailman/options/4d_tech
>> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
>> **
> 
> 
>>> **
>>> 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
>>> **
>> ---
>> Gas is for washing parts
>> Alcohol is for drinkin'
>> Nitromethane is for racing
>> 
---
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
**

Re: Scroll position of display-type subform

[Chip Scheide via 4D_Tech]

you could set the highlight row, 
then do whatever,
then set the scroll position back
and (if needed) un set the highlight row

Chip
On Sat, 11 May 2019 10:06:22 -0400, Alan Tilson via 4D_Tech wrote:
> Hello again,
> What I meant if it wasn't clear is can I get this to work with an Output
> Form showing a list of records?
> Thanks!
> Alan
> 
> On Fri, May 10, 2019 at 5:31 PM Alan Tilson  wrote:
> 
>> If I have selected a record HIGHLIGHT RECORDS works fine, but often I
>> haven't.
>> Alan
>> 
>> On Fri, May 10, 2019 at 5:30 PM Alan Tilson  wrote:
>> 
>>> Hello out there,
>>> I cannot get OBJECT GET SCROLL POSITION to work with a list form.
>>> OBJECT GET SCROLL POSITION([table]field;scrollPosition) leaves
>>> scrollPosition at zero, wherever I have scrolled.
>>> Thanks!
>>> Alan
>>> 
>>> On Tue, Jun 12, 2018 at 6:31 PM Richard Wright via 4D_Tech <
>>> 4d_tech@lists.4d.com> wrote:
>>> 
 Thanks, Miyako, that works!
 
 
> From: Keisuke Miyako 
> To: 4D iNug Technical <4d_tech@lists.4d.com>
> Subject: Re: Scroll position of display-type subform
> Message-ID: <30f1fc18-68d9-4b1b-9413-aba4d7db5...@4d.com>
> Content-Type: text/plain; charset="utf-8"
> 
> haven't tried,
> but I wonder if CONVERT COORDINATES would be smart enough to take into
 account the scrolled amount of a detail subform.
> 
> 
 http://doc.4d.com/4Dv16/4D/16.3/CONVERT-COORDINATES.301-3651760.en.html
> 
>> 2018/06/12 7:37、Richard Wright via 4D_Tech <4d_tech@lists.4d.com>
 のメール：
>> I need to get the position of an object on a display-type subform in
 global coordinates and the subform may be scrolled.
> 
 
 **
 4D Internet Users Group (4D iNUG)
 FAQ:  http://lists.4d.com/faqnug.html
 Archive:  http://lists.4d.com/archives.html
 Options: https://lists.4d.com/mailman/options/4d_tech
 Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
 **
>>> 
>>> 
> **
> 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
> **
---
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
**

Re: Printing an existing PDF File in Windows 10

[Chip Scheide via 4D_Tech]

Doug,
2 suggestions:
- 1 - go to www.computerhope.com -- very good, and seemingly complete, 
documentation for OSX, Linux, DOS, Windows.  You can get the exact 
syntax for the command(s) you want.

- 2 - get whatever you end up with working from the command line -- 
FIRST --, then screw around with getting LEP to work.  I have found 
some commands just will Not run through LEP (xCopy is one).

Chip

On Mon, 6 May 2019 14:22:53 -0400, Doug Cottrill via 4D_Tech wrote:
> Julio (and all),
> 
> So I tried the following code:
> 
> $docName:=Select document("";".pdf";"Please select a document for 
> print test:";0)   
> If (OK=1)
>   LAUNCH EXTERNAL PROCESS("print "+Document)
>   LAUNCH EXTERNAL PROCESS("print "+Char(Quote)+Document+Char(Quote))
>   LAUNCH EXTERNAL PROCESS("print";Document)
>   LAUNCH EXTERNAL PROCESS(Char(Quote)+"print "+Document+Char(Quote))
> End if 
> 
> But none of those calls actually caused the selected PDF file to be printed.
> I tried them one at a time but put them all there at once for clarity.
> So, I’m clearly not getting the exact format correct.  Can someone tell me
> what the exact syntax should be to get this to work?  I have set PDF Reader
> to be the default application and verified that I can print the 
> document I select
> if I open it manually.
> 
> So, any ideas on what I’m doing wrong?  More generally, is there a 
> resource I can 
> review to understand what I should be doing with LEP on windows in general.
> 
> If I can’t figure it out, I will try using the Win32API that someone 
> else suggested-
> the downside is that on windows you do actually have to open the 
> document in a 
> visible 4D window first, but I think we can live with that as long as 
> we don’t need
> any user interaction to get it to print.  (I’m actually printing 
> multiple documents in
> one go, so having to do all the page setup stuff each time would get 
> old fast)
> 
> Thanks,
> 
> DKC
> 
> 
>> On May 6, 2019, at 10:57 AM, Doug Cottrill via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>> 
>> Thanks Julio! I will give that a try- sounds like exactly what I was 
>> hoping for.
>> 
>>> On May 4, 2019, at 7:09 AM, Julio Carneiro via 4D_Tech 
>>> <4d_tech@lists.4d.com> wrote:
>>> 
>>> Try: “print xx.pdf”… simple as that :-)  
>>> 
>>> it tells Win 10 to just print the document using whatever app is 
>>> set do print the type of document passed to the command. It’ll no 
>>> open the app, will just print the document.
>>> 
>>> hth
>>> julio
>>> 
>> 
> 
> 
> **
> 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
> **
---
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
**

Re: 4D V15 crash

[Chip Scheide via 4D_Tech]

immediate observation -
OS version 14.4 v 14.3  have them try to update OS

> My client (4 time zones away), had been running the single user 
> compiled and merged app under windows. Then he purchased a new Mac. 
> It is running 10.14.3, I’m running 10.14.4. I have moved the 
> appropriate mac app files to his machine, along with the datafile and 
> index file from his PC.
> 
> 4D crashes on startup.
> 
> Then I had him add a printer. Tried again. No  luck.
> 
> Any ideas?
> _
> 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
> **

Hell is other people 
 Jean-Paul Sartre
**
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: Re(2): Window reverse layering issues

[Chip Scheide via 4D_Tech]

if the user clicks on it to bring it forward it has to have received 
the click, and it should generate either or both outside call, activate.

Chip

On Fri, 3 May 2019 11:48:52 -0700, Don Lapin wrote:
> Hi Chip,
> 
> Does the incorrectly-layered window (the type 8 in this case, 
> supposed to be in back of the modal) receive events? I haven't tried 
> that yet.
> 
> Thanks,
> Don
> 
> 
>> how about...
>> a bit clunky - but should work
>> 
>> when you open the modal dialog on top of the non modal window, you grab 
>> the modal window's window reference.
>> 
>> then in the form event of the non-modal (I presume larger window)
>> during either On OUTSIDE CALL and/or ON ACTIVATE:
>> Hide Window()
>> Show window()
>> 
>> You have to issue Hide Window, otherwise Show Window does nothing.
>> This will bring the modal window to the front, removing the double 
>> square cursor
>> 
>> BTW - the user can also use  to swap window positions if one 
>> gets hidden.
>> 
>> Side Note: this can be avoided on a Mac by using window type 34 (sheet 
>> window) then the dialog shows up as a 'pop down' window and is part of 
>> the main window.
>> 
>> Chip
>> 
>> On Thu, 2 May 2019 15:59:09 -0700, Don Lapin via 4D_Tech wrote:
>>> Having a couple of problems with window layering and wondered about 
>>> what other developers do as workarounds.
>>> 
>>> 1. A 4D application has two processes, each with windows being shown. 
>>> One process has two windows: a semi-modal dialog on top of a Type 8 
>>> non-modal. User is over in another (windowed) process, and clicks 
>>> back onto the wrong window of the first process (the Type 8 instead 
>>> of the semi-modal)...and so gets the double-square cursor. The user 
>>> is not familiar with 4D per se and therefore doesn't know about 
>>> [Ctrl]-Z.
>>> 
>>> 2. The same situation as #1, but the user is in an external 
>>> application like Chrome. Instead of using [Alt]-[Tab] to return to 
>>> 4d, the user clicks with the mouse, and doesn't click on the 
>>> frontmost window.
>>> 
>>> Anybody?
>>> 
>>> Thanks,
>>> Don
>>> 
>>> **
>>> 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
>>> **
>> ---
>> Gas is for washing parts
>> Alcohol is for drinkin'
>> Nitromethane is for racing 
> 
> 
> 
---
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
**

Re: Window reverse layering issues

[Chip Scheide via 4D_Tech]

how about...
a bit clunky - but should work

when you open the modal dialog on top of the non modal window, you grab 
the modal window's window reference.

then in the form event of the non-modal (I presume larger window)
during either On OUTSIDE CALL and/or ON ACTIVATE:
Hide Window()
Show window()

You have to issue Hide Window, otherwise Show Window does nothing.
This will bring the modal window to the front, removing the double 
square cursor

BTW - the user can also use  to swap window positions if one 
gets hidden.

Side Note: this can be avoided on a Mac by using window type 34 (sheet 
window) then the dialog shows up as a 'pop down' window and is part of 
the main window.

Chip

On Thu, 2 May 2019 15:59:09 -0700, Don Lapin via 4D_Tech wrote:
> Having a couple of problems with window layering and wondered about 
> what other developers do as workarounds.
> 
> 1. A 4D application has two processes, each with windows being shown. 
> One process has two windows: a semi-modal dialog on top of a Type 8 
> non-modal. User is over in another (windowed) process, and clicks 
> back onto the wrong window of the first process (the Type 8 instead 
> of the semi-modal)...and so gets the double-square cursor. The user 
> is not familiar with 4D per se and therefore doesn't know about 
> [Ctrl]-Z.
> 
> 2. The same situation as #1, but the user is in an external 
> application like Chrome. Instead of using [Alt]-[Tab] to return to 
> 4d, the user clicks with the mouse, and doesn't click on the 
> frontmost window.
> 
> Anybody?
> 
> Thanks,
> Don
> 
> **
> 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
> **
---
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
**

Forums

[Chip Scheide via 4D_Tech]

personally - they are horrible

I made a feature request for improvements:
https://forums.4d.com/Post//29609582/1/

vote for and/or add your own

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

Re: Resizing text on en Entry form

[Chip Scheide via 4D_Tech]

well it also has to take into account :
- spacing BETWEEN objects.
- vertical alignment
- horizontal alignment

... and I was hoping not to have to re-invent the wheel, so to speak  :)

Chip

On Wed, 1 May 2019 08:40:34 +0200, Herr Alexander Heintz via 4D_Tech 
wrote:
> Its basically not that complicated, BUT…
> It would require not only changing the font size, but also resizing 
> and moving all objects accordingly.
---
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
**

Re: Split Screen Support with 4D and MacOS?

[Chip Scheide via 4D_Tech]

you can still do this - just expand the explorer windows to show the 
'preview'
or
I do not remember who created it/them - but I know there are components 
which will export all methods to text you can then compare using 
something like Textwrangler's diff functions, or a Code management 
system, or it maybe built into the component.

I'm sure someone will speak up about the component.

Chip

On Tue, 30 Apr 2019 21:34:49 -0700, Tom Benedict wrote:
> Thanks Chip,
> 
>> - display the explorer in both
>> 
>> - adjust the windows so you can see the column (list of methods/forms 
>> whatever) in the destination.
> 
> Drag and Drop between Explorer windows will work, but since I’m 
> moving code between versions (15 to 16) I’m reluctant to replace 
> whole methods where v16 specific changes may have already been made, 
> so I’d like to compare first, hence my goal of having a side-by-side 
> ‘split window’ view.
> 
> Tom
> 
>> On Apr 30, 2019, at 15:23, Chip Scheide <4d_o...@pghrepository.org> wrote:
>> 
>> Tom,
>> don't copy/paste
>> drag n drop
>> 
>> - open 2 copies of 4D with what ever systems you want
>> - display the explorer in both
>> - adjust the windows so you can see the column (list of methods/forms 
>> whatever) in the destination.
>> - drag from the source to destination.  
>>  -- release when the cursor is a green +
>> 
>> example
>> source  -- moving 5 methods 
>> - select the 5 methods
>> - click and hold any of the selected ones, drag
>> - drag to explorer window in destination
>> - drop
>> 
>> depending on your setting you may see a dialog to click through 
>> regarding what to do with duplicated resources (style sheets, methods 
>> etc)
>> 
>> Chip
> 
---
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
**

Resizing text on en Entry form

[Chip Scheide via 4D_Tech]

I have code to resize the font in a listbox/listing form.

I was wondering if there anyone has code they would share to resize all 
text on an entry form?  something like command/control + (or -) on a 
web page.

Thanks
Chip
---
Hell is other people 
 Jean-Paul Sartre
**
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: Split Screen Support with 4D and MacOS?

[Chip Scheide via 4D_Tech]

Tom,
don't copy/paste
drag n drop

- open 2 copies of 4D with what ever systems you want
- display the explorer in both
- adjust the windows so you can see the column (list of methods/forms 
whatever) in the destination.
- drag from the source to destination.  
  -- release when the cursor is a green +

example
source  -- moving 5 methods 
- select the 5 methods
- click and hold any of the selected ones, drag
- drag to explorer window in destination
- drop

depending on your setting you may see a dialog to click through 
regarding what to do with duplicated resources (style sheets, methods 
etc)

Chip

On Tue, 30 Apr 2019 15:05:00 -0700, Tom Benedict via 4D_Tech wrote:
> After 25 years of using 4D on Windows I have started using 4D on Mac. 
> I am rather surprised at how many useful productivity features in 
> Windows are extremely hard to accomplish on MacOS. I suspect it’s 
> mostly a newbie thing. 
> 
> Right now I’m trying to copy/paste a lot of code edit from one 4D 
> structure to another. I have read that it is possible to set up ‘
> split screen’ views of applications on MacOS, which would make it a 
> lot easier to keep track of my changes. To assign and application to 
> a split portion of a screen you’re supposed to click-hold on the “
> full screen” (green) button in any window’s titlebar, then drag the 
> resulting small window image to the side of the screen you want the 
> app to be limited to. That works for non-4D apps, but click-hold on 
> the “full screen” button on a 4D window doesn’t appear to do 
> anything on a 4D window (no small windows image appears). I’ve tried 
> this with 4D v15 and v16. 
> 
> Am I missing something? If not, how do others work with two 4D 
> structures on MacOS?
> 
> 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
> **
---
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
**

Re: Data Merge from v13 to v15

[Chip Scheide via 4D_Tech]

Ronnie,
I do not remember, and with a little bit of experimenting you can 
figure it out.
BUT
as I recall if use SEND RECORD from [table A] which is a subset of 
[table A] in the receiving table this works.

issues :
- field order would need to be the same (at least through the fields 
sent from the old system).
- field data types probably have to match
- as Chuck said, Record keys might be an issue depending on what/how 
the internal keys were designed.

Keys:
-if you used UUIDs (unlikely, but not impossible, in v13) then no issue
- if you used longings (most likely) then you probably end up with 
duplicated keys for different data., and you will need some way to 
determine what to do with the duplicated key data.
  -- look for other identifiers to determine if the 'old' data is 
duplicated
   --- if not duplicated generate new keys, and save
   --- if duplicated - what to do?  that is a business process decision 
and will likely need to be take up with the owners of the data.


If I remember incorrectly and SEND/RECEIVE RECORD fail if the strutter 
is at all different.  Then writing an export/import will be needed.  
You will still need to watch the key issue above.

If you want/need, I can send you a v13 component that includes a record 
export to text.
let me know off list.

Chip

On Tue, 30 Apr 2019 14:53:26 +0800, Ronnie Teo via 4D_Tech wrote:
> Hi All,
> 
> A client has requested to decommissiona v13 database and merge the 
> data into a separate v15 database.
> The 2 database structures started the same (as in same tables and 
> fields) but has expanded in different directions down the years.
> It would be fair to say that the fields in the v13 structure would be 
> a subset of the v15 structure.
> 
> A send/receive record option would not be feasible.
> Tinkling with some ideas, perhaps exporting table data to CSV file 
> (from v13) and import into v15.   
> Or perhaps just exporting individual tables (individual) fields to 
> text files with custom delimiters….
> 
> What would be the best way to accomplish this? 
> 
> Regards,
> Ronnie
> Tarawerkz
> 
> **
> 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
> **
---
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
**

Re: Unexpected authentication window appears in web area

[Chip Scheide via 4D_Tech]

windows firewall?
windows running though a proxy?
through a different router/switch?
have you tried entering your network (email or or server) credentials?

if you can determine what credentials are accepted maybe you figure out 
what the cause is

Chip

On Thu, 25 Apr 2019 22:29:34 +0200, Peter Jakobsson via 4D_Tech wrote:
> Hi Randy
> 
> Thanks for your reply. Just to clarify, there’s no code involved. 
> It’s simply a web area through which I’m accessing the web. Behaves 
> as expected on the Mac but generates this authentication dialog out 
> of nowhere on Windows.
> 
> Peter
> 
> 
>> On 25 Apr 2019, at 22:23, Randy Engle via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>> 
>> Possibly, something is failing in the ON WEB AUTHENTICATION 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
> **
---
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
**

Project methods vs ...

[Chip Scheide via 4D_Tech]

Chris B made the below statement about project methods.

from a 'classic' 4D pogromming view, IMHO - which may mean nothing :), 
this is not the approach I use or advocate.

I do use object methods - but - only to call project methods which do 
all of the actual work.
ex: accept button script
// accept button script <[table].form.object>
tablename_entry_accept
   // end accept button script <[table].form.object>

the project method tablename_entry_accept will do data entry 
validation, messaging about entry failures, related record existence, 
calculations that need to be done etc. and usually an ACCEPT


Why?
Deduplication of code. Code should NOT be repeated. In the above 
example, the code to accept the form maybe reusable or be made more 
generic (with parameters). If the code for this accept button was 
placed in the object script - I might end up re-creating/repeating the 
code elsewhere (even to the point of copy/paste). 

At some point in the future I might need to change the logic/code. Then 
I would need to find all instances of the code through out the system, 
to make the change. If the system is NOT one I wrote, or it has been a 
long time (3 days?) since I worked on that section I would/might not 
know where all instances of the duplicated code are.

If the code is in a project method, I can make the changes needed in 
one place, done.
Also - code in scripts is harder to find/maintain.

Some people in the past have advocated for removal of all object 
scripts, placing the code instead into the form method (or better the 
project method called by the form method). I do not personally do this, 
as I looked at it once and, to me, the resulting code was too long and 
not clear -- of course maybe I was not implementing the idea correctly 
or completely :)

just my 2 cents

Chip


On Wed, 24 Apr 2019 22:37:51 -0600, Chris Belanger via 4D_Tech wrote:
> 
> Another use for it that I have not explored yet is to have a chunk of 
> code that gets run under several different circumstances, but which I 
> don’t want to make a dedicated Project Method for it.
> I prefer to reduce the number of Project Methods while, of course, 
> creating ones that make logical sense (as they can be called in 
> several places in my code). But you understand that as a programmer.
---
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
**

Re: -1 undefined database event

[Chip Scheide via 4D_Tech]

immediate thoughts:
- the data file it self is read only.
 -- due to file access permissions (from the OS)
 -- the data file is open by another copy of the structure
 -- the record (or more) are damaged in some manner (run MSC)

Chip


On Wed, 24 Apr 2019 16:23:09 -0500, David Ringsmuth via 4D_Tech wrote:
> The message says the record is locked, but 4D’s Locked($pTable->) 
> returns false, and so does 4D’s Read only state($pTable->).
> 
> Under what circumstances would this happen?
> 
> Undefined Database Event.[-1] in the method 'Save_Record', on line 50.
> Method: Save_Record
> Line: 50
> 1066: dbmg: Record  is locked in table Student of database CMv10
> 1046: dbmg: Cannot save record 132171 in table Student of database CMv10
> 
> If (Not(Locked($pTable->)) & Not(Read only state($pTable->)))
> If (ModifiedRecord ($pTable;1+2;->$tModified))
>   Error:=0
>   C_TEXT($WindowTitle_t)
>   SAVE RECORD($pTable->)  // this is line # 50
> End if
> else
> ...
> end if
> 
> David Ringsmuth
> 
> **
> 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
> **
---
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
**

More Engine quesitons

[Chip Scheide via 4D_Tech]

Custom desktop icon.

Is there a way to get the icon to 'stick'?
i.e. apply the icon in such a way that when I rebuild the app I do not 
have to manually place it.

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

Re: Engined App

[Chip Scheide via 4D_Tech]

Thanks - 
not happening :)

CHip
On Wed, 24 Apr 2019 09:46:52 -0700, Douglas von Roeder via 4D_Tech 
wrote:
> Chip:
> 
> That’s a licensing issue. I checked a few years back and the price was $3k.
> 
> --
> Douglas von Roeder
> 949-336-2902
> 
> 
> On Wed, Apr 24, 2019 at 9:43 AM Chip Scheide via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> 
>> Can the 'splash' on exit of an engined application be removed?
>> 
>> Chip
>> ---
>> 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
>> **
> **
> 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
> **
---
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
**

Re: Code signing works on one app but fails on another

[Chip Scheide via 4D_Tech]

compress the dmg (zip it) before uploading to dropbox?


On Wed, 24 Apr 2019 17:42:10 +0100, Pat Bensky via 4D_Tech wrote:
> Actually it doesn't seem to be working ... it seems to corrupt the app in
> some way.
> It's quite bizarre ... I compile the app, sign it using Miyako's code, and
> create a disk image using DropDMG. I check it by mounting the disk image
> and installing the app. It runs OK.
> Then I upload it to DropBox.
> Download it from Dropbox, open it, install it, and it will not run. The app
> starts to open and then I get the message "CatBase 8 is damaged and can't
> be opened."
> 
> Any ideas?
> 
> On Thu, 4 Apr 2019 at 11:52, Pat Bensky  wrote:
> 
>> Brilliant, thank you Miyako!
>> Note that I needed to make one change to the code, in the method "code
>> sign":
>> 
>> Change
>> 
>> $infoPlistPath:=$applicationPath+Folder separator+\
>> 
>> "Contents"+Folder separator+"Info.plist"
>> 
>> 
>> to
>> 
>> 
>> $infoPlistPath:=$applicationPath+\
>> 
>> "Contents"+Folder separator+"Info.plist"
>> 
>> Pat
>> 
>> On Thu, 4 Apr 2019 at 01:32, Keisuke Miyako via 4D_Tech <
>> 4d_tech@lists.4d.com> wrote:
>> 
>>> the text edit setting "smart dashes" may convert double hyphens to dash,
>>> which is not what you want in this context.
>>> 
>>> https://support.apple.com/kb/PH23628?locale=ja_JP=en_US
>>> 
>>> a single hyphen must be used with a short option name (-f)
>>> a double hyphen must be used with a short option name (--force)
>>> 
>>> -force is therefore an invalid instruction (single hyphen+long option
>>> name).
>>> 
>>> I've posted a utility to ease the process of signing
>>> 
>>> https://github.com/miyako/4d-utility-build-application
>>> 
>>> it is written in v17 but the target app path can be any path.
>>> 
>>> 2019/04/03 8:05、Pat Bensky via 4D_Tech <4d_tech@lists.4d.com>> 4d_tech@lists.4d.com>>のメール:
>>> ―force: No such file or directory
>>> 
>>> 
>>> **
>>> 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
>>> **
>> 
>> 
>> 
>> --
>> *
>> CatBase - Top Dog in Data Publishing
>> tel: +44 (0) 207 118 7889
>> w: http://www.catbase.com
>> skype: pat.bensky
>> *
>> 
> 
> 
> -- 
> *
> CatBase - Top Dog in Data Publishing
> tel: +44 (0) 207 118 7889
> w: http://www.catbase.com
> skype: pat.bensky
> *
> **
> 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
> **
---
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
**