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

Doug, Thanks for the suggestion, I’ll try it weekend. Happy Holidays to all. Myron From: rbase-l@googlegroups.com On Behalf Of Doug Hamilton Sent: December 21, 2023 8:32 PM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - Know when data has been changed in a row of data in a table.

RE: [RBASE-L] - logging database value changes in a form

Dan, Based on the post under this one we are still working on making the determination as to when data in a row has been changed. Once there we will make the changes accordingly and will keep everyone posted.. Thought you might want to see how our application starts. Our organization curren

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

To all – Thank you for sharing your knowledge. I will keep you in the loop as I work this through. Myron From: rbase-l@googlegroups.com On Behalf Of myron.fineg...@gmail.com Sent: December 3, 2023 8:26 AM To: rbase-l@googlegroups.com Subject: [RBASE-L] - Know when data has been changed in a

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

Subject: Know when data has been changed in a row of data in a table. Background: 1. Using a form to enter or change data that is in a row in a table. 2. The application has code in place to record who is logged into the system. 3. When exiting, with or without data changes to the

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

Bruce – I certainly will take a good hard look. I’ll let you know how I make out – hopefully soon. Thanks. Myron From: rbase-l@googlegroups.com On Behalf Of Bruce Chitiea Sent: April 12, 2023 7:13 PM To: rbase-l@googlegroups.com Subject: RE: [RBASE-L] - Scaling a form that is large to fit

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

Karen, Thank you. We have been trying to solve this for months. Appreciate the response. Myron From: 'Karen Tellef' via RBASE-L Sent: April 12, 2023 10:53 AM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - Scaling a form that is large to fit on a laptop display As far as I kn

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

Jan, Thank you as always. Myron From: rbase-l@googlegroups.com On Behalf Of jan johansen Sent: April 12, 2023 10:45 AM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - Scaling a form that is large to fit on a laptop display Myron, Couple of observations. IF vSize < '1920

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

We have a form that: 1. Is connected to 10 tables. 2. 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 di

RE: [RBASE-L] - Put together two rows of data from one table

Karen, Thanks for the idea. I’m working through all the info. I will get back on the list with ‘the’ solution. Thanks again. Myron From: 'Karen Tellef' via RBASE-L Sent: May 6, 2022 7:47 AM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - Put together two rows of data from one t

RE: Re[2]: [RBASE-L] - Put together two rows of data from one table

Bruce, Yes indeed. Myron From: rbase-l@googlegroups.com On Behalf Of Bruce Chitiea Sent: May 5, 2022 7:54 PM To: rbase-l@googlegroups.com Subject: Re[2]: [RBASE-L] - Put together two rows of data from one table Myron: I hasten to add that if you're blasting 17,000 households, you

RE: [RBASE-L] - Put together two rows of data from one table

Bruce, You are close on the structure. The table is: HouseDetail The column that is the primary key is ‘PropertyID’ (this is a text field based on the structure of the code that is given to the Posse) What I do not have is a unique identifier for each person in the house. My first issue

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 Fine

[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 3

RE: [RBASE-L] - Refresh an External Form

Hello R:Base The list was getting the message I sent – but I was not. Go figure. Sorry for the multiple sends. Myron Finegold From: 'Karen Tellef' via RBASE-L Sent: February 10, 2022 8:39 AM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - Refresh an External Form Was wondering

[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

RE: [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

RE: [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

RE: [RBASE-L] - Refresh an External Form

Thanks to all. I was remiss in explaining the total picture – not knowingly as it turns out. Although, I should have seen this. Ken Shapiro gets the prize for telling me what I missed. Turns out to be reasonable simple solution. The external form is based on a temporary table. So, each session

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 3

[RBASE-L] - Refresh an External Form

R:Base Version X5 - current build. External Form - shown below This 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 f

RE: [RBASE-L] - Converting a Variable to Text

I’d like to say thank you for the prompt responses. You helped me get over the hump, so to speak. Myron Finegold, Sheriff’s Posse of Sun City West From: rbase-l@googlegroups.com On Behalf Of Tony Luck Sent: January 10, 2022 1:58 PM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - Convertin

RE: [RBASE-L] - Converting a Variable to Text

Dan, Thank you. Much appreciated. Myron From: rbase-l@googlegroups.com On Behalf Of Dan Goldberg Sent: January 10, 2022 8:12 AM To: rbase-l@googlegroups.com Subject: RE: [RBASE-L] - Converting a Variable to Text This is what I do to launch(using bing) SET VAR veaddress1 = (address1

[RBASE-L] - Converting a Variable to Text

Goal: To have R:Base create a full text launch command to be used with a browser. The final command that I will need to put in browser will look like the one below. I can get a variable for the street address from the database as a variable, say for the property address (20450 N Stardust Blvd) but

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 RBA

RE: [RBASE-L] - Comparing R:Base Tables

Jim, Thanks for the response. Myron and Jim From: 'Jim Belisle' via RBASE-L Sent: November 16, 2021 7:25 AM To: rbase-l@googlegroups.com Subject: RE: [RBASE-L] - Comparing R:Base Tables If you want to browse the info in table1 you could use BROWSE * FROM table1 WHERE ‘fieldname’ NOT IN (SEL

RE: [RBASE-L] - Comparing R:Base Tables

The database has two tables (for this example). Table 1 - has a unique identifier for each house in the community. There are 17,000 roof tops in the community. So, 17,000 rows. These do not change, it is a fixed structure. Table 2 - uses the same unique identifier. This table contains the propert