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. 
Filed under: Progress | Leave a Comment
Tags: 4gl, abl, architect, Corrupted, dlc, eclipse, openedge, Progress, Workspace
STOP-AFTER – Progress 10.2B
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
Filed under: Progress | Leave a Comment
Tags: 10.2b, 4gl, abl, after, example, feature, oepnedge, Progress, sample, stop, stop-after
Filed under: Ubuntu | Leave a Comment
Tags: error, flash, install, plugin, Ubuntu, uninstall
MAX date in Progress databases
Filed under: Progress | Leave a Comment
Tags: 4gl, abl, code, database, Date, max, openedge, Progress
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.
Filed under: iPod | Leave a Comment
Tags: iphone, iPod, podcast, remove
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.
Filed under: Sql | Leave a Comment
Tags: code, example, microsoft, null, optional, parameters, Procedure, Server, Sql, T-Sql
Função para remover acentos
Segue um código para remover acentos de strings em progress… bem util.
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
Filed under: Progress | Leave a Comment
Tags: 4gl, abl, acentos, exemplo, Function, openedge, Progress, remover
Setting a HTTP Proxy with Java
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
Filed under: Java | Leave a Comment
Tags: code, example, host, http, Java, port, proxy, proxyhost, set
OpenEdge 10.2A simple FAQ
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
Filed under: Progress | Leave a Comment
Tags: 10.2a, 4gl, abl, faq, net, openedge, Progress
-
-
My Google Reader- 11 regras de Bill Gates para uma vida melhor
- Como funcionam as viagens de avião com animais de estimação
- Será que networking existe mesmo?
- A Origem das Linguagens de Patterns
- Follow Up – Uma aplicação gerencial
- As buscas mais populares no Google, Yahoo e Bing em 2009
- Google divulga pesquisas mais populares no Brasil
- Isn't Chrome OS another Linux distribution?
- 2 anos de Scrum e Agile na Globo.com e algumas coisas que eu aprendi
- É fácil fazer bem um software?
- My Wallpapers
Visitors
-
-
T-SQL – Finding strings in procs and triggers
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
Filed under: Sql | Leave a Comment
Tags: example, id, Like, microsoft, mssql, object_name, Procedure, Server, Sql, Stored, String, syscomments, T-Sql, Trigger