Search results

  1. G

    SQL Lengths

    Thank you again. And yeah ... 'Adding/dropping/changing columns and tables, Adding/rebuilding/dropping indexes (no recompiling of code)', that would be dreamy for sure. The problem isn't so much that doing these things is tedious or expensive directly, but it leads to people doing all kinds of...
  2. G

    SQL Lengths

    Getting back to the Lengths thing, I have a follow up question. Does anybody know what would be the implications of setting _width on every field to 32k (in our case, we don't have any LONGCHAR, etc. to worry about). This *sounds* like the worst idea ever, like every single field would get...
  3. G

    Include File - Bad Practice?

    In your defense, I think you, like I, still have code from v6, where the editor was even more ghastly than today (it's where I learned the word 'ohnosecond', that's the moment between when your brain already sent your hand a signal to press f8 and the moment you realize that it's too late to...
  4. G

    SQL Lengths

    Not sure what you mean by 'major maintenance' but for us it is certainly true that a lot of terrible, terrible things derive from the hassle of doing schema changes in Progress. If you could change schema the same way you can edit a .p, we would have avoided many atrocities. I know it's better...
  5. G

    Include File - Bad Practice?

    That's exactly what I mean, and Andre's example is almost exactly what we put in all of our includes. So in our world a typical largish program begins with 10-20 lines of .i declarations. Another rule we have is that includes should be written and used in such a way that they never get used...
  6. G

    Answered Why check for ? on a char field

    I think you can just say > "", rather than the AND, but I don't have Progress in front of me right now to double check. We have arguments sometimes over whether every field should be tagged mandatory in the schema. In principle I think the answer is Yes, but in reality, we don't do this and...
  7. G

    SQL Lengths

    Ok, I'll bite. Doesn't everyone have a lock table? What's the alternative? Optional table level locking might be helpful? +1 for dirty reads, this seems so terrible... though in all honesty I have never seen an actual production problem caused by this.
  8. G

    SQL Lengths

    Wow. What a superb reply. Thank you very, very much. Aside: it's just so crazy to me that SQL people think screwing around with field lengths is a good use of time. I like a great many things about SQL and Java, etc. over Progress, but this is one of two or three areas that Progress gets SO right.
  9. G

    SQL Lengths

    I vaguely understand that whereas Progress fields are inherently variable length, in SQL, they're usually fixed length (unless you define them as VARCHAR, which is, I gather, uncommon). I further believe that if the actual length of a field exceeds the "SQL length", bad things happen. To avoid...
  10. G

    Include File - Bad Practice?

    By the way, going back to the original post, 'it is not obvious where the included variables come from' is not an issue if you follow rules similar to ours. And 'may add unnecessary overhead' is, I think, totally false. Of course, IP's can add overhead, but (a) it's miniscule and (b) include...
  11. G

    Include File - Bad Practice?

    We use include files extensively, and while we definitely do some terrible things with them, for the most part, I'm OK with it and absent starting down the OO road, I'd probably do it again. We have three rules that we follow: 1. Any .I must be independently compilable, that is, it must...
  12. G

    Question get passing parameter number along with data type

    If you want to go down the parsing road ... I'd consider parsing .R. We do this in one situation and it works well (not sure I'd use it for a fly-by-wire system though). If you look at it with a binary editor, it's not very scary at all. It has the benefit that .R code is more likely to be...
  13. G

    Question get passing parameter number along with data type

    I think GET-SIGNATURE is only useful for 'RUN x IN y', not a bare 'RUN x'. If this has changed in a recent OE, I'd love to know about that, we have invested untold hours in working around the limitation of not being able to run GET-SIGNATURE directly! If the OP wants to know about the (three)...
  14. G

    Displaying Frames in Dual Monitors

    The Windows API is your friend for this kind of thing, and look, an article that answers this exact question: https://msdn.microsoft.com/en-us/library/windows/desktop/dd162826(v=vs.85).aspx Of course, you'd have to translate this from C++ into ABL.
  15. G

    AppServer Locks

    Thanks for the feedback. Rob - you're right, I need to track that down. Tom - we have a policy against bugs, so of course it can't be that ;) Do you guys agree that this (an AppServer holding onto a record lock outside of the duration of a call to it) is only feasible with an uncleanedup...
  16. G

    AppServer Locks

    Hello Progress World (mostly) 10.2B HPUX We have been running AppServers for eons, and we always run them StateFree (from WebClient) or StateLess (from Web Service proxies). We had a problem the other day where it appears (from log files) that one of our Web Services-supporting AppServers was...
  17. G

    Resolved Explain property and data member differences and when to use final

    We don't use Progress OOP, so I don't really know what I'm talking about. But I think the basic idea is that instead of 'METHOD PUBLIC HANDLE GetEmployeeList()' you could use 'DEFINE PUBLIC PROPERTY EmployeeList AS EmployeeListClass', where 'EmployeeListClass' is (basically) a class wrapper...
  18. G

    Question error call stack

    Would &FILE-NAME, &LINE-NUMBER help, eg. in the THROW statement? I have my doubts, and haven't used them myself. Your concern #1 about using callStack sounds not valid because you probably shouldn't be CATCHing errors very often. If you are, you probably have bigger problems. Eg., you generally...
  19. G

    OpenEdge Development Costs (that old chestnut)

    Well, a lot of people would disagree with you (basically anyone under 30, and I say that as someone way on the wrong side of 30 myself), but more to the point, they're robbing themselves by making it so difficult to find these things out. Nobody knows who Progress is, and nobody cares, and this...
  20. G

    OpenEdge Development Costs (that old chestnut)

    All three of these replies (especially Cringer's) must be a huge turn off to anyone considering Progress!
Back
Top