Search results

Hi @Ross55, this forum has nothing to do with Pervasive databases. I doubt anyone will be able to help.

It does indeed work. Although I agree with @Stefan that the complication is bad.. FUNCTION MyFunc RETURNS INTEGER (): MESSAGE 111 VIEW-AS ALERT-BOX. RETURN 10. END FUNCTION. DEFINE VARIABLE i AS INTEGER NO-UNDO. DO i = myfunc () TO 1 BY -1: END.

Your appserver will have a broker and server log file. These are a good place to look for errors.

Please can you post a more complete code sample as a starting point.

In reality assigning the NUM-ENTRIES () to a variable probably makes very little difference, but Tom is correct, that one probably should. I'll leave the religious wars on keyword casing to others. As well as the variable naming conventions. I write my code based upon the conventions of the...

o_O

I was a bit busy earlier, but I have had time to write a more efficient solution for the Sports DB as an example: DEFINE VARIABLE cCountries AS CHARACTER NO-UNDO INITIAL "USA,Finland,France". DEFINE VARIABLE i AS INTEGER NO-UNDO. DEFINE VARIABLE cCurrentCountry AS...

I agree the first will be better, and assigning the ENTRY() result to a variable will make a difference.

Both options will almost certainly result in a whole index read of the Order table. Functions in query predicates are typically hard to resolve and so you end up with poor performance. You could use an OPEN QUERY or a Dynamic Query to solve the problem more efficiently.

Well I never. My memory is failing. You're right of course, Tom.

You will have to create a constants library yourself. In your version the best way will be an include file I guess. In a modern version you could encapsulate them in an object.

Not being able to post the link is a bit annoying, yes. I've liked your post and if you get enough likes it should allow you to post them in future. I presume you clicked a link on one of the external resources feed posts? Those link out to the Progress Community pages. No harm having your...

Yeah... be pretty easy to make a program to calculate primes slowly...

I think the question is more "Is the ABL locking because the SQL is blocking it? And how can I identify this?"

Try APPLY "CLOSE" TO THIS-PROCEDURE.

Are you who I think you are? Nice to "see" you if so. :) Could you post the exact error you're getting in ODBC please? Sometimes the errors here can be useful in pinpointing the issue. Did you set up a broker to accept SQL connections? The recommendation is to add a secondary broker for SQL...

It's referred to hear in the community: https://community.progress.com/s/question/0D74Q000007xf6uSAA/detail

You can't. Not with a standard alert box. You could code a custom .net MessageForm with your desired dimensions - we use those because you can expand them to include a lot of information that an Alert Box doesn't.

Which OE12 version specifically? OE12.2.5 has, I believe, had the 32bit AppBuilder re-inserted. All other OE12 versions only have 64 bit AppBuilder.