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: Managing multiple windows in the same process (v17r5)

[Kirk Brooks via 4D_Tech]

Hi Chris,
Good questions. Here are my thoughts on them based on what I've picked up
from the World Tour and Summits.

On Wed, Jun 26, 2019 at 12:31 AM Chris Belanger via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> 1) What is the reasonable limit as to how many windows/dialogs should get
> opened in the same process?
>
This is going to be limited by the resources available to 4D. A laptop with
the minimum RAM and processor is going to have a lower limit than a nice
new Mac Pro by a long way.

But there's no reason to be opening a huge number of windows. A window is
really a UI portal as it were. We no longer need to hack certain operations
with 'offscreen' or 'hidden' windows so a good design should open a window
for something useful.

On top of that now it's really easy and fast to completely repurpose what a
window is 'doing' anyway. You could design a window interface to be a lot
like the OS window interfaces are - you display something and then
completely change it based on a user action. But now we could revert to any
previous window content like the back button on a Finder window. You would
have to retain the displayed form and the Form contents but with that info
you could reload a past window.

So I think this is a case where the technical limit on the number of
windows is less important than building a good design for the interface.


> 2) do windows that share the same process also share processing time? What
> I mean is: If window A is executing, does window B have to wait until
> Window A is done before any processing it does would start (think CALL FORM
> ( window ) )?
>
> For example: Window A is doing a QUERY that takes a few seconds. Does that
> make Window B (in the same process) unresponsive until Window A has
> finished the QUERY?
>
Prior to preemptive processes each instance of 4D ran on a single core of
the machine. How the CPU cycles were allocated and prioritized was between
4D and OS. To us it looked like multiple processes were running 'parallel'
but it was all happening on a single core. The only way you could truly
have parallel processing was by using server side processes or EXECUTE ON
CLIENT and each of those instances were limited in the same way.

With a preemptive process you can truly have different processes running
concurrently on different cores. Thomas Maul has some great demos of this.
If you aren't a Partner (they may be walled off from non-partners) check
out a presentation he did for 4DMethod . He also
includes a demo of why pre-emptive processing only matters on actual
hardware, not virtualized machines. I forget if that's in the 4DMethod
preso or I saw it at a Summit. Bottom line: preemptive is meaningless on a
virtual machine because the virtual machine is running virtual cores and
then entire virtual machine is running on a single instance of the host
machine. So, if you plan to deploy on AWS or the like don't worry about
preemptive, just use CALL WORKER.

So all the windows in the UI process will work, essentially, like the
windows in the separate processes we used to use. 4D has optimized things
like query a lot, for example. And the speed is improved significantly. I
hear in v18 ORDA may be as fast as classic 4D queries.


> 3) I used separate processes before because it was possible to do
> ‘parallel processing’ that way. Because windows were in separate processes,
> anything one window was working on would not impact the responsiveness of
> other windows.
> Is it still advisable to break out windows under its own process if it may
> need to do substantial processing at times?
>
It would be better to break out the heavy operations using CALL WORKER.
This is really what it's designed for.

Underlying all this is the question of memory management. I have the
impression 4D is committed to optimizing memory use. New process

recommends 0 for the stack size, "Pass 0 in stack to use a default stack
size, suitable for most applications (recommended setting)." The docs go on
to say the size is not total process memory and is influenced by things
like number of windows, number of forms, and so on. This isn't anything new
and doesn't address the situation you start off asking about.

I expect the memory allocation when you pass 0 stack size has been
addressed but it would be good for someone closer to the engineering team
to weight in on it.

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

Complex graph

[stardata.info via 4D_Tech]

Hi All,

Using 4D V16 or V17 on windows, I have need of to do a complex graphical 
representation.


Does someone know a demo application in 4D that explain the use of SVG 
or other 4D features that I can see?


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

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

[Charles Miller via 4D_Tech]

Go to https://firebirdsql.org/en/odbc-driver/ and download the ODBC
driver. Create ODBC connection on your windows box.

Log in and you should be all set


Regards


Chuck

On Wed, Jun 26, 2019 at 10:00 AM Charles Miller  wrote:
>
> I assume this is on windows.. If so, is there an ODBC driver, if so
> you can simply do general selects from 4D by logging into Firebird db
> using ODBC
>
> Regards
>
>
> Chuck
>
> On Wed, Jun 26, 2019 at 8:57 AM Jörg Knebel via 4D_Tech
> <4d_tech@lists.4d.com> wrote:
> >
> > Hi All,
> >
> > I try to transfer a Firebird db to 4D using RazorSQL.
> >
> > Transferring the structure was no big drama but getting the data exported 
> > out of the Firebird using RazorSQL produces an Error no matter what export 
> > option is chosen.
> >
> > The error message reads:
> > Error: serverVersion is an invalid version
> > (GDSServerVersion.INVALID_VERSION)
> >
> > A search for GDS-Server produces rubbish only.
> >
> > Anyone here with some pointers?
> >
> > Any and all help is appreciated.
> >
> > Thanks.
> >
> > 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
> > **
>
>
>
> --
> -
>  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.



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

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

[Charles Miller via 4D_Tech]

I assume this is on windows.. If so, is there an ODBC driver, if so
you can simply do general selects from 4D by logging into Firebird db
using ODBC

Regards


Chuck

On Wed, Jun 26, 2019 at 8:57 AM Jörg Knebel via 4D_Tech
<4d_tech@lists.4d.com> wrote:
>
> Hi All,
>
> I try to transfer a Firebird db to 4D using RazorSQL.
>
> Transferring the structure was no big drama but getting the data exported out 
> of the Firebird using RazorSQL produces an Error no matter what export option 
> is chosen.
>
> The error message reads:
> Error: serverVersion is an invalid version
> (GDSServerVersion.INVALID_VERSION)
>
> A search for GDS-Server produces rubbish only.
>
> Anyone here with some pointers?
>
> Any and all help is appreciated.
>
> Thanks.
>
> 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
> **



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

Re: Complex graph

[stardata.info via 4D_Tech]

Hi All,

I need to do a graph of type istogram as below.


ONE                            ]]

TWO            >  

TRE                                     * 

FOUR                                          + ]]

                2    4    6    8    10    12    14    16    18 20

The histograms must be drawn in horizontal

Someone know a demo that i can to see?

I need to draw some symbols in graph areas.

Thanks

/Ferdinando/

Il 26/06/2019 15:06, stardata.info ha scritto:


Hi All,

Using 4D V16 or V17 on windows, I have need of to do a complex 
graphical representation.


Does someone know a demo application in 4D that explain the use of SVG 
or other 4D features that I can see?


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

Re: 4d-write-like-toolbar-example-for-4d-write-pro help

[Jeremy French via 4D_Tech]

Hi John,

The “classic” 4D Write tool example for Write Pro doesn’t appear to be a 
component. (That’s because project form “Main” has “Published as subform in the 
host database” **unchecked**.

Project methods and 4D Standard actions appear to be how the toolbar and the 
Write Pro communicate.

Open Project form “WPToolbar” and look at the object methods that call project 
method “DisplayMenu”. For objects with no object method, look at the standard 
action specified for the object (ie, 3rd Property List tab).

These standard actions work because **only** the Write Pro area has focus. 
(Note the toolbar has “Focusable” **uncheck**.)

Write Pro standard actions (for v17.2) are listed at:
https://doc.4d.com/4Dv17/4D/17/Using-4D-Write-Pro-standard-actions.200-3726284.en.html
 


Best regards,
Jeremy


> On Jun 26, 2019, at 2:38 PM, John J Foster via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> So I am trying to use the “classic” 4D Write toolbar - as a component - in my 
> app. Here’s the link in case anyone wants to see it.
> 
> https://blog.4d.com/4d-write-like-toolbar-example-for-4d-write-pro/ 
>  
> https://blog.4d.com/4d-write-like-toolbar-example-for-4d-write-pro/ 
> https://blog.4d.com/4d-write-like-toolbar-example-for-4d-write-pro/>>
> 
> There is no obvious way (which means it must be obvious and easy) to connect 
> the behavior of the toolbar to the WP Pro area (or vice versa). I cannot find 
> any instructions.

**
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: Complex graph

[Kirk Brooks via 4D_Tech]

Ferdinando,
For truly complex graphing you can't beat D3 .

On the other hand for the sort of in-line graphs you referenced I heard a
great hack from David Adams: Unicode U+2588 is a small, black, borderless
square. So you create single line histograms in a text var using this
character.

On Wed, Jun 26, 2019 at 11:59 AM stardata.info via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Hi All,
>
> I need to do a graph of type istogram as below.
>
>
> ONE]]
>
> TWO>  
>
> TRE * 
>
> FOUR  + ]]
>
>  24681012141618 20
>
> The histograms must be drawn in horizontal
>
> Someone know a demo that i can to see?
>
> I need to draw some symbols in graph areas.
>
> Thanks
>
> /Ferdinando/
>
> Il 26/06/2019 15:06, stardata.info ha scritto:
> >
> > Hi All,
> >
> > Using 4D V16 or V17 on windows, I have need of to do a complex
> > graphical representation.
> >
> > Does someone know a demo application in 4D that explain the use of SVG
> > or other 4D features that I can see?
> >
> > 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
> **



-- 
Kirk Brooks
San Francisco, CA
===

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

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

Re: v 17.1 potential gotcha

[Tim Nevels via 4D_Tech]

On Jun 26, 2019, at 1:38 PM, Chuck Miller wrote:

> I have a form (invoice ) that I am printing 1 copy of and printing a second 
> copy using set print destination to create a PDF
> I made the following discoveries.
> 
> 1. The print was fine all on page as it should have been
> 2. When opening PDF (Preview)on Mac, print was not fine. Lost part of hear 
> and footer, unless fit to page was selection
> 3. When opening PDF (Acrobat reader)on Mac, print was not fine. Lost part of 
> hear and footer
> 4. When opening PDF on windows, the pdf showed 133% and was re-adjusted to 
> 88% so it printed on one page but not same as actual print
> 
> Solution was to set form scaling top 100%. I am going to compile and build 
> and see if that holds. Every time I open scaling for form=, it resets to 133% 
> on mac to windows
> 
> Does anyone have any other potential fixes

Are you using PAGE SETUP to before you start printing to set the size of the 
paper, or not using PAGE SETUP? That could be the issue.

PAGE SETUP appears to me to be almost a legacy command now. SET PRINT OPTION 
can do most things we used to rely on PAGE SETUP to do: set paper size, set 
landscape or portrait, set scale, etc. And this works cross platform where PAGE 
SETUP doesn't

I would use SET PRINT OPTION(Paper option;…) and specify the paper size. You 
also try SET PRINTABLE MARGIN. No need to “save print settings” to a form any 
longer. You can control all this via code. 

While you are at it, use GET PRINTABLE MARGIN and GET PRINTABLE AREA and see 
what it returns just before you start printing. Might give you info  on what is 
happening. 

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

Re: Complex graph

[Scott Staley via 4D_Tech]

I was able to make the linked chart in View Pro...

Link to:Chart
  






--
Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
**
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: v 17.1 potential gotcha

[Chuck Miller via 4D_Tech]

Thanks Tim, I will give that a shot and see if that also solves the problem, 
much more elegant than my solution

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 Jun 26, 2019, at 4:05 PM, Tim Nevels via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Are you using PAGE SETUP to before you start printing to set the size of the 
> paper, or not using PAGE SETUP? That could be the issue.
> 
> PAGE SETUP appears to me to be almost a legacy command now. SET PRINT OPTION 
> can do most things we used to rely on PAGE SETUP to do: set paper size, set 
> landscape or portrait, set scale, etc. And this works cross platform where 
> PAGE SETUP doesn't
> 
> I would use SET PRINT OPTION(Paper option;…) and specify the paper size. You 
> also try SET PRINTABLE MARGIN. No need to “save print settings” to a form any 
> longer. You can control all this via code. 
> 
> While you are at it, use GET PRINTABLE MARGIN and GET PRINTABLE AREA and see 
> what it returns just before you start printing. Might give you info  on what 
> is happening. 
> 
> Tim

**
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-write-like-toolbar-example-for-4d-write-pro help

[John J Foster via 4D_Tech]

Hi Jeremy,

> The “classic” 4D Write tool example for Write Pro doesn’t appear to be a 
> component. (That’s because project form “Main” has “Published as subform in 
> the host database” **unchecked**.

Yes, I set the property to be available and compiled it into a component.

> These standard actions work because **only** the Write Pro area has focus. 
> (Note the toolbar has “Focusable” **uncheck**.)

Yes I’ve looked at the code and see the call but it didn’t register to me. I 
thought it was relevant to the component form in the matrix but not to the 
object in the host db. Let me look at that again as the mystery might be that 
the toolbar knows what to do because of the object in focus.

Let me give that a try!

Appreciate,
John…


> On Jun 26, 2019, at 1:47 PM, Jeremy French  wrote:
> 
> Hi John,
> 
> The “classic” 4D Write tool example for Write Pro doesn’t appear to be a 
> component. (That’s because project form “Main” has “Published as subform in 
> the host database” **unchecked**.
> 
> Project methods and 4D Standard actions appear to be how the toolbar and the 
> Write Pro communicate.
> 
> Open Project form “WPToolbar” and look at the object methods that call 
> project method “DisplayMenu”. For objects with no object method, look at the 
> standard action specified for the object (ie, 3rd Property List tab).
> 
> These standard actions work because **only** the Write Pro area has focus. 
> (Note the toolbar has “Focusable” **uncheck**.)
> 
> Write Pro standard actions (for v17.2) are listed at:
> https://doc.4d.com/4Dv17/4D/17/Using-4D-Write-Pro-standard-actions.200-3726284.en.html
>  
> 
> 
> Best regards,
> Jeremy
> 
> 
>> On Jun 26, 2019, at 2:38 PM, John J Foster via 4D_Tech <4d_tech@lists.4d.com 
>> > wrote:
>> 
>> So I am trying to use the “classic” 4D Write toolbar - as a component - in 
>> my app. Here’s the link in case anyone wants to see it.
>> 
>> https://blog.4d.com/4d-write-like-toolbar-example-for-4d-write-pro/ 
>>  
>> https://blog.4d.com/4d-write-like-toolbar-example-for-4d-write-pro/ 
>> https://blog.4d.com/4d-write-like-toolbar-example-for-4d-write-pro/>>
>> 
>> There is no obvious way (which means it must be obvious and easy) to connect 
>> the behavior of the toolbar to the WP Pro area (or vice versa). I cannot 
>> find any instructions.
> 

**
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-write-like-toolbar-example-for-4d-write-pro help [SOLVED]

[John J Foster via 4D_Tech]

Hi Jeremy,

Thank you!

That was way too obvious for my simple mind!

So the key is to make sure that the 4D Writ Pro area is focusable and the 
Toolbar is not. In that way, as Jeremy said, the context fro the actions will 
be on the 4D Write Pro area.

Now I will have to reread the 4D Write Pro docs as I suspect I would have read 
that!

Thank you again,
John…


> On Jun 26, 2019, at 2:06 PM, John J Foster  wrote:
> 
> Hi Jeremy,
> 
>> The “classic” 4D Write tool example for Write Pro doesn’t appear to be a 
>> component. (That’s because project form “Main” has “Published as subform in 
>> the host database” **unchecked**.
> 
> Yes, I set the property to be available and compiled it into a component.
> 
>> These standard actions work because **only** the Write Pro area has focus. 
>> (Note the toolbar has “Focusable” **uncheck**.)
> 
> Yes I’ve looked at the code and see the call but it didn’t register to me. I 
> thought it was relevant to the component form in the matrix but not to the 
> object in the host db. Let me look at that again as the mystery might be that 
> the toolbar knows what to do because of the object in focus.
> 
> Let me give that a try!
> 
> Appreciate,
> John…
> 
> 
>> On Jun 26, 2019, at 1:47 PM, Jeremy French > > wrote:
>> 
>> Hi John,
>> 
>> The “classic” 4D Write tool example for Write Pro doesn’t appear to be a 
>> component. (That’s because project form “Main” has “Published as subform in 
>> the host database” **unchecked**.
>> 
>> Project methods and 4D Standard actions appear to be how the toolbar and the 
>> Write Pro communicate.
>> 
>> Open Project form “WPToolbar” and look at the object methods that call 
>> project method “DisplayMenu”. For objects with no object method, look at the 
>> standard action specified for the object (ie, 3rd Property List tab).
>> 
>> These standard actions work because **only** the Write Pro area has focus. 
>> (Note the toolbar has “Focusable” **uncheck**.)
>> 
>> Write Pro standard actions (for v17.2) are listed at:
>> https://doc.4d.com/4Dv17/4D/17/Using-4D-Write-Pro-standard-actions.200-3726284.en.html
>>  
>> 
>> 
>> Best regards,
>> Jeremy
>> 
>> 
>>> On Jun 26, 2019, at 2:38 PM, John J Foster via 4D_Tech 
>>> <4d_tech@lists.4d.com > wrote:
>>> 
>>> So I am trying to use the “classic” 4D Write toolbar - as a component - in 
>>> my app. Here’s the link in case anyone wants to see it.
>>> 
>>> https://blog.4d.com/4d-write-like-toolbar-example-for-4d-write-pro/ 
>>>  
>>> https://blog.4d.com/4d-write-like-toolbar-example-for-4d-write-pro/ 
>>> https://blog.4d.com/4d-write-like-toolbar-example-for-4d-write-pro/>>
>>> 
>>> There is no obvious way (which means it must be obvious and easy) to 
>>> connect the behavior of the toolbar to the WP Pro area (or vice versa). I 
>>> cannot find any instructions.
>> 
> 

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

APPLESCRIPT FROM 4D

[Chuck Miller via 4D_Tech]

I Have the following AppleScript which I run and which works fine

tell application "Preview"
print POSIX file 
"/Volumes/SnapServer/Test_Invoices/Checon_Invoices/2019/04 - 
April/224747_04_12.PDF" with print dialog
end tell

I have the code I use to create it and will share should someone else have a 
need. I am posting for a few reasons. Someone posted about printing
PDFs and I found the windows solution but none for a MAC. This one works. 

Can you print more than one document? if so do I need a second tell application 
or is there some other way. I do not want to muck around to
much as this has taken quite a bit to make work

How would I bring Preview to the front

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

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: v14+ find in design

[Tom Benedict via 4D_Tech]

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

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

v 17.1 potential gotcha

[Chuck Miller via 4D_Tech]

Hi all,

I have a form (invoice ) that I am printing 1 copy of and printing a second 
copy using set print destination to create a PDF
I made the following discoveries.

1. The print was fine all on page as it should have been
2. When opening PDF (Preview)on Mac, print was not fine. Lost part of hear and 
footer, unless fit to page was selection
3. When opening PDF (Acrobat reader)on Mac, print was not fine. Lost part of 
hear and footer
4. When opening PDF on windows, the pdf showed 133% and was re-adjusted to 88% 
so it printed on one page but not same as actual print

Solution was to set form scaling top 100%. I am going to compile and build and 
see if that holds. Every time I open scaling for form=, it resets to 133% on 
mac to windows

Does anyone have any other potential fixes

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

4d-write-like-toolbar-example-for-4d-write-pro help

[John J Foster via 4D_Tech]

Hi All,

4D v17.1 windows (and Mac) (dot release only as client will not use “R” 
releases) This means that I cannot use any 4D Write Pro functionality included 
in any of the “R” release including the 4D Write Pro widget.

So I am trying to use the “classic” 4D Write toolbar - as a component - in my 
app. Here’s the link in case anyone wants to see it.

https://blog.4d.com/4d-write-like-toolbar-example-for-4d-write-pro/ 
https://blog.4d.com/4d-write-like-toolbar-example-for-4d-write-pro/>

There is no obvious way (which means it must be obvious and easy) to connect 
the behavior of the toolbar to the WP Pro area (or vice versa). I cannot find 
any instructions.

I tried making the variable name of the 4D Write Pro area the same as the one 
within the component “WP_WriteProArea”. No effect.

Is anyone using this toolbar component? OR does anyone know what steps I am 
missing?

I know this must be obvious!

Anyone?

Appreciate,
John…


**
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: APPLESCRIPT FROM 4D

[Keisuke Miyako via 4D_Tech]

the "tell" verb specifies the target object in applescript.

so if there is only one line,

> tell application "Preview"
> print POSIX file "/Volumes/SnapServer/Test_Invoices/Checon_Invoices/2019/04 - 
> April/224747_04_12.PDF" with print dialog
> end tell

could be reduced to

> tell application "Preview" to print POSIX file 
> "/Volumes/SnapServer/Test_Invoices/Checon_Invoices/2019/04 - 
> April/224747_04_12.PDF" with print dialog


on the other hand, you can have multiple lines,

> tell application "Preview"
> print POSIX file "/Volumes/SnapServer/Test_Invoices/Checon_Invoices/2019/04 - 
> April/224747_04_12.PDF"
> print POSIX file "/Volumes/SnapServer/Test_Invoices/Checon_Invoices/2019/04 - 
> April/224747_04_13.PDF"
> print POSIX file "/Volumes/SnapServer/Test_Invoices/Checon_Invoices/2019/04 - 
> April/224747_04_14.PDF"
> end tell

you can also pass print settings

tell application "Preview"
print POSIX file "/Volumes/SnapServer/Test_Invoices/Checon_Invoices/2019/04 - 
April/224747_04_12.PDF" with properties {copies:2, collating:true, starting 
page:2}
end tell

etc.

> 2019/06/27 5:50、Chuck Miller via 4D_Tech <4d_tech@lists.4d.com>のメール:
>
> I have the code I use to create it and will share should someone else have a 
> need. I am posting for a few reasons. Someone posted about printing
> PDFs and I found the windows solution but none for a MAC. This one works.
> Can you print more than one document? if so do I need a second tell 
> application or is there some other way. I do not want to muck around to




**
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: APPLESCRIPT FROM 4D

[Keisuke Miyako via 4D_Tech]

you can insert a line

activate

in the tell~end tell block

> 2019/06/27 5:50、Chuck Miller via 4D_Tech <4d_tech@lists.4d.com>のメール:
> How would I bring Preview to the front




**
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: v 17.1 potential gotcha

[Keisuke Miyako via 4D_Tech]

 are you referring the the scaling dialog invoked from the "Form" menu (when 
the form editor is frontmost)

scaling is not a constant property.
it is a one-shot operation that globally resizes all form objects.

the dialog offers 3 options, 133% (72 to 96 DPI), 75% (opposite), or custom 
(default = 100% which means no change, obviously)
whichever ratio you apply, the form is permanently modified and the dialog 
reverts to default values.

the values on print settings (as used with PAGE SETUP), on the other hand, is a 
property saved with the form.
but I think scale is only available on Mac.

2019/06/27 2:44、Chuck Miller via 4D_Tech 
<4d_tech@lists.4d.com>のメール:
olution was to set form scaling top 100%. I am going to compile and build and 
see if that holds. Every time I open scaling for form=, it resets to 133% on 
mac to 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
**

Indexing taking a log time to reindex

[JOHN BAUGHMAN via 4D_Tech]

We have been having major thuderstorms on the Islands these last couple of 
days, and after a second power outage at one of my client sites their database 
had to be recovered from backup. I had problems with the log file, but 
eventually got it back up and the log file integrated. 

In the process I noticed that one of the tables with 52k records and many 
indeed fields, was taking a very long time to index each field. This particular 
table takes over 3  minutes to reindex each indexed field.   I have other 
tables with over 250k records and close to as many index fields where the whole 
table is reindexed in less than a minute. 

These fields are mostly long int, with a number of alpha and boolean field 
thrown into the mix. All seem to take about the same amount of time to index.

As it is what probably should only take about 15 to 20 mins to go through the 
reindexing process, is taking well over an hour. All of the field’s indexing 
method are set to Automatic.

Is this normal? Is there anything I can do to speed them up short of unindexing 
some of them? Are different indexing methods faster than others?

Thanks,

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

Re: Indexing taking a log time to reindex

[Keisuke Miyako via 4D_Tech]

perhaps the reindexing of the 250k table has saturated the cache, leaving 
little space the smaller table.

FLUSH CACHE (FLUSH BUFFERS) with the * could be used to purge objects from the 
cache, if that's the case.

also 15R4 improved the indexing process

https://download.4d.com/Documents/Products_Documentation/LastVersions/Line_15R4/VIntl/4D_Upgrade_v15_R4.pdf

before the optimisation, 4D could jump from table to table during indexing.

> 2019/06/27 10:04、JOHN BAUGHMAN via 4D_Tech <4d_tech@lists.4d.com>のメール:
> Is this normal? Is there anything I can do to speed them up short of 
> unindexing some of them? Are different indexing methods faster than others?




**
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: Indexing taking a log time to reindex

[JOHN BAUGHMAN via 4D_Tech]

> perhaps the reindexing of the 250k table has saturated the cache, leaving 
> little space the smaller table.
> 
> FLUSH CACHE (FLUSH BUFFERS) with the * could be used to purge objects from 
> the cache, if that's the case.

Miyako, I think you may have a point as the problem table appears to be 
one of the last, if not the last.

This is really only a problem when the reindex is automatically 
generated on startup, more than likely after a unexpected shut down during the 
clinic’s working hours, in which case how does one insert a FLUSH CACHE (FLUS 
BUFFERS) into the process? It’s not a problem for me if I am forcing a reindex 
after hours.

> also 15R4 improved the indexing process

This is v16R4.

John


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

Managing multiple windows in the same process (v17r5)

[Chris Belanger via 4D_Tech]

’Traditionally', I have opened windows in their own processes. In the ‘old 
days’ that was because of the need to use process variables, and to avoid any 
possibility that one window would screw up some process vars on another window, 
it was best to isolate them this way.

… new process ( ) ...
Open Form Window ( )
DIALOG ( name )
… additional code …. waits until the DIALOG is closed

But since the FORM object has been introduced, it is simple to isolate one’s 
‘variables’ within a window.  Very brilliant development.
Now 4D is encouraging using the same process for multiple windows using:

Open Form Window ()
DIALOG ( name; * )   // the   *   opens the form in the current process, 
but 
… any subsequent code completes; leaving the FORM open. …



I like that opening multiple windows in the same process is reasonable, given 
that we can use FORM. to manage the dialogs instead of process variables.

My questions are:

1) What is the reasonable limit as to how many windows/dialogs should get 
opened in the same process?

2) do windows that share the same process also share processing time? What I 
mean is: If window A is executing, does window B have to wait until Window A is 
done before any processing it does would start (think CALL FORM ( window ) )?

For example: Window A is doing a QUERY that takes a few seconds. Does that make 
Window B (in the same process) unresponsive until Window A has finished the 
QUERY?

3) I used separate processes before because it was possible to do ‘parallel 
processing’ that way. Because windows were in separate processes, anything one 
window was working on would not impact the responsiveness of other windows.
Is it still advisable to break out windows under its own process if it may need 
to do substantial processing at times?

I understand that CALL WORKER ( ) can help; I have used temporary or special 
processes in the past to do stuff; haven’t used CALL WORKER ( ) yet but I am 
doing a completely new project without any ‘classic’ 4D and just haven’t gotten 
to the point of needing workers yet.



Thanks for any of your observations on the merits / demerits of running 
multiple windows in the same process

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