Re: Re[4]: [RBASE-L] - Disappearing RStyle error list
WE HAVE A WINNER! I had no idea you could right-click on that icon! My window has magically appeared, thanks so much Jim Karen On Wednesday, May 15, 2024 at 06:38:06 PM CDT, 'jim schmitt' via RBASE-L wrote: Karen: When using rbed on a file, do a right click on the rstyle icon, and check the 'error messages' option at the bottom. Should work.Jim On Wednesday, May 15, 2024 at 05:56:38 PM EDT, Bruce Chitiea wrote: Within RBEdit ten-five and eleven, see "View" on the top-of-screen command line. Is "Error Messages" checked? On both versions, that toggles the Error Messages window at the bottom of the screen on/off. Is that it? b -- Original Message --From "'Karen Tellef' via RBASE-L" To "rbase-l@googlegroups.com" Date 5/15/2024 2:45:04 PMSubject Re: Re[2]: [RBASE-L] - Disappearing RStyle error list None of the errors show; there's no box to display the errors in. Karen On Wednesday, May 15, 2024 at 04:33:05 PM CDT, Bruce Chitiea wrote: I have a vetted v10.5 set I haven't converted yet. I'll break a few things and see whats is. Any sense of there being a category of error which doesn't pop? B ------ Original Message --From "'Karen Tellef' via RBASE-L" To "rbase-l@googlegroups.com" Date 5/15/2024 2:27:39 PMSubject Re: [RBASE-L] - Disappearing RStyle error list Version 10.5, noticed it on several builds of it, up to the most recent Karen On Wednesday, May 15, 2024 at 04:22:52 PM CDT, Bruce Chitiea wrote: Karen: Which version and release is this?Bruce Bruce A. ChitieaSafeSectors, Inc.1142 S Diamond Bar Blvd # 442Diamond Bar CA 91765-2203 rby...@safesectors.com (909) 238-9012 m -- Original Message --From "'Karen Tellef' via RBASE-L" To "RBase List" Date 5/15/2024 1:08:06 PMSubject [RBASE-L] - Disappearing RStyle error list This happens to me on and off. I RStyle something, it'll report the errors, but I don't get the box that explains what each error is. I do get the highlighted rows, so I can sorta see where the errors are, but I need the explanation sometimes. I've looked and can't find a setting to turn this back on, and I don't see any gutters that I can grab and expand, in case I had accidentally closed the space up. Anyone have a clue for me? Karen -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/442345200.440839.1715803686522%40mail.yahoo.com. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/emdb4812bc-0ece-4544-8ab2-a3c4b64571d1%40b94eb5b2.com. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/523885896.467916.1715808459862%40mail.yahoo.com. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/em65535d33-c5ea-4c88-ad9e-b57070787bd7%40b94eb5b2.com. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/1286513161.488469.1715809504839%40mail.yahoo.com. -- 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. To view this dis
Re: Re[2]: [RBASE-L] - Disappearing RStyle error list
None of the errors show; there's no box to display the errors in. Karen On Wednesday, May 15, 2024 at 04:33:05 PM CDT, Bruce Chitiea wrote: I have a vetted v10.5 set I haven't converted yet. I'll break a few things and see whats is. Any sense of there being a category of error which doesn't pop? B -- Original Message --From "'Karen Tellef' via RBASE-L" To "rbase-l@googlegroups.com" Date 5/15/2024 2:27:39 PMSubject Re: [RBASE-L] - Disappearing RStyle error list Version 10.5, noticed it on several builds of it, up to the most recent Karen On Wednesday, May 15, 2024 at 04:22:52 PM CDT, Bruce Chitiea wrote: Karen: Which version and release is this?Bruce Bruce A. ChitieaSafeSectors, Inc.1142 S Diamond Bar Blvd # 442Diamond Bar CA 91765-2203 rby...@safesectors.com (909) 238-9012 m -- Original Message --From "'Karen Tellef' via RBASE-L" To "RBase List" Date 5/15/2024 1:08:06 PMSubject [RBASE-L] - Disappearing RStyle error list This happens to me on and off. I RStyle something, it'll report the errors, but I don't get the box that explains what each error is. I do get the highlighted rows, so I can sorta see where the errors are, but I need the explanation sometimes. I've looked and can't find a setting to turn this back on, and I don't see any gutters that I can grab and expand, in case I had accidentally closed the space up. Anyone have a clue for me? Karen -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/442345200.440839.1715803686522%40mail.yahoo.com. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/emdb4812bc-0ece-4544-8ab2-a3c4b64571d1%40b94eb5b2.com. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/523885896.467916.1715808459862%40mail.yahoo.com. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/em65535d33-c5ea-4c88-ad9e-b57070787bd7%40b94eb5b2.com. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/1286513161.488469.1715809504839%40mail.yahoo.com.
Re: [RBASE-L] - Disappearing RStyle error list
Version 10.5, noticed it on several builds of it, up to the most recent Karen On Wednesday, May 15, 2024 at 04:22:52 PM CDT, Bruce Chitiea wrote: Karen: Which version and release is this?Bruce Bruce A. ChitieaSafeSectors, Inc.1142 S Diamond Bar Blvd # 442Diamond Bar CA 91765-2203 rby...@safesectors.com (909) 238-9012 m -- Original Message --From "'Karen Tellef' via RBASE-L" To "RBase List" Date 5/15/2024 1:08:06 PMSubject [RBASE-L] - Disappearing RStyle error list This happens to me on and off. I RStyle something, it'll report the errors, but I don't get the box that explains what each error is. I do get the highlighted rows, so I can sorta see where the errors are, but I need the explanation sometimes. I've looked and can't find a setting to turn this back on, and I don't see any gutters that I can grab and expand, in case I had accidentally closed the space up. Anyone have a clue for me? Karen -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/442345200.440839.1715803686522%40mail.yahoo.com. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/emdb4812bc-0ece-4544-8ab2-a3c4b64571d1%40b94eb5b2.com. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/523885896.467916.1715808459862%40mail.yahoo.com.
[RBASE-L] - Disappearing RStyle error list
This happens to me on and off. I RStyle something, it'll report the errors, but I don't get the box that explains what each error is. I do get the highlighted rows, so I can sorta see where the errors are, but I need the explanation sometimes. I've looked and can't find a setting to turn this back on, and I don't see any gutters that I can grab and expand, in case I had accidentally closed the space up. Anyone have a clue for me? Karen -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/442345200.440839.1715803686522%40mail.yahoo.com.
Re: [RBASE-L] - Version 11
Yes, assign a ComponentID to the List view. Then in your button where you add a new member to the list, add this command at the end, substituting your componentID: PROPERTY [componendID] REFRESHLIST 'TRUE' Karen On Friday, May 3, 2024 at 12:04:20 PM CDT, wrote: I have a DB Lookup List View on a form which collects potentially matching data from a membership table. If there are no matches, I have a button to add a new member to the membership table based on the information on my form. After adding the new member, is there a way to update the DB Lookup List View so that it displays the row that I’ve added? Thanks in advance! Steve Thorson -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/013301da9d7b%24ecd91980%24c68b4c80%24%40afsafund.org. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/6168552.5556760.1714756165710%40mail.yahoo.com.
Re: [RBASE-L] - rbase on win10
I also have windows version 6.5 running nicely on a windows 10 machine. You don’t say, but are you talking Rbase windows or DOS 6.5? None of my clients are on 6.5 anymore but I was recently running it a lot for a conversion project. You shouldn’t have a problem Karen Sent from my iPhone > On Apr 26, 2024, at 2:38 PM, 'Nicky Avery' via RBASE-L > wrote: > > > Hi Greg, > > FWIW I have R:Base 2000 6.5 1.842 RT03 running on Win 11 with compatibility > setting for XP SP3. It also ran on W10. There's a later patch 1.866 which I > seem not have installed - cannot remember why not. It runs well apart from > very occasional crashes which I think are Windows memory management issues. > > Nicky > > > On 4/26/2024 11:24 AM, greg mccullough wrote: >> Hi folks, my laptop running Win7 and R:base 2000 ver 6.5 recently died after >> a stellar 20 year run. My new laptop runs Win10 and ver 6.5 doesn't seem to >> want to run on it. My computer guy has set up Win7 in a virtual machine but >> the performance is haphazard. Questions for you: >> Can anything be done to get 6.5 running on Win10? I have tried the >> compatibility mode to no avail. >> Will Rbase 7.5 run on Win10? I have a copy that i have never loaded. >> >> Any help would be appreciated >> >> Greg McCullough >> Iris City Gardens >> -- >> 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. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/rbase-l/CABFcdu922t3Wx7aA9AXEMZ4dBnWr%3Dw-BJaxfomBknHRwURvOZA%40mail.gmail.com. > > -- > 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. > To view this discussion on the web visit > https://groups.google.com/d/msgid/rbase-l/fa1bcb5d-200a-49bb-87cd-757bd05b4b4d%40wwavs.com. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/0F6D9F30-0FC2-44AC-BA00-52A9E656FD24%40cs.com.
Re: Re[2]: [RBASE-L] - Disappearing text | An Old-School consideration
Bruce: Wish I knew all that! I've never visited their site, and I'm just a subcontractor on this large client. I know they are a manufacturing plant. I'll pass on your questions to the "man in charge" Karen On Tuesday, April 23, 2024 at 09:16:55 AM CDT, Bruce Chitiea wrote: Karen: You'd mentioned in your first message: "Client says this happens in a couple forms, but was sporadic", and nothing to suggest there's a "beat" to these episodes. Reminds of the good old days before PC power conditioning (UPS) became affordable. Voltage didn't/doesn't have to wander far off the mark for the ghosts to take over. SafeSectors was started, in part, to mitigate this very risk. So how's the grid in your client's area? Large wind farms? Any large, intermittent machine loads (e.g. HVAC) on the same breaker panels? Double-bussing on those panels? Has their infrastructure team paid attention to electrical integrity? Are server(s) and all network fixin's fed by reputable (e.g. APC), well-maintained UPS units? How 'bout workstations? Or are they relying on off-shore, off-brand surge strips? This is all certainly topical in California, where electrical chaos is the order of the day. Best, Bruce Bruce A. ChitieaSafeSectors, Inc.1142 S Diamond Bar Blvd # 442Diamond Bar CA 91765-2203 rby...@safesectors.com (909) 238-9012 m -- Original Message --From "'Karen Tellef' via RBASE-L" To "rbase-l@googlegroups.com" Date 4/23/2024 6:24:25 AMSubject Re: [RBASE-L] - Disappearing text - an interesting discovery Not a solution to my problem, but we did "discover" the command SET REFRESH [x] The help description: SET REFRESH specifies how often R:BASE refreshes the form or the Data Browser, and displays current data. It also automatically recalculates lower tables in forms. Specify zero to turn the setting off. When REFRESH is set off, R:BASE tells you of edits when you save or delete a row. So this is like the "auto save" that we've been talking about. The default is 0, and I checked all the programs and forms and we don't set or change it. I checked the value going in to the form and it is at 0. I put a 'set refresh 0' before bringing up the form, just in case, and it still disappears Karen On Monday, April 22, 2024 at 11:20:15 AM CDT, jan johansen wrote: Karen, I do not know the answer to the network but I have seen enough strangeness over networks to question it.Currently on my network there is a large slowdown that occurs at random that I haven't been able to pinpoint. Maybe Mike Byerly can shed some light on network vagaries, like random polling and such. Jan From: "'Karen Tellef' via RBASE-L" To: "rbase-l@googlegroups.com" Date: Mon, 22 Apr 2024 14:54:38 + (UTC) Subject: Re: [RBASE-L] - Disappearing text Jan: I don't have it here at my place. It has sensitive data so I work while connected remotely. So it happens to them on the network, and to me while dialed in (VPN). I could copy it down locally but it's a massive database But you gave me an idea to try. I brought the table definition and the form here to my environment. Made sure I ran the exact build of RBase as they are. Did the "edit using", sat on a field and waited, and the text never disappeared. So doesn't appear to be a form setting Can a network fire off a "save work" command? Karen On Monday, April 22, 2024 at 09:37:26 AM CDT, jan johansen wrote: Karen, Along the line of Jim's question, does the form exhibit this behavior running on your development environment i.e. not running across a network? Jan From: "'jim schmitt' via RBASE-L" To: 'Karen Tellef' via RBASE-L Date: Mon, 22 Apr 2024 14:21:29 + (UTC) Subject: Re: [RBASE-L] - Disappearing text Karen: do you get the error if you do the 'edit using' from an R: prompt ? or is the form in question being called by another form ? JImOn Monday, April 22, 2024 at 09:03:46 AM EDT, 'Karen Tellef' via RBASE-L wrote: Javier: I think you're getting close. Yep, I'm aware of the need of a dummy space to land so that it saves your final entry. So that RBase doesn't think that you've exited the field without wanting to save the value. But a "landing spot" isn't going to help here because if the user is taking a long time to type in the big memo field, it will blank out the field as the person is typing. It isn't based on inactivity. That's why they type outside RBase and copy it into the field. So yeah, it's as if there's an "auto save" somewhere and it thinks I don't want my final value because I haven't moved off the field. But is there such a thing? If so, that's news to me. And remember, it only happens in variable edits, doesn't happen in DB edits. There's no form timer. I don't think there's a form timer anywhere within this ap
Re: [RBASE-L] - Disappearing text - an interesting discovery
Not a solution to my problem, but we did "discover" the command SET REFRESH [x] The help description: SET REFRESH specifies how often R:BASE refreshes the form or the Data Browser, and displays current data. It also automatically recalculates lower tables in forms. Specify zero to turn the setting off. When REFRESH is set off, R:BASE tells you of edits when you save or delete a row. So this is like the "auto save" that we've been talking about. The default is 0, and I checked all the programs and forms and we don't set or change it. I checked the value going in to the form and it is at 0. I put a 'set refresh 0' before bringing up the form, just in case, and it still disappears Karen On Monday, April 22, 2024 at 11:20:15 AM CDT, jan johansen wrote: Karen, I do not know the answer to the network but I have seen enough strangeness over networks to question it.Currently on my network there is a large slowdown that occurs at random that I haven't been able to pinpoint. Maybe Mike Byerly can shed some light on network vagaries, like random polling and such. Jan From: "'Karen Tellef' via RBASE-L" To: "rbase-l@googlegroups.com" Date: Mon, 22 Apr 2024 14:54:38 + (UTC) Subject: Re: [RBASE-L] - Disappearing text Jan: I don't have it here at my place. It has sensitive data so I work while connected remotely. So it happens to them on the network, and to me while dialed in (VPN). I could copy it down locally but it's a massive database But you gave me an idea to try. I brought the table definition and the form here to my environment. Made sure I ran the exact build of RBase as they are. Did the "edit using", sat on a field and waited, and the text never disappeared. So doesn't appear to be a form setting Can a network fire off a "save work" command? Karen On Monday, April 22, 2024 at 09:37:26 AM CDT, jan johansen wrote: Karen, Along the line of Jim's question, does the form exhibit this behavior running on your development environment i.e. not running across a network? Jan From: "'jim schmitt' via RBASE-L" To: 'Karen Tellef' via RBASE-L Date: Mon, 22 Apr 2024 14:21:29 + (UTC) Subject: Re: [RBASE-L] - Disappearing text Karen: do you get the error if you do the 'edit using' from an R: prompt ? or is the form in question being called by another form ? JImOn Monday, April 22, 2024 at 09:03:46 AM EDT, 'Karen Tellef' via RBASE-L wrote: Javier: I think you're getting close. Yep, I'm aware of the need of a dummy space to land so that it saves your final entry. So that RBase doesn't think that you've exited the field without wanting to save the value. But a "landing spot" isn't going to help here because if the user is taking a long time to type in the big memo field, it will blank out the field as the person is typing. It isn't based on inactivity. That's why they type outside RBase and copy it into the field. So yeah, it's as if there's an "auto save" somewhere and it thinks I don't want my final value because I haven't moved off the field. But is there such a thing? If so, that's news to me. And remember, it only happens in variable edits, doesn't happen in DB edits. There's no form timer. I don't think there's a form timer anywhere within this application. The 30 seconds is a guess, it can happen earlier than that or later than that (I have waited up to a minute before it happened). There is a SET TIMER in the app, I think set for a couple hours, but RBase isn't exiting in this case. Yes, I need the values in those two variables after I exit the form to be used in an email that will be sent after the form closes. The variable data isn't saved anywhere. So -- is there an "auto save" somewhere? Either a form setting or a "SET" command that I don't know about? Otherwise since this doesn't happen with DB edits, I will probably create a temp table and add it to the form and turn these into DB Edits for the temp table. KarenOn Sunday, April 21, 2024 at 08:03:03 PM CDT, Javier Valencia wrote: EDIT USING is the only way I use forms and I don't have issues. What do the variables do? Do you need them after exiting the form?The fact it happens after 30 seconds would appear to indicate there might be a timer that refreshes the form every 30 seconds, and if the variable has not been saved it might reset it to the original, unchanged value.In the old days we used to place a dummy field behind the last variable to provide a landing spot as was mentioned.If the form is doing an auto save, there is a system variable you can check to see if there are pending changes and stop the save and return to the variable field with a message. Javier Valencia, PESent from my T-Mobile 4G LTE Device ---- Original message From: 'jim schmitt' via RBASE-L Date: 4/21/24 6:16 PM (GMT-06:00)T
Re: [RBASE-L] - Disappearing text
That didn't make a difference unfortunately Karen On Monday, April 22, 2024 at 09:43:57 AM CDT, 'jim schmitt' via RBASE-L wrote: Karen: On the main menu (which calls the problem menu), insert the following on an 'after start' eep. PROPERTY RBASE_FORM TIMERENABLED 'FALSE' RECALC VARIABLES RETURN Jim On Monday, April 22, 2024 at 10:39:09 AM EDT, 'Karen Tellef' via RBASE-L wrote: Jim: funny you should ask that. When I edit the form from the R> prompt, it never happens (which is why I didn't pick it up when I was designing/testing). I should've mentioned that up front. This form is called from the main menu, which has a Group Bar control. This is one of the group bar options with a simple "edit using" command, nothing else. No timers on the main menu. So do we all think there's some kind of "auto save" setting in the startup file that might cause this? If I had designed this system, it'd be easy to post the startup parameters for your perusal. But someone else designed this app, and to track down the myriad of settings is quite the process. If I knew a particular setting that might cause this to happen, I could search for it! Karen On Monday, April 22, 2024 at 09:21:38 AM CDT, 'jim schmitt' via RBASE-L wrote: Karen: do you get the error if you do the 'edit using' from an R: prompt ? or is the form in question being called by another form ? JIm On Monday, April 22, 2024 at 09:03:46 AM EDT, 'Karen Tellef' via RBASE-L wrote: Javier: I think you're getting close. Yep, I'm aware of the need of a dummy space to land so that it saves your final entry. So that RBase doesn't think that you've exited the field without wanting to save the value. But a "landing spot" isn't going to help here because if the user is taking a long time to type in the big memo field, it will blank out the field as the person is typing. It isn't based on inactivity. That's why they type outside RBase and copy it into the field. So yeah, it's as if there's an "auto save" somewhere and it thinks I don't want my final value because I haven't moved off the field. But is there such a thing? If so, that's news to me. And remember, it only happens in variable edits, doesn't happen in DB edits. There's no form timer. I don't think there's a form timer anywhere within this application. The 30 seconds is a guess, it can happen earlier than that or later than that (I have waited up to a minute before it happened). There is a SET TIMER in the app, I think set for a couple hours, but RBase isn't exiting in this case. Yes, I need the values in those two variables after I exit the form to be used in an email that will be sent after the form closes. The variable data isn't saved anywhere. So -- is there an "auto save" somewhere? Either a form setting or a "SET" command that I don't know about? Otherwise since this doesn't happen with DB edits, I will probably create a temp table and add it to the form and turn these into DB Edits for the temp table. Karen On Sunday, April 21, 2024 at 08:03:03 PM CDT, Javier Valencia wrote: EDIT USING is the only way I use forms and I don't have issues. What do the variables do? Do you need them after exiting the form?The fact it happens after 30 seconds would appear to indicate there might be a timer that refreshes the form every 30 seconds, and if the variable has not been saved it might reset it to the original, unchanged value.In the old days we used to place a dummy field behind the last variable to provide a landing spot as was mentioned.If the form is doing an auto save, there is a system variable you can check to see if there are pending changes and stop the save and return to the variable field with a message. Javier Valencia, PESent from my T-Mobile 4G LTE Device Original message From: 'jim schmitt' via RBASE-L Date: 4/21/24 6:16 PM (GMT-06:00) To: 'KAREN TELLEF' via RBASE-L Subject: Re: [RBASE-L] - Disappearing text Karen: Another thought..If you are using just variables on a form, the last variable field will need to have another 'dummy field as the form need a 'landing'.for the cursor (even if not used). I do this all the time with variable forms, set up a dummy variable field, that the screen never gets to after the last variable field.. Base your exit or return after the field is entered. Jim On Sunday, April 21, 2024 at 06:11:42 PM EDT, 'KAREN TELLEF' via RBASE-L wrote: Not sure what you mean. The variables are null going into the form. User is required to type something in both variables Karen Sent from my iPhone On Apr 21, 2024, at 4:12 PM, Bruce Chitiea wrote: What happens if you define the variables as Form Variables?Bruce -- Original Message --From "'Karen Tellef' via RBASE-L" To "RBase List" Dat
Re: [RBASE-L] - Disappearing text
Jan: I don't have it here at my place. It has sensitive data so I work while connected remotely. So it happens to them on the network, and to me while dialed in (VPN). I could copy it down locally but it's a massive database But you gave me an idea to try. I brought the table definition and the form here to my environment. Made sure I ran the exact build of RBase as they are. Did the "edit using", sat on a field and waited, and the text never disappeared. So doesn't appear to be a form setting Can a network fire off a "save work" command? Karen On Monday, April 22, 2024 at 09:37:26 AM CDT, jan johansen wrote: Karen, Along the line of Jim's question, does the form exhibit this behavior running on your development environment i.e. not running across a network? Jan From: "'jim schmitt' via RBASE-L" To: 'Karen Tellef' via RBASE-L Date: Mon, 22 Apr 2024 14:21:29 + (UTC) Subject: Re: [RBASE-L] - Disappearing text Karen: do you get the error if you do the 'edit using' from an R: prompt ? or is the form in question being called by another form ? JImOn Monday, April 22, 2024 at 09:03:46 AM EDT, 'Karen Tellef' via RBASE-L wrote: Javier: I think you're getting close. Yep, I'm aware of the need of a dummy space to land so that it saves your final entry. So that RBase doesn't think that you've exited the field without wanting to save the value. But a "landing spot" isn't going to help here because if the user is taking a long time to type in the big memo field, it will blank out the field as the person is typing. It isn't based on inactivity. That's why they type outside RBase and copy it into the field. So yeah, it's as if there's an "auto save" somewhere and it thinks I don't want my final value because I haven't moved off the field. But is there such a thing? If so, that's news to me. And remember, it only happens in variable edits, doesn't happen in DB edits. There's no form timer. I don't think there's a form timer anywhere within this application. The 30 seconds is a guess, it can happen earlier than that or later than that (I have waited up to a minute before it happened). There is a SET TIMER in the app, I think set for a couple hours, but RBase isn't exiting in this case. Yes, I need the values in those two variables after I exit the form to be used in an email that will be sent after the form closes. The variable data isn't saved anywhere. So -- is there an "auto save" somewhere? Either a form setting or a "SET" command that I don't know about? Otherwise since this doesn't happen with DB edits, I will probably create a temp table and add it to the form and turn these into DB Edits for the temp table. KarenOn Sunday, April 21, 2024 at 08:03:03 PM CDT, Javier Valencia wrote: EDIT USING is the only way I use forms and I don't have issues. What do the variables do? Do you need them after exiting the form?The fact it happens after 30 seconds would appear to indicate there might be a timer that refreshes the form every 30 seconds, and if the variable has not been saved it might reset it to the original, unchanged value.In the old days we used to place a dummy field behind the last variable to provide a landing spot as was mentioned.If the form is doing an auto save, there is a system variable you can check to see if there are pending changes and stop the save and return to the variable field with a message. Javier Valencia, PESent from my T-Mobile 4G LTE Device Original message From: 'jim schmitt' via RBASE-L Date: 4/21/24 6:16 PM (GMT-06:00)To: 'KAREN TELLEF' via RBASE-L Subject: Re: [RBASE-L] - Disappearing text Karen: Another thought..If you are using just variables on a form, the last variable field will need to have another 'dummy field as the form need a 'landing'.for the cursor (even if not used). I do this all the time with variable forms, set up a dummy variable field, that the screen never gets to after the last variable field.. Base your exit or return after the field is entered. Jim On Sunday, April 21, 2024 at 06:11:42 PM EDT, 'KAREN TELLEF' via RBASE-L wrote: Not sure what you mean. The variables are null going into the form. User is required to type something in both variables Karen Sent from my iPhone On Apr 21, 2024, at 4:12 PM, Bruce Chitiea wrote: What happens if you define the variables as Form Variables?Bruce -- Original Message --From "'Karen Tellef' via RBASE-L" To "RBase List" Date 4/21/2024 1:15:36 PMSubject [RBASE-L] - Disappearing text Version 10.5. Client says this happens in a couple forms, but was sporadic. Finally there's a form where the issue is easy to replicate so I have something to work on. Issue: if you type something in a variable edit field and are just sitting in that field, if you wait about 30 seconds
Re: [RBASE-L] - Disappearing text
Jim: funny you should ask that. When I edit the form from the R> prompt, it never happens (which is why I didn't pick it up when I was designing/testing). I should've mentioned that up front. This form is called from the main menu, which has a Group Bar control. This is one of the group bar options with a simple "edit using" command, nothing else. No timers on the main menu. So do we all think there's some kind of "auto save" setting in the startup file that might cause this? If I had designed this system, it'd be easy to post the startup parameters for your perusal. But someone else designed this app, and to track down the myriad of settings is quite the process. If I knew a particular setting that might cause this to happen, I could search for it! Karen On Monday, April 22, 2024 at 09:21:38 AM CDT, 'jim schmitt' via RBASE-L wrote: Karen: do you get the error if you do the 'edit using' from an R: prompt ? or is the form in question being called by another form ? JIm On Monday, April 22, 2024 at 09:03:46 AM EDT, 'Karen Tellef' via RBASE-L wrote: Javier: I think you're getting close. Yep, I'm aware of the need of a dummy space to land so that it saves your final entry. So that RBase doesn't think that you've exited the field without wanting to save the value. But a "landing spot" isn't going to help here because if the user is taking a long time to type in the big memo field, it will blank out the field as the person is typing. It isn't based on inactivity. That's why they type outside RBase and copy it into the field. So yeah, it's as if there's an "auto save" somewhere and it thinks I don't want my final value because I haven't moved off the field. But is there such a thing? If so, that's news to me. And remember, it only happens in variable edits, doesn't happen in DB edits. There's no form timer. I don't think there's a form timer anywhere within this application. The 30 seconds is a guess, it can happen earlier than that or later than that (I have waited up to a minute before it happened). There is a SET TIMER in the app, I think set for a couple hours, but RBase isn't exiting in this case. Yes, I need the values in those two variables after I exit the form to be used in an email that will be sent after the form closes. The variable data isn't saved anywhere. So -- is there an "auto save" somewhere? Either a form setting or a "SET" command that I don't know about? Otherwise since this doesn't happen with DB edits, I will probably create a temp table and add it to the form and turn these into DB Edits for the temp table. Karen On Sunday, April 21, 2024 at 08:03:03 PM CDT, Javier Valencia wrote: EDIT USING is the only way I use forms and I don't have issues. What do the variables do? Do you need them after exiting the form?The fact it happens after 30 seconds would appear to indicate there might be a timer that refreshes the form every 30 seconds, and if the variable has not been saved it might reset it to the original, unchanged value.In the old days we used to place a dummy field behind the last variable to provide a landing spot as was mentioned.If the form is doing an auto save, there is a system variable you can check to see if there are pending changes and stop the save and return to the variable field with a message. Javier Valencia, PESent from my T-Mobile 4G LTE Device Original message From: 'jim schmitt' via RBASE-L Date: 4/21/24 6:16 PM (GMT-06:00) To: 'KAREN TELLEF' via RBASE-L Subject: Re: [RBASE-L] - Disappearing text Karen: Another thought..If you are using just variables on a form, the last variable field will need to have another 'dummy field as the form need a 'landing'.for the cursor (even if not used). I do this all the time with variable forms, set up a dummy variable field, that the screen never gets to after the last variable field.. Base your exit or return after the field is entered. Jim On Sunday, April 21, 2024 at 06:11:42 PM EDT, 'KAREN TELLEF' via RBASE-L wrote: Not sure what you mean. The variables are null going into the form. User is required to type something in both variables Karen Sent from my iPhone On Apr 21, 2024, at 4:12 PM, Bruce Chitiea wrote: What happens if you define the variables as Form Variables?Bruce -- Original Message --From "'Karen Tellef' via RBASE-L" To "RBase List" Date 4/21/2024 1:15:36 PMSubject [RBASE-L] - Disappearing text Version 10.5. Client says this happens in a couple forms, but was sporadic. Finally there's a form where the issue is easy to replicate so I have something to work on. Issue: if you type something in a variable edit field and are just sitting in that field, if you wait about 30 seconds the text will disappear. The value of the variable is trul
Re: [RBASE-L] - Disappearing text
Javier: I think you're getting close. Yep, I'm aware of the need of a dummy space to land so that it saves your final entry. So that RBase doesn't think that you've exited the field without wanting to save the value. But a "landing spot" isn't going to help here because if the user is taking a long time to type in the big memo field, it will blank out the field as the person is typing. It isn't based on inactivity. That's why they type outside RBase and copy it into the field. So yeah, it's as if there's an "auto save" somewhere and it thinks I don't want my final value because I haven't moved off the field. But is there such a thing? If so, that's news to me. And remember, it only happens in variable edits, doesn't happen in DB edits. There's no form timer. I don't think there's a form timer anywhere within this application. The 30 seconds is a guess, it can happen earlier than that or later than that (I have waited up to a minute before it happened). There is a SET TIMER in the app, I think set for a couple hours, but RBase isn't exiting in this case. Yes, I need the values in those two variables after I exit the form to be used in an email that will be sent after the form closes. The variable data isn't saved anywhere. So -- is there an "auto save" somewhere? Either a form setting or a "SET" command that I don't know about? Otherwise since this doesn't happen with DB edits, I will probably create a temp table and add it to the form and turn these into DB Edits for the temp table. Karen On Sunday, April 21, 2024 at 08:03:03 PM CDT, Javier Valencia wrote: EDIT USING is the only way I use forms and I don't have issues. What do the variables do? Do you need them after exiting the form?The fact it happens after 30 seconds would appear to indicate there might be a timer that refreshes the form every 30 seconds, and if the variable has not been saved it might reset it to the original, unchanged value.In the old days we used to place a dummy field behind the last variable to provide a landing spot as was mentioned.If the form is doing an auto save, there is a system variable you can check to see if there are pending changes and stop the save and return to the variable field with a message. Javier Valencia, PESent from my T-Mobile 4G LTE Device Original message From: 'jim schmitt' via RBASE-L Date: 4/21/24 6:16 PM (GMT-06:00) To: 'KAREN TELLEF' via RBASE-L Subject: Re: [RBASE-L] - Disappearing text Karen: Another thought..If you are using just variables on a form, the last variable field will need to have another 'dummy field as the form need a 'landing'.for the cursor (even if not used). I do this all the time with variable forms, set up a dummy variable field, that the screen never gets to after the last variable field.. Base your exit or return after the field is entered. Jim On Sunday, April 21, 2024 at 06:11:42 PM EDT, 'KAREN TELLEF' via RBASE-L wrote: Not sure what you mean. The variables are null going into the form. User is required to type something in both variables Karen Sent from my iPhone On Apr 21, 2024, at 4:12 PM, Bruce Chitiea wrote: What happens if you define the variables as Form Variables?Bruce ------ Original Message --From "'Karen Tellef' via RBASE-L" To "RBase List" Date 4/21/2024 1:15:36 PMSubject [RBASE-L] - Disappearing text Version 10.5. Client says this happens in a couple forms, but was sporadic. Finally there's a form where the issue is easy to replicate so I have something to work on. Issue: if you type something in a variable edit field and are just sitting in that field, if you wait about 30 seconds the text will disappear. The value of the variable is truly null when you exit the form. Specifics: 1. Form is based on a table brought up with "edit using" on just one row of data. No processing is done before the form is brought up. Literally one line of code in the main menu option. 2. In addition to table fields I have a variable edit and a variable memo. Both variables are initialized to null on the form's before-start EEP, one is text type and one is note type. 3. The disappearing happens on both of the variable fields. Whether you are on the text edit or the memo edit, they will disappear. Only the one you are on will disappear; if you had entered data in the other variable it sticks around. 4. Entering text into a DB Edit field and sitting on that field will not disappear. 5. Doesn't seem to be a case of memory build-up. If you go into the application and this is the first thing you do, it will happen. Not just at end of day, after another heavy process, etc. Weird, huh? But I can replicate it every time on this one particular form Because they often type long notes into that memo field, and they aren't fast typists, they have been typ
Re: [RBASE-L] - Disappearing text
Not sure what you mean. The variables are null going into the form. User is required to type something in both variables Karen Sent from my iPhone > On Apr 21, 2024, at 4:12 PM, Bruce Chitiea wrote: > > > What happens if you define the variables as Form Variables? > Bruce > > > -- Original Message -- > From "'Karen Tellef' via RBASE-L" > To "RBase List" > Date 4/21/2024 1:15:36 PM > Subject [RBASE-L] - Disappearing text > >> Version 10.5. Client says this happens in a couple forms, but was sporadic. >> Finally there's a form where the issue is easy to replicate so I have >> something to work on. >> >> Issue: if you type something in a variable edit field and are just sitting >> in that field, if you wait about 30 seconds the text will disappear. The >> value of the variable is truly null when you exit the form. >> >> Specifics: >> >> 1. Form is based on a table brought up with "edit using" on just one row of >> data. No processing is done before the form is brought up. Literally one >> line of code in the main menu option. >> >> 2. In addition to table fields I have a variable edit and a variable memo. >> Both variables are initialized to null on the form's before-start EEP, one >> is text type and one is note type. >> >> 3. The disappearing happens on both of the variable fields. Whether you >> are on the text edit or the memo edit, they will disappear. Only the one >> you are on will disappear; if you had entered data in the other variable it >> sticks around. >> >> 4. Entering text into a DB Edit field and sitting on that field will not >> disappear. >> >> 5. Doesn't seem to be a case of memory build-up. If you go into the >> application and this is the first thing you do, it will happen. Not just at >> end of day, after another heavy process, etc. >> >> >> Weird, huh? But I can replicate it every time on this one particular form >> >> Because they often type long notes into that memo field, and they aren't >> fast typists, they have been typing the notes in Word and then copy/paste >> into the field and move off the field asap. >> >> >> Karen >> >> >> >> >> >> >> >> > > -- > 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. > To view this discussion on the web visit > https://groups.google.com/d/msgid/rbase-l/1125847848.1573463.1713730536856%40mail.yahoo.com. > -- > 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. > To view this discussion on the web visit > https://groups.google.com/d/msgid/rbase-l/em097f0a0e-37fb-4a3f-a48f-a3609151e292%40a5dc929d.com. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/47AC857F-1571-4A5A-88C6-B192FF5FD4CA%40cs.com.
[RBASE-L] - Disappearing text
Version 10.5. Client says this happens in a couple forms, but was sporadic. Finally there's a form where the issue is easy to replicate so I have something to work on. Issue: if you type something in a variable edit field and are just sitting in that field, if you wait about 30 seconds the text will disappear. The value of the variable is truly null when you exit the form. Specifics: 1. Form is based on a table brought up with "edit using" on just one row of data. No processing is done before the form is brought up. Literally one line of code in the main menu option. 2. In addition to table fields I have a variable edit and a variable memo. Both variables are initialized to null on the form's before-start EEP, one is text type and one is note type. 3. The disappearing happens on both of the variable fields. Whether you are on the text edit or the memo edit, they will disappear. Only the one you are on will disappear; if you had entered data in the other variable it sticks around. 4. Entering text into a DB Edit field and sitting on that field will not disappear. 5. Doesn't seem to be a case of memory build-up. If you go into the application and this is the first thing you do, it will happen. Not just at end of day, after another heavy process, etc. Weird, huh? But I can replicate it every time on this one particular form Because they often type long notes into that memo field, and they aren't fast typists, they have been typing the notes in Word and then copy/paste into the field and move off the field asap. Karen -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/1125847848.1573463.1713730536856%40mail.yahoo.com.
Re: [RBASE-L] - CVAL CONNECTIONS
What I've noticed (within my non-network-understanding limits) is that the
connections don't necessarily decrease when they exit RBase, but rather when
they log out of the network. It seems the network thinks they have RBase
connections still open, but not RBase itself.
Karen
On Tuesday, April 2, 2024 at 04:10:45 PM CDT, 'jim schmitt' via RBASE-L
wrote:
Hello, group:
i am using cval('connections') in a backup routine to test and insure that all
users are out of the system before starting the backup.
Some of my users appear to have more connections than they have computers.One
user who has 1 three user network had 26 connections. Does the connections get
reduced as each user exits ?
Just wondering what most of you are using to insure that all users are out of
the database before performing a backup.
Any enlightenment would be helpful.
Thanks, jim1-614-361-3942
--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/920496374.4843463.1712092238259%40mail.yahoo.com.
--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/1711672630.3821035.1712092984286%40mail.yahoo.com.
Re: Re[4]: [RBASE-L] - Forms | Accessing a DBcontrol value BEFORE it is saved. | Fail
Your syntax for 'SET VAR vtest_func_textvalue' is incorrect. That will never
work. You don't use "set var" with a "getproperty"
I use the getproperty often and don't have an issue. Brought up one of my apps
and I see that I've done it a couple different ways and apparently both of them
work! But I don't think I've ever used on a date/time edit
SET VAR fTOldQty TEXT = NULL
GETPROPERTY units TEXT 'fTOldQty'
SET VAR vText TEXT = NULL
GETPROPERTY NoUnitsSell TEXTVALUE vText
Karen
On Sunday, March 24, 2024 at 01:04:55 PM CDT, Bruce Chitiea
wrote:
Thank you for your response yesterday.
After focused repeated testing, I am unable to "get" a property value from an
RBG11 DB Date and Time Edit control into a target TEXT variable. Stripped to
its essence, in a bound form:
Within EEPs On Before Design and On Before Start: SET VAR
vtest_open_TEXTVALUE TEXT = NULL SET VAR vtest_func_TEXTVALUE TEXT = NULL
RETURN
DB Date and Time Edit control named: cid_dbdte_eventDate
On Exit EEP of cid_dbdte_eventDate: GETPROPERTY cid_dbdte_eventDate
TEXTVALUE 'vtest_open_TEXTVALUE' SET VAR vtest_func_TEXTVALUE =
(GETPROPERTY('cid_dbdte_eventDate','TEXTVALUE')) RECALC VARIABLES RETURN
Results:
Usually, I'm missing something screamingly obvious. What am I not getting?
Best, Bruce
Bruce A. ChitieaSafeSectors, Inc.1142 S Diamond Bar Blvd # 442Diamond Bar CA
91765-2203
rby...@safesectors.com (909) 238-9012 m
-- Original Message --From "Razzak Memon" To
rbase-l@googlegroups.com; "Bruce Chitiea" Date
3/23/2024 12:26:28 PMSubject Re: Re[2]: [RBASE-L] - Forms | Accessing a
DBcontrol value BEFORE it is saved.
Bruce, It is the TEXTVALUE that will provide the current value.
Here's how: GETPROPERTY TEXTVALUE 'varname' Have
fun! Very Best R:egards, Razzak
On 03/23/2024 1:19 PM EDT Bruce Chitiea wrote:
Thank you, Razzak. An elegant solution, to be sure. Comes the
question: "Which PROPERTY holds the the control's current value? Despite
extensive testing, I seem incapable of finding it. (Note: I continued
working yesterday within a variable form to keep momentum, and have the same
issue.) So I've experimented with a number of possible PROPERTY
names for a Variable Date and Time Edit control in both GETPROPERTY structures.
These have been placed alternately in the On Exit EEP of the VDTE control, and
the On Entry EEP of the following control. (Courier New font,
below) Within On Before Design and On Before Start EEPs: SET VAR
vtest TEXT = NULL SET VAR vdate DATE = NULL Tested, as noted above:
SET VAR vtest = (GETPROPERTY('cid_vdte_date','VALUE')) .. returns no value
SET VAR vtest = (GETPROPERTY('cid_vdte_date','VARNAME'))
returns string 'vdate' SET VAR vtest =
(GETPROPERTY('cid_vdte_date','AUTOSELECT')) . returns no value
GETPROPERTY cid_vdte_date VALUE 'vtest' .. returns no value
GETPROPERTY cid_vdte_date VARNAME 'vtest' returns string 'vdate'
GETPROPERTY cid_vdte_date AUTOSELECT 'vtest' . returns no value
Note that neither 'VALUE' nor 'VARNAME' are listed PROPERTYs within R:Docs for
either the Variable or DB version of the control (implying undocumented
properties. ) AUTOSELECT is of interest because R:Docs reports that it
"Specifies the data within the field will be selected, when the focus lands on
it." Presumably, focus lands when the date is clicked upon. Clearly, I'm
missing something screamingly obvious. What am I missing? Thank you,
Bruce Bruce A. Chitiea SafeSectors, Inc. 1142 S Diamond Bar Blvd #
442 Diamond Bar CA 91765-2203 rby...@safesectors.com (909) 238-9012
m
-- Original Message -- From "Razzak Memon"
To rbase-l@googlegroups.com; "Bruce Chitiea"Date
3/23/2024 1:24:25 AM Subject Re: [RBASE-L] - Forms | Accessing a DBcontrol
value BEFORE it is saved.
Bruce, Consider using the GETPROPERTY command to capture the control's
current value in a variable. Then, use that captured variable to extract
anything you see fit. That is as simple as it gets. Razzak
On 03/22/2024 6:32 PM EDT Bruce Chitiea wrote:
RBG11 Bound form. Is it possible to access a value just entered
into a DB control for processing, BEFORE the record being entered is saved to
the table? For instance, once a date value is selected from a DB Date
Time Edit control, how might one grab the year to a variable within the
control's On Exit EEP like: SET VAR vYear = (IYR4(selectedDate)) {for use
in constructing a down-stream value } I mean, the selectedDate value
hasn't yet been entered to a table ... and it's not a variable, so ... what
would I target? Thanks much
--
For group guidelines, visit
Re: Re[2]: [RBASE-L] - Forms | Accessing a DBcontrol value BEFORE it is saved.
Your syntax is wrong. It would be something like this:
GETPROPERTY Sum1BalCurr VALUE vTBalCurr
The "vTBalCurr" would be the variable that gets the value of the cell with that
componentID.
Karen
On Saturday, March 23, 2024 at 12:19:59 PM CDT, Bruce Chitiea
wrote:
Thank you, Razzak. An elegant solution, to be sure.
Comes the question: "Which PROPERTY holds the the control's current value?
Despite extensive testing, I seem incapable of finding it.
(Note: I continued working yesterday within a variable form to keep momentum,
and have the same issue.)
So I've experimented with a number of possible PROPERTY names for a Variable
Date and Time Edit control in both GETPROPERTY structures. These have been
placed alternately in the On Exit EEP of the VDTE control, and the On Entry EEP
of the following control.
(Courier New font, below)
Within On Before Design and On Before Start EEPs:SET VAR vtest TEXT = NULLSET
VAR vdate DATE = NULL
Tested, as noted above:SET VAR vtest = (GETPROPERTY('cid_vdte_date','VALUE'))
.. returns no valueSET VAR vtest = (GETPROPERTY('cid_vdte_date','VARNAME'))
returns string 'vdate'SET VAR vtest =
(GETPROPERTY('cid_vdte_date','AUTOSELECT')) . returns no value
GETPROPERTY cid_vdte_date VALUE 'vtest' .. returns no valueGETPROPERTY
cid_vdte_date VARNAME 'vtest' returns string 'vdate'GETPROPERTY
cid_vdte_date AUTOSELECT 'vtest' . returns no value
Note that neither 'VALUE' nor 'VARNAME' are listed PROPERTYs within R:Docs for
either the Variable or DB version of the control (implying undocumented
properties. ) AUTOSELECT is of interest because R:Docs reports that it
"Specifies the data within the field will be selected, when the focus lands on
it." Presumably, focus lands when the date is clicked upon.
Clearly, I'm missing something screamingly obvious. What am I missing?
Thank you, Bruce
Bruce A. ChitieaSafeSectors, Inc.1142 S Diamond Bar Blvd # 442Diamond Bar CA
91765-2203
rby...@safesectors.com (909) 238-9012 m
-- Original Message --From "Razzak Memon" To
rbase-l@googlegroups.com; "Bruce Chitiea" Date
3/23/2024 1:24:25 AMSubject Re: [RBASE-L] - Forms | Accessing a DBcontrol value
BEFORE it is saved.
Bruce, Consider using the GETPROPERTY command to capture the control's
current value in a variable. Then, use that captured variable to extract
anything you see fit. That is as simple as it gets. Razzak
On 03/22/2024 6:32 PM EDT Bruce Chitiea wrote:
RBG11 Bound form. Is it possible to access a value just entered
into a DB control for processing, BEFORE the record being entered is saved to
the table? For instance, once a date value is selected from a DB Date
Time Edit control, how might one grab the year to a variable within the
control's On Exit EEP like: SET VAR vYear = (IYR4(selectedDate)) {for use
in constructing a down-stream value } I mean, the selectedDate value
hasn't yet been entered to a table ... and it's not a variable, so ... what
would I target? Thanks much
--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/emc84fa026-5a10-453c-9f26-52e32366e449%40a4e8a7e3.com.
--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/976935309.5530528.1711182265965%40email.ionos.com.
--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/emb34e8309-8ef0-4ed0-9e3f-b98b631ea681%40a4e8a7e3.com.
--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/384479626.588044.1711221492813%40mail.yahoo.com.
Re: [EXTERNAL] Re: [RBASE-L] - mystery character
It's strange but a while ago I did a copy and paste of code from somewhere to keep in my notes to reuse, but the "apostrophe" that came over wasn't the "real" apostrophe so it wasn't recognizing all my OPTION parameters. Took me a long time to figure out why all my Gateway Export options weren't evaluating! It was only when I retyped the thing manually that I figured out the "apostrophe" was a weird character altho it looked okay to me Karen On Wednesday, January 17, 2024 at 02:03:21 PM CST, 'Dan Goldberg' via RBASE-L wrote: Thx it is some strange apostrophe that is not on my keyboard. Gunna see if I can just remove it from the fields. Dan Goldberg From: 'Karen Tellef' via RBASE-L Sent: Wednesday, January 17, 2024 10:46 AM To: rbase-l@googlegroups.com Subject: [EXTERNAL] Re: [RBASE-L] - mystery character Dan: I remember having to do this once. Bring one of the records up on the edit form, where you see the "real" character". Carefully copy just the one character. Then do a SRPL on that column. For the first value, paste in what you copied, and replace it with a normal apostrophe Karen On Wednesday, January 17, 2024 at 12:38:23 PM CST, Bruce Chitiea wrote: Dan: Happy-at-the-limit-New-Year: I presume that the data displayed in the Parts Master - View Mode is pulled directly from its source table, and that the " ' " character is otherwise your default for encapsulating text strings within code. I've seen this sort of weird formatting show up when pulling HTML data into non-HTML text columns. The alpha-numerics display correctly, but punctuations look look like something from the Planet Zog style manual. Guessing that what's happening here is similar: a formatting mis-match resulting from a search routine which can't handle an apostrophe embedded within an expected result. I'd look to see that the search code can handle an apostrophe orphaned within a returned text string. Can you use a different character (e.g. a " - ") in its place, and see what happens? Best, Bruce Bruce A. Chitiea SafeSectors, Inc. 1142 S Diamond Bar Blvd # 442 Diamond Bar CA 91765-2203 rby...@safesectors.com (909) 238-9012 m -- Original Message -- >From "'Dan Goldberg' via RBASE-L" To "rbase-l@googlegroups.com" Date 1/17/2024 7:34:07 AM Subject [RBASE-L] - mystery character I have a character that looks ok in db edits but not in enhanced db grids. I have played with the fonts thinking the font does not like the character but no help. Anyone ran across this before? TIA Dan Goldberg -- 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 torbase-l+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/BY3PR19MB5027DF37B80B6FCFFD6DD145D4722%40BY3PR19MB5027.namprd19.prod.outlook.com. -- 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 torbase-l+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/em1137183b-0900-4b24-953a-619a10beca22%40b30f3d59.com . -- 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 torbase-l+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/1441067067.13863.1705517176996%40mail.yahoo.com. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/BY3PR19MB5027F5C0A7EA557F4E77BAA7D4722%40BY3PR19MB5027.namprd19.prod.outlook.com. -- 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, s
Re: [RBASE-L] - mystery character
Dan: I remember having to do this once. Bring one of the records up on the edit form, where you see the "real" character". Carefully copy just the one character. Then do a SRPL on that column. For the first value, paste in what you copied, and replace it with a normal apostrophe Karen On Wednesday, January 17, 2024 at 12:38:23 PM CST, Bruce Chitiea wrote: Dan: Happy-at-the-limit-New-Year: I presume that the data displayed in the Parts Master - View Mode is pulled directly from its source table, and that the " ' " character is otherwise your default for encapsulating text strings within code. I've seen this sort of weird formatting show up when pulling HTML data into non-HTML text columns. The alpha-numerics display correctly, but punctuations look look like something from the Planet Zog style manual. Guessing that what's happening here is similar: a formatting mis-match resulting from a search routine which can't handle an apostrophe embedded within an expected result. I'd look to see that the search code can handle an apostrophe orphaned within a returned text string. Can you use a different character (e.g. a " - ") in its place, and see what happens? Best, Bruce Bruce A. ChitieaSafeSectors, Inc.1142 S Diamond Bar Blvd # 442Diamond Bar CA 91765-2203 rby...@safesectors.com (909) 238-9012 m -- Original Message --From "'Dan Goldberg' via RBASE-L" To "rbase-l@googlegroups.com" Date 1/17/2024 7:34:07 AMSubject [RBASE-L] - mystery character I have a character that looks ok in db edits but not in enhanced db grids. I have played with the fonts thinking the font does not like the character but no help. Anyone ran across this before? TIA Dan Goldberg -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/BY3PR19MB5027DF37B80B6FCFFD6DD145D4722%40BY3PR19MB5027.namprd19.prod.outlook.com. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/em1137183b-0900-4b24-953a-619a10beca22%40b30f3d59.com. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/1441067067.13863.1705517176996%40mail.yahoo.com.
Re: [RBASE-L] - Know when data has been changed in a row of data in a table.
I would use the table's "on save eep". If the EEP is triggered, then you know the user made some kind of change. In the EEP you would then write the name/date to the columns. Karen On Sunday, December 3, 2023 at 09:25:44 AM CST, wrote: Subject: Know when data has been changed in a row of data in a table. Background: - Using a form to enter or change data that is in a row in a table. - The application has code in place to record who is logged into the system. - When exiting, with or without data changes to the row of data, the form has code in the exit button that uses an update command to take the logged in username and update the column in the row of data ‘last updated by’. - Goal: only do that update if the data has actually been changed. R:Base has a way to check if data has been changed in a row of data when a table is opened and a column in a row has been changed. The save button on the bottom of the screen (the check mark) changes from grey to a color. Is there a way to know, using code, if the data in a row in a table has changed? This would allow control over the update statement on exit. Thanks in advance. Myron Finegold -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/012801da25fc%24f9748400%24ec5d8c00%24%40gmail.com. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/4815976.710615.1701635231999%40mail.yahoo.com.
Re: [RBASE-L] - email novice problems
Here's a copy of code that runs fine every day (all data is sent in by variables). Perhaps compare to your code and see what the differences are? It's been a long time since I've messed with this code; we embedded the host/port/authentication within the print itself for some reason rather than doing the settings. We store the settings within a table. I think it was just for ease rather than remembering to do report email settings with new RBase installs Karen PRINT invemail WHERE billdate = .#DATE OPTION PDF|FILENAME + |EMAIL ON + |EMAIL_AUTHENTICATION OFF + |EMAIL_HOST + |EMAIL_PORT 25 + |EMAIL_USERID + |EMAIL_PASSWORD + |EMAIL_TO_LIST + |EMAIL_FROM_NAME Boston Division + |EMAIL_FROM_ADDRESS + |EMAIL_SUBJECT + |EMAIL_BODY + |EMAIL_DELETE_AFTER_SEND ON + |EMAIL_SHOW_DIALOG OFF On Friday, November 10, 2023 at 04:52:49 PM CST, 'jim schmitt' via RBASE-L wrote: Greeting fellow R:base users: You may be able to offer some blues clues for me.This is my first attempt at trying to send a report via email: Using RB Version X5E 10.5.4 20646 Tried using Razzak's sample in RRBYW20 - code listed below: PRINT Invoice WHERE TransID = 1031 +OPTION PDF|FILENAME Invoice_1031.PDF +|EMAIL ON +|EMAIL_TO_LIST jim.schm...@yahoo.com +|EMAIL_FROM_NAME John D. Johnson +|EMAIL_FROM_ADDRESS jim.schm...@yahoo.com +|EMAIL_SUBJECT Imagine The Possibilities! +|EMAIL_BODY Attached is the invoice - sent via R:BASE. Because we Can! +|EMAIL_DELETE_AFTER_SEND ON +|EMAIL_SHOW_DIALOG ONreturn If I try it with just the first two lines, it works and creates the PDF file which I can see..With the email options, I get nothing ??Just can't see what I am missing.any help would be appreciated. The report email settings listed below: Thanks in advance.Jim -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/1074275864.2200889.1699656760734%40mail.yahoo.com. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/2067692558.1858400.1699710651612%40mail.yahoo.com.
Re: [RBASE-L] - Where do I set my Vars?
Welcome to the not-so-wonderful world of the "REAL" datatype. Long ago in DOS days that was the only datatype (other than currency) that allowed decimals. Unfortunately it isn't real accurate IMO (pun intended). Most of us switched all those Real numbers to the DOUBLE datatype. With Double, a 104.31 is always stored and displayed exactly as 104.31. With Real, internally that number may be stored as something like 104.309187983. So depending on your display formatting, you could get different representations to the screen. Looks like the 000.## type of formatting might be truncating. In my example, it would display as 104.30 or 104.309 even tho the number is actually 104.31. Someone else suggested using the ROUND function if you know how many decimal places you want displayed. Karen On Wednesday, November 8, 2023 at 01:47:25 PM CST, lin...@gmail.com wrote: Hello Razzak, Thank you - that is what I was looking for. I knew there was a simple solution. I am getting a strange output though: the real number stored is 104.31 000.## prints as 104.30 000.### prints as 104.309 This is an unusual situation where the number stored could possibly be 4 numbers to the left of the decimal and 3 to the right (we have never had more than 2 to the right) thanks for the help! Lin On Tuesday, November 7, 2023 at 7:57:30 PM UTC-8 Razzak Memon wrote: Lin, Here's how ... Please take a look at the attached illustration. - Open the report in Report Designer - Right-click on the Variable Object and select Display Format - Under the Display Format option change the Display Format to 0.000 - Click on the [OK] button to save the Display Format - Click on the [Preview] Tab to preview while still in Report Designer - Save the report and close the Report Designer That's all there is to it! I hope it helps! Very Best Regards, Razzak On 11/07/2023 8:53 PM EST Lin MacDonald wrote: This will sound silly, but I am working on a system that I wrote several years ago, but can't remember most of what I wrote! I have a report that prints a Var (type: Real) It is now printing it with 7 places after the decimal point. I need it to print a max of 3 places. Where do I set the number of places? I honestly can't rmemeber! Lin -- 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+u...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/1c446867-f6d4-49b8-adc4-3252ed914b4b%40app.fastmail.com. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/c065ed53-23d4-4581-baa4-11a2e5034242n%40googlegroups.com. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/1942164164.930636.1699476193291%40mail.yahoo.com.
Re: [RBASE-L] - I want to use a CHOOSE command to list options from a subdirectory rather than from inside a connected database.
Awesome! You gave me an idea to explore for something similar I need to do Karen On Monday, November 6, 2023 at 03:45:28 AM CST, randyp ctags.com wrote: Dear Karen, I found CHOOSE in help but didn't recognize the usage for its #Lfiles option. My RMD files are located in this subdirectory: C:\RBTI\RBGX5E\Samples\ CHOOSE vaRbase FROM #LFILES IN c:\rbti\rbgx5e\samples\*.rmd RUN .vaRbase This CHOOSE generates a lovely, alphabetical listing of available database opening commands.The RUN command, connects and opens the applicable database [represented by the .varbase variable—RMD program name-- selected.]. more complete program- CHOOSE varbase FROM #LFILES IN c:\rbti\rbgx5e\samples\*.rmd + TITLE 'databases available' +CAPTION 'select a database' +LINES 8 IF varbase IS NULL OR varbase = '[Esc]' THEN GOTO doneELSE RUN .varbase ENDIF LABEL done CLEAR VAR varbase RETURN -- In c:\rbti\rbgx5e\samples, I created an RBase.DAT file to open when the program begins. My CHOOSE box opens in the center of my windows desktop. Clean. Simple. RUN c:\rbti\rbgx5e\samples\varbase.cmd The combination of the STARTUP RBase.DAT file which shows a choose box is perfect—so easy. In order to work, all these related files must be in the same c:\rbti\rbgx5e\samples subdirectory. Thank you for all your valuable suggestions. RandyFrom: 'Karen Tellef' via RBASE-L Sent: Sunday, November 5, 2023 8:05 AM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - I want to use a CHOOSE command to list options from a subdirectory rather than from inside a connected database. Are you looking for the syntax for a choose command? If so:choose vchoice from #Lfiles in *.rmd For clients that have multiple databases, there's typically separate desktop icons that open that database's startup file Karen On Sunday, November 5, 2023 at 01:36:32 AM CST, randyp ctags.com wrote: I have multiple RMD files in the same subdirectory that basically say: Change directory to the directory where my desired database is located. OPEN this database. I would like a choose command that lists all my files ending in .RMD. That way I can select the RMD file, and use: RUN name.RMD which will take me into the correct subdirectory, and open the database. Do users with multiple databases have a desktop icon for each database, or how do you navigate from among them? All the best, Randy -- 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 torbase-l+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/PH0PR11MB51125E2C95370DCD569610F7C7ABA%40PH0PR11MB5112.namprd11.prod.outlook.com. -- 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 torbase-l+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/881986198.341027.1699193144565%40mail.yahoo.com. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/PH0PR11MB5112655778B6688FB7EA7E8CC7AAA%40PH0PR11MB5112.namprd11.prod.outlook.com. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/1279929094.612444.1699278661227%40mail.yahoo.com.
Re: [RBASE-L] - I want to use a CHOOSE command to list options from a subdirectory rather than from inside a connected database.
Are you looking for the syntax for a choose command? If so:choose vchoice from #Lfiles in *.rmd For clients that have multiple databases, there's typically separate desktop icons that open that database's startup file Karen On Sunday, November 5, 2023 at 01:36:32 AM CST, randyp ctags.com wrote: I have multiple RMD files in the same subdirectory that basically say: Change directory to the directory where my desired database is located. OPEN this database. I would like a choose command that lists all my files ending in .RMD. That way I can select the RMD file, and use: RUN name.RMD which will take me into the correct subdirectory, and open the database. Do users with multiple databases have a desktop icon for each database, or how do you navigate from among them? All the best, Randy -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/PH0PR11MB51125E2C95370DCD569610F7C7ABA%40PH0PR11MB5112.namprd11.prod.outlook.com. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/881986198.341027.1699193144565%40mail.yahoo.com.
Re: [RBASE-L] - Looking for developers to convert old dos based application to current R:Base - Windows.
You should take this conversation private! Karen Sent from my iPhone > On Oct 22, 2023, at 11:34 AM, fjfis...@fishercg.com wrote: > > > Thank you for your reply. I'm interested in chatting further with you, and > would be happy to supply you with what I have. Are you amenable to signing a > nondisclosure agreement? It's barely over a page long, and basically means > you can't discuss the project with anyone I don't authorize, as well as > assigning any and all work for hire copyrights to me, my company, or another > designee as I may foreman a different company in the future. Hope you don't > mind, but in fact these are actually fairly standard for work for hire > agreements. Please let me know and I'll send the agreement out to you for > your review and hopefully her signature. I look forward to work with you on > this project and thank you for your response. > > Regards, > > Frederick J . Fisher, J.D., CCP > President > Fisher Consulting Group Inc. > 214 Main Street #181 > El Segundo, CA 90245 > d. 310 426 2105 > c. 310-413-6200 > f. 310-356-3355 > Skype: (213) 457-3165 > www.fishercg.com > > > From: rbase-l@googlegroups.com On Behalf Of Rich > Sent: Thursday, October 19, 2023 4:26 PM > To: rbase-l@googlegroups.com > Subject: Re: [RBASE-L] - Looking for developers to convert old dos based > application to current R:Base - Windows. > > I can help. > Rich Jasinski > r...@ogdengroup.com > 585-755-0368 > > Sent from my iPhone > > > On Oct 19, 2023, at 7:20 PM, fjfis...@fishercg.com wrote: > > > I currently need help from an R: base programmer/Developer. Many years ago, > my company was using R:base for DOS. My company developed several insurance > related systems. One was a claim tracking and reserve tracking system capable > of producing audit trail reports per claim for losses, expenses and payments. > In addition, we also created a time and expense billing system unique for > claim adjusters in that, unlike law firm billing systems, adjusters had > other billable items that required special programming unique to that > industry. The system would also generate aged receivable reports on bills > that had not yet been paid, unbilled work in progress reports etc. > > These were never part ported over into the Windows environment, as > eventually, my company moved from handling claims, to opening an insurance > brokerage. Thus, all continued developing projects got tabled. > > The applications themselves were compiled using the R:base compiler which > originally had been created by former Microrim employees. I don't know if > this can be reversed engineered. In any event, I do have data files and > possibly the. APP files as well. > > I’m looking for someone who can re-create these in the current R:base and > window environment. > > Because these are DOS-based systems, they don't currently run on my computer > but I understand that there is a another program that can be obtained that > would allow these to run. Any assistance or advice will be greatly > appreciated. > > > > > Regards, > > Frederick J . Fisher, J.D., CCP > President > Fisher Consulting Group Inc. > 214 Main Street #181 > El Segundo, CA 90245 > d. 310 426 2105 > c. 310-413-6200 > f. 310-356-3355 > Skype: (213) 457-3165 > www.fishercg.com > fjfis...@fishercg.com > > -- > 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. > To view this discussion on the web visit > https://groups.google.com/d/msgid/rbase-l/089201da02e2%24d8b05470%248a10fd50%24%40fishercg.com. > -- > 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. > To view this discussion on the web visit > https://groups.google.com/d/msgid/rbase-l/35410BB6-E6A2-4D7E-994B-E0F1B75E6564%40ogdengroup.com. > -- > 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. > To view this discussion on the web visit > https://groups.google.com/d/msgid/rbase-l/173001da0505%24a7395a20%24f5ac0e60%24%40fishercg.com. -- 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
Re: [RBASE-L] - Getting out of an infinite loop
If you cannot connect the database single-user as Razzak suggests, trying ending the RBase session and then restarting your computer or just logging off. Often the computer shutdown sequence will clear the files that you have "open" even tho they really aren't Karen On Sunday, August 13, 2023 at 08:49:15 PM CDT, 'Philippe Gosselin' via RBASE-L wrote: Hi, Can you tell me how to get out of an infinite loop or a process that’s taking too much time? Right now, I end the task using windows. The problem is that when I re-enter R:Base, a new user is added. How do I reset the number of users? Thanks, Philippe p...@canl.nc BP 3899 - 98846 Noumea – New Caledonia Tel : +687 27.62.23 / Mobile : +687 77.15.76 -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/01d9ce51%241e700170%245b500450%24%40canl.nc. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/231217270.632271.1692021420430%40mail.yahoo.com.
Re: [RBASE-L] - Report Header Bands | Failure to collapse for NULL data
Try replacing your DBText fields with DBMemos and mark each memo "stretch". I have notes that at one time I had to do that to suppress the blank space Karen On Wednesday, August 2, 2023 at 02:11:35 PM CDT, Bruce Chitiea wrote: All: While generating a five-digit Chart of Accounts report, several Break Header bands (defined on data values 'glCode1 ... glCode5') fail to "collapse" when header data values are NULL: Dynamically-sized Break Header bands H0, H1 and H2 contain only DBText fields, aligning vertically as desired. Dynamically-sized Break Header bands H3 and H4 contain Regions where we want NULL-valued records to collapse. The H3 band contains the Before Generate EEP IF vglCode4 IS NULL THEN PROPERTY cid_region_h3 VISIBLE 'FALSE' ELSE PROPERTY cid_region_h3 VISIBLE 'TRUE' ENDIF RETURN The H4 band contains the Before Generate EEP IF vglCode5 IS NULL THEN PROPERTY cid_region_h4 VISIBLE 'FALSE' ELSE PROPERTY cid_region_h4 VISIBLE 'TRUE' ENDIF RETURN ... based on Report variables: Report: household_chartOfAccounts_level_5 1 : TEXT : H3 : vglCode4 = (glCode4) 2 : TEXT : H4 : vglCode5 = (glCode5) I find no reference to anything approximating a Region or Band "collapse" PROPERTY. I've monkeyed around with various Shift and Stretch properties, to no effect. Any thoughts / pointers MUCH appreciated! -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/em162e450d-6d8d-47e8-90b9-b45d62015b03%40fd7d3b70.com. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/1097136547.988820.1691003927776%40mail.yahoo.com.
Re: SV: [RBASE-L] - Second ORDER BY parameter?
Just a case of not seeing the forest for the trees!! Hope all is well with you Karen -Original Message- From: 'Bo Franzén' via RBASE-L To: rbase-l@googlegroups.com Sent: Thu, Jun 22, 2023 11:11 am Subject: SV: [RBASE-L] - Second ORDER BY parameter? Karen, exactly! I blush, it worked, it was as simple as that. Many thanks.Bo Franzén Från: 'Karen Tellef' via RBASE-L Skickat: den 22 juni 2023 17:53:43 Till: rbase-l@googlegroups.com Ämne: Re: [RBASE-L] - Second ORDER BY parameter? Sorry Bo, I'm probably not understanding. Are you asking if you can sort by two columns? Like: ORDER BY commodity ASC, tran_id ASC Karen -Original Message- From: 'Bo Franzén' via RBASE-L To: R:BASE Sent: Thu, Jun 22, 2023 10:47 am Subject: [RBASE-L] - Second ORDER BY parameter? Dear R:BASE, I have a coming printed volume with ca 8000 rows with Medieval Swedish commodity prices in (of course) R:BASE. The rows are originally in Swedish alphabetical order and every commodity are sorted in chronological order. All thanks to a unique key, tran_id, where the lower tran_id the older a price. My scholar colleagues in this long time-consuming project suddenly wanted the volume to be published in English, so I added columns for that translation. Only a few goods have the same name and spelling in Swedish and English and the publisher want an export i excel in English alphabetical order. Said and done, R>... ORDER BY commodity ASC. To exemplify below with selected columns: almond comes in the beginning of my export in English. But when the data is being exported the chronological order is "forgotten". This is no cow on the ice, as we say in Sweden, because it can be fixed in excel by going through commodity after commodity. Just want to check if there is an SQL way of ORDER BY first and second? I wish the whole R:BASE society A HAPPY MIDSUMMER! Bo FranzénDepartment of Economic HistoryStockholm University | tran_id | year | vara | commodity | numeral | enhet | price öre | | 39301 | 1470 | mandel | almond | markpound | markpund | 0,66 | | 39291 | 1468 | mandel | almond | markpound | markpund | 0,66 | | 39321 | 1473 | mandel | almond | markpound | markpund | 1,00 | | 39341 | 1503 | mandel | almond | pound | pund | 20,00 | | 39351 | 1511 | mandel | almond | pound | skålpund | 2,66 | | 39311 | 1472 | mandel | almond | markpound | markpund | 1,33 | | 39281 | 1465 | mandel | almond | markpound | markpund | 1,33 | | 39251 | 1463 | mandel | almond | markpound | markpund | 2,66 | | 39261 | 1463 | mandel | almond | pound | pund | 8,00 | | 39231 | 1328 | mandel | almond | pound | skålpund | 0,60 | | 39241 | 1462 | mandel | almond | markpound | markpund | 0,83 | | 39361 | 1513 | mandel | almond | pound | skålpund | 1,00 | | 39371 | 1515 | mandel | almond | pound | pund | 2,33 | | 39271 | 1464 | mandel | almond | markpound | markpund | 1,00 | | | | | | | | | | | | -- 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 torbase-l+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/38fed557dacc449390804213ebc16c44%40ekohist.su.se. -- 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 torbase-l+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/844702668.2792824.1687449223967%40mail.yahoo.com. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/4a3b6f6a2a374264a594abc054fce30d%40ekohist.su.se. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/376989207.2824896.1687455493875%40mail.yahoo.com.
Re: [RBASE-L] - Second ORDER BY parameter?
Sorry Bo, I'm probably not understanding. Are you asking if you can sort by two columns? Like: ORDER BY commodity ASC, tran_id ASC Karen -Original Message- From: 'Bo Franzén' via RBASE-L To: R:BASE Sent: Thu, Jun 22, 2023 10:47 am Subject: [RBASE-L] - Second ORDER BY parameter? Dear R:BASE, I have a coming printed volume with ca 8000 rows with Medieval Swedish commodity prices in (of course) R:BASE. The rows are originally in Swedish alphabetical order and every commodity are sorted in chronological order. All thanks to a unique key, tran_id, where the lower tran_id the older a price. My scholar colleagues in this long time-consuming project suddenly wanted the volume to be published in English, so I added columns for that translation. Only a few goods have the same name and spelling in Swedish and English and the publisher want an export i excel in English alphabetical order. Said and done, R>... ORDER BY commodity ASC. To exemplify below with selected columns: almond comes in the beginning of my export in English. But when the data is being exported the chronological order is "forgotten". This is no cow on the ice, as we say in Sweden, because it can be fixed in excel by going through commodity after commodity. Just want to check if there is an SQL way of ORDER BY first and second? I wish the whole R:BASE society A HAPPY MIDSUMMER! Bo FranzénDepartment of Economic HistoryStockholm University | tran_id | year | vara | commodity | numeral | enhet | price öre | | 39301 | 1470 | mandel | almond | markpound | markpund | 0,66 | | 39291 | 1468 | mandel | almond | markpound | markpund | 0,66 | | 39321 | 1473 | mandel | almond | markpound | markpund | 1,00 | | 39341 | 1503 | mandel | almond | pound | pund | 20,00 | | 39351 | 1511 | mandel | almond | pound | skålpund | 2,66 | | 39311 | 1472 | mandel | almond | markpound | markpund | 1,33 | | 39281 | 1465 | mandel | almond | markpound | markpund | 1,33 | | 39251 | 1463 | mandel | almond | markpound | markpund | 2,66 | | 39261 | 1463 | mandel | almond | pound | pund | 8,00 | | 39231 | 1328 | mandel | almond | pound | skålpund | 0,60 | | 39241 | 1462 | mandel | almond | markpound | markpund | 0,83 | | 39361 | 1513 | mandel | almond | pound | skålpund | 1,00 | | 39371 | 1515 | mandel | almond | pound | pund | 2,33 | | 39271 | 1464 | mandel | almond | markpound | markpund | 1,00 | | | | | | | | | | | | -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/38fed557dacc449390804213ebc16c44%40ekohist.su.se. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/844702668.2792824.1687449223967%40mail.yahoo.com.
Re: [RBASE-L] - Building Ampersanded PROPERTY-Set Variables
I’m gonna guess that your Activate is the issue. I wouldn’t think that you
could do multiple commands using a CR between in an ampersand command. Maybe if
you put semicolons rather than CR?
Karen
Sent from my iPhone
> On May 31, 2023, at 5:02 PM, Bruce Chitiea wrote:
>
>
> All:
>
> I'm attempting to build an RBASE_FORM_ACTION library of frequently-used
> PROPERTY sets - reduced to single variables - for ampersanding wherever
> they're needed. Should speed things up and eliminate error and omission.
>
> The required single quote characters are embedded using SET VAR vapos TEXT =
>
>
> --assemble
>
> SET VAR v502_button_pullEnter_ACTIVATE TEXT = +
> ('PROPERTY cid_pb_pullEnter ENABLED ' + .vapos + 'TRUE' + .vapos +
> (CHAR(013)) + +
> 'PROPERTY cid_pb_pullEnter COLOR ' + .vapos + 'WEBGOLD' + .vapos +
> (CHAR(013)) + +
> 'PROPERTY cid_pb_pullEnter SET_ACTIVE_CONTROL ' + .vapos + 'TRUE' + .vapos )
>
> --test result
> PAUSE 1 USING .v502_button_pullEnter_ACTIVATE +
> OPTION MESSAGE_FONT_NAME courier new |MESSAGE_FONT_SIZE 12
>
>
>
> --initialize buttons --
> _button_pullEnter_ACTIVATE
> ...
>
>
>
> The individual statements work fine; and, at least the PAUSE construct looks
> right.
>
> Any ideas on what I'm not seeing here?
>
> Thanks, as ever, Bruce
>
> Bruce A. Chitiea | SafeSectors, Inc.
> 112 Harvard Ave #272 | Claremont CA 91711-4716 | USA
> +011 (909) 238-9012 m | rby...@safesectors.com
>
>
> --
> 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.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/rbase-l/emc60281d8-3a28-4a3c-af4c-d59cef5dd374%405bac5577.com.
--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/D48479C2-9ACF-4A63-B642-711AFA0A2A05%40cs.com.
Re: [RBASE-L] - CREATE TEMPORARY TABLE fails sometimes
So from your code I'm assuming it is the CREATE that isn't working, not the drop. I've seen that error message when trying to drop a table and there is a "declare cursor" still defined on a temp table that was never dropped. There's only one thing I can think of with the Create, and that's whether some other program is creating a temp table with a common column name but with a different data type. But that wouldn't explain why the loop sometimes works. And I'm guessing that no one would have the form or report designer up that uses the temp table? Hey, did you see that Packers / Bears schedule??? Karen -Original Message- From: Doug Hamilton To: R:Base List Sent: Fri, May 26, 2023 10:35 pm Subject: [RBASE-L] - CREATE TEMPORARY TABLE fails sometimes I create a temporary table in a form's On Before Start EEP The form is run dozens of times a day. Once or twice a week I trap an SQL 2440 error, "Unavailable resource encountered during command". This is not machine-specific, it occurs on several computers. SCRATCH is set to TMP - local C:\Users\...\Temp WAIT TIME is 15 seconds. INTERVAL is .5 seconds. What could be causing the error message? What resource could be unavailable? Or is it a red herring message and it's really something else? Code is below. The [error routine] allows up to 4 tries to loop back and create the table. It usually works the second time; once in a great while it fails after 4 tries and I exit the program. TIA & Happy Memorial Day weekend - take a moment to reflect. Doug SET ERROR MESSAGE 2038 OFF DROP TABLE tSHPT SET ERROR MESSAGE 2038 ON CREATE TEMPORARY TABLE `tSHPT` + (`PIKD_ID` INTEGER, + etc ) SET VAR vSQLCode = .SQLCODE IF vSQLCode <> 0 THEN [error routine] ENDI -- This email has been checked for viruses by Avast antivirus software. www.avast.com -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/83ca8547-99bc-0b03-214f-f3de6216bc8e%40wi.rr.com. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/868214035.2618807.1685190929466%40mail.yahoo.com.
Re: [RBASE-L] - Scaling a form that is large to fit on a laptop display
As far as I know, the "fill_screen" property only works to scale something UP,
not down. We played around with using that at a client who had all different
resolutions, so I designed a form for the smallest resolution then did a
"fill_screen" on all the other computers, but we didn't like the way the fonts
were scaled and sometimes combo boxes were cut off.
Karen
-Original Message-
From: myron.fineg...@gmail.com
To: rbase-l@googlegroups.com
Sent: Wed, Apr 12, 2023 9:52 am
Subject: [RBASE-L] - Scaling a form that is large to fit on a laptop display
We have a form
that:
- Is connected to 10 tables.
- Uses six Enhanced Group Boxes as containers for the data.
The Goal: to be able to scale the form to fit on a laptop. The form is 1863
wide and 1066 high. The Border Style is set to sizable. The setup works fine on
24 or 27 inch displays. So, one of the people on our team, Jim, did the
following:I found if the screen resolution on my laptop is set to 1920x1080
(recommended setting), the form displays correctly. However, I use a lower
resolution of 1440x900 to make it easier to see.One option is to manually set
the Windows screen resolution to 1920x1080 when displaying the form.Another is
to hardcode the resolution to 1920 in the After Start EEP:PROPERTY RBASE_FORM
SCALEBY '1920'Finally, it could be programmed in the After Start EEP with
something like the followingSET VAR vRes TEXT = (CVAL('SCREENSIZE')) -- Get
screen size (e.g. 1440,900)SET VAR vSize TEXT = (SSUB(vRes,1)) --
Get first number (e.g. 1440) SET VAR vNewSize TEXT = NULL
-- New screen size -- Resolution must be at least 1920 x 1080 for Property
Search form to fit on the screen. If less, then set to 1920, else leave as
is.IF vSize < '1920' THEN SET VAR vNewSize = '1920'ELSE SET VAR vNewSize
= vSizeENDIFPROPERTY RBASE_FORM SCALEBY .vNewSize Note: I found the following
in the Properties document for RBase Forms, but could not get it to
work.PROPERTY RBASE_FORM SCALEBY 'FILL_SCREEN'Possibly there is another way to
approach this. It's not something I've worked with before. Jim --
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/016a01d96d4e%246d45ade0%2447d109a0%24%40gmail.com.
--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/1014491238.2287259.1681321952299%40mail.yahoo.com.
Re: [RBASE-L] - Enhanced DB Grid Popup Menu on Column
The first thing I’d try is leaving out the order by. Start with it as simple as possible? Karen Sent from my iPhone > On Apr 7, 2023, at 10:01 AM, BILL MILYARD wrote: > > > I have a form with a popup menu on a column in an Enhanced DB Grid that > doesn't popup. Each row of the column has the little box with three dots but > when I double click on the box, nothing happens. The popup menu points to a > table with a single column returned. I've identified 10 lines and an Order > by on the returned column. Does anyone know what I'm missing? > > Thanks, Bill > -- > 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. > To view this discussion on the web visit > https://groups.google.com/d/msgid/rbase-l/SA1PR12MB56379918E913B0176182F0EECB969%40SA1PR12MB5637.namprd12.prod.outlook.com. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/2834AE1B-828B-49BD-B866-BAE970EFED92%40cs.com.
Re: Re[4]: [RBASE-L] - Printing spreadsheets - got it to work!
Boy that was easy!!! Here's my testing code. The single and double quotes
are both required in the particular places so it's a bit tricky. My actual
code will have complicated spreadsheet names with spaces, so I don't have that
worked in yet. But this works.
You see the command prompt box come up and it sits there for a few seconds,
then you see Excel come up, load the file, print it and exit, so it's kinda
weird seeing all that happen, but it does work.
SET VAR vCommand = ('powershell -command "start-process -filepath ''test.xlsx''
-verb print" ')
OUTPUT Excel.bat
WRITE .vCommand=200
OUTPUT SCREEN
LAUNCH Excel.bat||W
Karen
-Original Message-
From: Bruce Chitiea
To: rbase-l@googlegroups.com
Sent: Thu, Mar 16, 2023 3:18 pm
Subject: Re[4]: [RBASE-L] - Printing spreadsheets
#yiv7527517542 #yiv7527517542xcd0e9592aa0a4c3
#yiv7527517542x86b4dd35dfc94ef5a5432fdb70f5f643 {font-family:'Segoe
UI';font-size:12pt;}It would appear that LAUNCH and Powershell are your friends,
here.B
Bruce A. Chitiea | SafeSectors, Inc.112 Harvard Ave #272 | Claremont CA
91711-4716 | USA+011 (909) 238-9012 m | rby...@safesectors.com
-- Original Message ------From "'Karen Tellef' via RBASE-L"
To "rbase-l@googlegroups.com"
Date 3/16/2023 1:14:31 PMSubject Re: Re[2]: [RBASE-L]
- Printing spreadsheets
I guess I needed to be more clear. This is a random existing spreadsheet, has
nothing to do with RBase at all
Karen
-Original Message-
From: 'Jim Belisle' via RBASE-L
To: rbase-l@googlegroups.com
Sent: Thu, Mar 16, 2023 2:10 pm
Subject: RE: Re[2]: [RBASE-L] - Printing spreadsheets
Karen, Try this. GATEWAY
EXPORT XLSW + .. set up location of your file here ….xlsx + SELECT * FROM
(table you created with the info) + OPTION COL_NAMES ON + |SHEET_INDEX 1 +
|RAW_GEN ON + |BLANK_IF_NULL ON + |BLANK_IF_ZERO OFF + |SHOW_PROGRESS ON +
|MERGE_DATA ON + |TAB_NAME ( name of tab in the workbook) This overwrites
the info in the tab you are pointing to. I use this to add info to multiple
tabs in one Excel book. James Belisle Making Information Systems People
Friendly Since 1990 From: 'Karen Tellef' via RBASE-L
Sent: Thursday, March 16, 2023 1:18 PM
To: rbase-l@googlegroups.com
Subject: Re: Re[2]: [RBASE-L] - Printing spreadsheets
| | CAUTION:This is an EXTERNAL EMAIL,STOP! and think before clicking on any
links or opening attachments. |
This is an already existing spreadsheet, not printing a report to a spreadsheet
format Karen -Original Message-
From: Bruce Chitiea
To: rbase-l@googlegroups.com
Sent: Thu, Mar 16, 2023 1:15 pm
Subject: Re[2]: [RBASE-L] - Printing spreadsheets Have you considered: PRINT
reportname ARRANGE clause WHERE clause .. ORDER BY clause .. OPTION XLSX
(from RSyntax) Bruce Bruce A. Chitiea | SafeSectors, Inc. 112 Harvard Ave
#272 | Claremont CA 91711-4716 | USA +011 (909) 238-9012 m |
rby...@safesectors.com -- Original Message ------ From "'Karen Tellef'
via RBASE-L" To "rbase-l@googlegroups.com"
Date 3/16/2023 11:11:51 AM Subject Re: [RBASE-L] -
Printing spreadsheets
This will be a "batch" operation so we wouldn't want to launch them all right
away. He claims it's "not a big deal unless it's easy to print them". I
tried your first link, but get a "page not found" One place to explore
solution:
https://support.microsoft.com/en-us/office/command-line-switches-for-microsoft-office-products
Karen -Original Message-
From: Bruce Chitiea
To: rbase-l@googlegroups.com
Sent: Thu, Mar 16, 2023 1:08 pm
Subject: Re: [RBASE-L] - Printing spreadsheets Karen: Just riffin' here.
LAUNCH excel.exe gets you part of the way there, maybe One place to explore
solution:
https://support.microsoft.com/en-us/office/command-line-switches-for-microsoft-office-products
Another possible source: www.windows-commandline.com/run-command-for-excel/
In the end PowerShell may be the solution. Bruce Bruce A. Chitiea |
SafeSectors, Inc. 112 Harvard Ave #272 | Claremont CA 91711-4716 | USA +011
(909) 238-9012 m | rby...@safesectors.com
-- Original Message -- From "'Karen Tellef' via RBASE-L"
To "rbase-l@googlegroups.com"
Date 3/16/2023 10:38:20 AM Subject [RBASE-L] -
Printing spreadsheets
I've never been asked to do this before, and I have nothing in my voluminous
notes Can you print an Excel spreadsheet (xlsx) from within your RBase
app? Karen --
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
torbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https:/
Re: Re[2]: [RBASE-L] - Printing spreadsheets
I guess I needed to be more clear. This is a random existing spreadsheet, has nothing to do with RBase at all Karen -Original Message- From: 'Jim Belisle' via RBASE-L To: rbase-l@googlegroups.com Sent: Thu, Mar 16, 2023 2:10 pm Subject: RE: Re[2]: [RBASE-L] - Printing spreadsheets Karen, Try this. GATEWAY EXPORT XLSW + .. set up location of your file here ….xlsx + SELECT * FROM (table you created with the info) + OPTION COL_NAMES ON + |SHEET_INDEX 1 + |RAW_GEN ON + |BLANK_IF_NULL ON + |BLANK_IF_ZERO OFF + |SHOW_PROGRESS ON + |MERGE_DATA ON + |TAB_NAME ( name of tab in the workbook) This overwrites the info in the tab you are pointing to. I use this to add info to multiple tabs in one Excel book. James Belisle Making Information Systems People Friendly Since 1990 From: 'Karen Tellef' via RBASE-L Sent: Thursday, March 16, 2023 1:18 PM To: rbase-l@googlegroups.com Subject: Re: Re[2]: [RBASE-L] - Printing spreadsheets | | CAUTION:This is an EXTERNAL EMAIL,STOP! and think before clicking on any links or opening attachments. | This is an already existing spreadsheet, not printing a report to a spreadsheet format Karen -Original Message- From: Bruce Chitiea To: rbase-l@googlegroups.com Sent: Thu, Mar 16, 2023 1:15 pm Subject: Re[2]: [RBASE-L] - Printing spreadsheets Have you considered: PRINT reportname ARRANGE clause WHERE clause .. ORDER BY clause .. OPTION XLSX (from RSyntax) Bruce Bruce A. Chitiea | SafeSectors, Inc. 112 Harvard Ave #272 | Claremont CA 91711-4716 | USA +011 (909) 238-9012 m | rby...@safesectors.com -- Original Message -- From "'Karen Tellef' via RBASE-L" To "rbase-l@googlegroups.com" Date 3/16/2023 11:11:51 AM Subject Re: [RBASE-L] - Printing spreadsheets This will be a "batch" operation so we wouldn't want to launch them all right away. He claims it's "not a big deal unless it's easy to print them". I tried your first link, but get a "page not found" One place to explore solution: https://support.microsoft.com/en-us/office/command-line-switches-for-microsoft-office-products Karen -Original Message- From: Bruce Chitiea To: rbase-l@googlegroups.com Sent: Thu, Mar 16, 2023 1:08 pm Subject: Re: [RBASE-L] - Printing spreadsheets Karen: Just riffin' here. LAUNCH excel.exe gets you part of the way there, maybe One place to explore solution: https://support.microsoft.com/en-us/office/command-line-switches-for-microsoft-office-products Another possible source: www.windows-commandline.com/run-command-for-excel/ In the end PowerShell may be the solution. Bruce Bruce A. Chitiea | SafeSectors, Inc. 112 Harvard Ave #272 | Claremont CA 91711-4716 | USA +011 (909) 238-9012 m | rby...@safesectors.com ------ Original Message -- From "'Karen Tellef' via RBASE-L" To "rbase-l@googlegroups.com" Date 3/16/2023 10:38:20 AM Subject [RBASE-L] - Printing spreadsheets I've never been asked to do this before, and I have nothing in my voluminous notes Can you print an Excel spreadsheet (xlsx) from within your RBase app? Karen -- 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 torbase-l+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/1537336721.947201.1678988300047%40mail.yahoo.com. -- 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 torbase-l+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/emacbf23ed-229c-4899-90df-4b055721892c%40a91e6852.com. -- 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 torbase-l+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/618413864.106307.1678990311876%40mail.yahoo.com. -- 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 torbase-l+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.goog
[RBASE-L] - Re: Printing spreadsheets
I asked a buddy of mine at the same time, and he pointed me to this: https://stackoverflow.com/questions/46901160/how-to-print-excel-by-command-line There's an example of a Powershell command, so I'm going to mess around with this (print-screen attached) Karen -Original Message- From: Karen Tellef To: rbase-l@googlegroups.com Sent: Thu, Mar 16, 2023 12:38 pm Subject: Printing spreadsheets I've never been asked to do this before, and I have nothing in my voluminous notes Can you print an Excel spreadsheet (xlsx) from within your RBase app? Karen -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/887173493.955898.1678990841749%40mail.yahoo.com.
Re: Re[2]: [RBASE-L] - Printing spreadsheets
This is an already existing spreadsheet, not printing a report to a spreadsheet
format
Karen
-Original Message-
From: Bruce Chitiea
To: rbase-l@googlegroups.com
Sent: Thu, Mar 16, 2023 1:15 pm
Subject: Re[2]: [RBASE-L] - Printing spreadsheets
#yiv5318881876 #yiv5318881876x755c9ee8fa0b4c9
#yiv5318881876x86b4dd35dfc94ef5a5432fdb70f5f643 {font-family:'Segoe
UI';font-size:12pt;}Have you considered:
PRINT reportname ARRANGE clause WHERE clause .. ORDER BY clause .. OPTION XLSX
(from RSyntax)
Bruce
Bruce A. Chitiea | SafeSectors, Inc.112 Harvard Ave #272 | Claremont CA
91711-4716 | USA+011 (909) 238-9012 m | rby...@safesectors.com
-- Original Message --From "'Karen Tellef' via RBASE-L"
To "rbase-l@googlegroups.com"
Date 3/16/2023 11:11:51 AMSubject Re: [RBASE-L] -
Printing spreadsheets
This will be a "batch" operation so we wouldn't want to launch them all right
away. He claims it's "not a big deal unless it's easy to print them".
I tried your first link, but get a "page not found"
One place to explore solution:
https://support.microsoft.com/en-us/office/command-line-switches-for-microsoft-office-products
Karen
-Original Message-
From: Bruce Chitiea
To: rbase-l@googlegroups.com
Sent: Thu, Mar 16, 2023 1:08 pm
Subject: Re: [RBASE-L] - Printing spreadsheets
Karen:
Just riffin' here.
LAUNCH excel.exe gets you part of the way there, maybe
One place to explore
solution:https://support.microsoft.com/en-us/office/command-line-switches-for-microsoft-office-products
Another possible source:www.windows-commandline.com/run-command-for-excel/
In the end PowerShell may be the solution.
Bruce
Bruce A. Chitiea | SafeSectors, Inc.112 Harvard Ave #272 | Claremont CA
91711-4716 | USA+011 (909) 238-9012 m | rby...@safesectors.com
------ Original Message --From "'Karen Tellef' via RBASE-L"
To "rbase-l@googlegroups.com"
Date 3/16/2023 10:38:20 AMSubject [RBASE-L] -
Printing spreadsheets
I've never been asked to do this before, and I have nothing in my voluminous
notes
Can you print an Excel spreadsheet (xlsx) from within your RBase app?
Karen
--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/1537336721.947201.1678988300047%40mail.yahoo.com.
--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/emacbf23ed-229c-4899-90df-4b055721892c%40a91e6852.com.
--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/618413864.106307.1678990311876%40mail.yahoo.com.
--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/em237796d7-7920-434d-a805-54da45a0b190%40a91e6852.com.
--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/2002970857.945404.1678990697251%40mail.yahoo.com.
Re: [RBASE-L] - Printing spreadsheets
This will be a "batch" operation so we wouldn't want to launch them all right
away. He claims it's "not a big deal unless it's easy to print them".
I tried your first link, but get a "page not found"
One place to explore solution:
https://support.microsoft.com/en-us/office/command-line-switches-for-microsoft-office-products
Karen
-Original Message-
From: Bruce Chitiea
To: rbase-l@googlegroups.com
Sent: Thu, Mar 16, 2023 1:08 pm
Subject: Re: [RBASE-L] - Printing spreadsheets
#yiv0416507510 #yiv0416507510xf2711c293ab14b5
#yiv0416507510x86b4dd35dfc94ef5a5432fdb70f5f643 {font-family:'Segoe
UI';font-size:12pt;}Karen:
Just riffin' here.
LAUNCH excel.exe gets you part of the way there, maybe
One place to explore
solution:https://support.microsoft.com/en-us/office/command-line-switches-for-microsoft-office-products
Another possible source:www.windows-commandline.com/run-command-for-excel/
In the end PowerShell may be the solution.
Bruce
Bruce A. Chitiea | SafeSectors, Inc.112 Harvard Ave #272 | Claremont CA
91711-4716 | USA+011 (909) 238-9012 m | rby...@safesectors.com
-- Original Message --From "'Karen Tellef' via RBASE-L"
To "rbase-l@googlegroups.com"
Date 3/16/2023 10:38:20 AMSubject [RBASE-L] -
Printing spreadsheets
I've never been asked to do this before, and I have nothing in my voluminous
notes
Can you print an Excel spreadsheet (xlsx) from within your RBase app?
Karen
--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/1537336721.947201.1678988300047%40mail.yahoo.com.
--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/emacbf23ed-229c-4899-90df-4b055721892c%40a91e6852.com.
--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/618413864.106307.1678990311876%40mail.yahoo.com.
[RBASE-L] - Printing spreadsheets
I've never been asked to do this before, and I have nothing in my voluminous notes Can you print an Excel spreadsheet (xlsx) from within your RBase app? Karen -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/1537336721.947201.1678988300047%40mail.yahoo.com.
Re: [EXTERNAL] [RBASE-L] - OT: laptop batteries?
I did a search on Amazon, and the battery that came up was for an Inspiron. So that made me a bit leery. I thought the same, tho, just check the ratings of the seller Karen -Original Message- From: Dan Goldberg To: rbase-l@googlegroups.com Sent: Mon, Feb 20, 2023 10:35 am Subject: Re: [EXTERNAL] [RBASE-L] - OT: laptop batteries? Amazon is the way to go. There is dell batteries and others. I usually look at the ratings to determine which one i will purchase. Dan GoldbergIT ManagerLance CamperFrom: 'Karen Tellef' via RBASE-L Sent: Monday, February 20, 2023 8:24:39 AM To: rbase-l@googlegroups.com Subject: [EXTERNAL] [RBASE-L] - OT: laptop batteries? Hope you all don't mind a hardware question. Need to replace my Dell laptop battery. Seems I've heard warnings about not getting "cheap" batteries. Battery for the Latitude 3560 is not even available on Dell's website. Search shows everything from $23 from Secure-Battery.com to $90 from Parts-People.com This has been my warrior development machine for a long time and I don't have plans of replacing it anytime soon. How do I know if "cheap is good"? Typically it isn't. Karen -- 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 torbase-l+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/1200773699.3371950.1676910279895%40mail.yahoo.com. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/BY3PR19MB5027C7F05E295EAE91225886D4A49%40BY3PR19MB5027.namprd19.prod.outlook.com. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/1458284364.3375932.1676911283151%40mail.yahoo.com.
[RBASE-L] - OT: laptop batteries?
Hope you all don't mind a hardware question. Need to replace my Dell laptop battery. Seems I've heard warnings about not getting "cheap" batteries. Battery for the Latitude 3560 is not even available on Dell's website. Search shows everything from $23 from Secure-Battery.com to $90 from Parts-People.com This has been my warrior development machine for a long time and I don't have plans of replacing it anytime soon. How do I know if "cheap is good"? Typically it isn't. Karen -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/1200773699.3371950.1676910279895%40mail.yahoo.com.
Re: [RBASE-L] - Using Alias for column names - solution!
Well folks, Bruce figured it out for me! I know for sure I haven't done this
before. I had to enclose it with IDQuotes.
Step 1:
Each of the 12 variables is defined as:
SET VAR vText = ("vMonth" + CTXT(.vLoopRunning))
SET VAR = ( CVAL("IDQUOTES") + FORMAT(.vDateReport, "MMM-YY") +
CVAL("IDQUOTES") )
Step 2:In my gateway select, use the ampersand:SELECT CustPart, Month1 AS
, Month2 AS ...
Thanks Bruce! Owe ya one
Karen
-Original Message-
From: Bruce Chitiea
To: rbase-l@googlegroups.com
Sent: Mon, Feb 13, 2023 11:24 am
Subject: Re: [RBASE-L] - Using Alias for column names
I take it that you're using the [ " ] as your quote character.
SET VAR vmonth1 TEXT = ("`Jan-23`")
Bruce
-- Original Message --From "'Karen Tellef' via RBASE-L"
To "rbase-l@googlegroups.com"
Date 2/13/2023 9:06:17 AMSubject [RBASE-L] - Using
Alias for column names
I could have SWORN I've done this before, but nothing is working.
I have a table with columns Month1, Month2 Month12
I have a bunch of variables that represent the displayed months: vMonth1 =
"Jan-23", vMonth2 = "Feb-23"
Trying to do an Excel Gateway export including: Month1 AS .vMonth1, Month2 AS
.vMonth2
I tried .vMonth1,
I swear I've done this before. If anyone can tell me, for sure I'll document
it for the future!!!
Karen
--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/791241025.792952.1676307977150%40mail.yahoo.com.
--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/eme190e39b-59a6-449f--fd576c7c050b%40a88f78da.com.
--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/281803989.831341.1676312337794%40mail.yahoo.com.
Re: [RBASE-L] - Using Alias for column names
Yes, this client is using double quotes
-Original Message-
From: Bruce Chitiea
To: rbase-l@googlegroups.com
Sent: Mon, Feb 13, 2023 11:24 am
Subject: Re: [RBASE-L] - Using Alias for column names
I take it that you're using the [ " ] as your quote character.
SET VAR vmonth1 TEXT = ("`Jan-23`")
Bruce
-- Original Message ------From "'Karen Tellef' via RBASE-L"
To "rbase-l@googlegroups.com"
Date 2/13/2023 9:06:17 AMSubject [RBASE-L] - Using
Alias for column names
I could have SWORN I've done this before, but nothing is working.
I have a table with columns Month1, Month2 Month12
I have a bunch of variables that represent the displayed months: vMonth1 =
"Jan-23", vMonth2 = "Feb-23"
Trying to do an Excel Gateway export including: Month1 AS .vMonth1, Month2 AS
.vMonth2
I tried .vMonth1,
I swear I've done this before. If anyone can tell me, for sure I'll document
it for the future!!!
Karen
--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/791241025.792952.1676307977150%40mail.yahoo.com.
--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/eme190e39b-59a6-449f--fd576c7c050b%40a88f78da.com.
--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/750026677.828774.1676310289541%40mail.yahoo.com.
[RBASE-L] - Using Alias for column names
I could have SWORN I've done this before, but nothing is working. I have a table with columns Month1, Month2 Month12 I have a bunch of variables that represent the displayed months: vMonth1 = "Jan-23", vMonth2 = "Feb-23" Trying to do an Excel Gateway export including: Month1 AS .vMonth1, Month2 AS .vMonth2 I tried .vMonth1, I swear I've done this before. If anyone can tell me, for sure I'll document it for the future!!! Karen -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/791241025.792952.1676307977150%40mail.yahoo.com.
Re: [RBASE-L] - leading zeros and excel gateway file
I looked in my notes. I see you're exporting to a CSV. If you don't need a
CSV, my notes say that exporting to a worksheet (XLS) rather than a work book
(XLSW) retains leading zeros
Karen
-Original Message-
From: 'jim schmitt' via RBASE-L
To: rbase group
Sent: Mon, Feb 6, 2023 12:19 pm
Subject: [RBASE-L] - leading zeros and excel gateway file
Hello, Group:
I am transfering a data file using the gateway command, and two of the fields
which are text and have a leading zero ('0602', '0605').When I use the gateway
command, everything is fine, except the two fields with leading zeros in the
csv file have dropped the leading zeros (which are needed).
Am I missing something or can this be resolved. ? gateway command and sample
file attached
Thanks, Jim,
gateway command and sample file attached::
GATEWAY EXPORT CSV w2upload.csv + SELECT * FROM OHIO_W2_DATA + OPTION
COL_NAMES OFF --- | SHOW_PROGRESS ON | ACTION OPENVIEW
--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/1973250947.972841.1675707561020%40mail.yahoo.com.
--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/1290823543.771706.1675708572260%40mail.yahoo.com.
Re: [RBASE-L] - VAR Lookup List Box PROPERTY LOOKUPWHERECLAUSE
Yes it has been way too many years since we've seen each other, Manuel! Thanks
for the kind words. I miss seeing all my programmer friends in person for sure
Glad that suggestion worked for you.
Karen
-Original Message-
From: Manuel De Aguiar
To: rbase-l@googlegroups.com
Sent: Sat, Jan 21, 2023 4:06 pm
Subject: Re: [RBASE-L] - VAR Lookup List Box PROPERTY LOOKUPWHERECLAUSE
Hi Karen! It has been so many years that we last saw each other in person.
Maybe 20 years ago? You are always so kind with your time. Today I had time
to revisit this challenge and I wanted to tell you it works! The WHERE clause
in the variable Lookup List Box is like this:
and with a pop up dialog box the user enters the phrase he wants the CONTAINS
to look for. If the user enters the % symbol then all rows are displayed.I am
not sure why the PROPERTY LOOKUPWHERECLAUSE .vSrch did not work but I
have spent way too much time on this to worry about it.Thank you and I wish
Razzak could plan a convention/Reunion this summer for us all to meet once
again. I think that would be great.Again Thank youManuel de
aguiar323-243-122...@mdenterprises.net
On Thu, Jan 19, 2023 at 5:42 AM 'Karen Tellef' via RBASE-L
wrote:
Manuel: When I'm constructing variables like you are, I NEVER embed the actual
value in the where clause. Too difficult to deal with quotation marks, etc. I
find that if you just do something like this: SET VAR vWhere = 'Company
CONTAINS .vSearchValue'
you don't have to worry about that kind of stuff. Have you tried this?
Karen
-Original Message-
From: Manuel De Aguiar
To: rbase-l@googlegroups.com
Sent: Wed, Jan 18, 2023 7:26 pm
Subject: [RBASE-L] - VAR Lookup List Box PROPERTY LOOKUPWHERECLAUSE
Hello everyone, I think I tried every combination possible, but the right
one, to use the property command LOOKUPWHERECLAUSE for the variable lookup
list box object and it simply does not work..Using the RRBYW20 database from
R:BASE X.5, Enterprise, U.S. Version, Build: 10.5.5.10818 I added a search
feature to the form: DynamicListViews and it simply does not work. When you
have a long list of customers it would be nice to have a way to limit the
display using a CONTAINS where clause. For example I may want to list only
those companies that have an 'Inc' on the company name.. If I add the
following WHERE clause on the object: Company CONTAINS 'Inc' and run the form
it behaves properly and displays those companies that have 'Inc' on their name.
However if I try to do it programatically.SET VAR vWhere = +
('Company CONTAINS' & CHAR(39)+ 'Inc' +CHAR(39) & CHAR(39) ) It fails
to display a list of any company.
I tried different combinations without success. If anyone has an answer. I
will GREATLY APPRECIATED IT...Thank youManuel de AguiarM|D
Enterprises323-243-1224 cel...@mdenterprises.net
--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/CABiOS48kRk3p6e6JCf28vZtnuK-HbgmsHkau640iB5cZiU5ZcA%40mail.gmail.com.
--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/252017736.2969006.1674135764892%40mail.yahoo.com.
--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/CABiOS4_GfHACPhWP%3DNuCrvRuLBppaDEH-gsUh39HrTRT1pv%3Dsg%40mail.gmail.com.
--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/433517407.373386.1674399015718%40mail.yahoo.com.
Re: [RBASE-L] - VAR Lookup List Box PROPERTY LOOKUPWHERECLAUSE
Manuel: When I'm constructing variables like you are, I NEVER embed the actual
value in the where clause. Too difficult to deal with quotation marks, etc. I
find that if you just do something like this: SET VAR vWhere = 'Company
CONTAINS .vSearchValue'
you don't have to worry about that kind of stuff. Have you tried this?
Karen
-Original Message-
From: Manuel De Aguiar
To: rbase-l@googlegroups.com
Sent: Wed, Jan 18, 2023 7:26 pm
Subject: [RBASE-L] - VAR Lookup List Box PROPERTY LOOKUPWHERECLAUSE
Hello everyone, I think I tried every combination possible, but the right
one, to use the property command LOOKUPWHERECLAUSE for the variable lookup
list box object and it simply does not work..Using the RRBYW20 database from
R:BASE X.5, Enterprise, U.S. Version, Build: 10.5.5.10818 I added a search
feature to the form: DynamicListViews and it simply does not work. When you
have a long list of customers it would be nice to have a way to limit the
display using a CONTAINS where clause. For example I may want to list only
those companies that have an 'Inc' on the company name.. If I add the
following WHERE clause on the object: Company CONTAINS 'Inc' and run the form
it behaves properly and displays those companies that have 'Inc' on their name.
However if I try to do it programatically.SET VAR vWhere = +
('Company CONTAINS' & CHAR(39)+ 'Inc' +CHAR(39) & CHAR(39) ) It fails
to display a list of any company.
I tried different combinations without success. If anyone has an answer. I
will GREATLY APPRECIATED IT...Thank youManuel de AguiarM|D
Enterprises323-243-1224 cel...@mdenterprises.net
--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/CABiOS48kRk3p6e6JCf28vZtnuK-HbgmsHkau640iB5cZiU5ZcA%40mail.gmail.com.
--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/252017736.2969006.1674135764892%40mail.yahoo.com.
Re: [RBASE-L] - weird form situations
If I'm correct, temporary tables will use whatever your SCRATCH setting is within RBase. What do you have that set to in your app? I would check to make sure that that setting is still accurate Karen -Original Message- From: 'Jim Belisle' via RBASE-L To: RBase Maillist Sent: Thu, Jan 12, 2023 9:06 am Subject: [RBASE-L] - weird form situations I do not think this is specifically an RBASE problem but it is affecting RBASE and I am trying to get ideas from you about what our IT people should look for. Last night the IT company we use did a server reboot. This morning we are now experiencing strange behavior with some of our forms, mostly the order and quote entry/edit forms. (at least that is what I have heard about thus far) One of two problems are showing up. - In some cases, order entry form, the temporary tables are not being created. - In other cases, quote edit form, the temporary table column names are showing in the fields on the form. (these are the ones I have checked thus far) I can browse and work in the actual tables since I have been doing that all morning. I used RSCOPE to check all my data, indexes, etc and I received no errors at all. I tried uploading backups of the problem forms and that did not help. I rebooted my computer and had our users reboot their computers and that did not help. Any suggestions as to what I should try or suggest to the IT people to do on their end? James Belisle Making Information Systems People Friendly Since 1990 -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/IA1PR02MB88988C9262353365573763F7A0FD9%40IA1PR02MB8898.namprd02.prod.outlook.com. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/1095061600.408524.1673537942384%40mail.yahoo.com.
Re: [RBASE-L] - out of dynamic space epilog
"he claimed he didn't do anything". I believe that! Come on, how many times does a client tell you that a program doesn't work, you dial in, press the same button and it magically works??? Happy New Year everyone! Karen -Original Message- From: 'jim schmitt' via RBASE-L To: rbase group Sent: Thu, Dec 29, 2022 8:25 am Subject: [RBASE-L] - out of dynamic space epilog Thanks to Karen, Razzak, Randy, Mark, Nicky, and Rehan for their great suggestions to my clients 'OUT OF DYNAMIC SPACE' problem. I dialed in to the client, and tried to do a Reload and Pack, but it blew up.Next, I copied the db and files to my computer, and did a Reload and Pack - worked great, and then tested the db - that worked too. Dialed back in and transferred the db and files back to client. Fired up and again 'OUT OF DYNAMIC SPACE' Tried to tracethe errorduring my testing, everthing went to an extremely slow mode for about 1 1/2 hours. So after a day being down, the clients network IT tech called me..he dialed in..then magicallyeverything worked, and was unbelievably fast. He claimed he didn't do antthing (yeah, right). So, as usual NO PROBLEMS WITHIN R:BASE (it's running like a champ) ..the culprit was somewhere in the client's computer and/or the IT tech guy. No clue as to what caused the 'OUT OF DYNAMIC SPACE' error; I guess i'll never know. Client is now happy once more. But, again thanks to all for the great suggestions, and HAPPY NEW YEAR ! Jim Schmitt -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/443960974.1109136.1672323913425%40mail.yahoo.com. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/514380027.41121.1672324858478%40mail.yahoo.com.
Re: [RBASE-L] - out of dynamic space II
Merry Christmas to you, Jim! I think there was only 2 times I saw this happen. One was a non-robust server that had MANY daily backup copies of a very large database. They actually did run out of room! They had to change their routine to archive older backups to an external drive. The other time was when there was a limit to the size of a drive-mapped partition, and that partition alone had run out of room Karen -Original Message- From: 'jim schmitt' via RBASE-L To: 'Karen Tellef' via RBASE-L Sent: Mon, Dec 26, 2022 1:29 pm Subject: Re: [RBASE-L] - out of dynamic space II Hi, Karen: Thanks for the quick reply, and Merry Christmas and Happy Holidays. I just called the client to see what was the size of the server, but they have left for the day.Thye just purchased the server a few months ago, but I would think most clients would want a rather robust server. . Jim On Monday, December 26, 2022 at 02:02:43 PM EST, 'Karen Tellef' via RBASE-L wrote: I was gonna say that I've seen that message in two instances. Either out of hard drive space (either server or local temp directory if you use local temp) or an issue with local memory Karen -Original Message- From: 'jim schmitt' via RBASE-L To: rbase group Sent: Mon, Dec 26, 2022 12:54 pm Subject: [RBASE-L] - out of dynamic space II Hello again to all: Could 'out of dynamic space ' mean there is no more room on the server ? Here are the server drives: i believe 'P' is a copy of 'S', as it is exactly same sizes. H dive S drive (production) P driveused 83.0 GB USED 429 gb USED 429 GBFREE 362 gb free 384GB FREE 384 GB TOTAL 446 gb TOTAL 813 GB TOTAL 813 GB Could their server be only 1TB and out of room ? Just guessing in the dark . Jim-- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/591133800.4046390.1672080894289%40mail.yahoo.com. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/1347456052.3409335.1672081361444%40mail.yahoo.com. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/1024213708.4045010.1672082956746%40mail.yahoo.com. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/278486229.3206490.1672086767814%40mail.yahoo.com.
Re: [RBASE-L] - out of dynamic space II
I was gonna say that I've seen that message in two instances. Either out of hard drive space (either server or local temp directory if you use local temp) or an issue with local memory Karen -Original Message- From: 'jim schmitt' via RBASE-L To: rbase group Sent: Mon, Dec 26, 2022 12:54 pm Subject: [RBASE-L] - out of dynamic space II Hello again to all: Could 'out of dynamic space ' mean there is no more room on the server ? Here are the server drives: i believe 'P' is a copy of 'S', as it is exactly same sizes. H dive S drive (production) P driveused 83.0 GB USED 429 gb USED 429 GBFREE 362 gb free 384GB FREE 384 GB TOTAL 446 gb TOTAL 813 GB TOTAL 813 GB Could their server be only 1TB and out of room ? Just guessing in the dark . Jim-- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/591133800.4046390.1672080894289%40mail.yahoo.com. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/1347456052.3409335.1672081361444%40mail.yahoo.com.
Re: [RBASE-L] - capture autonumber field value
Are you doing an "enter using" form? I think the autonumber doesn't get "set" until you save the record. My experience has been that when you exit the form, your variable would then be populated and can be referenced in code after the form is exited. But if you need it while still in the form, you'll have to issue a "saverow" to assign the autonum Karen -Original Message- From: Dan Goldberg To: rbase-l@googlegroups.com Sent: Thu, Dec 8, 2022 9:34 am Subject: [RBASE-L] - capture autonumber field value I am trying to capture an autonumber field value in the after start eep but it keeps showing 0. So I put the variable field on the form so I can watch it(circled red). But when I step thru it I see the variable value in the form but not in the eep. Is there a better way after a form start and when a row is save to get the current autonumber value when those are triggered? TIA Dan Goldberg -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/BY3PR19MB5027F39DE5DF0671E6E6873BD41D9%40BY3PR19MB5027.namprd19.prod.outlook.com. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/1131986925.2185178.1670518105949%40mail.yahoo.com.
Re: [RBASE-L] - A "null" variable image
Javier:
We don't store the filenames in the database at all. They are all stored in a
directory with the unique ID as the beginning characters of the filename. My
examples were shortened as an example, but for example for CARLogID 5800, I
would do a Dir /B of files that start with "5800-". So we do a DIR and load
into a temp table. That way the users can add and delete files outside of
RBase, and the database isn't involved at all.
So my program loads the dir into a temp table called tmpCARPhotos. It would
usually load for several CARLogIDs at a time. The temp table has an
autonumbered CARPhotoID column.
In the report, I now have this in the report's Break Header (on CARLogID)
Before Generate EEP. Works great now!
SET VAR vfilename1 TEXT = “BlankJPG.JPG”,vfilename2 TEXT = “BlankJPG.JPG”, +
vfilename3 TEXT = “BlankJPG.JPG”,vfilename4 TEXT = “BlankJPG.JPG”
SET VAR vMin INT = 0, vMax INT = 0
SELECT (MIN(CARPhotoID)), (MAX(CARPhotoID)) INTO vMin, vMax FROM tmpCARPhotos +
WHERE CARLogid = .vPCARLogid
IF vMin > 0 THEN
SET VAR vCount = (.vMax - .vMin + 1)
SET VAR vCount = (IFGT(.vCount, 4, 4,.vCount))
SET VAR vLoop = 1
WHILE vLoop <= .vCount THEN
SET VAR vText =("vFilename" + CTXT(.vLoop))
SELECT CARFilename INTO tmpCARPhotos WHERE CARLogID =
.vPCARLogID +
AND CARPhotoID = .vMin
SET VAR vLoop = (.vLoop + 1), vMin =(.vMin + 1)
ENDWHILE
ENDIF
Karen
-Original Message-
From: javier.valen...@vtgonline.com
To: rbase-l@googlegroups.com
Sent: Thu, Nov 10, 2022 5:52 pm
Subject: RE: [RBASE-L] - A "null" variable image
I am trying to figure out how where the
picture names/links are stored.How do you know how many picture placeholders to
assign in the report?If you have a record in Table1 and the corresponding
picture names are stored in Table2 on a 1 to many relationships, which I
believe would the recommended approach, then you can create a parent and a
child table in your report, and I will print only pictures that are available
and not display blank placeholders.I will guess that your application is
probable differentYou can always create a blank picture that is basically a
blank, thin sliver and then, when you get your variables run something like
this:IF vFilename3 IS NULL THEN SET VAT vFilename3 =
‘c:\BlankPic.jpg’ENDIFThis will display the blank picture that should not take
much space.I am not sure how your data is structured in you application and
hopefully, the above is of help. Javier, Javier Valencia, PE913-915-3137
From: 'Karen Tellef' via RBASE-L
Sent: Thursday, November 10, 2022 1:46 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - A "null" variable image I'm guessing I have to go
with a "null" image to display. Certainly easier than the code to make the
images visible or invisible. I do not have to collapse the space, only one
part prints on a page and the photos are at the bottom Karen
-Original Message-
From: Robert Thompson
To: rbase-l@googlegroups.com
Sent: Thu, Nov 10, 2022 2:28 pm
Subject: RE: [RBASE-L] - A "null" variable imageNot sure about a setting,
perhaps someone else is. But if not, you might consider a "default" image that
is a simple white or transparent square. Then predefine all 4 variables to
"Default.jpg" (or what ever). Then if you do not assign an actual image, the
default will always display. No real code changes other than the variable
filename predefault. This would also allow you to display a default image for
information or some other nice option. However if you are wanting to collapse
the print space when both image 3 & 4 are null, this would not help. And as
you stated, the make invisible code would work as well. Robert ThompsonTTC
Inc.219-363-7441 Original message From: 'Karen Tellef' via
RBASE-L Date: 11/10/22 1:53 PM (GMT-05:00) To:
rbase-l@googlegroups.com Subject: [RBASE-L] - A "null" variable image
Hopefully I can explain this. I have attached a print-screen because my
embedded images don't show in the list emails. Each part we print on this
report can have unlimited (or no) photos saved on disk. We will print no more
than 4 on the page, so I am pulling 4 random photos into my text variables
(vfilename1, 2, 3, 4), and Variable Images are located. Works great except
when I have null variables. As shown on the attached, vFilename1 and
vFilename2 have values and print the photos just fine. But variables
vFilename3 and vFilename4 are NULL (as shown below, my null setting is actually
' ' when printing but I changed to -0- to show you the list). The null ones
have that weird white/red thing. I'm wondering if I am missing a setting for
these. I know I can write code to make controls invisible, but I was hoping
I'm missing something simple. Any c
Re: [RBASE-L] - A "null" variable image
I'm guessing I have to go with a "null" image to display. Certainly easier than the code to make the images visible or invisible. I do not have to collapse the space, only one part prints on a page and the photos are at the bottom Karen -Original Message- From: Robert Thompson To: rbase-l@googlegroups.com Sent: Thu, Nov 10, 2022 2:28 pm Subject: RE: [RBASE-L] - A "null" variable image Not sure about a setting, perhaps someone else is. But if not, you might consider a "default" image that is a simple white or transparent square. Then predefine all 4 variables to "Default.jpg" (or what ever). Then if you do not assign an actual image, the default will always display. No real code changes other than the variable filename predefault. This would also allow you to display a default image for information or some other nice option. However if you are wanting to collapse the print space when both image 3 & 4 are null, this would not help. And as you stated, the make invisible code would work as well. Robert ThompsonTTC Inc.219-363-7441 ---- Original message From: 'Karen Tellef' via RBASE-L Date: 11/10/22 1:53 PM (GMT-05:00) To: rbase-l@googlegroups.com Subject: [RBASE-L] - A "null" variable image Hopefully I can explain this. I have attached a print-screen because my embedded images don't show in the list emails. Each part we print on this report can have unlimited (or no) photos saved on disk. We will print no more than 4 on the page, so I am pulling 4 random photos into my text variables (vfilename1, 2, 3, 4), and Variable Images are located. Works great except when I have null variables. As shown on the attached, vFilename1 and vFilename2 have values and print the photos just fine. But variables vFilename3 and vFilename4 are NULL (as shown below, my null setting is actually ' ' when printing but I changed to -0- to show you the list). The null ones have that weird white/red thing. I'm wondering if I am missing a setting for these. I know I can write code to make controls invisible, but I was hoping I'm missing something simple. Any clues for me? Karen Variable = Value Type -- -- --- vFilename1 = F:\Quality\123773-A.jpg TEXT vFilename2 = F:\Quality\123773-B.jpg TEXT vFilename3 = -0- TEXT vFilename4 = -0- TEXT -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/1588128635.1982897.1668106391324%40mail.yahoo.com. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/636d510f.810a0220.9f9d.04b8SMTPIN_ADDED_BROKEN%40gmr-mx.google.com. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/1444136802.2005358.1668109576636%40mail.yahoo.com.
Re: [RBASE-L] - A "null" variable image
Jason: You know what, I remember using that exact thing years ago for something. So yeah, if there isn't something simple, I'll do that. Thanks for the reminder! Karen -Original Message- From: Kramer, Jason To: rbase-l@googlegroups.com Sent: Thu, Nov 10, 2022 1:58 pm Subject: RE: [RBASE-L] - A "null" variable image You could create a blank image and name it something like NoImage.png and then use IFNULL in your query to load it in place of nulls. SELECT …(IFNULL(fieldname,’NoImage.png’,fieldname))…. This does not directly solve your problem but it is a low effort way around it. Thanks, Jason | | | Jason Kramer Computing Support Specialist II University Archives and Records Management 002E Pearson Hall, 125 Academy St, Newark DE 19716-4399 University of Delaware 302-831-3127 | fax:302-831-6903 jjkra...@udel.edu | From: 'Karen Tellef' via RBASE-L Sent: Thursday, November 10, 2022 1:53 PM To: rbase-l@googlegroups.com Subject: [RBASE-L] - A "null" variable image Hopefully I can explain this. I have attached a print-screen because my embedded images don't show in the list emails. Each part we print on this report can have unlimited (or no) photos saved on disk. We will print no more than 4 on the page, so I am pulling 4 random photos into my text variables (vfilename1, 2, 3, 4), and Variable Images are located. Works great except when I have null variables. As shown on the attached, vFilename1 and vFilename2 have values and print the photos just fine. But variables vFilename3 and vFilename4 are NULL (as shown below, my null setting is actually ' ' when printing but I changed to -0- to show you the list). The null ones have that weird white/red thing. I'm wondering if I am missing a setting for these. I know I can write code to make controls invisible, but I was hoping I'm missing something simple. Any clues for me? Karen Variable = Value Type -- -- --- vFilename1 = F:\Quality\123773-A.jpg TEXT vFilename2 = F:\Quality\123773-B.jpg TEXT vFilename3 = -0- TEXT vFilename4 = -0- TEXT -- 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 torbase-l+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/1588128635.1982897.1668106391324%40mail.yahoo.com. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/PH7PR10MB62049AC319B990ABBFF57D41BA019%40PH7PR10MB6204.namprd10.prod.outlook.com. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/1823449882.1985585.1668106846035%40mail.yahoo.com.
Re: [RBASE-L] - Outlook meetings?
WELL SHOOT Why didn't I think of looking at add-on products Thanks, I'll look at the help manual over the weekend Karen -Original Message- From: John Minyo II To: rbase-l@googlegroups.com Sent: Fri, Oct 14, 2022 12:33 pm Subject: Re: [RBASE-L] - Outlook meetings? Karen, Please review the product page and details for R:OutLink: https://www.rbase.com/products/routlink/ Best regards, John Minyo II R:BASE Technologies, Inc. https://www.rbase.com On 10/14/2022 11:00 AM, 'Karen Tellef' via RBASE-L wrote: Someone asked me if RBase can create an Outlook meeting. If anyone has done this, let me know either on or off the list (obviously we'd be willing to pay for your time) Karen -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/8ec67333-6430-2b1d-580a-681db4d9b847%40rbase.com. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/1968480227.1541817.1665770333056%40mail.yahoo.com.
Re: [RBASE-L] - Outlook meetings?
Wow, thanks for the links, I really appreciate it!! Karen -Original Message- From: Nicky Avery To: rbase-l@googlegroups.com Sent: Fri, Oct 14, 2022 12:27 pm Subject: Re: [RBASE-L] - Outlook meetings? Karen, That's interesting! I'm not sure if your cust. wants just to schedule a meeting or an online meeting but, in theory, you can do both as Outlook can invoke Teams and Skype. I looked about online and I'm sure you have found the links below but, if not, ... https://support.microsoft.com/en-us/office/schedule-a-meeting-with-other-people-5c9877bc-ab91-4a7c-99fb-b0b68d7ea94f https://support.microsoft.com/en-us/office/set-up-an-online-meeting-in-outlook-b8305620-d16e-4667-989d-4a977aad6556 One method to "automate" the process appears to be to an MS product now called PowerAutomate (formerly Flow) as it has functions to add/remove events in the Outlook calendar. https://powerusers.microsoft.com/t5/Building-Power-Apps/Add-Remove-Events-on-calendar/m-p/461637#M138109 https://powerusers.microsoft.com/t5/Building-Flows/Creating-Events-on-Calendar/m-p/1679988#M186405 The question would now be how to invoke PowerAutomate functions from another program and this article shows a way to do it. I cannot imagine why I don't think this looks like a walk in the park. Maybe someone knows of a simpler way. Good luck! Nicky On 10/14/2022 8:00 AM, 'Karen Tellef' via RBASE-L wrote: Someone asked me if RBase can create an Outlook meeting. If anyone has done this, let me know either on or off the list (obviously we'd be willing to pay for your time) Karen -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/125396264.1461885.1665759620191%40mail.yahoo.com. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/cc3b6dfb-a939-2498-ced0-e0e3c2a0e50e%40wwavs.com. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/1125006368.1538419.1665769848369%40mail.yahoo.com.
Re: [RBASE-L] - Outlook meetings?
They want to create the Outlook Meeting, no emails so far. If all else fails I will google as you suggest. Just hoping that someone already had the command code written from within RBase or had documentation of how to do it (didn't find any FTE articles or Tip of the Day, and nothing saved in my extensive notes document) Karen -Original Message- From: javier.valen...@vtgonline.com To: rbase-l@googlegroups.com Sent: Fri, Oct 14, 2022 11:22 am Subject: RE: [RBASE-L] - Outlook meetings? I am not sure what you are trying to do. Do you just want to create an Outlook Meeting directly from code? Do you want to email the meeting? Do you want to fill all the required fields and addresses with code and mail it? Do you just want to pop the Outlook Meetings screen?I believe you can use the Outlook command line switches to do some of this; you can also create a meeting template and attach it via switch from the command line.You can Google “how to create Outlook meeting from command line” and you should get some information that will get you started. Javier, Javier Valencia, PE913-915-3137 From: 'Karen Tellef' via RBASE-L Sent: Friday, October 14, 2022 10:00 AM To: rbase-l@googlegroups.com Subject: [RBASE-L] - Outlook meetings? Someone asked me if RBase can create an Outlook meeting. If anyone has done this, let me know either on or off the list (obviously we'd be willing to pay for your time) Karen -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/125396264.1461885.1665759620191%40mail.yahoo.com.-- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/!%26!AAAYAG1gU%2BA71stIig71BAFnx9iihQAAEEu83jzKRhRMuAxGPMMlZgEBAA%3D%3D%40vtgonline.com. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/200282648.1519428.1665767069246%40mail.yahoo.com.
[RBASE-L] - Outlook meetings?
Someone asked me if RBase can create an Outlook meeting. If anyone has done this, let me know either on or off the list (obviously we'd be willing to pay for your time) Karen -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/125396264.1461885.1665759620191%40mail.yahoo.com.
Re: [RBASE-L] - Tip of the Day: Specify a Custom Font in PDF Output with Font Substitutions
I've been curious about something similar for quite a while (don't remember how long ago this started). I have a report defined with a simple Times New Roman 12. No bold, no effects. But when I send it to a PDF it comes out different (no PDF options are specified). The attached shows a side by side. Can I use this new command but somehow substitute it for TNR? Or should I submit as an enhancement or fix? Karen -Original Message- From: A. Razzak Memon To: RBASE-L Group Sent: Wed, Oct 12, 2022 11:12 pm Subject: [RBASE-L] - Tip of the Day: Specify a Custom Font in PDF Output with Font Substitutions Thursday, October 13, 2022 Tip of the Day: Specify a Custom Font in PDF Output with Font Substitutions Product...: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5) Build.: 10.5.5.11013 or higher Sections..: Reports/Labels Keywords..: PDF, PROPERTY, Font Substitution, TrueType, Device Font Did you know that you can specify a replacement font for all reports/labels using the MS San Serif device font when printing to PDF output? When printing to the PDF output, the MS Sans Serif device font is substituted with Helvetica (native PDF font), which is wider than MS Sans Serif, and may result in characters being truncated. The substitution logic is true for all device fonts, which is indicated by a monitor icon in the font drop-down, within the Report Designer's Format toolbar. MS Sans Serif is in the Swiss font family which are recognized by variable stroke widths, which are proportional to the actual widths of the glyphs, and which do not have serifs. R:BASE has been updated to optionally change the replacement font for all reports/labels using the MS San Serif device font, or any fonts in the Swiss font family, when printing to PDF output. Any TrueType font can be used for the substitution. The following command may be used at the R:BASE startup to specify a replacement font: PROPERTY REPORT PDF_SERIF_FONT_REPLACEMENT 'Arial' To clear a substitution, use the following command to pass a space as the font name. PROPERTY REPORT PDF_SERIF_FONT_REPLACEMENT ' ' Very Best R:egards, Razzak. R:BASE Technologies, Inc. https://www.rbase.com -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/58318de7-abaf-5da3-92a1-4e6402db9c85%40rbase.com. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/820681693.1150422.1665683504286%40mail.yahoo.com.
Re: [RBASE-L] - Finding Duplicates
Select col1, col2 from table group by col1, col2 having count(*) > 1 Karen Sent from my iPhone > On Sep 19, 2022, at 3:50 AM, johnd...@gmail.com wrote: > > Hi, > > I am not sure if I am missing something that already exists but I was > wondering if there is a quick way of identifying duplicates in a table using > more than one column to do the selection. I was thinking of something similar > to the DELETE DUPLICATES command - but without the DELETE. I just want to see > if any duplicates exist. > > If anyone can tell me if this can be done that would be very much appreciated. > > Thank you. > > Regards > John Docherty > -- > 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. > To view this discussion on the web visit > https://groups.google.com/d/msgid/rbase-l/4691e5f2-c2da-4b1e-b00f-f1963382d197n%40googlegroups.com. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/F03C3DF3-920D-4CBB-A125-9D0393E5CC93%40cs.com.
Re: [RBASE-L] - Using Multiselect in dialog lookup
Hey, Brad is right I removed the quotes around 'TRUE' and it works now!
The print-screen that I had copied from the What's New when it was announced
had quotes
Karen
-Original Message-
From: bcdavid...@outlook.com
To: rbase-l@googlegroups.com
Sent: Mon, Aug 22, 2022 11:25 am
Subject: Re: [RBASE-L] - Using Multiselect in dialog lookup
#yiv5784782385 P {margin-top:0;margin-bottom:0;}Dan,
Try removing single quotes around 'TRUE' and include Karen's tip on
POPUP_LIST...:
My lookup with multiselect option works fine:
DIALOG 'Send Email To (use comma to add additional email addresses)' vcidlist
vendkey 1 +CAPTION ' Testing Popup with MultiSelect' +OPTION DIALOG_EDIT_HINT
'Double-Click for a List of Contacts' +|POPUP_ENABLED TRUE
+|POPUP_DIALOG_TYPE LOOKUP +|POPUP_TITLE_TEXT 'Select Contact(s) to Add'
+|POPUP_CAPTION 'List of Contacts' +|POPUP_TABLE Contacts +|POPUP_SELECT
Cid,Cname,Cemail +|POPUP_WHERE WHERE Cemail IS NOT NULL ORDER BY Cname ASC
+|POPUP_RETURN_COLUMN Cid +|POPUP_SHOW_LINES TRUE +|POPUP_RETURN_TYPE column
+|POPUP_LIST_MULTISELECT TRUE +|POPUP_LINES 20
Brad Davidsonbcdavidson@outlook.comFrom: rbase-l@googlegroups.com
on behalf of Dan Goldberg
Sent: Monday, August 22, 2022 9:18 AM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Using Multiselect in dialog lookup Thx all i put in a
bug request to the RBTI crew.
Dan GoldbergLance CamperFrom: rbase-l@googlegroups.com
on behalf of Doug Hamilton
Sent: Monday, August 22, 2022 8:58:23 AM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Using Multiselect in dialog lookup Jan et al - to
minimize irrelevant options, I tried the following:
DIALOG 'Send Email To(use comma to add additional email addresses)' veemail +
whtemp 1 CAPTION .vecaption OPTION DIALOG_EDIT_HINT +
'Double-Click for a List of Contacts' +
|POPUP_ENABLED ON +
|MULTISELECT ON +
|POPUP_TABLE CLIENT +
|POPUP_SELECT c_CliName,EMAIL +
|POPUP_WHERE +
WHERE c_CliName IS NOT NULL +
ORDER BY c_CliName ASC +
|POPUP_RETURN_COLUMN EMAIL
Also tried POPUP_LIST_MULTISELECT 'TRUE' in place ofMULTISELECT ON
Table and column names have been changed so it works in my system.
I couldn't get multi-select to work with either multi-clicking, Shift-Click or
Ctrl-Click.
BTW, 'WHERE' is required: | POPUP_WHERE WHERE full_name IS NOT NULL +
Doug
On 8/22/2022 10:14 AM, jan johansen wrote:
Dan, Shot in the dark but I know that some commands were pretty finicky about
the order of options.Have you tried re-ordering the command?I noticed that your
"multiselect" option is after your where clause. Jan
From: Dan Goldberg
To: "rbase-l@googlegroups.com"
Date: Mon, 22 Aug 2022 14:42:52 +
Subject: RE: Re[2]: [RBASE-L] - Using Multiselect in dialog lookup
Thx but it multiselect is still not working. here is my command. Maybe I am
not seeing why the multiselect would not trigger. It pops up but cannot multi
select. DIALOG 'Send Email To(use comma to add additional email addresses)'
veemail +whtemp 1 CAPTION .vecaption OPTION DIALOG_EDIT_HINT +'Double-Click for
a List of Contacts' |POPUP_ENABLED ON | POPUP_DIALOG_TYPE +LOOKUP
|POPUP_TITLE_FONT_NAME VERDANA | POPUP_TITLE_FONT_SIZE 10
|+POPUP_TITLE_FONT_BOLD TRUE | POPUP_TITLE_FONT_COLOR GREEN
|+POPUP_TITLE_BACK_COLOR WHITE | POPUP_TITLE_TEXT 'Select Contact(s) to Add'
|+POPUP_LIST_FONT_COLOR GREEN | POPUP_LIST_BACK_COLOR WHITE |+POPUP_CAPTION
'List of Contacts' | POPUP_TABLE Menuaccess |+POPUP_SELECT Full_Name,EmailAdd
|POPUP_WHERE WHERE full_name IS NOT NULL +ORDER BY full_name ASC |
POPUP_LIST_MULTISELECT 'TRUE' | +POPUP_RETURN_COLUMN emailadd |POPUP_SHOW_LINES
TRUE |POPUP_RETURN_TYPE +COLUMN | POPUP_LINES 20 Dan Goldberg From: 'Karen
Tellef' via RBASE-L
Sent: Monday, August 22, 2022 7:20 AM
To: rbase-l@googlegroups.com
Subject: Re: Re[2]: [RBASE-L] - Using Multiselect in dialog lookup Hey Dan, I
missed that you're asking about the multi-select! Here's the code that I use
for that, different than what you have POPUP_LIST_MULTISELECT 'TRUE' Karen
-Original Message-
From: Bruce Chitiea
To: rbase-l@googlegroups.com
Sent: Mon, Aug 22, 2022 8:52 am
Subject: Re[2]: [RBASE-L] - Using Multiselect in dialog lookupKaren: Your
code:|POPUP_WHERE ORDER BY Company + Dan's code:| POPUP_WHERE WHERE full_name
IS NOT NULL + Bruce -- Original Message --From "'Karen Tellef' via
RBASE-L" To "rbase-l@googlegroups.com"
Date 8/22/2022 6:46:39 AMSubject Re: [RBASE-L] -
Using Multiselect in dialog lookup
Bruce: your code looks identical to what I use, but with one exception. In
none of the rows do I have quotation marks. Not sure I see any other
differences (mine also has a bunch of font settings I left out here). Here's
an example of a live one that works for me: DIALOG 'Enter Customer ID'
vResponse=33 vEndKey 1 CAPTION .vCaption ICON APP +
OPTION DIALOG_EDIT_HINT Double-Click for List of Customers +
|POPUP_
Re: [RBASE-L] - Using Multiselect in dialog lookup
Me too, Doug. I tried various iterations and couldn't get multi-select to work. Like you I tried clicking, shift and control. I've never tried to use this in production Karen -Original Message- From: Doug Hamilton To: rbase-l@googlegroups.com Sent: Mon, Aug 22, 2022 10:58 am Subject: Re: [RBASE-L] - Using Multiselect in dialog lookup Jan et al - to minimize irrelevant options, I tried the following: DIALOG 'Send Email To(use comma to add additional email addresses)' veemail + whtemp 1 CAPTION .vecaption OPTION DIALOG_EDIT_HINT + 'Double-Click for a List of Contacts' + |POPUP_ENABLED ON + |MULTISELECT ON + |POPUP_TABLE CLIENT + |POPUP_SELECT c_CliName,EMAIL + |POPUP_WHERE + WHERE c_CliName IS NOT NULL + ORDER BY c_CliName ASC + |POPUP_RETURN_COLUMN EMAIL Also tried POPUP_LIST_MULTISELECT 'TRUE' in place of MULTISELECT ON Table and column names have been changed so it works in my system. I couldn't get multi-select to work with either multi-clicking, Shift-Click or Ctrl-Click. BTW, 'WHERE' is required: | POPUP_WHERE WHERE full_name IS NOT NULL + Doug On 8/22/2022 10:14 AM, jan johansen wrote: Dan, Shot in the dark but I know that some commands were pretty finicky about the order of options. Have you tried re-ordering the command? I noticed that your "multiselect" option is after your where clause. Jan From: Dan Goldberg To: "rbase-l@googlegroups.com" Date: Mon, 22 Aug 2022 14:42:52 + Subject: RE: Re[2]: [RBASE-L] - Using Multiselect in dialog lookup Thx but it multiselect is still not working. here is my command. Maybe I am not seeing why the multiselect would not trigger. It pops up but cannot multi select. DIALOG 'Send Email To(use comma to add additional email addresses)' veemail + whtemp 1 CAPTION .vecaption OPTION DIALOG_EDIT_HINT + 'Double-Click for a List of Contacts' |POPUP_ENABLED ON | POPUP_DIALOG_TYPE + LOOKUP |POPUP_TITLE_FONT_NAME VERDANA | POPUP_TITLE_FONT_SIZE 10 |+ POPUP_TITLE_FONT_BOLD TRUE | POPUP_TITLE_FONT_COLOR GREEN |+ POPUP_TITLE_BACK_COLOR WHITE | POPUP_TITLE_TEXT 'Select Contact(s) to Add' |+ POPUP_LIST_FONT_COLOR GREEN | POPUP_LIST_BACK_COLOR WHITE |+ POPUP_CAPTION 'List of Contacts' | POPUP_TABLE Menuaccess |+ POPUP_SELECT Full_Name,EmailAdd |POPUP_WHERE WHERE full_name IS NOT NULL + ORDER BY full_name ASC | POPUP_LIST_MULTISELECT 'TRUE' | + POPUP_RETURN_COLUMN emailadd |POPUP_SHOW_LINES TRUE |POPUP_RETURN_TYPE + COLUMN | POPUP_LINES 20 Dan Goldberg From: 'Karen Tellef' via RBASE-L Sent: Monday, August 22, 2022 7:20 AM To: rbase-l@googlegroups.com Subject: Re: Re[2]: [RBASE-L] - Using Multiselect in dialog lookup Hey Dan, I missed that you're asking about the multi-select! Here's the code that I use for that, different than what you have POPUP_LIST_MULTISELECT 'TRUE' Karen -Original Message- From: Bruce Chitiea To: rbase-l@googlegroups.com Sent: Mon, Aug 22, 2022 8:52 am Subject: Re[2]: [RBASE-L] - Using Multiselect in dialog lookupKaren: Your code:|POPUP_WHERE ORDER BY Company + Dan's code: | POPUP_WHERE WHERE full_name IS NOT NULL + Bruce -- Original Message -- From "'Karen Tellef' via RBASE-L" To "rbase-l@googlegroups.com" Date 8/22/2022 6:46:39 AM Subject Re: [RBASE-L] - Using Multiselect in dialog lookup Bruce: your code looks identical to what I use, but with one exception. In none of the rows do I have quotation marks. Not sure I see any other differences (mine also has a bunch of font settings I left out here). Here's an example of a live one that works for me: DIALOG 'Enter Customer ID' vResponse=33 vEndKey 1 CAPTION .vCaption ICON APP + OPTION DIALOG_EDIT_HINT Double-Click for List of Customers + |POPUP_ENABLED TRUE + |POPUP_DIALOG_TYPE LOOKUP + |POPUP_CAPTION List of Customers + |POPUP_TABLE Customer + |POPUP_SELECT Company, CustCity + ',' & CustState & CustZip + |POPUP_RETURN_COLUMN CustID + |POPUP_WHERE ORDER BY Company + |POPUP_SHOW_LINES TRUE + |POPUP_RETURN_TYPE COLUMN + |POPUP_LINES 20 + |POPUP_DISTINCT TRUE Karen -Original Message- From: Bruce Chitiea To: rbase-l@googlegroups.com Sent: Sun, Aug 21, 2022 8:31 pm Subject: Re: [RBASE-L] - Using Multiselect in dialog lookupFWIW: Highlighted the only thing that stood out to me Bruce DIALOG 'Send Email To(use comma to add additional email addresses)' veemail whtemp 1 +CAPTION .vecaption +OPTION DIALOG_EDIT_HINT 'Double-Click for a List of Contacts' +|POPUP_ENABLED TRUE +-- rsyntax: POPUP_ENABLED [ ON | OFF ] |POPUP_DIALOG_TYPE LOOKUP +|POPUP_TITLE_TEXT 'Select Contact(s) to Add' +|POPUP_CAPTION 'List of Contacts' +|POPUP_TABLE Menuaccess +|POPUP_SE
Re: Re[2]: [RBASE-L] - Using Multiselect in dialog lookup
Hey Dan, I missed that you're asking about the multi-select! Here's the code that I use for that, different than what you have POPUP_LIST_MULTISELECT'TRUE' Karen -Original Message- From: Bruce Chitiea To: rbase-l@googlegroups.com Sent: Mon, Aug 22, 2022 8:52 am Subject: Re[2]: [RBASE-L] - Using Multiselect in dialog lookup Karen: Your code:|POPUP_WHERE ORDER BY Company + Dan's code:| POPUP_WHERE WHERE full_name IS NOT NULL + Bruce -- Original Message --From "'Karen Tellef' via RBASE-L" To "rbase-l@googlegroups.com" Date 8/22/2022 6:46:39 AMSubject Re: [RBASE-L] - Using Multiselect in dialog lookup Bruce: your code looks identical to what I use, but with one exception. In none of the rows do I have quotation marks. Not sure I see any other differences (mine also has a bunch of font settings I left out here). Here's an example of a live one that works for me: DIALOG 'Enter Customer ID' vResponse=33 vEndKey 1CAPTION .vCaption ICON APP + OPTION DIALOG_EDIT_HINT Double-Click for List of Customers + |POPUP_ENABLED TRUE + |POPUP_DIALOG_TYPE LOOKUP + |POPUP_CAPTION List of Customers + |POPUP_TABLE Customer + |POPUP_SELECT Company, CustCity + ',' & CustState & CustZip + |POPUP_RETURN_COLUMN CustID + |POPUP_WHERE ORDER BY Company + |POPUP_SHOW_LINES TRUE + |POPUP_RETURN_TYPE COLUMN + |POPUP_LINES 20 + |POPUP_DISTINCT TRUE Karen -Original Message- From: Bruce Chitiea To: rbase-l@googlegroups.com Sent: Sun, Aug 21, 2022 8:31 pm Subject: Re: [RBASE-L] - Using Multiselect in dialog lookup FWIW: Highlighted the only thing that stood out to meBruce DIALOG 'Send Email To(use comma to add additional email addresses)' veemail whtemp 1 +CAPTION .vecaption +OPTION DIALOG_EDIT_HINT 'Double-Click for a List of Contacts' +|POPUP_ENABLED TRUE +-- rsyntax: POPUP_ENABLED [ ON | OFF ] |POPUP_DIALOG_TYPE LOOKUP +|POPUP_TITLE_TEXT 'Select Contact(s) to Add' +|POPUP_CAPTION 'List of Contacts' +|POPUP_TABLE Menuaccess +|POPUP_SELECT Full_Name,EmailAdd +|POPUP_WHERE WHERE full_name IS NOT NULL ORDER BY full_name ASC +|POPUP_RETURN_COLUMN emailadd +|POPUP_SHOW_LINES TRUE +|POPUP_RETURN_TYPE column +|MULTISELECT TRUE +|POPUP_LINES 20 -- Original Message --From "Dan Goldberg" To "rbase-l@googlegroups.com" Date 8/21/2022 6:11:53 PMSubject [RBASE-L] - Using Multiselect in dialog lookup I have the following command to bring up a popup. It works but I cannot get the multiselect to work in the popup. Anyone have any blues clues on what I am doing wrong? DIALOG 'Send Email To(use comma to add additional email addresses)' veemail + whtemp 1 CAPTION .vecaption OPTION DIALOG_EDIT_HINT + 'Double-Click for a List of Contacts' |POPUP_ENABLED TRUE | + POPUP_DIALOG_TYPE LOOKUP |POPUP_TITLE_FONT_NAME VERDANA | + POPUP_TITLE_FONT_SIZE 10 |POPUP_TITLE_FONT_BOLD TRUE | + POPUP_TITLE_FONT_COLOR GREEN |POPUP_TITLE_BACK_COLOR WHITE | + POPUP_TITLE_TEXT 'Select Contact(s) to Add' |POPUP_LIST_FONT_COLOR GREEN | + POPUP_LIST_BACK_COLOR WHITE |POPUP_CAPTION 'List of Contacts' | + POPUP_TABLE Menuaccess |POPUP_SELECT Full_Name,EmailAdd | POPUP_WHERE + WHERE full_name IS NOT NULL + ORDER BY full_name ASC | POPUP_RETURN_COLUMN emailadd |POPUP_SHOW_LINES + TRUE |POPUP_RETURN_TYPE column | MULTISELECT TRUE | POPUP_LINES 20 TIA Dan Goldberg -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0014F0CB565%40EXCHANGE10. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/emf8c5c1d7-fb83-41ef-a681-4a6bda0a8df1%40f8ecd6cd.com. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/142327202.901918.1661175999630%40mail.yahoo.com. -- 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 a
Re: [RBASE-L] - Using Multiselect in dialog lookup
Bruce: your code looks identical to what I use, but with one exception. In
none of the rows do I have quotation marks. Not sure I see any other
differences (mine also has a bunch of font settings I left out here). Here's
an example of a live one that works for me:
DIALOG 'Enter Customer ID' vResponse=33 vEndKey 1CAPTION .vCaption ICON APP +
OPTION DIALOG_EDIT_HINT Double-Click for List of Customers +
|POPUP_ENABLED TRUE +
|POPUP_DIALOG_TYPE LOOKUP +
|POPUP_CAPTION List of Customers +
|POPUP_TABLE Customer +
|POPUP_SELECT Company, CustCity + ',' & CustState & CustZip +
|POPUP_RETURN_COLUMN CustID +
|POPUP_WHERE ORDER BY Company +
|POPUP_SHOW_LINES TRUE +
|POPUP_RETURN_TYPE COLUMN +
|POPUP_LINES 20 +
|POPUP_DISTINCT TRUE
Karen
-Original Message-
From: Bruce Chitiea
To: rbase-l@googlegroups.com
Sent: Sun, Aug 21, 2022 8:31 pm
Subject: Re: [RBASE-L] - Using Multiselect in dialog lookup
#yiv6784334522 #yiv6784334522 --#yiv6784334522xa4ee28077147422
p.yiv6784334522MsoNormal{margin:0in;font-size:11pt;font-family:Calibri,
sans-serif;}#yiv6784334522 #yiv6784334522xa4ee28077147422
div.yiv6784334522WordSection1{}#yiv6784334522 #yiv6784334522 #yiv6784334522
--blockquote.yiv6784334522cite
{margin-left:5px;margin-right:0px;padding-left:10px;padding-right:0px;border-left:1px
solid #cc;}#yiv6784334522 blockquote.yiv6784334522cite2
{margin-left:5px;margin-right:0px;padding-left:10px;padding-right:0px;border-left:1px
solid #cc;margin-top:3px;padding-top:0px;}#yiv6784334522 a img
{border:0px;}#yiv6784334522 #yiv6784334522 #yiv6784334522 #yiv6784334522 ,
#yiv6784334522 #yiv6784334522 #yiv6784334522 #yiv6784334522 , #yiv6784334522
#yiv6784334522 #yiv6784334522 #yiv6784334522 , #yiv6784334522 #yiv6784334522
#yiv6784334522 #yiv6784334522 {list-style-position:inside;}#yiv6784334522 body
{font-size:12pt;}#yiv6784334522 .yiv6784334522quote
{margin-left:1em;margin-right:1em;border-left:5px #ebebeb
solid;padding-left:0.3em;}#yiv6784334522 FWIW: Highlighted the only thing that
stood out to meBruce
DIALOG 'Send Email To(use comma to add additional email addresses)' veemail
whtemp 1 +CAPTION .vecaption +OPTION DIALOG_EDIT_HINT 'Double-Click for a
List of Contacts' +|POPUP_ENABLED TRUE +-- rsyntax: POPUP_ENABLED [ ON | OFF ]
|POPUP_DIALOG_TYPE LOOKUP +|POPUP_TITLE_TEXT 'Select Contact(s) to Add'
+|POPUP_CAPTION 'List of Contacts' +|POPUP_TABLE Menuaccess +|POPUP_SELECT
Full_Name,EmailAdd +|POPUP_WHERE WHERE full_name IS NOT NULL ORDER BY
full_name ASC +|POPUP_RETURN_COLUMN emailadd +|POPUP_SHOW_LINES TRUE
+|POPUP_RETURN_TYPE column +|MULTISELECT TRUE +|POPUP_LINES 20
-- Original Message --From "Dan Goldberg" To
"rbase-l@googlegroups.com" Date 8/21/2022 6:11:53
PMSubject [RBASE-L] - Using Multiselect in dialog lookup
I have the following command to bring up a popup. It works but I cannot get the
multiselect to work in the popup. Anyone have any blues clues on what I am
doing wrong? DIALOG 'Send Email To(use comma to add additional email
addresses)' veemail + whtemp 1 CAPTION .vecaption OPTION DIALOG_EDIT_HINT +
'Double-Click for a List of Contacts' |POPUP_ENABLED TRUE | + POPUP_DIALOG_TYPE
LOOKUP |POPUP_TITLE_FONT_NAME VERDANA | + POPUP_TITLE_FONT_SIZE 10
|POPUP_TITLE_FONT_BOLD TRUE | + POPUP_TITLE_FONT_COLOR GREEN
|POPUP_TITLE_BACK_COLOR WHITE | + POPUP_TITLE_TEXT 'Select Contact(s) to Add'
|POPUP_LIST_FONT_COLOR GREEN | + POPUP_LIST_BACK_COLOR WHITE |POPUP_CAPTION
'List of Contacts' | + POPUP_TABLE Menuaccess |POPUP_SELECT Full_Name,EmailAdd
| POPUP_WHERE + WHERE full_name IS NOT NULL + ORDER BY full_name ASC |
POPUP_RETURN_COLUMN emailadd |POPUP_SHOW_LINES + TRUE |POPUP_RETURN_TYPE column
| MULTISELECT TRUE | POPUP_LINES 20 TIA Dan Goldberg
--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0014F0CB565%40EXCHANGE10.
--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/emf8c5c1d7-fb83-41ef-a681-4a6bda0a8df1%40f8ecd6cd.com.
--
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.
To view
Re: [RBASE-L] - Sending a HTML email with rmail
I had some free time, decided to test this. Right now, I send out RMail with HTML in the body, but I am inserting data into a table and then using "select... as html". I had never used a report yet so I decided to try it. I printed my report with OPTION HTML as you did. Right away, I noticed that my htm file when launched had only one "page" of information on it, rather than the 3 pages the printed document would be. So if that's normal behavior, then that limits what you can use the HTML option for. But I sent the shortened htm file anyway as the body of the email. I did get the full one page of info in the body, but it's all jumbled up, didn't get a full one-line of the data Karen -Original Message- From: Dan Angcao To: rbase-l@googlegroups.com Sent: Thu, Aug 18, 2022 1:13 pm Subject: [RBASE-L] - Sending a HTML email with rmail I have a problem trying to send an email in rmail with the body of the email being HTLM format.I have rbaseX and rmailX I create a variable as varcharset var vbody varchar I created a report that only has the vbody variable on it. I print it with this command. print HTMLemail option HTML|filename body.htm|output_styles_to_css_file off I can see the body.htm file looks just like I want it to look. I send the email with rmail with these commands PLUGINS RMail v1|MESSAGE_TYPE html PLUGINS RMail v1|LOAD_MESSAGE_BODY_FROM_FILE body.htm The rmail progress screen shows the email is going out. The v1 variable shows ‘ok’. But the email never arrives. If I use the same code but send as plain text the mail comes right though. Any ideas? Dan -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/041e01d8b32e%242cda9660%24868fc320%24%40emicrodesign.com. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/1099544897.195827.1660849751300%40mail.yahoo.com.
Re: [RBASE-L] - using column name in report variables
I don't think I've ever tried that, but I'm not surprised it doesn't work. If it was me, I would create 2 variables (I'm winging this, so syntax might not be exactly right): VpartlocA = partnum2 in mastervendors where part# = part# and PriSupplerL = 'Y'VpartlocB = partnum2 in mastervendors where part# = part# and PriSupplerD = 'Y' Vpartnum2 = (ifeq(vpltaccess2,'L', .vpartlocA, .vpartlocB)) Karen -Original Message- From: Dan Goldberg To: rbase-l@googlegroups.com Sent: Mon, Jul 25, 2022 3:06 pm Subject: [RBASE-L] - using column name in report variables I have a few variables in a report. Vpartloc = (ifeq(vpltaccess2,'L','PriSupplerL','PriSupplerD')) I want to create a lookup based on that column name in vpartloc Vpartnum2 = partnum2 in mastervendors where part# = part# and = 'Y' I usually use the & symbol to substitute for the column name but it gives me an error when I try to save the variable. Any ideas why it does not work? TIA Dan Goldberg -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0014F0903AC%40EXCHANGE10. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/1042612017.1545249.1658779907686%40mail.yahoo.com.
Re: [RBASE-L] - Detecting Row With Focus In Scrolling Region
Just create a form variable to the unique ID of the row (no need to use an EEP). So focus will evaluate all the variables Karen -Original Message- From: James Burroughs To: rbase-l@googlegroups.com Sent: Thu, Jun 23, 2022 10:09 pm Subject: [RBASE-L] - Detecting Row With Focus In Scrolling Region Does anyone know if there is a way to detect which row within a scrolling region has the focus? For example, I would like to put code in the double-click EEP to perform certain actions, but only for the row which was clicked. Thanks, Jim -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/395bca56-e55e-d77a-2903-71f7320f05b6%40cox.net. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/484038500.234709.1656074707885%40mail.yahoo.com.
Re: [RBASE-L] - Help not Working
John: If you go into explorer, right-click on a CHM file and select "open with", what does it show? Attached is a pic of what my windows 10 computer shows Karen -Original Message- From: johnd...@gmail.com To: RBASE-L Sent: Tue, Jun 7, 2022 7:05 pm Subject: Re: [RBASE-L] - Help not Working Hi Razzak, I removed the two fonts in that folder and re-booted my laptop but still no luck with the first three items on the Help menu. The tutorial works though. Is there any difference in the 'mechanism' for running the help files ? (The chm files are exactly the same as the ones on the laptop where Help does work.) Thank you.John Docherty On Wednesday, June 8, 2022 at 8:05:16 AM UTC+12 johnd...@gmail.com wrote: Hi Razzak, Thanks for your reply. RBase is on the D drive. (I have a C & D on this laptop.) I did install a new font a while ago so I will try that later. (Just off out now - already late) I will let you know if that solves the issue. Thanks for your help. RegardsJohn Docherty On Wednesday, June 8, 2022 at 1:38:29 AM UTC+12 A. Razzak Memon wrote: Hello John, Is the R:BASE installation on the local C:\ drive, a secondary drive, or perhaps a network shared drive? Do you have custom fonts installed on the computer? Navigate to the "C:\Users\\AppData\Local\Microsoft\Windows\Fonts\" location and remove any custom fonts loaded in the folder. Very Best R:egards, Razzak. R:BASE Technologies, Inc. https://www.rbase.com At 01:32 AM 6/7/2022, johnd...@gmail.com wrote: >I was wondering if anyone has any suggestions as to why Help does >not work on one of my laptops. (It is fine with the same version on >the other one I use, so not an R:Base issue.) Any suggestions as to >what I should try would be much appreciated. (I have reinstalled the >latest version of Help but nothing changed.) > >Thank you. >Regards >John Docherty -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/02cafcd6-4f95-4ce6-bf05-024f91a497c7n%40googlegroups.com. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/1793811104.231039.1654697483281%40mail.yahoo.com.
Re: [RBASE-L] - Put together two rows of data from one table
Myron: Here's a thought. Can you use "LISTOF"? If you had a table with a FullName column, you can do a SELECT (LISTOF(fullname)) INTO variable WHERE householdid = You could create a view or temp table with the results of LISTOF with a GROUP BY parameter. If you want a separator other than a comma, I'd probably first get rid of any embedded commas in the fullname (like Will Jones, Jr) and then after the Listof you could replace a comma with your separator. Karen -Original Message- From: myron.fineg...@gmail.com To: rbase-l@googlegroups.com Sent: Fri, May 6, 2022 9:38 am Subject: RE: [RBASE-L] - Put together two rows of data from one table Bruce,There is a key column (PropertyID) in the table (housedetail) that identifies each individual house (roof) and each person in the house. So, if you were to look at my house you would have two rows of data identified by the ‘PropertyID’ key. Goal for the address header: Myron Finegold and Susan Shapiro (or any other variation)15132 Blackgold Ln.Sun City West, AZ 85375 Best regards, Myron Finegold15132 W Blackgold LnSun City West, AZ 85375 From: rbase-l@googlegroups.com On Behalf Of Bruce Chitiea Sent: May 5, 2022 5:28 PM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - Put together two rows of data from one table "... two rows of data identified by a unique number." To be clear, is this a key value common to the two rows, e.g. "householdID"? as in: 10001 | party110001 | party2 Did this for a series of gala invitations a while back, happy to dig it up tonite. Best, Bruce Bruce A. Chitiea | SafeSectors, Inc.112 Harvard Ave #272 | Claremont CA 91711-4716 | USA+011 (909) 238-9012 m | rby...@safesectors.com -- Original Message --From myron.finegold@gmail.comTo rbase-l@googlegroups.comDate 5/5/2022 5:17:42 PMSubject [RBASE-L] - Put together two rows of data from one table Goal: To creating an address label that has two separate names concatenated – for a mailing label. For example: Myron Finegold and Susan Shapiro. (The street information and the city and state are easy)The data: We have a table that tracks the owners of a house. (we have about 17,000 houses and 30,000 rows of data) So, if there are two owners there will be two rows of data identified by a unique number. Party 1 – first name and last name and other information; Party 2 first name and last name and other information.I’ve never done this and I’m not sure where to start. What is the best way to pragmatically do this?Thanks in advance. Myron Finegold / Sheriff’s Posse of Sun City West -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/000401d860de%24b480dd60%241d829820%24%40gmail.com.-- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/em3816b5d7-280a-4fe2-b37d-e6c7fea2d9fe%40e1947d0a.com.-- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/019001d86156%24ff5bd600%24fe138200%24%40gmail.com. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/251407538.215251.1651848427368%40mail.yahoo.com.
Re: [RBASE-L] - eMail table structure
Jan: I have one application with this ability. The structure was started by another programmer, so I don't take full credit. It isn't perfect, as we added features over the years and would've done it differently if I had designed it today. Here's the structure of the table (not all the columns), along with a description of what some of the columns are for. We have a scheduled task that runs every 20 minutes, scans the table for "xDateTimeSent is null". Cursors thru the rows, sends out using RMail, updates the xDateTimeSent. The program that deciphers all the elements is quite complicated. It was originally set up to send emails to "groups" (ReptGroup). There's a maintenance table that has a group name and a list of email addresses. So different programs will send emails to different "groups" of people (a group could have just one person). Later on, we needed the ability for users to send emails to specific people, not a group, so we created an AlertDetail table that has the to / from / cc information. It works really well for us. Table: Alert CmdFile Type : TEXT 50 This is the name of the RBase program that created the email ReptGroup Type : TEXT 8 The group the email is sent to; lookup to another table for email addresses xDateTime Type : DATETIME NOT NULL When the email was inserted xDateTimeSent Type : DATETIME When the email was sent by RMail AlertSubject Type : NOTEAlertFailed Type : DATETIME If RMail failed, date put here EmailTypeID Type : INTEGER Default: 1 1 = look at ReptGroup, 2 = look at AlertDetail table for email address AlertEmailType Type : TEXT 4 Default: TEXT This was added when we started using HTML as the body on some emails. Would have the word "HTML" AlertFileAttach Type : TEXT 120 Name of a file to attach AlertNote Type : NOTE If the email body is just a string text, it goes in here AlertTxtFile Type : TEXT 120 Or the email body can be contained in an external file, either ascii or html. So this would be the filename, like F:\EmailFiles\Orders.txt Hope this gives you some ideas!! Karen -Original Message- From: jan johansen To: rbase-l@googlegroups.com Sent: Wed, May 4, 2022 10:03 am Subject: [RBASE-L] - eMail table structure Greetings, Was just wondering if anyone had a successful table structure to store emails to send, etcthat would be willing to share. 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/WC20220504150311.87010F%40jjcalibrations.com. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/1649618192.3458901.1651683163487%40mail.yahoo.com.
Re: [RBASE-L] - Delete Trigger mystery?
Jim:
Yes, I found the ability to "ABORT TRIGGER" from within the Before Delete
trigger, and I verified that it does work. I had added a message to the user
in the trigger telling them that they had somehow deleted a record so I changed
it to include the "abort trigger" and changed the message to the user.
So far no more deletes have happened. We still have no clues how it happens
when it does
Karen
-Original Message-
From: 'James Bentley' via RBASE-L
To: rbase-l@googlegroups.com
Sent: Thu, Mar 31, 2022 4:30 am
Subject: Re: [RBASE-L] - Delete Trigger mystery?
Karen,Search RBase Help for SYS_OLD used in the command element WHERE CURRENT
OF SYS_OLD in the BEFORE DELETE trigger.Be aware that access to SYS_OLD record
is only available in the BEFORE DELETE trigger not in an AFTER DELETE trigger
where according to SQL syntax where the update of the archive table should be
updated.
Jim Bentley, American Celiac Society 1-504-305-2968
On Friday, March 11, 2022, 06:01:51 PM CST, 'Karen Tellef' via RBASE-L
wrote: B
Why I needed the before-delete trigger: no one should ever be deleting data
from this table. And althonugh they have the full version of RBase, no one
knows how to "get to the R> prompt". There is a monthend routine that the
senior user runs that will delete a batch of data, but that's all (we remove
the trigger before this monthend routine, then put it back on)
Yet every now and then we find data mysteriously disappeared.
So I created a before-delete trigger. It takes the record to be deleted and
appends it to an archive table. 3 columns in the archive table will hold the
deleted date / time and the user who deleted it. Works perfectly at my
development environment and when I test it at the place where the database is
installed. Records the date, time and the user.
However, twice now we have found records in that archive table that had been
deleted (hundreds at a time). The records had the deleted date/time but had NO
user name.
Here's the code I use in my stored procedure. The DeletedDate and DeletedTime
works fine, it gets updated every time. There is no login to this app, so I
grab the NetUser (used many times in the application for other things,
successfully). The first time that the archive had no user name, I modified
the stored procedure to grab the ComputerName. But still, nothing.
SET VAR vText TEXT = NULL
SET VAR vText = (CVAL("NetUser"))
IF vText IS NULL THEN
SET VAR vText = (CVAL("ComputerName"))
ENDIF
UPDATE ClaimsDeleted SET DeletedDate = .#DATE, DeletedTime = .#TIME, +
DeletedBy = .vText WHERE claim = .spClaim
Can anyone think of anything else I can trap that would help me figure out
how/when the records got deleted?
Or does anyone know how records could get deleted when there actually is no
NetUser or ComputerName?
Karen
--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/1654695576.980450.1647043308102%40mail.yahoo.com.
--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/1579508681.180222.1648719038761%40mail.yahoo.com.
--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/1906605611.264489.1648738815937%40mail.yahoo.com.
Re: [RBASE-L] - DOS command line prompt
Cool, glad it worked! I find that good old-fashioned batch files are useful for SO many things (I often use them with Dir ... /b as you are doing). A developer friend of mine writes all kinds of neat utilities like turning PDF files into CSV files, PDFs into JPGs, fun things like that. And I call all his utilities from batch files, creating them on the fly to pass in the name of files, etc I would most gladly take you up on the lunch offer! And would look forward to any king off R:Gathering Karen -Original Message- From: 'jim schmitt' via RBASE-L To: 'Karen Tellef' via RBASE-L Sent: Tue, Mar 22, 2022 7:48 pm Subject: Re: [RBASE-L] - DOS command line prompt Karen: WOW !!! Just wanted to say thanks again as this is exactly what I wanted, and it works perfect. Never had to use a Launch of a BAT file before. After I exicute the Launch of .the BAT command, I can then load the values into a table for further processing.Works like a charm. I owe you a lunch at the next R:Gathering...Thanks again Jim On Tuesday, March 22, 2022, 03:10:04 PM EDT, 'Karen Tellef' via RBASE-L wrote: Absolutely! What you want to do is create a batch file (.BAT) that has your DIR command and you "LAUNCH" the .BAT file from within RBase. Either have the batch file permanently there or you can create the batch file on the fly if you want it dynamic Karen -Original Message- From: 'jim schmitt' via RBASE-L To: rbase group Sent: Tue, Mar 22, 2022 2:00 pm Subject: [RBASE-L] - DOS command line prompt Hello, group: I have an application in which I need to find the names of some CSV payment files. The payment files are composed of the word 'PAYMENTS_' followed by the date in 'MMDD format. ie. 'PAYMENTS_20220302.CSV', or 'PAYMENTS_20220310.CSV'. I have been playing around with the DIR command from a Command prompt., which produces the names of needed files. When using the following command in a command prompt, (dir payments_* /B >myfile), it puts the names of the payments file into a file called 'myfile', which is exactly what I need.. The question: Is their any way that this dos command can be executed within a RBase program , such as ZIP, Launch, ??? ?Ver RBGX5E Thanks for any input. Jim Schmitt1-614-361-3942 -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/1033887566.1905707.1647975613894%40mail.yahoo.com. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/1786837149.1180146.1647976197714%40mail.yahoo.com. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/2037440939.2035423.1647996508643%40mail.yahoo.com. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/392611835.1388570.1648040309717%40mail.yahoo.com.
Re: [RBASE-L] - DOS command line prompt
Absolutely! What you want to do is create a batch file (.BAT) that has your DIR command and you "LAUNCH" the .BAT file from within RBase. Either have the batch file permanently there or you can create the batch file on the fly if you want it dynamic Karen -Original Message- From: 'jim schmitt' via RBASE-L To: rbase group Sent: Tue, Mar 22, 2022 2:00 pm Subject: [RBASE-L] - DOS command line prompt Hello, group: I have an application in which I need to find the names of some CSV payment files. The payment files are composed of the word 'PAYMENTS_' followed by the date in 'MMDD format. ie. 'PAYMENTS_20220302.CSV', or 'PAYMENTS_20220310.CSV'. I have been playing around with the DIR command from a Command prompt., which produces the names of needed files. When using the following command in a command prompt, (dir payments_* /B >myfile), it puts the names of the payments file into a file called 'myfile', which is exactly what I need.. The question: Is their any way that this dos command can be executed within a RBase program , such as ZIP, Launch, ??? ?Ver RBGX5E Thanks for any input. Jim Schmitt1-614-361-3942 -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/1033887566.1905707.1647975613894%40mail.yahoo.com. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/1786837149.1180146.1647976197714%40mail.yahoo.com.
Re: [RBASE-L] - Delete Trigger mystery?
Doug: I was thinking about whether to use something with IP Address. I won't
bother with "USER" because that looks at the CFG file, and I only have one CFG
file so everyone is "none". Tests show that UserID is the same as NetUser, but
what the heck, it's worth a try using those 2 other identifiers!
Karen
-Original Message-
From: Doug Hamilton
To: rbase-l@googlegroups.com
Sent: Tue, Mar 15, 2022 1:23 pm
Subject: Re: [RBASE-L] - Delete Trigger mystery?
I set up a DBActivityLogger table to track various events when/where needed.
I set variables for form name, component ID, etc and then RUN SELECT a little
routine that adds a row of data to the table.
To get user info that goes into a column in the table; I use:
SET VAR +
pDBLogUser = ( +
'NetUser:' + (CVAL('NETUSER')) + +
';WinUser:' + (CVAL('USERID')) + +
';RBUser:' + (CVAL('USER')) ), +
pDBLogLocation = ('IP Addr:' & (GETVAL('GetIPAddress','1')) )
Maybe one of those will help you track the errant deleter.
Doug
On 3/15/2022 11:48 AM, 'Karen Tellef' via RBASE-L wrote:
Yes I'm set on the archive table holding the records that were deleted, easy
to restore. The only thing missing is the Before Delete Trigger recording the
name of the user who did the deleting so we can figure out how it's getting
done. No clue why the user comes up Null
One thing I added to my trigger is a Pause statement in red and white telling
the user to get ahold of me or the office manager right away and tell them what
menu option you're running, etc. The person/program who just deleted 200
records is going to be pressing [enter] a bunch of times (most likely will
reboot their computer, yikes)
I guess I'll have to look at GRANT. A quick read of the help screens (I've
never used Grant in all my decades of RBase work) shows that I need to first
set up a bunch of SET USER commands. Dialed into the company, and the USER
name is set to "NONE". I use CVAL("NetUser") anytime I need to identify a
user, I never refer to the cfg file for anything. So I'm guessing I could set
USER equal to NetUser, and then Grant Delete privileges only to the one person
that I sorta trust? She of course claims she's not the one deleting, but I
can't say I'm 100% on board with that.
Karen
-Original Message-
From: baue...@gmail.com
To: RBASE-L
Sent: Tue, Mar 15, 2022 11:32 am
Subject: Re: [RBASE-L] - Delete Trigger mystery?
At this juncture, I would go straight to the GRANT on permissions to lock down
the tables to specific uses, based on users. If there is no Damage occurring,
then this would eliminate any deletions without identifying the user first.
On Tuesday, March 15, 2022 at 12:24:25 PM UTC-4 baue...@gmail.com wrote:
And I missed the deletions from the Archive table as well. Ok then. The
Archive table is just that, without any triggers period? If that is the case,
then the ONLY way is through active persons doing it.
On Tuesday, March 15, 2022 at 12:19:13 PM UTC-4 baue...@gmail.com wrote:
Alrighty then.. I guess I missed that and why I earlier suggested as much,
using either of "Delete Flag) (in lieu of ACTUAL DELETION) and / or a separate
table " Add a second table, as you have already done to contain just the
records marked as deleted. This would be to determine if there are any actual
deletions occurring in either table and if there are any deletions, is there
any commonality to the deletions. " So at least you have protection! And from
my above comment, I assume there are NO deletions in your archive table, so it
still points to the two possibilities outline previously.
On Tuesday, March 15, 2022 at 10:55:21 AM UTC-4 Karen Tellef wrote:
They are stored nicely in the table that the Before Delete Trigger saves to,
so it's an easy "append". Much easier than RScope!
Karen
-Original Message-
From: baue...@gmail.com
To: RBASE-L
Sent: Tue, Mar 15, 2022 9:41 am
Subject: Re: [RBASE-L] - Delete Trigger mystery?
Also, If you did NOT know, since the DB is not damaged, those deleted rows
are recovered fairly easily with R:Scope. From R:Scope
5.4.2.2 Manually Fixing the Data File
The Manual option allows you more control over the data file than the
Automatic option. By using the
Manual option, you can:
· Rebuild pointers in the data file
· Find and undelete rows of deleted data
5.4.2.2.7 Restoring and Deleting Row s
You can restore deleted rows to a table or delete existing rows from a table
by using R:Scope. If you
restore or delete rows, you will need to rebuild the indexes for the table.
Restoring Rows
R:BASE marks a row as deleted by making its row size a negative number.
To restore a deleted row:
1. Move the block cursor to the row you want to undelete.
2. Select the red button with the plus (+) or p
Re: [RBASE-L] - Delete Trigger mystery?
rch 14, 2022 at 5:58:29 PM UTC-4 Karen Tellef wrote: But we have NO CLUE where/when these deletions are happening. There is nowhere in code that I can add the insertion of a delete flag, because there honestly should be nowhere that a user (nor a program) is deleting these rows. This data has to do with lawsuits, and the data has to stay there until the lawsuit is settled and then the record is archived at monthend. We know someone isn't running this monthend routine when they shouldn't, because a bunch of other stuff would also happen at the same time, and none of that is happening Karen -Original Message- From: baue...@gmail.com To: RBASE-L Sent: Mon, Mar 14, 2022 3:23 pm Subject: Re: [RBASE-L] - Delete Trigger mystery? A "Delete Flag" is just a single character field that excludes the record from any results. It is in lieu of "Actual" deletion. Internally, I believe R:Base does the same thing with deleted records and they stay "so marked" until PACK or RELOAD occurs. By doing this, you can then restrict to a single event that would occur ONLY when one person, so authorized, has access to do so. The requirement for a password in advance of any deletions is a good stopgap too, so long as the password is not widely known, but you know a secret is only a secret when kept among 3 people and two of them are dead. On Monday, March 14, 2022 at 2:34:53 PM UTC-4 Karen Tellef wrote: Do you mean using GRANT to restrict deletion? You know, I have never once used GRANT in all the decades I've used RBase!!! I'd have to read up on how to use it. Do you assign permission to delete to only specific users? And what "name" is it using to assign permissions? Stuff like that that I don't have the answers to, would have to read up on. Also, I have nowhere in my code where the user is allowed to delete a record, so there wouldn't be anywhere to set some kind of "delete flag". No program deletes a batch of records other than the one monthend program which works fine to archive/delete records, we know that one works on the last day of the month as intended. Only one user has the password to run that routine and the monthend date is never the one that is erroneously deleting records. Karen -Original Message- From: baue...@gmail.com To: RBASE-L Sent: Sun, Mar 13, 2022 9:04 am Subject: Re: [RBASE-L] - Delete Trigger mystery? Well it might take a little work, but this is what I would do. #1 - I would lock the table down with access control as tight as practically possible. Add a single character field to the table to use as a Delete Flag (hangover from the old DBase days, using an asterisk (0x2A) as the marker or something else as your choosing). Having done that, you would have to change your code to exclude those marked as deleted. To the above, you might also add another table with just a datetime column that is added by a trigger from the main table that is updated ANY TIME the table is accessed (this will give you a timeframe to point to user activity involvement at the time of ANY access or deletions) Add a second table, as you have already done to contain just the records marked as deleted. This would be to determine if there are any actual deletions occurring in either table and if there are any deletions, is there any commonality to the deletions. It seems as the detective work is pointing to user access being the culprit, but maybe by taking extraordinary steps, it can be conclusive one way or another. On Saturday, March 12, 2022 at 2:45:33 PM UTC-5 Karen Tellef wrote: Adrian: I am assuming they were actually deleted. Since the trigger is "before delete" and operates as it should other than giving me that null DeletedBy, and I can't find them anywhere in the original table, I have to think they were deleted. If there was an issue with indexes or a database problem itself, I would think it would show up on an Autochk. This database has never had a bad Autochk. Karen -Original Message- From: Adrian Huessy To: rba...@googlegroups.com Sent: Sat, Mar 12, 2022 11:14 am Subject: RE: [RBASE-L] - Delete Trigger mystery? Karen,Quick question: do you feel that records are/were effectively deleted or do you have NULL entries even though nothing was deleted?BR, Adrian Von: 'Karen Tellef' via RBASE-L [mailto:rba...@googlegroups.com] Gesendet: Samstag, 12. März 2022 01:02 An: rba...@googlegroups.com Betreff: [RBASE-L] - Delete Trigger mystery? Why I needed the before-delete trigger: no one should ever be deleting data from this table. And although they have the full version of RBase, no one knows how to "get to the R> prompt". There is a monthend routine that the senior user runs that will delete a batch of data, but that's all (we remove the trigger before this monthend routine, then put it back on) Yet every now and then we find
Re: [RBASE-L] - Delete Trigger mystery?
Flag (hangover
from the old DBase days, using an asterisk (0x2A) as the marker or something
else as your choosing). Having done that, you would have to change your code
to exclude those marked as deleted.
To the above, you might also add another table with just a datetime column that
is added by a trigger from the main table that is updated ANY TIME the table is
accessed (this will give you a timeframe to point to user activity involvement
at the time of ANY access or deletions)
Add a second table, as you have already done to contain just the records marked
as deleted. This would be to determine if there are any actual deletions
occurring in either table and if there are any deletions, is there any
commonality to the deletions.
It seems as the detective work is pointing to user access being the culprit,
but maybe by taking extraordinary steps, it can be conclusive one way or
another.
On Saturday, March 12, 2022 at 2:45:33 PM UTC-5 Karen Tellef wrote:
Adrian: I am assuming they were actually deleted. Since the trigger is
"before delete" and operates as it should other than giving me that null
DeletedBy, and I can't find them anywhere in the original table, I have to
think they were deleted. If there was an issue with indexes or a database
problem itself, I would think it would show up on an Autochk. This database
has never had a bad Autochk.
Karen
-Original Message-
From: Adrian Huessy
To: rba...@googlegroups.com
Sent: Sat, Mar 12, 2022 11:14 am
Subject: RE: [RBASE-L] - Delete Trigger mystery?
Karen,Quick question: do you feel that records are/were effectively deleted or
do you have NULL entries even though nothing was deleted?BR, Adrian Von:
'Karen Tellef' via RBASE-L [mailto:rba...@googlegroups.com]
Gesendet: Samstag, 12. März 2022 01:02
An: rba...@googlegroups.com
Betreff: [RBASE-L] - Delete Trigger mystery? Why I needed the before-delete
trigger: no one should ever be deleting data from this table. And although
they have the full version of RBase, no one knows how to "get to the R>
prompt". There is a monthend routine that the senior user runs that will
delete a batch of data, but that's all (we remove the trigger before this
monthend routine, then put it back on) Yet every now and then we find data
mysteriously disappeared. So I created a before-delete trigger. It takes the
record to be deleted and appends it to an archive table. 3 columns in the
archive table will hold the deleted date / time and the user who deleted it.
Works perfectly at my development environment and when I test it at the place
where the database is installed. Records the date, time and the user.
However, twice now we have found records in that archive table that had been
deleted (hundreds at a time). The records had the deleted date/time but had NO
user name. Here's the code I use in my stored procedure. The DeletedDate
and DeletedTime works fine, it gets updated every time. There is no login to
this app, so I grab the NetUser (used many times in the application for other
things, successfully). The first time that the archive had no user name, I
modified the stored procedure to grab the ComputerName. But still,
nothing. SET VAR vText TEXT = NULL
SET VAR vText = (CVAL("NetUser"))
IF vText IS NULL THEN
SET VAR vText = (CVAL("ComputerName"))
ENDIF
UPDATE ClaimsDeleted SET DeletedDate = .#DATE, DeletedTime = .#TIME, +
DeletedBy = .vText WHERE claim = .spClaim Can anyone think of
anything else I can trap that would help me figure out how/when the records got
deleted? Or does anyone know how records could get deleted when there
actually is no NetUser or ComputerName? Karen --
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+u...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/1654695576.980450.1647043308102%40mail.yahoo.com.--
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+u...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/dbba74c3572c4f6aa054b424fd42d70b%40huessy.com.
--
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+u...@googlegroups.com.
To view
Re: [RBASE-L] - Delete Trigger mystery?
d show up on an Autochk. This database
has never had a bad Autochk.
Karen
-Original Message-
From: Adrian Huessy
To: rba...@googlegroups.com
Sent: Sat, Mar 12, 2022 11:14 am
Subject: RE: [RBASE-L] - Delete Trigger mystery?
Karen,Quick question: do you feel that records are/were effectively deleted or
do you have NULL entries even though nothing was deleted?BR, Adrian Von:
'Karen Tellef' via RBASE-L [mailto:rba...@googlegroups.com]
Gesendet: Samstag, 12. März 2022 01:02
An: rba...@googlegroups.com
Betreff: [RBASE-L] - Delete Trigger mystery? Why I needed the before-delete
trigger: no one should ever be deleting data from this table. And although
they have the full version of RBase, no one knows how to "get to the R>
prompt". There is a monthend routine that the senior user runs that will
delete a batch of data, but that's all (we remove the trigger before this
monthend routine, then put it back on) Yet every now and then we find data
mysteriously disappeared. So I created a before-delete trigger. It takes the
record to be deleted and appends it to an archive table. 3 columns in the
archive table will hold the deleted date / time and the user who deleted it.
Works perfectly at my development environment and when I test it at the place
where the database is installed. Records the date, time and the user.
However, twice now we have found records in that archive table that had been
deleted (hundreds at a time). The records had the deleted date/time but had NO
user name. Here's the code I use in my stored procedure. The DeletedDate
and DeletedTime works fine, it gets updated every time. There is no login to
this app, so I grab the NetUser (used many times in the application for other
things, successfully). The first time that the archive had no user name, I
modified the stored procedure to grab the ComputerName. But still,
nothing. SET VAR vText TEXT = NULL
SET VAR vText = (CVAL("NetUser"))
IF vText IS NULL THEN
SET VAR vText = (CVAL("ComputerName"))
ENDIF
UPDATE ClaimsDeleted SET DeletedDate = .#DATE, DeletedTime = .#TIME, +
DeletedBy = .vText WHERE claim = .spClaim Can anyone think of
anything else I can trap that would help me figure out how/when the records got
deleted? Or does anyone know how records could get deleted when there
actually is no NetUser or ComputerName? Karen --
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+u...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/1654695576.980450.1647043308102%40mail.yahoo.com.--
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+u...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/dbba74c3572c4f6aa054b424fd42d70b%40huessy.com.
--
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+u...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/ff8ce79d-ce09-43b8-a3fc-48a36de02ca2n%40googlegroups.com.
--
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+u...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/bc0980d9-c3a2-47ee-8d40-b1364fb952c7n%40googlegroups.com.
--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/f7c59574-ff16-48d1-86d0-43df117ecbf5n%40googlegroups.com.
--
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 r
Re: [RBASE-L] - Delete Trigger mystery?
But we have NO CLUE where/when these deletions are happening. There is nowhere in code that I can add the insertion of a delete flag, because there honestly should be nowhere that a user (nor a program) is deleting these rows. This data has to do with lawsuits, and the data has to stay there until the lawsuit is settled and then the record is archived at monthend. We know someone isn't running this monthend routine when they shouldn't, because a bunch of other stuff would also happen at the same time, and none of that is happening Karen -Original Message- From: baue...@gmail.com To: RBASE-L Sent: Mon, Mar 14, 2022 3:23 pm Subject: Re: [RBASE-L] - Delete Trigger mystery? A "Delete Flag" is just a single character field that excludes the record from any results. It is in lieu of "Actual" deletion. Internally, I believe R:Base does the same thing with deleted records and they stay "so marked" until PACK or RELOAD occurs. By doing this, you can then restrict to a single event that would occur ONLY when one person, so authorized, has access to do so. The requirement for a password in advance of any deletions is a good stopgap too, so long as the password is not widely known, but you know a secret is only a secret when kept among 3 people and two of them are dead. On Monday, March 14, 2022 at 2:34:53 PM UTC-4 Karen Tellef wrote: Do you mean using GRANT to restrict deletion? You know, I have never once used GRANT in all the decades I've used RBase!!! I'd have to read up on how to use it. Do you assign permission to delete to only specific users? And what "name" is it using to assign permissions? Stuff like that that I don't have the answers to, would have to read up on. Also, I have nowhere in my code where the user is allowed to delete a record, so there wouldn't be anywhere to set some kind of "delete flag". No program deletes a batch of records other than the one monthend program which works fine to archive/delete records, we know that one works on the last day of the month as intended. Only one user has the password to run that routine and the monthend date is never the one that is erroneously deleting records. Karen -Original Message- From: baue...@gmail.com To: RBASE-L Sent: Sun, Mar 13, 2022 9:04 am Subject: Re: [RBASE-L] - Delete Trigger mystery? Well it might take a little work, but this is what I would do. #1 - I would lock the table down with access control as tight as practically possible. Add a single character field to the table to use as a Delete Flag (hangover from the old DBase days, using an asterisk (0x2A) as the marker or something else as your choosing). Having done that, you would have to change your code to exclude those marked as deleted. To the above, you might also add another table with just a datetime column that is added by a trigger from the main table that is updated ANY TIME the table is accessed (this will give you a timeframe to point to user activity involvement at the time of ANY access or deletions) Add a second table, as you have already done to contain just the records marked as deleted. This would be to determine if there are any actual deletions occurring in either table and if there are any deletions, is there any commonality to the deletions. It seems as the detective work is pointing to user access being the culprit, but maybe by taking extraordinary steps, it can be conclusive one way or another. On Saturday, March 12, 2022 at 2:45:33 PM UTC-5 Karen Tellef wrote: Adrian: I am assuming they were actually deleted. Since the trigger is "before delete" and operates as it should other than giving me that null DeletedBy, and I can't find them anywhere in the original table, I have to think they were deleted. If there was an issue with indexes or a database problem itself, I would think it would show up on an Autochk. This database has never had a bad Autochk. Karen -Original Message- From: Adrian Huessy To: rba...@googlegroups.com Sent: Sat, Mar 12, 2022 11:14 am Subject: RE: [RBASE-L] - Delete Trigger mystery? Karen,Quick question: do you feel that records are/were effectively deleted or do you have NULL entries even though nothing was deleted?BR, Adrian Von: 'Karen Tellef' via RBASE-L [mailto:rba...@googlegroups.com] Gesendet: Samstag, 12. März 2022 01:02 An: rba...@googlegroups.com Betreff: [RBASE-L] - Delete Trigger mystery? Why I needed the before-delete trigger: no one should ever be deleting data from this table. And although they have the full version of RBase, no one knows how to "get to the R> prompt". There is a monthend routine that the senior user runs that will delete a batch of data, but that's all (we remove the trigger before this monthend routine, then put it back on) Yet every now and then we find data mysteriously disappeared. So I created
Re: [RBASE-L] - Delete Trigger mystery?
Do you mean using GRANT to restrict deletion? You know, I have never once used
GRANT in all the decades I've used RBase!!! I'd have to read up on how to use
it. Do you assign permission to delete to only specific users? And what
"name" is it using to assign permissions? Stuff like that that I don't have
the answers to, would have to read up on.
Also, I have nowhere in my code where the user is allowed to delete a record,
so there wouldn't be anywhere to set some kind of "delete flag". No program
deletes a batch of records other than the one monthend program which works fine
to archive/delete records, we know that one works on the last day of the month
as intended. Only one user has the password to run that routine and the
monthend date is never the one that is erroneously deleting records.
Karen
-Original Message-
From: baue...@gmail.com
To: RBASE-L
Sent: Sun, Mar 13, 2022 9:04 am
Subject: Re: [RBASE-L] - Delete Trigger mystery?
Well it might take a little work, but this is what I would do. #1 - I would
lock the table down with access control as tight as practically possible.
Add a single character field to the table to use as a Delete Flag (hangover
from the old DBase days, using an asterisk (0x2A) as the marker or something
else as your choosing). Having done that, you would have to change your code
to exclude those marked as deleted.
To the above, you might also add another table with just a datetime column that
is added by a trigger from the main table that is updated ANY TIME the table is
accessed (this will give you a timeframe to point to user activity involvement
at the time of ANY access or deletions)
Add a second table, as you have already done to contain just the records marked
as deleted. This would be to determine if there are any actual deletions
occurring in either table and if there are any deletions, is there any
commonality to the deletions.
It seems as the detective work is pointing to user access being the culprit,
but maybe by taking extraordinary steps, it can be conclusive one way or
another.
On Saturday, March 12, 2022 at 2:45:33 PM UTC-5 Karen Tellef wrote:
Adrian: I am assuming they were actually deleted. Since the trigger is
"before delete" and operates as it should other than giving me that null
DeletedBy, and I can't find them anywhere in the original table, I have to
think they were deleted. If there was an issue with indexes or a database
problem itself, I would think it would show up on an Autochk. This database
has never had a bad Autochk.
Karen
-Original Message-
From: Adrian Huessy
To: rba...@googlegroups.com
Sent: Sat, Mar 12, 2022 11:14 am
Subject: RE: [RBASE-L] - Delete Trigger mystery?
Karen,Quick question: do you feel that records are/were effectively deleted or
do you have NULL entries even though nothing was deleted?BR, Adrian Von:
'Karen Tellef' via RBASE-L [mailto:rba...@googlegroups.com]
Gesendet: Samstag, 12. März 2022 01:02
An: rba...@googlegroups.com
Betreff: [RBASE-L] - Delete Trigger mystery? Why I needed the before-delete
trigger: no one should ever be deleting data from this table. And although
they have the full version of RBase, no one knows how to "get to the R>
prompt". There is a monthend routine that the senior user runs that will
delete a batch of data, but that's all (we remove the trigger before this
monthend routine, then put it back on) Yet every now and then we find data
mysteriously disappeared. So I created a before-delete trigger. It takes the
record to be deleted and appends it to an archive table. 3 columns in the
archive table will hold the deleted date / time and the user who deleted it.
Works perfectly at my development environment and when I test it at the place
where the database is installed. Records the date, time and the user.
However, twice now we have found records in that archive table that had been
deleted (hundreds at a time). The records had the deleted date/time but had NO
user name. Here's the code I use in my stored procedure. The DeletedDate
and DeletedTime works fine, it gets updated every time. There is no login to
this app, so I grab the NetUser (used many times in the application for other
things, successfully). The first time that the archive had no user name, I
modified the stored procedure to grab the ComputerName. But still,
nothing. SET VAR vText TEXT = NULL
SET VAR vText = (CVAL("NetUser"))
IF vText IS NULL THEN
SET VAR vText = (CVAL("ComputerName"))
ENDIF
UPDATE ClaimsDeleted SET DeletedDate = .#DATE, DeletedTime = .#TIME, +
DeletedBy = .vText WHERE claim = .spClaim Can anyone think of
anything else I can trap that would help me figure out how/when the records got
deleted? Or does anyone know how records could get deleted when there
actually is no NetUser or ComputerName?
Re: [RBASE-L] - Delete Trigger mystery?
Bob:
Well that's something I've never used before! YES, it turns out you can "abort
trigger" if you're using a before update / insert / delete!
A very quick piece of code here, and I can stop a delete from happening unless
they type in a password. Of course, this wouldn't work well if you're running
a program that you know will be deleting batches of rows at once, someone would
have to type a password for every row that the program is deleting. So I was
thinking that for those types of programs that have "permission" to delete
records, you could pass in a variable like vOkayToDelete = "yes" and the
stored procedure would skip the password
SET VAR vText TEXT = NULL
DIALOG "password to delete" vText vendkey 1
IF vText IS NULL OR vText <> "test" THEN
ABORT TRIGGER
RETURN
ENDIF
PAUSE 2 USING "OKAY TO DELETE"
RETURN
I'm going to ask them if they want to try this, thanks!
Karen
-----Original Message-
From: Robert Thompson
To: 'Karen Tellef' via RBASE-L
Sent: Sun, Mar 13, 2022 12:21 pm
Subject: Re: [RBASE-L] - Delete Trigger mystery?
Karen, I have never done this (I think) and am not sure if it is possible,
however can a person abort the delete function from within a before delete
trigger? If you can, you could ask for a password and continue the delete. If
the password is not given or is incorrect, abort the delete procedure.
(I am not where I can test this idea at present), but perhaps upon not
getting a correct password, then you could either clear your Where variable
"spClaim" ?
Or perhaps a break, etc. Again, I have not tested this, but if possible, I
see it being a handy option! This would also remove the need to remove the
trigger every month.
-Bob
On 3/13/2022 12:12 PM, 'Karen Tellef' via RBASE-L wrote:
Doug: That's how I started out. Altho I never abbreviate and always use
"DELETE ROWS" I figured I couldn't use that for a search in case I for some
reason abbreviated or did "DELETE FROM".
So I searched for "FROM claim" because I would never split that into separate
lines of code (darn those line continuations, right?). Of course that turned
up a whole bunch of other syntax (select, correlated updates, insert) but not a
single "delete" other than that one monthend routine, where she deletes the
trigger first and then puts it back on.
I didn't think of searching reports, so I just did that and nothing came up.
I have no external programs other than the one startup routine. I had one
table holding "common code", and I had searched that for "FROM claim" also.
This weekend I had an AH HA moment, but just for a second... Years ago this
was a 6.5 DOS app that I converted. I wondered if there was any chance that
someone still has the DOS icon on their desktop (I thought I had removed them
all, but maybe not). All the DOS programs are moved to a different directory,
and the startup APX file has a "connect XXX" in there without pointing to a
directory so there's no way that would work as there is no database in the DOS
program directory. But for the heck of it, I told my contact there to check
everyone's computer on Monday to see if the icon is still there and to ask each
person if they've ever run DOS. These people rate a 0.01 on technical skills,
so they couldn't figure out a way around it. But I want her to check anyway.
Karen
-Original Message-
From: Doug Hamilton
To: rbase-l@googlegroups.com
Sent: Sun, Mar 13, 2022 10:51 am
Subject: Re: [RBASE-L] - Delete Trigger mystery?
What about using FIND in Custom EEPS, Expressions and Control Properties in
all forms for:
DEL ROWS FROM [tablename]
DELETE ROWS FROM [tablename]
DEL FROM [tablename]
DELETE FROM [tablename]
If you R:Style or use consistent coding you might skip some of the above
commands.
And possibly RMD files, maybe even reports?
Doug
On 3/13/2022 9:03 AM, 'Karen Tellef' via RBASE-L wrote:
Adrian: That's what I'm thinking some kind of "system" user without a
name. Nope, database is not accessed by any other program (client is very
small, simple, very non-tech). This is the only trigger in the database.
Deletions are contiguous. Looking at the time of deletion, they all follow
each other a second apart, every single one. So a batch is being deleted at
once. Then we won't see anything for months. This has happened 3 times that
we know of during the past year
Karen
-Original Message-
From: Adrian Huessy
To: rbase-l@googlegroups.com
Sent: Sat, Mar 12, 2022 2:52 pm
Subject: RE: [RBASE-L] - Delete Trigger mystery?
#yiv5258828797 filtered {}#yiv5258828797 filtered {}#yiv5258828797 filtered
{}#yiv5258828797 p.yiv5258828797MsoNormal, #yiv5258828797
li.yiv5258828797MsoNormal,
Re: [RBASE-L] - Delete Trigger mystery?
Doug: That's how I started out. Altho I never abbreviate and always use
"DELETE ROWS" I figured I couldn't use that for a search in case I for some
reason abbreviated or did "DELETE FROM".
So I searched for "FROM claim" because I would never split that into separate
lines of code (darn those line continuations, right?). Of course that turned
up a whole bunch of other syntax (select, correlated updates, insert) but not a
single "delete" other than that one monthend routine, where she deletes the
trigger first and then puts it back on.
I didn't think of searching reports, so I just did that and nothing came up.
I have no external programs other than the one startup routine. I had one
table holding "common code", and I had searched that for "FROM claim" also.
This weekend I had an AH HA moment, but just for a second... Years ago this
was a 6.5 DOS app that I converted. I wondered if there was any chance that
someone still has the DOS icon on their desktop (I thought I had removed them
all, but maybe not). All the DOS programs are moved to a different directory,
and the startup APX file has a "connect XXX" in there without pointing to a
directory so there's no way that would work as there is no database in the DOS
program directory. But for the heck of it, I told my contact there to check
everyone's computer on Monday to see if the icon is still there and to ask each
person if they've ever run DOS. These people rate a 0.01 on technical skills,
so they couldn't figure out a way around it. But I want her to check anyway.
Karen
-Original Message-
From: Doug Hamilton
To: rbase-l@googlegroups.com
Sent: Sun, Mar 13, 2022 10:51 am
Subject: Re: [RBASE-L] - Delete Trigger mystery?
What about using FIND in Custom EEPS, Expressions and Control Properties in
all forms for:
DEL ROWS FROM [tablename]
DELETE ROWS FROM [tablename]
DEL FROM [tablename]
DELETE FROM [tablename]
If you R:Style or use consistent coding you might skip some of the above
commands.
And possibly RMD files, maybe even reports?
Doug
On 3/13/2022 9:03 AM, 'Karen Tellef' via RBASE-L wrote:
Adrian: That's what I'm thinking some kind of "system" user without a name.
Nope, database is not accessed by any other program (client is very small,
simple, very non-tech). This is the only trigger in the database. Deletions
are contiguous. Looking at the time of deletion, they all follow each other a
second apart, every single one. So a batch is being deleted at once. Then we
won't see anything for months. This has happened 3 times that we know of
during the past year
Karen
-Original Message-
From: Adrian Huessy
To: rbase-l@googlegroups.com
Sent: Sat, Mar 12, 2022 2:52 pm
Subject: RE: [RBASE-L] - Delete Trigger mystery?
#yiv0120854750 filtered {}#yiv0120854750 filtered {}#yiv0120854750 filtered
{}#yiv0120854750 p.yiv0120854750MsoNormal, #yiv0120854750
li.yiv0120854750MsoNormal, #yiv0120854750 div.yiv0120854750MsoNormal
{margin:0cm;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New
Roman", "serif";}#yiv0120854750 a:link, #yiv0120854750
span.yiv0120854750MsoHyperlink
{color:blue;text-decoration:underline;}#yiv0120854750 a:visited, #yiv0120854750
span.yiv0120854750MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}#yiv0120854750 p
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;font-family:"Times New
Roman", "serif";}#yiv0120854750 p.yiv0120854750msonormal, #yiv0120854750
li.yiv0120854750msonormal, #yiv0120854750 div.yiv0120854750msonormal
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;font-family:"Times New
Roman", "serif";}#yiv0120854750 p.yiv0120854750msochpdefault, #yiv0120854750
li.yiv0120854750msochpdefault, #yiv0120854750 div.yiv0120854750msochpdefault
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;font-family:"Times New
Roman", "serif";}#yiv0120854750 span.yiv0120854750msohyperlink {}#yiv0120854750
span.yiv0120854750msohyperlinkfollowed {}#yiv0120854750
span.yiv0120854750e-mailformatvorlage18 {}#yiv0120854750
p.yiv0120854750msonormal1, #yiv0120854750 li.yiv0120854750msonormal1,
#yiv0120854750 div.yiv0120854750msonormal1
{margin:0cm;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New
Roman", "serif";}#yiv0120854750 span.yiv0120854750msohyperlink1
{color:blue;text-decoration:underline;}#yiv0120854750
span.yiv0120854750msohyperlinkfollowed1
{color:purple;text-decoration:underline;}#yiv0120854750
span.yiv0120854750e-mailformatvorlage181 {font-family:"Calibri",
"sans-serif";color:#1F497D;}#yiv0120854750 p.yiv0120854750msochpdefault1,
#yiv0120854750 li.yiv0120854750msochpdefault1, #yiv0120854750
div.yiv0120854750msochpdefault1
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;fo
Re: [RBASE-L] - Delete Trigger mystery?
Adrian: That's what I'm thinking some kind of "system" user without a name.
Nope, database is not accessed by any other program (client is very small,
simple, very non-tech). This is the only trigger in the database. Deletions
are contiguous. Looking at the time of deletion, they all follow each other a
second apart, every single one. So a batch is being deleted at once. Then we
won't see anything for months. This has happened 3 times that we know of
during the past year
Karen
-Original Message-
From: Adrian Huessy
To: rbase-l@googlegroups.com
Sent: Sat, Mar 12, 2022 2:52 pm
Subject: RE: [RBASE-L] - Delete Trigger mystery?
Karen,Brainstorming without
knowing your application and database: Missing user and computer name could
indicate system user. Access via ODBC/Oterro, other trigger? The way of
deletion may give a hint: are the deletions contiguous or scattered during the
day?AdrianVon: 'Karen Tellef' via RBASE-L [mailto:rbase-l@googlegroups.com]
Gesendet: Samstag, 12. März 2022 20:45
An: rbase-l@googlegroups.com
Betreff: Re: [RBASE-L] - Delete Trigger mystery? Adrian: I am assuming they
were actually deleted. Since the trigger is "before delete" and operates as it
should other than giving me that null DeletedBy, and I can't find them anywhere
in the original table, I have to think they were deleted. If there was an
issue with indexes or a database problem itself, I would think it would show up
on an Autochk. This database has never had a bad Autochk. Karen
-Original Message-
From: Adrian Huessy
To: rbase-l@googlegroups.com
Sent: Sat, Mar 12, 2022 11:14 am
Subject: RE: [RBASE-L] - Delete Trigger mystery?Karen,Quick question: do you
feel that records are/were effectively deleted or do you have NULL entries even
though nothing was deleted?BR, Adrian Von: 'Karen Tellef' via RBASE-L
[mailto:rbase-l@googlegroups.com]
Gesendet: Samstag, 12. März 2022 01:02
An: rbase-l@googlegroups.com
Betreff: [RBASE-L] - Delete Trigger mystery? Why I needed the before-delete
trigger: no one should ever be deleting data from this table. And although
they have the full version of RBase, no one knows how to "get to the R>
prompt". There is a monthend routine that the senior user runs that will
delete a batch of data, but that's all (we remove the trigger before this
monthend routine, then put it back on) Yet every now and then we find data
mysteriously disappeared. So I created a before-delete trigger. It takes the
record to be deleted and appends it to an archive table. 3 columns in the
archive table will hold the deleted date / time and the user who deleted it.
Works perfectly at my development environment and when I test it at the place
where the database is installed. Records the date, time and the user. However,
twice now we have found records in that archive table that had been deleted
(hundreds at a time). The records had the deleted date/time but had NO user
name. Here's the code I use in my stored procedure. The DeletedDate and
DeletedTime works fine, it gets updated every time. There is no login to this
app, so I grab the NetUser (used many times in the application for other
things, successfully). The first time that the archive had no user name, I
modified the stored procedure to grab the ComputerName. But still,
nothing. SET VAR vText TEXT = NULL
SET VAR vText = (CVAL("NetUser"))
IF vText IS NULL THEN
SET VAR vText = (CVAL("ComputerName"))
ENDIF
UPDATE ClaimsDeleted SET DeletedDate = .#DATE, DeletedTime = .#TIME, +
DeletedBy = .vText WHERE claim = .spClaim Can anyone think of anything
else I can trap that would help me figure out how/when the records got deleted?
Or does anyone know how records could get deleted when there actually is no
NetUser or ComputerName? Karen --
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/1654695576.980450.1647043308102%40mail.yahoo.com.--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/dbba74c3572c4f6aa054b424fd42d70b%40huessy.com.--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"
Re: [RBASE-L] - Delete Trigger mystery?
Adrian: I am assuming they were actually deleted. Since the trigger is
"before delete" and operates as it should other than giving me that null
DeletedBy, and I can't find them anywhere in the original table, I have to
think they were deleted. If there was an issue with indexes or a database
problem itself, I would think it would show up on an Autochk. This database
has never had a bad Autochk.
Karen
-Original Message-
From: Adrian Huessy
To: rbase-l@googlegroups.com
Sent: Sat, Mar 12, 2022 11:14 am
Subject: RE: [RBASE-L] - Delete Trigger mystery?
Karen,Quick question: do
you feel that records are/were effectively deleted or do you have NULL entries
even though nothing was deleted?BR, Adrian Von: 'Karen Tellef' via RBASE-L
[mailto:rbase-l@googlegroups.com]
Gesendet: Samstag, 12. März 2022 01:02
An: rbase-l@googlegroups.com
Betreff: [RBASE-L] - Delete Trigger mystery? Why I needed the before-delete
trigger: no one should ever be deleting data from this table. And although
they have the full version of RBase, no one knows how to "get to the R>
prompt". There is a monthend routine that the senior user runs that will
delete a batch of data, but that's all (we remove the trigger before this
monthend routine, then put it back on) Yet every now and then we find data
mysteriously disappeared. So I created a before-delete trigger. It takes the
record to be deleted and appends it to an archive table. 3 columns in the
archive table will hold the deleted date / time and the user who deleted it.
Works perfectly at my development environment and when I test it at the place
where the database is installed. Records the date, time and the user.
However, twice now we have found records in that archive table that had been
deleted (hundreds at a time). The records had the deleted date/time but had NO
user name. Here's the code I use in my stored procedure. The DeletedDate
and DeletedTime works fine, it gets updated every time. There is no login to
this app, so I grab the NetUser (used many times in the application for other
things, successfully). The first time that the archive had no user name, I
modified the stored procedure to grab the ComputerName. But still,
nothing. SET VAR vText TEXT = NULL
SET VAR vText = (CVAL("NetUser"))
IF vText IS NULL THEN
SET VAR vText = (CVAL("ComputerName"))
ENDIF
UPDATE ClaimsDeleted SET DeletedDate = .#DATE, DeletedTime = .#TIME, +
DeletedBy = .vText WHERE claim = .spClaim Can anyone think of
anything else I can trap that would help me figure out how/when the records got
deleted? Or does anyone know how records could get deleted when there
actually is no NetUser or ComputerName? Karen --
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/1654695576.980450.1647043308102%40mail.yahoo.com.--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/dbba74c3572c4f6aa054b424fd42d70b%40huessy.com.
--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/840423822.1120239.1647114324158%40mail.yahoo.com.
Re: [RBASE-L] - Delete Trigger mystery?
Bob: Here's my answers to your thoughtful questions:
Was the Deletedby value actually null or a blank? If it was blank, then the
computer name would not be captured with the "is null" parameter. Good
question. I did a "sel count(*) from tmpclaimsdeleted where deletedby is null"
and all records come up. So it is a Null
Just in case there is some odd condition with nulls, you could set the var
vtext = ( (CVAL('NetUser')) & (Cval('Computer')) ) and capture both all the
time, thus avoiding the IF nulls. I could try that, thanks for the suggestion
I see that you are using double quotes?
Yes, using double quotes
My help states the cval syntax is 'Computer' instead of 'ComputerName' ?
My test shows that cval "computer" and "computername" return the same result
Karen
-Original Message-----
From: Robert Thompson
To: 'Karen Tellef' via RBASE-L
Sent: Fri, Mar 11, 2022 7:43 pm
Subject: Re: [RBASE-L] - Delete Trigger mystery?
A couple of thoughts...(some obvious, but it never hurts to ask!)
Was the Deletedby value actually null or a blank? If it was blank, then the
computer name would not be captured with the "is null" parameter. Just in case
there is some odd condition with nulls, you could set the var vtext = (
(CVAL('NetUser')) & (Cval('Computer')) ) and capture both all the time, thus
avoiding the IF nulls. I see that you are using double quotes?
My help states the cval syntax is 'Computer' instead of 'ComputerName' ? -Bob
On 3/11/2022 6:01 PM, 'Karen Tellef' via RBASE-L wrote:
Why I needed the before-delete trigger: no one should ever be deleting data
from this table. And although they have the full version of RBase, no one
knows how to "get to the R> prompt". There is a monthend routine that the
senior user runs that will delete a batch of data, but that's all (we remove
the trigger before this monthend routine, then put it back on)
Yet every now and then we find data mysteriously disappeared.
So I created a before-delete trigger. It takes the record to be deleted and
appends it to an archive table. 3 columns in the archive table will hold the
deleted date / time and the user who deleted it. Works perfectly at my
development environment and when I test it at the place where the database is
installed. Records the date, time and the user.
However, twice now we have found records in that archive table that had been
deleted (hundreds at a time). The records had the deleted date/time but had NO
user name.
Here's the code I use in my stored procedure. The DeletedDate and
DeletedTime works fine, it gets updated every time. There is no login to this
app, so I grab the NetUser (used many times in the application for other
things, successfully). The first time that the archive had no user name, I
modified the stored procedure to grab the ComputerName. But still,
nothing.
SET VAR vText TEXT = NULL
SET VAR vText = (CVAL("NetUser"))
IF vText IS NULL THEN
SET VAR vText = (CVAL("ComputerName"))
ENDIF
UPDATE ClaimsDeleted SET DeletedDate = .#DATE, DeletedTime = .#TIME, +
DeletedBy = .vText WHERE claim = .spClaim
Can anyone think of anything else I can trap that would help me figure out
how/when the records got deleted?
Or does anyone know how records could get deleted when there actually is no
NetUser or ComputerName?
Karen
--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/1654695576.980450.1647043308102%40mail.yahoo.com.
--
Robert Thompson
TTC. Inc.
219-363-7441 --
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/c5a2daa4-0240-af9c-b33f-558ae652cee6%40comcast.net.
--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/42530637.1085053.1647101404875%40mail.yahoo.com.
Re: [RBASE-L] - Delete Trigger mystery?
Unfortunately not. There is no primary / foreign key set up on this table.
There is a primary key, but it is not referenced from any other table
Karen
-Original Message-
From: Buddy Walker
To: rbase-l@googlegroups.com
Sent: Fri, Mar 11, 2022 6:45 pm
Subject: Re: [RBASE-L] - Delete Trigger mystery?
Karen
My first thought was primary and foreign keys with cascade. So when you
delete row with primary key system deletes foreign key
Buddy
Sent from my iPhone
On Mar 11, 2022, at 7:01 PM, 'Karen Tellef' via RBASE-L
wrote:
Why I needed the before-delete trigger: no one should ever be deleting data
from this table. And although they have the full version of RBase, no one
knows how to "get to the R> prompt". There is a monthend routine that the
senior user runs that will delete a batch of data, but that's all (we remove
the trigger before this monthend routine, then put it back on)
Yet every now and then we find data mysteriously disappeared.
So I created a before-delete trigger. It takes the record to be deleted and
appends it to an archive table. 3 columns in the archive table will hold the
deleted date / time and the user who deleted it. Works perfectly at my
development environment and when I test it at the place where the database is
installed. Records the date, time and the user.
However, twice now we have found records in that archive table that had been
deleted (hundreds at a time). The records had the deleted date/time but had NO
user name.
Here's the code I use in my stored procedure. The DeletedDate and DeletedTime
works fine, it gets updated every time. There is no login to this app, so I
grab the NetUser (used many times in the application for other things,
successfully). The first time that the archive had no user name, I modified
the stored procedure to grab the ComputerName. But still, nothing.
SET VAR vText TEXT = NULL
SET VAR vText = (CVAL("NetUser"))
IF vText IS NULL THEN
SET VAR vText = (CVAL("ComputerName"))
ENDIF
UPDATE ClaimsDeleted SET DeletedDate = .#DATE, DeletedTime = .#TIME, +
DeletedBy = .vText WHERE claim = .spClaim
Can anyone think of anything else I can trap that would help me figure out
how/when the records got deleted?
Or does anyone know how records could get deleted when there actually is no
NetUser or ComputerName?
Karen
--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/1654695576.980450.1647043308102%40mail.yahoo.com.
--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/C98666B1-D52E-444A-A976-2230F7941E53%40comcast.net.
--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/950228522.1048878.1647091901892%40mail.yahoo.com.
[RBASE-L] - Delete Trigger mystery?
Why I needed the before-delete trigger: no one should ever be deleting data
from this table. And although they have the full version of RBase, no one
knows how to "get to the R> prompt". There is a monthend routine that the
senior user runs that will delete a batch of data, but that's all (we remove
the trigger before this monthend routine, then put it back on)
Yet every now and then we find data mysteriously disappeared.
So I created a before-delete trigger. It takes the record to be deleted and
appends it to an archive table. 3 columns in the archive table will hold the
deleted date / time and the user who deleted it. Works perfectly at my
development environment and when I test it at the place where the database is
installed. Records the date, time and the user.
However, twice now we have found records in that archive table that had been
deleted (hundreds at a time). The records had the deleted date/time but had NO
user name.
Here's the code I use in my stored procedure. The DeletedDate and DeletedTime
works fine, it gets updated every time. There is no login to this app, so I
grab the NetUser (used many times in the application for other things,
successfully). The first time that the archive had no user name, I modified
the stored procedure to grab the ComputerName. But still, nothing.
SET VAR vText TEXT = NULL
SET VAR vText = (CVAL("NetUser"))
IF vText IS NULL THEN
SET VAR vText = (CVAL("ComputerName"))
ENDIF
UPDATE ClaimsDeleted SET DeletedDate = .#DATE, DeletedTime = .#TIME, +
DeletedBy = .vText WHERE claim = .spClaim
Can anyone think of anything else I can trap that would help me figure out
how/when the records got deleted?
Or does anyone know how records could get deleted when there actually is no
NetUser or ComputerName?
Karen
--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/1654695576.980450.1647043308102%40mail.yahoo.com.
Re: [RBASE-L] - add week
When I have to "add weeks", I just add the number of days, so 56 days for 8 weeks Karen -Original Message- From: Dan Goldberg To: rbase-l@googlegroups.com Sent: Thu, Mar 10, 2022 9:19 am Subject: [RBASE-L] - add week I have a need to add 8 weeks to a date variable. I looked and noticed there is not an addwk function like addday and addmon Has anyone added a number of weeks to a date variable? TIA Dan Goldberg -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0014EF8EF9B%40EXCHANGE10. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/1043403734.543860.1646926874151%40mail.yahoo.com.
Re: [RBASE-L] - Refresh an External Form
Was wondering if it was only me. I got it once a day for 4 days straight so
far, as if it's on some kind of automatic repeat once a day at the same time
maybe?
Karen
-Original Message-
From: Bruce Chitiea
To: rbase-l@googlegroups.com
Sent: Wed, Feb 9, 2022 6:09 pm
Subject: Re: [RBASE-L] - Refresh an External Form
#yiv0155336424 #yiv0155336424x91f9021e29954a2
#yiv0155336424x86b4dd35dfc94ef5a5432fdb70f5f643{font-size:12pt;}#yiv0155336424
#yiv0155336424 #yiv0155336424 #yiv0155336424 --#yiv0155336424x2b73fbbb16fb473
p.yiv0155336424MsoNormal{margin:0in;font-size:11pt;font-family:Calibri,
sans-serif;}#yiv0155336424 #yiv0155336424x2b73fbbb16fb473
a:link{color:blue;text-decoration:underline;}#yiv0155336424
#yiv0155336424x2b73fbbb16fb473 div.yiv0155336424WordSection1{}#yiv0155336424
#yiv0155336424 #yiv0155336424 --blockquote.yiv0155336424cite
{margin-left:5px;margin-right:0px;padding-left:10px;padding-right:0px;border-left:1px
solid #cc;}#yiv0155336424 blockquote.yiv0155336424cite2
{margin-left:5px;margin-right:0px;padding-left:10px;padding-right:0px;border-left:1px
solid #cc;margin-top:3px;padding-top:0px;}#yiv0155336424 a img
{border:0px;}#yiv0155336424 #yiv0155336424 #yiv0155336424 #yiv0155336424 ,
#yiv0155336424 #yiv0155336424 #yiv0155336424 #yiv0155336424 , #yiv0155336424
#yiv0155336424 #yiv0155336424 #yiv0155336424 , #yiv0155336424 #yiv0155336424
#yiv0155336424 #yiv0155336424 {list-style-position:inside;}#yiv0155336424 body
{font-family:Segoe UI;font-size:12pt;}#yiv0155336424 .yiv0155336424quote
{margin-left:1em;margin-right:1em;border-left:5px #ebebeb
solid;padding-left:0.3em;}#yiv0155336424 For reasons obscure ... which might be
that Mr. Finegold is REALLY thankful for the assist ... this message keeps
arriving from the list.
d:) Bruce
Bruce A. Chitiea | SafeSectors, Inc.112 Harvard Ave #272 | Claremont CA
91711-4716 | usarby...@safesectors.com | +011 (909) 238-9012 c | +011 (909)
912-8678 f
-- Original Message --From: myron.finegold@gmail.comTo:
rbase-l@googlegroups.comSent: 2/9/2022 4:05:38 PMSubject: [RBASE-L] - Refresh
an External Form
To close this one out. A special thanks go to Ken Shapiro for setting me
straight.What I did not say and should have is that this external form is
driven by a temporary table. As we know, each session gets their own temporary
table. So, the update is not straight forward.Once we jumped that hurdle, Ken
put in the correct code to do the update. Thanks to all.Myron From:
myron.fineg...@gmail.com
Sent: February 4, 2022 7:08 AM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - Refresh an External Form Jan,Thank you. I’ll give it
a try. Stay tuned for the results.Myron From: rbase-l@googlegroups.com
On Behalf Of jan johansen
Sent: February 4, 2022 7:00 AM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Refresh an External Form Myron, Enable the form
timer.Set it to 3mSRefresh your form components in the eep. That's what I'm
doing in an external form. Jan
From:
To:
Date: Fri, 4 Feb 2022 06:38:08 -0700
Subject: [RBASE-L] - Refresh an External Form
R:Base Version X5 – current build.External Form – shown belowThis form is run
off of a server and is at two locations in the building.When someone comes into
or leaves the building the data is updated.However, the change does not show on
the second system without closing and reopening the form.Goal: to have the
external form refresh itself (say every 5 minutes) without closing and opening
the form.Help shows that a ‘regular’ form can use the: ‘SET REFRESH value’ to
refresh a form, no mention of an external form.I’ve tried to use the ‘SET
REFRESH’ in the external form and could not get it to work. Any suggestions are
welcome. As always – thanks in advance. Myron FinegoldSun City West Posse --
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/016d01d819cc%24726a46e0%24573ed4a0%24%40gmail.com.
--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/WC20220204135942.500019%40jjcalibrations.com.
--
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
Re: [RBASE-L] - WHERE
Can't you use a good old-fashioned form variable? Just define a form variableequal to the PK or some other identifier of the row the user has just clicked on?You can use a "getproperty" in the grid eep, but form variables are very easy Karen -Original Message- From: Dick Fey To: RBase Maillist Sent: Thu, Feb 3, 2022 12:26 pm Subject: [RBASE-L] - WHERE Somewhere in my foggy mind, I remember a way to click on a line in a dbgrid and have it update that line with a variable using WHERE current of cursor. What I want to do is populate a field on one line with a variable for another table. IE: Top table is a vendor invoice. Clicking a line there populates order lines for that order into a second DBGrid Need to update specific lines in the second table with a number from the first table by clicking the appropriate line. I think the Covid has fogged by brain. 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 --- You received this message because 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/57e0e065-7f9a-2708-0020-8a3783f7c7c4%40carpetbroker.com. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/1035445468.4468992.1643913723928%40mail.yahoo.com.
Re: [RBASE-L] - Multi-User commands Best Practices
Go ahead and flame me on this one, but I've had the same modus operandi ever since I think version 9.0 I don't use CFG files. Ever. Anywhere. I have no clue where/if they are installed, nor where they are. And to this day it has never presented a problem in any of my installations. To me it was one of the best enhancements ever, that you can basically ignore those CFG files if you want to. Need to add a user? Give them the desktop icon that points to the network RBase install and you're done. Do they have/need a CFG? I've never assigned one to a new user. I'm not sure how RBase handles it, but I don't care because it works wonderfully. 100% of my commands, like the ones you list Doug, are in the startup file. That way if you want to change anything, you change one program. You don't run around and change/copy over new CFG files for every user. I never use "name" anymore, I use NetUser. Karen -Original Message- From: Buddy Walker To: rbase-l@googlegroups.com Sent: Mon, Jan 31, 2022 6:18 am Subject: RE: [RBASE-L] - Multi-User commands Best Practices Doug I would only put those in the cfg file. I would set the NAME in RBASE.DAT like this SET VAR vUserName = (CVAL(‘NETUSER’)) SET NAME I would then make sure the RBASE.DAT AND rbase CFG file were located in same folder as the rbase EXE Make sure there aren’t any other RBASE.DAT and rbase CFG file located anywhere. Buddy From: rbase-l@googlegroups.com On Behalf Of Doug Hamilton Sent: Sunday, January 30, 2022 10:32 PM To: R:Base List Subject: [RBASE-L] - Multi-User commands Best Practices In the recent R:Base Multi-User Guide, the recommended sequence for Multi-User Concurrency Settings in a startup file, e.g. RBASE.DAT, is: DISCONNECT SET MULTI ON SET STATICDB ON SET FASTLOCK ON SET PAGELOCK OFF SET ROWLOCKS ON SET VERIFY COLUMN SET WAIT 4 SET INTERVAL 5 The same settings are found in the .CFG file, e.g. RBENGINEX5E.CFG MULTI ON STATICDB ON FASTLOCK ON PAGELOCK OFF ROWLOCKS ON VERIFY COLUMN WAIT 4 INTERVAL 5 Is it correct that: 1) the CFG file is processed before the startup DAT file? 2) The order of the commands in the CFG should be the same as in the DAT file? 3) The SET commands in the DAT file are redundant and are not really necessary in the DAT file unless settings need to be changed for special circumstances? Note that the user Guide states: "The settings may be set within the R:BASE configuration file. However, the settings are best set in a startup file before connecting to the database. For example: ..." Why are the settings best set in a startup file? Shouldn't default settings be established in the CFG file and modified only if necessary? TIA, Doug | | This email has been checked for viruses by Avast antivirus software. www.avast.com | -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/f09f7740-a3a9-aebf-5c8d-963075b275c6%40wi.rr.com.-- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/004901d8169c%24ad391c20%2407ab5460%24%40comcast.net. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/480366446.3189550.1643637579601%40mail.yahoo.com.
Re: [RBASE-L] - Extraction de données / Data Extraction
Doug: once you know the trick of replacing spaces with commas and doing an
"item count", isn't it crazy how many uses that has? I just had to use this
technique again this week.
Karen
-Original Message-
From: Doug Hamilton
To: rbase-l@googlegroups.com
Sent: Fri, Jan 28, 2022 4:54 am
Subject: Re: [RBASE-L] - Extraction de données / Data Extraction
Bonjour Jean-Marc.
CLS
SET VAR vadrchant TEXT = +
'Mobil Home Rideau 12 Parc de la Landette 85190 VENANSAULT'
SET VAR vadrchant2 = (SRPL(.vadrchant,' ',',',0))
SET VAR vCount = (ITEMCNT(.vadrchant2))
SHOW VAR vadr%
SHOW VAR vCount
SET VAR vadrpostcode = (SSUB(.vadrchant2,(.vCount - 1)))
SET VAR vadrcity = (SSUB(.vadrchant2,.vCount))
SHOW VAR vadr%
RETURN
Doug
On 1/28/2022 2:37 AM, Jean-Marc Massé wrote:
_filtered {} _filtered {}#yiv9426004986 p.yiv9426004986MsoNormal,
#yiv9426004986 li.yiv9426004986MsoNormal, #yiv9426004986
div.yiv9426004986MsoNormal
{margin:0cm;font-size:11.0pt;font-family:sans-serif;}#yiv9426004986
span.yiv9426004986EmailStyle20
{font-family:sans-serif;color:windowtext;}#yiv9426004986
.yiv9426004986MsoChpDefault {font-family:sans-serif;}#yiv9426004986
div.yiv9426004986WordSection1 {} Bonjour à tous, Dans une table de
coordonnées de clients j’ai un champ NOTE « ADRCHANT » dans lequel figure
l’adresse complète du client comme la variable jointe SET VAR VADRCHANT
TEXT = "Mobil Home Rideau 12 Parc de la Landette 85190 VENANSAULT" Pourriez
vous me dire comment on peut extraire d’un coté le code postal « 85190 » dans
une variable distincte Et d’autre part la ville « VENANSAULT » dans une autre
variable ? Merci d’avance pour votre aide ! Traduction Google : Hello
everyone, In a table of customer details I have a field NOTE "ADRCHANT" in
which appears the complete address of the customer as the attached variable
SET VAR VADRCHANT TEXT = "Mobile Home Rideau 12 Parc de la Landette 85190
VENANSAULT" Could you tell me how we can extract on one side the postal code
"85190" in a separate variable And on the other hand the city "VENANSAULT" in
another variable? Thank you in advance for your help ! Best regards,
Jean-Marc Massé (mobile : 06.08.82.80.86) Sté MCS 85510 ROCHETREJOUX (France)
--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/3549e19b3ab14f7dbcc5500f9aa9ca67%40masse-charpente.fr.
| | This email has been checked for viruses by Avast antivirus software.
www.avast.com |
--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/00a0f327-b8bb-e76d-7a4f-bc96a548c235%40wi.rr.com.
--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/682475445.2590698.1643395651814%40mail.yahoo.com.
Re: [RBASE-L] - How to navigate to a specific table row and display it on a form
I've only been able to do this one way. I don't have the app in front of me, so just going by memory. Create a single-table view of the table using a variable, such as: set var vID INT create view vTable as select * from Table where id = (.vID) After you select the dropdown search parameter, you do a property table vTable 'refresh' Just not sure how it works with adding a row. Haven't tried that! Karen -Original Message- From: James Burroughs To: rbase-l@googlegroups.com Sent: Wed, Jan 26, 2022 8:54 pm Subject: [RBASE-L] - How to navigate to a specific table row and display it on a form I have a form which displays columns from a single row of a table. The user is given the option either to enter a new row or to edit an existing row. If a new row, then a blank form is displayed. If an existing row, then the user selects a row from a drop down list based on a date. My question is how to get the form to display the row that was selected? I've tried the EDIT USING command with a WHERE clause from within an EEP to select the desired row and display the information on the form. This works, but opens a new instance of the form. I'm wondering if there is a better approach. Thanks, Jim Burroughs -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/28f5a21f-85d0-3267-9e30-dd91e86d77c0%40cox.net. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/1692724494.2216555.1643300550162%40mail.yahoo.com.
Re: [RBASE-L] - Export to a specific sheet in Excel
Jim: You use these 2 options in the gateway export command: SHEET_NAME Detail | SHEET_INDEX 0 The sheet index changed at some point from starting at 1 to starting at 0. I think it's 0 right now. I haven't tested it recently but at one point it saved it with the last tab being the one in focus; I wished I could've changed that behavior. And make sure you erase the file first in case there's one with the name, otherwise it will stick more tabs onto the existing one Karen -Original Message- From: 'Jim Belisle' via RBASE-L To: rbase-l@googlegroups.com Sent: Wed, Dec 22, 2021 1:19 pm Subject: [RBASE-L] - Export to a specific sheet in Excel Is there a way to export RBASE info into a specific sheet within an Excel file? James Belisle Making Information Systems People Friendly Since 1990 -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/SA0PR02MB743497479B13C1C3A65C1572A07D9%40SA0PR02MB7434.namprd02.prod.outlook.com. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/139646580.551150.1640201900840%40mail.yahoo.com.
Re: [RBASE-L] - Resettable Cursor
Hi Bruce! I'm unclear what you mean by "resettable cursor". Do you mean using
the OPEN c1 RESET command within a DECLARE CURSOR loop?
If so, quickly I'll mention that I use the RESET all the time if I am embedding
a second cursor within the first cursor, but that's the only time I use it.
And if you want to see my syntax for doing that, let me know
Karen
-Original Message-
From: Bruce Chitiea
To: rbase-l@googlegroups.com
Sent: Fri, Dec 17, 2021 9:32 pm
Subject: [RBASE-L] - Resettable Cursor
#yiv7613448107 #yiv7613448107x707264cbb7454dd
#yiv7613448107x86b4dd35dfc94ef5a5432fdb70f5f643{font-family:'Segoe
UI';font-size:12pt;}#yiv7613448107 blockquote.yiv7613448107cite
{margin-left:5px;margin-right:0px;padding-left:10px;padding-right:0px;border-left:1px
solid #cc;}#yiv7613448107 blockquote.yiv7613448107cite2
{margin-left:5px;margin-right:0px;padding-left:10px;padding-right:0px;border-left:1px
solid #cc;margin-top:3px;padding-top:0px;}#yiv7613448107 a img
{border:0px;}#yiv7613448107 Peace to all:
Can someone please send an example of a 'Resettable Cursor' [1] in use? I
understand the use of scrolling, but ...
Wondering if the contents of a scrolling cursor can be modified during
processing between the WHILE sqlcode <> 100 THEN and ENDWHILE statements.
I'm building time-series data for use in charting parallel data series, and
using a cursor to insert zero values for time periods with no data, so that all
the series align. When a year, say, is found to be missing, I'd like to pop
that missing year into the cursor's source table, then have the cursor
redefined "on the fly", so that the next cursor-retrieved value may be
evaluated relative to the newly inserted value. Especially handy when there's a
multi-year gap, when RELATIVE -n would now have the right value to land upon.
Seems like the cursor needs to be reset for that to happen.
On the right track?
Ever grateful, Bruce
Bruce A. Chitiea | SafeSectors, Inc.112 Harvard Ave #272 | Claremont CA
91711-4716 | usarby...@safesectors.com | +011 (909) 238-9012 c | +011 (909)
912-8678 f
[1] As noted in From the Edge: "R:BASE Cursors Explained" (01/04/2021)--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/eme9daf667-df30-4b9b-bd6c-ce382dcc669e%40pathfinder.
--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/1434955470.2527171.1639835176988%40mail.yahoo.com.
Re: Re[2]: [RBASE-L] - Windows 11?
They're getting new workstations with Win11 installed, but thanks I'll keep
that in my notes!
Karen
-Original Message-
From: Bruce Chitiea
To: rbase-l@googlegroups.com
Sent: Fri, Dec 17, 2021 9:40 am
Subject: Re[2]: [RBASE-L] - Windows 11?
#yiv3315009353 #yiv3315009353xce7558da23b94ac
#yiv3315009353x86b4dd35dfc94ef5a5432fdb70f5f643{font-family:'Segoe
UI';font-size:12pt;}You might also recommend that your client:
(1) open the Win10 Settings> Windows Update & Security page. (2) Within the
"Upgrade to Windows 11 is ready-and it's free!" blurb, click the "Check device
specifications" link
This will gets them to the Microsoft web page dealing with upgrade issues and
requirements.
Cheers, Bruce
Bruce A. Chitiea | SafeSectors, Inc.112 Harvard Ave #272 | Claremont CA
91711-4716 | usarby...@safesectors.com | +011 (909) 238-9012 c | +011 (909)
912-8678 f
-- Original Message ------From: "'Karen Tellef' via RBASE-L"
To: "rbase-l@googlegroups.com"
Sent: 12/17/2021 7:24:29 AMSubject: Re: [RBASE-L] -
Windows 11?
Cool, I'll send them that print-screen. And good to have Myron's first-hand
experience too
Karen
-Original Message-
From: A. Razzak Memon
To: rbase-l@googlegroups.com
Sent: Fri, Dec 17, 2021 9:08 am
Subject: Re: [RBASE-L] - Windows 11?
https://www.rbase.com/rbgx5/require.php
At 09:51 AM 12/17/2021, 'Karen Tellef' via RBASE-L wrote:
>I was just asked if RBase is well behaved with Windows 11. I don't
>know anyone who has Win11 yet, so I'm curious if anyone on this list
>is using it. They are on X.5, so no old versions to worry about.
>
>Karen
--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/0M7ZR3-1mbuAi1OAJ-00xNDW%40mrelay.perfora.net.
--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/1552711679.1722269.1639754669642%40mail.yahoo.com.
--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/em063fb2d9-6848-458c-9165-bb7ea491cbaa%40pathfinder.
--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/2124056320.2446035.1639755918972%40mail.yahoo.com.
Re: [RBASE-L] - Windows 11?
Cool, I'll send them that print-screen. And good to have Myron's first-hand experience too Karen -Original Message- From: A. Razzak Memon To: rbase-l@googlegroups.com Sent: Fri, Dec 17, 2021 9:08 am Subject: Re: [RBASE-L] - Windows 11? https://www.rbase.com/rbgx5/require.php At 09:51 AM 12/17/2021, 'Karen Tellef' via RBASE-L wrote: >I was just asked if RBase is well behaved with Windows 11. I don't >know anyone who has Win11 yet, so I'm curious if anyone on this list >is using it. They are on X.5, so no old versions to worry about. > >Karen -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/0M7ZR3-1mbuAi1OAJ-00xNDW%40mrelay.perfora.net. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/1552711679.1722269.1639754669642%40mail.yahoo.com.
Re: [RBASE-L] - Windows 11?
Appreciate it, thanks Myron! Karen -Original Message- From: myron.fineg...@gmail.com To: rbase-l@googlegroups.com Sent: Fri, Dec 17, 2021 9:09 am Subject: RE: [RBASE-L] - Windows 11? Karen,I am running a Windows 11 Pro laptop with the current version of R:Base X5E. Absolutely no problems. Our organization app runs as it did on Windows 10.And, I’m finding Windows 11 to be a nice upgrade even this early in the life cycle. Myron Finegold From: 'Karen Tellef' via RBASE-L Sent: December 17, 2021 7:52 AM To: rbase-l@googlegroups.com Subject: [RBASE-L] - Windows 11? I was just asked if RBase is well behaved with Windows 11. I don't know anyone who has Win11 yet, so I'm curious if anyone on this list is using it. They are on X.5, so no old versions to worry about. Karen -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/1481159529.2413866.1639752702771%40mail.yahoo.com.-- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/01df01d7f358%2417d18e40%244774aac0%24%40gmail.com. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/811152819.1869242.1639754028491%40mail.yahoo.com.
[RBASE-L] - Windows 11?
I was just asked if RBase is well behaved with Windows 11. I don't know anyone who has Win11 yet, so I'm curious if anyone on this list is using it. They are on X.5, so no old versions to worry about. Karen -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/1481159529.2413866.1639752702771%40mail.yahoo.com.
Re: [RBASE-L] - Announcement: R:BASE "Community" Facebook Group
Yeah the writing was on the wall, wasn't it? Yahoo groups gone, now I think Google groups are on the way out too. Of the dozen groups I was a member of at one time, RBase, RStreet and one horse-related group are the only ones left. I work for my village's government, and whether you like Facebook or not, it is simply the fastest way to get information out to our residents. We can say "it's on our website" or "sign up for our automatic emails or phone calls" til we're blue in the face, and residents check neither. A FB group will work as long as there is the ability for people to create their own posts, include JPGs or upload files (altho it's only recently that we've been able to do the latter on the Google groups!) The thing I like about groups is that it pushes the emails to you, so no effort is required from me to keep up with the posts. In FB either you have to remember to visit the page, or turn notifications on which can be overload and easily ignored. We'll see how it goes! Karen -Original Message- From: javier.valen...@vtgonline.com To: rbase-l@googlegroups.com Sent: Tue, Dec 14, 2021 3:36 pm Subject: RE: [RBASE-L] - Announcement: R:BASE "Community" Facebook Group Wow, the end of an institution. I have archived posts from the various Lists including the old Developer's List going back to 2003 and I still occasionally search for information I remembered someone posted once upon a time. I belong to several groups on Facebook, mostly car related, and I find them very helpful. Habits are hard to change but we must move on with the times. Javier, Javier Valencia, PE 913-915-3137 -Original Message- From: rbase-l@googlegroups.com On Behalf Of A. Razzak Memon Sent: Tuesday, December 14, 2021 1:52 PM To: rbase-l@googlegroups.com Subject: [RBASE-L] - Announcement: R:BASE "Community" Facebook Group Tuesday, December 14, 2021 Dear R:BASE Community, We all know first-hand the fulfillment and joy of helping one another and sharing with R:BASE users online. With the past Email List Servers, and now current Google Group, the R:BASE community members have been paying it forward for decades. As such, we are proud to introduce an additional way to seek help and share R:BASE knowledge with the community, the R:BASE Community Facebook Group! As with Facebook posts, your shared group content may receive feedback/reaction from members in form of likes, wows, etc., with comments and shares. Use the below URL to join the R:BASE Community Facebook Group, and let's start a whole new way of sharing our R:BASE knowledge! https://www.facebook.com/groups/958182905107520 While you all join the group and get ready, we are planning to go live on January 3rd, 2022. Please Note: This Google List Server will no longer be active effective January 3, 2022. Very Best R:egards, Razzak. R:BASE Technologies, Inc. https://www.rbase.com -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/1MqaIG-1mAdU43cTg-00mXIr%40mrelay.perfora.net. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/!%26!AAAYAG1gU%2BA71stIig71BAFnx9iihQAAEG0YO1AHFkFFp0MPHXWnJooBAA%3D%3D%40vtgonline.com. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/128618186.1627934.1639519144375%40mail.yahoo.com.
