Recent content by Stefan

  1. Stefan

    Question Pushing CSV File from Progress Code to Amazon S3 Bucket

    If you view the documentation on the RequestBuilder you can see what the Put method needs: OpenEdge.Net.HTTP.RequestBuilder Put (character, Object) OpenEdge.Net.HTTP.RequestBuilder Put (URI, Object) OpenEdge.Net.HTTP.RequestBuilder Put (URI, Object, character) So you always need to...
  2. Stefan

    Question Import Data volume increase to 300,000 causing DB updates to almost halt after updating 38000 records - Progress 11.7 Windows client - Linux db server

    /* why break-by ? - probably for the LAST( ), but won't hurt, only a small table for 1 customer*/ Let's just assume that this is not entirely true. :D
  3. Stefan

    Is it possible to store a json file into master

    The question title: But, using your example and manually creating the child records based on the extent, may be easier but also more error prone, than digging into how JsonObject and JsonArray work.
  4. Stefan

    Is it possible to store a json file into master

    Of course it fails, that's why you need to disect the json yourself using JsonObject and JsonArray - look these classes up on docs.progress.com google site:docs.progress.com JsonObject google site:docs.progress.com JsonArray
  5. Stefan

    Is it possible to store a json file into master

    Yes, although with your structure you will need to disect the json yourself using JsonObject and JsonArray.
  6. Stefan

    0 / 0 = ?

    That's not really your calculator though, is it James ;-). My calculator returns an error:
  7. Stefan

    0 / 0 = ?

    Working as documented Progress Documentation
  8. Stefan

    Get all values from created table

    If you just need to know which tables are hit, to get insight into the black box your application may be, you can monitor this using _TableStat or _UserTableStat To not reinvent the wheel, you could look at - the free version of - ProTop.
  9. Stefan

    Question how to find which separator or delimiter is used in given csv file ?

    Those are all possible approaches, you can also use the outcome of this as a default that the user can change if needed. Upon reading data, if you get an exceptionally high number of errors due to data type mismatches, you could retry.
  10. Stefan

    How to Query Longchar

    You can compare them, you just cannot use them in a query. So I think you are going to need to rethink what you are trying to achieve.
  11. Stefan

    How to Query Longchar

    Both a longchar and a clob are large objects, so this is not going to work.
  12. Stefan

    How to Query Longchar

    Why could you not write:
  13. Stefan

    How to Query Longchar

    Deserialize your json to a temp-table and use that, this should get you started: def var lcjson as longchar no-undo. lcjson = '~{"Customer": [ ~{ "cust-num": 121, "name": "Jack", "state": "Texas", "city": "Houston" } ]}'. def var ht as handle no-undo. def var hb as handle...
  14. Stefan

    ROWID on Dynamic Table

    Your trigger file: { deletetrigger.i customer } the include file // deletetrigger.i procedure trigger for delete of {1}: run scankey ( ( buffer {1}:handle ) ). Or if you have a strong dislike for ordered parameters: { deletetrigger.i &table = customer } with // deletetrigger.i...
Top