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.
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(...
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...
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.
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
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
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 ?
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
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:
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...
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...
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.