Thanks for the info. Let me know if you had to remove it so I do not add it to
all my menu items...
This is all I have in my compiled startup exe. I connect in the before start
eep of my rff.
-- Startup.DAT (For External Form File Menus)
if #time bet '12:00:00 am' and '12:45:00 am' then
exit
endif
property loadwindow showindicator 'True'
PROPERTY loadwindow TITLE 'Loading - Please Wait ...'
PROPERTY loadwindow progress 25
SET VAR vuserchk =(CVAL('NETUSER'))
REFF lance_menu.rff
RETURN
Dan Goldberg
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of
Brad Davidson
Sent: Thursday, April 07, 2016 3:33 PM
To: [email protected]
Subject: Re: [RBASE-L] - Compiled APP not connecting to DB after DISCONNECT
All I can say, Dan, is I've been using this technique for several years for the
same reason you report (which is probably a Windows related issue - yes, NIC
set to disable power savings..., etc...) as well, I liked the idea of bandwidth
being returned upon return to main menu as the files all disconnect after use
and await the user's next selection, at which time there's a re-connect. We
know Windows is reluctant to return all memory resources, but, some better than
none (my opinion, of course!). All working fine until migrating to RBGXE -
however, as I'm debugging remotely perhaps something else is going on in my LAN
(about 28 PC's, couple of network switches, primary server Win2012, DB server
Win2003); I'll need to travel into the facility late night, morning hours to
resolve. Because this is so fundamental (can't even run a connect statement
within the DAT calling the main menu RFF - it just bails... odd!
Anyway, I'm going to test a reversal of all the disconnects/re-connects and
just connect at beginning of the program prior to launching the RFF, then,
revise a few programs off the main menu to comment out the connect/disconnect
statements...
Brad
Brad Davidson
CIO, Director
Aero-Craft Hydraulics, Inc.
951.736.4690
[email protected]
www.aero-craft.com
________________________________________
From: [email protected] <[email protected]> on behalf of Dan
Goldberg <[email protected]>
Sent: Thursday, April 07, 2016 3:23 PM
To: [email protected]
Subject: RE: [RBASE-L] - Compiled APP not connecting to DB after DISCONNECT
Hey Brad, sort of off topic but why do you disconnect/reconnect after each
command file? I just connect once when the external form file starts.
The reason I ask is I noticed that if a user just goes back to the main menu of
the rff and comes back after a while, sometimes they have to end task because
it is frozen. I am thinking maybe the db connection got lost or stuck.
I was thinking of trying to change like you have it but not sure if it is worth
the effort.
Dan Goldberg
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of
Brad Davidson
Sent: Thursday, April 07, 2016 3:09 PM
To: [email protected]
Subject: RE: [RBASE-L] - Compiled APP not connecting to DB after DISCONNECT
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?
http://cp.mcafee.com/d/avndzgw839J5xOZT1POrVKVJ56XXarWbZPqadTTC7SnDzqadTSkTQnQjqadTTC77S63p2eEsxFCi5aM1m_6FuQttDOVLvzkLqeKPVsTtR11OUV_HYehpd7arzDnKnhd7bbf8ILcfnKZR4kRHFGTusVkffGhBrwqrhdzzt-jhd79EVLtwQszDPtPo0eOTaSRT_Vv4cQP10Ij0xYf304wAse70M60k6g8vs0o1Jy0F02gIbqw2gi93xy0sa2SE0AoawA1U0e8ySE0A4ygUscecH9-dk3NsiA_ESyGaK2Xo3PC71wcxkOa5gGbu1gm3d1wI4NrOEUwa1Nsaxy90k3NEcwk5wm0MO0Vc63gpg7eStu5Ngf2PFkC8Gwk91uoc3xAy1OUKUu1i8K130M68xkc2N3t8n384xX09Ecnj51EqQmf39DkryE4GGKzclwM5QMY2zhOObdMtKCh3WC33pvkO4Sr5C9nr5pjlgQg9N1z07l4DwGcC2FcbBiNAcK8awI9k0Gbpch0Ga9Ansbn0s230qIMyo5y0ul0s2x8Js2xpV7gA4w751kywNsM-o3hpVUYi5Dy1UuO0MycTb2PNEV1q35Wm4yPc5xlw1Obxq_IAP4CrShc0eqery0M4_g0WOswi2NNsT4xJfbDw18gIgg5E3xpJRJmIi3bXcWIql8yTP9M9Ca2Ma8RGhfYz6HqRendEFIc8CMmd96y0QJwIp41wqbxkQKCy0Kq81aGGQz_gd40w5wIq88lCq8blx3XjB0yq89Rd40scCy3np_4Qg6y0e3hwi30c1wQ90ASUedRuJKKTMe
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
http://cp.mcafee.com/d/FZsScCQm7bTs7f9LCXCQkrLIFLELTdEETvuovpuudEETvpjvhvhdEETvuosvoodA8WxO6Cp8kH05rYqBXhRSvbCZ-diZEWXfBPtTk47bzD-LMV5AQsFKetuVt4QsIIYyOYMZuXTkhjmKCHtVPBgY-F6lK1FJcSedTVd4QsCzCZS3hOevdTdw0XbsHrnv_BYgMGn0GbxeYD14m8cz830l_KywFcb2SE0AoawA1U0c90ely5gHpQd2HHw3Boxkd5MGd1kq4w7aN2ElJXErpMccj8xBAhI8quoj0wKx82hE1g6t6gISaK2Xo3PC71wcwg-dwfgq-0VQ2j8wcg7cAMJce2U983gEa4MMbuTlIC8zCh9Iqb2g4jgl0oktQf384OI5Wcy8II10w2j8w0WFkGGy5w6jd7851Ad3L5wmM6zoEU5No5-Y2MAjt5hA3AgoG7Kis9Lh4gM6iVEV19ew50OB18eCa2gMj6Nwrd79EV3051weFgKXkaxEm67VjACg3J6hEKj6p6go1aowbyEo3856zBAmrwXtcy7Rc66O-FA9ISbciKSaOCGxEwjy360eG9f1kpc5ionaBz8psgl1oiE1kmOoy1kkj8KUmK0U460Rpx4Mb40YG0U52hqU52POex890ea2F51yVxYM6yPPNUAbf43MZA1x4pKm5DzhO2Q6bQI95Cob2H03An2R_p9C9cTIyo0sQsT41w9-wbxwrg665GxMzhwT4xJfbDw18gIgg5E3xpJRJmIi3bXcWIql8yTP9M9Ca2Ma8RGhfYz6HqRendEFIc8CMmd96y0QJwIp41wqbxkQKCy0Kq81aGGQz_gd40w5wIq88lCq8blx3XjB0yq89Rd40scCy3np_4Qg6y0e3hwi30c1wQ90ASUedVIeA.
For more options, visit
http://cp.mcafee.com/d/avndygQd6Qm7bTs7f9LCXCQkrLIFLELTdEETvuovpuudEETvpjvhvhdEETvuosvoodA8WxO6Cp8kH05rYqBXhRSvbCZ-diZEWXfBPtTk47bzD-LMV5AQsFKetuVt4QsIIYyOYMZuXTkhjmKCHtVPBgY-F6lK1FJASedTVd4QsCzCZS3hOevdTdw0XbsHrnv_BYgNZQbygc42bxeUMm6MOS0MEa2wj2o9Ec5xio4za04LBMO13Xw30c5Cg681o60g-U0M3r41i02CzA27T060obcyw3cExEuea-h0sb6zBcpHsbChgG5hrMa2MpE2gG30B021Q5we1kit41SIz8c2MH0cE38c6M7E2lw50Ac0aY4M7E92ws93x0G31IcxMiu5ML0hf0E9xoc3jpAGaq2rwec1yaO093a3UO--oEn6OQgayqegI90gj8mu1wi6084iO0I828G6jb5wA17xuwmF9M1Me1jtS0Zc68T0A3Bm5g5smou4bwin4053hoZUI2iNEV2o4m9Ci5NEkl5S1kcm5w82VkcQ60em3G32oH91x4nyzkcfcT0u2oKbPgohE0V5cYYYn75P0IYzswzk1O94bS0syG5QNMM7qyM0V4h2gIZs9H8ce0k5yVEV6z235We2BN1OZmkhGi9EV0wrF4ktl5icH1AT4xJfbDw18gIgg5E3xpJRJmIi3bXcWIql8yTP9M9Ca2Ma8RGhfYz6HqRendEFIc8CMmd96y0QJwIp41wqbxkQKCy0Kq81aGGQz_gd40w5wIq88lCq8blx3XjB0yq89Rd40scCy3np_4Qg6y0e3hwi30c1wQ90ASUedIXkQHTpXdiS.
--
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
http://cp.mcafee.com/d/k-Kr4xEg410SyMVuXwVVdYTsSyztZBdZ5-VJ56XXP3XbPNJ56XXarWbW9J56XXP3zX31Ix7kegQP92Bo0HvzkLqeKPVsTLNGnJ7npYKrKWwwVss_R-78ICzBdNPHTbECzBBDAmnC7HTuWyaqRQRrLesG7DR8OJMddI6NNK_9ECzAQsTKMqehPVKVIDeqR4IMz6HqRe8RGhf_BYgNmx6i6h8rjOV-46bqMUgos8cA677TjhOetuj7fS8qed7bOdy0ZyUScwdtVcK0G9si31tDxE1x8bTujUo6wm6hE5xoc1T0Mq19K93qunf02gxowwbg72PrHqJoA6nSpRoQGh5LCjwjck5wkhHkyvV6dmRGsKrhjoohdwIqid41Fr1oO830Qn2FFtd41sQg2lllF7-wq810b1oQggHcQgmH27SDa14QgjGq80Upd46KP-9Ewd40s6z0A60o31Ei19JMsr6ITiMkQuZUt9.
For more options, visit
http://cp.mcafee.com/d/avndzhJ5xOZT1POrVKVJ56XXarWbZPqadTTC7SnDzqadTSkTQnQjqadTTC77S63p2eEsxFCi5aM1m_6FuQttDOVLvzkLqeKPVsTtR11OUV_HYehpd7arzDnKnhd7bbf8ILcfnKZR4kRHFGTusVkffGhBrwqrvdzzt-jhd79EVLtwQszDPtPpesRG9px6dmRGshHkyv_bUxBlFRrCrygSDBPM0A8m882Q1MISWSHm91BZCtmdaAhrVAU4P51o54qR8D-hzlJqDbCQkS64job6Azh0qmMmcy0Md5MGqnjh0nd40Bllqh_E6y0g2Mmd44aPd45GMxZFOwhd44WCy0e6jh1HI_yq83h071EM91w60Mq4wirs76X58-YgHtM2T.
--
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
http://cp.mcafee.com/d/k-Kr418p6jqb3BXK3DATPtPqadTSkTQnXCQkrLLcfILf6QkrLIFLELECQkrLLcefIc6O4tgV3jcAalw2J-diZEWXfBPu_6FuQttDOVKXG23BNP_nUsyOqekT7eLsKyqemmuhpuouLtXG8FHnjlKYVOEuvkzaT0QSUr76XYCyqejhPuX1EV7fCXCOsVHkiP2cqJHkUzmF4_-nN35q4p8p4xJfbDUCdcfcT4xEihsshvovupjd78sO7fcII9yXMtt5dUepj6hAuNsq0oi2Uw30AdfsoB3xjURfQzOVK93qunf02gxowwbg72PrHqJoA6nSpRoQGh5LCjwjck5wkhHkyvV6dmRGsKrhjoohdwIqid41Fr1oO830Qn2FFtd41sQg2lllF7-wq810b1oQggHcQgmH27SDa14QgjGq80Upd46KP-9Ewd40s6z0A60o31Ei19JMsrl8m.
For more options, visit
http://cp.mcafee.com/d/5fHCN8g6zqb3BXK3DATPtPqadTSkTQnXCQkrLLcfILf6QkrLIFLELECQkrLLcefIc6O4tgV3jcAalw2J-diZEWXfBPu_6FuQttDOVKXG23BNP_nUsyOqekT7eLsKyqemmuhpuouLtXG8FHnjlKYVOEuvkzaT0QSedzzt-jhd79EVLtwQszDPtPpesRG9px6dmRGshHkyv_bUxBlFRrCrygSDBPM0A8m882Q1MISWSHm91BZCtmdaAhrVAU4P51o54qR8D-hzlJqDbCQkS64job6Azh0qmMmcy0Md5MGqnjh0nd40Bllqh_E6y0g2Mmd44aPd45GMxZFOwhd44WCy0e6jh1HI_yq83h071EM91w60Mq4wirs76YH0cGD0h.
--
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/1460068383314.57129%40aero-craft.com.
For more options, visit https://groups.google.com/d/optout.
--
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/2E4830CEC16615458329D3D83342F8D0128D34DE%40EXCHANGE8.win.zerolag.com.
For more options, visit https://groups.google.com/d/optout.
