Export data

emarc

New Member
Hello.

I need your help.

I have a legacy application in Progress OpenEdge 10.

It doesn't fits our needs any more and we have to port to a newer system. The enterprise who wrote this application was closed last year.

So I have not and I cannot expect to have any password or assistance for the database.

The software application is perfectly active and I have full access to it (it's installed in my computers).

¿ Without knowing database passwords, there is any way I can try to access to his data throught ODBC or I can export a few Tables to Access/Excel/CSV/.... ?.

PS: I have not any knwoledge about Progress OpenEdge, but I'm a Delphi developer with experience using SQL Server, Interbase/Firebird, MySQL, Oracle, etc. ...

Thank you.
 

RealHeavyDude

Well-Known Member
I suppose you are talking about an 4GL application.

Basically there are two options two access an OpenEdge database:
  • Native via the 4GL engine. If you want to access the database outside of the application you need to have some development license installed and must use one of the development tools - most likely the procedure editor. If the vendor of the application has secured the database with user credentials you don't know you might be able to connect the database but you will not be able to access any database table. If that's the case you are probably locked out. The access control of an OpenEdge database is usually characterized by a revoke philosophy and done in the application. If that's the case you might be lucky and the database is not secured at all.
  • Via the SQL engine using the ODBC/JDBC driver that comes with the client runtime with a tool that supports ODBC/JDBC connections of your choice. You must be aware that the OpenEdge database is not a SQL database in the first place - therefore the access differs totally from the native 4GL access and is "more" compliant with what you would expect from any other SQL database. In order to access an OpenEdge database the first time via SQL you have two options:
    • Using the credentials of the Windows account under which the database was created (this account has DBA privileges granted per default).
    • Using the SYSPROGRESS user account you has been created accessing the database via the 4GL engine in the first place (this special account has DBA privileges granted per default).
Either way your first stepping stone to access the database.

Heavy Regards, RealHeavyDude.
 

rstanciu

Member
on windows, click to program files -> OpenEdge -> config (icon) ... and copy/paste to the forum your
configuration to known what you have on options.
search any *.pf files on the server and copy/paste to the forum to known where is the database and the tcp/ip
port number (parameter -S)
or search any *.db, *.b1,*.d1,*.lg,*.lic ... to know the database location.
If you have a icon Program files -> Open Edge -> Procedure Editor , (click) open the application and
write:
CONNECT database_name -S port
and execute using F2
If it works ... go to Tools ->DataDictionary->Admin->Dump-> dump data definition / dump data ....
and you can export data from database to flat files *.d
 

emarc

New Member
Thanks for your help.

on windows, click to program files -> OpenEdge -> config (icon) ... and copy/paste to the forum your
configuration to known what you have on options.

Company Name: XXXXXXXXX
Product Name: OE Studio
Installation Date: Thu Jul 13 11:07:04 2006
User Limit: 1
Expiration Date: None
Serial Number: 003521984
Control Numbers: ZZASS - 6PE2N - MMC?6
Version Number: 10.0B
Machine Class: KB
Port Number: 31

search any *.pf files on the server and copy/paste to the forum to known where is the database and the tcp/ip
port number (parameter -S)
or search any *.db, *.b1,*.d1,*.lg,*.lic ... to know the database location.

Data could be in another server (there are two servers, a terminal server for application execution and another one named as database server). In this database server I can see a shared folder with a lot of subfolders and .r, .w files that appear to be application source code.

This is the config mcs100b.ini (in database server shared folder) that appears in the starting program link :

[Startup]
V6Display=no
;ImmediateDisplay=yes
;MultitaskingInterval=100
DefaultFont=MS Sans Serif, size 8
DefaultFixedFont=Courier New, size 8
PrinterFont=Courier New, size=8
Keep3DFillinBorder=Yes
DLC=c:\oe100b
PROBUILD=c:\oe100b\PROBUILD
PROPATH=.,./FicherosMaestros,./Estadisticas,./Distribucion,./Facturacion,./Utilidades,./Contabilidad,./Financiero,C:\oe100b\GUI,C:\oe100b,C:\oe100b\BIN,C:\oe100b\gui\adecomm.pl,C:\oe100b\gui\adecomp.pl,C:\oe100b\gui\adedesk.pl,C:\oe100b\gui\adedict.pl,C:\oe100b\gui\adeedit.pl,C:\oe100b\gui\adeicon.pl,C:\oe100b\gui\aderes.pl,C:\oe100b\gui\adeshar.pl,C:\oe100b\gui\adetran.pl,C:\oe100b\gui\adeuib.pl,C:\oe100b\gui\adeweb.pl,C:\oe100b\gui\prodict.pl,C:\oe100b\gui\protools.pl,C:\oe100b\SRC
PROMSGS=c:\oe100b\PROMSGS
PROSTARTUP=.\configuraciones\MCS.PF

[Colors]
;******************************************************************************
; THE DEFINITION OF COLOR 0 THROUGH 15 IS PRIVATE TO THE PROGRESS ADE.
; MODIFYING COLORS 0 THROUGH 15 MAY PREVENT THE PROGRESS ADE FROM RUNNING.
; The following color definitions correspond to the ADE standards.
; 0 to 15 - reserved
color0=0,0,0
color1=0,0,128
color2=0,128,0
color3=0,128,128
color4=128,0,0
color5=128,0,128
color6=128,128,0
color7=128,128,128
color8=192,192,192
color9=0,0,255
color10=0,255,0
color11=0,255,255
color12=255,0,0
color13=255,0,255
color14=255,255,0
color15=255,255,255
color16=254,255,225

NORMAL=0,15
INPUT=15,0
MESSAGES=15,1
color17=254,255,225
color18=188,247,250
color19=94,129,193
color20=233,237,245
color21=251,252,253
color22=255,128,128
color23=0,0,0
color24=0,0,0
color25=0,0,0
color26=0,0,0
color27=0,0,0
color28=0,0,0
color29=0,0,0
color30=0,0,0
color31=0,0,0
color32=0,0,0
color33=0,0,0
color34=0,0,0
color35=0,0,0
color36=0,0,0
color37=0,0,0
color38=0,0,0
color39=0,0,0
color40=0,0,0
color41=0,0,0
color42=0,0,0
color43=0,0,0
color44=0,0,0
color45=0,0,0
color46=0,0,0
color47=0,0,0
color48=0,0,0
color49=0,0,0
color50=0,0,0
color51=0,0,0
color52=0,0,0
color53=0,0,0
color54=0,0,0
color55=0,0,0
color56=0,0,0
color57=0,0,0
color58=0,0,0
color59=0,0,0
color60=0,0,0
color61=0,0,0
color62=0,0,0
color63=0,0,0
color64=0,0,0
color65=0,0,0
color66=0,0,0
color67=0,0,0
color68=0,0,0
color69=0,0,0
color70=0,0,0
color71=0,0,0
color72=0,0,0
color73=0,0,0
color74=0,0,0
color75=0,0,0
color76=0,0,0
color77=0,0,0
color78=0,0,0
color79=0,0,0
color80=0,0,0
color81=0,0,0
color82=0,0,0
color83=0,0,0
color84=0,0,0
color85=0,0,0
color86=0,0,0
color87=0,0,0
color88=0,0,0
color89=0,0,0
color90=0,0,0
color91=0,0,0
color92=0,0,0
color93=0,0,0
color94=0,0,0
color95=0,0,0
color96=0,0,0
color97=0,0,0
color98=0,0,0
color99=0,0,0
color100=0,0,0
color101=0,0,0
color102=0,0,0
color103=0,0,0
color104=0,0,0
color105=0,0,0
color106=0,0,0
color107=0,0,0
color108=0,0,0
color109=0,0,0
color110=0,0,0
color111=0,0,0
color112=238,185,87
color113=0,0,0
color114=0,0,0
color115=0,0,0
color116=0,0,0
color117=0,0,0
color118=0,0,0
color119=0,0,0
color120=0,0,0
color121=0,0,0
color122=0,0,0
color123=0,0,0
color124=0,0,0
color125=0,0,0
color126=0,0,0
color127=0,0,0

[Default Window]
;x=
;y=
;rows=
;columns=

[fonts]
;******************************************************************************
; THE DEFINITION OF FONT 0 THROUGH 7 IS PRIVATE TO THE PROGRESS ADE.
; MODIFYING FONTS 0 THROUGH 7 MAY PREVENT THE PROGRESS ADE FROM RUNNING.
; The following fonts definitions correspond to the ADE standards.
; ? - Note choice of DefaultFont above (=FixedSys)
; 0 - Fixed System Font (1 char per PPU)
; 1 - Proportional System Font
; 2 - Editor Font for 4GL program entry
; 3 - TTY Simulator (should be fixed)
; 4 - for dynamically-sized widgets, eg status-line, selection-list
; 5 - static, eg combo-boxes
; 6 - dynamic, bold (TranMan2)
; 7 - reserved
font0=FixedSys
font1=System
font2=Courier New, size=8
font3=Courier New, size=8
font4=MS Sans Serif, size=8
font5=MS Sans Serif, size=10
font6=MS Sans Serif, size=8, bold
font7=System
font8=system,
font9=Courier New, size 9
font10=Fixedsys, size 9
font11=Courier New, size 9
font12=MS Sans Serif, size 8
font13=Arial, size 9
font14=system,
font15=system,
font16=system,
font17=system,
font18=courier new, size 18
font19=system,
font20=courier new, size 20 bold
font21=Timpani, size 8
font22=system,
font23=system,
font24=system,
font25=system,
font26=Timpani, size 10 bold
font27=system,
font28=system,
font29=system,
font30=system,
font31=system,
font32=system,
font33=system,
font34=system,
font35=system,
font36=system,
font37=system,
font38=system,
font39=system,
font40=system,
font41=system,
font42=system,
font43=system,
font44=system,
font45=system,
font46=system,
font47=system,
font48=system,
font49=system,
font50=Courier New, size 11
font51=Courier New, size 10
font52=Courier New, size 8
font53=Courier New, size 7
font54=system,
font55=Courier New, size 11
font56=Courier New, size 10
font57=Courier New, size 8
font58=Courier New, size 7
font59=system,
font60=Courier New, size 11
font61=Courier New, size 10
font62=Courier New, size 8
font63=Courier New, size 7
font64=system,
font65=Courier New, size 11 bold
font66=Courier New, size 10 bold
font67=Courier New, size 8 bold
font68=Courier New, size 7 bold
font69=system,
font70=system,
font71=system,
font72=system,
font73=system,
font74=system,
font75=system,
font76=system,
font77=system,
font78=system,
font79=system,
font80=system,
font81=system,
font82=system,
font83=system,
font84=system,
font85=system,
font86=system,
font87=system,
font88=system,
font89=system,
font90=system,
font91=system,
font92=system,
font93=system,
font94=system,
font95=system,
font96=system,
font97=system,
font98=system,
font99=system,
font100=system,
font101=system,
font102=system,
font103=system,
font104=system,
font105=system,
font106=system,
font107=system,
font108=system,
font109=system,
font110=system,
font111=system,
font112=system,
font113=system,
font114=system,
font115=system,
font116=system,
font117=system,
font118=system,
font119=system,
font120=system,
font121=system,
font122=system,
font123=system,
font124=system,
font125=system,
font126=system,
font127=system,
font128=system,
font129=system,
font130=system,
font131=system,
font132=system,
font133=system,
font134=system,
font135=system,
font136=system,
font137=system,
font138=system,
font139=system,
font140=system,
font141=system,
font142=system,
font143=system,
font144=system,
font145=system,
font146=system,
font147=system,
font148=system,
font149=system,
font150=system,
font151=system,
font152=system,
font153=system,
font154=system,
font155=system,
font156=system,
font157=system,
font158=system,
font159=system,
font160=system,
font161=system,
font162=system,
font163=system,
font164=system,
font165=system,
font166=system,
font167=system,
font168=system,
font169=system,
font170=system,
font171=system,
font172=system,
font173=system,
font174=system,
font175=system,
font176=system,
font177=system,
font178=system,
font179=system,
font180=system,
font181=system,
font182=system,
font183=system,
font184=system,
font185=system,
font186=system,
font187=system,
font188=system,
font189=system,
font190=system,
font191=system,
font192=system,
font193=system,
font194=system,
font195=system,
font196=system,
font197=system,
font198=system,
font199=system,
font200=system,
font201=system,
font202=system,
font203=system,
font204=system,
font205=system,
font206=system,
font207=system,
font208=system,
font209=system,
font210=system,
font211=system,
font212=system,
font213=system,
font214=system,
font215=system,
font216=system,
font217=system,
font218=system,
font219=system,
font220=system,
font221=system,
font222=system,
font223=system,
font224=system,
font225=system,
font226=system,
font227=system,
font228=system,
font229=system,
font230=system,
font231=system,
font232=system,
font233=system,
font234=system,
font235=system,
font236=system,
font237=system,
font238=system,
font239=system,
font240=system,
font241=system,
font242=system,
font243=system,
font244=system,
font245=system,
font246=system,
font247=system,
font248=system,
font249=system,
font250=system,
font251=system,
font252=system,
font253=system,
font254=system,
font255=Courier New, size 8

[Debug-Init]
;******************************************************************************
; THE FOLLOWING INFORMATION IS PRIVATE TO THE DEBUGGER. IT SHOULD NEVER BE
; MODIFIED EXCEPT BY THE DEBUGGER PROGRAM.
;
Location=3,88,88,548,320
Pane0=1,52," "
Pane1=1,8,""
Pane2=1,16,"Commands in Queue: 0"
Pane3=1,25,""
DebuggerName=PRODEBUG.EXE

[Debug-Macros]
Macro0=r, run &file
Macro1=c, continue
Macro2=s, step
Macro3=n, next
Macro4=b, break &file &line
Macro5=cb, cancel break &file &line
Macro6=sb, show breaks
Macro7=ss, show stack
Macro8=u, up
Macro9=d, down
Macro10=di, display &text
Macro11=sm, show macros

[Debug-Buttons]
Button0=Run,run &file
Button1=Cont,continue
Button2=Step,step
Button3=Next,next
Button4=Break,break &file &line
Button5=Stack,show stack
Button6=Up,up
Button7=Down,down
Button8=Disp,display &text
Button9=Exit,exit

[ProADE]
;DividerFgColor=15
;DividerBgColor=1
;OKBoxFgColor=1
;OKBoxBgColor=8
;FillinFgColor=0
;FillinBgColor=8
;Editor4GLFgColor=DEFAULT
;Editor4GLBgColor=DEFAULT
;Editor4GLFgSmallColor=0
;Editor4GLBgSmallColor=8
;FixedFont=0
;StandardFont=1
;Editor4GLFont=2

[Proedit]
SaveSettings=yes
BufList=
ExitWarning=yes
SaveBufList=yes
MinimizeBeforeRun=yes
RestoreAfterRun=yes
PauseAfterRun=yes
AutoCleanup=yes
EditorFont=2
New=SHIFT-F3
Open=F3
Close=F8
NewProcedureWindow=CTRL-F3
Save=F6
SaveAs=SHIFT-F6
Cut=CTRL-X
Copy=CTRL-C
Paste=CTRL-V
Find=CTRL-F
FindNext=F9
FindPrevious=SHIFT-F9
Replace=CTRL-R
GotoLine=CTRL-G
List=CTRL-L
NextBuffer=F7
PreviousBuffer=SHIFT-F7
Information=F4
Run=F2
CheckSyntax=SHIFT-F2
Debug=SHIFT-F4
CompilerMessages=CTRL-E
Contents=
SearchforHelpOn=
MenuCommands=
HowtoUseHelp=
Undo=CTRL-Z

[JAVA]
JREHOME=C:\oe100b\jre
JDKHOME=c:\oe100b\JDK
JRECP=c:\oe100b\jre\lib\rt.jar;c:\oe100b\jre\lib\i18n.jar
JDKCP=c:\oe100b\jdk\lib\tools.jar
FATHOMCP=
REPLCP=
PROGRESSCP=c:\oe100b\Java\progress.jar;c:\oe100b\Java\messages.jar;
JVMEXE=Java
JVMARGS=-ms8m
JAVAPOLICY=c:\oe100b\Java\java.policy

[ReportBuilderDefaults]
EngineParameters=-charset ibm850
DB Platform=PROGRESS
DefMeas=0
PgLM=1
BotM=127
LeftM=127
RightM=127
TopM=127
RulPit=10
VRulPit=10
Pts=90
SnapTo=1
Color=0
WidthRep=1
WidthColor=9
FaceName=Arial
LogF=No
LogT=Yes
LibDir=
ImgDir=
MemExt=TXT
ImgExt=BMP

[ReportBuilderProgress]
OIDNetwork=
OIDHostname=
OIDServername=
Database=c:\pgil\magister.db
UserID=magister
NeedsPassword=Y
Network=
LogicalName=magister
HostName=
Server=
Schema=
ConParameters=

[ReportBuilderSaveList]
NotFirstTime=1
ActionBar=1
FormatBar=1
FieldNames=1
PasteArgs=1
ShHzRul=1
ShVtRul=1
ShGrd=1
Maximize=1
IVer=1
Library=c:\PGIL\REPORTS.PRL
Report=pedidos_proveedores

[Procomp]
SaveSettings=yes
DefFileSpec=*.p *.w
LogFile=compile.log
ShowStatus=yes
RemoveOldRs=yes
IfNoR=no
SubDirs=yes
SaveNewRs=yes
XrefAppend=no
ListAppend=no
PageLength=60
PageWidth=80
V6Frame=No
StreamIO=no
FileSpec09=./word,*.p *.w
FileSpec11=objetosUib/*.p,*.p *.w
FileSpec12=ObjetosUIB/*.w,*.p *.w
FileSpec13=triggers\*.p,*.p *.w
FileSpec14=utilidades/*.p,*.p *.w
FileSpec15=utilidades/*.w,*.p *.w
MinRcodeSize=no
GenerateMD5=no
FileSpec01=.,*.p *.w
FileSpec03=./utilidades,*.p *.w
FileSpec04=./varios,*.p *.w
FileSpec05=./Visitas,*.p *.w
FileSpec06=./vta,*.p *.w
FileSpec08=./vta,*.p *.w

[ProUIB]
SaveSettings=yes
GridFactorHorizontal=1
GridFactorVertical=1
IconDirectories=Bitmaps,.\Bitmaps,adeicon,Bitmaps,c:\jpg
CustomWidgetFile=c:\oe100b\SRC\TEMPLATE\CUSTOM.TXT
AdvisorSettings=----------
PaletteLoc=0,0
PaletteVisualization=Labels
PaletteItemsPerRow=2
CustomObjectFiles=./configuraciones/progress.cst,./configuraciones/smart.cst
GiveHints=no
ShowAdvisor=no
PropertyEditorPosition=263,89,315,366
Disabled_Cue_Cards=SmartViewer

[Debug-Macros]
Macro0=r, run &file
Macro1=c, continue
Macro2=s, step
Macro3=n, next
Macro4=b, break &file &line
Macro5=cb, cancel break &file &line
Macro6=sb, show breaks
Macro7=ss, show stack
Macro8=u, up
Macro9=d, down
Macro10=di, display &text
Macro11=sm, show macros

[Debug-Buttons]
Button0=Run,run &file
Button1=Cont,continue
Button2=Step,step
Button3=Next,next
Button4=Break,break &file &line
Button5=Stack,show stack
Button6=Up,up
Button7=Down,down
Button8=Disp,display &text
Button9=Exit,exit

[ReportBuilderPreferences]
InstantRep=2
PromptFields=1
ScrBarHz=1
ScrBarVt=1
PromptConnection=0

[ProTools]
FunctionDefs=c:\dlc82a\se-pro8\se-tools\protools.dat
PaletteLoc=22,6
ItemsPerRow=4
Visualization=labels
[SE*Tools]
UIBSectionEditorToolbar=yes
UIBAddTapItMenu=yes
UIBAddPROToolsMenu=yes
CD-DRIVE=D:
CD-PATH=\movies

[ImpresorasMCS]
\\apv\oki ml 320 elite (ibm) = \\apv\okiml320

[MCS]
HojasExcel=F:\McsCliDB\Excel
CuentasResultados=F:\McsCliDB\Excel\Resultados
Balances=F:\McsCliDB\Excel\Balances
Root=F:\McsCliDB
Cartas=F:\McsCliDB\Word
Documentacion=F:\McsCliDB\Documentacion
PaginaInicial=F:\McsCliDB\Documentacion\Documentacion.html
SaltAuto=1
ActAuto=1
ImagenLogo = .\bitmaps\Logo_MCS.gif
PaisesComunidad="001,002,003,004,005,006,007,008,009,010,030,032,038,090"
Envio=m:\Cosmetica\Envio
Recepcion=m:\Cosmetica\Recepcion
UsuRep=3
dirTraspaso=C:\tmp
ExtFicTraspaso=*.tmp
OkFicTraspaso=*.ped


[uib]

[ProAB]
SaveSettings=no
MinimizeOnRun=yes
GridFactorHorizontal=1
GridFactorVertical=1
AdvisorSettings=XXXXXXXXXXX
LocalHost=PC2
WebBrowser=C:\Archiv~1\intern~1\iexplore.exe
OpenNewBrowser=yes
WebBroker=http://localhost/scripts/cgiip.exe/WService=wsbroker1
RemoteFileManagement=No
PropertyEditorPosition=30,286,315,293
ABMainLocation=135,2
PaletteLoc=0,0
PaletteItemsPerRow=5
CustomObjectFiles=configuraciones\shared.cst,configuraciones\smart.cst,configuraciones\progress.cst,configuraciones\smartv8.cst
GiveHints=no
ShowAdvisor=no
IconDirectories=Bitmaps,adeicon,.\Bitmaps
MostRecentlyUsedFileList=yes
PrintDialog=yes
MRUEntries=9
MultipleSectionEd=yes
NewObjectToggles=63
TestSetting=OK
MRUFile1=C:\MCS\McsCliDb\Compras\pedir_proveedor.i
MRUFile2=C:\MCS\McsCliDb\Facturacion\SmartVie\vLinAlbaranes.w
MRUFile3=C:\MCS\McsCliDb\Facturacion\VtasGafas_Pr.w
MRUFile4=C:\MCS\McsCliDb\Facturacion\vtaDirecta_pr.w
MRUFile5=C:\MCS\McsCliDb\Facturacion\SmartVie\vPedidosProveedor.w
MRUFile6=C:\MCS\McsCliDb\Facturacion\SmartBro\bPedidosProveedor.w
MRUFile7=C:\MCS\McsCliDb\Busquedas\BuscaCabPedProveedores.w
MRUFile8=C:\MCS\McsCliDb\Busquedas\BuscaPedProDer.w
MRUFile9=C:\MCS\McsCliDb\FicherosMaestros\LisClientes.w




[ADM]
Color3DFace=128
Color3DHighLight=129
Color3DShadow=130
[WidAttr]
ObjRef-Object=Async-request
[Debug-Temp-Macros]
[ProSpy]
TreeFont=Medium
HideADE=FALSE
HideUIB=TRUE

In this shared folder I only see a 32kb .db file (M:\DB\Structure.db). ¿ Can this be the database ?

This is one sample of this .rw source code :

&ANALYZE-SUSPEND _VERSION-NUMBER UIB_v8r12 GUI ADM1
&ANALYZE-RESUME
/* Connected Databases
mcs PROGRESS
*/
&Scoped-define WINDOW-NAME w-win
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _DEFINITIONS w-win
/* (c) MCS . */
/* ****************************************************************** */
/* CopyRight 1998-2000 (c) Metrega Comunicaciones y Servicios, s.l. */
/* CIF B61368825 */
/* C/ Angli, 6 08017 Barcelona (Spain) */
/* soporte@metregacom.com */
/* ****************************************************************** */
/* (c) MCS .. */
/*------------------------------------------------------------------------
File:
Description: from cntnrwin.w - ADM SmartWindow Template
Input Parameters:
<none>
Output Parameters:
<none>
History:

------------------------------------------------------------------------*/
/* This .W file was created with the Progress UIB. */
/*----------------------------------------------------------------------*/
/* Create an unnamed pool to store all the widgets created
by this procedure. This is a good default which assures
that this procedure's triggers and internal procedures
will execute in this procedure's storage, and that proper
cleanup will occur on deletion of the procedure. */
CREATE WIDGET-POOL.
/* *************************** Definitions ************************** */
/* Parameters Definitions --- */
/* Local Variable Definitions --- */
{utilidades/globales.i}

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&ANALYZE-SUSPEND _UIB-PREPROCESSOR-BLOCK

/* ******************** Preprocessor Definitions ******************** */

&Scoped-define PROCEDURE-TYPE SmartWindow
&Scoped-define DB-AWARE no

&Scoped-define ADM-CONTAINER WINDOW

/* Name of first Frame and/or Browse and/or first Query */
&Scoped-define FRAME-NAME F-Main

/* External Tables */
&Scoped-define EXTERNAL-TABLES Clientes
&Scoped-define FIRST-EXTERNAL-TABLE Clientes


/* Need to scope the external tables to this procedure */
DEFINE QUERY external_tables FOR Clientes.
/* Standard List Definitions */
&Scoped-Define ENABLED-OBJECTS btnListados btnSalir RECT-16 RECT-17

/* Custom List Definitions */
/* List-1,List-2,List-3,List-4,List-5,List-6 */

/* _UIB-PREPROCESSOR-BLOCK-END */
&ANALYZE-RESUME



/* *********************** Control Definitions ********************** */

/* Define the widget handle for the window */
DEFINE VAR w-win AS WIDGET-HANDLE NO-UNDO.

/* Menu Definitions */
DEFINE SUB-MENU m_Ayuda
MENU-ITEM m_Acerca_de_ LABEL "Acerca de ..." ACCELERATOR "SHIFT-F1".

DEFINE MENU MENU-BAR-h_w-claves MENUBAR
SUB-MENU m_Ayuda LABEL "&Ayuda" .


/* Definitions of handles for SmartObjects */
DEFINE VARIABLE h_b-clientes AS HANDLE NO-UNDO.
DEFINE VARIABLE h_bcontactoscli-2 AS HANDLE NO-UNDO.
DEFINE VARIABLE h_folder AS HANDLE NO-UNDO.
DEFINE VARIABLE h_p-updsav AS HANDLE NO-UNDO.
DEFINE VARIABLE h_p-updsav-2 AS HANDLE NO-UNDO.
DEFINE VARIABLE h_v-cli1 AS HANDLE NO-UNDO.
DEFINE VARIABLE h_vcontactoscli-2 AS HANDLE NO-UNDO.

/* Definitions of the field level widgets */
DEFINE BUTTON btnListados
IMAGE-UP FILE "Bitmaps\impr_win":U
LABEL "&Listados"
SIZE 7 BY 1.52 TOOLTIP "Imprimir ... (Shift + F3)".

DEFINE BUTTON btnSalir
IMAGE-UP FILE "Bitmaps\salir":U
IMAGE-INSENSITIVE FILE "Bitmaps\saliri":U
LABEL "&Salir"
SIZE 7 BY 1.52.

DEFINE RECTANGLE RECT-16
EDGE-PIXELS 2 GRAPHIC-EDGE NO-FILL
SIZE 9 BY 2.

DEFINE RECTANGLE RECT-17
EDGE-PIXELS 2 GRAPHIC-EDGE NO-FILL
SIZE 9 BY 2.


/* ************************ Frame Definitions *********************** */

DEFINE FRAME F-Main
btnListados AT ROW 22.19 COL 87
btnSalir AT ROW 22.19 COL 150
RECT-16 AT ROW 22 COL 86
RECT-17 AT ROW 21.95 COL 149
WITH 1 DOWN NO-BOX KEEP-TAB-ORDER OVERLAY
SIDE-LABELS NO-UNDERLINE THREE-D
AT COL 1 ROW 1
SIZE 158.6 BY 23.19.


/* *********************** Procedure Settings ************************ */

&ANALYZE-SUSPEND _PROCEDURE-SETTINGS
/* Settings for THIS-PROCEDURE
Type: SmartWindow
External Tables: MCS.Clientes
Allow: Basic,Browse,DB-Fields,Query,Smart,Window
Design Page: 2
Other Settings: COMPILE
*/
&ANALYZE-RESUME _END-PROCEDURE-SETTINGS

/* ************************* Create Window ************************** */

&ANALYZE-SUSPEND _CREATE-WINDOW
IF SESSION:DISPLAY-TYPE = "GUI":U THEN
CREATE WINDOW w-win ASSIGN
HIDDEN = YES
TITLE = "Entrada/Mant. de Clientes"
HEIGHT = 23.14
WIDTH = 158.8
MAX-HEIGHT = 32.38
MAX-WIDTH = 204.8
VIRTUAL-HEIGHT = 32.38
VIRTUAL-WIDTH = 204.8
RESIZE = no
SCROLL-BARS = no
STATUS-AREA = yes
BGCOLOR = ?
FGCOLOR = ?
PRIVATE-DATA = "mcs"
THREE-D = yes
MESSAGE-AREA = no
SENSITIVE = yes.
ELSE {&WINDOW-NAME} = CURRENT-WINDOW.

ASSIGN {&WINDOW-NAME}:MENUBAR = MENU MENU-BAR-h_w-claves:HANDLE.

&IF '{&WINDOW-SYSTEM}' NE 'TTY' &THEN
IF NOT w-win:LOAD-ICON("Bitmaps\mcs":U) THEN
MESSAGE "Unable to load icon: Bitmaps\mcs"
VIEW-AS ALERT-BOX WARNING BUTTONS OK.
&ENDIF

&IF '{&WINDOW-SYSTEM}' NE 'TTY' &THEN
IF NOT w-win:LOAD-SMALL-ICON("Bitmaps\mcs":U) THEN
MESSAGE "Unable to load small icon: Bitmaps\mcs"
VIEW-AS ALERT-BOX WARNING BUTTONS OK.
&ENDIF
/* END WINDOW DEFINITION */
&ANALYZE-RESUME

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _INCLUDED-LIB w-win
/* ************************* Included-Libraries *********************** */
{src/adm/method/containr.i}

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME




/* *********** Runtime Attributes and AppBuilder Settings *********** */

&ANALYZE-SUSPEND _RUN-TIME-ATTRIBUTES
/* SETTINGS FOR WINDOW w-win
VISIBLE,,RUN-PERSISTENT */
/* SETTINGS FOR FRAME F-Main
Custom */
IF SESSION:DISPLAY-TYPE = "GUI":U AND VALID-HANDLE(w-win)
THEN w-win:HIDDEN = yes.

/* _RUN-TIME-ATTRIBUTES-END */
&ANALYZE-RESUME





/* ************************ Control Triggers ************************ */

&Scoped-define SELF-NAME w-win
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL w-win w-win
ON END-ERROR OF w-win /* Entrada/Mant. de Clientes */
OR ENDKEY OF {&WINDOW-NAME} ANYWHERE DO:
/* This case occurs when the user presses the "Esc" key.
In a persistently run window, just ignore this. If we did not, the
application would exit. */
IF THIS-PROCEDURE:pERSISTENT THEN RETURN NO-APPLY.
END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL w-win w-win
ON WINDOW-CLOSE OF w-win /* Entrada/Mant. de Clientes */
DO:
/* This ADM code must be left here in order for the SmartWindow
and its descendents to terminate properly on exit. */
APPLY "CLOSE":U TO THIS-PROCEDURE.
RETURN NO-APPLY.
END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&Scoped-define SELF-NAME F-Main
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F-Main w-win
ON ALT-C OF FRAME F-Main
anywhere
DO:
run select-page(3).
END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F-Main w-win
ON ALT-F OF FRAME F-Main
ANYWHERE
DO:
run select-page(2).
END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F-Main w-win
ON ALT-G OF FRAME F-Main
anywhere
DO:
run select-page(1).
END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F-Main w-win
ON F11 OF FRAME F-Main
ANYWHERE
DO:
apply "close" to this-procedure. /*canvi 25/8/98*/
return no-apply.
END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&Scoped-define SELF-NAME btnListados
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL btnListados w-win
ON CHOOSE OF btnListados IN FRAME F-Main /* Listados */
OR SHIFT-F3 OF {&WINDOW-NAME} ANYWHERE
DO:
run FicherosMaestros/LisClientes.w .
END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&Scoped-define SELF-NAME btnSalir
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL btnSalir w-win
ON CHOOSE OF btnSalir IN FRAME F-Main /* Salir */
DO:
apply "close" to this-procedure. /*canvi 25/8/98*/
return no-apply.
END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&Scoped-define SELF-NAME m_Acerca_de_
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL m_Acerca_de_ w-win
ON CHOOSE OF MENU-ITEM m_Acerca_de_ /* Acerca de ... */
DO:
create widget-pool "Acerca".
{pracerca.wi}.
NombrePrograma = this-procedure:file-name.
DISPLAY NombrePrograma
WITH FRAME ABOUT.
ENABLE ImagenSCSI RECT-1 btnCorrecto
WITH FRAME ABOUT.
ASSIGN FRAME ABOUT:HIDDEN = NO.


WAIT-FOR GO OF FRAME ABOUT .
HIDE FRAME ABOUT.
DELETE WIDGET-POOL "Acerca".
END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&UNDEFINE SELF-NAME

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _MAIN-BLOCK w-win


/* *************************** Main Block *************************** */
/* Include custom Main Block code for SmartWindows. */
{src/adm/template/windowmn.i}

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


/* ********************** Internal Procedures *********************** */

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE adm-create-objects w-win _ADM-CREATE-OBJECTS
PROCEDURE adm-create-objects :
/*------------------------------------------------------------------------------
Purpose: Create handles for all SmartObjects used in this procedure.
After SmartObjects are initialized, then SmartLinks are added.
Parameters: <none>
------------------------------------------------------------------------------*/
DEFINE VARIABLE adm-current-page AS INTEGER NO-UNDO.

RUN get-attribute IN THIS-PROCEDURE ('Current-Page':U).
ASSIGN adm-current-page = INTEGER(RETURN-VALUE).

CASE adm-current-page:

WHEN 0 THEN DO:
RUN init-object IN THIS-PROCEDURE (
INPUT 'FicherosMaestros/SmartBro/bClientes.w':U ,
INPUT FRAME F-Main:HANDLE ,
INPUT 'Layout = ':U ,
OUTPUT h_b-clientes ).
RUN set-position IN h_b-clientes ( 1.00 , 1.00 ) NO-ERROR.
RUN set-size IN h_b-clientes ( 23.10 , 37.00 ) NO-ERROR.

RUN init-object IN THIS-PROCEDURE (
INPUT 'adm/objects/folder.w':U ,
INPUT FRAME F-Main:HANDLE ,
INPUT 'FOLDER-LABELS = ':U + '&General|&Telf./Conta' + ',
FOLDER-TAB-TYPE = 1':U ,
OUTPUT h_folder ).
RUN set-position IN h_folder ( 1.00 , 39.00 ) NO-ERROR.
RUN set-size IN h_folder ( 20.76 , 120.00 ) NO-ERROR.

RUN init-object IN THIS-PROCEDURE (
INPUT 'objetosuib/p-updsav.w':U ,
INPUT FRAME F-Main:HANDLE ,
INPUT 'Edge-Pixels = 2,
SmartPanelType = Save,
AddFunction = One-Record':U ,
OUTPUT h_p-updsav ).
RUN set-position IN h_p-updsav ( 22.00 , 39.00 ) NO-ERROR.
RUN set-size IN h_p-updsav ( 2.00 , 44.00 ) NO-ERROR.

/* Links to SmartFolder h_folder. */
RUN add-link IN adm-broker-hdl ( h_folder , 'Page':U , THIS-PROCEDURE ).

/* Adjust the tab order of the smart objects. */
RUN adjust-tab-order IN adm-broker-hdl ( h_b-clientes ,
btnSalir:HANDLE IN FRAME F-Main , 'AFTER':U ).
RUN adjust-tab-order IN adm-broker-hdl ( h_folder ,
h_b-clientes , 'AFTER':U ).
RUN adjust-tab-order IN adm-broker-hdl ( h_p-updsav ,
h_folder , 'AFTER':U ).
END. /* Page 0 */
WHEN 1 THEN DO:
RUN init-object IN THIS-PROCEDURE (
INPUT 'ficherosmaestros/smartvie/vcligeneral.w':U ,
INPUT FRAME F-Main:HANDLE ,
INPUT 'Layout = ':U ,
OUTPUT h_v-cli1 ).
RUN set-position IN h_v-cli1 ( 2.71 , 40.80 ) NO-ERROR.
/* Size in UIB: ( 17.62 , 116.00 ) */

/* Links to SmartViewer h_v-cli1. */
RUN add-link IN adm-broker-hdl ( h_b-clientes , 'Record':U , h_v-cli1 ).
RUN add-link IN adm-broker-hdl ( h_p-updsav , 'TableIO':U , h_v-cli1 ).

/* Adjust the tab order of the smart objects. */
RUN adjust-tab-order IN adm-broker-hdl ( h_b-clientes ,
btnSalir:HANDLE IN FRAME F-Main , 'AFTER':U ).
RUN adjust-tab-order IN adm-broker-hdl ( h_folder ,
h_b-clientes , 'AFTER':U ).
RUN adjust-tab-order IN adm-broker-hdl ( h_p-updsav ,
h_folder , 'AFTER':U ).
RUN adjust-tab-order IN adm-broker-hdl ( h_v-cli1 ,
h_p-updsav , 'AFTER':U ).
END. /* Page 1 */
WHEN 2 THEN DO:
RUN init-object IN THIS-PROCEDURE (
INPUT 'ficherosmaestros/smartbro/bcontactoscli.w':U ,
INPUT FRAME F-Main:HANDLE ,
INPUT 'Layout = ':U ,
OUTPUT h_bcontactoscli-2 ).
RUN set-position IN h_bcontactoscli-2 ( 4.57 , 40.60 ) NO-ERROR.
RUN set-size IN h_bcontactoscli-2 ( 5.24 , 117.00 ) NO-ERROR.

RUN init-object IN THIS-PROCEDURE (
INPUT 'objetosuib/p-updsav.w':U ,
INPUT FRAME F-Main:HANDLE ,
INPUT 'Edge-Pixels = 2,
SmartPanelType = Save,
AddFunction = One-Record':U ,
OUTPUT h_p-updsav-2 ).
RUN set-position IN h_p-updsav-2 ( 16.05 , 96.00 ) NO-ERROR.
RUN set-size IN h_p-updsav-2 ( 1.91 , 44.00 ) NO-ERROR.

RUN init-object IN THIS-PROCEDURE (
INPUT 'ficherosmaestros/smartvie/vcontactoscli.w':U ,
INPUT FRAME F-Main:HANDLE ,
INPUT 'Layout = ':U ,
OUTPUT h_vcontactoscli-2 ).
RUN set-position IN h_vcontactoscli-2 ( 9.81 , 60.00 ) NO-ERROR.
/* Size in UIB: ( 6.19 , 80.00 ) */

/* Links to SmartBrowser h_bcontactoscli-2. */
RUN add-link IN adm-broker-hdl ( h_b-clientes , 'Record':U , h_bcontactoscli-2 ).

/* Links to SmartViewer h_vcontactoscli-2. */
RUN add-link IN adm-broker-hdl ( h_bcontactoscli-2 , 'Record':U , h_vcontactoscli-2 ).
RUN add-link IN adm-broker-hdl ( h_p-updsav-2 , 'TableIO':U , h_vcontactoscli-2 ).

/* Adjust the tab order of the smart objects. */
RUN adjust-tab-order IN adm-broker-hdl ( h_b-clientes ,
btnSalir:HANDLE IN FRAME F-Main , 'AFTER':U ).
RUN adjust-tab-order IN adm-broker-hdl ( h_folder ,
h_b-clientes , 'AFTER':U ).
RUN adjust-tab-order IN adm-broker-hdl ( h_p-updsav ,
h_folder , 'AFTER':U ).
RUN adjust-tab-order IN adm-broker-hdl ( h_bcontactoscli-2 ,
h_p-updsav , 'AFTER':U ).
RUN adjust-tab-order IN adm-broker-hdl ( h_p-updsav-2 ,
h_bcontactoscli-2 , 'AFTER':U ).
RUN adjust-tab-order IN adm-broker-hdl ( h_vcontactoscli-2 ,
h_p-updsav-2 , 'AFTER':U ).
END. /* Page 2 */

END CASE.
/* Select a Startup page. */
IF adm-current-page eq 0
THEN RUN select-page IN THIS-PROCEDURE ( 1 ).

END PROCEDURE.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE adm-row-available w-win _ADM-ROW-AVAILABLE
PROCEDURE adm-row-available :
/*------------------------------------------------------------------------------
Purpose: Dispatched to this procedure when the Record-
Source has a new row available. This procedure
tries to get the new row (or foriegn keys) from
the Record-Source and process it.
Parameters: <none>
------------------------------------------------------------------------------*/

/* Define variables needed by this internal procedure. */
{src/adm/template/row-head.i}

/* Create a list of all the tables that we need to get. */
{src/adm/template/row-list.i "Clientes"}

/* Get the record ROWID's from the RECORD-SOURCE. */
{src/adm/template/row-get.i}

/* FIND each record specified by the RECORD-SOURCE. */
{src/adm/template/row-find.i "Clientes"}

/* Process the newly available records (i.e. display fields,
open queries, and/or pass records on to any RECORD-TARGETS). */
{src/adm/template/row-end.i}

END PROCEDURE.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE disable_UI w-win _DEFAULT-DISABLE
PROCEDURE disable_UI :
/*------------------------------------------------------------------------------
Purpose: DISABLE the User Interface
Parameters: <none>
Notes: Here we clean-up the user-interface by deleting
dynamic widgets we have created and/or hide
frames. This procedure is usually called when
we are ready to "clean-up" after running.
------------------------------------------------------------------------------*/
/* Delete the WINDOW we created */
IF SESSION:DISPLAY-TYPE = "GUI":U AND VALID-HANDLE(w-win)
THEN DELETE WIDGET w-win.
IF THIS-PROCEDURE:pERSISTENT THEN DELETE PROCEDURE THIS-PROCEDURE.
END PROCEDURE.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE enable_UI w-win _DEFAULT-ENABLE
PROCEDURE enable_UI :
/*------------------------------------------------------------------------------
Purpose: ENABLE the User Interface
Parameters: <none>
Notes: Here we display/view/enable the widgets in the
user-interface. In addition, OPEN all queries
associated with each FRAME and BROWSE.
These statements here are based on the "Other
Settings" section of the widget Property Sheets.
------------------------------------------------------------------------------*/
ENABLE btnListados btnSalir RECT-16 RECT-17
WITH FRAME F-Main IN WINDOW w-win.
{&OPEN-BROWSERS-IN-QUERY-F-Main}
VIEW w-win.
END PROCEDURE.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE LeerCodigoCliente w-win
PROCEDURE LeerCodigoCliente :
/*------------------------------------------------------------------------------
Purpose:
Parameters: <none>
Notes:
------------------------------------------------------------------------------*/
define output parameter CCliente as char.
run LeerCodCliente in h_v-cli1 ( output CCliente ).
END PROCEDURE.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE local-exit w-win
PROCEDURE local-exit :
/* -----------------------------------------------------------
Purpose: Starts an "exit" by APPLYing CLOSE event, which starts "destroy".
Parameters: <none>
Notes: If activated, should APPLY CLOSE, *not* dispatch adm-exit.
-------------------------------------------------------------*/
APPLY "CLOSE":U TO THIS-PROCEDURE.

RETURN.

END PROCEDURE.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE local-initialize w-win
PROCEDURE local-initialize :
/*------------------------------------------------------------------------------
Purpose: Override standard ADM method
Notes:
------------------------------------------------------------------------------*/
/* Code placed here will execute PRIOR to standard behavior. */
/* Dispatch standard ADM method. */
RUN dispatch IN THIS-PROCEDURE ( INPUT 'initialize':U ) .
/* Code placed here will execute AFTER standard behavior. */
RUN init-pages("1,2,3,4").

/* RUN SELECT-PAGE(4).
RUN SELECT-PAGE(3).
RUN SELECT-PAGE(2).
RUN SELECT-PAGE(1).*/

END PROCEDURE.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE local-view w-win
PROCEDURE local-view :
/*------------------------------------------------------------------------------
Purpose: Override standard ADM method
Notes:
------------------------------------------------------------------------------*/
/* Code placed here will execute PRIOR to standard behavior. */
/* Dispatch standard ADM method. */
RUN dispatch IN THIS-PROCEDURE ( INPUT 'view':U ) .
/* Code placed here will execute AFTER standard behavior. */
RUN titular.

END PROCEDURE.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE send-records w-win _ADM-SEND-RECORDS
PROCEDURE send-records :
/*------------------------------------------------------------------------------
Purpose: Send record ROWID's for all tables used by
this file.
Parameters: see template/snd-head.i
------------------------------------------------------------------------------*/

/* Define variables needed by this internal procedure. */
{src/adm/template/snd-head.i}

/* For each requested table, put it's ROWID in the output list. */
{src/adm/template/snd-list.i "Clientes"}

/* Deal with any unexpected table requests before closing. */
{src/adm/template/snd-end.i}

END PROCEDURE.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE state-changed w-win
PROCEDURE state-changed :
/* -----------------------------------------------------------
Purpose:
Parameters: <none>
Notes:
-------------------------------------------------------------*/
DEFINE INPUT PARAMETER p-issuer-hdl AS HANDLE NO-UNDO.
DEFINE INPUT PARAMETER p-state AS CHARACTER NO-UNDO.
END PROCEDURE.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE titular w-win
PROCEDURE titular :
/*------------------------------------------------------------------------------
Purpose:
Parameters: <none>
Notes:
------------------------------------------------------------------------------*/
RUN LeerEmpresa in BuscarProgramaPrincipal() ( output EmpresaWhere ).
RUN LeerNombreEmpresa in BuscarProgramaPrincipal() ( output NombreEmpresa ).
w-win:title = w-win:title + " " +
"(" + NombreEmpresa + ")".

END PROCEDURE.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME

If you have a icon Program files -> Open Edge -> Procedure Editor , (click) open the application and
write:
CONNECT database_name -S port
and execute using F2
If it works ... go to Tools ->DataDictionary->Admin->Dump-> dump data definition / dump data ....
and you can export data from database to flat files *.d

No, I don't have an Procedure Editor icon.

I have :

Progress Dynamics (Dynamics Configuration Utiliity / Dynamics Developement / Dynamics Runtime / Dynamics Runtime with AppServer / Start Dynamics DB Servers / Stop Dynamics DB Servers)
4GL Batch Engine
Add Components
AppBuilder
Application Compiler
Character Client
Client
Config
Data Administration
Data dictionary
Debugger
Desktop
Help
License Update
Proenv
Progress Explorer Tool
Proxy Generator
Release Notes
RESULTS
SpeedStart
SQL Explorer Tool
Unistall OpenEdge
Version Info

I have tried Data Dictionary icon, but I don't know what input I need to connect to the database.
 

rstanciu

Member
I think is a web-client application, the configuration of the database connection can be in the file:
c:\oe100b\properties\ubroker.properties
and/or
c:\oe100b\properties\conmgr.properties

search for -db mcs

or search a file named "mcs.db" and in data-dictionary connect database name mcs and physical database
the file you find, puch "details or options" ->> check multiple connection. It have to woks

... take a look to the shotcut " Start Dynamics DB Servers" properties, may be to find the database
connection informations
 
Top