Now what?
Filed under: Others | 1 Comment
Tags: internet, redes sociais, tempo, vida
What’s new in OpenEdge 10.2B
Hi all,
Do you want to know what’s new in OpenEdge 10.2B???
http://communities.progress.com/pcom/docs/DOC-103415
cya…
Filed under: Progress | Leave a Comment
Tags: 10.2b, 4gl, abl, documentation, new, openedge, Progress
Using
DLC_installation\bin\bprowsdldoc your_wsdl folder_for_documentation
Sample – MsDOS
cd C:\DLC101B\bin
bprowsdldoc http://myhost:2580/MyService/MyMethod?WSDL c:\myws
Now it’s just open the index page inside the chosen folder.
c:\myws\index.html
Filed under: Progress | Leave a Comment
Tags: 4gl, abl, bprowsdldoc, documentation, openedge, Progress, WebService, ws, wsdl
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

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