Search results

On the for each you request an exclusive-lock. You can only acquire an exclusive-lock within a transaction. That is the very reason why the transaction function function will return true. This is done by the compiler and does not happen at runtime. Furthermore, in this case, every iteration of...

Just my 2 cents: Your information about your environment is much to vague. You need to find out what tools or possibilities you have to copy a file from the Windows box to the Unix/Linux box before even attempt to come up with a solution wrapped by ABL functionality. This has nothing to do...

That is why I said religious flame wars. If or case could be replaced by the factory design pattern in OO ( Factory method pattern - Wikipedia ) in many cases. In a nutshell: Instead of branching with an if else or case statement you can put each branch into a distinct classes which inherit...

For the record: The number of licenses you have bought is not enforced by an server-side product of Progress in OE10 and OE11, and, I doubt that it is in OE12. That means that either you are using a workgroup database ( if I remember correctly the maximum value -n is 63 or something like that )...

You don't need to disconnect from the databases - on quitting the session they are automatically disconnected gracefully. But, if you really want to use the disconnect and use the no-error option you should check if there were any errors. Otherwise any error encountered will be eaten and you...

What proof do you have that the session is still actively connected to the database server?

I like rsync to copy (binary) dump files from one machine to another. In my case from a "very" old Solaris SPARC system to a RHEL 7 x86 system. Works really great. In my case it turned out to be much faster than to use a shared network file system or an NFS mount to dump to and load from.

I can only second Tom's opinion. Fiddling around with such code without refactoring it will likely introduce new problems. Refactoring, IMHO, is an engineering practice that is not applied enough. Most developers I met through my career actually didn't own they code they produced - just pushing...

The same could be said about if statements - in that they should be avoided. I witnessed religious flame wars about OO design patterns vs. procedural and more recently functional programming and immutability. IMHO it is all about clean code and comments as to why you are leaving a block early...

The error message "tends" to point to a permission issue - for example a firewall blocking the traffic. Don't know whether this is relevant to you: https://knowledgebase.progress.com/articles/Article/windows-10-shared-drive-executables-socket-error-781...

The ABL is oriented in blocks to which something can be scoped - like transactions, buffers and undo. Without labeling a block the default behavior and default capabilities of blocks kick in. A simple DO does not make a block to which something can be scoped and therefore a leave statement will...

The error message suggest that the OE 11.6 installation per default does use different SSL/TLS protocls and ciphers than the one requested by the service. You will get the same error message when you try to connect from a 11.7 client via TCP to a 11.3 server out-of-the-box. To get more...

The -sslprotocols TLSv1 -sslciphers AES128-SHA and not or not very well documented options you can use on the connect method of an ABL socket. They also work on the connect method on the server handle - connection to the classic AppServer - which I have to use because right now in production we...

Some caveats I stumbled on: You must have a development license installed or you must start the ABL client session with the -rx parameter On *nix you must have the ${DLC}/tty/OpenEdge.ServerAdmin.pl in the PROPATH.

Found the solution - for anyone who is interested using OpenEdge.DataAdmin.DataAdminService from propath. using OpenEdge.DataAdmin.IAdministrator from propath. define variable administrator as class IAdministrator no-undo. define variable service as class DataAdminService...

It is not exactly true that one cannot trap stop conditions pre-OE12. This is what I use: do on error undo, leave on stop undo, retry: /* STOP Condition trapped */ if retry then do: end. end. I know it is not sexy - but it works for me.

OpenEdge 11.7.3 The data administration tool provides a menu item to set security administrator on the database in the security menu. I need to invoke this function from a batch procedure and I don't like to roll my own and fiddle with the respective meta-schema tables can-* settings. Does...

The Progress documentation is notorious for bad coding style examples and even bad practice. As always you have to take the examples with a grain of salt - at least I do as there are only there to illustrate usage of an isolated feature.

The reason why you would add the transaction keyword to a do block is because a do block by default does not have transaction capabilities. That means without specifying the transaction keyword the transaction scope will be increased to the next outer block with transaction capabilities. In a...

The charscan option to the proutil convchar can do that for you too. The tool is intended to be used when you plan to change the code page of your database to find records with strings that may contain characters which are not supported by the target code page - to do something with them ...