Search results

  1. schaapie

    Trapping stop AND errors

    I am trying to catch stop conditions (caused by a lock timeout) and errors in a program calling another program. I have tried various options, but end up trapping either errors OR the stop: Has anyone any clue how to do this? Following code is some of the things I tried, but now I can't...
  2. schaapie

    OpenEdge ABLDatareader

    We are trying to get data from a Progress-db into .Net. I have tried several ways, including ODBC and Appserver. Now I am wondering if anyone has any experience on this. The Appserver-solution would use something like the gettemptable.p example sourcecode from Progress. But I was wondering if...
  3. schaapie

    Supplying domain for -proxyUserid

    I am trying to access a webservice from ABL (OE10.1c) through a proxyserver. I can get the following code to work on a machine which doesn't route this through the proxy, but when I want to add the proxy-credentials I get a 407 error (proxy authentication). When I access this webservice from...
  4. schaapie

    select entry(x,y,z) as columnname

    Is it possible to select an entry of a db-column as a view-column? We have a field that contains a delimited list in the db and I want to present these as separate values to the customer in a view. What I would like to do is: SELECT TABELALGEMEEN . CODE, TABELALGEMEEN . IDTABELALGEMEEN...
  5. schaapie

    Revoke all from all

    I would like to reset the sql-92-rights on a database. I would like to start with the command: revoke all on pub.ACCOUNT from *; And after that grant to specified users. But the * is not recognized. "from public" still leaves a user granted with rights, I think it's the creator or owner or...
  6. schaapie

    stored procedure send-sql-statement in progress

    In some of the documentation the mention a stored procedure "send-sql-statement" which should be there by default. But... Is it only available in an Oracle-db? Can i even have stored-procedures on an progress-db? If so, how can i create a stored-procedure in a progress-db which allows me to...
  7. schaapie

    stored procedure send-sql-statement in progress

    In some of the documentation the mention a stored procedure "send-sql-statement" which should be there by default. But... Is it only available in an Oracle-db? Can i even have stored-procedures on an progress-db? If so, how can i create a stored-procedure in a progress-db which allows me to...
  8. schaapie

    stored procedure send-sql-statement in progress

    In some of the documentation the mention a stored procedure "send-sql-statement" which should be there by default. But... Is it only available in an Oracle-db? Can i even have stored-procedures on an progress-db? If so, how can i create a stored-procedure in a progress-db which allows me to...
  9. schaapie

    Updatable browse displays double rows

    I'm having a problem with an updateble (static) browse. When I come to the last row in the view-port. I press enter (enabeling the row for update) update the record. leave again by pressing enter (only one field is enables so this equals go) After completion of the row-leave (=assign changes...
  10. schaapie

    Crystal Reps command/view parameter

    I'm researching the possibilities of Crystal Reports 11 with our Progress 91d application. I've managed to export a report from our Progress application but now i'm to setting the parameters. I can set normal parameters (that is report parameters) just fine: chParamDefs =...
  11. schaapie

    add-calc-column on dynamic browse

    I'm trying to add a calc column on a dynamic browse which is populated by a dynamic query. So when I start off, i don't know anything about what will be in the browse. I'm able to open the query (with multible buffers) and populate the browse, but when I try to add/fill the calculated column I...
  12. schaapie

    Dynamic temp-table in dynamic browse result-list error

    Dynamic temp-table in dynamic browse result-list error In my code i'm doing the following: create a dynamic temp-table fill it with 25+ records create a dynamic browse for the complete temp-table create a dynamic query for the complete temp-table Now when I insert a row into the browse (and...
Top