Search results

This may not be an issue, but bear in mind any basic 4GL sorting will render the list in ascii order, and will not (for instance) handle embedded numbers in the human-friendly way that Windows does. eg. order of the following filenames would be: file1 file12 file2 not file1...

No. They are stored in low-level structures that are not realistically accessible dynamically through the 4GL in your version. DataAdmin > Admin > Dump Data > Sequence Values (which uses) CURRENT-VALUE()

Unless you've upgraded in the last couple of hours, no, as I have already said, not directly in the 4GL. You can write some fancy code to generate the values along these lines: RUN FancyCode(sequencename). Procedure FancyCode (sequencename). <output to tempfile.p '4GL with...

Yes. Upgrade, or implement with static sequences.

Incidentally, on my quick (and admittedly ignoramus) reading of SQL-92 LIKE syntax, the implied runtime parsing of the LIKE clause (beyond the standard pattern matching characters) is invalid, so your separation of the string pattern using "+" would seem moot.

It is not being used as one, is it? Like most others here, I am not an SQL developer, but the 'But' seems to be indicated as a terminator in your error message. I know this is not consistent with the SELECT clause above where you prove it works, but does it work when the string is put in...

(with apologies to the original author)

It gave me a chance to become forum cop again. Although, given Casper is the real forum cop, I guess I'm more like Lassie or Skippy, or somesuch.

The clue is in the name.

The OP is a clever spammer. Technique is to lift an old question from elsewhere, and post it with an embedded link (which has been removed here). eg. This question originates 2 years ago: http://forums.techguy.org/business-applications/576329-need-some-excel-formatting-help.html

Yes - and there are also a couple of other negative references elsewhere on the site, and its sister site serverfault (none as 'authoritative' as that, though). They are normally accompanied by wrong or misleading answers which indicate a lack of understanding and inability to think outside...

I read it and wanted to pull it apart, it's so ignorant, obnoxious and pathetically playing-to-the-crowd. Unfortunately, just as I did with Joel, I forgot my StackOverflow password (I seem to be jinxed with that family of sites) and can't be bothered creating a new login and building up...

For anybody who has missed it, OP has 'found the solution' according to edit comments in first post.

Or defining it beforehand.

The standard (non-OO) way to call internal procedures in an external procedure that isn't supered to the session is to get the external proc ready, then call the internal procedure: RUN external-proc PERSISTENT SET external-proc-handle. RUN internal-proc IN external-proc-handle (<params>)...

The code you've posted isn't running anything - it's using an include, which judging from the name and structure is a substitute for the Progress RUN statement, the pointfulness of which I will refrain from commenting on.

I deleted the post (while you were editing, obviously) because it occurred to me there was an outside chance in the examples I gave the messages were duplicated automatically by bots unrelated to our alleged spammer. Anyway, there you go. So, The Peg...

...................................

Clever spammer. Not-quite-nonsense messages, and others lifted from a different context and placed here with a link.

Heh heh. I forgot that. A childish schoolboy error, as my old team leader used to say.