I’m an OpenEdge Architect addicted, so the workspace is the most import folder in hd.

Last week, my workspace became corrupted… if it happens with you, follow the steps below:

Alter the file…

File
Your_DLC_Installation\oeide\eclipse\configuration\.settings\org.eclipse.ui.ide.prefs

Old Line
RECENT_WORKSPACES=c:\old_workspace

New Line
RECENT_WORKSPACES=c:\new_workspace,c:\old_workspace

Just do it. :D


Progress 10.1B is going to have a new block control feature called STOP-AFTER.

It’s a improvement, but I think we waited too long for this feature.

I don’t know your needs, but for me it will be very useful in webservices calling.

Anyway, it works and thanks Progress Software.

Sample
define variable iCont as integer no-undo.
do while true stop-after 1 on stop undo, leave:
assign iCont = iCont + 1.
end.
display iCont.

cya :D


Hi all,
If you have trouble to install or uninstall the flashplugin in Ubuntu, this is a solution for your problem.
Error message
The package adobe-flashplugin needs to be reinstalled, but I can’t find an archive for it.
Internal error opening cache (1). Please report.
Removing
sudo rm /var/lib/dpkg/info/adobe-flashplugin.prerm
sudo dpkg-reconfigure adobe-flashplugin –force
sudo dpkg –purge –force-all adobe-flashplugin
Updating aptitude
sudo aptitude update
Installing flash plugin
sudo aptitude install flashplugin-installer

:D


Sometimes PROGRESS scares me… lol
BY curious I was seeking the MAX VALUE TO PUT IN a DATE VARIABLE.
RESULT…. 31/12/32767
But… why 32767 year?
Maybe because of the MAX VALUE TO an INTEGER VARIABLE.
Take a look…
DEFINE VARIABLE dToday AS DATE NO-UNDO.
ASSIGN dToday = 12/31/32767.
MESSAGE dToday VIEW-AS ALERT-BOX.
Error….
DEFINE VARIABLE dToday AS DATE NO-UNDO.
ASSIGN dToday = 12/31/32768.
MESSAGE dToday VIEW-AS ALERT-BOX.
:D

 

 


This is a quick and small tip, but…. very useful.

If u download a podcast in your ipod/iphone… probably some day you’ll remove it.

To remove is easy…

• Go to the podcast you want to delete;
• Instead of selecting it, quickly swipe your finger across to the left or to the right;
• A delete button will appear;
• Delete.

If u have some problem, please… let me know.

update…. it works for e-mail too.


Hi everyone,

If you work with development, you’ll understand me… sometimes, your procedures must have optional params. It’s very common in languages like… VB, Java, C#, Progress ABL, and so on.

In T-Sql isn’t diff, and this is an example of optional params.
It’s just use =NULL in the param…

Proc
–DROP PROC DBO.AAA_TESTE
CREATE PROC DBO.AAA_TESTE
(@NUM1 INTEGER
,@NUM2 INTEGER
,@NUM3 INTEGER = NULL)
AS

IF @NUM3 IS NULL
BEGIN
SELECT @NUM1 + @NUM2
END
ELSE
BEGIN
SELECT @NUM1 + @NUM2 + @NUM3
END

Testing
EXEC AAA_TESTE 1,2
EXEC AAA_TESTE 1,2,1

Both scripts work, with 2 and with 3 params.

That’s all.


Hi all,

This post is about how to find a STRING in stored procedures and triggers.
This tip is VERY useful for those who works with T-SQL.

code
select distinct(object_name(id)) from syscomments
where
text like ‘%string%’

example
select distinct(object_name(id)) from syscomments
where
text like ‘%mytable%’

see ya :D


Segue um código para remover acentos de strings em progress… bem util. :D

Código
FUNCTION removeAcento RETURNS CHARACTER (INPUT pChar AS CHARACTER):
DEFINE VARIABLE iPos AS INTEGER NO-UNDO.
DO iPos = 1 TO LENGTH(pChar):
IF CAN-DO(“á,ã,â,à”,SUBSTRING(pChar,iPos,1)) THEN
ASSIGN SUBSTRING(pChar,iPos,1) = “a”.
END.

DO iPos = 1 TO LENGTH(pChar):
IF CAN-DO(“é,ê,è”,SUBSTRING(pChar,iPos,1)) THEN
ASSIGN SUBSTRING(pChar,iPos,1) = “e”.
END.

DO iPos = 1 TO LENGTH(pChar):
IF CAN-DO(“í,î,ì”,SUBSTRING(pChar,iPos,1)) THEN
ASSIGN SUBSTRING(pChar,iPos,1) = “i”.
END.

DO iPos = 1 TO LENGTH(pChar):
IF CAN-DO(“ó,õ,ô,ò”,SUBSTRING(pChar,iPos,1)) THEN
ASSIGN SUBSTRING(pChar,iPos,1) = “o”.
END.

DO iPos = 1 TO LENGTH(pChar):
IF CAN-DO(“ú,û,ù”,SUBSTRING(pChar,iPos,1)) THEN
ASSIGN SUBSTRING(pChar,iPos,1) = “u”.
END.

RETURN UPPER(pChar).

END FUNCTION.

Exemplo
MESSAGE removeAcento(“ÁCÁícáo”) VIEW-AS ALERT-BOX.

vlw


If your app access the Internet and you have a http proxy, probably you’ll need to set the proxy in your app.

It’s very simple…

Code
Properties systemSettings = System.getProperties();
systemSettings.put(“http.proxyHost”, “host”);
systemSettings.put(“http.proxyPort”, “port”);

Example
Properties systemSettings = System.getProperties();
systemSettings.put(“http.proxyHost”, “server22″);
systemSettings.put(“http.proxyPort”, “8080″);

see you :D


OpenEdge 10.2A simple FAQ

Can the OpenEdge Ultra Controls for .NET be used in any development environment?
A. The OpenEdge Ultra Controls for .NET has a restricted license and can only be used within an OpenEdge environment. Customers wishing to use the Infragistics Controls in a non-OpenEdge environment will have to purchase an unrestricted license directly from Infragistics.

The controls can be purchased and installed only if the customer has one of the following OpenEdge products:
• Development:
• OpenEdge Architect
• OpenEdge Studio
• 4GL Development
• OE Development Server

What are the key features of 10.2A?
• OpenEdge GUI for .NET including a new Visual Designer in OpenEdge Architect
• OpenEdge Ultra Controls for .NET (optional product) (see below for additional information)
• OpenEdge Architect usability and performance enhancements
• New OpenEdge Architect XML, XML schema, and WSDL editors, and XPATH helper
• Additional Object Oriented (OO) extensions, garbage collection
• Oracle DataServer CLOB, and both Oracle and Microsoft SQL Server datetime data type support
• Support for Windows Server 2003 (OpenEdge server products)
• Windows Server 2008 64-bit