Brad,

Take that first and most important step to clean all external forms and/or command files with redundant CONN/DISC statements and see how it goes.

Make sure that you are NOT embedding the RBENGINEXE.DLL file inside the compiled app. Keep this file outside along with your compiled EXE in the same folder.

And, feel free to reach out to me with any questions.

Very Best R:egards,

Razzak


At 06:09 PM 4/7/2016, Brad Davidson wrote:

Thanks for all the tips, Razzak - looks like an all-nighter for me to re-work logic with compiled apps (half a dozen to do in all).

Yes, the tool enhancements are much appreciated - will keep in mind through the process.

I've noticed even one connect statement called from one of the command files does connect, but then, bails to r> prompt in tracing mode. Something rudimentary wrong here, and out of the blue, all of the sudden...

Thanks again,
Brad

-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon
Sent: Thursday, April 07, 2016 3:04 PM
To: [email protected]
Subject: Re: [RBASE-L] - Compiled APP not connecting to DB after DISCONNECT

At 05:34 PM 4/7/2016, Brad Davidson wrote:

>Is anyone using a RBGXE compiled app, with SEVERAL disconnects/connects
>within the app seeing difficulties in re-connecting to the database?
>
>RBGXE, multi user environ, just migrated 3 bus days ago from 9.5 64-bit.
>
>In each command file I disconnect from the DB prior to returning to RFF
>(main menu). Each command file connects at start of code. All working
>in this scenario since version 7.6 in a compiled application. However,
>since migrating to RBGXE, my apps do NOT reconnect to the database via
>straight
>forward:
>
>IF (CVAL('DATABASE')) <> 'DBNAME' OR (CVAL('DATABASE')) IS NULL THEN
>   CONNECT DBNAME
>ENDIF
>
>Tracing the code I find it will not re-connect, hence, no programs run.
>
>I've unloaded/re-loaded the DB a couple of times, zero errors, fully
>optimized DB.
>
>CHARS all check out fine
>
>Before I go through my 100 or so command files and remove all
>disconnects /re-connects in the compiled app, I though I'd check with you all.
>
>Would appreciate if anyone else uses the scenario descibed above in
>their compiled apps - are you having any issues re-connecting to the DB?


Brad,

I love the new R:BASE X Enterprise Compiler that comes with so many cool tools and features. Of course I am biased :)

Have you seen all new compiled R:BASE X Enterprise sample applications?

Without knowing all details, it is difficult to make any recommendations.

It is probably a good idea to remove all CONN/DISC statements for each item in the menu(s) of your application or each command file.

Your application startup file, or the "On Before Start EEP" of your main application external file should validate and/or establish the CONNection only once.

Did you know that ...

You can highlight all your External form(s) and/or command files and search for any keyword using the (Ctrl+F] keys?

That should help you identify all occurrences.

Also, make sure to keep the Engine DLL (RBENGINEXE.DLL) externally in the same folder with your compiled .EXE.

You may also take a close look at all compiled sample applications to understand the proper logic of using compiled applications in a network multi-user environment.

Hope that helps!

Very Best R:egards,

Razzak.



--
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/201604072216.u37MG2oS027914%40atl4mhob19.myregisteredsite.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to