Search results

We're currently using Progress 10.2B via ODBC and recently ran into the following issue: Progress KB - Running SQL query with large WHERE IN clause crashes _SQLSRV2 on some UNIX systems The work around for us was to increase the -SQLStack parameter (2000 wasn't high enough to get us around our...

Search seems to be broken again?

<rant> It's really most unfortunate and I continue to find more and more cases where support is lacking in progress as far as interoperability goes. It also probably doesn't help that our MRP is running on 10.2B and I can't even leverage some of the simpler SQL statements (like a limit +...

I see that it appears as of 10.2A progress started supporting database save points which is exactly what I was hoping to use in this php application. However, when I search through the dmsql and dmsrf documentation the only thing I can find referencing a savepoint is in the error code. I'm not...

I'd agree that the internet risk is minimal and that the performance impact these days is so negligible there's not really a reason not to do it (other than maybe the minor pain of setting up a new certificate every X years). However, that still doesn't prevent the deviant computer science...

FWIW We connect to our databases from web applications via ODBC. We ALWAYS have our application servers in the same city as our database server. We are also a multi site company but trying to have the application be driven from a different city is severely taxing on database performance...

I'd agree that is has quite a bit to do with naming and comments, but it also touches on things like DRY principle, having minimal dependencies, and extendibility (if that's even a word?); which I do think are things that good OO design need to incorporate. Regardless it's good info.

Another frequent term linked with Object Oriented Programming is SOLID programming. Also if you look poke around long enough you can find that Robert Martin (AKA Uncle Bob) is kind of the authority on these principles. Be sure to check out youtube for some of his talks, I'm sure you'll find...

Not sure if this is exactly what you're looking for or not: http://stackoverflow.com/questions/3491329/group-by-with-maxdate/14841015#14841015 My understanding of what you said is that you're looking to get the max date record for each userid which you can accomplish with a left join and a...

I actually recently came across Pieter's encode function and did translate it from C# to PHP. You can check it out at https://github.com/ExchangeCore/progressencode. Hope that helps!