this used to be possible.
what happens when an older structure with a self referential relation is
upgraded?
>> how do I draw a self-referential relation?
> You cannot make a single field both the primary and foreign keys of a
> relation. You must choose two different fields.
> For example,
> how do I draw a self-referential relation?
You cannot make a single field both the primary and foreign keys of a relation.
You must choose two different fields.
For example, you can make [Table_1]Field1 related to [Table_1]field2
Reminder: the fields must be compatible with each other as you
How do you create a self referential relation?
in older versions you could drag the relational arrow back to the same
field to get a 'loop'
This does not work now, and I tried to modify the system tables but
these are locked, and I can not get them to unlock.
2 questions:
- how do I draw a
Hi Lutz,
Sorry to bug you again, but we’re moving forward on a project where we are
consulting with a client who is setting up an agile development team to use 4D.
They will be managing this team with Microsoft Team Foundation Server. I’m
thinking that TFS should be able to serve as a
Solved…
Thank to all that gave me pointers & suggestions !!
> $tDocRef:=Open document($DocPath_t;”*";Read mode)
>
> this is the point when I get the “file not found” error message.
>
> what am I missing….. ?
the error was right after the “open document” command
where I do a "Document to
Thanks!
on the first look it would appear to be simpler/faster to use Sql.
On Thu, 10 Jan 2019 21:15:48 +0100, Arnaud de Montard via 4D_Tech wrote:
>
>> Le 10 janv. 2019 à 20:21, cjmiller--- via 4D_Tech
>> <4d_tech@lists.4d.com> a écrit :
>>
>> You could run it on server
>
> Running a
> Le 10 janv. 2019 à 20:21, cjmiller--- via 4D_Tech <4d_tech@lists.4d.com> a
> écrit :
>
> You could run it on server
Running a method on server is great if there a lot of data to read and/or
write, because it avoids the transfer of these data through network. Here the
data is very small,
You could run it on server
Regards
Chuck
Sent from my iPhone
> On Jan 10, 2019, at 2:10 PM, Arnaud de Montard via 4D_Tech
> <4d_tech@lists.4d.com> wrote:
>
>
>> Le 10 janv. 2019 à 19:52, Charles Miller via 4D_Tech <4d_tech@lists.4d.com>
>> a écrit :
>>
>> You can use data form the
> Le 10 janv. 2019 à 19:52, Charles Miller via 4D_Tech <4d_tech@lists.4d.com> a
> écrit :
>
> You can use data form the following two 4d tables without having to
> loop through each of your tables/fields [...]
Yes, but it's always slower in C/S (specially when it's far far away): using
system
You can use data form the following two 4d tables without having to
loop through each of your tables/fields
_USER_CONSTRAINTS
and
_USER_CONS_COLUMNS
. You can find these defined on page 57 or so iof the v_15 sql reference manual
Regards
CHUCK
On Thu, Jan 10, 2019 at 11:01 AM Arnaud de
Thanks Arnuad,
however, that will work, but requires a bunch of 'work'.
Thanks to Keisuke, again :), his query component contains code that
pulls all relations ENDING (where the current field of parent table is
the many of a one to many relation). without having to troll through
the entire
In prior versions of 4D one of my favorite uses of array based listboxes is
for displaying lists of things and including a variable the user could type
into to filter the list as they typed. The technique involved two things:
the listbox had a 'hidden' array specified
the code for the search
Hi,
Something else to try is maybe running as Administrator. Perhaps it is a
permissions issue.
Also where is the file located? Maybe you can try a simple new file on the
desktop and call it with a simple hardcoded method to make sure it works in the
first place to confirm it may have
> Le 8 janv. 2019 à 21:47, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> a
> écrit :
>
> given a pointer to a table, or a pointer to a field of a table,
> I want to be able, for the current record of this table, to :
Hi Chip,
I use this for foreign keys:
//DB_getForeignKeys (aTable_p)
Hi Ernie,
Just a wild guess. Could you try without the "*"? Use an empty string or even
remove the second parameter (it is optional).
$tDocRef:=Open document($DocPath_t;Read mode)
Are you building with the same desktop volume version?
Have you tried compiled against 4D developer (without
Using 4D v15.6 on pc W7
Made a small program, no fields are used, no tables are used or present
all memory based and there is a “datafile” because 4D requires that.
When running during interpreted and compiled, and open 1 particular file, using
cmd “open document”
there is no error message and
16 matches
Mail list logo