Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #7679 > unrolled thread

Change the Path for EXE of DLL file using VO28SDK - Adam functions

Started by"Marc Verkade [MITCon]" <marc@mitNOSPAMconDELETE.nl>
First post2015-01-22 19:31 +0100
Last post2015-02-17 19:19 +0100
Articles 8 — 4 participants

Back to article view | Back to comp.lang.clipper.visual-objects


Contents

  Change the Path for EXE of DLL file using VO28SDK - Adam functions "Marc Verkade [MITCon]" <marc@mitNOSPAMconDELETE.nl> - 2015-01-22 19:31 +0100
    Re: Change the Path for EXE of DLL file using VO28SDK - Adam functions JohnMartens <martens@tennishulp.info> - 2015-01-22 20:30 +0100
      Re: Change the Path for EXE of DLL file using VO28SDK - Adam functions "Marc Verkade [MITCon]" <marc@mitNOSPAMconDELETE.nl> - 2015-01-23 00:33 +0100
        Re: Change the Path for EXE of DLL file using VO28SDK - Adam functions rui.gominho@gmail.com - 2015-02-04 07:07 -0800
          Re: Change the Path for EXE of DLL file using VO28SDK - Adam functions "Marc Verkade [MITCon]" <marc@mitNOSPAMconDELETE.nl> - 2015-02-06 13:36 +0100
            Re: Change the Path for EXE of DLL file using VO28SDK - Adam functions "Willie Moore" <williem@wmconsulting.com> - 2015-02-12 11:12 -0600
            Re: Change the Path for EXE of DLL file using VO28SDK - Adam functions rui.gominho@gmail.com - 2015-02-16 03:14 -0800
              Re: Change the Path for EXE of DLL file using VO28SDK - Adam functions "Marc Verkade [MITCon]" <marc@mitNOSPAMconDELETE.nl> - 2015-02-17 19:19 +0100

#7679 — Change the Path for EXE of DLL file using VO28SDK - Adam functions

From"Marc Verkade [MITCon]" <marc@mitNOSPAMconDELETE.nl>
Date2015-01-22 19:31 +0100
SubjectChange the Path for EXE of DLL file using VO28SDK - Adam functions
Message-ID<hmbww.196813$5S.5942@fx06.am1>
Hello to all,

I am creating a conversion app that interacts with ADAM.
Now I want to set the path of an application programmatically but I lack the 
proper documentation to do that.
I want to set the Path for EXE and DLL files, probably using the 
AppSetOptions SDK method.

Does anybody have a code snipped to show me how to do that?
Here a code snippet to show what I am doing and want to do....

// Open the project
SELF:_RepoProject:=repoProject{SELF:_RepoRepository:CurrentProject}

// Open the applications
DO CASE
CASE SELF:_RepoProject==NULL_OBJECT
    MC_WarningBox(MC_StringMerge1("Could not select project '%1'. Make sure 
it is not opened in VO!",sProject))
    // Add comment
    SELF:LogAdd("ERROR: Project not opened : "+sProject)
OTHERWISE

    // Add comment
    SELF:LogAdd("Project opened : "+sProject)

    // Get the apps
    aApps:=SELF:_RepoProject:Applications
    FOR dwAppPointer:=1 UPTO ALen(aApps)

        // Get an app
        oApp:=aApps[dwAppPointer]
        sApp:=oApp:Name
        SELF:LogAdd("Using application : "+sApp)

        // 
*******************************************************************
        // Now set the EXE or DLL path of this app so generating the EXE/DLL 
will save it at that specific location
        // Does anybody have a clue how to do that?
        // 
*******************************************************************

    NEXT dwAppPointer
END 

[toc] | [next] | [standalone]


#7681

FromJohnMartens <martens@tennishulp.info>
Date2015-01-22 20:30 +0100
Message-ID<m9rj2l$jju$1@dont-email.me>
In reply to#7679
Hi Marc,

This is what I found in the Help of RepoScript. I think the syntax of 
RepoScript is similar like the ADAM syntax.
I suppose you can read the German text as tey are our neigbours.

Is this of any help ?

Cheers,
John



appSetExeName()


Verwendung

Setzt den Namen der Exe-/DLL-Datei in einer Applikation.

Syntax

appSetExeName(<cFile>) Æ lSuccess



appSetExeName(<cApplication>, <cFile>) Æ lSuccess

Argumente

<cApplication> Name der Applikation, für die der Name der Exe-/DLL-Datei 
gesetzt werden soll.



Wenn das Argument nicht übergeben wird, dann bezieht sich der Befehl auf 
die aktuelle Applikation. Diese kann beispielsweise mit den Funktionen 
appSearch(), appGetFirst() oder appGetNext() aktiviert werden.



Datentyp: String



<cFile> Name der Exe-/DLL-Datei, der gesetzt werden sell.

Datentyp: String

Rückgabewert

lSuccess Status der Operation.

TRUE Der Name der Exe-/DLL-Datei wurde gesetzt.

FALSE Der Name der Exe-/DLL-Datei konnte nicht gesetzt werden.

Datentyp: Logic

Beschreibung

appSetExeName() setzt in einer Applikation vom Typ Application den Namen 
der EXE-Datei bzw. in einer Applikation vom Typ DLL den Namen der DLL-Datei.



Unter dem Namen der Exe-/DLL-Datei wird eine Applikation mittels der 
Funktion appBuild() als externe Datei auf einen Datenträger erzeugt.



Mit der Funktion appGetExeName() kann der Name der Exe-/DLL-Datei 
abgefragt werden.



Marc Verkade [MITCon] schreef op 22-1-2015 om 19:31:
> Hello to all,
>
> I am creating a conversion app that interacts with ADAM.
> Now I want to set the path of an application programmatically but I lack
> the proper documentation to do that.
> I want to set the Path for EXE and DLL files, probably using the
> AppSetOptions SDK method.
>
> Does anybody have a code snipped to show me how to do that?
> Here a code snippet to show what I am doing and want to do....
>
> // Open the project
> SELF:_RepoProject:=repoProject{SELF:_RepoRepository:CurrentProject}
>
> // Open the applications
> DO CASE
> CASE SELF:_RepoProject==NULL_OBJECT
>     MC_WarningBox(MC_StringMerge1("Could not select project '%1'. Make
> sure it is not opened in VO!",sProject))
>     // Add comment
>     SELF:LogAdd("ERROR: Project not opened : "+sProject)
> OTHERWISE
>
>     // Add comment
>     SELF:LogAdd("Project opened : "+sProject)
>
>     // Get the apps
>     aApps:=SELF:_RepoProject:Applications
>     FOR dwAppPointer:=1 UPTO ALen(aApps)
>
>         // Get an app
>         oApp:=aApps[dwAppPointer]
>         sApp:=oApp:Name
>         SELF:LogAdd("Using application : "+sApp)
>
>         //
> *******************************************************************
>         // Now set the EXE or DLL path of this app so generating the
> EXE/DLL will save it at that specific location
>         // Does anybody have a clue how to do that?
>         //
> *******************************************************************
>
>     NEXT dwAppPointer
> END

[toc] | [prev] | [next] | [standalone]


#7683

From"Marc Verkade [MITCon]" <marc@mitNOSPAMconDELETE.nl>
Date2015-01-23 00:33 +0100
Message-ID<lNfww.79325$744.69667@fe60.am1>
In reply to#7681
Thanx. ,that was what Robert also suggested.
I will try that.
Regards, Marc Verkade

"JohnMartens"  schreef in bericht news:m9rj2l$jju$1@dont-email.me...

Hi Marc,

This is what I found in the Help of RepoScript. I think the syntax of
RepoScript is similar like the ADAM syntax.
I suppose you can read the German text as tey are our neigbours.

Is this of any help ?

Cheers,
John



appSetExeName()


Verwendung

Setzt den Namen der Exe-/DLL-Datei in einer Applikation.

Syntax

appSetExeName(<cFile>) Æ lSuccess



appSetExeName(<cApplication>, <cFile>) Æ lSuccess

Argumente

<cApplication> Name der Applikation, für die der Name der Exe-/DLL-Datei
gesetzt werden soll.



Wenn das Argument nicht übergeben wird, dann bezieht sich der Befehl auf
die aktuelle Applikation. Diese kann beispielsweise mit den Funktionen
appSearch(), appGetFirst() oder appGetNext() aktiviert werden.



Datentyp: String



<cFile> Name der Exe-/DLL-Datei, der gesetzt werden sell.

Datentyp: String

Rückgabewert

lSuccess Status der Operation.

TRUE Der Name der Exe-/DLL-Datei wurde gesetzt.

FALSE Der Name der Exe-/DLL-Datei konnte nicht gesetzt werden.

Datentyp: Logic

Beschreibung

appSetExeName() setzt in einer Applikation vom Typ Application den Namen
der EXE-Datei bzw. in einer Applikation vom Typ DLL den Namen der DLL-Datei.



Unter dem Namen der Exe-/DLL-Datei wird eine Applikation mittels der
Funktion appBuild() als externe Datei auf einen Datenträger erzeugt.



Mit der Funktion appGetExeName() kann der Name der Exe-/DLL-Datei
abgefragt werden.



Marc Verkade [MITCon] schreef op 22-1-2015 om 19:31:
> Hello to all,
>
> I am creating a conversion app that interacts with ADAM.
> Now I want to set the path of an application programmatically but I lack
> the proper documentation to do that.
> I want to set the Path for EXE and DLL files, probably using the
> AppSetOptions SDK method.
>
> Does anybody have a code snipped to show me how to do that?
> Here a code snippet to show what I am doing and want to do....
>
> // Open the project
> SELF:_RepoProject:=repoProject{SELF:_RepoRepository:CurrentProject}
>
> // Open the applications
> DO CASE
> CASE SELF:_RepoProject==NULL_OBJECT
>     MC_WarningBox(MC_StringMerge1("Could not select project '%1'. Make
> sure it is not opened in VO!",sProject))
>     // Add comment
>     SELF:LogAdd("ERROR: Project not opened : "+sProject)
> OTHERWISE
>
>     // Add comment
>     SELF:LogAdd("Project opened : "+sProject)
>
>     // Get the apps
>     aApps:=SELF:_RepoProject:Applications
>     FOR dwAppPointer:=1 UPTO ALen(aApps)
>
>         // Get an app
>         oApp:=aApps[dwAppPointer]
>         sApp:=oApp:Name
>         SELF:LogAdd("Using application : "+sApp)
>
>         //
> *******************************************************************
>         // Now set the EXE or DLL path of this app so generating the
> EXE/DLL will save it at that specific location
>         // Does anybody have a clue how to do that?
>         //
> *******************************************************************
>
>     NEXT dwAppPointer
> END 

[toc] | [prev] | [next] | [standalone]


#7711

Fromrui.gominho@gmail.com
Date2015-02-04 07:07 -0800
Message-ID<09512981-2e16-4caa-b308-0765800e91af@googlegroups.com>
In reply to#7683
On Thursday, January 22, 2015 at 11:33:39 PM UTC, Marc Verkade [MITCon] wrote:
> Thanx. ,that was what Robert also suggested.
> I will try that.
> Regards, Marc Verkade
> 
> "JohnMartens"  schreef in bericht news:m9rj2l$jju$1@dont-email.me...
> 
> Hi Marc,
> 
> This is what I found in the Help of RepoScript. I think the syntax of
> RepoScript is similar like the ADAM syntax.
> I suppose you can read the German text as tey are our neigbours.
> 
> Is this of any help ?
> 
> Cheers,
> John
> 
> 
> 
> appSetExeName()
> 
> 
> Verwendung
> 
> Setzt den Namen der Exe-/DLL-Datei in einer Applikation.
> 
> Syntax
> 
> appSetExeName(<cFile>) Æ lSuccess
> 
> 
> 
> appSetExeName(<cApplication>, <cFile>) Æ lSuccess
> 
> Argumente
> 
> <cApplication> Name der Applikation, für die der Name der Exe-/DLL-Datei
> gesetzt werden soll.
> 
> 
> 
> Wenn das Argument nicht übergeben wird, dann bezieht sich der Befehl auf
> die aktuelle Applikation. Diese kann beispielsweise mit den Funktionen
> appSearch(), appGetFirst() oder appGetNext() aktiviert werden.
> 
> 
> 
> Datentyp: String
> 
> 
> 
> <cFile> Name der Exe-/DLL-Datei, der gesetzt werden sell.
> 
> Datentyp: String
> 
> Rückgabewert
> 
> lSuccess Status der Operation.
> 
> TRUE Der Name der Exe-/DLL-Datei wurde gesetzt.
> 
> FALSE Der Name der Exe-/DLL-Datei konnte nicht gesetzt werden.
> 
> Datentyp: Logic
> 
> Beschreibung
> 
> appSetExeName() setzt in einer Applikation vom Typ Application den Namen
> der EXE-Datei bzw. in einer Applikation vom Typ DLL den Namen der DLL-Datei.
> 
> 
> 
> Unter dem Namen der Exe-/DLL-Datei wird eine Applikation mittels der
> Funktion appBuild() als externe Datei auf einen Datenträger erzeugt.
> 
> 
> 
> Mit der Funktion appGetExeName() kann der Name der Exe-/DLL-Datei
> abgefragt werden.
> 
> 
> 
> Marc Verkade [MITCon] schreef op 22-1-2015 om 19:31:
> > Hello to all,
> >
> > I am creating a conversion app that interacts with ADAM.
> > Now I want to set the path of an application programmatically but I lack
> > the proper documentation to do that.
> > I want to set the Path for EXE and DLL files, probably using the
> > AppSetOptions SDK method.
> >
> > Does anybody have a code snipped to show me how to do that?
> > Here a code snippet to show what I am doing and want to do....
> >
> > // Open the project
> > SELF:_RepoProject:=repoProject{SELF:_RepoRepository:CurrentProject}
> >
> > // Open the applications
> > DO CASE
> > CASE SELF:_RepoProject==NULL_OBJECT
> >     MC_WarningBox(MC_StringMerge1("Could not select project '%1'. Make
> > sure it is not opened in VO!",sProject))
> >     // Add comment
> >     SELF:LogAdd("ERROR: Project not opened : "+sProject)
> > OTHERWISE
> >
> >     // Add comment
> >     SELF:LogAdd("Project opened : "+sProject)
> >
> >     // Get the apps
> >     aApps:=SELF:_RepoProject:Applications
> >     FOR dwAppPointer:=1 UPTO ALen(aApps)
> >
> >         // Get an app
> >         oApp:=aApps[dwAppPointer]
> >         sApp:=oApp:Name
> >         SELF:LogAdd("Using application : "+sApp)
> >
> >         //
> > *******************************************************************
> >         // Now set the EXE or DLL path of this app so generating the
> > EXE/DLL will save it at that specific location
> >         // Does anybody have a clue how to do that?
> >         //
> > *******************************************************************
> >
> >     NEXT dwAppPointer
> > END

Hi Marc!

If I remember correctly we did that for the B**sius project! There is some code lurking there in the repository that read those damned Clipper source, produced a VO project, compiled it and generated the executable!

Those were the times!

Adriano

[toc] | [prev] | [next] | [standalone]


#7721

From"Marc Verkade [MITCon]" <marc@mitNOSPAMconDELETE.nl>
Date2015-02-06 13:36 +0100
Message-ID<Sy2Bw.88290$PU5.76326@fe31.am1>
In reply to#7711
Hey Adriano, nice to see you lurking here!

Yep, nice project that was!!! And great sushi too in our kimono's!
We must have a talk soon! Any plans to come to Curacao?

I am building the same kind of application now to convert Bake-it to SQL 
tables
I already took your code and extended it and added numerous methods for 
repo-management.

Almost done with Bake-it for SQL...
Step 1 - Open 'Bake-it DBF to MS-SQL Converter' and press the button
- Create a SQL scheme based on the Bake-it DBF structure and convert data.
Step 2 - Open 'Bake-it Repo Converter' and press the button
- Wait for the app to create a new Repo based on an existing Bake-it DBF 
repo (create SQL objects based on DBF objects, write various code changes, 
remap libraries etc..)
Step 3 - Press the compile-all button
- Voila, a Bake-it.Exe based on SQL tables in stead of DBF tables

Easier than that is impossible IMHO....
Now let's see how it performs....
And then there are the reports.....

Regards, Marc


schreef in bericht 
news:09512981-2e16-4caa-b308-0765800e91af@googlegroups.com...

On Thursday, January 22, 2015 at 11:33:39 PM UTC, Marc Verkade [MITCon] 
wrote:
> Thanx. ,that was what Robert also suggested.
> I will try that.
> Regards, Marc Verkade
>
> "JohnMartens"  schreef in bericht news:m9rj2l$jju$1@dont-email.me...
>
> Hi Marc,
>
> This is what I found in the Help of RepoScript. I think the syntax of
> RepoScript is similar like the ADAM syntax.
> I suppose you can read the German text as tey are our neigbours.
>
> Is this of any help ?
>
> Cheers,
> John
>
>
>
> appSetExeName()
>
>
> Verwendung
>
> Setzt den Namen der Exe-/DLL-Datei in einer Applikation.
>
> Syntax
>
> appSetExeName(<cFile>) Æ lSuccess
>
>
>
> appSetExeName(<cApplication>, <cFile>) Æ lSuccess
>
> Argumente
>
> <cApplication> Name der Applikation, für die der Name der Exe-/DLL-Datei
> gesetzt werden soll.
>
>
>
> Wenn das Argument nicht übergeben wird, dann bezieht sich der Befehl auf
> die aktuelle Applikation. Diese kann beispielsweise mit den Funktionen
> appSearch(), appGetFirst() oder appGetNext() aktiviert werden.
>
>
>
> Datentyp: String
>
>
>
> <cFile> Name der Exe-/DLL-Datei, der gesetzt werden sell.
>
> Datentyp: String
>
> Rückgabewert
>
> lSuccess Status der Operation.
>
> TRUE Der Name der Exe-/DLL-Datei wurde gesetzt.
>
> FALSE Der Name der Exe-/DLL-Datei konnte nicht gesetzt werden.
>
> Datentyp: Logic
>
> Beschreibung
>
> appSetExeName() setzt in einer Applikation vom Typ Application den Namen
> der EXE-Datei bzw. in einer Applikation vom Typ DLL den Namen der 
> DLL-Datei.
>
>
>
> Unter dem Namen der Exe-/DLL-Datei wird eine Applikation mittels der
> Funktion appBuild() als externe Datei auf einen Datenträger erzeugt.
>
>
>
> Mit der Funktion appGetExeName() kann der Name der Exe-/DLL-Datei
> abgefragt werden.
>
>
>
> Marc Verkade [MITCon] schreef op 22-1-2015 om 19:31:
> > Hello to all,
> >
> > I am creating a conversion app that interacts with ADAM.
> > Now I want to set the path of an application programmatically but I lack
> > the proper documentation to do that.
> > I want to set the Path for EXE and DLL files, probably using the
> > AppSetOptions SDK method.
> >
> > Does anybody have a code snipped to show me how to do that?
> > Here a code snippet to show what I am doing and want to do....
> >
> > // Open the project
> > SELF:_RepoProject:=repoProject{SELF:_RepoRepository:CurrentProject}
> >
> > // Open the applications
> > DO CASE
> > CASE SELF:_RepoProject==NULL_OBJECT
> >     MC_WarningBox(MC_StringMerge1("Could not select project '%1'. Make
> > sure it is not opened in VO!",sProject))
> >     // Add comment
> >     SELF:LogAdd("ERROR: Project not opened : "+sProject)
> > OTHERWISE
> >
> >     // Add comment
> >     SELF:LogAdd("Project opened : "+sProject)
> >
> >     // Get the apps
> >     aApps:=SELF:_RepoProject:Applications
> >     FOR dwAppPointer:=1 UPTO ALen(aApps)
> >
> >         // Get an app
> >         oApp:=aApps[dwAppPointer]
> >         sApp:=oApp:Name
> >         SELF:LogAdd("Using application : "+sApp)
> >
> >         //
> > *******************************************************************
> >         // Now set the EXE or DLL path of this app so generating the
> > EXE/DLL will save it at that specific location
> >         // Does anybody have a clue how to do that?
> >         //
> > *******************************************************************
> >
> >     NEXT dwAppPointer
> > END

Hi Marc!

If I remember correctly we did that for the B**sius project! There is some 
code lurking there in the repository that read those damned Clipper source, 
produced a VO project, compiled it and generated the executable!

Those were the times!

Adriano 

[toc] | [prev] | [next] | [standalone]


#7742

From"Willie Moore" <williem@wmconsulting.com>
Date2015-02-12 11:12 -0600
Message-ID<mbimt7$qlc$1@speranza.aioe.org>
In reply to#7721
Marc,

Good luck with your new project!

Regards,
Willie
Vulcan VIP

"Marc Verkade [MITCon]"  wrote in message 
news:Sy2Bw.88290$PU5.76326@fe31.am1...

Hey Adriano, nice to see you lurking here!

Yep, nice project that was!!! And great sushi too in our kimono's!
We must have a talk soon! Any plans to come to Curacao?

I am building the same kind of application now to convert Bake-it to SQL
tables
I already took your code and extended it and added numerous methods for
repo-management.

Almost done with Bake-it for SQL...
Step 1 - Open 'Bake-it DBF to MS-SQL Converter' and press the button
- Create a SQL scheme based on the Bake-it DBF structure and convert data.
Step 2 - Open 'Bake-it Repo Converter' and press the button
- Wait for the app to create a new Repo based on an existing Bake-it DBF
repo (create SQL objects based on DBF objects, write various code changes,
remap libraries etc..)
Step 3 - Press the compile-all button
- Voila, a Bake-it.Exe based on SQL tables in stead of DBF tables

Easier than that is impossible IMHO....
Now let's see how it performs....
And then there are the reports.....

Regards, Marc


schreef in bericht
news:09512981-2e16-4caa-b308-0765800e91af@googlegroups.com...

On Thursday, January 22, 2015 at 11:33:39 PM UTC, Marc Verkade [MITCon]
wrote:
> Thanx. ,that was what Robert also suggested.
> I will try that.
> Regards, Marc Verkade
>
> "JohnMartens"  schreef in bericht news:m9rj2l$jju$1@dont-email.me...
>
> Hi Marc,
>
> This is what I found in the Help of RepoScript. I think the syntax of
> RepoScript is similar like the ADAM syntax.
> I suppose you can read the German text as tey are our neigbours.
>
> Is this of any help ?
>
> Cheers,
> John
>
>
>
> appSetExeName()
>
>
> Verwendung
>
> Setzt den Namen der Exe-/DLL-Datei in einer Applikation.
>
> Syntax
>
> appSetExeName(<cFile>) Æ lSuccess
>
>
>
> appSetExeName(<cApplication>, <cFile>) Æ lSuccess
>
> Argumente
>
> <cApplication> Name der Applikation, für die der Name der Exe-/DLL-Datei
> gesetzt werden soll.
>
>
>
> Wenn das Argument nicht übergeben wird, dann bezieht sich der Befehl auf
> die aktuelle Applikation. Diese kann beispielsweise mit den Funktionen
> appSearch(), appGetFirst() oder appGetNext() aktiviert werden.
>
>
>
> Datentyp: String
>
>
>
> <cFile> Name der Exe-/DLL-Datei, der gesetzt werden sell.
>
> Datentyp: String
>
> Rückgabewert
>
> lSuccess Status der Operation.
>
> TRUE Der Name der Exe-/DLL-Datei wurde gesetzt.
>
> FALSE Der Name der Exe-/DLL-Datei konnte nicht gesetzt werden.
>
> Datentyp: Logic
>
> Beschreibung
>
> appSetExeName() setzt in einer Applikation vom Typ Application den Namen
> der EXE-Datei bzw. in einer Applikation vom Typ DLL den Namen der 
> DLL-Datei.
>
>
>
> Unter dem Namen der Exe-/DLL-Datei wird eine Applikation mittels der
> Funktion appBuild() als externe Datei auf einen Datenträger erzeugt.
>
>
>
> Mit der Funktion appGetExeName() kann der Name der Exe-/DLL-Datei
> abgefragt werden.
>
>
>
> Marc Verkade [MITCon] schreef op 22-1-2015 om 19:31:
> > Hello to all,
> >
> > I am creating a conversion app that interacts with ADAM.
> > Now I want to set the path of an application programmatically but I lack
> > the proper documentation to do that.
> > I want to set the Path for EXE and DLL files, probably using the
> > AppSetOptions SDK method.
> >
> > Does anybody have a code snipped to show me how to do that?
> > Here a code snippet to show what I am doing and want to do....
> >
> > // Open the project
> > SELF:_RepoProject:=repoProject{SELF:_RepoRepository:CurrentProject}
> >
> > // Open the applications
> > DO CASE
> > CASE SELF:_RepoProject==NULL_OBJECT
> >     MC_WarningBox(MC_StringMerge1("Could not select project '%1'. Make
> > sure it is not opened in VO!",sProject))
> >     // Add comment
> >     SELF:LogAdd("ERROR: Project not opened : "+sProject)
> > OTHERWISE
> >
> >     // Add comment
> >     SELF:LogAdd("Project opened : "+sProject)
> >
> >     // Get the apps
> >     aApps:=SELF:_RepoProject:Applications
> >     FOR dwAppPointer:=1 UPTO ALen(aApps)
> >
> >         // Get an app
> >         oApp:=aApps[dwAppPointer]
> >         sApp:=oApp:Name
> >         SELF:LogAdd("Using application : "+sApp)
> >
> >         //
> > *******************************************************************
> >         // Now set the EXE or DLL path of this app so generating the
> > EXE/DLL will save it at that specific location
> >         // Does anybody have a clue how to do that?
> >         //
> > *******************************************************************
> >
> >     NEXT dwAppPointer
> > END

Hi Marc!

If I remember correctly we did that for the B**sius project! There is some
code lurking there in the repository that read those damned Clipper source,
produced a VO project, compiled it and generated the executable!

Those were the times!

Adriano 

[toc] | [prev] | [next] | [standalone]


#7745

Fromrui.gominho@gmail.com
Date2015-02-16 03:14 -0800
Message-ID<860d4ef6-5b27-42bd-82ca-f6d756cc058b@googlegroups.com>
In reply to#7721
Hi Marc!

It sounds like you're having serious fun with that project!
Are you also pulling out the DBF "do while !eof()" logic and building SQL queries from it? Most of the DBF parsing code we used to write can (and should) be written in pure SQL and have the server optimize it and take care of performance issues...

For example, the following DBF logic...

  do while !records->eof()
      if records->useThis
          details->append()
          details->recordID = records->recordID
      endif
      records->skip()
  enddo

...would be transformed into SQL like:

  INSERT INTO details (recordID) SELECT records.recordID FROM records WHERE records.useThis;

Of course things would be much more complex but still doing this automatically(ish) would be fun!

I hope this year I will finally manage to visit you in Curacao!

Regards

Adriano


On Friday, February 6, 2015 at 12:36:04 PM UTC, Marc Verkade [MITCon] wrote:
> Hey Adriano, nice to see you lurking here!
> 
> Yep, nice project that was!!! And great sushi too in our kimono's!
> We must have a talk soon! Any plans to come to Curacao?
> 
> I am building the same kind of application now to convert Bake-it to SQL 
> tables
> I already took your code and extended it and added numerous methods for 
> repo-management.
> 
> Almost done with Bake-it for SQL...
> Step 1 - Open 'Bake-it DBF to MS-SQL Converter' and press the button
> - Create a SQL scheme based on the Bake-it DBF structure and convert data.
> Step 2 - Open 'Bake-it Repo Converter' and press the button
> - Wait for the app to create a new Repo based on an existing Bake-it DBF 
> repo (create SQL objects based on DBF objects, write various code changes, 
> remap libraries etc..)
> Step 3 - Press the compile-all button
> - Voila, a Bake-it.Exe based on SQL tables in stead of DBF tables
> 
> Easier than that is impossible IMHO....
> Now let's see how it performs....
> And then there are the reports.....
> 
> Regards, Marc
> 
> 
> schreef in bericht 
> news:09512981-2e16-4caa-b308-0765800e91af@googlegroups.com...
> 
> On Thursday, January 22, 2015 at 11:33:39 PM UTC, Marc Verkade [MITCon] 
> wrote:
> > Thanx. ,that was what Robert also suggested.
> > I will try that.
> > Regards, Marc Verkade
> >
> > "JohnMartens"  schreef in bericht news:m9rj2l$jju$1@dont-email.me...
> >
> > Hi Marc,
> >
> > This is what I found in the Help of RepoScript. I think the syntax of
> > RepoScript is similar like the ADAM syntax.
> > I suppose you can read the German text as tey are our neigbours.
> >
> > Is this of any help ?
> >
> > Cheers,
> > John
> >
> >
> >
> > appSetExeName()
> >
> >
> > Verwendung
> >
> > Setzt den Namen der Exe-/DLL-Datei in einer Applikation.
> >
> > Syntax
> >
> > appSetExeName(<cFile>) Æ lSuccess
> >
> >
> >
> > appSetExeName(<cApplication>, <cFile>) Æ lSuccess
> >
> > Argumente
> >
> > <cApplication> Name der Applikation, für die der Name der Exe-/DLL-Datei
> > gesetzt werden soll.
> >
> >
> >
> > Wenn das Argument nicht übergeben wird, dann bezieht sich der Befehl auf
> > die aktuelle Applikation. Diese kann beispielsweise mit den Funktionen
> > appSearch(), appGetFirst() oder appGetNext() aktiviert werden.
> >
> >
> >
> > Datentyp: String
> >
> >
> >
> > <cFile> Name der Exe-/DLL-Datei, der gesetzt werden sell.
> >
> > Datentyp: String
> >
> > Rückgabewert
> >
> > lSuccess Status der Operation.
> >
> > TRUE Der Name der Exe-/DLL-Datei wurde gesetzt.
> >
> > FALSE Der Name der Exe-/DLL-Datei konnte nicht gesetzt werden.
> >
> > Datentyp: Logic
> >
> > Beschreibung
> >
> > appSetExeName() setzt in einer Applikation vom Typ Application den Namen
> > der EXE-Datei bzw. in einer Applikation vom Typ DLL den Namen der 
> > DLL-Datei.
> >
> >
> >
> > Unter dem Namen der Exe-/DLL-Datei wird eine Applikation mittels der
> > Funktion appBuild() als externe Datei auf einen Datenträger erzeugt.
> >
> >
> >
> > Mit der Funktion appGetExeName() kann der Name der Exe-/DLL-Datei
> > abgefragt werden.
> >
> >
> >
> > Marc Verkade [MITCon] schreef op 22-1-2015 om 19:31:
> > > Hello to all,
> > >
> > > I am creating a conversion app that interacts with ADAM.
> > > Now I want to set the path of an application programmatically but I lack
> > > the proper documentation to do that.
> > > I want to set the Path for EXE and DLL files, probably using the
> > > AppSetOptions SDK method.
> > >
> > > Does anybody have a code snipped to show me how to do that?
> > > Here a code snippet to show what I am doing and want to do....
> > >
> > > // Open the project
> > > SELF:_RepoProject:=repoProject{SELF:_RepoRepository:CurrentProject}
> > >
> > > // Open the applications
> > > DO CASE
> > > CASE SELF:_RepoProject==NULL_OBJECT
> > >     MC_WarningBox(MC_StringMerge1("Could not select project '%1'. Make
> > > sure it is not opened in VO!",sProject))
> > >     // Add comment
> > >     SELF:LogAdd("ERROR: Project not opened : "+sProject)
> > > OTHERWISE
> > >
> > >     // Add comment
> > >     SELF:LogAdd("Project opened : "+sProject)
> > >
> > >     // Get the apps
> > >     aApps:=SELF:_RepoProject:Applications
> > >     FOR dwAppPointer:=1 UPTO ALen(aApps)
> > >
> > >         // Get an app
> > >         oApp:=aApps[dwAppPointer]
> > >         sApp:=oApp:Name
> > >         SELF:LogAdd("Using application : "+sApp)
> > >
> > >         //
> > > *******************************************************************
> > >         // Now set the EXE or DLL path of this app so generating the
> > > EXE/DLL will save it at that specific location
> > >         // Does anybody have a clue how to do that?
> > >         //
> > > *******************************************************************
> > >
> > >     NEXT dwAppPointer
> > > END
> 
> Hi Marc!
> 
> If I remember correctly we did that for the B**sius project! There is some 
> code lurking there in the repository that read those damned Clipper source, 
> produced a VO project, compiled it and generated the executable!
> 
> Those were the times!
> 
> Adriano

[toc] | [prev] | [next] | [standalone]


#7746

From"Marc Verkade [MITCon]" <marc@mitNOSPAMconDELETE.nl>
Date2015-02-17 19:19 +0100
Message-ID<YCLEw.491060$ZQ.257241@fx05.am1>
In reply to#7745
Hey Adriano,

Nope, it is a 1-on-1 translation. So I mimic the DBF behavior and translate 
it to SQL.
Pitfalls were SetSelectiveRelations (nailed it) and compound indexes (nailed 
it too) and different notifications (almost nailed it)
Now busy with testing and reports...

Optimalisation comes next and is not in the scope of this project, that is 
something for Bob, Bulent and Ronald!
Hope to see you here!

Regards, Marc


schreef in bericht 
news:860d4ef6-5b27-42bd-82ca-f6d756cc058b@googlegroups.com...

Hi Marc!

It sounds like you're having serious fun with that project!
Are you also pulling out the DBF "do while !eof()" logic and building SQL 
queries from it? Most of the DBF parsing code we used to write can (and 
should) be written in pure SQL and have the server optimize it and take care 
of performance issues...

For example, the following DBF logic...

  do while !records->eof()
      if records->useThis
          details->append()
          details->recordID = records->recordID
      endif
      records->skip()
  enddo

...would be transformed into SQL like:

  INSERT INTO details (recordID) SELECT records.recordID FROM records WHERE 
records.useThis;

Of course things would be much more complex but still doing this 
automatically(ish) would be fun!

I hope this year I will finally manage to visit you in Curacao!

Regards

Adriano


On Friday, February 6, 2015 at 12:36:04 PM UTC, Marc Verkade [MITCon] wrote:
> Hey Adriano, nice to see you lurking here!
>
> Yep, nice project that was!!! And great sushi too in our kimono's!
> We must have a talk soon! Any plans to come to Curacao?
>
> I am building the same kind of application now to convert Bake-it to SQL
> tables
> I already took your code and extended it and added numerous methods for
> repo-management.
>
> Almost done with Bake-it for SQL...
> Step 1 - Open 'Bake-it DBF to MS-SQL Converter' and press the button
> - Create a SQL scheme based on the Bake-it DBF structure and convert data.
> Step 2 - Open 'Bake-it Repo Converter' and press the button
> - Wait for the app to create a new Repo based on an existing Bake-it DBF
> repo (create SQL objects based on DBF objects, write various code changes,
> remap libraries etc..)
> Step 3 - Press the compile-all button
> - Voila, a Bake-it.Exe based on SQL tables in stead of DBF tables
>
> Easier than that is impossible IMHO....
> Now let's see how it performs....
> And then there are the reports.....
>
> Regards, Marc
>
>
> schreef in bericht
> news:09512981-2e16-4caa-b308-0765800e91af@googlegroups.com...
>
> On Thursday, January 22, 2015 at 11:33:39 PM UTC, Marc Verkade [MITCon]
> wrote:
> > Thanx. ,that was what Robert also suggested.
> > I will try that.
> > Regards, Marc Verkade
> >
> > "JohnMartens"  schreef in bericht news:m9rj2l$jju$1@dont-email.me...
> >
> > Hi Marc,
> >
> > This is what I found in the Help of RepoScript. I think the syntax of
> > RepoScript is similar like the ADAM syntax.
> > I suppose you can read the German text as tey are our neigbours.
> >
> > Is this of any help ?
> >
> > Cheers,
> > John
> >
> >
> >
> > appSetExeName()
> >
> >
> > Verwendung
> >
> > Setzt den Namen der Exe-/DLL-Datei in einer Applikation.
> >
> > Syntax
> >
> > appSetExeName(<cFile>) Æ lSuccess
> >
> >
> >
> > appSetExeName(<cApplication>, <cFile>) Æ lSuccess
> >
> > Argumente
> >
> > <cApplication> Name der Applikation, für die der Name der Exe-/DLL-Datei
> > gesetzt werden soll.
> >
> >
> >
> > Wenn das Argument nicht übergeben wird, dann bezieht sich der Befehl auf
> > die aktuelle Applikation. Diese kann beispielsweise mit den Funktionen
> > appSearch(), appGetFirst() oder appGetNext() aktiviert werden.
> >
> >
> >
> > Datentyp: String
> >
> >
> >
> > <cFile> Name der Exe-/DLL-Datei, der gesetzt werden sell.
> >
> > Datentyp: String
> >
> > Rückgabewert
> >
> > lSuccess Status der Operation.
> >
> > TRUE Der Name der Exe-/DLL-Datei wurde gesetzt.
> >
> > FALSE Der Name der Exe-/DLL-Datei konnte nicht gesetzt werden.
> >
> > Datentyp: Logic
> >
> > Beschreibung
> >
> > appSetExeName() setzt in einer Applikation vom Typ Application den Namen
> > der EXE-Datei bzw. in einer Applikation vom Typ DLL den Namen der
> > DLL-Datei.
> >
> >
> >
> > Unter dem Namen der Exe-/DLL-Datei wird eine Applikation mittels der
> > Funktion appBuild() als externe Datei auf einen Datenträger erzeugt.
> >
> >
> >
> > Mit der Funktion appGetExeName() kann der Name der Exe-/DLL-Datei
> > abgefragt werden.
> >
> >
> >
> > Marc Verkade [MITCon] schreef op 22-1-2015 om 19:31:
> > > Hello to all,
> > >
> > > I am creating a conversion app that interacts with ADAM.
> > > Now I want to set the path of an application programmatically but I 
> > > lack
> > > the proper documentation to do that.
> > > I want to set the Path for EXE and DLL files, probably using the
> > > AppSetOptions SDK method.
> > >
> > > Does anybody have a code snipped to show me how to do that?
> > > Here a code snippet to show what I am doing and want to do....
> > >
> > > // Open the project
> > > SELF:_RepoProject:=repoProject{SELF:_RepoRepository:CurrentProject}
> > >
> > > // Open the applications
> > > DO CASE
> > > CASE SELF:_RepoProject==NULL_OBJECT
> > >     MC_WarningBox(MC_StringMerge1("Could not select project '%1'. Make
> > > sure it is not opened in VO!",sProject))
> > >     // Add comment
> > >     SELF:LogAdd("ERROR: Project not opened : "+sProject)
> > > OTHERWISE
> > >
> > >     // Add comment
> > >     SELF:LogAdd("Project opened : "+sProject)
> > >
> > >     // Get the apps
> > >     aApps:=SELF:_RepoProject:Applications
> > >     FOR dwAppPointer:=1 UPTO ALen(aApps)
> > >
> > >         // Get an app
> > >         oApp:=aApps[dwAppPointer]
> > >         sApp:=oApp:Name
> > >         SELF:LogAdd("Using application : "+sApp)
> > >
> > >         //
> > > *******************************************************************
> > >         // Now set the EXE or DLL path of this app so generating the
> > > EXE/DLL will save it at that specific location
> > >         // Does anybody have a clue how to do that?
> > >         //
> > > *******************************************************************
> > >
> > >     NEXT dwAppPointer
> > > END
>
> Hi Marc!
>
> If I remember correctly we did that for the B**sius project! There is some
> code lurking there in the repository that read those damned Clipper 
> source,
> produced a VO project, compiled it and generated the executable!
>
> Those were the times!
>
> Adriano 

[toc] | [prev] | [standalone]


Back to top | Article view | comp.lang.clipper.visual-objects


csiph-web