Query from two 4D application

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

Component works with compiled source but not as a component

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

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) >

RE: CALL FORM and CALL WORKER

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: poor performance LISTBOX INSERT COLUMN

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: Component works with compiled source but not as a component

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.

CALL FORM and CALL WORKER

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: Component works with compiled source but not as a component

$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

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

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: Quick Report Sort Field Names

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: Quick Report Sort Field Names

> 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: Component works with compiled source but not as a component

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: poor performance LISTBOX INSERT COLUMN

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: Change field type programmatically?

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

bad code does bad things

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

Change field type programmatically?

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

Re: Change field type programmatically?

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

poor performance LISTBOX INSERT COLUMN

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

Re: poor performance LISTBOX INSERT COLUMN

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

RE: poor performance LISTBOX INSERT COLUMN

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

RE: New Log Parser says : this doesnt make sense

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

> 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: Component works with compiled source but not as a component

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