M
miha56155136
Guest
I'm so sory for my silly question - I just start to study Progress and have no many best practic examples for my target. I created code follow your instructions: 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. I hope it's work, but I receive unexpected result. I have sequence (IdDogOwner_seq), that must authomatly create ID record. In my database, that was created in Data Dictionary, I aready have the Trigger procedure for my ID sequence: TRIGGER PROCEDURE FOR ASSIGN OF Owner.IdPerson. ASSIGN Owner.IdPerson = NEXT-VALUE(IdPerson_seq). End for result database didn't create next record and next sequence value, wrote that Owner is already exist with IdPerson 1. Why sequence didn't add next value for next record? Procedure result in Image
Continue reading...
Continue reading...