Dan: A reason to disconnect is so that the database is relased when the user returns back to the external form main menu. That way, you don't have to worry about users having the database open, like when you're trying to run maintenance after hours. I suppose a timeout might do the same thing, but I always worry about a timeout happening in the middle of a program when perhaps the program is waiting for a user to press a key or provide info.
Karen -----Original Message----- From: Dan Goldberg <[email protected]> To: rbase-l <[email protected]> Sent: Thu, Apr 7, 2016 5:23 pm 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/avndyhJ5xOZT777NNKVJ56XXarWbZPqadTTC7SnDzqadTSkTQnQjqadTTC77S63p2eEsxFCi5aM1m_6FuQttDOVLvzkLqeKPVsSyUqek7bzD-LOrbzxEVKPRXBQhNEVd7fcf8FzxPfkhjmKCHtNDBgY-F6lK1FJ4SOrLOqbaab0VZx4TsS02zEEaqlVva10_ZmmfBrpOH2xK93qunf02gxowwu-a2bt3cy4i0u_itmdaAhrN4YmC8LBwkhHkyvV6dmRGsKruhjKr1vF6y0QJwIp41wqbxkQKCy0Kq81aGGQz_gd40w5wIq88lCq8blx3XjB0yq89Rd40scCy3np_4Qg6y0e3hwi30c1wQ90ASUedYp2iTR7- 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/k-Kr6h0i6jqb3BXKeefzztPqadTSkTQnXCQkrLLcfILf6QkrLIFLELECQkrLLcefIc6O4tgV3jcAalw2J-diZEWXfBPu_6FuQttDOVJ5MQsEen7fZvASn73hPtDHTbEzzhOqeuouhj73CuEyCJtdmXzfaxVZicHs3jqpJATvAQmkkm1PX29KVIDeqR4IMz6HqRe8RGhf_BYgNmx6i6h8rjOV-9ThsKNssCDtzCShMSM99OKODss-foLIPS5iti2bDaBE-hBivNZ2AF_OVK93qunf02gxowwu-a2bt3cy4i0u_itmdaAhrN4YmC8LBwkhHkyvV6dmRGsKruhjKr1vF6y0QJwIp41wqbxkQKCy0Kq81aGGQz_gd40w5wIq88lCq8blx3XjB0yq89Rd40scCy3np_4Qg6y0e3hwi30c1wQ90ASUedFOMdS4poDjs4. For more options, visit http://cp.mcafee.com/d/5fHCNAg6h0SyMVuXzzzUUTsSyztZBdZ5-VJ56XXP3XbPNJ56XXarWbW9J56XXP3zX31Ix7kegQP92Bo0HvzkLqeKPVsTLNGnJ7npYKrhsd7a3BNP_nVdBNMQsTpWZOW8UQsCzDC7AkNMVDG8FHnjlKUPOEuvkzaT0QSOrpdTVd5B55ws-MyrKr9PCJhbc8NGSJjydqAj_Vv4cGJeHsPsi6QYKu04x2N10ZYk4mW6p48A0Z-AWIql8yTy9UJchvb0EzmF4_OcqJHkVsSYyDsS2_id41Fr1oO830Qn2FFtd41sQg2lllF7-wq810b1oQggHcQgmH27SDa14QgjGq80Upd46KP-9Ewd40s6z0A60o31Ei19JMsrzfm_gicV. -- 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/b4ca46b46b3b465f97f8275cba7981cb%40MBX082-W1-CO-3.EXCH082.SERVERPOD.NET. 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/2E4830CEC16615458329D3D83342F8D0128D32BB%40EXCHANGE8.win.zerolag.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/153f5e6f8e1-4da7-19330%40webprd-m56.mail.aol.com. For more options, visit https://groups.google.com/d/optout.
