Search results

  1. Stefan

    Table Name - Trigger Procedure

    How are you planning on doing this (without an include), since the trigger procedure must start with a static: trigger procedure for <event> of <table>. We use a (generated) single line .p with the table name passed as a preprocessor to an include that does the actual work.
  2. Stefan

    Table Data Records

    Have a class based example as a starting point: https://abldojo.services.progress.com/?shareId=62838cdf3fb02369b254634f def var odelete as delete no-undo. def var lcjson as longchar no-undo. odelete = new delete( 'order' ). odelete:populate(). lcjson = odelete:write(). message string(...
  3. Stefan

    Table Data Records

    I cannot make heads nor tails of your code. // first you need to prepare your temp-table based on the index create ht. for each _file... ht:add-like-field. end. ht:temp-table-prepare(). // then you get records and populate temp-table create hq. hq:query-prepare(). do while hq:get-next...
  4. Stefan

    Table Data Records

    after pressing share, a url is copied to your clipboard - you need to provide the url.
  5. Stefan

    Table Data Records

    Maybe share your "working" code on ProgressAblDojo
  6. Stefan

    Table Data Records

    So you need to not do that and only create what you need when you need it. If you want a temp-table with multiple records, you need to create the temp-table once and then create multiple records in that temp-table.
  7. Stefan

    Table Data Records

    You are creating the dynamic buffer, query and temp-table per index field of the unique index on table 'test'. So you are: not getting what you need leaking memory since you are repeatedly creating dynamic objects over each other
  8. Stefan

    Table Data Records

    Since JSON is not a line based format, you cannot simply append like with the output statement, so you need to: read-json file into temp-table create temp-table records write-json temp-table to file
  9. Stefan

    Error ** More than 1024 items in a single statement. Use the -tok parameter. (136)

    You may also want to have a look at the quoter function: Progress Documentation
  10. Stefan

    Error ** More than 1024 items in a single statement. Use the -tok parameter. (136)

    -tok is a client startup parameter, so it needs to be on the command line directly or indirectly (-pf) of whatever is starting your ABL session.
  11. Stefan

    PDSOE refusing to open a file

    Which Java version are you using? You need to be using an 11.0.x version.
  12. Stefan

    Error ** More than 1024 items in a single statement. Use the -tok parameter. (136)

    Or just increase the value of startup parameter -tok, the default value for any current version of Progress is 3000 - for older versions see Progress KB - What is -tok parameter ?
  13. Stefan

    Question Changing triggers.

    r-code caching is a startup parameter: -q to clear the cache from within the ABL: current-language = current-language to clear the cache from outside: asbman -trimagents
  14. Stefan

    Dump of Deleted Records

    Create a delete trigger. Which has an interesting oddity in the notes:
  15. Stefan

    Example on how to calculate the week number of the year from a date

    Repeatedly dating a substituted string with an assumed session DMY format is asking for trouble. Use the date function with three integer inputs for month, day and year, it will work regardless of the session settings:
  16. Stefan

    OpenEdge to MSSql Conversion ?

    The tool is Progress Data Administration. I'm fairly sure that move is just a poorly chosen name, since it just creates insert statements for all your data and does not remove your original data...
  17. Stefan

    Question Email html images

    Assuming you are not a spambot, what are you using to send mail?
  18. Stefan

    Answered Config files for scheduled task

    Yes, see documentation: load get-key-value put-key-value
  19. Stefan

    Answered Multiple progspec.ini

    What does your software do? How can you prove that your software works correctly? Are there parts of this proof that can be automated?
  20. Stefan

    Answered Multiple progspec.ini

    In an ideal world in which bugs do not exist, you are correct. My priorities in your case would be: source control automated builds (pct) automated testing of these builds continuous integration Modern tooling helps for all of the above. When introducing a new version of anything in your...
Back
Top