Search results

  1. Smud

    How I do ER diagrams

    Just thought I'd share .... Run the code "makexmlschema.p" to build the code to extract xml table details, run the program "sports.p" to create the xml files, open up Micro$oft Access and import the tables you want to document (the import adds a "row" to the end of the table name, just rename...
  2. Smud

    Readkey

    try this; READKEY PAUSE 86400. DISPLAY LASTKEY. What is the highest "PAUSE" seconds that does not break? Try running a second time with say 15000, and it works first time but not on a second run? Anybody else come across this?
  3. Smud

    Game of Life

    Create a spreadsheet, select 60 columns and 36 rows, set background colour black, make the columns 0.92 wide and save as GameOfLife.xlsx. Put the spreadsheet in c:\Temp and run the OpenEdge.p code in AppBuilder (Windows). Its very slow (the interaction to Excel is the slow bit) but will get...
  4. Smud

    On leave of field

    re GUI development (I'm working in a viewer client side); I have a "need" to do some processing on leave of a field - on change I'm setting a flag then using "on mouse-click anywhere" and "on cursor-up etc" but problem is the mouse-click gets eaten up and does not activate as before (lucky...
  5. Smud

    DOS command hangs processing etc

    Had the problem where the DOS command causes Openedge to wait till process has finished etc and could not see a decent resolution in any of the forums, so the difference between; DOS SILENT notepad c:\temp\text. and OS-COMMAND SILENT ("start /B notepad.exe c:\temp\text.txt"). is the...
  6. Smud

    A"maze"ing fun

    Thanks to these guys - http://people.uncw.edu/tagliarinig/Courses/380/F2017%20papers%20and%20presentations/The%20Amazing%20Maze--Lawrence,%20Neill,%20and%20Nobles/The%20Amazing%20Maze(1).pdf was able to decipher an interpretation of the sidewinder algorithm; /*...
  7. Smud

    Call me "Silly"

    Was playing around running tty type unix code in windows just using the _progres.exe file with a few minor code changes it all works fine (compile on the fly) but I could not find the settings to change the screen size rows and columns ie 25 rows and 80 column type terminal. Even read some...
  8. Smud

    Count Records in each table of a Database

    Saw this question recently, this is better than "for each ...: i = i + 1. end. display i." type of code; CREATE WIDGET-POOL. DEF VAR h_predicate AS CHAR NO-UNDO. DEF VAR h_qry AS HANDLE NO-UNDO. DEF VAR h_buffer AS HANDLE NO-UNDO. FOR EACH _file NO-LOCK: if...
  9. Smud

    While Debugging old Code ....

    If you try something like this in the Dojo (this is for demonstration only, not serious code); FIND Order Where ordernum = 100 no-error. IF AVAILABLE(Order) THEN DO: /* then do lots of processing .... before */ FOR EACH Orderline OF Order: DISPLAY ordernum Linenum Itemnum Price Qty...
  10. Smud

    Soundex

    search is down for some reason .... anyway, does this soundex code look about right? Longtime since I used Soundex, think it was payroll surname lookup (cobol code).
  11. Smud

    Comment Sudoku Fun!

    took the excel solution from Sudoku Solver and translated to Openedge. Openedge does not have multi dimmentional arrays so it requires some "fiddles". Also note the variable "tom" in the Excel vba is an uninitialised variable so it equates to zero, also note, dodgy variable scoping eg...
Top