Search results

  1. J

    Question Importing Text File Into Temp Table

    Thanks guys! Stefan didn't even know that ABL Dojo website existed, awesome tool to use!
  2. J

    Question Importing Text File Into Temp Table

    Thanks Tom works a treat! Sorry to keep adding to it how would I get the line immediately successing the line that matches, I've tried the below but it's not liking it. DEFINE VARIABLE lineInDateString AS CHAR NO-UNDO. DEFINE VARIABLE lineInBody AS CHAR NO-UNDO. DEFINE VARIABLE lineAfterMatch...
  3. J

    Question Importing Text File Into Temp Table

    Thanks Cringer & Stefan I'll give the suggestions a go :)
  4. J

    Question Importing Text File Into Temp Table

    Thanks I've got this far which is the first bit you mentioned but I'm not sure where to go next as I'm not familiar with pattern matching and longchar's. I want to do something like if line contains "Lines:" grab the value immediately preceding that. It also need to grab the Date & Time from...
  5. J

    Question Importing Text File Into Temp Table

    Thanks Cringer the file itself will be ~5000 lines long, is this still the best way to do it?
  6. J

    Question Importing Text File Into Temp Table

    Hi, I'm attempting to import a text file into a temp table so I can perform some calculations on data held within it. I'm struggling as I've only managed to upload a file in the past where only 1 delimiter was needed and the columns were laid out nicely. Basically I have a temp table at the...
  7. J

    Question Speed Up Csv File Import

    Works like a dream now :) less than 1 second to run thanks very much for all the help
  8. J

    Question Speed Up Csv File Import

    Thanks for all the feedback guys being a massive help :) I've tested out Cringer's method and seen a ~50% speed increase which is great although on a 50 record test it's still taking 26 seconds as opposed to 49 seconds before, when I'm expecting ~1-2 seconds run time. Tom I tried to...
  9. J

    Question Speed Up Csv File Import

    Hi, I'm wondering is someone can help me speed up an upload of data I'm trying to perform. I'm new to this so haven't much experience but I've managed to piece together the below which works fine although I would expect it to complete within a few seconds instead it's taking 45 seconds a go...
  10. J

    Question Unable To Scroll Frame Up

    Almost there! Not showing any data now, so the browse part appears to be working and it outputs the label names at the top but no data. IF outputSelection = "terminalOption" THEN DO: DEFINE FRAME terminal-frame WITH SIZE 80 BY 15 ROW 7 COLUMN 1. DEFINE QUERY terminal-display FOR...
  11. J

    Question Unable To Scroll Frame Up

    the iNewStk and deCostAdj are variables that I created for this program so they don't lie within any database/table. DEFINE VARIABLE deCostAdj AS DECIMAL NO-UNDO FORMAT "->>>9.99" LABEL "Cost Value" INIT "0.00". DEFINE VARIABLE iNewStk AS INTEGER NO-UNDO FORMAT "->>>>9" LABEL "New Stk" INIT...
  12. J

    Question Unable To Scroll Frame Up

    Thank you for all your help so far, I'm getting this error for the variables I'm creating in the ADD-LIKE-COLUMN statements: iNewStk in ADD-LIKE-COLUMN must have a table qualifier. (9158) IF outputSelection = "terminalOption" THEN DO: DEFINE FRAME terminal-frame WITH SIZE 27 BY 15 ROW 7...
  13. J

    Question Unable To Scroll Frame Up

    Still nothing I'm afraid, here's the code. DISPLAY " STOCK ADJUSTMENT REPORT" WITH 1 COLUMNS FRAME HEADER-1 NO-BOX ROW 1 COLUMN 1. DISPLAY daStartDate daEndDate SKIP(1) "Adjust Report Date" TODAY WITH SIDE-LABELS ROW 2...
  14. J

    Question Unable To Scroll Frame Up

    Thanks for the quick response. I've tried both methods but still no luck I'm afraid
  15. J

    Question Unable To Scroll Frame Up

    Thank you thats fixed it! Any idea why it still won't scroll up/down?
  16. J

    Question Unable To Scroll Frame Up

    Thank you, I've taken a look at making my own browse widget but keep on getting the error:BROWSE widget does not fit in parent FRAME terminal-frame. (4041) I've changed the X/Y figures for the BROWSE Widget and Frame but had no luck. DEFINE FRAME terminal-frame WITH SIZE 25 BY 15 ROW 7...
  17. J

    Question Unable To Scroll Frame Up

    Hi, I'm struggling to get my frame which is being displayed to the terminal to scroll up/down. At the moment I can only navigate by pressing space bar/carriage return in which case it moves downwards but then won't let you scroll back up or move around using the arrow keys. Any help would be...
  18. J

    Error Procedure Not Running

    Thank You that works perfectly, knew it would be something simple!
  19. J

    Error Procedure Not Running

    Hi, When running the below code and selecting the file-btn it doesn't run the procedure within the SET statement (fileOutputReport), the MESSAGE statement works so I know the variable is populated with the data entered by the user however it doesn't go ahead and OUTPUT TO the file which is the...
  20. J

    Question For Each Where Clause Wildcards

    Thanks Cringer that has helped things
Top