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

['jim schmitt' via RBASE-L]

 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 
line. Is "Error Messages" checked? On both versions, that toggles the Error 
Messages window at the bottom of the screen on/off. Is that it?
b

-- Original Message --From "'Karen Tellef' via RBASE-L" 
To "rbase-l@googlegroups.com" 
Date 5/15/2024 2:45:04 PMSubject Re: Re[2]: [RBASE-L] 
- Disappearing RStyle error list

 None of the errors show; there's no box to display the errors in.  

Karen


On Wednesday, May 15, 2024 at 04:33:05 PM CDT, Bruce Chitiea 
 wrote:   

 I have a  vetted v10.5 set I haven't converted yet. I'll break a few things 
and see whats is.
Any sense of there being a category of error which doesn't pop?
B

-- Original Message --From "'Karen Tellef' via RBASE-L" 
To "rbase-l@googlegroups.com" 
Date 5/15/2024 2:27:39 PMSubject Re: [RBASE-L] - 
Disappearing RStyle error list

 Version 10.5, noticed it on several builds of it, up to the most recent


Karen

On Wednesday, May 15, 2024 at 04:22:52 PM CDT, Bruce Chitiea 
 wrote:   

 Karen:
Which version and release is this?Bruce
Bruce A. ChitieaSafeSectors, Inc.1142 S Diamond Bar Blvd # 442Diamond Bar CA 
91765-2203
rby...@safesectors.com (909) 238-9012 m
-- Original Message --From "'Karen Tellef' via RBASE-L" 
To "RBase List" Date 
5/15/2024 1:08:06 PMSubject [RBASE-L] - Disappearing RStyle error list

This happens to me on and off.  I RStyle something, it'll report the errors, 
but I don't get the box that explains what each error is.  I do get the 
highlighted rows, so I can sorta see where the errors are, but I need the 
explanation sometimes.
I've looked and can't find a setting to turn this back on, and I don't see any 
gutters that I can grab and expand, in case I had accidentally closed the space 
up.
Anyone have a clue for me?

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/442345200.440839.1715803686522%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/emdb4812bc-0ece-4544-8ab2-a3c4b64571d1%40b94eb5b2.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/523885896.467916.1715808459862%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/em65535d33-c5ea-4c88-ad9e-b57070787bd7%40b94eb5b2.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/1286513161.488469.1715809504839%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/emb496b8d9-96cc-4d55-ac73-34b73e31994b%40b94eb5b2.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 

Re: [RBASE-L] - Version 11

['jim schmitt' via RBASE-L]

 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 things that do not respond the same. I 
have a form with a scrolling region that I capture a variable on startup which 
is used as a default value in a particular field.  Every version I have used 
has not created a problem, but with 11 that default value is not placed in the 
field, just a blank field.  I have not made any changes just upgraded to 11.  
In the default field I am using the .varname, is that not correct now?
Tom Hart

-- 
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/CABX9BNemQgyo9xexQnAKjxNzEVSXaBhEjR1BqtTfMPTs9cg%3D1Q%40mail.gmail.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/1996150110.5662268.1714511983728%40mail.yahoo.com.

Re: [RBASE-L] - Disappearing text

['jim schmitt' via RBASE-L]

 Karen:
On the main menu (which calls the problem menu), insert the following on an 
'after start' eep.

   PROPERTY RBASE_FORM TIMERENABLED 'FALSE'   RECALC VARIABLES
   RETURN
Jim



On Monday, April 22, 2024 at 10:39:09 AM EDT, 'Karen Tellef' via RBASE-L 
 wrote:  
 
  Jim:  funny you should ask that.  When I edit the form from the R> prompt, it 
never happens (which is why I didn't pick it up when I was designing/testing).  
I should've mentioned that up front.

This form is called from the main menu, which has a Group Bar control.  This is 
one of the group bar options with a simple "edit using" command, nothing else.  
No timers on the main menu.

So do we all think there's some kind of "auto save" setting in the startup file 
that might cause this?  If I had designed this system, it'd be easy to post the 
startup parameters for your perusal.  But 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 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, PESent 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 PMSubject [RBASE-L] - Disappearing text

Version 10.5.  Client says this happens in a couple forms, but was sporadic.  
Final

Re: [RBASE-L] - Disappearing text

['jim schmitt' via RBASE-L]

 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, PESent 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 PMSubject [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; if you had entered data in the other variable it sticks 
around.
4.  Entering text into a DB Edit field and sitting on that field will not 
disappear.
5.  Doesn't seem to be a case of memory build-up.  If you go into the 
application and this is the first thing you do, it will happen.  Not just at 

Re: [RBASE-L] - Disappearing text

['jim schmitt' via RBASE-L]

 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 PMSubject [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; if you had entered data in the other variable it sticks 
around.
4.  Entering text into a DB Edit field and sitting on that field will not 
disappear.
5.  Doesn't seem to be a case of memory build-up.  If you go into the 
application and this is the first thing you do, it will happen.  Not just at 
end of day, after another heavy process, etc.

Weird, huh?  But I can replicate it every time on this one particular form 

Because they often type long notes into that memo field, and they aren't fast 
typists, they have been typing the notes in Word and then copy/paste into the 
field and move off the field asap.

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/1125847848.1573463.1713730536856%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/em097f0a0e-37fb-4a3f-a48f-a3609151e292%40a5dc929d.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/47AC857F-1571-4A5A-88C6-B192FF5FD4CA%40cs.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/947643679.1980961.1713741352479%40mail.yahoo.com.

Re: [RBASE-L] - Disappearing text

['jim schmitt' via RBASE-L]

 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 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 PMSubject [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; if you had entered data in the other variable it sticks 
around.
4.  Entering text into a DB Edit field and sitting on that field will not 
disappear.
5.  Doesn't seem to be a case of memory build-up.  If you go into the 
application and this is the first thing you do, it will happen.  Not just at 
end of day, after another heavy process, etc.

Weird, huh?  But I can replicate it every time on this one particular form 

Because they often type long notes into that memo field, and they aren't fast 
typists, they have been typing the notes in Word and then copy/paste into the 
field and move off the field asap.

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/1125847848.1573463.1713730536856%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/em097f0a0e-37fb-4a3f-a48f-a3609151e292%40a5dc929d.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/47AC857F-1571-4A5A-88C6-B192FF5FD4CA%40cs.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/1786576650.1963770.1713738970677%40mail.yahoo.com.

Re: [RBASE-L] - CVAL CONNECTIONS

['jim schmitt' via RBASE-L]

 HA, HA.
Tell the 'BOSS' to be more careful.
Concerning the backup message for the operator, I thought it would be more 
informative to give the operator the number of users connected, like:


But, I can simply change the message to 'YOU HAVE OTHER USERS'.
As far as 'error' logs, I too utilize a 'Tracking' table, to log the time, 
date, operator, function, etc, for entry and exit into the system.I also track 
the description and 'operator entered' options for all major functions in the 
system.  This has proved to be invaluable when errors occur.   The log or 
tracking table is the largest table row-wise in the system.
Regards, Jim


On Tuesday, April 2, 2024 at 09:53:20 PM EDT, Steve Sweeney 
 wrote:  
 
 
Hi Jim,
 
  
 
Yes, the number of users would be nice to know.  I do have a UserLog table in 
most of my applications.  I have a routine called RBOnline.CMD showing all 
users 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@googlegroups.com
Subject: Re: [RBASE-L] - CVAL CONNECTIONS
 
  
 
Thanks, Steve:
 
  
 
Good to hear from you...The only thing I really like with the 
'CVAL(''connections'))' option is that it responds with an integer # (of 
connections), but when it's incorrect it doesn't do any good.      Although, 
sometimes it is the correct number (of connections).
 
  
 
Your method is what I used to use, but I thought it would be better to inform 
the operator of exactly how many users are connected, and need to exit.    
 
  
 
Thanks and regards.
 
  
 
On Tuesday, April 2, 2024 at 06:05:50 PM EDT, Steve Sweeney 
 wrote:
 
  
 
  
 
I always:
 
    DISCONNECT
 
    SET MULTI OFF
 
    CONNECT {dbname}
 
 
 
If there are NO errors (if I CAN connect) then we are good to go with a backup.
 
 
 
Also, I stop any web services connecting through Oterro – this seems to have a 
persistent connection, as well.
 
 
 
Steve
 
 
 
 
 
From: 'Karen Tellef' 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 of the network.  It seems the network thinks they have RBase 
connections still open, but not RBase itself.
 
 
 
 
 
Karen
 
 
 
 
 
 
 
On Tuesday, April 2, 2024 at 04:10:45 PM CDT, 'jim schmitt' 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 connections.  Does the connections 
get reduced as each user exits ?
 
 
 
 
 
Just wondering what most of you are using to insure that all users are out of 
the database before performing a backup.
 
 
 
Any enlightenment would be helpful.
 
 
 
Thanks,  jim
 
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 
torbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/920496374.4843463.1712092238259%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 
torbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/1711672630.3821035.1712092984286%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 
torbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/BYAPR03MB3718B1CDC371051562846AC3893E2%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 
torbase-l+unsubscr...@googlegroups.com.
To view this discussion on th

Re: [RBASE-L] - CVAL CONNECTIONS

['jim schmitt' via RBASE-L]

 Thanks, Steve:
Good to hear from you...The only thing I really like with the 
'CVAL(''connections'))' option is that it responds with an integer # (of 
connections), but when it's incorrect it doesn't do any good.      Although, 
sometimes it is the correct number (of connections).
Your method is what I used to use, but I thought it would be better to inform 
the operator of exactly how many users are connected, and need to exit.    
Thanks and regards.
On Tuesday, April 2, 2024 at 06:05:50 PM EDT, Steve Sweeney 
 wrote:  
 
 
I always:
 
    DISCONNECT
 
    SET MULTI OFF
 
    CONNECT {dbname}
 
  
 
If there are NO errors (if I CAN connect) then we are good to go with a backup.
 
  
 
Also, I stop any web services connecting through Oterro – this seems to have a 
persistent connection, as well.
 
  
 
Steve
 
  
 
  
 
From: 'Karen Tellef' 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 of the network.  It seems the network thinks they have RBase 
connections still open, but not RBase itself.
 
  
 
  
 
Karen
 
  
 
  
 
  
 
On Tuesday, April 2, 2024 at 04:10:45 PM CDT, 'jim schmitt' 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 connections.  Does the connections 
get reduced as each user exits ?
 
  
 
  
 
Just wondering what most of you are using to insure that all users are out of 
the database before performing a backup.
 
  
 
Any enlightenment would be helpful.
 
  
 
Thanks,  jim
 
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 
torbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/920496374.4843463.1712092238259%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 
torbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/1711672630.3821035.1712092984286%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/BYAPR03MB3718B1CDC371051562846AC3893E2%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/msgid/rbase-l/2109224727.4940646.1712106276043%40mail.yahoo.com.

Re: [RBASE-L] - CVAL CONNECTIONS

['jim schmitt' via RBASE-L]

 Thanks, Karen
I believe what you have said is true. I just wanted to see how other RB 
users determine if all are users are disconnected.
Thanks.  Jim
On Tuesday, April 2, 2024 at 05:23:07 PM EDT, 'Karen Tellef' via RBASE-L 
 wrote:  
 
  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 of the network.  It seems the network thinks they have RBase 
connections still open, but not RBase itself.

Karen


On Tuesday, April 2, 2024 at 04:10:45 PM CDT, 'jim schmitt' 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 connections.  Does the connections get 
reduced as each user exits ?

Just wondering what most of you are using to insure that all users are out of 
the database before performing a backup.
Any enlightenment would be helpful.
Thanks,  jim1-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 on the web visit 
https://groups.google.com/d/msgid/rbase-l/920496374.4843463.1712092238259%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/1711672630.3821035.1712092984286%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/254407601.4944372.1712105712624%40mail.yahoo.com.

[RBASE-L] - CVAL CONNECTIONS

['jim schmitt' via RBASE-L]

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 connections get 
reduced as each user exits ?

Just wondering what most of you are using to insure that all users are out of 
the database before performing a backup.
Any enlightenment would be helpful.
Thanks,  jim1-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 on the web visit 
https://groups.google.com/d/msgid/rbase-l/920496374.4843463.1712092238259%40mail.yahoo.com.

Re: [RBASE-L] - email novice problems

['jim schmitt' via RBASE-L]

 Hi, Karen:
Thanks for the sample.I guess i missed it, and thought that the print 
command with email on and options could figure out the host/port/authentication 
issue on its own.   but, not true.  I guess I'll have to mess with the email to 
determine the settings, which I have never done.    Thanks again.
Jim 
On Saturday, November 11, 2023 at 08:50:59 AM EST, 'Karen Tellef' via 
RBASE-L  wrote:  
 
  Here's a copy of code that runs fine every day (all data is sent in by 
variables).  Perhaps compare to your code and see what the differences are?  
It's been a long time since I've messed with this code; we embedded the 
host/port/authentication within the print itself for some reason rather than 
doing the settings.  We store the settings within a table.  I think it was just 
for ease rather than remembering to do report email settings with new RBase 
installs

Karen

PRINT invemail WHERE billdate = .#DATE OPTION PDF|FILENAME  +
 |EMAIL ON +
 |EMAIL_AUTHENTICATION OFF +
 |EMAIL_HOST  +
 |EMAIL_PORT 25 +
 |EMAIL_USERID  +
 |EMAIL_PASSWORD  +
 |EMAIL_TO_LIST  +
 |EMAIL_FROM_NAME 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 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 Invoice_1031.PDF 
+|EMAIL ON +|EMAIL_TO_LIST jim.schm...@yahoo.com +|EMAIL_FROM_NAME John D. 
Johnson +|EMAIL_FROM_ADDRESS jim.schm...@yahoo.com +|EMAIL_SUBJECT Imagine The 
Possibilities! +|EMAIL_BODY Attached is the invoice - sent via R:BASE. Because 
we Can! +|EMAIL_DELETE_AFTER_SEND ON +|EMAIL_SHOW_DIALOG ONreturn

If I try it with just the first two lines, it works and creates the PDF file 
which I can see..With the email options, I get nothing ??Just can't see what I 
am missing.any help would be appreciated. The report email settings listed  
below:


Thanks in advance.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/1074275864.2200889.1699656760734%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/2067692558.1858400.1699710651612%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/1872682227.3620598.1699989282797%40mail.yahoo.com.

Re: [RBASE-L] - email novice problems

['jim schmitt' via RBASE-L]

 Thanks, Karen:
I will try this later on today.
On Saturday, November 11, 2023 at 08:50:59 AM EST, 'Karen Tellef' via 
RBASE-L  wrote:  
 
  Here's a copy of code that runs fine every day (all data is sent in by 
variables).  Perhaps compare to your code and see what the differences are?  
It's been a long time since I've messed with this code; we embedded the 
host/port/authentication within the print itself for some reason rather than 
doing the settings.  We store the settings within a table.  I think it was just 
for ease rather than remembering to do report email settings with new RBase 
installs

Karen

PRINT invemail WHERE billdate = .#DATE OPTION PDF|FILENAME  +
 |EMAIL ON +
 |EMAIL_AUTHENTICATION OFF +
 |EMAIL_HOST  +
 |EMAIL_PORT 25 +
 |EMAIL_USERID  +
 |EMAIL_PASSWORD  +
 |EMAIL_TO_LIST  +
 |EMAIL_FROM_NAME 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 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 Invoice_1031.PDF 
+|EMAIL ON +|EMAIL_TO_LIST jim.schm...@yahoo.com +|EMAIL_FROM_NAME John D. 
Johnson +|EMAIL_FROM_ADDRESS jim.schm...@yahoo.com +|EMAIL_SUBJECT Imagine The 
Possibilities! +|EMAIL_BODY Attached is the invoice - sent via R:BASE. Because 
we Can! +|EMAIL_DELETE_AFTER_SEND ON +|EMAIL_SHOW_DIALOG ONreturn

If I try it with just the first two lines, it works and creates the PDF file 
which I can see..With the email options, I get nothing ??Just can't see what I 
am missing.any help would be appreciated. The report email settings listed  
below:


Thanks in advance.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/1074275864.2200889.1699656760734%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/2067692558.1858400.1699710651612%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/195320199.2340903.1699712187530%40mail.yahoo.com.

Re: [RBASE-L] - email novice problems

['jim schmitt' via RBASE-L]

 Hi, Jim:
Thanks for the suggestion.  I tried the attachment option (code listed below), 
Still - no go.I know this looks easy enough, but it isn't working.   Am i 
missing something ?
SET MESSAGES ONSET ERROR MESSAGES ON
Set var vfilename TEXT = ‘c:\emailtest\_1031.PDF’
PRINT validate  +OPTION PDF|FILENAME Invoice_1031.PDF +|EMAIL ON 
+|EMAIL_TO_LIST jim.schm...@yahoo.com +|EMAIL_FROM_NAME John D. Johnson 
+|EMAIL_FROM_ADDRESS jim.schm...@yahoo.com +|EMAIL_SUBJECT Imagine The 
Possibilities! +|EMAIL_BODY Attached is the invoice - sent via R:BASE. Because 
we Can! +|EMAIL_ATTACHMENTS  +|EMAIL_DELETE_AFTER_SEND ON 
+|EMAIL_SHOW_DIALOG ON
return
 
On Friday, November 10, 2023 at 06:53:38 PM EST, 'Jim Belisle' via RBASE-L 
 wrote:  
 
 
Jim,
 
  
 
Try adding a line for the attachment.
 
You may want to set the attachment as a variable with the complete location.
 
Example:
 
Set var 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 is an EXTERNAL EMAIL,STOP! and think before clicking on any links 
or opening attachments. 
  |


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 Invoice_1031.PDF +
 
|EMAIL ON +
 
|email_to_listjim.schm...@yahoo.com +
 
|EMAIL_FROM_NAME John D. Johnson +
 
|email_from_addressjim.schm...@yahoo.com +
 
|EMAIL_SUBJECT Imagine The Possibilities! +
 
|EMAIL_BODY Attached is the invoice - sent via R:BASE. Because we Can! +
 
|EMAIL_DELETE_AFTER_SEND ON +
 
|EMAIL_SHOW_DIALOG ON
 
return
 
  
 
If I try it with just the first two lines, it works and creates the PDF file 
which I can see..
 
With the email options, I get nothing ??
 
Just can't see what I am missing.any help would be appreciated.
 
 
 
The report email settings listed  below:
 
  
 

 
Thanks in advance.
 
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 
torbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/1074275864.2200889.1699656760734%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/PH7PR02MB994323D03D5F3990B3A1C013A0AEA%40PH7PR02MB9943.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/97081457.2319033.1699709336057%40mail.yahoo.com.

[RBASE-L] - email novice problems

['jim schmitt' via RBASE-L]

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 Invoice_1031.PDF 
+|EMAIL ON +|EMAIL_TO_LIST jim.schm...@yahoo.com +|EMAIL_FROM_NAME John D. 
Johnson +|EMAIL_FROM_ADDRESS jim.schm...@yahoo.com +|EMAIL_SUBJECT Imagine The 
Possibilities! +|EMAIL_BODY Attached is the invoice - sent via R:BASE. Because 
we Can! +|EMAIL_DELETE_AFTER_SEND ON +|EMAIL_SHOW_DIALOG ONreturn

If I try it with just the first two lines, it works and creates the PDF file 
which I can see..With the email options, I get nothing ??Just can't see what I 
am missing.any help would be appreciated. The report email settings listed  
below:


Thanks in advance.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/1074275864.2200889.1699656760734%40mail.yahoo.com.

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

['jim schmitt' via RBASE-L]

 Happening at 3 different client, database and all program files are in the 
'C\UBILL' director, so, yes, many files, approx 70.Doesn't 'source file' refer 
to the input source file ?   I need the  because the operator may backup 
multiple times per day, and we don't want to use the same name as the last 
backup name, hence we embed date and time.
Still searching..
On Monday, June 26, 2023 at 11:47:22 AM EDT, Alastair Burr 
 wrote:  
 
  
Yes, but a very long time ago now I had backup copying problems and ended up 
with errors that eventually were solved by everything being right not 
necessarily just what appeared to be wrong. I remember expanding all the 
variables so that the command was simply copy: "sourcefiles" "destination" - so 
without the  and with quotes to allow spaces
 
 
Stupid question I'm sure but there really are files to copy at the time?
 
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\*.*' of the copy command ? 
  Still searching.     Jim
 
  
  On Monday, June 26, 2023 at 10:50:22 AM EDT, Alastair Burr 
 wrote:  
  
 
Looks to me that you have 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 villages, and the backup 
routine which does a backup to an external drive has failed lately at 3 clients 
with the same error message of 'cannot open source file (2085).  I wrote the 
routine years ago, and it is quite simple.  I create a variable of 
'location/name/time/date' for where we are sending the data to (VF_TO}'.   This 
is because the operator may do multiple backup on any given day.    
  The command is:  COPY C:\UBILL\*.* _TO     
  Sample trace attached.  Am i doing the simplest way for a backup or others 
have a better way. ?? Any 'blues' clues. 
  Thanks for any assistance. 
  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/2029899591.5130715.1687788099654%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/DUZPR10MB80996122BF106084F681C3D0AC26A%40DUZPR10MB8099.EURPRD10.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/338283074.5153202.1687791564491%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/DUZPR10MB80994FC06D8B9FB77E6D6956AC26A%40DUZPR10MB8099.EURPRD10.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/186640552.5197023.1687795070399%40mail.yahoo.com.

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

['jim schmitt' via RBASE-L]

 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\*.*' of the copy command ?
Still searching.     Jim


On Monday, June 26, 2023 at 10:50:22 AM EDT, Alastair Burr 
 wrote:  
 
  
Looks to me that you have 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 villages, and the backup 
routine which does a backup to an external drive has failed lately at 3 clients 
with the same error message of 'cannot open source file (2085).  I wrote the 
routine years ago, and it is quite simple.  I create a variable of 
'location/name/time/date' for where we are sending the data to (VF_TO}'.   This 
is because the operator may do multiple backup on any given day.    
  The command is:  COPY C:\UBILL\*.* _TO     
  Sample trace attached.  Am i doing the simplest way for a backup or others 
have a better way. ?? Any 'blues' clues. 
  Thanks for any assistance. 
  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/2029899591.5130715.1687788099654%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/DUZPR10MB80996122BF106084F681C3D0AC26A%40DUZPR10MB8099.EURPRD10.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/338283074.5153202.1687791564491%40mail.yahoo.com.

[RBASE-L] - form problem

['jim schmitt' via RBASE-L]

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, , it had ("") beside the table name.  Tried to 
find the reason for the '("")'  in the Help notes but to no avail.Can someone 
point me in the right direction for this mishap?   .Version X. 
Thanks in advance...
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/510615390.1612374.1677518598545%40mail.yahoo.com.

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

['jim schmitt' via RBASE-L]

 Thanks Karen, for the suggestion.this did work just fine.

On Monday, February 6, 2023 at 01:36:15 PM EST, 'Karen Tellef' via RBASE-L 
 wrote:  
 
 I looked in my notes.  I see you're exporting to a CSV.  If you don't need a 
CSV, my notes say that exporting to a worksheet (XLS) rather 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, 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 are needed).
Am I missing something or can this be resolved. ?  gateway command and sample 
file attached
Thanks,  Jim, 
gateway command and sample file attached::  
   GATEWAY EXPORT CSV w2upload.csv +     SELECT * FROM OHIO_W2_DATA +   OPTION 
COL_NAMES OFF    ---   | SHOW_PROGRESS ON | ACTION OPENVIEW
-- 
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/1973250947.972841.1675707561020%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/1290823543.771706.1675708572260%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/514754207.1599362.1677517857883%40mail.yahoo.com.

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

['jim schmitt' via RBASE-L]

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 are needed).
Am I missing something or can this be resolved. ?  gateway command and sample 
file attached
Thanks,  Jim, 
gateway command and sample file attached::  
   GATEWAY EXPORT CSV w2upload.csv +     SELECT * FROM OHIO_W2_DATA +   OPTION 
COL_NAMES OFF    ---   | SHOW_PROGRESS ON | ACTION OPENVIEW

-- 
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/1973250947.972841.1675707561020%40mail.yahoo.com.


table1
Description: Binary data

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

['jim schmitt' via RBASE-L]

 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




On Friday, December 30, 2022 at 09:40:22 AM EST, A. Razzak Memon 
 wrote:  
 
 Friday, December 30, 2022

On behalf of everyone at R:BASE Technologies, we wish for all to have a 
wonderful holiday season with their families, with terabytes of love and 
peace in your hearts!

I want to thank you for being valued members of the R:BASE Community. 
It's been an honor serving everyone this year, across the globe, and in 
every facet of R:BASE use!

As we approach our 25th Anniversary, rest assured, there will be plenty 
of exciting news coming in 2023. The R:BASE Technologies development and 
support teams have been working at an accelerated pace to bring the many 
bold ideas from R:BASE users and developers into innovative solutions, 
to optimize all that you do with R:BASE. New transformations constructed 
on top of the high performance relational design will be built to 
revolve around you and your applications.

We will continue to provide the highest caliber of support and services, 
to present our customers with exceptional efficiency and productivity.

However you celebrate, we wish you the very best for this holiday season 
and a happy, healthy, and prosperous 2023!

Thank you again for making R:BASE a part of your life!

My Very Best R:egards,

Razzak

A. Razzak Memon
Founder, President & CEO
R:BASE Technologies, Inc.
https://www.rbase.com

Founder, President & CEO
RAM Data Systems, Inc.
https://www.ramdatasystems.com

https://www.linkedin.com/in/razzakmemon/



-- 
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/9688d05e-880d-1563-30f5-2dce7fa5f461%40rbase.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/627285090.6024654.1672514841199%40mail.yahoo.com.

[RBASE-L] - out of dynamic space epilog

['jim schmitt' via RBASE-L]

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, and then tested the db - that worked too.
Dialed back in and transferred the db and files back to client. Fired up and 
again 'OUT OF DYNAMIC SPACE'
Tried to tracethe errorduring my testing, everthing went to an extremely 
slow mode for about 1 1/2 hours.
So after a day being down, the clients network IT tech called me..he dialed 
in..then magicallyeverything worked, and was unbelievably fast.    He 
claimed he didn't do antthing (yeah, right).
So, as usual NO PROBLEMS WITHIN R:BASE (it's running like a champ) 
..the culprit was somewhere in the client's computer and/or the IT tech guy.
No clue as to what caused the 'OUT OF DYNAMIC SPACE' error; I guess i'll never 
know.   Client is now happy once more.
But, again thanks to all for the great suggestions, and HAPPY NEW YEAR !
Jim Schmitt

-- 
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/443960974.1109136.1672323913425%40mail.yahoo.com.

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

['jim schmitt' via RBASE-L]

 Hi, Karen:
Thanks for the quick reply, and Merry Christmas and Happy Holidays.  I just 
called the client to see what was the size of the server, but they have left 
for the day.Thye just purchased the server a few months ago, but I would think 
most clients would want a rather robust server.    .
Jim
On Monday, December 26, 2022 at 02:02:43 PM EST, 'Karen Tellef' via RBASE-L 
 wrote:  
 
 I was gonna say that I've seen that message in two instances.  Either out of 
hard drive space (either server or local temp directory if you use local temp) 
or an issue with local memory

 Karen
 
 
-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' is a copy of 'S', as it is exactly 
same sizes.
H dive                    S drive (production)        P driveused 83.0 
GB        USED 429 gb              USED 429 GBFREE   362 gb    
free    384GB             FREE 384 GB
TOTAL 446 gb    TOTAL 813 GB          TOTAL 813 GB
Could their server be only 1TB and out of room ?  Just guessing in the dark .
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/591133800.4046390.1672080894289%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/1347456052.3409335.1672081361444%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/1024213708.4045010.1672082956746%40mail.yahoo.com.

[RBASE-L] - out of dynamic space II

['jim schmitt' via RBASE-L]

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              USED 429 GBFREE   362 gb    
free    384GB             FREE 384 GB
TOTAL 446 gb    TOTAL 813 GB          TOTAL 813 GB
Could their server be only 1TB and out of room ?  Just guessing in the dark .
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/591133800.4046390.1672080894289%40mail.yahoo.com.

[RBASE-L] - out of dynamic space

['jim schmitt' via RBASE-L]

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 standstill.
Can anyone explain  what this error means. ?
Thanks in advance..
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/1786887480.4030899.1672079548700%40mail.yahoo.com.

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

['jim schmitt' via RBASE-L]

 Ha, HaGood one, Bruce.    
You are in my basket for a drink at the next R:Gathering.now that covid is 
down, maybe the R:Base team will have another training / review seminar in the 
future.    Maybe it would be a R:Celebrationare you listening Razzak?
With a great organization like R:Base, with Razzak, John, and other fellow 
users like Karen, you, and many others, offering excellent timely advice on how 
to achieve our programming goals is exactly what is needed.    We thank all 
within this group for their kind insight and assistance.
Hope to see you at the next R: group meeting.
Regards,Jim  


On Tuesday, March 22, 2022, 09:38:19 PM EDT, Bruce Chitiea 
 wrote:  
 
 Jim:
What do I have to do for you to get a prime rib dinner and a round at the next 
R:Gathering?
Best, Bruce
Bruce A. Chitiea | SafeSectors, Inc.112 Harvard Ave #272 | Claremont CA 
91711-4716 | USA+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 this is exactly what I wanted, 
and it works perfect.  Never had to use a Launch of a BAT file before.
After I exicute the Launch of .the BAT command, I can then load the values into 
a table for further processing.Works like a charm.   I owe you a lunch at the 
next R:Gathering...Thanks again   
Jim

On Tuesday, March 22, 2022, 03:10:04 PM EDT, 'Karen Tellef' via RBASE-L 
 wrote:  
 
 Absolutely!  What you want to do is create a batch file (.BAT) that has your 
DIR command and you "LAUNCH" the .BAT file from within RBase.  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, 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 command from 
a Command prompt., which produces the names of needed files.
When using the following command in a command prompt, (dir payments_* /B 
>myfile), it puts the names of the payments file into a file called 'myfile', 
which is exactly what I need..
The question:  Is their any way that this dos command can be executed within a 
RBase program , such as ZIP, Launch, ??? ?Ver RBGX5E
Thanks for any input.
Jim Schmitt1-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 on the web visit 
https://groups.google.com/d/msgid/rbase-l/1033887566.1905707.1647975613894%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/1786837149.1180146.1647976197714%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/2037440939.2035423.1647996508643%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/eme6e92acd-7b28-4e47-ac56-3883720c42fc%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/1606756178.2254568.1648050689829%40mail.yahoo.com.

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

['jim schmitt' via RBASE-L]

 Karen:
WOW   !!!   Just wanted to say thanks again as this is exactly what I wanted, 
and it works perfect.  Never had to use a Launch of a BAT file before.
After I exicute the Launch of .the BAT command, I can then load the values into 
a table for further processing.Works like a charm.   I owe you a lunch at the 
next R:Gathering...Thanks again   
Jim

On Tuesday, March 22, 2022, 03:10:04 PM EDT, 'Karen Tellef' via RBASE-L 
 wrote:  
 
 Absolutely!  What you want to do is create a batch file (.BAT) that has your 
DIR command and you "LAUNCH" the .BAT file from within RBase.  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, 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 command from 
a Command prompt., which produces the names of needed files.
When using the following command in a command prompt, (dir payments_* /B 
>myfile), it puts the names of the payments file into a file called 'myfile', 
which is exactly what I need..
The question:  Is their any way that this dos command can be executed within a 
RBase program , such as ZIP, Launch, ??? ?Ver RBGX5E
Thanks for any input.
Jim Schmitt1-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 on the web visit 
https://groups.google.com/d/msgid/rbase-l/1033887566.1905707.1647975613894%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/1786837149.1180146.1647976197714%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/2037440939.2035423.1647996508643%40mail.yahoo.com.

[RBASE-L] - DOS command line prompt

['jim schmitt' via RBASE-L]

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 command from 
a Command prompt., which produces the names of needed files.
When using the following command in a command prompt, (dir payments_* /B 
>myfile), it puts the names of the payments file into a file called 'myfile', 
which is exactly what I need..
The question:  Is their any way that this dos command can be executed within a 
RBase program , such as ZIP, Launch, ??? ?Ver RBGX5E
Thanks for any input.
Jim Schmitt1-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 on the web visit 
https://groups.google.com/d/msgid/rbase-l/1033887566.1905707.1647975613894%40mail.yahoo.com.

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

['jim schmitt' via RBASE-L]

 Hi, Bruce:

Thank you for your input. Karen T. had a simple and easy solution to my 
problem, but thanks again for your suggestion. 

The RB Group is amazing.

Regards,

Jim 
 On Monday, July 26, 2021, 11:59:34 AM EDT, Bruce Chitiea 
 wrote:  
 
 #yiv1599604620 #yiv1599604620x6736bc4ff2fe478ba23450b3bc46c929 
blockquote.yiv1599604620cite{border-left:1px solid #CCC;}#yiv1599604620 
#yiv1599604620x7be4106dbf054dd 
#yiv1599604620x86b4dd35dfc94ef5a5432fdb70f5f643{font-family:'Segoe 
UI';font-size:12pt;}Jim:
"I have an application where the operator will be receiving a CSV 'payments' 
file each day ... "
(1) By which system/protocol (e.g. smtp, ftp) is the file transmitted to your 
application at present time? (2) Does the transmission/file arrive within a 
consistent time range, and/or reliably by a given time of day?
Bruce
Bruce A. Chitiea | SafeSectors, Inc.112 Harvard 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

 Hi, Tony ,

Thanks for the speedy reply , but there will be only one PAYMENTScsv file 
each day, and I would like to get the file name without having the operator to 
choose it.
If I could get the name in a var, I could parse the date and capture the date.

Thanks,
Jim On Monday, July 26, 2021, 02:49:51 AM EDT, Tony IJntema 
 wrote:  
 
  
If the filename does not have always the same length, you can use a procedure 
like this
 

   -- capture the file name using procedure of Tony Luck
   SET VAR vfile  = 'PAYMENTS_637467300105556434-20210120-030011.csv'
   -- (SLOCP(TextNoteVarcharValue,string,occurrence))
   -- assuming '-' is always used in the filename
   -- locate startposition
   SET VAR V_STARTPOSITION = ( (SLOCP(.vfile ,'-',1)) + 1)
   -- (SGET(text,nchar,pos))
   -- get datevalue as a textvalue
   SET VAR V_PAYMENTDATE_TXT TEXT = (SGET(.vfile ,8,.V_STARTPOSITION) )
   -- (RDATE(mon,day,yr))
   -- convert text value to a date value
   SET VAR V_PAYMENTDATE DATE  = (RDATE(  (NINT( (SGET(.V_PAYMENTDATE_TXT,2,5)) 
)), (NINT( (SGET(.V_PAYMENTDATE_TXT,2,7)) )), (NINT( 
(SGET(.V_PAYMENTDATE_TXT,4,1)) )) ))
 
-- Regards
 
Tony IJ
 
 

 
 

 
 Op 26-07-2021 om 04:39 schreef Tony Luck:
  
 There's a few ways to achieve that, here's one I use to capture the file name 
of a file we import twice daily using a CHOOSE statement that popups up the 
files for the operator. CHOOSE vfile FROM #LFILES IN  TITLE 'Press ESC 
to Exit' +
 CAPTION 'Am Data Import File' OPTION LIST_FONT_SIZE 12 +
 TITLE_FONT_SIZE 12 | TITLE_FONT_COLOR BLUE
  
  From there, if the file name always places the date in the same spot you can 
use SGET function to extract it. 
  P.S. I use an ampersand variable to store the network directory the file is 
loaded to.   
  On Mon, Jul 26, 2021 at 12: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 date (20210720) is buried inside the file name. 
  Is it possible within RBASE to programmatically capture the file name in a 
variable so that I can interrogate the variable to obtain the processing date ? 
  Thanks, 
  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/1438844295.721301.1627265246989%40mail.yahoo.com.
 
  
 
  -- 
 Regards
 Tony -- 
 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/CABnhDARk-7tS5u0t4NC6WmUecE%2B0ONhey4AZddev6VraCeSHjw%40mail.gmail.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/ca4e5ff7-dd79-4c48-4c52-eb399652b41f%40cio-bv.nl.
  

-- 
For group guidelines, visit 
http://www.rbase.com/s

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

['jim schmitt' via RBASE-L]

 Hi, Karen:

OMG.it works beautifully.. I only had to make one modification, and it 
was off and running.
I appreciate it so much..

Thanks again.

Jim
 On Monday, July 26, 2021, 12:11:11 PM EDT, 'Karen Tellef' via RBASE-L 
 wrote:  
 
 Ah, that's the piece of info we all needed.  So the user is NOT going to pick 
the file?  So then the file is going to be sitting somewhere in a directory and 
you just want to pick up the file?
One way is to get a DIR of the directory into a file, load it into a table and 
then use a SELECT... INTO  to get the filename.  Of course you would add lots 
of error checking.  But code like the following
Karen

  OUTPUT c:\temp\file.txt
  DIR d:\YourDir\*.csv
  OUT SCR

  DROP TABLE tmpFile
  CREATE TEMP TABLE tmpFile (dirfiledate TEXT 10, dirfiletime TEXT 8, +
    dirfilesize TEXT 10, dirFilename TEXT 100 ) 
  
  SET NULL -0-  
  LOAD tmpFile FROM c:\temp\file.txt AS FORMATTED USING +
    dirfiledate 1 10, dirfiletime 13 20, dirfilesize 31 40 dirfilename 42 141
  SET NULL ' '  
      DELETE ROWSFROM tmpFile WHERE dirfilename IS NULL OR dirfilename LIKE 
'byte%' +
    OR dirfilename = '.' OR dirfilename = '..' OR dirfiledate CONTAINS 
'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 would like to get the file name without having the operator to 
choose it.
If I could get the name in a var, I could parse the date and capture the date.

Thanks,
Jim On Monday, July 26, 2021, 02:49:51 AM EDT, Tony IJntema 
 wrote:  
 
  If the filename does not have always the same length, you can use a procedure 
like this 
   -- capture the file name using procedure of Tony Luck
   SET VAR vfile  = 'PAYMENTS_637467300105556434-20210120-030011.csv'
   -- (SLOCP(TextNoteVarcharValue,string,occurrence))
   -- assuming '-' is always used in the filename
   -- locate startposition
   SET VAR V_STARTPOSITION = ( (SLOCP(.vfile ,'-',1)) + 1)
   -- (SGET(text,nchar,pos))
   -- get datevalue as a textvalue
   SET VAR V_PAYMENTDATE_TXT TEXT = (SGET(.vfile ,8,.V_STARTPOSITION) )
   -- (RDATE(mon,day,yr))
   -- convert text value to a date value
   SET VAR V_PAYMENTDATE DATE  = (RDATE(  (NINT( (SGET(.V_PAYMENTDATE_TXT,2,5)) 
)), (NINT( (SGET(.V_PAYMENTDATE_TXT,2,7)) )), (NINT( 
(SGET(.V_PAYMENTDATE_TXT,4,1)) )) )) -- Regards Tony IJ
  
  
  Op 26-07-2021 om 04:39 schreef Tony Luck:
  
 There's a few ways to achieve that, here's one I use to capture the file name 
of a file we import twice daily using a CHOOSE statement that popups up the 
files for the operator. CHOOSE vfile FROM #LFILES IN  TITLE 'Press ESC 
to Exit' +
 CAPTION 'Am Data Import File' OPTION LIST_FONT_SIZE 12 +
 TITLE_FONT_SIZE 12 | TITLE_FONT_COLOR BLUE
  
  From there, if the file name always places the date in the same spot you can 
use SGET function to extract it. 
  P.S. I use an ampersand variable to store the network directory the file is 
loaded to.   
  On Mon, Jul 26, 2021 at 12: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 date (20210720) is buried inside the file name. 
  Is it possible within RBASE to programmatically capture the file name in a 
variable so that I can interrogate the variable to obtain the processing date ? 
  Thanks, 
  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/1438844295.721301.1627265246989%40mail.yahoo.com.
 
  
 
  -- 
 Regards
 Tony -- 
 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/CABnhDARk-7tS5u0t4NC6WmUecE%2B0ONhey4AZddev6VraCeSHjw%40mail.gmail.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 th

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

['jim schmitt' via RBASE-L]

 Hi, Karen ,

Thanks for your reply , but there will be only one PAYMENTScsv file each 
day, and I would like to get the file name without having the operator choose 
it.
If I could get the name in a var, I could parse the data and capture the date.
I did think of the 'loadiflenameplus' option but i'm trying to avoid having 
operator choose something..
Maybe it's not possible?

Thanks again,
Jim On Monday, July 26, 2021, 09:26:23 AM EDT, 'Karen Tellef' via RBASE-L 
 wrote:  
 
 Jim:  Assuming your user will be selecting the file to process?  Use this 
statement to capture the name of the file into variable vFilename, then parse 
it like the code in another response.

PLUGINS loadfilenameplus.rbl 'vFilename|fullpath on +
    |TITLE Please selectyour Supplier Invoice Excel file+
    |VIEW_MODE Details +
    |FULLPATH ON +
    |NO_CHANGE_DIR ON + 
    |INITIAL_DIR x:\docs\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 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 possible within RBASE to programmatically capture the file name in a 
variable so that I can interrogate the variable to obtain the processing date ?
Thanks,
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/1438844295.721301.1627265246989%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/1952665032.1048804.1627305975942%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/2127193461.837781.1627314616287%40mail.yahoo.com.

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

['jim schmitt' via RBASE-L]

 Hi, Tony ,

Thanks for the speedy reply , but there will be only one PAYMENTScsv file 
each day, and I would like to get the file name without having the operator to 
choose it.
If I could get the name in a var, I could parse the date and capture the date.

Thanks,
Jim On Monday, July 26, 2021, 02:49:51 AM EDT, Tony IJntema 
 wrote:  
 
  
If the filename does not have always the same length, you can use a procedure 
like this
 

   -- capture the file name using procedure of Tony Luck
   SET VAR vfile  = 'PAYMENTS_637467300105556434-20210120-030011.csv'
   -- (SLOCP(TextNoteVarcharValue,string,occurrence))
   -- assuming '-' is always used in the filename
   -- locate startposition
   SET VAR V_STARTPOSITION = ( (SLOCP(.vfile ,'-',1)) + 1)
   -- (SGET(text,nchar,pos))
   -- get datevalue as a textvalue
   SET VAR V_PAYMENTDATE_TXT TEXT = (SGET(.vfile ,8,.V_STARTPOSITION) )
   -- (RDATE(mon,day,yr))
   -- convert text value to a date value
   SET VAR V_PAYMENTDATE DATE  = (RDATE(  (NINT( (SGET(.V_PAYMENTDATE_TXT,2,5)) 
)), (NINT( (SGET(.V_PAYMENTDATE_TXT,2,7)) )), (NINT( 
(SGET(.V_PAYMENTDATE_TXT,4,1)) )) ))
 
-- Regards
 
Tony IJ
 
 

 
 

 
 Op 26-07-2021 om 04:39 schreef Tony Luck:
  
 There's a few ways to achieve that, here's one I use to capture the file name 
of a file we import twice daily using a CHOOSE statement that popups up the 
files for the operator. CHOOSE vfile FROM #LFILES IN  TITLE 'Press ESC 
to Exit' +
 CAPTION 'Am Data Import File' OPTION LIST_FONT_SIZE 12 +
 TITLE_FONT_SIZE 12 | TITLE_FONT_COLOR BLUE
  
  From there, if the file name always places the date in the same spot you can 
use SGET function to extract it. 
  P.S. I use an ampersand variable to store the network directory the file is 
loaded to.   
  On Mon, Jul 26, 2021 at 12: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 date (20210720) is buried inside the file name. 
  Is it possible within RBASE to programmatically capture the file name in a 
variable so that I can interrogate the variable to obtain the processing date ? 
  Thanks, 
  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/1438844295.721301.1627265246989%40mail.yahoo.com.
 
  
 
  -- 
 Regards
 Tony -- 
 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/CABnhDARk-7tS5u0t4NC6WmUecE%2B0ONhey4AZddev6VraCeSHjw%40mail.gmail.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/ca4e5ff7-dd79-4c48-4c52-eb399652b41f%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/807717408.839292.1627314401541%40mail.yahoo.com.

[RBASE-L] - Capture a file Name possible

['jim schmitt' via RBASE-L]

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 possible within RBASE to programmatically capture the file name in a 
variable so that I can interrogate the variable to obtain the processing date ?
Thanks,
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/1438844295.721301.1627265246989%40mail.yahoo.com.

[RBASE-L] - Import File

['jim schmitt' via RBASE-L]

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 it to load.  Using RBX5E.
Test File attached.
Do I need to set up a table in the database with the same names as in the test 
file ? Is this truly a tab delimited file ?  Nothing seems to be working ?Maybe 
the file has Covid  Any suggestions would be greatly appreciated.

Thanks in advance,
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/569365336.6619340.1605636079737%40mail.yahoo.com.
AccountIDAmtPaidPayDatePayTimePayType
Last4CName   TransID
1-0040-0063.0010/28/202004:19:56CC5278  
  HARVEST LAND CO OP INC041955
1-0085-0060.7310/28/202004:38:31ACH6108 
   TONY ATCHLEYOKAY N524

Re: [RBASE-L] - report problem

['jim schmitt' via RBASE-L]

 Dan, Razzak, and Karen:
Found something interesting this PM, concerning my problem with being able to 
change the label contents.
If I leave the 'format' option in the View/Toolbars unchecked, the field pops 
up on the right side of the screen so that I can change the label verbiage.
Again, thanks to you three for your ideas.
Regards.


On Wednesday, September 2, 2020, 01:30:04 PM EDT, 'Karen Tellef' via 
RBASE-L  wrote:  
 
 It's a puzzle.  Here's a sample of what you should be seeing.  In my report, I 
click on the Label object "clients".  When I click on it, then up above 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-L 
To: 'Karen Tellef' via RBASE-L 
Sent: Wed, Sep 2, 2020 11:01 am
Subject: Re: [RBASE-L] - report problem

 Thank you to Karen, Razzak, and Dan for your suggestions...but even 
with all boxes checked in the tool bars, there is still no where to change from 
'LABEL x' to anything else.    If I select a data field, I have a drop down to 
select from.
and If I select a variable field, I also have a drop down to select from.
I just don't see a way to change the  verbiage in the label (which is a 
standard control)
HELP !
Jim


On Wednesday, September 2, 2020, 09:54:09 AM EDT, 'Karen Tellef' via 
RBASE-L  wrote:  
 
 Yeah what Dan says.  But also -- I find that if I have RBase in a window, not 
full screen, that the little edit box isn't displayed depending on the size of 
my window.  So the first thing I do is go full screen and it almost always 
magically pops up!
 
 Karen
 
-Original Message-
From: Dan Goldberg 
To: rbase-l@googlegroups.com 
Sent: Wed, Sep 2, 2020 8:48 am
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. 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, 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 
torbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/454039756.2047750.1599052371690%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/2E4830CEC16615458329D3D83342F8D0014E5EA017%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/744417202.1727384.1599054844180%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/1136764038.2162588.1599062514878%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/545392923.1838974.1599067795520%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...@g

Re: [RBASE-L] - report problem

['jim schmitt' via RBASE-L]

 Thank you to Karen, Razzak, and Dan for your suggestions...but even 
with all boxes checked in the tool bars, there is still no where to change from 
'LABEL x' to anything else.    If I select a data field, I have a drop down to 
select from.
and If I select a variable field, I also have a drop down to select from.
I just don't see a way to change the  verbiage in the label (which is a 
standard control)
HELP !
Jim


On Wednesday, September 2, 2020, 09:54:09 AM EDT, 'Karen Tellef' via 
RBASE-L  wrote:  
 
 Yeah what Dan says.  But also -- I find that if I have RBase in a window, not 
full screen, that the little edit box isn't displayed depending on the size of 
my window.  So the first thing I do is go full screen and it almost always 
magically pops up!
 
 Karen
 
-Original Message-
From: Dan Goldberg 
To: rbase-l@googlegroups.com 
Sent: Wed, Sep 2, 2020 8:48 am
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. 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, 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 
torbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/454039756.2047750.1599052371690%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/2E4830CEC16615458329D3D83342F8D0014E5EA017%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/744417202.1727384.1599054844180%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/1136764038.2162588.1599062514878%40mail.yahoo.com.

[RBASE-L] - report problem

['jim schmitt' via RBASE-L]

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, 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/454039756.2047750.1599052371690%40mail.yahoo.com.

Re: [RBASE-L] - File import

['jim schmitt' via RBASE-L]

 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 SUPPORT ! '+      CAPTION ' 
INFORMATION MESSAGE ' ICON ERROR      GOTO ABEND   ENDIF   
---   
---
   LOAD BADGER_INPUT FROM HHUP.CSV AS CSV   ---   CHECK FOR FILE NOT FOUND   IF 
SQLCODE = -2077 THEN      BEEP 'FREQ 200,150'      ---   DEVELOPE THE MESSAGE   
   SET VAR VF_MSG TEXT = +        (' INPUT FILE HHUP.CSV IS NOT PRESENT ! ' ++  
         (CHAR(013)) ++           (CHAR(013)) ++             ' PROCESSING WILL 
TERMINATE !' ++           (CHAR(013))  )      PAUSE 2 USING .VF_MSG +        
CAPTION ' ERROR MESSAGE ' ICON SERIOUS +        OPTION BACK_COLOR WHITE +       
 |MESSAGE_FONT_SIZE 10 +        |MESSAGE_FONT_BOLD ON +        |MESSAGE_COLOR 
WHITE +        |MESSAGE_FONT_COLOR RED      
-      
-        CLOSEWINDOW        
CLEAR VAR VF_%      RETURN   ENDIF   
---   ---   GET A COUNT OF THE 
# OF RECORDS LOADED   SET VAR VF_COUNT INT =  000   SELECT COUNT(*)  INTO 
VF_COUNT INDICATOR VG_IND FROM IMPORT_HH   SET VAR VF_COUNT = (.VF_COUNT -1)
   IF VF_COUNT = 0 THEN      BEEP 'FREQ 200,150'      ---   DEVELOPE THE 
MESSAGE      SET VAR VF_MSG TEXT = +        (' THERE WERE NO ACCOUNTS LOADED ! 
' ++           (CHAR(013)) ++           (CHAR(013)) ++             ' PLEASE 
NOTIFY SUPPORT '    ++           (CHAR(013))   ++           (CHAR(013)) ++      
       ' PROCESSING WILL TERMINATE !' ++           (CHAR(013))  )      PAUSE 2 
USING .VF_MSG +        CAPTION ' ERROR MESSAGE ' ICON SERIOUS +        OPTION 
BACK_COLOR WHITE +        |MESSAGE_FONT_SIZE 10 +        |MESSAGE_FONT_BOLD ON 
+        |MESSAGE_COLOR WHITE +        |MESSAGE_FONT_COLOR RED
      -      
-        CLOSEWINDOW        
CLEAR VAR VF_%      RETURN   ENDIF   
---
Hope this helps.
Jim Schmitt

On Sunday, May 10, 2020, 04:10:38 PM EDT, 'Jim Belisle' via RBASE-L 
 wrote:  
 
 
I forgot that it really is not an Excel file. it is a CSV file.
 
I actually thought of that, Bruce, but as you say, it is not elegant, and I was 
hoping I could find somehow to count the CSV file rows without importing.
 
I may need to go that route. 
 
  
 
James Belisle
 
  
 
Making Information Systems People Friendly Since 1990
 

 
  
 
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com]On Behalf Of 
Bruce Chitiea
Sent: Sunday, May 10, 2020 3:06 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - File import
 
  
 
Perhaps not elegant, but should work
 
  
 
(1) Print the Excel file to a .TXT file
 
(2) Import/Load .TXT file to a TEMP table
 
(3) Count the number of rows to a variable
 
(4) If count value is <2, don't GATEWAY
 
  
 
Bruce
 
  
 
Bruce A. Chitiea
 
SafeSectors, Inc.
 
112 Harvard Ave #272
 
Claremont CA 91711-4716
 
rby...@safesectors.com
 
(909) 238-9012 c
 
  
 
  
 
-- Original Message --
 
From: "'Jim Belisle' via RBASE-L" 
 
To: "rbase-l@googlegroups.com" 
 
Sent: 5/10/2020 12:59:33 PM
 
Subject: [RBASE-L] - File import
 
  
 

I am trying to work with our web administrator in bringing order information 
into RBASE using FTP.
 
The FTP syncornizer creates an Excel file from the web then send that Excel 
file to our server. I then create code that brings that file information into 
RBASE using GATEWAY.
 
 
 
Here is the glitch. On the web side, the automated sync downloading the Excel 
file fires even if there is no info to send to us. That means I end up with a 
file that has a header row but no actual information to import.
 
My GATEWAY just hangs up if there is no actual info to import.
 
So my question. Is there some code or GATEWAY setting that can check an Excel 
file for info so it will not import?
 
My web man says he cannot set up the FTP to NOT send files (if no info 
available) if it is automated to sync with my server at set times.   
 
 
 
The only other option is for the web to export to our server all the web 
traffic every time. That eventually will get to be a BIG file if our web 
traffic increases as we wish.
 
 
 
Can anyone think of anything I can do on the RBASE end? 
 
 
 
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 

Re: [RBASE-L] - Bill Eyring

['jim schmitt' via RBASE-L]

 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, 11:31:27 AM EDT, Doug Hamilton 
 wrote:  
 
 R:Base List - A few years ago you may remember that I was looking for an 
R:Base developer to help with a large project.  Several of you 
responded, for which I am grateful.  We (client and I) chose to have 
Bill Eyring help develop our new order processing database. Our division 
of labor just sort of fell into place - Bill in New York handled 
receiving and sending the data via EDI and the shipping end of the order 
processing.  From Wisconsin, I did the front end processing of the data, 
order preparation and building the output files.

Over the course of many phone calls, Bill and I commiserated in our 
frustrations, rejoiced in our progress, solved world problems and 
ultimately developed a working system.  A large part of the success is 
due to our client's guidance and patience.

With great sadness, I'm writing on behalf of Bill's wife JoAnn to say 
Bill passed away several weeks ago due to complications from the corona 
virus.

This leaves another void in the R:Base community that is needing to be 
filled.  Prudent business practice is to have a backup, an issue for 
subsequent posts.

Doug Hamilton

-- 
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/725e0e3b-c272-4a8e-15b9-7f76a2dcbc6d%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/283587429.773952.1589056356925%40mail.yahoo.com.

[RBASE-L] - forms problems

['jim schmitt' via RBASE-L]

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 design, I get a form design with nothing on 
it (white screen). 
Can anyone tell me what causes this?

Thanks in advance.

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/61598.3779725.1563460411323%40mail.yahoo.com.
For more options, visit https://groups.google.com/d/optout.

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

['jim schmitt' via RBASE-L]

 Thanks Albert:

No passwords used on my tables.

After many hours on this issue, I did discover the culprit - a field named PST 
(abbreviation for Payer State. I changed the field to PSTATE, and everything 
worked fine.

Also, a big shout out to John at RBase for pointing me in the right 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.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 {CVAL('USER')), it returns a user name of NONE.
> 
> Any assistance would be most appreciated.
> 
> Thanks
> 
> Jim Schmitt
> Ohio Software Services
> 614-863-1850
> 
> -- 
> 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/561383832.931035.1562946652594%40mail.yahoo.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/2C40AB5F-94A6-4040-893E-970C8444C002%40albertberry.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/561151334.1031253.1562953423451%40mail.yahoo.com.
For more options, visit https://groups.google.com/d/optout.

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

['jim schmitt' via RBASE-L]

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 {CVAL('USER')), it returns a user name of NONE.

Any assistance would be most appreciated.

Thanks

Jim Schmitt
Ohio Software Services
614-863-1850

-- 
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/561383832.931035.1562946652594%40mail.yahoo.com.
For more options, visit https://groups.google.com/d/optout.

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

['jim schmitt' via RBASE-L]

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 Technologies
   
Monday, December 24, 2018

Dear R:BASE Community,

He's making a database.

He's sorting it twice.

  R> SELECT * FROM Contacts WHERE Behavior = 'Nice' ORDER BY LastName

R:Santa Clause is coming to town!

The team at R:BASE Technologies would like to extend our sincere 
thanks and appreciation
for your business, partnership, and friendship!

In celebrating our 20th Anniversary, we are grateful for your role in 
our achievements,
and look forward to providing new opportunities to help you reach 
your goals for growth
and prosperity.

We're honored that a uniquely warm-spirited community has let us be a 
part of your
business, and we are overwhelmingly proud to have been able to 
deliver products and
support that have helped achieve your database objectives!

However you celebrate, we wish you the very best for this holiday 
season and a happy,
healthy, and prosperous 2019!

My very best R:egards,

Razzak



-- 
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] - Value change in a form

['jim schmitt' via RBASE-L]

 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 a before value, compare with after value still the best 
way to go?
I could create an entry eep to save the value on entry into the row, and then 
get the after value on exit using RBTI_FORM variables, but is there a better 
way?

Albert

-- 
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] - using goto labels in while loop

['jim schmitt' via RBASE-L]

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 7, 2018 4:05 PM
 Subject: RE: [RBASE-L] - using goto labels in while loop
   
#yiv0870360102 #yiv0870360102 -- _filtered #yiv0870360102 {panose-1:2 4 5 3 5 4 
6 3 2 4;} _filtered #yiv0870360102 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 
3 2 4;}#yiv0870360102 #yiv0870360102 p.yiv0870360102MsoNormal, #yiv0870360102 
li.yiv0870360102MsoNormal, #yiv0870360102 div.yiv0870360102MsoNormal 
{margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:sans-serif;}#yiv0870360102
 a:link, #yiv0870360102 span.yiv0870360102MsoHyperlink 
{color:blue;text-decoration:underline;}#yiv0870360102 a:visited, #yiv0870360102 
span.yiv0870360102MsoHyperlinkFollowed 
{color:purple;text-decoration:underline;}#yiv0870360102 
p.yiv0870360102msonormal0, #yiv0870360102 li.yiv0870360102msonormal0, 
#yiv0870360102 div.yiv0870360102msonormal0 
{margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:sans-serif;}#yiv0870360102
 p.yiv0870360102aolmailmsonormal, #yiv0870360102 
li.yiv0870360102aolmailmsonormal, #yiv0870360102 
div.yiv0870360102aolmailmsonormal 
{margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:sans-serif;}#yiv0870360102
 p.yiv0870360102aolmailmsochpdefault, #yiv0870360102 
li.yiv0870360102aolmailmsochpdefault, #yiv0870360102 
div.yiv0870360102aolmailmsochpdefault 
{margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:sans-serif;}#yiv0870360102
 span.yiv0870360102aolmailmsohyperlink {}#yiv0870360102 
span.yiv0870360102aolmailmsohyperlinkfollowed {}#yiv0870360102 
span.yiv0870360102aolmailemailstyle17 {}#yiv0870360102 
p.yiv0870360102aolmailmsonormal1, #yiv0870360102 
li.yiv0870360102aolmailmsonormal1, #yiv0870360102 
div.yiv0870360102aolmailmsonormal1 
{margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:sans-serif;}#yiv0870360102
 span.yiv0870360102aolmailmsohyperlink1 
{color:#0563C1;text-decoration:underline;}#yiv0870360102 
span.yiv0870360102aolmailmsohyperlinkfollowed1 
{color:#954F72;text-decoration:underline;}#yiv0870360102 
span.yiv0870360102EmailStyle26 
{font-family:sans-serif;color:windowtext;}#yiv0870360102 
span.yiv0870360102EmailStyle29 
{font-family:sans-serif;color:windowtext;}#yiv0870360102 
.yiv0870360102MsoChpDefault {font-family:sans-serif;} _filtered #yiv0870360102 
{margin:1.0in 1.0in 1.0in 1.0in;}#yiv0870360102 div.yiv0870360102WordSection1 
{}#yiv0870360102 Thx. Just don’t know why it sometimes throws an error when 
tracing. It says something like an endif or while block not closed    Your 
command file contains an IF...THEN command line without a matching ENDIF, a 
SWITCH without a matching ENDSW or a WHILE...THEN command line without a 
matching ENDWHILE. Enter ENDIF, ENDSW or ENDWHILE to close the loop.    But 
they are all in there. I will keep checking.    BTW,  I like the parameter 
passing idea from inside the while loop.    Dan Goldberg    From: karentellef 
via RBASE-L 
Sent: Monday, May 7, 2018 11:56 AM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - using goto labels in while loop    It's okay to move 
around inside of a while loop, but never to take yououtside of the while loop.

If I need to do something like that, I would:

while 1 = 1 then
   If  then
  set var vAction = 'quit'
  break
   endif

endwhile

set var vAction text
If vAction = 'quit' then
  goto somewhereelse
endif


Karen       -Original Message-
From: Dan Goldberg 
To: rbase-l 
Sent: Mon, May 7, 2018 1:41 pm
Subject: [RBASE-L] - using goto labels in while loop Is using goto label 
commands not a good idea inside while loops?   I was tracing a command file and 
noticed it would give me an error.   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 
torbase-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 
torbase-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 

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

['jim schmitt' via RBASE-L]

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 the early days.   If you would 
like to chat, give me a call at 614-863-1850, and we can discuss your issues.
Thanks
Ohio Software ServicesJim Schmitt1-614-863-1850 

  From: Michael 
 To: RBASE-L  
 Sent: Sunday, November 12, 2017 5:11 PM
 Subject: [RBASE-L] - Developer Needed for DOS 7.5/9.5 Conversion to RBase X
   
I am in need of an experienced developer to convert or recreate about a dozen 
key DOS 7.5/9.5 forms & reports to Rbase X, followed by occasional tutoring on 
RB Windows techniques. If interested, please contact me directly at 
f00f4...@opayq.com (valid but masked email). Our need is immediate tho 
completion can occur in 2018.

Michael Dean, Fine Games, North Bend OR
-- 
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] - Form: Data veification on last field in a row

['jim schmitt' via RBASE-L]

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 have a place to land.
Jim



  From: Albert Berry 
 To: rbase-l@googlegroups.com 
 Sent: Friday, September 30, 2016 1:48 PM
 Subject: [RBASE-L] - Form: Data veification on last field in a row
   
  I have a form used to enter offerings for my parish. The form is shown below. 
Date/Parish/Fund use a hidden dbedit to that #DUP can be used saving the user 
re-entering data, and those three entry items are do not have the tab stop 
enabled. The can override when things change by selecting the field. The 
Envelope number and Amount fields are DBEdit's. 
  The envelope number is verified on leaving the field Env # and I have an eep 
on that field that checks the number, beeps, and if the envelope is invalid, 
displays a popup giving the option of adding a new envelope number or 
correcting the typo. No problems there.
  We do not want null or $0.00 amounts to be added to the database, and the 
column is set to NOT NULL in the data table. The catch is that this is the last 
field in the row and when the user presses enter, I have an exit eep that 
checks the data. The eep doesn't fire before the the form attempts to save the 
row. I tried it as a trigger, but that still didn't seem to work properly. I 
just want the user to hear a beep and be returned to the 
  Any ideas? eep and form are below. 
  { ContactDonationAmount.eep
 Albert Berry
 2016-09-30
 Moved from stored procedure to form field exit that will run before leaving
 the row.
 }
 
    SET VAR vAmountText TEXT, vAmount CURRENCY,vKey TEXT = (LASTKEY(0))
   PAUSE 2 USING .vKey
   IF LASTKEY(0) = "[Esc]" THEN
   GOTO Stop
   ENDIF
   GETPROPERTY cAmount TEXTVALUE "vAmountText"
   SET VAR vAmount = (FLOAT(.vAmountText))
   IF vAmountText IS NULL OR vAmount=0 THEN
   BEEP
   PAUSE 2 USING "You must enter a non zero amount" +
     CAPTION "NO AMOUNT ENTERED" +
     ICON SERIOUS +
     BUTTON "OK" +
     OPTION MESSAGE_FONT_NAME Tahoma +
     |MESSAGE_FONT_COLOR -16777208 +
     |MESSAGE_FONT_SIZE 10 +
     |THEMENAME Royale
   PROPERTY cAmount SET_FOCUS "TRUE"
   PROPERTY cAmount SELECTALL "TRUE"
   ENDIF
 LABEL Stop
   RETURN
 
  
   -- 
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.


   

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