Re: Server Process "Frozen"-ish

Steve, I have a few that I've been running for a long time. #1 is a method that manages sending emails. Emails created by users and the system go into a que and then are sent by the server. The method just sits and runs every few minutes. Another one runs every few minutes to update the current sal

Re: Listbox Spacing Between Columns

Aloha, Probably the simplest solution is to tweak the format in the number column and add a couple of spaces at the right. eg. "$###,##0.00 ;($###,##0.00) ; - " Add more spaces if you like. On Sat, Sep 23, 2017 at 2:21 PM, Sannyasin Siddhanathaswami via 4D_Tech < 4d_tech@lists.4d.com> wrote:

Re: Listbox Spacing Between Columns

Sannyasin, Sorry about that - could have sworn I'd used that before. Next approach is to read the real arrays into text arrays. In this case since they are just display it doesn't really matter. In lots of cases it's a benefit using text arrays for user input as it lets you accept formulas for inp

Re: Listbox Spacing Between Columns

Sannyasin, It works with any text. Outside of listboxes I let users write formulas for things like pricing and commissions. It's nice to let them do this in terms of things they understand so a formula can look like: P= (Cost * x) + Z P= (MSRP * (1 - x)) + Z There are two ways you can evaluate t

Is it possible to put a SVG file directly on a form?

or does it have to be converted to a picture? -- Kirk Brooks San Francisco, CA === *The only thing necessary for the triumph of evil is for good men to do nothing.* *- Edmund Burke* ** 4D Internet Users Grou

Re: Listbox Spacing Between Columns

m> wrote: > even if it doesn't seem applicable to your immediate deployment target, > it is good practice as a programmer > to not assume that a thousand (decimal) separator would always be a comma > (period). > > 2017/09/25 7:43、Kirk Brooks via 4D_Tech <4d_tech@li

Re: Is it possible to put a SVG file directly on a form?

ource in a text variable (either visible or > invisible) on a form if you need to save the SVG temporarily. What are you > trying to do? > > On Mon, Sep 25, 2017 at 12:51 AM, Kirk Brooks via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > > > or does it have to be conv

How to get a the hidden array of a listbox?

This is v15 - how do I do that. Listbox get array would seem like the answer, and I think it is in v16, but not in v15. Is it possible? Thanks -- Kirk Brooks San Francisco, CA === *The only thing necessary for the triumph of evil is for good men to do nothing.* *- Edmund B

Re: How to get a the hidden array of a listbox?

2/Managing-List-Box- > Objects.300-3433556.en.html> > It > indicates that the page was modified in 15R4. > > Also, the string "managing row display" is in the V16 docs but not the V15 > so perhaps the feature was introduce in R4? > > -- > Douglas von Roeder &g

OPEN COLOR PICKER or OBJECT SET RGB COLORS inconsistencies

Hi folks, I was playing with using the OPEN COLOR PICKER command for the first time. Reasonably cool feature that really is only missing a way to close the window programmatically and get the selected value directly. But it's way better than the rgb sliders we had to use for years. I used a modif

Re: OPEN COLOR PICKER or OBJECT SET RGB COLORS inconsistencies

ou open the picker, > the device space is selected by default, so all is fine. > but when you use the picker tool, it switches to generic, > so the RGB representation differs to that used in 4D. > you need to manually switch the space to device, > or use the value returned by the

Re: OPEN COLOR PICKER or OBJECT SET RGB COLORS inconsistencies

gwheel. > select device color space (the one that 4D uses). > > you will see that the hex value changes from FF6600 to FF7C00, on the > panel. > this is the value that OPEN COLOR PICKER returns. > > 2017/10/02 10:30、Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com d_t...@lists.

Re: What to do about users who won't follow instructions?

Pat, There is a real difference between being a developer and being a trainer. I'm not a particularly good trainer. I just can't get my head around the beginner mind well enough in these circumstances to be really effective. In others I can but not in 4D world. So it's usually best I refer such qu

Re: Number format

That's the way I've always been able to make it work - with the space for the zero condition. On Wed, Oct 4, 2017 at 7:16 AM, Tom Dillon via 4D_Tech <4d_tech@lists.4d.com > wrote: > Try "###.##0,##0;-###.##0,##0; " > > Note that (I think) you need a space after the second semicolon. -- Kirk Br

Re: Is Table Number Valid Cannot Validate New Temporary Table

Miyako, Will that trick work compiled? On Tue, Oct 10, 2017 at 9:06 AM, Keisuke Miyako via 4D_Tech < 4d_tech@lists.4d.com> wrote: > why not simply use Get last table number? > > and you don't really need to use SQL to get a table pointer from name, > just do something like... > > C_POINTER($p) >

Re: [offish]Volume of mail

You know it's not like the French Forum has a legion of posts either. I just opened the 'v16 Corner' and the first 50 posts span from last Friday to March (of this year). 50 topics in 7+ months. The 'Current versions(v16-v15-R)' first 50 is from yesterday to July. These are the English ones. The F

Re: Is Table Number Valid Cannot Validate New Temporary Table

That's pretty cool - being able to get a pointer into a local var like that. On Tue, Oct 10, 2017 at 10:17 AM, Keisuke Miyako via 4D_Tech < 4d_tech@lists.4d.com> wrote: > of course it works compiled :) > > > 2017/10/11 1:12、Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com&

Re: Print From Web Area

Cannon, If the web area isn't using the WebKit it's rendered using whatever the system browser is. I think that would mean that browser would be used to print it as well but I haven't really tested that. On Wed, Oct 11, 2017 at 2:58 PM, Cannon Smith via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Hi

Re: Print From Web Area

> > What command would I use to invoke the printing in the first place? > > -- > Cannon.Smith > Synergy Farm Solutions Inc. > Hill Spring, AB Canada > 403-626-3236 > > > > > > On Oct 11, 2017, at 5:11 PM, Kirk Brooks via 4D_Tech < > 4d_tech@lists.4d.c

Re: Subrecords with subrecords

Lee, I assume you mean migrate the data out of that structure and into a brand new one? I'd say the thing to do is look at the result of opening it in v16 - which you already did and said the nested subtable isn't even there. So now add that table yourself linking as appropriate to the new table 4

Re: Subrecords with subrecords

Tim, On Fri, Oct 13, 2017 at 8:50 AM, Tim Nevels via 4D_Tech < 4d_tech@lists.4d.com> wrote: > If I remember correctly, the 2004 method editor will show sub-subtable > field references, but as soon as you edit a line with the reference (or > maybe even retokenize the whole method) it drops the sub-

Re: QUERY into variable vs. Records in Table

Hi Jeff, On Thu, Oct 19, 2017 at 10:28 AM, Jeffrey Kain via 4D_Tech < 4d_tech@lists.4d.com> wrote: > ​... > all it's doing is waiting for a relatively rare condition to happen (and a > record to appear in this table). It might happen at most once or twice per > day, maybe only once every few da

SVG add object question

I must be confused about how this works. I have some SVG files I want to use to create button icons. These are nice, simple, native SVG. I want to manipulate them using SVG. I can open a file and export it to a pic variable just fine. But I'm not able to put that object into a new svg. For example

Re: SVG add object question

gt; > On Sat, Oct 21, 2017 at 8:48 PM, Kirk Brooks via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > > > I must be confused about how this works. I have some SVG files I want to > > use to create button icons. These are nice, simple, native SVG. I want to > > manipulate

Re: SVG add object question

Hi Keith, Huh - that sounds like the problem I'm having. Plus I was thinking the added document ref would remain valid - like adding an object to a c-obj. That's not the way it works I know now. Makes sense to get the elements and just add those. That's more or less what I would up doing anyway. T

Re: Primary Key in 4Dv15

Ronnie, You can use the Generate UUID command to fill or regenerate a the key fields. On Tue, Oct 24, 2017 at 2:49 AM, Ronnie Teo via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Hi All, > > Need to seek some advice in converting a client’s database from v11 to v15. > > For one of the tables, 4D rep

Re: Tip: Exporting to a target folder in a package

Peter, You know Chuck is right - letting user's store stuff in Resources is problematic. I'm working on something right now where I came across this. In my case I'm letting users created button icons. Such files can only be referenced by buttons only when they are in the Resources folder. But the r

Re: POP3 Email Processing

On Fri, Oct 27, 2017 at 7:05 AM, Epperlein, Lutz (agendo) via 4D_Tech < 4d_tech@lists.4d.com> wrote: > The main problem with 4D Internet Commands is: > It blocks the whole application while waiting for and downloading messages > from the server. ​I moved downloading emails into a separate 4D dat

Re: Placing cursor in text field in included form

Lee, First, write a method to take an object name as $1 and uses HIGHLIGHT TEXT to place the cursor wherever you want it. Second, call this method using EXECUTE IN SUBFORM("subform name"; "MyMethod";*;"subform object name") On Fri, Oct 27, 2017 at 10:10 AM, Lee Hinde via 4D_Tech < 4d_tech@lists

Re: find only partial strings

Peter, Try this pattern: "\bseg\b" When you paste it into 4d the string will change to "\\bseg\\b". The '\b' is 'word boundary' so this looks for the letters 'seg' between word boundaries. On Fri, Oct 27, 2017 at 12:07 PM, Peter Mew via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Hi > If I have a

Method to put a c-obj (or JSON) into a hierarchical list

I thought I had such a method but it seems I don't. Before I re-invent this particular wheel does anyone have this already and are willing to share? Thanks -- Kirk Brooks San Francisco, CA === *The only thing necessary for the triumph of evil is for good men to do nothing.*

Re: Method to put a c-obj (or JSON) into a hierarchical list

Jeff, Just display a c-obj in a hierarchical list. I want to mimic the way the debugger shows c-objects. On Sun, Oct 29, 2017 at 11:03 AM, Jeffrey Kain via 4D_Tech < 4d_tech@lists.4d.com> wrote: > What are you trying to do? > > > On Oct 29, 2017, at 1:38 PM, Kirk Brooks via 4

Re: Method to put a c-obj (or JSON) into a hierarchical list

/expandable. > > Let me know if you’re interested and I’ll post it here. > > > On Oct 29, 2017, at 5:26 PM, Kirk Brooks via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > > > > Jeff, > > Just display a c-obj in a hierarchical

Re: Method to put a c-obj (or JSON) into a hierarchical list

Hi folks, Here's a native 4D solution. This is something I just roughed out so consider it a starting point for your own work. I noticed, and take advantage of, a couple of interesting aspects of how 4D handles c-objects. 1) OB GET($obj;"some key"; Is text) will almost always return the correct

Re: Method to put a c-obj (or JSON) into a hierarchical list

To follow up a little bit - After working with the above code I'm starting to really like it. First a correction, where it says " $subList:=New list" change it to " $subList:=0". As soon as the next line is executed $sublist gets assigned a new list anyway and this is a memory leak. The other ch

Re: Method to put a c-obj (or JSON) into a hierarchical list

Hi Ortwin, Nicely done. In this case I want to be able to view and edit the json easily. This is a developer tool I'm building but the solution is really all hierarchical list based. The key for me is being able to edit the json value without messing with the key. This is where I discovered the Ad

Re: Method to put a c-obj (or JSON) into a hierarchical list

s an editor, but I have only used it to display an objects content. > Haven’t tried to get the modified data back to 4D. > > HTH > Koen > > > Op 29 okt. 2017, om 22:26 heeft Kirk Brooks via 4D_Tech < > 4d_tech@lists.4d.com> het volgende geschreven: > > > > J

Re: Method to put a c-obj (or JSON) into a hierarchical list

n template or class based > languages. > > anyway, > > 4D is a strongly typed language, so the use of the 3rd argument "Is text" > does not remove the need to declare the left operand. > > if you > > $t:=OB Get($o;"foo";Is text) > > then you mu

Re: Method to put a c-obj (or JSON) into a hierarchical list

Hey Tim, Good point. I thought it might be an issue between 32 and 64 but I think I was just conflating the effect when dealing with other data types. ie. C_LONGINT($i) C_OBJECT($obj) $t:=OB Get($obj;"key") // no error $i:=OB Get($obj;"key") // ** error $i:=OB Get($obj;"key";Is longint) //

Re: pointers to arrays

Peter, This is easy to do with local arrays and dynamic variables. It looks like you only need to build text arrays. You can declare a local array, ARRAY TEXT($aText2d;0;0). Then you can resize this to add more 'columns' as needed and populate them. Next you need to populate the listbox. First del

Re: Method to put a c-obj (or JSON) into a hierarchical list

Tim, As we all know this sort of thing isn't what I'm particularly good at - but maybe it's the case that the compiler hits the -20007 error before getting to the more specific characterization that it's caused by incompatible types. If it's not that then I agree it would be nice if the messages w

Re: Method to put a c-obj (or JSON) into a hierarchical list

Er - "I wasn't aware the error handler would get tripped by line 14" is what I meant to type. On Tue, Oct 31, 2017 at 5:09 PM, Kirk Brooks wrote: > I wan't aware that the error handler would get tripped by that though. > -- Kirk Brooks San Francisco, CA === *The only thin

Re: [Warning] Settings properties values on object field by object notation

Tim, On Wed, Nov 1, 2017 at 10:13 AM, Tim Nevels via 4D_Tech < 4d_tech@lists.4d.com> wrote: > On Nov 1, 2017, at 11:04 AM, Keisuke Miyako wrote: > > > like a global preference, to the effect of > > > > "Call OB Copy implicitly when performing object assignments" > > > > it is an interesting point

Re: [Warning] Settings properties values on object field by object notation

+1 - all of it On Wed, Nov 1, 2017 at 9:56 PM, David Adams via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Thanks to TIm and Brian for responding here, always appreciated. > > There is no lack of clarity from 4D that the official channel is to post on > the forums. Before that, it was bugs.4d.fr. Th

Re: Normalization question

Doug, That's a really good resource for ideas for structuring things. I haven't looked at in a long time - it's grown quite a lot. On Wed, Nov 8, 2017 at 12:23 PM, Douglas von Roeder via 4D_Tech < 4d_tech@lists.4d.com> wrote: > This is a link

Re: Counting occurrences of specific characters In a document

Kirk, One trick for counting the number of characters is : $n:=length($text) $text:=replace string($text;$char;"") $n:=$n-length($text) That will work for your text file. Excel is more complicated. If it's .xls it's basically XML. Miyako made a component for working with them that may work for

Re: Slow characters visualization

Ferdinando, If you happen to have some forms open that include subforms and you have the subform open too it can cause the design process to use a lot of CPU cycles which might cause your system overall to behave as you describe. This was especially true if the subforms had listboxes. I haven't not

List item parent question

I'm working with hLists for the first time in a long time. I have a hList with 3 hierarchical levels. I select 'this item' at level 3 and want to get the Parent. A B B-sub1 B-sub2 this item B-sub3 C D ​I expect the parent is B-sub2. List item parent returns the parent as B.​ I veri

Re: Debug window messed up

Really? It's that simple? Did you just make that up? On Mon, Nov 13, 2017 at 8:55 AM, Vincent de Lachaux via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Create a method with just one line : TRACE > > Run the method with the shift key down will restore the debug window. > > -- Kirk Brooks San Franci

Re: List item parent question

Sujit, Yeah, I thought about that too but no error gets thrown. On Mon, Nov 13, 2017 at 10:46 AM, Sujit Shah via 4D_Tech < 4d_tech@lists.4d.com> wrote: > No > > Perhaps an error in code > -- Kirk Brooks San Francisco, CA === *The only thing necessary for the triumph of evil

Re: wa open url command in v15

Chuck, Yeah, using WA OPEN URL to open pdfs was a great hack for a while. Those were the days. I do this a lot and finally had to abandon it because of the sorts of issues you report. I resorted to this method for opening files. I am certain I got most of the details from reading something Miyako p

Re: Drop Down Menu Form Event

Jim, I use On click as well, but I rarely use dropdowns that are enterable (combo lists). In that case you want to recognize the data change event to do whatever in that case. Or turn off the On data change event and make the list non-enterable so you only have On clicked events to handle. As far

Re: New error about primary keys

Lee, I seem to recall something like this when I converted a datafile that had dupes in the PK field. But I don't recall the specific wording on the dlog. On Tue, Nov 21, 2017 at 4:19 PM, Lee Hinde via 4D_Tech <4d_tech@lists.4d.com > wrote: > I've seen the dialog that comes up with database with

Re: Subform initialize logic

Piotr, On Thu, Nov 23, 2017 at 5:14 AM, Piotr Chabot Stadhouders via 4D_Tech < 4d_tech@lists.4d.com> wrote: > As I understand correctly, when not on page 1, this subform is only > initialized when the page is loaded > ​I assume you are talking about a subform you placed in the design environment

Re: Subform initialize logic

Piotr, On Thu, Nov 23, 2017 at 11:01 AM, Piotr Chabot Stadhouders via 4D_Tech < 4d_tech@lists.4d.com> wrote: > I have to do this “On Page Change” > ​Yep, this is exactly the sort of situation that makes having the subform config code in a process method useful - the subform doesn't need to even k

Re: Subform initialize logic

Piotr, On Fri, Nov 24, 2017 at 2:59 AM, Piotr Chabot Stadhouders via 4D_Tech < 4d_tech@lists.4d.com> wrote: > As an example I have the following scenario: > An employee form with a lot of fields and a checkbox “manager” on page 1 > Other fields on page 2 > The items of some “dropdown lists” (cust

Re: Numeric Array Variable Not Reset When Array Redefined

Allan, I went along for quite a while before realizing changing the size of the array didn't clear it too. COPY ARRAY also fundamentally changes the array dimensions and content including the {0} element. On Sat, Nov 25, 2017 at 4:56 PM, Allan Udy via 4D_Tech <4d_tech@lists.4d.com > wrote: > ​..

Re: Numeric Array Variable Not Reset When Array Redefined

Pat, On Mon, Nov 27, 2017 at 1:33 AM, Pat Bensky via 4D_Tech < 4d_tech@lists.4d.com> wrote: > The selected or specified value of the array is stored in the "zeroeth" > element. > ​I don't think that's universally true any longer. It's the way things like popup lists and combo boxes work or scrol

The speed penalty for pointers is pretty low compiled

I still have a lingering sense that using pointers to variables imposes a noticeable speed penalty on code execution time. It's an old sense. I was just thinking about it while using a simple method I have for doing Increments. It's called Increment, takes a pointer to a var and adds 1 to it. $1->

Re: The speed penalty for pointers is pretty low compiled

Arnaud, On Tue, Nov 28, 2017 at 1:26 AM, Arnaud de Montard via 4D_Tech < 4d_tech@lists.4d.com> wrote: > In the same kind of old belief, the "price to pay" to call a method in > compiled mode is very low, but still passing a pointer parameter seems > slower than other types of parameters. > ​Good

Re: The speed penalty for pointers is pretty low compiled

Hey Jody, Great post. On Thu, Nov 30, 2017 at 7:43 AM, Jody Bevan via 4D_Tech < 4d_tech@lists.4d.com> wrote: > You are right how we stick to our old habits. We do though because they > have proven to work and sticking with them saves a lot of time. > ​True but there's retro code that while workin

Re: Tab into subform containers and GOTO OBJECT

Hi John, I'm curious what the situation is for having multiple embedded subforms beyond things like widgets for dates and such. Care to talk a little about what you need to do or why stacked subforms was your choice for it? On Wed, Nov 29, 2017 at 5:11 PM, truegold via 4D_Tech <4d_tech@lists.4d.co

Re: The speed penalty for pointers is pretty low compiled

Hey Wayne, On Thu, Nov 30, 2017 at 1:10 PM, Wayne Stewart via 4D_Tech < 4d_tech@lists.4d.com> wrote: > ​> ​Agreed again. I really do wish 4D did a better job of presenting new > ​ ​ > technology.​ > > ​Not wanting to sound like a 4D shill but I think the new blog ( > https://blog.4d.com) is fanta

Re: Tab into subform containers and GOTO OBJECT

John, Yep, it does make sense. Does sound pretty complex. On Thu, Nov 30, 2017 at 12:27 PM, truegold via 4D_Tech <4d_tech@lists.4d.com > wrote: > I had it all worked out (prior to last 4D world) using Object arrays. Then > I found out that I will need to have a licenses for 4D Spreadsheet (or > w

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

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 10

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.

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

t; > > > > > How else could I pass an array of record keys to the host? > > > > > > Jim > > > > On Fri, Dec 1, 2017 at 7:08 PM, Kirk Brooks via 4D_Tech < > > 4d_tech@lists.4d.com> wrote: > > > >> Jim, > >> ​ > >&g

Re: Assign multidimensional array

Ferdinando, Copy array works fine with 2D arrays if you want $B to be - a copy - of $A. But it sounds like you need to _append_ the elements. You can also use COPY ARRAY on specific arrays within the 2D array. Example: $A has 4 'arrays' with some number of elements in each array. I have $C that I

Execute on server gotcha

I use EOS methods a lot. They can make a huge difference since we run over IP connections. As part of my init for new processes I put all tables into Read Only and unlock the ones I need as I go along. You all probably do that too. Every now and then I'd be vexed by occasional locked records. 4D r

Re: Execute on server gotcha

Hi Miyako, Nice post. On Tue, Dec 5, 2017 at 5:01 PM, Keisuke Miyako via 4D_Tech < 4d_tech@lists.4d.com> wrote: > the place to look in documentation is in "Triggers" > http://doc.4d.com/4Dv16R4/4D/16-R4/Triggers.300-3317281.en.html ​OK. Not intuitive but I get the correlation. This is the first

Re: Execute on server gotcha

Hi Janet, The point about unloading the records is a good one. Have you see this recent tip in the KB: http://kb.4d.com/assetid=77893 Looking at some of my methods that run EOS my biggest issue is the assumption I was in READ ONLY when in fact it was READ WRITE. I like the suggestion Miyako made

Re: Execute on server gotcha

Hi Chip, Correct I believe. Looking at the chart: http://doc.4d.com/4Dv16R4/4D/16-R4/4D-Server-Sets-and- Named-Selections.300-3423889.en.html not only is the $test set local to the client machine but the <>test set is too - they differ in scope on the client machine's processes. But the 'regular'

Anyone seeing issues with OPEN PRINTING JOB and Windows 10?

I have a user running a brand new Win10 laptop and is unable to print a report built inside an OPEN/CLOSE PRINTING JOB clause. This is an old report and no other users are having issues. I'm looking for ideas about what it might be. -- Kirk Brooks San Francisco, CA === The

Re: Anyone seeing issues with OPEN PRINTING JOB and Windows 10?

Sorry - I should mention this is v15.4. On Thu, Dec 7, 2017 at 12:14 PM, Kirk Brooks wrote: > I have a user running a brand new Win10 laptop and is unable to print a > report built inside an OPEN/CLOSE PRINTING JOB clause. This is an old > report and no other users are having issues. > > I'm lo

Re: Typing a menu ref for Dynamic pop up menu

John, On Thu, Dec 7, 2017 at 1:00 PM, John Baughman via 4D_Tech <4d _t...@lists.4d.com> wrote: > The compiler then complains when I try to append to the list saying > “Changing the type of vTopLevelList from type text to type Real. > ​You can only use APPEND MENU ITEM with a menu ref. You menti

Re: Typing a menu ref for Dynamic pop up menu

not being used anymore, or more probably not ever used. > > Thanks, > > John > > > > > On Dec 7, 2017, at 11:13 AM, Kirk Brooks via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > > > > John, > > > > On Thu, Dec 7, 2017 at 1:00 PM, John

Anyone have a link to a Northwind SQL dataset?

Hi Folks, I would like to setup the Northwind sample data set. I found this site: https://northwinddatabase.codeplex.com/ but 4D fails when attempting to use SQL EXECUTE SCRIPT on it. I looked at the Microsoft site but have no idea which flavor would/could work. So - anyone have a suggestion? -

Re: Anyone have a link to a Northwind SQL dataset?

Hi Lee, I've started looking at Neo4js and they use Northwind as a demo data set. I want to put the same dataset into a 4D database to work out interacting with Neo4js from 4D. I thought it would be easy... On Sat, Dec 9, 2017 at 2:43 PM, Lee Hinde via 4D_Tech <4d_tech@lists.4d.com> wrote: > Tha

Re: Anyone have a link to a Northwind SQL dataset?

te: > Are you connecting from a Mac or PC? > Which version of 4D? > Can you make the connection to the Northwind db OK? > What error do you get? > What's the script contents? > > So many questions ... :) > > Pat > > On 9 December 2017 at 21:14, Kirk Brooks vi

Re: Anyone have a link to a Northwind SQL dataset?

For those of you playing along at home - I found this site on Github where you can get the basic data set. The structure is pretty simple to just make in 4D. https://github.com/tmcnab/northwind-mongo On Sat, Dec 9, 2017 at 2:14 PM, Kirk Brooks wrote: > Hi Folks, > I would like to setup the No

Re: Anyone have a link to a Northwind SQL dataset?

Pat, If I'm looking at it correctly this would allow me to access a running MySql database from 4D. What I was trying to do was create the Northwind db in a 4D database so I could practice exporting the data neo4J is using in its demo. I thought it would be useful for working out the code on the

Re: [off] File will not open in excel

Hi Chip, I get these from time to time as well. PITA. The ones I get have some weird formatting at the beginning. If you look at it in your text editor you'll probably see some style tag ( ... ) followed by two tables. The first one probably has the column headers and the second one the data. Aft

Re: Creating/Modifying 4DWrite/Pro Documents via Web Page

On Thu, Dec 21, 2017 at 10:01 AM, Timothy Penner via 4D_Tech < 4d_tech@lists.4d.com> wrote: > { > Note: The 4D Write Pro internal document format is a proprietary HTML > extension, compatible with HTML5/XHTML5, but which supports its own subset > of HTML/CSS attributes and tags. As a result, only

Re: Programmatically Manage Parent Tab an Multi-Subforms

John, Spencer's suggestion isn't bad and would allow you to use SET SUBFORM OBJECT within a method executed using EMIS called by the parent. The only other way I've been able to accomplish what you want to do is with nested EMIS calls: {Parent Form} EXECUTE METHOD IN SUBFORM ("Subform_1";"EMIS_1";

Re: Programmatically Manage Parent Tab an Multi-Subforms

John, On Tue, Dec 26, 2017 at 6:56 AM, truegold via 4D_Tech <4d_tech@lists.4d.com> wrote: > I think I will take a few more days off and when I return look at it with > fresh eyes. ​Frequently the very best advice and, for me anyway, ​usually the very hardest to follow. -- Kirk Brooks San Fran

Re: List Box Header background color programatically.

John, Listbox headers are essentially buttons so I think you've got the same options as buttons and setting the background color isn't one of them. You could make a graphic and load it as the icon but that would involve re-drawing it if the column changed size. I wonder if you can call OBJECT SET

Re: List Box Header background color programatically.

Hi all, On Tue, Dec 26, 2017 at 7:51 AM, Kirk Brooks wrote: > I wonder if you can call OBJECT SET FORMAT on them too? Probably can't > change the button type (which looks like 3D-bevel) but that does open up > the formatting options a bit. Simply changing the button from 3D-bevel to > 3D-none mak

Re: Electronic Signature Pads

Lee, How did the 4D app present/communicate/capture the signature image? On Thu, Dec 28, 2017 at 8:51 AM, Lee Hinde via 4D_Tech <4d_tech@lists.4d.com > wrote: > Justin, > > I’ve used this https://willowsystems.github.io/jSignature/#/about/ < > https://willowsystems.github.io/jSignature/#/about/>

Re: Using web areas in v16, is there a way to 'talk back' to 4d...

Lee, Be more specific about the scope of "talk back". The easiest way to directly allow users to interact with a web area displaying a page you created is the filter URL option. This is how I use web areas and either do something like popup a 4D menu or make a connection to an actual web link. I'v

Can I use METHOD GET NAMES in the Host to get methods from a component?

Doesn't look like it but maybe there is something I'm not thinking of. Thanks! -- Kirk Brooks San Francisco, CA === *The only thing necessary for the triumph of evil is for good men to do nothing.* *- Edmund Burke* ***

Re: Can I use METHOD GET NAMES in the Host to get methods from a component?

technique, where you use a host method as proxy to obtain info not > available to components works great. It may fail with some special 4D > commands, but has worked for me with all those I tried. > Give it a try. > > julio > > > On Jan 18, 2018, at 6:22 PM, Kirk Brooks via 4D

TIP: Method to calculate a formula using c-object values

Hi folks, Here is a method I find incredibly useful. It's another one of those things I suspect a lot of you have already written but I haven't seen anyone talking about it so I will. This method allows you to write a formula as a text string referring to object keys then pass the formula and c-ob

Re: v16 List Box Set Enterable not working?

The link Miyako included to the section on Managing Entry does actually talk about this. (I confess I hadn't read it very carefully before now myself.) You use OBJECT SET ENTERABLE to manage the enterability of the 'object' which is the listbox column. To control the enterability of an individual

Re: Going to the Summit Training, does it worth it?

I agree it's worthwhile. Many of you will recall this hasn't always been my quietly held opinion. The biggest thing that changed? I actually started going to them. The biggest benefits for me personally have been making personal connections with people in the company and other developers. On the

Re: v16 List Box Set Enterable not working?

ify the method a little bit to do the same. Kirk Brooks San Francisco, CA === *We go vote - they go home* On Tue, Jan 23, 2018 at 6:22 AM, Jim Crate via 4D_Tech <4d_tech@lists.4d.com > wrote: > On Jan 22, 2018, at 11:30 AM, Kirk Brooks via 4D_Tech < > 4

Re: Print settings Crash

Magnus, I run v15.5 on my OLED MacBookPro with no problems under Sierra. I also suggest upgrading from the v15R. Kirk Brooks San Francisco, CA === *We go vote - they go home* On Wed, Jan 24, 2018 at 4:52 AM, Magnus Torell via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Dear, >

Re: Document capture

Hi Kenneth, You've gotten a lot of good feedback already. I deal with a lower volume of documents but high access rates. Last year I moved the actual document storage to AWS using Bruno LeGay's component. Storing large numbers of actual documents in 4D isn't really feasible. Even if you use the 's

Re: Document capture

Arnaud, On Fri, Jan 26, 2018 at 7:34 AM, Arnaud de Montard via 4D_Tech < 4d_tech@lists.4d.com> wrote: > > > Le 26 janv. 2018 à 15:55, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> > a écrit : > > Even if you use the 'store outside of datafile' option the ba

Re: Document capture

Arnaud, On Fri, Jan 26, 2018 at 10:28 AM, Arnaud de Montard via 4D_Tech < 4d_tech@lists.4d.com> wrote: > > > Le 26 janv. 2018 à 18:49, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> > a écrit : > > > > Arnaud, > > On Fri, Jan 26, 2018 at 7:34 AM, Arnaud

  1   2   3   4   5   6   7   8   >