[RBASE-L] - EMAIL_ATTACHMENTS
Hey group, Need a solution for a problem. I have been using the PRINT to email with attachments and has worked well for a number of years. It was reported to me that it started throwing errors the other day. What I found is that vAttachFile is type TEXT and the file was being truncated. But if I change vAttachFile to NOTE, the code no longer functions properly. Any ideas? Jan -- 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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [RBASE-L] - R:BASE X Enterprise - Super Advanced Training Course Outline
Razzak, et al, Looking forward to it. Is there anything we need to download/update prior to training? Jan -Original Message- From: "A. Razzak Memon" To: rbase-l@googlegroups.com Date: Mon, 09 May 2016 10:42:06 -0400 Subject: [RBASE-L] - R:BASE X Enterprise - Super Advanced Training Course Outline Monday, May 9, 2016 To All Attendees of 2016 R:BASE X Enterprise SAT in San Diego, California: Updated R:BASE X Enterprise (Version 10) SAT Course Outline is now available. http://www.rbaseuniversity.com [http://www.rbaseuniversity.com/] For your viewing pleasure ... Here's a preview of 2016 R:BASE X Enterprise SAT Switchboard and Dashboard. http://www.rbaseuniversity.com/applications/RBGXE_SAT_Splash.jpg [http://www.rbaseuniversity.com/applications/RBGXE_SAT_Splash.jpg] http://www.rbaseuniversity.com/applications/RBGXE_SAT_Switchboard.jpg [http://www.rbaseuniversity.com/applications/RBGXE_SAT_Switchboard.jpg] http://www.rbaseuniversity.com/applications/RBGXE_SAT_Dashboard.jpg [http://www.rbaseuniversity.com/applications/RBGXE_SAT_Dashboard.jpg] http://www.rbaseuniversity.com/applications/RBGXE_SAT_Dashboard_Expanded.jpg [http://www.rbaseuniversity.com/applications/RBGXE_SAT_Dashboard_Expanded.jpg] http://www.rbaseuniversity.com/applications/RBGXE_SAT_Applications_Part_1e.jpg [http://www.rbaseuniversity.com/applications/RBGXE_SAT_Applications_Part_1e.jpg] http://www.rbaseuniversity.com/applications/RBGXE_SAT_Applications_Part_1c.jpg [http://www.rbaseuniversity.com/applications/RBGXE_SAT_Applications_Part_1c.jpg] http://www.rbaseuniversity.com/applications/RBGXE_SAT_Applications_Part_2e.jpg [http://www.rbaseuniversity.com/applications/RBGXE_SAT_Applications_Part_2e.jpg] http://www.rbaseuniversity.com/applications/RBGXE_SAT_Applications_Part_2c.jpg [http://www.rbaseuniversity.com/applications/RBGXE_SAT_Applications_Part_2c.jpg] http://www.rbaseuniversity.com/applications/RBGXE_SAT_Applications_Part_3e.jpg [http://www.rbaseuniversity.com/applications/RBGXE_SAT_Applications_Part_3e.jpg] http://www.rbaseuniversity.com/applications/RBGXE_SAT_Applications_Part_3c.jpg [http://www.rbaseuniversity.com/applications/RBGXE_SAT_Applications_Part_3c.jpg] http://www.rbaseuniversity.com/applications/RBGXE_SAT_Applications_Part_4e.jpg [http://www.rbaseuniversity.com/applications/RBGXE_SAT_Applications_Part_4e.jpg] http://www.rbaseuniversity.com/applications/RBGXE_SAT_Applications_Part_4c.jpg [http://www.rbaseuniversity.com/applications/RBGXE_SAT_Applications_Part_4c.jpg] http://www.rbaseuniversity.com/applications/RBGXE_SAT_Applications_Part_5e.jpg [http://www.rbaseuniversity.com/applications/RBGXE_SAT_Applications_Part_5e.jpg] http://www.rbaseuniversity.com/applications/RBGXE_SAT_Applications_Part_5c.jpg [http://www.rbaseuniversity.com/applications/RBGXE_SAT_Applications_Part_5c.jpg] See you all on May 19th-20th, 2016. 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l%2Bunsubscribe%40googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
RE: [RBASE-L] - body contains information
Jim, I'm with Buddy on this one. However, I would tell the production manager that it could be done but this method was chosen for archival purposes. Other wise, if the first two options are not available, you could try creating a NOTE variable, run a cursor through your multiple appending a to each line. Then use the NOTE as your email body. Jan -Original Message- From: "Buddy Walker" To: Date: Thu, 12 May 2016 16:15:50 -0400 Subject: RE: [RBASE-L] - body contains information Jim I would use R:Mail for this. Buddy From:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf OfJim Belisle Sent: Thursday, May 12, 2016 3:28 PM To: rbase-l@googlegroups.com Subject: [RBASE-L] - body contains information I create a pdf for certain items we order and send them to the production manager for viewing. He would like for the same information to come as part of the body of the email rather than as a pdf. Since we are talking multiple lines from within a table, what would be the best way to accomplish this goal? James Belisle Making Information Systems People Friendly Since 1990 -- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [RBASE-L] - RBase Training - San Diego
All, A very good training and connecting time. Jan -Original Message- From: "Bruce Chitiea" To: rbase-l@googlegroups.com Date: Mon, 23 May 2016 14:51:10 + Subject: Re: [RBASE-L] - RBase Training - San Diego All: I'm with Dan. If you have never been to a SAT, you really must go. The value of the samples and examples alone far outstrip the cost of the trip. And, of course, the Razzak experience itself is a trip-and-a-half so the whole thing is an incredible positive bargain for new and old hands alike. Thanks to Razzak, Donna and friends for a great vacation. Bruce Chitiea SafeSectors, Inc. 909.238.9012 Mobile -- Original Message -- Sent: 5/23/2016 6:37:08 AM Subject: [RBASE-L] - RBase Training - San Diego From: "Dan Goldberg" mailto:d...@lancecamper.com]> To: "rbase-l@googlegroups.com" mailto:rbase-l@googlegroups.com]> Cc: I wanted to thank Razzak for the brain swelling training we had in San Diego. The training is worth every dollar! It is nice to learn about the new things RBase X has to offer as well as networking with other Rbase Developers. Dan Goldberg -- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [RBASE-L] - RBase Training - San Diego
Gary, The last time I hosted one in Portland, I couldn't attendees and we had to cancel the event. Jan -Original Message- From: Gary Randall To: rbase-l@googlegroups.com Date: Mon, 23 May 2016 11:19:06 -0700 Subject: Re: [RBASE-L] - RBase Training - San Diego Need a training visit to the PNW! On May 23, 2016, at 10:01 AM, jan johansen mailto:j...@jjcalibrations.com]> wrote: All, A very good training and connecting time. Jan -Original Message- From: "Bruce Chitiea" mailto:rby...@safesectors.com]> To: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] Date: Mon, 23 May 2016 14:51:10 + Subject: Re: [RBASE-L] - RBase Training - San Diego All: I'm with Dan. If you have never been to a SAT, you really must go. The value of the samples and examples alone far outstrip the cost of the trip. And, of course, the Razzak experience itself is a trip-and-a-half so the whole thing is an incredible positive bargain for new and old hands alike. Thanks to Razzak, Donna and friends for a great vacation. Bruce Chitiea SafeSectors, Inc. 909.238.9012 Mobile -- Original Message -- Sent: 5/23/2016 6:37:08 AM Subject: [RBASE-L] - RBase Training - San Diego From: "Dan Goldberg" mailto:d...@lancecamper.com]> To: "rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com]"; mailto:rbase-l@googlegroups.com]> Cc: I wanted to thank Razzak for the brain swelling training we had in San Diego. The training is worth every dollar! It is nice to learn about the new things RBase X has to offer as well as networking with other Rbase Developers. Dan Goldberg -- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
RE: [RBASE-L] - Dialog format mask numbers and decimals
Dan, How 'bout this. 1. Pre-define a varaiable SET VAR vINeedThisNoText REAL = NULL SET VAR vCancel TEXT = 'Yes' SET VAR vContinue TEXT = 'No' 2. Create a variable form with a DB-Edit and 2 buttons, CANCEL and CONTINUE 3. Treat the form as you would a dialog. So it looks like this SET VAR vINeedThisNoText REAL = NULL SET VAR vCancel TEXT = 'Yes' SET VAR vContinue TEXT = 'No' EDIT USING MyDialog IF vCancel = 'Yes' GOTO Done ENDIF Jan -Original Message- From: Dan Goldberg To: "rbase-l@googlegroups.com" Date: Wed, 15 Jun 2016 21:14:41 + Subject: RE: [RBASE-L] - Dialog format mask numbers and decimals That is a good workaround. I was thinking the same thing. I was hoping on something that would not allow not numeric entries in the dialog box. Dan From:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf OfBuddy Walker Sent: Wednesday, June 15, 2016 12:13 PM To: rbase-l@googlegroups.com Subject: RE: [RBASE-L] - Dialog format mask numbers and decimals Dan Since the format mask will not work for you then I maybe something like this. Buddy __code starts here LABEL Start SET VAR V1 DOUBLE = NULL SET ERROR MESSAGE 480 OFF DIAL 'Enter number (ex. 48.54)' v1=10 vendkey 1 SET ERROR MESSAGE 480 ON IF v1 = 0 or v1 IS NULL THEN PAUSE 2 USI ' Invalid number entered' GOTO Start ENDIF code ends here From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] [mailto:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com]] On Behalf OfDan Goldberg Sent: Wednesday, June 15, 2016 2:06 PM To: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] Subject: RE: [RBASE-L] - Dialog format mask numbers and decimals Thx buddy. It sort of works but looks weird with the spaces. Dan Goldberg From:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] [mailto:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com]] On Behalf OfBuddy Walker Sent: Wednesday, June 15, 2016 10:58 AM To: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] Subject: RE: [RBASE-L] - Dialog format mask numbers and decimals Dan Try something like this SET VAR v1 DOUBLE DIALOG 'Enter your number here||99.00' v1=10 vEndKey 1 Buddy From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] [mailto:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com]] On Behalf OfDan Goldberg Sent: Wednesday, June 15, 2016 1:46 PM To: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] Subject: [RBASE-L] - Dialog format mask numbers and decimals I need to have a dialog box that only allows numbers and the decimal. I am thinking the format option will work but am confused on if it will. Has anybody done this or have any ideas? TIA Dan Goldberg -- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [https://groups.google.com/d/optout]. Please note, responding to this email leads to an email box that is not monitored, if you have any questions feel free to send request to customerserv...@jjcalibrations.com or to your normal contact. Thank you, JJ Staff -- 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 emai
Re: [RBASE-L] - remove the x from the pause box
Dan, If I remember right, that's been asked before. I believe it is "a windows thing" in that RBase is using a windows call and has no control over it. Jan -Original Message- From: Dan Goldberg To: "rbase-l@googlegroups.com" Date: Thu, 4 Aug 2016 20:34:04 + Subject: [RBASE-L] - remove the x from the pause box Is there a way to remove the x in the upper right of the pause box so people do not close it? TIA Dan Goldberg -- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [https://groups.google.com/d/optout]. Please note, responding to this email leads to an email box that is not monitored, if you have any questions feel free to send request to customerserv...@jjcalibrations.com or to your normal contact. Thank you, JJ Staff -- 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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
RE: [RBASE-L] - remove the x from the pause box
Dan, When I first wrote my application to work with touch screens, I created my own "PAUSE" and "DIALOG" forms with big buttons and no close button (X). I just set a variable before issuing an "EDIT USING" and checked the variable after the form was closed to determine the action. A little bit of work but very satisfying. Jan -Original Message- From: Dan Goldberg To: "rbase-l@googlegroups.com" Date: Thu, 4 Aug 2016 20:42:50 + Subject: RE: [RBASE-L] - remove the x from the pause box Thx. Thinking about it, it might have been me that asked before lol. I will look at my old emails and see if there was any ideas. Dan Goldberg From:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Ofjan johansen Sent: Thursday, August 4, 2016 1:36 PM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - remove the x from the pause box Dan, If I remember right, that's been asked before. I believe it is "a windows thing" in that RBase is using a windows call and has no control over it. Jan -Original Message- From: Dan Goldberg mailto:d...@lancecamper.com]> To: "rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com]"; mailto:rbase-l@googlegroups.com]> Date: Thu, 4 Aug 2016 20:34:04 + Subject: [RBASE-L] - remove the x from the pause box Is there a way to remove the x in the upper right of the pause box so people do not close it? TIA Dan Goldberg -- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [https://groups.google.com/d/optout]. Please note, responding to this email leads to an email box that is not monitored, if you have any questions feel free to send request to customerserv...@jjcalibrations.com [mailto:customerserv...@jjcalibrations.com] or to your normal contact. Thank you, JJ Staff -- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [https://groups.google.com/d/optout]. Please note, responding to this email leads to an email box that is not monitored, if you have any questions feel free to send request to customerserv...@jjcalibrations.com or to your normal contact. Thank you, JJ Staff -- 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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
RE: [RBASE-L] - Email
Hmmm. I've been receiving some reports of some emails not going. I think I need to check that setting as well. -Original Message- From: Frank Taylor To: "rbase-l@googlegroups.com" Date: Wed, 10 Aug 2016 11:37:06 + Subject: RE: [RBASE-L] - Email Tom, We recently switched to a hosted exchange where I had to make some changes to my report code, one thing that got me was while I had to send a userid and password, I had to have EMAIL_AUTHENTICATION OFF , not sure why but once I changed that setting it worked on my end.. just something to try |email ON + |email_authentication OFF + |email_host &gEmailHost + |email_port 25 + |email_userid &gEmailUser + |email_password &gEmailPass + |email_to_list &vtoadd + |email_from_name Araho Transfer - Boston Division + |email_from_address &vfrom + |Email_subject &vsubject + |email_body &vames + |email_delete_after_send ON + |email_show_dialog OFF Frank Taylor – Director of Information Technology F.J. O'Hara & Sons, Inc - Araho Transfer – Boston Florida Transport – Florida Refrigerated Logistics Boston, MA - Rockland, ME - Ft. Myers, FL – Miami, FL Direct Dial - 617-790-3093 Email: ftay...@fjohara.com [mailto:ftay...@fjohara.com] From:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf OfTom Hart Sent: Monday, August 8, 2016 8:22 AM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - Email Steve, I have tried just about port Tom On Aug 7, 2016 11:44 PM, "Steve Johnson" [mailto:sjohnson...@sprintmail.com]> wrote: Tom, See if you send out on another port that does not require SSL. Might try Port 25, even though it's use is discouraged or even blocked by many residential ISP's. Steve Johnson BlackBerry Z30 From:Tom Hart Sent:Thursday, August 4, 2016 7:59 PM To:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] Reply To:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] Subject:[RBASE-L] - Email I have used the email on report settings to send emails directly thru my website and it has worked fine. Now it has stopped and when I test I get no connection. I have checked with my webhost and am doing everything write. The following is my code which worked until recently PRINT stemailreport WHERE COUNT = 1 OPTION PDF|FILENAME dbcheck.CHK + |EMAIL ON + |EMAIL_HOST mail.worldsecureemail.com [http://mail.worldsecureemail.com/] + |EMAIL_USERID t...@mywebsite.com [mailto:t...@mywebsite.com] + |EMAIL_PASSWORD Mycorrectpassword + |EMAIL_TO_LIST tooma...@sbcglobal.net [mailto:tooma...@sbcglobal.net] + |EMAIL_FROM_NAME Daisy Exchange + |EMAIL_FROM_ADDRESS t...@daisyexchange.com [mailto:t...@daisyexchange.com] + |EMAIL_SUBJECT hello + |EMAIL_BODY FROM Daisy Exchange + |EMAIL_ATTACHMENTS dbcheck.CHK + |EMAIL_PORT 587 + |EMAIL_AUTHENTICATION ON + |EMAIL_DELETE_AFTER_SEND ON + |EMAIL_SHOW_DIALOG On return Tom Hart -- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [https://groups.google.com/d/optout]. Please note, responding to this email leads to an email box that is not monitored, if you have any questions feel free to send request to customerserv...@jjcalibrations.com or to your normal contact. Thank you, JJ Staff -- 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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
[RBASE-L] - Count
Group, I need to count the number of entries in a var edit i.e. (name1,name2,name3) should result in 3. How do I do that? Jan Please note, responding to this email leads to an email box that is not monitored, if you have any questions feel free to send request to customerserv...@jjcalibrations.com or to your normal contact. Thank you, JJ Staff -- 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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [RBASE-L] - Count
Perfect! Thx
-Original Message-
From: "Bruce Chitiea"
To: rbase-l@googlegroups.com
Date: Sat, 13 Aug 2016 23:18:49 +
Subject: Re: [RBASE-L] - Count
(ITEMCNT('Text String'))
... where 'Text String' is a comma delimited list.
Bruce
-- Original Message --
Sent: 8/13/2016 4:16:32 PM
Subject: [RBASE-L] - Count
From: "jan johansen" [mailto:j...@jjcalibrations.com]>
To: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com]
Cc:
Group,
I need to count the number of entries in a var edit i.e. (name1,name2,name3)
should result in 3.
How do I do that?
Jan
Please note, responding to this email leads to an email box that is not
monitored, if you have any questions feel free to send request to
customerserv...@jjcalibrations.com
[mailto:customerserv...@jjcalibrations.com] or to your normal contact.
Thank you,
JJ Staff
--
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 rbase-l+unsubscr...@googlegroups.com
[mailto:rbase-l+unsubscr...@googlegroups.com].
For more options, visit https://groups.google.com/d/optout
[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 rbase-l+unsubscr...@googlegroups.com
[mailto:rbase-l+unsubscr...@googlegroups.com].
For more options, visit https://groups.google.com/d/optout
[https://groups.google.com/d/optout].
Please note, responding to this email leads to an email box that is not
monitored, if you have any questions feel free to send request to
customerserv...@jjcalibrations.com or to your normal contact.
Thank you,
JJ Staff
--
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
[RBASE-L] - Print all
Group, I find myself in need of printing ALL invoices for a year as a PDF. While I know I could do this in a cursor, are there any other ideas? Jan Please note, responding to this email leads to an email box that is not monitored, if you have any questions feel free to send request to customerserv...@jjcalibrations.com or to your normal contact. Thank you, JJ Staff -- 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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
RE: [RBASE-L] - Print all
Razzak, Sorry. Got lost in translation. I need to output all the invoices as individual pdf's. Like I said, I can only think of using a cursor. Jan -Original Message- From: "A. Razzak Memon" To: rbase-l@googlegroups.com Date: Tue, 06 Sep 2016 14:02:54 -0500 Subject: RE: [RBASE-L] - Print all Jan, Unless I am missing something, printing a report as PDF with appropriate WHERE clause should print the entire report as one PDF document. Very Best R:egards, Razzak Original message ---- From: jan johansen Date: 9/6/16 1:56 PM (GMT-06:00) To: rbase-l@googlegroups.com Subject: [RBASE-L] - Print all Group, I find myself in need of printing ALL invoices for a year as a PDF. While I know I could do this in a cursor, are there any other ideas? Jan -- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [https://groups.google.com/d/optout]. Please note, responding to this email leads to an email box that is not monitored, if you have any questions feel free to send request to customerserv...@jjcalibrations.com or to your normal contact. Thank you, JJ Staff -- 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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [RBASE-L] - Print all
Karen,Razzak, Thx all. On a lark, I printed with a where clause of BETWEEN and got a properly formatted report with all the invoices in one document. Glad I spent the time to set the report up properly!! Jan -Original Message- From: karentellef via RBASE-L To: rbase-l@googlegroups.com Date: Tue, 6 Sep 2016 15:11:40 -0400 Subject: Re: [RBASE-L] - Print all That's what I do.Set a cursor, construct a unique PDF name, print individual files Karen -Original Message- From: jan johansen To: rbase-l Sent: Tue, Sep 6, 2016 2:07 pm Subject: RE: [RBASE-L] - Print all Razzak, Sorry. Got lost in translation. I need to output all the invoices as individual pdf's. Like I said, I can only think of using a cursor. Jan -Original Message- From: "A. Razzak Memon" mailto:raz...@rbase.com]> To: rbase-l@googlegroups.com [mailto:l...@googlegroups.com] Date: Tue, 06 Sep 2016 14:02:54 -0500 Subject: RE: [RBASE-L] - Print all Jan, Unless I am missing something, printing a report as PDF with appropriate WHERE clause should print the entire report as one PDF document. Very Best R:egards, Razzak Original message From: jan johansen [mailto:j...@jjcalibrations.com]> Date: 9/6/16 1:56 PM (GMT-06:00) To: rbase-l@googlegroups.com [mailto:l...@googlegroups.com] Subject: [RBASE-L] - Print all Group, I find myself in need of printing ALL invoices for a year as a PDF. While I know I could do this in a cursor, are there any other ideas? Jan -- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [https://groups.google.com/d/optout]. Please note, responding to this email leads to an email box that is not monitored, if you have any questions feel free to send request to customerserv...@jjcalibrations.com [mailto:customerserv...@jjcalibrations.com] or to your normal contact. Thank you, JJ Staff -- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [https://groups.google.com/d/optout]. Please note, responding to this email leads to an email box that is not monitored, if you have any questions feel free to send request to customerserv...@jjcalibrations.com or to your normal contact. Thank you, JJ Staff -- 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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [RBASE-L] - triggers?
Jim, Do you use a Form as your main menu? If so, you could try creating a custom form action to do want you want. Call the form action every 1-2 minutes using the form timer. Jan -Original Message- From: Jim Belisle To: "rbase-l@googlegroups.com" Date: Tue, 15 Nov 2016 19:41:14 + Subject: [RBASE-L] - triggers? WE use RBASE 9.5. I want to use a table (we will call it table1) to gather work punches from the shop. Then at let’s say every minute I want to update other tables based on this gathered info. This would be instead of doing it each time a row is added to table1. What would be the most efficient way to do this? I looked at triggers, but it seems they would be based on each time a row is added. I am not sure if I want to go that route. James Belisle Making Information Systems People Friendly Since 1990 -- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
RE: [RBASE-L] - triggers?
correct -Original Message- From: Jim Belisle To: "rbase-l@googlegroups.com" Date: Tue, 15 Nov 2016 21:00:28 + Subject: RE: [RBASE-L] - triggers? Jan, If the other forms run off of a main form, then as long as the application is up, that custom form action would run based on the timer, correct? James Belisle Making Information Systems People Friendly Since 1990 From:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Ofjan johansen Sent: Tuesday, November 15, 2016 2:53 PM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - triggers? Jim, Do you use a Form as your main menu? If so, you could try creating a custom form action to do want you want. Call the form action every 1-2 minutes using the form timer. Jan -Original Message- From: Jim Belisle mailto:j...@kaypark.com]> To: "rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com]"; mailto:rbase-l@googlegroups.com]> Date: Tue, 15 Nov 2016 19:41:14 + Subject: [RBASE-L] - triggers? WE use RBASE 9.5. I want to use a table (we will call it table1) to gather work punches from the shop. Then at let’s say every minute I want to update other tables based on this gathered info. This would be instead of doing it each time a row is added to table1. What would be the most efficient way to do this? I looked at triggers, but it seems they would be based on each time a row is added. I am not sure if I want to go that route. James Belisle Making Information Systems People Friendly Since 1990 -- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
RE: [RBASE-L] - triggers?
Jim, Since you are not using temp tables another approach would be to utilize the task scheduler on your server to call an RBase command file and update your table and then the users are just looking a data that's already there. Jan -Original Message- From: Jim Belisle To: "rbase-l@googlegroups.com" Date: Tue, 15 Nov 2016 21:09:20 + Subject: RE: [RBASE-L] - triggers? Thanks, Jan. It makes sense to use that approach. I will test that. James Belisle Making Information Systems People Friendly Since 1990 From:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Ofjan johansen Sent: Tuesday, November 15, 2016 3:06 PM To: rbase-l@googlegroups.com Subject: RE: [RBASE-L] - triggers? correct -Original Message- From: Jim Belisle mailto:j...@kaypark.com]> To: "rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com]"; mailto:rbase-l@googlegroups.com]> Date: Tue, 15 Nov 2016 21:00:28 + Subject: RE: [RBASE-L] - triggers? Jan, If the other forms run off of a main form, then as long as the application is up, that custom form action would run based on the timer, correct? James Belisle Making Information Systems People Friendly Since 1990 From:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] [mailto:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com]] On Behalf Ofjan johansen Sent: Tuesday, November 15, 2016 2:53 PM To: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] Subject: Re: [RBASE-L] - triggers? Jim, Do you use a Form as your main menu? If so, you could try creating a custom form action to do want you want. Call the form action every 1-2 minutes using the form timer. Jan -Original Message- From: Jim Belisle mailto:j...@kaypark.com]> To: "rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com]"; mailto:rbase-l@googlegroups.com]> Date: Tue, 15 Nov 2016 19:41:14 + Subject: [RBASE-L] - triggers? WE use RBASE 9.5. I want to use a table (we will call it table1) to gather work punches from the shop. Then at let’s say every minute I want to update other tables based on this gathered info. This would be instead of doing it each time a row is added to table1. What would be the most efficient way to do this? I looked at triggers, but it seems they would be based on each time a row is added. I am not sure if I want to go that route. James Belisle Making Information Systems People Friendly Since 1990 -- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [RBASE-L] - variable lookup list mult select groups
There is a way. You have to enable "multi-select" in the list view. Be aware that you will to change the variable that you use to capture the "multi". Not in front of R:Base right now and can't tell you where it is, but I have done it before and it works great! -Original Message- From: Dan Goldberg To: "rbase-l@googlegroups.com" Date: Thu, 17 Nov 2016 23:49:18 + Subject: [RBASE-L] - variable lookup list mult select groups Is there a way to select a group of items in a variable lookup list other than clicking on one at a time? It would be nice to be able to select the first one and then hold down the shift on the last one I need to select a range but cannot find a setting for it. TIA Dan Goldberg -- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
RE: [RBASE-L] - variable lookup list mult select groups
Hmmm. Let me fire up the program and look at my settings. -Original Message- From: Dan Goldberg To: "rbase-l@googlegroups.com" Date: Thu, 17 Nov 2016 23:55:06 + Subject: RE: [RBASE-L] - variable lookup list mult select groups Thx Jan. I have the multi select on and the variable is text. I am guessing the variable must be a different type for it to work. Dan Goldberg From:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Ofjan johansen Sent: Thursday, November 17, 2016 3:52 PM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - variable lookup list mult select groups There is a way. You have to enable "multi-select" in the list view. Be aware that you will to change the variable that you use to capture the "multi". Not in front of R:Base right now and can't tell you where it is, but I have done it before and it works great! -Original Message- From: Dan Goldberg mailto:d...@lancecamper.com]> To: "rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com]"; mailto:rbase-l@googlegroups.com]> Date: Thu, 17 Nov 2016 23:49:18 + Subject: [RBASE-L] - variable lookup list mult select groups Is there a way to select a group of items in a variable lookup list other than clicking on one at a time? It would be nice to be able to select the first one and then hold down the shift on the last one I need to select a range but cannot find a setting for it. TIA Dan Goldberg -- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
RE: [RBASE-L] - variable lookup list mult select groups
Dan,
I set up 2 variables in the on before start eep
SET VAR vCodeList NOTE = NULL
SET VAR vCodeListTXT NOTE = NULL
The info I'm trying to capture are TEXT variables
The variable for the var list view is vCodeList
In my dbl clk eep in the var list view
SET VAR vQuotes = (CVAL('QUOTES'))
SET VAR vCodeListTXT NOTE = NULL
SET VAR vRows = (ITEMCNT(.vCodeList))
SET VAR vCodeListTXT = ('('+.vCodeList+')')
SET VAR vMode = 'Edit'
SET VAR vnupc TEXT = EquipUPC, +
vequipsd DATE = EquipEnterDate, +
vequipdd DATE = EquipDueDate +
IN Equipment WHERE EquipUPC IN &vCodeListTXT
IF vaccesslevel < 6 THEN
BROWSE USING Equipment WHERE EquipUPC IN &vCodeListTXT
ELSE
EDIT USING Equipment WHERE EquipUPC IN &vCodeListTXT
ENDIF
SET VAR vTransUPC = NULL
SET VAR vSearchFor = NULL
RECALC VARIABLES
PROPERTY ContinueButton ENABLED 'FALSE'
PROPERTY SearchFor SET_FOCUS 'TRUE'
RETURN
I hope this gives you something to try.
I didn't clean any of it up.
Jan
-Original Message-
From: Dan Goldberg
To: "rbase-l@googlegroups.com"
Date: Fri, 18 Nov 2016 00:32:34 +
Subject: RE: [RBASE-L] - variable lookup list mult select groups
I am also using that list to check against integer values in a table.
Browse all from tablename where serial in (.vlist)
If I run it with vlist as a text it comes up with a random column must be
compared to integer values.
But if I run
Browse all from tablename where serial
in(‘1’,’2’,’3’,’7’,’9’) it works fine.
Strange.
Dan Goldberg
From:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf
Ofjan johansen
Sent: Thursday, November 17, 2016 4:10 PM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - variable lookup list mult select groups
Hmmm. Let me fire up the program and look at my settings.
-Original Message-
From: Dan Goldberg mailto:d...@lancecamper.com]>
To: "rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com]";
mailto:rbase-l@googlegroups.com]>
Date: Thu, 17 Nov 2016 23:55:06 +
Subject: RE: [RBASE-L] - variable lookup list mult select groups
Thx Jan. I have the multi select on and the variable is text. I am guessing
the variable must be a different type for it to work.
Dan Goldberg
From:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com]
[mailto:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com]] On
Behalf Ofjan johansen
Sent: Thursday, November 17, 2016 3:52 PM
To: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com]
Subject: Re: [RBASE-L] - variable lookup list mult select groups
There is a way. You have to enable "multi-select" in the list view.
Be aware that you will to change the variable that you use to capture the
"multi".
Not in front of R:Base right now and can't tell you where it is, but I have
done it before and it works great!
-Original Message-
From: Dan Goldberg mailto:d...@lancecamper.com]>
To: "rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com]";
mailto:rbase-l@googlegroups.com]>
Date: Thu, 17 Nov 2016 23:49:18 +
Subject: [RBASE-L] - variable lookup list mult select groups
Is there a way to select a group of items in a variable lookup list other
than clicking on one at a time?
It would be nice to be able to select the first one and then hold down the
shift on the last one I need to select a range but cannot find a setting for
it.
TIA
Dan Goldberg
--
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 rbase-l+unsubscr...@googlegroups.com
[mailto:rbase-l+unsubscr...@googlegroups.com].
For more options, visit https://groups.google.com/d/optout
[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 rbase-l+unsubscr...@googlegroups.com
[mailto:rbase-l+unsubscr...@googlegroups.com].
For more options, visit https://groups.google.com/d/optout
[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 rbase-l+unsubscr...@googlegroups.com
[mailto:rbase-l+unsubscr...@googlegroups.com].
For more options, visit https://groups.google.com/d/optout
[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 rbase-l+unsubscr...@googlegroups.com
[mailto:rbase-l+unsubscr...@googlegroups.com].
For more options, visit https://groups.google.com/d/optout
[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
Re: [RBASE-L] - Tip of the Day: Managing Monitors and Monitor Properties
sweet -Original Message- From: "A. Razzak Memon" To: rbase-l@googlegroups.com Date: Tue, 06 Dec 2016 09:00:15 -0500 Subject: [RBASE-L] - Tip of the Day: Managing Monitors and Monitor Properties Tuesday, December 06, 2016 Tip of the Day: Managing Monitors and Monitor Properties Product...: R:BASE X/X Enterprise (Version 10) Build.: 10.0.2.11130 or higher Section...: Commands Keywords..: GETPROPERTY, Monitors Did you know that there are new GETPROPERTY command parameters to help manage multi-monitor hardware environments? For instance, the functionality to return the number of monitors connected to a system, is available using the GETPROPERTY command as follows: GETPROPERTY APPLICATION MONITOR_COUNT vMonitorCount In addition, the following GETPROPERTY command has been implemented to return the monitor screen size properties, using the value of X as a zero based index. GETPROPERTY APPLICATION MONITOR_PROPERTY[X] VarName The result is a comma separated list of values in the following format: MonitorNumber,MonitorIsPrimaryYN,MonitorLeft,MonitorTop,MonitorWidth, MonitorHeight,MonitorWorkareaLeft,MonitorWorkareaTop,MonitorWorkareaRight, MonitorWorkareaBottom The "WorkArea" properties is the monitor area, less the task bar area. Example: GETPROPERTY APPLICATION MONITOR_PROPERTY[0] vMonitorProps SHOW VAR vMonitorProps 0,Y,0,0,1920,1080,0,0,1920,1040 Very Best R:egards, Razzak. www.rbase.com [http://www.rbase.com/] www.facebook.com/rbase [http://www.facebook.com/rbase] -- 33 years of continuous innovation! 18 Years of R:BASE Technologies, Inc. making R:BASE what it is today! -- -- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l%2Bunsubscribe%40googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [RBASE-L] - R:BASE X Enterprise - SAT (Additional Application)
Does this apply to alumni of the 2016 SAT? -Original Message- From: "A. Razzak Memon" To: rbase-l@googlegroups.com Date: Tue, 06 Dec 2016 10:30:10 -0500 Subject: [RBASE-L] - R:BASE X Enterprise - SAT (Additional Application) Tuesday, December 6, 2016 All attendees of 2016 R:BASE X Enterprise SAT in San Diego, CA will also receive a limited and compiled application of R:BASE Customer Relational Management (CRM). For your viewing pleasure ... http://www.rbaseuniversity.com/applications/RBASE_CRM_01.JPG [http://www.rbaseuniversity.com/applications/RBASE_CRM_01.JPG] http://www.rbaseuniversity.com/applications/RBASE_CRM_02.JPG [http://www.rbaseuniversity.com/applications/RBASE_CRM_02.JPG] http://www.rbaseuniversity.com/applications/RBASE_CRM_03.JPG [http://www.rbaseuniversity.com/applications/RBASE_CRM_03.JPG] http://www.rbaseuniversity.com/applications/RBASE_CRM_04.JPG [http://www.rbaseuniversity.com/applications/RBASE_CRM_04.JPG] http://www.rbaseuniversity.com/applications/RBASE_CRM_05.JPG [http://www.rbaseuniversity.com/applications/RBASE_CRM_05.JPG] http://www.rbaseuniversity.com/applications/RBASE_CRM_06.JPG [http://www.rbaseuniversity.com/applications/RBASE_CRM_06.JPG] 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l%2Bunsubscribe%40googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [RBASE-L] - Property command
Tom, I believe in a scrolling region you will only be able to change the color based on the current 'row' if that makes a difference to you. Otherwise a DB grid or variable list will show all 'T' as green. Jan -Original Message- From: Tom Hart To: rbase-l@googlegroups.com Date: Thu, 8 Dec 2016 14:16:48 -0600 Subject: [RBASE-L] - Property command Using Rbase X have a scrolling region for that has a field with 'T' taxable or 'N' nontaxable. If it is 'T' I want it to show green, if 'N' to show red. What is the best to accomplish this Tom Hart -- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
[RBASE-L] - Store comma seperated
Group, Having a sugar induced brain cramp. I want to store a comma separated list in a table. Basically want to save either a list of job functions by individual or assign individuals to job functions. So a person can have more than one job function or job functions can have several people. I don't seem to see a DB object that allows multi-select. Am I blind? Jan Please note that JJ Calibrations will be closed on Friday the 23rd and Monday the 26th so that our employees can be with their families. We will also be closed on Monday, January 2nd. We will respond to emails as quickly as we can upon our return. Thank you, Eric Johansen President -- 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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [RBASE-L] - Store comma seperated
Bill, Good point. Let me explore one to many form. Jan -Original Message- From: Bill Downall To: rbase-l@googlegroups.com Date: Wed, 21 Dec 2016 20:25:01 -0500 Subject: Re: [RBASE-L] - Store comma seperated Relational purist that I am, I would use a many-side table with a row for each job function for an employee. Indexes would retrieve everybody with a particular job function quickly. And a "SELECT List of (colname)" would get you your comma-separated list if and when you need it. (sent from Moto Z) On Dec 21, 2016 8:12 PM, "jan johansen" [mailto:j...@jjcalibrations.com]> wrote: Group, Having a sugar induced brain cramp. I want to store a comma separated list in a table. Basically want to save either a list of job functions by individual or assign individuals to job functions. So a person can have more than one job function or job functions can have several people. I don't seem to see a DB object that allows multi-select. Am I blind? Jan Please note that JJ Calibrations will be closed on Friday the 23rd and Monday the 26th so that our employees can be with their families. We will also be closed on Monday, January 2nd. We will respond to emails as quickly as we can upon our return. Thank you, Eric Johansen President -- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [https://groups.google.com/d/optout]. Please note that JJ Calibrations will be closed on Friday the 23rd and Monday the 26th so that our employees can be with their families. We will also be closed on Monday, January 2nd. We will respond to emails as quickly as we can upon our return. Thank you, Eric Johansen President -- 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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [RBASE-L] - Store comma seperated
Razzak, Thank you. I was sure that there was a Multi select tool for DB and didn't look at DB Grid. I think based on your attached image, I can locate your sample in the version X sample database. Jan -Original Message- From: "A. Razzak Memon" To: rbase-l@googlegroups.com Date: Thu, 22 Dec 2016 11:38:24 -0500 Subject: Re: [RBASE-L] - Store comma seperated Jan, Did you know that you can enable the "Multi-Select" option of the Enhanced DB Grid Control Properties to accomplish you goal? For your viewing pleasure ... http://www.razzak.com/tips/Multi_Select_EnhancedDBGrid.png [http://www.razzak.com/tips/Multi_Select_EnhancedDBGrid.png] Remember, you are only limited to your knowledge, in-depth experience, and all available options in R:BASE X Enterprise (Version 10). Let me know if you need a sample application to illustrate the use of such cool feature in R:BASE X Enterprise. Very Best R:egards, Razzak At 08:12 PM 12/21/2016, jan johansen wrote: Having a sugar induced brain cramp. I want to store a comma separated list in a table. Basically want to save either a list of job functions by individual or assign individuals to job functions. So a person can have more than one job function or job functions can have several people. I don't seem to see a DB object that allows multi-select. Am I blind? -- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l%2Bunsubscribe%40googlegroups.com]. For more options, visit https://groups.google.com/d/optout [https://groups.google.com/d/optout]. Please note that JJ Calibrations will be closed on Friday the 23rd and Monday the 26th so that our employees can be with their families. We will also be closed on Monday, January 2nd. We will respond to emails as quickly as we can upon our return. Thank you, Eric Johansen President -- 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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
[RBASE-L] - ENTER
Using latest X (1130) I have a very simple (a db edit and navigator). Using ENTER mode. Yesterday if I pressed ENTER in the DB edit, the form inserted a row, cleared the db edit and was ready for the next input. Today, Enter inserts the row but doesn't clear the DB edit. What am I missing? Jan Please note that JJ Calibrations will be closed on Friday the 23rd and Monday the 26th so that our employees can be with their families. We will also be closed on Monday, January 2nd. We will respond to emails as quickly as we can upon our return. Thank you, Eric Johansen President -- 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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
RE: [RBASE-L] - RIP Bob Castanaro
Hmmm. He has been active telling the stories of his struggles on Facebook here https://www.facebook.com/bobcastanaro Jan -Original Message- From: "Javier Valencia" To: Date: Fri, 23 Dec 2016 14:19:46 -0600 Subject: RE: [RBASE-L] - RIP Bob Castanaro Sorry to hear about Bob, I also remember him from the Conferences and contributions to the List in the past. Looks like he has not used his Facebook account in the last couple of years since he got the initial diagnostic; I wanted to post something there for his family, but I would need to become friends first…which a this time seems moot. Javier, Javier Valencia, PE 14315 S. Twilight Ln. Olathe, KS 66062 Home: 913-397-9605 Office: 913-829-0888 Cell: 913-915-3137 From:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf OfBill Downall Sent: Thursday, December 22, 2016 7:28 PM To: rbase-l@googlegroups.com Subject: [RBASE-L] - RIP Bob Castanaro After a grueling battle with cancer, long-time R:BASE developer Bob Castanaro, from Barberton, OH, died this week. He chose to stop dialysis a little over a week ago, and, as he said, to say goodbye on his own terms. I always enjoyed playful, friendly, respectful political disagreements with Bob at Developers' Conferences, and he always had great ideas and experiences to share from his hospital administration database applications. https://www.facebook.com/bobcastanaro [https://www.facebook.com/bobcastanaro] Bill (sent from Moto Z) -- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [https://groups.google.com/d/optout]. Please note that JJ Calibrations will be closed on Friday the 23rd and Monday the 26th so that our employees can be with their families. We will also be closed on Monday, January 2nd. We will respond to emails as quickly as we can upon our return. Thank you, Eric Johansen President -- 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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [RBASE-L] - Convert
Tom, I believe so. Let's just say that I was trouble shooting a compiled app and was working with a backup copy. I attempted to connect to a 9.5 database and was asked "do you want to convert". Jan -Original Message- From: Tom Hart To: rbase-l@googlegroups.com Date: Tue, 27 Dec 2016 14:12:13 -0600 Subject: [RBASE-L] - Convert Can you convert a database from 95(32) to X(Enterprise) in a compiled app Tom Hart -- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [https://groups.google.com/d/optout]. Please note that JJ Calibrations will be closed on Friday the 23rd and Monday the 26th so that our employees can be with their families. We will also be closed on Monday, January 2nd. We will respond to emails as quickly as we can upon our return. Thank you, Eric Johansen President -- 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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [RBASE-L] - Odd Report Action
Tom, I moved to separate NOTE tables. If I remember correctly, NOTE can be 4096. However it is limited by the other fields in the row. Just a thought. Jan -Original Message- From: "Tom Frederick" To: Date: Sun, 15 Jan 2017 15:55:00 -0600 Subject: [RBASE-L] - Odd Report Action I have a large, complicated report with has 20 sections based on 12 view based subreports. It has run correctly for several years. I can repeatedly run this report for any number of people and create a complete 20 section report. Recently I had one person where this report built everything except sections XI/XII. After many attempts, I tracked down the field in a record that was causing the problem for that one person. The field was a NOTE that had about 100 characters. It is the only NOTE in this table. There were no strange characters that I could see. Simply rewriting the NOTE ended the problem. This same field in other rows often had over 1400 characters so NOTE works. Using RBXE latest updates. So I have two questions: 1.Is there some way to identify when non-text items are in a field? 2.I used to have many NOTEs in tables. Most of those got changed to TEXT based how much users actually wrote over time. Numerous RBase examples have Notes in the associated Tables. Is this print problem an indication that I need to completely move to separate NOTE tables? Tom Frederick -- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [RBASE-L] - ERASE filespec
Claudine,
You can try this (untested).
SET VAR vQuotes = (CVAL('QUOTES'))
SET VAR vfilename1 TEXT = NULL
SET VAR vfilename2 TEXT = NULL
SET VAR vDeleteFileCommand TEXT = ('DELETE ' + .vQuotes +.vfilename2 +
.vQuotes)
SET VAR vCopyFileCommand TEXT = ('COPY ' + .vQuotes + .vfilename1 + .vQuotes
&.vQuotes + .vfilename2 + .vQuotes)
&vDeleteFileCommand
PAUSE FOR 2
&vCopyFileCommand
Jan
-Original Message-
From: Claudine Robbins
To: "rbase-l@googlegroups.com"
Date: Thu, 2 Feb 2017 19:35:45 +
Subject: [RBASE-L] - ERASE filespec
Hello all,
I’m having a bit of a headache with an ERASE filespec command which has
worked reliably for weeks, works reliably from the R:> prompt and yields
“Failed deleting… (2262)” then “Cannot create destination file
(2086)” from within a form when I:
ERASE .filename2
And
COPY .filename1 .filename2
Permissions are ok… Undoubtedly my fault but I can’t find it, help!
TIA,
Claudine
--
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 rbase-l+unsubscr...@googlegroups.com
[mailto:rbase-l+unsubscr...@googlegroups.com].
For more options, visit https://groups.google.com/d/optout
[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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Re: [RBASE-L] - Still stumped
Does the RFF work in an uncompiled state? -Original Message- From: Tom Hart To: rbase-l@googlegroups.com Date: Wed, 8 Feb 2017 21:45:31 -0600 Subject: [RBASE-L] - Still stumped I am going to post this again because I am totally stumped. Very simply I am trying to print a report directly to the printer using an external form as follows: PRINT PR_Testreport OPTION PRINTER return This works fine from R>, but pulls up the Print Preview screen if run from a compiled version. I do nothing execpt compile the external form(the one that runs correctly form R>). Any ideas Tom Hart -- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [RBASE-L] - Still stumped
Tom, Shot in the dark. There have been a couple of times that after an update, major weirdness happened in a couple of my forms. I restored the forms from a backup and everything was fine again. I suggest just recreate your form since it sounds simple enough. Also going over some of your previous questions, I have never tried the batch compile so I don't know if something else is happening. Do your other projects work as expected after they were re-compiled after the update? Do you compile including the engine? If not, is there an engine mismatch? Many things to look at. Jan -Original Message- From: Tom Hart To: rbase-l@googlegroups.com Date: Thu, 9 Feb 2017 11:07:31 -0600 Subject: Re: [RBASE-L] - Still stumped Yes it works fine in uncompiled Tom On Feb 9, 2017 11:06 AM, "jan johansen" mailto:j...@jjcalibrations.com]> wrote: Does the RFF work in an uncompiled state? -Original Message- From: Tom Hart mailto:tooma...@gmail.com]> To: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] Date: Wed, 8 Feb 2017 21:45:31 -0600 Subject: [RBASE-L] - Still stumped I am going to post this again because I am totally stumped. Very simply I am trying to print a report directly to the printer using an external form as follows: PRINT PR_Testreport OPTION PRINTER return This works fine from R>, but pulls up the Print Preview screen if run from a compiled version. I do nothing execpt compile the external form(the one that runs correctly form R>). Any ideas Tom Hart -- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
RE: [RBASE-L] - Still stumped
Tom, I save all my updates in different directories so I can backwards just in case. Do you as well? If you do, you can see if previous version works. See my previous post about making sure your engines are the proper version. Jan -Original Message- From: Tom Hart To: rbase-l@googlegroups.com Date: Thu, 9 Feb 2017 13:52:50 -0600 Subject: RE: [RBASE-L] - Still stumped Jan, Nothing I compile will work, I will try and download current update, already tried newest updates that I had downloaded right when it came available, so I'll try re-downloading. Tom On Feb 9, 2017 11:33 AM, "Javier Valencia" mailto:javier.valen...@vtgonline.com]> wrote: Have you tried using a regular form rather than an external form? Javier, Javier Valencia, PE 14315 S. Twilight Ln. Olathe, KS 66062 Home: 913-397-9605 [tel:(913)%20397-9605] Office: 913-829-0888 [tel:(913)%20829-0888] Cell: 913-915-3137 [tel:(913)%20915-3137] From:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] [mailto:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com]] On Behalf OfTom Hart Sent: Thursday, February 09, 2017 11:08 AM To: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] Subject: Re: [RBASE-L] - Still stumped Yes it works fine in uncompiled Tom On Feb 9, 2017 11:06 AM, "jan johansen" mailto:j...@jjcalibrations.com]> wrote: Does the RFF work in an uncompiled state? -Original Message- From: Tom Hart mailto:tooma...@gmail.com]> To: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] Date: Wed, 8 Feb 2017 21:45:31 -0600 Subject: [RBASE-L] - Still stumped I am going to post this again because I am totally stumped. Very simply I am trying to print a report directly to the printer using an external form as follows: PRINT PR_Testreport OPTION PRINTER return This works fine from R>, but pulls up the Print Preview screen if run from a compiled version. I do nothing execpt compile the external form(the one that runs correctly form R>). Any ideas Tom Hart -- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [RBASE-L] - my first go around with staticdb on
Dan, We have run with STATICDB and FASTLOCK on for years and can only confirm this one 'Compiled apps freeze at random. You can have a compiled app open and switch to another program then come back and it is non-responsive. You have to end task.' It is so random that it happens I have never tried to track it down and have never associated your observations with those settings. Interesting. -Original Message- From: Dan Goldberg To: "rbase-l@googlegroups.com" Date: Fri, 10 Feb 2017 16:48:42 + Subject: [RBASE-L] - my first go around with staticdb on A couple of weeks ago I turned on staticdb and fastlock to see how it worked for us for the first time. We have ran into some issues after turning it on. Compiled apps freeze at random. You can have a compiled app open and switch to another program then come back and it is non-responsive. You have to end task. Fedex software cannot find orders after a period of time over ottero odbc. Some reports will be missing data at random. If they close the compiled app and reopen it, it works fine. Just thought I would report on it. See if anybody had experiences, thoughts… Dan Goldberg -- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [RBASE-L] - MDI syntax help
Karen, I've used a couple of MDI forms. I think the issue is this PROPERTY 'AllBLs|RBASE_FORM' SET_FOCUS 'TRUE' change it to this PROPERTY AllBLs|RBASE_FORM SET_FOCUS 'TRUE' Jan -Original Message- From: Motel Du Parc To: rbase-l@googlegroups.com Date: Fri, 10 Feb 2017 11:50:52 -0500 Subject: Re: [RBASE-L] - MDI syntax help EDIT USING formname MDI AS alias SETFOCUS alias 2017-02-10 9:56 GMT-05:00 karentellef via RBASE-L mailto:rbase-l@googlegroups.com]>: I'm using syntax that's from the X SAT that I attended, and there's something I'm obviously not getting correct. I bring up a form (non-MDI, form name AllBLs) and clicking into a row brings up an MDI form based on that row. However, after bringing up that MDI form, I want to transfer focus immediately back to the "calling form" AllBLs. I thought this was the syntax per the SAT example. At first I just refer to the calling form's original name, and I put this on the MDI form's on after start eep: PROPERTY 'AllBLs|RBASE_FORM' SET_FOCUS 'TRUE' But I get the error message: Component 'AllBLs|RBASE_FORM' not found in current form I thought maybe I had to bring up the calling form in MDI mode, so I changed it to: EDIT USING AllBLs where MDI AS 'AllBLs' but I still get the same error after bringing up the MDI form. What do I have wrong in that syntax to return focus back to the AllBLs form? Thanks! Karen -- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
RE: [RBASE-L] - my first go around with staticdb on
Dan, I think it's a focus issue. Let me explain our scenario. We have a main menu that calls other things as I'm sure we all use. However in many cases, the called form is smaller than the menu form. So the client is in the smaller form and goes to check email. Tries to come back to the app and all they see is the main menu. The smaller form is hidden behind the main menu and they have to use to get back to the form they left. I believe there is a way to overcome this but I think it would be handy to know how to force the O/S back to the compiled with a PROPERTY command or something like that. Jan -Original Message- From: Dan Goldberg To: "rbase-l@googlegroups.com" Date: Fri, 10 Feb 2017 17:53:43 + Subject: RE: [RBASE-L] - my first go around with staticdb on Thx Jan, this was my first time trying it so I did not know what to expect besides not being able to make structure changes. Gunna turn it back off this weekend to see if they go away. My users are crying mostly about the freeze issue. Dan Goldberg From:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Ofjan johansen Sent: Friday, February 10, 2017 9:20 AM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - my first go around with staticdb on Dan, We have run with STATICDB and FASTLOCK on for years and can only confirm this one 'Compiled apps freeze at random. You can have a compiled app open and switch to another program then come back and it is non-responsive. You have to end task.' It is so random that it happens I have never tried to track it down and have never associated your observations with those settings. Interesting. -Original Message- From: Dan Goldberg mailto:d...@lancecamper.com]> To: "rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com]"; mailto:rbase-l@googlegroups.com]> Date: Fri, 10 Feb 2017 16:48:42 + Subject: [RBASE-L] - my first go around with staticdb on A couple of weeks ago I turned on staticdb and fastlock to see how it worked for us for the first time. We have ran into some issues after turning it on. Compiled apps freeze at random. You can have a compiled app open and switch to another program then come back and it is non-responsive. You have to end task. Fedex software cannot find orders after a period of time over ottero odbc. Some reports will be missing data at random. If they close the compiled app and reopen it, it works fine. Just thought I would report on it. See if anybody had experiences, thoughts… Dan Goldberg -- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
RE: [RBASE-L] - problem with null values
Patti, Buddy beat me to it but sometimes when we are using an older database, we actually saved a space for a null so you may need to check to see if you actually have nulls. Jan -Original Message- From: "Buddy Walker" To: Date: Tue, 14 Feb 2017 17:11:14 -0500 Subject: RE: [RBASE-L] - problem with null values Patti You might want to try something like this depending on how you want to hand null dates. It my example I’m saying if date is null then make it 12/31/2999 or whatever date you want. …. OldestDate =(LMAX((IFNULL(DATE1,12/31/2999,DATE1)),(IFNULL(DATE2,12/31/2999,DATE2)),(IFNULL(DATE3,12/31/2999,DATE3 I didn’t test this so make sure to test on a copy of database Buddy From:'Patti Jakusz' via RBASE-L [mailto:rbase-l@googlegroups.com] Sent: Tuesday, February 14, 2017 3:38 PM To: rbase-l@googlegroups.com; RBASE-L ; RBASE-L Subject: [RBASE-L] - problem with null values Hello, I'm using Rbase 10. I'm trying to update one date column in my table to be the oldest of 3 other date columns. My command is: update Table1 set OldestDate = (LMAX(date1, date2, date3)) But it only works if all three dates have values. I have zero set on. I tried setting on Eqnull. But I only get a blank if one of the dates is null. Is there another setting to turn on? Thanks, Patti -- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
RE: [RBASE-L] - my first go around with staticdb on
Razzak, I'm with Dan. Whatever it is, it's totally random. So there is nothing to report to the dream team. Jan -Original Message- From: Dan Goldberg To: "rbase-l@googlegroups.com" Date: Wed, 15 Feb 2017 16:55:17 + Subject: RE: [RBASE-L] - my first go around with staticdb on It is a random issue and cannot replicate it on demand. That is the problem. I am sure it is not a programming issue because you can just have it open doing nothing and it will become unresponsive. Dan Goldberg From:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf OfA. Razzak Memon Sent: Tuesday, February 14, 2017 9:27 PM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - my first go around with staticdb on Dan, Kenny, Brad, Jan, Et al. Have any one of you had any interaction with the members of R:Dream Team? If you think it is an R:BASE related item, and not any of your programming or other contributing factors, all you need to do is to prepare a sample that illustrates the issue, and make sure that you are able to reliably replicate it on demand. Then, let R:Dream Team take care of it accordingly, as always! Otherwise, spend some quality time to explore other contributing factors. FWIW ... Here are typical examples of running R:BASE applications in STATICDB ON and STATICDB OFF environments: -- STATICDB OFF Environment DISCONNECT SET STATICDB OFF SET ROWLOCKS ON SET FASTLOCK OFF SET PAGELOCK OFF CONNECT RRBYW19 IDENTIFIED BY NONE RETURN -- STATICDB ON Environment DISCONNECT SET STATICDB ON SET ROWLOCKS ON SET FASTLOCK ON SET PAGELOCK OFF SET ERROR MESSAGE 2495 OFF CONNECT RRBYW19 IDENTIFIED BY NONE SET ERROR MESSAGE 2495 ON RETURN Hope it helps! Very Best R:egards, Razzak On Fri, Feb 10, 2017 at 12:19 PM, jan johansen mailto:j...@jjcalibrations.com]> wrote: Dan, We have run with STATICDB and FASTLOCK on for years and can only confirm this one 'Compiled apps freeze at random. You can have a compiled app open and switch to another program then come back and it is non-responsive. You have to end task.' It is so random that it happens I have never tried to track it down and have never associated your observations with those settings. Interesting. -Original Message- From: Dan Goldberg mailto:d...@lancecamper.com]> To: "rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com]"; mailto:rbase-l@googlegroups.com]> Date: Fri, 10 Feb 2017 16:48:42 + Subject: [RBASE-L] - my first go around with staticdb on A couple of weeks ago I turned on staticdb and fastlock to see how it worked for us for the first time. We have ran into some issues after turning it on. Compiled apps freeze at random. You can have a compiled app open and switch to another program then come back and it is non-responsive. You have to end task. Fedex software cannot find orders after a period of time over ottero odbc. Some reports will be missing data at random. If they close the compiled app and reopen it, it works fine. Just thought I would report on it. See if anybody had experiences, thoughts… Dan Goldberg -- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [RBASE-L] - Form size
Do you have a backup of the form? -Original Message- From: "Carpet Broker, Dick Fey" To: RBase Maillist Date: Fri, 24 Feb 2017 12:47:09 -0600 Subject: [RBASE-L] - Form size OK, so this is really weird. If I examine the form in form designer, I can see nothing that shouldn't be there, but if I open the form, at the r-prompt scroll all the way to the right, and the blank space is MUCH wider than it looks in form designer, I can see two db-labels that are the problem. But I can't seem to get to them in form designer. Dick Fey -- Carpet Broker Inc P: 913-894-9211 F: 913-894-0138 -- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l%2Bunsubscribe%40googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [RBASE-L] - Scrolling Region question
Frank, I'm not sure you can do what you want with a scrolling region as you only display different colors when you enter the row (I believe). So if you have your tier color as GRAY and you want your row color to be RED when un-available, it will only do that on that specific row when you enter it. However, you should be able to accomplish what you desire using the DB-Grid and a form timer to update the colors based on availability, say a 10 second update. Hope that makes sense. Jan -Original Message- From: Frank Massimo To: "rbase-l@googlegroups.com" Date: Thu, 2 Mar 2017 19:41:03 + Subject: [RBASE-L] - Scrolling Region question I am using a scrolling region as part of a data entry system. The items displayed in the region can be determined to be "unavailable" at different times of the day or because of some other business decision. I would like to display that item (or entire tier) in a different font or color or some other effect which would let the order taker know that the item is presently unavailable, yet let them see what it is. I'm using Rbase X Enterprise (love it!) and can't seem to find a method to do this, or if it's even a possibility. Any help would be greatly appreciated. Frank Massimo Tri-State Logistics, Inc. -- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [RBASE-L] - Using R: Charts with temporary tables
Stefan, Looks like Razzak has you covered but what I did when I wanted to use TEMP tables was make them PERMANENT tables until design of chart was completed and then changed the table to TEMP. Jan -Original Message- From: "A. Razzak Memon" To: rbase-l@googlegroups.com Date: Wed, 15 Mar 2017 07:35:48 -0400 Subject: Re: [RBASE-L] - Using R: Charts with temporary tables Stefan: While in R:Charts XE designer, after connecting to database, and before creating/updating an existing project (.rbc), you may take advantage of newly introduced options as follows: . On Before Design EEP ... . On Before Design EEP without Opening RBC File ... This is where you would define all TEMPORARY table(s) to select them as Source. Hope that helps! Feel free to reach out to me if you have further questions. Very Best R:egards, Razzak At 04:47 AM 3/15/2017, Stefan Maldet wrote: >Hello Everybody, > >I want to use R:Charts with temporary tables but >I cannot find my temp tables to select them as source…. >Has anybody an idea what I do wrong? -- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l%2Bunsubscribe%40googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [RBASE-L] - Dialog options
Don't believe so. However you can make a simple to accomplish you task. You know SET VAR vMyDialogOptions TEXT = 'No' EDIT USING MyDialogOptions SWITCH vMyDialogOptions CASE 'Yes' GOTO Yes BREAK CASE 'Maybe' GOTO Maybe BREAK DEFAULT GOTO No BREAK ENDSW -Original Message- From: "Carpet Broker, Dick Fey" To: RBase Maillist Date: Tue, 21 Mar 2017 13:59:29 -0500 Subject: [RBASE-L] - Dialog options I know I could handle this is various ways, but is it possible to do a dialog command with more than 2 buttons ? (YES NO MAYBE DON'T KNOW) -- Carpet Broker Inc P: 913-894-9211 F: 913-894-0138 -- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l%2Bunsubscribe%40googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [RBASE-L] - From The Edge: R:BASE Cursors Explained
Karen, This is an excellent article. A couple of things for you. 1. Since you are dealing with an OLD cursor, make sure you SET all the needed VARIABLE datatypes and values to NULL completely outside the CURSOR. You can set the values inside the CURSOR but you can't (shouldn't) really define vars inside the CURSOR. 2. Because of all your GOTO's inside the CURSOR, you should really explore the SCROLL feature in your cursor. The cursor is looking for the GOTO Labels from top to bottom repeatedly. Telling the cursor to go forward or backward a certain number of rows (since you know where the labels are) would most certainly speed up the cursor. Jan -Original Message- From: karentellef via RBASE-L To: rbase-l@googlegroups.com Date: Fri, 28 Apr 2017 12:16:47 -0400 Subject: Re: [RBASE-L] - From The Edge: R:BASE Cursors Explained Cool, read the whole document!! Unfortunately not alot of it applies to my specific situation since there are no nested cursors and it's never updating any tables. The original writer of the program also did a nice job of writing the initial "declare" command to pull in as much data as needed, including some calculations right there rather than within the loop. But one thing jumped out, that you say that a "set var" is slightly faster than a "select into". I was thinking of converting all those "set var" statements, so I won't bother now! Karen -Original Message- From: A. Razzak Memon To: rbase-l Sent: Fri, Apr 28, 2017 10:56 am Subject: [RBASE-L] - From The Edge: R:BASE Cursors Explained Friday, April 28, 2017 >From The Edge.: R:BASE Cursors Explained Product...: R:BASE X, R:BASE X Enterprise (Version 10) Build.: 10.0.2.20411 or higher www.rupdates.com [http://www.rupdates.com/] Keywords..: Commands, CURSOR, DECLARE, FETCH, SELECT An R:BASE cursor is a valuable programming control structure that enables traversal reference over the records in a database. It is a pointer to rows in a table that can step through rows one by one, performing the same action on each row. A cursor can be set to point to all the rows in a table or to a subset of rows. A cursor is set using the DECLARE CURSOR command. R:BASE supports several types of cursors and cursor structures including: . Multi-Table Cursors . Non-Updateable Cursors . Nested Cursors . Resettable Cursors . Scrolling Cursors All of the cursors above and examples of Optimizing Cursors are described within the R:BASE Cursors Explained technical document. >From The Edge: http://www.razzak.com/fte [http://www.razzak.com/fte] Article Title: R:BASE Cursors Explained Very Best R:egards, Razzak. www.rbase.com [http://www.rbase.com/] www.facebook.com/rbase [http://www.facebook.com/rbase] -- 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 rbase-l+unsubscr...@googlegroups.com [mailto:l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [RBASE-L] - From The Edge: R:BASE Cursors Explained
Karen, I have not used scroll so don't have any experience with it. However, this command seems to indicate "skipping" around RELATIVE n - Moves the cursor the specified number of rows from the current cursor position. This option moves the cursor either forwards or backwards - forwards if a positive number is specified, backwards if a negative number is specified. The intervening rows are jumped over. You can't jump past the last row or the first row; an "end of data" error is returned if the specified number would take you past the beginning or end of the selected rows. Jan -Original Message- From: karentellef via RBASE-L To: rbase-l@googlegroups.com Date: Fri, 28 Apr 2017 14:25:08 -0400 Subject: Re: [RBASE-L] - From The Edge: R:BASE Cursors Explained Jan, I think you're misunderstanding what SCROLL is. What that does is to scroll through rows of data in your cursor, not through lines of code. So your declare cursor could FETCH LAST to go to the last data row, FETCH RELATIVE 5 to jump forward by 5 rows of data, etc. FETCH NEXT is the only possible use in my situation, but after issuing the FETCH NEXT you still have to go somewhere with the data, I'm not just fetching and dumping out of the loop as the pdf example shows. Unless I'm misunderstanding what you were suggesting. You seem to be suggesting that SCROLL would help jump around the program code Karen -Original Message- From: karentellef To: rbase-l Sent: Fri, Apr 28, 2017 1:18 pm Subject: Re: [RBASE-L] - From The Edge: R:BASE Cursors Explained 1. The programmer was good at initializing variables before the cursor. Here's his list (look at all the REAL datatypes, the database is loaded with REAL columns). In 2014 when our While loop first started misbehaving, I made sure that no variables are defined using a datatype within the looping, even tho we do run with whileopt OFF. SET VAR vagentno TEXT = NULL, vagentcount INTEGER = 0, vagent1comm REAL = NULL, + vagent2comm REAL = NULL, vagent3comm REAL = NULL, vagentcomm REAL = NULL, + vtestagtcomm REAL = NULL, vagtstatus TEXT = NULL, vrktcomm REAL = NULL, + vrktcommission REAL = NULL, vagentcommission REAL = NULL, vplanins TEXT = NULL, + vcountmgr INTEGER = 0, vcountpol INTEGER = 0, vinsadvance REAL = 0, + vtestrecdate DATE = NULL, vtestagtcomm REAL = NULL, vagtcomm REAL = NULL, + vcount INTEGER = 0, vpaycode TEXT = NULL, vicount INTEGER = 0, vagtadvance REAL = NULL, + tdate DATE = NULL, fac_year INTEGER = NULL, fac_month INTEGER = NULL, viscancelled TEXT = NULL, + vdate1 DATE = NULL, vdate2 DATE = NULL, vdatecursor DATE = NULL, vdays INTEGER = NULL, + vmonths INTEGER = NULL, vfreqtx TEXT = NULL, vfreq INTEGER = NULL, vmonprem CURR = NULL2. Most ofthe "gotos" (7 of them) relate to going to separate areas within the loop, to do certain calculations, skip over some calculations, or to return back to a previous spot in the loop if something needed to be repeated. There is a possibility with very careful reconstruction that I could avoid a few of those gotos by constructing yet more nested IF loops, not sure. It's one thing that's on my list to try! There are only 3 actual "goto startloop" that relate to going back to the top to get another record, which is what you could use the SCROLL for. I've never tried "scroll" without a "while" loop, however, so I'd have to test if that would even work. When this was an actual while loop, I think it used "CONTINUE", which would be my first choice over SCROLL, but I no longer have a while loop. The "goto startloop" is only evaluated if there's error conditions in the record, and is only at the very top of the processing loop. If I go with one of my ideas of setting up an autonumbered temp table first rather than a declare cursor, I should be able to do the error checking before I even get into the loop, so that will take away the "goto startloop" altogether! Karen -Original Message- From: jan johansen mailto:j...@jjcalibrations.com]> To: karentellef via RBASE-L mailto:l...@googlegroups.com]> Sent: Fri, Apr 28, 2017 11:43 am Subject: Re: [RBASE-L] - From The Edge: R:BASE Cursors Explained Karen, This is an excellent article. A couple of things for you. 1. Since you are dealing with an OLD cursor, make sure you SET all the needed VARIABLE datatypes and values to NULL completely outside the CURSOR. You can set the values inside the CURSOR but you can't (shouldn't) really define vars inside the CURSOR. 2. Because of all your GOTO's inside the CURSOR, you should really explore the SCROLL feature in your cursor. The cursor is looking for the GOTO Labels from top to bottom repeatedly. Telling the cursor to go forward or backward a certain number of rows (since you know where the labels are) would mo
Re: [RBASE-L] - From The Edge: R:BASE Cursors Explained
My apologies. I read "rows" as "rows of code" not "rows of data" -Original Message- From: karentellef via RBASE-L To: rbase-l@googlegroups.com Date: Fri, 28 Apr 2017 14:45:13 -0400 Subject: Re: [RBASE-L] - From The Edge: R:BASE Cursors Explained Yes, exactly. Ifyour cursor is on data row #10, and for some reason you wanted the cursor to skip down to data row #15, you could issue a FETCH RELATIVE 5 and it would jump 5 data rows. My cursor would never do anything other than fetch the next row. I never skip rows, back up, or jump forward. I remember using FETCH RELATIVE once in my career, way back when I did a program to randomly select a row of data from a table. I would use the RANDOM function (whatever that was) to generate a random number, and then within my cursor would use that to skip forward or backward that random number of data rows. Karen -----Original Message- From: jan johansen To: karentellef via RBASE-L Sent: Fri, Apr 28, 2017 1:37 pm Subject: Re: [RBASE-L] - From The Edge: R:BASE Cursors Explained Karen, I have not used scroll so don't have any experience with it. However, this command seems to indicate "skipping" around RELATIVE n - Moves the cursor the specified number of rows from the current cursor position. This option moves the cursor either forwards or backwards - forwards if a positive number is specified, backwards if a negative number is specified. The intervening rows are jumped over. You can't jump past the last row or the first row; an "end of data" error is returned if the specified number would take you past the beginning or end of the selected rows. Jan -Original Message- From: karentellef via RBASE-L mailto:l...@googlegroups.com]> To: rbase-l@googlegroups.com [mailto:l...@googlegroups.com] Date: Fri, 28 Apr 2017 14:25:08 -0400 Subject: Re: [RBASE-L] - From The Edge: R:BASE Cursors Explained Jan, I think you're misunderstanding what SCROLL is. What that does is to scroll through rows of data in your cursor, not through lines of code. So your declare cursor could FETCH LAST to go to the last data row, FETCH RELATIVE 5 to jump forward by 5 rows of data, etc. FETCH NEXT is the only possible use in my situation, but after issuing the FETCH NEXT you still have to go somewhere with the data, I'm not just fetching and dumping out of the loop as the pdf example shows. Unless I'm misunderstanding what you were suggesting. You seem to be suggesting that SCROLL would help jump around the program code Karen -Original Message- From: karentellef mailto:karentel...@cs.com]> To: rbase-l mailto:l...@googlegroups.com]> Sent: Fri, Apr 28, 2017 1:18 pm Subject: Re: [RBASE-L] - From The Edge: R:BASE Cursors Explained 1. The programmer was good at initializing variables before the cursor. Here's his list (look at all the REAL datatypes, the database is loaded with REAL columns). In 2014 when our While loop first started misbehaving, I made sure that no variables are defined using a datatype within the looping, even tho we do run with whileopt OFF. SET VAR vagentno TEXT = NULL, vagentcount INTEGER = 0, vagent1comm REAL = NULL, + vagent2comm REAL = NULL, vagent3comm REAL = NULL, vagentcomm REAL = NULL, + vtestagtcomm REAL = NULL, vagtstatus TEXT = NULL, vrktcomm REAL = NULL, + vrktcommission REAL = NULL, vagentcommission REAL = NULL, vplanins TEXT = NULL, + vcountmgr INTEGER = 0, vcountpol INTEGER = 0, vinsadvance REAL = 0, + vtestrecdate DATE = NULL, vtestagtcomm REAL = NULL, vagtcomm REAL = NULL, + vcount INTEGER = 0, vpaycode TEXT = NULL, vicount INTEGER = 0, vagtadvance REAL = NULL, + tdate DATE = NULL, fac_year INTEGER = NULL, fac_month INTEGER = NULL, viscancelled TEXT = NULL, + vdate1 DATE = NULL, vdate2 DATE = NULL, vdatecursor DATE = NULL, vdays INTEGER = NULL, + vmonths INTEGER = NULL, vfreqtx TEXT = NULL, vfreq INTEGER = NULL, vmonprem CURR = NULL2. Most ofthe "gotos" (7 of them) relate to going to separate areas within the loop, to do certain calculations, skip over some calculations, or to return back to a previous spot in the loop if something needed to be repeated. There is a possibility with very careful reconstruction that I could avoid a few of those gotos by constructing yet more nested IF loops, not sure. It's one thing that's on my list to try! There are only 3 actual "goto startloop" that relate to going back to the top to get another record, which is what you could use the SCROLL for. I've never tried "scroll" without a "while" loop, however, so I'd have to test if that would even work. When this was an actual while loop, I think it used "CONTINUE", which would be my first choice over SCROLL, but I no longer have a while loop. The "goto startloop" is only evaluated if there's error conditions
Re: [RBASE-L] - From The Edge: R:BASE Cursors Explained
Karen, Have you explored using a SWITCH inside the cursor? It might be faster than GOTO. Jan -Original Message- From: "jan johansen" To: "karentellef via RBASE-L" Date: Fri, 28 Apr 2017 11:49:19 -0700 Subject: Re: [RBASE-L] - From The Edge: R:BASE Cursors Explained My apologies. I read "rows" as "rows of code" not "rows of data" -Original Message- From: karentellef via RBASE-L To: rbase-l@googlegroups.com Date: Fri, 28 Apr 2017 14:45:13 -0400 Subject: Re: [RBASE-L] - From The Edge: R:BASE Cursors Explained Yes, exactly. Ifyour cursor is on data row #10, and for some reason you wanted the cursor to skip down to data row #15, you could issue a FETCH RELATIVE 5 and it would jump 5 data rows. My cursor would never do anything other than fetch the next row. I never skip rows, back up, or jump forward. I remember using FETCH RELATIVE once in my career, way back when I did a program to randomly select a row of data from a table. I would use the RANDOM function (whatever that was) to generate a random number, and then within my cursor would use that to skip forward or backward that random number of data rows. Karen -Original Message- From: jan johansen To: karentellef via RBASE-L Sent: Fri, Apr 28, 2017 1:37 pm Subject: Re: [RBASE-L] - From The Edge: R:BASE Cursors Explained Karen, I have not used scroll so don't have any experience with it. However, this command seems to indicate "skipping" around RELATIVE n - Moves the cursor the specified number of rows from the current cursor position. This option moves the cursor either forwards or backwards - forwards if a positive number is specified, backwards if a negative number is specified. The intervening rows are jumped over. You can't jump past the last row or the first row; an "end of data" error is returned if the specified number would take you past the beginning or end of the selected rows. Jan -Original Message- From: karentellef via RBASE-L mailto:l...@googlegroups.com]> To: rbase-l@googlegroups.com [mailto:l...@googlegroups.com] Date: Fri, 28 Apr 2017 14:25:08 -0400 Subject: Re: [RBASE-L] - From The Edge: R:BASE Cursors Explained Jan, I think you're misunderstanding what SCROLL is. What that does is to scroll through rows of data in your cursor, not through lines of code. So your declare cursor could FETCH LAST to go to the last data row, FETCH RELATIVE 5 to jump forward by 5 rows of data, etc. FETCH NEXT is the only possible use in my situation, but after issuing the FETCH NEXT you still have to go somewhere with the data, I'm not just fetching and dumping out of the loop as the pdf example shows. Unless I'm misunderstanding what you were suggesting. You seem to be suggesting that SCROLL would help jump around the program code Karen -Original Message- From: karentellef mailto:karentel...@cs.com]> To: rbase-l mailto:l...@googlegroups.com]> Sent: Fri, Apr 28, 2017 1:18 pm Subject: Re: [RBASE-L] - From The Edge: R:BASE Cursors Explained 1. The programmer was good at initializing variables before the cursor. Here's his list (look at all the REAL datatypes, the database is loaded with REAL columns). In 2014 when our While loop first started misbehaving, I made sure that no variables are defined using a datatype within the looping, even tho we do run with whileopt OFF. SET VAR vagentno TEXT = NULL, vagentcount INTEGER = 0, vagent1comm REAL = NULL, + vagent2comm REAL = NULL, vagent3comm REAL = NULL, vagentcomm REAL = NULL, + vtestagtcomm REAL = NULL, vagtstatus TEXT = NULL, vrktcomm REAL = NULL, + vrktcommission REAL = NULL, vagentcommission REAL = NULL, vplanins TEXT = NULL, + vcountmgr INTEGER = 0, vcountpol INTEGER = 0, vinsadvance REAL = 0, + vtestrecdate DATE = NULL, vtestagtcomm REAL = NULL, vagtcomm REAL = NULL, + vcount INTEGER = 0, vpaycode TEXT = NULL, vicount INTEGER = 0, vagtadvance REAL = NULL, + tdate DATE = NULL, fac_year INTEGER = NULL, fac_month INTEGER = NULL, viscancelled TEXT = NULL, + vdate1 DATE = NULL, vdate2 DATE = NULL, vdatecursor DATE = NULL, vdays INTEGER = NULL, + vmonths INTEGER = NULL, vfreqtx TEXT = NULL, vfreq INTEGER = NULL, vmonprem CURR = NULL 2. Most ofthe "gotos" (7 of them) relate to going to separate areas within the loop, to do certain calculations, skip over some calculations, or to return back to a previous spot in the loop if something needed to be repeated. There is a possibility with very careful reconstruction that I could avoid a few of those gotos by constructing yet more nested IF loops, not sure. It's one thing that's on my list to try! There are only 3 actual "goto startloop" that relate to going back to the top to get another record, which is what you could use the SCROLL for. I've never tried "scroll" without a "while"
Re: [RBASE-L] - Compute vs Select
If they only run this code once a month, why don't you put the code in a bat file and run it on the server off hours and send the results to someone? -Original Message- From: karentellef via RBASE-L To: rbase-l@googlegroups.com Date: Fri, 28 Apr 2017 17:21:29 -0400 Subject: Re: [RBASE-L] - Compute vs Select I have no temp tables created yet.Probably won't be getting to this project until next week, just gathering ideas at this time. They'll next run the program on May 20 (they run it once a month) so I'd like to have something in place by then Karen -Original Message- From: Dan Goldberg To: rbase-l Sent: Fri, Apr 28, 2017 3:47 pm Subject: Re: [RBASE-L] - Compute vs Select Have u tried indexing the temp tables? Dan Goldberg Lance Camper On Fri, Apr 28, 2017 at 1:07 PM -0700, "karentellef via RBASE-L" mailto:rbase-l@googlegroups.com]> wrote: Just an FYI Idid a comparison of "compute" vs "select" in Version X (works the same as 9.5). See the print-screen below. I tested with a where clause that will fail, I tested both a SUM and a COUNT: With zero ON (my default) SUM "compute" returns a null "select" returns a 0 COUNT both return a 0 No errors are returned With zero OFF SUM both return a null COUNT both return a 0 A "warning" is returned only for the Select Sum So in my old code, I can replace my "compute" with "select" when I'm doing a "COUNT" because it always returns a 0 However, I cannot easily replace my "compute SUM" with a "select" because the program tests for a result being null, and it instead would evaluate as 0. I would have to either (a) change my checking to look at 0 rather than null or (b) change my zero to OFF, which I'm reluctant to do for the entire routine because that would change everything, so I'd have to set it off and back on around every single compute statement, and there's alot of them. Speed: Couldn't get a good comparison. Everything I tried took either 1 or 2 seconds and they switched back and forth, so I'm guessing it was "rounding". Seems like they're about equal in speed. BTW: these are two of the lookup-type of variable gathering commands that are in my monster cursor program. The first table AgtComm has 4 million rows, with RecDate indexed. However, it usually (not always) looks at just one month's worth of data, which is usually around 55,000 rows. So I can pull that 55,000 rows into a temp table to see if it speeds up. Karen -- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [RBASE-L] - Quickbooks
Karen, Yes. Cost me a customer. The data they wished to send was huge and I advised against it because I knew that Quickbooks was a bad fit. They did it anyway and when the data import routine into took hours and would drop data, they blamed me. I must add that we use Quickbooks for recording of expenses but we only record total daily sales as reported by our RBase database. The database handles billing and AR functions. This is my opinion only. Jan -Original Message- From: karentellef via RBASE-L To: rbase-l@googlegroups.com Date: Thu, 4 May 2017 13:17:08 -0400 Subject: [RBASE-L] - Quickbooks It's been decades since I've had to deal with Quickbooks, and it wasn't exactly a joy back then... Someone just asked me about sending stuff from RBase into Quickbooks (they do not own QB yet, so it would be a new version of the software). Has anyone here used a new version of QB and let me know if it's easier nowadays to send data to QB? For example, what kind of formats does it accept as an import? Any gotchas? We'd probably be sending over lists of "members" (name, address, etc), and different kinds of revenues received (member fees, special fees, event fees) Thanks for any insight! Karen -- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [RBASE-L] - Rbase
I will admit that we did our accounting in RBase 4.5 and it did everything as well. RBaseX still handles billing and accounts receivable. At the end of the day we print a report with to enter about 6 numbers into Quickbooks. Quickbooks handles accounts payable. -Original Message- From: "Carpet Broker, Dick Fey" To: RBase Maillist Date: Thu, 11 May 2017 11:48:15 -0500 Subject: [RBASE-L] - Rbase It might take a little more work up front, but for 30 years we have been running our multi-million dollar business totally from R:base. No peachtree, No Quickbooks. We do everything in R:Base. Accounting, Payroll, Sales, everything. Even print customers Fax checks. No outside problems to deal with. Dick Fey -- Carpet Broker Inc P: 913-894-9211 F: 913-894-0138 -- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l%2Bunsubscribe%40googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [RBASE-L] - Including Forms in Compiled app
Dawn, Welcome. 1. How much of an improvement (in speed) could one expect by including the forms in the compiled application vs just keeping them in the db? It will depend on your network but you should see slight improvement. Forms really aren't all that big. 2. Checking current compiled version. Nice idea. I had it a couple years back but it can't be done. Basically the compiler is running an instance and it can't be copied over it self. You can check the version and inform the user that there is a newer version but not an automatic install. Jan -Original Message- From: Dawn Hast To: rbase-l@googlegroups.com Date: Tue, 30 May 2017 17:09:49 + Subject: [RBASE-L] - Including Forms in Compiled app After an extended leave, I'm back having fun with RBase, even if only part time! It's nice to see all the familiar names in the group :-) I don't have a ton of history using the compiler and have a couple questions. How much of an improvement (in speed) could one expect by including the forms in the compiled application vs just keeping them in the db? I thought I remembered seeing something about detecting the version of the compiled application - but can't find it. I'm wanting to check the version of the exe against the current approved version and force an update if the user is using an out of date exe. I have some old scripts that looked at file information that I might dig out, but I thought someone had posted something on this recently. Thanks! Dawn Hast -- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [RBASE-L] - Including Forms in Compiled app
Dawn, Then you should be able to place this in an ON AFTER START eep in a form. SET VAR vCurrentVersion TEXT = '2017.04.30.001' SET VAR vWhatVersionAmI TEXT = NULL GETPROPERTY APPLICATION FileVersion vWhatVersionAmI IF vWhatVersionAmI <> .vCurrentVersion THEN PAUSE USING ... CLOSEWINDOW EXIT RETURN ENDIF Jan -Original Message- From: Dawn Hast To: rbase-l@googlegroups.com Date: Tue, 30 May 2017 19:08:57 + Subject: Re: [RBASE-L] - Including Forms in Compiled app Thanks Jan, Yes, I was thinking check the version, inform the user and exit the program. Not allowing them to use the old version will force the issue. On Tue, May 30, 2017 at 2:59 PM jan johansen mailto:j...@jjcalibrations.com]> wrote: Dawn, Welcome. 1. How much of an improvement (in speed) could one expect by including the forms in the compiled application vs just keeping them in the db? It will depend on your network but you should see slight improvement. Forms really aren't all that big. 2. Checking current compiled version. Nice idea. I had it a couple years back but it can't be done. Basically the compiler is running an instance and it can't be copied over it self. You can check the version and inform the user that there is a newer version but not an automatic install. Jan -Original Message- From: Dawn Hast mailto:dbh...@gmail.com]> To: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] Date: Tue, 30 May 2017 17:09:49 + Subject: [RBASE-L] - Including Forms in Compiled app After an extended leave, I'm back having fun with RBase, even if only part time! It's nice to see all the familiar names in the group :-) I don't have a ton of history using the compiler and have a couple questions. How much of an improvement (in speed) could one expect by including the forms in the compiled application vs just keeping them in the db? I thought I remembered seeing something about detecting the version of the compiled application - but can't find it. I'm wanting to check the version of the exe against the current approved version and force an update if the user is using an out of date exe. I have some old scripts that looked at file information that I might dig out, but I thought someone had posted something on this recently. Thanks! Dawn Hast -- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [RBASE-L] - Including Forms in Compiled app
So it's personal preference. If you have 20 users all in the same building and have access to all of them, place the compiled version on each each computer. If you users are spread out over buildings and states, run it from the server. Jan -Original Message- From: Dawn Hast To: "rbase-l@googlegroups.com" Date: Tue, 30 May 2017 19:45:44 + Subject: Re: [RBASE-L] - Including Forms in Compiled app Dan - that's kind of where I was going with that. I've always run it on the server - but I was thinking that if the forms were local to the PC and it just had to retrieve data, then it might be faster in those situations where the network speed was less than optimal. But that introduces the issue of making sure the version on the local PC is current, so was thinking ahead of how to control that. Though it doesn't sound like the improvement would be enough to make a difference. I might test it out tomorrow if time allows. On Tue, May 30, 2017 at 3:40 PM Dan Goldberg mailto:d...@lancecamper.com]> wrote: That brings up an interesting topic. My compiled app is located in a network share on the server and the users have a shortcut to it. It is better to have the compiled app on the users pc? Dan Goldberg From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] [mailto:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com]] On Behalf Ofjan johansen Sent: Tuesday, May 30, 2017 12:21 PM To: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] Subject: Re: [RBASE-L] - Including Forms in Compiled app Dawn, Then you should be able to place this in an ON AFTER START eep in a form. SET VAR vCurrentVersion TEXT = '2017.04.30.001' SET VAR vWhatVersionAmI TEXT = NULL GETPROPERTY APPLICATION FileVersion vWhatVersionAmI IF vWhatVersionAmI <> .vCurrentVersion THEN PAUSE USING ... CLOSEWINDOW EXIT RETURN ENDIF Jan -Original Message- From: Dawn Hast mailto:dbh...@gmail.com]> To: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] Date: Tue, 30 May 2017 19:08:57 + Subject: Re: [RBASE-L] - Including Forms in Compiled app Thanks Jan, Yes, I was thinking check the version, inform the user and exit the program. Not allowing them to use the old version will force the issue. On Tue, May 30, 2017 at 2:59 PM jan johansen mailto:j...@jjcalibrations.com]> wrote: Dawn, Welcome. 1. How much of an improvement (in speed) could one expect by including the forms in the compiled application vs just keeping them in the db? It will depend on your network but you should see slight improvement. Forms really aren't all that big. 2. Checking current compiled version. Nice idea. I had it a couple years back but it can't be done. Basically the compiler is running an instance and it can't be copied over it self. You can check the version and inform the user that there is a newer version but not an automatic install. Jan -Original Message- From: Dawn Hast mailto:dbh...@gmail.com]> To: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] Date: Tue, 30 May 2017 17:09:49 + Subject: [RBASE-L] - Including Forms in Compiled app After an extended leave, I'm back having fun with RBase, even if only part time! It's nice to see all the familiar names in the group :-) I don't have a ton of history using the compiler and have a couple questions. How much of an improvement (in speed) could one expect by including the forms in the compiled application vs just keeping them in the db? I thought I remembered seeing something about detecting the version of the compiled application - but can't find it. I'm wanting to check the version of the exe against the current approved version and force an update if the user is using an out of date exe. I have some old scripts that looked at file information that I might dig out, but I thought someone had posted something on this recently. Thanks! Dawn Hast -- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com [mail
RE: [RBASE-L] - Including Forms in Compiled app
Login script good. I haven't done that in a while. -Original Message- From: Dan Goldberg To: "rbase-l@googlegroups.com" Date: Tue, 30 May 2017 19:56:41 + Subject: RE: [RBASE-L] - Including Forms in Compiled app Thx jan. I have a lot of users. I guess I can create a login script when they login to their pcs to copy the compiled app each time. Dan From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Ofjan johansen Sent: Tuesday, May 30, 2017 12:52 PM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - Including Forms in Compiled app So it's personal preference. If you have 20 users all in the same building and have access to all of them, place the compiled version on each each computer. If you users are spread out over buildings and states, run it from the server. Jan -Original Message- From: Dawn Hast mailto:dbh...@gmail.com]> To: "rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com]"; mailto:rbase-l@googlegroups.com]> Date: Tue, 30 May 2017 19:45:44 + Subject: Re: [RBASE-L] - Including Forms in Compiled app Dan - that's kind of where I was going with that. I've always run it on the server - but I was thinking that if the forms were local to the PC and it just had to retrieve data, then it might be faster in those situations where the network speed was less than optimal. But that introduces the issue of making sure the version on the local PC is current, so was thinking ahead of how to control that. Though it doesn't sound like the improvement would be enough to make a difference. I might test it out tomorrow if time allows. On Tue, May 30, 2017 at 3:40 PM Dan Goldberg mailto:d...@lancecamper.com]> wrote: That brings up an interesting topic. My compiled app is located in a network share on the server and the users have a shortcut to it. It is better to have the compiled app on the users pc? Dan Goldberg From:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] [mailto:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com]] On Behalf Ofjan johansen Sent: Tuesday, May 30, 2017 12:21 PM To: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] Subject: Re: [RBASE-L] - Including Forms in Compiled app Dawn, Then you should be able to place this in an ON AFTER START eep in a form. SET VAR vCurrentVersion TEXT = '2017.04.30.001' SET VAR vWhatVersionAmI TEXT = NULL GETPROPERTY APPLICATION FileVersion vWhatVersionAmI IF vWhatVersionAmI <> .vCurrentVersion THEN PAUSE USING ... CLOSEWINDOW EXIT RETURN ENDIF Jan -Original Message- From: Dawn Hast mailto:dbh...@gmail.com]> To: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] Date: Tue, 30 May 2017 19:08:57 + Subject: Re: [RBASE-L] - Including Forms in Compiled app Thanks Jan, Yes, I was thinking check the version, inform the user and exit the program. Not allowing them to use the old version will force the issue. On Tue, May 30, 2017 at 2:59 PM jan johansen mailto:j...@jjcalibrations.com]> wrote: Dawn, Welcome. 1. How much of an improvement (in speed) could one expect by including the forms in the compiled application vs just keeping them in the db? It will depend on your network but you should see slight improvement. Forms really aren't all that big. 2. Checking current compiled version. Nice idea. I had it a couple years back but it can't be done. Basically the compiler is running an instance and it can't be copied over it self. You can check the version and inform the user that there is a newer version but not an automatic install. Jan -Original Message- From: Dawn Hast mailto:dbh...@gmail.com]> To: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] Date: Tue, 30 May 2017 17:09:49 + Subject: [RBASE-L] - Including Forms in Compiled app After an extended leave, I'm back having fun with RBase, even if only part time! It's nice to see all the familiar names in the group :-) I don't have a ton of history using the compiler and have a couple questions. How much of an improvement (in speed) could one expect by including the forms in the compiled application vs just keeping them in the db? I thought I remembered seeing something about detecting the version of the compiled application - but can't find it. I'm wanting to check the version of the exe against the current approved version and force an update if the user is using an out of date exe. I have some old scripts that looked at file information that I might dig out, but I thought someone had posted something on this recently. Thanks! Dawn Hast -- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more o
Re: [RBASE-L] - Tip of the Day: Enhanced RBA Application Conversion to External Form File
Nice! -Original Message- From: "A. Razzak Memon" To: rbase-l@googlegroups.com Date: Sat, 03 Jun 2017 10:45:42 -0400 Subject: [RBASE-L] - Tip of the Day: Enhanced RBA Application Conversion to External Form File Saturday, June 3, 2017 Tip of the Day: Enhanced RBA Application Conversion to External Form File Product...: R:BASE X/X Enterprise (Version 10) Build.: 10.0.2.20530 or higher Section...: Forms, External Forms Keywords..: Conversion, Application, RBA, External Form Did you know that your RBA Application can be converted to a Tree View control within an External Form (RFF) file? Converting R:BASE applications has taken another long stride forward with the recent added features to migrate RBA Application files to External Form files. In addition to the Menu Bar layout style for the columnar menus, the Tree View control is an added option, to arrange menu options within a hierarchical list tree structure where end users can expand or collapse the associated list of items and nodes. http://www.razzak.com/tips/RBGX_Convert_RBA_File.png [http://www.razzak.com/tips/RBGX_Convert_RBA_File.png] Also, to assist with the transition of code, Application Actions are also placed and referenced into Custom EEPs and Custom Form Actions accordingly, saving many hours in programming. One of the most important aspects in business growth is your company data, and no one else has more invested in your success than R:BASE Technologies. Invest forward with R:BASE! Very Best R:egards, Razzak. www.rbase.com [http://www.rbase.com/] www.facebook.com/rbase [http://www.facebook.com/rbase] -- 34 years of continuous innovation! 19 Years of R:BASE Technologies, Inc. making R:BASE what it is today! -- -- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l%2Bunsubscribe%40googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [RBASE-L] - Tip of the Day: Modern Appearance Styles for Digital Clock
Razzak, Just a quick question. These formats can be used without a theme? Jan -Original Message- From: "A. Razzak Memon" To: rbase-l@googlegroups.com Date: Fri, 02 Jun 2017 00:05:38 -0400 Subject: [RBASE-L] - Tip of the Day: Modern Appearance Styles for Digital Clock Friday, June 2, 2017 Tip of the Day: Modern Appearance Styles for Digital Clock Product...: R:BASE X/X Enterprise (Version 10) Build.: 10.0.2.20530 or higher Section...: Forms Keywords..: Digital Clock, Style, Appearance Did you know the Digital Clock form control was updated to support modern appearance styles to superbly enhance the clock display? There are sixteen (16) new "Modern" appearance styles added to the Digital Clock control: . AfricaSunset . Classic . CleanWhite . DarkNight . DeepFire . Disco . IceColdZone . iStyle . Future . Mechanical . Military . Retro . Smart . SportCar . YellowSubmarine . White Africa Sunset Style: http://www.razzak.com/tips/RBGX_ModernDigitalClock_AfricanSunset.jpg [http://www.razzak.com/tips/RBGX_ModernDigitalClock_AfricanSunset.jpg] Mechanical Style: http://www.razzak.com/tips/RBGX_ModernDigitalClock_Mechanical.jpg [http://www.razzak.com/tips/RBGX_ModernDigitalClock_Mechanical.jpg] Yellow Submarine Style: http://www.razzak.com/tips/RBGX_ModernDigitalClock_YellowSubmarine.jpg [http://www.razzak.com/tips/RBGX_ModernDigitalClock_YellowSubmarine.jpg] Have fun designing R:TimeClock, R:TimeTrack, or even R:BiometricXn applications using the Modern Digital Clock in R:BASE X and R:BASE X Enterprise (ver 10). One of the most important aspects in business growth is your company data, and no one else has more invested in your success than R:BASE Technologies. Invest forward with R:BASE! Very Best R:egards, Razzak. www.rbase.com [http://www.rbase.com/] www.facebook.com/rbase [http://www.facebook.com/rbase] -- 34 years of continuous innovation! 19 Years of R:BASE Technologies, Inc. making R:BASE what it is today! -- -- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l%2Bunsubscribe%40googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [RBASE-L] - Strange printing problem
That's handy!
Thx Karen.
-Original Message-
From: karentellef via RBASE-L
To: rbase-l@googlegroups.com
Date: Wed, 14 Jun 2017 15:43:35 -0400
Subject: Re: [RBASE-L] - Strange printing problem
Jim: I saved this syntax to send PDFs to the printer, so you could form
them first and then send. The problem with this is that you would need to
know the location of Adobe
LAUNCH 'C:\Program Files\Adobe\Acrobat 5.0\Reader\AcroRd32.exe|/p /h
C:\Cust.pdf'
Karen
-Original Message-
From: Javier Valencia
To: rbase-l
Sent: Wed, Jun 14, 2017 2:32 pm
Subject: RE: [RBASE-L] - Strange printing problem
#AOLMsgPart_1.2_75f0bb8a-9478-4b77-99ac-138bb4c0f1b1 td{color: black;}
@font-face {font-family:Helvetica; panose-1:2 11 6 4 2 2 2 2 2 4;
mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable;
mso-font-signature:-536859905 -1073711037 9 0 511 0;}@font-face
{font-family:Helvetica; panose-1:2 11 6 4 2 2 2 2 2 4; mso-font-charset:0;
mso-generic-font-family:swiss; mso-font-pitch:variable;
mso-font-signature:-536859905 -1073711037 9 0 511 0;}@font-face
{font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4; mso-font-charset:0;
mso-generic-font-family:swiss; mso-font-pitch:variable;
mso-font-signature:-536870145 1073786111 1 0 415 0;}@font-face
{font-family:Tahoma; panose-1:2 11 6 4 3 5 4 4 2 4; mso-font-charset:0;
mso-generic-font-family:swiss; mso-font-pitch:variable;
mso-font-signature:-520081665 -1073717157 41 0 66047 0;}@font-face
{font-family:"Lucida Console"; panose-1:2 11 6 9 4 5 4 2 2 4;
mso-font-charset:0; mso-generic-font-family:modern; mso-font-pitch:fixed;
mso-font-signature:-2147482993 6144 0 0 31 0;}.aolReplacedBody
p.aolmail_MsoNormal,.aolReplacedBody li.aolmail_MsoNormal,.aolReplacedBody
div.aolmail_MsoNormal {mso-style-unhide:no; mso-style-qformat:yes;
mso-style-parent:""; margin:0in; margin-bottom:.0001pt;
mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New
Roman","serif"; mso-fareast-font-family:Calibri;}.aolReplacedBody
a:link,.aolReplacedBody span.aolmail_MsoHyperlink {mso-style-priority:99;
color:blue; text-decoration:underline;
text-underline:single;}.aolReplacedBody a:visited,.aolReplacedBody
span.aolmail_MsoHyperlinkFollowed {mso-style-noshow:yes;
mso-style-priority:99; color:purple; text-decoration:underline;
text-underline:single;}.aolReplacedBody p {mso-style-noshow:yes;
mso-style-priority:99; mso-margin-top-alt:auto; margin-right:0in;
mso-margin-bottom-alt:auto; margin-left:0in; mso-pagination:widow-orphan;
font-size:12.0pt; font-family:"Times New Roman","serif";
mso-fareast-font-family:Calibri;}.aolReplacedBody
p.aolmail_MsoAcetate,.aolReplacedBody
li.aolmail_MsoAcetate,.aolReplacedBody div.aolmail_MsoAcetate
{mso-style-noshow:yes; mso-style-priority:99; mso-style-link:"Balloon Text
Char"; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan;
font-size:8.0pt; font-family:"Tahoma","sans-serif";
mso-fareast-font-family:Calibri;}.aolReplacedBody
span.aolmail_BalloonTextChar {mso-style-name:"Balloon Text Char";
mso-style-noshow:yes; mso-style-priority:99; mso-style-unhide:no;
mso-style-locked:yes; mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif"; mso-ascii-font-family:Tahoma;
mso-hansi-font-family:Tahoma; mso-bidi-font-family:Tahoma;}.aolReplacedBody
p.aolmail_yiv6072838519msoacetate,.aolReplacedBody
li.aolmail_yiv6072838519msoacetate,.aolReplacedBody
div.aolmail_yiv6072838519msoacetate {mso-style-name:yiv6072838519msoacetate;
mso-style-priority:99; mso-style-unhide:no; mso-margin-top-alt:auto;
margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in;
mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New
Roman","serif"; mso-fareast-font-family:Calibri;}.aolReplacedBody
p.aolmail_yiv6072838519msonormal0,.aolReplacedBody
li.aolmail_yiv6072838519msonormal0,.aolReplacedBody
div.aolmail_yiv6072838519msonormal0 {mso-style-name:yiv6072838519msonormal0;
mso-style-priority:99; mso-style-unhide:no; mso-margin-top-alt:auto;
margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in;
mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New
Roman","serif"; mso-fareast-font-family:Calibri;}.aolReplacedBody
p.aolmail_yiv6072838519msonormal,.aolReplacedBody
li.aolmail_yiv6072838519msonormal,.aolReplacedBody
div.aolmail_yiv6072838519msonormal {mso-style-name:yiv6072838519msonormal;
mso-style-priority:99; mso-style-unhide:no; mso-margin-top-alt:auto;
margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in;
mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New
Roman","serif"; mso-fareast-font-family:Calibri;}.aolReplacedBody
p.aolmail_yiv6072838519msochpdefault,.aolReplacedBody
li.aolmail_yiv6072838519msochpdefault,.aolReplacedBody
div.aolmail_yiv6072838519msochpdefault
{mso-style-name:yiv6072838519msochpdefault; mso-style-priority:99;
mso-style-unhide:no; mso-margin-top-alt:auto; margin-right:0in;
m
Re: [RBASE-L] - Lookup List view and scroll bars
Tom, If I'm reading correctly you can use the TOPITEM property. Place something like this in your listview ONCLICK eep CLEAR VARIABLE vTopItem SET VAR vTopItem TEXT = NULL GETPROPERTY YOURLISTVIEWPROPERTYID TOPITEM vTopItem PROPERTY YOURLISTVIEWPROPERTYID TOPITEM .vTopItem Jan -Original Message- From: Tom Frederick To: "rbase-l@googlegroups.com" Date: Sat, 8 Jul 2017 11:47:38 -0500 Subject: [RBASE-L] - Lookup List view and scroll bars I use Variable Lookup List Views regularly. They provide a list of names, click on a name, and the name moves to a selected view. Basic concept is from SAT samples. Works great. If I leave space on screen to show 20 names and 40 names are selected, a scroll bar pops up to help navigate. Is there a way to control that scroll bar? The screen list will show names in ASC order based on LastName. John Smith will be off the screen because the 20th name is Mary Jones and John Smith in name 35. Move to John Smith, click his name to add him and the screen will pop back to the remaining names in ASC order with Henry Adder at the top of the list. If my next name to pick is Tom Smith I have to go back through the list. Is there some way to make the scroll bar/cursor stay where I was when I selected John Smith so it is easy to simply click on Tom Smith? Tom Frederick -- 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 rbase-l+unsubscr...@googlegroups.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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [RBASE-L] - RE: strange error
Does it show as a temp table in your db explorer? -Original Message- From: Jim Belisle To: "rbase-l@googlegroups.com" Date: Fri, 14 Jul 2017 17:41:35 + Subject: [RBASE-L] - RE: strange error No. James Belisle Making Information Systems People Friendly Since 1990 From:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf OfDan Goldberg Sent: Friday, July 14, 2017 12:38 PM To: rbase-l@googlegroups.com Subject: [RBASE-L] - RE: strange error Do you see any strange tables in the database explorer? Dan Goldberg From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] [mailto:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com]] On Behalf OfJim Belisle Sent: Friday, July 14, 2017 10:36 AM To: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] Subject: [RBASE-L] - strange error We use 9.5 the last build. I have a shop application that has been running smoothly until this morning. One form that comes up has code that DROPS a temp table. Here is the code. Starting this morning, this error message started coming up when during this code. I rebuilt the DB last night and got no errors. I also checked the DB with RSCOPE last night with no errors. I tried using a backup form and got the same results. Could this be that the application somehow got corrupted and I just need to bring in a recompiled app? The forms used in this application work fine on the backup DB on my C drive. James Belisle Making Information Systems People Friendly Since 1990 -- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [RBASE-L] - clicking too often
One thing you can do is "disable" the object in the on-click eep., Like PROPERTY VariableListViewObject ENABLE FALSE -Original Message- From: Jim Belisle To: "rbase-l@googlegroups.com" Date: Tue, 18 Jul 2017 15:50:14 + Subject: [RBASE-L] - clicking too often In the past there was a thread about preventing more than one click because of users being so used to “double clicking”. I have looked in my saved lists and cannot seem to find it. Can anyone give me an idea of how to prevent this? We just installed my shop management system out in the shop and am concerned the employees will do the double clicking. I want my code to be a “security blanket” against corruption due to too many clicks. James Belisle Making Information Systems People Friendly Since 1990 -- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [RBASE-L] - clicking too often
I've done the disabling of an object and it does work. However I'm always providing feedback such as a PAUSE that you clear after the processing is completed. -Original Message- From: Albert Berry To: "rbase-l@googlegroups.com" Date: Tue, 18 Jul 2017 13:44:46 -0600 Subject: Re: [RBASE-L] - clicking too often Temporary tables are not within the database, they are .$$$ files on the drive. I always drop and never delete from temporary tables with no problems. The problems here appear from the posts to be that a second (double) click is sending a second request to the system. There is one post in here that suggests that the first click can be used to disable the component so that R:Base doesn’t see the second click. I have not tried that myself, but it certainly sounds like a reasonable idea. On Jul 18, 2017, at 1:06 PM, Tony IJntema mailto:t.ijnt...@cio-bv.nl]> wrote: James, Maybe a silly question, but why dropping the table instead of emptying the table. It looks a less vulnerable operation to me, but I could be wrong. Tony Van:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com][mailto:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com]]NamensJim Belisle Verzonden:dinsdag 18 juli 2017 18:18 Aan:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] Onderwerp:RE: [RBASE-L] - clicking too often Dan, That may explain what has been happening. A particular employee, twice now, has corrupted the DB. Each time he gets an error that the temp table is not available. If he is double clicking, could it be the second click is so fast it is running the deleting of the temp table (I delete temp tables at the start per training)? Then the computer is confused? Not sure but so far it is only the one employee. I am not on site until next week so I am not sure if this is the case. But it is strange that it is the same employee each time. SO he must be doing something and as the programmer I need to stop him. James Belisle Making Information Systems People Friendly Since 1990 From:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com][mailto:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com]]On Behalf OfDan Goldberg Sent:Tuesday, July 18, 2017 11:13 AM To:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] Subject:RE: [RBASE-L] - clicking too often That is correct jim Dan Goldberg Lance Camper On Tue, Jul 18, 2017 at 9:09 AM -0700, "Jim Belisle" mailto:j...@kaypark.com]> wrote: Dan and Jan, So this is a bit button. It creates a temp table then has code verifying the employee information prior to bringing up another form. You are saying I should put the property command at the start of the code. Then if the employee double clicks instead of clicking, this will prevent the code from repeating. Then Enable to form bit button at the end of the code. Is this correct? James Belisle Making Information Systems People Friendly Since 1990 From:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com][mailto:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com]]On Behalf Ofjan johansen Sent:Tuesday, July 18, 2017 10:55 AM To:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] Subject:Re: [RBASE-L] - clicking too often One thing you can do is "disable" the object in the on-click eep., Like PROPERTY VariableListViewObject ENABLE FALSE -Original Message- From: Jim Belisle mailto:j...@kaypark.com]> To: "rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com]"; mailto:rbase-l@googlegroups.com]> Date: Tue, 18 Jul 2017 15:50:14 + Subject: [RBASE-L] - clicking too often In the past there was a thread about preventing more than one click because of users being so used to “double clicking”. I have looked in my saved lists and cannot seem to find it. Can anyone give me an idea of how to prevent this? We just installed my shop management system out in the shop and am concerned the employees will do the double clicking. I want my code to be a “security blanket” against corruption due to too many clicks. James Belisle Making Information Systems People Friendly Since 1990 -- 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 torbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visithttps://groups.google.com/d/optout [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 torbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visithttps://groups.google.com/d/optout [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
Re: [RBASE-L] - get the minimum and store it
INSERT INTO + mytable + SELECT distance, dlrnum, loczipcode, dlrzipcode + FROM myview -Original Message- From: Dan Goldberg To: "rbase-l@googlegroups.com" Date: Wed, 19 Jul 2017 21:38:16 + Subject: [RBASE-L] - get the minimum and store it I am drawing a blank. I have a view that has distance, dlrnum, loczipcode, dlrzipcode I want to extract the dlrnum, loczipcode, dlrzipcode from the view based on the minimum distance and store it in a table. What would be the code to store it in a table? TIA Dan Goldberg -- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
RE: [RBASE-L] - get the minimum and store it
...have you tried SELECT (MIN(distance))? -Original Message- From: Dan Goldberg To: "rbase-l@googlegroups.com" Date: Wed, 19 Jul 2017 21:52:27 + Subject: RE: [RBASE-L] - get the minimum and store it Thx. I need to get the minimum distance and dlrnum by loczipcode. That is the tricky part. Data example. Dlrnumdistance loczipcode Abc5 93535 Def2 93535 Dan From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Ofjan johansen Sent: Wednesday, July 19, 2017 2:50 PM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - get the minimum and store it INSERT INTO + mytable + SELECT distance, dlrnum, loczipcode, dlrzipcode + FROM myview -Original Message- From: Dan Goldberg mailto:d...@lancecamper.com]> To: "rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com]"; mailto:rbase-l@googlegroups.com]> Date: Wed, 19 Jul 2017 21:38:16 + Subject: [RBASE-L] - get the minimum and store it I am drawing a blank. I have a view that has distance, dlrnum, loczipcode, dlrzipcode I want to extract the dlrnum, loczipcode, dlrzipcode from the view based on the minimum distance and store it in a table. What would be the code to store it in a table? TIA Dan Goldberg -- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [RBASE-L] - Released: R:BASE X/XE (Version 10) - Add-on Products
Razzak, I know I am sight impaired, but I can't find the Ottero download. Jan -Original Message- From: "A. Razzak Memon" To: rbase-l@googlegroups.com Date: Mon, 31 Jul 2017 00:05:00 -0400 Subject: [RBASE-L] - Released: R:BASE X/XE (Version 10) - Add-on Products Monday, July 31, 2017 To All Users of R:BASE X and R:BASE X Enterprise Add-on Products: Updates are now available for the following add-on products for R:BASE X and R:BASE X Enterprise (Version 10): Build: 10.0.2.20731 - Update 2 . Oterro X/XE * . R:BASE Editor X . R:Docs X . R:Scope X/XE http://www.rbaseupdates.com [http://www.rbaseupdates.com/] http://www.rupdates.com [http://www.rupdates.com/] (Mirror Site) * Users of Oterro X and Oterro XE Enterprise (Version 10) may contact our dedicated support team at 1+724.733.0053, or e-mail mailto:supp...@rbase.com [mailto:support%40rbase.com] for the appropriate link(s) to download your add-on product(s). Very Best R:egards, Razzak. www.rbase.com [http://www.rbase.com/] www.facebook.com/rbase [http://www.facebook.com/rbase] -- 34 years of continuous innovation! 19 Years of R:BASE Technologies, Inc. making R:BASE what it is today! -- -- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l%2Bunsubscribe%40googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [RBASE-L] - Released: R:BASE X/XE (Version 10) - Add-on Products
Sorry, Since the other products were available at the update, it made it sound like Oterro should be there as well. Got the link. Thx. Jan -Original Message- From: "A. Razzak Memon" To: rbase-l@googlegroups.com Date: Wed, 02 Aug 2017 12:23:28 -0400 Subject: Re: [RBASE-L] - Released: R:BASE X/XE (Version 10) - Add-on Products Jan, Here is the entire paragraph that you missed. * Users of Oterro X and Oterro XE Enterprise (Version 10) may contact our dedicated support team at 1+724.733.0053, or e-mail mailto:supp...@rbase.com [mailto:support%40rbase.com] for the appropriate link(s) to download your add-on product(s). Razzak At 12:10 PM 8/2/2017, jan johansen wrote: >Razzak, > >I know I am sight impaired, but I can't find the Ottero download. > >Jan > >-Original Message- >From: "A. Razzak Memon" mailto:razzak%40rbase.com]> >To: rbase-l@googlegroups.com [mailto:rbase-l%40googlegroups.com] >Date: Mon, 31 Jul 2017 00:05:00 -0400 >Subject: [RBASE-L] - Released: R:BASE X/XE (Version 10) - Add-on Products > >Monday, July 31, 2017 > >To All Users of R:BASE X and R:BASE X Enterprise Add-on Products: > >Updates are now available for the following add-on products for >R:BASE X and R:BASE X Enterprise (Version 10): > >Build: 10.0.2.20731 - Update 2 > >. Oterro X/XE * >. R:BASE Editor X >. R:Docs X >. R:Scope X/XE > ><http://www.rbaseupdates.com [http://www.rbaseupdates.com/]>http://www.rbaseupdates.com [http://www.rbaseupdates.com/] >http://www.rupdates.com [http://www.rupdates.com/] (Mirror Site) > >* Users of Oterro X and Oterro XE Enterprise (Version 10) may contact >our dedicated support team at 1+724.733.0053, or e-mail >mailto:supp...@rbase.com [mailto:support%40rbase.com] for the appropriate link(s) to download >your add-on product(s). > >Very Best R:egards, > >Razzak. > ><http://www.rbase.com [http://www.rbase.com/]>www.rbase.com [http://www.rbase.com/] >www.facebook.com/rbase [http://www.facebook.com/rbase] >-- >34 years of continuous innovation! >19 Years of R:BASE Technologies, Inc. making R:BASE what it is today! >-- > >-- >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 ><mailto:rbase-l%2Bunsubscribe%40googlegroups.com>rbase-l+unsubscr...@googlegroups.com > [mailto:rbase-l%2Bunsubscribe%40googlegroups.com]. >For more options, visit ><https://groups.google.com/d/optout [https://groups.google.com/d/optout]>https://groups.google.com/d/optout [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 ><mailto:rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l%2Bunsubscribe%40googlegroups.com]>rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l%2Bunsubscribe%40googlegroups.com]. >For more options, visit ><https://groups.google.com/d/optout [https://groups.google.com/d/optout]>https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l%2Bunsubscribe%40googlegroups.com]. For more options, visit https://groups.google.com/d/optout [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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
RE: [RBASE-L] - Help with DBGrid search command - correction
Karen,
Why are you using a DB-Grid?
Seems you can you do want with Variable List View that you can keep the
focus on the row.
Jan
-Original Message-
From: Dan Goldberg
To: "rbase-l@googlegroups.com"
Date: Fri, 25 Aug 2017 16:57:35 +
Subject: RE: [RBASE-L] - Help with DBGrid search command - correction
Don’t know. I use the search command that looks the same as yours.
I use a similar code without any issues.
SET VAR vedate DATE = (.#DATE - 1)
SET VAR vesearch TEXT = ('PROPERTY TABLE orders99 SEARCH->onlinedate->'++
(CTXT (.#date)))
&vesearch
Dan Goldberg
From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com]
Sent: Friday, August 25, 2017 9:49 AM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Help with DBGrid search command - correction
Yes, vOldBLNo is a row that still exists. They are not allowed to change
the Primary Key BLNo field in the grid.
Originally I was using the form variable vBLNo which identifies the PK, but
found that the Close/Open command put the focus back on the first row and
changed the vBLNo variable. That's why I had to "save" the vBLNo of the row
they were on and search using that variable after the Close/Open!
Karen
-Original Message-
From: Dan Goldberg mailto:d...@lancecamper.com]>
To: rbase-l mailto:rbase-l@googlegroups.com]>
Sent: Fri, Aug 25, 2017 11:46 am
Subject: RE: [RBASE-L] - Help with DBGrid search command - correction
Does vOldBLNo exist in the grid? If it does not the search will not do
anything.
Dan Goldberg
From:karentellef via RBASE-L [mailto:rbase-l@googlegroups.com
[mailto:rbase-l@googlegroups.com?]]
Sent: Friday, August 25, 2017 9:14 AM
To: rbase-l@googlegroups.com [mailto:l...@googlegroups.com]
Subject: [RBASE-L] - Help with DBGrid search command - correction
A slight error in my message:
Using version X, 7/31 build.
I have a grid based on a view. Clicking in a column runs eep code that
updates the underlying data, does a CLOSE/OPEN of the grid's view.
Problem is that I lose the focus on the row the user was on. I thought that
the "search" command was the way to go. It traces fine, no errors, the
variable values look correct, but it doesn't change focus. Focus stays on
the first row of the refreshed grid. Can anyone find an error in my code,
or suggest a different way? I do not want to use "filter" commands because
I want all data to show up.
SET VAR vOldBLNo = .vBLNo
UPDATE salesdelwksheet SET po = .vPO WHERE blno = .vBLNo
PROPERTY TABLE vSalesDelWksheet2 'CLOSE'
PROPERTY TABLE vSalesDelWksheet2 'OPEN'
SET VAR vCommand = ('PROPERTY TABLE vSalesDelWksheet2 SEARCH->BLNo->' +
(CTXT(.vOldBLNo)) )
&vCommand
Thanks for the help!
Karen
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
[http://www.rbase.com/support/usersgroup_guidelines.php]
---
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 rbase-l+unsubscr...@googlegroups.com
[mailto:rbase-l+unsubscr...@googlegroups.com].
For more options, visit https://groups.google.com/d/optout
[https://groups.google.com/d/optout].
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
[http://www.rbase.com/support/usersgroup_guidelines.php]
---
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 rbase-l+unsubscr...@googlegroups.com
[mailto:rbase-l+unsubscr...@googlegroups.com].
For more options, visit https://groups.google.com/d/optout
[https://groups.google.com/d/optout].
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
[http://www.rbase.com/support/usersgroup_guidelines.php]
---
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 rbase-l+unsubscr...@googlegroups.com
[mailto:rbase-l+unsubscr...@googlegroups.com].
For more options, visit https://groups.google.com/d/optout
[https://groups.google.com/d/optout].
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
[http://www.rbase.com/support/usersgroup_guidelines.php]
---
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 rbase-l+unsubscr...@googlegroups.com
[mailto:rbase-l+unsubscr...@googlegroups.com].
For more options, visit https://groups.google.com/d/optout
[https://groups.google.com/d/optout].
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving email
Re: [RBASE-L] - Tip of the Day: Group Font/Color Changes for List View Headers and Columns
Very nice! -Original Message- From: "A. Razzak Memon" To: rbase-l@googlegroups.com Date: Mon, 18 Sep 2017 09:00:10 -0400 Subject: [RBASE-L] - Tip of the Day: Group Font/Color Changes for List View Headers and Columns Monday, September 18, 2017 Tip of the Day: Group Font/Color Changes for List View Headers and Columns Product...: R:BASE X and R:BASE X Enterprise (Version 10) Build.: 10.0.3.10907 or higher Section...: Form Designer Keywords..: List View, Header, Column, Font, Color Did you know that the font and color for List View headers and columns can be changed for a group of selected columns? New to the Variable List View and DB List View property editors is the ability to highlight several items and modify the color and font simultaneously. http://www.razzak.com/tips/VarLookupListView_Columns_Multi.jpg [http://www.razzak.com/tips/VarLookupListView_Columns_Multi.jpg] Users with many "column items" and scores of List View controls in their forms will appreciate this added timesaving ability. One of the most important aspects in business growth is your company's data, and no one else has more invested in your success than R:BASE Technologies. Invest forward with R:BASE! Very Best R:egards, Razzak. www.rbase.com [http://www.rbase.com/] www.facebook.com/rbase [http://www.facebook.com/rbase] -- 34 years of continuous innovation! 19 Years of R:BASE Technologies, Inc. making R:BASE what it is today! -- -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php [http://www.rbase.com/support/usersgroup_guidelines.php] --- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l%2Bunsubscribe%40googlegroups.com]. For more options, visit https://groups.google.com/d/optout [https://groups.google.com/d/optout]. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- 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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
[RBASE-L] - DELETE syntax
Group, Looking for a little help here. So I'm trying to update some code that deals with a UNC connection. The code deletes a file. So if I map a drive, the code works i.e. DELETE Z:\deletethisfile.pdf However using an UNC drive throws a syntax error 2045 DELETE \\deletethisfile.pdf I want to use the UNC but how do I overcome the error. Thx in advance. Jan -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- 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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [RBASE-L] - DELETE syntax
I need to correct something Should look like this \\myuncdrive\deletethisfile.pdf -Original Message- From: "jan johansen" To: rbase-l@googlegroups.com Date: Fri, 29 Sep 2017 14:26:12 -0700 Subject: [RBASE-L] - DELETE syntax Group, Looking for a little help here. So I'm trying to update some code that deals with a UNC connection. The code deletes a file. So if I map a drive, the code works i.e. DELETE Z:\deletethisfile.pdf However using an UNC drive throws a syntax error 2045 DELETE \\deletethisfile.pdf I want to use the UNC but how do I overcome the error. Thx in advance. Jan -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php [http://www.rbase.com/support/usersgroup_guidelines.php] --- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [https://groups.google.com/d/optout]. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- 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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
RE: [RBASE-L] - DELETE syntax
Brad/Claudine, Thx. Interestingly I had been using an & variable in the past and it worked. Turns out, I know need the . variable. That being said, the & variable is what's working for Brad. I'm too tired to think about this. I'll try again after the weekend. Jan -Original Message- From: Claudine Robbins To: "rbase-l@googlegroups.com" Date: Fri, 29 Sep 2017 21:45:47 + Subject: RE: [RBASE-L] - DELETE syntax Jan, Have you tried: Set var vfiletodelete = ‘\\myuncdrive\deletethisfile.pdf [file:/myuncdrive/deletethisfile.pdf]’ Delete .vfiletodelete Claudine From:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Ofjan johansen Sent: Friday, September 29, 2017 4:33 PM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - DELETE syntax I need to correct something Should look like this \\myuncdrive\deletethisfile.pdf [file:/myuncdrive/deletethisfile.pdf] -----Original Message- From: "jan johansen" mailto:j...@jjcalibrations.com]> To: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] Date: Fri, 29 Sep 2017 14:26:12 -0700 Subject: [RBASE-L] - DELETE syntax Group, Looking for a little help here. So I'm trying to update some code that deals with a UNC connection. The code deletes a file. So if I map a drive, the code works i.e. DELETE Z:\deletethisfile.pdf However using an UNC drive throws a syntax error 2045 DELETE \\deletethisfile.pdf [file:/deletethisfile.pdf] I want to use the UNC but how do I overcome the error. Thx in advance. Jan -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php [http://www.rbase.com/support/usersgroup_guidelines.php] --- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [https://groups.google.com/d/optout]. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php [http://www.rbase.com/support/usersgroup_guidelines.php] --- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [https://groups.google.com/d/optout]. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php [http://www.rbase.com/support/usersgroup_guidelines.php] --- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [https://groups.google.com/d/optout]. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- 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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
[RBASE-L] - PAUSE
Group, I believe this has been asked before and I think the answer is NO. Can the CLOSE (X) be disabled on a PAUSE? I think it's no because it's a windows thing. I'm finding weirdnesses in my system because I think users are closing the PAUSE before I issue the CLS. Thank you, Jan -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- 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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
[RBASE-L] - query
Group, I need to query a table looking for non-whole dollars i.e. $71.25 $102.50 etc TIA, Jan -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- 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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
RE: [RBASE-L] - query
That works well. -Original Message- From: Stephen Markson To: "rbase-l@googlegroups.com" Date: Thu, 7 Dec 2017 20:46:36 + Subject: RE: [RBASE-L] - query How about: …WHERE Amount<>INT(Amount)? Regards, Stephen Markson The Pharmacy Examining Board of Canada 416.979.2431 x251 From:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Ofjan johansen Sent: December-07-17 3:41 PM To: rbase-l@googlegroups.com Subject: [RBASE-L] - query Group, I need to query a table looking for non-whole dollars i.e. $71.25 $102.50 etc TIA, Jan -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php [http://www.rbase.com/support/usersgroup_guidelines.php] --- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [https://groups.google.com/d/optout]. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php [http://www.rbase.com/support/usersgroup_guidelines.php] --- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [https://groups.google.com/d/optout]. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- 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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [RBASE-L] - Android App
Retire?? You can't retire! -Original Message- From: Bill Downall To: rbase-l@googlegroups.com Date: Mon, 11 Dec 2017 19:25:23 -0500 Subject: Re: [RBASE-L] - Android App Fantastic! If I weren't retiring in 20 days, I'd be asking for details. Thanks, Tommy of "Tommy and the Sworbugs." Happy holidays. Bill (sent from Moto Z) On Dec 11, 2017 7:16 PM, "THOMAS CIMICATO" mailto:t...@securemailgateway.net]> wrote: I just want to brag here and see if anybody else has used RBase this way My 18 year old autistic son just wrote an Android App using App Inventor that will connect to our RBaseX Database hosted on a Win2012 Cloud Server via a HTTPS POST to a PHP script (which he also wrote) using ODBC/SQL that will submit a financial transaction that triggers a complex stored procedure to approve or decline the transaction. His Android app then displays the approval or decline result to the app user on their smartphone. How cool is that?? Thom -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php [http://www.rbase.com/support/usersgroup_guidelines.php] --- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l%2bunsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [https://groups.google.com/d/optout]. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php [http://www.rbase.com/support/usersgroup_guidelines.php] --- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [https://groups.google.com/d/optout]. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- 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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [RBASE-L] - copying images
Karen, As a pilot, I can tell you that flying a plane is easy. It's landing that takes all the training! :) Jan -Original Message- From: karentellef via RBASE-L To: rbase-l@googlegroups.com Date: Thu, 14 Dec 2017 12:40:23 -0500 Subject: Re: [RBASE-L] - copying images Lots to learn! It's easier to ride a bike than fly a plane! Karen -Original Message- From: Randy Larsen To: rbase-l Sent: Thu, Dec 14, 2017 11:26 am Subject: Re: [RBASE-L] - copying images Thank you Karen :) there’s a lot to learn about this application.. Cheers, -Randy If you want to go fast, go alone. If you want to go far, go together. -African proverb On Dec 14, 2017, at 12:08 PM, karentellef via RBASE-L mailto:rbase-l@googlegroups.com]> wrote: Hi Randy!I usually have a report called DEFAULTS. On that report I have located all kinds of misc things, like page footers that I put at the bottom of each page, or page styles or letterhead-type of addresses, etc. If there's DB fields that are in alot of reports and I always forget how wide the field should be (like a CustomerPart TEXT 20 field), I will put that control in my DEFAULTS report with the proper width for every font type/size I might use (I base my DEFAULTS report on the most commonly used table, or will have a report named with the table, like DefaultsCustPart, so I can locate DBEdits). All controls can be copy/paste into other reports. So yes, go ahead and define your section in your report and when you have it right you can copy/paste it to another report. It's easy if the other report is based on the same table. But if it isn't, you can still copy your controls. You would just have to click on every control you pasted and then assign the proper table/column Karen -Original Message- From: Randy Larsen mailto:thelars...@gmail.com]> To: rbase-l mailto:rbase-l@googlegroups.com]> Sent: Thu, Dec 14, 2017 10:47 am Subject: Re: [RBASE-L] - copying images Sorry, i wasn’t clear.. the table i’m referring is not a db table, but a table printed in the form..essentially a “reusable" section of the report. So basically is there a way to create a reusable section, that is populated with data that could be shared amount many reports HTH Cheers, -Randy If you want to go fast, go alone. If you want to go far, go together. -African proverb On Dec 14, 2017, at 11:17 AM, Buddy Walker mailto:walker.bu...@comcast.net]> wrote: Randy If the “similar” is populated based on the user I would make the “similar” a temporary table. With that the report would print based on that table with data for that user. By the way other users would not see that table (since it is dropped when user exits R:Base). Buddy Sent from my iPhone On Dec 14, 2017, at 10:56 AM, Randy Larsen mailto:thelars...@gmail.com]> wrote: Hi Everyone, I’m also new to Rbase and I’m new to this group.. and very happy to see that you are so active! I have a question about Reports as well. I have number of reports that all share a similar table. I was wondering if it is possible to create a report or sub report that can be shared/included b/n multiple reports? Thank you! -Randy If you want to go fast, go alone. If you want to go far, go together. -African proverb On Dec 14, 2017, at 10:49 AM, Chaya Goldberg mailto:cgoldb...@omnirehab.com]> wrote: Thanks for your suggestion, Albert. It gave me an idea. I actually did use a sub report initially, but it has the same issue. However perhaps I can use separate sub reports for the two images, in order to eliminate the need for the UPDATE statement. Thanks, Chaya -Original Message- From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] [mailto:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com]] On Behalf Of Albert Berry Sent: Wednesday, December 13, 2017 3:51 PM To: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] Subject: Re: [RBASE-L] - copying images Would it perhaps be easier to use a sub report for the images rather than updating the main table? Sub reports work quite will in R:Base Albert On Dec 13, 2017, at 1:33 PM, Chaya Goldberg mailto:cgoldb...@omnirehab.com]> wrote: Hi Everyone, I’m writing a report which needs to have two or three images on it in a certain order. I get these images by querying our database. The queried images first get saved to separate temporary tables (one of which will become the “main” table), then get collected into the main table using an UPDATE statement. I then print the report off of this main table. The problem is that the results are inconsistent. Sometimes it works and the images print as they’re supposed to,
RE: [RBASE-L] - Form Compression
I no longer use form compression but used to. I don't know for sure and I thought I heard this from Razzak. Windows MAY see the process of un-compressing a form as something malevolent. -Original Message- From: "Richardson, Jeff" To: "rbase-l@googlegroups.com" Date: Fri, 15 Dec 2017 14:22:20 + Subject: RE: [RBASE-L] - Form Compression Thank you both for the answers. I perceive no lag time with the compressed form versus the uncompressed form, but since storage is not an issue, I will take every millisecond I can get. Thanks again. From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com] Sent: Friday, December 15, 2017 9:02 AM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - Form Compression In addition to the milliseconds that Razzak mentions: At one time if a form was compressed you could not search for words in the form. Now, the "find" database explorer function will work against a compressed form (not sure what version it started working that way, so test it with your version). But if you do it the old fashioned way (select all from sys_forms3 where #4 contains 'value') it will not work on a compressed form. Karen -Original Message- From: Richardson, Jeff mailto:jrich...@dmainc.com]> To: rbase-l mailto:rbase-l@googlegroups.com]> Sent: Fri, Dec 15, 2017 5:47 am Subject: [RBASE-L] - Form Compression Basic question: I understand that “Compress Form” is used to minimize space. What is the disadvantage? Why would you not compress a form? Thanks! Jeff Richardson | Project Manager, Asset Verification Services (AVS) DMA – DuCharme, McMillen & Associates, Inc. | 828 S Harrison Street Suite 650, Fort Wayne, IN 46802 Cell: 724-366-1724 Connect: jrichard...@dmainc.com [mailto:jrichard...@dmainc.com]|Website [http://www.dmainc.com/]|LinkedIn [https://www.linkedin.com/company/ducharme-mcmillen-&-associates]|Twitter [https://twitter.com/DMATAX]|Facebook [https://www.facebook.com/DMAtaxservices] ___ ATTENTION:This message and all attachments are PRIVATE, and may contain information that is CONFIDENTIAL and PRIVILEGED. If you have received this message in error, please notify the sender by reply e-mail and delete the message immediately. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php [http://www.rbase.com/support/usersgroup_guidelines.php] --- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [https://groups.google.com/d/optout]. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php [http://www.rbase.com/support/usersgroup_guidelines.php] --- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [https://groups.google.com/d/optout]. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php [http://www.rbase.com/support/usersgroup_guidelines.php] --- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [https://groups.google.com/d/optout]. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- 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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
RE: [RBASE-L] - Suppressing main R:Base screen
David, I believe you are going to need to choose the form you want to land on. Something like CONNECT custmr PROPERTY APPLICATION TITLE 'Dispatch' EDIT USING dispatchedjobs WHERE status='d' SORTED BY jobdate tin operator MDI AS dispatchwindow CAPTION 'DISPATCHED JOBS' EDIT USING pendingjobs WHERE status='p' SORTED BY jobdate street AS pendingwindow CAPTION 'PENDING JOBS' RETURN Then put a way to exit the form 'pendingjobs' that closes dispatchedjobs as well. This should open 'dispatchedjobs' as an MDI and stop on the form 'pendingjobs'. Your main menu will probably still be in the background. Remember that when using MDI, the code calling it continues to run. That is why the main menu pops up. Your code is telling it to return. Jan -Original Message- From: "Paul C. Buckley" To: Date: Mon, 18 Dec 2017 14:13:26 -0500 Subject: RE: [RBASE-L] - Suppressing main R:Base screen David, Try moving the second Edit Using pendingjobs ... into the first form, dispatchjobs as an On After Start EEP. Good luck, Paul Buckley -Original Message- From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of DAVID FOWLER Sent: December 18, 2017 12:14 PM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - Suppressing main R:Base screen Razzak, Thank you for the quick answer. What you suggest is what I have done. The only difference is that the second for I open is also MDI. If I open the second without it being MDI, I can't move back and forth between the two forms, I can only access the second form that is opened. Here's the code from the app that opens the forms. CONNECT custmr PROPERTY APPLICATION TITLE 'Dispatch' EDIT USING dispatchedjobs WHERE status='d' SORTED BY jobdate tin operator + MDI AS dispatchwindow CAPTION 'DISPATCHED JOBS' EDIT USING pendingjobs WHERE status='p' SORTED BY jobdate street + MDI AS pendingwindow CAPTION 'PENDING JOBS' RETURN Thanks for any other ideas. David Fowler > On December 18, 2017 at 10:12 AM "A. Razzak Memon" wrote: > > > David, > > Here is a very simple approach ... > > 01. Create a command file, such as, MyApplication.DAT, that include > all your database CONNECT statement and then EDIT USING formname , etc. > -- Example > -- MyApplication.DAT > CONNECT dbname > CLS > EDIT USING formname1 MDI > EDIT USING formname2 > RETURN > > 02. Create application shortcut as follows: > -- Example > Target: C:\RBTI\RBGX\RBGX.EXE MyApplication.DAT > Start in: C:\Databases\ > > 03. Double-clicking on the shortcut will launch RBGX.exe with all your > statements in the MyApplication.DAT file. > > 04. You may also RUN MyApplication.DAT at the R> Prompt or from the > Database Explorer > Command Files as well. > > That should provide you with the outcome you are looking for. > > Hope that helps! > > Very Best R:egards, > > Razzak > > > > At 09:41 AM 12/18/2017, dkfowler6179 wrote: > > >I've got an app that opens two forms as MDI. That part works, but > >after the forms open, the main R:Base screen (database explorer, > >editor, etc. Opens over top of the forms. I can minimize that window > >and hide it behind the forms and use them but would like to suppress > >the window from opening at all. I'm probably missing something easy, > >but haven't been able to figure it out. > > > >Thanks for any help. > > > >David Fowler > >Roto-Rooter > > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > --- > 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 rbase-l+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- 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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- 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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- 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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
RE: [RBASE-L] - Suppressing main R:Base screen
David, I know what want to do is possible. I do know that for a client I created what you are trying to do. But I also believe I made copies of the 2 forms I wanted to use as I needed to make some changes to the MDI calls that would not be applicable if calling either of the original forms individually. Hope that makes sense. Jan -Original Message- From: dkfowler6179 To: RBASE-L Date: Mon, 18 Dec 2017 13:54:03 -0800 (PST) Subject: RE: [RBASE-L] - Suppressing main R:Base screen Jan, Thanks for the idea. I've tried several versions of this (and now your version). Each time, as soon as the second form is not MDI it makes it so that I cannot use/make entries in the MDI form as the focus remains on the non MDI form until it is closed. David -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php [http://www.rbase.com/support/usersgroup_guidelines.php] --- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l%2Bunsubscribe%40googlegroups.com]. For more options, visit https://groups.google.com/d/optout [https://groups.google.com/d/optout]. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- 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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
RE: [RBASE-L] - Suppressing main R:Base screen
David, I believe that you need to determine which form will your primary form. Call it using the MDI option. In the On After Start eep of the primary form, you need to call the second form using the MDI option. On the primary form include a close option that will close both forms on exit. Jan -Original Message- From: "jan johansen" To: rbase-l@googlegroups.com Date: Tue, 19 Dec 2017 08:54:43 -0800 Subject: RE: [RBASE-L] - Suppressing main R:Base screen David, I know what want to do is possible. I do know that for a client I created what you are trying to do. But I also believe I made copies of the 2 forms I wanted to use as I needed to make some changes to the MDI calls that would not be applicable if calling either of the original forms individually. Hope that makes sense. Jan -Original Message- From: dkfowler6179 To: RBASE-L Date: Mon, 18 Dec 2017 13:54:03 -0800 (PST) Subject: RE: [RBASE-L] - Suppressing main R:Base screen Jan, Thanks for the idea. I've tried several versions of this (and now your version). Each time, as soon as the second form is not MDI it makes it so that I cannot use/make entries in the MDI form as the focus remains on the non MDI form until it is closed. David -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php [http://www.rbase.com/support/usersgroup_guidelines.php] --- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l%2Bunsubscribe%40googlegroups.com]. For more options, visit https://groups.google.com/d/optout [https://groups.google.com/d/optout]. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php [http://www.rbase.com/support/usersgroup_guidelines.php] --- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [https://groups.google.com/d/optout]. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- 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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
RE: [RBASE-L] - table with dates and date calculations
Chaya, You can use SELECT INTO from your driving table and it will populate your TEMP table without a cursor. Jan -Original Message- From: Chaya Goldberg To: "rbase-l@googlegroups.com" Date: Fri, 22 Dec 2017 18:14:29 + Subject: RE: [RBASE-L] - table with dates and date calculations Another question. Is there a way to create the original list of dates without using a loop? Thanks. Chaya From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf OfChaya Goldberg Sent: Friday, December 22, 2017 1:08 PM To: rbase-l@googlegroups.com Subject: RE: [RBASE-L] - table with dates and date calculations Thanks, Buddy. That’s actually exactly what I was doing, but was getting nowhere. Looking at your code now, perhaps my syntax was a little off… (Although I did not get any error messages). Anyway, will try again. Thanks. From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] [mailto:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com]] On Behalf OfBuddy Walker Sent: Friday, December 22, 2017 1:03 PM To: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] Subject: RE: [RBASE-L] - table with dates and date calculations Chaya Take a look at functions for Date I did a temp table structure to get you started. Buddy CREATE TEMPORARY TABLE `TmpDates` + (`YourDateHere` DATE, + `YourDayOfWeek` = (TDWK(YourDateHere)) TEXT (25), + `YourMonthHere` = (TMON(YourDateHere)) TEXT (25)) From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] [mailto:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com]] On Behalf OfChaya Goldberg Sent: Friday, December 22, 2017 12:43 PM To: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] Subject: [RBASE-L] - table with dates and date calculations Hi Everyone, I’m trying to create a (temporary) table in which the first column will hold all the date values between two given dates (for ex: 9/1/2017, 9/2/2017….8/31/2018), and subsequent columns will hold calculations on this date column (such as dayOfWeek, or the month of the date). Seems like it should be simple, but I’m having a lot of trouble with this. Any advice would be appreciated. Thanks. Chaya -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php [http://www.rbase.com/support/usersgroup_guidelines.php] --- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [https://groups.google.com/d/optout]. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php [http://www.rbase.com/support/usersgroup_guidelines.php] --- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [https://groups.google.com/d/optout]. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php [http://www.rbase.com/support/usersgroup_guidelines.php] --- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [https://groups.google.com/d/optout]. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php [http://www.rbase.com/support/usersgroup_guidelines.php] --- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [https://groups.google.com/d/optout]. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- 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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
RE: [RBASE-L] - One last question, if possible
Are you using Windows 10? You may need to change the file attributes that you wish to see in the folder. There are several dates available. -Original Message- From: "Cathy Grimes" To: Date: Sun, 31 Dec 2017 09:52:49 -0800 Subject: RE: [RBASE-L] - One last question, if possible Thank you, Albert. The date and time does not change no matter what I do, or when I make any changes. The file sizes not changing is what concerns me most. I have not been creating new databases or tables, but regularly edit the data and create and/or edit reports….but still no file size change (or date change) at all. Hopefully, since I don’t seem to be losing my changed data, the static file sizes are not affecting the integrity of the database. But it would really ease my mind if I could find out how to fix it. Cathy From:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf OfAlbert Berry Sent: Sunday, December 31, 2017 9:33 AM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - One last question, if possible The date/time is last connection time, not the time you disconnected, I think. I don’t think you need to change the dates. When you disconnect and reconnect, the date/time will be updated to the time of connection. File sizes, on the other hand, should change as you manipulate the data and the database files are saved. Albert On Dec 31, 2017, at 9:20 AM, Cathy Grimes mailto:cfgri...@verizon.net]> wrote: Thank you, Buddy, for taking the time to respond. I am the only user so no one else in the database ever. I’m not sure what you mean by R:Base possibly considering the database as being out of sync, but I’ve had no problems accessing the database, making changes, etc., then having the changes (ones I’ve checked) still there after I’ve exited, updated the dates, then re-accessed. I do check my back-up drive periodically to make sure that all 4 of the data files are copied after I’ve forced a date change. Because I do manually update the dates and copy the files every couple of days, that should accomplish the same end result as your schedule task suggestion – it just takes me a few seconds each time (even if it is annoying to have to do this). That is a good thing, because I would have no idea how to create a schedule task. My tech guy set up Acronic True Image in the separate back-up hard drive, and I have periodically have problems with that working properly. I guess I just wanted to be assured that my database is still ok with my manual updating, especially since the file sizes do not change at all when I update them. Cathy From:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] [mailto:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com]]On Behalf OfBuddy Walker Sent:Sunday, December 31, 2017 7:56 AM To:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] Subject:RE: [RBASE-L] - One last question, if possible Cathy I believe the date will change when everyone is disconnected from the database. Also I would be careful about forcing a new date because R:Base may see this as the database being out of SYNC. The auto backup looking at dates may not backup up all 4 database rx files. I would suggest using something like a schedule task that would start R:Base and then copy all 4 files to a backup area. I did this in the past. I would copy the database files at noon (limited activity) and then at 5:00pm and then the normal daily backup at 11:00pm Buddy From:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com][mailto:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com]]On Behalf OfCathy Grimes Sent:Sunday, December 31, 2017 10:10 AM To:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] Subject:[RBASE-L] - One last question, if possible I hope it’s ok if I ask one more question that has been driving me crazy (as an end user, also the buyer of R:Base). I was so happy to have my only other main R:Base problem fixed by Razzak so quickly and easily. When I last upgraded to R:Base Extreme 9.5(32), the file Attributes suddenly stopped changing, i.e., the date modified never changes, and RB1 through RB4 never changes size (no matter how many rows I add or changes I make). Because I have auto back-up drive that backs up changes only, it will not back-up my R:Base data files unless I do it manually. I found a program that will automatically update the date changes to current (if I mark and select those each time), but it does NOT change the size of any of the RB1 through RB4 files. My data always seems to be there, but I’m worried that the file sizes are static. Thank you. Cathy -- For group guidelines, visithttp://www.rbase.com/support/usersgroup_guidelines.php [http://www.rbase.com/support/usersgroup_guidelines.php] --- 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 emai
RE: [RBASE-L] - One last question, if possible
Open the folder and check thusly -Original Message- From: "jan johansen" To: rbase-l@googlegroups.com Date: Sun, 31 Dec 2017 11:18:16 -0800 Subject: RE: [RBASE-L] - One last question, if possible Are you using Windows 10? You may need to change the file attributes that you wish to see in the folder. There are several dates available. -Original Message- From: "Cathy Grimes" To: Date: Sun, 31 Dec 2017 09:52:49 -0800 Subject: RE: [RBASE-L] - One last question, if possible Thank you, Albert. The date and time does not change no matter what I do, or when I make any changes. The file sizes not changing is what concerns me most. I have not been creating new databases or tables, but regularly edit the data and create and/or edit reports….but still no file size change (or date change) at all. Hopefully, since I don’t seem to be losing my changed data, the static file sizes are not affecting the integrity of the database. But it would really ease my mind if I could find out how to fix it. Cathy From:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf OfAlbert Berry Sent: Sunday, December 31, 2017 9:33 AM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - One last question, if possible The date/time is last connection time, not the time you disconnected, I think. I don’t think you need to change the dates. When you disconnect and reconnect, the date/time will be updated to the time of connection. File sizes, on the other hand, should change as you manipulate the data and the database files are saved. Albert On Dec 31, 2017, at 9:20 AM, Cathy Grimes mailto:cfgri...@verizon.net]> wrote: Thank you, Buddy, for taking the time to respond. I am the only user so no one else in the database ever. I’m not sure what you mean by R:Base possibly considering the database as being out of sync, but I’ve had no problems accessing the database, making changes, etc., then having the changes (ones I’ve checked) still there after I’ve exited, updated the dates, then re-accessed. I do check my back-up drive periodically to make sure that all 4 of the data files are copied after I’ve forced a date change. Because I do manually update the dates and copy the files every couple of days, that should accomplish the same end result as your schedule task suggestion – it just takes me a few seconds each time (even if it is annoying to have to do this). That is a good thing, because I would have no idea how to create a schedule task. My tech guy set up Acronic True Image in the separate back-up hard drive, and I have periodically have problems with that working properly. I guess I just wanted to be assured that my database is still ok with my manual updating, especially since the file sizes do not change at all when I update them. Cathy From:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] [mailto:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com]]On Behalf OfBuddy Walker Sent:Sunday, December 31, 2017 7:56 AM To:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] Subject:RE: [RBASE-L] - One last question, if possible Cathy I believe the date will change when everyone is disconnected from the database. Also I would be careful about forcing a new date because R:Base may see this as the database being out of SYNC. The auto backup looking at dates may not backup up all 4 database rx files. I would suggest using something like a schedule task that would start R:Base and then copy all 4 files to a backup area. I did this in the past. I would copy the database files at noon (limited activity) and then at 5:00pm and then the normal daily backup at 11:00pm Buddy From:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com][mailto:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com]]On Behalf OfCathy Grimes Sent:Sunday, December 31, 2017 10:10 AM To:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] Subject:[RBASE-L] - One last question, if possible I hope it’s ok if I ask one more question that has been driving me crazy (as an end user, also the buyer of R:Base). I was so happy to have my only other main R:Base problem fixed by Razzak so quickly and easily. When I last upgraded to R:Base Extreme 9.5(32), the file Attributes suddenly stopped changing, i.e., the date modified never changes, and RB1 through RB4 never changes size (no matter how many rows I add or changes I make). Because I have auto back-up drive that backs up changes only, it will not back-up my R:Base data files unless I do it manually. I found a program that will automatically update the date changes to current (if I mark and select those each time), but it does NOT change the size of any of the RB1 through RB4 files. My data always seems to be there, but I’m worried that the file sizes are static. Thank you. Cathy -- For group guidelines, visithttp://www.rbase.com/support/usersgroup_guidelines.php
Re: [RBASE-L] - One last question, if possible
... except version 9.5 should be *.RX? -Original Message- From: Larry Wilson To: rbase-l@googlegroups.com Date: Sun, 31 Dec 2017 17:06:24 -0500 Subject: Re: [RBASE-L] - One last question, if possible Cathy, IF you really want to confirm date, time and file size changes here is a sure method. Make certain that you have a current backup of your database. #1 - exit to the R> prompt #2 - R> dir *.RB? make not fo the date. time and file sizes #3 - R> Disconnect #4 - R> Set Multi Off #5 - R> Pack #6 - R> Dir *.RB? make note of the date, time and file sizes - they should have changed Reconnect to your database Hope this helps and gives you comfort. Larry Larry Wilson President & CEO Promesa Consulting Group, Inc. 1727 N Street NW, Suite 400 Washington, DC 20036 202-808-8836 (O) 202-733-7006 (C) 202-808-8837 (F) On Sun, Dec 31, 2017 at 12:52 PM, Cathy Grimes mailto:cfgri...@verizon.net]> wrote: Thank you, Albert. The date and time does not change no matter what I do, or when I make any changes. The file sizes not changing is what concerns me most. I have not been creating new databases or tables, but regularly edit the data and create and/or edit reports….but still no file size change (or date change) at all. Hopefully, since I don’t seem to be losing my changed data, the static file sizes are not affecting the integrity of the database. But it would really ease my mind if I could find out how to fix it. Cathy From:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] [mailto:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com]] On Behalf OfAlbert Berry Sent: Sunday, December 31, 2017 9:33 AM To: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] Subject: Re: [RBASE-L] - One last question, if possible The date/time is last connection time, not the time you disconnected, I think. I don’t think you need to change the dates. When you disconnect and reconnect, the date/time will be updated to the time of connection. File sizes, on the other hand, should change as you manipulate the data and the database files are saved. Albert On Dec 31, 2017, at 9:20 AM, Cathy Grimes mailto:cfgri...@verizon.net]> wrote: Thank you, Buddy, for taking the time to respond. I am the only user so no one else in the database ever. I’m not sure what you mean by R:Base possibly considering the database as being out of sync, but I’ve had no problems accessing the database, making changes, etc., then having the changes (ones I’ve checked) still there after I’ve exited, updated the dates, then re-accessed. I do check my back-up drive periodically to make sure that all 4 of the data files are copied after I’ve forced a date change. Because I do manually update the dates and copy the files every couple of days, that should accomplish the same end result as your schedule task suggestion – it just takes me a few seconds each time (even if it is annoying to have to do this). That is a good thing, because I would have no idea how to create a schedule task. My tech guy set up Acronic True Image in the separate back-up hard drive, and I have periodically have problems with that working properly. I guess I just wanted to be assured that my database is still ok with my manual updating, especially since the file sizes do not change at all when I update them. Cathy From:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] [mailto:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com]]On Behalf OfBuddy Walker Sent:Sunday, December 31, 2017 7:56 AM To:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] Subject:RE: [RBASE-L] - One last question, if possible Cathy I believe the date will change when everyone is disconnected from the database. Also I would be careful about forcing a new date because R:Base may see this as the database being out of SYNC. The auto backup looking at dates may not backup up all 4 database rx files. I would suggest using something like a schedule task that would start R:Base and then copy all 4 files to a backup area. I did this in the past. I would copy the database files at noon (limited activity) and then at 5:00pm and then the normal daily backup at 11:00pm Buddy From:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com][mailto:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com]]On Behalf OfCathy Grimes Sent:Sunday, December 31, 2017 10:10 AM To:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] Subject:[RBASE-L] - One last question, if possible I hope it’s ok if I ask one more question that has been driving me crazy (as an end user, also the buyer of R:Base). I was so happy to have my only other main R:Base problem fixed by Razzak so quickly and easily. When I last upgraded to R:Base Extreme 9.5(32), the file Attributes suddenly stopped changing, i.e., the date modified never changes, and RB1 through RB4 never changes size (no matter how many rows I add or changes I make). Because I have
Re: [RBASE-L] - [Business Web Applications using Java]
All, If you are interested in looking at a Java site that works with Oterro into our RBaseX database, goto www.jjcalibrations.com/equipmgr/ Use the following to login; guest jjguest We had Raffee convert our PHP application. Hope this helps. Jan -Original Message- From: "A. Razzak Memon" To: rbase-l@googlegroups.com Date: Thu, 04 Jan 2018 21:42:31 -0500 Subject: Re: [RBASE-L] - [Business Web Applications using Java] If anyone is planning to develop and deploy robust and secure web applications/portals, they should look into using Java. In 2017, we have switched all our corporate clients and their mission critical business applications and web portals to Java running on MS Windows Server 2012R2 and 2016. In doing so, the latest versions and updates of Oterro XE (Version 10, Version 10.5) are made fully compatible with Java. Java is by far the most robust and secure environment. It has become a preferred choice for developing web applications for a cross platform approach. Since Java works on most leading Operating Systems, it is used in a wide range of platforms from desktops to mobile devices. Our own R:BASE Updates portal https://www.rbaseupdates.com [https://www.rbaseupdates.com/] is a great example of our showcase. If anyone is interested in seeing business applications and customer web portals using R:BASE XE, Oterro XE, and Java running on MS Windows Server 2012R2 and Server 2016, please contact R:BASE Technologies' Services Division at mailto:servi...@rbase.com [mailto:services%40rbase.com]. Very Best R:egards, Razzak At 04:44 PM 1/4/2018, Jim Belisle wrote: >We are looking into having our customers be able to order product >directly into RBASE >from the web. They of course would fill out a form, create a user >name and password >and be able to order. This would also give the ability for them to >print certain >reports showing what they ordered. >Anyone out there use a specific software that you have found helpful >in this case? > >You can send directly to my email if you want. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php [http://www.rbase.com/support/usersgroup_guidelines.php] --- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l%2Bunsubscribe%40googlegroups.com]. For more options, visit https://groups.google.com/d/optout [https://groups.google.com/d/optout]. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- 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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
RE: [RBASE-L] - [Business Web Applications using Java]
Believe it or not, this is just a continuation of what we were allowing our customers to do in the early 90's using Rbase 4.1 I believe. Using a 300 baud modem! The good old days. You just need to identify what would be helpful to your customers and provide an easy way to access it. We query our customers every 6mo asking what we can do to improve. Sometimes they offer suggestions that we just have to say no to, but it never hurts to try. Like Dan, we used CodeCharge to move up to PHP and then we used Raffee to upgrade to Java. Jan -Original Message- From: "Steve Johnson" To: Date: Sun, 7 Jan 2018 20:54:23 -0500 Subject: RE: [RBASE-L] - [Business Web Applications using Java] Jan, Thanks for allowing us to visit the site, cool. Perhaps there are some, including myself, that would like to explore web based applications, is there any information out there on how all this is put together? Steve J From:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Ofjan johansen Sent: Friday, January 05, 2018 12:38 PM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - [Business Web Applications using Java] All, If you are interested in looking at a Java site that works with Oterro into our RBaseX database, goto www.jjcalibrations.com/equipmgr/ [http://www.jjcalibrations.com/equipmgr/] Use the following to login; guest jjguest We had Raffee convert our PHP application. Hope this helps. Jan -Original Message- From: "A. Razzak Memon" To: rbase-l@googlegroups.com Date: Thu, 04 Jan 2018 21:42:31 -0500 Subject: Re: [RBASE-L] - [Business Web Applications using Java] If anyone is planning to develop and deploy robust and secure web applications/portals, they should look into using Java. In 2017, we have switched all our corporate clients and their mission critical business applications and web portals to Java running on MS Windows Server 2012R2 and 2016. In doing so, the latest versions and updates of Oterro XE (Version 10, Version 10.5) are made fully compatible with Java. Java is by far the most robust and secure environment. It has become a preferred choice for developing web applications for a cross platform approach. Since Java works on most leading Operating Systems, it is used in a wide range of platforms from desktops to mobile devices. Our own R:BASE Updates portal https://www.rbaseupdates.com [https://www.rbaseupdates.com/] is a great example of our showcase. If anyone is interested in seeing business applications and customer web portals using R:BASE XE, Oterro XE, and Java running on MS Windows Server 2012R2 and Server 2016, please contact R:BASE Technologies' Services Division at mailto:servi...@rbase.com [mailto:services%40rbase.com]. Very Best R:egards, Razzak At 04:44 PM 1/4/2018, Jim Belisle wrote: >We are looking into having our customers be able to order product >directly into RBASE >from the web. They of course would fill out a form, create a user >name and password >and be able to order. This would also give the ability for them to >print certain >reports showing what they ordered. >Anyone out there use a specific software that you have found helpful >in this case? > >You can send directly to my email if you want. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php [http://www.rbase.com/support/usersgroup_guidelines.php] --- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l%2Bunsubscribe%40googlegroups.com]. For more options, visit https://groups.google.com/d/optout [https://groups.google.com/d/optout]. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php [http://www.rbase.com/support/usersgroup_guidelines.php] --- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [https://groups.google.com/d/optout]. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php [http://www.rbase.com/support/usersgroup_guidelines.php] --- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [https://groups.google.com/d/optout]. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and sto
Re: [RBASE-L] - Licensing question
The customer needs both Rbase and Rcompiler. You can’t develop in Rcompiler. -Original Message- From: dkfowler6179 To: RBASE-L Date: Fri, 12 Jan 2018 18:32:51 -0800 (PST) Subject: Re: [RBASE-L] - Licensing question > Tom, > Yes, sounds like R:Compiler would be the answer. Not likely to happen > though since I'm not developing for hire, wouldn't be charging and > don't see the need for it in my own business applications. Looks like > it would be less expensive to have them purchase R:Base than to go with > R:Compiler. > > David > > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > --- > 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 rbase-l+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- 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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [RBASE-L] - SubReports
Lena, Don't know if this will fix your issue but in general ALL and I mean ALL property must be used in the AFTER start section. Jan -Original Message- From: Lena Dammstrom To: "rbase-l@googlegroups.com" Date: Wed, 17 Jan 2018 12:14:46 -0600 Subject: [RBASE-L] - SubReports Using RBase 9.5 (32) version 9.5.5.30128 I have a report with 6 sub reports (ComponentID SR1 – SR6) Main: tmpReportControls with the six Object Sub Reports in the BreakHeader 0, breaking on the RptControlID (in tmpReportControls) Sometimes I do not want SR2 to print So I thought setting PROPERTY SR2 VISIBLE ‘FALSE’ in the Main: Before Generate would do the trick. It does suppress the information from showing on the page, yet it does print a blank page between SR1 and SR3 Am I missing a setting, or am I trying to do something that cannot be done? Any suggestions would be appreciated. Regards Lena [http://www.qmiusa.com/] Lena Dammstrom Software Developer Email: ldammst...@qmiusa.com [mailto:ldammst...@qmiusa.com] Toll Free: 800-446-2500 International: 01 630-529-7111 Extension: 1037 www.qmiusa.com [http://www.qmiusa.com/] . This email may contain material that is confidential, privileged and/or attorney work product for the sole use of the intended recipient. Any review, reliance or distribution by others or forwarding without express permission is strictly prohibited. If you are not the intended recipient, please contact the sender and delete all copies -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php [http://www.rbase.com/support/usersgroup_guidelines.php] --- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [https://groups.google.com/d/optout]. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- 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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
RE: [RBASE-L] - SubReports
Lena, I am away from the office and I know that I have several reports where I turn off the displays of certain sections. So it's possible I may get this wrong. Place your sub-report in a section (something that gives you a componentid) Test for your condition in the report ON BEFORE START eep. In the report ON AFTER START eep do the IF displayconditionyes THEN PROPERTY componentid VISIBLE TRUE ELSE PROPERTY componentid VISIBLE FALSE ENDIF Something like that. Jan -Original Message- From: Lena Dammstrom To: "rbase-l@googlegroups.com" Date: Wed, 17 Jan 2018 12:45:03 -0600 Subject: RE: [RBASE-L] - SubReports Jan, I am trying to update an existing report which is working just fine, by adding an additional Sub report. Was SR1, SR2, SR3, SR4 and SR5… now SR1, SR2, SR3(was SR2), SR4(was SR3), SR5(was SR4) and SR6(was SR5). I’ve changed the component IDs When you say After start, I am thinking you are talking about the After Generate Custom eep in the Main Currently everything is being done in the Before generate and nothing in the After generate. With that being said, I am still confused…. Regards Lena From:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Ofjan johansen Sent: Wednesday, January 17, 2018 12:23 PM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - SubReports Lena, Don't know if this will fix your issue but in general ALL and I mean ALL property must be used in the AFTER start section. Jan -Original Message- From: Lena Dammstrom mailto:ldammst...@qmiusa.com]> To: "rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com]"; mailto:rbase-l@googlegroups.com]> Date: Wed, 17 Jan 2018 12:14:46 -0600 Subject: [RBASE-L] - SubReports Using RBase 9.5 (32) version 9.5.5.30128 I have a report with 6 sub reports (ComponentID SR1 – SR6) Main: tmpReportControls with the six Object Sub Reports in the BreakHeader 0, breaking on the RptControlID (in tmpReportControls) Sometimes I do not want SR2 to print So I thought setting PROPERTY SR2 VISIBLE ‘FALSE’ in the Main: Before Generate would do the trick. It does suppress the information from showing on the page, yet it does print a blank page between SR1 and SR3 Am I missing a setting, or am I trying to do something that cannot be done? Any suggestions would be appreciated. Regards Lena [http://www.qmiusa.com/] Lena Dammstrom Software Developer Email: ldammst...@qmiusa.com [mailto:ldammst...@qmiusa.com] Toll Free: 800-446-2500 International: 01 630-529-7111 Extension: 1037 www.qmiusa.com [http://www.qmiusa.com/] . This email may contain material that is confidential, privileged and/or attorney work product for the sole use of the intended recipient. Any review, reliance or distribution by others or forwarding without express permission is strictly prohibited. If you are not the intended recipient, please contact the sender and delete all copies -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php [http://www.rbase.com/support/usersgroup_guidelines.php] --- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [https://groups.google.com/d/optout]. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php [http://www.rbase.com/support/usersgroup_guidelines.php] --- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [https://groups.google.com/d/optout]. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php [http://www.rbase.com/support/usersgroup_guidelines.php] --- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [https://groups.google.com/d/optout]. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- 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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
RE: [RBASE-L] - SubReports
Glad I could help. -Original Message- From: Lena Dammstrom To: "rbase-l@googlegroups.com" Date: Thu, 18 Jan 2018 08:51:01 -0600 Subject: RE: [RBASE-L] - SubReports Jan, I got my report/sub reports to work properly. Thank you for all your help and insights! Regards Lena From:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Ofjan johansen Sent: Wednesday, January 17, 2018 1:05 PM To: rbase-l@googlegroups.com Subject: RE: [RBASE-L] - SubReports Lena, I am away from the office and I know that I have several reports where I turn off the displays of certain sections. So it's possible I may get this wrong. Place your sub-report in a section (something that gives you a componentid) Test for your condition in the report ON BEFORE START eep. In the report ON AFTER START eep do the IF displayconditionyes THEN PROPERTY componentid VISIBLE TRUE ELSE PROPERTY componentid VISIBLE FALSE ENDIF Something like that. Jan -Original Message- From: Lena Dammstrom mailto:ldammst...@qmiusa.com]> To: "rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com]"; mailto:rbase-l@googlegroups.com]> Date: Wed, 17 Jan 2018 12:45:03 -0600 Subject: RE: [RBASE-L] - SubReports Jan, I am trying to update an existing report which is working just fine, by adding an additional Sub report. Was SR1, SR2, SR3, SR4 and SR5… now SR1, SR2, SR3(was SR2), SR4(was SR3), SR5(was SR4) and SR6(was SR5). I’ve changed the component IDs When you say After start, I am thinking you are talking about the After Generate Custom eep in the Main Currently everything is being done in the Before generate and nothing in the After generate. With that being said, I am still confused…. Regards Lena From:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] [mailto:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com]] On Behalf Ofjan johansen Sent: Wednesday, January 17, 2018 12:23 PM To: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] Subject: Re: [RBASE-L] - SubReports Lena, Don't know if this will fix your issue but in general ALL and I mean ALL property must be used in the AFTER start section. Jan -Original Message- From: Lena Dammstrom mailto:ldammst...@qmiusa.com]> To: "rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com]"; mailto:rbase-l@googlegroups.com]> Date: Wed, 17 Jan 2018 12:14:46 -0600 Subject: [RBASE-L] - SubReports Using RBase 9.5 (32) version 9.5.5.30128 I have a report with 6 sub reports (ComponentID SR1 – SR6) Main: tmpReportControls with the six Object Sub Reports in the BreakHeader 0, breaking on the RptControlID (in tmpReportControls) Sometimes I do not want SR2 to print So I thought setting PROPERTY SR2 VISIBLE ‘FALSE’ in the Main: Before Generate would do the trick. It does suppress the information from showing on the page, yet it does print a blank page between SR1 and SR3 Am I missing a setting, or am I trying to do something that cannot be done? Any suggestions would be appreciated. Regards Lena [http://www.qmiusa.com/] Lena Dammstrom Software Developer Email: ldammst...@qmiusa.com [mailto:ldammst...@qmiusa.com] Toll Free: 800-446-2500 International: 01 630-529-7111 Extension: 1037 www.qmiusa.com [http://www.qmiusa.com/] . This email may contain material that is confidential, privileged and/or attorney work product for the sole use of the intended recipient. Any review, reliance or distribution by others or forwarding without express permission is strictly prohibited. If you are not the intended recipient, please contact the sender and delete all copies -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php [http://www.rbase.com/support/usersgroup_guidelines.php] --- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [https://groups.google.com/d/optout]. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php [http://www.rbase.com/support/usersgroup_guidelines.php] --- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [https://groups.google.com/d/optout]. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php [http://www.rbase.com/support/usersgroup_guidelines.php] --- 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 rbase-l+unsubscr...@googlegroups.com [mail
Re: [RBASE-L] - Stay_On_Top
All property call's must be in an AFTER START eep -Original Message- From: karentellef via RBASE-L To: rbase-l@googlegroups.com Date: Thu, 18 Jan 2018 14:06:39 -0500 Subject: [RBASE-L] - Stay_On_Top If I am using PROPERTY RBASE_FORM STAY_ON_TOP 'ON' where should I put it? On the form Before start or After? Thanks! Karen -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php [http://www.rbase.com/support/usersgroup_guidelines.php] --- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [https://groups.google.com/d/optout]. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- 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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [RBASE-L] - Speed Difference - Same APP Different Laptops & AV Software
Ok, so this brings up a further question. In the old days we could just exclude the working directory. So ... now we need exclude the extensions? -Original Message- From: "A. Razzak Memon" To: rbase-l@googlegroups.com Date: Mon, 29 Jan 2018 08:54:15 -0500 Subject: Re: [RBASE-L] - Speed Difference - Same APP Different Laptops & AV Software John, Make sure to configure the AV software with the exclusions as follows: . \RBTI\RBGXE\*.* . RBENGINE*.dll . RBGX*.dll . RStyleX.dll . OterroX*.dll -- if applicable . RBENGINE*.cfg . OterroX*.cfg -- if applicable . RSyleX.cfg . Compiledappname.exe . *.dat . *.eep . *.rbc . *.rbm . *.rgw . *.rff . *.rmd . *.rx* Hope it helps! Very Best R:egards, Razzak At 04:38 AM 1/29/2018, John Docherty wrote: >I am running the same application on two >different laptops, both Windows 10 64 Bit, >R:Base XE, one with Bitdefender (old machine) >and the other (new) with Windows Defender. I >find that with the same RX% files on both >machines, the starting screen (an external form) >will be displayed within about 5 seconds on the >old laptop, while on the new one it takes in >excess of 20 seconds. I have the same >configuration settings (as far as I can tell) >and find that this behaviour only happens with >R:Base. With RRBYW19 the start time is about 4 >seconds on the old machine and about 24 >seconds on the new one. (With CAD files the >newer machine opens files faster than the old >one, as it should.)  I was wondering if >anyone has any suggestions as to what may be >causing this significant difference in >performance. (According to a disc test I ran on >both, the transfer rates on the new laptop are >1500 MB/sec (write) and 3000 MB/sec (read), >while the rates are significantly lower on the old machine - all SSDs.) > >Is this likely to be due to the AV software, and >if it is, can I stop WD scanning RX? files >? (I tried installing BD on the new machine >but that created a few blue screens so I gave that idea up.) > >Any suggestions would be welcome. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php [http://www.rbase.com/support/usersgroup_guidelines.php] --- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l%2Bunsubscribe%40googlegroups.com]. For more options, visit https://groups.google.com/d/optout [https://groups.google.com/d/optout]. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- 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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [RBASE-L] - Speed Difference - Same APP Different Laptops & AV Software
Razzak, Thank you for the clarification. However I may add the extensions as well because we still have machines on our network that open the application faster than others. Jan -Original Message- From: "A. Razzak Memon" To: rbase-l@googlegroups.com Date: Mon, 29 Jan 2018 12:15:35 -0500 Subject: Re: [RBASE-L] - Speed Difference - Same APP Different Laptops & AV Software Jan, No. That was just an example for all possible folders and extensions where the executables could be in one folder, and the applications, and DLLs could be in different folder(s). However, if everything is in one folder, such as compiled applications and projects as in your case, excluding the folder should take care of all files underneath that folder. Very Best R:egards, Razzak At 12:07 PM 1/29/2018, jan johansen wrote: >Ok, so this brings up a further question. In the >old days we could just exclude the working directory. >So ... now we need exclude the extensions? > > >-Original Message- >From: "A. Razzak Memon" mailto:razzak%40rbase.com]> >To: rbase-l@googlegroups.com [mailto:rbase-l%40googlegroups.com] >Date: Mon, 29 Jan 2018 08:54:15 -0500 >Subject: Re: [RBASE-L] - Speed Difference - Same >APP Different Laptops & AV Software > >John, > >Make sure to configure the AV software with the exclusions as follows: > >. \RBTI\RBGXE\*.* >. RBENGINE*.dll >. RBGX*.dll >. RStyleX.dll >. OterroX*.dll -- if applicable >. RBENGINE*.cfg >. OterroX*.cfg -- if applicable >. RSyleX.cfg >. Compiledappname.exe >. *.dat >. *.eep >. *.rbc >. *.rbm >. *.rgw >. *.rff >. *.rmd >. *.rx* > >Hope it helps! > >Very Best R:egards, > >Razzak > > >At 04:38 AM 1/29/2018, John Docherty wrote: > > >I am running the same application on two > >different laptops, both Windows 10 64 Bit, > >R:Base XE, one with Bitdefender (old machine) > >and the other (new) with Windows Defender. I > >find that with the same RX% files on both > >machines, the starting screen (an external form) > >will be displayed within about 5 seconds on the > >old laptop, while on the new one it takes in > >excess of 20 seconds. I have the same > >configuration settings (as far as I can tell) > >and find that this behaviour only happens with > >R:Base. With RRBYW19 the start time is about 4 > >seconds on the old machine and about 24 > >seconds on the new one. (With CAD files the > >newer machine opens files faster than the old > >one, as it should.)  I was wondering if > >anyone has any suggestions as to what may be > >causing this significant difference in > >performance. (According to a disc test I ran on > >both, the transfer rates on the new laptop are > >1500 MB/sec (write) and 3000 MB/sec (read), > >while the rates are significantly lower on the old machine - all SSDs.) > > > >Is this likely to be due to the AV software, and > >if it is, can I stop WD scanning RX? files > >? (I tried installing BD on the new machine > >but that created a few blue screens so I gave that idea up.) > > > >Any suggestions would be welcome. > >-- >For group guidelines, visit ><http://www.rbase.com/support/usersgroup_guidelines.php [http://www.rbase.com/support/usersgroup_guidelines.php]>http://www.rbase.com/support/usersgroup_guidelines.php [http://www.rbase.com/support/usersgroup_guidelines.php] >--- >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 ><mailto:rbase-l%2Bunsubscribe%40googlegroups.com>rbase-l+unsubscr...@googlegroups.com > [mailto:rbase-l%2Bunsubscribe%40googlegroups.com]. >For more options, visit ><https://groups.google.com/d/optout [https://groups.google.com/d/optout]>https://groups.google.com/d/optout [https://groups.google.com/d/optout]. > >-- >For group guidelines, visit ><http://www.rbase.com/support/usersgroup_guidelines.php [http://www.rbase.com/support/usersgroup_guidelines.php]>http://www.rbase.com/support/usersgroup_guidelines.php [http://www.rbase.com/support/usersgroup_guidelines.php] >--- >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 ><mailto:rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l%2Bunsubscribe%40googlegroups.com]>rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l%2Bunsubscribe%40googlegroups.com]. >For more options, visit ><https://groups.google.com/d/optout [https://groups.google.com/d/optout]>ht
Re: [RBASE-L] - Autofill a form field
David, You can indeed use the ON KEYPRESS eep. However you may want to explore your WALKMENU time interval setting. Default is 1500 ms. Try something like 3000 ms. Jan -Original Message- From: Albert Berry To: "rbase-l@googlegroups.com" Date: Wed, 31 Jan 2018 18:25:35 -0700 Subject: Re: [RBASE-L] - Autofill a form field I vaguely remember Razzak showing how using an ON KEYPRESS EEP. Perhaps a search of this and of Razzak’s helpful site would give you the clue. Albert > On Jan 31, 2018, at 3:28 PM, dkfowler6179 mailto:dkfowler6179%40comcast.net]> wrote: > > R:Base X, newest version. Looking for a way to autofill a field in a form with a value from an existing table based in characters typed in. For example. If we have a table that holds city names, I'd like to autofill a field for city in a form based on what is being typed, with the more characters being typed increasing the accuracy of the fill choice. This value then needs to be saved when the row of data specific to a the job being entered is saved. I've played with a DB Lookup List View and this acts similar to what I'm hoping for. However you have to type very quickly to keep it from switching the lookup back to the first letter of the street name. I also don't need a long list, just a few choices as more characters are entered and narrow down the options to the correct choice. > Any help is appreciated. > Thanks, > David Fowler > > -- > For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php [http://www.rbase.com/support/usersgroup_guidelines.php] > --- > 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l%2Bunsubscribe%40googlegroups.com]. > For more options, visit https://groups.google.com/d/optout [https://groups.google.com/d/optout]. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php [http://www.rbase.com/support/usersgroup_guidelines.php] --- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l%2Bunsubscribe%40googlegroups.com]. For more options, visit https://groups.google.com/d/optout [https://groups.google.com/d/optout]. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- 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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
[RBASE-L] - File location
My turn!
I need to make sure external documents are placed in the proper directory.
On the surface it's pretty easy.
However I have been running into some obstacles.
1. UNC/Mapped drive - machines on the network either use a UNC connection or
a mapped drive make it difficult to figure out the "home" directory
2. It appears (only occasionally) that the (CVAL('CURRDIR')) returns a
directory other that RBase if you have used the file explorer tool.
So I'm kind of looking for a fool proof way of making sure I have the proper
file location.
Suggestions?
Jan
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Re: [RBASE-L] - Autofill a form field
David, FYI. A "very large list" will turn into a "very slow form". Lookup Combo Box and the like require the loading of all the data before it can display the result. Jan -Original Message- From: dkfowler6179 To: RBASE-L Date: Thu, 1 Feb 2018 11:37:14 -0800 (PST) Subject: [RBASE-L] - Autofill a form field I've found the behavior I'm looking for in the Variable User Defined Combo Box with a the auto complete box checked. Only problem with this is having to manually enter thousands of street names. The Variable Lookup Combo Box is very similar and allows for lookup from a table. There is, however no Auto Complete box to check. Any way to import a very large list of streets into the user defined lookup or to have the Lookup Combo Box do the Auto Complete behavior? Thanks for any ideas. David Fowler -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php [http://www.rbase.com/support/usersgroup_guidelines.php] --- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l%2Bunsubscribe%40googlegroups.com]. For more options, visit https://groups.google.com/d/optout [https://groups.google.com/d/optout]. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- 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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
RE: [RBASE-L] - File location
Good advice Brad
-Original Message-
From: Brad Davidson
To: "rbase-l@googlegroups.com"
Date: Thu, 1 Feb 2018 18:54:15 +
Subject: RE: [RBASE-L] - File location
Jan,
May be a bit tangential to your request, but, having experienced this would
like to share.
A couple of years ago one of our users tried to open an email file
attachment which did not present but did establish the CryptoWall virus and
proceed to spread across mapped drives to server resources. After discovery
and remediation of several PDF and XLS files on our NAS device (mapped
drive) I then removed all mapped drives across LAN workstation devices. Now
using only UNC pathing to launch all server resources (and of course, R:BASE
applications).
Just for your consideration…
Brad Davidson
CIO, Director
Aero-Craft Hydraulics, Inc.
951.736.4690
brad.david...@aero-craft.com [mailto:brad.david...@aero-craft.com]
www.aero-craft.com [http://www.aero-craft.com/]
From:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf
Ofjan johansen
Sent: Thursday, February 01, 2018 9:56 AM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - File location
My turn!
I need to make sure external documents are placed in the proper directory.
On the surface it's pretty easy.
However I have been running into some obstacles.
1. UNC/Mapped drive - machines on the network either use a UNC connection or
a mapped drive make it difficult to figure out the "home" directory
2. It appears (only occasionally) that the (CVAL('CURRDIR')) returns a
directory other that RBase if you have used the file explorer tool.
So I'm kind of looking for a fool proof way of making sure I have the proper
file location.
Suggestions?
Jan
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
[https://url.emailprotection.link/?av9CDc-iyLOPPIWv3tKYgJaINkD5QW6ZflPvSdGXhHwFVd9H3-zcIg4w9YJ5CHvjNROgFUpcHti-ELb1dymnjRQ~~]
---
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 rbase-l+unsubscr...@googlegroups.com
[mailto:rbase-l+unsubscr...@googlegroups.com].
For more options, visit https://groups.google.com/d/optout
[https://url.emailprotection.link/?acI2QHOlLUu5r3fIWsg0FukefuYIqVJU2gt8_envaf_7bRGVAePvclKgGlI5iD7VjZEtCv8mJsYVLH4A0CyroQQ~~].
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
[http://www.rbase.com/support/usersgroup_guidelines.php]
---
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 rbase-l+unsubscr...@googlegroups.com
[mailto:rbase-l+unsubscr...@googlegroups.com].
For more options, visit https://groups.google.com/d/optout
[https://groups.google.com/d/optout].
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
RE: [RBASE-L] - File location
Thanks Dan.
-Original Message-
From: Dan Goldberg
To: "rbase-l@googlegroups.com"
Date: Thu, 1 Feb 2018 18:44:24 +
Subject: RE: [RBASE-L] - File location
Do you use rbase to link the files to the database?
Here is a snippet of what I use to link the files to the line item in the
database.
SET VAR vefilename TEXT, vedir TEXT =(ENVVAL('userprofile') + '\Desktop')
SET VAR venewfilename TEXT, veloc INTEGER, velen INTEGER
SET VAR vefilename2 TEXT, veitemcnt INTEGER
SET VAR vefileexists TEXT, veyorn TEXT = NULL
--check for existing file
GETPROPERTY cfilename TEXTVALUE 'vefileexists'
IF vefileexists IS NOT NULL THEN
DIALOG 'File already is linked. Overwrite?' veyorn whtemp no +
CAPTION 'Link File'
IF veyorn = 'no' THEN
GOTO eendproc
ENDIF
ENDIF
--have user select the file and defaults to their desktop
PLUGINS loadfilename vefilename |fullpath on |TITLE SELECT file +
TO attach |view_mode list |initial_dir &vedir
--copy to folder
SET VAR venewfilename = ((CTXT(.VSupportID)) + (CTXT((JDATE(.#DATE +
(CTXT +
(IHR(.#TIME))) + (CTXT(IMIN(.#TIME))) + (CTXT(ISEC(.#TIME
SET VAR vefilename2 = (SRPL(.vefilename,'.',',',0))
SET VAR veitemcnt = (ITEMCNT(.vefilename2))
SET VAR venewfilename = ('\\servername\sharename\RecAtt\ST' + .venewfilename
+ +
'.' + (SSUB (.vefilename2, .veitemcnt)))
--copy to the network share and gives it a unique name
COPY .vefilename .venewfilename
--place link name in db
PROPERTY cfilename TEXTVALUE .venewfilename
LABEL eendproc
CLEAR VAR ve%
RETURN
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf
Ofjan johansen
Sent: Thursday, February 1, 2018 9:56 AM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - File location
My turn!
I need to make sure external documents are placed in the proper directory.
On the surface it's pretty easy.
However I have been running into some obstacles.
1. UNC/Mapped drive - machines on the network either use a UNC connection or
a mapped drive make it difficult to figure out the "home" directory
2. It appears (only occasionally) that the (CVAL('CURRDIR')) returns a
directory other that RBase if you have used the file explorer tool.
So I'm kind of looking for a fool proof way of making sure I have the proper
file location.
Suggestions?
Jan
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
[http://www.rbase.com/support/usersgroup_guidelines.php]
---
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 rbase-l+unsubscr...@googlegroups.com
[mailto:rbase-l+unsubscr...@googlegroups.com].
For more options, visit https://groups.google.com/d/optout
[https://groups.google.com/d/optout].
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
[http://www.rbase.com/support/usersgroup_guidelines.php]
---
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 rbase-l+unsubscr...@googlegroups.com
[mailto:rbase-l+unsubscr...@googlegroups.com].
For more options, visit https://groups.google.com/d/optout
[https://groups.google.com/d/optout].
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
RE: [RBASE-L] - DB problem
I have not used it since 7.1. I did a complete unload from 6.5++, normalized the database, and wrote a specific routine to load the new db at that time. No troubles since. -Original Message- From: Jim Belisle To: "rbase-l@googlegroups.com" Date: Tue, 13 Feb 2018 20:36:16 + Subject: RE: [RBASE-L] - DB problem I have used it a number of times but I must admit I only use it diagnostically. The only fix I have tried is the automatic fix. I have not learned the “Curve” to go in and try row by row. James Belisle Making Information Systems People Friendly Since 1990 From:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf OfAlbert Berry Sent: Tuesday, February 13, 2018 12:23 PM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - DB problem The year R:Scope was introduced in Seattle, many years ago, the company DBA came with me to the annual conference held by MicroRIM. At the end of the R:Scope presentation he turned to me and said “Buy it”. I did. It works wonders for really troublesome databases. As mentioned, there is a learning curve, but there is nothing else that will do all it will do for you. > On Feb 13, 2018, at 10:54 AM, Dan Goldberg [mailto:d...@lancecamper.com%3e] wrote: > > Rscope could possibly fix it. there is a learning curve to it though. > > Dan Goldberg > > -Original Message- > From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] [mailto:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com]] On Behalf Of Carpet Broker, Dick Fey > Sent: Tuesday, February 13, 2018 9:49 AM > To: RBase Maillist [mailto:RBASE-L@GoogleGroups.com%3e] > Subject: [RBASE-L] - DB problem > > Looks like I have a problem with a table with spurious rows that a reload or a pack is not fixing. > I have never needed to inspect my data in this way, but is R:Scope the product I need? > > Dick Fey > > Carpet Broker Inc > P: 913-894-9211 > F: 913-894-0138 > > > -- > For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php [http://www.rbase.com/support/usersgroup_guidelines.php] > --- > 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. > For more options, visit https://groups.google.com/d/optout [https://groups.google.com/d/optout]. > > -- > For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php [http://www.rbase.com/support/usersgroup_guidelines.php] > --- > 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. > For more options, visit https://groups.google.com/d/optout [https://groups.google.com/d/optout]. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php [http://www.rbase.com/support/usersgroup_guidelines.php] --- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [https://groups.google.com/d/optout]. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php [http://www.rbase.com/support/usersgroup_guidelines.php] --- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [https://groups.google.com/d/optout]. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- 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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
[RBASE-L] - File location and path
I'm looking for ideas. I need BOTH the fullpath and the filename without the path. I don't think there is an option using either of the loadfile plugins. Thoughts? -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- 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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [RBASE-L] - File location and path
Yes but I need them both -Original Message- From: karentellef via RBASE-L To: rbase-l@googlegroups.com Date: Thu, 15 Feb 2018 15:17:55 -0500 Subject: Re: [RBASE-L] - File location and path Yes, loadfilename plugin has a parameter: FULLPATH ON/OFF Karen -Original Message- From: jan johansen To: rbase-l Sent: Thu, Feb 15, 2018 2:05 pm Subject: [RBASE-L] - File location and path I'm looking for ideas. I need BOTH the fullpath and the filename without the path. I don't think there is an option using either of the loadfile plugins. Thoughts? -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php [http://www.rbase.com/support/usersgroup_guidelines.php] --- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [https://groups.google.com/d/optout]. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php [http://www.rbase.com/support/usersgroup_guidelines.php] --- 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 rbase-l+unsubscr...@googlegroups.com [mailto:rbase-l+unsubscr...@googlegroups.com]. For more options, visit https://groups.google.com/d/optout [https://groups.google.com/d/optout]. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- 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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
