I forgot to tell that without setting controller.fields[n].providerflags1,
I can see generator item (id) which is the key of tmsequery. but the
others default values are null.
the generator is incremented by 2 instead of 1 I manage that with
tsequencelink.
I have autoapply/autocommitret to true.
Best Regards
Med.
2014-06-10 6:50 GMT+01:00 Martin Schreiber <mse00...@gmail.com>:
> On Monday 09 June 2014 16:28:26 Med Hamza wrote:
> > Now the trigger does not get fired immediatly .
>
> Are you sure? I assume the trigger is fired but you don't see the default
> value after INSERT statement because it has been generated server side.
>
> > I can show the fields
> > default values after closing and reopening the dataset?
> >
> Use a persistent field of tmsesqlquery, activate
> <tmsesqlquery>.controller.fields[n].providerflags1 pf1_refreshinsert then
> the
> INSERT statement will use the RETURNING clause in order to fetch the
> generated value from server.
>
> Martin
>
>
> ------------------------------------------------------------------------------
> HPCC Systems Open Source Big Data Platform from LexisNexis Risk Solutions
> Find What Matters Most in Your Big Data with HPCC Systems
> Open Source. Fast. Scalable. Simple. Ideal for Dirty Data.
> Leverages Graph Analysis for Fast Processing & Easy Data Exploration
> http://p.sf.net/sfu/hpccsystems
> _______________________________________________
> mseide-msegui-talk mailing list
> mseide-msegui-talk@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/mseide-msegui-talk
>
------------------------------------------------------------------------------
HPCC Systems Open Source Big Data Platform from LexisNexis Risk Solutions
Find What Matters Most in Your Big Data with HPCC Systems
Open Source. Fast. Scalable. Simple. Ideal for Dirty Data.
Leverages Graph Analysis for Fast Processing & Easy Data Exploration
http://p.sf.net/sfu/hpccsystems
_______________________________________________
mseide-msegui-talk mailing list
mseide-msegui-talk@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mseide-msegui-talk
