Re: Please give us a split-pane in the Method Editor

Kirk, Nice examples! Vote early, vote often! Talk here is just talk as 4D *officially* ignores this list. Over on the forums, 4D only unofficially ignores us ;-) ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqn

Re: Web Areas On Form Page >1

Cannon, I know my solution works on both platforms but since I develop on a Mac I don't know if it even showed up on the Windows side. I seem to recall coming to the same conclusion Ingo mentioned - that the web area isn't instantiated until it's actually displayed. This is all in v15 , BTW. And

Re: Please give us a split-pane in the Method Editor

You know if every method really on did one thing, and only had a few params that never changed and ... well then the split screen really wouldn't be necessary. But here are the places I really miss it. 1) when I'm passing parameters to a method in a c-obj. After I'm more than about 15 lines down I

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

type the command + ( and the command and parameters display at the bottom of the window > > - Need a quick reminder of command parameters? Just hover the mouse > over the 4D command name and wait for the tool tip to appear. Hell is other people Jean-Paul Sartre *

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

On Mon, May 29, 2017 at 3:16 PM, David Adams via 4D_Tech < 4d_tech@lists.4d.com> wrote: > On Mon, May 29, 2017 at 11:11 PM, Tim Nevels via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > > I miss the split pane feature too. So useful in long methods. Wish they > > would bring it back. > > > I also miss

Re: USE DATABASE from a component. ?

that you can avoid by passing AUTO_CLOSE. the advantage of not using AUTO_CLOSE is that the structure definition of the external database is cached, so subsequent access becomes faster. it's useful, for example, if you want to switch contexts several times. 2017/05/30 9:12、David Adams via 4D_Tec

Re: USE DATABASE from a component. ?

that's the idea. Component.4DC would have an empty placeholder Component.4DD, even if Component and Product were in fact identical. whether to put the data inside Resources is a decision based on whether you want the data to be sent to the client. although you can place multiple 4DB/4DC/4DD insid

Re: USE DATABASE from a component. ?

Keisuke, I'm not worthy! Once again, you got to the heart of the problem with a solid technical answer. Better than that you've corrected my mental map of the underlying feature. That's even more helpful. Since I didn't stumble across this stated succinctly in the docs, here's a summary of my und

Re: Get table fragmentation

Cannon writes and David responds: >I'm working on some server health reporting. I can get the percentage of table >fragmentation using "Get table fragmentation" for each table. >I'm not quite sure what to do with it, though. I'd like to get a report when >the overall fragmentation reaches some t

Re: USE DATABASE from a component. ?

On Tue, May 30, 2017 at 8:57 AM, Keisuke Miyako via 4D_Tech < 4d_tech@lists.4d.com> wrote: > opening a 4DC/4DD pair as an external database does not make sense. > I think you mave have pushed me over the line towards understand here. I was using a 4DD associated with the source of the component i

Re: Please give us a split-pane in the Method Editor

On Tue, May 30, 2017 at 8:45 AM, Keisuke Miyako via 4D_Tech < 4d_tech@lists.4d.com> wrote: Good point about tabs in V16 R3, that looks nice. But it's not the same thing. I know that people vary in their cognitive strengths, weaknesses, and styles. Personally, I'm terrible at copying things by mem

Re: Help with Regex

JR's solution works Some would argue that more specifically alluding to the six digits is more robust in case some slightly mis-titled file exists. Therefore ^SP_\d\d\d\d\d\d ^SP_INS_\d\d\d\d\d\d iPhone RRL > On May 29, 2017, at 11:45 AM, Jeremy Roussak via 4D_Tech > <4d_tech@lists.4d.com

Re: USE DATABASE from a component. ?

opening a 4DC/4DD pair as an external database does not make sense. I mean, it kind of makes sense, but I can't see why it has to be done using a 4DC. there are not methods, including triggers, to call in that context, so what is the virtue of the structure file being compiled? you can create a 4

Re: Please give us a split-pane in the Method Editor

I felt splitting panes was more alike a carry over from classic Mac OS, that the "removal" was more a case of "not (easily) portable" to newer SDKs. (also being less critical as screen sizes got bigger) true, many code editors have a similar feature, but more relevant in a "diff" context. meanwhi

Re: Web Areas On Form Page >1

This is needed and works on both Mac and Windows. __ ViELMAC Ingo Wolf Rheinhessenring 53A D 55597 Wöllstein Tel. +49 (0)6703 3070320 Fax +49 (0)6703 3070321 e-Mail i...@vielmac.de > Hi Ingo, > > This is basically the workaround I’m using right now. Do you know if this is > necessary on both M

Re: USE DATABASE from a component. ?

Hey, thanks for the answers and background! I'd never heard that thing about having to create the data file with SQL in order to use it as an external data file. I guess that's not true now...I guess? In it's simplest form, my question is: How do I open an external file from a compiled component?

Re: Get table fragmentation

> I’m glad I’m not the only one who isn’t sure how to calculate a meaningful fragmentation threshold value. :-) Yeah, you're not alone. I'll add that the automated health check business is a *great* feature to have. So reassuring, so satisfying. If you have your remote installs phone home, you can

Tips and Tricks Google Doc

Sannyasin, That’s very helpful - thanks. Cheers, Keith > > ...public Google Doc (editable by anyone with the link), summarizing all of > the tips posted so I could reference and implement them. Feel free to add or > edit any of them. > > https://docs.google.com/document/d/1HpEqRUotpQtO3-3C_Tvp

Please give us a split-pane in the Method Editor

Please give us a split-pane in the Method Editor http://forums.4d.fr/Post//19482991/1/ Please vote for this feature request. And if anyone wants to make a better argument, please do! It's early here and I'm not at my best yet... *

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: Get table fragmentation

Hi David, Thanks for chiming in on this. Your examples are exactly the kinds of things I’m checking for. I’m glad I’m not the only one who isn’t sure how to calculate a meaningful fragmentation threshold value. :-) -- Cannon.Smith Synergy Farm Solutions Inc. Hill Spring, AB Canada 403-626-3236

Re: Tips and Tricks Google Doc

On Tue, May 30, 2017 at 5:49 AM, Sannyasin Siddhanathaswami via 4D_Tech As part of that, I made a public Google Doc (editable by anyone with the > link), summarizing all of the tips posted so I could reference and > implement them. Feel free to add or edit any of them. > > https://docs.google.com/

Re: Get table fragmentation

Cannon, If anyone knows the answer to Cannon's question, I'd really like to know too! I went down this road a few years ago in V13 and couldn't figure out any way to get worthwhile information out of the fragmentation percentage. Apart from getting the numbers for snapshots and automated health ch

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 requir

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

On Mon, May 29, 2017 at 11:11 PM, Tim Nevels via 4D_Tech < 4d_tech@lists.4d.com> wrote: > > I miss the split pane feature too. So useful in long methods. Wish they > would bring it back. > I also miss it. So much. > I never use bookmarks. Does anyone? > What's a bookmark? I've not heard of th

Re: Help with Regex

On May 29, 2017, at 9:00 PM, Jeremy Roussak wrote: > “SP_[0-9]*” will match the first lot, and “SP_INS_[0-9]*” will match the rest. > > But it might be quicker to do the second batch first, matching the names > simply to “SP_INS_@“ and removing them from the list when they’re done, then > re-sc

Re: USE DATABASE from a component. ?

On May 29, 2017, at 9:00 PM, Keisuke Miyako wrote: > are you sure that the index is "embedded"? > > it's true that an external database created using SQL does not have an > accompanying 4DIndx, > but an MSC repair would add one. I have created an external data file with SQL and created an index

Re: Help with Regex

Tim - > On May 29, 2017, at 3:00 PM, 4d_tech-requ...@lists.4d.com wrote: > > Subject: Help with Regex If you have flexibility to process file names on Mac & outside of 4D… http://renamer.com David Eddy Babson Park, MA ***

Tips and Tricks Google Doc

Aloha, Thanks for all the great favorite tips posted in the past few days! I’ve learned quite a bit of helpful time savers. As part of that, I made a public Google Doc (editable by anyone with the link), summarizing all of the tips posted so I could reference and implement them. Feel free to a

Re: Web Areas On Form Page >1

Hi Ingo, This is basically the workaround I’m using right now. Do you know if this is necessary on both Mac and Windows? I haven’t tested Windows yet, but I’m curious. Thanks. -- Cannon.Smith Synergy Farm Solutions Inc. Hill Spring, AB Canada 403-626-3236 > On May 29, 2017, at 1:33 PM, Ing

Re: Web Areas On Form Page >1

I did run into this issue, too. At the end of the "On load" form event i set a flag and run Set timer. In the "on timer" event i check if the flag is still set and if i'm on the page with the web area. If yes, i do WA OPEN URL and clear the flag. My understanding of this is that the web area isn

Re: Web Areas On Form Page >1

Hi Kirk, It’s interesting that this works correctly for Steve. I’m wondering if it’s because I’ve only tried on the Mac so far and he’s using Windows. Do you know if you’ve tried it on both platforms? Thanks. -- Cannon.Smith Synergy Farm Solutions Inc. Hill Spring, AB Canada 403-626-3236 >

Re: Help with Regex

On Mon, May 29, 2017 at 8:29 PM, Tim Nevels via 4D_Tech < 4d_tech@lists.4d.com> wrote: > $regexPattern_t:="what do I put here" > with a timi little bit of playing, $regexPattern_t:="SP_(\\D{3}|)(?>_|)(\\d{2})(\\d{2})(\\d{2})" catches prefix (INS) without "_". -- Peter Bozek *

Re: Help with Regex

On Mon, May 29, 2017 at 8:29 PM, Tim Nevels via 4D_Tech < 4d_tech@lists.4d.com> wrote: > $regexPattern_t:="what do I put here" > Tim, Try SP_(\D{3}_|)(\d{2})(\d{2})(\d{2}) with properly escaped backslashes, it means regexPattern_t:="SP_(\\D{3}_|)(\\d{2})(\\d{2})(\\d{2})" This should catch for

Re: Help with Regex

Tim, “SP_[0-9]*” will match the first lot, and “SP_INS_[0-9]*” will match the rest. But it might be quicker to do the second batch first, matching the names simply to “SP_INS_@“ and removing them from the list when they’re done, then re-scanning for “SP_@“ to do the rest. Just a thought. Regula

Help with Regex

I needs some help with 2 regex expressions. I have to process some files in groups from a list of files. Here is an example of the file names: SP_050317 SP_050417 SP_050517 SP_INS_050317 SP_INS_050417 SP_INS_050517 I need to process the files that start with “SP_” and then the date as one gro

Re: Web Areas On Form Page >1

Cannon, I had the same problem. I just looked to see how I resolved it. Turns out I just brute-forced the matter and put that second 'page' onto a separate form and open it into the window. Looks & behaves just like 'page 2' but it's not. I'm actually using multiple pages more conservatively - rar

RE: Web Areas On Form Page >1

Cannon, I vaguely remember running into this, but don't remember the exact details, or what I may have done to deal with it. I can tell you that we use web areas on form pages 7+ and they work correctly. Let me see if I can jog my memory on anything special we may do. Steve *

Write Pro beginner question

(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 lo

Web Areas On Form Page >1

Is there something different about web areas when they are on a form page > 1? I’ve used lots of web areas before and never run into my current problem and the only thing I can think of that is different is that it is on form page 3. Here is roughly what happens: FORM GOTO PAGE(3) //Set up the

Get table fragmentation

I’m working on some server health reporting. I can get the percentage of table fragmentation using "Get table fragmentation” for each table. I’m not quite sure what to do with it, though. I’d like to get a report when the overall fragmentation reaches some threshold where it might be worth compa

Re: USE DATABASE from a component. ?

are you sure that the index is "embedded"? it's true that an external database created using SQL does not have an accompanying 4DIndx, but an MSC repair would add one. and if you open that database with USE DATABASE, the 4DIndx is opened too, so I would assume that the index is external to the 4

Re: USE DATABASE from a component. ?

yes, the original (during beta) specification was that an external database must be created using SQL, but that changed in the release of v12, as explained in the documentation: An external database is a standard 4D database. It can be opened and worked with as the main database by a 4D or 4D Se

Write Pro beginner questions

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 do

Re: USE DATABASE from a component. ?

On May 29, 2017, at 10:56 AM, David Adams wrote: > Hey Wayne, thanks for answering. I think that external .4DD files were > created for use from components in the first place and I've made it work > before...but it's been years. I don't remember hearing that you had to > create the data file from

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

On May 29, 2017, at 10:56 AM,Koen Van Hooreweghe wrote: > And while we're at it, the thing I miss the most is the split pane in the > method editor. Unfortunately 4D eliminated this feature a few years ago. IMHO > bookmarks are not a valid alternative. I miss the split pane feature too. So usef

Re: USE DATABASE from a component. ?

I just looked at the docs again. The problem is (from the create database page): However, it is imperative that you do not activate the access management system (by assigning a password to the Designer) in an external database, otherwise you will no longer be able to have access to it via the USE

Re: USE DATABASE from a component. ?

David, A lot of my comments were tongue in cheek but I'm sure I heard that once an external data file is opened in real 4D it buggers it up from then on as an external database Wayne On Mon, 29 May 2017 at 18:56, David Adams via 4D_Tech <4d_tech@lists.4d.com> wrote: > Hey Wayne, thanks for answ

Windows frames

Hi All, I have done a conversion for an application from V13 to V15 on windows. Using the aplication in V15, the frames of the windows in V15 are meno subtile than in V13. The command for open the windows is: $Win:=Open form window("Check_In";Palette form window;Horizontally Centered;Verticall

Re: https not working

We know the correct certificate format for 4D server, so thats not the problem ;-) David, please contact me directly so that we can get this sorted out. Kind Regards Pascal Geuns QualitySSL Meet me on LinkedIn http://www.linkedin.com/in/pascalgeuns

Re: Picture Buttons in v16

Thanks Keisuke Miyako! That’s exactly what I needed. So I basically do this: PICTURE LIBRARY LIST loop through each picture and GET PICTURE FROM LIBRARY use GET PICTURE FORMATS to detect if it is a PICT if the picture is a PICT,  CONVERT PICTURE to PNG  TRANSFORM PICTURE to add transparency  SET

Re: USE DATABASE from a component. ?

Hey Wayne, thanks for answering. I think that external .4DD files were created for use from components in the first place and I've made it work before...but it's been years. I don't remember hearing that you had to create the data file from SQL, I thought that you could use any data file that you l

Re: Picture Buttons in v16

I would recommended converting the source pictures inside the library, from PICT to PNG. there is nothing wrong with using the picture library, you can consider resource files in new development. so, take a 32-bit v16, iterate all pictures in your picture library, use GET PICTURE FORMATS to dete

Picture Buttons in v16

Aloha, I’m trying to make progress preparing our database for v16. Thanks for the help a few months back converting old PICT files. Turns out, Convert Picture was crashing like crazy in v15.2, but works fine in 15.3… Hopefully that helps someone else trying to do the same. Now I’m trying to co

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

Hi all, My all time favorite is of course: cmd-Z. But related to 4D, I love the alt-arrow up or down in the method editor. To move a line or a block of lines up/down in the code. And while we're at it, the thing I miss the most is the split pane in the method editor. Unfortunately 4D eliminate

Re: USE DATABASE from a component. ?

David, The only database available from a component is the host database. You can access it via pointers, (works for me). Or you can create a table in the host via SQL (although I prefer to avoid Satan's QL): http://doc.4d.com/4Dv16/4D/16/CREATE-TABLE.300-3201315.en.html But if you are heading

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

> Le 29 mai 2017 à 08:10, Bernd Fröhlich via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > My favorite trick: > moving a selection of code with alt+uparrow/downarrow Yes, nice one. It seems it slows down in proportion of number of opened windows in design. -- Arnaud de Montard