RE: [RBASE-L] - using user IDs and passwords for RBASE
Karen,
If you could send me privately a sample of the log on / password routine you
are talking about, that would give me an option I might need to use.
We have a couple of computers that would fall into that category. In most case
however each person here logs in as their own user with their own password /
user name.
James Belisle
Making Information Systems People Friendly Since 1990
[cid:image001.jpg@01CD8CE2.FB048F50]
From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com]
Sent: Monday, August 6, 2018 8:46 AM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - using user IDs and passwords for RBASE
That's almost all I ever use too, (cval('netuser')). I've never used cfg files
for that.
I have a couple installations where there is a general windows logon just to
boot the computer up, and then multiple people will use that machine. In those
cases I will institute a log on / password routine within RBase, compared to a
table that holds the list.
Karen
-Original Message-
From: Dan Goldberg
To: rbase-l
Sent: Mon, Aug 6, 2018 8:33 am
Subject: RE: [RBASE-L] - using user IDs and passwords for RBASE
I use the cval(‘netuser’) to authenticate and give permissions from there. I
have a table with the users/windows logon names with their access rights. Based
on their rights the menu will displayed.
Dan Goldberg
From: rbase-l@googlegroups.com
mailto:l...@googlegroups.com>> On Behalf Of Jim
Belisle
Sent: Monday, August 6, 2018 4:41 AM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - using user IDs and passwords for RBASE
Buddy and Albert,
Thanks for the information. I am in meetings the first part of the week so will
have to wait on this.
I am not sure if I mentioned this to you but I am the only one who has a full
version of RBASE.
I create the compiled application and all others use this application and use
the same CFG file on the server.
That CFG is located on the server in the same folder as the compiled apps and
any DLLS or other programs needed in RBASE.
So as you can see, all this is new to me and I am having trouble “connecting
the dots”.
I will read the RBASE pdfs to see if I can get further understanding on setting
up log ins based on users in a compiled app system.
I have read this in the past but we did not implement.
James Belisle
Making Information Systems People Friendly Since 1990
[cid:image001.jpg@01CD8CE2.FB048F50]
From: rbase-l@googlegroups.com
[mailto:rbase-l@googlegroups.com] On Behalf Of Buddy Walker
Sent: Saturday, August 4, 2018 10:40 PM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - using user IDs and passwords for RBASE
Jim
Each user will need there own RBENGINEXE.CFG (RBENGINEX.CFG) file. You would
have to visit each user’s PC once and update the RBENGINEXE.CFG (RBENGINEX.CFG)
this can be done in couple of different ways:
1. Start a session of R:Base and then select Settings > Configuration
Settings > Multi User now in the NAME box type in the users windows/exchange
name
2. The other way is edit the file using Notepad or some other text
editor. Find the line that starts with NAME and then highlight and replace the
name that is there.
Now just follow Albert’s example below.
Buddy
From: rbase-l@googlegroups.com
mailto:rbase-l@googlegroups.com>> On Behalf Of Albert
Berry
Sent: Saturday, August 4, 2018 12:05 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - using user IDs and passwords for RBASE
Create a Windows file and add it to the line in the user icon that calls the
database. It should read as Buddy suggested. In the icon command line below, I
called it DBLogin.dat
IF CVAL (‘USER’) <> (‘NETUSER’) THEN
PAUSE 2 USING ‘Not Authorized’
EXIT
RETURN
The icon would read along these lines. The default is RBASE.DAT but I would not
recommend that, because that would give you indigestion every time you tried to
log into the database.
C:\RBTI\RBGXE\RBGXE.exe DBLogin.dat
As Razzak would say “That’s all there is to it”
Albert
On Aug 4, 2018, at 9:16 AM, Jim Belisle
mailto:j...@kaypark.com>> wrote:
Buddy,
Thanks for the response.
You are talking to someone who is very ignorant of how to even start down this
road.
At the present the DB is setup without IDs (USER is NONE) I need to know how to
get that setup in the first place.
The code set var vu = (CVAL('USER')) gives my NONE as an answer.
So I will need to start from the beginning.
We are talking about an application in which 12 to 15 users will be accessing
the DB.
I do not know the passwords for the users.
James Belisle
Making Information Systems People Friendly Since 1990
From: rbase-l@googlegroups.com
[mailto:rbase-l@googlegroups.com] On Behalf Of Buddy Walker
Sent: Saturday, August 4, 2018 10:02 AM
[RBASE-L] - rmail xe
I am working on changing our email to using RMAILX. Our RBASE is RBASEXE the latest version. For close to 30 years we have used Outlook so this is going to be a big change. We are used to the "look" of Outlook so I need to be prepared for the responses of our staff when that "look" is gone when emailing through RBASE. We use our email in a variety of ways. 1) We send auto emails in which the user does not add anything and they just see the "sending" box. No further user input needed. I figured this out with RMAIL. 2) We send some email in which the user wants to add to the body their own wording like "thanks for the order." In watching the RMAIL in action, I imagine they will still be able to do that in the box that comes up when it goes through the connection, sending routine. I know there is a WAIT code (PLUGIN RMail v1|WAIT 2000) but is there a way to make RMAIL wait until the user hits a send button? 3) We also send our email with the below image. I saw an example in the pdf of sending using HTML code. I believe these are Bitmap images. Will the code be the same. 4) We then have at least one instance in which the user likes the emails to come up so they can choose to not send. This is in a WHILE loop where we are sending shipping confirmations. There are instances in which they either decide not to send the email or change the email address or add one. Would list also have to be cared for with the WAIT code and make the wait longer? 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. For more options, visit https://groups.google.com/d/optout.
Re: [RBASE-L] - Tip of the Day: Enhanced Case Sensitive and Whole Word Search Options
If we thanked the R:Dream Team for every enhancement, the postings would be 10 X what they are on here. Albert the appreciative. > On Aug 8, 2018, at 10:41 AM, A. Razzak Memon wrote: > > > You should thank the resilient and talented R:Dream Team to implement such a > cool and useful tool based on a request from one of our corporate customers. > > You all are simply the beneficiaries of such vision and dedication. > > Enjoy! > > Razzak > > > At 11:18 AM 8/8/2018, karentellef via RBASE-L wrote: > >> I can sure see using the "whole word" search! >> >> But being me, I always test to the nth degree, and I am thrilled to >> announce that it works perfectly, ignoring punctuation. >> >> For example, it found the whole word even if there was parenthesis >> or commas around it. It located the word "BLNo" in these >> 2 examples I typed into a custom eep: >> >> CREATE TEMP TABLE tmpBL (BLNo Int ..) >> SELECT blno, bdate INTO .. >> >> Good job! >> >> Karen >> >> -Original Message- >> From: A. Razzak Memon >> To: rbase-l >> Sent: Wed, Aug 8, 2018 7:08 am >> Subject: [RBASE-L] - Tip of the Day: Enhanced Case Sensitive and Whole Word >> Search Options >> >> Wednesday, August 08, 2018 >> >> Tip of the Day: Enhanced Case Sensitive and Whole Word Search Options >> Product...: R:BASE X and R:BASE X Enterprise (Version 10) >> Build.: 10.0.4.10808 or higher >> Sections..: Database Explorer, Forms, Reports, Labels, External Forms >> Keywords..: Search, EEPs, Expressions, Control Properties, Case >> Sensitive, Whole Word >> >> Did you know the search capabilities for finding text in Custom EEPs, >> Control Properties, and >> Expressions has been enhanced to include "case sensitive" and "whole >> word" criteria? >> >> When searching for text in Custom EEPs, Control Properties, and >> Expressions, for database Forms, >> Reports, Labels, External Forms, and Applications, the "Find in" >> dialog now includes the "Match >> Case" and "Whole Word" options for more detailed searches. >> >> Emacs! >> >> >> http://www.razzak.com/tips/RBGX_FindInCustomEEPsForms_Options.png >> >> The added capability adds to the existing search capabilities built >> into R:BASE X/X Enterprise >> (Version 10) for users to locate text within the database modules and >> within external files, >> including: >> >> 01. Find in Database Explorer >> 02. Find in Stored Procedures >> 03. Find in Custom EEPs - [Ctrl] + F >> . Find in Form Custom EEPs >> . Find in Report Custom EEPs >> . Find in Label Custom EEPs >> . Find in Application Custom EEPs >> . Find in External Form Custom EEPs >> 04. Find in Control Properties - [Ctrl] + L >> . Find in Form Control Properties >> . Find in Report Control Properties >> . Find in Label Control Properties >> . Find External Form Control Properties >> 05. Find in Expressions - [Ctrl] + [Shift] + F >> . Find in Form Expressions >> . Find in Report Expressions >> . Find in Label Expressions >> 06. Find in Files >> 07. Find in R> Prompt Output >> >> From The Edge: http://www.razzak.com/fte >> Topic: Searching in R:BASE X and R:BASE X Enterprise (Version 10) >> >> Very Best R:egards, >> >> Razzak. >> >> https://www.rbase.com >> http://www.facebook.com/rbase/ > > > > > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > --- You received this message because you are subscribed to the Google 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] - Arrange by
Here's how ... Based on sample RRBYW19 database ... EDIT USING SalesTransactions + ARRANGE InvoiceHeader BY TransID, + ARRANGE InvoiceDetail BY DetailNum, + ARRANGE Employee BY EmpLName,EmpFName + ARRANGE Contact BY ContLName,ContFName + ORDER BY Company WHERE CustState = 'PA' RETURN Hope it helps! Very Best R:egards, Razzak At 12:35 PM 8/8/2018, Carpet Broker, Dick Fey wrote: I hate it when I have used a command in the past, need it again, and can't find the documentation. There is a command to use when editing a multi table form to arrange one of the tables in a certain order. HELP. Dick Fey -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [RBASE-L] - Tip of the Day: Enhanced Case Sensitive and Whole Word Search Options
You should thank the resilient and talented R:Dream Team to implement such a cool and useful tool based on a request from one of our corporate customers. You all are simply the beneficiaries of such vision and dedication. Enjoy! Razzak At 11:18 AM 8/8/2018, karentellef via RBASE-L wrote: I can sure see using the "whole word" search! But being me, I always test to the nth degree, and I am thrilled to announce that it works perfectly, ignoring punctuation. For example, it found the whole word even if there was parenthesis or commas around it. It located the word "BLNo" in these 2 examples I typed into a custom eep: CREATE TEMP TABLE tmpBL (BLNo Int ..) SELECT blno, bdate INTO .. Good job! Karen -Original Message- From: A. Razzak Memon To: rbase-l Sent: Wed, Aug 8, 2018 7:08 am Subject: [RBASE-L] - Tip of the Day: Enhanced Case Sensitive and Whole Word Search Options Wednesday, August 08, 2018 Tip of the Day: Enhanced Case Sensitive and Whole Word Search Options Product...: R:BASE X and R:BASE X Enterprise (Version 10) Build.: 10.0.4.10808 or higher Sections..: Database Explorer, Forms, Reports, Labels, External Forms Keywords..: Search, EEPs, Expressions, Control Properties, Case Sensitive, Whole Word Did you know the search capabilities for finding text in Custom EEPs, Control Properties, and Expressions has been enhanced to include "case sensitive" and "whole word" criteria? When searching for text in Custom EEPs, Control Properties, and Expressions, for database Forms, Reports, Labels, External Forms, and Applications, the "Find in" dialog now includes the "Match Case" and "Whole Word" options for more detailed searches. Emacs! http://www.razzak.com/tips/RBGX_FindInCustomEEPsForms_Options.png The added capability adds to the existing search capabilities built into R:BASE X/X Enterprise (Version 10) for users to locate text within the database modules and within external files, including: 01. Find in Database Explorer 02. Find in Stored Procedures 03. Find in Custom EEPs - [Ctrl] + F . Find in Form Custom EEPs . Find in Report Custom EEPs . Find in Label Custom EEPs . Find in Application Custom EEPs . Find in External Form Custom EEPs 04. Find in Control Properties - [Ctrl] + L . Find in Form Control Properties . Find in Report Control Properties . Find in Label Control Properties . Find External Form Control Properties 05. Find in Expressions - [Ctrl] + [Shift] + F . Find in Form Expressions . Find in Report Expressions . Find in Label Expressions 06. Find in Files 07. Find in R> Prompt Output From The Edge: http://www.razzak.com/fte Topic: Searching in R:BASE X and R:BASE X Enterprise (Version 10) Very Best R:egards, Razzak. https://www.rbase.com http://www.facebook.com/rbase/ -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google 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] - Arrange by
I hate it when I have used a command in the past, need it again, and can't find the documentation. There is a command to use when editing a multi table form to arrange one of the tables in a certain order. HELP. 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. For more options, visit https://groups.google.com/d/optout.
Re: [RBASE-L] - Tip of the Day: Enhanced Case Sensitive and Whole Word Search Options
I can sure see using the "whole word" search! But being me, I always test to the nth degree, and I am thrilled to announce that it works perfectly, ignoring punctuation. For example, it found the whole word even if there was parenthesis or commas around it. It located the word "BLNo" in these 2 examples I typed into a custom eep: CREATE TEMP TABLE tmpBL (BLNo Int ..) SELECT blno, bdate INTO .. Good job! Karen -Original Message- From: A. Razzak Memon To: rbase-l Sent: Wed, Aug 8, 2018 7:08 am Subject: [RBASE-L] - Tip of the Day: Enhanced Case Sensitive and Whole Word Search Options Wednesday, August 08, 2018 Tip of the Day: Enhanced Case Sensitive and Whole Word Search Options Product...: R:BASE X and R:BASE X Enterprise (Version 10) Build.: 10.0.4.10808 or higher Sections..: Database Explorer, Forms, Reports, Labels, External Forms Keywords..: Search, EEPs, Expressions, Control Properties, Case Sensitive, Whole Word Did you know the search capabilities for finding text in Custom EEPs, Control Properties, and Expressions has been enhanced to include "case sensitive" and "whole word" criteria? When searching for text in Custom EEPs, Control Properties, and Expressions, for database Forms, Reports, Labels, External Forms, and Applications, the "Find in" dialog now includes the "Match Case" and "Whole Word" options for more detailed searches. Emacs! http://www.razzak.com/tips/RBGX_FindInCustomEEPsForms_Options.png The added capability adds to the existing search capabilities built into R:BASE X/X Enterprise (Version 10) for users to locate text within the database modules and within external files, including: 01. Find in Database Explorer 02. Find in Stored Procedures 03. Find in Custom EEPs - [Ctrl] + F . Find in Form Custom EEPs . Find in Report Custom EEPs . Find in Label Custom EEPs . Find in Application Custom EEPs . Find in External Form Custom EEPs 04. Find in Control Properties - [Ctrl] + L . Find in Form Control Properties . Find in Report Control Properties . Find in Label Control Properties . Find External Form Control Properties 05. Find in Expressions - [Ctrl] + [Shift] + F . Find in Form Expressions . Find in Report Expressions . Find in Label Expressions 06. Find in Files 07. Find in R> Prompt Output From The Edge: http://www.razzak.com/fte Topic: Searching in R:BASE X and R:BASE X Enterprise (Version 10) Very Best R:egards, Razzak. https://www.rbase.com http://www.facebook.com/rbase/ -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google 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] - Tip of the Day: Enhanced Case Sensitive and Whole Word Search Options
Wednesday, August 08, 2018 Tip of the Day: Enhanced Case Sensitive and Whole Word Search Options Product...: R:BASE X and R:BASE X Enterprise (Version 10) Build.: 10.0.4.10808 or higher Sections..: Database Explorer, Forms, Reports, Labels, External Forms Keywords..: Search, EEPs, Expressions, Control Properties, Case Sensitive, Whole Word Did you know the search capabilities for finding text in Custom EEPs, Control Properties, and Expressions has been enhanced to include "case sensitive" and "whole word" criteria? When searching for text in Custom EEPs, Control Properties, and Expressions, for database Forms, Reports, Labels, External Forms, and Applications, the "Find in" dialog now includes the "Match Case" and "Whole Word" options for more detailed searches. Emacs! http://www.razzak.com/tips/RBGX_FindInCustomEEPsForms_Options.png The added capability adds to the existing search capabilities built into R:BASE X/X Enterprise (Version 10) for users to locate text within the database modules and within external files, including: 01. Find in Database Explorer 02. Find in Stored Procedures 03. Find in Custom EEPs - [Ctrl] + F . Find in Form Custom EEPs . Find in Report Custom EEPs . Find in Label Custom EEPs . Find in Application Custom EEPs . Find in External Form Custom EEPs 04. Find in Control Properties - [Ctrl] + L . Find in Form Control Properties . Find in Report Control Properties . Find in Label Control Properties . Find External Form Control Properties 05. Find in Expressions - [Ctrl] + [Shift] + F . Find in Form Expressions . Find in Report Expressions . Find in Label Expressions 06. Find in Files 07. Find in R> Prompt Output From The Edge: http://www.razzak.com/fte Topic: Searching in R:BASE X and R:BASE X Enterprise (Version 10) Very Best R:egards, Razzak. https://www.rbase.com http://www.facebook.com/rbase/ -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google 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.
