Re: V19 Issues

I may not be of any use to anyone (long time retired), but I’m still here… Cheers. Keith :-) > it seems very few developers are using this list. > only 2 or 3 users have posted in the last couple of years. > the majority of the community discussion has moved to the forums.

Re: Recurring “Wrong Header” issue, same table, v17.5, Windows

Alan, I think I came across a problem like you are describing many years ago. I think 4D Tech support responded with a possible solution that was successful. I have a feeling that it had something to do with a unique field setting that was set wrong, but I can’t recall exactly what happened (too

Re: How to convert date to integer or vice versa

Stephane, I no longer have access to Design mode as I am retired and have let my 4D Partner license lapse so I’m unable to check out the latest date/number commands. That said, I used to store dates as numbers in a way that sorted the numbers chronologically. I did that by extracting the day,

Re: How to convert date to integer or vice versa

Hi Stephane, Thinking in ”old-school” 4D code, using a trigger can be a good way to enforce a field population rule but an alternative is to create the date field’s object method and populate the integer from there. The code may well be easier to find and maintain from there. If you need help

Re: Odd Runtime Error in Design

Miyako, hi there. This is just an “I’m curious” reply. I don’t know why, but my Google search returns no hits when I enter "Error when executing the method "RUNTIME_EXPLORER_HDL (runtime)" at line number 239”. Searching for “ACI0101576” (which I couldn’t find from the above search) does return

Re: Where is the trace/debug command?

Thanks everyone for your replies. Yes, there are ways to force a trace using code, but I’m referring to those occasions where you simply want to check a piece of code without having to make code additions and then deletions. Very surprised it hasn’t been addressed by 4D yet as it’s a *very*

Re: Where is the trace/debug command?

:08 am, Randy Kaempen wrote: > > Keith, > >> On Oct 6, 2021, at 3:03 PM, Keith Goebel via 4D_Tech <4d_tech@lists.4d.com >> <mailto:4d_tech@lists.4d.com>> wrote: >> >> Also, v17 had a severely bad habit of ignoring breakpoints after a short >

Re: Where is the trace/debug command?

I have encountered methods in the past that kept breaking into Trace mode without displaying a breakpoint. For me, the breakpoint handling in 4D reached its lowest point with v17. I saw methods that would continue to drop into Trace mode with no breakpoints showing. The only solution was -

Re: Compiled Structure does not Match Data

> … but let's not kid ourselves > - we all know that what happens inside 4D is actually magic. :-) LOL ** 4D Internet Users Group (4D iNUG) New Forum: https://discuss.4D.com Archive: http://lists.4d.com/archives.html Options:

Re: 4D Default Folder Structure

Jörg, I am disappointed to see disharmony on the 4D list. As far as I can tell, Jody was trying to help by advising the new 4D manual has a good description of the workings of the default folder. There have been times I read the docs thoroughly without finding out what I needed, but overlooked

Re: 4D Chart replacement

Hi Jörg. I am out of it now but we replaced it with HighCharts. It meant minimal learning of JavaScript, but pretty easy using their templates and just tweaking them as required. Allowed us to do graphs with up to 6 plotting scales (3 at each end) with full control of titles, legends, colours

Re: Record locking woes

Sorry - nothing to add, but still here… :-) Cheers, Keith There are 3 kinds of mathematician. Those who can count, and those who can't. ** 4D Internet Users Group (4D iNUG) New Forum: https://discuss.4D.com Archive:

Re: Bugs with Quick Report Editor v18.4

Peter, it sounds like you’ve done an excellent sleuthing job and I’m sure 4D will want to hear about it and examine your structure to find the cause. Cheers, Keith > I've completed a bit more research into why and where the 'Error when > executing the method "db_Get_field_list"' was occurring in

Re: Drag and drop replacement command(s)? Solved

Have just realised I pressed send before thanking all those who supplied me with examples of how to go about the replacement. So, to you all, I thank you. Cheers, Keith ** 4D Internet Users Group (4D iNUG) New Forum:

Re: Drag and drop replacement command(s)? Solved

Hi all. If you have no need (or interest) in my replacement for 4D’s Drag and Drop command, stop reading now :-). I have (like many others no doubt) developed alternative method calls to replace the obsolete 4D command _O_DRAG AND DROP PROPERTIES, and include the calls/code below in case

Re: Drag and drop replacement command(s)?

2020, at 12:06 AM, Keith Goebel via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I’m upgrading a structure to v18 (Win) and am trying to replace the obsolete > command > _O_DRAG AND DROP PROPERTIES($Source_Object_p;$Source_Element_l;$Process_ID_l) > with the v18 equivalent

Drag and drop replacement command(s)?

Hi all. I’m upgrading a structure to v18 (Win) and am trying to replace the obsolete command _O_DRAG AND DROP PROPERTIES($Source_Object_p;$Source_Element_l;$Process_ID_l) with the v18 equivalent for the purposes of handling drag and drop between two array based list boxes. An element in either

Re: Native 4D code to convert numbers into text?

> I'm looking for code that converts something like this: > 24120.10 into something like this: > twenty-four thousand, one hundred and twenty point one David, I have 4D code that converts your value into "Twenty Four Thousand One Hundred Twenty Dollars and Ten Cents”. It uses the example code

Not the only one

It’s good to see I’m not the only one still watching this list. :-) Cheers, Keith ** 4D Internet Users Group (4D iNUG) New Forum: https://discuss.4D.com Archive: http://lists.4d.com/archives.html Options:

Re: Discuss.4D.com - old Safari doesn't work (is known?)

Walt, thanks for your reply. I’ll look into that. I guess I’m just getting lazy and want the “NUG” software to do it all for me :-) Cheers, Keith > … I have always subscribed with the individual emails rather than the digest. > Then just create a mail rule inside Apple Mail to move them into a

Discuss.4D.com - old Safari doesn't work (is known?)

I have gotten as far as receiving a summary of new posts on the new forum (that’s good because I get/got the iNUG digest). But, when I click on the new summary topic link, Safari 10.1.2 (yeah, I know it’s old) rejects it with “...can’t establish secure connection…”. Firefox v76.0.1 does work if

Re: Remote working with 4D networks - what are people using ?

When I need to work from home, I connect my iMac to a PC at work using Splashtop. It's just like sitting at the desk at work and it works great! HTH, Keith ** 4D Internet Users Group (4D iNUG) Archive:

Re: Multi-Select Dropdown Menu

Hi all. Many good ideas have been offered for this and I thought I’d share a very simple solution we use for actions on listbox columns. Sort - first click on the column title = sort the column contents in default direction - click again = sort in reverse Keep track of the last column clicked

Re: Email Attachments Missing after New process ?

Allan, I have found the best way to handle emails is by storing all parts in a record, and then building the email from the record's parts during the “send”. I store the attached docs in an object field. This allows a single email dispatcher method that simply processes the “outgoing - waiting

RE: Re: 4D v17r4 Windows Print To PDF ignoring PAGE SETUP

My only suggestion here is to ensure any Print Options calls are made after Set Printer, as the latter can mess up options set before that command. HTH, Keith > On 11/10/2019, at 2:20 am, Piotr Chabot Stadhouders wrote: > ... > Did you find a solution for this? > I am working on a Windows 10

Re: 4D v17.1HF1 to v17.2HF1

Tim, thanks for your reply. Good to hear. Cheers, Keith > On 15/08/2019, at 7:00 am,Tim Nevels wrote: > I did a v17.0HF3 to v17.2HF1 upgrade a few weeks ago and have not had any > problems reported so far. > … >> Hi all. >> We are using Win 4D v17.1HF1 and would like to upgrade to v17.2HF1 but

Re: Filter MSC Log File?

> On 19/06/2019, at 7:00 am, Tom Benedict wrote: > Is there a way to filter the log file that is generated by MSC? I want to > only see the warnings or errors and filter out the rest. The log is hundreds > of pages and scrolling through it looking for warnings is tedious. Tom, I have

Error code 203 (xbox) from 4D

Hi all. I have encountered an error code I have never seen before and hope someone can shed light on it. We are using 4D v17.1 for built client and server applications (server is 64bit and Client is 32bit), both running on virtual machines using Win Server 2016 DataCenter. I have a (very)

Re: Problems with Microsoft Print to PDF

Charles and Julio, thanks for your replies. On 4/04/2019, Charles Miller wrote: > I think the problems with odd creator o. Windows had to do with 4D as when > I went to 17.1 it started working again. > When using earlier 4D releases no pdf was created own windows at all Charles, are you saying

Re: Problems with Microsoft Print to PDF

cument contains an error and cannot be displayed > correctly... > >> Op 1 apr. 2019, om 05:10 heeft Keith Goebel via 4D_Tech >> <4d_tech@lists.4d.com <mailto:4d_tech@lists.4d.com>> het volgende geschreven: >> >> Has anyone else encountered this problem and,

Re: v17 web area

Allan, Hope you are all well. Having Ant available for the odd bit of sleuthing sounds like a very handy thing to have… :-) I’m using v17.1 HF1 for the deployed ePro. Server is 64bit, clients are 32bit (to stop graph bug). V17 64bit is doing strange things to my highCharts graphs (they are not

Re: LEP that will quit Chrome?

Chip and Lutz, Delayed thanks for your ideas. I have had no luck so far, but have been pulled off that task for something else so have been unable to keep trying. Thanks anyway. Cheers, Keith ** 4D Internet Users Group (4D iNUG)

RE: exe file that can launch 4D client as well as Chrome?

Chip, Julio and Tai, Many thanks for your replies and ideas. Much food for thought. Cheers, Keith ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options:

LEP that will quit Chrome?

Hi all. I am trying to formulate a LEP command from 4D v17.0HF3 Win on Win7 (although it will be deployed on Win Server 2016). The idea is to quit Chrome from within 4D. After lots of Google searches I have tried (in my development version) $Command_t:="TASKKILL /IM /t chrome.exe" SET

exe file that can launch 4D client as well as Chrome?

Hi all. We have a scenario where we want to use an exe file to start both 4D Client (v17.0 HF3 Win) and Chrome browser. The browser has to login to a given url with a user name and password. Also, the 4D Client has to be in front when they have finished startup. Is all that possible? If so, can

Re: v17 conundrum in design

Chuck, I have encountered this a few times since at least v15 (now using v17.0 HF3). The only way I found to clear it is to - create a new method - copy the code across - delete old method I found it impossible to “make it happen” for a reproducible bug for 4D, though I did report it anyway (a

Re: Compact data file

Fernando, Check out the data file that has been moved to the “Old” folder. Using v17HF3 I have found that, after compacting on Win7, the data files are in the opposite place they are supposed to be (i.e. the compacted one is in the “old” folder and the old one is now the current one). Not saying

Re: V15.2 to v17.0HF3 conversion problem

en use OBJECT Get action to > find the problem check boxes. > Or open a copy of the structure in 17R and export all the forms to search > them with your favorite text editor. > >> On Nov 22, 2018, at 9:36 PM, Keith Goebel via 4D_Tech <4d_tech@lists.4d.com> >> wr

V15.2 to v17.0HF3 conversion problem

Hi all. Just offering a headzup on a problem I encountered after upgrading a v15.2 structure to v17.0HF3 on Win7. A few of the checkboxes on my forms decided to change their action to Accept. It came to light after user reports that clicking on a certain checkbox dismissed the dialog. Wish I

Re: Built Server—Best Practices...

Robert, don’t know it this is relevant to your situation but many years ago, to get around the problem of losing the backup settings when installing a new built application version, I setup a system where, on quit, I stored the backups xml file in the data folder (or a record in the data - too

Re: Volume Shadow Copy

Vincent and Tom, thanks for your answers - just what I wanted to know. > You can read this blog post : > https://blog.4d.com/enterprise-virtual-machine-snapshot-support/ > Hope it helps > Prior to 4D v17, Volume Shadow Copy was something to definitely avoid on a 4D > server. It could

Volume Shadow Copy

Hi all. We are testing 4D v17 on a Winserver 2016 virtual machine. The 64bit compiled/built server application shows "Volume Shadow Copy up and running” on the first page of the server admin window. Googling "Volume Shadow Copy” shows it to be a system that allows backups while an application is

Re: PDF generation on Windows - Latest Thinking

We are using both pdfCreator and Win10’s “Print to PDF” printers - pdfCreator for pre-Win10 machines. It switches according to the OS version. Discovered a couple of days ago that the Win10 printer creates huge pdf files in comparison to pdfCreator. One report containing graph images is around

pdfCreator problem

Hi all. We have suddenly struck a problem with pdfCreator v1.7.2 not working when using a built 4D Client via Remote Desktop Connection access. It used to work, but started giving problems about a month ago (that's when we first detected it). pdfCreator works just fine when the 4D Client is

Zoom box removal + window title icon placement

Hi all. Playing with 4D v17.0 HF1 Win... 1) Zoom box removal Is there a 4D command that will remove the zoom box stuff from a window already open? 2) Window title bar icon Is there a 4D command that will insert an icon into the left end of a window title bar? (window already open) I know

Re: Export text columns containing carriage returns to Excel?

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?

Brad, There have been a couple of “export data” related threads lately that seem to be having problems with embedded CRs. Where I have CRs in the data, I save the exported data as csv and that has always solved that problem for me. Perhaps there is some reason that is not suitable for you...

Administrator

To the list Administrator: Would it be possible to eliminate some of the headers shown for each email in the digest? At the moment we see, for each email Message: 1 Date: Wed, 18 Apr 2018 14:32:01 -0500 From: Tim Nevels To: 4d_tech@lists.4d.com Subject: Re: URGENT: 4D in

Re: Delay process bug

> On 1/04/2018, at 7:00 am, Jeffrey Kain wrote: > So, the Delay Process bug hit two servers within an hour of each other this > morning, after months of not having the issue. It was weird that both of > them hit the bug this morning within a short period of time of each other. > This was on

Collections

Hi all. 4D seem to be really fired up about the new Collection object available in upcoming versions. I’ve read the examples given in the blurb, but I have yet to read anything that would give me an idea as to why I would want to use a Collection instead of an Object. It seems as though

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

Thank you to all who responded (there have been many of you). Lots of food for thought, and we’ll chew them over carefully… Cheers, Keith ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive:

Re: Import from Excel

Pat, > Yes ... We wrote a procedure to import csv files. My point was that you can't > just use the basic 4D Import option to import such files. We don’t use 4D’s import, so I can’t comment on whether it works correctly or not. Chip, > >> the problem I have found with csv is that different

Re: Import from Excel

Pat, As I understand it, in a cvs file, all string values should be enclosed inside “. This means that a CR is simply part of the cell’s string. If you open the exported file with a text editor, you should see the CR enclosed inside “. If it isn’t, the Excel export is not working correctly. If

RE: Import from Excel

Ferdinando , If you convert the Excel file to csv, you shouldn't have any problems with cells containing carriage returns/line feeds when you import into 4D. I assume 4D’s built-in import can handle csv files - I haven’t checked - we use special import and export code to handle csv so we don’t

Re: [SAD NEWS] legendary developer and 4D base-rock Ortwin Zillgen

Ortwin was a frequent contributor here. I always took notice of his advice, and will miss it. His passing adds pressure to the realisation that we have to do the things we want, asap, because you never know… ** 4D Internet Users

Stored procedures not waking up?

Hi all. For some time, on this list, there has been talk about a v16 problem where, periodically, stored procedures that have been paused will not wake up. The reports I’ve seen have indicated there is no way to duplicate the problem on demand. We are currently in 4D v15.2 and want to move to

Re: Gridline for header in Listbox

Alan, I noticed this too - it does look odd - and I couldn’t find a command to do it, so I found a work-around… Because my listboxes have the zebra stripes (every 2nd row has a light grey background), I simply reversed the order of the row colour in the design window - the grey ones now come

Re: [Warning] Settings properties values on object field by object notation

I think the “standard behaviour” answer is a mistake on the part of 4D, and I hope they will reconsider their stand on this. As others have said, “Target:=value“ should always mean the target gets changed to the value. Anything else is “non-standard behaviour”. It may be tricky to make it

v16 - our print preview issue - solved

Hi all. We had a problem with all versions of 4D from v15.4 upwards, on Win7: - print preview using XPS Viewer freezes 4D. It was determined that the preview file being created in the Temp folder had an extension of 4DPreview instead of the required XPS extension. 4D Tech support were involved

Away

In case anyone is trying to contact me, I will be away from my desk for 4 weeks starting Sunday. It’s going to be a pity to miss out on the large threads going at the moment - lots of great observations and comments. Cheers, Keith There are 3 kinds of mathematician. Those who can count, and

Re: Wiki software: Confluence

We have been using Confluence and JIRA for several years now, and love them. With one exception: We setup our entire Online Help system in Confluence; a button click in 4D takes you to the relevant Confluence page. Worked really well until recently when they decided to prevent url link logins.

Re: Set Print Option clarity needed

rogress window on Mac) > then call SET PRINT OPTION in a different process, > you get the error 1009 telling you can't do that once a printing job has > started. > > you might want to use a semaphore to make sure only one process prints at a > time. > >> 2017/06/30 8:0

Re: Automatic type-ahead on single-column listbox?

Probably not what you are looking for and perhaps this approach has already been discussed… When I want to let the user reduce the selection shown in a listbox, I add a search field above it and they just enter what they are looking for in that. You can create a “type-ahead” response to an entry

Set Print Option clarity needed

Hi all. In the v16 Conversion doc, I noticed the following instruction. I see it was the same from at least 4D v13, and it has caused me no problems so far, but I'd like to make sure there are no problems in the future... The SET PRINT OPTION command is used to modify, by programming, the value

RE: v16 sort editor

Timothy, thanks for your reply. I presume it wouldn’t take much to add a "sort fields” command to the existing sort and expression editor, but what do I know… I will try your suggestion. Thanks, Keith > I think the only reason the Query Editor has the fields in alphabetical order > is because

Re: Web Areas On Form Page >1

Actually, the variable names are all the same - it is the object names that are different. > Using 4D v15.2 Win we have forms with 7 or 8 web areas on different pages - > all work fine. > I can’t get at the code at the moment but I think I just made sure each web > area had a different

Re: Web Areas On Form Page >1

Using 4D v15.2 Win we have forms with 7 or 8 web areas on different pages - all work fine. I can’t get at the code at the moment but I think I just made sure each web area had a different variable name. If that’s not it, I’ll send another message.

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

I don’t have any that haven’t already been mentioned, but I *really* miss: from Arnaud: - cmd+click on fold/unfold arrows (collapse/expand current level), came with v11 and gone with v12. Having this back would save me some time every day now spent manually closing/opening arrows so the

Unable to connect to 4D Server

Hi all. We have a built 4D v15.2 Win 64bit server and client application. The client runs on a separate machine from the 4D server machine and they are on separate AWS servers in the cloud. The existing version works well (I think the OS is Windows Server 2008 R2). Our IT guy is setting up new

Re: Lost window cursor

That’s it! Many thanks. I know I looked there but didn’t see it (on Win7 anyway). Note to self - don’t look for icons when you’re tired! :-) > On 11/05/2017, at 12:01 pm, Keisuke Miyako wrote: > /4D.app/Contents/Resources/Cursors

Re: How to clear a webpage from a web area?

Cannon, Thanks - I will try that when I get back on-site. Cheers, Keith > On 11/05/2017, at 12:01 pm, Cannon Smith wrote: > No sure about using the variable, but I do this when I need to get a blank > web area: > > WA OPEN URL(*;"vtWebArea";"about:blank")

Lost window cursor

Greetings. I have a need to document the "lost window" cursor you get when the active window is hidden behind another window. I know we should always prevent this happening but there is one situation I cannot avoid and need to document it and need a picture of that cursor. I am not in the

How to clear a webpage from a web area?

Hi all. Using 4D v15.2 Win7: In a dialog I have a web area that is displaying a webpage and I want to simply clear it to show nothing. I have tried - clearing the URL variable from a button - adding "WA REFRESH CURRENT URL(URL_t)" after clearing URL_t but after the button script finishes, 4D

"Placeholder" in property list

> On 23/04/2017, at 5:03 am, Jeffrey Kain wrote: > Has anyone noticed that in 15.4 (HF2... maybe others) there's a new property > for fields and variables called 'Placeholder' that automatically fills an > empty field with descriptive text in a light gray font color,… They’re a great addition

Re: How to collapse/expand all panes in Property List (v16)

If this disparity between 32 bit 4D and 64 bit 4D exists for other than the developer interface stuff, !hat’s quite scary thought! With testing done in standalone and deployed on server = server could have bugs not there in test version. That also means 2 complete sets of testing is required -

Re: 4D freezing on print preview

ms to be the only app that > causes Preview to unexpectedly quit when getting a print preview. It does > not affect 4D however. > >> On Mar 23, 2017, at 4:07 PM, Keith Goebel via 4D_Tech <4d_tech@lists.4d.com >> <mailto:4d_tech@lists.4d.com>> wrote: >> >>

4D freezing on print preview

Hi all. We are using 4D v15.2 on Win7, Win10, Win Server 2012 (or similar). All good. We have just tested 4D v15.4 and v15.4 HF1 and found both to freeze whenever we print preview a report. All seems to work fine until about the point where 4D would hand off control to XPS Viewer, and then 4D

Re: tab seperated text - what to use for Cr

> I tried that - > it too creates a new row in excel when opened/imported. csv format will do the job, if that format is permitted for your purpose. You’ll need to enclose text fields with “ to keep contained CRs safe. ** 4D

Re: Copy or Drag from a listbox?

I’d like to offer a belated thank you to everyone who replied to my post and offered suggestions how to do it. Much food for thought. Cheers, Keith ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html

Re: Please vote for this feature request: Raise the 31 character limit

On 7/03/2017, at 8:55 am, Timothy Penner wrote: > > Don't click on the green + under the "Average" heading. > The green + expands the breakdown of the Average. > > Instead, you should see 4 stars to the RIGHT of the green plus under the > "Rate This" heading. OK that works -

Re: Copy or Drag from a listbox?

Thanks to John and Kirk for your ideas. Cheers, Keith ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech

Re: Saved query files (.4df) and changes from v12 to v15 - automated conversion?

… > For a number of reasons we decided to shield our users from 4D’s new query > dialog, which we find not intuitive… That surprises me. We found the v15 4D search interface really easy to understand. I guess we must be used to very different interfaces. Cheers, Keith

4D v15.4 print preview freeze

Hi all. Using Win7, I have just started testing with compiled and interpreted v15.4 and found that print preview is broken. The printing happens but before the preview screen opens 4D freezes = force quit. v15.2 works correctly for same structure. No test on v15.3. I have tested this using the

Copy or Drag from a listbox?

Hi all. A client has asked: I have the list (selection based listbox) showing the records I'm interested in, and I have set the columns to show only those I want and put them in the order I want them (all available from the list interface). Why can't I select the rows and copy/paste or drag

RE: Better variable names

> This tech tip should help explain the difference between +1 and voting: > > Tech Tip: How to vote for a feature request > http://kb.4d.com/assetid=76726 If doesn’t explain the list of users I had to select one from in order to precede with the vote (it appeared