MainForm with
1 tdbstring1 dataSource:ds fieldname:lib;
2 tdbstring2 dataSource:ds: fieldname:code;
3 tdbintegerdisp1 datasource:ds fieldname :ntiers;
4 tdbnav dataSource:ds with insert, edit,delete, filter...
DataModule with
1 IBC:tmseIbconnect ibo_embedded
DataBaseName:arts
2 transaction.
3 tmsesqlQuery
controller.option dso_autoapply true
dso_autocommitret true
SQL: select ntiers,lib ,code from tiers;
SQLINSERT:insert into tiers (lib) values (:lib);
code is default and ntiers is id
i
4. tsequencelink datafield :ntiers;
sequencename cpttiers
TRIGGER in database arts
SET TERM ^ ;
Alter Trigger CPTTIERS
ACTIVE
Before Insert
Position 0
AS BEGIN
IF (NEW.NTIERS IS NULL OR NEW.NTIERS = 0) THEN
NEW.NTIERS = GEN_ID(CPTTIERS, 1);
NEW.code ='C';
END ^
SET TERM ; ^
best regards
2014-06-11 9:28 GMT+01:00 Martin Schreiber <[email protected]>:
> On Wednesday 11 June 2014 09:14:16 Med Hamza wrote:
> > 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.
> >
> Please send a simple test project.
>
> 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
> [email protected]
> 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
[email protected]
https://lists.sourceforge.net/lists/listinfo/mseide-msegui-talk
