Query from two 4D application

2017-12-01 Thread stardata.info via 4D_Tech
Hi All, I use 4D V15 on windows, and i need to do a query from one 4D application to another 4D application. How i can do this? Thanks /Ferdinando/ ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html

Re: Component works with compiled source but not as a component

2017-12-01 Thread Jim Dorrance via 4D_Tech
Thanks, I'll try stuffing the array into a blob, and passing the blob. On Fri, Dec 1, 2017 at 9:44 PM, Timothy Penner via 4D_Tech < 4d_tech@lists.4d.com> wrote: > This thread sounds familiar... Maybe the answer is already posted: > http://4d.1045681.n5.nabble.com/Passing-var-from- >

Re: poor performance LISTBOX INSERT COLUMN

2017-12-01 Thread Arnaud de Montard via 4D_Tech
> Le 1 déc. 2017 à 15:49, Piotr Chabot Stadhouders via 4D_Tech > <4d_tech@lists.4d.com> a écrit : > > Hi, > > In search of a performance problem in 1 of our forms I am asking for some > advice. > > I have succeeded in analyzing 10 4DDebuglog.txt files (using an Oracle DB by > the way) and

Re: poor performance LISTBOX INSERT COLUMN

2017-12-01 Thread Tim Nevels via 4D_Tech
On Dec 1, 2017, at 2:00 PM,Piotr Chabot Stadhouders wrote: > But, bottom line, we are skipping the fact that still the command LISTBOX > INSERT COLUMN is very slow compared to all other commands > And we wouldn't probably having this discussion if it was executed as fast as > the other commands

RE: Component works with compiled source but not as a component

2017-12-01 Thread Timothy Penner via 4D_Tech
This thread sounds familiar... Maybe the answer is already posted: http://4d.1045681.n5.nabble.com/Passing-var-from-component-to-host-td5737479.html http://forums.4d.com/Post/FR/16238062/1/16238063#16238063 http://livedoc.4d.com/4Dv16.1/help/Title/en/page1274.html#516584 " The component

Re: Quick Report Sort Field Names

2017-12-01 Thread Arnaud de Montard via 4D_Tech
> Le 1 déc. 2017 à 21:27, Jim Medlen via 4D_Tech <4d_tech@lists.4d.com> a écrit > : > > > Is there a way to tell the Quick Report Editor to sort the list of Field > Names Alphabetically ? There is ;-) See here: --

Re: Quick Report Sort Field Names

2017-12-01 Thread BTB-Gmail via 4D_Tech
Jim, Use the Set Field Titles command. That will do what you need. Thanks! David Conley By The Book, Inc. Office: 815-234-7530 Direct Line: 815-406-5502 Fax: 815-234-7532 http://www.bythebook.com > On Dec 1, 2017, at 2:27 PM, Jim Medlen via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > >

Re: Component works with compiled source but not as a component

2017-12-01 Thread Kirk Brooks via 4D_Tech
Jim, I must be missing something - where is $2 defined? On Fri, Dec 1, 2017 at 12:28 PM, Jim Dorrance via 4D_Tech < 4d_tech@lists.4d.com> wrote: > $tCallbackMethod gets called in the context of the host database and $1 is > correct. It is just that $2 contains ->$ > > On Fri, Dec 1, 2017 at 9:23

Re: Component works with compiled source but not as a component

2017-12-01 Thread Jim Dorrance via 4D_Tech
$tCallbackMethod gets called in the context of the host database and $1 is correct. It is just that $2 contains ->$ On Fri, Dec 1, 2017 at 9:23 PM, Jim Dorrance wrote: > Thanks for your input. > > On a contextual click on a svg area in a subform: > > $nArraySize:=*Size

Quick Report Sort Field Names

2017-12-01 Thread Jim Medlen via 4D_Tech
Is there a way to tell the Quick Report Editor to sort the list of Field Names Alphabetically ? The List of fields for the Master Table is sorted by Field number and I was wondering if there was any way to sort the list Alphabetically. Thanks, Jim Medlen Computer & Information Systems

Re: Component works with compiled source but not as a component

2017-12-01 Thread Jim Dorrance via 4D_Tech
Thanks for your input. On a contextual click on a svg area in a subform: $nArraySize:=*Size of array*($atSelectedRecordKeys) *If *($nArraySize>0) *EXECUTE METHOD*($tCallbackMethod;*;$tSubformName;->$atSelectedRecordKeys) *End if * And I works when the component runs interpreted or compiled.

RE: CALL FORM and CALL WORKER

2017-12-01 Thread Piotr Chabot Stadhouders via 4D_Tech
In fact, the functionality explained below could be seen as setting an alarm The alarm fires after a second (period of time) In the meantime it can be reset to again wait for a period of time before it fires Gr, Piotr Van: Piotr Chabot Stadhouders Verzonden: vrijdag 1 december 2017 17:40 Aan:

Re: Component works with compiled source but not as a component

2017-12-01 Thread Kirk Brooks via 4D_Tech
Jim, ​ First, if $tCallbackMethod is a Host database method it must have the Shared with host & component property set. As I understand it EXECUTE METHOD runs in the context of the method called. So if ​$tCallbackMethod is in the host it will run there. If it's in the component it will run there.

Re: poor performance LISTBOX INSERT COLUMN

2017-12-01 Thread Kirk Brooks via 4D_Tech
Piotr, On Fri, Dec 1, 2017 at 8:59 AM, Piotr Chabot Stadhouders via 4D_Tech < 4d_tech@lists.4d.com> wrote: > In fact our customers have big screens an want to see a lot of data at once > They like how it is displayed right now. > I have counted the listboxes displayed at once and the number is

RE: New Log Parser says : this doesnt make sense

2017-12-01 Thread Timothy Penner via 4D_Tech
Hi Piotr, Justin is correct on the reason behind the error. I meant to remove the TRACE commands before releasing it, I must have missed that, sorry. The log parser should still build the hierarchy. I will see about releasing an update with the TRACE removed... For now just comment out the

RE: poor performance LISTBOX INSERT COLUMN

2017-12-01 Thread Piotr Chabot Stadhouders via 4D_Tech
Hi Chip, Thanks for your quick response, it is much appreciated First of all you are right that I could recode some parts and is also for other reasons sometimes no bad idea at all > Load the list boxes as you go. Depending on your usage, you might only need 1, > or 4 list boxes not 27(!) In

CALL FORM and CALL WORKER

2017-12-01 Thread Piotr Chabot Stadhouders via 4D_Tech
Hi, This is the first time I am going to use CALL FORM and CALL WORKER I am going to convert a "Searchbox" mechanism where a user enters some characters and after 3 or more characters the search is started This was done by a custom Timer mechanism implemented via a separate process and inter

Re: poor performance LISTBOX INSERT COLUMN

2017-12-01 Thread Chip Scheide via 4D_Tech
Piotr recode this! On Fri, 1 Dec 2017 14:49:11 +, Piotr Chabot Stadhouders via 4D_Tech wrote: > > No big deal you could say, but for a couple of our forms it IS a big deal > We have a form with 27 listboxes on it, all dynamically build, with a > total of 477 columns recode this - I can't

poor performance LISTBOX INSERT COLUMN

2017-12-01 Thread Piotr Chabot Stadhouders via 4D_Tech
Hi, In search of a performance problem in 1 of our forms I am asking for some advice. I have succeeded in analyzing 10 4DDebuglog.txt files (using an Oracle DB by the way) and have come to following : The problem is with the execution time of the "LISTBOX INSERT COLUMN" The performance of this

bad code does bad things

2017-12-01 Thread Kirk Brooks via 4D_Tech
Miyako wrote that recently in a response to a question about a plugin and what's expected. This is one of those things that needs to be written on the wall next to "Think". I googled the phrase because - well, of course I would. This article

Re: Change field type programmatically?

2017-12-01 Thread Pat Bensky via 4D_Tech
Hi Olivier, Good point ... that will ease the pain somewhat! Pat On 1 December 2017 at 13:42, Olivier Deschanels via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Hello, > > Just in case … > > You can select several fields in the structure window and change their > type through a right clic. Even if

Re: Change field type programmatically?

2017-12-01 Thread Olivier Deschanels via 4D_Tech
Hello, Just in case … You can select several fields in the structure window and change their type through a right clic. Even if the fields are in different tables. Regards, Olivier > Le 1 déc. 2017 à 14:19, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> a écrit > : > > Using v16: > I have

Change field type programmatically?

2017-12-01 Thread Pat Bensky via 4D_Tech
Using v16: I have a large number of fields (hundreds) that I want to change from String to Text. Is there any way to do this programmatically? I thought I might be able to do it via SQL commands, but apparently 4D doesn't support the ALTER FIELD function. I'd prefer not to spend the rest of the

Component works with compiled source but not as a component

2017-12-01 Thread Jim Dorrance via 4D_Tech
4D v15.5 EXECUTE METHOD($tCallbackMethod;*;$tSubformName;->$atSelectedRecordKeys) On a contextual click in a component subform displayed in the host database, the method $tCallbackMethod is to be executed in the context of the host database. When the component source runs interpreted, or the

Re: New Log Parser says : this doesnt make sense

2017-12-01 Thread Justin Carr via 4D_Tech
On 1 Dec 2017, at 5:44 pm, Piotr Chabot Stadhouders via 4D_Tech <4d_tech@lists.4d.com> wrote: > > Hi, > > I am trying to use the new Log Parser, but without success > > First of all, when I start logging I have 10 files of 10MB each within 1 > minute, but that's not the problem (or is it) >