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

2019-06-26 Thread 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: >

Re: Managing multiple windows in the same process (v17r5)

2019-06-26 Thread 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

Complex graph

2019-06-26 Thread 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/

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

2019-06-26 Thread 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

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

2019-06-26 Thread 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

Re: Complex graph

2019-06-26 Thread stardata.info via 4D_Tech
Hi All, I need to do a graph of type istogram as below. ONE                            ]] TWO            >  TRE                                    * FOUR                                          +

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

2019-06-26 Thread 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.

Re: Complex graph

2019-06-26 Thread 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

Re: v 17.1 potential gotcha

2019-06-26 Thread 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

Re: Complex graph

2019-06-26 Thread 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

Re: v 17.1 potential gotcha

2019-06-26 Thread 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)

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

2019-06-26 Thread 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

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

2019-06-26 Thread 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

APPLESCRIPT FROM 4D

2019-06-26 Thread 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

v14+ find in design

2019-06-26 Thread 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

Re: v14+ find in design

2019-06-26 Thread 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

Re: v14+ find in design

2019-06-26 Thread 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

v 17.1 potential gotcha

2019-06-26 Thread 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

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

2019-06-26 Thread 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

Re: APPLESCRIPT FROM 4D

2019-06-26 Thread 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

Re: APPLESCRIPT FROM 4D

2019-06-26 Thread 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:

Re: v 17.1 potential gotcha

2019-06-26 Thread 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

Indexing taking a log time to reindex

2019-06-26 Thread 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

Re: Indexing taking a log time to reindex

2019-06-26 Thread 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

Re: Indexing taking a log time to reindex

2019-06-26 Thread 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

Managing multiple windows in the same process (v17r5)

2019-06-26 Thread 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 ( ) ...