ABL(4GL) General Programming Group

This group is for topics on coding in ABL (formerly known as Progress 4GL). Topics include code snippets, code examples, utility programs, tricks, techniques, and patterns. There are other groups for other more specific topics like Win32 API, OO programming, and specific programming tools.


Word Automation "InsertFile" Method fails with Insufficient Memory error

I have a Word Automation issue that I haven't been able to get past. Our client has roughly 4 to 5 pages of rich text stored in our Progress OE 10 database that we haven't been able to insert into a new Word document using the InsertFile method. The text contains no images, tables, etc., just rich text. The process is not new, and the same client has used it hundreds or maybe thousands of times for the same purpose. The text size approaches the largest text size in use, but doesn't appear to be the largest. The most recent change to the data was to add "a few words".


Oracle dataserver use

Hi - not sure of this is a bug or not - but getting the progress error 7334. Something to do with datadiggerlib.p cQuery = substitute('for each &1._File no-lock where _File-number < 32768', cDatabase).


help with name server ..

How can i get the server's name on wich I'm working ... I'm using a GUI application and it's connected to a linux server with a .ini and .pf file ..

does anybody know some code for get this??? I have tried with DB-REMOTE-HOST but it didn't work ...


add + clone buttons - they work but throw an error

error is (record already exists)
I have to click close button to exit - hit refresh on table + new record is there - for both add and clone

so it's adding the proper record - but on click of OK (in add/clone mode) it is trying to add it 2x?

Note: GREAT! to have Add working + also CLONE is a great idea that I will use! yes!


Fastest "1 TO x" loop when x is not a constant

It's ~30% faster to use "DO i = x TO 1 BY -1" than the closest "DO i = 1 TO x", even when x is calculated before the loop,


Query-Browse - Highlight first line in Browse

I have done this many a times in character where the first record in a Browse is highlighted using the syntax 'apply "entry" to browse abc-browse' or in the wait-for statement where 'focus' is given to the browse. But I can't seem to get it working in Windows??

Any suggestion or advice will be appreciated.

Thanks in advance.

Errol


SLIBDOCX Expired

Dear all,

I am running the LIBOOXML sample LETTER.P and when I run, it gave me one error: "This copy of SLIBDOCX.O has expired".

It is possible re-release it?

I am running "10.2b02-win-32bit-rcode" version over 10.2b04

Thanks in advance,

Marco


Word and Excel Utils

I tried to user the program "slibxlsx" from library slibooxml an I received the messaje:
This copy of slibxlsx.p has expired.
I mention that I use OpenEdge 10.2B on Linux.

I called this library because I had an error "COM objects not implemented on this system (5676)" when I tried to create an excel file from Progress.


Finding the name of the calling procedure...

Hi...

I'm trying to develop some code which writes an audit record.
Basically I want to put the calling procedure name into record when I write it

The code is run something like this

/*Test.p*/
run pctest.
Procedure pcTest:
run audit.p("this is some audit code")
end.

How can I get access to both the name of the .p and the name of the internal procedure from within audit.p??????

i.e. test.p pcTest

I want to write this to the log file so I ca easily see what called it

Thanks in advance
ryan


Data querying feature

I'm a new guy for progress.Is there a query tool like toad for oracle to query data from table directly?


Need help on underline font

Hi Everyone,

I'm new to progress ABL,
can anyone tell me what is the command to change the font to become underline font?

Thank you in advance.


Compiling xcode on Linux

I'm having trouble compiling with slibmath.i on Linux, can't figure out the problem. According to the app compiler output it appears to have backslashes in the include file path, but I have checked and this is not the case!

Just in case it was TTY related, I tried character mode on Windows and it still compiles fine.

Any suggestions?


Why Can't I Use a Bullet Character - CHR(149) - MESSAGE alert-boxes?

They don't show, even though I am using the standard character set, and this is a standard ASCII character.

MESSAGE "This is a bullet:" CHR(149) VIEW-AS ALERT-BOX.
... shows no bullet.


Can't get schtasks.exe to work in Windows 7

I have a functioning command in Windows XP to schedule a task to run every minute with the Windows scheduler. It looks like this:

ASSIGN l-cmd = 'schtasks /Create /SC minute /RU "" /TN "Capture AutoSync" /TR "\"C:\Auto.lnk"'.
OS-COMMAND NO-CONSOLE VALUE(l-cmd).

On Windows 7, I get "The task XML is missing a required element or attribute."

However, the MS example (from their website) shows the following example:

SCHTASKS /Create /S system /U user /P password /RU runasuser
/RP runaspassword
/SC HOURLY /TN rtest1 /TR notepad


OS-COMMAND Fails Due to Windows Command-Line Parsing

I know I have seen the solution for this before, but I'll be darned if I can find it...

Windows does some funky parsing of command line parameters, requiring embedded quotes, tildas, etc. to pass a parameter that has embedded quotes from OS-COMMAND. Hoping somebody has the key.

Example:

l-db = "C:\My Folder\My Subfolder\My.db".
l-cmd = "C:\PROGRESS\OpenEdge\bin\prostrct repair " + l-db.

OS-COMMAND VALUE(l-cmd).

I've also tried:

l-db = "C:~"\My Folder~"\~"My Subfolder~"\My.db".
l-cmd = "C:\PROGRESS\OpenEdge\bin\prostrct repair " + l-db.


#
Syndicate content