[RBASE-L] - RBG11 | Thank you

2024-05-23 Thread Bruce Chitiea
A sincere thanks to everyone involved in suggesting and building the recent enhancements into R:BASE. Well done! Warmest Regards, Bruce Bruce A. Chitiea SafeSectors, Inc. 1142 S Diamond Bar Blvd # 442 Diamond Bar CA 91765-2203 rby...@safesectors.com (909) 238-9012 m -- For group guidelines,

Re[4]: [RBASE-L] - Disappearing RStyle error list

2024-05-15 Thread Bruce Chitiea
Karen Tellef' via RBASE-L" To "rbase-l@googlegroups.com" Date 5/15/2024 2:45:04 PM Subject 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:

Re[2]: [RBASE-L] - Disappearing RStyle error list

2024-05-15 Thread Bruce Chitiea
4 2:27:39 PM Subject 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. Chitiea Safe

Re: [RBASE-L] - Disappearing RStyle error list

2024-05-15 Thread Bruce Chitiea
Karen: Which version and release is this? 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 "'Karen Tellef' via RBASE-L" To "RBase List" Date 5/15/2024 1:08:06 PM

[RBASE-L] - Still an Ampersand Variable Crash Test Dummy

2024-05-07 Thread Bruce Chitiea
All: RGB11 An automated SELECT statement assembly routine produces the variable: v006_select_statement ... from multiple variable segments, which contains a single, no-line-break string such as: SELECT _columnList INTO v006a_hsldOrder_1 INDICATOR vind1, v006a_titleCode_1 INDICATOR vind2,

Re: [RBASE-L] - Version 11

2024-05-03 Thread Bruce Chitiea
Steve: Try this after adding the member: PROPERTY REFRESHLIST ' ' Hope I got that right. 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

Re: [RBASE-L] - Concatenation in an update statement

2024-04-28 Thread Bruce Chitiea
Just a quick shot. IF ... IF there's only one in field1, the SSUBCD function can see it as the "custom delimiter": SET VAR vfield_1_entire TEXT = 'Smith a.4503' SET VAR vfield_1_last4 TEXT = (SSUBCD(.vfield_1_entire,2,'.')) Result: SHOW VAR vfield_1_last4 = 4503 The length of the field after

Re: [RBASE-L] - Checking Variables

2024-04-24 Thread Bruce Chitiea
(CHKVAR('varname')) Checks to see if a variable name exists. The function returns an integer value of 1 if the variable name exists or declared, and 0 if it is not found or declared. -- Original Message -- From "'Dan Goldberg' via RBASE-L" To "rbase-l@googlegroups.com" Date

Re[4]: [RBASE-L] - Disappearing text | An Old-School consideration

2024-04-23 Thread Bruce Chitiea
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 yo

Re[2]: [RBASE-L] - Disappearing text | An Old-School consideration

2024-04-23 Thread Bruce Chitiea
E-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 -- Ori

Re[2]: [RBASE-L] - Disappearing text

2024-04-21 Thread Bruce Chitiea
4, 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

Re: [RBASE-L] - Disappearing text

2024-04-21 Thread Bruce Chitiea
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.

Re[2]: [RBASE-L] - Forms | Accessing a DBcontrol value BEFORE it is saved. | Success

2024-03-25 Thread Bruce Chitiea
variable making it equal to the form field name? Javier, Javier Valencia, PE 14315 S Twilight Ln Olathe, KS 66062 913-915-3137 From:rbase-l@googlegroups.com On Behalf Of Bruce Chitiea Sent: Friday, March 22, 2024 5:33 PM To:rbase-l@googlegroups.com Subject: [RBASE-L] - Forms

Re[6]: [RBASE-L] - Forms | Accessing a DBcontrol value BEFORE it is saved. | Fail

2024-03-25 Thread Bruce Chitiea
ty' 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

Re[4]: [RBASE-L] - Forms | Accessing a DBcontrol value BEFORE it is saved. | Fail

2024-03-24 Thread Bruce Chitiea
(909) 238-9012 m -- Original Message -- From "Razzak Memon" To rbase-l@googlegroups.com; "Bruce Chitiea" Date 3/23/2024 12:26:28 PM Subject Re: Re[2]: [RBASE-L] - Forms | Accessing a DBcontrol value BEFORE it is saved. Bruce, It is the TEXTVALUE that will provide

Re[2]: [RBASE-L] - Forms | Accessing a DBcontrol value BEFORE it is saved.

2024-03-23 Thread Bruce Chitiea
- 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 variabl

[RBASE-L] - Forms | Accessing a DBcontrol value BEFORE it is saved.

2024-03-22 Thread Bruce Chitiea
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

Re[2]: [EXTERNAL] [RBASE-L] - RE: variable gauges

2024-03-21 Thread Bruce Chitiea
Steve already has more gauges than he can handle. So, let's enhance the R: in RV! I can see an app to replace those crappy, useless [ empty | 1/3 | 2/3 | full ] fresh-gray-black-water-tank and battery "gauges" that frustrate the beejeez out of EVERY rig owner! I'll help! Let's test it on

Re[2]: [EXTERNAL] Re: [RBASE-L] - variable gauge set max value

2024-03-20 Thread Bruce Chitiea
Dan: Just spitballin' here: Perhaps variable veshipnum needs pre-formatting to provide the quoted PROPERTY syntax: SET VAR vapos TEXT = SET VAR vgaugeParam TEXT = (.vapos + (CTXT(.veshipnum)) + .vapos) ... alternately: SET VAR vgaugeParam TEXT = ( (CHAR(039)) + (CTXT(.veshipnum)) +

[RBASE-L] - Variable Date Time Edit Control | "Automatic Open"

2024-03-18 Thread Bruce Chitiea
All: I cannot find an RBG11 PROPERTY dedicated to auto-opening a Variable Date Time Edit control. Neither AUTODROPDOWN or MAKECLICK apply to the control (according to R:DOCS); as apparently confirmed by their failure to have an effect. Thoughts? and thanks, Bruce Bruce A. Chitiea

Re: [RBASE-L] - Re: Keyboard Wedge Utility Needed | Thanks

2024-03-12 Thread Bruce Chitiea
dated RBase solution that would place a couple of controls on ANY Rbase form to transfer data to a foreign app's Edit Control. Stay tuned to see how successful the debugging goes. :) Mike On Thursday, February 29, 2024 at 11:47:20 PM UTC-5 Bruce Chitiea wrote: All: I'm exporting a QuickBooks report

[RBASE-L] - Keyboard Wedge Utility Needed

2024-02-29 Thread Bruce Chitiea
All: I'm exporting a QuickBooks report to .CSV for GATEWAY IMPORT and post-processing. I'd like to run an R:BASE external form side-by-side with a QBooks session, so that I can insert a parameter string (e.g. '(1,1,m,s,i,#12345)' ) from R:BASE data into the QBooks Memo field, in real time,

Re[2]: [RBASE-L] - Mailing Address Line Feed Fail | Thank you

2024-01-22 Thread Bruce Chitiea
/21/2024 8:31 PM EST Bruce Chitiea wrote: All: I need to concatenate mailing addresses with variable line counts, for envelope printing. For example: Addressee StreetAddress CityStateZip or: Addressee Department Corporation StreetAddress CityStateZip A Report Variable is placed within the Pa

Re: [RBASE-L] - Re: Mailing Address Line Feed Fail | Solution

2024-01-22 Thread Bruce Chitiea
+ .vspzipplus) ENDIF ELSE SET VAR vrettext = 'No Address Entry' ENDIF Clear Var pt1 CLEAR VAR vspin0,vspcity,vspstatename,vrettextess1,vrettextess2, + vspmainname,vspzipcode,vspzipplus RETURN .vrettext [End SP] On Sunday, January 21, 2024 at 8:31:31 PM UTC-5 Bruce Chitiea wrote: All: I need

Re[2]: [RBASE-L] - Mailing Address Line Feed Fail | Notes

2024-01-22 Thread Bruce Chitiea
. Doug On 1/21/2024 7:31 PM, Bruce Chitiea wrote: All: I need to concatenate mailing addresses with variable line counts, for envelope printing . For example: Addressee StreetAddress CityStateZip or: Addressee Department Corporation StreetAddress CityStateZip A Report Variable is placed wi

Re[2]: [RBASE-L] - R:BASE 11 Released! | Email Address Integrity

2024-01-21 Thread Bruce Chitiea
Kayza: I can't speak to what RBTI might have up their sleeve, but a brute force approach might involve something like this: This might then be a candidate for feeding, possible after validation checking, to the new Variable E-Mail Label control. Very best, Bruce Bruce A. Chitiea

[RBASE-L] - Mailing Address Line Feed Fail

2024-01-21 Thread Bruce Chitiea
All: I need to concatenate mailing addresses with variable line counts, for envelope printing. For example: Addressee StreetAddress CityStateZip or: Addressee Department Corporation StreetAddress CityStateZip A Report Variable is placed within the Page Header of a table-bound Report to serve

Re: [RBASE-L] - mystery character

2024-01-17 Thread Bruce Chitiea
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

Re: [RBASE-L] - R:BASE 11 Released!

2024-01-11 Thread Bruce Chitiea
... and the interface is truly beautiful as well. Great design decisions, across the board. Well done! Many thanks, 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

Re[2]: [RBASE-L] - forcing email address format

2023-12-28 Thread Bruce Chitiea
Kayza: For "one-off" domain verifications, R:BASE includes a very basic 'R:Whois' plugin within the Utilities> Plugin menu. Plugin rwhois opens a dialog which accepts a manually typed domain name, returning whois info, which may then be copied to the clipboard (from which to initiate a

Re: [RBASE-L] - Know when data has been changed in a row of data in a table.

2023-12-03 Thread Bruce Chitiea
Myron: Perhaps test for the value of system variable RBTI_DIRTY_FLAG before running the update routine. R:Syntax: "Returns 1 if any DB Control value(s) in form were changed or 0 if nothing was changed." Great confabbing with you in Vegas, Bruce Bruce A. Chitiea SafeSectors, Inc. 1142 S

Re[2]: [RBASE-L] - Calculating Age in Years, Months | PRIVATE

2023-11-11 Thread Bruce Chitiea
to DATEDIF in Excel. Glad to have the opinion of someone more versed in R:Base than I am. I will use it - as is - in all its ugliness, since it works. Cheers, On Fri, Nov 10, 2023 at 10:24 PM Bruce Chitiea wrote: Charles: Played with it a bit, searching for elegance. The only fully duplicate

Re: [RBASE-L] - Calculating Age in Years, Months

2023-11-10 Thread Bruce Chitiea
Charles: Played with it a bit, searching for elegance. The only fully duplicated segment 'DOD - DOB' is wrapped on all sides by unique function strings, so atomization likely creates more work than it's worth. So, ugly it may be; but if it works ... Alternately, from the list in 2016: CLEAR

Re[2]: [RBASE-L] - On the Question of Primary Keys | Two Cents

2023-11-09 Thread Bruce Chitiea
time. I'm trying to find a bandaid Lin On 2023-11-09 8:19 a.m., Bruce Chitiea wrote: My blustery 0.02061 cents. Just about anything can serve as a PK, so long as ALL values are unique. The code used to generate keys MUST repeat MUST eliminate all opportunities for variance in key structure.

[RBASE-L] - On the Question of Primary Keys | Two Cents

2023-11-09 Thread Bruce Chitiea
My blustery 0.02061 cents. Just about anything can serve as a PK, so long as ALL values are unique. The code used to generate keys MUST repeat MUST eliminate all opportunities for variance in key structure. When one departs from plain vanilla INTEGERs into the realm of text or decimal

Re[2]: [RBASE-L] - Where do I set my Vars?

2023-11-08 Thread Bruce Chitiea
I try to have all calculation and data-formation issues squared away before applying display formatting. So, from R:SYNTAX, this might be helpful: (BRND(arg1,arg2,arg3)) Rounds REAL, DOUBLE, or CURRENCY data to a specific number of decimal places and allows specification of the number of

Re[2]: [RBASE-L] - SET ZERO

2023-11-08 Thread Bruce Chitiea
.e. set var vresult = (.v1 + .v2 + .v3) prior to the comparison logic I personally set zero on if there is any chance of one of the variables being a null value as it may return a null causing the 'IF" statement to fail if zero was off. Anyway just my thoughts on how I use SET ZERO. On Thu,

[RBASE-L] - SET ZERO

2023-11-08 Thread Bruce Chitiea
All: Does SET ZERO affect the parsing of this code: IF varName > 0 THEN ... where varName is INTEGER? In other words, is that expression considered to be a mathematical expression by the parser? From R:SYNTAX: "SET ZERO allows a null to be treated as a zero in a mathematical expression

Re: [RBASE-L] - Limit command does not work as documented

2023-11-06 Thread Bruce Chitiea
Rohan, try: SELECT ALL FROM customer WHERE LIMIT = 5 Bruce -- Original Message -- From rkco...@gmail.com To rbase-l@googlegroups.com Date 11/6/2023 2:12:25 PM Subject [RBASE-L] - Limit command does not work as documented I am using the Concomp database as an example. The following

Re[2]: [RBASE-L] - Database CHOOSER

2023-11-06 Thread Bruce Chitiea
All the best, Randy From:rbase-l@googlegroups.com on behalf of Bruce Chitiea Sent: Sunday, November 5, 2023 9:52 AM To:rbase-l@googlegroups.com Subject: Re: [RBASE-L] - Database CHOOSER Randy: Thanks to help from the list a looong time ago, I built a variable-driven CHOOSE s

Re: [RBASE-L] - Database CHOOSER

2023-11-05 Thread Bruce Chitiea
Randy: Thanks to help from the list a looong time ago, I built a variable-driven CHOOSE structure driven from the R:BASE startup file. The first tier selects the CLASS of database: The second selects a database NAME within the selected Class A stand-alone Choose, available at any time within

Re[2]: [RBASE-L] - creating text file with blank spaces in tact

2023-11-04 Thread Bruce Chitiea
problems, I'll seek further assistance. Thanks again, James On 11/3/2023 6:06 PM, Bruce Chitiea wrote: James: Try using the "hard space" character in place of the ASCII "soft space": clear all var set var vSpc TEXT= (char(160)) set var vfiletext= ('test'+

Re: [RBASE-L] - creating text file with blank spaces in tact

2023-11-03 Thread Bruce Chitiea
James: Try using the "hard space" character in place of the ASCII "soft space": clear all var set var vSpc TEXT= (char(160)) set var vfiletext= ('test'+ format(.#date,'_MMDD')+ '.txt') SET VAR vline01 TEXT= (SFIL(.vSpc,50)) SET VAR vline02 TEXT= (SFIL(.vSpc,50))

Re: [RBASE-L] - Alter table add column

2023-10-31 Thread Bruce Chitiea
Dan: I've relied upon the Design Table feature within the Database Explorer. After adding the column in code, I use the green "Change Order" arrow in the bottom left of the Columns display to move a highlighted column up or down. Good to see you in Vegas, Bruce -- Original Message

Re: [RBASE-L] - Refresh DBGrid after delete?

2023-09-22 Thread Bruce Chitiea
Doing some deep learning on enhanced dbgrids. No real idea. Just spit-ballin' here: PROPERTY invoice8 REDRAWGRID ' ' trees turning color yet? Bruce A. Chitiea SafeSectors, Inc. 1142 S Diamond Bar Blvd # 442 Diamond Bar CA 91765-2203 rby...@safesectors.com (909) 238-9012 m -- Original

[RBASE-L] - Enhanced DB Grid | Does not populate fully

2023-09-10 Thread Bruce Chitiea
All: RBGX5E - current Issue: An Enhanced DB Grid (EDBG) control populates with only the first row drawn from its temp table source. Background: -- the source temp table is configured as a slave table in the Select Tables -- the source temp table is created and fully populated in the On

Re[2]: [RBASE-L] - Announcing the R:BASE 11 Beta

2023-08-21 Thread Bruce Chitiea
Well then, in your mutual honors: Congratulations, and warmest regards! 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 "Javier Valencia" To rbase-l@googlegroups.com

Re: [RBASE-L] - Announcing the R:BASE 11 Beta

2023-08-21 Thread Bruce Chitiea
SELECT ALL EXCEPT col1, ..., coln So much here. Thanks! 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 "A. Razzak Memon" To "RBASE-L Group" Date 8/21/2023 8:00:02

Re: [RBASE-L] - Getting out of an infinite loop

2023-08-13 Thread Bruce Chitiea
Philipe: Try holding down the [ctrl] key and hitting [break] three or four times (maybe 5) in rapid succession. Not a scientific answer, but it has worked for me. Bonne chance! Bruce Bruce A. Chitiea | SafeSectors, Inc. 112 Harvard Ave #272 | Claremont CA 91711-4716 | USA +011 (909)

Re[2]: [RBASE-L] - Report Header Bands | Failure to collapse for NULL data | Success

2023-08-02 Thread Bruce Chitiea
e 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 "collaps

[RBASE-L] - Report Header Bands | Failure to collapse for NULL data

2023-08-02 Thread Bruce Chitiea
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

Re[4]: [RBASE-L] - R:CHARTS - Adjusting the Label Increments on a DateTime X Axis

2023-07-24 Thread Bruce Chitiea
ures. 2. The two hours came from a drop down list. I will let you know how I get on. Thanks again. Regards John Docherty On Monday, July 24, 2023 at 8:29:25 AM UTC+12 Bruce Chitiea wrote: John: It's been a while since I've standardized my axis' configs, rusty now on charting anomalies. F

Re[2]: [RBASE-L] - R:CHARTS - Adjusting the Label Increments on a DateTime X Axis

2023-07-23 Thread Bruce Chitiea
t you have would be much appreciated. Thank you. Regards John Docherty On Monday, July 24, 2023 at 2:12:53 AM UTC+12 Bruce Chitiea wrote: John: Please send a screenshot or PDF of the challenge. Bruce Bruce A. Chitiea | SafeSectors, Inc. 112 Harvard Ave #272 | Claremont CA 91711-4716 | USA

Re: [RBASE-L] - R:CHARTS - Adjusting the Label Increments on a DateTime X Axis

2023-07-23 Thread Bruce Chitiea
John: Please send a screenshot or PDF of the challenge. 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 "johnd...@gmail.com" To "RBASE-L" Date 7/23/2023

Re: [RBASE-L] - Rbase office

2023-07-12 Thread Bruce Chitiea
If that silence is of more than a few days duration, no answer. Comms nationally are taking a beating this week, what with storms, heat and solar activity. Here in SoCal we're having Spectrum and Verizon issues. Guess we'll find out. Bruce A. Chitiea | SafeSectors, Inc. 112 Harvard Ave #272

Re[2]: [RBASE-L] - SubReport Sorting Fail | Success

2023-07-04 Thread Bruce Chitiea
by maintable Dan Goldberg From:rbase-l@googlegroups.com on behalf of Bruce Chitiea Sent: Tuesday, July 4, 2023 3:39:12 PM To:rbase-l@googlegroups.com Subject: [EXTERNAL] [RBASE-L] - SubReport Sorting

[RBASE-L] - SubReport Sorting Fail

2023-07-04 Thread Bruce Chitiea
All: A report "testReport" based on table "mainTable" functions perfectly in all respects, organized around a single Break Header and single Detail band. A subReport based on table "subTable" functions perfectly within the Detail Band in all respects, EXCEPT that so far, I've been unable

Re: [RBASE-L] - Copy of files suddenly stops working | Question

2023-06-27 Thread Bruce Chitiea
Jim: Are you backing up only .RX? files, or do you have a mix in the source folder? If just the .RX? files, there's the old R:azzak trick, run from an .RMD file within the database folder: SET VAR gv_rbaseName TEXT = NULL [1] SET VAR gv_targetPath TEXT = NULL SET VAR gv_fileName TEXT =

Re[2]: [RBASE-L] - Copy of files suddenly stops working

2023-06-27 Thread Bruce Chitiea
This test rig works: SET TRACE ON CLEAR VAR vjim_% SET VAR vjim_source TEXT = 'D:\TESTBED\HUMPTY\*.*' SET VAR vjim_target TEXT = 'D:\TESTBED\DUMPTY\*.*' SET VAR vjim_testFiles TEXT = (.vjim_source & .vjim_target) SET VAR vjim_testCopy TEXT = ('COPY' & .vjim_testFiles) _testCopy SET TRACE OFF

Re[5]: [RBASE-L] - Second ORDER BY parameter? | Thank you

2023-06-22 Thread Bruce Chitiea
volumes.  Y s Bo Franzén Från:rbase-l@googlegroups.com för Bruce Chitiea Skickat: den 22 juni 2023 20:24:43 Till:rbase-l@googlegroups.com Ämne: Re[3]: [RBASE-L] - Second ORDER BY parameter? H

Re[3]: [RBASE-L] - Second ORDER BY parameter?

2023-06-22 Thread Bruce Chitiea
Herr Franzen: Vilken fascinerande forskning! Jag skulle gärna vilja veta om och när den engelska versionen finns tillgänglig. Med vänliga hälsningar, Bruce What fascinating research! I would love to know if and when the English version is available. Very Best, Bruce Bruce A. Chitiea |

[RBASE-L] - Building Ampersanded PROPERTY-Set Variables

2023-05-31 Thread Bruce Chitiea
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

[RBASE-L] - Performance: EEP v. Custom Form Action

2023-04-27 Thread Bruce Chitiea
Just wondering - maintenance considerations aside - if there is a performance gain for code embedded in CFAs vs. EEPs for individual Form controls. Say that in an On Click, or On Exit EEP I have variable-driven branching logic directing the process to one or more blocks of static

RE: [RBASE-L] - Scaling a form that is large to fit on a laptop display

2023-04-12 Thread Bruce Chitiea
n > > From: rbase-l@googlegroups.com On Behalf Of Bruce > Chitiea > Sent: April 12, 2023 4:20 PM > To: rbase-l@googlegroups.com > Subject: Re: [RBASE-L] - Scaling a form that is large to fit on a laptop > display > > Myron: > > Sounds like the form might b

Re: [RBASE-L] - Scaling a form that is large to fit on a laptop display

2023-04-12 Thread Bruce Chitiea
Myron: Sounds like the form might be an all-in-one 'dashboard'. Might there be opportunities to solve the issue for all screen sizes by 'splitting the baby' into two (or more) MDI forms (meaning you can skootch them around, roll them up and down as needed)? Razzak provides a sample

Re: [RBASE-L] - Norton Anti-Virus and the R:Documenter Plugin | Solved

2023-04-11 Thread Bruce Chitiea
| SafeSectors, Inc. 112 Harvard Ave #272 | Claremont CA 91711-4716 | USA +011 (909) 238-9012 m | rby...@safesectors.com -- Original Message -- From "Bruce Chitiea" To "rbase-l@googlegroups.com" Date 3/21/2023 6:08:11 PM Subject [RBASE-L] - Norton Anti-Virus and the

Re[2]: [RBASE-L] - Norton Anti-Virus and the R:Documenter Plugin

2023-03-27 Thread Bruce Chitiea
Original message ---- From: Bruce Chitiea Date: 3/21/23 8:08 PM (GMT-06:00) To: rba...@googlegroups.com Subject: [RBASE-L] - Norton Anti-Virus and the R:Documenter Plugin All: For years now, the Norton 360 anti-virus module has played nice with the excluded RBGX5E.EX

Re[2]: [RBASE-L] - Digest for rbase-l@googlegroups.com - 6 updates in 2 topics

2023-03-23 Thread Bruce Chitiea
:BASE X.5 (Version 10.5) March Madness Promotion Reminder <#group_thread_1> - 1 Update Norton Anti-Virus and the R:Documenter Plugin <http://groups.google.com/group/rbase-l/t/b02f51502f76612?utm_source=digest_medium=email> "Bruce Chitiea" : Mar 22 01:08AM All: For

[RBASE-L] - Fw: Norton Anti-Virus and the R:Documenter Plugin

2023-03-23 Thread Bruce Chitiea
) 238-9012 m | rby...@safesectors.com -- Forwarded Message -- From "Bruce Chitiea" To "rbase-l@googlegroups.com" Date 3/21/2023 6:08:11 PM Subject Norton Anti-Virus and the R:Documenter Plugin All: For years now, the Norton 360 anti-virus module has played nic

[RBASE-L] - Norton Anti-Virus and the R:Documenter Plugin

2023-03-21 Thread Bruce Chitiea
All: For years now, the Norton 360 anti-virus module has played nice with the excluded RBGX5E.EXE program. No issues. Of a sudden, running the R:Documenter Plugin results in: -ERROR- Function sequence error. (2677) ... and, after terminating the running instance of RBGX5E.EXE, Norton

Re[4]: [RBASE-L] - Printing spreadsheets

2023-03-16 Thread Bruce Chitiea
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 claus

Re[2]: [RBASE-L] - Printing spreadsheets

2023-03-16 Thread Bruce Chitiea
less 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: r

Re: [RBASE-L] - Printing spreadsheets

2023-03-16 Thread Bruce Chitiea
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

Re[2]: [RBASE-L] - RCharts Plugin

2023-03-13 Thread Bruce Chitiea
I am trying to implement. Richard -----Original Message- From: Bruce Chitiea To: rbase-l@googlegroups.com Sent: Tue, Mar 7, 2023 2:15 pm Subject: Re: [RBASE-L] - RCharts Plugin Richard Hopkins Haven't had time to dig in today. But try this, ideally in your RBEditor: (Based on the syn

Re: [RBASE-L] - RCharts Plugin

2023-03-07 Thread Bruce Chitiea
Richard: Haven't had time to dig in today. But try this, ideally in your RBEditor: (Based on the syntax for BeforeGenerate EEP in report: RRBYW20:Quarterly_PieChart (shown here in Courier New font, casing in just my style): PLUGIN rCharts + FILENAME midTerm.rbc + |SAVE_TO_JPG

Re[2]: [EXTERNAL] [RBASE-L] - OT: laptop batteries?

2023-02-20 Thread Bruce Chitiea
Karen: Battery ratings are also critical. Latitude model numbers come with a prefix, e.g. "15-3560"; and the battery voltages (e.g. 14.4v, 14.8v) and ratings (e.g. mAh/Wh) are model dependent. Beware the simple listing: "battery for Dell Latitude 3560 laptop". A quick Google of "Dell

Re: ***SPAM*** Re: [RBASE-L] - Filename COPY, and the persistent date/time stamp

2023-02-14 Thread Bruce Chitiea
Interesting. Thanks. Nicky On 2/14/2023 7:07 PM, Bruce Chitiea wrote: Nicky: Great stuff! Did a quick spin through all three, the SourceForge TOUCH option being best suited for .RMD-embedded operation. Revisited an old (1990's) association with JPSoft's TCC.exe replacement for CMD.EXE. Used th

Re: [RBASE-L] - Filename COPY, and the persistent date/time stamp

2023-02-14 Thread Bruce Chitiea
r <https://securityxploded.com/file-date-time-changer.php>. Maybe one invoked through launch would work for you. Nicky On 2/14/2023 2:08 PM, Bruce Chitiea wrote: Thank you, Razzak: I once impugned a litigant's sworn testimony by revealing the metadata of files he had entered into e

Re: [RBASE-L] - Filename COPY, and the persistent date/time stamp

2023-02-14 Thread Bruce Chitiea
SPAM*** Re: [RBASE-L] - Filename COPY, and the persistent date/time stamp Bruce, Change your Windows File Explorer View properties to see the Date created and Date modified columns to see the difference. Very Best R:egards, Razzak On 2/13/2023 5:48 PM, Bruce Chitiea wrote: All: Consider a file

[RBASE-L] - Filename COPY, and the persistent date/time stamp

2023-02-13 Thread Bruce Chitiea
All: Consider a file displayed in the RGBX5E Command file listing: template.rmd | 02/12/2023 | 13:40 On Monday, Feb 13, at 12:00, use the COPY command within an EEP to make a copy: COPY template.rmd showtime.rmd Now, in the file listing, see: template.rmd | 02/12/2023 | 13:40 showtime.rmd

Re: [RBASE-L] - Using Alias for column names

2023-02-13 Thread Bruce Chitiea
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 AM Subject [RBASE-L] - Using Alias for column names I could have

Re: [RBASE-L] - DB checkbox size

2023-01-24 Thread Bruce Chitiea
Dan: Take a look at R:Docs entry for PROPERTY > Database Controls > DB Check Box >[ Height | Width ]. Looks like they adjust the pixel count. I'd like to know too. Bruce A. Chitiea | SafeSectors, Inc. 112 Harvard Ave #272 | Claremont CA 91711-4716 | USA +011 (909) 238-9012 m |

Re[5]: [RBASE-L] - GATEWAY IMPORT Fail | Success, Notes and Postscript

2023-01-12 Thread Bruce Chitiea
12 m | rby...@safesectors.com -- Original Message -- From "Bruce Chitiea" To "rbase-l@googlegroups.com" Date 1/12/2023 9:29:40 AM Subject Re[4]: [RBASE-L] - GATEWAY IMPORT Fail Hey Jim, Happy New Year, and thanks. Great minds. My original code, which I simplified for pre

Re[4]: [RBASE-L] - GATEWAY IMPORT Fail

2023-01-12 Thread Bruce Chitiea
tems People Friendly Since 1990 From:rbase-l@googlegroups.com On Behalf Of Bruce Chitiea Sent: Thursday, January 12, 2023 11:01 AM To:rbase-l@googlegroups.com Subject: Re[2]: [RBASE-L] - GATEWAY IMPORT Fail CAUTION:This is an EXTERNAL EMAIL, STOP! and think before clicking on any links or

Re[2]: [RBASE-L] - GATEWAY IMPORT Fail

2023-01-12 Thread Bruce Chitiea
t; file to automate the entire process. Hope that provides you with some blue's clues! Very Best R:egards, Razzak On 1/11/2023 10:01 PM, Bruce Chitiea wrote: RBG5XE current I'll fill in the drywall forehead dents tomorrow, maybe. Been all over every aspect of this. Exhaustively. Target table refuses

Re[2]: [RBASE-L] - GATEWAY IMPORT Fail

2023-01-12 Thread Bruce Chitiea
manipulate the column names once the data is in R:Base. Happy to send you some code if it helps On Thu, 12 Jan 2023, 1:01 pm Bruce Chitiea, wrote: RBG5XE current I'll fill in the drywall forehead dents tomorrow, maybe. Been all over every aspect of this. Exhaustively. Target table refuses to popul

[RBASE-L] - GATEWAY IMPORT Fail

2023-01-11 Thread Bruce Chitiea
RBG5XE current I'll fill in the drywall forehead dents tomorrow, maybe. Been all over every aspect of this. Exhaustively. Target table refuses to populate. Can anyone see a reason why this import fails? GATEWAY TARGET TABLE CREATE TEMP TABLE stage2_atomized_tt + ( stage1_filenameID TEXT

Re: ***SPAM*** Re: [RBASE-L] - Bit Button On-Click EEP variable values 77, 99

2022-12-27 Thread Bruce Chitiea
ancel] vButton = 99, is the indicator as to how the form was closed. Then, based on the returned value you can continue or cancel the process as you see fit. There is more to that logic in my complex applications. Hope it helps! Very Best R:egards, Razzak On 12/27/2022 1:26 PM, Bruce Chitiea wrote:

[RBASE-L] - Bit Button On-Click EEP variable values 77, 99

2022-12-27 Thread Bruce Chitiea
Of what significance are the specific variable values "77" and "99", often found within Bit Button On-Click EEPs, e.g.: SET VAR vbitButton INTEGER = 77 SET VAR vbitButton INTEGER = 99 If these represent Virtual-Key Codes (FormsManual.pdf, Section 1.8.3.4 p.1321), I'm not "getting" their

Re: [RBASE-L] - Released: R:BASE X.5/X.5 Enterprise (Version 10.5) - Update 5

2022-12-22 Thread Bruce Chitiea
Gentlemen: Thank you very much for rounding out the year for us. Hope you all have the opportunity to relax with family, away from the keyboard and the stresses of the day. Warmest Regards, Bruce Bruce A. Chitiea | SafeSectors, Inc. 112 Harvard Ave #272 | Claremont CA 91711-4716 | USA +011

Fw: Re[2]: [RBASE-L] - capture autonumber field value | COUNT=INSERT

2022-12-08 Thread Bruce Chitiea
All: I searched R:SYNTAX for "COUNT = INSERT" (Found under "WHERE (Short Name: WHER)" | "Basic WHERE Clause Conditions") Can someone clarify? "Refers to the last row inserted in a table by the current user, even if it has been modified by another user. " Q. If I am the "current user",

[RBASE-L] - Reports | Subreport configuration issue

2022-12-04 Thread Bruce Chitiea
RBG5XE latest Q. What might drive this behaviour? With all tables defined around a common key, and with Child Subreports 1-4 successfully established and previewing correctly, Subreport 5 defies configuration. The Subreport 5 configuration tab provides only a Detail band, No Header or

RE: [RBASE-L] - A "null" variable image

2022-11-10 Thread Bruce Chitiea
No selecting-out null records from the data set before generating report? Bruce A. Chitiea SafeSectors, Inc. 112 Harvard Ave #272 | Claremont CA 91711-4716 USA (909) 238-9012 m | rby...@safesectors.com On Nov 10, 2022, 14:53 -0800, javier.valen...@vtgonline.com, wrote: > I am trying to figure out

Re: [RBASE-L] - Released: R:BASE X.5/X.5 Enterprise (Version 10.5) - Update 5 | Thank you

2022-10-13 Thread Bruce Chitiea
Gentlemen: Again, thank you for stellar support and respect for your clientele. Warmest Regards, 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 "A. Razzak

[RBASE-L] - Do you have an R:BASE Fund Accounting App?

2022-09-19 Thread Bruce Chitiea
All: Having recently stepped into the treasurer position of my Rotary Club[1], I'm looking for tools to manage finance and contacts involved in fund raising (e.g. food bank collection, golf tournament, car show) and charitable distribution (e.g. food bank, scholarships, merit awards, global

Re[2]: [RBASE-L] - Finding Duplicates

2022-09-19 Thread Bruce Chitiea
The Indispensable Karen T. ! 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 9/19/2022 7:23:45 AM

Re[2]: [RBASE-L] - Using Multiselect in dialog lookup

2022-08-22 Thread Bruce Chitiea
amp; 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 Su

Re: [RBASE-L] - Using Multiselect in dialog lookup

2022-08-21 Thread Bruce Chitiea
FWIW: 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 |

Re: [RBASE-L] - Released: R:BASE X.5/X.5 Enterprise (Version 10.5) - Update 5 | Thank you very much

2022-08-18 Thread Bruce Chitiea
-- Original Message -- From "A. Razzak Memon" To "rbase-l@googlegroups.com" Date 8/17/2022 9:07:33 PM Subject [RBASE-L] - Released: R:BASE X.5/X.5 Enterprise (Version 10.5) - Update 5 Thursday, August 18, 2022 To All Users of R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5):

Re[2]: [RBASE-L] - Transferring ALL settings ... bad brains

2022-07-30 Thread Bruce Chitiea
olor Configs Bruce - I believe you need rstyle.cfg, per version of R:BASE you are using. Brad Davidson bcdavid...@outlook.com From:rbase-l@googlegroups.com on behalf of Bruce Chitiea Sent: Saturday, July 30, 20

  1   2   3   4   5   >