//discuss.4d.com/pub/frequently-asked-questions>
--
Arnaud de Montard
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mail
Hi,
direct link is <https://discuss.4d.com>
--
Arnaud de Montard
> Le 4 mars 2024 à 18:32, Jody Bevan via 4D_Tech <4d_tech@lists.4d.com> a écrit
> :
>
> Hello Ferdinando:
>
> This list is really not used anymore.
>
> I would recommend that yo
Hi Ferdinando,
schematicaly:
selection to arrays (ID, name, surname, date of birth, sex)
for($i;size of array;1;-1)
if (values $i # values $i-1)
remove from arrays
end if
end for
query with array (arrayIDs)
and you have the duplicates
--
Arnaud
> Le 22 oct. 2022 à 12:04,
> Le 27 janv. 2022 à 22:55, Alan Tilson via 4D_Tech <4d_tech@lists.4d.com> a
> écrit :
>
> Hello Keisuke,
> You make it sound simple, so how do I "parse the xml"?
> Open it in a text editor and search for "reject null values"?
> Thanks!
Hi Allan,
it seems to be "never_null".
But if you
e listbox based on array, when i insert one row in the 5
> arrays contained in the list box, i have a red message in the list box area
> with this message " 4d wIEV PRO LICENCE REQUIRED
I suppose you're using a command or some property that requires that license,
see here:
<ht
use assert:
for ($i;1;...)
assert($i#1;"stop on first iteration only")
end for
Another cool thing with assert is you can alt+clic on the "Continue" button in
the dialog; it means "ignore all comming false asserts for this process". I
tend to use ASSERT much more tha
> Le 15 janv. 2021 à 16:54, Neil Dennis via 4D_Tech <4d_tech@lists.4d.com> a
> écrit :
>
> My last complaint, and it is minor is that I use dark mode on my computer.
There is a dark mode setting in 4d discuss preferences.
--
Arnaud
It works the other way round :-)
--
Arnaud de Montard
> Le 15 janv. 2021 à 13:17, Jeremy Roussak via 4D_Tech <4d_tech@lists.4d.com> a
> écrit :
>
> I have all non-English conversations muted as well, but I’m still given the
> opportunity to test my rusty schoo
s that [table] will probably inflate/deflate:
save, process, delete… Even if the documents have to be processed later, I
think I'd move them to a folder on server rather than in the data.
--
Arnaud de Montard
**
4D Internet
between macOS and smb shared volumes. Everything's
fine when I copy another way (ftp, for example.)
--
Arnaud de Montard
**
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/m
y move doc into the path.
I do like this and strongly recommend it. But don't expect it guarantees the
target shared folder will be here when you move files from local to shared, you
just reduce the time you need it to be here. Shared volumes on a 4D server are
my personal nightmare, specially
s
48862725,2287590)
- uuid: no limit about the encoded number, but I don't know if performances are
better than real
--
Arnaud de Montard
**
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d.com/archives.html
Options: h
ex based on a "fixed length" field is always more
efficient (search, update…) than one based on a "variable length" field.
--
Arnaud de Montard
**
4D Internet Users Group (4D iNUG)
Archive: http://li
lds than longitude, make some tests and analyse
query plan/query path to see if that index is required.
--
Arnaud de Montard
**
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d.com/archives.html
Options: https://
er they say, knowing that we did not made
great efforts for that use.
--
Arnaud de Montard
**
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:4d_tech-unsubscr...@lists.4d.com
**
, while using uuid gives a good distribution (the opposite would be
unexpected and boring…). If you're interested, there's a link to a small test
4db at the bottom of the tread, it's quite easy to add another generator and
try it.
>
> Someone has a suggestion.
It may change nothing to this problem, but first I'd move to 13.5 or 13.6.
What is different since "some days": more data, more clients, nothing..?
--
Arnaud de Montard
**
4D
s
custom date formats.
Any idea?
--
Arnaud de Montard
**
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:4d_tech-unsubscr...@lists.4d.com
**
For each ($test_t;$test_c)
ASSERT(Match regex($rx_t;$test_t;1;$pos_al;$len_al))
End for each
I'm not sure the starting anchor "^" suits your case, it depends on how you
manage the method. For my own, I alway
> Le 4 déc. 2019 à 10:55, Jeremy Roussak via 4D_Tech <4d_tech@lists.4d.com> a
> écrit :
>
> On 4 Dec 2019, at 08:26, Arnaud de Montard via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
>>
>> Hi Peter,
>> I'm not sure it always works on mac, becaus
Not only 4D (page seems old, but you get the idea):
<https://gabriel.nagmay.com/2009/09/firefox-respects-macintosh-preferences-disrespects-users/>
--
Arnaud de Montard
**
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d
ecord) in the
> highlighted selection and apply this value.
Hi,
schematically, I do this:
save selection
use userset
selection to array
replace values in array
array to selection
use selection
highlight userset
--
Arnaud de Montard
*
ERROR CALL method, after a while I put that
method back in the host :-(
Maybe I missed something, like using an object reference in v17…
--
Arnaud de Montard
**
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d.com/arch
that note. When 4D does not recognise me I delete all cookies
containing "4D", usually it stops being blind and deaf.
--
Arnaud de Montard
**
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d.com/ar
title_t)
LISTBOX DELETE COLUMN(*;$LBname_t;1)
End for
--
Arnaud de Montard
**
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:4d_tech-unsubscr...@lists.4d.com
**
adsheet, insert a single quote (or use some "0"
format once opened in spreadsheet)
- to transfer data to another system, nothing to change
As Dani, I avoid the use spreadsheet to control a csv, the "automatic cell type
recognition" (text, num, bool…) will o
e.
To query with array, another solution:
<https://forums.4d.com/Post/FR/13701036/1/13701037#13705082>
--
Arnaud de Montard
**
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d.com/archives.html
Options: https://lis
s. If it's the former, I'd suggest the use of GET TEXT KEYWORDS to
produce 2 arrays of words to compare. In the resulting array words keep ordered
as in the text, it may help if the wanted match is the sequence of words.
\r", but that just inserted those specific characters.
> :)
Hi Chip,
you may write a macro for that, schematically:
- open method, select the line, execute macro
- macro method reads the line, makes what you want, replaces the original.
I did something like that to tran
> Le 23 juil. 2019 à 14:53, Koen Van Hooreweghe via 4D_Tech
> <4d_tech@lists.4d.com> a écrit :
>
> I personally do prefer PDF Viewer instead of picture fields or web areas (on
> mac).
Another solution here:
<https://forums.4d.com/Post/FR/28377705/1/30106287#28403909
(BBEdit, notepad c++…) there's an option in the "save as"
to add it or not.
--
Arnaud de Montard
**
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailma
stbox "flavours" (selection, collection or entity sel).
--
Arnaud de Montard
**
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Uns
b Lavaux's XL plugin, the demo mode is enough for your need (and it's
worth it):
<https://www.pluggers.nl/product/xl-plugin/>
--
Arnaud de Montard
**
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d.com/archives
s already supposed to…
More generally, I don't know if your client can hear that, but he should be
sensitized to prepare the near future. I'm moving many apps on 17R4 because
it's 32+64, write plugin works and write pro is mature.
--
: ($in_l=Page down key)
$out_l:=0x21DF
Else
$out_l:=Character code("¿") //unknown
End case
End if
$0:=$out_l
//_
++
--
Arnaud de Montard
**
clean and safe
code."
Documented = more than safe ;-)
--
Arnaud de Montard
**
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:4d_tech-unsubscr...@lists.4d.com
**
ET ( docRef ; receptBlob ; aLotOfBytesButNotTooMuch )
but it depends what's your goal. I had to use that with huge text document to
import. Even in 64bits, the limit is about 1Gb (I suppose the documentation 2Gb
limit means bytes, not chars).
rface and want to
print it… then you realise that many printing commands use "legacy" selection /
current record.
--
Arnaud de Montard
**
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d.com/archives.
ke command naming starting with a verb
when the chapter offers an obvious prefix (as listbox, web services, dom, etc).
I'm tired to go through the whole Köchel catalog to find an unpredictable
command name.
--
Arnaud de Montard
ructure
> digram I need using either of these. Surely there are database schema
> [structure] diagram printing applications out there someplace that someone
> has used successfully. I am also open to 4D based solutions.
See this Vincent's contribution:
<https://forums.4d.com/Post/FR
FR/28377705/1/28639612#28403909>
Strangely, using right click to print, the pdf document is printed 50% reduced
at center of page: any idea, someone?
--
Arnaud de Montard
**
4D Internet Users Group (4D iNUG)
Archive: ht
ar as I can remember when a friend showed
me, this plugin allows to work in a very similar way to Print object.
--
Arnaud de Montard
**
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d.com/archives.html
Options: ht
and let the command do the
rounding job. And once printed, a pixel is small (~0.35mm)…
Strangely I've noticed that GET MOUSE(x;y;b) returns x & y as real numbers:
something to do with retina? Else?
--
Arnaud de Montard
would need to adjust the result?
Yes too ;-)
--
Arnaud de Montard
**
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:4d_tech-unsubscr...@lists.4d.com
**
ERT FROM TEXT($string;$charset;$blb)
$string2:=Convert to text($blb;$charset)
$offset:=4
$hex2:=Substring($string2;1;$offset)
$len2:=hexaToDecimal ($hex2)
$hello2:=Substring($string2;$offset+1;$len2)
ASSERT($len2=$len)
ASSERT($hex2=$hex)
ASSERT($hello2=$hello)
--
Arnaud de Montard
**
s from Bruno Legay about epoch in the code
sharing zone:
<https://forums.4d.com/Post/FR/19709356/1/19709357#19709357>
<https://forums.4d.com/Post/FR/19709356/1/19709357#19710119>
--
Arnaud de Montard
**
4D Internet Users Gro
od in the
context of the form… In a recent 4d training, someone told me he had replaced a
lot of "On timer" old code with it.
--
Arnaud de Montard
**
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d.com/
that will not allow to
get the table easily (tooth/teeth, story/stories, fish/fishes)
--
Arnaud de Montard
**
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/opt
oc.4d.com/4Dv17R4/4D/17-R4/Entity-selections.300-4085815.en.html>
"Entity selections can be "sorted" or "unsorted" (this point is discussed
below)"
and the § "Ordered vs Unordered entity selections"
I suppos
isplayed to client but not considered as code
that you can trace. You should try the usual shortcut (alt+cmd+right click) in
that window, I'm quite sure trace will occur on next line of code.
--
Arnaud de Montard
**
4D Intern
llows to identify the function is great:
find regex("^FK_";property;1) -> foreign key
find regex("_p$";property;1) -> many to one relation
And these names are not supposed to change every day…
--
Arnaud de Montard
***
ent.
For example this table:
[Human]
PK
FK_humanFather
FK_humanMother
Relations:
from PK to FK_humanFather: humanFather_f
from PK to FK_humanMother: humanMother_f
from FK_humanFather to PK: human_p, father_p, etc.
from FK_humanMother to PK: human_p, mother_p, etc.
--
Arnaud de Mon
ed)
on timer
set timer(0)
job.do(please)
set timer(jobPostponed)
end case
Thinking after, there is surely more events to consider (On click, double clic,
menu, etc.)
--
Arnaud de Montard
**
4D Internet Users
lay a form
is dialog, dialog or dialog.
--
Arnaud de Montard
**
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:4d_tech-unsubscr...@lists.4d.com
**
$out_l:=Character code("¿") //unknown
//$out_l:=0x2328
End case
End if
$0:=$out_l
//_
+
I use it this way:
$buttonTitle:=:="Validate "+Char(UI_KeyboardGetChar (Enter key))
OBJECT SET TITLE(*;"buttonName";$buttonTitle)
--
Arnaud de Montard
data is very small, time to ask server to run the method and time to get that
little data will be the same. Some times:
- using SQL ~ 250 ms 1st time, then ~60 ms (I don't know why 1st time is
longer, BTW)
- loop ~ 9 ms (and the server can do something better for other clients)
--
away): using
system tables with SQL involves a request to the server, that ugly loop
doesn't. And if you compile it in a component it's reduced to nothing…
--
Arnaud de Montard
**
4D Internet Users Group (4D iNUG)
A
table and check if a
relation exists for the current one (as above).
--
Arnaud de Montard
**
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
U
heet
/ paste in 4D than export the document as csv and open it after. They do like
it.
--
Arnaud de Montard
**
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailm
umbers, I can add
or subtract easily. BTW date and time in a spreadsheet are of the same family:
a number where integer portion = day and fractional portion = hour.
--
Arnaud de Montard
**
4D Internet Users Group (4D iNUG)
resulting char could vary, depending on the OS "flavour"
(see bottom of list, many codes were represented on mac with no equivalent on
windows).
In unicode, one code = one char and, definitely, 165 is "¥" and 0x2022 is "•".
--
Arnaud de Montard
***
there was a nice example of tab control made in svg in the "svg goodies" demo.
--
Arnaud de Montard
**
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailm
ign "shared parts" of UI.
--
Arnaud de Montard
**
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:4d_tech-unsubscr...@lists.4d.com
**
hods, often a prefix representing a group of the same "module"…
--
Arnaud de Montard
**
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:4d_tech-unsubscr...@lists.4d.com
**
orks already on server side… If we had events
triggered (add, modify, delete) by structure objects (methods, forms) on server
too, life would be simple.
--
Arnaud de Montard
**
4D Internet Users Group (4D iNUG)
Ar
sive.
Did you check there is no duplicate names at runtime (FORM GET OBJECTS)?
--
Arnaud de Montard
**
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
U
xed here:
<https://bugs.4d.fr/fixes?version=16.1_HF2>
--
Arnaud de Montard
**
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:4d_tech-unsubscr...@lists.4d.com
**
TO ARRAY($ut_at;"aa")
APPEND TO ARRAY($col_al;702)
APPEND TO ARRAY($ut_at;"zz")
APPEND TO ARRAY($col_al;703)
APPEND TO ARRAY($ut_at;"aaa")
APPEND TO ARRAY($ut_at;"aaa")
APPEND TO ARRAY($col_al;1024)
For ($i_l;1;Size of array($col_al))
$ref_t:=Utl_sp
)
Sannyasin,
• using on display detail will call the server every time a record is displayed
and will result in a very slow list (not to say insupportable if you access
server through WAN)
• using SET AUTOMATIC RELATIONS, lines content are calculated on ser
tamp.301-3730728.en.html>
>
> https://blog.4d.com/timestamp-is-now-available/
> <https://blog.4d.com/timestamp-is-now-available/>
I had forgotten :-(
--
Arnaud de Montard
**
4D Internet Users Group (4D iNU
t in seconds:
<http://forums.4d.com/Post/FR/14701949/1/14701950#14928049>
--
Arnaud de Montard
**
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailma
pe Daylight Saving
Time (DST) could be abandoned next year - good for 4D.
--
Arnaud de Montard
**
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_t
At each time change, the alert throws: server not updated, I
have to restart it. I don't know if this bug is corrected and, if it is, since
when.
--
Arnaud de Montard
**
4D Internet Users Group (4D iNUG)
Archive: http://list
nk in a browser as well.
Firefox works, AFAICR.
Another problem will come with CSM in v17: nice new format but no anchors…
--
Arnaud de Montard
**
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d.com/archives.h
old stuff (tables, forms, etc.) will be deleted after the new app is
released.
--
Arnaud de Montard
**
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/
a set. I notice
> that set is visible to the client as well.
EoS method and trigger are executed in the same twin process, see "Execution
Context" here:
<http://doc.4d.com/4Dv17R2/4D/17-R2.1720/Execute-on-Server-attribute.300-3925945.en.html>
t set shortcut (*;"allNamedTheSame"; Shortcut with Carriage Return) ;-)
I noticed this works better with all keyboards than hardcoded setting (legacy
dialog)
--
Arnaud de Montard
**
4D Internet Users Group (4D iN
> Le 9 oct. 2018 à 17:50, Jody Bevan via 4D_Tech <4d_tech@lists.4d.com> a écrit
> :
>
> [...]
> 1. Is this the right location I should be saving this kind of information?
Unless it represents a huge amout of data / traffic, I think I'd choose to
write this on server
imal_Link..Animal
This use of RELATE ONE SELECTION is not documented but works (or used to work,
it's a while since I didn't try)
--
Arnaud de Montard
**
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d.com/arc
(the object says it all)
--
Arnaud de Montard
**
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:4d_tech-unsubscr...@lists
should have access to this:
>> http://kb.4d.com/assetid=78020
>
> Hmm, I went to Summit in Paris and do not have access to the article.
Do you have many mail adresses?
If I use the registered email, it works.
--
Arnaud de Montard
se ;-)
append text to file
set text array to zero
end if
end loop
- see also >http://forums.4d.com/Post/FR/19466463/1/19466704#19466704>, I
didn't test
--
Arnaud de Montard
**
4D Internet Users Group (4D
amount of text can be hold this way, very fast.
About the 2Gb limit of text, I noticed the limit in number of chars is about
the half.
--
Arnaud de Montard
**
4D Internet Users Group (4D iNUG)
Archive: http://lists.4
When I use 4dv16r6, I'd like the alt clic shortcut on a command to open the
good version of doc.
Of course not, it drives me nuts.
Any idea?
Where are documented the links we can use?
--
Arnaud de Montard
**
4D Internet
ey were not recognised. I may be wrong but I suppose formulas and editor rely
on common stuff…
--
Arnaud de Montard
**
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d.com/archives.html
Options: https://lists.4
", like SQL or html…). I
used the code under to establish the bad names list
<http://forums.4d.com/Post/FR/14532263/1/14536260#14536260
<http://forums.4d.com/Post/FR/14532263/1/14536260#14536260>>
then I began to rename…
(note: such a "mass" renami
> Le 6 sept. 2018 à 08:20, Arnaud de Montard via 4D_Tech <4d_tech@lists.4d.com>
> a écrit :
>
> Hi Tim,
> I did not get your first response from the list. No matter as I can read it
> cited under Richard's response, but I wonder about that gap??
oops I'm wrong
the interpreter):
<https://screencast.com/t/VUhPZ4PI <https://screencast.com/t/VUhPZ4PI>>
why line 6 is not recognised?
I thought I could put anything before the token, but it sounds like I have to
use the hardcoded table name or the wildcard, and n
Hi Tim,
I did not get your first response from the list. No matter as I can read it
cited under Richard's response, but I wonder about that gap??
--
Arnaud de Montard
**
4D Internet Users Group (4D iNUG)
Archive: http
/ use wildcard:
TimeStampToText ([@:2]@:3)
Surely something to do with dot notation, but I wonder if it's a bug or
something I miss?
--
Arnaud de Montard
**
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d.com
le]longint=Num("123xxx")
We are not surprised that values = 123 are found. If you consider that 4D uuid
field is a 2^128 integer (scalar number), it's the same thing that happens to
your trailing "xxx" and those above.
BTW, I think that uuid fields with an alpha icon in structure it is
> Le 16 août 2018 à 01:29, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> a
> écrit :
>
> interpretably it does work - with locals!
>
> tomorrow Ill try compiled...
Second syntax of MULTI SORT ARRAY does not work
code :-)
BTW, it seems finally you use a picture var over the cell? Makes me think that
besides getting blind, my english is ununderstandable ;-)
<http://kb.4d.com/resources/inug?msgid=GmailId165352a46312ce6a
<http://kb.4d.com/resources/inug?msgid=GmailId165352a4631
d.com/Post/FR/12933938/2/15016907#15016907>>
--
Arnaud de Montard
**
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:4d_tech-unsubscr...@lists.4d.com
**
always missed a *fixed* line spacing in the plugin: does it exist
in write pro?
--
Arnaud de Montard
**
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:4d_tech-unsubscr...@lists.4d.com
**
coordinates, same picture, could work.
--
Arnaud de Montard
**
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:4d_tech-unsubscr...@lists.4d.com
**
they found refuge in an ice cream shop.
--
Arnaud de Montard
**
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:4d_tech-unsubscr...@lists.4d.com
**
/blog.4d.com/detailed-analysis-database-structure/>
• on 4DBB, search for "flatStructure" (off today, I can't paste a link), it's a
component that gets xml, converts it to object, then reads table, fields,
relations and indexes from it.
--
Arnaud de Montard
*
,
comments TEXT,
PRIMARY KEY (PK)
);
/* indexes */
CREATE INDEX idx1 ON Agence (PK);
CREATE INDEX idx2 ON ContactAgence (PK);
/* relation */
ALTER TABLE ContactAgence ADD CONSTRAINT rel1 FOREIGN KEY (FK_agence)
REFERENCES Agence (PK);
++
Note: I never create such relations…
e adapted for object fields.
--
Arnaud de Montard
**
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:4d_tech-unsubscr...@lists.4d.com
**
1 - 100 of 406 matches
Mail list logo