It is with great sadness that I read of Bob’s death. He was such a great guy
and made my trips to PA for R:BASE training & conferences so much more
enjoyable. My prayers go out to his family & friends. I will be sure to raise a
toast to this kind man over the holidays.
Rest in peace my frien
Jim,
Have you tried running RBG95_64_Default_Settings.exe from the R:BASE program
folder? This should resolve it but be warned it will reset EVERYTHING to its
defaults so if you’ve customized other settings they will disappear.
Paul Buckley
From: rbase-l@googlegroups.com [mailto:rbase
Razzak,
To answer your questions:
01 - it is a table
02 - I do have full rights to update the table
03 - I was able to successfully project a table from the SQL table.
Here's what I did figure out yesterday. I will definitely need to get the
datatype changed from nvarchar(max) so I can even see
Good afternoon,
I’m running the latest version of R:BASE X Enterprise and I’m trying to use an
Enhanced DB Grid in a form. I’ve got the grid working great and I’ve created a
variable lookup listbox to allow the user to select all the parts they would
like to see and that is working, it gives
Good morning,
I’m using the latest R:BASE X Enterprise and I’m trying to change the
background color on a column in an Enhanced DB Grid. I’m using the command:
PROPERTY enhanceddbgrid1 'COLUMNS[13]->COLOR' 'red'. I’m seeing no change in
the background color.
Suggestions?
Thanks,
Pau
l there is to it!
Have fun!
Very Best R:egards,
Razzak
At 09:48 AM 5/19/2017, Paul C. Buckley wrote:
>Good morning,
>
>I'm using the latest R:BASE X Enterprise and I'm trying to change the
>background color on a column in an Enhanced DB G
Bill,
Take a look at the Power Plugins, specifically; GetFileLockStatus.
See if that does what you need.
Paul Buckley
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of
Bill Niehaus
Sent: May 25, 2017 11:32 AM
To: rbase-l@googlegroups.com
Subject: RE:
Stephen,
Sorry for the delay in responding, I’ve been buried with projects. I have a
couple of projects I have integrated R:FTP & R:FTPS and it works flawlessly.
Worth looking into in my opinion.
Thanks,
Paul Buckley
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On
I can’t answer the password dilemma but I looked in the Help file for CREATE
SCHEMA and AUTHOR is short for AUTHORIZATION and is used to define the name of
the database. It also states if no owner name is defined it defaults to PUBLIC
which allows everyone to have full access to the database.
Good afternoon,
It must be Monday, I’m fading already and it’s only 4:00. I’m using the latest
version of R:BASE X Enterprise. I’d capturing some data from a SQL table into
an R:BASE table and I’d like to “clean it up” some before I work on it. I know
several of the columns have leading zero
you may use the UPDATE
command as follows:
UPDATE tablename SET columnname1 =
(TRIM(columnname1)), columnname2 =
(TRIM(columnname2)), columnname3 = (TRIM(columnname3))
Hope that helps!
Very Best R:egards,
Razzak
At 03:53 PM 6/19/2017, Paul C. Buckley wrote:
>Good afternoon,
>
>It must
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
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>
[mailto:rbase-l@googlegroups.com] On Behalf Of Paul C. Buckley
Sent: Thursday, August 3
: [RBASE-L] - Problem with a Select Distinct Statement
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 mailto:p...@buckleyandassoc.com> >
To: rbase-l mailt
Subject: Re: [RBASE-L] - Problem with a Select Distinct Statement
Can you alias the SQL database to eliminate the ‘.’ from the name, perhaps?
Albert
On Aug 3, 2017, at 9:55 AM, Paul C. Buckley mailto:p...@buckleyandassoc.com> > wrote:
Buddy,
That didn’t work either, I still g
Razzak,
I agree with Albert & Claudine. I contribute so much less than what I get out
of R:BASE. I only wish more software companies were as responsive to their
users as you are.
My sincere thanks to you and the Dream Team,
Paul
-Original Message-
From: rbase-l@googlegroups.com [mailto
’ from the name, perhaps?
Albert
On Aug 3, 2017, at 9:55 AM, Paul C. Buckley mailto:p...@buckleyandassoc.com> > wrote:
Buddy,
That didn’t work either, I still get the “Database dbo not connected” error.
Paul
From: <mailto:rbase-l@googlegroups.com> rbase-l
I'm starting a project connecting to SQL Server, and
we're not doing that
Karen
-Original Message-
From: Paul C. Buckley mailto:p...@buckleyandassoc.com> >
To: rbase-l mailto:rbase-l@googlegroups.com> >
Sent: Thu, Aug 3, 2017 10:55 am
Subject: RE: [RBASE-L] - Pr
connection.
Buddy
From: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>
[mailto:rbase-l@googlegroups.com] On Behalf Of Paul C. Buckley
Sent: Thursday, August 3, 2017 2:13 PM
To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>
Subject: RE: [RBASE-L] - Pr
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
bject: 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. Buckle
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 mailto:p...@buckleyandassoc.com> >
To: rbase-l mailto:rbase-l@goog
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 cl
: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>
[mailto:rbase-l@googlegroups.com] On Behalf Of
ome blue's clues ...
Very Best R:egards,
Razzak
At 08:18 AM 8/24/2017, Paul C. Buckley wrote:
>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,
>
ps.com] On Behalf Of
Paul C. Buckley
Sent: August 24, 2017 8:39 AM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - Another Enhanced DB Grid Question
Razzak,
That's it, I'll pull them out.
I appreciate the help,
Paul
-Original Message-
From: rbase-l@googlegroups
Good afternoon,
I'm running today's release of R:BASE X Enterprise and I've got a question
about enhanced db grid. I'm trying to find the "right" way to make sure if a
user changes a value in a cell the changes get saved. Right now I'm using an On
Row Exit EEP as well as in the table settings f
Good morning,
I'm running the latest release of R:BASE X Enterprise and I've got a question
about enhanced db grid. I'm trying to find the "right" way to make sure if a
user changes a value in a cell the changes get saved. Right now I'm using an On
Row Exit EEP as well as in the table settings
ase-l@googlegroups.com
Subject: Re: [RBASE-L] - Correct Way to Save Changes Made in an Enhanced DB Grid
Paul,
Did you read my reply on the same subject line on Thu, 14 Dec 2017
14:36:35 -0500?
Very Best R:egards,
Razzak
At 08:30 AM 12/18/2017, Paul C. Buckley wrote:
>Good morning,
>
>I
hancedDBGridTable 'REFRESH'
RETURN
Hope that helps!
Very Best R:egards,
Razzak
------------
At 09:20 AM 12/18/2017, Paul C. Buckley wrote:
>Razzak,
>
>I don't have a response from you
Good morning,
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 g
David,
Try moving the second Edit Using pendingjobs ... into the first form,
dispatchjobs as an On After Start EEP.
Good luck,
Paul Buckley
-Original Message-
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of
DAVID FOWLER
Sent: December 18, 2017 12:14 PM
To
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
Multi
CTEDVALUES[CustID]' 'vCSVValues'
CLS
PAUSE 2 USING .vCSVValues CAPTION 'Selected Values' ICON WINDOWS +
BUTTON 'Press any key to continue ...' +
OPTION BACK_COLOR WHITE +
|MESSAGE_FONT_NAME Tahoma +
|MESSAGE_FONT_COLOR NAVY +
|MESSAGE_FO
Good afternoon,
I’m using the latest version of R:BASE X Enterprise and I’m looking for a way
to individually change the colors of rows in an Enhanced DB Grid. I’m not
seeing anything in R:DOCS or the help file. Am I missing something or can this
not be done?
Thanks,
Paul Buckley
--
F
field to change it. I use a temp view with the color field in it.
Dan Goldberg
From: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>
[mailto:rbase-l@googlegroups.com] On Behalf Of Paul C. Buckley
Sent: Friday, December 22, 2017 12:12 PM
To: rbase-l@googlegrou
Manuel,
Look at LoadFileName & LoadFileNamePlus plugins that are included with R:BASE
and see if they give you what you need.
Good luck,
Paul Buckley
4.1.3 LoadFileName
The LoadFileName plugin is used to load a file name into a variable by
displaying a dialog window for the
user to
David,
You can do this with a lookup combo box on the form as long as the form with
the cities is part of the form.
Hope this helps,
Paul Buckley
-Original Message-
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of
dkfowler6179
Sent: January 31, 2018 5:29 PM
David,
A little more on lookup combo boxes, I don't think the table needs to be the
table the form is based on. I've done many variable forms and variable lookup
combo boxes where you choose the table to lookup from.
Paul
-Original Message-
From: rbase-l@googlegroups.com [mailto:rbase-
Good morning,
I'm running the latest version of R:BASE X Enterprise. I have form with an
enhanced DB grid and when I open the form with the edit using command I apply a
multiple column sort. I'd like to give the user a button on the form to restore
the default multi-column sort without closing
uary 09, 2018 10:26 AM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - Multi-Column Sort in Enhanced DB Grid
PROPERTY TABLE 'RestoreOrderBy'
Dan Goldberg
-Original Message-
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of
Paul C. Buckle
Good morning group,
I'm using the latest R:BASE Extreme Enterprise and I'd like to reposition the
cursor on the row I was "on" after resorting the table the DB Grid is based on.
I have a row id value I can use.
Any suggestions?
Thanks,
Paul Buckley
--
For group guidelines, visit
http://www.
o:rbase-l@googlegroups.com] On Behalf Of
Paul C. Buckley
Sent: Tuesday, February 13, 2018 8:29 AM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - Position on a Specific Row in an Enhanced DB Grid
Good morning group,
I'm using the latest R:BASE Extreme Enterprise and I'd like to reposition
Jan,
Look at LoadFileName Plus Plus. Below is a partial screen snip and it shows
both path only & filename. I use this all the time
Paul Buckley
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of
jan johansen
Sent: February 15, 2018 3:23 PM
To: rbase-l@
rs to let the data speak for itself!
Very Best R:egards,
Razzak.
www.rbase.com
www.facebook.com/rbase
--
34 years of continuous innovation!
19 Years of R:BASE Technologies, Inc. making R:BASE what it is today!
--
At 03:11 PM 12/22/2017, Paul C. Buckley wrote:
>Good afternoon,
>
>I
isn't it?
Very Best R:egards,
Razzak
At 04:29 PM 2/20/2018, Paul C. Buckley wrote:
>Razzak,
>
>I'm sorry it has taken me so long to get back to this but I've read
>thru your email and looked again in R:DOCS and can't see how to change
>the color on an in
Razzak & the Dream Team,
Thank you all so much. This is very useful and convenient.
Looking for more socks ...
Paul Buckley
-Original Message-
From: rbase-l@googlegroups.com On Behalf Of A.
Razzak Memon
Sent: March 21, 2018 8:15 AM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - Tip
Razzak,
Once again, you guys add something really cool and very useful for me.
Thanks,
Paul Buckley
-Original Message-
From: rbase-l@googlegroups.com On Behalf Of A.
Razzak Memon
Sent: March 27, 2018 8:17 AM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - Tip of the Day: DIALOG/PAUSE
Claudine,
For what it’s worth, all the examples of this that I am using do not have the
“trailing” ‘\’ on the path. For example if I check for the temp folder on the
C: drive I do something like this:
SET VAR vcheckfolderpath = 'C:\temp'
SET VAR vchkfile = (CHKFILE(.vcheckfolderpath))
I
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,
P
Good afternoon,
I’m using the latest version of R:BASE X Enterprise. I’ve got multiple SQL
tables from a SQL database sattached. I’m creating multiple views from a
combination of attached SQL tables and R:BASE tables. Each is a view linking
the previous view and another table/view or 2. The
Good afternoon,
I'm using the latest version of R:BASE X Enterprise. I'm trying to sort in a
form where there is a revision column. When it's A-Z there's no problem but
when we get into double digits AA, AB etc. I'm trying to figure out how to
determine the current revision. For example, I have
Buckley
-Original Message-
From: rbase-l@googlegroups.com On Behalf Of Albert
Berry
Sent: April 27, 2018 3:23 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Sorting Question in a Form
Does the revised whatever have a revision date as well as a revision code?
Albert
> On
David,
If you've been to a Super Advanced Training class look for a sample labeled
"Management Tools" and in there look for "Designing Ad Hoc Reports Using Query
Forms". This might give some clues on what to do with your situation. I've used
this as a template for many Ad Hoc queries for users
Razzak,
Congratulations on 20 years and whoopee for a user's conference again. I am so
excited about both.
Thanks,
Paul Buckley
-Original Message-
From: rbase-l@googlegroups.com On Behalf Of A.
Razzak Memon
Sent: May 16, 2018 3:00 PM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - A
Claudine,
Just as a test you might try this, not knowing the complexity of this form, you
might create a new form based on the same table/view and do a control-A – copy
all from the original and paste it into the new form. It won’t bring all the
form settings and any variables you may have d
56 matches
Mail list logo