RE: [EXTERNAL] Re: [RBASE-L] - restricting a db edit to certain characters

Dan You could also look at SKEEP Buddy From: 'Tony IJntema' via RBASE-L Sent: Tuesday, June 18, 2024 9:40 AM To: rbase-l@googlegroups.com Subject: Re: [EXTERNAL] Re: [RBASE-L] - restricting a db edit to certain characters Dan, have a look at the function (SSTRIPI(source, chars

Re: [RBASE-L] - update not working

Dan  I would try putting paren around where clause asWhere ((t1.dlrnum = t2.dlrnum and t1.serial < 90) and t1.invdate is null)BuddySent from my iPhoneOn Mar 6, 2023, at 7:59 PM, Dan Goldberg wrote: I have an update command in am trying to run. I am using the newest rbase version.   upd

RE: [RBASE-L] - Number of Columns in a DB

Doug Could it be that the select sum picks up all columns in the table and list command does not include the system table columns Buddy -Original Message- From: rbase-l@googlegroups.com On Behalf Of Doug Hamilton Sent: Tuesday, January 24, 2023 11:34 PM To: R:Base List Subject: [RB

RE: [RBASE-L] - Detecting Row With Focus In Scrolling Region

Jim Wouldn’t setting a variable to the unique id when entering that row. Buddy -Original Message- From: rbase-l@googlegroups.com On Behalf Of James Burroughs Sent: Thursday, June 23, 2022 11:10 PM To: rbase-l@googlegroups.com Subject: [RBASE-L] - Detecting Row With Focus In Scrolling

Re: [RBASE-L] - Delete Trigger mystery?

Karen My first thought was primary and foreign keys with cascade. So when you delete row with primary key system deletes foreign key Buddy Sent from my iPhone > On Mar 11, 2022, at 7:01 PM, 'Karen Tellef' via RBASE-L > wrote: > >  > > Why I needed the before-delete trigger: no one

RE: [RBASE-L] - TreeBuilder

Paix 85500 Les Herbiers _ De : rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> mailto:rbase-l@googlegroups.com> > De la part de Buddy Walker Envoyé : vendredi 4 février 2022 16:03 À : rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> Objet : RE:

RE: [RBASE-L] - TreeBuilder

Jean-Marc Avez-vous envisagé de créer des points d’arrêt dans le rapport? Créez une variable vSubTotal et faites-la totaliser (calculez sur : Détail) Créez un point d’arrêt pour le chapitre, puis réinitialisez/effacez vSubToal lors de la modification localiser la variable vSubTotal

RE: [RBASE-L] - Multi-User commands Best Practices

. 100% of my commands, like the ones you list Doug, are in the startup file. That way if you want to change anything, you change one program. You don't run around and change/copy over new CFG files for every user. I never use "name" anymore, I use NetUser. Karen

RE: [RBASE-L] - Multi-User commands Best Practices

Doug I would only put those in the cfg file. I would set the NAME in RBASE.DAT like this SET VAR vUserName = (CVAL(‘NETUSER’)) SET NAME &vUserName I would then make sure the RBASE.DAT AND rbase CFG file were located in same folder as the rbase EXE Make sure there a

RE: [RBASE-L] - How to navigate to a specific table row and display it on a form

Jim I would prefer using DIALOG to get the date then based on date use CHOOSE which would return uniqueID for that row. Then EDIT USING formName WHERE UniqueID = .vUniqueID If user didn't choose anything then using DIALOG ask if they want to add a row if yes then ENTER USING formName

RE: Re[2]: [RBASE-L] - Ampersanding in the Dark

Bruce I believe you are using the & wrong when setting up the string. To concantenate the string the & indicates a space Added vyearStart as integer which I assume is the 4 digit you are setting I commented out two variables don’t need them unless you are using them elsewher

RE: [RBASE-L] - How to copy from a DBGrid cell?

Doug I haven't tried this but have you tried the GETPROPERTY for the grid GETPROPERTY 'SELECTEDVALUES[NNN]' 'varname' Have an variable edit control for the getproperty varname then copy to clipboard. Buddy -Original Message- From: rbase-l@googlegroups.com On Behalf Of Doug Hamil

RE: [RBASE-L] - Pre-selected list view/box

t I'm trying to find out how to do Karen -Original Message- From: Buddy Walker mailto:walker.bu...@comcast.net> > To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> Sent: Tue, Sep 7, 2021 4:29 pm Subject: RE: [RBASE-L] - Pre-selected list view/b

RE: [RBASE-L] - Pre-selected list view/box

Should be .vST not .vStat You could also use that as a WHERE clause From: rbase-l@googlegroups.com On Behalf Of Buddy Walker Sent: Tuesday, September 7, 2021 5:25 PM To: rbase-l@googlegroups.com Subject: RE: [RBASE-L] - Pre-selected list view/box Karen Compare the schedid

RE: [RBASE-L] - Pre-selected list view/box

Karen Compare the schedid to variable using IN. Variable would have to have () around the values and since they are integer you shouldn’t need quotes around each value SET VAR vST TEXT = (‘(‘ + .vST + ‘)’) IF SchedID IN .vStat THEN X ELSE Y EN

RE: [RBASE-L] - Variable Not Defined

Charles Have you tried CHKVAR checks to see if variable name exists Buddy From: rbase-l@googlegroups.com On Behalf Of Charles Stevens Sent: Sunday, September 5, 2021 4:42 PM To: RBASE-L Subject: [RBASE-L] - Variable Not Defined What would be the best way to identify a variable as

RE: [RBASE-L] - UPDATE a column WHERE a dot is missing in the end?

913-915-3137 From: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> mailto:rbase-l@googlegroups.com> > On Behalf Of Buddy Walker Sent: Saturday, July 3, 2021 1:53 PM To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> Subject: RE: [RBASE-L] - UPD

RE: [RBASE-L] - UPDATE a column WHERE a dot is missing in the end?

Bo If all else fails then try looping through table with declare cursor I’m assuming there could be a dot anywhere in the column but you also need one at the end. Buddy ---Code Starts Here SET VAR vColValue TEXT SET VAR vColLength INTEGER SET VAR vDot = ('.') DECLARE

RE: [RBASE-L] - Increment letters

Dan Try this SET VAR vStart TEXT = ('12345C') SET VAR vGetNumber TEXT = (SKEEPI(.vStart,'1234567890')) SET VAR vGetLetter TEXT = (SKEEPI(.vStart,'ABCDEFGHIJKLMNOPQRSTUVWXYZ')) SET VAR vIChar = (ICHAR(.vGetLetter)) SET VAR vNxtChar = (.vIChar + 1) SET VAR vNxtLetter = (CHAR(.vNxtChar)

Re: [RBASE-L] - Formatting a Phone Number in an Enhanced DB Grid

Myron Maybe I’m missing something but is there a reason you want the format saved in the table. Since it is easy to format in forms and reports. I would store the number as integer. This way only numbers would be stored. Buddy Sent from my iPhone > On Apr 7, 2021, at 12:01 PM, Myron wro

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 >

RE: [RBASE-L] - new to drag and drop

on Systems People Friendly Since 1990 From: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> mailto:rbase-l@googlegroups.com> > On Behalf Of Buddy Walker Sent: Monday, January 18, 2021 4:38 PM To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> Subject: RE:

RE: [RBASE-L] - new to drag and drop

Jim Right click on DBGrid then enable Drag and Drop should be near the bottom. You will see Start Drag (EEP) and Drop Drag (EEP) Buddy From: 'Jim Belisle' via RBASE-L Sent: Monday, January 18, 2021 5:05 PM To: rbase-l@googlegroups.com Subject: [RBASE-L] - new to drag and drop I am

RE: [RBASE-L] - convert text to time data type

Dan You could create another column newTimeCol and set it to time UPDATE table SET newTimeCol = oldTextCol This should work as long as each row has AM or PM in it You could also just change the column from text to time. This may caused problems with reports/forms etc.

Re: [RBASE-L] - Report output to Excel

Karen What I have done in the past was to open Notepad then highlight the column of numbers and cut and paste them into Notepad. Highlight and copy them from Notepad paste them back to Excel column. Buddy Sent from my iPhone > On Dec 29, 2020, at 10:24 AM, 'Karen Tellef' via RBASE-L > wr

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

RE: [RBASE-L] - rmail anomaly

r/password changed on the server, then all his programs would fail, not just this one Jim: You don't have user/PW hard-coded into the RMail code, do you? Assume you use just the one CFG file? Karen -Original Message----- From: Buddy Walker mailto:walker.bu...@comcast.net

RE: [RBASE-L] - rmail anomaly

Jim I would think the user and/or password you are using to send from your applications has changed on the outlook server Buddy From: 'Jim Belisle' via RBASE-L Sent: Monday, December 7, 2020 1:08 PM To: rbase-l@googlegroups.com Subject: [RBASE-L] - rmail anomaly We use RMAIL X5 a

RE: [RBASE-L] - VB: Problem with R>AUTOCHK FULL

: SV: [RBASE-L] - VB: Problem with R>AUTOCHK FULL Yeas, but I only got the structure of my base, no rows. Have not used the RELOAD command for many years. Y s Bo Franzén _ Från: rbase-l@googlegroups.com mailto:rbase-l@googlegroups.com> > för Buddy Walker mailto:

Re: [RBASE-L] - VB: Problem with R>AUTOCHK FULL

Bo Have you tried reloading the data base Buddy Sent from my iPhone > On Nov 7, 2020, at 2:53 PM, Bo Franzén wrote: > >  > > > > > Från: Bo Franzén > Skickat: den 7 november 2020 20:48 > Till: RBASE-L Mailing List > Ämne: Problem with R>AUTOCHK FULL > > Dear R:BASE, > > > > Hello

RE: [RBASE-L] - PDF form generation problems

On Saturday, October 24, 2020, 10:20:28 AM EDT, Buddy Walker <mailto:walker.bu...@comcast.net> wrote: Patti How is the variable being populated. Look up from another table, column in report table. If it is being looked up in another table make sure it is being done i

RE: [RBASE-L] - PDF form generation problems

To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - PDF form generation problems It's in the Detail band. Patti On Friday, October 23, 2020, 3:27:04 PM EDT, Buddy Walker mailto:walker.bu...@comcast.net> > wrote: Patti What band is the date in (PH, D etc) and

RE: [RBASE-L] - PDF form generation problems

Patti What band is the date in (PH, D etc) and when the variable is being created in what band Buddy From: 'Patti Jakusz' via RBASE-L Sent: Friday, October 23, 2020 2:09 PM To: rbase-l@googlegroups.com; RBASE-L Subject: [RBASE-L] - PDF form generation problems Hello all, We

RE: [RBASE-L] - using choose in where clause

Dan I wanted to mention that if your selections contain spaces it may break. If possible I would return a unique ID from the choose process. Buddy From: rbase-l@googlegroups.com On Behalf Of Buddy Walker Sent: Friday, October 16, 2020 1:20 PM To: rbase-l@googlegroups.com Subject: RE

RE: [RBASE-L] - using choose in where clause

Dan I believe what you need to do once selection is made is to enclose the vpartprefix open and close paren and then use the & instead of the . SET VAR vpartprefix = (‘(‘ + .vpartprefix + ‘)’) EDIT USI FormName WHERE colname IN &vpartprefix Buddy From: rbase-l@googlegroups.co

RE: [RBASE-L] - Debug command while in application

Jim You may want to check before adding parts to the TO location to make sure it doesn’t already exist. As to the cause it almost seems like a USER maybe exiting R:Base without letting the code to complete or it could be a certain work station is losing connection. Buddy From: 'Jim

RE: [RBASE-L] - Enhanced Variable calendar

Karen Place a radio group on form asking if optional date is needed I would set NO as the default selection. In the After FORM Start EEP you would have PROPERTY OptCalEnhCal ENABLED ‘FALSE’ Or PROPERTY OptCalEnhCal VISIBLE ‘FALSE’ You could also use VISIBLE true

Re: [RBASE-L] - Variable Forms | Clearing Values within EEPs.

> +011 (909) 238-9012 c > +011 (909) 912-8678 f > > > -- Original Message -- > From: "Buddy Walker" > To: rbase-l@googlegroups.com > Sent: 7/5/2020 4:43:38 PM > Subject: Re: [RBASE-L] - Variable Forms | Clearing Values within EEPs. > &

Re: [RBASE-L] - Variable Forms | Clearing Values within EEPs.

Bruce Have you tried RECALC VAR after settling them to null and before the setfocus Buddy Sent from my iPhone > On Jul 5, 2020, at 6:24 PM, Bruce Chitiea wrote: > >  > RGBX5E Current > > Fairly new to Forms. > > A Variable Form provides values to an On Click EEP in a Bit Button. The EEP

RE: [RBASE-L] - Forms

Thanks another option forgot about that one Buddy From: rbase-l@googlegroups.com On Behalf Of Michael Byerley Sent: Saturday, July 4, 2020 10:31 AM To: RBASE-L Subject: Re: [RBASE-L] - Forms RHIDE On Saturday, July 4, 2020 at 10:15:02 AM UTC-4, Buddy Walker wrote: Karen

RE: [RBASE-L] - Forms

on after a "closewindow", other than following it with a "return". Makes sense if you think of it, it wouldn't be able to do the next line of code ("edit using myreportsmenu") if the form had actually closed upon your closewindow command. Karen

[RBASE-L] - Forms

Maybe I'm missing something but forms are not closing when I use CLOSEWINDOW This happens on RBase forms and External Forms Windows 10 pro R:Base XE (current version) I'm using a Speed Button on the forms and on click EEP FORMS myMainMenu or myMainMenu.RFF form has various speedbut

RE: [RBASE-L] - DB Edit Field - Change the field background color based on the value in the field

Myron I believe you need quotes around the variable name in GETPROPERTY. Buddy SET VAR vwho TEXT = 'Y' GETPROPERTY dbwho TEXTVALUE 'vWho' IF vWho IS NULL THEN RETURN ENDIF IF vwho = 'Y' THEN PROPERTY dbwho COLOR 'Blue' ELSE PROPERTY dbwho COLOR '

Re: [RBASE-L] - Function: Text "Number" to Integer Value

Bruce Did you try SET VAR vintegervalue INT = .vtextnimbervalue Buddy Sent from my iPhone > On May 17, 2020, at 3:21 PM, Bruce Chitiea wrote: > >  > All: > > Is there a single R:BASE function that'll convert a text "number" to an > integer value? > > It would replace this: > > SET VA

RE: [RBASE-L] - exporting to Excel with fixed column width

Mohammed You may want to try creating a blank worksheet with column settings (width, currency, text, etc.). Once you have this done save the worksheet where everyone has access to it. Then before your export, copy the blank worksheet with a different name then export to it. Buddy Fro

RE: [RBASE-L] - COPY command using SELECT?

Jim I assuming vfilename and vdirectoryfilename has the full path and filename I would do something like this Buddy ---Begin Here SET VAR vfilename TEXT = NULL SET VAR vdirectoryfilename TEXT = ('newFolderName') SET VAR vdocopy TEXT = NULL DECLARE c1 CURSOR FOR SELECT filena

RE: [RBASE-L] - UPDATE Anomaly

Bruce Maybe I’m missing something but it appears to me that you are trying to update glcodeid but in your where clause you are getting the same thing WHERE t1.glcodeid = t2.glcodeid Buddy From: rbase-l@googlegroups.com On Behalf Of Bruce Chitiea Sent: Wednesday, April 15, 2020 11:

Re: [RBASE-L] - capture just the decimal

Using the vdouble SET VAR vsomething int = (sloc(ctxt(.vdouble)),’.’,0) If vsomething is not 0 then it found the decimal I’m doing this from my phone and memory. Buddy Sent from my iPhone > On Mar 17, 2020, at 10:13 AM, 'Karen Tellef' via RBASE-L > wrote: > >  > Admittedly this is a bit

Re: [RBASE-L] - capture just the decimal

Have you looked at SLOC Sent from my iPhone > On Mar 17, 2020, at 10:03 AM, Jim Belisle wrote: > >  > What is the function or combination of functions that will give me just to > decimal portion of a numeric number? > I want to use the decimal portion to determine my next action. > > James

RE: [RBASE-L] - R:Base & DFS?

Jim Have you looked at the MIRROR setting. Buddy From: rbase-l@googlegroups.com On Behalf Of Jim McPherson Sent: Monday, March 2, 2020 4:34 PM To: rbase-l@googlegroups.com Subject: [RBASE-L] - R:Base & DFS? All, I’m considering taking our R:Base share and replicating it as p

RE: [RBASE-L] - Sending text messages?

Doug Depending on the cell phone carrier sent an email message to the phone number. This list was compiled years back so I’m not sure how current it is. I know the Comcast still works but not sure about the others. The “TO” line would look like412...@vtext.com

RE: [RBASE-L] - Long embedded files in RMail

up a cursor thru every row in the table and write each column one at a time I'm also wondering if it's the email client that's responsible for deciding where to wrap a row when the user receives the email. Karen -Original Message- From: Buddy Walker mail

RE: [RBASE-L] - Long embedded files in RMail

the only way to get data from a table into an Rmail body is to output it to a text file (as far as I know) So whether you do: output test.txt select Col1, Col2, Col3... Col10 FROM table output screen or output test.txt select NoteColumn FROM table output screen It's sti

RE: [RBASE-L] - Long embedded files in RMail

10 FROM table WHERE. Karen -----Original Message- From: Buddy Walker mailto:walker.bu...@comcast.net> > To: rbase-l mailto:rbase-l@googlegroups.com> > Sent: Mon, Dec 16, 2019 1:44 pm Subject: RE: [RBASE-L] - Long embedded files in RMail You select the information into a variabl

RE: [RBASE-L] - Long embedded files in RMail

basically what I'm doing now. Or is there another way to get a "select" statement as the body of an email? Karen -Original Message- From: Buddy Walker mailto:walker.bu...@comcast.net> > To: rbase-l mailto:rbase-l@googlegroups.com> > Sent: Mon, Dec 16,

RE: [RBASE-L] - Long embedded files in RMail

Karen Instead of creating text files I would create a Temporary Table IDcolumn and either NoteColumn or VarCharColumn. Depending on size of body data. Insert info into Temp table Then when you select the body for your email you will select NoteColumn/VarCharColumn as your body base on

RE: [RBASE-L] - PROPERTY Command Using Variable Toggle?

Jim you could use and ampersand before the variable and instead of a dot. This will cause the variable to execute. SET VAR vDoProperty TEXT = NULL SET VAR vQuotes = (CVAL(‘QUOTES’)) SET VAR MenuPerm TEXT = NULL SELECT MenuPerm INTO PropertyTest FROM AccessLevel WHERE Level = .vAcce

RE: [RBASE-L] - error in rpt expression

Jim I seems like you may be defining the variable(s) “before design report” and that would also explain why no error when you run your code after designing report Buddy From: rbase-l@googlegroups.com On Behalf Of Jim Belisle Sent: Monday, November 11, 2019 11:28 AM To: rbase-l@google

Re: [RBASE-L] - Ghost form

Jan The first thing I would do is make a copy of the database then reload it to see if that clears up the duplicate form. Buddy Sent from my iPhone > On May 9, 2019, at 9:40 AM, jan johansen wrote: > > Group, > > Somehow I ended up with 2 forms with the same name. > I can remove one but

RE: [RBASE-L] - RE: SCRATCH

Jim Locate the RBEngine*.CFG file. Make sure the CFG file has SCRATCH C:\TEMP and not SCRATCH TMP Buddy From: rbase-l@googlegroups.com On Behalf Of Jim Belisle Sent: Thursday, April 25, 2019 2:46 PM To: rbase-l@googlegroups.com Subject: [RBASE-L] - RE: SCRATCH I am so

RE: [RBASE-L] - SCRATCH

Jim I always kept the folder clean. TEMP or TMP meant just that. I would clean the folder up every day. A lot of files could also slow things down. Could you ask your IT people to exclude files with $$$ extensions. Buddy From: rbase-l@googlegroups.com On Behalf Of Jim Belisl

Re: [RBASE-L] - Rbase_form Print options?

Karen If the form is that large couldn’t you creat a report that looks like the form. Just save changes before printing. Sent from my iPhone > On Apr 20, 2019, at 9:15 AM, 'Karen Tellef' via RBASE-L > wrote: > > I want to put a "print this form" button on a very large form to send a > pri

RE: [RBASE-L] - The current R:BASE build is incompatible with the database files.

Make a copy of the database you cannot connect and then try connecting to the copy. If you are able to connect then someone or server has the database locked. Buddy From: rbase-l@googlegroups.com On Behalf Of MD Sent: Saturday, April 6, 2019 12:11 AM To: rbase-l@googlegroups.com Subj

Re: [RBASE-L] - when email is not correct

Jim I don’t think that is a RMail issue. Most email servers will not respond to bad email addresses. The main reason is this would verify email server exists. Buddy Sent from my iPhone > On Apr 5, 2019, at 5:41 PM, Jim Belisle wrote: > > We use Rmail working with the Outlook365 STMP. >

RE: [RBASE-L] - finding views containing certain tables

Jim What I do is create a RMD file with all the views. Then you can search the RMD file for a specific table, plus you have a file with your views just in case you have to re-create one or all. OUT AllMyViews.RMD ; UNLOAD STRUC FOR VIEWS ; OUT TERM Buddy From: rbase-l@googlegr

RE: [RBASE-L] - Working with external databases

e. Where would I add the userid and password on the SCONNECT command? Javier, Javier Valencia, PE O: 913-829-0888 C: 913-915-3137 From: <mailto:rbase-l@googlegroups.com> rbase-l@googlegroups.com [ <mailto:rbase-l@googlegroups.com> mailto:rbase-l@googlegroups.com] On

RE: [RBASE-L] - Working with external databases

Javier Is it access rights. You may need a user (uid) and password (psw). Buddy From: rbase-l@googlegroups.com On Behalf Of javier.valen...@vtgonline.com Sent: Monday, February 11, 2019 1:58 AM To: rbase-l@googlegroups.com Subject: [RBASE-L] - Working with external databases I

RE: [RBASE-L] - How to add Find Button on button toolbar of Print report.

Rehan Have you tried printing report directly to a PDF and then the “Ctrl+F” should work?? Buddy From: 'rehan wyne' via RBASE-L Sent: Monday, February 4, 2019 4:38 AM To: rbase-l@googlegroups.com Subject: [RBASE-L] - How to add Find Button on button toolbar of Print report. I

Re: [RBASE-L] - changing a column's length?

Lin Make sure the length of the computed column is at least the same as the total length of the two columns. Also make sure the concatenated column name isn’t in any other table if so the length has to be the same. Buddy Sent from my iPhone > On Nov 17, 2018, at 8:43 PM, Lin MacDonald wr

RE: [RBASE-L] - edit using form child table where clause

Dan Have you tried something like this EDIT using formname where parentNameColumn in (SELECT parentNameColumn FROM childTable where childColumn = value) Buddy From: rbase-l@googlegroups.com On Behalf Of Dan Goldberg Sent: Tuesday, September 25, 2018 1:13 PM To: rbase-l@googl

Re: [RBASE-L] - problems with forms not saving

Randy I believe that is by design not to save changes when firm is opened in design mode Buddy Sent from my iPhone > On Sep 9, 2018, at 11:52 AM, Randy Larsen wrote: > > I just started having a problem with Forms not saving changes. When i click > on the save icon (disk) nothing happens.

RE: [RBASE-L] - Easy Way to Add Conditions to Report?

Cathy If I understand you right why not create a view with your 3 conditions and then base the report on the view. This way all you have to do is print report without where clause. If you wanted an additional condition like from only from specific city you would PRINT reportName WHERE C

RE: [RBASE-L] - using user IDs and passwords for RBASE

@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 <mailto:rbase-l@googlegroups.com> Subject: RE: [RBASE-L] - using user IDs and passwords for RBASE Jim Each user will need there own

RE: [RBASE-L] - using user IDs and passwords for RBASE

legroups.com> [mailto:rbase-l@googlegroups.com] On Behalf Of Buddy Walker Sent: Saturday, August 4, 2018 10:02 AM To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> Subject: RE: [RBASE-L] - using user IDs and passwords for RBASE Jim Use the CVAL(‘USER’) and CVAL(

Re: [RBASE-L] - using user IDs and passwords for RBASE

; 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@goo

RE: [RBASE-L] - using user IDs and passwords for RBASE

Jim Use the CVAL(‘USER’) and CVAL(‘NETUSER’) If CVAL(‘USER’) <> CVAL(‘NETUSER’) THEN PAUSE 2 USI ‘Not Authorized’ EXIT ENDIF Just make sure the CFG name matches the Network User Name. This way you won’t have to worry about R:Base password Windows should handle everythi

Re: [RBASE-L] - Picking and Renaming Windows Files

rom my iPhone > > On Aug 1, 2018, at 1:03 PM, Buddy Walker wrote: > > Claudine > Since you have commas in the file I would think you have to load the table > instead of insert. > > Buddy > > > From: rbase-l@googlegroups.com On Behalf Of > Claudine

RE: [RBASE-L] - Picking and Renaming Windows Files

Claudine Since you have commas in the file I would think you have to load the table instead of insert. Buddy From: rbase-l@googlegroups.com On Behalf Of Claudine Robbins Sent: Wednesday, August 1, 2018 1:21 PM To: rbase-l@googlegroups.com Subject: [RBASE-L] - Picking and Renaming W

RE: [RBASE-L] - Dropping a default?

Karen ALTER TABLE tblName ALTER colName DROP DEFAULT Buddy From: karentellef via RBASE-L Sent: Tuesday, May 22, 2018 11:26 AM To: rbase-l@googlegroups.com Subject: [RBASE-L] - Dropping a default? Is there a way to drop a column's default value in code?We have a routine that

RE: [RBASE-L] - Does Table exist?

I think doing a COUNT(*) FROM SYS_TABLES is the best way to check for an existing table. With that being said and you truly want to delete/drop a TEMPORARY table then recreate it I would just turn the error message off and drop the table then turn the error message back on. SET ERROR MES

RE: [RBASE-L] - IT update and problem

Jim I had the same problem a couple of months ago. It was from a Windows 10 Pro Update. Had to keep contacting John as well. It turned out when I did a shutdown it would not shutdown it would go through like a restart. When it did that I lost the R:Base registration. If I would do an actual r

RE: [RBASE-L] - 2 page report in Rbase X

Kayza Reports > Breaks > From the dropdown select the uniqueID and click Add Check box for "Start New Page" Note: this will sort the report based on the uniqueID Buddy -Original Message- From: rbase-l@googlegroups.com On Behalf Of Kayza Kleinman Sent: Wednesday, April 25, 2

RE: [RBASE-L] - RBase 101

om] On Behalf Of Buddy Walker Sent: Saturday, April 21, 2018 2:19 PM To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> Subject: RE: [RBASE-L] - RBase 101 Claudine It could be index corruption. Any time that has happened to me a reload or pack would fix it.

RE: [RBASE-L] - RBase 101

Claudine It could be index corruption. Any time that has happened to me a reload or pack would fix it. If company_name is indexed you could just try packing the indexes. Buddy From: rbase-l@googlegroups.com On Behalf Of Claudine Robbins Sent: Saturday, April 21, 2018 3:1

RE: [RBASE-L] - 2 page report in Rbase X

Kayza The best way I have found to do this is to use regions and checkbox. The regions can be set to expand based on the region before. Buddy From: rbase-l@googlegroups.com On Behalf Of Kayza Kleinman Sent: Wednesday, April 18, 2018 12:24 AM To: rbase-l@googlegroups.com Subject: R

RE: [RBASE-L] - gateway export to xlsx

Dan Try changing GATEWAY EXPORT XLS Customers_123.xls to GATEWAY EXPORT XLSW Customers_123.xlsx If you want a small file you could trying exporting to CSV then have Excel open the csv file. Buddy From: rbase-l@googlegroups.com On Behalf Of Dan Goldberg Sent: Thu

RE: [RBASE-L] - Form DB Table change?

Randy Copy original form to a new form name and select the new table. Be sure all fields located on the form are in the new table. Once you are satisfied then delete the original form and then rename the copied form to the original form name. Buddy -Original Message- From: rbase-l

RE: [RBASE-L] - DIRTYVAR

Jan Check to see if the variable exists first SET VAR vChkVar = (CHKVAR(' RBTI_FORM_DIRTYVAR ')) --1 = exists --0 = does not exists IF vChkVar = 1 THEN IF RBTI_FORM_DIRTYVAR = 1 THEN SAVEROW ENDIF ENDIF CLOSEWINDOW Bud

RE: [RBASE-L] - Formatting OUTPUT

oups.com> [mailto:rbase-l@googlegroups.com] On Behalf Of Buddy Walker Sent: Saturday, February 24, 2018 12:11 PM To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> Subject: RE: [RBASE-L] - Formatting OUTPUT Claudine I think you are going to have to loop through the table. See

RE: [RBASE-L] - Formatting OUTPUT

oups.com> [mailto:rbase-l@googlegroups.com] On Behalf Of Buddy Walker Sent: Friday, February 23, 2018 10:45 PM To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> Subject: RE: [RBASE-L] - Formatting OUTPUT Claudine Are you doing an unload data from a table and a

RE: [RBASE-L] - Formatting OUTPUT

Claudine Are you doing an unload data from a table and all of the data is in one column. If so it will quote the text with single quote because of the space. The character that looks like a right arrow could be the EOFCHAR. Can you show the code you are using for output either ASCII

RE: [RBASE-L] - Text file that retains trailing blank space

James I have a file that contains the use of SFIL and SPUT. I used this to provide a class listing to a health insurance company. It's about 11 years old but I think it should still work. Buddy -Original Message- From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Be

RE: [RBASE-L] - Lost rows

Dick Have you re-loaded/packed the database recently. I would suggest pack keys for the table in question. It could be the index is corrupt and the row is not really deleted. If the row is actually deleted I would suggest putting an On Before DELETE trigger on the table. This way you could

RE: [RBASE-L] - File location

Jan I would just elect to use the UNC for everyone, provided the UNC path to the home folder is the same (the only difference is the home folder name). The other way would be to just create a table with the user name and path to the home folder. The other problem would be if you are accessing

RE: Re[4]: [RBASE-L] - Disaster Avoidance: SRPL Syntax Question

at only the 'V' character value would be affected. Thanks Bruce -- Original Message -- From: "Buddy Walker" mailto:walker.bu...@comcast.net> > To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> Sent: 1/14/2018 1:30:08 PM Subject: RE:

RE: Re[2]: [RBASE-L] - Disaster Avoidance: SRPL Syntax Question

Bruce Maybe I’m missing something but you could have used the function ULC if “V” was the only alpha character in the field UPDATE tableNameHere SET columnName = (ULC(columnName)) WHERE if you need it. Buddy From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Beha

RE: [RBASE-L] - Elapsed time in HH:MM format

David You could give this code a try. I'm allowing that check in and check out could be different days. Buddy *Code Starts Here* CLEAR ALL VAR SET TIME FORMAT 'HH:MM' SET VAR vchkin DATETIME = '01/12/2018 21:25' SET VAR vchkout DATETIME = '01/13/2018 01:45' --S

RE: [RBASE-L] -

Jim You could also look into Visual Studio (version 2013 through 2017 work). I have used them with Oterro was also able to tie into PayPal. Buddy From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of Jim Belisle Sent: Thursday, January 4, 2018 4:45 PM To: rba

[RBASE-L] - Phishing

I just received an email from rbase-l@googlegroups.com wishing me a Merry Christmas and it has an e-card attached. I didn’t click on and would suggest if you received this don’t click on it. It was 1. delivered to my in box instead of my R:Base fold

RE: [RBASE-L] - One last question, if possible

Cathy I believe the date will change when everyone is disconnected from the database. Also I would be careful about forcing a new date because R:Base may see this as the database being out of SYNC. The auto backup looking at dates may not backup up all 4 database rx files. I would s

  1   2   3   >