[RBASE-L] - Convert PDF to JPG

[karentellef via RBASE-L]

I had asked about this over a year ago, but the project was dropped.  Now it's 
back on.
I had asked for recommendations of utilities (hopefully free, but doesn't have 
to be) that will convert a 1-page PDF to a JPG.  I need it to be a command-line 
type of thing that will be run from within RBase to temporarily copy a PDF to a 
JPG so that it can be incorporated inside an RBase report.
At the time, 2 programs were recommended, ImageMagick and IrfanView.  However, 
both of these (with more modern OSs) both need DLLs and other programs like 
GhostScript installed before they'll work.  The company doesn't want to have to 
do this on every workstation, nor do they want me installing these other DLLs 
on their server.
So I'm back to asking if there's other recommendations for an all-in-one 
utility that won't make me install other things, can be installed just on the 
server, and run from a command line.  I have a consultant friend whose 
programmers can probably write a .net program for me to do it, but thought I 
would check here just one more time!
Thanks!  Have a great weekend

Karen

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [RBASE-L] - Reports - force a page feed?

[karentellef via RBASE-L]

I had that in my notes and I tried it.  With trace on, I could see it evaluate 
that property for every row of my Cell 9, but it didn't change the live form 
feed.  I'm wondering if that property is something that you would maybe set 
once before the report generates to tell whether a section gets a new page or 
not, and not in the middle of generating the data.
Karen
 
 
 
-Original Message-
From: Claudine Robbins 
To: rbase-l@googlegroups.com 
Sent: Tue, Sep 11, 2018 11:11 am
Subject: RE: [RBASE-L] - Reports - force a page feed?

#yiv6836414550 -- filtered {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 
4;}#yiv6836414550 filtered {font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 
4;}#yiv6836414550 p.yiv6836414550MsoNormal, #yiv6836414550 
li.yiv6836414550MsoNormal, #yiv6836414550 div.yiv6836414550MsoNormal 
{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:New;}#yiv6836414550
 a:link, #yiv6836414550 span.yiv6836414550MsoHyperlink 
{color:blue;text-decoration:underline;}#yiv6836414550 a:visited, #yiv6836414550 
span.yiv6836414550MsoHyperlinkFollowed 
{color:purple;text-decoration:underline;}#yiv6836414550 p 
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New;}#yiv6836414550
 span.yiv6836414550EmailStyle18 {color:#1F497D;}#yiv6836414550 
.yiv6836414550MsoChpDefault {}#yiv6836414550 filtered {margin:1.0in 1.0in 1.0in 
1.0in;}#yiv6836414550 div.yiv6836414550WordSection1 {}#yiv6836414550 I’ve never 
used report bands (Report Controls, Report Band), could that help?    PROPERTY 
 NEWPAGE 'TRUE'    Might be simpler just to create a new break.   
 Claudine    From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com]
Sent: Tuesday, September 11, 2018 10:01 AM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - Reports - force a page feed?    Using version XE.  I have 
a report defined with a field called Descript located.  I have a report 
variable vDescript set up to trap the value.    The values of the field are 
something like "Cell 1", "Cell 2", etc.  It is sorted by this field.   When the 
value hits Cell 9, I'd like to kick the report onto a second page.  I can do a 
"Detail on before generate eep" that traps the variable and gives me a pause 
when it gets to it (so I know it works), but I can't get it to force a page 
feed.  I thought something like this:   IF vDescript = "cell 9" THEN
    NEWPAGE
  ENDIF    The report is based on a temp table, so I can create a new break 
column and assign an A/B for what goes on page 1 and page 2 with a page feed on 
change of break, but I was hoping a simple eep command would work.      Doable? 
   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 
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 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[RBASE-L] - Reports - force a page feed?

[karentellef via RBASE-L]

Using version XE.  I have a report defined with a field called Descript 
located.  I have a report variable vDescript set up to trap the value.
The values of the field are something like "Cell 1", "Cell 2", etc.  It is 
sorted by this field.   When the value hits Cell 9, I'd like to kick the report 
onto a second page.  I can do a "Detail on before generate eep" that traps the 
variable and gives me a pause when it gets to it (so I know it works), but I 
can't get it to force a page feed.  I thought something like this:  IF 
vDescript = "cell 9" THEN
    NEWPAGE
  ENDIF

The report is based on a temp table, so I can create a new break column and 
assign an A/B for what goes on page 1 and page 2 with a page feed on change of 
break, but I was hoping a simple eep command would work.  

Doable?
Karen

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [RBASE-L] - RE: Positioning of popup menus

[karentellef via RBASE-L]

Oh I'm sorry, I totally misread your question!!!


Karen

 

 

-Original Message-
From: Stuart Hellman 
To: rbase-l 
Sent: Fri, Aug 31, 2018 3:38 pm
Subject: [RBASE-L] - RE: Positioning of popup menus



Karen & Albert, thanks for the input.  
 
What I was asking about was about the popup menu in the properties:
 

 
How do I specify the coordinates of this control?
 

From: rbase-l@googlegroups.com On Behalf Of Stuart 
Hellman
Sent: Friday, August 31, 2018 12:00 PM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - Positioning of popup menus

 
Greetings all,
 
When using a popup menu in RBase X, is there a way you can set the coordinates 
as to where the menu will display?  The list of choices is displaying right 
over the field I’m trying to populate. The popup menu shows up right in the 
middle of the form. I’ve tried an ‘ugly’ solution of moving the position of the 
form executing the popup off to the side, but there has got to be a better 
solution.
 
When doing a CHOOSE command, there is an option to set the TOP & LEFT 
coordinates. I was looking for a similar functionality for the popup menu.
 
 
Along the same line, is there a way to highlight an selection on the popup menu 
(again like the CHOOSE command)? This would be useful when setting default 
selections or when user goes back to edit a field, seeing what has been 
selected. 
 
 
Thank you in advance.
 
 
Stu Hellman
 
-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because 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 
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] - Positioning of popup menus

[karentellef via RBASE-L]

You can specify top and left:
CHOOSE vchoice  FROM #VALUES FOR Description FROM chart OPTION TOP 50 | LEFT 10




I haven't used this yet, but here's example code that I saved.  You can 
"pre-select" from a choose by either indicating the value itself or its numeric 
position:


CHOOSE vMenuPick  FROM #VALUES FOR MenuText  FROMAppMenuItems   OPTION  INITPOS 
2  (this is 0-baed) 

 CHOOSE vMenuPick  FROM #VALUES FOR MenuText  FROMAppMenuItems   OPTION  
INITVAL Customer




Karen



 

 

-Original Message-
From: Stuart Hellman 
To: rbase-l 
Sent: Fri, Aug 31, 2018 12:01 pm
Subject: [RBASE-L] - Positioning of popup menus



Greetings all,
 
When using a popup menu in RBase X, is there a way you can set the coordinates 
as to where the menu will display?  The list of choices is displaying right 
over the field I’m trying to populate. The popup menu shows up right in the 
middle of the form. I’ve tried an ‘ugly’ solution of moving the position of the 
form executing the popup off to the side, but there has got to be a better 
solution.
 
When doing a CHOOSE command, there is an option to set the TOP & LEFT 
coordinates. I was looking for a similar functionality for the popup menu.
 
 
Along the same line, is there a way to highlight an selection on the popup menu 
(again like the CHOOSE command)? This would be useful when setting default 
selections or when user goes back to edit a field, seeing what has been 
selected. 
 
 
Thank you in advance.
 
 
Stu Hellman


-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google 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] - Multiple Data Browser Windows

[karentellef via RBASE-L]

Sweet!  Knew I was missing something!   Works great


Karen

 

 

 

-Original Message-
From: A. Razzak Memon 
To: rbase-l 
Sent: Sat, Aug 25, 2018 11:22 am
Subject: Re: [RBASE-L] - Multiple Data Browser Windows

Karen,

You will have to enable the option for "Use Dialog to Open Table/View".

Here's how ...

Main Menu > Settings > Database Explorer ...

[x] Use Dialog to Open Table/View

That's all there is to it!

See attached screen shot for complete details.

Have fun!

Razzak


At 11:43 AM 8/25/2018, karentellef via RBASE-L wrote:

>Razzak:  Can you explain exactly how to get the #01 data browser
>selection screen to come up?  I'm using the latest build of X, and
>no menu selection or clicking technique brings up that dialog box
>where I can check "MDI".
>
>Thanks!!
>
>Karen
>
>-Original Message-
>From: A. Razzak Memon 
>To: rbase-l 
>Sent: Sat, Aug 25, 2018 12:19 am
>Subject: Re: [RBASE-L] - Multiple Data Browser Windows
>
>D'day Clive,
>
>There are three approaches to accomplish the desired results ...
>
>01. While opening the table, make sure to check the option for MDI.
>
>Database Explorer > Database Explorer > Tables > Open
>
>Make sure to check the box for [x] MDI
>
>See attached screen shot for complete details.
>
>02. You may update the RBEngineX.CFG or RBEngineXE.cfg to turn the
>MDI option to ON.
>
>Database Explorer > Main Menu > Settings > Configuration Settings ...
>
>Operating Conditions ...
>
>Make sure to check the option for [ ] MDI
>
>See attached screen shot for complete details
>
>03. You may also include the following setting in your database
>startup file as follows:
>
>SET MDI ON
>
>Hope that helps!
>
>Very Best R:egards,
>
>Razzak
>
>At 12:56 AM 8/25/2018, Clive wrote:
>
> >G'day all
> >
> >Using latest version of R:Base X Enterprise. I can only open one
> >table at a time in the Data Browser.
> >Is there a way of having more than one Browser window open at once
> >so I can have two tables side by
> >side? Now, when I have the Data Browser window open for one table I
> >get a beep if I try to open anything
> >outside the browser window.


-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google 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] - Multiple Data Browser Windows

[karentellef via RBASE-L]

Razzak:  Can you explain exactly how to get the #01 data browser
selection screen to come up?  I'm using the latest build of X, and
no menu selection or clicking technique brings up that dialog box
where I can check "MDI".


Thanks!!


Karen

 

 

 

-Original Message-
From: A. Razzak Memon 
To: rbase-l 
Sent: Sat, Aug 25, 2018 12:19 am
Subject: Re: [RBASE-L] - Multiple Data Browser Windows

D'day Clive,

There are three approaches to accomplish the desired results ...

01. While opening the table, make sure to check the option for MDI.

   Database Explorer > Database Explorer > Tables > Open

 Make sure to check the box for [x] MDI

 See attached screen shot for complete details.

02. You may update the RBEngineX.CFG or RBEngineXE.cfg to turn the 
MDI option to ON.

 Database Explorer > Main Menu > Settings > Configuration Settings ...

 Operating Conditions ...

 Make sure to check the option for [ ] MDI

 See attached screen shot for complete details

03. You may also include the following setting in your database 
startup file as follows:

 SET MDI ON

Hope that helps!

Very Best R:egards,

Razzak

At 12:56 AM 8/25/2018, Clive wrote:

>G'day all
>
>Using latest version of R:Base X Enterprise.  I can only open one 
>table at a time in the Data Browser.
>Is there a way of having more than one Browser window open at once 
>so I can have two tables side by
>side?  Now, when I have the Data Browser window open for one table I 
>get a beep if I try to open anything
>outside the browser window.



-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google 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] - Determining operating condition -- Standalone vs. Scripted

[karentellef via RBASE-L]

I can only think of the really low-tech way that I do it (because I do the 
exact same thing you do)


When running a routine from another place (like calling from another program or 
from a menu system), I would do this:
  SET VAR vFromProgram = 'Overnightrun'
  RUN whatever.rmd
  CLEAR VAR vFromProgram




Then whatever.rmd would do
  SET VAR vFromProgram TEXT
  IF vFromProgram IS NULL (or '= Overnight') THEN
 do whatever
  ENDIF


Karen

 

 

 

-Original Message-
From: mike.ramsour 
To: rbase-l 
Sent: Fri, Aug 17, 2018 9:19 am
Subject: [RBASE-L] - Determining operating condition -- Standalone vs. Scripted


Good morning:

Is there a way to determine the operatingcondition that R:BASE programs are 
running in?  I didn't see a CVALfunction that would match what I'm thinking of.

For example, I have a set of 300+ programsthat run daily in a set sequence over 
a 3-hour time period.  For variousreasons any of these programs may need to be 
run individually from theR>.

For example at the R>:  RUNSuchAndSuch.RMD

There are situations where it wouldhelpful to be able to determine whether the 
program was launched separatelywith the RUN command vs. running in a sequence 
of programs.

Something like:

IF (CVAL("Standalone")) =1 THEN

Do something

ELSE

Do something else

ENDIF

Is there something already in placethat would let me test for this situation?

If not I might be contacting the DreamTeam soon.

Thanks for sharing any thoughts or suggestions.


Mike Ramsour
AK Steel Coshocton Works
Quality Department
Phone:  740-829-4340
Cell:  740-502-1659
Confidentiality Notice
This message is intended exclusively for the individual or entity to which it 
is addressed and may contain privileged, proprietary, or otherwise private 
information.  
If you are not the named addressee, you are not authorized to read, print, 
retain, copy or disseminate this message or any part of it.  If you have 
received this message in error, please notify the sender immediately by e-mail 
and delete all copies of the message.

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
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] - Tip of the Day: Enhanced Case Sensitive and Whole Word Search Options

[karentellef via RBASE-L]

I can sure see using the "whole word" search!


But being me, I always test to the nth degree, and I am thrilled to
announce that it works perfectly, ignoring punctuation.


For example, it found the whole word even if there was parenthesis 

or commas around it.  It located the word "BLNo" in these
2 examples I typed into a custom eep:


CREATE TEMP TABLE tmpBL (BLNo Int ..)
SELECT blno, bdate INTO ..



Good job!


Karen

 

 

 

-Original Message-
From: A. Razzak Memon 
To: rbase-l 
Sent: Wed, Aug 8, 2018 7:08 am
Subject: [RBASE-L] - Tip of the Day: Enhanced Case Sensitive and Whole Word 
Search  Options

Wednesday, August 08, 2018

Tip of the Day: Enhanced Case Sensitive and Whole Word Search Options
Product...: R:BASE X and R:BASE X Enterprise (Version 10)
Build.: 10.0.4.10808 or higher
Sections..: Database Explorer, Forms, Reports, Labels, External Forms
Keywords..: Search, EEPs, Expressions, Control Properties, Case 
Sensitive, Whole Word

Did you know the search capabilities for finding text in Custom EEPs, 
Control Properties, and
Expressions has been enhanced to include "case sensitive" and "whole 
word" criteria?

When searching for text in Custom EEPs, Control Properties, and 
Expressions, for database Forms,
Reports, Labels, External Forms, and Applications, the "Find in" 
dialog now includes the "Match
Case" and "Whole Word" options for more detailed searches.

Emacs!


http://www.razzak.com/tips/RBGX_FindInCustomEEPsForms_Options.png

The added capability adds to the existing search capabilities built 
into R:BASE X/X Enterprise
(Version 10) for users to locate text within the database modules and 
within external files,
including:

01. Find in Database Explorer
02. Find in Stored Procedures
03. Find in Custom EEPs - [Ctrl] + F
  . Find in Form Custom EEPs
 . Find in Report Custom EEPs
 . Find in Label Custom EEPs
 . Find in Application Custom EEPs
 . Find in External Form Custom EEPs
04. Find in Control Properties - [Ctrl] + L
 . Find in Form Control Properties
 . Find in Report Control Properties
 . Find in Label Control Properties
 . Find External Form Control Properties
05. Find in Expressions - [Ctrl] + [Shift] + F
 . Find in Form Expressions
 . Find in Report Expressions
 . Find in Label Expressions
06. Find in Files
07. Find in R> Prompt Output

 From The Edge: http://www.razzak.com/fte
Topic: Searching in R:BASE X and R:BASE X Enterprise (Version 10)

Very Best R:egards,

Razzak.

https://www.rbase.com
http://www.facebook.com/rbase/

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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

[karentellef via RBASE-L]

That's almost all I ever use too, (cval('netuser')).  I've never used cfg files 
for that.



I have a couple installations where there is a general windows logon just to 
boot the computer up, and then multiple people will use that machine.  In those 
cases I will institute a log on / password routine within RBase, compared to a 
table that holds the list.


Karen

 

 

 

-Original Message-
From: Dan Goldberg 
To: rbase-l 
Sent: Mon, Aug 6, 2018 8:33 am
Subject: RE: [RBASE-L] - using user IDs and passwords for RBASE



I use the cval(‘netuser’) to authenticate and give permissions from there. I 
have a table with the users/windows logon names with their access rights. Based 
on their rights the menu will displayed.
 
Dan Goldberg
 

From: rbase-l@googlegroups.com On Behalf Of Jim 
Belisle
Sent: Monday, August 6, 2018 4:41 AM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - using user IDs and passwords for RBASE

 
Buddy and Albert,
 
Thanks for the information. I am in meetings the first part of the week so will 
have to wait on this.
I am not sure if I mentioned this to you but I am the only one who has a full 
version of RBASE.
I create the compiled application and all others use this application and use 
the same CFG file on the server.
That CFG is located on the server in the same folder as the compiled apps and 
any DLLS or other programs needed in RBASE.
 
So as you can see, all this is new to me and I am having trouble “connecting 
the dots”.
I will read the RBASE pdfs to see if I can get further understanding on setting 
up log ins based on users in a compiled app system.
I have read this in the past but we did not implement. 
 

James Belisle
 
Making Information Systems People Friendly Since 1990


 

From:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com]On Behalf Of 
Buddy Walker
Sent: Saturday, August 4, 2018 10:40 PM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - using user IDs and passwords for RBASE

 
Jim
  Each user will need there own RBENGINEXE.CFG (RBENGINEX.CFG) file. You would 
have to visit each user’s PC once and update the RBENGINEXE.CFG (RBENGINEX.CFG) 
this can be done in couple of different ways:
1.  Start a session of R:Base and then select Settings > Configuration 
Settings > Multi User now in the NAME box type in the users windows/exchange 
name
2.  The other way is edit the file using Notepad or some other text editor. 
Find the line that starts with NAME and then highlight and replace the name 
that is there.
 
   Now just follow Albert’s example below.
 
Buddy
 

From: rbase-l@googlegroups.com On Behalf Of Albert 
Berry
Sent: Saturday, August 4, 2018 12:05 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - using user IDs and passwords for RBASE

 
Create a Windows file and add it to the line in the user icon that calls the 
database. It should read as Buddy suggested. In the icon command line below, I 
called it DBLogin.dat

 



IF CVAL (‘USER’) <> (‘NETUSER’) THEN


PAUSE 2 USING ‘Not Authorized’

EXIT

RETURN

 


The icon would read along these lines. The default is RBASE.DAT but I would not 
recommend that, because that would give you indigestion every time you tried to 
log into the database.

C:\RBTI\RBGXE\RBGXE.exe DBLogin.dat

 

As Razzak would say “That’s all there is to it”

 

Albert

 


 

On Aug 4, 2018, at 9:16 AM, Jim Belisle  wrote:

 

Buddy,

 

Thanks for the response.

You are talking to someone who is very ignorant of how to even start down this 
road.

 

At the present the DB is setup without IDs (USER is NONE) I need to know how to 
get that setup in the first place.

The code set var vu = (CVAL('USER')) gives my NONE as an answer.

 

So I will need to start from the beginning.

We are talking about an application in which 12 to 15 users will be accessing 
the DB.

I do not know the passwords for the users.

 


James Belisle

 

Making Information Systems People Friendly Since 1990




 


From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Buddy Walker
Sent: Saturday, August 4, 2018 10:02 AM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - using user IDs and passwords for RBASE


 

Jim

  Use the CVAL(‘USER’) and CVAL(‘NETUSER’)

 

  If CVAL(‘USER’) <> CVAL(‘NETUSER’) THEN

   PAUSE 2 USI ‘Not Authorized’ 

   EXIT

  ENDIF

   

 Just make sure the CFG name matches the Network User Name.  This way you won’t 
have to worry about R:Base password Windows should handle everything.

 

Buddy

 

 


From: rbase-l@googlegroups.com  On Behalf Of Jim 
Belisle
Sent: Saturday, August 4, 2018 9:43 AM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - using user IDs and passwords for RBASE


 

We are needing to change our RBASE application so as to require user IDS and 
passwords. Here is what we want to do.

We want the computer login USER and password to be used as the login for RBASE.

In other words, I want this to be automatic so the user does not need to fill 
in 

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

[karentellef via RBASE-L]

Sweet!


Karen

 

 

 

-Original Message-
From: Claudine Robbins 
To: rbase-l 
Sent: Wed, Aug 1, 2018 2:45 pm
Subject: RE: [RBASE-L] - Picking and Renaming Windows Files



Like a charm.
 
Thank you Karen!
 

 
From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com]
Sent: Wednesday, August 01, 2018 2:12 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Picking and Renaming Windows Files
 

Ahh I think I see what you're trying to do.  Because you have multiple 
filenames I think you'd have to strip each one.  I haven't tested this code, 
just winging it, but something like this might work.  This would load each 
filename into the table.  The only problem you might have is if the filenames 
contain spaces. 

 

set var vloop int = 1

while 1 = 1 then

  set var vtext = (ssub(.vfilename,.vloop))

  if vtext is null then

break

  endif

 

  insert into tfilename (filen) values (.vtext)

 

  set var vloop = (.vloop + 1)

endwhile

 

 

Karen

 

 

 

-Original Message-
From: Claudine Robbins 
To: rbase-l 
Sent: Wed, Aug 1, 2018 2:04 pm
Subject: RE: [RBASE-L] - Picking and Renaming Windows Files


Karen,

 

I tried at least half a dozen combinations including:

R>INSERT INTO tfilename SELECT ALL FROM 

-ERROR- Syntax error (2367)

And get syntax errors…

 

Claudine

 

From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com]
Sent: Wednesday, August 01, 2018 1:10 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Picking and Renaming Windows Files

 

Claudine:   This syntax doesn't look right.  Either you would use VALUES or 
SELECT, but not both


INSERT INTO tfilename (FILEN) VALUES (FILEN) SELECT ALL FROM 


 


 


Karen


 


 


-Original Message-
From: Buddy Walker 
To: rbase-l 
Sent: Wed, Aug 1, 2018 1:03 pm
Subject: RE: [RBASE-L] - Picking and Renaming Windows Files



Claudine


  Since you have commas in the file I would think you have to load the table 
instead of insert.


 


Buddy


 


 



From: rbase-l@googlegroups.com On Behalf Of Claudine 
Robbins
Sent: Wednesday, August 1, 2018 1:21 PM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - Picking and Renaming Windows Files



 


Hi all,


 


I’m trying to capture multiple file names to rename them.  The following code 
gives me the error: “ERROR-Incorrect number of values for this table (118)”.


 


It appears I may need quotes around each value.  Any easy way to do this?


 


TIA,


 


Claudine


 


PLUGINS LoadFileNamePlus vFileName +


|INITIAL_DIR C:\iex_x\CHRISPREP +


|TITLE 'Select file' +


|FULLPATH ON +


|NO_CHANGE_DIR ON +


|FILTER PDF Files (*.PDF)#*.PDF +


|HIDE_READ_ONLY ON +


|MULTISELECT ON +


|SHOW_HIDDEN OFF +


|ENABLE_SIZING ON +


|VIEW_MODE LIST


 


SET VAR vfilename = ( '('+.vfilename+')' )


 


SET ERROR MESSAGE 2058 OFF


DROP TABLE `tFileName` NOCHECK


SET ERROR MESSAGE 2058 ON


CREATE TEMP TABLE `tFileName` (`FILEN` TEXT (40))


 


R>INSERT INTO tfilename (FILEN) VALUES (FILEN) SELECT ALL FROM 


-ERROR- Incorrect number of values for this table ( 118)


 


R>sho v vfilename


(C:\IEX_X\CHRISPREP\ACME-54572


05-BU-0702181107AU.pdf,C:\IEX_


X\CHRISPREP\ACME-5457205-07021


81107AU.pdf,C:\IEX_X\CHRISPREP


\ACME-5457205-INV-0702181107AU


.pdf)


--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because 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 
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

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

[karentellef via RBASE-L]

Ahh I think I see what you're trying to do.  Because you have multiple 
filenames I think you'd have to strip each one.  I haven't tested this code, 
just winging it, but something like this might work.  This would load each 
filename into the table.  The only problem you might have is if the filenames 
contain spaces.  



set var vloop int = 1
while 1 = 1 then
  set var vtext = (ssub(.vfilename,.vloop))
  if vtext is null then
break
  endif


  insert into tfilename (filen) values (.vtext)



  set var vloop = (.vloop + 1)

endwhile




Karen

 

 

 

-Original Message-
From: Claudine Robbins 
To: rbase-l 
Sent: Wed, Aug 1, 2018 2:04 pm
Subject: RE: [RBASE-L] - Picking and Renaming Windows Files



Karen,
 
I tried at least half a dozen combinations including:
R>INSERT INTO tfilename SELECT ALL FROM 
-ERROR- Syntax error (2367)
And get syntax errors…
 
Claudine
 
From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com]
Sent: Wednesday, August 01, 2018 1:10 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Picking and Renaming Windows Files
 
Claudine:   This syntax doesn't look right.  Either you would use VALUES or 
SELECT, but not both

INSERT INTO tfilename (FILEN) VALUES (FILEN) SELECT ALL FROM 

 

 

Karen

 

 

-Original Message-
From: Buddy Walker 
To: rbase-l 
Sent: Wed, Aug 1, 2018 1:03 pm
Subject: RE: [RBASE-L] - Picking and Renaming Windows Files


Claudine

  Since you have commas in the file I would think you have to load the table 
instead of insert.

 

Buddy

 

 


From: rbase-l@googlegroups.com On Behalf Of Claudine 
Robbins
Sent: Wednesday, August 1, 2018 1:21 PM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - Picking and Renaming Windows Files


 

Hi all,

 

I’m trying to capture multiple file names to rename them.  The following code 
gives me the error: “ERROR-Incorrect number of values for this table (118)”.

 

It appears I may need quotes around each value.  Any easy way to do this?

 

TIA,

 

Claudine

 

PLUGINS LoadFileNamePlus vFileName +

|INITIAL_DIR C:\iex_x\CHRISPREP +

|TITLE 'Select file' +

|FULLPATH ON +

|NO_CHANGE_DIR ON +

|FILTER PDF Files (*.PDF)#*.PDF +

|HIDE_READ_ONLY ON +

|MULTISELECT ON +

|SHOW_HIDDEN OFF +

|ENABLE_SIZING ON +

|VIEW_MODE LIST

 

SET VAR vfilename = ( '('+.vfilename+')' )

 

SET ERROR MESSAGE 2058 OFF

DROP TABLE `tFileName` NOCHECK

SET ERROR MESSAGE 2058 ON

CREATE TEMP TABLE `tFileName` (`FILEN` TEXT (40))

 

R>INSERT INTO tfilename (FILEN) VALUES (FILEN) SELECT ALL FROM 

-ERROR- Incorrect number of values for this table ( 118)

 

R>sho v vfilename

(C:\IEX_X\CHRISPREP\ACME-54572

05-BU-0702181107AU.pdf,C:\IEX_

X\CHRISPREP\ACME-5457205-07021

81107AU.pdf,C:\IEX_X\CHRISPREP

\ACME-5457205-INV-0702181107AU

.pdf)

--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because 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 
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 
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] - Picking and Renaming Windows Files

[karentellef via RBASE-L]

Claudine:   This syntax doesn't look right.  Either you would use VALUES or 
SELECT, but not both

 INSERT INTO tfilename (FILEN) VALUES (FILEN) SELECT ALL FROM 




Karen

 

 

-Original Message-
From: Buddy Walker 
To: rbase-l 
Sent: Wed, Aug 1, 2018 1:03 pm
Subject: RE: [RBASE-L] - Picking and Renaming Windows Files



Claudine
  Since you have commas in the file I would think you have to load the table 
instead of insert.
 
Buddy
 
 

From: rbase-l@googlegroups.com  On Behalf Of Claudine 
Robbins
Sent: Wednesday, August 1, 2018 1:21 PM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - Picking and Renaming Windows Files

 
Hi all,
 
I’m trying to capture multiple file names to rename them.  The following code 
gives me the error: “ERROR-Incorrect number of values for this table (118)”.
 
It appears I may need quotes around each value.  Any easy way to do this?
 
TIA,
 
Claudine
 
PLUGINS LoadFileNamePlus vFileName +
|INITIAL_DIR C:\iex_x\CHRISPREP +
|TITLE 'Select file' +
|FULLPATH ON +
|NO_CHANGE_DIR ON +
|FILTER PDF Files (*.PDF)#*.PDF +
|HIDE_READ_ONLY ON +
|MULTISELECT ON +
|SHOW_HIDDEN OFF +
|ENABLE_SIZING ON +
|VIEW_MODE LIST
 
SET VAR vfilename = ( '('+.vfilename+')' )
 
SET ERROR MESSAGE 2058 OFF
DROP TABLE `tFileName` NOCHECK
SET ERROR MESSAGE 2058 ON
CREATE TEMP TABLE `tFileName` (`FILEN` TEXT (40))
 
R>INSERT INTO tfilename (FILEN) VALUES (FILEN) SELECT ALL FROM 
-ERROR- Incorrect number of values for this table ( 118)
 
R>sho v vfilename
(C:\IEX_X\CHRISPREP\ACME-54572
05-BU-0702181107AU.pdf,C:\IEX_
X\CHRISPREP\ACME-5457205-07021
81107AU.pdf,C:\IEX_X\CHRISPREP
\ACME-5457205-INV-0702181107AU
.pdf)
-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [RBASE-L] - Blank date value

[karentellef via RBASE-L]

Bill:  She's saying that NULL date values are displaying like that in a form.   



Claudine:  does the database see them as null?  If you did a select where 
datecol is null, do they show up?


Karen

 

 

 

-Original Message-
From: Bill Downall 
To: rbase-l 
Sent: Fri, May 25, 2018 7:19 am
Subject: Re: [RBASE-L] - Blank date value



Claudine,


If you can write a WHERE clause that finds all the bad dates, you should be 
able to write an UPDATE that fixes them. 


Are all the wrong dates off by exactly a century? If not, you will have to make 
your WHERE clause more complicated, and do this more than once.


SELECT datecolumn FROM tablename WHERE datecolumn <= '01/01/1900'


UPDATE tablename SET datecolumn = +
 (RDATE(imon(datecolumn), iday(datecolumn), (iyr4(datecolumn) + 100 )) +
WHERE datecolumn <= '01/01/1900'


Bill


On Thu, May 24, 2018 at 9:50 PM, Claudine Robbins  wrote:


Hello all,
 
I’m on latest release.  Some null values in a date field on a form are coming 
up 12/30/99, fully extended to 12/30/1899!  There are no values in that field 
in the table and the field correctly takes whatever date is inserted and saves 
it to the table.
 
I switched from 2-digit year to 4-digit year a few months ago and wonder if 
that’s when this started.  I reloaded the database, ran it through R:Scope and 
all is sound.
 
Any ideas on how to fix this?
 
TIA,
 
Claudine


-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.




-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [RBASE-L] - How Get Individual Reports to PRINT in Report Head the TOTAL # entries for THAT report only?

[karentellef via RBASE-L]

Do you have the break set on a variable?   If so, that has never worked.  It 
doesn't evaluate variables
before hand, just row by row, and for a break it has to know the values before 
the report loads.


To get around it, create a view that has the IMON as an actual column and set 
that as the break


Karen


 

 

 

-Original Message-
From: Jim Belisle <j...@kaypark.com>
To: rbase-l <rbase-l@googlegroups.com>
Sent: Thu, May 24, 2018 8:02 am
Subject: RE: [RBASE-L] - How Get Individual Reports to PRINT in Report Head the 
TOTAL # entries for THAT report only?



Since you are talking about DBcalcs, I have a question.
I just created a report in which I use DBcalcs in two variable footers, one for 
the week and one for the month, and one column footer for each day.
I am using the COUNT function to count orders each day (this is a column), week 
(using IWOY) and month (IMON).
Each DBCalc is in a separate break footer for the day, week and month.
For some reason the first order of the beginning of the week always resets then 
goes onto the rest of the orders in that week.
See below and notice the first order of the first day of each week resets 
itself.
What simple thing am I doing wrong? I will be leaving soon to be on the road 
two hours so will not be able to respond.

 

James Belisle
 
Making Information Systems People Friendly Since 1990


 

From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com]
Sent: Thursday, May 24, 2018 7:27 AM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - How Get Individual Reports to PRINT in Report Head the 
TOTAL # entries for THAT report only?

 

Awesome!  Glad we both gave you hints.  DB Calcs are an awesome addition to 
reports since

the 6.5 days.   Whenever I do a conversion, I try to replace all the old report 
variables

with DB Calcs.  Especially nice is that they automatically reset themselves on 
a break level,

no more remembering (or rather, forgetting) to specify a "reset" at break 
levels!

 

Karen

 

 

 

-Original Message-
From: Cathy Grimes <cfgri...@verizon.net>
To: rbase-l <rbase-l@googlegroups.com>
Sent: Thu, May 24, 2018 3:10 am
Subject: RE: [RBASE-L] - How Get Individual Reports to PRINT in Report Head the 
TOTAL # entries for THAT report only?


IT WORKED!  Such a simple addition to the DBCalc Karen suggested enabled me to, 
FINALLY, get all the counts I wanted on my reports – THANK YOU SO MUCH!!

 

Cathy

 


From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com]On Behalf Of 
Dan Goldberg
Sent: Wednesday, May 23, 2018 10:40 AM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - How Get Individual Reports to PRINT in Report Head the 
TOTAL # entries for THAT report only?


 

Try checking the “look ahead”. Right click on it and check it then give it a 
try.

 



 

Dan Goldberg

 


From:rbase-l@googlegroups.com <rbase-l@googlegroups.com>On Behalf Of Cathy 
Grimes
Sent: Wednesday, May 23, 2018 10:36 AM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - How Get Individual Reports to PRINT in Report Head the 
TOTAL # entries for THAT report only?


 

Thanks so much for taking the time to respond, Karen.

 

I got through your steps to the end, so very clear explanation.  Unfortunately, 
all I get is “1” as a response no matter what where clauses I use in testing 
the report.  It sounds like this is the right method, so I don’t know why it’s 
not working.

 

Cathy

 

From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com]
Sent: Wednesday, May 23, 2018 6:59 AM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - How Get Individual Reports to PRINT in Report Head the 
TOTAL # entries for THAT report only?

 

Since you upgraded from an earlier version, I'm guessing you might have an "old 
style" variable.   You should instead locate a "DB Calc".  Find that control in 
the database controls list and locate it on the report (delete the location for 
your variable).   Above it, you'll see a "data field" area where you select the 
column you are counting.  Then right-click on the control, select Calculations, 
and select "count".   Now it will operate on whatever where clause you print 
the report for. 


 


Hope that made sense!


 


Karen


 


 


 


-Original Message-
From: Cathy Grimes <cfgri...@verizon.net>
To: rbase-l <rbase-l@googlegroups.com>
Sent: Wed, May 23, 2018 8:43 am
Subject: [RBASE-L] - How Get Individual Reports to PRINT in Report Head the 
TOTAL # entries for THAT report only?



I still haven’t been able to fix some of the R:Base upgrade differences that 
negated a few of my previous entries/variables that worked before.  It’s been 
decades since I did any database/form/report/table designing with my database 
except add rows using my previous forms and print existing reports.


 


I have R:Base Extreme 9 (C:\RBTI\RBG95_32\RBG95_32.exe).  I have one report 
that I f

Re: [RBASE-L] - How Get Individual Reports to PRINT in Report Head the TOTAL # entries for THAT report only?

[karentellef via RBASE-L]

Awesome!  Glad we both gave you hints.  DB Calcs are an awesome addition to 
reports since
the 6.5 days.   Whenever I do a conversion, I try to replace all the old report 
variables
with DB Calcs.  Especially nice is that they automatically reset themselves on 
a break level,
no more remembering (or rather, forgetting) to specify a "reset" at break 
levels!


Karen

 

 

 

-Original Message-
From: Cathy Grimes <cfgri...@verizon.net>
To: rbase-l <rbase-l@googlegroups.com>
Sent: Thu, May 24, 2018 3:10 am
Subject: RE: [RBASE-L] - How Get Individual Reports to PRINT in Report Head the 
TOTAL # entries for THAT report only?



IT WORKED!  Such a simple addition to the DBCalc Karen suggested enabled me to, 
FINALLY, get all the counts I wanted on my reports – THANK YOU SO MUCH!!
 
Cathy
 

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Dan Goldberg
Sent: Wednesday, May 23, 2018 10:40 AM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - How Get Individual Reports to PRINT in Report Head the 
TOTAL # entries for THAT report only?

 
Try checking the “look ahead”. Right click on it and check it then give it a 
try.
 

 
Dan Goldberg
 

From: rbase-l@googlegroups.com <rbase-l@googlegroups.com> On Behalf Of Cathy 
Grimes
Sent: Wednesday, May 23, 2018 10:36 AM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - How Get Individual Reports to PRINT in Report Head the 
TOTAL # entries for THAT report only?

 
Thanks so much for taking the time to respond, Karen.
 
I got through your steps to the end, so very clear explanation.  Unfortunately, 
all I get is “1” as a response no matter what where clauses I use in testing 
the report.  It sounds like this is the right method, so I don’t know why it’s 
not working.
 
Cathy
 
From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com] 
Sent: Wednesday, May 23, 2018 6:59 AM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - How Get Individual Reports to PRINT in Report Head the 
TOTAL # entries for THAT report only?
 
Since you upgraded from an earlier version, I'm guessing you might have an "old 
style" variable.   You should instead locate a "DB Calc".  Find that control in 
the database controls list and locate it on the report (delete the location for 
your variable).   Above it, you'll see a "data field" area where you select the 
column you are counting.  Then right-click on the control, select Calculations, 
and select "count".   Now it will operate on whatever where clause you print 
the report for. 

 

Hope that made sense!

 

Karen

 

 

 

-Original Message-
From: Cathy Grimes <cfgri...@verizon.net>
To: rbase-l <rbase-l@googlegroups.com>
Sent: Wed, May 23, 2018 8:43 am
Subject: [RBASE-L] - How Get Individual Reports to PRINT in Report Head the 
TOTAL # entries for THAT report only?


I still haven’t been able to fix some of the R:Base upgrade differences that 
negated a few of my previous entries/variables that worked before.  It’s been 
decades since I did any database/form/report/table designing with my database 
except add rows using my previous forms and print existing reports.

 

I have R:Base Extreme 9 (C:\RBTI\RBG95_32\RBG95_32.exe).  I have one report 
that I frequently use and just change the ‘where’ clauses to suit each report.  
I cannot find a way in this R:Base for the report to simply count the total of 
each main entry (i.e., ‘title’) SPECIFIC to EACH REPORT’s ‘where’ clause that I 
give the report when I ask it to print.  The only way I’ve managed to get the 
count is to go to DESIGN, variables and CHANGE the variable to the same ‘where’ 
clause as the particular report I’m printing.  But it would be so much easier 
if I could just add a variable where R:Base can just use the where clause I 
give it each time I print the report.  (Hope that makes sense).

 

If anyone knows how I could do this, I would really appreciate it.  Thank you.

 

Cathy

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from 

Re: [RBASE-L] - How Get Individual Reports to PRINT in Report Head the TOTAL # entries for THAT report only?

[karentellef via RBASE-L]

Where did you place the DB Calc?   Put it in the Report Footer to be the most 
effective, or in the Break Footer if the calculation resets on a break level


Karen

 

 

 

-Original Message-
From: Cathy Grimes <cfgri...@verizon.net>
To: rbase-l <rbase-l@googlegroups.com>
Sent: Wed, May 23, 2018 12:36 pm
Subject: RE: [RBASE-L] - How Get Individual Reports to PRINT in Report Head the 
TOTAL # entries for THAT report only?



Thanks so much for taking the time to respond, Karen.
 
I got through your steps to the end, so very clear explanation.  Unfortunately, 
all I get is “1” as a response no matter what where clauses I use in testing 
the report.  It sounds like this is the right method, so I don’t know why it’s 
not working.
 
Cathy
 
From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com] 
Sent: Wednesday, May 23, 2018 6:59 AM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - How Get Individual Reports to PRINT in Report Head the 
TOTAL # entries for THAT report only?
 
Since you upgraded from an earlier version, I'm guessing you might have an "old 
style" variable.   You should instead locate a "DB Calc".  Find that control in 
the database controls list and locate it on the report (delete the location for 
your variable).   Above it, you'll see a "data field" area where you select the 
column you are counting.  Then right-click on the control, select Calculations, 
and select "count".   Now it will operate on whatever where clause you print 
the report for. 

 

Hope that made sense!

 

Karen

 

 

 

-Original Message-
From: Cathy Grimes <cfgri...@verizon.net>
To: rbase-l <rbase-l@googlegroups.com>
Sent: Wed, May 23, 2018 8:43 am
Subject: [RBASE-L] - How Get Individual Reports to PRINT in Report Head the 
TOTAL # entries for THAT report only?


I still haven’t been able to fix some of the R:Base upgrade differences that 
negated a few of my previous entries/variables that worked before.  It’s been 
decades since I did any database/form/report/table designing with my database 
except add rows using my previous forms and print existing reports.

 

I have R:Base Extreme 9 (C:\RBTI\RBG95_32\RBG95_32.exe).  I have one report 
that I frequently use and just change the ‘where’ clauses to suit each report.  
I cannot find a way in this R:Base for the report to simply count the total of 
each main entry (i.e., ‘title’) SPECIFIC to EACH REPORT’s ‘where’ clause that I 
give the report when I ask it to print.  The only way I’ve managed to get the 
count is to go to DESIGN, variables and CHANGE the variable to the same ‘where’ 
clause as the particular report I’m printing.  But it would be so much easier 
if I could just add a variable where R:Base can just use the where clause I 
give it each time I print the report.  (Hope that makes sense).

 

If anyone knows how I could do this, I would really appreciate it.  Thank you.

 

Cathy

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google 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] - How Get Individual Reports to PRINT in Report Head the TOTAL # entries for THAT report only?

[karentellef via RBASE-L]

Since you upgraded from an earlier version, I'm guessing you might have an "old 
style" variable.   You should instead locate a "DB Calc".  Find that control in 
the database controls list and locate it on the report (delete the location for 
your variable).   Above it, you'll see a "data field" area where you select the 
column you are counting.  Then right-click on the control, select Calculations, 
and select "count".   Now it will operate on whatever where clause you print 
the report for.


Hope that made sense!


Karen


 

 

-Original Message-
From: Cathy Grimes 
To: rbase-l 
Sent: Wed, May 23, 2018 8:43 am
Subject: [RBASE-L] - How Get Individual Reports to PRINT in Report Head the 
TOTAL # entries for THAT report only?



I still haven’t been able to fix some of the R:Base upgrade differences that 
negated a few of my previous entries/variables that worked before.  It’s been 
decades since I did any database/form/report/table designing with my database 
except add rows using my previous forms and print existing reports.
 
I have R:Base Extreme 9 (C:\RBTI\RBG95_32\RBG95_32.exe).  I have one report 
that I frequently use and just change the ‘where’ clauses to suit each report.  
I cannot find a way in this R:Base for the report to simply count the total of 
each main entry (i.e., ‘title’) SPECIFIC to EACH REPORT’s ‘where’ clause that I 
give the report when I ask it to print.  The only way I’ve managed to get the 
count is to go to DESIGN, variables and CHANGE the variable to the same ‘where’ 
clause as the particular report I’m printing.  But it would be so much easier 
if I could just add a variable where R:Base can just use the where clause I 
give it each time I print the report.  (Hope that makes sense).
 
If anyone knows how I could do this, I would really appreciate it.  Thank you.
 
Cathy

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google 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] - Dropping a default?

[karentellef via RBASE-L]

I swear... I brought up that help screen and stared and searched, figured there 
had to be a way.  Gotta get my eyes checked!


Thanks!!


Karen

 

 

 

-Original Message-
From: Dan Goldberg <d...@lancecamper.com>
To: rbase-l <rbase-l@googlegroups.com>
Sent: Tue, May 22, 2018 10:28 am
Subject: RE: [RBASE-L] - Dropping a default?



I think this is what you are looking for.
 

 
Dan Goldberg
 
From: karentellef via RBASE-L <rbase-l@googlegroups.com>
Sent: Tuesday, May 22, 2018 8:26 AM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - Dropping a default?
 

Is there a way to drop a column's default valuein code?We have a routine 
that runs overnight to do structure changes and I want to drop a default value 
for a column.  I know I can drop and recreate the column, but then I have to 
make sure that I've saved a copy of the original values because they might have 
changed them, and then bring in that data.

 

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 
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 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[RBASE-L] - Dropping a default?

[karentellef via RBASE-L]

Is there a way to drop a column's default value in code?We have a routine 
that runs overnight to do structure changes and I want to drop a default value 
for a column.  I know I can drop and recreate the column, but then I have to 
make sure that I've saved a copy of the original values because they might have 
changed them, and then bring in that data.


Karen


-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [RBASE-L] - RBase on Linux

[karentellef via RBASE-L]

Thanks Mark (and Albert).  Have you run RBase on the Linux?  How is 
performance?  He's suspecting overly-opportunistic locking on Windows server 
and is hoping for better performance on a Linux, but probably wouldn't try it 
unless someone tells me that they've done that and the performance is good

Karen


 

 

 

-Original Message-
From: Mark Lindner <mlind...@lindner-law.com>
To: rbase-l <rbase-l@googlegroups.com>
Sent: Wed, May 16, 2018 8:22 pm
Subject: Re: [RBASE-L] - RBase on Linux



Not sure which question you are asking.




It is trivial to set up shares on a linux server to store the files and to 
store the executables using SAMBA on the server.  You just set up a drive 
letter to the share, set permissions and you are set.  I expect there are other 
solutions like SAMBA.


If you want to run the executables on a windows workstation attached to the 
linux server, you are set.  Windows will just see the linux box as just another 
drive.


You can not run the executables in linux itself without an add on like Albert 
is using.


Mark Lindner

Lindner & Associates
PO Box 327
Randolph  MA  02368
781 247 1100




From: karentellef via RBASE-L <rbase-l@googlegroups.com>
Sent: Wednesday, May 16, 2018 8:49 PM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - RBase on Linux
 

I am posting for a friend who is not active on this list.

Has anyone here run RBase X/XE on a Linux server?  Specifically locating the 
database there, perhaps also the RBase executables.  They are willing to pay 
someone for their time if setting up such an arrangement is possible.   If you 
like, you may contact me off-list to discuss specifics.

Thanks!!!(PS: might not be on the list much Thursday, so be patient if I 
don't respond)

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 
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 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.



-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[RBASE-L] - RBase on Linux

[karentellef via RBASE-L]

I am posting for a friend who is not active on this list.

Has anyone here run RBase X/XE on a Linux server?  Specifically locating the 
database there, perhaps also the RBase executables.  They are willing to pay 
someone for their time if setting up such an arrangement is possible.   If you 
like, you may contact me off-list to discuss specifics.

Thanks!!!(PS: might not be on the list much Thursday, so be patient if I 
don't respond)

Karen

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [RBASE-L] - User defined search

[karentellef via RBASE-L]

When I do search forms, I have the fields on the form and the user types in the 
values to search.  There's a search button that constructs a "where" clause.  

Parts of the code look like this.  In my case, I would have a list view on the 
form that displays the matching records, with the "where" clause in its lookup, 
but I put your Edit using in the example:


SET VAR vCWhere TEXT = "invoice IS NOT NULL"

IF vBalDue = "T" THEN
  SET VAR vCWhere = (.vCWhere & "AND baldueInv > 0")
ENDIF

IF vID IS NOT NULL THEN
  SET VAR vCWhere = (.vCWhere & "AND id = .vID")
ENDIF

SELECT COUNT(*) INTO vfCount FROM vInvoice WHERE 
IF vfCount > 0 THEN
EDIT USING JobDetails WHERE 
  --PROPERTY listview REFRESHLIST "TRUE"   (this is what I do)
ELSE
  PAUSE 2 USING "Sorry, no Invoice records meet your search criteria!"
ENDIF


Karen



-Original Message-
From: dkfowler6179 
To: RBASE-L 
Sent: Fri, May 11, 2018 1:52 pm
Subject: [RBASE-L] - User defined search

Using R:Base X latest version.
I'm trying to figure out how to make some sort of user definable search.  My 
thoughts are to have a form with drop downs for the columns I want them to be 
able to search and conditions of the search.  I can make the form and generate 
the search criteria as a variable.  Just cant figure out how to get that to run 
as a search.
Example:
Set var tsearch=.v0&.v1&.v2&.v3&.v4&.v5
Gets me:
Edit using jobdetails where number=45878 
as the value for tsearch.
How can I use this variable (tsearch) to actually run?  Or am I totally off 
base and there's a better way to go about this?

Thanks for any ideas.
David Fowler

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google 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] - Possible e-mail or list problem?

[karentellef via RBASE-L]

Yes you're right, I checked my "recently deleted" emails and I don't see a post 
from you to the list

Karen

 

 

 

-Original Message-
From: Alastair Burr 
To: R:Base Listserver 2016 
Sent: Wed, May 9, 2018 5:01 am
Subject: [RBASE-L] - Possible e-mail or list problem?


A few days ago I replied to Dan Goldberg using the reply button in my e-mail 
software (Mozilla Thunderbird) and thenlater wondered why I hadn't had the 
message returned to me as usual via the list.

This has happened a few times and I have simply re-posted my post if it was 
still relevant.

This morning, however, I noticed that my post to Dan hadn't returned and I 
looked to see if it was in my "Sent" box - it was - but, by chance, it caught 
my eye that it had been sent to Dan directly and not to the list.

The source contains this:


X-Original-Sender: d...@lancecamper.com
X-Original-Authentication-Results: gmr-mx.google.com;   spf=softfail
 (google.com: domain of transitioning d...@lancecamper.com does not designate
 199.102.107.209 as permitted sender) smtp.mailfrom=d...@lancecamper.com
Reply-To: rbase-l@googlegroups.com


Has anybody got any idea what might be going on?

Regards,
Alastair.

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google 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

[karentellef via RBASE-L]

It's okay to move around inside of a while loop, but never to take you outside 
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 
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] - 2 page report in Rbase X

[karentellef via RBASE-L]

Right-click inside the report footer section, and pick "new page"

Karen

 

 

 

-Original Message-
From: Kayza Kleinman 
To: rbase-l 
Sent: Wed, Apr 25, 2018 9:42 am
Subject: RE: [RBASE-L] - 2 page report in Rbase X

When I put a sub report on the footer, it prints as the footer on that page. 
What I need is for it to print on the next page.

Kayza Kleinman
Director of the Nonprofit Helpdesk 
CIO
Jewish Community Council of Greater Coney Island, Inc
www.jccgci.org
www.nphd.org

-Original Message-
From: rbase-l@googlegroups.com  On Behalf Of A. 
Razzak Memon
Sent: Wednesday, April 18, 2018 8:38 AM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - 2 page report in Rbase X

At 12:24 AM 4/18/2018, Kayza Kleinman wrote:

>What I can't figure out is if I can have both pages print as one report.

Kayza,

Here's how ...

01. Create a sub-report and place the Sub Report object on Report Page Footer 
section.

02. Place all necessary and/or relevant columns/fields on this sub-report 
accordingly.

03. When PRINTing the report, both pages will be printed as one report.

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.

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google 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] - Date Chooser Dialog?

[karentellef via RBASE-L]

Kayza:  I copy/pasted Razzak's simple example and ran it in both 9.5 and X 
without an error

I know this is a stupid suggestion, but if you did a copy/paste to the R> 
prompt, make sure you remove the continuation + characters

Karen

 

 

 

-Original Message-
From: A. Razzak Memon 
To: rbase-l 
Sent: Fri, Apr 20, 2018 3:10 am
Subject: RE: RE: [RBASE-L] - Date Chooser Dialog?

If your connected database QUOTES settings are single quotes, and you 
cannot run the sample
DIALOG command below, there is something else going on.

-- Dialog with Popup as Date
 CLEAR VAR vDate,vEndKey
 SET VAR vDate DATE = NULL
 DIALOG 'Enter Date (mm/dd/) or Double-Click for Calendar' +
   vDate=34 vEndKey 1 +
 CAPTION 'DIALOG with Date Pop-up' ICON WINDOWS +
OPTION POPUP_ENABLED TRUE +
 |POPUP_DIALOG_TYPE DATE
 RETURN

Please contact R:BASE Technologies' Support Team with a sample of 
your database for further
help.

Very Best R:egards,

Razzak


At 12:06 AM 4/20/2018, Kayza Kleinman wrote:

>-ERROR- Syntax is incorrect for the command DIALOG (2045)
>
>That's what I get - I'm using Copy / paste to avoid typos.
>
>Kayza Kleinman





-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google 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] - Date Chooser Dialog?

[karentellef via RBASE-L]

If you want a calendar, do this:

set var vdate = (getdate('title here'))

Karen

 

 

 

-Original Message-
From: Kayza Kleinman 
To: 'rbase-l@googlegroups.com' 
Sent: Tue, Apr 17, 2018 12:26 am
Subject: [RBASE-L] - Date Chooser Dialog?



I often need to get dates from users before I run a report or form. Is there a 
way to build a dialog that gives a date chooser similar to what you can do in a 
form, without  having to create a form for it?


Thanks!
 
 
Kayza Kleinman
Director of the Nonprofit Helpdesk
CIO
Jewish Community Council of Greater Coney Island, Inc
3001 West 37th Street
Brooklyn NY 11224
718 449-5000 x 2266
fax347-946-6390
www.jccgci.org
www.nphd.org
 
 

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google 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] - Enhanced DBGrid Refresh

[karentellef via RBASE-L]

Yep, I had it noted in my "cheat sheet" document as a fix that was made 
in 2014 in version 9.5, but my print-screen example was still the original one
that RBTI had created!  I replaced my print-screen with the updated screen, 
and now I'll never "forget" that new syntax again!  Goes to show that the eye
looks immediately at a picture, and kind of ignores the text "please note"
that's written right under it!!

Karen

 

 

 

-Original Message-
From: A. Razzak Memon <raz...@rbase.com>
To: rbase-l <rbase-l@googlegroups.com>
Sent: Wed, Apr 11, 2018 2:01 pm
Subject: Re: [RBASE-L] - Enhanced DBGrid Refresh


FWIW ...

It was the R:BASE Development Team who provided you with the insight 
as well as the correct
syntax to use that technique of using Lookup Expressions in DB Grid control.

Very Best R:egards,

Razzak

At 08:48 AM 4/11/2018, karentellef via RBASE-L wrote:

>Claudine:  Just yesterday (in 3/20 build) I designed a DBGrid that 
>had a lookup expression
>designed to show the account's name, and a popup menu to select the 
>account from another
>table.




-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google 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] - Enhanced DBGrid Refresh

[karentellef via RBASE-L]

One other thing.   When you have your lookup defined, are you putting the 
second lookup value in <> ?  That trips me up all the time. It helps with 
refreshing the lookup when you leave the row, so perhaps it also makes this 
dynamic?

I mean:
actname IN accounts WHERE acctno = 

Karen

 

 

 

-Original Message-
From: Claudine Robbins <crobb...@iexgroup.com>
To: rbase-l <rbase-l@googlegroups.com>
Sent: Wed, Apr 11, 2018 10:22 am
Subject: RE: [RBASE-L] - Enhanced DBGrid Refresh



Thanks.  I’ll try and let you know. ~Claudine
 
From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com]
Sent: Wednesday, April 11, 2018 7:49 AM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Enhanced DBGrid Refresh
 
Claudine:  Just yesterday (in 3/20 build) I designed a DBGrid that had a lookup 
expression designed to show the account's name, and a popup menu to select the 
account from another table.  Is that similar to what you're doing?


 


I just tried this.  I brought the form up.  On another session, I added a row 
to the account lookup table.  In the form I did the popup menu and my new value 
showed up as one of the choices.  If this is what you're trying to do and it 
isn't working, perhaps add the lookup table as an actual form slave table, and 
then maybe the 'table...refresh' command would work on it?

Karen

 

 

 

-Original Message-
From: Paul C. Buckley <p...@buckleyandassoc.com>
To: rbase-l <rbase-l@googlegroups.com>
Sent: Wed, Apr 11, 2018 7:17 am
Subject: RE: [RBASE-L] - Enhanced DBGrid Refresh


Claudine,

 

I have an Enhanced DB Grid on several forms in the current database I’m working 
on. I don’t have an dropdown fields but I have the code below in the On Exit 
EEP for the grid. See if this helps.

 

PROPERTY TABLE tablename 'POST'

PROPERTY TABLE tablename 'REFRESH'

 

Good luck,

Paul Buckley

 


From: rbase-l@googlegroups.com <rbase-l@googlegroups.com> On Behalf OfClaudine 
Robbins
Sent: April 10, 2018 7:04 PM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - Enhanced DBGrid Refresh


 

Actually, I think I’ll use closing and reopening the form as a work around for 
now.

 

Claudine

 


From:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com]On Behalf Of 
Claudine Robbins
Sent: Tuesday, April 10, 2018 3:31 PM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - Enhanced DBGrid Refresh



 

Armin,

 

Upon returning to the Enhanced DBGrid, the row in the lookup table has been 
saved but is not available to the dropdown.  A refresh command of some sort 
needs to be applied to the DBGrid, like the closing and reopening of the form 
does.

 

Thanks,

 

Claudine

 


From:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com]On Behalf Of 
Armin Thoma
Sent: Monday, April 02, 2018 1:35 PM
To: rbase-l@googlegroups.com
Subject: AW: [RBASE-L] - Enhanced DBGrid Refresh


 


Claudine

 

SAVEROW might do it.

 

Armin

 




Von:rbase-l@googlegroups.com <rbase-l@googlegroups.com> im Auftrag von Claudine 
Robbins <crobb...@iexgroup.com>
Gesendet: Montag, 2. April 2018 20:33
An: rbase-l@googlegroups.com
Betreff: RE: [RBASE-L] - Enhanced DBGrid Refresh


 



Thank you Razzak.

 

I don't think I made it clear that there are two tables involved here.  One 
underlies the Enhanced DBGrid, the other underlies the expression lookup of one 
of its columns, the one I'm using in the grid to provide a dropdown.

 



 

Claudine

 

-Original Message-
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
A. Razzak Memon
Sent: Monday, April 02, 2018 1:02 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Enhanced DBGrid Refresh

 

Claudine,

 

Please try the following and see what you get ...

 

-- Start

PROPERTY TABLE endbgridtablename 'CLOSE'

PROPERTY TABLE endbgridtablename 'OPEN'

RETURN

-- End

 

Very Best R:egards,

 

Razzak

 

 

At 01:53 PM 4/2/2018, Claudine Robbins wrote:

 

>I don't know how to refresh an Enhanced DBGrid.  I have an expression

>lookup on a DBGrid column (dropdown) and a button on the form to edit

>its underlying table but changes are not reflected when I use PROPERTY

>TABLE tablename 'POST'

>and PROPERTY TABLE tablename 'REFRESH' after editing the records.

 

 

--

For group guidelines, 
visithttp://www.rbase.com/support/usersgroup_guidelines.php

---

You received this message because 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, visithttps://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+unsub

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

[karentellef via RBASE-L]

Not sure if this is still the case, but I thought char(32) was always a soft 
space.  I always used 255 as a hard space.  Glad to hear the 00 might work for 
you!

Karen

 

 

 

-Original Message-
From: James W. Kim, CPA, MBA 
To: rbase-l 
Sent: Tue, Feb 20, 2018 12:28 pm
Subject: Re: [RBASE-L] - Text file that retains trailing blank space

Thank you Stephen and others for the suggestions.  Most of systems I 
work with does not allow extended ASCII characters, so CHAR(160) would 
not work.

I have been submitting formatted text files to various federal and state 
authorities for years.  Some systems, such as EFTPS, are tolerant and 
simple SFIL and SPUT functions work well.  However, Social Security 
Admin EFW2 and IRS FIRE systems require fixed length files (512 and 750 
characters long)  that are sparsely populated with actual data, 
accompanied by great deal of blank spaces.

For blank spaces, I have been using CHAR(32) which worked fine up to 
R:Base X Build: 10.0.1.20225.  However, newer updates tend to trim the 
CHAR(32) hard spaces and I had to keep one of computers at build 
10.0.1.20225 for the purpose of creating these upload files.  I just 
tried CHAR(00) as suggested by Razzak and the null spaces seem to 
stick.  So, I am hopeful and will upload some test files.

Thanks again,
James


On 2/20/2018 9:04 AM, Stephen Markson wrote:
> Hi James,
>
> Can you insert CHAR(160) as the 512th character? This will keep the preceding 
> spaces and will show up as a blank. I don't know though whether the program 
> that takes the file as input will tolerate that.
>
> Regards,
>
> Stephen Markson
> The Pharmacy Examining Board of Canada
> 416.979.2431 x251
>
> -Original Message-
> From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
> James W. Kim, CPA, MBA
> Sent: February-19-18 4:26 PM
> To: rbase-l@googlegroups.com
> Subject: [RBASE-L] - Text file that retains trailing blank space
>
> Need some help with creating text file that retains blank spaces at the end 
> of each row.
>
> I often need to create text files with fixed row length such as 512 or
> 750 characters in a row. When there are no data value near the right end of 
> each row, the unused spaces need to be filled with blank spaces.
>
> The following is an example of how such text file would be built. The example 
> creates a row that has "FLOOR 7" at 274th space in a row that has 512 
> characters.  With some previous versions of R:Base, the trailing spaces is 
> retained after insertion of data using SPUT function and line feed (CR/LF) 
> would show up at 513th position.
>
> However, the current version would remove the trailing space when data is 
> inserted using SPUT function and the (CR/LF) moves up to 281st position.
>
> Is there anyway I can force the retention of trailing spaces so that CR/LF 
> always shows up at 513th position?
>
> Thanks in advance,
>
> James
>
>
>
> -- create text variable with blank spaces SET VAR vRow TEXT = NULL SET VAR 
> vRow = (SFIL((CHAR(32)),512))
> -- use SPUT function to fill in data
> SET VAR vRow = (SPUT(.vRow, 'start', 1)) SET VAR vRow = (SPUT(.vRow, 'Floor 
> 7', 274))
>
> -- write the variable to a text file
> OUTPUT sample.txt append
> WRITE .vRow USING
> ''
> OUTPUT SCREEN
>
>

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google 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] - Autofill a form field

[karentellef via RBASE-L]

Not sure about combo boxes, but you can load list boxes with this syntax:
   
PROPERTY boxItems load_from_file 'Itemlist.txt'

Karen

 

 

 

-Original Message-
From: dkfowler6179 
To: RBASE-L 
Sent: Thu, Feb 1, 2018 1:37 pm
Subject: [RBASE-L] - Autofill a form field

I've found the behavior I'm looking for in the Variable User Defined Combo Box 
with a the auto complete box checked.  Only problem with this is having to 
manually enter thousands of street names.  The Variable Lookup Combo Box is 
very similar and allows for lookup from a table.  There is, however no Auto 
Complete box to check.  Any way to import a very large list of streets into the 
user defined lookup or to have the Lookup Combo Box do the Auto Complete 
behavior? 

Thanks for any ideas.
David Fowler

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google 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] - Command History buttons

[karentellef via RBASE-L]

I know that one of the parameters you can send is this, where you specify the 
port:

|EMAIL_PORT 25 

Have you tried adding this parameter and seeing it it helps?

Karen

 

 

 

-Original Message-
From: Gary Wendike 
To: rbase-l 
Sent: Mon, Jan 29, 2018 12:23 pm
Subject: RE: [RBASE-L] - Command History buttons



I have experienced a failure in the Print Email format that I have been using 
for 5 months.
 
Cox, my carrier, implemented a port change on the 25th of January.  Since then 
the program has not worked.  There only change was the out going port.
 
I can send an email to myself using the program, however, I cannot send emails 
to anyone else that is required.
 
I am using the current version of RBase Enterprise.
 
Here is a snippet of print routine…
  PRINT  +
  OPTION PDF|FILENAME  +
  |EMAIL ON +
  |EMAIL_HOST smtp.cox.net +
  |EMAIL_USERID CompCon2017 +
  |EMAIL_PASSWORD XX +
  |EMAIL_TO_LIST .vmailadd + (This area is the limiting function. I can 
only send to my self at this point.  All other locations are blocked)
  |EMAIL_FROM_NAME Gary Wendike +
  |EMAIL_FROM_ADDRESS compcon2...@cox.net +
  |EMAIL_SUBJECT .vsubject EMAIL +
  |EMAIL_BODY Automated EMAIL...do NOT respond TO. +
  |EMAIL_SHOW_DIALOG OFF
 
Cox says it could be an update by windows that has caused the problem.
 
Has anyone experienced a problem like this?  Any blue clues would be helpful.
 
Thanks
Gary

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google 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] - RE: Check for an Internet Connection

[karentellef via RBASE-L]

It was instant on mine (win 10, wired)

Karen

 

 

 

-Original Message-
From: Albert Berry 
To: rbase-l 
Sent: Fri, Jan 26, 2018 10:55 am
Subject: Re: [RBASE-L] - RE: Check for an  Internet Connection


Now there is one I didn’t know about. Tried it in RBGXE running on Win 7 Pro 
via Parallels on my MacBook Air. A little under 5 seconds returned YES. The 
connection is via Mac OS X High Sierra through the Parallels interface to WiFi 
on the MacBook. I don’t know why, but I suspect that the convoluted interface I 
run under might have contributed to the time the command took ;)


Albert





On Jan 26, 2018, at 9:46 AM, Dan Goldberg  wrote:



GETPROPERTY APPLICATION IsInternetConnected 'varname'
 
Dan Goldberg
 

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Richardson, Jeff
Sent: Friday, January 26, 2018 8:43 AM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - Check for an Internet Connection

 
Hello. Is there a command that will check for an Internet connection in R:Base 
X Enterprise? Thanks!
 
 
Jeff Richardson | Project Manager, Asset Verification Services (AVS)
DMA – DuCharme, McMillen & Associates, Inc. | 828 S Harrison Street Suite 650, 
Fort Wayne, IN 46802
Cell: 724-366-1724
Connect: jrichard...@dmainc.com | Website | LinkedIn | Twitter | Facebook
___
ATTENTION: This message and all attachments are PRIVATE, and may contain 
information that is CONFIDENTIAL and PRIVILEGED.  If you have received this 
message in error, please notify the sender by reply e-mail and delete the 
message immediately.
 
-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.



-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.




-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google 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] - Stay_On_Top

[karentellef via RBASE-L]

Makes sense, thanks.  That's what I did

Karen


 

 

 

-Original Message-
From: jan johansen <j...@jjcalibrations.com>
To: karentellef via RBASE-L <rbase-l@googlegroups.com>
Sent: Thu, Jan 18, 2018 1:11 pm
Subject: Re: [RBASE-L] - Stay_On_Top



All property call's must be in an AFTER START eep
 
 
-Original Message-
From: karentellef via RBASE-L <rbase-l@googlegroups.com>
To: rbase-l@googlegroups.com
Date: Thu, 18 Jan 2018 14:06:39 -0500
Subject: [RBASE-L] - Stay_On_Top

If I am using 
PROPERTY RBASE_FORM STAY_ON_TOP 'ON'


where should I put it?   On the form Before start or After?

Thanks!

Karen
 
--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[RBASE-L] - Stay_On_Top

[karentellef via RBASE-L]

If I am using 
PROPERTYRBASE_FORM STAY_ON_TOP 'ON'


where should I put it?   On the form Before start or After?

Thanks!

Karen

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [RBASE-L] - SHORTFILENAME vs. LONGFILENAME

[karentellef via RBASE-L]

Ooops!!!  Yeah, I was talking about
SET SHORTNAME ON/OFF

which I've had to use before.  Not the PROPERTY shortname.  Sorry!

Karen

 

 

 

-Original Message-
From: A. Razzak Memon 
To: rbase-l 
Sent: Wed, Jan 17, 2018 2:36 pm
Subject: Re: [RBASE-L] - SHORTFILENAME vs. LONGFILENAME


I simply could not resist letting this thread go with such an answer ...

Using the FileListBox control, the SHORTFILENAME has everything to do 
what Manuel is trying
to accomplish.

Using the FileListBox form control in R:BASE X and R:BASE Enterprise 
has a lot to do with
the GETPROPERTY SHORTFILENAME and LONGFILENAME command as clearly 
stated in Manuel's post.

GETPROPERTY  SHORTFILENAME 'varname'
Use this property to obtain the short version of the currently 
selected file name in a
FileListBox control.

GETPROPERTY  LONGFILENAME 'varname'
Use this property to obtain the long version of the currently 
selected file name in a
FileListBox control, including path, etc.

Manuel,

Let me prepare a sample to illustrate the proper use of supported 
GETPROPERTY commands
for FileListBox control to accomplish your goal.

Very Best R:egards,

Razzak


At 09:06 AM 1/17/2018, Karen Tellef wrote:

>No "shortfilename" has nothing to do with what you're 
>trying.  Shortfilename is only used when
>you're using the "DIR" command, it controls what's shown back to you 
>in the file listing.
>
>Karen
>
>-Original Message-
>From: MD 
>To: rbase-l 
>Sent: Wed, Jan 17, 2018 2:48 am
>Subject: [RBASE-L] - SHORTFILENAME vs. LONGFILENAME
>
>I have a filelistbox and when I select an image on a folder using 
>the PROPERTY LONGFILENAME I
>obtain the file name and its full path.  I wanted to get just the 
>file name so I assumed that
>using the SHORTFILENAME would yield the name of the file 
>only.  Component ID:  flbFileNam
>My code is:
>
>GETPROPERTY flbFileNam LONGFILENAME 'fvFileImgNam'
>.
>GETPROPERTY flbFileNam SHORTFILENAME 'fvFileImgNamShrt'
>The result is:
>[]
>
>
>It appears that both property command yield the same results.  So my 
>understanding of the
>SHORT & LONGFILENAME is weak or I am doing something wrong or 
>something else? I need some help.
>
>I was just trying to get the file name without the path 
>(CM9197.jpg).  Your help is greatly
>appreciated.
>
>Thank you,
>Manuel
>RBase XE latest upgrade.
>
>By the way I tried this in the RRBYW19 database on an existing form 
>and it behaved in the same way.

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google 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] - unusual spacing in email body

[karentellef via RBASE-L]

You don't by any chance do something like
WRITE (or show var) .vBody=100

do you?  If you embed CRs in the text, you cannot also display a width 
otherwise you get all these weird breaks

Karen

 

 

 

-Original Message-
From: Jim Belisle 
To: rbase-l 
Sent: Wed, Jan 17, 2018 11:23 am
Subject: [RBASE-L] - unusual spacing in email body



We send out invoices via email as pdf attachments.
Within the email body itself, we have multiple lines with instructions.
I use the (CHAR(13)) at the end of each line to put in a carriage return.
However for some reason carriage returns show up in strange places.
 
Example: (these are just the first two lines. There are more following the 
second line.)
('Body:The invoice for your recent order is attached. Thank you!'+(CHAR(13))+ +
'PLEASE NOTE OUR ADDRESS HAS CHANGED-WE NO LONGER HAVE A PO BOX!'+(CHAR(13))+ +
 
The first line shows in the email properly – see below.
The invoice for your recent order is attached. Thank you!
 
The second line shows up this way. Looks strange. 
PLEASE 
NOTE OUR ADDRESS HAS CHANGED-WE NO LONGER HAVE A PO BOX!
 
Each email body to each customer shows up the same.
Any blues clues as to why this would happen?
 
James Belisle
 
Making Information Systems People Friendly Since 1990

 

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.



-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [RBASE-L] - SHORTFILENAME vs. LONGFILENAME

[karentellef via RBASE-L]

No "shortfilename" has nothing to do with what you're trying.  Shortfilename is 
only used when you're using the "DIR" command, it controls what's shown back to 
you in the file listing.

Karen

 

 

 

-Original Message-
From: MD 
To: rbase-l 
Sent: Wed, Jan 17, 2018 2:48 am
Subject: [RBASE-L] - SHORTFILENAME vs. LONGFILENAME



I have a filelistbox and when I select an image on a folder using the PROPERTY  
LONGFILENAME I obtain the file name and its full path.  I wanted to get just 
the file name so I assumed that using the SHORTFILENAME would yield the name of 
the file only.Component ID:  flbFileNam
My code is:
 
GETPROPERTY flbFileNam LONGFILENAME 'fvFileImgNam'
.
GETPROPERTY flbFileNam SHORTFILENAME 'fvFileImgNamShrt'
The result is:

 
It appears that both property command yield the same results.  So my 
understanding of the SHORT & LONGFILENAME is weak or I am doing something wrong 
or something else?  I need some help.
 
I was just trying to get the file name without the path (CM9197.jpg).  Your 
help is greatly appreciated.
 
Thank you,
Manuel
RBase XE latest upgrade.
 
By the way I tried this in the RRBYW19 database on an existing form and it 
behaved in the same way.

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google 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] - Error using View to create new table

[karentellef via RBASE-L]

The column "amtpd" isn't by any chance a computed column in the ActiveReceipts 
table, is it?  If so, then change your "AS" alias

Karen

 

 

 

-Original Message-
From: John Murnane 
To: rbase-l 
Sent: Tue, Jan 16, 2018 1:06 pm
Subject: [RBASE-L] - Error using View to create new table



Hi All:
I’m using R:BASE X Enterprise v 10.03.20116.  I am running into an issue with a 
an RBASE view.  I can successfully run a browse query, see image below, but get 
a “Illegal column name (2056)” when I attempt to save the query results to a 
new table.  Any ideas as to what I’m missing?  Thanks in advance!!
 
Query :
SELECT T1.AccountNum AS AccountNum,T1.datepd AS datepd,T1.depnum as 
depnum,T1.checknum as checknum,
  SUM (T1.amtpd)  AS amtpd, SUM ( T1.interest )  AS 
interest,SUM ( T1.principl )  as principl,T1.nsfflag AS nsfflag
FROM  ActiveReceipts T1
ORDER BY   T1.AccountNum, T1.datepd
GROUP BY  T1.AccountNum, T1.datepd, T1.checknum, T1.depnum, T1.nsfflag
 
Browse Query Result:
 

 
Error when attempting to “Save Query as Table”:
 

Detail:  The column name you specified is unacceptable. A column name must be 
from one to eighteen characters long. It must start with a letter and cannot 
contain blanks.
 
ActiveReceipts definition:


lastname

TEXT (30)


firstnm

TEXT (16)


AccountNum

"NUMERIC (8,0)"


pymtdate

DATE


depnum

TEXT (5)


checknum

TEXT (5)


datepd

DATE


amtpd

CURRENCY


nsfflag

TEXT (1)


interest

CURRENCY


principl

CURRENCY


field

TEXT (24)


pymtnum

INTEGER


acrdpd

CURRENCY


 
- John
 _
John Murnane
UTO Computing Support
Arizona State University
work: 602-496-1137
mobile: 480-543-9582
 

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google 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] - Disaster Avoidance: SRPL Syntax Question

[karentellef via RBASE-L]

Maybe I'm reading your statement wrong, but no I don't think that's what you 
wanted to do.  Did you want to do this?

UPDATE transx SET trxnum = (SRPL(trxnum, 'V0', 'v0', 0))


 


Karen

 

 

-Original Message-
From: Bruce Chitiea 
To: rbase-l 
Sent: Sun, Jan 14, 2018 12:11 pm
Subject: [RBASE-L] - Disaster Avoidance: SRPL Syntax Question


Happy New Year to all!


Might this be the correct SRPL syntax for replacing a substring within a text 
column? If not, what?


SET VAR vTargetColumn TEXT = NULL
SET VAR vTargetColumn = 'ColumnNAME'
UPDATE TableNAME SET  = 
(SRPL(,'SearchString','ReplaceString',0))


I ask because I attempted a SRPL on a column using a literal string in place of 
'', with an ugly result (Fortunately I had a backup. )


Target column 'transx' contained several thousand values [ V00xx | 
v00xx ] where 'x' might be any digit. For visual clarity-in-reporting's 
sake, I decided to replace the legacy capital 'V' with lower case 'v'.


UPDATE transx SET trxnum = (SRPL('V0','V','v',0)) WHERE trxnum LIKE 'V0%'


This produced a uniform value of 'v0'. No trailing digits. Disaster. Restore 
from backup.


???


Thanks very much,


Bruce Chitiea
SafeSectors, Inc.
909.238.9012 m

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google 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] - Any way to have DIALOG pre-select the default text.

[karentellef via RBASE-L]

Albert:  That doesn't put it in "overwrite" mode.   I don't think there's a way 
of doing what Larry wants.

Karen

 

 

 

-Original Message-
From: Albert Berry 
To: rbase-l 
Sent: Fri, Jan 12, 2018 10:29 am
Subject: Re: [RBASE-L] - Any way to have DIALOG pre-select the default text.


SET VAR vDialog TEXT = “whatever”
DIALOG …..


Albert



On Jan 12, 2018, at 8:08 AM, 'Lawrence Lustig' via RBASE-L 
 wrote:



I'm starting a DIALOG command with a default value already in the variable used 
by the DIALOG.


The appearance is that the cursor is positioned at the beginning of the value 
in the DIALOG's input edit.


I would prefer the value to be already selected so that anything the user 
enters replaces what's there already.  I cannot find anything in the OPTIONS 
documentation to pre-select the value display.


Anyone know if this is possible.
--
Larry



-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.





-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [RBASE-L] - [Business Web Applications using Java]

[karentellef via RBASE-L]

Steve:  I agree 100%.  I'm sure everyone would like to see a simple "punch 
list" of everything that is recommended to get a web interface to a RBase 
database.  All the pieces that are needed...  Not pages of explanation (at this 
point), but a simple "You need this stuff."

Karen

 

 

 

-Original Message-
From: Steve Johnson <sjohnson...@sprintmail.com>
To: rbase-l <rbase-l@googlegroups.com>
Sent: Tue, Jan 9, 2018 9:33 pm
Subject: RE: [RBASE-L] - [Business Web Applications using Java]



Hmm, I was afraid this would be complicated.  If I were 20 years younger, I 
might tackle Java.  But even a block diagram would be useful to understand the 
pieces and relationships.  I have an application that has a service request 
module in it, and I have always thought it would be cool to have the person 
making a request for service put in the information directly into the 
application, rather than transferring the information from email into the 
application. Unfortunately, it appears to be too complicated and since the 
transaction volume is small and there is no financial incentive, (it is a free 
service for a community), I guess not and probably not worth the cost to 
implement.  
 
Steve
 
 
 
From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com] 
Sent: Monday, January 08, 2018 9:36 AM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - [Business Web Applications using Java]
 
A class in Java?  My buddy Frank in Boston has an amazing web-based interface 
to his database, but until he or I learn a web programming language there 
wouldn't be anything that either of us could "do" to replicate that system 
anywhere else.  He hired Raffee to do all his work.  Because he knows the 
"pieces" he could probably put together a punch list of what is required (like, 
get this as your server and OS, get Oterro) but then it would be "and hire 
someone who knows Java"

Karen

 

 

 

-Original Message-
From: Dan Goldberg <d...@lancecamper.com>
To: rbase-l <rbase-l@googlegroups.com>
Sent: Mon, Jan 8, 2018 8:21 am
Subject: RE: [RBASE-L] - [Business Web Applications using Java]


I concur, maybe a class would be good?

 

Dan Goldberg

 


From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Steve Johnson
Sent: Sunday, January 7, 2018 5:54 PM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - [Business Web Applications using Java]


 

Jan,

 

Thanks for allowing us to visit the site, cool.  Perhaps there are some, 
including myself, that would like to explore web based applications, is there 
any information out there on how all this is put together?  

 

Steve J

 


From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
jan johansen
Sent: Friday, January 05, 2018 12:38 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - [Business Web Applications using Java]


 


All,


 


If you are interested in looking at a Java site that works with Oterro into our 
RBaseX database,


goto


www.jjcalibrations.com/equipmgr/


Use the following to login;


guest


jjguest


 


We had Raffee convert our PHP application.


 


Hope this helps.


 


Jan


  

-Original Message-
From: "A. Razzak Memon" <raz...@rbase.com>
To: rbase-l@googlegroups.com
Date: Thu, 04 Jan 2018 21:42:31 -0500
Subject: Re: [RBASE-L] - [Business Web Applications using Java]
  


If anyone is planning to develop and deploy robust and secure web
applications/portals,
they should look into using Java.

In 2017, we have switched all our corporate clients and their mission
critical business
applications and web portals to Java running on MS Windows Server
2012R2 and 2016.

In doing so, the latest versions and updates of Oterro XE (Version
10, Version 10.5)
are made fully compatible with Java.

Java is by far the most robust and secure environment. It has become
a preferred choice
for developing web applications for a cross platform approach. Since
Java works on most
leading Operating Systems, it is used in a wide range of platforms
from desktops to
mobile devices.

Our own R:BASE Updates portal https://www.rbaseupdates.com is a great
example of our
showcase.

If anyone is interested in seeing business applications and customer
web portals using
R:BASE XE, Oterro XE, and Java running on MS Windows Server 2012R2
and Server 2016,
please contact R:BASE Technologies' Services Division at
mailto:servi...@rbase.com.

Very Best R:egards,

Razzak

At 04:44 PM 1/4/2018, Jim Belisle wrote:

>We are looking into having our customers be able to order product
>directly into RBASE
>from the web. They of course would fill out a form, create a user
>name and password
>and be able to order. This would also give the ability for them to
>print certain
>reports showing what they ordered.
>Anyone out there use a specific software that you have found helpful
>in this cas

Re: [RBASE-L] - [Business Web Applications using Java]

[karentellef via RBASE-L]

A class in Java?  My buddy Frank in Boston has an amazing web-based interface 
to his database, but until he or I learn a web programming language there 
wouldn't be anything that either of us could "do" to replicate that system 
anywhere else.  He hired Raffee to do all his work.  Because he knows the 
"pieces" he could probably put together a punch list of what is required (like, 
get this as your server and OS, get Oterro) but then it would be "and hire 
someone who knows Java"

Karen

 

 

 

-Original Message-
From: Dan Goldberg 
To: rbase-l 
Sent: Mon, Jan 8, 2018 8:21 am
Subject: RE: [RBASE-L] - [Business Web Applications using Java]



I concur, maybe a class would be good?
 
Dan Goldberg
 

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com]On Behalf Of 
Steve Johnson
Sent: Sunday, January 7, 2018 5:54 PM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - [Business Web Applications using Java]

 
Jan,
 
Thanks for allowing us to visit the site, cool.  Perhaps there are some, 
including myself, that would like to explore web based applications, is there 
any information out there on how all this is put together?  
 
Steve J
 

From:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com]On Behalf Of jan 
johansen
Sent: Friday, January 05, 2018 12:38 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - [Business Web Applications using Java]

 

All,

 

If you are interested in looking at a Java site that works with Oterro into our 
RBaseX database,

goto

www.jjcalibrations.com/equipmgr/

Use the following to login;

guest

jjguest

 

We had Raffee convert our PHP application.

 

Hope this helps.

 

Jan

 
-Original Message-
From: "A. Razzak Memon" 
To: rbase-l@googlegroups.com
Date: Thu, 04 Jan 2018 21:42:31 -0500
Subject: Re: [RBASE-L] - [Business Web Applications using Java]
  

If anyone is planning to develop and deploy robust and secure web
applications/portals,
they should look into using Java.

In 2017, we have switched all our corporate clients and their mission
critical business
applications and web portals to Java running on MS Windows Server
2012R2 and 2016.

In doing so, the latest versions and updates of Oterro XE (Version
10, Version 10.5)
are made fully compatible with Java.

Java is by far the most robust and secure environment. It has become
a preferred choice
for developing web applications for a cross platform approach. Since
Java works on most
leading Operating Systems, it is used in a wide range of platforms
from desktops to
mobile devices.

Our own R:BASE Updates portal https://www.rbaseupdates.com is a great
example of our
showcase.

If anyone is interested in seeing business applications and customer
web portals using
R:BASE XE, Oterro XE, and Java running on MS Windows Server 2012R2
and Server 2016,
please contact R:BASE Technologies' Services Division at
mailto:servi...@rbase.com.

Very Best R:egards,

Razzak

At 04:44 PM 1/4/2018, Jim Belisle wrote:

>We are looking into having our customers be able to order product
>directly into RBASE
>from the web. They of course would fill out a form, create a user
>name and password
>and be able to order. This would also give the ability for them to
>print certain
>reports showing what they ordered.
>Anyone out there use a specific software that you have found helpful
>in this case?
>
>You can send directly to my email if you want.




--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because 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 
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 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


-- 
For group guidelines, visit 

Re: [RBASE-L] - Enhanced DB Grid Multi-Select Option

[karentellef via RBASE-L]

Update to Paul:  I just loaded the 12/14 build and the code still works fine 
for me.

Karen

 

 

 

-Original Message-
From: karentellef 
To: rbase-l 
Sent: Wed, Dec 20, 2017 7:46 am
Subject: Re: [RBASE-L] - Enhanced DB Grid Multi-Select Option


Paul, I hadn't used this feature yet but decided to give it a go.  I haven't 
downloaded the latest release yet so this is 11/14 build.   On my DBGrid, I 
checked "multi select" and gave it a componentID.  I put a button with this 
code, trapping the integer column:
   GETPROPERTY gridHours 'SELECTEDVALUES[tmpInteger]' 'vValues'
   PAUSE 2 USING .vValues

Hopefully you can see the print-screen attached to see that it worked.  If you 
want me to download the Dec build and try it, let me know.



 Karen

 

 

-Original Message-
From: Paul C. Buckley 
To: rbase-l 
Sent: Wed, Dec 20, 2017 7:14 am
Subject: [RBASE-L] - Enhanced DB Grid Multi-Select Option

Good morning,

Sorry, I need to repost this but I haven't received any feedback and I'm still 
trying to get this working. Thanks in advance.

I'm using the latest release or R:BASE Extreme Enterprise and trying to use 
multi-select in a Enhanced DB Grid. Under DB Grid Options I have checked 
Multiselect and I am able to select multiple rows. I can't find the variable 
that stores those selections? I've tried 'GETPROPERTY gridID 
'SELECTEDVALUES[columnname]' 'vmultiselect' ' but the variable vmultiselect is 
null.

Any blues clues would be greatly appreciated.

Thanks,
Paul Buckley

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
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] - Enhanced DB Grid Multi-Select Option

[karentellef via RBASE-L]

Paul, I hadn't used this feature yet but decided to give it a go.  I haven't 
downloaded the latest release yet so this is 11/14 build.   On my DBGrid, I 
checked "multi select" and gave it a componentID.  I put a button with this 
code, trapping the integer column:
   GETPROPERTY gridHours 'SELECTEDVALUES[tmpInteger]' 'vValues'
   PAUSE 2 USING .vValues

Hopefully you can see the print-screen attached to see that it worked.  If you 
want me to download the Dec build and try it, let me know.



 Karen

 

 

-Original Message-
From: Paul C. Buckley 
To: rbase-l 
Sent: Wed, Dec 20, 2017 7:14 am
Subject: [RBASE-L] - Enhanced DB Grid Multi-Select Option

Good morning,

Sorry, I need to repost this but I haven't received any feedback and I'm still 
trying to get this working. Thanks in advance.

I'm using the latest release or R:BASE Extreme Enterprise and trying to use 
multi-select in a Enhanced DB Grid. Under DB Grid Options I have checked 
Multiselect and I am able to select multiple rows. I can't find the variable 
that stores those selections? I've tried 'GETPROPERTY gridID 
'SELECTEDVALUES[columnname]' 'vmultiselect' ' but the variable vmultiselect is 
null.

Any blues clues would be greatly appreciated.

Thanks,
Paul Buckley

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
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 Compression

[karentellef via RBASE-L]

In addition to the milliseconds that Razzak mentions:


At one time if a form was compressed you could not search for words in the 
form.  Now, the "find" database explorer function will work against a 
compressed form (not sure what version it started working that way, so test it 
with your version).  But if you do it the old fashioned way (select all from 
sys_forms3 where #4 contains 'value') it will not work on a compressed form.


Karen

 

 

 

-Original Message-
From: Richardson, Jeff 
To: rbase-l 
Sent: Fri, Dec 15, 2017 5:47 am
Subject: [RBASE-L] - Form Compression



Basic question: I understand that “Compress Form” is used to minimize space. 
What is the disadvantage? Why would you not compress a form? Thanks!
 
 
Jeff Richardson | Project Manager, Asset Verification Services (AVS)
DMA – DuCharme, McMillen & Associates, Inc. | 828 S Harrison Street Suite 650, 
Fort Wayne, IN 46802
Cell: 724-366-1724
Connect: jrichard...@dmainc.com |Website |LinkedIn |Twitter |Facebook
___
ATTENTION:This message and all attachments are PRIVATE, and may contain 
information that is CONFIDENTIAL and PRIVILEGED.  If you have received this 
message in error, please notify the sender by reply e-mail and delete the 
message immediately.
 

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google 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] - copying images

[karentellef via RBASE-L]

Lots to learn!   It's easier to ride a bike than fly a plane!

Karen

 

 

 

-Original Message-
From: Randy Larsen <thelars...@gmail.com>
To: rbase-l <rbase-l@googlegroups.com>
Sent: Thu, Dec 14, 2017 11:26 am
Subject: Re: [RBASE-L] - copying images


Thank you Karen :)


there’s a lot to learn about this application.. 



Cheers,
-Randy











If you want to go fast, go alone.  If you want to go far, go together.
-African proverb







On Dec 14, 2017, at 12:08 PM, karentellef via RBASE-L 
<rbase-l@googlegroups.com> wrote:


Hi Randy!  I usually have a report called DEFAULTS.  On that report I have 
located all kinds of misc things, like page footers that I put at the bottom of 
each page, or page styles or letterhead-type of addresses, etc.  If there's DB 
fields that are in alot of reports and I always forget how wide the field 
should be (like a CustomerPart TEXT 20 field), I will put that control in my 
DEFAULTS report with the proper width for every font type/size I might use (I 
base my DEFAULTS report on the most commonly used table, or will have a report 
named with the table, like DefaultsCustPart, so I can locate DBEdits).  All 
controls can be copy/paste into other reports.

So yes, go ahead and define your section in your report and when you have it 
right you can copy/paste it to another report.   It's easy if the other report 
is based on the same table.  But if it isn't, you can still copy your controls. 
 You would just have to click on every control you pasted and then assign the 
proper table/column 

Karen



 

 

-Original Message-
From: Randy Larsen <thelars...@gmail.com>
To: rbase-l <rbase-l@googlegroups.com>
Sent: Thu, Dec 14, 2017 10:47 am
Subject: Re: [RBASE-L] - copying images


Sorry, i wasn’t clear.. the table i’m referring is not a db table, but a table 
printed in the form..essentially a “reusable" section of the report.


So basically is there a way to create a reusable section, that is populated 
with data that could be shared amount many reports


HTH



Cheers,
-Randy











If you want to go fast, go alone.  If you want to go far, go together.
-African proverb







On Dec 14, 2017, at 11:17 AM, Buddy Walker <walker.bu...@comcast.net> wrote:


Randy
  If the “similar” is populated based on the user I would make the “similar” a 
temporary table. With that the report would print based on that table with data 
for that user. By the way other users would not see that table (since it is 
dropped when user exits R:Base). 


Buddy


Sent from my iPhone

On Dec 14, 2017, at 10:56 AM, Randy Larsen <thelars...@gmail.com> wrote:



Hi Everyone, I’m also new to Rbase and I’m new to this group.. and very happy 
to see that you are so active!


I have a question about Reports as well.


I have number of reports that all share a similar table.  I was wondering if it 
is possible to create a report or sub report that can be shared/included b/n 
multiple reports?



Thank you!




-Randy











If you want to go fast, go alone.  If you want to go far, go together.
-African proverb







On Dec 14, 2017, at 10:49 AM, Chaya Goldberg <cgoldb...@omnirehab.com> wrote:


Thanks for your suggestion, Albert.  It gave me an idea.
I actually did use a sub report initially, but it has the same issue.  However 
perhaps I can use separate sub reports for the two images, in order to 
eliminate the need for the UPDATE statement.

Thanks,
Chaya

-Original Message-
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Albert Berry
Sent: Wednesday, December 13, 2017 3:51 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - copying images

Would it perhaps be easier to use a sub report for the images rather than 
updating the main table? Sub reports work quite will in R:Base

Albert


On Dec 13, 2017, at 1:33 PM, Chaya Goldberg <cgoldb...@omnirehab.com> wrote:

Hi Everyone,

I’m writing a report which needs to have two or three images on it in a certain 
order.  I get these images by querying our database.  The queried images first 
get saved to separate temporary tables (one of which will become the “main” 
table), then get collected into the main table using an UPDATE statement.  I 
then print the report off of this main table.

The problem is that the results are inconsistent.  Sometimes it works and the 
images print as they’re supposed to, but other times the second image does not 
appear.  In reviewing the tables during their intermediate stages, I’ve found 
that although both images initially appear when queried, the second image does 
not copy during 

Re: [RBASE-L] - copying images

[karentellef via RBASE-L]

Hi Randy!  I usually have a report called DEFAULTS.  On that report I have 
located all kinds of misc things, like page footers that I put at the bottom of 
each page, or page styles or letterhead-type of addresses, etc.  If there's DB 
fields that are in alot of reports and I always forget how wide the field 
should be (like a CustomerPart TEXT 20 field), I will put that control in my 
DEFAULTS report with the proper width for every font type/size I might use (I 
base my DEFAULTS report on the most commonly used table, or will have a report 
named with the table, like DefaultsCustPart, so I can locate DBEdits).  All 
controls can be copy/paste into other reports.

So yes, go ahead and define your section in your report and when you have it 
right you can copy/paste it to another report.   It's easy if the other report 
is based on the same table.  But if it isn't, you can still copy your controls. 
 You would just have to click on every control you pasted and then assign the 
proper table/column 

Karen



 

 

-Original Message-
From: Randy Larsen 
To: rbase-l 
Sent: Thu, Dec 14, 2017 10:47 am
Subject: Re: [RBASE-L] - copying images


Sorry, i wasn’t clear.. the table i’m referring is not a db table, but a table 
printed in the form..essentially a “reusable" section of the report.


So basically is there a way to create a reusable section, that is populated 
with data that could be shared amount many reports


HTH



Cheers,
-Randy











If you want to go fast, go alone.  If you want to go far, go together.
-African proverb







On Dec 14, 2017, at 11:17 AM, Buddy Walker  wrote:


Randy
  If the “similar” is populated based on the user I would make the “similar” a 
temporary table. With that the report would print based on that table with data 
for that user. By the way other users would not see that table (since it is 
dropped when user exits R:Base). 


Buddy


Sent from my iPhone

On Dec 14, 2017, at 10:56 AM, Randy Larsen  wrote:



Hi Everyone, I’m also new to Rbase and I’m new to this group.. and very happy 
to see that you are so active!


I have a question about Reports as well.


I have number of reports that all share a similar table.  I was wondering if it 
is possible to create a report or sub report that can be shared/included b/n 
multiple reports?



Thank you!




-Randy











If you want to go fast, go alone.  If you want to go far, go together.
-African proverb







On Dec 14, 2017, at 10:49 AM, Chaya Goldberg  wrote:


Thanks for your suggestion, Albert.  It gave me an idea.
I actually did use a sub report initially, but it has the same issue.  However 
perhaps I can use separate sub reports for the two images, in order to 
eliminate the need for the UPDATE statement.

Thanks,
Chaya

-Original Message-
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Albert Berry
Sent: Wednesday, December 13, 2017 3:51 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - copying images

Would it perhaps be easier to use a sub report for the images rather than 
updating the main table? Sub reports work quite will in R:Base

Albert


On Dec 13, 2017, at 1:33 PM, Chaya Goldberg  wrote:

Hi Everyone,

I’m writing a report which needs to have two or three images on it in a certain 
order.  I get these images by querying our database.  The queried images first 
get saved to separate temporary tables (one of which will become the “main” 
table), then get collected into the main table using an UPDATE statement.  I 
then print the report off of this main table.

The problem is that the results are inconsistent.  Sometimes it works and the 
images print as they’re supposed to, but other times the second image does not 
appear.  In reviewing the tables during their intermediate stages, I’ve found 
that although both images initially appear when queried, the second image does 
not copy during the UPDATE. 

Any suggestions or ideas as to why this would happen?


Chaya Goldberg

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
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 

Re: [RBASE-L] - OT: A Reflection on the integrity of the R:BASE Relational Engine

[karentellef via RBASE-L]

That is cool, Bruce, thanks for posting!

I remember in my early RBase days that I took a C class (can't remember what 
version of C it was at that point).  I liked it fine until we got to memory 
management, if I remember correct it was "pointers"??   I couldn't believe I 
had to tell the computer where the heck to put stuff!!   I passed the class, 
but I never chose to do anything with it.

Karen

 

 

 

-Original Message-
From: Bruce Chitiea 
To: rbase-l 
Sent: Sun, Dec 10, 2017 5:17 pm
Subject: [RBASE-L] - OT: A Reflection on the integrity of the R:BASE Relational 
Engine



All:


I humbly offer - as a meditation of sorts - an excerpt from the 
esr.ibiblio.org blog authored by Eric Raymond, on 2017-1113, in a series 
discussing possible paths for transitioning out of C++. No point to push, here: 
perspective, is all.



"...
"Ever since the very earliest computer languages it’s been understood that 
every language design embodies an assertion about the relative value of 
programmer time vs. machine resources. At one end of that spectrum you have 
languages like assembler and (later) C that are designed to extract maximum 
performance at the cost of also pessimizing developer time and costs; at the 
other, languages like Lisp and (later) Python that try to automate away as much 
housekeeping detail as possible, at the cost of pessimizing machine performance.
In broadest terms, the most important discriminator between the ends of 
this spectrum is the presence or absence of automatic memory management. This 
corresponds exactly to the empirical observation that memory-management bugs 
are by far the most common class of defects in machine-centric languages that 
require programmers to manage that resource by hand.
A language becomes economically viable where and when its relative-value 
assertion matches the actual cost drivers of some particular area of software 
development. Language designers respond to the conditions around them by 
inventing languages that are a better fit for present or near-future conditions 
than the languages they have available to use.
Over time, there’s been a gradual shift from languages that require manual 
memory management to languages with automatic memory management and garbage 
collection (GC). This shift corresponds to the Moore’s Law effect of decreasing 
hardware costs making programmer time relatively more expensive. But there are 
at least two other relevant dimensions.
One is distance from the bare metal. Inefficiency low in the software stack 
(kernels and service code) ripples multiplicatively up the stack. This, we see 
machine-centric languages down low and programmer-centric languages higher up, 
most often in user-facing software that only has to respond at human speed 
(time scale 0.1 sec).
Another is project scale. Every language also has an expected rate of 
induced defects per thousand lines of code due to programmers tripping over 
leaks and flaws in its abstractions. This rate runs higher in machine-centric 
languages, much lower in programmer-centric ones with GC. As project scale goes 
up, therefore, languages with GC become more and more important as a strategy 
against unacceptable defect rates.
... "

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google 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] - Restricting changes on a form

[karentellef via RBASE-L]

Seems to me like checking only the "add" box would make the form non-editable.  
But I'm wondering if because the Read-Only is OFF, that that overrules 
everything else.   But yeah, either turn the Read-Only ON, or bring up the form 
using BROWSE.  Add would have to be a button.

Karen

 

 

-Original Message-
From: Dan Goldberg <d...@lancecamper.com>
To: rbase-l <rbase-l@googlegroups.com>
Sent: Tue, Oct 31, 2017 8:32 am
Subject: RE: [RBASE-L] - Restricting changes on a form



Thx for the tip. Don’t know why the table settings do not work though.
 
Dan Goldberg
 
From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com]
Sent: Tuesday, October 31, 2017 5:50 AM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Restricting changes on a form
 

In the grids, you can select all the columns, do a right-click and set 
Read-Only ON.  But the person won't be able to add a row to the grid directly, 
you'd have to handle that by perhaps having a button on the form and bringing 
up a mini-form to add the data and refresh the grid.

Karen

 

 

 

-Original Message-
From: Dan Goldberg <d...@lancecamper.com>
To: rbase-l <rbase-l@googlegroups.com>
Sent: Mon, Oct 30, 2017 6:06 pm
Subject: Re: [RBASE-L] - Restricting changes on a form


Yes I have the master and the slave the same. They can add parts but not change 
or delete.


Dan Goldberg

 





On Mon, Oct 30, 2017 at 4:04 PM -0700, "Albert Berry" <alb...@albertberry.com> 
wrote:

Dan: just a thought, but do you have the replace check as off both tables?

 

On Oct 30, 2017, at 4:15 PM, Dan Goldberg <d...@lancecamper.com> wrote:

 

I have a form with 2 enhanced db grids(2 tables) that I want to allow the user 
to only be able to add new rows. I unchecked everything except “Add new rows to 
the table” but it still allows changes to existing rows.

 

Any blue’s clues on why or how to restrict them from changing saved data?

 



 

TIA

 

 

Dan Goldberg

 

 

 

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
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 
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 
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] - Tip of the Day: Column References in Enhanced DB Grid Dynamic Colors

[karentellef via RBASE-L]

This is great!  In the past I would always use an extra text column
and assign it an A/B/C depending on the calculation and then reference
that text column to assign the color.  This saves that extra step and
works when there's a permanent table with no extra text column for 
me to use!

Karen



 

-Original Message-
From: A. Razzak Memon 
To: rbase-l 
Sent: Sun, Oct 15, 2017 11:14 pm
Subject: [RBASE-L] - Tip of the Day: Column References in Enhanced DB Grid 
Dynamic  Colors

Monday, October 16, 2017

Tip of the Day: Column References in Enhanced DB Grid Dynamic Colors
Product...: R:BASE X and R:BASE X Enterprise (Version 10)
Build.: 10.0.3.11010 or higher
Section...: Forms
Keywords..: Enhanced DB Grid, Columns, Background Color, Font 
Color, Dynamic

Did you know that a column in the dataset may be referenced when 
assigning dynamic colors within
an Enhanced DB Grid?

The added Enhanced DB Grid ability allows for a field/column in the 
dataset to referenced in
order to apply a dynamic font/background color to the grid column.

http://www.razzak.com/tips/EnhancedDBGrid_DynamicColor_ColumnRef.jpg

The Dynamic Colors feature allows for the background and text colors 
to change based upon the
data values within the cell. To reflect upon the cell data, values 
can be a dotted variable,
a column enclosed in square brackets "[xxx]", or a combination of 
variable and literals, for
example: ".vCompName Corporation".

Column Reference Examples:

Example 1: Highlight all values greater than the "TotalAvailable" 
column: >([TotalAvailable])
Example 2: Highlight all values less than the value for the 
"LowerLimit" column: <([LowerLimit])
Example 3: Highlight all values equal to the value for the 
"PrimeRate" column: =([PrimeRate])

One of the most important aspects in business growth is your 
company's data, and no one else
has more invested in your success than R:BASE Technologies. Invest 
forward with R:BASE!

Very Best R:egards,

Razzak.

www.rbase.com
www.facebook.com/rbase
-- 

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [RBASE-L] - Send a PDF to printer command line

[karentellef via RBASE-L]

This is the command from an RBase file, so you can probably extract what you 
need from this for a batch file?


SET VAR vPrintString = +
(.vQuotes+'C:\Program Files\Adobe\Acrobat 5.0\Reader\AcroRd32.exe|/p 
/h'&.vPDFFilename+.vQuotes)

LAUNCH 


Karen


-Original Message-
From: THOMAS CIMICATO 
To: rbase-l 
Sent: Fri, Sep 29, 2017 10:47 am
Subject: [RBASE-L] - Send a PDF to printer command line

I want to send a PDF file to a printer from the windows command line 
batch file launched by an RBase stored procedure that was fired by an 
insert trigger from an ODBC insert. The PDF was created by R:WebReports.

Any thoughts?

Thom

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google 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] - Re: Trying to figure out IFF command

[karentellef via RBASE-L]

You cannot change the code from within that "code" tab at the bottom, if that's 
what you're trying to do.  You have to edit it from where it's located.  What 
kind of control is it in?   Bring up the properties of that control, look for 
the "eep" tab at the top, and you'll see highlighted in yellow where the eep 
code is.  You edit it there.

 

 Karen


 

-Original Message-
From: 'Patti Jakusz' via RBASE-L 
To: rbase-l 
Sent: Tue, Sep 26, 2017 12:58 pm
Subject: Re: [RBASE-L] - Re: Trying to figure out IFF command



I need help.
I figured out how to get the code in there.  But I made a typo and so the code 
didn't work and now I can't get it back out and I can't edit it.  


I see that Settings drop down box on the right side where it lets you select 
"Edit on start of EEP" or "Edit on cursor position", but it's not letting me 
edit the code.


Patti



  
 
 
  
 From: Buddy Walker 
 To: rbase-l@googlegroups.com 
 Sent: Tuesday, September 26, 2017 12:21 PM
 Subject: Re: [RBASE-L] - Re: Trying to figure out IFF command
  
 


No problem.  I won’t have access to my pc for about 3 hours or so.  If any 
questions just ask. 


Buddy


Sent from my iPhone


On Sep 26, 2017, at 11:15 AM, 'Patti Jakusz' via RBASE-L 
 wrote:




No, I didn't know about it (or was told and forgot.)  I just found the Code 
tab.  I'll try to figure it out.  
Thanks!


Patti



  
 
 
  
 From: Buddy Walker 
 To: rbase-l@googlegroups.com 
 Sent: Tuesday, September 26, 2017 11:01 AM
 Subject: Re: [RBASE-L] - Re: Trying to figure out IFF command
  
 


Patti
  Have you tried using on before eep in the detail band to test for null and 
write your IF statement there. 


Buddy


Sent from my iPhone


On Sep 26, 2017, at 10:09 AM, 'Patti Jakusz' via RBASE-L 
 wrote:




Nope.  Still didn't work.


Thank you for your help.  I'm giving up and creating a temp table and 
converting the field to a 1 or 0 in the temp table. 


Patti
  
 
 
  
 From: Michael Byerley 
 To: RBASE-L  
 Sent: Monday, September 25, 2017 10:54 PM
 Subject: [RBASE-L] - Re: Trying to figure out IFF command
  
 



If nulls are to be evaluated in your expressions, you need to set ZERO ON:



Syntax: SET ZERO ON/OFF


 


Default: OFF


 


SET ZERO allows a null to be treated as a zero in a mathematical expression 
involving INTEGER, NUMERIC, REAL, DOUBLE, CURRENCY, DATE, DATETIME, or TIME 
data types. With ZERO set on, R:BASE returns a negative number when you 
subtract an integer from a null. With ZERO set off, the same computation 
results in a null. R:BASE stores the setting with the database.


Otherwise your expression will fail unless you are evaluating for a NULL 
condition as in using IFNULL.


 



On Monday, September 25, 2017 at 2:58:21 PM UTC-4, Patti Jakusz wrote:


Hello,










I'm using Rbase X and creating a new report.


I have a field in my database, that can have a value of 0,1,2,3,4,5,7 or 8.  If 
it has a value of 3,4 or 5, I want a checkbox to be checked.  So I'm trying to 
use this new (new to me) command IFF.


I set a report variable (var1) = to the field in the database.  (I tried using 
just the field name, and that didn't work either.)
Then another variable var2 = (iff(('.var1>2 and .var1<6'),1,0))




The definition of IFF says you can use "and", but then Rbase doesn't like it.
(IFF((condition),arg1,arg2))

The condition must list a set of conditions that combine to form a statement 
that is either true or false. Conditions can be combined with the connecting 
operators AND, OR, AND NOT, and OR NOT.  



but then it further states:
It is important to note that the condition needs to be a single item, which is 
why quotes are used in the examples below. 



???


I get the following errors:

Constant cannot be followed by a column/variable


If I add more quotation marks '.var1>2' and '.var1<6'
then I get the following error: Nulls cannot be used in comparisons other than 
NE or EQ


What am I doing wrong?
Thank you,
Patti




 
 
  




-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.




 
 
  

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.




-- 
For group guidelines, visit 

Re: [RBASE-L] - Adding computed column

[karentellef via RBASE-L]

Something like:

ALTER TABLE tablename ADD CompColname=(column1 * column2) CURRENCY

Karen

 

 

 

-Original Message-
From: Tom Hart 
To: rbase-l 
Sent: Tue, Sep 19, 2017 11:02 am
Subject: [RBASE-L] - Adding computed column



For some reason when I converted my databases to XE I lost a computed column.  
How do I create the computed column again thru a command line like alter 
table


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.
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] - calculate number of business days

[karentellef via RBASE-L]

I'm not aware of any function that will do it.  Here's a simple while loop, in 
case you don't already do this.  vCount would have the #days


SET VAR vDays = (.vedate - .vbdate)
SET VAR vCount INT = 0, vLoop INT = 0
WHILE vLoop <= .vDays THEN
  SET VAR vTestDate = (.vbdate + .vLoop)
  IF (IDWK(.vTestDate)) BETWEEN 1 AND 5 THEN
SET VAR vCount = (.vCount + 1)
  ENDIF
  SET VAR vLoop = (.vLoop + 1)
ENDWHILE

Karen

 

 

 

-Original Message-
From: Dan Goldberg 
To: rbase-l 
Sent: Tue, Sep 5, 2017 1:04 pm
Subject: [RBASE-L] - calculate number of business days



I need to calculate the number of business days between to date values.
 
Which gives me the number of days. But I need to calculate the number of days 
without weekends.
 
I cannot find a function that will achieve the results in need.
 
Does anyone have an idea on how to calculate it?
 
TIA 
 
 
Dan Goldberg
 

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
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

[karentellef via RBASE-L]

Awesome!  Glad it worked!

Karen

 

 

 

-Original Message-
From: Carpet Broker, Dick Fey 
To: RBase Maillist 
Sent: Fri, Sep 1, 2017 12:44 pm
Subject: [RBASE-L] - Form

Thanks Karen... Fixed!

This list is so awesome.

Dick Fey

-- 
Carpet Broker Inc
P: 913-894-9211
F: 913-894-0138


-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google 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 problem

[karentellef via RBASE-L]

If I understand, your setup will not work. It is trying to link common
columns between the tables in the two grids, and because your
color column is called the same (I'm guessing) it will only show
the match, which is probably the exact same data as on the left.

To do that, you'd have to make sure the 2nd grid is based on a
table/view that has only ONE linking column to the 1st grid.

Like if on the left you had:
AcctNo  INT
ColorCol TEXT 12

You button would have to create a temp view (or a temp table):
create temp view vTest (AcctNo, ColorCol2) as select acctno, colorcol from 
 
property table vTest 'refresh'

That way AcctNo is the only link.  

Karen

 

 

 

-Original Message-
From: Carpet Broker, Dick Fey 
To: RBase Maillist 
Sent: Fri, Sep 1, 2017 12:12 pm
Subject: [RBASE-L] - Form problem

Building a form with 2 db grids.  Left grid displays all products that 
contain a certain color name or number.
Upon clicking the desired style with a on click eep,  I want to display 
all the colors in the selected style in grid 2.
I project a temp table containing all the colors.  If you look at the 
table it works perfectly, but the dbgrid on the
right only displays 1 line.

Its like you display a list of products on the left, clicking the field 
displays a list of necessary parts on the right.

So close, but no cigar.

???

Dick Fey

-- 
Carpet Broker Inc
P: 913-894-9211
F: 913-894-0138


-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google 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] - Re: send keystroke

[karentellef via RBASE-L]

Speaking of playback   I have one database that has a tiny little piece
that is still in RBase 6.5 windows, waiting to be updated like their other
99% has been updated.  Everything was working until they got a few new 
computers with MS Windows 10 installed.  Playbacks no longer work under 
Windows 10.  Halle-freakin-lujah!  Now they have to upgrade this last little 
chunk.

Karen

 

 

-Original Message-
From: Michael Byerley 
To: RBASE-L 
Sent: Fri, Aug 25, 2017 5:35 pm
Subject: [RBASE-L] - Re: send keystroke





Razzak,


  RBase DOS PlayBack function had more than one use, as I recall  :)

On Tuesday, August 22, 2017 at 6:01:20 PM UTC-4, dang wrote:

I need to send a keystroke to the pc but forgot how to do it.
 
I need to send a ctrl-F12 to the pc.
 
TIA
 
Dan Goldberg
 



-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
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] - Help with DBGrid search command - correction

[karentellef via RBASE-L]

Yeah, you're sorta right.  This form started out with an editable DBGrid based 
on a table.
Then we switched it to be based on a view (and therefore became not-editable), 
and it was 
easier to simply modify the existing DBGrid to be based on a view than to throw 
it out
and turn it into a list view.  But a list view is on our "workaround" list if 
we don't get this
to work.


Karen

 

 

-Original Message-
From: jan johansen <j...@jjcalibrations.com>
To: rbase-l <rbase-l@googlegroups.com>
Sent: Fri, Aug 25, 2017 12:40 pm
Subject: RE: [RBASE-L] - Help with DBGrid search command - correction



Karen,
 
Why are you using a DB-Grid?
Seems you can you do want with Variable List View that you can keep the focus 
on the row.
 
Jan
 
-Original Message-
From: Dan Goldberg <d...@lancecamper.com>
To: "rbase-l@googlegroups.com" <rbase-l@googlegroups.com>
Date: Fri, 25 Aug 2017 16:57:35 +
Subject: RE: [RBASE-L] - Help with DBGrid search command - correction
 
Don’t know. I use the search command that looks the same as yours.
 
I use a similar code without any issues.
 
SET VAR vedate DATE = (.#DATE - 1)
 
SET VAR vesearch TEXT = ('PROPERTY TABLE orders99 SEARCH->onlinedate->'++
(CTXT (.#date)))

 
Dan Goldberg
 
From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com]
Sent: Friday, August 25, 2017 9:49 AM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Help with DBGrid search command - correction
 
Yes, vOldBLNo is a row that still exists.  They are not allowed to change the 
Primary Key BLNo field in the grid.

Originally I was using the form variable vBLNo which identifies the PK, but 
found that the Close/Open command put the focus back on the first row and 
changed the vBLNo variable.  That's why I had to "save" the vBLNo of the row 
they were on and search using that variable after the Close/Open!

Karen

 

 

 

-Original Message-
From: Dan Goldberg <d...@lancecamper.com>
To: rbase-l <rbase-l@googlegroups.com>
Sent: Fri, Aug 25, 2017 11:46 am
Subject: RE: [RBASE-L] - Help with DBGrid search command - correction


Does vOldBLNo exist in the grid? If it does not the search will not do anything.

 

Dan Goldberg

 

 

From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com]
Sent: Friday, August 25, 2017 9:14 AM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - Help with DBGrid search command - correction

 

A slight error in my message:


 


 


 


Using version X, 7/31 build.

I have a grid based on a view.  Clicking in a column runs eep code that updates 
the underlying data, does a CLOSE/OPEN of the grid's view. 

Problem is that I lose the focus on the row the user was on.  I thought that 
the "search" command was the way to go.  It traces fine, no errors, the 
variable values look correct, but it doesn't change focus.  Focus stays on the 
first row of the refreshed grid.  Can anyone find an error in my code, or 
suggest a different way?  I do not want to use "filter" commands because I want 
all data to show up.

SET VAR vOldBLNo = .vBLNo
UPDATE salesdelwksheet SET po = .vPO WHERE blno = .vBLNo
PROPERTY TABLE vSalesDelWksheet2 'CLOSE'
PROPERTY TABLE vSalesDelWksheet2 'OPEN'
SET VAR vCommand = ('PROPERTY TABLE vSalesDelWksheet2 SEARCH->BLNo->' + 
(CTXT(.vOldBLNo)) )



Thanks for the help!

Karen



--
For group guidelines, visit  
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit  https://groups.google.com/d/optout.

--
For group guidelines, visit  
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit  https://groups.google.com/d/optout.


--
For group guidelines, visit  
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

 
--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

-- 
For group guidelines, visit 
http://www.r

Re: [RBASE-L] - Help with DBGrid search command

[karentellef via RBASE-L]

Actually this is kinda timely because I did use the REFRESH first, but it didn't
work.  I always use REFRESH and never before have needed to use CLOSE/OPEN.
Must have something to do with the particular view that the DBGrid is based on, 
but it never refreshed.   It's a 4-table view, because it's looking up the 
account name 
to the same table for 3 different columns of the primary table.  Here's the 
definition (formatted to fit this email):

View: vSalesDelWksheet2 (SWID, BLNo, HasNotes, ShipDate, PO, 
BillTo,   Cosignee, Shipper, ActNameB, ActNameC, ActNameS)
SELECT t1.swid, t1.blno, t1.hasnotes, t1.shipdate, t1.po,
t1.billto, t1.cosignee, t1.shipper, t2.actname, t3.actname, t4.actname 
FROM SalesDelWksheet t1, account t2, account t3, account t4 
WHERE t1.billto = t2.acctno AND t1.cosignee = t3.acctno AND t1.shipper = 
t4.acctno


So I changed it to be a CLOSE/OPEN and then it worked perfectly.  So I'm
surmising that the search will only work against a REFRESH.

Maybe I will prepare an example of this form & the view to demonstrate that
it didn't refresh.

Thanks for the response!

Karen

 

 

-Original Message-
From: A. Razzak Memon 
To: rbase-l 
Sent: Fri, Aug 25, 2017 1:04 pm
Subject: Re: [RBASE-L] - Help with DBGrid search command

I feel compelled to help this particular post.

This may be too overwhelming to comprehend .

When developing applications, there are very specific scenarios when 
you have to use PROPERTY TABLE TableViewName ('CLOSE'/'OPEN') commands.

However, based on the specific needs, there are times when you simply 
have to use the good old PROPERTY TABLE TableViewName 'REFRESH' command.

In your specific case, if you wish to retain the highlighted/selected 
row of Enhanced DB Grid, as is, you will have to use the REFRESH 
option to accomplish your goal.

Here is a col example to illustrate the exact use of such PROPERTY command:
(See attached screen shots)

-- Start
-- Enhanced DB Grid
-- On Double-Click EEP
-- Author: A. Razzak Memon
-- Date Created: June 3, 2017
-- Last Updated: August 18, 2017
-- Last Updated: August 20, 2017
-- Last Updated: August 24, 2017
CLS
EDIT USING TSSXE_Dashboard_Job WHERE JobID = .vJobID CAPTION 'Job Details'
PROPERTY TABLE Jobs_By_Project_Manager 'REFRESH'
PROPERTY TABLE Jobs_By_Project_Manager_ThreeDays 'REFRESH'
RETURN
-- End

Variable (vJobID) is a Table based Form Expression, associated with 
Enhanced DB Grid.

That's all there is to it!

Very Best R:egards,

Razzak


At 12:10 PM 8/25/2017, Karen Tellef via RBASE-L wrote:

>Using version X, 7/31 build.
>
>I have a grid based on a view.  Clicking in a column runs eep code 
>that updates the underlying data,
>does a CLOSE/OPEN of the grid's view.
>
>Problem is that I use the focus on the row the user was on.  I 
>thought that the "search" command was the way to go.  It traces 
>fine, no errors, the variable values look correct, but it doesn't 
>change focus.  Focus stays on the first row of the refreshed 
>grid.  Can anyone find an error in my code, or suggest a different 
>way?  I do not want to use "filter" commands because I want all data 
>to show up.
>
> SET VAR vOldBLNo = .vBLNo
> UPDATE salesdelwksheet SET po = .vPO WHERE blno = .vBLNo
> PROPERTY TABLE vSalesDelWksheet2 'CLOSE'
> PROPERTY TABLE vSalesDelWksheet2 'OPEN'
> SET VAR vCommand = ('PROPERTY TABLE vSalesDelWksheet2 
> SEARCH->BLNo->' + (CTXT(.vOldBLNo)) )
> 
>
>Thanks for the help!


-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google 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] - Help with DBGrid search command - correction

[karentellef via RBASE-L]

Yes, vOldBLNo is a row that still exists.  They are not allowed to change the 
Primary Key BLNo field in the grid.

Originally I was using the form variable vBLNo which identifies the PK, but 
found that the Close/Open command put the focus back on the first row and 
changed the vBLNo variable.  That's why I had to "save" the vBLNo of the row 
they were on and search using that variable after the Close/Open!

Karen

 

 

 

-Original Message-
From: Dan Goldberg <d...@lancecamper.com>
To: rbase-l <rbase-l@googlegroups.com>
Sent: Fri, Aug 25, 2017 11:46 am
Subject: RE: [RBASE-L] - Help with DBGrid search command - correction



Does vOldBLNo exist in the grid? If it does not the search will not do anything.
 
Dan Goldberg
 
 
From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com]
Sent: Friday, August 25, 2017 9:14 AM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - Help with DBGrid search command - correction
 
A slight error in my message:

 

 

 

Using version X, 7/31 build.

I have a grid based on a view.  Clicking in a column runs eep code that updates 
the underlying data, does a CLOSE/OPEN of the grid's view. 

Problem is that I lose the focus on the row the user was on.  I thought that 
the "search" command was the way to go.  It traces fine, no errors, the 
variable values look correct, but it doesn't change focus.  Focus stays on the 
first row of the refreshed grid.  Can anyone find an error in my code, or 
suggest a different way?  I do not want to use "filter" commands because I want 
all data to show up.

SET VAR vOldBLNo = .vBLNo
UPDATE salesdelwksheet SET po = .vPO WHERE blno = .vBLNo
PROPERTY TABLE vSalesDelWksheet2 'CLOSE'
PROPERTY TABLE vSalesDelWksheet2 'OPEN'
SET VAR vCommand = ('PROPERTY TABLE vSalesDelWksheet2 SEARCH->BLNo->' + 
(CTXT(.vOldBLNo)) )



Thanks for the help!

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 
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 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[RBASE-L] - Help with DBGrid search command - correction

[karentellef via RBASE-L]

A slight error in my message:

 





Using version X, 7/31 build.

I have a grid based on a view.  Clicking in a column runs eep code that updates 
the underlying data, does a CLOSE/OPEN of the grid's view.  

Problem is that I lose the focus on the row the user was on.  I thought that 
the "search" command was the way to go.  It traces fine, no errors, the 
variable values look correct, but it doesn't change focus.  Focus stays on the 
first row of the refreshed grid.  Can anyone find an error in my code, or 
suggest a different way?  I do not want to use "filter" commands because I want 
all data to show up.

SET VAR vOldBLNo = .vBLNo
UPDATE salesdelwksheet SET po = .vPO WHERE blno = .vBLNo
PROPERTY TABLE vSalesDelWksheet2 'CLOSE'
PROPERTY TABLE vSalesDelWksheet2 'OPEN'
SET VAR vCommand = ('PROPERTY TABLE vSalesDelWksheet2 SEARCH->BLNo->' + 
(CTXT(.vOldBLNo)) )



Thanks for the help!

Karen


-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[RBASE-L] - Help with DBGrid search command

[karentellef via RBASE-L]

Using version X, 7/31 build.

I have a grid based on a view.  Clicking in a column runs eep code that updates 
the underlying data, does a CLOSE/OPEN of the grid's view.  

Problem is that I use the focus on the row the user was on.  I thought that the 
"search" command was the way to go.  It traces fine, no errors, the variable 
values look correct, but it doesn't change focus.  Focus stays on the first row 
of the refreshed grid.  Can anyone find an error in my code, or suggest a 
different way?  I do not want to use "filter" commands because I want all data 
to show up.

SET VAR vOldBLNo = .vBLNo
UPDATE salesdelwksheet SET po = .vPO WHERE blno = .vBLNo
PROPERTY TABLE vSalesDelWksheet2 'CLOSE'
PROPERTY TABLE vSalesDelWksheet2 'OPEN'
SET VAR vCommand = ('PROPERTY TABLE vSalesDelWksheet2 SEARCH->BLNo->' + 
(CTXT(.vOldBLNo)) )



Thanks for the help!

Karen

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [RBASE-L] - Another Enhanced DB Grid Question

[karentellef via RBASE-L]

Paul:  is this happening only after someone selects your "update" button?  If 
the "update" button is changing the table data, are you then refreshing the 
data in the grid?  If you aren't, then that's the problem.

Have the button do its updating code then either   PROPERTY TABLE  
'REFRESH' or if that doesn't work do a 'CLOSE' / 'OPEN'

Otherwise, what RBase is telling you is that the button updated the underlying 
code, but your grid still shows the previous values so it's correctly letting 
you know of the mismatch.

Karen


 

 

 

-Original Message-
From: Paul C. Buckley 
To: rbase-l 
Sent: Thu, Aug 24, 2017 7:19 am
Subject: RE: [RBASE-L] - Another Enhanced DB Grid Question



Claudine,
 
That was the first thing I tried. This isn’t happening closing the form it 
happens going from one field to the next in the Enhanced DB grid.
 
Thanks,
Paul
 

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Claudine Robbins
Sent: August 23, 2017 5:32 PM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - Another Enhanced DB Grid Question

 
Check  the “Don’t Show Save Dialog” in the FORM PROPERTIES Attributes
 

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Paul C. Buckley
Sent: Wednesday, August 23, 2017 3:14 PM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - Another Enhanced DB Grid Question

 
Good afternoon,
 
I'm probably missing something simple, I'm using the latest R:BASE X Enterprise 
and I have an Enhanced DB grid based on a single table view. Thanks to Karen, 
I’ve got the dirty flag and primary key working so I can update changes from a 
push button. Here’s my dilemma, if I click on a cell and make a change and then 
click on another cell (same row or different row, it doesn’t matter) I get a 
popup message the data has changed, do I want to save the data. I’m handling 
the updates from a push button and looking at the dirty flag. I’ve tried 
everywhere I can think of and I have found to not “ask to save changes” and 
this continues to popup.
 
Any blues clues would be greatly appreciated,
 
Paul Buckley
-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.



-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google 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] - Determining Current Row in Enhanced DB Grid

[karentellef via RBASE-L]

Yeah, let's say your grid is based on a table called Clients and there's a PK 
column called ClientID.  Just create a form variable:
   vClientID = ClientID

So if they click anywhere in that row, the vclientID will hold the value of the 
PK column in that row.  So if they click a button that then says "update" or 
whatever, you just grab the vClientID to see what row they had clicked in.  I 
do that all the time.  Just to verify, I always put a dialog box to the user 
something like:   "Do you want to update the record for ClientID:  
To: rbase-l <rbase-l@googlegroups.com>
Sent: Wed, Aug 23, 2017 7:55 am
Subject: RE: [RBASE-L] - Determining Current Row in Enhanced DB Grid



Karen,
 
I guess I haven’t had enough coffee yet, you said “then just create a form 
variable to capture the PK of the row they're on”. That’s what I’m struggling 
with. The user can click any cell in the grid in a given row. What I’d like to 
do is set a variable to the primary key column for that row. If they change 
anything in the row the dirty flag is set and I can update my tables 
accordingly.
 
Thanks in advance for any assistance,
Paul Buckley
 
From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com] 
Sent: August 22, 2017 5:34 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Determining Current Row in Enhanced DB Grid
 

Are they clicking into a particular row in the Grid to change?  If so, then 
just create a form variable to capture the PK of the row they're on

Karen

 

 

 

-Original Message-
From: Paul C. Buckley <p...@buckleyandassoc.com>
To: rbase-l <rbase-l@googlegroups.com>
Sent: Tue, Aug 22, 2017 3:44 pm
Subject: [RBASE-L] - Determining Current Row in Enhanced DB Grid

Good afternoon,

I'm probably making this much harder than it needs to be but I can't figure out 
what to do. I'm using the latest R:BASE X Enterprise and I have an Enhanced DB 
grid based on a single table view. I have a column in the table/view that I 
want to set if the user changes anything in the row. There is an update button 
on the form that updates the data in an attached SQL table based on only the 
rows in the R:BASE table that have changed. I'm struggling with how to change 
the update flag column using the RBTI_DIRTY_FLAG. I'm looking for something 
like the "Where current cursor" option in Declare Cursor. Any suggestions would 
be greatly appreciated.

Thanks,
Paul Buckley

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.



-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google 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] - This worked previously as a on click eep but not now under version X

[karentellef via RBASE-L]

Have you put 'set trace on' at the top of your eep, and added watch variables 
so you can see what's happening?

Karen

 

 

 

-Original Message-
From: Albert Berry 
To: rbase-l 
Sent: Thu, Aug 17, 2017 11:37 am
Subject: Re: [RBASE-L] - This worked previously as a on click eep but not now 
under version X





Some ideas
- Does Costs have a PK that is not being updated with a new value on the insert?
- Should your insert include the value of the current row for reference?


Albert



On Aug 17, 2017, at 8:01 AM, DB GEOINFO  wrote:



Simple problem. Old fashioned. This just calculates a 10% tax except when less 
is levied or sometimes zero. Simple but doesn’t work anymore. Nothing happens. 
Gst is not updated. How should I re-write it?
 
 
EEP
*(calc_gst)
*(Y = 10% gst, N = 0 gst, X = manual gst entry)
 
SET VAR vgst1 = .CGST
SET VAR vcamt = .CAmt
SET VAR vynx = .GstYN
SET VAR vgst = 0
SWITCH (.vynx)
  CASE 'Y'
SET VAR vgst = (.vcamt/11)
BREAK
  CASE 'N'
SET VAR vgst = 0
BREAK
  CASE 'X'
SET VAR vgst = .vgst1
BREAK
ENDSW
 
INSERT INTO Costs (CGst) VALUES (.vgst)
 
RECALC VARIABLES
RETURN
 
Drake-Brockman Geoinfo Pty Ltd 
404 Great Eastern Highway 
Woodbridge, Perth, WA, Australia, 6056
Tel +61 8 9274 5477 
Mob +61427 525952 
Email d...@dbgeoinfo.net.au
Web www. dbgeoinfo.net.au
Dropbox URL:  https://www.hightail.com/u/DBGEOINFO
 



-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.




-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [RBASE-L] - Default to FILL for UNLOAD DATA

[karentellef via RBASE-L]

I think what I'd do is project a temporary table, do the "unload all / 
noschema" on the temp table, run the file in the new database, and then append 
to the permanent table

Karen

 

 

 

-Original Message-
From: Buddy Walker 
To: rbase-l 
Sent: Sat, Aug 12, 2017 8:08 pm
Subject: RE: [RBASE-L] - Default to FILL for UNLOAD DATA



Larry
 Maybe I’m missing the point but why not 
 
   LOAD table FROM filename USI columnListHere
 
   Just make sure to exclude computed/autonum  and any new columns.
 
Buddy
 
 

From: 'Lawrence Lustig' via RBASE-L [mailto:rbase-l@googlegroups.com] 
Sent: Saturday, August 12, 2017 12:26 PM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - Default to FILL for UNLOAD DATA

 

I'm trying to migrate a database which involves doing UNLOAD DATA from the load 
database and running the resulting files into a new database.

 

In some tables, the new database tables have a few fields added at the end of 
the table.  R:Base is refusing to load these tables because, when the unloaded 
files are created, they do not include the FILL statement to populate "extra" 
columns on the LOAD.

 

Is there a way to either:

Tell R:Base to include FILL in the UNLOAD DATA command OR
Tell R:Base that, when processing a LOAD command, if neither FILL or NOFILL  is 
specified the default should be FILL instead of NOFILL?

 

--

Larry

 

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [RBASE-L] - rbadmin

[karentellef via RBASE-L]

I didn't see anyone respond to you yet.


The one thing that I was told is that it needs to be installed on and run from 
the database server, so in my specific case it wouldn't work for me.  When you 
remote in, are you remoting (is that a word) into the server?  If you can't get 
to the server itself, then it won't help you.

Karen

 

 

 

-Original Message-
From: Jim Belisle 
To: rbase-l 
Sent: Tue, Aug 8, 2017 11:14 am
Subject: [RBASE-L] - rbadmin



 
We use 9.5 here and we also have RBAdmin but I have not installed it.
Because I do most of my work remotely, I often need to remove the RBASE 
connections but cannot while the office is closed.
 
My question is this. I know I have to have administrator rights to install 
RBAdmin.
Do I have administrator rights to use the program and disconnect users?
 
James Belisle
 
Making Information Systems People Friendly Since 1990

 

-- 
You received this message because you are subscribed to the Google 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.

Re: [RBASE-L] - Problem with Windows 10 update and my RB reports - SOLVED

[karentellef via RBASE-L]

I had 4 USB devices plugged in.  3 of the devices were turned OFF and one was 
ON when the update happened.   I lost the 3 devices that were OFF, only the ON 
device was still there after the update.

I was able to reinstall the 3 devices.  Not a good way for an update to behave!

Karen

 

 

 

-Original Message-
From: Albert Berry <alb...@albertberry.com>
To: rbase-l <rbase-l@googlegroups.com>
Sent: Sun, Aug 6, 2017 5:41 pm
Subject: Re: [RBASE-L] - Problem with Windows 10 update and my RB reports - 
SOLVED


Not the first time Windows 10 has removed printers. Happens to my wife’s PC 
about every 3rd update. Of course, I am anti-Microsoft biased since Win 10 
wiped the operating system off a laptop. 



On Aug 6, 2017, at 4:05 PM, karentellef via RBASE-L <rbase-l@googlegroups.com> 
wrote:


And THANK YOU Dan.   I should've known that when there's an issue with reports, 
you just gotta check your printers!!!

Karen

 

 

 

-Original Message-
From: karentellef <karentel...@cs.com>
To: rbase-l <rbase-l@googlegroups.com>
Sent: Sun, Aug 6, 2017 5:00 pm
Subject: Re: [RBASE-L] - Problem with Windows 10 update and my RB reports - 
SOLVED


My printer is gone!!   It's nowhere listed.

I'll reinstall that and look for the windows setting


Karen



 

 

 

-Original Message-
From: Dan Goldberg <d...@lancecamper.com>
To: rbase-l <rbase-l@googlegroups.com>
Sent: Sun, Aug 6, 2017 4:16 pm
Subject: Re: [RBASE-L] - Problem with Windows 10 update and my RB reports



Make sure u have a default printer set correct. Also I turn off the setting 
that allows windows to manage the default printer.



Dan Goldberg

Lance Camper






On Sun, Aug 6, 2017 at 1:15 PM -0700, "karentellef via 
RBASE-L"<rbase-l@googlegroups.com> wrote:


This morning my laptop insisted on installing a really long Windows 10 update 
that I'd been putting off for probably a week.

This is on my personal development machine, not on a network.

And now my RBase reports are screwed up.  I can bring reports up in the 
designer, but both preview and printing from the R> prompt shows a blank page.  
Sometimes doing the preview locks RBase up.

Here's what I tested:

1.  I picked multiple local databases, they all behaved the same way.  All the 
databases are ones I use regularly, they all worked fine the last time I 
accessed before today.

2.  I would pick a table that has lots of data and multiple reports.  Some 
reports will print fine, some do not.  Cannot find a pattern.

3.  It happens on version 9.5, version X,  32-bit and 64-bit (I got them all 
installed here).  Fails on databases inALL versions

4.  My first hint that something was wrong:  I tried to do an insert into a 
table and got an error message I'd never seen, about not having privileges with 
owner password NONE.  None of my databases have an owner password.  I did an 
autochk and a reload of that database and the error message went away and I 
could insert.  However, it is one of the databases where reports do not work.


Anyone having this happening to them?  Can someone think of a Windows setting 
that would affect this?

Should I revert to the previous windows 10 build, and if so how do I do that?  
A restore point?

And then I guess I research how to stop windows 10 from updating..

Thank you Microsoft

Karen



-- 
You received this message because 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.



-- 
You received this message because you are subscribed to the Google 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.





-- 
You received this message because you are subscribed to the Google 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.

Re: [RBASE-L] - Problem with Windows 10 update and my RB reports - SOLVED

[karentellef via RBASE-L]

And THANK YOU Dan.   I should've known that when there's an issue with reports, 
you just gotta check your printers!!!

Karen

 

 

 

-Original Message-
From: karentellef <karentel...@cs.com>
To: rbase-l <rbase-l@googlegroups.com>
Sent: Sun, Aug 6, 2017 5:00 pm
Subject: Re: [RBASE-L] - Problem with Windows 10 update and my RB reports - 
SOLVED


My printer is gone!!   It's nowhere listed.

I'll reinstall that and look for the windows setting


Karen



 

 

 

-Original Message-
From: Dan Goldberg <d...@lancecamper.com>
To: rbase-l <rbase-l@googlegroups.com>
Sent: Sun, Aug 6, 2017 4:16 pm
Subject: Re: [RBASE-L] - Problem with Windows 10 update and my RB reports



Make sure u have a default printer set correct. Also I turn off the setting 
that allows windows to manage the default printer.



Dan Goldberg

Lance Camper






On Sun, Aug 6, 2017 at 1:15 PM -0700, "karentellef via 
RBASE-L"<rbase-l@googlegroups.com> wrote:


This morning my laptop insisted on installing a really long Windows 10 update 
that I'd been putting off for probably a week.

This is on my personal development machine, not on a network.

And now my RBase reports are screwed up.  I can bring reports up in the 
designer, but both preview and printing from the R> prompt shows a blank page.  
Sometimes doing the preview locks RBase up.

Here's what I tested:

1.  I picked multiple local databases, they all behaved the same way.  All the 
databases are ones I use regularly, they all worked fine the last time I 
accessed before today.

2.  I would pick a table that has lots of data and multiple reports.  Some 
reports will print fine, some do not.  Cannot find a pattern.

3.  It happens on version 9.5, version X,  32-bit and 64-bit (I got them all 
installed here).  Fails on databases inALL versions

4.  My first hint that something was wrong:  I tried to do an insert into a 
table and got an error message I'd never seen, about not having privileges with 
owner password NONE.  None of my databases have an owner password.  I did an 
autochk and a reload of that database and the error message went away and I 
could insert.  However, it is one of the databases where reports do not work.


Anyone having this happening to them?  Can someone think of a Windows setting 
that would affect this?

Should I revert to the previous windows 10 build, and if so how do I do that?  
A restore point?

And then I guess I research how to stop windows 10 from updating..

Thank you Microsoft

Karen



-- 
You received this message because 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.



-- 
You received this message because you are subscribed to the Google 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.

Re: [RBASE-L] - Problem with Windows 10 update and my RB reports - SOLVED

[karentellef via RBASE-L]

My printer is gone!!   It's nowhere listed.

I'll reinstall that and look for the windows setting


Karen



 

 

 

-Original Message-
From: Dan Goldberg <d...@lancecamper.com>
To: rbase-l <rbase-l@googlegroups.com>
Sent: Sun, Aug 6, 2017 4:16 pm
Subject: Re: [RBASE-L] - Problem with Windows 10 update and my RB reports



Make sure u have a default printer set correct. Also I turn off the setting 
that allows windows to manage the default printer.



Dan Goldberg

Lance Camper






On Sun, Aug 6, 2017 at 1:15 PM -0700, "karentellef via 
RBASE-L"<rbase-l@googlegroups.com> wrote:


This morning my laptop insisted on installing a really long Windows 10 update 
that I'd been putting off for probably a week.

This is on my personal development machine, not on a network.

And now my RBase reports are screwed up.  I can bring reports up in the 
designer, but both preview and printing from the R> prompt shows a blank page.  
Sometimes doing the preview locks RBase up.

Here's what I tested:

1.  I picked multiple local databases, they all behaved the same way.  All the 
databases are ones I use regularly, they all worked fine the last time I 
accessed before today.

2.  I would pick a table that has lots of data and multiple reports.  Some 
reports will print fine, some do not.  Cannot find a pattern.

3.  It happens on version 9.5, version X,  32-bit and 64-bit (I got them all 
installed here).  Fails on databases inALL versions

4.  My first hint that something was wrong:  I tried to do an insert into a 
table and got an error message I'd never seen, about not having privileges with 
owner password NONE.  None of my databases have an owner password.  I did an 
autochk and a reload of that database and the error message went away and I 
could insert.  However, it is one of the databases where reports do not work.


Anyone having this happening to them?  Can someone think of a Windows setting 
that would affect this?

Should I revert to the previous windows 10 build, and if so how do I do that?  
A restore point?

And then I guess I research how to stop windows 10 from updating..

Thank you Microsoft

Karen



-- 
You received this message because 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.



-- 
You received this message because you are subscribed to the Google 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.

[RBASE-L] - Problem with Windows 10 update and my RB reports

[karentellef via RBASE-L]

This morning my laptop insisted on installing a really long Windows 10 update 
that I'd been putting off for probably a week.

This is on my personal development machine, not on a network.

And now my RBase reports are screwed up.  I can bring reports up in the 
designer, but both preview and printing from the R> prompt shows a blank page.  
Sometimes doing the preview locks RBase up.

Here's what I tested:

1.  I picked multiple local databases, they all behaved the same way.  All the 
databases are ones I use regularly, they all worked fine the last time I 
accessed before today.

2.  I would pick a table that has lots of data and multiple reports.  Some 
reports will print fine, some do not.  Cannot find a pattern.

3.  It happens on version 9.5, version X,  32-bit and 64-bit (I got them all 
installed here).  Fails on databases in ALL versions

4.  My first hint that something was wrong:  I tried to do an insert into a 
table and got an error message I'd never seen, about not having privileges with 
owner password NONE.  None of my databases have an owner password.  I did an 
autochk and a reload of that database and the error message went away and I 
could insert.  However, it is one of the databases where reports do not work.


Anyone having this happening to them?  Can someone think of a Windows setting 
that would affect this?

Should I revert to the previous windows 10 build, and if so how do I do that?  
A restore point?

And then I guess I research how to stop windows 10 from updating..

Thank you Microsoft

Karen


-- 
You received this message because you are subscribed to the Google 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] - Problem with a Select Distinct Statement

[karentellef via RBASE-L]

Is the "dbo" required?  I'm starting a project connecting to SQL Server, and 
we're not doing that

Karen

 

 

 

-Original Message-
From: Paul C. Buckley 
To: rbase-l 
Sent: Thu, Aug 3, 2017 10:55 am
Subject: RE: [RBASE-L] - Problem with a Select Distinct Statement



Buddy,
 
That didn’t work either, I still get the “Database dbo not connected” error.
 
Paul 
 

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Buddy Walker
Sent: August 03, 2017 11:05 AM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - Problem with a Select Distinct Statement

 
Paul
  Since there is a dot in the column name try using the IDQUOTES around the 
column name
 
Buddy
 
 

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Paul C. Buckley
Sent: Thursday, August 3, 2017 10:41 AM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - Problem with a Select Distinct Statement

 
Good morning,
 
I'm running the latest build of R:BASE X Enterprise. I have a connection to a 
SQL database & about 6 or 8 SQL tables attached. I'm trying to create a SQL 
Select Distinct statement and can't get the syntax correct. Here's what I've 
tried:
 
SELECT DISTINCT dbo.sales_rep.id AS rep_id, sales_rep.NAME-ALIAS from 
dbo.SALES_REP
 
Error is:
 

 
 
SELECT DISTINCT sales_rep.id AS rep_id from dbo.SALES_REP
 
Error is:
 

 
But this works without error: SELECT * from dbo.SALES_REP
 
Any blues clues?
 
Thanks,
Paul Buckley
 
 
-- 
You received this message because you are subscribed to the Google 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.

-- 
You received this message because you are subscribed to the Google 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.

Re: [RBASE-L] - DB corruption

[karentellef via RBASE-L]

Great news, Jim!  When you have time, would you mind giving us more details
just so we know the kinds of things to look for?  Like, were they patching when
users had the database connected, was the server rebooting, etc.  Just some
details as to why their patches were affecting your database.

Karen

 

 

 

-Original Message-
From: Jim Belisle 
To: rbase-l 
Sent: Wed, Jul 26, 2017 5:39 am
Subject: [RBASE-L] - DB corruption



I want to thank all of those who tried to help with the corruption problem.
It turns out our “wonderful” outside IT company was the problem.
They were doing server patches at 6:00 each morning causing the corruption.
The ideas you sent I am saving, and it may be I can tweak the form to be better.
 
James Belisle
 
Making Information Systems People Friendly Since 1990

 

-- 
You received this message because you are subscribed to the Google 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.

Re: [RBASE-L] - Easily creating multiple R:BASE ODBC registry entries

[karentellef via RBASE-L]

Do you have an example of the code?  This is a simple statement to connect to 
another RBase database.  

SCONNECT ';driver=Oterro X Enterprise Database Driver (*.RX1);dbq=x:\freight'

The last example I had of an Acce$$ command was this, but it's old:

SCONNECT';driver=Microsoft Access Driver (*.mdb);dbq=T:\consult.mdb'

And yeah, just create variables and concatenate into the sconnect string and 
then do an   to run the statement.

Karen

 

 

 

-Original Message-
From: mike.ramsour 
To: rbase-l 
Sent: Tue, Jul 25, 2017 1:09 pm
Subject: Re: [RBASE-L] - Easily creating multiple R:BASE ODBC registry entries


Thank you, Razzak, and others that responded. I will pursue the DSN-less route.

I have used this technique when havingto connect to mulitple Acce$$ databases.  
It was neat bit of code.

I'm thinking the DSN-less method lendsitself to creating a command file that 
uses passed parameters.

I'm going to go have some fun.  Mightlose a sock or two in the process  :-)

Have a wonderful afternoon everyone!


Mike Ramsour
AK Steel Coshocton Works
Quality Department
Phone:  740-829-4340
Cell:  740-502-1659



From:   "A. Razzak Memon"
To:   rbase-l@googlegroups.com,
Date:   07/25/2017 01:55 PM
Subject:   Re: [RBASE-L]- Easily creating multiple R:BASE ODBC registry  
entries
Sent by:   rbase-l@googlegroups.com




Mike,

Did you know that you can achieve your goal by using the DSN-Less 
connection(s)?

For complete details and examples, take a close look at the technical 
articles on From The Edge ...

 From The Edge: http://www.razzak.com/fte/

Article Title:

01. Using SQL Data Sources in R:BASE X and R:BASE X Enterprise 
(Version 10) 06/06/2017

02. Using DSN-Less Connections in R:BASE X Enterprise (Version 10) 05/10/2016

Have fun!

Very Best R:egards,

Razzak

At 01:17 PM 7/25/2017, mike.rams...@aksteel.com wrote:

>I'm about to make the upgrade to R:BASE X Enterprise and need to 
>create a couple of dozen ODBC data sources using the ODBC driver for
>R:BASE X Enterprise.
>
>Essentially the question is what's the easiest way to do 
>this?  Having to manually create that many new entries will be
>pretty time-consuming.
>
>Can this be done with a script?

-- 
You received this message because you are subscribed to the Google 
Groups"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, sendan email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Confidentiality Notice
This message is intended exclusively for the individual or entity to which it 
is addressed and may contain privileged, proprietary, or otherwise private 
information.  
If you are not the named addressee, you are not authorized to read, print, 
retain, copy or disseminate this message or any part of it.  If you have 
received this message in error, please notify the sender immediately by e-mail 
and delete all copies of the message.

-- 
You received this message because you are subscribed to the Google 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.

Re: Re[2]: [RBASE-L] - Lookup List view and ... speed

[karentellef via RBASE-L]

Love ya, Bruce!   I look at a 2 hr doctor waiting room time as a wonderful way 
to chill and catch up with my favorite book (which is always with me)

Karen

 

 

 

-Original Message-
From: Bruce Chitiea <rby...@safesectors.com>
To: rbase-l <rbase-l@googlegroups.com>
Sent: Fri, Jul 14, 2017 2:27 pm
Subject: Re[2]: [RBASE-L] - Lookup List view and ... speed



Karen:


Then, what's not to love about credit card security chips? I use my time in the 
lengthening checkout lines for zen meditation. Calming. Centering. Living in 
the moment.


Om,


Bruce


-- Original Message --
Sent: 7/14/2017 6:09:49 AM
Subject: Re: [RBASE-L] - Lookup List view and scroll bars
From: "karentellef via RBASE-L" <rbase-l@googlegroups.com>
To: rbase-l@googlegroups.com
Cc: 


I swear, I think 90% of "problems" would be solved if users weren't so damn 
fast!   ...

-- 
You received this message because you are subscribed to the Google 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.

Re: [RBASE-L] - Lookup List view and scroll bars

[karentellef via RBASE-L]

I swear, I think 90% of "problems" would be solved if users weren't so damn 
fast!   Sometimes you sit and watch these people and you see them leaning on 
the [enter] key like it was a hot dog eating contest, the more the faster the 
better.  Sometimes it is worthwhile to design things that force the user to 
pause and think, to do an extra keystroke so they are deliberate in what they 
do.  No more of this "how did I get here?"

Remember the old days, when everyone complained that windows was so much slower 
for data entry than DOS because in DOS you could type ahead and just fly thru 
data entry?  I for one welcomed the "slow down" because users had to pay 
attention to what they were doing!

Karen

 

 

 

-Original Message-
From: Tom Frederick <tf...@mchsi.com>
To: rbase-l <rbase-l@googlegroups.com>
Sent: Thu, Jul 13, 2017 7:09 pm
Subject: RE: [RBASE-L] - Lookup List view and scroll bars



Karen, I will check that. Users can go to any field they want on screen, in any 
order, and use any key. So far I have not gotten the ‘hey, I did not want that’ 
while using On Click. However On Click is really fast and I can hit 20 names 
quickly. Double Click works just as well, but forces you to pause slightly 
which can be a good thing. That leaves me with Option B depending on what the 
users do/say/request. Thanks for the heads up.
Tom   
 
From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com] 
Sent: Tuesday, July 11, 2017 9:01 AM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Lookup List view and scroll bars
 

Tom:  One thing to test:  sometimes moving thru a list of things
with the cursor (up/down arrows) will execute a single-click eep.
So test that in your situation.  If you think the user will move 
around with the keyboard, and you don't want a single-click eep
to execute for each row they move thru, then definitely do a 
double-click!

Karen

 

 

 

-Original Message-
From: A. Razzak Memon <raz...@rbase.com>
To: rbase-l <rbase-l@googlegroups.com>
Sent: Mon, Jul 10, 2017 11:22 am
Subject: RE: [RBASE-L] - Lookup List view and scroll bars

Tom,

Cool!

In reference to single (just click) versus Double-Click, there are 
fundamental differences.

Single (just Click) EPP will execute just by clicking once. However, 
for special and/or conditional EEP code to be executed, user will 
have to double-click. This is how you control special code.

Hope that helps!

Very Best R:egards,

Razzak


At 12:01 PM 7/10/2017, Tom Frederick wrote:

>Razzak and Jan,
>That works great. I used the On-Click EEP. I tried the Double-Click 
>EEP too. Is there a difference between On-Click and Double-Click or 
>is it just another option? This will now a regular part of all our 
>Var lookup ListViews. Thanks.
>
>Tom Frederick
>
>
>-Original Message-
>From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On 
>Behalf Of A. Razzak Memon
>Sent: Sunday, July 09, 2017 3:29 PM
>To: rbase-l@googlegroups.com
>Subject: Re: [RBASE-L] - Lookup List view and scroll bars
>
>Tom,
>
>Use the Variable Lookup ListView TOPITEM GETPROPERTY/PROPERTY to 
>remember the selected/highlighted row and the exact spot when 
>refreshing the ListView window.
>
>Here's how ...
>
>Use the following code as "On Double-Click EEP"
>
>-- Example 01
>-- On Double-Click Custom EEP
> SET VAR vTopItem TEXT = NULL
> GETPROPERTY DrivingTableListView TOPITEM vTopItem
> APPEND Customers TO tSelectedValues WHERE CustID = .vCustID
> PROPERTY DrivingTableListView REFRESHLIST 'TRUE'
> PROPERTY DrivingTableListView TOPITEM .vTopItem
> CLEAR VARIABLE vTopItem
> RETURN
>
>This will ALWAYS return the focus to the exact same highlighted row 
>in the Variable Lookup ListView where you double-clicked the last time.
>
>That's all there is to it!
>
>See attached screen shot for such a cool illustration.
>
>Feel free to reach out to me if you need that form to understand the 
>implementation of such GETPROPERTY/PROPERTY commands.
>
>Very Best R:egards,
>
>Razzak.
>
>
>At 12:47 PM 7/8/2017, Tom Frederick wrote:
>
> >Is there some way to make the scroll bar/cursor stay where I was when I
> >selected John Smith so it is easy to simply click on Tom Smith?
>
>
>
>--
>You received this message because you are subscribed to the Google 
>Groups "RBASE-L" group.
>To unsubscribe from this group and stop receiving emails from it, 
>send an email to rbase-l+unsubscr...@googlegroups.com.



-- 
You received this message because you are subscribed to the Google 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

Re: [RBASE-L] - Lookup List view and scroll bars

[karentellef via RBASE-L]

Tom:  One thing to test:  sometimes moving thru a list of things
with the cursor (up/down arrows) will execute a single-click eep.
So test that in your situation.  If you think the user will move 
around with the keyboard, and you don't want a single-click eep
to execute for each row they move thru, then definitely do a 
double-click!

Karen

 

 

 

-Original Message-
From: A. Razzak Memon 
To: rbase-l 
Sent: Mon, Jul 10, 2017 11:22 am
Subject: RE: [RBASE-L] - Lookup List view and scroll bars

Tom,

Cool!

In reference to single (just click) versus Double-Click, there are 
fundamental differences.

Single (just Click) EPP will execute just by clicking once. However, 
for special and/or conditional EEP code to be executed, user will 
have to double-click. This is how you control special code.

Hope that helps!

Very Best R:egards,

Razzak


At 12:01 PM 7/10/2017, Tom Frederick wrote:

>Razzak and Jan,
>That works great. I used the On-Click EEP. I tried the Double-Click 
>EEP too. Is there a difference between On-Click and Double-Click or 
>is it just another option? This will now a regular part of all our 
>Var lookup ListViews. Thanks.
>
>Tom Frederick
>
>
>-Original Message-
>From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On 
>Behalf Of A. Razzak Memon
>Sent: Sunday, July 09, 2017 3:29 PM
>To: rbase-l@googlegroups.com
>Subject: Re: [RBASE-L] - Lookup List view and scroll bars
>
>Tom,
>
>Use the Variable Lookup ListView TOPITEM GETPROPERTY/PROPERTY to 
>remember the selected/highlighted row and the exact spot when 
>refreshing the ListView window.
>
>Here's how ...
>
>Use the following code as "On Double-Click EEP"
>
>-- Example 01
>-- On Double-Click Custom EEP
> SET VAR vTopItem TEXT = NULL
> GETPROPERTY DrivingTableListView TOPITEM vTopItem
> APPEND Customers TO tSelectedValues WHERE CustID = .vCustID
> PROPERTY DrivingTableListView REFRESHLIST 'TRUE'
> PROPERTY DrivingTableListView TOPITEM .vTopItem
> CLEAR VARIABLE vTopItem
> RETURN
>
>This will ALWAYS return the focus to the exact same highlighted row 
>in the Variable Lookup ListView where you double-clicked the last time.
>
>That's all there is to it!
>
>See attached screen shot for such a cool illustration.
>
>Feel free to reach out to me if you need that form to understand the 
>implementation of such GETPROPERTY/PROPERTY commands.
>
>Very Best R:egards,
>
>Razzak.
>
>
>At 12:47 PM 7/8/2017, Tom Frederick wrote:
>
> >Is there some way to make the scroll bar/cursor stay where I was when I
> >selected John Smith so it is easy to simply click on Tom Smith?
>
>
>
>--
>You received this message because you are subscribed to the Google 
>Groups "RBASE-L" group.
>To unsubscribe from this group and stop receiving emails from it, 
>send an email to rbase-l+unsubscr...@googlegroups.com.



-- 
You received this message because you are subscribed to the Google 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.

Re: [RBASE-L] - Re: Embedding PDF in a report

[karentellef via RBASE-L]

Yeah that's one of the links that I had for the download.   From some of the 
help comments, it seems you have to download the 32-bit version even if you're 
running 64-bit because IM expects gswin32c.exe, not the 64c...

Good to know it's a common routine.  I'll ask them if they wouldn't mind 
installing at their workstations if it isn't there

Karen

 

 

 

-Original Message-
From: Dan Goldberg <d...@lancecamper.com>
To: rbase-l <rbase-l@googlegroups.com>
Sent: Wed, Jun 21, 2017 10:42 am
Subject: RE: [RBASE-L] - Re: Embedding PDF in a report



Ghostscript is an open source library that many of the free pdf creators use to 
convert to pdfs. It is included in pdfcreator, in which I use.
 
You can download the most current version on their website.
 
https://www.ghostscript.com/download/gsdnld.html
 
Maybe there is a way to run it without installing it.
 
Dan Goldberg
 
From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com]
Sent: Wednesday, June 21, 2017 8:27 AM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - Re: Embedding PDF in a report
 
Remember I asked for recommendations of programs that would automatically 
convert a PDF to a JPG.
Several people recommended ImageMagick, which I downloaded and successfully got 
it to do things like convert JPG to PNG, etc.

However, in order for it to convert a PDF to any other format, it relies on 
there being a programgswin32c.exe, which their help forum says is "Ghost 
Script".  Apparently newer computers (including my win10) do not have this 
program.  There was a link to download it, website dating back to 2006, and it 
speaks to working thru Win XP.

I'm reluctant to download it, and I'm guessing that all my users also wouldn't 
have this program so it'd be more work for them to install at every workstation.

Can anyone enlighten me about this program and if it's okay to install?

Karen

 


 


 

-- 
You received this message because 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.

-- 
You received this message because you are subscribed to the Google 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.

[RBASE-L] - Re: Embedding PDF in a report

[karentellef via RBASE-L]

Remember I asked for recommendations of programs that would automatically 
convert a PDF to a JPG.
Several people recommended ImageMagick, which I downloaded and successfully got 
it to do things like convert JPG to PNG, etc.

However, in order for it to convert a PDF to any other format, it relies on 
there being a program gswin32c.exe, which their help forum says is "Ghost 
Script".  Apparently newer computers (including my win10) do not have this 
program.  There was a link to download it, website dating back to 2006, and it 
speaks to working thru Win XP.

I'm reluctant to download it, and I'm guessing that all my users also wouldn't 
have this program so it'd be more work for them to install at every workstation.

Can anyone enlighten me about this program and if it's okay to install?

Karen

 


 

 

-- 
You received this message because you are subscribed to the Google 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] - Embedding PDF in a report

[karentellef via RBASE-L]

Multiple recommendations of ImageMagick, so I'll give that one a whirl!  Thanks!

How would you normally run it from within RBase?  Dynamically write a batch 
file with the convert command and launch the bat file?


Karen

 

 

 

-Original Message-
From: Javier Valencia <javier.valen...@vtgonline.com>
To: rbase-l <rbase-l@googlegroups.com>
Sent: Thu, Jun 15, 2017 3:49 pm
Subject: RE: [RBASE-L] - Embedding PDF in a report



You can try ImageMagick…
http://www.imagemagick.org/script/index.php
 
to convert just run the command:
 
convert file.pdf file.jpg
 
and it should do it.
 
Javier,
 
Javier Valencia, PE
14315 S. Twilight Ln.
Olathe, KS 66062
Home: 913-397-9605
Office: 913-829-0888
Cell: 913-915-3137
 
From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com] 
Sent: Thursday, June 15, 2017 3:24 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Embedding PDF in a report
 
No, I don't want to go non-automated.  These will be shop guys at a shared 
computer printing out shop orders, so they want to press a button in RBase and 
have the PDF print on the backside of the shop order report.  

I might have to get someone there to perhaps create jpgs of the current PDFs 
and from now on scan into both formats

Karen

 

 

 

-Original Message-
From: Javier Valencia <javier.valen...@vtgonline.com>
To: rbase-l <rbase-l@googlegroups.com>
Sent: Thu, Jun 15, 2017 3:20 pm
Subject: RE: [RBASE-L] - Embedding PDF in a report


Karen,

If you want a non-automated process, you can always use the Windows Sniping 
tool. Simply start the tool, select the area you want copied and then save the 
image as a JPG file. Pretty simple, I use it all the time to capture partial 
screen images.

You can find the snipping tool under All Programs>>Accessories and then you can 
pin it permanently to the task bar.

 



 

 

Javier,

 

Javier Valencia, PE

O: 913-829-0888

H: 913-397-9605

C: 913-915-3137

 

From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com] 
Sent: Thursday, June 15, 2017 12:49 PM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - Embedding PDF in a report

 

Unless something has changed lately, I know you cannot place a
PDF inside an RBase report, like you can a JPG.  (I don't want a link,
I want the actual one-page PDF)

My notes say that the solution is to convert the PDF to a JPG, but
I have no examples or recommendations of programs. Has anyone
used a free, easy to install program to convert a PDF to a JPG?
I am going to want to have RBase do the conversion "on the fly"
when a report is requested with no intervention from the user.  

I am going to design a report with data info on the 1st page and the 
PDF file printed as the second page, duplexed.  That's why I can't just
print the PDF directly, following the report.

Everyone has a full version of Adobe on their computers, so if there's
a way to automatically launch Adobe with a conversion parameter
that'd be great.

Thanks for any help!

Karen

-- 
You received this message because you are subscribed to the Google 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.


-- 
You received this message because you are subscribed to the Google 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.


-- 
You received this message because you are subscribed to the Google 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] - Embedding PDF in a report

[karentellef via RBASE-L]

No, I don't want to go non-automated.  These will be shop guys at a shared 
computer printing out shop orders, so they want to press a button in RBase and 
have the PDF print on the backside of the shop order report.  

I might have to get someone there to perhaps create jpgs of the current PDFs 
and from now on scan into both formats

Karen

 

 

 

-Original Message-
From: Javier Valencia <javier.valen...@vtgonline.com>
To: rbase-l <rbase-l@googlegroups.com>
Sent: Thu, Jun 15, 2017 3:20 pm
Subject: RE: [RBASE-L] - Embedding PDF in a report



Karen,
If you want a non-automated process, you can always use the Windows Sniping 
tool. Simply start the tool, select the area you want copied and then save the 
image as a JPG file. Pretty simple, I use it all the time to capture partial 
screen images.
You can find the snipping tool under All Programs>>Accessories and then you can 
pin it permanently to the task bar.
 

 
 
Javier,
 
Javier Valencia, PE
O: 913-829-0888
H: 913-397-9605
C: 913-915-3137
 
From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com] 
Sent: Thursday, June 15, 2017 12:49 PM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - Embedding PDF in a report
 
Unless something has changed lately, I know you cannot place a
PDF inside an RBase report, like you can a JPG.  (I don't want a link,
I want the actual one-page PDF)

My notes say that the solution is to convert the PDF to a JPG, but
I have no examples or recommendations of programs. Has anyone
used a free, easy to install program to convert a PDF to a JPG?
I am going to want to have RBase do the conversion "on the fly"
when a report is requested with no intervention from the user.  

I am going to design a report with data info on the 1st page and the 
PDF file printed as the second page, duplexed.  That's why I can't just
print the PDF directly, following the report.

Everyone has a full version of Adobe on their computers, so if there's
a way to automatically launch Adobe with a conversion parameter
that'd be great.

Thanks for any help!

Karen
-- 
You received this message because you are subscribed to the Google 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.


-- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[RBASE-L] - Embedding PDF in a report

[karentellef via RBASE-L]

Unless something has changed lately, I know you cannot place a
PDF inside an RBase report, like you can a JPG.  (I don't want a link,
I want the actual one-page PDF)

My notes say that the solution is to convert the PDF to a JPG, but
I have no examples or recommendations of programs. Has anyone
used a free, easy to install program to convert a PDF to a JPG?
I am going to want to have RBase do the conversion "on the fly"
when a report is requested with no intervention from the user.  

I am going to design a report with data info on the 1st page and the 
PDF file printed as the second page, duplexed.  That's why I can't just
print the PDF directly, following the report.

Everyone has a full version of Adobe on their computers, so if there's
a way to automatically launch Adobe with a conversion parameter
that'd be great.

Thanks for any help!

Karen

-- 
You received this message because you are subscribed to the Google 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] - Password error

[karentellef via RBASE-L]

I've never had a database with an owner PW so I don't know much
about them.  But when I unload schema for my personal consulting 
database it says:
 CREATE SCHEMA AUTHOR CONSULT PUBLIC

I'm not sure why mine says 'PUBLIC" rather than "NONE".  I do not
have any privileges granted.  Can you try changing it to Public and 
see if that sticks?

And I'm curious myself:  what does the word "AUTHOR" mean?  Is
that always there, or does it mean something?

Karen



 

 

 

-Original Message-
From: Alastair Burr 
To: R:Base Listserver 2016 
Sent: Thu, Jun 15, 2017 5:42 am
Subject: Fwd: Re: [RBASE-L] - Password error


For some reason this went direct to Mike rather than the list.



 Forwarded Message 

Subject: 
Re: [RBASE-L] - Password error

Date: 
Wed, 14 Jun 2017 17:02:25 +0100

From: 
Alastair Burr 

Reply-To: 
adbb...@outlook.com

To: 
mike.rams...@aksteel.com



I have the exact same problem - mentioned here a good few months back.

I can give you the solution but I cannot get rid of the problem - it keeps 
coming back.

The solution is that the "null" or non-existent password gets sets to "none" 
for no obvious reason.

If you type in the password as "none" you will get in as normal.

If you unload to a file and edit it you will see it in the Create Schema 
command. I've edited it endlessly butit still comes back. Igave up and cut my 
loses and now just enter "none" - I can't waste more time on it. It's just one 
database; my other four are fine.

For what it's worth, I loop through and autochk, copy (reload) to a new 
folderas well in my back-ups in case that's relevant somehow.

Good luck,
Regards,
Alastair.



On 14/06/2017 15:47, mike.rams...@aksteel.com wrote:

Good day: 

I have a daily backup routine that loops through about 20 databases.  The 
program connects to a database, AUTOCHKs it and then copies it to a backup 
folder.

There is one database that generates the following error when the program 
attempts to connect to it:  -ERROR- The current password is not correct for 
this user identifier. (2867)

The owner of the database is set to public and there has never been a password 
associated with the database.

Entering a bogus password or clicking through it generates this message: 
-ERROR- Incorrect password.  User identifier has been changed to PUBLIC. (2870)

After which the database gets backed up. 

I cannot find anything that would indicate why this is happening to this one 
particular database.  I've checked it, I've rebuilt it and still I get the 
message.

Using eXtreme 9.5, I would appreciate some suggestions or insight into why this 
happens or what I can look for.

Thanks for any help. 



Mike Ramsour 
AK Steel Coshocton Works 
Quality Department 
Phone:  740-829-4340 
Cell:  740-502-1659 
Confidentiality Notice
This message is intended exclusively for the individual or entity to which it 
is addressed and may contain privileged, proprietary, or otherwise private 
information.
If you are not the named addressee, you are not authorized to read, print, 
retain, copy or disseminate this message or any part of it. If you have 
received this message in error, please notify the sender immediately by e-mail 
and delete all copies of the message.
-- 
You received this message because 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.




-- 
You received this message because you are subscribed to the Google 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.

Re: [RBASE-L] - Strange printing problem

[karentellef via RBASE-L]

Jim:  I saved this syntax to send PDFs to the printer, so you could form them 
first and then send.  The problem with this is that you would need to know the 
location of Adobe



LAUNCH 'C:\Program Files\Adobe\Acrobat5.0\Reader\AcroRd32.exe|/p /h C:\Cust.pdf'
 

Karen


 

 

-Original Message-
From: Javier Valencia 
To: rbase-l 
Sent: Wed, Jun 14, 2017 2:32 pm
Subject: RE: [RBASE-L] - Strange printing problem



Jim,
 
If you are sending files directly to the printer, you have to consider the 
interaction between the program generating the file and the spooler; however, 
if the PDF file or files is or are created first and then you want to print 
hard copies (or e-mail them) then the Windows printer spooler (or e-mail 
application spooler) takes over it and you don’t have to worry about conflicts. 
In any case, you generate the file just once and then you use it or re-use it 
as needed. Makes sense?
 

Javier,
 
Javier Valencia, PE
14315 S. Twilight Ln.
Olathe, KS 66062
Home: 913-397-9605
Office: 913-829-0888
Cell: 913-915-3137

 

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Jim Belisle
Sent: Tuesday, June 13, 2017 7:06 PM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - Strange printing problem

 
I am trying to implement the some of the suggestions from the list to care for 
this problem that popped up again.
I am looking at your suggestion and you say, “An option would be to create the 
PDF file first and then print it (let Windows worry about it), this way you 
generate the report only once”
What do you mean “let Windows worry about it”? 
Are you suggesting that I print all the pdf files in the loop then outside the 
loop print the pdf files?
 
This code creates the pdf, then prints them for a physical copy, Code not shown 
then emails the pdfs to specific customers.
In your suggestion, how or when would I print the PDFs. My code at present sets 
OPEN OFF (for the pdfs).  
 

James Belisle
 
Making Information Systems People Friendly Since 1990


 

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Javier Valencia
Sent: Wednesday, May 17, 2017 12:15 PM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - Strange printing problem

 
Jim,
 
In addition to the other suggestions you might also look at the disk and see if 
it getting too full or the specific directory has too many files. I seem to 
recall that when you have too many files in one directory problems like this 
happen. I have an application that stores PDF files and we create 
subdirectories on the fly with the year as the name to limit the number of PDF 
files stored. You can probably create year-month subdirectories as needed.
Also, I see that you generate the report twice, once to print and once to store 
as a PDF file. If the reports are long and complicated it could take a long 
time and hold up the spooler. An option would be to create the PDF file first 
and then print it (let Windows worry about it), this way you generate the 
report only once and it might be easier on the temporary resources/memory use 
by the application.
 

Javier,
 
Javier Valencia, PE
O: 913-829-0888
H: 913-397-9605
C: 913-915-3137

 

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Jim Belisle
Sent: Wednesday, May 17, 2017 11:04 AM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - Strange printing problem

 
Thanks for the suggestions.
We seldom have more than 75 invoices so I doubt that s a problem.
I do have the variables created outside the loop.
Creating the cursor on both Control# and the Invoice# I have not done so that 
may be a start.
 

James Belisle
 
Making Information Systems People Friendly Since 1990


 

From: 'James Bentley' via RBASE-L [mailto:rbase-l@googlegroups.com] 
Sent: Wednesday, May 17, 2017 10:45 AM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Strange printing problem

 

Jim,

The following statement from your code may be in error

"  |AUTHORIZATION Accounts Receivable +"

Should it be " |AUTHOR Accounts Receivable +"

 

Also, expanding on Buddy's suggestion you should consider incorporating

creating the pdf file name as part of the DECLARE CURSOR statement

 

DECLARE c1 CURSOR FOR SELECT control#,invoice#,('PDFinvcust\'+invoice#+'.PDF') 
+ 

FROM tinvcust ORDER BY control#

 

FETCH c1 INTO vord INDICATOR ivord,vinv INDICATOR ivinv, vfilename INDICATOR 
ivFN

 

remove Following statement from WHILE loop:


" SET VAR vfilename = ('PDFinvcust\'+.vinv+'.PDF')"

 

I am assuming the column "invoice#" is a TEXT value.

Buddy assumed it was an INTEGER.

 

Make sure that all variables are defined before the WHILE loop

including the indicator variables.

 

This should speed up the loop. The loop could be further optimized

by precalculating the number of rows in the table and using the count to 

build the loop

 


Jim Bentley, American Celiac Society 

Re: [RBASE-L] - make a hyperlink in reports

[karentellef via RBASE-L]

I just tested here with latest version X.  I put the code on the "report 
actions - before generate", not the detail band before generate.  Worked for 
me.  Clicking on it asked if I trusted the site, if I said yes it went to the 
site

Karen

 

 

 

-Original Message-
From: Dan Goldberg <d...@lancecamper.com>
To: rbase-l <rbase-l@googlegroups.com>
Sent: Mon, Jun 5, 2017 4:49 pm
Subject: RE: [RBASE-L] - make a hyperlink in reports



Thx Karen. Just moved it to before generate and still not working. Think maybe 
the property URL is not live or a different name? Could not find it in the 
RDocs.
 
Dan Goldberg
 
From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com]
Sent: Monday, June 5, 2017 2:46 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - make a hyperlink in reports
 
My notes say to put the PROPERTY command on the "beforegenerate eep".  Don't 
think I've ever done this so I'm not speaking from experience

Karen

 

 

 

-Original Message-
From: Dan Goldberg <d...@lancecamper.com>
To: rbase-l <rbase-l@googlegroups.com>
Sent: Mon, Jun 5, 2017 4:40 pm
Subject: [RBASE-L] - make a hyperlink in reports


I am creating a pdf report to have our dealers update the customers email 
addresses on our website. So each line will have a unique hyperlink.

 



I want to have label that says “Update” which will be a unique hyperlink for 
each line item.

 

 

I have created a variable

 

TEXT   : D : vuplink = 
('http://dealer.lancecamper.com/warranty/warranty_email.php?serial=' + 
(ctxt(serial))) 

 

I found the URL property for the text label. So I put this in the after 
generate eep for the details

 

PROPERTY cuplink URL .vuplink

RETURN

 

But when I create the pdf the links are not created.

 

If I put the variable label in the details without the url property it works 
fine.

 

Has anybody been able to put the URL from a variable on a text label in a 
report?

 

TIA

 

Dan Goldberg

--
You received this message because 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.


-- 
You received this message because 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.

-- 
You received this message because you are subscribed to the Google 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.

Re: [RBASE-L] - make a hyperlink in reports

[karentellef via RBASE-L]

My notes say to put the PROPERTY command on the "before generate eep".  Don't 
think I've ever done this so I'm not speaking from experience

Karen


 

 

 

-Original Message-
From: Dan Goldberg 
To: rbase-l 
Sent: Mon, Jun 5, 2017 4:40 pm
Subject: [RBASE-L] - make a hyperlink in reports



I am creating a pdf report to have our dealers update the customers email 
addresses on our website. So each line will have a unique hyperlink.
 

I want to have label that says “Update” which will be a unique hyperlink for 
each line item.
 
 
I have created a variable
 
TEXT   : D : vuplink = 
('http://dealer.lancecamper.com/warranty/warranty_email.php?serial=' + 
(ctxt(serial)))
 
I found the URL property for the text label. So I put this in the after 
generate eep for the details
 
PROPERTY cuplink URL .vuplink
RETURN
 
But when I create the pdf the links are not created.
 
If I put the variable label in the details without the url property it works 
fine.
 
Has anybody been able to put the URL from a variable on a text label in a 
report?
 
TIA
 
Dan Goldberg

-- 
You received this message because you are subscribed to the Google 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.

Re: [RBASE-L] - Pagelock (corrected text)

[karentellef via RBASE-L]

Thanks, Dan.  I'd have to say that this particular app usually does not update 
"a row at a time", other than when the user is in an edit form.  I'd say almost 
all of the routines would be updating multiple rows based on some kind of 
"where" clause.  Can't say whether it would be updating 10 rows or 1000 rows, 
the description below says to use On when "affecting many rows in a table" 
which would be a subjective matter.  Obviously I'm trying to speed up multi-row 
table updates, not a single-row update, so it looks like Pagelock should be 
kept On.   My guess would be that 90% of the app updates multiple rows, so 
probably no reason to change from the default On.

Karen

 

 

 

-Original Message-
From: Dan Goldberg <d...@lancecamper.com>
To: rbase-l <rbase-l@googlegroups.com>
Sent: Tue, May 30, 2017 5:25 pm
Subject: RE: [RBASE-L] - Pagelock (corrected text)



I run with both pagelock and rowlock on. I tried turning off pagelock once and 
my users complained it was slow on updating data. I haven’t got time to do the 
switching per commands.
 
My commands mostly has many update and deletes many rows at a time. Now you can 
turn it on or off at any time. So you can leave it off and when you have an 
update or delete command that affects more than one row then you can turn it on 
and then off after.
 
Razzak had a good article explaining when you would turn on or off the pagelock.
 
http://www.razzak.com/fte/pdf/TipoftheDayDigest_2016.pdf
 
The settings for PAGELOCK are:
 
ON - R:BASE uses page locking or row locking as appropriate. When PAGELOCK is 
ON and two or more users are updating rows within the same page of data, R:BASE 
only lets the first user update rows--the other users are locked out until the 
first user's update has been completed. 
 
OFF - R:BASE uses a fast row-locking method where only row locking is applied 
with no page locking. When PAGELOCK is OFF, you can lock rows of data instead 
of locking a page of data. You increase multiuser performance when PAGELOCK is 
OFF. And even more so when STATICDB and FASTLOCK are on. 
 
If you know that your application mainly updates or deletes data a row at a 
time, rather than many rows, set PAGELOCK to OFF for row locking. In this case, 
R:BASE locks a row, reads the row, makes the change, and then releases the row. 
Otherwise, set PAGELOCK ON for page locking when you are doing an UPDATE and/or 
DELETE affecting many rows in a table.
Keep in mind that the PAGELOCK setting can be changed dynamically and can be 
different for different users using the same database.


Dan
 
From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com]
Sent: Tuesday, May 30, 2017 3:09 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Pagelock (corrected text)
 
Ooops, got one word wrong

 

 

 

I'm wrestling with the decision of whether to use PAGELOCK OFF in one of my

bigger X Enterprise databases.  Looking at all the "help" documents it seems
like the only reason you would want pagelock On (the default) is if you are
updating all the rows in a table, with no "where" clause.  As in this help 
example:

-- The UPDATE must alter the values for many rows

  SET PAGELOCK ON --use page locking 

UPDATE  SET  = value  --no WHERE Clause

SET PAGELOCK OFF --use row locking 



So, if I have heavily-used tables with millions of rows and never update without
some kind of Where clause, and if the only tables where I might update all rows
would be smaller tables, there's no reason to keep the default Pagelock On
is there?   And I"m guessing that no one knows if there's a threshold where you
would want to set it back to On, say if you used a where clause that would 
update
a couple hundred or thousands of records?  Or is Pagelock On ignored if there's
any kind of where clause?

I've never changed the default Rowlocks On setting, so I'm good there.

Opinions?  Anyone who's recently changed from On to Off and noticed a 
difference?

Thanks everyone!

Karen



--
You received this message because 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.


-- 
You received this message because 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.

-- 
You received this message because you are subscribed to the Google 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 

Re: [RBASE-L] - Pagelock (corrected text)

[karentellef via RBASE-L]

Ooops, got one word wrong 

 

 



I'm wrestling with the decision of whether to use PAGELOCK OFF in one of my

bigger X Enterprise databases.  Looking at all the "help" documents it seems
like the only reason you would want pagelock On (the default) is if you are
updating all the rows in a table, with no "where" clause.  As in this help 
example:


-- The UPDATE must alter the values for many rows
   SET PAGELOCK ON -- use page locking 
UPDATE  SET  = value  -- no WHERE Clause
SET PAGELOCK OFF -- use row locking 


So, if I have heavily-used tables with millions of rows and never update without
some kind of Where clause, and if the only tables where I might update all rows
would be smaller tables, there's no reason to keep the default Pagelock On
is there?   And I"m guessing that no one knows if there's a threshold where you
would want to set it back to On, say if you used a where clause that would 
update
a couple hundred or thousands of records?  Or is Pagelock On ignored if there's
any kind of where clause?

I've never changed the default Rowlocks On setting, so I'm good there.

Opinions?  Anyone who's recently changed from On to Off and noticed a 
difference?

Thanks everyone!

Karen




-- 
You received this message because you are subscribed to the Google 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.

[RBASE-L] - Pagelock

[karentellef via RBASE-L]

I'm wrestling with the decision of whether to use PAGELOCK OFF in one of my
bigger X Enterprise databases.  Looking at all the "help" documents it seems
like the only reason you would want pagelock On (the default) is if you are
updating all the rows in a table, with no "where" clause.  As in this help 
example:


-- The UPDATE must alter the values for many rows
   SET PAGELOCK ON -- use page locking 
UPDATE  SET  = value  -- no WHERE Clause
SET PAGELOCK OFF -- use row locking 


So, if I have heavily-used tables with millions of rows and never update without
some kind of Where clause, and if the only tables where I might update all rows
would be much  tables, there's no reason to keep the default Pagelock On
is there?   And I"m guessing that no one knows if there's a threshold where you
would want to set it back to On, say if you used a where clause that would 
update
a couple hundred or thousands of records?  Or is Pagelock On ignored if there's
any kind of where clause?

I've never changed the default Rowlocks On setting, so I'm good there.

Opinions?  Anyone who's recently changed from On to Off and noticed a 
difference?

Thanks everyone!

Karen



-- 
You received this message because you are subscribed to the Google 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] - count updates, save excel file

[karentellef via RBASE-L]

Welcome!

1.  First, if you SET FEEDBACK ON, then after your insert/update/delete you 
issue this command:
SET VAR vCount = . RBTI_RowsDeleted (inserted/updated)

 
2.  Not sure if this is what you mean, but you can include the drive in the 
gateway export filename:  gateway export xls c:\temp\importfile.xls ...


Karen


 

 

-Original Message-
From: Chaya Goldberg 
To: rbase-l 
Sent: Thu, May 25, 2017 3:12 pm
Subject: [RBASE-L] - count updates, save excel file

Hi, thanks for this list.  It’s my first time writing in.

I have two questions:

1.  Is there a way to get a count of updated records?  I have a SQL UPDATE 
statement and would like to display a message with the count of updates.  Right 
now I’m counting the fields in a temporary table – which works, but is not 100% 
accurate, in that it’s counting pending updates and not actual updates.  Is 
there a way to directly count the updates?

2.  I’m doing a gateway export into excel.  Is there a way to automatically 
save the generated excel document in a predetermined location?  

Thanks,
Chaya


Chaya Goldberg
Omni Childhood Center
(718) 998-1415  ext. 103
cgoldb...@omnirehab.com
___
Confidentiality Notice: This e-mail communication and any attachments may 
contain confidential and privileged information for the use of the designated 
recipients named above. If you are not the intended recipient, you are hereby 
notified that you have received this communication in error and that any 
review, disclosure, dissemination, distribution or copying of it or its 
contents is prohibited. If you have received this communication in error, 
please notify me immediately by replying to this message and deleting it from 
your computer.

-- 
You received this message because you are subscribed to the Google 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.

Re: [RBASE-L] - Oddity when exporting a report to Excel

[karentellef via RBASE-L]

Yes, make sure you check the horizontal alignment, because if it's off a 
fraction of a pixel, it might throw it on a new line.  Also make sure you have 
plenty of white space around your new field

Karen


 

 

 

-Original Message-
From: Tony IJntema 
To: rbase-l 
Sent: Mon, May 22, 2017 1:14 pm
Subject: RE: [RBASE-L] - Oddity when exporting a report to Excel



Do you have tried to align using one of  these: 
The middle one
 
Tony

Van: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] Namens Kayza 
Kleinman
Verzonden: maandag 22 mei 2017 19:22
Aan: rbase-l@googlegroups.com
Onderwerp: [RBASE-L] - Oddity when exporting a report to Excel

 
I have a report that has one line per row of data. Nothing special or esoteric 
about it. I need to print this report to Excel, which has worked just fine till 
I made an edit to the report. 
 
I added a field to the report. Now, every few lines (and the number of lines is 
NOT consistent!) the last field shows up on the row below.
 
What should be happening is:
 
Item1Item2Item3Item4
Item1a  Item2a  Item3a  Item4a
 
What is happening every few lines is:
Item1Item2Item3
Item4
Item1a  Item2a  Item3a  Item4a
 
This is creating some major problem.
 
R:base v 9.5
 
Thanks for any insight.
 
PS this shows up properly when I print to PDF or Word. When I print to Quattro, 
I get the blank lines, but I all of the items are on the same line.
 
 
Kayza Kleinman
Director of the Nonprofit Helpdesk 
CIO
Jewish Community Council of Greater Coney Island, Inc
3001 West 37th Street
Brooklyn NY 11224
718 449-5000 x 2266
fax 347-946-6411
www.jccgci.org
www.nphd.org
 
-- 
You received this message because you are subscribed to the Google 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.


-- 
You received this message because you are subscribed to the Google 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] - Strange printing problem

[karentellef via RBASE-L]

I'm guessing the cursor isn't processing thousands of rows, is it?  Because of 
course remember my previous post about how my cursor would hit a "critical 
mass" and crash out when it hit > 25,000 loops

Karen

 

 

 

-Original Message-
From: Jim Belisle 
To: rbase-l 
Sent: Wed, May 17, 2017 9:59 am
Subject: RE: [RBASE-L] - Strange printing problem



Whileopt is OFF (unchecked) and doing a unload reload did not show any errors 
so I do not think the DB is corrupted.
I may change the filename to include the drive to see if that will make a 
difference. It has not in the past but I am not sure where else to look.
 

James Belisle
 
Making Information Systems People Friendly Since 1990


 

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com]On Behalf Of 
Buddy Walker
Sent: Wednesday, May 17, 2017 9:13 AM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - Strange printing problem

 
Jim
  Your code looks ok but I would suggest getting the invoice# at the same time 
you are getting the control#. This would save a hit on the table. See below in 
red
  Make sure your variables are defined before the while loop
Buddy
 
SET VAR vinv INTEGER
SET VAR vord INTEGER
 
DECLARE c1 CURSOR FOR SELECT control#,invoice# FROM tinvcust ORDER BY control#
OPEN c1
FETCH c1 INTO vord INDICATOR ivord,vinv INDICATOR ivinv
WHILE SQLCODE <> 100 THEN
--  SET VAR vinv = invoice# FROM tinvcust WHERE control# = .vord
  SET VAR vfilename = ('PDFinvcust\'+.vinv+'.PDF')
  PRINT kayparkinvtemp WHERE control# = .vord OPTION PRINTER
  PRINT kayparkinvtemp WHERE control# = .vord +
  OPTION PDF +
  |FILENAME  +
  |TITLE Kay Park Recreation +
  |SUBJECT Invoice +
  |AUTHORIZATION Accounts Receivable +
  |OPEN OFF
  CLS
  FETCH c1 INTO vord INDICATOR ivord,vinv INDICATOR ivinv
ENDWHILE
DROP CURSOR c1
 
 
 

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com]On Behalf Of 
Jim Belisle
Sent: Wednesday, May 17, 2017 9:33 AM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - Strange printing problem

 
We have been using the same code within RBASE 9.5 to print our invoices to a 
printer and create a PDF for almost two years now.
Starting yesterday, while trying to print the invoices (both a report and a 
PDF), printing starts then after printing three invoices, the RBASE session 
completely shuts down.
No ERROR codes show. RBASE completely shuts down. 
 
Last night I did a reload. The user did a test run this morning having the same 
result.
I decided to run the code outside of the application in the TRACE mode and 
everything printed fine and the PDFs were created. RBASE did not shut down.
 
Does anyone have any “Blues Clues”?
Below is the code I use in a cursor.
 
SET ERROR MESSAGE 705 OFF
DROP CURSOR c1
SET ERROR MESSAGE 705 ON
DECLARE c1 CURSOR FOR SELECT control# FROM tinvcust ORDER BY control#
OPEN c1
FETCH c1 INTO vord INDICATOR ivord
WHILE SQLCODE <> 100 THEN
  SET VAR vinv = invoice# FROM tinvcust WHERE control# = .vord
  SET VAR vfilename = ('PDFinvcust\'+.vinv+'.PDF')
  PRINT kayparkinvtemp WHERE control# = .vord OPTION PRINTER
  PRINT kayparkinvtemp WHERE control# = .vord +
  OPTION PDF +
  |FILENAME  +
  |TITLE Kay Park Recreation +
  |SUBJECT Invoice +
  |AUTHORIZATION Accounts Receivable +
  |OPEN OFF
  CLS
  FETCH c1 INTO vord INDICATOR ivord
ENDWHILE
DROP CURSOR c1
 
 
 
James Belisle
 
Making Information Systems People Friendly Since 1990

 
-- 
You received this message because 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.

-- 
You received this message because you are subscribed to the Google 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.

Re: [RBASE-L] - Strange printing problem

[karentellef via RBASE-L]

Of course, when people say that tracing works we automatically want to know if 
your app sets Whileopt OFF.  If it doesn't, consider it.

Otherwise your code looks clean.  I don't construct my cursor loops that way, 
but the code looks good

Karen

 

 

 

-Original Message-
From: Jim Belisle 
To: rbase-l 
Sent: Wed, May 17, 2017 8:32 am
Subject: [RBASE-L] - Strange printing problem



We have been using the same code within RBASE 9.5 to print our invoices to a 
printer and create a PDF for almost two years now.
Starting yesterday, while trying to print the invoices (both a report and a 
PDF), printing starts then after printing three invoices, the RBASE session 
completely shuts down.
No ERROR codes show. RBASE completely shuts down. 
 
Last night I did a reload. The user did a test run this morning having the same 
result.
I decided to run the code outside of the application in the TRACE mode and 
everything printed fine and the PDFs were created. RBASE did not shut down.
 
Does anyone have any “Blues Clues”?
Below is the code I use in a cursor.
 
SET ERROR MESSAGE 705 OFF
DROP CURSOR c1
SET ERROR MESSAGE 705 ON
DECLARE c1 CURSOR FOR SELECT control# FROM tinvcust ORDER BY control#
OPEN c1
FETCH c1 INTO vord INDICATOR ivord
WHILE SQLCODE <> 100 THEN
  SET VAR vinv = invoice# FROM tinvcust WHERE control# = .vord
  SET VAR vfilename = ('PDFinvcust\'+.vinv+'.PDF')
  PRINT kayparkinvtemp WHERE control# = .vord OPTION PRINTER
  PRINT kayparkinvtemp WHERE control# = .vord +
  OPTION PDF +
  |FILENAME  +
  |TITLE Kay Park Recreation +
  |SUBJECT Invoice +
  |AUTHORIZATION Accounts Receivable +
  |OPEN OFF
  CLS
  FETCH c1 INTO vord INDICATOR ivord
ENDWHILE
DROP CURSOR c1
 
 
 
James Belisle
 
Making Information Systems People Friendly Since 1990

 

-- 
You received this message because you are subscribed to the Google 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.

Re: [RBASE-L] - Off topic - ransomware in the news

[karentellef via RBASE-L]

That's a great article, thanks!  It's funny, at the end there's a link to 
download a piece of software that will analyze your computer's risks   I'm 
reluctant to even do it!  Even tho I guess I went to that link to begin with, 
so

Karen

 

 

 

-Original Message-
From: Claudine Robbins 
To: rbase-l 
Sent: Sat, May 13, 2017 2:10 pm
Subject: [RBASE-L] - Off topic - ransomware in the news



Just wanted to share an excellent blog on the subject provided by my security 
expert.
 
https://blog.knowbe4.com/ransomware-attack-uses-nsa-0-day-exploits-to-go-on-worldwide-rampage
 
Claudine

-- 
You received this message because you are subscribed to the Google 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.

Re: [RBASE-L] - Re: Quickbooks

[karentellef via RBASE-L]

RBase wouldn't work with QODBC?

Karen

 

 

 

-Original Message-
From: J Blaustein 
To: rbase-l 
Sent: Tue, May 9, 2017 3:56 pm
Subject: Re: [RBASE-L] - Re: Quickbooks


I worked with QODBC using Access as the interface since Rbase didnot 
support it.  But due to the complexity of QBW, I only used it tochange 
prices, cost and status info.
J

On 5/9/2017 4:46 PM, Michael Byerley wrote:
  


I didn't look at the under the cover nuances of this ODBC driver
for Quickbooks, but maybe it's something..

  http://qodbc.com/

  
  
  On Thursday, May 4, 2017 at 1:17:10 PM UTC-4, karen...@cs.com 
 wrote:  
It'sbeen decades since I've had to deal with Quickbooks, and
it wasn't exactly a joy back then...

Someone just asked me about sending stuff from RBase
into Quickbooks (they do not own QB yet, so it would bea 
new version of the software).

Has anyone here used a new version of QB and let me know
if it's easier nowadays to send data to QB?  For
example, what kind of formats does it accept as animport?  Any 
gotchas?   We'd probably be sending overlists of "members" 
(name, address, etc), and differentkinds of revenues received 
(member fees, special fees,event fees)

Thanks for any insight!

Karen

  

  
  -- 
  You received this message because you are subscribed to the Google  
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.




-- 
J Blaustein
12 Herrick Drive
Lawrence, NY 11559
516-371-3445
  
-- 
You received this message because you are subscribed to the Google 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.

[RBASE-L] - Re: Quickbooks

[karentellef via RBASE-L]

Well isn't that interesting, Mike!  Here's the information page:
http://qodbc.com/qodbcOnline.htm

Here's some quotes from it.  They mention reading the data alot (which I 
wouldn't need) but one reference to being able to "write data".  I'm going to 
ignore the fact that they misuse the word "  it's  "


QODBC is an ODBC driver (DLL) for QuickBooksOnline 
Accounting format files. QuickBooks Online Accounting stores it's data in it's  
   own proprietary file format in the cloud. This driver allows users of 
any ODBC compliant front end PC application to read and write data 
contained in QuickBooks Accounting format files similarly to any other 
ODBC enabled database and the same as our product for Desktop 
QuickBooks.

 
  
QODBC works by accepting SQL commands from applications through the 
ODBC interface, then converting those calls to navigational XML 
commands to the QuickBooks Online Accounting system and returning 
record sets that qualify for the query results. This driver is not a 
Client/Server product, but rather communicates directly with the   
QuickBooks Online web site as it runs. QuickBooks Online is a flat file 
  database, and this driver will not change it into a relational
   database, so keep that in mind when developing with this driver.
  


QODBC acts as a 'wrapper' around the Intuit SDK   so customers can 
finally get at their QuickBooks Online data using   standard 
database tools; speeding development time.
 

 

 

-Original Message-
From: Michael Byerley 
To: RBASE-L 
Cc: karentellef 
Sent: Tue, May 9, 2017 3:46 pm
Subject: Re: Quickbooks





I didn't look at the under the cover nuances of this ODBC driver for 
Quickbooks, but maybe it's something..

  http://qodbc.com/



On Thursday, May 4, 2017 at 1:17:10 PM UTC-4, karen...@cs.com wrote:
It's been decades since I've had to deal with Quickbooks, and it wasn't exactly 
a joy back then...

Someone just asked me about sending stuff from RBase into Quickbooks (they do 
not own QB yet, so it would be a new version of the software).

Has anyone here used a new version of QB and let me know if it's easier 
nowadays to send data to QB?  For example, what kind of formats does it accept 
as an import?  Any gotchas?   We'd probably be sending over lists of "members" 
(name, address, etc), and different kinds of revenues received (member fees, 
special fees, event fees)

Thanks for any insight!

Karen





-- 
You received this message because you are subscribed to the Google 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] - Quickbooks

[karentellef via RBASE-L]

That's not at all what I read on QB's website.  They have SDKs for you to 
download, saying they no longer support import/export of data files, and you 
program an interface using program languages such as .Net and C++.  And that 
the days of the .IIF import files are over

Karen

 

 

 

-Original Message-
From: James W. Kim, CPA, MBA <james@kimcpa.com>
To: rbase-l <rbase-l@googlegroups.com>
Sent: Tue, May 9, 2017 2:28 pm
Subject: Re: [RBASE-L] - Quickbooks



I am not sure if following info is what you arelooking for.  
Nevertheless, these days, it's relatively easy toimport/export data 
with Quickbooks. It can import Excel or csvfile easily.  Also many 
banks provide transaction details on.qbo files just for importing into 
Quickbooks.  The .qbo appearsto be a type of XML file. Looking at the 
content of .qbo files,R:Base can be easily programmed to produce .qbo 
files from datatable. 
  

--

James 



  On 5/9/2017 2:41 PM, karentellef via RBASE-L wrote:



  
Great question
  
 
Karen
  
  
 
  
  
 
  
  
-OriginalMessage-
From: Bruce Chitiea <rby...@safesectors.com>
To: rbase-l <rbase-l@googlegroups.com>
Sent: Tue, May 9, 2017 11:54 am
Subject: Re[2]: [RBASE-L] - Quickbooks




Ok then, looking forward.




Is anyone awareof - or had any direct experience with - 
ANYaccounting system in QuickBooks' market segment  
  (Peachtree, perhaps) which hosts dead-bang,   
 SQL-compliant import/export capabilities; withor 
without resort to third-party "translators"?




Bruce Chitiea

SafeSectors, Inc.

909.238.9012 Mobile




-- Original Message --

Sent: 5/9/2017 8:47:08 AM

Subject: Re: [RBASE-L] - Quickbooks

From: "Bill Downall" <b...@downall.us>

To: rbase-l@googlegroups.com

Cc: 




  
I've built a bridge between R:BASEand QB through a 3rd 
party product calledTransaction Pro Importer out of Bay 
StateConsulting. It's been working well for years,  
  but Karen is right: when QB gets upgraded or  
  moved from desktop to cloud, the TPI product may
have to change and the R:BASE end reworked,too. 




That company's experience with trying to  move from QB 
Desktop to QB Online was a  disaster, as others have 
described. (Would  have had to archive/abandon 
historical  details, and it still took over 24 hours to 
 convert in testing.)  I've also seen a 
 non-profit I have worked with abandon efforts  
to improve their QB by moving it to QB Online.




Frank's story  -- a company spending 6  figures to 
learn that moving to XXX was not an  improvement in the 
end -- is one many people  have shared and heard over 
and over again when  R:BASE developers got together.
  
  


On Tue, May 9,          2017 at 11:31 AM, karentellef via 
RBASE-L <rbase-l@googlegroups.com>  wrote:
  
Thanks  for the two cents.   Just   
 confirms everything I've heard that QB 
   does not want to talk to otherprograms.  The 
vertical market appthey're looking at 
apparently has aseparate add-on program you can 
buy tomake the transfer, but who knows what 
   version of QB it interfaces with.
   Gonna share your

Re: Re[2]: [RBASE-L] - Quickbooks

[karentellef via RBASE-L]

Great question

 
Karen

 

 

-Original Message-
From: Bruce Chitiea <rby...@safesectors.com>
To: rbase-l <rbase-l@googlegroups.com>
Sent: Tue, May 9, 2017 11:54 am
Subject: Re[2]: [RBASE-L] - Quickbooks



Ok then, looking forward.


Is anyone aware of - or had any direct experience with - ANY accounting system 
in QuickBooks' market segment (Peachtree, perhaps) which hosts dead-bang, 
SQL-compliant import/export capabilities; with or without resort to third-party 
"translators"?


Bruce Chitiea
SafeSectors, Inc.
909.238.9012 Mobile


-- Original Message --
Sent: 5/9/2017 8:47:08 AM
Subject: Re: [RBASE-L] - Quickbooks
From: "Bill Downall" <b...@downall.us>
To: rbase-l@googlegroups.com
Cc: 



I've built a bridge between R:BASE and QB through a 3rd party product called 
Transaction Pro Importer out of Bay State Consulting. It's been working well 
for years, but Karen is right: when QB gets upgraded or moved from desktop to 
cloud, the TPI product may have to change and the R:BASE end reworked, too. 


That company's experience with trying to move from QB Desktop to QB Online was 
a disaster, as others have described. (Would have had to archive/abandon 
historical details, and it still took over 24 hours to convert in testing.)  
I've also seen a non-profit I have worked with abandon efforts to improve their 
QB by moving it to QB Online.


Frank's story  -- a company spending 6 figures to learn that moving to XXX was 
not an improvement in the end -- is one many people have shared and heard over 
and over again when R:BASE developers got together.



On Tue, May 9, 2017 at 11:31 AM, karentellef via RBASE-L 
<rbase-l@googlegroups.com> wrote:

Thanks for the two cents.   Just confirms everything I've heard that QB does 
not want to talk to other programs.  The vertical market app they're looking at 
apparently has a separate add-on program you can buy to make the transfer, but 
who knows what version of QB it interfaces with.Gonna share your post (but 
not your name) with the company.

Karen

 

 

 

-Original Message-
From: Frank Massimo <frankmass...@hotmail.com>
To: rbase-l <rbase-l@googlegroups.com>
Sent: Tue, May 9, 2017 10:21 am
Subject: Re: [RBASE-L] - Quickbooks




Karen,


One of my clients has been using R:Base from DOS through Enterprise 10 (nearly 
20 years). Their accountant felt that the AR portion of the R:Base application 
should be handled through Quickbooks (Enterprise Ver 14). They have been using 
QB as a check writer for years. I made a number of arguments against it, as 
they produce 1000-1300 invoices per day and the well-honed, specialized R:Base 
programs developed to create, track and process the ultimate payment of 
1000-1300 invoices a day was in place and working. The only thing that was 
missing was integration of AR numbers for general ledger purposes in 
Quickbooks, which I pointed out could be produced easily on demand when the 
necessary reports were required. The accountant prevailed and the debacle 
began. I wrote the necessary programs to provide overnight data which had to be 
fed to QB via Transaction Pro because the QB process of importing the data was 
too slow. On the AR side, all of the specialized functionality of the custom 
R:Base programs was lost so the AR staff had to learn (the hard way) that QB 
had pretty screens and some neat features but it took them twice as long to 
post invoices, not to mention the dozens of other glitches the import process 
encountered, the difficulty of handling incoming EDI payments, and all of the 
other oddities that R:Base let's you code around. That's the short version, but 
bottom line, I am now busily migrating the AR system back to R:Base. 


Just my two cents. Cost them six figures to come to the same conclusion, though.


Frank Massimo
Tri-State Logistics, Inc. 



From: karentellef via RBASE-L <rbase-l@googlegroups.com>
Sent: Thursday, May 4, 2017 1:17 PM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - Quickbooks
 

It's been decades since I've had to deal with Quickbooks, and it wasn't exactly 
a joy back then...

Someone just asked me about sending stuff from RBase into Quickbooks (they do 
not own QB yet, so it would be a new version of the software).

Has anyone here used a new version of QB and let me know if it's easier 
nowadays to send data to QB?  For example, what kind of formats does it accept 
as an import?  Any gotchas?   We'd probably be sending over lists of "members" 
(name, address, etc), and different kinds of revenues received (member fees, 
special fees, event fees)

Thanks for any insight!

Karen


-- 
You received this message because 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.



-- 
You rece