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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.