Re: QUERY BY ATTRIBUTE is slow af

2017-09-12 Thread John DeSoi via 4D_Tech
> On Sep 12, 2017, at 5:48 PM, David Adams via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Exciting stuff. I've read a ton about it and done some tests. Rob's plugin > doesn't have an explicit command for transferring object fields, but you > can stringify them and send them as text. Most

Re: QUERY BY ATTRIBUTE is slow af

2017-09-12 Thread David Adams via 4D_Tech
On Wed, Sep 13, 2017 at 9:25 AM, Tim Nevels via 4D_Tech < 4d_tech@lists.4d.com> wrote: > On Sep 12, 2017, at 5:49 PM, Jeffrey Kain wrote: > > > Yeah, so many caveats to object fields. Bite the bullet, use a related > table... > > Remember 4D’s implementation strategy for new features: > > - You

Re: Connecting to SQL on a PC

2017-09-12 Thread Charles Miller via 4D_Tech
The same way, except the drivers are already there. There is an ODBC admin function similar to Mac Log in could be different depending on how access is set up. Regards Chuck Chuck Miller Voice:

Re: 4D and Fusion Charts

2017-09-12 Thread Jeremy French via 4D_Tech
Have you looked at these items in the Web Area documentation? 1) Configuring the Web area 2) Using the $4d object See Accessing 4D Methods at http://doc.4d.com/4Dv16/4D/16.2/Programmed-management-of-Web-Areas.300-3434143.en.html#3190797 > On Sep 12, 2017, at 2:53 PM, John S. Poteat via

Re: QUERY BY ATTRIBUTE is slow af

2017-09-12 Thread Tim Nevels via 4D_Tech
On Sep 12, 2017, at 5:49 PM, Jeffrey Kain wrote: > Yeah, so many caveats to object fields. Bite the bullet, use a related > table... Remember 4D’s implementation strategy for new features: - You get a little bit at a time. - The feature set is not complete. - The public (i.e. 4D developers)

Re: 4D and Fusion Charts

2017-09-12 Thread Tom DeMeo via 4D_Tech
Hi John, Fusion charts will allow you to set an on click event handler in javascript. You need that function to be part of the page you are loading in the web area. You probably can look at one of your Wakanda examples to see how that event handler is written. Inside that function, you can

Re: QUERY BY ATTRIBUTE is slow af

2017-09-12 Thread David Adams via 4D_Tech
That's a good article, if you want more - ping me. And that's exactly the idea I was referring to when I said I'd be willing to learn some new operators if it bought me a lot. And, since I tend to write like I know what I'm talking about no matter if I do or don't ;-) At the least, John DeSoi and

Connecting to SQL on a PC

2017-09-12 Thread Robert McKeever via 4D_Tech
For years, we have had a couple of clients that connect to an SQL server. All the traffic is done using triggers under 4D Server (the triggers run on the server), and we use the Actual OBDC SQL drivers for the connection on a Mac server. Works well. Now I have received a request to draw some

Re: QUERY BY ATTRIBUTE is slow af

2017-09-12 Thread Jeffrey Kain via 4D_Tech
I agree. I had just read this article the other day, however, and was hoping (expecting) that 4D would provide something similar to Postgres JSONB and GIN indexes: https://compose.com/articles/is-postgresql-your-next-json-database/ -- Jeffrey Kain jeffrey.k...@gmail.com > On Sep 12, 2017, at

Re: QUERY BY ATTRIBUTE is slow af

2017-09-12 Thread David Adams via 4D_Tech
Jeff, Well, thanks for trying to be the cranky old man instead of me. But just won't do. Now I have to rant. My skepticism regarding using object fields for the purposes should be pretty obvious to anyone that's paid attention. Regarding the Summit demo...I watched the video and thought that it

Re: [Off] Remote backup

2017-09-12 Thread Jeffrey Kain via 4D_Tech
Don't use 4D's code. Read the tech note to understand the concepts, but that code is not good for use in the real world. And don't put your mirror backup code in a component either -- you'll want to prevent your mirror from starting a backup in the middle of an integration, and the only way

Re: [Off] Remote backup

2017-09-12 Thread Benedict, Tom via 4D_Tech
Bob Miller writes: >[Server#1] Runs 4D Server that users are actively using. Code in a loop on >the 4D Server calls >"New Log File" every 10 minutes. Code in the loop then calls LEP to a script >to transfer the last journal file to [Server#2]. > >[Server#2] Runs 4D Server that users aren't

4D and Fusion Charts

2017-09-12 Thread John S. Poteat via 4D_Tech
Hi Everyone, I am working with Fusion Charts inside of a 4D Application and I have it working as expected but there is one feature I am not able to get working get and I thought I would post it here in case someone in the group has it working. I have a dialog that contains a ListBox and

Re: QUERY BY ATTRIBUTE is slow af

2017-09-12 Thread Jeffrey Kain via 4D_Tech
Yeah, so many caveats to object fields. Bite the bullet, use a related table... -- Jeffrey Kain jeffrey.k...@gmail.com > On Sep 12, 2017, at 5:03 PM, David Adams via 4D_Tech <4d_tech@lists.4d.com> > wrote: > >> I am playing with idea to use object for values that are used only for >> display /

Re: QUERY BY ATTRIBUTE is slow af

2017-09-12 Thread David Adams via 4D_Tech
On Wed, Sep 13, 2017 at 3:22 AM, Peter Bozek via 4D_Tech < 4d_tech@lists.4d.com> wrote: > On Tue, Sep 12, 2017 at 7:10 PM, Herr Alexander Heintz via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > > > > I am playing with idea to use object for values that are used only for > display / searching. I

Re: [Off] Remote backup

2017-09-12 Thread Jeffrey Kain via 4D_Tech
Yes - you have it correct. > It would seem that Server#1 never runs 4D Backup, because any restoration > would be done using Server#2. Nevertheless, if Server#1 started up and > somehow choked, a "normal" behavior would be to restore from backup and > integrate the log file. Since this

Re: QUERY BY ATTRIBUTE is slow af

2017-09-12 Thread Peter Bozek via 4D_Tech
On Tue, Sep 12, 2017 at 7:10 PM, Herr Alexander Heintz via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Absolutely. > I exclusively use object fields for additional data and storage of > connected information to a specific data row, such as record and field > history, specific item settings etc. >

Re: QUERY BY ATTRIBUTE is slow af

2017-09-12 Thread Herr Alexander Heintz via 4D_Tech
Absolutely. I exclusively use object fields for additional data and storage of connected information to a specific data row, such as record and field history, specific item settings etc. All of these will NOT be queried on. There are cases where I use object fields for variable data structures,

Re: QUERY BY ATTRIBUTE is slow af

2017-09-12 Thread Jeffrey Kain via 4D_Tech
So disappointing. -- Jeffrey Kain jeffrey.k...@gmail.com > On Sep 12, 2017, at 12:14 PM, Herr Alexander Heintz via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > Having worked with 4D since ages long forgotten, I would have to feel very > lucky and outright daring to even assume such a thing

[Off] Remote backup

2017-09-12 Thread bob.miller--- via 4D_Tech
Hi Jeff, This is a great idea, I had not thought of it. Let me repeat it back to see if I have it: [Server#1] Runs 4D Server that users are actively using. Code in a loop on the 4D Server calls "New Log File" every 10 minutes. Code in the loop then calls LEP to a script to transfer the

Re: QUERY BY ATTRIBUTE is slow af

2017-09-12 Thread Herr Alexander Heintz via 4D_Tech
Am 12.09.2017 um 17:22 schrieb Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com>: > > Trying to figure out why our experience with QUERY BY ATTRIBUTE is so > different than the demos at the last 4D Summit. > > We're running 4D Server 16.2 64-bit on Windows. The Invoices table has about > 9

Re: QUERY BY ATTRIBUTE is slow af

2017-09-12 Thread Jeffrey Kain via 4D_Tech
That was my first thought too, but I can change the query string to "Ralph" and it still does a sequential scan of the table, returning no rows. -- Jeffrey Kain jeffrey.k...@gmail.com > On Sep 12, 2017, at 11:26 AM, Spencer Hinsdale via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > isn't there

RE: QUERY BY ATTRIBUTE is slow af

2017-09-12 Thread Epperlein, Lutz (agendo) via 4D_Tech
Maybe there is an issue with @ character in the search string ... I've no idea how to circumvent it. HTH Regards Lutz > -Original Message- > From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Jeffrey Kain > via > 4D_Tech > Sent: Tuesday, September 12, 2017 5:23 PM > To:

Re: QUERY BY ATTRIBUTE is slow af

2017-09-12 Thread Spencer Hinsdale via 4D_Tech
isn't there some trick to use a character code instead of at? and does the "beginning and end" pref possibly apply? > On Sep 12, 2017, at 8:22 AM, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Trying to figure out why our experience with QUERY BY ATTRIBUTE is so > different

QUERY BY ATTRIBUTE is slow af

2017-09-12 Thread Jeffrey Kain via 4D_Tech
Trying to figure out why our experience with QUERY BY ATTRIBUTE is so different than the demos at the last 4D Summit. We're running 4D Server 16.2 64-bit on Windows. The Invoices table has about 9 million rows, and we added an index to the Extra field in this table which is an object field.

Re: Edit in list / subform / 4D v16

2017-09-12 Thread Two Way Communications via 4D_Tech
Ok, I tested a regular list of [Contacts], where the fields are side by side on 1 row. Editing works here. However, if you make the detail section bigger and put the fields vertically, editing is no longer possible… bug? Regards, Rudy Mortier Two Way Communications bvba -

Re: Edit in list / subform / 4D v16

2017-09-12 Thread Two Way Communications via 4D_Tech
In the output form, fields are one above the other, so the detail section is 3 fields high. Could that be the cause? Regards, Rudy Mortier Two Way Communications bvba - > On 12 Sep 2017, at 13:21, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > to edit in

Re: Edit in list / subform / 4D v16

2017-09-12 Thread Keisuke Miyako via 4D_Tech
to edit in list you need to click twice; that means to click an already selected line with an interval longer than that of a double click. the exact threshold is adjustable at the system level. ** 4D Internet Users Group (4D

Re: Edit in list / subform / 4D v16

2017-09-12 Thread Spencer Hinsdale via 4D_Tech
read write([contacts])? > On Sep 12, 2017, at 4:15 AM, Two Way Communications via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > I thought this would be a no brainer but it’s starting to become a nuisance… > > I create a subform for a table [Contacts] inside the form for the table > [Customers]

Edit in list / subform / 4D v16

2017-09-12 Thread Two Way Communications via 4D_Tech
I thought this would be a no brainer but it’s starting to become a nuisance… I create a subform for a table [Contacts] inside the form for the table [Customers] The subform is set to display the [Contacts] Output form, is set to ‘Edit in list’ etc. However, when I display the list of

RE: OBJECT get variable type

2017-09-12 Thread Keith White via 4D_Tech
Hi >@Piotr: can you report this in the 4D forum as feature request? So I can vote Object filters don't do the same thing because placeholders cause the problems Koen already outlined. Here is the link to the feature request for alpha variable length limit (I also asked for similar alpha/text