RE: [EXTERNAL] [RBASE-L] - R> command history
That was easy. Thanks Dan. From: "'Daniel Goldberg' via RBASE-L" To: "rbase-l@googlegroups.com" Date: Thu, 5 Dec 2024 15:30:14 + Subject: RE: [EXTERNAL] [RBASE-L] - R> command history Go to settings R> Dan Goldberg From: rbase-l@googlegroups.com On Behalf Of jan johansen Sent: Thursday, December 5, 2024 7:22 AM To: rbase-l@googlegroups.com Subject: [EXTERNAL] [RBASE-L] - R> command history All, Somewhere along the line, my command history disappeared. Where do you re-enable it? 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 visit https://groups.google.com/d/msgid/rbase-l/WC20241205152149.1300E8%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 visit https://groups.google.com/d/msgid/rbase-l/BY3PR19MB50272FFEDE85B901A87EC574D4302%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 visit https://groups.google.com/d/msgid/rbase-l/WC20241205153553.7000EA%40jjcalibrations.com.
[RBASE-L] - R> command history
All, Somewhere along the line, my command history disappeared. Where do you re-enable it? 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 visit https://groups.google.com/d/msgid/rbase-l/WC20241205152149.1300E8%40jjcalibrations.com.
[RBASE-L] - QODBC connector
All, I am looking for someone that has experience using the QODBC connector to connect to QuickBooks from R:Base. A little background. I have successfully connected to QuickBooks and attached a table. However I do not appear to be able to list out the table issuing a browse command or just clicking on the attached table. I know I'm overlooking something. 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 visit https://groups.google.com/d/msgid/rbase-l/WC20241203185932.52004A%40jjcalibrations.com.
Re: [RBASE-L] - rotated tex
Jim, Select the "rotated label" under the standard controls in the label designer. Jan From: "'jim schmitt' via RBASE-L" To: rbase group Date: Tue, 29 Oct 2024 16:27:09 + (UTC) Subject: [RBASE-L] - rotated tex I have a sample attached of a postcard bill. The bill will be a report, two per page. Can anyone tell me how to rotate the text as on the attached sample. thanks in advance. Jim Schmitt 1-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 visit https://groups.google.com/d/msgid/rbase-l/514660809.7598212.1730219229105%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 visit https://groups.google.com/d/msgid/rbase-l/WC20241029164553.240004%40jjcalibrations.com.
Re: [RBASE-L] - rotated tex
Jim, Select the "rotated label" under the standard controls in the label/report designer. Jan From: "'jim schmitt' via RBASE-L" To: rbase group Date: Tue, 29 Oct 2024 16:27:09 + (UTC) Subject: [RBASE-L] - rotated tex I have a sample attached of a postcard bill. The bill will be a report, two per page. Can anyone tell me how to rotate the text as on the attached sample. thanks in advance. Jim Schmitt 1-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 visit https://groups.google.com/d/msgid/rbase-l/514660809.7598212.1730219229105%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 visit https://groups.google.com/d/msgid/rbase-l/WC20241029165024.640005%40jjcalibrations.com.
[RBASE-L] - Computed column
All, Is it possible to create a computed column based on a value in a different table? 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/WC20240913134024.780007%40jjcalibrations.com.
Re: [RBASE-L] - Disappearing text
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 ? 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, PE Sent 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:
Re: [RBASE-L] - Disappearing text
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 ? 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, PE Sent 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 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; i
Re: [RBASE-L] - variable gauge set max value
Dan, Just guessing here but the syntax guide shows that n.nn should be surrounded by quotes. Jan From: "'Dan Goldberg' via RBASE-L" To: "rbase-l@googlegroups.com" Date: Mon, 18 Mar 2024 13:16:06 + Subject: [RBASE-L] - variable gauge set max value Using 10.5 latest I have a variable gauge that the max value will need to be set dynamically. I think I found the correct rdocs reference: PROPERTY 'SCALES[n]->OPTIONSVIEW->MAXVALUE' 'n.nn' So I have my command PROPERTY cvgshipped 'SCALES[1]->OPTIONSVIEW->MAXVALUE' .veshipnum Which does not work. I have tried to set SCALES[0] in case it is zero based. Anyone have blues clues? 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/BY3PR19MB50273D65E12E55A78884C29AD42D2%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/WC20240318165658.28005C%40jjcalibrations.com.
Re: [RBASE-L] - Changing File List Box Directory
John,
Glad I could point you in the right direction.
Jan
From: "johnd...@gmail.com"
To: RBASE-L
Date: Thu, 30 Nov 2023 00:32:13 -0800 (PST)
Subject: Re: [RBASE-L] - Changing File List Box Directory
Hi Jan,
I finally have this operating correctly. In case it is of interest to anyone
else, I have the current drive (vdrive), and default DB directory
(vdefdrive) saved when the DB starts, the default directory, including the
drive name, set in the File List Box control and the ON AFTER START EEP in
the DB directory. The On After Start EEP runs an EEP in a file in the DB
directory, which is different from the one the files I am looking for are in
so I had to include the path name to that in the EEP run command, otherwise
it was looking for it in the drive the files were in:-
GETPROPERTY rbfilebox1 DEFAULTDIRECTORY vdefault_can_dir
SET VAR vdefdrive=(SGET(.vdefault_can_dir,2,1))
IF vdefdrive <> .vdrive THEN
SET VAR vdefault_can_dir=(SRPL(.vdefault_can_dir,.vdefdrive, vdrive,0))
ENDIF
PROPERTY RBFileBox1 DEFAULTDIRECTORY &vdefault_can_dir
PROPERTY RBFileBox1 MASK '*.pdf'
PROPERTY RBFileBox1 REFRESHLIST 'TRUE'
Once I sorted out the need to use the &variable in the PROPERTY command, but
not in the GETPROPERTY command things went a lot better.
Thank you.
Regards
John Docherty
On Thursday, November 30, 2023 at 7:46:55 PM UTC+13 johnd...@gmail.com
wrote:
Hi Jan,
Thank you for your advice. I am still working on this but I have made some
progress thanks to your help.
Regards
John Docherty
On Thursday, November 30, 2023 at 2:15:12 AM UTC+13 jan johansen wrote:
John,
I would think you need to do something like this...
--Form On Before Start EEP
SET VAR vCurrDrv = (CVAL('CURRDRV'))
--Form On AFTER Start EEP
PROPERTY yourfilelistboxpropertyid DEFAULTDIRECTORY .vCurrDrv
PROPERTY yourfilelistboxpropertyid REFRESHLIST 'TRUE'
Jan
From: "johnd...@gmail.com"
To: RBASE-L
Date: Wed, 29 Nov 2023 02:03:17 -0800 (PST)
Subject: [RBASE-L] - Changing File List Box Directory
I am trying to work out how to change the default directory based on the
value of the CURRDRV as I swap the database between one laptop where the DB
is on the D drive and another which only has a C drive. I have tried using
the PROPERTY & GETPROPERTY commands and the DEFAULTDIRECTORY but it seems
that making this work is beyond me... If anyone can please provide some
advice regarding this 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+u...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/58b539c0-278f-4047-9b14-7de88f495ea1n%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/ccac742f-40a7-4a4e-a26e-a43c6ccc5fbfn%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/WC20231130133536.170004%40jjcalibrations.com.
Re: [RBASE-L] - Changing File List Box Directory
John,
I would think you need to do something like this...
--Form On Before Start EEP
SET VAR vCurrDrv = (CVAL('CURRDRV'))
--Form On AFTER Start EEP
PROPERTY yourfilelistboxpropertyid DEFAULTDIRECTORY .vCurrDrv
PROPERTY yourfilelistboxpropertyid REFRESHLIST 'TRUE'
Jan
From: "johnd...@gmail.com"
To: RBASE-L
Date: Wed, 29 Nov 2023 02:03:17 -0800 (PST)
Subject: [RBASE-L] - Changing File List Box Directory
I am trying to work out how to change the default directory based on the
value of the CURRDRV as I swap the database between one laptop where the DB
is on the D drive and another which only has a C drive. I have tried using
the PROPERTY & GETPROPERTY commands and the DEFAULTDIRECTORY but it seems
that making this work is beyond me... If anyone can please provide some
advice regarding this 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/58b539c0-278f-4047-9b14-7de88f495ea1n%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/WC20231129131508.210004%40jjcalibrations.com.
Re: [RBASE-L] - Windows 11
Razzak, Thank you, Jan From: Razzak Memon To: rbase-l@googlegroups.com Date: Wed, 19 Jul 2023 14:08:08 -0400 (EDT) Subject: Re: [RBASE-L] - Windows 11 Jan, Here's a checklist for you! Create a C:\Temp folder with full access Setup Windows System Properties > Environment Variables (TEMP and TMP) to C:\Temp Adjust User Account Setting Control (All the way down to Never Notify) Windows Virus & threat protection settings > Exclusions > Add an Exclusion The entire \RBTI\ folder The entire database/application folder C:\Windows\SysWOW64\RBENGINEX5E.DLL I hope that provides you with some blue's clues ... Very Best R:egards, Razzak On 07/19/2023 1:28 PM EDT jan johansen wrote: All, Reported from user that everything runs "snappy" except RBase. Any blues clues for Windows 11? 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/WC20230719172854.5600E3%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/713908600.1512201.1689790088212%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/WC20230720144322.90006D%40jjcalibrations.com.
[RBASE-L] - Windows 11
All, Reported from user that everything runs "snappy" except RBase. Any blues clues for Windows 11? 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/WC20230719172854.5600E3%40jjcalibrations.com.
Re: [RBASE-L] - Scaling a form that is large to fit on a laptop display
Myron,
Couple of observations.
IF vSize < '1920' THEN SET VAR vNewSize = '1920'
ELSE
SET VAR vNewSize = vSize ( <-- shouldn't vsize be a dotted variable? )
ENDIF
PROPERTY RBASE_FORM SCALEBY .vNewSize (possibly use &vNewSize)
Jan
From:
To:
Date: Wed, 12 Apr 2023 07:52:37 -0700
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 following
SET 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 = vSize
ENDIF
PROPERTY 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/WC20230412174439.160138%40jjcalibrations.com.
RE: [RBASE-L] - Date
Thanks all. From: "Ken Shapiro" To: Date: Thu, 12 Jan 2023 20:25:48 -0500 Subject: RE: [RBASE-L] - Date Alternatively – accomplishes the same thing. SET VAR vdate DATE =(.#DATE) SET VAR vprevious_date date= (ADDMON (RDATE(IMON(.vdate),1,IYR4(.vdate)),-2)) Regards, Ken From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of Doug Hamilton Sent: Thursday, January 12, 2023 2:12 PM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - Date Jan, try this: --vDate is a test date, try different values; change to .#Date in the expression after testing SET VAR vdate DATE = '2/28/2023' SET VAR vStartDate DATE = + (RDATE( (IMON( ADDMON(.vdate,-2))),1,(IYR(ADDMON(.vdate,-2))) )) SHOW VAR vstartdate RETURN Doug On 1/12/2023 12:27 PM, jan johansen wrote: All, I'm having a brain cramp. My code doesn't handle crossing years apparently. I need to set a start date that is the first of the 2 months ago based on today i.e. 11/1/2022 Thanks 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/WC20230112182746.3000D7%40jjcalibrations.com. 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/5967bf96-15ae-6114-3a01-83e4aa986d07%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/000501d926ed%24f845f820%24e8d1e860%24%40optonline.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/WC20230113141951.310001%40jjcalibrations.com.
[RBASE-L] - Date
All, I'm having a brain cramp. My code doesn't handle crossing years apparently. I need to set a start date that is the first of the 2 months ago based on today i.e. 11/1/2022 Thanks 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/WC20230112182746.3000D7%40jjcalibrations.com.
RE: [RBASE-L] - capture autonumber field value
I prefer Steve's way because as Karen already mentioned, forms work differently between ENTER USING and EDIT USING. From: Steve Sweeney To: "'rbase-l@googlegroups.com'" Date: Thu, 8 Dec 2022 17:01:54 + Subject: RE: [RBASE-L] - capture autonumber field value Another option would be to INSERT INTO tablename (TEXT_columnname) VALUES (‘obscure_reference_code’) to establish the primary key (PK) first. Then SELECT pk_columnname INTO variable_name FROM tablename WHERE TEXT_columnname = ‘obscure_reference_code’ Then you can “EDIT USING formname WHERE pk_columnname = . variable_name From: rbase-l@googlegroups.com On Behalf Of Doug Hamilton Sent: Thursday, December 8, 2022 9:01 AM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - capture autonumber field value whoopsie - NEXT is a bad idea if you just want the autonum value - because it increments the Autonum counter Doug On 12/8/2022 10:56 AM, Doug Hamilton wrote: Dan - two other options might be: 1) If you're trying to get the next autonumber value, the NEXT function: (NEXT(tblname,autonumcol)) Returns the next value of an autonumbered column. Subtract 1 to get the last assigned number. See: https://www.rbase.com/support/rsyntax/rbgx5/next_functions_3.html 2) MAX function: SELECT MAX(ColumnName) FROM TableName You might need to consider how many users are adding rows to the table to make sure you get the right number. Doug On 12/8/2022 9:45 AM, A. Razzak Memon wrote: Dan, SET VAR vLastValue INTEGER = 0 SELECT colname INTO vLastValue INDIC iv1 FROM tablename WHERE COUNT = INSERT Alternatively, you could also try: SET VAR vLastValue INTEGER = 0 SELECT colname INTO vLastValue INDIC iv1 FROM tablename WHERE COUNT = LAST Hope it helps! Very Best R:egards, Razzak On 12/8/2022 10:34 AM, Dan Goldberg wrote: 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/436f1de3-b28b-42e1-872d-4ba5fec406e8%40rbase.com. 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/c025e046-ce92-0cf8-b9f1-2dc21e4c3489%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/812fc3be-0dbf-5e17-1c6a-06a41658d1a4%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/BYAPR03MB371879136A57A16DB60E068E891D9%40BYAPR03MB3718.namprd03.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/m
RE: Re[2]: [RBASE-L] - Using Multiselect in dialog lookup
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 mailto:rby...@safesectors.com]> To:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com]mailto: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_WHEREORDER BY Company + Dan's code: | POPUP_WHERE WHEREfull_name IS NOT NULL + Bruce -- Original Message -- >From "'Karen Tellef' via RBASE-L" mailto:rbase-l@googlegroups.com]> To "rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com]"; mailto: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 mailto:rby...@safesectors.com]> To:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com]mailto: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 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_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" mailto:d...@lancecamper.com]> To "rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com]"; mailto:rbase-l@googlegroups.com]> Date 8/21/2022 6:11:53 PM Subject [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
Re: [RBASE-L] - eMail table structure
Karen, Nice. Thanks a lot! Jan From: "'Karen Tellef' via RBASE-L" To: "rbase-l@googlegroups.com" Date: Wed, 4 May 2022 16:52:43 + (UTC) Subject: 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 CmdFileType : 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 : NOTE AlertFailedType : DATETIME If RMail failed, date put here EmailTypeIDType : INTEGERDefault: 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" AlertFileAttachType : 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, etc that 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. -- 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/WC20220504170350.47013E%40jjcalibrations.com.
[RBASE-L] - eMail table structure
Greetings, Was just wondering if anyone had a successful table structure to store emails to send, etc that 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.
[RBASE-L] - R:Mail and Office365
Group, After several days of much weeping and gnashing of teeth, finally got a resolution on R:Mail and Office365. With John's help at RBTI interpreting the error messages we finally landed on a setting that allowed a decipherable error message in the 365Admin panel. >From Microsoft support; Sign in to the Azure portal as a security administrator, Conditional Access administrator, or global administrator. Browse to Azure Active Directory > Properties. Select Manage security defaults. Set the Enable security defaults toggle to NO Select Save. I hope this helps someone else. 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/WC20220503153143.290003%40jjcalibrations.com.
Re: [RBASE-L] - detect wireless connection
Dan, I'm interested in this idea as well. One option I've been wondering about is including ALL the forms, reports and labels inside the compiled app. That way the only stuff that should be flying through the ether is the actual data. Maybe someone else has an idea. Jan From: Dan Goldberg To: "rbase-l@googlegroups.com" Date: Fri, 22 Apr 2022 13:36:54 + Subject: [RBASE-L] - detect wireless connection Does anyone know If there is a way to detect if the active network connection is wireless? I want to be able to not allow them to run our compiled rbase app on their laptops when they are on wireless. 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/2E4830CEC16615458329D3D83342F8D0014EFEE31D%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/WC20220422134549.620127%40jjcalibrations.com.
Re: [RBASE-L] - Suspend message
...it would still be helpful to know "what" message id that is. From: "A. Razzak Memon" To: rbase-l@googlegroups.com Date: Fri, 25 Feb 2022 09:18:54 -0500 Subject: Re: [RBASE-L] - Suspend message TRACE it (line-by-line), and you will see exactly what line and/or sequence is the cause. At 09:13 AM 2/25/2022, jan johansen wrote: >Well, I'm the only one logged in using a temporary table. >I'm really trying to figure out at what point the message is being generated. > > > >From: "A. Razzak Memon" >To: rbase-l@googlegroups.com >Date: Fri, 25 Feb 2022 09:06:59 -0500 >Subject: Re: [RBASE-L] - Suspend message > >Jan, > >Instead of suppressing that message, I suggest to closely review and >change your EEP and/or sequence that is generating that message. > >As a developer, it would be the right thing to do, IMHO. > >Razzak > >At 09:00 AM 2/25/2022, jan johansen wrote: > > >All, > > > >I'm interested in silencing this message; > > > >Data Has Been Changed by Another User Since Last Refresh. Do You > >Want to Save The Changes? > >-- >For group guidelines, visit ><http://www.rbase.com/support/usersgroup_guidelines.php>http://www.rbase.com/support/usersgroup_guidelines.php >--- >You received this message because you are subscribed to the Google >Groups "RBASE-L" group. >To unsubscribe from this group and stop receiving emails from it, >send an email to ><mailto:rbase-l%2Bunsubscribe%40googlegroups.com>rbase-l+unsubscr...@googlegroups.com. >To view this discussion on the web visit ><https://groups.google.com/d/msgid/rbase-l/0M07SM-1oD6RH1dLY-00uGLk%40mrelay.perfora.net>https://groups.google.com/d/msgid/rbase-l/0M07SM-1oD6RH1dLY-00uGLk%40mrelay.perfora.net. > >-- >For group guidelines, visit ><http://www.rbase.com/support/usersgroup_guidelines.php>http://www.rbase.com/support/usersgroup_guidelines.php >--- >You received this message because you are subscribed to the Google >Groups "RBASE-L" group. >To unsubscribe from this group and stop receiving emails from it, >send an email to ><mailto:rbase-l+unsubscr...@googlegroups.com>rbase-l+unsubscr...@googlegroups.com. >To view this discussion on the web visit ><https://groups.google.com/d/msgid/rbase-l/WC20220225141350.890045%40jjcalibrations.com?utm_medium=email&utm_source=footer>https://groups.google.com/d/msgid/rbase-l/WC20220225141350.890045%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/0MU0Mp-1noAhy355l-00Qjut%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/WC20220225142301.880048%40jjcalibrations.com.
Re: [RBASE-L] - Suspend message
Well, I'm the only one logged in using a temporary table. I'm really trying to figure out at what point the message is being generated. From: "A. Razzak Memon" To: rbase-l@googlegroups.com Date: Fri, 25 Feb 2022 09:06:59 -0500 Subject: Re: [RBASE-L] - Suspend message Jan, Instead of suppressing that message, I suggest to closely review and change your EEP and/or sequence that is generating that message. As a developer, it would be the right thing to do, IMHO. Razzak At 09:00 AM 2/25/2022, jan johansen wrote: >All, > >I'm interested in silencing this message; > >Data Has Been Changed by Another User Since Last Refresh. Do You >Want to Save The Changes? -- 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/0M07SM-1oD6RH1dLY-00uGLk%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/WC20220225141350.890045%40jjcalibrations.com.
[RBASE-L] - Suspend message
All, I'm interested in silencing this message; Data Has Been Changed by Another User Since Last Refresh. Do You Want to Save The Changes? 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/WC20220225140005.300036%40jjcalibrations.com.
Re: [RBASE-L] - PRINT
Thank you Razzak! From: "A. Razzak Memon" To: rbase-l@googlegroups.com Date: Fri, 04 Feb 2022 10:30:29 -0500 Subject: Re: [RBASE-L] - PRINT Jan, Here's how ... Use the RBTI_PRNDEFFILE system variable to define the default file name for the "Print to File" print dialog, before the dialog is launched. SET VAR RBTI_PRNDEFFILE TEXT = 'InventoryReport.pdf' The below report-based RBTI system variables are also available: RBTI_PRNDEFDIR - defines the default directory for the "Print to File" print dialog, before the dialog is launched SET VAR RBTI_PRNDEFDIR TEXT = 'C:\Temp\' RBTI_PRNDEFFILET - defines the default output type for the "Print to File" print dialog, before the dialog is launched SET VAR RBTI_PRNDEFFILET TEXT = 'Adobe PDF File' Have fun! Very Best R:egards, Razzak. R:BASE Technologies, Inc. https://www.rbase.com At 07:12 AM 2/4/2022, jan johansen wrote: >All, > >I thought I'd seen this before but I'm not sure. > >Most of the time printing a report to SCREEN is the preferred option. >However, when I want to "Print to a file" from the SCREEN, the file name >shows as the called report i.e. PRINT MyReport shows up as MyReport in the >print to file area. > >Is there a way to pre-define what that filename will be? > >I'm not interested in printing as PDF and launching. > >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/0MLNQq-1nGYVZ0MRW-000e2M%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/WC20220206113830.760027%40jjcalibrations.com.
Re: [RBASE-L] - Refresh an External Form
Myron, Enable the form timer. Set it to 3mS Refresh 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 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 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 Finegold Sun 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.
[RBASE-L] - PRINT
All, I thought I'd seen this before but I'm not sure. Most of the time printing a report to SCREEN is the preferred option. However, when I want to "Print to a file" from the SCREEN, the file name shows as the called report i.e. PRINT MyReport shows up as MyReport in the print to file area. Is there a way to pre-define what that filename will be? I'm not interested in printing as PDF and launching. 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/WC20220204121242.060010%40jjcalibrations.com.
Re: [RBASE-L] - How to navigate to a specific table row and display it on a form
Jim, Maybe EDIT USING ... WHERE COUNT = INSERT Jan From: James Burroughs To: rbase-l@googlegroups.com Date: Wed, 26 Jan 2022 19:54:04 -0700 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/WC20220127120200.38000F%40jjcalibrations.com.
Re: [RBASE-L] - unique key/primary key
Dan, It's my understanding that a PK is an index. Jan From: Dan Goldberg To: "rbase-l@googlegroups.com" Date: Fri, 14 Jan 2022 15:25:10 + Subject: [RBASE-L] - unique key/primary key Doe a unique key or primary key also act as an index? Just wonder if i should index a unique/primary key to speed up look ups. 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/2E4830CEC16615458329D3D83342F8D0014EF2AA18%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/WC20220114154214.40012A%40jjcalibrations.com.
Re: [RBASE-L] - Formatting
...there I go complicating things again. Thanks Razzak. From: "A. Razzak Memon" To: rbase-l@googlegroups.com Date: Wed, 12 Jan 2022 07:33:20 -0500 Subject: Re: [RBASE-L] - Formatting Here's how ... SET VAR vMakeDir TEXT = (FORMAT(.#DATE,'_MM')) That's all there is to it! Very Best R:egards, Razzak At 07:18 AM 1/12/2022, jan johansen wrote: >Group, > >Desired end result: 2022_01 > >I want RBase to create a directory named "2022_01" >I can use this >SET VAR vMakeDir TEXT = ( (CTXT(IYR4,.#DATE))+'_'+(CTXT(IMON,.#DATE)) ) >but that results in 2022_1 > >How can I format the "month" to be 2 characters? > >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/0MVen3-1mqpSP0Lk7-00Z0yW%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/WC20220112123721.890008%40jjcalibrations.com.
[RBASE-L] - Formatting
Group, Desired end result: 2022_01 I want RBase to create a directory named "2022_01" I can use this SET VAR vMakeDir TEXT = ( (CTXT(IYR4,.#DATE))+'_'+(CTXT(IMON,.#DATE)) ) but that results in 2022_1 How can I format the "month" to be 2 characters? 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/WC20220112121832.030004%40jjcalibrations.com.
RE: [RBASE-L] - Copy from Rbase Report to Clipboard
What I have done is to print the report using OPTION PDF and then launch it (most files using PDF are already associated with Adobe reader). Then you copy your text. From: To: Date: Fri, 10 Sep 2021 02:38:14 -0500 Subject: RE: [RBASE-L] - Copy from Rbase Report to Clipboard You can click on the Printer icon on the upper left corner and then check print to file, select a format such as PDF and assign a name: When you click OK you will be prompted to select options: Click open to generate and OK and the report will be opened as PDF and you can select and save to the Windows clipboard as needed. Of course you can send the report directly to a PDF file with a command: PRINT YourReportName WHERE….. Order BY ….OPTION PDF |FILENAME xxx.PDF |OPEN ON And the file xxx.PDF will open with the report. Javier, Javier Valencia, PE 913-915-3137 -Original Message- From: rbase-l@googlegroups.com On Behalf Of James Burroughs Sent: Thursday, September 9, 2021 6:17 PM To: rbase-l@googlegroups.com Subject: [RBASE-L] - Copy from Rbase Report to Clipboard Is it possible to select text from an Rbase report that is displayed on the screen and copy it to the Windows clipboard? 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/d434b2f6-ee08-985b-fe17-259523a16c93%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/!%26!AAAYAG1gU%2BA71stIig71BAFnx9iihQAAEBfiHtPFd3JPmaQy76eJOYUBAA%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/WC20210910113828.850010%40jjcalibrations.com.
Re: [RBASE-L] - Variable Not Defined
Charles,
Try
IF (CHKVAR('vMAXID')) = 1 THEN
SET VAR vMAXID = (IFEQ(.VMAXID,NULL,0,.VMAXID)
ENDIF
Jan
From: Charles Stevens
To: RBASE-L
Date: Sun, 5 Sep 2021 13:41:34 -0700 (PDT)
Subject: [RBASE-L] - Variable Not Defined
What would be the best way to identify a variable as undefinied in an
application and exit the routine? I have a reference to vMAXID which may not
be defined under some circumstances (not just null), and I need to terminate
processing. I have a SET VAR vMAXID = (IFEQ(.VMAXID,NULL,0,.VMAXID) which
throws an error message "variable not defined" with an error code of 2515,
but this seems a rather clumsy way to find the error. Thanks in advance . .
.
--
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/de7023d9-a39d-4bdb-a67b-b860f52c6abcn%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/WC20210907143255.040050%40jjcalibrations.com.
Re: [RBASE-L] - Still No watch variables, even after 20812 update
Doug, Are you pressing F6 to bring up the list of variables and then selecting the ones you wish to watch? Jan From: Doug Hamilton To: rbase-l@googlegroups.com Date: Tue, 17 Aug 2021 10:23:30 -0500 Subject: Re: [RBASE-L] - Still No watch variables, even after 20812 update Thank you Razzak. The Watch variables option is checked and the Watch Variables panel is displayed but no variables appear. I went into the registry. These were the initial values: FloatHeight x266, FloatLeft x000, FloatTop x000, FloatWidth x000 I modified them as suggested and still no variables are displayed in the Watch Variable panel. There are no other floating windows or panels displayed. Below is screen shot of a trace-in-progress with the Registry overlaid. F6, Added Variables, expected to be Watched include #DATE, #PI, vEndKey, vErrVar and others. Are any other registry values incorrect? I wanted to check before I run Default_Settings. TIA, Doug On 8/17/2021 8:45 AM, A. Razzak Memon wrote: Doug, While in Trace Debugger select Layout > Toolbars from the main menu, and check the option for Watch Variables. If you had recently secured your personal settings for the R:BASE environment, those setting may be loaded. The R:BASE development environment that has been customized with your display preferences, custom colors, startup options, R> Prompt command history, Database Explorer color appearance, and R:BASE Editor schema can be preserved to load later, for reinstalls of R:BASE. To unload your personal settings, choose "Settings" > "Registry Settings" > "Save to File..." from the main menu bar. A .bin file is to be specified for the registry data. Save the .bin file to a non-local media, similar to the database files. You may also run the RBGX5E_Default_Settings.exe utility within the C:\RBTI\RBGX5E folder, which will reset all of environment registry settings for the R:BASE installation. R:BASE must be closed for the utility to run correctly. If you had not secured your personal settings, and you want keep the current work environment, you may edit the Registry, and modify the following node: Computer\HKEY_CURRENT_USER\SOFTWARE\R:BASE Technologies\RBGX5E\Trace Window\Toolbars\Watch Variables The FloatHeight, FloatLeft, FloatTop, and FloatWidth binary values can be modified to around 300 to place the floating toolbar at coordinates you can then see. Please note, modifying the Registry can damage your Windows environment, if done improperly. Very Best R:egards, Razzak At 07:21 PM 8/16/2021, Doug Hamilton wrote: Trace Debugger is still not showing variables in the Watch Variables panel, even reliables like #DATE, #TIME, #PI etc. The new Live variables are displayed. Any hints to cure the Blues Clues? TIA, Doug 10.5XE 10.5.3.20812 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/b6fa1e7b-6f34-866c-49d8-5b169795b403%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/WC20210817153933.41006D%40jjcalibrations.com.
Re: [RBASE-L] - R:Mail question
David, Once you get it running again, I would be very interested in your settings. Jan From: dkfowler6...@comcast.net To: rbase-l@googlegroups.com Date: Tue, 27 Jul 2021 20:04:16 -0400 Subject: [RBASE-L] - R:Mail question We've been using R:Mail with R:Base X for 3 years or so. Same email provider (comcast) and code for sending email without issues all this time. Today our emails quit sending. A look at the R:Mail log shows that the email provider says that authentication and TLS are now required. We have always had authentication enabled along with SSL. I see different options for TLS in the R:Mail configuration app, but I don't really know what any of the options mean. I made several changes to those check boxes and tried many different combinations. I also changed the port to the one now listed as the correct port to use with the provider. No matter what I tried, I end up with a failure notice. Looking at the log again with different TLS settings returns no error, but there is also no log of communication with the smtp server. I also tried using a gmail smtp that we had set up previously as a backup in case of issues with the comcast server. Those attempts gave the same issues and failure to send. Even tried with a Yahoo account with the same results. I would appreciate any help or advice anyone may have that could get me headed in the right direction for a solution. Thanks, David Fowler Sent from my android device. -- 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/7622b9e2-a342-4af6-8a94-47efcfbe41d8.maildroid%40localhost. -- 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/WC20210728120437.600033%40jjcalibrations.com.
Re: Re[2]: [RBASE-L] - Hybrid Drop-Down, Multi-Select Variable Control?
Bruce, No I haven't used that. I had wanted to replicate a "Quickbooks" style drill on a very limited basis and had some success using a Variable List View. I think the Enhanced DB-Grid might do what you want. Jan From: "Bruce Chitiea" To: "rbase-l@googlegroups.com" Date: Mon, 19 Jul 2021 16:23:33 + Subject: Re[2]: [RBASE-L] - Hybrid Drop-Down, Multi-Select Variable Control? An intriguing note within the R:Syntax Help for the CHOOSE command: "Use the CHOOSE command to display the following types of menus: bar with a pull-down..." I imagine that the control looks like ... a bar with a pull down, much like a combo box. But I am NOT finding reference, within either the Help OPTIONS text, or within the CHOOSE BUILDER Plugin interface, to the formatting of such an object. Have you created a "bar with a pull down" CHOOSE object? Thanks much, Bruce Bruce A. Chitiea | SafeSectors, Inc. 112 Harvard Ave #272 | Claremont CA 91711-4716 | USA rby...@safesectors.com | +011 (909) 238-9012 c | +011 (909) 912-8678 f -- Original Message -- From: "jan johansen" To: rbase-l@googlegroups.com Sent: 7/19/2021 9:02:25 AM Subject: Re: [RBASE-L] - Hybrid Drop-Down, Multi-Select Variable Control? Bruce, Short answer...yes, I have simulated it. However, if I remember correctly, there is a better control for that now, but the name escapes me. Jan From: "Bruce Chitiea" To: "rbase-l@googlegroups.com" Date: Mon, 19 Jul 2021 15:50:07 + Subject: [RBASE-L] - Hybrid Drop-Down, Multi-Select Variable Control? Off-the-wall, perhaps: Has anyone simulated, in any fashion, the integration of the drop-down feature of a Variable Lookup Combo Box with the Multi-Select / Show Check Box features of a Variable Lookup [ List Box | List View ]? This would speed aggregation of list variable values, while conserving Form real estate. The closest I've come is a CHOOSE routine embedded in an EEP, or a Variable Lookup List Box within a nested form. Just wondering, Bruce Bruce A. Chitiea | SafeSectors, Inc. 112 Harvard Ave #272 | Claremont CA 91711-4716 | USA rby...@safesectors.com | +011 (909) 238-9012 c | +011 (909) 912-8678 f -- 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/em97f4783b-9534-47fa-b9c9-97326c07520b%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/WC20210719160225.54008B%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/em1a7766c3-0917-4fb5-a34d-226f954cf256%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/WC20210719163416.0500A9%40jjcalibrations.com.
Re: [RBASE-L] - Hybrid Drop-Down, Multi-Select Variable Control?
Bruce, Short answer...yes, I have simulated it. However, if I remember correctly, there is a better control for that now, but the name escapes me. Jan From: "Bruce Chitiea" To: "rbase-l@googlegroups.com" Date: Mon, 19 Jul 2021 15:50:07 + Subject: [RBASE-L] - Hybrid Drop-Down, Multi-Select Variable Control? Off-the-wall, perhaps: Has anyone simulated, in any fashion, the integration of the drop-down feature of a Variable Lookup Combo Box with the Multi-Select / Show Check Box features of a Variable Lookup [ List Box | List View ]? This would speed aggregation of list variable values, while conserving Form real estate. The closest I've come is a CHOOSE routine embedded in an EEP, or a Variable Lookup List Box within a nested form. Just wondering, Bruce Bruce A. Chitiea | SafeSectors, Inc. 112 Harvard Ave #272 | Claremont CA 91711-4716 | USA rby...@safesectors.com | +011 (909) 238-9012 c | +011 (909) 912-8678 f -- 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/em97f4783b-9534-47fa-b9c9-97326c07520b%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/WC20210719160225.54008B%40jjcalibrations.com.
Re: [RBASE-L] - PROPERTY 'cid_variableControl' ENABLED [ 'TRUE' | 'FALSE' ] fail
Bruce, Sometimes PROPERTY order makes a difference, so I would reverse your color setting and the enable. I think you need to trace your "Save & Next" to see where it isn't looping back. Jan From: "Bruce Chitiea" To: "rbase-l@googlegroups.com" Date: Sat, 17 Jul 2021 18:42:24 + Subject: [RBASE-L] - PROPERTY 'cid_variableControl' ENABLED [ 'TRUE' | 'FALSE' ] fail RBGX5E ... 0624 (1) A Variable Lookup Combo Box control: cid_vlcb_humpty is successfully activated in the Form's On After Start EEP with: PROPERTY 'cid_vlcb_humpty' ENABLED 'TRUE' PROPERTY 'cid_vlcb_humpty' COLOR 'BUTTONFACE' (2) Depending on the need, cid_vlcb_humpty is successfully de-activated in an EEP of an upstream control with: PROPERTY 'cid_vlcb_humpty' ENABLED 'FALSE' PROPERTY 'cid_vlcb_humpty' COLOR 'INACTIVECAPTION' (3) In the Form's "Save & Next" Bit Button, cid_vlcb_humpty is SUPPOSED TO be re-activated for the next go-round with: PROPERTY 'cid_vlcb_humpty' ENABLED 'TRUE' PROPERTY 'cid_vlcb_humpty' COLOR 'BUTTONFACE' ... but the control is not re-activated. This simplified presentation holds true for several controls on the form. What am I missing? Assistance greatly appreciated, Bruce Bruce A. Chitiea | SafeSectors, Inc. 112 Harvard Ave #272 | Claremont CA 91711-4716 | USA rby...@safesectors.com | +011 (909) 238-9012 c | +011 (909) 912-8678 f -- 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/em19c06730-7e19-4374-a08c-834f48de5ebd%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/WC20210719125320.190013%40jjcalibrations.com.
[RBASE-L] - P-Touch label printers
Group, I would just like to know if anyone has had success printing to the Brother P-Touch series. I have the label set for "landscape" and have reversed the "length" and "width" because these labels are sideways. I can send the label and can see it in the print queue but all it ever says is "spooling" I'm just at a loss and would like to see if anyone has any blues clues. 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/WC20210714124134.9300D3%40jjcalibrations.com.
Re: [RBASE-L] - drag and drop pictures from outlook
Dan, I'm not sure how you accomplish this. You have rightly noted that you have the "on drop" eep that you can work with. But the initiate "on drag" doesn't really work because you attempting to grab something outside of R:Base. Perhaps Mike Byerly or Razzak knows a trick on this one. Jan From: Dan Goldberg To: "rbase-l@googlegroups.com" Date: Wed, 23 Jun 2021 20:14:22 + Subject: [RBASE-L] - drag and drop pictures from outlook So we have a customer support ticket system in Rbase. Currently I have it setup where they link files to the ticket. 1. save the attached files from outlook to desktop 2. In Rbase When they click on “link the files” they select the file(s) with the plugin and it copies it into an attachment folder with a unique name. They would like to be able to just drag the files from outlook to the rbase ticket and it will automatically do the same. I can do a “on drop” on a form button but I do not know how to have it grab the file info to copy/rename the dropped file. Anyone done this? 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/2E4830CEC16615458329D3D83342F8D0014E9245BB%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/WC20210624105809.660006%40jjcalibrations.com.
Re: [RBASE-L] - Labels
Yes. Those label defaults are there when you set up a new label. From: Rich To: rbase-l@googlegroups.com Date: Tue, 25 May 2021 14:32:05 -0400 Subject: [RBASE-L] - Labels When creating a new label is there a way to specify a certain type of label like Avery 5160? Rich Sent from my iPhone -- 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/70F171BA-2641-4132-A191-2427F06C36DE%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/WC20210525183807.970123%40jjcalibrations.com.
Re: [RBASE-L] - Loadfilenameplus with initial directory
Karen,
If I use the|INITIAL_DIR C:\Users\Jan I see my stuff.
So I believe you will need to play around with these
SET VAR p_Net_HomeDirectory TEXT = (CVAL('CURRDIR'))
SET VAR p_Net_UserID TEXT = (CVAL('NETUSER'))
SET VAR p_Net_NetGroup TEXT = (CVAL('NETGROUP'))
SET VAR p_Net_NetLocalGroup TEXT = (CVAL('NETLOCALGROUP'))
SET VAR p_Computer = (CVAL('COMPUTER'))
and probably use an &variable to build your string.
Hope this helps.
Jan
From: "'Karen Tellef' via RBASE-L"
To: "rbase-l@googlegroups.com"
Date: Thu, 29 Apr 2021 14:56:52 + (UTC)
Subject: [RBASE-L] - Loadfilenameplus with initial directory
I've never tried this before. I want to use the Loadfilenameplus plugin and
have it come up with the topmost level, which would be "My PC" when I just
bring up windows explorer on its own. That way the user can start with his
own Pictures or Documents directory, the hard drive, and all network drives.
I don't see a way of specifying that top level with the "initial_dir". Is
there a way to do that?
Here's the most basic syntax of what I'll be doing, with the root of C
showing.
PLUGINS loadfilenameplus.rbl "vFilename|fullpath on +
|TITLE Please select your Complaint JPG files +
|VIEW_MODE Details +
|FULLPATH ON +
|NO_CHANGE_DIR ON +
|INITIAL_DIR C:\ +
|FILTER JPG Files (*.jpg)#*.jpg"
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/281587267.1475894.1619708212984%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/WC20210429155359.790074%40jjcalibrations.com.
Re: [RBASE-L] - Cannot launch a JPG
Hmmm. I can do it just fine with version X. Can you try RBBE youphoto.jpg? Jan From: "'Karen Tellef' via RBASE-L" To: "rbase-l@googlegroups.com" Date: Wed, 28 Apr 2021 18:56:52 + (UTC) Subject: [RBASE-L] - Cannot launch a JPG This is strange. See attached print-screen Trying to do a Launch of a JPG and it gives me the error message about no application associated with the file extension. However, if I go into windows explorer and select the JPG it loads immediately with the preferred viewer. I can launch PDFs and TXTs, just can't launch JPGs. We're testing out a new routine, and every user who has tried it gets the same error. All users are able to go into explorer and view the file. Can anyone think of something else to try. Unfortunately the user is on Version X (not X.5, which they have purchased but waiting on a new server to install) 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/673858461.1234800.1619636212210%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/WC20210428190934.9800F2%40jjcalibrations.com.
[*** SPAM ***] Re: [RBASE-L] - Suggestions on Using AutoCHK in a Command File
Tony, I'm interested in the rollback idea! Jan From: Tony IJntema To: rbase-l@googlegroups.com Date: Thu, 22 Apr 2021 20:06:18 +0200 Subject: Re: [RBASE-L] - Suggestions on Using AutoCHK in a Command File Paul, I have implemented more or less the same procedure as Karen describes with a few differences. The differences are: On beforehand I perform some calculations like counting the number of columns in all tables and the total number of rows in the database It looks like this: SET VAR V_SYS_NUM_COLUMNS_ATL BIGINT = 0 SET VAR V_SYS_NUM_ROWS_ATL BIGINT = 0 SET VAR V_TOTAAL BIGINT = 0 -- SELECT SUM(SYS_NUM_COLUMNS) INTO V_SYS_NUM_COLUMNS_ATL INDICATOR V_IND01S FROM SYS_TABLES WHERE SYS_TABLE_TYPE = 'Table' SELECT SUM(SYS_NUM_ROWS) INTO V_SYS_NUM_ROWS_ATL INDICATOR V_IND02S FROM SYS_TABLES WHERE SYS_TABLE_TYPE = 'Table' -- SET VAR V_TOTAAL = (.V_SYS_NUM_COLUMNS_ATL + .V_SYS_NUM_ROWS_ATL) Then I perform a reload with setting error messages on. After the reload I perform the same calculations and compare the outcome with the apriori calculations If there is a difference I rollback the database. Tony Op 22-04-2021 om 15:46 schreef p...@buckleyandassoc.com: Good morning, I’m running the latest build of R:BASE X.5 Enterprise and I’m trying to incorporate the AutoCHK command to run in a scheduled task every night before doing a “Pack in Place”. Anyone have experience with this? Anyone will to share your code? Thought I’d ask that last one 😊 Thanks, Paul Buckley -- 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!AAAYAJ4mzQXf2gpHhGgkNNfb5kTCgAAAEPzkRWmLe5JOt01PLYI1e4kBAA%3D%3D%40buckleyandassoc.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/ba810e9a-4c66-3004-f1ff-15bac62592a9%40cio-bv.nl. -- 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/WC20210422181456.09008C%40jjcalibrations.com.
Re: [RBASE-L] - Date Conversion
Bill, There is a lot of helpful information located here https://www.razzak.com/fte/ Jan From: BILL MILYARD To: "rbase-l@googlegroups.com" Date: Sun, 28 Mar 2021 21:36:02 + Subject: Re: [RBASE-L] - Date Conversion Thanks Buddy. Hard to believe it's that easy. But it works! Thanks again. Bill From: rbase-l@googlegroups.com on behalf of Buddy Walker Sent: Saturday, March 27, 2021 6:56 PM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - Date Conversion Don’t use the () around the text Buddy Sent from my iPhone On Mar 27, 2021, at 5:50 PM, BILL MILYARD wrote: Razzak: Thanks for you quick response. You're going to think I've lost my mind. I explained it backwards I want to convert a text to a date. vDate is TEXT and vServiceDate is DATE set var vServiceDate = (.vDate) Sorry, Bill From: rbase-l@googlegroups.com on behalf of A. Razzak Memon Sent: Saturday, March 27, 2021 4:45 PM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - Date Conversion Bill, Here's how: SET VAR vServiceDate TEXT = NULL SET VAR vServiceDate = (CTXT(.vDate)) That's all there is to it! Very Best R:egards, Razzak At 04:30 PM 3/27/2021, bmilyard wrote: >This should be easy but for some reason I can't get it to work. I >need to convert a date variable to a text variable. In my program >I'm setting a date to a text variable as: > >set var vServiceDate = (.vDate) >vServiceDate is a TEXT type and >vDate is a DATE type > >I've tried several Conversion, Date and String functions but none >work. I know I've done it in the past but can't hit on a >solution. What am I doing wrong? >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/0LfCve-1m1WV7166q-00olZl%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/BLAPR10MB5345597A4A13CB1E5E84F514CB609%40BLAPR10MB5345.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/32DB3AF0-6E74-4320-94F9-A0808404EF94%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/BLAPR10MB5345AC960E388EC87D5F7064CB7F9%40BLAPR10MB5345.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/WC20210329105802.39000A%40jjcalibrations.com.
RE: [RBASE-L] - Date calculation
Javier, Thanks. That pointed me in the right direction. I ended up with this as a computed temp table (only part of it shown here) `CalculatedYear`= (IYR4(OrderDate)) INTEGER, + `CalculatedMonth`= (IMON(OrderDate)) INTEGER, + `CalculatedWeek`= (IWOY(OrderDate)) INTEGER, + `CalculatedWeekStart`= ((DWE(OrderDate))-5) DATE, + `CalculatedWeekEnd`= ((DWE(OrderDate))-1) DATE, + `TrimmedWeek`= ((SGET((CTXT(CalculatedWeekStart)),5,1))+' - '+(SGET((CTXT(CalculatedWeekEnd)),5,1))) TEXT (20), + `CalculatedMonthName`= (TMON(OrderDate)) TEXT, + Jan From: To: Date: Wed, 24 Mar 2021 11:39:13 -0500 Subject: RE: [RBASE-L] - Date calculation Lots of ways to do this depending on your preference. The following function return the first weekend date for whatever DATE you enter: SET VAR vToday DATE = (DWE(.#DATE)) Now you have the next Saturday’s date, so you just need to subtract 5 days for the previous Monday and 1 for the previous Friday. set var vStart DATE = (ADDDAY(.vToday, -5)) set var vEnd DATE = (ADDDAY(.vToday, -1)) And you will have the beginning and end dates for the week and you can easily format them. You can probably combine the commands into one long command, but it would be more difficult to read in the future. You can also use the function IDWk which will tell which day of the week for any date. Then you can use a simple CASE construct to add or subtract days accordingly. I can think of other ways but the ones I mentioned are simple and easy to understand. Hopefully, this is what you were looking for. Javier, Javier Valencia, PE javier.valen...@vtgonline.com O: 913-829-0888 C: 913-915-3137 From: rbase-l@googlegroups.com On Behalf Of jan johansen Sent: Wednesday, March 24, 2021 6:59 AM To: rbase-l@googlegroups.com Subject: RE: [RBASE-L] - Date calculation Thanks all, Pointed me in the right direction. However, now I have another challenge that so far eludes me. So I know that using (IWOY(.#DATE)) today will 13. But I'm really trying to find out what the Monday and Friday of Week 13 are so I can display something like "Week of 3/21 - 3/26". Any suggestions appreciated. Jan From: Troy Sosamon To: "rbase-l@googlegroups.com" Date: Tue, 16 Mar 2021 15:33:04 + Subject: RE: [RBASE-L] - Date calculation Jan, Historically I have found building a table full of business days works best, so that you can take into account holidays and special days off/snow days Along with a business day flag y/n Put one row in for each business day for the year using a simple loop and Idwk function and a Y flag and then go flip the flag on the holidays and any other special days when you don’t operate. Then you can just count the number of rows between any two dates where the flag = 'Y'. I actually had an app with 2 flags because the company was a car auction so actual business days for sellers and buyers were not always the same so there was a flag for each because sometimes it might not be a business day for the sellers if you cant go pickup cars because of a snowstorm, but are open for buyers who can make in to the location to pay their bills. This data was used for calculating buyer storage and seller pickup SLA reports. Just depends on your application and what you need to accomplish with it. Troy -Original Message- From: rbase-l@googlegroups.com On Behalf Of A. Razzak Memon Sent: Tuesday, March 16, 2021 5:25 AM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - Date calculation Jan, Here's how ... Use the IDWK function to exclude the 6th and 7th (Saturday and Sunday) day of the Week. -- IDWK returns the day of the week where Monday is 1. -- Example 01 SELECT * FROM tablename WHERE (IDWK(datecolumn)) NOT IN (6,7) -- Example 02 SELECT * FROM tablename WHERE (IDWK(datetimecolumn)) NOT IN (6,7) That's all there is to it! Have fun. Very Best R:egards, Razzak At 07:15 AM 3/16/2021, jan johansen wrote: >Group, > >Anyone got a good date algorithm that ignores weekends? Or in other >words, only counts workdays? > >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/0Lm2Pn-1lvSWt3yqH-00Zixe%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 th
RE: [RBASE-L] - Date calculation
Thanks all, Pointed me in the right direction. However, now I have another challenge that so far eludes me. So I know that using (IWOY(.#DATE)) today will 13. But I'm really trying to find out what the Monday and Friday of Week 13 are so I can display something like "Week of 3/21 - 3/26". Any suggestions appreciated. Jan From: Troy Sosamon To: "rbase-l@googlegroups.com" Date: Tue, 16 Mar 2021 15:33:04 + Subject: RE: [RBASE-L] - Date calculation Jan, Historically I have found building a table full of business days works best, so that you can take into account holidays and special days off/snow days Along with a business day flag y/n Put one row in for each business day for the year using a simple loop and Idwk function and a Y flag and then go flip the flag on the holidays and any other special days when you don’t operate. Then you can just count the number of rows between any two dates where the flag = 'Y'. I actually had an app with 2 flags because the company was a car auction so actual business days for sellers and buyers were not always the same so there was a flag for each because sometimes it might not be a business day for the sellers if you cant go pickup cars because of a snowstorm, but are open for buyers who can make in to the location to pay their bills. This data was used for calculating buyer storage and seller pickup SLA reports. Just depends on your application and what you need to accomplish with it. Troy -Original Message- From: rbase-l@googlegroups.com On Behalf Of A. Razzak Memon Sent: Tuesday, March 16, 2021 5:25 AM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - Date calculation Jan, Here's how ... Use the IDWK function to exclude the 6th and 7th (Saturday and Sunday) day of the Week. -- IDWK returns the day of the week where Monday is 1. -- Example 01 SELECT * FROM tablename WHERE (IDWK(datecolumn)) NOT IN (6,7) -- Example 02 SELECT * FROM tablename WHERE (IDWK(datetimecolumn)) NOT IN (6,7) That's all there is to it! Have fun. Very Best R:egards, Razzak At 07:15 AM 3/16/2021, jan johansen wrote: >Group, > >Anyone got a good date algorithm that ignores weekends? Or in other >words, only counts workdays? > >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/0Lm2Pn-1lvSWt3yqH-00Zixe%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/CH2PR06MB67435C0EED5561DE3F4BB1FD9C6B9%40CH2PR06MB6743.namprd06.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/WC20210324115914.830183%40jjcalibrations.com.
Re: [RBASE-L] - Date calculation
Razzak, Thanks! You're up early. I know, I know... the sun never sets on R:Base! Jan From: "A. Razzak Memon" To: rbase-l@googlegroups.com Date: Tue, 16 Mar 2021 07:25:26 -0400 Subject: Re: [RBASE-L] - Date calculation Jan, Here's how ... Use the IDWK function to exclude the 6th and 7th (Saturday and Sunday) day of the Week. -- IDWK returns the day of the week where Monday is 1. -- Example 01 SELECT * FROM tablename WHERE (IDWK(datecolumn)) NOT IN (6,7) -- Example 02 SELECT * FROM tablename WHERE (IDWK(datetimecolumn)) NOT IN (6,7) That's all there is to it! Have fun. Very Best R:egards, Razzak At 07:15 AM 3/16/2021, jan johansen wrote: >Group, > >Anyone got a good date algorithm that ignores weekends? Or in other >words, only counts workdays? > >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/0Lm2Pn-1lvSWt3yqH-00Zixe%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/WC20210316114033.39000A%40jjcalibrations.com.
[RBASE-L] - Date calculation
Group, Anyone got a good date algorithm that ignores weekends? Or in other words, only counts workdays? 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/WC20210316111516.710007%40jjcalibrations.com.
Re: [RBASE-L] - Importing XML data into R:BASE
Mike, I'm going out on a limb here. I'm not sure there is a standardized XML format so you kind of have to look at the data presented and see what you can do with it. In the past, I've run a cursor through some pretty weird data as an input routine. Good luck, Jan From: mike.rams...@aksteel.com To: rbase-l@googlegroups.com Date: Wed, 24 Feb 2021 10:12:50 -0500 Subject: [RBASE-L] - Importing XML data into R:BASE Greetings: I am tasked with importing a large amount of data in the XML format into R:BASE. I haven't worked with the XML format much yet. I would appreciate any suggestions on good learning resources that anyone in R:BASE World has used to enhance their XML skills. Thank you in advance. Have a safe and healthy day! Mike Ramsour AK Steel Coshocton Works Quality Department Phone: 740-829-4340 Cell: 740-502-1659 Confidentiality Notice This message is intended exclusively for the individual or entity to which it is addressed and may contain privileged, proprietary, or otherwise private information. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. -- 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/OF2087463D.4801D557-ON85258686.0052E6A4-85258686.005392CB%40aksteel.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/WC20210225160758.670060%40jjcalibrations.com.
Re: [RBASE-L] - Choose command with headers
Karen, I guess I would have just done a quick form using a VariableListView. Jan From: "'Karen Tellef' via RBASE-L" To: "rbase-l@googlegroups.com" Date: Tue, 23 Feb 2021 15:06:52 + (UTC) Subject: [RBASE-L] - Choose command with headers I played around with being able to put HEADERS above the columns in a CHOOSE command. I think every programmer has wanted that since the "beginning of time"! I started out with RBTI's example code that runs against ConComp and it works great to display 2 columns of data. What I tried to do was add a third column to their example (the sys_table_type in the command below). It took quite a while, but my conclusions are: 1. You must have Vertical Lines ON. I am unable to get it to work without having vertical lines on. 2. I then fiddled with the Vertical Line Breaks line until the headers lined up perfect with the vertical lines. No rhyme or reason, I just plugged in random numbers til it worked. 3. Then I played with the Text Breaks line until the data all lined up perfectly. Has anyone used this? Am I correct in that you must have Vertical Lines ON? And I'm guessing there's no shortcut to guessing on the 2 list of numbers since pixels would depend on your font size, etc. I'll attach a picture of my choose command with the 3rd column added. Code below. CHOOSE vTableViewName FROM #VALUES FOR + ((LJS(SYS_TABLE_NAME,35))&LJS(SYS_COMMENT,75) & ljs(sys_table_type,10)),SYS_TABLE_NAME FROM SYS_TABLES + WHERE SYS_TABLE_TYPE <> 'SYSTEM TABLE' ORDER BY SYS_TABLE_NAME ASC + CHKBOX 1 TITLE 'Select Table/View' + CAPTION 'Tables' LINES 26 FORMATTED + OPTION TITLE_BACK_COLOR WHITE + |TITLE_FONT_NAME Segoe UI + |TITLE_FONT_SIZE 16 + |TITLE_FONT_COLOR BLACK + |TITLE_BOLD ON + |LIST_BACK_COLOR WHITE + |LIST_FONT_NAME Tahoma + |LIST_FONT_SIZE 9 + |LIST_FONT_COLOR NAVY + |WINDOW_BACK_COLOR WHITE + |BUTTON_OK_CAPTION &Continue + |BUTTON_CANCEL_CAPTION C&ancel + |BUTTONS_SHOW_GLYPH ON + |LINE_COLOR black + |ZEBRA_STRIPES ON + |ZEBRA_ODD_COLOR 3DLIGHT + |ZEBRA_EVEN_COLOR WINDOW + |HORIZONTAL_LINES ON + |VERTICAL_LINES ON + |VERTICAL_LINE_BREAKS 150,450 + |TEXT_BREAKS 36,112 + |HEADERS Table Name,Description,Type 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/660651785.1231586.1614092812858%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/WC20210223163636.1100F7%40jjcalibrations.com.
Re: [RBASE-L] - Help - first time sending report via email
Patti, Don't give up. Jim has offered me some suggestions to look for. He has it working. I just need to clear my slate a little. From: "'Patti Jakusz' via RBASE-L" To: "rbase-l@googlegroups.com" Date: Wed, 3 Feb 2021 01:20:07 + (UTC) Subject: Re: [RBASE-L] - Help - first time sending report via email Just last week, our system admin installed X5E on all the computers. (By now, I forgot how to convert the databases.) I'm not sure we are going to buy Rmail because I am turning in my notice next year and we have to get them a new database, probably something other Healthy Start sites are using, though they are terrible, I'm starting a different thread with a new question, printing to a URL on OneDrive. Patti On Friday, January 29, 2021, 10:44:04 PM EST, 'Jim Belisle' via RBASE-L wrote: We have office 365 and use RMAIL. It took a little trial and error but we got it to work. We use version X5E. James Belisle Making Information Systems People Friendly Since 1990 From: 'Karen Tellef' via RBASE-L Sent: Friday, January 29, 2021 10:54 AM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - Help - first time sending report via email CAUTION:This is an EXTERNAL EMAIL, STOP! and think before clicking on any links or opening attachments. I looked in my notes document, and I saved this from 2016: Claudine reports in 2016 that the print/email on does not work with email from Office365. Per Razzak, it won’t work because you cannot specify the port within the print, only by setting up Rmail. One of the Office365 email requirements for integration with third-party applications, in this case R:BASE, is Transport Layer Security (TLS) and Secure Sockets Layer (SSL) support, specifically with port 587. The option to specify TLS/SSL email security protocol is not available in the R:BASE PRINT command at this time, and is only available within R:Mail. Karen -Original Message- From: 'Patti Jakusz' via RBASE-L To: rbase-l@googlegroups.com Sent: Fri, Jan 29, 2021 10:42 am Subject: Re: [RBASE-L] - Help - first time sending report via email Hi Karen, Dan sent me this list also, but he had Authentication on. I tried it your way, with "Off". Still didn't work. IT doesn't even go all the way thru to give me the dialog box. Jan said it might be a problem with office365. I will see if our tech guy can help with that. Patti On Friday, January 29, 2021, 11:14:09 AM EST, 'Karen Tellef' via RBASE-L wrote: Don't know if this will help, but here's an example of what I use. I am passing in a bunch of variables (email host info is looked up). BTW you don't have to repeat the filename as an "attachment" PRINT invemail WHERE billto = .vblto + OPTION PDF | FILENAME &vfilename + |EMAIL ON + |EMAIL_AUTHENTICATION OFF + |EMAIL_HOST &gEmailHost + |EMAIL_PORT 25 + |EMAIL_USERID &gEmailUser + |EMAIL_PASSWORD &gEmailPass + |EMAIL_TO_LIST &vtoadd + |EMAIL_FROM_ADDRESS &vfrom + |EMAIL_SUBJECT &vsubject + |EMAIL_BODY &vames + |EMAIL_DELETE_AFTER_SEND ON + |EMAIL_SHOW_DIALOG OFF Karen -Original Message- From: 'Patti Jakusz' via RBASE-L To: rbase-l@googlegroups.com ; RBASE-L Sent: Fri, Jan 29, 2021 9:53 am Subject: [RBASE-L] - Help - first time sending report via email Hello Everyone, For the first time, I'm trying to have our database send reports as email attachments. I set up our email account and can send and receive messages. I set up our server info in Rbase Report Settings. Tested and works ok. (see snip attached) I have a command file that prints the report and is supposed to send it to the email address, but it doesn't. I get a dialog box so I think the command file worked far enough along to get to the end. But I don't get any error message and I don't get an email - not in the inbox of one address or the sent box of the other address. I don't know how to troubleshoot. I attached my command file below. Can anyone help? PRINT NurseRfrlOutcome whe Casenum='30109' and IDO13bor=1 + OPTION PDF|FILENAME L:\Letter\pj30109.PDF + |EMAIL ON + |EMAIL_TO_LIST pjak...@baltimorehealthystart.org + |EMAIL_FROM_ADDRESS rbaset...@baltimorehealthystart.org + |EMAIL_SUBJECT referral for nurse + |EMAIL_BODY Attached is the invoice - sent via R:BASE. Because we Can! + |EMAIL_ATTACHMENTS L:\Letter\pj30109.PDF + |EMAIL_DELETE_AFTER_SEND OFF + |EMAIL_SHOW_DIALOG ON -- 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/2123626015.163953.1611935622005%40mail.yahoo.com. -- For group guidelines
Re: [RBASE-L] - Help - first time sending report via email
OK. Maybe Dan knows the trick because I couldn't authenticate with RMail either. From: "'Karen Tellef' via RBASE-L" To: "rbase-l@googlegroups.com" Date: Fri, 29 Jan 2021 16:59:39 + (UTC) Subject: Re: [RBASE-L] - Help - first time sending report via email You're welcome. And to answer your other question, yes RMail is an RBase product that you would purchase and install separately. I use both -- RMail and the simple Print...Email ON. If you're lucky, you can install RMail yourself as long as you know the username/password/port to use. If it doesn't work there's a couple other options that your IT guy might have to help you with. Karen -Original Message- From: 'Patti Jakusz' via RBASE-L To: rbase-l@googlegroups.com Sent: Fri, Jan 29, 2021 10:55 am Subject: Re: [RBASE-L] - Help - first time sending report via email Thank you! Passing this along. Patti On Friday, January 29, 2021, 11:53:59 AM EST, 'Karen Tellef' via RBASE-L wrote: I looked in my notes document, and I saved this from 2016: Claudine reports in 2016 that the print/email on does not work with email from Office365. Per Razzak, it won’t work because you cannot specify the port within the print, only by setting up Rmail. One of the Office365 email requirements for integration with third-party applications, in this case R:BASE, is Transport Layer Security (TLS) and Secure Sockets Layer (SSL) support, specifically with port 587. The option to specify TLS/SSL email security protocol is not available in the R:BASE PRINT command at this time, and is only available within R:Mail. Karen -Original Message- From: 'Patti Jakusz' via RBASE-L To: rbase-l@googlegroups.com Sent: Fri, Jan 29, 2021 10:42 am Subject: Re: [RBASE-L] - Help - first time sending report via email Hi Karen, Dan sent me this list also, but he had Authentication on. I tried it your way, with "Off". Still didn't work. IT doesn't even go all the way thru to give me the dialog box. Jan said it might be a problem with office365. I will see if our tech guy can help with that. Patti On Friday, January 29, 2021, 11:14:09 AM EST, 'Karen Tellef' via RBASE-L wrote: Don't know if this will help, but here's an example of what I use. I am passing in a bunch of variables (email host info is looked up). BTW you don't have to repeat the filename as an "attachment" PRINT invemail WHERE billto = .vblto + OPTION PDF | FILENAME &vfilename + |EMAIL ON + |EMAIL_AUTHENTICATION OFF + |EMAIL_HOST &gEmailHost + |EMAIL_PORT 25 + |EMAIL_USERID &gEmailUser + |EMAIL_PASSWORD &gEmailPass + |EMAIL_TO_LIST &vtoadd + |EMAIL_FROM_ADDRESS &vfrom + |EMAIL_SUBJECT &vsubject + |EMAIL_BODY &vames + |EMAIL_DELETE_AFTER_SEND ON + |EMAIL_SHOW_DIALOG OFF Karen -Original Message- From: 'Patti Jakusz' via RBASE-L To: rbase-l@googlegroups.com ; RBASE-L Sent: Fri, Jan 29, 2021 9:53 am Subject: [RBASE-L] - Help - first time sending report via email Hello Everyone, For the first time, I'm trying to have our database send reports as email attachments. I set up our email account and can send and receive messages. I set up our server info in Rbase Report Settings. Tested and works ok. (see snip attached) I have a command file that prints the report and is supposed to send it to the email address, but it doesn't. I get a dialog box so I think the command file worked far enough along to get to the end. But I don't get any error message and I don't get an email - not in the inbox of one address or the sent box of the other address. I don't know how to troubleshoot. I attached my command file below. Can anyone help? PRINT NurseRfrlOutcome whe Casenum='30109' and IDO13bor=1 + OPTION PDF|FILENAME L:\Letter\pj30109.PDF + |EMAIL ON + |EMAIL_TO_LIST pjak...@baltimorehealthystart.org + |EMAIL_FROM_ADDRESS rbaset...@baltimorehealthystart.org + |EMAIL_SUBJECT referral for nurse + |EMAIL_BODY Attached is the invoice - sent via R:BASE. Because we Can! + |EMAIL_ATTACHMENTS L:\Letter\pj30109.PDF + |EMAIL_DELETE_AFTER_SEND OFF + |EMAIL_SHOW_DIALOG ON -- 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/2123626015.163953.1611935622005%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/12
Re: [RBASE-L] - Help - first time sending report via email
Patti, Let us know what your tech guy gives for suggestions. I could not get eMail option to work with smtp.office365.com due to Office365 moving to two-factor authorization late last year. I've read some things on how to dumb 365 down but I couldn't get it to work. Jan From: "'Patti Jakusz' via RBASE-L" To: 'Patti Jakusz' via RBASE-L Date: Fri, 29 Jan 2021 16:19:57 + (UTC) Subject: Re: [RBASE-L] - Help - first time sending report via email Yes, we are using office365. Damn. But I am logging into it manually without a problem. I will ask our tech guy. Patti On Friday, January 29, 2021, 11:04:13 AM EST, jan johansen wrote: What are you using for your email? Is it Office365? If so, you may be battling a two-factor authorization issue. From: "'Patti Jakusz' via RBASE-L" To: "rbase-l@googlegroups.com" , RBASE-L Date: Fri, 29 Jan 2021 15:53:41 + (UTC) Subject: [RBASE-L] - Help - first time sending report via email Hello Everyone, For the first time, I'm trying to have our database send reports as email attachments. I set up our email account and can send and receive messages. I set up our server info in Rbase Report Settings. Tested and works ok. (see snip attached) I have a command file that prints the report and is supposed to send it to the email address, but it doesn't. I get a dialog box so I think the command file worked far enough along to get to the end. But I don't get any error message and I don't get an email - not in the inbox of one address or the sent box of the other address. I don't know how to troubleshoot. I attached my command file below. Can anyone help? PRINT NurseRfrlOutcome whe Casenum='30109' and IDO13bor=1 + OPTION PDF|FILENAME L:\Letter\pj30109.PDF + |EMAIL ON + |EMAIL_TO_LIST pjak...@baltimorehealthystart.org + |EMAIL_FROM_ADDRESS rbaset...@baltimorehealthystart.org + |EMAIL_SUBJECT referral for nurse + |EMAIL_BODY Attached is the invoice - sent via R:BASE. Because we Can! + |EMAIL_ATTACHMENTS L:\Letter\pj30109.PDF + |EMAIL_DELETE_AFTER_SEND OFF + |EMAIL_SHOW_DIALOG ON -- 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/2123626015.163953.1611935622005%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/WC20210129160408.610023%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/1665332571.176907.1611937197693%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/WC20210129162631.680026%40jjcalibrations.com.
Re: [RBASE-L] - Help - first time sending report via email
What are you using for your email? Is it Office365? If so, you may be battling a two-factor authorization issue. From: "'Patti Jakusz' via RBASE-L" To: "rbase-l@googlegroups.com" , RBASE-L Date: Fri, 29 Jan 2021 15:53:41 + (UTC) Subject: [RBASE-L] - Help - first time sending report via email Hello Everyone, For the first time, I'm trying to have our database send reports as email attachments. I set up our email account and can send and receive messages. I set up our server info in Rbase Report Settings. Tested and works ok. (see snip attached) I have a command file that prints the report and is supposed to send it to the email address, but it doesn't. I get a dialog box so I think the command file worked far enough along to get to the end. But I don't get any error message and I don't get an email - not in the inbox of one address or the sent box of the other address. I don't know how to troubleshoot. I attached my command file below. Can anyone help? PRINT NurseRfrlOutcome whe Casenum='30109' and IDO13bor=1 + OPTION PDF|FILENAME L:\Letter\pj30109.PDF + |EMAIL ON + |EMAIL_TO_LIST pjak...@baltimorehealthystart.org + |EMAIL_FROM_ADDRESS rbaset...@baltimorehealthystart.org + |EMAIL_SUBJECT referral for nurse + |EMAIL_BODY Attached is the invoice - sent via R:BASE. Because we Can! + |EMAIL_ATTACHMENTS L:\Letter\pj30109.PDF + |EMAIL_DELETE_AFTER_SEND OFF + |EMAIL_SHOW_DIALOG ON -- 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/2123626015.163953.1611935622005%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/WC20210129160408.610023%40jjcalibrations.com.
RE: [RBASE-L] - enhanced tab control
Is your 'PROPERTY' code in the 'tab change eep'? From: "'Jim Belisle' via RBASE-L" To: "rbase-l@googlegroups.com" Date: Mon, 18 Jan 2021 14:13:38 + Subject: RE: [RBASE-L] - enhanced tab control No. Using the actual table. My ultimate goal is to either do a drag and drop from another control that is on the same tab. Or I may use a varlistview for the other table and do a click to bring rows over to the DBGrid table. I am trying to associate each tab (I will end up with 10 or so tabs) to a diff. number. Then using the drag and drop or click, bring rows over from another table side by side. James Belisle Making Information Systems People Friendly Since 1990 From: rbase-l@googlegroups.com On Behalf Of jan johansen Sent: Monday, January 18, 2021 8:08 AM To: 'Jim Belisle' via RBASE-L Subject: RE: [RBASE-L] - enhanced tab control Jim, Are you using a temp table to display the data in the db-grid? If so, why not just drop the table, and reload it with only the rows you need. Jan From: "'Jim Belisle' via RBASE-L" To: "rbase-l@googlegroups.com" Date: Mon, 18 Jan 2021 13:42:36 + Subject: RE: [RBASE-L] - enhanced tab control Thanks, Jan. I was able to capture the TAB caption just fine. Now for the next step. The tab has an enhanced DBGrid control. I want to filter the information of the DBgrid based upon the caption. On tab change here is the code. (this is successful) GETPROPERTY comp_tab501 CAPTION 'vtabcap' The code below does not change the DBgrid to show JUST the 501 info. PROPERTY comp_501 'FILTERS->COLUMN_NAME->empid' .vtabcap PROPERTY TABLE scheduling 'REFRESH' RETURN I have tried the code using an & in front of the var, without the single quotes on the FILTER section, etc. Nothing changes what the user will see. I want just the 501 info to show. I even tried closing the table then opening it. No change. PROPERTY TABLE scheduling 'CLOSE' PROPERTY TABLE scheduling 'OPEN' James Belisle Making Information Systems People Friendly Since 1990 From: rbase-l@googlegroups.com On Behalf Of jan johansen Sent: Monday, January 18, 2021 7:30 AM To: 'Jim Belisle' via RBASE-L Subject: Re: [RBASE-L] - enhanced tab control CAUTION:This is an EXTERNAL EMAIL, STOP! and think before clicking on any links or opening attachments. Jim, This might be a little hard to explain. You need to assign a componentid to the overall control, which is the EnhancedTab control. Then you need to assign componentid's to the individual tabs in the EnhancedTab control. I think should point you in the right direction. Jan From: "'Jim Belisle' via RBASE-L" To: "rbase-l@googlegroups.com" Date: Mon, 18 Jan 2021 12:42:18 + Subject: [RBASE-L] - enhanced tab control I am using the enhanced tab control for the first time. I want to use the var links editor to capture the tabs caption value. It is also the first time for me to use the links editor. The value of vtabcap is not changing and I get an error saying the var has not been defined. So my questions are: Am I using the links editor properly? Is there a way to capture the caption of the tab using the GETPROPERTY commands? I do not see anything in RDOCS. 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/CH2PR02MB6821371F2A19F0358DCDA156A0A40%40CH2PR02MB6821.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/CH2PR02MB68218714920F69806D56923BA0A40%40CH2PR02MB6821.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/CH2PR02MB6821A0FD2469A50C14974BC6A0A40%40
RE: [RBASE-L] - enhanced tab control
Jim, Are you using a temp table to display the data in the db-grid? If so, why not just drop the table, and reload it with only the rows you need. Jan From: "'Jim Belisle' via RBASE-L" To: "rbase-l@googlegroups.com" Date: Mon, 18 Jan 2021 13:42:36 + Subject: RE: [RBASE-L] - enhanced tab control Thanks, Jan. I was able to capture the TAB caption just fine. Now for the next step. The tab has an enhanced DBGrid control. I want to filter the information of the DBgrid based upon the caption. On tab change here is the code. (this is successful) GETPROPERTY comp_tab501 CAPTION 'vtabcap' The code below does not change the DBgrid to show JUST the 501 info. PROPERTY comp_501 'FILTERS->COLUMN_NAME->empid' .vtabcap PROPERTY TABLE scheduling 'REFRESH' RETURN I have tried the code using an & in front of the var, without the single quotes on the FILTER section, etc. Nothing changes what the user will see. I want just the 501 info to show. I even tried closing the table then opening it. No change. PROPERTY TABLE scheduling 'CLOSE' PROPERTY TABLE scheduling 'OPEN' James Belisle Making Information Systems People Friendly Since 1990 From: rbase-l@googlegroups.com On Behalf Of jan johansen Sent: Monday, January 18, 2021 7:30 AM To: 'Jim Belisle' via RBASE-L Subject: Re: [RBASE-L] - enhanced tab control CAUTION:This is an EXTERNAL EMAIL, STOP! and think before clicking on any links or opening attachments. Jim, This might be a little hard to explain. You need to assign a componentid to the overall control, which is the EnhancedTab control. Then you need to assign componentid's to the individual tabs in the EnhancedTab control. I think should point you in the right direction. Jan From: "'Jim Belisle' via RBASE-L" To: "rbase-l@googlegroups.com" Date: Mon, 18 Jan 2021 12:42:18 + Subject: [RBASE-L] - enhanced tab control I am using the enhanced tab control for the first time. I want to use the var links editor to capture the tabs caption value. It is also the first time for me to use the links editor. The value of vtabcap is not changing and I get an error saying the var has not been defined. So my questions are: Am I using the links editor properly? Is there a way to capture the caption of the tab using the GETPROPERTY commands? I do not see anything in RDOCS. 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/CH2PR02MB6821371F2A19F0358DCDA156A0A40%40CH2PR02MB6821.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/CH2PR02MB68218714920F69806D56923BA0A40%40CH2PR02MB6821.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/WC20210118140736.220014%40jjcalibrations.com.
Re: [RBASE-L] - enhanced tab control
Jim, This might be a little hard to explain. You need to assign a componentid to the overall control, which is the EnhancedTab control. Then you need to assign componentid's to the individual tabs in the EnhancedTab control. I think should point you in the right direction. Jan From: "'Jim Belisle' via RBASE-L" To: "rbase-l@googlegroups.com" Date: Mon, 18 Jan 2021 12:42:18 + Subject: [RBASE-L] - enhanced tab control I am using the enhanced tab control for the first time. I want to use the var links editor to capture the tabs caption value. It is also the first time for me to use the links editor. The value of vtabcap is not changing and I get an error saying the var has not been defined. So my questions are: Am I using the links editor properly? Is there a way to capture the caption of the tab using the GETPROPERTY commands? I do not see anything in RDOCS. 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/CH2PR02MB6821371F2A19F0358DCDA156A0A40%40CH2PR02MB6821.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/WC20210118132946.39000E%40jjcalibrations.com.
Re: [RBASE-L] - dbgrid not showing all rows
James, I'm not going to say this correctly. If you have have 2 rows with a duplicated column, no rows show. Does that make sense? Jan From: "'Jim Belisle' via RBASE-L" To: "rbase-l@googlegroups.com" Date: Thu, 7 Jan 2021 18:32:24 + Subject: [RBASE-L] - dbgrid not showing all rows I am sure I am missing something simple but here is the problem. I am adding a DB grid to a form based upon a temp table. When the grid is visible with a property command all that shows are the first two rows. When I look at the temp table, all rows are there. 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/CY4PR0201MB33943600F72AB712B77B49ECA0AF0%40CY4PR0201MB3394.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/WC20210107183846.14002A%40jjcalibrations.com.
RE: [RBASE-L] - autonum when creating
Jim, Yes. The AUTONUM is issued after the table is created and before you insert data. Jan From: "'Jim Belisle' via RBASE-L" To: "rbase-l@googlegroups.com" Date: Thu, 24 Dec 2020 13:51:03 + Subject: RE: [RBASE-L] - autonum when creating Tony, So after you create the table but before adding rows you use the code you mentioned instead of the alter table command? I saw the syntax you mentioned but was not sure if I used the alter command. James Belisle Making Information Systems People Friendly Since 1990 From: rbase-l@googlegroups.com On Behalf Of Tony IJntema Sent: Thursday, December 24, 2020 7:41 AM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - autonum when creating CAUTION:This is an EXTERNAL EMAIL, STOP! and think before clicking on any links or opening attachments. AUTONUM IN USINGNUM Tony Op 24-12-2020 om 14:27 schreef 'Jim Belisle' via RBASE-L: What is the proper syntax for creating a column within a temp table as an auto numbered column? 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/CY4PR0201MB3394F36E4750A622B0545B5FA0DD0%40CY4PR0201MB3394.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/CY4PR0201MB339466EAC7B6E384E173574DA0DD0%40CY4PR0201MB3394.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/WC20201224140237.72000E%40jjcalibrations.com.
RE: [RBASE-L] - Query
Duh, Thanks Jim. Merry Christmas! Jan From: "'Jim Belisle' via RBASE-L" To: "rbase-l@googlegroups.com" Date: Wed, 23 Dec 2020 17:35:11 + Subject: RE: [RBASE-L] - Query BROWSE table1 WHERE common col info NOT IN (SELECT common col info FROM table2) James Belisle Making Information Systems People Friendly Since 1990 From: rbase-l@googlegroups.com On Behalf Of jan johansen Sent: Wednesday, December 23, 2020 11:33 AM To: rbase-l@googlegroups.com Subject: [RBASE-L] - Query CAUTION:This is an EXTERNAL EMAIL, STOP! and think before clicking on any links or opening attachments. Group, Situation. Table 1 and Table 2 are related via a common column. I want to view items in Table 1 that doesn't have any data in Table 2. This should be simple but the syntax escapes me right now. 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/CY4PR0201MB3394F53004A650C67DE5AD62A0DE0%40CY4PR0201MB3394.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/WC20201223174405.9300C4%40jjcalibrations.com.
[RBASE-L] - Query
Group, Situation. Table 1 and Table 2 are related via a common column. I want to view items in Table 1 that doesn't have any data in Table 2. This should be simple but the syntax escapes me right now. 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/WC20201223173232.8200C3%40jjcalibrations.com.
Re: [RBASE-L] - drag and drop
Jim, What Buddy said. You can drag and drop between tables. It requires some forethought and experimentation to make it work. I have done it so I know it works. Jan From: Buddy Walker To: rbase-l@googlegroups.com Date: Wed, 23 Dec 2020 10:52:18 -0500 Subject: Re: [RBASE-L] - drag and drop Jim The the way I look at is you have drag and drop EEPs. When you grab (drag) write your rep for that for example delete row from a specific table the when you drop code to add to a table. Buddy Sent from my iPhone On Dec 23, 2020, at 10:21 AM, 'Jim Belisle' via RBASE-L wrote: I have a couple of questions about drag and drop. I have never used this feature. Can you drag and drop between tables if both tables are associated on the same form? Or can you only drag within one table? I have read the instructions on Drag and Drop but do not understand what code I would use in each part, On start drag, on drag drop. 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/CY4PR0201MB3394F03F2DD0F9187B34B574A0DE0%40CY4PR0201MB3394.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/04441C55-3ADE-46A3-9B2F-02945219DE8F%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/WC20201223173047.6200C2%40jjcalibrations.com.
RE: [RBASE-L] - Search the archive
Perfect! Thank you. From: Dan Goldberg To: "rbase-l@googlegroups.com" Date: Tue, 8 Dec 2020 14:40:58 + Subject: RE: [RBASE-L] - Search the archive https://groups.google.com/u/1/g/rbase-l You will need to be logged into google. Dan Goldberg From: rbase-l@googlegroups.com On Behalf Of jan johansen Sent: Tuesday, December 8, 2020 4:31 AM To: rbase-l@googlegroups.com Subject: [RBASE-L] - Search the archive All, I need to search the Rbase list archive. Where is it located? 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/WC20201208123111.5100D9%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/2E4830CEC16615458329D3D83342F8D0014E6A8085%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/WC20201208145122.3500FD%40jjcalibrations.com.
[RBASE-L] - Search the archive
All, I need to search the Rbase list archive. Where is it located? 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/WC20201208123111.5100D9%40jjcalibrations.com.
Re: [RBASE-L] - Date function
Duh! I need another cup of coffee! Thanks Razzak From: "A. Razzak Memon" To: rbase-l@googlegroups.com Date: Thu, 03 Dec 2020 12:21:17 -0500 Subject: Re: [RBASE-L] - Date function Jan, Here's how ... UPDATE tablename SET datecolum = (ADDYR(datecolumn,-100)) That's all there is to it! Have fun! Razzak At 12:18 PM 12/3/2020, jan johansen wrote: >All, > >Had a case where some dates blew up. >Basically the year is 100 years in the future. But not all of them. >So how do I subtract 100 years? > >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/0Lu7BQ-1k4lGi3fks-011Uxw%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/WC20201203173206.020002%40jjcalibrations.com.
[RBASE-L] - Date function
All, Had a case where some dates blew up. Basically the year is 100 years in the future. But not all of them. So how do I subtract 100 years? 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/WC20201203171836.10004D%40jjcalibrations.com.
[RBASE-L] - Filemaker import
Hey all, Has anyone tried to do a FileMaker Pro import? 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/WC20201116202314.360091%40jjcalibrations.com.
RE: [RBASE-L] - navigation in variable lookup list view
Oh, so you're wanting navigation buttons to move up and down? Sure I've done that. From: Dan Goldberg To: "rbase-l@googlegroups.com" Date: Tue, 13 Oct 2020 22:04:06 + Subject: RE: [RBASE-L] - navigation in variable lookup list view A lookup variable list view is not tied to the forms table so the normal navigation buttons do not work. Dan Goldberg From: rbase-l@googlegroups.com On Behalf Of jan johansen Sent: Tuesday, October 13, 2020 3:02 PM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - navigation in variable lookup list view Dan, I'm not sure I'm following. I've used bit buttons to move rows up or down in variable list views as well as used drag and drop to move rows around. But you're talking in the listview itself? Jan From: Dan Goldberg To: "rbase-l@googlegroups.com" Date: Tue, 13 Oct 2020 20:14:41 + Subject: [RBASE-L] - navigation in variable lookup list view I want to put buttons to navigate up and down rows in a variable lookup list view. I checked the properties and so not seen one. Has anybody done this? 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/2E4830CEC16615458329D3D83342F8D0014E628ABC%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/WC20201013220153.42002B%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/2E4830CEC16615458329D3D83342F8D0014E628D0E%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/WC20201013221218.56002C%40jjcalibrations.com.
Re: [RBASE-L] - navigation in variable lookup list view
Dan, I'm not sure I'm following. I've used bit buttons to move rows up or down in variable list views as well as used drag and drop to move rows around. But you're talking in the listview itself? Jan From: Dan Goldberg To: "rbase-l@googlegroups.com" Date: Tue, 13 Oct 2020 20:14:41 + Subject: [RBASE-L] - navigation in variable lookup list view I want to put buttons to navigate up and down rows in a variable lookup list view. I checked the properties and so not seen one. Has anybody done this? 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/2E4830CEC16615458329D3D83342F8D0014E628ABC%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/WC20201013220153.42002B%40jjcalibrations.com.
Re: [RBASE-L] - Using Variable Lookup List to move data between tables
Javier, Karen beat me to it. I really like Variable list views. You can also due a "Multi-drag and drop" using the shift or ctrl shift keys. Jan From: "'Karen Tellef' via RBASE-L" To: "rbase-l@googlegroups.com" Date: Fri, 25 Sep 2020 14:07:10 + (UTC) Subject: Re: [RBASE-L] - Using Variable Lookup List to move data between tables Javier: Have you looked at the "drag and drop"? It's on the right-click properties of list views. You enable it first, then do the EEPs. I've done it once or twice, I'd have to look in my notes where I might've kept examples of how I did mine. So I can't give you examples without looking. Karen -Original Message- From: javier.valen...@vtgonline.com To: rbase-l@googlegroups.com Sent: Thu, Sep 24, 2020 10:31 pm Subject: [RBASE-L] - Using Variable Lookup List to move data between tables I have an application in which I have to display records from one table (driving_table) and when I click on a record it is moved to a Temporary second table (selected_records) and virtually removed from the driving table (driving_table does not display records already present in the selected_records table) so it cannot be selected again. Likewise, when I click on a record on the selected _records table, it is removed from the selected_records table and the driving_table display that record again since it is no longer in the selected_records table and thus it is available for re-selection if needed. Hopefully this makes sense. In the past I have used two Variable Lookup List boxes, the first with the driving_table data and the second with the selected_records data and use "on click" to move record back and forth. Once the desired records are selected I merge them into one combined record and store it in a separate table. Is this still the preferred way to do this or is there a better approach? I actually would prefer using two grids but I have not tried this approach. Any suggestions or simpler/easier approach that you might have will be appreciated. Javier, Javier Valencia, PE javier.valen...@vtgonline.com O: 913-829-0888 C: 913-915-3137 -- 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!AAAYAO1ueGVb5zRMiwo7hebUe7jCgAAAEPBnw8jQiQpDqLRYG3Y2WcoBAA%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/1423684075.601871.1601042830293%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/WC20200925153456.41%40jjcalibrations.com.
Re: [RBASE-L] - Enhanced Variable calendar
I have a form that hides the second date unless it is needed if you are interested. From: "'Karen Tellef' via RBASE-L" To: "rbase-l@googlegroups.com" Date: Tue, 1 Sep 2020 13:53:04 + (UTC) Subject: Re: [RBASE-L] - Enhanced Variable calendar That's a neat idea, never saw anyone design a form like that. That's a great idea for a Generic date form. In this instance, they are always selecting just one date, which is why a calendar is so handy. And of course they do not have to select a second date. It's not a date range, the two dates are used independently for two types of calculations, but the 2nd calculation is not required. I could hide the 2nd calendar and put a button or checkbox for "select 2nd date for receipt date calculation" and then display the calendar. Which I might do if they get confused by the display Karen -Original Message- From: javier.valen...@vtgonline.com To: rbase-l@googlegroups.com Sent: Mon, Aug 31, 2020 9:12 pm Subject: RE: [RBASE-L] - Enhanced Variable calendar Karen, Would something like this work for you? The form is very easy to use and users can pick any date span very quickly with a few mouse clicks. The form is pre-set with the current year pre-selected but you can pre-select any date range. The more used time spans can be easily selected by clicking on the appropriate range. When you select a range, the corresponding start and end dates are updated on the red colored fields at the bottom. You can select a specific date span by clicking on the arrows next to the “From” and “To” dates (highlighted in yellow) and the calendar will pop with the current date highlighted where you can select a custom date. 9 out of 10 times the required time span needed is one of the pre-programmed time spans, at least in my application, but you have the freedom to select a custom time span. You can modify the form to include date spans that fit you applications. The form returns the To and From date values a 2 variables, vFrom Date and vTo Date. Javier, Javier Valencia, PE javier.valen...@vtgonline.com O: 913-829-0888 C: 913-915-3137 From: 'Karen Tellef' via RBASE-L [mailto:rbase-l@googlegroups.com] Sent: Sunday, August 30, 2020 3:54 PM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - Enhanced Variable calendar I have submitted an enhancement request, thanks everyone for trying to find something for me! Karen -Original Message- From: Tony IJntema To: rbase-l@googlegroups.com Sent: Sun, Aug 30, 2020 1:56 pm Subject: Re: [RBASE-L] - Enhanced Variable calendar Karen, I am using the latest version of X5 Enterprise 10.5.2.20820 I have found out that if you set the variable to NULL TODAY is highlighted as if Today is selected, which is not the case. As soon as you select another date , the selected date is highlighted It seems to me that you can report this to the dream team,maybe they can solve it The work around is to set a date to the variable instead of a null value Tony Op 30-8-2020 om 19:53 schreef 'Karen Tellef' via RBASE-L: I cannot replicate what you have. I changed my Color settings to match exactly what you have, and today still comes up highlighted clearly. My variable is initialized to null. Shown here: What version are you using? Do you have any other settings checked on other calendar tabs? And unfortunately my previous "solution" doesn't work. I cannot have "white" as the Date Selected Background color. You click a day, you can see the highlight, but as soon as you move to another control (like my 2nd calendar), your first selection totally disappears and is no longer highlighted. So far I've changed the background to a very light grey so at least it isn't as noticeable as the default blue, but it still looks like a date has been selected in both calendars. Karen -Original Message- From: Tony IJntema To: rbase-l@googlegroups.com Sent: Sun, Aug 30, 2020 11:50 am Subject: Re: [RBASE-L] - Enhanced Variable calendar Karen, I have tried this using Samples\RRBYW20 form EnhancedCalendar The only thing I have changed was the setting in the enddate. It looks like this Error! Filename not specified. As you can see the enddate does not show today. the settings for the enddate are and the only one I have changed is Todays Date Frame: Error! Filename not specified. So you can compare the settings of this example with the settings in your own application. Tony Op 30-8-2020 om 16:18 schreef 'Karen Tellef' via RBASE-L: Tony: I had already tried that. It works for you? Cuz it doesn't for me. I'm using the latest 10.5 enterprise. Here's my property page and how the form comes up with a null initialized variable. When I was previously playing around with it, it does indeed seem to be the "frame" around the blue highlight as it says. Changing it to white causes no frame around the highlight, but it does not get rid of the blue highlight. Thin
Re: [RBASE-L] - Claudine Robbins
So sorry to hear that. She had lot's to share in the RBase community. She was in the Houston are, right? Jan From: "'Karen Tellef' via RBASE-L" To: "rbase-l@googlegroups.com" Date: Tue, 16 Jun 2020 14:56:09 + (UTC) Subject: [RBASE-L] - Claudine Robbins Sadly I am informing you all that Claudine Robbins has passed away. She had been ill for quite a while, and passed away quietly under hospice care a few days ago in Texas. Her daughter and son are now carrying on her business. Of course I was lucky enough to meet her a few times at conferences, one of the few other female programmers in the early days so we had a bit in common. I always thought of her as being 'Texan' through and through. 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/1882176459.1351647.1592319369757%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/WC20200616151955.36008E%40jjcalibrations.com.
RE: [RBASE-L] - DB Edit Field - Change the field background color based on the value in the field
Well I did a simple test on a DB Edit field where ON ENTRY changed and ON EXIT changed, so I know it works. From: "Myron Finegold" To: Date: Sun, 7 Jun 2020 10:38:11 -0700 Subject: RE: [RBASE-L] - DB Edit Field - Change the field background color based on the value in the field Jan, No themes. Myron From: rbase-l@googlegroups.com On Behalf Of jan johansen Sent: June 7, 2020 8:38 AM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - DB Edit Field - Change the field background color based on the value in the field Myron, Just out of curiosity, are you using themes? Jan From: "Myron Finegold" To: Date: Sat, 6 Jun 2020 13:26:11 -0700 Subject: [RBASE-L] - DB Edit Field - Change the field background color based on the value in the field What Object: DB Edit Field Desire: to the background color change based on the value in the column. This will be a ‘Y’ or an ‘N’. The DB Edit field has been given a unique component ID. ciLockBox A custom EEP has been put into the ‘On Enter’ choice PROPERTY ciLockBox COLOR 'white' RETURN A custom EEP has been put into the ‘On Exit’ choice SET VAR vwatch1 TEXT = NULL GETPROPERTY cilockbox TEXTVALUE vwatch1 IF vwatch1 IS NULL THEN RETURN ENDIF IF cilockbox = 'Y' THEN PROPERTY cilockbox COLOR 'green' ELSE PROPERTY cilockbox COLOR 'red' ENDIF RETURN This isn’t working. As they say I have hit the wall. Any suggestions would be appreciated. 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/00a601d63c40%24b8fc3c00%242af4b400%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/WC20200607153813.090006%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/017b01d63cf2%246ac49a70%24404dcf50%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/WC20200607183440.05000B%40jjcalibrations.com.
Re: [RBASE-L] - DB Edit Field - Change the field background color based on the value in the field
Myron, Also, put your SET VAR vwatch1 TEXT = NULL in the form ON BEFORE START eep. Then change your DB-edit ON ENTER to SET VAR vwatch1 = NULL You declare a vWatch1 variable but then you evaluate cilockbox. You should evaluate vWatch1 Jan From: "Myron Finegold" To: Date: Sat, 6 Jun 2020 13:26:11 -0700 Subject: [RBASE-L] - DB Edit Field - Change the field background color based on the value in the field What Object: DB Edit Field Desire: to the background color change based on the value in the column. This will be a ‘Y’ or an ‘N’. The DB Edit field has been given a unique component ID. ciLockBox A custom EEP has been put into the ‘On Enter’ choice PROPERTY ciLockBox COLOR 'white' RETURN A custom EEP has been put into the ‘On Exit’ choice SET VAR vwatch1 TEXT = NULL GETPROPERTY cilockbox TEXTVALUE vwatch1 IF vwatch1 IS NULL THEN RETURN ENDIF IF cilockbox = 'Y' THEN PROPERTY cilockbox COLOR 'green' ELSE PROPERTY cilockbox COLOR 'red' ENDIF RETURN This isn’t working. As they say I have hit the wall. Any suggestions would be appreciated. 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/00a601d63c40%24b8fc3c00%242af4b400%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/WC20200607154955.310008%40jjcalibrations.com.
Re: [RBASE-L] - DB Edit Field - Change the field background color based on the value in the field
Myron, Just out of curiosity, are you using themes? Jan From: "Myron Finegold" To: Date: Sat, 6 Jun 2020 13:26:11 -0700 Subject: [RBASE-L] - DB Edit Field - Change the field background color based on the value in the field What Object: DB Edit Field Desire: to the background color change based on the value in the column. This will be a ‘Y’ or an ‘N’. The DB Edit field has been given a unique component ID. ciLockBox A custom EEP has been put into the ‘On Enter’ choice PROPERTY ciLockBox COLOR 'white' RETURN A custom EEP has been put into the ‘On Exit’ choice SET VAR vwatch1 TEXT = NULL GETPROPERTY cilockbox TEXTVALUE vwatch1 IF vwatch1 IS NULL THEN RETURN ENDIF IF cilockbox = 'Y' THEN PROPERTY cilockbox COLOR 'green' ELSE PROPERTY cilockbox COLOR 'red' ENDIF RETURN This isn’t working. As they say I have hit the wall. Any suggestions would be appreciated. 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/00a601d63c40%24b8fc3c00%242af4b400%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/WC20200607153813.090006%40jjcalibrations.com.
Re: Re[2]: [RBASE-L] - Using #c within SELECT - Revisited
No, I understand. I was just curious. I fixed all weird column names a very
long time ago so I was wondering if it was a potential source of
consternation.
From: "Bruce Chitiea"
To: rbase-l@googlegroups.com
Date: Mon, 18 May 2020 15:33:27 +
Subject: Re[2]: [RBASE-L] - Using #c within SELECT - Revisited
Thanks, Jan, no.
Per R:SYNTAX ("... where #c is the column number shown in the output of the
LIST TABLES command..."), I've failed to define and insert a column alias
into a SELECT statement, so as to specify the position of a column, as in:
SELECT 1 FROM HUMPTY ...
... retrieving the value from column 1 .
The value of vColumn_Alias increments within a WHILE loop, walking columns
of a single table: (1,2,3, ..., n ) to produce concatenated output:
(Value_1 (Value_2 (Value_3 (Value_n
I receive a literal string, instead:
"(1 (2 (3 ... (n"
Thoughts? and thanks.
Bruce
------ Original Message --
From: "jan johansen"
To: rbase-l@googlegroups.com
Sent: 5/18/2020 8:05:06 AM
Subject: Re: [RBASE-L] - Using #c within SELECT - Revisited
Bruce,
Do you actually have a column named "C#"?
Jan
From: "Bruce Chitiea"
To: rbase-l@googlegroups.com
Date: Sun, 17 May 2020 20:38:54 +
Subject: Re: [RBASE-L] - Using #c within SELECT - Revisited
All:
This:
SET VAR vColumn_Alias TEXT = NULL
SET VAR vColumn_Alias = (CTXT(.vColumnCNT_Stp))
... correctly resolves to this: " 1 " , being the " #c " column number, in
text datatype, accepted by the SELECT command.
But, when used in a SELECT statement to retrieve the value contained within
Field 1:
SELECT &vColumn_Alias +
INTO vColumn_Text INDIC vInd +
FROM Parsed_Filenames +
WHERE WalkListID = .vWalkList_Stp
... the value retrieved is the literal value of the text variable: " 1 ",
instead of the field value.
What needs to be changed in the definition of the variable, or in its use
within the SELECT statement, to retrieve the value of column number " 1 "?
Sooo close. Stumped.
Thanks much, Bruce
Bruce A. Chitiea
SafeSectors, Inc.
112 Harvard Ave #272
Claremont CA 91711-4716
rby...@safesectors.com
+011 (909) 238-9012 c
-- Original Message --
From: "Bruce Chitiea"
To: "rbase-l@googlegroups.com"
Sent: 5/15/2020 5:10:50 PM
Subject: [RBASE-L] - Using #c within an UPDATE ... SELECT
All:
Courier New font
BACKGROUND
For a file naming and re-naming project, several thousands of
custom-delimited document filenames are to be parsed into fields within
table ParsedFileNames. The field count for each record varies by class and
filetype, so that the filename extension scatters over a range of fields.
The goal is to copy the filename extension from whichever field it falls
within, to common column DocExt, ideally as the table is being populated.
To this end, during parsing, SLOCI generates a field count to be stored in a
FieldCount column for each record. Since the filename extension is the last
field in a parsed filename, the extension is found within Column# =
FieldCount.
ISSUE
By itself ...
SELECT ('#'+(CTXT(FieldCount))) FROM ParsedFilenames
... produces:
#13
#11
.
#10
... as intended. So, I'd thought this would do the trick:
UPDATE ParsedFileNames +
SET DocExt = +
SELECT ('#'+(CTXT(FieldCount))) +
FROM ParsedFileNames +
WHERE DocExt IS NULL
... which produces the error:
"Illegal table name - ('#'+(CTXT(FieldCount))) (2037)"
Several attempts to turn the offending string into a variable, for use as an
ampersand variable, have also failed. Still working at it, but clearly not
getting it.
How might the column number be specified within the SELECT statement, to
avoid resort to a WHERE loop or CURSOR?
Many thanks, Bruce
Bruce A. Chitiea
SafeSectors, Inc.
112 Harvard Ave #272
Claremont CA 91711-4716
rby...@safesectors.com
+011 (909) 238-9012 c
--
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/emdaf59928-37f7-4860-a39e-91a4b7d4e199%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/emd608335b-5794-4374-a6c6-86bc95fc2f86%40pathfinder.
--
For group guidelines, vis
Re: [RBASE-L] - Using #c within SELECT - Revisited
Bruce,
Do you actually have a column named "C#"?
Jan
From: "Bruce Chitiea"
To: rbase-l@googlegroups.com
Date: Sun, 17 May 2020 20:38:54 +
Subject: Re: [RBASE-L] - Using #c within SELECT - Revisited
All:
This:
SET VAR vColumn_Alias TEXT = NULL
SET VAR vColumn_Alias = (CTXT(.vColumnCNT_Stp))
... correctly resolves to this: " 1 " , being the " #c " column number, in
text datatype, accepted by the SELECT command.
But, when used in a SELECT statement to retrieve the value contained within
Field 1:
SELECT &vColumn_Alias +
INTO vColumn_Text INDIC vInd +
FROM Parsed_Filenames +
WHERE WalkListID = .vWalkList_Stp
... the value retrieved is the literal value of the text variable: " 1 ",
instead of the field value.
What needs to be changed in the definition of the variable, or in its use
within the SELECT statement, to retrieve the value of column number " 1 "?
Sooo close. Stumped.
Thanks much, Bruce
Bruce A. Chitiea
SafeSectors, Inc.
112 Harvard Ave #272
Claremont CA 91711-4716
rby...@safesectors.com
+011 (909) 238-9012 c
-- Original Message --
From: "Bruce Chitiea"
To: "rbase-l@googlegroups.com"
Sent: 5/15/2020 5:10:50 PM
Subject: [RBASE-L] - Using #c within an UPDATE ... SELECT
All:
Courier New font
BACKGROUND
For a file naming and re-naming project, several thousands of
custom-delimited document filenames are to be parsed into fields within
table ParsedFileNames. The field count for each record varies by class and
filetype, so that the filename extension scatters over a range of fields.
The goal is to copy the filename extension from whichever field it falls
within, to common column DocExt, ideally as the table is being populated.
To this end, during parsing, SLOCI generates a field count to be stored in a
FieldCount column for each record. Since the filename extension is the last
field in a parsed filename, the extension is found within Column# =
FieldCount.
ISSUE
By itself ...
SELECT ('#'+(CTXT(FieldCount))) FROM ParsedFilenames
... produces:
#13
#11
.
#10
... as intended. So, I'd thought this would do the trick:
UPDATE ParsedFileNames +
SET DocExt = +
SELECT ('#'+(CTXT(FieldCount))) +
FROM ParsedFileNames +
WHERE DocExt IS NULL
... which produces the error:
"Illegal table name - ('#'+(CTXT(FieldCount))) (2037)"
Several attempts to turn the offending string into a variable, for use as an
ampersand variable, have also failed. Still working at it, but clearly not
getting it.
How might the column number be specified within the SELECT statement, to
avoid resort to a WHERE loop or CURSOR?
Many thanks, Bruce
Bruce A. Chitiea
SafeSectors, Inc.
112 Harvard Ave #272
Claremont CA 91711-4716
rby...@safesectors.com
+011 (909) 238-9012 c
--
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/emdaf59928-37f7-4860-a39e-91a4b7d4e199%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/emd608335b-5794-4374-a6c6-86bc95fc2f86%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/WC20200518150506.43004C%40jjcalibrations.com.
Re: [RBASE-L] - CAPTURE_FROM_WINDOW fails on one machine
Doug, My only guess is that the one computer has a lousy video card in it. Jan From: Doug Hamilton To: "R:Base List" Date: Wed, 13 May 2020 14:49:53 -0500 Subject: [RBASE-L] - CAPTURE_FROM_WINDOW fails on one machine I have a 3-user RBX.5E system, all running Win10, that has a push button to capture an image of the current form: PROPERTY RBASE_FORM CAPTURE_FROM_WINDOW 'CLIPBOARD' I can paste the image on two of the machines but no image gets pasted on the third. I've tried pasting into an email (Outlook, where it works on the other two machines) and Paint. I get an outline of the image with the handles but no content. I can't even ask for blues clues 'cuz there's no color. :( Any ideas why it would work on 2 machines and not the third? TIA, Doug -- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus -- 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/588d4462-1a0d-8714-6e06-a076ab513358%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/WC20200513201922.7800B8%40jjcalibrations.com.
Re: [RBASE-L] - TWO INSERTS
I think I’d put a PAUSE FOR 1 In between the inserts. Make sure that you have a DIALOG before inserts to let the user know something is happening and CLS after the inserts. > From: Jim Belisle > To: "rbase-l@googlegroups.com" > Date: Thu, 27 Feb 2020 20:24:29 + > Subject: [RBASE-L] - TWO INSERTS > I have a few places in my code where I do two inserts into two > different tables one right after the other. > Most of the time that is not a problem. > However there is code that runs on the thin clients out in the shop > (hardwire) where recently the second table does not get populated as it > should. > Once again this is only once in awhile. > The code runs in an on exit (from a field) EEP. > The information going into both tables is from a view. > > First insert > INSERT INTO inventry + > (list of columns) + > SELECT list of columns + > FROM twkinvtbl > > Second insert > > INSERT INTO workdetail + > (list of columns) + > SELECT list of columns + > FROM twkinvtbl > > He form closes after dropping the temp view. > Any BLUES CLUES? > > (Also this field is populated by scanning a location. All they user is > supposed to do after the scan is hit the enter key.) > > James Belisle > > Making Information Systems People Friendly Since 1990 > [cid:image001.jpg@01CD8CE2.FB048F50] > > -- > 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/CH2PR02MB704775C028C7BDA18663 > 88B6A0EB0%40CH2PR02MB7047.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/WC20200228011310.570029%40jjcalibrations.com.
Re: [RBASE-L] - RMail Blues Clues
Dick, I think I would look at the security on those 2 computers. Make sure they have read/write access to the temp folders, etc. Jan From: Dick Fey To: RBase Maillist Date: Wed, 26 Feb 2020 12:11:16 -0600 Subject: [RBASE-L] - RMail Blues Clues Were running Windows 7 Now on Windows 10. All updated Weird that only 1 of 3 is problematic. Dang. 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/16c708dc-1585-89ab-9f74-0ef97644dfe2%40thecarpetbroker.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/WC20200226181621.23004C%40jjcalibrations.com.
Re: [RBASE-L] - Rmail Blues Clues
Dick, If I remember correctly, you mentioned "new" computers. Different operating systems? Jan From: Dick Fey To: RBase Maillist Date: Wed, 26 Feb 2020 11:38:52 -0600 Subject: [RBASE-L] - Rmail Blues Clues So here is where I am. As mentioned before, code shows Email was sent. But it is not sent. Cfg dashboard indicates a good connection to server. Tried a trace in our application, but it shows no errors. Set up logging on my machine and on problem one. Works fine on my computer. The log file is getting nothing. Dont' know when it starts logging, but it seems like it never gets that far. Tried moving my cfg file to problem machine. Assume mail server does not actually know which computer is sending. No change. Hard to figure out when all other machines are working from same application code. And thats why I am singing the blues. (loud wailing and knashing of teeth) (some cursing) 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/17f9b49f-5dd1-a39d-f1f8-da3a241f51e4%40thecarpetbroker.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/WC20200226174317.22002D%40jjcalibrations.com.
Re: [RBASE-L] - Custom Form Actions
You can call a form action from another form if it is open. For example if you fave a form action in your main menu and you open another form, you can call the form action from the main menu. You have to have assign a property to your first form. I don’t remember the syntax off hand but I know I have a sample > From: "Jim McPherson" > To: > Date: Thu, 6 Feb 2020 14:11:52 -0800 > Subject: [RBASE-L] - Custom Form Actions > All, > > > > Are Custom Form Actions unique to the form in which they are created? > In > other words, can a single CFA be called from more than one form? > > > > Thanks, > > > > Jim McPherson > > > > -- > 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/002f01d5dd3a%2471762ef0%24546 > 28cd0%24%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/WC20200207024510.72009D%40jjcalibrations.com.
Re: [RBASE-L] - using & in set var or select into statement
Does ... (COUNT(dlrname)) IN dealer WHERE activelines CONTAINS .vactivelines AND dlrnum > 'cf000' + AND ((activelines CONTAINS .vactivelines AND &activetype < .vmonend) + OR (activelines1 = 'n' AND &canceltype > .vmonstart + AND &activetype < .vmonstart)) work at the R> ? From: Dan Goldberg To: "rbase-l@googlegroups.com" Date: Tue, 17 Dec 2019 18:34:29 + Subject: [RBASE-L] - using & in set var or select into statement I am trying to use variable values for column names in set var and select statement and it gives me the error -ERROR- An expression cannot begin with binary operator (2150) If I replace the & variables with the column names it works. Here is my set var command. SET VAR vnumdlrs = (COUNT(dlrname)) IN dealer + WHERE activelines CONTAINS .vactivelines AND dlrnum > 'cf000' + AND ((activelines CONTAINS .vactivelines AND &activetype < .vmonend) + OR (activelines1 = 'n' AND &canceltype > .vmonstart + AND &activetype < .vmonstart)) Any blues clues on how I can do this? 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/2E4830CEC16615458329D3D83342F8D0011ECC99F6%40exchange11. -- 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/WC20191217190038.710089%40jjcalibrations.com.
Re: [RBASE-L] - App display to screen
If I remember correctly, all WRITE statements need to be converted to like a PAUSE USING From: Rich To: rbase-l@googlegroups.com Date: Thu, 5 Dec 2019 12:19:32 -0500 Subject: [RBASE-L] - App display to screen I have converted to rbase 10. I have an action in the app that does writes to the screen as it executes. The action executes but the writes to the screen do not display. Any ideas? Rich Jasinski Sent from my iPhone -- 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/950297C1-FED4-40A7-B40B-73FD955C5E17%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/WC20191205180850.050036%40jjcalibrations.com.
Re: [RBASE-L] - multiple sorting of db grid
Jim, I don't use DB grids all often but should be able to use an "order by" before bringing up the form. Also there appears to be a PROPERTY command to bring up a sort called SHOWSORTDIALOG Jan From: Jim Belisle To: "rbase-l@googlegroups.com" Date: Thu, 27 Jun 2019 15:09:47 + Subject: [RBASE-L] - multiple sorting of db grid Is there a way to have multiple sorting of an enhanced DB grid form? 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/DM6PR02MB453930DF5ACF2DA9BE45D064A0FD0%40DM6PR02MB4539.namprd02.prod.outlook.com. For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/WC20190701162525.21005A%40jjcalibrations.com. For more options, visit https://groups.google.com/d/optout.
[RBASE-L] - Form search
Group, I'm sure that hasn't to anyone else. The client changed their mind on form sizes. Is there a way to search form sizes without bringing up each individual form? 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/WC20190612183931.010062%40jjcalibrations.com. For more options, visit https://groups.google.com/d/optout.
Re: [RBASE-L] - SCONNECT and SATTACH
Razzak, Thank you. I can now see the table structure of the Acess database. Jan From: "A. Razzak Memon" To: rbase-l@googlegroups.com Date: Thu, 09 May 2019 20:05:08 -0400 Subject: Re: [RBASE-L] - SCONNECT and SATTACH Jan, The best approach to understand and view the external (other) database structure, is to use the Database Explorer's Utilities option. 01. Start RBGXE or RBGX5E and CONNect to R:BASE database. 02. Database Explorer > Main Menu > Utilities > Connect SQL Data Source ... Once connected successfully ... 03. Database Explorer > Main Menu > Utilities > Attach SQL Database Tables This is where you will see the list of all tables and views While SATTACHing, you will have the option to attach that table as: . Attach As Alias . Attach As Temporary . Attach USING ALL Once SATTACHed successfully, you can review everything and then write a command file to accomplish the exact same task automatically. That's all there is to it! To further understand and automate the entire process, take a close look at the R:BASE Super Advanced Training Sample Applications (Part 5): Application: R:BASE for Everyone (Integrating R:BASE X.5 Enterprise (Version 10.5) with ODBC Compliant Databases) Have fun! Razzak At 05:57 PM 5/9/2019, jan johansen wrote: >Group, > >I haven't really had the need to utilize these commands until now. >I need to connect to an Access DB (mdb). > >I can SCONNECT to it no problem. >However how to SATTACH to the internal tables if you have no idea what >the Access structure is or what the table names are? -- 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/20190515.x4A05CjA002697%40atl4mhob12.registeredsite.com. For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/WC20190510141429.830086%40jjcalibrations.com. For more options, visit https://groups.google.com/d/optout.
RE: [RBASE-L] - SCONNECT and SATTACH
Paul, Thanks for the offer. To answer your question, still on version XE. I'm trying to clean up a few things before upgrading. There are few things that need to wait til after the upgrade (I want to use the new calendar in 10.5) Jan From: "Paul Buckley" To: Date: Fri, 10 May 2019 09:16:15 -0400 Subject: RE: [RBASE-L] - SCONNECT and SATTACH Jan, Adding to what Razzak has already said, I have had a lot of experience connecting external databases. The beauty is, once the ODBC connection is created and you SATTACH the database when you look at “Attach SQL Database Tables” (ignore the SQL) it lists all the tables in the database. One thing you will find is that other databases will allow table names that are reserved names in R:BASE so you will have to create an alias column name. If you have any questions feel free to reach out to me offline. I will be at our Nashville, TN facility next week (central time zone) and have some time in the evenings. BTW, what version of R:BASE will you be using? Good luck, Paul Buckley From: rbase-l@googlegroups.com On Behalf Of jan johansen Sent: May 09, 2019 5:57 PM To: rbase-l@googlegroups.com Subject: [RBASE-L] - SCONNECT and SATTACH Group, I haven't really had the need to utilize these commands until now. I need to connect to an Access DB (mdb). I can SCONNECT to it no problem. However how to SATTACH to the internal tables if you have no idea what the Access structure is or what the table names are? 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/WC20190509215719.300061%40jjcalibrations.com. For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/!%26!AAAYACTQrV%2BjpqhNvfOkAo0BwxzCgAAAECsFJtvt61dHq4lQoKRYqHQBAA%3D%3D%40buckleyandassoc.com. For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/WC20190510140734.71007F%40jjcalibrations.com. For more options, visit https://groups.google.com/d/optout.
[RBASE-L] - SCONNECT and SATTACH
Group, I haven't really had the need to utilize these commands until now. I need to connect to an Access DB (mdb). I can SCONNECT to it no problem. However how to SATTACH to the internal tables if you have no idea what the Access structure is or what the table names are? 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/WC20190509215719.300061%40jjcalibrations.com. For more options, visit https://groups.google.com/d/optout.
Re: [RBASE-L] - Ghost form
Razzak, Thank you. Form removed. Jan From: "A. Razzak Memon" To: rbase-l@googlegroups.com Date: Thu, 09 May 2019 09:50:29 -0400 Subject: Re: [RBASE-L] - Ghost form Jan, Here's how ... 01. EDIT ALL FROM SYS_FORMS3 ORDER BY SYS_FORM_NAME 02. Highlight the one you don't need based on SYS_FORM_MOD_TS and SYS_FORM_VERSION 03. Press [F9] key to delete the row Have fun! Razzak At 09:40 AM 5/9/2019, jan johansen wrote: >Group, > >Somehow I ended up with 2 forms with the same name. >I can remove one but not the other. > >Suggestions? I seem remember a way to do this by going >into SYS_FORMS but wanted to check in here first. > >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/201905091350.x49DoWhL031412%40atl4mhob01.registeredsite.com. For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/WC20190509140016.5400A9%40jjcalibrations.com. For more options, visit https://groups.google.com/d/optout.
[RBASE-L] - Ghost form
Group, Somehow I ended up with 2 forms with the same name. I can remove one but not the other. Suggestions? I seem remember a way to do this by going into SYS_FORMS but wanted to check in here first. 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/WC20190509134016.1400A3%40jjcalibrations.com. For more options, visit https://groups.google.com/d/optout.
Re: [RBASE-L] - Is there a limit to PDF printing?
Karen, My recommendation is the individual statements. We print statements to PDF's and they are stored on the server so we can always go back for them. Also the statement program runs on the server at about 2AM on the last day of the month. So much faster than the user pressing a "print statement" button. Jan From: "'Karen Tellef' via RBASE-L" To: rbase-l@googlegroups.com Date: Tue, 30 Apr 2019 16:16:51 + (UTC) Subject: [RBASE-L] - Is there a limit to PDF printing? I have an app that prints thousands of statements a month, and the program hasn't changed much since 6.5 days. Each statement is calculated one at a time and printed one at a time. Most of the time the computer will lock up during the printing, which I assume is because RBase is printing so fast to the spooler, and the network/spooler/printer simply cannot keep up with the number of files waiting to print, and at some point RBase can no longer send jobs to the print queue. Luckily I've programmed it so that the user can come back in and easily continue where it left off, but it's a pain to have to do that. We've tried building in "waits" after so many statements print, but the program ended up taking like 6 hrs to run! And yes, believe it or not, they are mailing the statements to their customers and have no wish to email them. So I'm thinking of utilizing PDFs instead, and I have the choice of generating 1000s of individual PDFs (where the user can then highlight multiple PDFs, right-click, "print" at their own schedule), or generating one huge multi-1000s page PDF. I have never created that big of a PDF. Is there a reasonable limit to the #pages RBase can print to a PDF file? Can someone tell me the largest PDF file they've ever generated? Thanks!Or if you have other suggestions. 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. For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [RBASE-L] - Google Maps
Never mind. I just parse the address to see what Google was doing. Have a great weekend. From: "jan johansen" To: rbase-l@googlegroups.com Date: Fri, 26 Apr 2019 13:03:42 -0700 Subject: [RBASE-L] - Google Maps All, Looking for a shortcut. Has any passed an address to Google Maps? TIA, Jan -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
[RBASE-L] - Google Maps
All, Looking for a shortcut. Has any passed an address to Google Maps? TIA, Jan -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [RBASE-L] - Form search
Albert, Ding, ding, ding! That work's really well. Jan From: Albert Berry To: rbase-l@googlegroups.com Date: Wed, 17 Apr 2019 11:21:20 -0600 Subject: Re: [RBASE-L] - Form search DB Explorer Forms Highlight All [Ctrl-F] Control Properties On Apr 17, 2019, at 10:13 AM, jan johansen wrote: All, Is there a way to search FORMS for a particular object i.e. Bit Button, Speed Button, etc? Jan -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
[RBASE-L] - Form search
All, Is there a way to search FORMS for a particular object i.e. Bit Button, Speed Button, etc? Jan -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [RBASE-L] - simple question
Jim, I think I remember that you are running compiled. Did you include Steel Blue as an additional resource in your compiler? As an aside, it may be beneficial to move from themes in database. They are overhead and slow it down. Jan From: Jim Belisle To: "rbase-l@googlegroups.com" Date: Thu, 21 Mar 2019 16:28:43 + Subject: [RBASE-L] - simple question I bring up the pause with gauge box quite often when running reports. In my test DB the gauge comes up properly (colors, etc). In my application it is all plain and not fancy like it should be. I still see only the outline and hardly see the lettering. What setting in my CFG or startup file do I need to change in order to have the gauge look like it should? This is the code I bring into the code from a command file table within RBASE. -- Pause 3 with Gauge. JPB PAUSE 3 USING 'Calculating ... Please Stand By ...' + CAPTION .vgaugemsg + ICON WINDOWS OPTION GAUGE_VISIBLE ON + |GAUGE_COLOR RED + |GAUGE_INTERVAL 10 + |MESSAGE_FONT_NAME VERDANA + |MESSAGE_FONT_SIZE 10 + |MESSAGE_FONT_COLOR WHITE + |THEMENAME Steel Blue 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. For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [RBASE-L] - MIssing object
All, Never mind. I found a workaround. Jan From: "jan johansen" To: rbase-l@googlegroups.com Date: Tue, 19 Mar 2019 11:20:44 -0700 Subject: [RBASE-L] - MIssing object Group, Somewhere along the way, I've made an object in a form not visible. When I run the form, the object appears. However when I try to design the form, the object is not visible. I've tried using the object inspector, but I'm not finding it. Suggestions? Jan -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
