Re: Coloured button background

Thanks Tom. What I learned is that OBJECT SET COLOR works with regular buttons as your demo shows. However, it does not work with 3D Buttons. I want to display an icon at the same time. So I will roll my own. Mitch ** 4D

Re: 4D Shell or not so much...?

Robert Yes, we are starting with a new structure. That way we have to put our eyes on everything. Yes we do grab things over as works between versions. We always have a clean copy of the shell. This is we can start a new project, as well if we get a great idea we can put it into the shell

Re: UUID Duplicate Key Error

data always takes precedence over auto-generation, otherwise, you would end up miserable when you import related data. > 2016/09/01 8:09、Robert ListMail のメール： > > When importing a tab-delimited text data into a v15-based table where the > Auto UUID box is checked in the

UUID Duplicate Key Error

When importing a tab-delimited text data into a v15-based table where the Auto UUID box is checked in the field attributes, shouldn’t 4D happily generate the required UUID if none are being imported from the source text file? Thanks, Robert

Re: 4D Shell or not so much...?

On Aug 31, 2016, at 5:44 PM, Robert ListMail wrote: > Hi Tim, thanks for the input. I suppose that you don’t maintain a copy of the > pure shell and that you manually move (drag/drop or copy/paste) over the > shell elements (from the previous project) each time—yes? That’s exactly right. I

Re: 4D Shell or not so much...?

Understood—thanks! BTW: this is a reminder to use components more. Robert > On Aug 31, 2016, at 4:59 PM, Kirk Brooks wrote: > > I forgot to include Canon Smith's OBJ component. Until that functionality > is baked into 4D it's required.

Re: Using ListBoxes as Output forms

The only problem I see is that you have to provide your own sort dialog so you can capture all of the sort parameters. For simple sorts (click on Listbox headers), you can capture the event, store the sort parameters, and then perform the sort yourself or let 4D do it. Are you stuck because you

Re: Can't Save Record Mandatory field is null

Aloha Kirk, Good hint. I’ll look at related tables/fields for mandatory. I’ll also double check I have primary keys on everything. I thought I did. Chip, unfortunately I get this error when I try to save a record with code without loading a form. -- Sannyasin Siddhanathaswami On August 31,

Re: 4D Shell or not so much...?

I forgot to include Canon Smith's OBJ component. Until that functionality is baked into 4D it's required. On Wed, Aug 31, 2016 at 2:42 PM, Kirk Brooks wrote: > Coupled with 4DPop it makes for a pretty robust starting point for me. > -- Kirk Brooks San Francisco, CA

Re: 4D Shell or not so much...?

Robet, Custom alerts, date & time manipulation methods, formatting, string operations, file ops, lots of listbox tools, math functions, form object and c-obj tools, a number of other little things like that and a set of developer tools and palettes I like. Coupled with 4DPop it makes for a pretty

Re: Using ListBoxes as Output forms

Alan, I was fixated on the part that was talking about the wonky spacing issues on the right side of a listbox. Which was really a pretty incidental part of the whole as I look back at it. This sounds like a pretty sophisticated scenario you're dealing with. I would start by looking at an array

Re: 4D Shell or not so much...?

Kirk, what core functionality does your component provide? Thanks, Robert > On Aug 31, 2016, at 4:18 PM, Kirk Brooks wrote: > > I've condensed many of mine into a single component I can drop into a > database to provide things I like to have and lots of core

Compatibility: (Do not) Remove "/" on unknown URLs

Dear, When upgrading to v15 (from v12) we caught some errors depending on code in OWC where we tested for instance for "/something@". Toggling between on and off for the compatibility database setting: - Remove "/" on unknown URLs removed some errors, but then some other errors were introduced. I

Re: 4D Shell or not so much...?

Hi Tim, thanks for the input. I suppose that you don’t maintain a copy of the pure shell and that you manually move (drag/drop or copy/paste) over the shell elements (from the previous project) each time—yes? BTW: I used G4 Shell back in the day (1992 or so) and then Foundation on several

Re: 4D Shell or not so much...?

Robert, I'll echo what the others are saying - and meaning no disrespect to anyone - I think the landscape of 4D development is changing so quickly these days it's tough to think about using a full featured shell. Like Tim said depending on your skills, preferences and needs you'll develop

Re: 4D Shell or not so much...?

Jody, When you “make the shell up again” are you starting with a new structure and dragging (or copying) over the objects that are not being redesigned? Are you maintaining a copy of the shell that is purely the shell…? Thanks, Robert > On Aug 31, 2016, at 3:18 PM, Jody Bevan

Re: Upgrading 2004 to v15

And guard your catalog.xml file with your life. :) On Thursday, 1 September 2016, Tim Nevels wrote: > On Aug 31, 2016, at 1:36 PM, Peter Mew wrote: > > > I just tried to open the 2004 database with the v13 development > environment and it converted both structure and

Re: Using ListBoxes as Output forms

You can't put arrays directly in a selection based listbox, but you can display data from them using a formula column. If you are mixing views with 4D based data, I would definitely use selection based listboxes especially if you want to display large selections. The arrays you use for the

Re: 4D Shell or not so much...?

On Aug 31, 2016, at 3:18 PM, Robert ListMail wrote: > It was recently suggested to me that the value of using a 4D-based shell is > less important now… and that I should consider new 4D applications from > scratch. I’ve created more apps with a shell than without with great > success—that is,

Named selection based List Box

List Box has been getting a great deal of discussion and one thing I have noticed is that the Named Selection based list box is rarely mentioned and on at least one occasion was referred to as not being of much use. I recently had the requirement for a form that included 3 lists displaying

Re: Using ListBoxes as Output forms

John: Since v12 of 4D we had one form for all outputs. It used a listbox. We let users determine which column they would show or not. We also let the system administrator add new columns that were based on fields or formulas that they could make up. When a user selected one of the formula

Re: Using ListBoxes as Output forms (or AreaList Pro)

Alan, If you load SQL data into 4D arrays, displaying them with AreaList Pro is straightforward, as well as displaying 4D fields. Or do you want to display data directly from an external SQL database such as mySql? We can continue privately to avoid cluttering the Nug on this specific topic.

Re: Using ListBoxes as Output forms

Phil, Generally it is a set of arrays loaded via SQL and most of the time there is a corresponding table in 4D with additional fields to display. Thanks, Alan On Wed, Aug 31, 2016 at 3:07 PM, Philippe Ganter wrote: > Alan, > > What kind of external data ? > > Best regards, >

Re: Using ListBoxes as Output forms

they do not really support arrays but do support variables calculated on display detail event Regards Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064

Re: Using ListBoxes as Output forms

Alan, What kind of external data ? Best regards, -- Phil forums.e-node.net > On 31 Aug 2016, at 20:53, Alan Tilson wrote: > > Philippe, > Thank you for the suggestion. Does AreaList Pro handle external data synced > with 4D data well? > Alan

Re: Using ListBoxes as Output forms

Philippe, Thank you for the suggestion. Does AreaList Pro handle external data synced with 4D data well? Alan On Wed, Aug 31, 2016 at 5:08 AM, Philippe Ganter wrote: > Alan, > > You may want to check out AreaList Pro, the most popular professional tool. > >

Re: Using ListBoxes as Output forms

John, I did not realize that array based listboxes did not support formula columns. Do selection based listboxes also support arrays? I mean if the data from the external source is in sorted arrays that are in sync with the 4D selection, it would be great to just include the array for the column

Re: New 4D v15 DB--What foundational decisions are important...?

Walt, the current v5 Foundation is based on a v11 structure? Thanks, Robert > On Aug 21, 2015, at 10:43 PM, Walt Nelson wrote: > > www.foundationshell.com and download the > free demo. > > When you purchase you receive ALL the source

Re: Can you run 4D merged app as a Windows service?

We use NSSM for managing 4D remotes (working as slaves for main 4D ever) so I would also assume it work with a single 4D user application. Best, Rikard > On 4 aug. 2016, at 11:27, li...@sussol.net wrote: > > NSSM (non-sucking service monitor) can run any app as a service I believe. We > use

Re: How to find 2 digit years in legacy Database.

> Le 31 août 2016 à 15:54, Benedict, Tom a écrit : > > Hi Eric, > > [...] > With birthdates I don't think there is any question that 4 digits are > mandatory. Pivot years don't help. It's gotta be totally unambiguous. same approach here, I use 2 entry filters for

Re: Print header, then PRINT SELECTION, then footer

OBJECT MOVE might also be a possibility, if you can ID the last page. www William W. Weale Business Owners Support, LLC. Operations Analysis MIS Advising Decision Support Systems > On Aug 31, 2016, at 11:45 AM, Koen Van Hooreweghe > wrote: > > Hi David, > > Have

Re: Print header, then PRINT SELECTION, then footer

Hi David, Have you tried by moving the data/footer marker lines by code using SET PRINT MARKER When in print selection, you can only call this in the On Header form event. So you might need to find a way to determine if it is the last page when that header is printed to change the footer maker

Re: Upgrading 2004 to v15

Doug, It should just convert. I recently went from 6.7 to v15 in one step. No problem at all Wayne On Thursday, 1 September 2016, Doug Hall wrote: > When you guys say you've moved from 4D 2004 to v13 (or later) in one go, > you don't mean that the data file converts

Re: Upgrading 2004 to v15

Yes and no 4d has implemented a system of 'Find in Design' that, mostly, replaces Insider. It does some things that insider didn't, and there are a few things that insider did that the new system does not. Find in design does the insider cross referencing, live; BUT, it does so only on the

Re: Coloured button background

Hi Mitch, Not sure what the problem is. I created a demo. Download the link below. It has one project form with one button, with the object’s Appearance Platform set to “Printing". I change the color on load in the object method of the button. It works for me in 15 on OSX and Windows.

Re: How to find 2 digit years in legacy Database.

Actually this issue is related in that I have numerous people who have used a 2 digit year in their data entry and now they have a person who died in 16 and were born in 28 which makes them -12 years old right? According the the 4D date format that is right. At least based on what I am seeing

Re: Can't Save Record Mandatory field is null

Sannyasin, You can also get that error if there are related or linked records. I've never seen this come up outside of a change in structure when there is existing data. And a primary key field that doesn't get set, of course. Those might be clues. On Tue, Aug 30, 2016 at 9:05 PM, Sannyasin

Re: Upgrading 2004 to v15

Hi Doug I upgraded a 2004 database to v13 in one go. I had to rewrite some code for plugins no longer supported, many of the routines for which a plug was used, are now available in native 4D. I upgraded ALP to the latest version. There were no major problems with the 4D code. Good luck -pm

Re: Using ListBoxes as Output forms

Alan, You may want to check out AreaList Pro, the most popular professional tool. www.e-node.net/alp Far more powerful than listboxes, and generally easier to program. Best regards, -- Phil forums.e-node.net > On 30 Aug 2016, at 22:48, Alan Tilson wrote: > > Hello

Re: Upgrading 2004 to v15

Doug, As far as our plugins are concerned you’ll need to upgrade AreaList PrintList Pro and PrintList Pro to the current versions: www.e-node.net/alp www.e-node.net/plp Best regards, -- Phil forums.e-node.net > On 30 Aug 2016, at 23:17, Doug Hall wrote: > > For

Re: How to find 2 digit years in legacy Database.

> Le 29 août 2016 à 15:34, Benedict, Tom a écrit : > > 4D does support the datetime data type when the field is created using SQL > commands. [...] Hi Tom, if a date field is created with legacy tools, can it be used it as a datetime? And an hour field? -- Arnaud de