Search results

I tried all sorts, but am unable to catch the error. I tried seek( input ) - but the redirected input is special and returns unknown value. I tried fetching the command line with a Windows API call, but this returns the command line without the redirected input file. I tried using...

Yes, a dynamic temp-table can only be queried dynamically. A static temp-table can be queried statically or dynamically. You can also pass a dynamic temp-table as table-handle to a static receiver (I think). But why not just rename the temp-table and put it in its own namespace? define...

I would guess that this is your convert function trying to cast some text string in date_time to a date. Your assumption that all records contain a value that can be cast to a date seems untrue. Further qualifying your select statement is resulting in a record with an invalid date not being part...

Len is Dutch, I rest my case. ;)

Good luck doing that with 11.2 and a workgroup database license ;-)

And which part of my reply, which did update the XML using ABL, was unclear?

This should get you started: define temp-table tt serialize-name 'keyboard' field ckey_label as char serialize-name 'key-label' xml-node-type 'attribute' field ckey_value as char serialize-name 'key-value' xml-node-type 'attribute' field special-lKey as char field cimage_up...

Since you are asking the question, probably. One solution is to use a dynamic query in which the query is simplified before the query is opened.

Once the temp-table has been temp-table-prepared you can no longer modify it. You can copy-temp-table to a new temp-table and add your field to the copy.

The debugger will tell you exactly what line you are on and can show you what the values of all your variables are.

You just need to get rid of the intermediate variables b1 and b2 since b2 is always evaluated even when it's value is irrelevant based on b1. function bitOR returns integer (input X as integer, input Y as integer): define variable n as integer no-undo. define variable Z as integer...

Nice, you can win some performance (about 15%) by allowing your bitwise OR and AND functions to short-circuit.

1. please put code inside [ code ] tags to make it legible 2. when you have a problem and would like others to help you with it, it helps if you reduce the problem to the smallest version of the problem. Showing how you assign NINE fields with all sorts of crap does not help. What you need is...

Not that I can share. I can share that we started by reducing an xlsx to a bare minimum (there is a lot of fluff in an empty worksheet) and then building it up with our content. It's a lot more fun than reading through pages and pages of specifications.

We use option 3 Create an xlsx file (is multiple xml files created using sax-writer, which are then zipped as xlsx) - fetching simple data (1 table), creating report and creating excel file takes less than 1 second (640 records, approx 20 columns)

If your backend service can use .Net and if it can create an ABL window and if you can hoist this in a .Net window, then you may be able to use the CopyFromScreen method.

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...

/* 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

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.

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