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:
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
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
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,
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
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
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)
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
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
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:
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
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
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 <
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
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.
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
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:
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
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
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
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
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
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}
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
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
25 matches
Mail list logo