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.


Prolint - tablename rule for class method parameters not working

I am having a class with method and that method is having 2 input parameters assigning to some other local vars.

Using Prolint I am generating ouput for the same class and output is showing warning like "inpt1 must be qualified with table name" and same for the 2nd input parameter for the line number where I am assigning it to other local vars.

But the same is working for procedure file having input parameters, no warning in the output page.

Please suggest


Progress X Libre Office (Calc)

Good afternoon.
It is possible to generate a file (Calc) of LibreOffice, through a progress program?
Someone would have an example.
It can be basic to use as reference.
Thank you.


Changing font size in Editbox?

Hi,
I'm using Progress 10.1 b. I want to change the size of Editbox in GUI. There is maximum 23. But I want to set it 46 or create new font which is 46. But when I change the size it stays only for the same session. When I close and re open session the font back to 23 again?

How can I make it lasting 46 pt?

Regards,
Mucip:)


OESNMP: Monitoring your OpenEdge infrastructure from Any monitoring solution

Expose OpenEdge infrastructure to any monitoring platform

OESNMP is a set of utilites to expose information about OpenEdge Appservers, Databases and related infrastructure to Monitoring systems supporting SNMP. This allows you to notice unusual behaviour, verify performance tuning has the desired results, warn you before problems result in downtime,...


Connect to Windows SQL Server from QAD

I'm supporting a QAD application. Over the past 4 years, I've taught myself Open Edge. I'm not expert by any means but I've written some solid maintenance / label printing programs.

I would like to connect to a Windows SQL database, so I can interface it to UPS / FedEx, etc.

What would I need on the Unix side? Do you have recommendations for a Unix ODBC driver?

Also I need some sample code of how I connect to SQL and send SQL commands / invoke stored procedures from a Progress program on Unix.

I would appreciate any guidance.


Progress AES Decryption NoPadding

Hi everybody, does anyone knows how to decrypt with 4GL without padding?, i have been trying to do it but i fail everytime, i managed to do it with java but i don't know how to replicate the code in 4GL

4GL Implementation:

DEFINE VARIABLE TextToDecrypt    AS CHARACTER NO-UNDO.
DEFINE VARIABLE EncryptionAlgor  AS CHARACTER NO-UNDO.
DEFINE VARIABLE EncryptionKeyHex AS CHARACTER NO-UNDO.
DEFINE VARIABLE EncryptionIVHex  AS CHARACTER NO-UNDO.
DEFINE VARIABLE cDecryptedText   AS CHARACTER NO-UNDO.

Sintaks For Create OpenOffice Writer

Hi,

I have some problem, I can't find another sintaks to create openoffice writer from
openedge 10.2a. All samples just like this :
DEFINE VARIABLE hSM AS COM-HANDLE NO-UNDO.
DEFINE VARIABLE hDesktop AS COM-HANDLE NO-UNDO.
DEFINE VARIABLE hDocument AS COM-HANDLE NO-UNDO.

DEFINE VARIABLE hText AS COM-HANDLE NO-UNDO.
DEFINE VARIABLE hCursor AS COM-HANDLE NO-UNDO.

/* Some methods require an Array parameters for extra arguments. The
only Progress database that translates to Array is RAW. */
DEFINE VARIABLE extraArgs AS RAW NO-UNDO.

CREATE "com.sun.star.ServiceManager" hSM.


Using blob fields in dataserver MSSQL

Hello!!

I need some help to convert a memo field in SQL Server, progress see it as longvarbinary (character), into a text or string.

Sql function to do it:
SELECT
[SRM].[R_E_C_N_O_],
ISNULL(CONVERT(VARCHAR(1024),CONVERT(VARBINARY(1024),[alias].[memoField])),'') AS [MEMO]
FROM
[table] [alias] WITH (NOLOCK)

I need to do it in 4GL.

Can you help.

Thanks.


convert PDF to txt file in progress

Good morning everyone forum.
I need a help.
I have to develop a routine in progress, for converting a PDF file to a file in TXT format.
For later import into the system.
How do I Convert this? There is a FREE application that I can run on my progress application?
How do I do that? What parameters do I use?

thanks


CIM Load QAD EE

Good Afternoon,

I've being using cimloads in QAD all the way from 74i to SE2013. We are now using EE2014 and I'm having an issue with the messages that come out from the screen.

So a simple sample of how I'm doing the cimload would be:

input from value(cim_file).
output to value(log_file).
batchrun = true.
execname = "pitcmt1.p".
{gprun.i execname}
input close.
output close.


CITRIX

how I can read the computer name if the user is connected via CITRIX


Chart Screenshot

Chart Screenshot

DocxFactory 1.2.5

Hello All,

Just released version 1.2.5 of the Free DocxFactory Project.

Version 1.2.5 introduces several major enhancements –

  • Support for the entire list of more than 70 chart types in Microsoft Word.
  • A single XML and JSON merge function.
  • Support for multiple sections for supporting different page sizes and page orientations.

integration between the Arduino and Progress

Good afternoon everyone forum.
Someone has already developed an integration between the Arduino and the progress?

They could give me some tips.
Is there any DLL to install?

If you have a very basic program to show as an example.
Thank you.


Using .net user control with 4GL (adm2) container

The sample shows how a .net user control can be used with an ADM2 container. There is no specific support for ADM2 otherwise (links, etc) but it should be quite possible to modify the window super-proc to support automated display of date values in a date picker, f.ex, along the lines it's done for the JukeBox framework.

Components:

JBoxWrapWindowInForm.p:
Super proc for container that keeps track of control(s) in window, (re-)creates the window menu as .net menu and manages resize of control(s)

JBoxWrapperForm.cls:


#
Syndicate content