Re: Complex graph

2019-06-30 Thread Bernd Fröhlich via 4D_Tech
stardata.info: > I've thought of this option. > Have you a database example? Here is part of a calendar that I create with a listbox: The basics are quite simple: Just setup the listbox in the form-editor (or by code if you like) and color the cells with LISTBOX

Re: Complex graph

2019-06-28 Thread Bernd Fröhlich via 4D_Tech
Scott Staley: > I don't and I actually created the graph in microsoft excel and then opened > it with view pro. A simple graph like that can even be created using a Listbox (if you are on 4D V17). Just set the background colour of the cells to any colour you like. If it gets more complex I

Re: Custom Form Events

2019-04-25 Thread Bernd Fröhlich via 4D_Tech
Chris Belanger: > One simple instance I want to experiment on — which, of course, is trivial, > is: > > I have three fields (actually object attributes) > City > Province (or State) > FullCityName > > FullCityName is computed from City & Province > : (City = “”) —> FullCityName := “” >

RE: Error connecting to 4D Server

2019-04-09 Thread Bernd Fröhlich via 4D_Tech
Stephen J. Orth: > What we get are the multiple errors that started this thread, where already > connected clients simply can no longer talk to the server. Either you get > the -10002/3/4 error message, or the one that is happening mostly is the > "non-blocking" error. I encounter those from

Re: 4D V16 R6 Vs 4D V16.5

2019-03-13 Thread Bernd Fröhlich via 4D_Tech
Milan Adamov: > But there not announced as v16 features, that is simply not true, no one ever > said that. On the contrary, it is explicitly said and written many times that > those features are upcoming features in next major version. So it IS a V17 beta after all... Maybe all the folks at

Re: 4D V16 R6 Vs 4D V16.5

2019-03-13 Thread Bernd Fröhlich via 4D_Tech
Jim Dorrance: > Wouldn't it be less confusing if 4D called v16 R6 something other > than v16 , because the v16 R6 new features will never be released in a v16 > upgrade. Good Idea. v16R6 should really be called V17Beta6. That´s what it is after all. Would save a lot of confusion. Greetings

Re: Closing a window with another application in focus

2019-02-06 Thread Bernd Fröhlich via 4D_Tech
Jeffrey Kain: > On macOS - some of the windows in my application will close if I click on the > close box while another application has the focus, but others don't. > > Does anyone know what the secret is for this? They all close fine if 4D is > the frontmost application - even if other 4D

Re: REDRAW WINDOW not working v17?

2019-01-03 Thread Bernd Fröhlich via 4D_Tech
Alan Tilson: > Hello again Bernd, > > I tried several other things but never got anything to work other than my > original code. Hi Alan, sorry, I´m out of ideas. If my workaround doesn´t help try to contact 4D. Maybe someday we get a working REDRAW WINDOW command again... Greetings from

REDRAW WINDOW not working v17?

2019-01-02 Thread Bernd Fröhlich via 4D_Tech
Alan Tilson: > Has anyone had issues with REDRAW WINDOW working differently or not working > in v17? I have an output form with a boolean variable in the header that > affects the text color of the fields in each line of output as well as > determining which of a few optional fields are

Re: 4D Write for v17

2018-12-16 Thread Bernd Fröhlich via 4D_Tech
Mitchell Shiller: > Where do I get a v17 version of the old 4D Write to run in 32 bit mode? Must > be having a brain cramp cause I don’t see it on the website. It is a "little" bit hidden: there is a tiny note at the bottom in light blue that says

Re: v13 - Why can a record NOT be Pushed?

2018-11-06 Thread Bernd Fröhlich via 4D_Tech
Benedict, Tom: > Another useful tool to avoid disturbing the current selection is to use SQL > queries within Begin SQL...End SQL. I use them frequently to collect data > from various tables into arrays (or objects if you're in the 21st Century). If you´re really in the 21st Century, you use

RE: Defining and documenting Objects

2018-10-11 Thread Bernd Fröhlich via 4D_Tech
Dennis, Neil: >> I LOVE it that there are no longer ANY global variables necessary when >> working with forms > > Is there a way to do hidden rows in a list box? So far I have not found a way > and still have to use a process array. If you know of something please share. Sorry, maybe my

Re: Defining and documenting Objects

2018-10-11 Thread Bernd Fröhlich via 4D_Tech
Peter Jakobsson: > Out of interest, what advantages does this give you over using a global ? The > advantage of a global to me is that it preserves state throughout the life of > the form without any coding. (For example you don’t need to keep using Object > get Pointer(“myPopUp”) all over the

Re: Defining and documenting Objects

2018-10-11 Thread Bernd Fröhlich via 4D_Tech
Peter Jakobsson: > So what I’m doing now is just using a single object to hold all form > properties that I’d previously used globals for. Then just use globals where > required for active objects like menus. Hi Peter, there are no globals required for menus (I assume here that you are

Re: Do I want to use SELECTION TO ARRAY instead of GOTO SELECTED RECORD server-side in V17?

2018-09-17 Thread Bernd Fröhlich via 4D_Tech
David Adams: > I'm checking for the simplest, least difficult default as that should work in > the vast majority of cases. Here are my two Eurocents: it does not matter how you collect the data, but concatenating the text in memory vs. writing to a file makes a HUGE difference when you have

Re: 4D Write to 4D Write Pro

2018-08-30 Thread Bernd Fröhlich via 4D_Tech
Tim Nevels: > The only legacy support they promised to provide is to convert legacy 4D > Write documents. And even that does have it´s problems: Line spacing is not preserved. So if you have e.g. a 6 page 4DWrite document it is 8 pages after the conversion :-/ > But I have a crazy idea… >

Re: New record numbering system and CALL WORKER

2018-08-28 Thread Bernd Fröhlich via 4D_Tech
Kirk Brooks: > scanning back over it a key point is that all of these > contortions and workarounds to preserve a number sequence are based on the > single design decision to use an invoice (in this case) number as a key > field. Nope, the invoice number has never been a key field over here.

Re: New record numbering system and CALL WORKER

2018-08-28 Thread Bernd Fröhlich via 4D_Tech
Pat Bensky: > The important thing is that all record cancellations go through a > *CancelRecord* method. > I created a [SpareRecordNumbers] table which contains 3 fields: unique id, > table number, and spare record number > As I said, it hasn't been thoroughly tested yet. So please feel free to

Re: Conversion to WritePro

2018-08-15 Thread Bernd Fröhlich via 4D_Tech
Pat Bensky: > You can set the line spacing in WritePro v17 using an automatic action: > lineHeight > > *Syntax*: lineHeight?value={ | } > > Paragraph line height. > Ex: *lineHeight?value=120%* > > For example: > > *INVOKE ACTION*("lineHeight?value=110%") > > > Maybe a bit of experimentation

Conversion to WritePro

2018-08-15 Thread Bernd Fröhlich via 4D_Tech
I moved our database from V16.3 to V17.0. I converted 172300 4D Write documents from the last 20 Years to Write Pro using [MyTable]WritePro:=WP New([MyTable]WriteBlob) The good: conversion went without any errors. All the text seems to be there. The bad: layout is not the same. Documents that

Re: E-Mail in 4D

2018-08-15 Thread Bernd Fröhlich via 4D_Tech
Jody Bevan: > The last time I wrote an E-Mail client with 4D was circuit 4D v11 and into > v12. It worked great. I left the programming world for a break for 2 years, > and then got back in. > > Now I am using 16R6, and will likely move into the v17. releases for a > product I am working on.

Re: Orphaned blobs and SSD drives

2018-07-30 Thread Bernd Fröhlich via 4D_Tech
Scott Wirth: > Is there a chance that you once had a blob field that was later converted to > another type? If my understanding is correct this can lead to orphan blobs > when the data in that converted field is changed, particularly if the blob > was stored outside the datafile. I read

Re: Orphaned blobs and SSD drives

2018-07-30 Thread Bernd Fröhlich via 4D_Tech
Keisuke Miyako: > to be clear, > > "BLOB" in this context means object, text, picture or BLOB field (anything > that can be saved outside the record). Ah, OK. > the table doesn't have any of those 4 types? It does have textfields but those are all set to be stored in the record (just

Re: Orphaned blobs and SSD drives

2018-07-30 Thread Bernd Fröhlich via 4D_Tech
Tim Nevels: > Orphaned blobs are not serious. They are due to a bug in 4D. It’s not really > corruption. It’s just some blobs — the ones attached to blob fields that you > have set to store the blob outside the record but in the data file — are > hanging around in the data file and they are

Re: Trouble Decoding Base64 Text

2018-06-30 Thread Bernd Fröhlich via 4D_Tech
Dave Nasralla: > Nevermind, though I'm not entirely sure this isn't a kind of bug. > If you change the Encoding by adding two equal signs to the end > "eyJ1c2VySWQiOiJiMDhmODZhZi0zNWRhLTQ4ZjItOGZhYi1jZWYzOTA0NjYwYmQifQ==" > > It properly decodes to: >

Re: Delay process bug

2018-06-19 Thread Bernd Fröhlich via 4D_Tech
Jeffrey Kain: > It seems like a big clue is that the 4D Server user interface stops updating > when this happens. Like the internal clock/heartbeat/metronome of 4D Server > just stops, and DELAY PROCESS comes along for the ride. Server might be a clue indeed. It happened only on the Server

Re: Delay process bug

2018-06-18 Thread Bernd Fröhlich via 4D_Tech
Keisuke Miyako: > it's not that the DELAY P. has a problem resuming, > the problem manifests itself when the codes pauses a process that is already > in "delay" status. > a double resume is required to cancel a delay-double combo. That would be another bug then. Over here it was a simple loop

Re: Delay process bug

2018-06-15 Thread Bernd Fröhlich via 4D_Tech
Bryan Green: > Actually, that's exactly what I meant -- short-term (5 minutes, 10 minutes, > etc.) kind of delay using DELAY PROCESS is more stable than something like 12 > hours, 1 day, etc. using DELAY PROCESS. If by "more stable" you mean "hangs only every few weeks" that may be right. I

Re: Delay process bug

2018-06-13 Thread Bernd Fröhlich via 4D_Tech
Cannon Smith: > We just released a new version of our software a week and a half ago. In this > version I added a palette window on the server which runs On Timer. I also > added code to most every background process which updates some information > every time it wakes up from a Delay Process

Re: High Sierra - Export Text in 4D v13.6

2018-06-06 Thread Bernd Fröhlich via 4D_Tech
setar accnt: > Came across a weird behavior and want to know if anyone else has encountered > this and how to solve this (mac & V13.6 & v15) > I use a document (“StoreHere.txt") in the Resources folder to store some data > in it, to be used later. > > After using the command Export Text, the

Re: Bug or feature?

2018-04-07 Thread Bernd Fröhlich via 4D_Tech
David Adams: > If anyone can suggest why this might be happening, I'd love to hear about it. If I understood your description correctly, then the code only blows up if you process lots of data and not if you test every piece of data individually. If that is the case then I would guess there

Re: 4D data on the web - what do you use?

2018-03-15 Thread Bernd Fröhlich via 4D_Tech
John Baughman: > I use Xojo, http://xojo.com. I may be the only 4D developer on the planet > that uses Xojo. No, you are not alone :-) I have written an iOS app to access data that comes from our 4D server using the REST approach. So there is no zoo of ever changing languages/libraries, just

Re: European Data Protection Reglementation to take effect on May 25 - 4D compliance?

2018-02-11 Thread Bernd Fröhlich via 4D_Tech
Stephen Shaw: > You may find the UK’s ICOs website more user friendly. > > https://ico.org.uk Yup. It´s short and gets right to the point: "We're sorry, but our website is unavailable at the moment. Please try again later. We apologise for any inconvenience caused."

Re: 4D Parameter

2018-02-07 Thread Bernd Fröhlich via 4D_Tech
Tim Nevels: > So I am assuming you are talking about “Stored Procedures” running on 4D > Server. Yes, you can slow them down and reduce the load on 4D Server. We call > it “throttling”. (Remove foot from the throttle pedal.) > > To do this, add DELAY PROCESS(Current process;$delayTicks_l) in

Re: Problems installing built application

2018-02-06 Thread Bernd Fröhlich via 4D_Tech
macjimbo: > Is there no way to get a built application to remember the location of the > data file between application upgrades? Have a look at 4D-link files. Basically you store information about the datafile and program in the link-file and the user just doubleklicks the link file. I don´t

Re: Problem with PDF Creation into Temporary Folder

2018-02-03 Thread Bernd Fröhlich via 4D_Tech
Stephen Shaw: > Error -43 is returned on the following line > $error:=SMTP_Attachment ($smtp_id; $document; 2; 0; ””; ”application/PDF”) Error -43 is the OS error "file not found". Maybe try a shorter path to a known good location for a test. Greetings from Germany, Bernd Fröhlich

Re: "Goodbye 4D Write" email

2018-02-01 Thread Bernd Fröhlich via 4D_Tech
Don Lapin: > You did not answer the question regarding whether 4D will continue to work > with 4D Write (the regular version, not the Pro). That's my primary concern > at the moment. From my understanding the "old" 4D Write will continue working in 32Bit versions of 4D. There will be no 64Bit

Re: Intermittent 4D Server / System crashes

2018-01-29 Thread Bernd Fröhlich via 4D_Tech
Mitchell Shiller: > 4D Server 16.2 > Mac OS 10.13.2 running on a MacMini (Late 2014) 8GB RAM > External RAID 0+1 Samsung SSD. Using SoftRaid XT > > Only applications running are: > 4D Server (no stored procedures), 15 users > Carbon Copy Cloner 5.05 (latest) scheduled to run every hour except

Re: "Failed to synchronize Resources folder." Error

2018-01-16 Thread Bernd Fröhlich via 4D_Tech
Randy Jaynes: > Bizarre, but true: When the user gets this dialog, she can continue on in. > Then immediately log out, then log back in with no issues. To me that sounds as if some other software (malwareprotection or other diskcleaning stuff) has that file locked at the first attempt, so that

Re: DELAY PROCESS bug

2018-01-08 Thread Bernd Fröhlich via 4D_Tech
John DeSoi: > Are you having this issue with the server, client, or both? I'm just seeing > it with 4D Client. My new theory is that during a long delay 4D Server > disconnects the client because there is no activity and 4D Server timeout > (selector 13 for SET DATABASE PARAMETER) is reached.

RE: DELAY PROCESS bug

2018-01-07 Thread Bernd Fröhlich via 4D_Tech
Drew Waddell: > That's not really a solution though, we'd have to write like a process > watching that would have to make a call that process needed to be revived. Just make sure the watching process does not depend on using Delay Process for itself. Since Delay Process sometimes just behaves

Re: 4D Backup causes 4D Remote to hang (15.4)

2017-11-14 Thread Bernd Fröhlich via 4D_Tech
Jim Crate: > Note to self: perhaps an automated weekly restart of 4D Server is the trick > to avoiding the occasional v16x DELAY PROCESS hang. When a hammer works, > might as well use it. Sorry, but no. Our 4D Server shuts down and restarts every night with a script, but one process still

Re: 4D v16.2 false record locks

2017-10-04 Thread Bernd Fröhlich via 4D_Tech
David Adams: > ..but seriously, what I'd like to see 4D do is an *entire release* that > consists of *nothing* but fixing bugs - as many as they can find, as many > as we can find and longstanding annoyances. No fancy new features. Just > cleaning up crashes, usability bugs (I see lingering 2004

Re: Server Process "Frozen"-ish

2017-09-14 Thread Bernd Fröhlich via 4D_Tech
Cannon Smith: > Thanks for the idea. I did try that before to see if I could jumpstart the > process, but unfortunately it doesn’t work. 4D thinks the process is already > there. And it it there. It just doesn’t seem to be executing. Yep, same here. I do have a method that would start the

Object fields (Was: Re: QUERY BY ATTRIBUTE is slow af)

2017-09-13 Thread Bernd Fröhlich via 4D_Tech
David Adams: > I've been asking about real-world use of object fields for quite some time Here´s my real-world use: I wrote an iPhone app that collects data (scans barcodes). That data is in JSON format and transferred via HTTP to a 4D Server. The server stores that data in an object field

Re: Server Process "Frozen"-ish

2017-09-11 Thread Bernd Fröhlich via 4D_Tech
Cannon Smith: > I’ve seen something odd since upgrading our customers to v16.1 a few months > ago. This is on 64-bit server, both platforms. There are a few background > processes that continually run on the servers, waking up every few seconds to > see if there is work to be done. This has

Re: v13 on OS X 12.6

2017-08-30 Thread Bernd Fröhlich via 4D_Tech
Chip Scheide: > I am getting error -10002 (connection disrupted) during the initial > connection. -10002 is usually a network problem. Is there some switch/firewall active that may block the connestion? Could you test with an older system running on the same machine (start from a cloned

Re: Rotate Picture in 4D

2017-06-27 Thread Bernd Fröhlich via 4D_Tech
Peter Mew: > I am trying to use Miyako's rotate picture component in v13. > I dont know if its not compatible but It wont run. Hi Peter, I had some problems also (not sure what exactly), so I rolled my own: // Methode: PIC_Rotate // Angelegt: BF 04.04.12 // Objekt: Bildbearbeitung //

Re: Storing an using Print sttings

2017-06-23 Thread Bernd Fröhlich via 4D_Tech
Keisuke Miyako: > the commands are deprecated in v16, > in favour of a native command. > > http://doc.4d.com/4Dv16/4D/16/BLOB-to-print-settings.301-2999340.en.html "The parameters set are used more particularly by the PRINT SELECTION, PRINT LABEL, PRINT RECORD, Print form and QR REPORT

Re: Enterable Variables in Output Form headers

2017-06-20 Thread Bernd Fröhlich via 4D_Tech
Robert Livingston: > But I am curious and ask the assembled crowd. Has everyone basically given up > on using DISPLAY/MODIFY SELECTION? The cool kids have moved on? Not sure if I´m a cool kid but I don´t use DISPLAY/MODIFY SELECTION anymore. Selection based Listboxes are really comfortable.

TEXT TO ARRAY won't break solid text

2017-06-01 Thread Bernd Fröhlich via 4D_Tech
Don Lapin: > Does anyone know how to measure the size of an unbroken text string, in a > particular font, size, etc, such as -- > > But because TEXT TO ARRAY doesn't work on the codes, I get -- I think this was one of the reasons I still use hmFree

Re: Write Pro beginner question

2017-05-30 Thread Bernd Fröhlich via 4D_Tech
Pat Bensky: > Please don't cry, Bernd :) > I think you have slightly misunderstood ST SET PLAIN TEXT. In this context > PLAIN TEXT means *unformatted*, rather than *unstyled*. In other words, ST > SET PLAIN TEXT inserts text into whatever styling is already in place. So > to remove the bold, you

Write Pro beginner question

2017-05-29 Thread Bernd Fröhlich via 4D_Tech
(First mail was truncated, so here I go again) I am doing lots of work with 4D Write and really like it. Now I am trying to take my first babysteps with 4D WritePro (V16.1). Unfortunately I am falling down at each little step so far and need a grown-up to help me before I start crying really

Write Pro beginner questions

2017-05-29 Thread Bernd Fröhlich via 4D_Tech
I am doing lots of work with 4D Write and really like it. Now I am trying to take my first babysteps with 4D WritePro (V16.1). Unfortunately I am falling down at each little step so far and need a grown-up to help me before I start crying really loud. What I did a lot in 4D Write is to create

Re: Favorite tricks and keystrokes: Please take one and leave on

2017-05-29 Thread Bernd Fröhlich via 4D_Tech
Douglas von Roeder: > I *do* like how it works - if something's selected, Ctrl-k will go to its > definition Yup, works. I like that and use it quite often. > but if nothing's selected, Ctrl-k opens the Explorer. Nope, not in V16.1 on macOS 10.12.5 My favorite trick: moving a selection of

Re: v13 - Warning Compiler misses syntax error

2017-05-25 Thread Bernd Fröhlich via 4D_Tech
Chip Scheide: > I accidentally typed the following line of code: > $0:=(Type($To_Validate->->)=Is Pointer) > > Notice anything wrong? > At least the compiler did not... > > Error is : > ->-> That is not an error. $To_Validate could be a pointer to a pointer, so from the compiler´s viewpoint

Re: repost : Printer selection issue

2017-03-24 Thread Bernd Fröhlich via 4D_Tech
Chip Scheide: > I have found that the margins(?) or Page Size(?), are different than > the Xerox printers that are used here, and probably different than any > actual printer. This affects printing, usually by causing an extra > blank page to be printed. In some instances the blank page is

Re: osx open url vs osascript FYI

2017-03-11 Thread Bernd Fröhlich via 4D_Tech
David Ringsmuth: > I tried many different things to launch a .htm on OSX using OPEN URL, and it > would not automatically open the document. Have you tried using ".html" instead of ".htm"? What happens if you doubleclick your .htm-document in the finder? Greetings from Germany, Bernd Fröhlich

Re: 4D v15.4: Sequence number issue / Duplicate key error

2017-03-10 Thread Bernd Fröhlich via 4D_Tech
Kirk Brooks: > If a subsequent call to sequence number is made it causes the sequence to > increment. So the final call my test method makes causes the sequence to > increment by 3 even through at the time that call is made the other > processes have quit and 'released' their numbers. Yes, if