G
goo
Guest
Trigger procedURE FOR CREATE OF Owner.IdPerson should be Trigger procedure for create of Owner. Check manual: OpenEdge 11.7 Documentation Sendt fra min iPad 29. des. 2017 kl. 20:09 skrev miha56155136 : Update from Progress Community miha56155136 Dear Brian, I`m so sorry that you think that I offended you with my doubts - of couse you are proffy, what why I asked: why you suggest right tech solution and it must work, but I didn't caught working solution - of cause, I do something wrong. Please, if for you it not hard, explain me my mistake. First of all I changed my trigger. It's now look like: TRIGGER PROCEDURE FOR CREATE OF Owner.IdPerson. ASSIGN Owner.IdPerson = NEXT-VALUE(IdPerson_seq). And now I add in my project next code: /* Fragment 1 begin */ DEFINE VARIABLE iCurrentOwnerNum AS INTEGER NO-UNDO. ASSIGN iCurrentOwnerNum = CURRENT-VALUE(IdPerson_seq). FIND FIRST Owner NO-LOCK WHERE Owner.IdPerson = iCurrentOwnerNum NO-ERROR. /* Fragment 1 end */ /* Fragment 2 begin */ DEFINE VARIABLE oname NO-UNDO LIKE Owner.Name. DEFINE VARIABLE osurname NO-UNDO LIKE Owner.SurName. DEFINE VARIABLE otelefon NO-UNDO LIKE Owner.Telefon. DEFINE VARIABLE oemail NO-UNDO LIKE Owner.E_mail. INPUT FROM VALUE ("ownerData.txt"). REPEAT: CREATE Owner. IMPORT DELIMITER ";" Owner.Name Owner.SurName Owner.Telefon Owner.E_mail. oname = Owner.Name. osurname = Owner.SurName. otelefon = Owner.Telefon. oemail = Owner.E_mail. RELEASE Owner. FIND Owner NO-LOCK WHERE Owner.Name = oname AND Owner.SurName = osurname NO-ERROR. IF AVAIL ( Owner ) THEN DISPLAY Owner. END. /* Fragment 2 end */ Why Fragment 1 work without any problem (I hope - it show info: Procedure complete), but Fragment 1 and Fragment 2 didn't work correctly together. Now I have the result that was before. And I don't understand quite normal - why? View online You received this notification because you subscribed to the forum. To unsubscribe from only this thread, go here . Flag this post as spam/abuse.
Continue reading...
Continue reading...