Re: SVG Overlay Layer

2018-08-05 Thread Jim Dorrance via 4D_Tech
The On Hover annotation balloon is another svg image on top of the data svg image On Mon, Aug 6, 2018 at 12:28 AM, John J Foster via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Hey Jim, > > Thanks for the example. > > It looks like a single svg image and then some dragging logic. Is that > correct?

Re: SVG Overlay Layer

2018-08-05 Thread John J Foster via 4D_Tech
Hey Jim, Thanks for the example. It looks like a single svg image and then some dragging logic. Is that correct? My intention is to draw on top of the image. So I am thinking I’ll just: 1. Make it clear I’m in drawing mode. This will prevent any of the underlying objects from firing any code.

Re: selected rows for a collection listbox

2018-08-05 Thread John DeSoi via 4D_Tech
I found a solution that has good performance and does not require creating thousands of objects for rows that will never be displayed. - The listbox collection is initially setup as a collection of row numbers. Using ARRAY TO COLLECTION seems to be the fastest way to do this. About 30

Re: Export text columns containing carriage returns to Excel?

2018-08-05 Thread Perkins, Bradley D via 4D_Tech
Keith, I asked because I haven't seen that feature. I mostly work with non-4D systems these days and some have that capability. Also, I'd like to not have to install code, a component etc as I'm trying to do the export from their production compiled database. It is looking like I can probably

Re: Export text columns containing carriage returns to Excel?

2018-08-05 Thread Keith Goebel via 4D_Tech
Brad, I don’t know - I rarely use 4D’s export and when I do it’s only for a quick text file (tab delimited) export. I do my main exports using code and the csv version follows the cvs rules and it works great. Sorry I can’t share the code - it is buried in a contracted project. I suspect there

Re: Export text columns containing carriage returns to Excel?

2018-08-05 Thread Perkins, Bradley D via 4D_Tech
Hi Tom, I've been working this with the QR Editor with some success. Another challenge I've found is that the 4D text fields have carriage returns, carriage return/new line pairs, and even some tabs. Therefore I'll need to nest the calls to Replace string in the proper order to place markers

Re: Export text columns containing carriage returns to Excel?

2018-08-05 Thread Perkins, Bradley D via 4D_Tech
Hi Keith, Is there an explicit CSV option in Export Data or Quick Reports that will properly 'quote' and escape any commas (or tabs, unfortunately there are a few) in the exported text fields? If 4D can produce a file that I don't have to inspect and manipulate prior to importing into Excel

Re: Downloaded 4D app: structure file in read only mode

2018-08-05 Thread Donald Koffman via 4D_Tech
Thanks, Miyako. Yes, I know the structure file being read only is expected, just didn’t expect the warning, since it doesn’t occur when installing form a zipped file. > On Jul 29, 2018, at 8:36 PM, Keisuke Miyako via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > is it not normal and expected

RE: SFTP

2018-08-05 Thread Lo via 4D_Tech
Thank you Gentlemen. Spot on, as always. Best Lo -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Keisuke Miyako via 4D_Tech Sent: 04 August 2018 23:16 To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Keisuke Miyako Subject: Re: SFTP for SFTP:

Re: Fields Missing Getters and setters

2018-08-05 Thread Arnaud de Montard via 4D_Tech
> Le 3 août 2018 à 18:36, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > I am trying to insure that all of my intended primary key fields - are > primary keys. > [...] > > Am I missing something? Yes ;-) I think it's better to use structure xml description instead of SQL:

Re: v13 - marking field as 'Primary Key'

2018-08-05 Thread Arnaud de Montard via 4D_Tech
> Le 3 août 2018 à 18:12, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > Thanks, > I do not really use the online docs > but it is nice to know SQL script example. ++ /* tables and primary keys */ CREATE TABLE Agence ( PK INT32 NOT NULL UNIQUE AUTO_INCREMENT,

Re: SVG Overlay Layer

2018-08-05 Thread Jim Dorrance via 4D_Tech
Hi John, Here is an example: https://www.screencast.com/t/82CWeG8Vqu2 Jim Dorrance jim.dorra...@gmail.com 4...@dorrance.eu www.4d.dorrance.eu PS: If you know of anyone that needs an experienced 4D programmer to add energy and experience to their team, please let me know. I have experience in