date:20160831

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

**
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
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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

2016-08-31 Thread Tim Nevels

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 open 2 copies of 4D. One with the existing structure 
and another with a new, empty structure. Then you start dragging and dropping 
to copy items to the new structure. Do some editing. Add some tables, menu 
bars, lists, pictures, etc. Quit and start a few times. Fix more things. Copy 
more things from the old structure I thought I didn’t need but found out I 
still do need. Finally after a few hours I’ve got a working new structure with 
the basics that I need to start doing some real work on the new project. 

> BTW: I used G4 Shell back in the day (1992 or so) and then Foundation on 
> several projects over the years. One of my concerns is that some of the 
> commercial 4D shells have not been updated very much… for example, using the 
> latest 4D Object features and JSON abilities would make that structure 
> incompatible with older versions of 4D which some shells continue to support. 
> I’m fine with embracing v15 and above—not looking back!

If you want to get started fast and have a lot of functionality then Foundation 
is the way to go. Great shell that you can use to do what I’m doing but get it 
done in minutes instead of hours. Foundation is being maintained by Walt Nelson 
now. The website only talks about 4D v11/v12/v13. Not sure what his plans are 
and what new 4D technologies he plans to add to Foundation. You’d have to ask 
Walt about that. 

Tim

Tim Nevels
Innovative Solutions
785-749-3444
timnev...@mac.com

**
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
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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.

**
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
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Using ListBoxes as Output forms

2016-08-31 Thread John DeSoi

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 are using 
4D's built-in sort dialog?

John DeSoi, Ph.D.

> On Aug 31, 2016, at 5:19 PM, Sannyasin Siddhanathaswami  
> wrote:
> 
> I’m still stuck on not being able to get a complex sort from a selection so I 
> can do a sort again after changing the selection. I guess I need to add a 
> feature request. Not having this limits the usefulnees of listboxes as an 
> output form. For this need, I’ll keep using ALP. I guess some of my output 
> forms don’t really need this feature, but they could benefit from it.

**
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
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Can't Save Record Mandatory field is null

2016-08-31 Thread Sannyasin Siddhanathaswami

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, 2016 at 4:31:14 AM, Chip Scheide 
(4d_o...@pghrepository.org) wrote:

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.
**
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
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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
===
**
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
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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 robust starting point for me.

Generally I move methods into it when I've used them in databases for a
while and am comfortable with the implementation. I'll also add things from
tech notes, tech tips or such when I find myself thinking, "wow - that's a
good idea." The XML to JSON and back tech note most recently, for
instance. I setup my components to build to a folder in my 4D workspace. I
put an alias to the component in the database component folders. So when I
update the component build it automatically propagates to the other
databases I'm working on. It's usually a good idea to put a hard copy in to
databases once they are built or 'frozen'.

I was on the fence about using components like this for a long time but now
I'm a fan.

On Wed, Aug 31, 2016 at 2:23 PM, Robert ListMail 
wrote:

> Kirk, what core functionality does your component provide?
>
-- 
Kirk Brooks
San Francisco, CA
===
**
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
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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 based listbox. The reason is it seems
you've got 3 discrete things going on: the external data, the 4D records
and the view of it all. Putting the view into variables (arrays) gives you
the flexibility to manipulate the other parts easily and 'reflect' onto the
screen (the listbox) the results of those actions. It might make it easier
to keep things straight internally.

On Wed, Aug 31, 2016 at 11:51 AM, Alan Tilson  wrote:

> Kirk,
> I'm not sure what part of my situation your proposal is for?
>

-- 
Kirk Brooks
San Francisco, CA
===
**
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
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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 functionality.

**
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
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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

2016-08-31 Thread Magnus Torell

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 suspected that the definition of unknown URLs were changed over years so
I went to the documentation to understand what should be the standard
setting.
I became confused.

In docs for v12:

Do not remove “/” on unknown URLs: In former versions of 4D, unknown URLs
(URLs that do not correspond to an existing page nor to a 4D special URL)
were returned in the On Web Authentication and On Web Connection ($1)
database methods and did not begin with the “/” character. This specificity
was removed in 4D 2004. However, if you implemented algorithms based on this
special case and wish to keep the previous behavior, you can uncheck this
option.

In docs for v15R4:

Remove “/” on unknown URLs: In former versions of 4D, unknown URLs (URLs
that do not correspond to an existing page nor to a 4D special URL) were
returned in the On Web Authentication and On Web Connection ($1) database
methods and did not begin with the “/” character. This specificity was
removed in 4D 2004. However, if you implemented algorithms based on this
operation and wish to keep it, you can uncheck this option.

It seems that the standard should be to have this setting checked.
But does it mean that the / are removed or not?

Best Regards
Magnus Torell

--
View this message in context:
http://4d.1045681.n5.nabble.com/Compatibility-Do-not-Remove-on-unknown-URLs-tp5747160.html
Sent from the 4D Tech mailing list archive at Nabble.com.
**
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
Unsub: mailto:4d_tech-unsubscr...@lists.4d.com
**

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 projects over the years. 
One of my concerns is that some of the commercial 4D shells have not been 
updated very much… for example, using the latest 4D Object features and JSON 
abilities would make that structure incompatible with older versions of 4D 
which some shells continue to support. I’m fine with embracing v15 and 
above—not looking back!

Robert

> On Aug 31, 2016, at 3:34 PM, Tim Nevels  wrote:
> 
> Now with a new client I take that final version from the other projects and 
> build that into the new project. And probably at that time make some of the 
> above changes I mentioned. That’s how I do things. 

**
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
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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 (discovered pun) your own set of tools.

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 functionality. I
have a couple of other databases with some bare bones elements that involve
tables I'll copy in as needed.

This is one of the areas where 4D's tendency to attract a lot of lone wolf,
independent devs doesn't really help new folks. It's stark contrast to
something like javaScript or even D3 where you find a plethora of options
and frameworks for starting new projects.

On Wed, Aug 31, 2016 at 12:29 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, I’ve been a shell guy for the most part snd i do see the
> value. With that said, I was trying to find the private email from those
> that suggested, and recognized value, with the non-shell approach. Thoughts
> about new v15-based 4D projects via a shell or not? Why is a shell less
> relevant today?
>

-- 
Kirk Brooks
San Francisco, CA
===
**
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
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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  wrote:
> 
> We are again excited to be making the shell up again in version 4D v15 and 
> likely 4D v16 again as the shell may cross over those versions

**
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
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Upgrading 2004 to v15

2016-08-31 Thread Wayne Stewart

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 database to v13 format.
> Then I had to work my way through it to find what still worked, and fix
> what didn't.
>
> I would agree with Peter’s advice. You’ve already said you are going to
> upgrade to v15. So just grab a copy of the current structure and a copy of
> the current data file and open it in v15 and let it convert it.
>
> You’ll get a bunch of errors about the plugins and messages about not
> having primary keys set for all the tables. And of course it will not
> compile. Then you get to work like Peter says.
>
> Upgrade the plugins. Then run a compile. Go to each error, like all the
> plugin related ones, and fix them by writing new code or replacing a plugin
> with a method you create. It’s going to take you a few days and maybe 50
> attempts to compile before it works. But you’ll get there.
>
> You may have to write some code to update your data file because v15
> requires a primary key be set for every table you want to journal. So you
> may have to do several test data file upgrades before it works smoothly.
> You may also have to make one more 2004 version that has all the primary
> key fields created and values assigned to them. Then when you open that
> data file with v15 it will convert it and assign the primary keys without
> issues.
>
> We all had to go through the primary key issues when moving from v13 to
> v14 or v15.
>
> Once all that is done, you’ll be ready to install the v15 version and let
> it upgrade your production data file.  The final step will be dealing with
> those odd bugs and issues that users report about certain things that you
> didn’t run across while doing the upgrade work. Can’t get around that part
> either. It’s going to happen, but they usually very quick and easy to fix.
> Probably on need one or two v15 version bug fix structure installs and you
> will be back to where you are now running your 2004 version.
>
> And as they say… good luck. :)
>
> Tim
>
> 
> Tim Nevels
> Innovative Solutions
> 785-749-3444
> timnev...@mac.com 
> 
>
> **
> 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
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com 
> **



-- 

Regards,

Wayne


[image: --]
Wayne Stewart
[image: http://]about.me/waynestewart

**
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
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Using ListBoxes as Output forms

2016-08-31 Thread John DeSoi

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 external SQL data don't need to be equal in size to 
the number of selected 4D records. For example, suppose your selection in 4D is 
5000 records. You could start by loading only 1000 rows of SQL data into 
arrays. If the user scrolls to row 2000, you detect this in the On Display 
Detail event and fetch the next 1000 rows of data in the arrays. It is possible 
to implement very smooth scrolling of SQL data without loading huge amounts of 
data into arrays all at once.

John DeSoi, Ph.D.

> On Aug 31, 2016, at 1:51 PM, Alan Tilson  wrote:
> 
> 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 and
> for 4D to keep it in sync when sorting, etc.

**
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
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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

2016-08-31 Thread Tim Nevels

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, I’ve been a shell guy for the most part snd i do see the 
> value. With that said, I was trying to find the private email from those that 
> suggested, and recognized value, with the non-shell approach. Thoughts about 
> new v15-based 4D projects via a shell or not? Why is a shell less relevant 
> today?

In the distant past there were a few “shells” to choose from to get you jump 
started with 4D. It provided a lot of the “user environment” functionality to a 
compiled and merged 4D application. The most popular is Foundation. I’ve looked 
at it several times in the past. It is a great product and gives you a lot of 
features and capabilities you can use without writing a lot of code.

I have never used Foundation or any of the other shells. I’ve written my own. 
I’ve done it probably 3 times. I build an application for a client making my 
own “shell” of features. Then I get a new client, so I copy a lot of the work 
from the other client, the shell part, but not all of it. I change some of it 
and make it better learning from my previous mistake. Then repeat that.

So I now have my own "shell" that has gone through 3 major revisions over the 
years. I’m basically happy with it. Of course there are a few things I would 
add and change. Let XML die and switch to JSON everywhere. Use object more, 
etc. 

Now with a new client I take that final version from the other projects and 
build that into the new project. And probably at that time make some of the 
above changes I mentioned. That’s how I do things. 

Tim

Tim Nevels
Innovative Solutions
785-749-3444
timnev...@mac.com

**
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
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Named selection based List Box

2016-08-31 Thread John Baughman

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 
different selections from the same table. In the past I would have used arrays 
in either list boxes or ALPro areas. This time I decided to give Named 
Selection based list boxes a try and was pleasantly surprised how easy it was 
to setup and maintain.  

If I had used arrays, with each list displaying 6 fields I would have had to 
create and maintain more than 18 arrays. With Named Selections I could do the 
same thing without any arrays. Changing the selections is a simple matter of 
clearing the Named Selection for each list box and creating a new one. Way less 
code than would be required to update 3 sets of arrays.

So much easier, and very powerful.
**
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
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Using ListBoxes as Output forms

2016-08-31 Thread Jody Bevan

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 based columns it worked just fine. It 
was slower than without it, but if one needs the information it saves time 
overall.

Sincerely
Jody Bevan

> On Aug 30, 2016, at 18:18, John DeSoi  wrote:
> 
> 
>> On Aug 30, 2016, at 3:48 PM, Alan Tilson  wrote:
>> 
>> Most of the time there is a matching 4D table but there could also be times
>> where all the data is coming from an external source, so I suppose I am
>> talking about array based listboxes.
> 
> It takes some work, but selection based listboxes work well for displaying 
> large result sets from external databases. I use this all the time with 
> Postgres. You need a "dummy" table to create a record selection with the 
> number of rows in the result set. A table with a single boolean field is all 
> you need. You can use the On Display Detail event to cache just a subset of 
> the data needed to display the visible rows.
> 
> It would be really nice if array based listboxes supported formula columns 
> and the on Display Detail event. Then all you would need to do is create a 
> boolean array with the right size and manage data fetching for the visible 
> rows.
> 
> John DeSoi, Ph.D.
> 
> 
> **
> 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
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
**
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
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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. 
It could also be the proper place.

Best regards,
-- 
Phil
forums.e-node.net



> On 31 Aug 2016, at 21:23, Alan Tilson  wrote:
> 
> 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,
>> --
>> 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














**
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
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Using ListBoxes as Output forms

2016-08-31 Thread Alan Tilson

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,
> --
> 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
>
>
>
>
>
>
>
>
>
>
>
>
> **
> 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
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
>
**
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
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Using ListBoxes as Output forms

2016-08-31 Thread Chuck Miller

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   
mailto:cjmillerinformed-solutions.com 
 Brookline, MA 02446 USA Registered 4D Developer
   Providers of 4D and Sybase connectivity
  http://www.informed-solutions.com  



> On Aug 31, 2016, at 2:51 PM, Alan Tilson  wrote:
> 
> 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 and
> for 4D to keep it in sync when sorting, etc.
> Thank you,
> Alan

**
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
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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












**
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
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Using ListBoxes as Output forms

2016-08-31 Thread Alan Tilson

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.
>
> 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 everyone,
> >
> > Is there anything new to add to this discussion?
> >
> > I'm looking for a way to display records from an external database synced
> > with records stored in 4D.
> >
> > Most of the time there is a matching 4D table but there could also be
> times
> > where all the data is coming from an external source, so I suppose I am
> > talking about array based listboxes.
> >
> > As Walt said to start this thread, I'd rather not reinvent the wheel!
> >
> > And right now we are using v13.6 but are planning on moving to v15 before
> > too long, so I'd love to find something that could work in both places.
> >
> > Thanks,
> > Alan
>
>
>
>
>
>
>
>
>
>
> **
> 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
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
**
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
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Using ListBoxes as Output forms

2016-08-31 Thread Alan Tilson

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 and
for 4D to keep it in sync when sorting, etc.
Thank you,
Alan

Kirk,
I'm not sure what part of my situation your proposal is for?
Alan


On Tue, Aug 30, 2016 at 8:18 PM, John DeSoi  wrote:

>
> > On Aug 30, 2016, at 3:48 PM, Alan Tilson  wrote:
> >
> > Most of the time there is a matching 4D table but there could also be
> times
> > where all the data is coming from an external source, so I suppose I am
> > talking about array based listboxes.
>
> It takes some work, but selection based listboxes work well for displaying
> large result sets from external databases. I use this all the time with
> Postgres. You need a "dummy" table to create a record selection with the
> number of rows in the result set. A table with a single boolean field is
> all you need. You can use the On Display Detail event to cache just a
> subset of the data needed to display the visible rows.
>
> It would be really nice if array based listboxes supported formula columns
> and the on Display Detail event. Then all you would need to do is create a
> boolean array with the right size and manage data fetching for the visible
> rows.
>
> John DeSoi, Ph.D.
>
>
> **
> 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
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
**
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
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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 code, so you will not be left in 
> the dark with how things work.

**
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
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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

2016-08-31 Thread Rikard Sagnér

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 it for Dropbox, but I’m pretty sure we’ve done single user 4D too.
> You should get it just because it’s got such a good name ;-)
> https://nssm.cc/
> Cheers,
> Craig

**
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
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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

2016-08-31 Thread Arnaud de Montard


> 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 dates: one has 2 digits years 
(management, invoice, payment, etc.) and another with 4 digits when the pivot 
can't do (most of the time for birth date). 

-- 
Arnaud de Montard


**
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
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Print header, then PRINT SELECTION, then footer

2016-08-31 Thread Bill Weale

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 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 line.
> 
> HTH
> Koen
> 
> Op 31-aug.-2016, om 17:37 heeft David Rose  het volgende 
> geschreven:
> 
>> I want to print the header only on the first page and the footer only on the 
>> last page. In between I want to print a selection of records, with subtotals 
>> in the two break areas. What series of print commands and other code do I 
>> need?

**
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
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Print header, then PRINT SELECTION, then footer

2016-08-31 Thread Koen Van Hooreweghe

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 line.

HTH
Koen

Op 31-aug.-2016, om 17:37 heeft David Rose  het volgende 
geschreven:

> I want to print the header only on the first page and the footer only on the 
> last page. In between I want to print a selection of records, with subtotals 
> in the two break areas. What series of print commands and other code do I 
> need?

**
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
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Upgrading 2004 to v15

2016-08-31 Thread Wayne Stewart

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 seamlessly jumping straight to
> those later versions, do you? I'm working under the assumption that the
> data file must be opened and manipulated with contiguous versions, but that
> the CODE can jump (with a lot of rework) from 2004 to v15. Is this right?
>
> Thanks!
>
> On Wed, Aug 31, 2016 at 4:34 AM, Peter Mew  > wrote:
>
> > 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
> >
> > Sent from my iPad
> >
> > > On 30 Aug 2016, at 22:30, Doug Hall  > wrote:
> > >
> > > Oops. I accidentally sent the above before I was finished.
> > >
> > > Anyway, I'd like to pick some brains of those who've transitioned from
> a
> > > similar environment. Did you just rewrite the Bash routines? That's got
> > to
> > > be a pain. Is there nothing out there that does a lot of the same
> stuff?
> > I
> > > primarily used the DTS (DateTimeStamp) and DSS modules. UI probably
> used
> > > NULL, too, but not much. I'm a little worried about all the time it
> will
> > > take to recreate this functionality.
> > >
> > > Most of the other stuff, I think I'm going to be okay upgrading.
> Active4D
> > > and ObjectTools are still supported by Aparajita Fishman, and PDF
> Plugin
> > > and PostgreSQL Plugin are in good hands with Rob Laveaux. AreaList Pro
> I
> > > see has changed hands and the licensing structure has changed. Are
> there
> > > any other surprises there, or should the upgrade be pretty
> > straightforward?
> > >
> > > Do I make the leap all the way from 2004 to v15, or should I try to
> shoot
> > > for interim versions? Do I need to get each version to work, or will
> the
> > > data upgrade from version to version be fine from an uncompiled (and
> > > non-functioning) version. I know I'll have to remove the components,
> like
> > > Bash. What other lovely surprises await me?
> > >
> > > Many thanks ahead of time!
> > > Doug Hall
> > >
> > >> On Tue, Aug 30, 2016 at 4:17 PM, Doug Hall  >
> > wrote:
> > >>
> > >> For various reasons, we have put off upgrading 4D. We originally
> > intended
> > >> to just move off of 4D all at once, but that turned out to be
> > impossible.
> > >> I've added onto our existing structure in spurts, but for the most
> part,
> > >> I've been out of active 4D development for almost a decade, now.So,
> now
> > I
> > >> begin the journey of a million miles, with a single step. The first is
> > >> advise from you guys. Should I shoot for an interim version, say v13,
> > or is
> > >> it possible (practical) to go all the way from 2004 to v15?
> > >>
> > >> I know that the Bash component we're using has not been supported for
> > >> years. Has anyone reverse engineered the methods in this component? If
> > so,
> > >> please email me privately.
> > >>
> > >>
> > >> Here's what we're currently using in 4D 2004:
> > >>
> > >> Foundation (v3.7.2?)
> > >>
> > >> Components:
> > >> Bash Component: I've heard there is no way to upgrade. Please advise.
> > >> Rollover (Used by ToolBar) No longer available.
> > >>
> > >> Plugins:
> > >> AreaList Pro 7.9
> > >> Active4D
> > >> MD5 Plugin
> > >> PDF Plugin
> > >> PostgreSQL Plugin
> > > **
> > > 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
> > > Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com 
> > > **
> > **
> > 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
> > Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com 
> > **
> >
> **
> 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
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com 
> **



-- 

Regards,

Wayne

Re: Upgrading 2004 to v15

2016-08-31 Thread Chip Scheide

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 entered request.
so there is no Xref to look through, BUT you can ask : Where is this 
variable/field/text/command/table/etc. used and get an answer in a 
second or 2.

There are menu functions to allow finding unused local and global vars, 
and methods.

Moving .. stuff.. is not just drag n drop between 2 open databases. 
Need a form from system 1 in system 2?
open both, drag from 1 to 2.

On Tue, 30 Aug 2016 18:03:04 -0500, Doug Hall wrote:
> 4D Insider will help me
> locate stuff I'm not using. By the way, is there a replacement for that
> functionality now that there is no more 4D Insider?
**
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
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Coloured button background

2016-08-31 Thread Tom DeMeo

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. 



https://drive.google.com/open?id=0B4EGxrgGEBl_U25RQ3dLM2VDZEk 




Tom DeMeo
**
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
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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

2016-08-31 Thread Eric Naujock

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 in 4D with the pivot dates that is right. 
The question is how to force people who are entering dates to put in a 4 digit 
year, and be able to find the 2 digit years and be able to correct them to a 
proper 4 digit year. Without messing up properly entered 4 digit years.

---

MacCafe
4405 Talmadge  St.
Toledo, OH 43623
Eric Naujock  -  ACSA 10.2, 10.3, 10.4 Apple - ACTC 10.5, 10.6, 10.7, 10.8, 
10.9, 10.10
http://www.mac-cafe.com
email: e r...@mac-cafe.com 
AOL IM: erlic

> On Aug 31, 2016, at 4:33 AM, Arnaud de Montard  wrote:
> 
> 
>> 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 Montard 
> 
> 
> **
> 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
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

**
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
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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 Siddhanathaswami <
sid...@hindu.org> wrote:

> It says :
> Cannot Save record…
> Cannot update record…
> Mandatory field is Null in record…
>

-- 
Kirk Brooks
San Francisco, CA
===
**
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
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Upgrading 2004 to v15

2016-08-31 Thread Peter Mew

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

Sent from my iPad

> On 30 Aug 2016, at 22:30, Doug Hall  wrote:
> 
> Oops. I accidentally sent the above before I was finished.
> 
> Anyway, I'd like to pick some brains of those who've transitioned from a
> similar environment. Did you just rewrite the Bash routines? That's got to
> be a pain. Is there nothing out there that does a lot of the same stuff? I
> primarily used the DTS (DateTimeStamp) and DSS modules. UI probably used
> NULL, too, but not much. I'm a little worried about all the time it will
> take to recreate this functionality.
> 
> Most of the other stuff, I think I'm going to be okay upgrading. Active4D
> and ObjectTools are still supported by Aparajita Fishman, and PDF Plugin
> and PostgreSQL Plugin are in good hands with Rob Laveaux. AreaList Pro I
> see has changed hands and the licensing structure has changed. Are there
> any other surprises there, or should the upgrade be pretty straightforward?
> 
> Do I make the leap all the way from 2004 to v15, or should I try to shoot
> for interim versions? Do I need to get each version to work, or will the
> data upgrade from version to version be fine from an uncompiled (and
> non-functioning) version. I know I'll have to remove the components, like
> Bash. What other lovely surprises await me?
> 
> Many thanks ahead of time!
> Doug Hall
> 
>> On Tue, Aug 30, 2016 at 4:17 PM, Doug Hall  wrote:
>> 
>> For various reasons, we have put off upgrading 4D. We originally intended
>> to just move off of 4D all at once, but that turned out to be impossible.
>> I've added onto our existing structure in spurts, but for the most part,
>> I've been out of active 4D development for almost a decade, now.So, now I
>> begin the journey of a million miles, with a single step. The first is
>> advise from you guys. Should I shoot for an interim version, say v13, or is
>> it possible (practical) to go all the way from 2004 to v15?
>> 
>> I know that the Bash component we're using has not been supported for
>> years. Has anyone reverse engineered the methods in this component? If so,
>> please email me privately.
>> 
>> 
>> Here's what we're currently using in 4D 2004:
>> 
>> Foundation (v3.7.2?)
>> 
>> Components:
>> Bash Component: I've heard there is no way to upgrade. Please advise.
>> Rollover (Used by ToolBar) No longer available.
>> 
>> Plugins:
>> AreaList Pro 7.9
>> Active4D
>> MD5 Plugin
>> PDF Plugin
>> PostgreSQL Plugin
> **
> 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
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
**
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
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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 everyone,
> 
> Is there anything new to add to this discussion?
> 
> I'm looking for a way to display records from an external database synced
> with records stored in 4D.
> 
> Most of the time there is a matching 4D table but there could also be times
> where all the data is coming from an external source, so I suppose I am
> talking about array based listboxes.
> 
> As Walt said to start this thread, I'd rather not reinvent the wheel!
> 
> And right now we are using v13.6 but are planning on moving to v15 before
> too long, so I'd love to find something that could work in both places.
> 
> Thanks,
> Alan










**
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
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Upgrading 2004 to v15