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

Hi, Dan: Not to elegant, but this will work, try it. Regards, Jim    ---   VALIDATE THE PART NUMBER   ---     CHAR BY CHAR    ---   06-17-24    CLSLABEL START   SET VAR VF_TEXT = NULL   SET VAR VF_MSG  - TEXT    DIALOG 'Enter Part Number -or-  Type ''END'' to exit ' VF_TEXT= 20 vEndKey 1    SET

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

Karen: When using rbed on a file, do a right click on the rstyle icon, and check the 'error messages' option at the bottom. Should work.Jim On Wednesday, May 15, 2024 at 05:56:38 PM EDT, Bruce Chitiea wrote: Within RBEdit ten-five and eleven, see "View" on the top-of-screen command

Re: [RBASE-L] - Version 11

Tom: Just a quick thought.check the var name and make sure it is not on the reserved word list. On Tuesday, April 30, 2024 at 02:28:27 PM EDT, Tom Hart wrote: I have been running the same compiled app for 10+ years with no problem, but after upgrading to 11 I have found a few

Re: [RBASE-L] - Disappearing text

t someone else designed this app, and to track down the myriad of settings is quite the process.    If I knew a particular setting that might cause this to happen, I could search for it! Karen On Monday, April 22, 2024 at 09:21:38 AM CDT, 'jim schmitt' via RBASE-L wrote: Karen: do y

Re: [RBASE-L] - Disappearing text

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, PESent from my T-Mobile 4G LTE Device -------- Original message From: 'jim schmitt' via RBASE-L Date: 4/21/

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

Re: [RBASE-L] - Disappearing text

Karen: If the form with the problems (lets call if form 2) is called from another form (form 1), and their is a 'timer' on form1, when the timer goes off , the fields on form2 will disappear.   I had this happen recently. Maybe you are having the same problem. Jim On Sunday, April 21, 2024

Re: [RBASE-L] - CVAL CONNECTIONS

who have either not logged out, or exited ungracefully so as to not post a log-out time.   This just happened 10 minutes ago – the BOSS was on the program!   All the best!   Steve     From: 'jim schmitt' via RBASE-L Sent: Tuesday, April 2, 2024 6:05 PM To: rbase-l

Re: [RBASE-L] - CVAL CONNECTIONS

' via RBASE-L Sent: Tuesday, April 2, 2024 2:23 PM To: 'jim schmitt' via RBASE-L Subject: Re: [RBASE-L] - CVAL CONNECTIONS   What I've noticed (within my non-network-understanding limits) is that the connections don't necessarily decrease when they exit RBase, but rather when they log out

Re: [RBASE-L] - CVAL CONNECTIONS

' via RBASE-L wrote: Hello, group: i am using cval('connections') in a backup routine to test and insure that all users are out of the system before starting the backup. Some of my users appear to have more connections than they have computers.One user who has 1 three user network had 26

[RBASE-L] - CVAL CONNECTIONS

Hello, group: i am using cval('connections') in a backup routine to test and insure that all users are out of the system before starting the backup. Some of my users appear to have more connections than they have computers.One user who has 1 three user network had 26 connections.  Does the

Re: [RBASE-L] - email novice problems

+ |EMAIL_FROM_ADDRESS + |EMAIL_SUBJECT + |EMAIL_BODY + |EMAIL_DELETE_AFTER_SEND ON + |EMAIL_SHOW_DIALOG OFF On Friday, November 10, 2023 at 04:52:49 PM CST, 'jim schmitt' via RBASE-L wrote: Greeting fellow R:base users: You may be able to offer some

Re: [RBASE-L] - email novice problems

Boston Division + |EMAIL_FROM_ADDRESS + |EMAIL_SUBJECT + |EMAIL_BODY + |EMAIL_DELETE_AFTER_SEND ON + |EMAIL_SHOW_DIALOG OFF On Friday, November 10, 2023 at 04:52:49 PM CST, 'jim schmitt' via RBASE-L wrote: Greeting fellow R:base users: You

Re: [RBASE-L] - email novice problems

vfilename TEXT = ‘complete location_1031.PDF’ |EMAIL_ATTACHMENTS Try something like this and see what happens.   Jim     From: 'jim schmitt' via RBASE-L Sent: Friday, November 10, 2023 4:53 PM To: rbase group Subject: [RBASE-L] - email novice problems   | | CAUTION:This

[RBASE-L] - email novice problems

Greeting fellow R:base users: You may be able to offer some blues clues for me.This is my first attempt at trying to send a report via email: Using RB Version X5E  10.5.4 20646 Tried using Razzak's sample in RRBYW20 - code listed below: PRINT Invoice WHERE TransID = 1031 +OPTION PDF|FILENAME

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

? Has windows been upgraded? If so defaults might not be the same. Good luck, Alastair. On 26/06/2023 15:59, 'jim schmitt' via RBASE-L wrote: Thanks, Alastair: Yes, there are three spaces in the VF_TO variable, but isn't the 'cannot open source file' referring to the 'C:\UBILL\*.*'

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

a space, just before AM - possibly due to date/time format change. Filenames with spaces need to be in double quotes  for system copy. Rwgards. Alastair. On 26/06/2023 15:01, 'jim schmitt' via RBASE-L wrote: Good Moring, group: I have a Utility Billing program running at several

[RBASE-L] - form problem

Hello group - good day to all: Just ran into a problem with one of my main menu forms.When I tried to bring it up for an edit, the screen was all white and the form did not appear on the screen. when clicking on forms, under database explorer,  and  Looking up the associated table for the form,

Re: [RBASE-L] - leading zeros and excel gateway file

than a work book (XLSW) retains leading zeros Karen -Original Message- From: 'jim schmitt' via RBASE-L To: rbase group Sent: Mon, Feb 6, 2023 12:19 pm Subject: [RBASE-L] - leading zeros and excel gateway file Hello, Group: I am transfering a data file using the gateway command

[RBASE-L] - leading zeros and excel gateway file

Hello, Group: I am transfering a data file using the gateway command, and two of the fields which are text and have a leading zero ('0602', '0605').When I use the gateway command, everything is fine, except the two fields with leading zeros in the csv file have dropped the leading zeros (which

Re: [RBASE-L] - Happy Holidays from R:BASE Technologies

To the Dream Team, Razzak, John, Donna, Rafee, et all. No one could have done it better     Thanks for being there when we need you. We appreciate you more than you know !   Happy New Year and best wishes to your and your families, and all R:base users.. Jim and Val / Ohio Software Services

[RBASE-L] - out of dynamic space epilog

Thanks to Karen, Razzak, Randy, Mark, Nicky, and Rehan for their great suggestions to my clients 'OUT OF DYNAMIC SPACE' problem. I dialed in to the client, and tried to do a Reload and Pack, but it blew up.Next, I copied the db and files to my computer, and did a Reload and Pack - worked great,

Re: [RBASE-L] - out of dynamic space II

-Original Message- From: 'jim schmitt' via RBASE-L To: rbase group Sent: Mon, Dec 26, 2022 12:54 pm Subject: [RBASE-L] - out of dynamic space II Hello again to all: Could 'out of dynamic space ' mean there is no more room on the server ? Here are the server drives:  i believe 'P

[RBASE-L] - out of dynamic space II

Hello again to all: Could 'out of dynamic space ' mean there is no more room on the server ? Here are the server drives:  i believe 'P' is a copy of 'S', as it is exactly same sizes. H dive                    S drive (production)        P driveused 83.0 GB        USED 429 gb         

[RBASE-L] - out of dynamic space

Good Day to all: A client called today with a minor problem, version X5E and on a server,; when I dialed in and connected to them and attempted to run the application, I received an error of:  'INTERNAL ERROR  -  out of dynamic space'.   i have never experienced this error. and am at a

Re: Re[2]: [RBASE-L] - DOS command line prompt

+011 (909) 238-9012 m | rby...@safesectors.com   -- Original Message --From: "'jim schmitt' via RBASE-L" To: "'Karen Tellef' via RBASE-L" Sent: 3/22/2022 5:48:28 PMSubject: Re: [RBASE-L] - DOS command line prompt Karen: WOW   !!!   Just wanted to say thanks again as th

Re: [RBASE-L] - DOS command line prompt

e.  Either have the batch file permanently there or you can create the batch file on the fly if you want it dynamic Karen -Original Message----- From: 'jim schmitt' via RBASE-L To: rbase group Sent: Tue, Mar 22, 2022 2:00 pm Subject: [RBASE-L] - DOS command line prompt Hello, gro

[RBASE-L] - DOS command line prompt

Hello, group: I have an application in which I need to find the names of some CSV payment files.  The payment files are composed of the word 'PAYMENTS_' followed by the date in 'MMDD format.  ie. 'PAYMENTS_20220302.CSV', or 'PAYMENTS_20220310.CSV'.  I have been playing around with the DIR

Re: Re[2]: [RBASE-L] - Capture a file Name possible

d Ave #272 | Claremont CA 91711-4716 | usarby...@safesectors.com | +011 (909) 238-9012 c | +011 (909) 912-8678 f -- Original Message --From: "'jim schmitt' via RBASE-L" To: rbase-l@googlegroups.comSent: 7/26/2021 8:46:41 AMSubject: Re: [RBASE-L] - Capture a file Name possible

Re: [RBASE-L] - Capture a file Name possible

'directory' -Original Message- From: 'jim schmitt' via RBASE-L To: rbase-l@googlegroups.com Sent: Mon, Jul 26, 2021 10:46 am Subject: Re: [RBASE-L] - Capture a file Name possible Hi, Tony , Thanks for the speedy reply , but there will be only one PAYMENTScsv file each day, and I

Re: [RBASE-L] - Capture a file Name possible

\supplier recordsand invoices' Karen -Original Message- From: 'jim schmitt' via RBASE-L To: rbase group Sent: Sun, Jul 25, 2021 9:07 pm Subject: [RBASE-L] - Capture a file Name possible Hello, Group: I have an application where the operator will be receiving a CSV 'payments' file

Re: [RBASE-L] - Capture a file Name possible

:07 PM 'jim schmitt' via RBASE-L wrote: Hello, Group: I have an application where the operator will be receiving a CSV 'payments' file each day and the file has a rather long file name. Sample file name:      PAYMENTS_637467300105556434-20210120-030011.csv Notice that the processing

[RBASE-L] - Capture a file Name possible

Hello, Group: I have an application where the operator will be receiving a CSV 'payments' file each day and the file has a rather long file name. Sample file name:      PAYMENTS_637467300105556434-20210120-030011.csv Notice that the processing date (20210720) is buried inside the file name. Is it

[RBASE-L] - Import File

Hi, Group: Need some assistance today.  I have worked previously with Exporting files, but have not worked with Importing files.  Now I have a potential new customer who wants me to Import data from another system.   I have enclosed the tab delimited test file (only two records), but cannot get

Re: [RBASE-L] - report problem

the "set value" line appears (isn't there until I click).  As Dan said, you need the "edit" toolbar checked, and in my case, I often cannot see "set value" if I don't have my RBase session full-screen Karen -Original Message- From: 'jim schmitt' via RBASE

Re: [RBASE-L] - report problem

Subject: RE: [RBASE-L] - report problem Make sure edit is turned on in the toolbar.     Dan     From: 'jim schmitt' via RBASE-L Sent: Wednesday, September 2, 2020 6:13 AM To: rbase group Subject: [RBASE-L] - report problem   Good Morning:   Having some problem with a report this AM

[RBASE-L] - report problem

Good Morning: Having some problem with a report this AM.Using x.5.2 On a report, when I add a label (from DB controls), it places the object on the report, but there is no where to change the label contents from LABEL 1 to what I need it to be. Foggy this morning. Jim -- For group guidelines,

Re: [RBASE-L] - File import

Jim ...here is a snippet of how to do it.  Data is from a Badger Meter Reading system.      ---   DELETE ROS FROM HOLDING TABLE   DELETE ROWS FROM BADGER_INPUT    IF VF_ERROR = 2038 THEN      BEEP 'FREQ 200,150'      PAUSE 2 USING +      ' INPUT HOLDING TABLE (IMPORT_HH) IS MISSING - NOTIFY

Re: [RBASE-L] - Bill Eyring

So said to hear about Bill's passing. I have talked will Bill quite a few times over the past years,and was always glad to see him at the  RB conferences, and lunches. Rest in Peace, Bill. To the RB community, stay safe, my friends. Jim Schmitt10614-863-1850. On Saturday, May 9, 2020,

[RBASE-L] - forms problems

Good morning to all: When working with forms this AM, I am seeing something I have never seen before. Under Database exployer > FORMS > when viewing the list of form names, form table, on a few forms I see () to the right of the Form Table name. If I highlight the form, and choose

Re: [RBASE-L] - Need assistance when creating an account.

direction to start today. Thanks again. On Friday, July 12, 2019, 12:19:10 PM EDT, Albert Berry wrote: There is a password set for the table, I suspect. > On Jul 12, 2019, at 9:50 AM, 'jim schmitt' via RBASE-L > wrote: > > Good Morning: > > I have installed RB X.

[RBASE-L] - Need assistance when creating an account.

Good Morning: I have installed RB X.5 - latest version for a new user. New application...when she tries to add a new account, she received the message 'Unauthorized access to table PAYERS for user NONE (2039)'. I don't understand what is causing this problem.never had it before In doing a

Re: [RBASE-L] - Happy Holidays from R:BASE Technologies

Merry Christmas and Happy Holidays to our wonderful partners at RBTI, and to the entire RBASE community. Jim SchmittOhio Software Services From: A. Razzak Memon To: rbase-l@googlegroups.com Sent: Monday, December 24, 2018 10:21 AM Subject: [RBASE-L] - Happy Holidays from R:BASE

Re: [RBASE-L] - Value change in a form

On some important fields, thats the way I've done it for years, but if there is a better way I'd like to know. On Thursday, October 18, 2018, 4:56:41 PM EDT, Albert Berry wrote: I need to know if a specific value (a DBEDIT: Date) has been changed by the user. Is the old school, get

Re: [RBASE-L] - using goto labels in while loop

Hi, Dan: Karen's example does have a matching ENDIF, just above the ENDWHILE command.   Her ENDWHILE closes the loop.Everything looks OK to me in her example. Jim Schmitt From: Dan Goldberg To: "rbase-l@googlegroups.com" Sent: Monday, May

Re: [RBASE-L] - Developer Needed for DOS 7.5/9.5 Conversion to RBase X

Hi, Mike: My name is Jim Schmitt, located in Columbus, Ohio, and have been doing RB full time since 1985.   I am a co-owner of Ohio Software Services. My background is in businees and government applications.   We currently have all customer is RB windows, but we started with RB 4.0 Dos back in

Re: [RBASE-L] - Form: Data veification on last field in a row

Albert: Insert a variable field, such as vf_landing, which will be defined as tab stop, and mark it autoselect, and you can 'hide' it behind the last field.   Next, put an on exit eep on the last regular field, with a ''nextrow' command.  Your eep isn't firing because the last field doesn't