[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: How to add datavalue into database from text file

  • Thread starter Thread starter rayherring
  • Start date Start date
Status
Not open for further replies.
R

rayherring

Guest
There are a couple of problems I can see, for one, the 'INPUT FROM' doesn't look right, the other issue is that you have commas in your 'IMPORT' statement, which is what the thing is complaining about (notice how the error says 'Unable to understand after -- "DELIMITER ; oname", what that is saying is that something after that statement is confusing it (in this case the comma). On a working one that I have, I do INPUT FROM VALUE ("filename"). In your case, that would be INPUT FROM VALUE ("ownerData.txt") (you may need to give it the full path if it isn't in your propath). Once I have done that, I use a 'REPEAT' statement to loop through every line in the file, and 'IMPORT' them into what I want. In your case, you could probably get away with just doing: REPEAT: IMPORT DELIMITER ";" oname osurname otelefon oemail. DISPLAY oname osurname otelefon oemail. END. For an 'Import' statement (and certain other ones), I like to put each variable on its own line, just so I can read things easier.

Continue reading...
 
Status
Not open for further replies.
Back
Top