Re: Printing structures

2019-10-03 Thread Patrick Emanuel via 4D_Tech
Hi Tom, should be good if you're able to share it here ;-) Cheers Patrick - Patrick EMANUEL Administrator www.association-qualisoft.eu (Soft1002, Simply Asso & QS_Toolbox) -- Sent from:

Re: Printing structures

2019-10-03 Thread Tom Benedict via 4D_Tech
Another possibility is to export an SQL Script which will can be imported into any number of data modeling tools (or even things like Visio). In the data modeling tool you can move stuff around and reformat as you wish. I have a method to generate a SQL Script if you are interested. Tom

Re: v15 - Array Object and Append array

2019-10-03 Thread Keisuke Miyako via 4D_Tech
objects are references, so you can't use the same object over and over again, as if they point to different things. bad code: ARRAY OBJECT($oo;0) C_OBJECT($o) For ($i;1;3) OB SET($o;"value";$i) APPEND TO ARRAY($oo;$o) End for good code #1: ARRAY OBJECT($oo;0) C_OBJECT($o) For ($i;1;3) OB

Re: Printing structures

2019-10-03 Thread Keisuke Miyako via 4D_Tech
for what it's worth, I've put out an XML to SVG example here: https://github.com/miyako/4d-utility-structure-to-svg-converter-v2 --- the native exported HTML is supposed to look like this: https://imgur.com/RGfiPq5 however, because cross reference of XSL is blocked be default in Safari,

Re: Foundation Shell

2019-10-03 Thread Walt Nelson via 4D_Tech
Not to worry. I am rebuilding the Foundation website and it should be back up in another week or so. Thanks, Walt www.foundationshell.com > On Oct 2, 2019, at 3:21 PM, Douglas von Roeder via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > Please keep us posted. Foundation is part of the 4D

Re: 4D ODBC, MS SQL and Alpha Fields

2019-10-03 Thread Tom Benedict via 4D_Tech
I second Chuck’s comment about 4D -> SQL Server via ODBC being much easier, stable etc than SQL Server -> 4D via ODBC. I know that probably doesn’t help, but if you have the option to change your architecture it would make life much easier. Tom Benedict > On Oct 3, 2019, at 10:22, Charles

Nevermind - Re: v15 - Array Object and Append array

2019-10-03 Thread Chip Scheide via 4D_Tech
never mind - of course the below fails to fill the array. as I was replying to Peter's post I realized... the loop inserts a new element at position 1 BUT OB Set is acting on element $i DUH! Chip On Thu, 3 Oct 2019 23:36:32 +0200, Peter Bozek wrote: >> >> in a loop >> For ($i;1;$Column_Count)

Tracking Object properties

2019-10-03 Thread Chip Scheide via 4D_Tech
I am starting to replace my current listbox management which uses 3 tables, - Listbox definitions - column definitions - query definitions My initial design is: - listbox definition table - identifiers, object field which contains both the listbox definition, and column defintioins I find I

Re: v15 - Array Object and Append array

2019-10-03 Thread Peter Bozek via 4D_Tech
On Thu, Oct 3, 2019 at 10:55 PM Chip Scheide via 4D_Tech < 4d_tech@lists.4d.com> wrote: > ok.. > why does this not work??? > > in a loop > For ($i;1;$Column_Count) > INSERT IN ARRAY($Columns;1) > OB SET($Columns{$i};) > end for > How it could? Line INSERT IN ARRAY($Columns;1) tries to

Re: v15 - Array Object and Append array

2019-10-03 Thread Jeremy Roussak via 4D_Tech
Chip, At a guess, because after INSERT IN ARRAY, $Columns{$i} is Null rather than {}. Try $Columns{$i}:=New object before the OB SET; or replace it with $Columns{$i}:= New object () Jeremy > On 3 Oct 2019, at 21:55, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> > wrote:

Re: v15 - Array Object and Append array

2019-10-03 Thread Kirk Brooks via 4D_Tech
Chip, On Thu, Oct 3, 2019 at 1:55 PM Chip Scheide via 4D_Tech < 4d_tech@lists.4d.com> wrote: > ok.. > why does this not work??? > > in a loop > For ($i;1;$Column_Count) > INSERT IN ARRAY($Columns;1) > OB SET($Columns{$i};) > You said you wanted to append an array so you would use: OB SET

Re: v15 - Array Object and Append array

2019-10-03 Thread Chip Scheide via 4D_Tech
ok.. why does this not work??? in a loop For ($i;1;$Column_Count) INSERT IN ARRAY($Columns;1) OB SET($Columns{$i};) end for the first iteration is fine, and the $Columns{1} is assigned the correct properties and values. However, the second loop results in $Columns{2} containing the

Re: v15 - Array Object and Append array

2019-10-03 Thread Chip Scheide via 4D_Tech
I was not doing this. I see... said the blind man as he picked up his hammer and saw... :) I was trying array object($Array;0) append to array($Array;) which did not work... Chip On Thu, 3 Oct 2019 22:43:35 +0200, Peter Bozek wrote: > On Thu, Oct 3, 2019 at 10:26 PM Chip Scheide via 4D_Tech <

Re: v15 - Array Object and Append array

2019-10-03 Thread Peter Bozek via 4D_Tech
On Thu, Oct 3, 2019 at 10:26 PM Chip Scheide via 4D_Tech < 4d_tech@lists.4d.com> wrote: > is it possible to use append array with an object array? > > I forgot - append to array works fine as well: ARRAY OBJECT($ao;0) C_OBJECT($o) OB SET($o;"property";$value) APPEND TO ARRAY($ao;OB COPY($o)) OB

Re: Printing structures

2019-10-03 Thread Mike Kerner via 4D_Tech
Has anyone tried exporting a structure in 17.3 to html (really xml/xsl), and opening it in a browser to render it? When I do that, it doesn't render. On Wed, May 8, 2019 at 6:43 PM Cannon Smith via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Hi Alexander, > > This is great! Thank you for sharing.

Re: v15 - Array Object and Append array

2019-10-03 Thread Peter Bozek via 4D_Tech
On Thu, Oct 3, 2019 at 10:26 PM Chip Scheide via 4D_Tech < 4d_tech@lists.4d.com> wrote: > is it possible to use append array with an object array? > > Sure, I started to use it in v15 and code seems to be working in v17 without problem > I was playing, and I do not see a way to get this to

Re: v15 - Array Object and Append array

2019-10-03 Thread Chip Scheide via 4D_Tech
it loos like an alternative to Append to Array is: array object($Array;0) insert in array($array;1) ob set($array{1}; ) Chip On Thu, 3 Oct 2019 13:28:24 -0700, Kirk Brooks via 4D_Tech wrote: > Chip, > > On Thu, Oct 3, 2019 at 1:26 PM Chip Scheide via 4D_Tech < > 4d_tech@lists.4d.com> wrote:

Re: v15 - Array Object and Append array

2019-10-03 Thread Kirk Brooks via 4D_Tech
Chip, On Thu, Oct 3, 2019 at 1:26 PM Chip Scheide via 4D_Tech < 4d_tech@lists.4d.com> wrote: > is it possible to use append array with an object array? > No. But you can with collections. To accomplish what you are describing you would need to create an object, set the array to the object and

v15 - Array Object and Append array

2019-10-03 Thread Chip Scheide via 4D_Tech
is it possible to use append array with an object array? I was playing, and I do not see a way to get this to work. Thanks Chip --- Gas is for washing parts Alcohol is for drinkin' Nitromethane is for racing ** 4D

folder structure in a hierarchical list box

2019-10-03 Thread Charles Miller via 4D_Tech
Hi all, 4D version is 15. has anyone coded this. For a variety of reasons we are trying to best show resource folder structure in a list box. We want to code for an unknown folder depth so that if we need to add a folder no additional coding would need be done. We are doing this as we have

Re: 4D ODBC, MS SQL and Alpha Fields

2019-10-03 Thread Charles Miller via 4D_Tech
can we see the entire sql statement you are using. What version of 4D? Lastly, If you can I have always found it easier to go from 4D to sql server. If you are on PC you already have odbc on PC if on mac you would have to buy odbc driver for sql server. I always use the one from actual

Question about sub- and superscripts in 4D Write Pro (WP) tables (4D172)

2019-10-03 Thread Harry Schulting via 4D_Tech
I have a form with a WP area with superscripts en subscripts. How can I show these superscripts en subscripts in a WP area in a WP Table cell? When using the command "WP Table append row" I am loosing the superscripts and subscripts because it does not accept a 4D write pro object as parameter

4D ODBC, MS SQL and Alpha Fields

2019-10-03 Thread Paul Jones via 4D_Tech
We pull data from 4D into MS SQL using the 4D ODBC Driver. On occasion, we have a problem with some Alpha fields where only the first 2 characters are pulled into SQL. In MS SQL, the associated field has been configure to use varchar(255) {or whatever the field length is for the 4D field}

Re: Web aficionados - Not allow user to access file directly

2019-10-03 Thread Keith White via 4D_Tech
Hi For the HTML markup files, I suggest using the extension .shtml rather than .html For us any direct request for a .shtml file will trigger On Web Authentication and you can catch and reject the request. Doing that allows you to keep things simpler in a single folder and you don't have to

Database … is write protected (AGAIN)

2019-10-03 Thread Piotr Chabot Stadhouders via 4D_Tech
Hi, 4D v17R5 64-bit, Windows We use a 4D Volume Desktop application in a Citrix environment It seems that in 64-bit there is no possibility to use a Virtual Store in Windows So, when launching our app for the second time, we get the message “Database … is write protected” This is strange