Interesting ...
Suppose I wanted to add a function to my 4D app to allow end-users to
create new tables. This presumably could be accomplished using XML and
METHOD SET CODE.
Now, we release a program update. Any tables added by the end-user could be
recovered using GET MISSING TABLE NAMES and
Pat,
Not in the XML, but you could import the table structure (with trigger
properties enabled) and then set the trigger code using METHOD SET CODE. My
approach would be to enable all the trigger properties even if there is not an
immediate need to have a trigger. I don't think there is any
John,
Can you set the trigger code that way as well (using XML)?
Pat
On Sat, 23 Jun 2018 at 21:04, John DeSoi via 4D_Tech <4d_tech@lists.4d.com>
wrote:
> The triggers won't run until you set the trigger properties on the table.
> I'm not aware there is any way to do that via SQL. You can set the
The triggers won't run until you set the trigger properties on the table. I'm
not aware there is any way to do that via SQL. You can set the trigger
properties if you create the tables via XML and use IMPORT STRUCTURE.
John DeSoi, Ph.D.
> On Jun 23, 2018, at 11:52 AM, Jody Bevan via 4D_Tech
: Jody Bevan
Subject: Re: Creating Tables by running a method
Randy:
So I have got this done using all SQL. At the end it would create the indexes
for the first table I created, but then fail for al the next. Eventually I
figured out that the index name (behind the scenes) need to be unique withi
Randy:
So I have got this done using all SQL. At the end it would create the indexes
for the first table I created, but then fail for al the next. Eventually I
figured out that the index name (behind the scenes) need to be unique within
the whole database. Therefore I just added a string of
Software LLC – XC2LIVE!
>
> -Original Message-
> From: 4D_Tech <4d_tech-boun...@lists.4d.com
> <mailto:4d_tech-boun...@lists.4d.com>> On Behalf Of Jody Bevan via 4D_Tech
> Sent: Friday, June 22, 2018 10:45 AM
> To: 4D iNug Technical <4d_tech@lists.4d.com &
Pat:
We have rarely used a trigger, but it is an important thing to know in going
into it. Thanks for telling me. At least I will not spend a week trying to get
a trigger into a table I have created this way. One never knows what they will
be doing, or need in the future. Life has certainly
...@lists.4d.com> On Behalf Of Jody Bevan via
> 4D_Tech
> Sent: Friday, June 22, 2018 10:45 AM
> To: 4D iNug Technical <4d_tech@lists.4d.com>
> Cc: Jody Bevan
> Subject: Creating Tables by running a method
>
> I know that this feature has been around for a long time
; On Behalf Of Jody Bevan via 4D_Tech
Sent: Friday, June 22, 2018 10:45 AM
To: 4D iNug Technical <4d_tech@lists.4d.com>
Cc: Jody Bevan
Subject: Creating Tables by running a method
I know that this feature has been around for a long time ~ 4D 2011.
I am now using 16R6. I now have a method that
t;4d_tech-boun...@lists.4d.com> On Behalf Of Jody Bevan via 4D_Tech
Sent: Friday, June 22, 2018 10:45 AM
To: 4D iNug Technical <4d_tech@lists.4d.com>
Cc: Jody Bevan
Subject: Creating Tables by running a method
I know that this feature has been around for a long time ~ 4D 2011.
I am
I know that this feature has been around for a long time ~ 4D 2011.
I am now using 16R6. I now have a method that creates a table with the fields I
want added.
The challenge I am having is setting indexes (and index types), as well as
Primary Keys.
I looked in the Knowledge Base for code
12 matches
Mail list logo