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