M
miha56155136
Guest
Hello, everyone! I have the strong problem. I want to add data from file into my created database. But I din't undestand quite normal, how to do it. I have in database simple table Owner , that consist fields Owner.Name, Owner.SurName, Owner.Telefon, Owner.E_mail. And I have simple text file with data (ownerData.txt): Mike;Park;7655548622;mike.park@gmail.com Anna;Novak;34554123234;anna.novak@gmail.com I want to write this value into database, I use code: 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 ownerData. FOR EACH Owner: IMPORT DELIMITER ";" oname, osurname, otelefon, oemail. DISPLAY oname osurname otelefon oemail. END. INPUT CLOSE. But it didn`t work. OpenEdge Developer Studio told, that problem with line in code, where is delimiter. You can to see in images in attached file I don't resolve this problem so long time. Anyway, how to easy add data value from file into database using procedure and method? Thank you for you help!
Continue reading...
Continue reading...