RE: [RBASE-L] - Blank date value

[Paul C. Buckley]

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 defined but all the fields and 
anything on the screen will be copied. Try the new form and see what happens.

 

Just a thought. Good luck,

Paul Buckley

 

From: rbase-l@googlegroups.com  On Behalf Of Claudine 
Robbins
Sent: May 25, 2018 1:05 PM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - Blank date value

 

Furthermore, I recreated the DBEdit field on the form with no change.  However, 
I created a test form based on the same table and that date value is indeed 
NULL so that clearly points to my form.  I’ll continue playing with it and 
report my findings.  Probably something I’m unaware of doing wrong…

 

Claudine

 

From: rbase-l@googlegroups.com   
[mailto:rbase-l@googlegroups.com] On Behalf Of Claudine Robbins
Sent: Friday, May 25, 2018 11:37 AM
To: rbase-l@googlegroups.com  
Subject: RE: [RBASE-L] - Blank date value

 

Yes Karen. This is a phantom value.  All the NULL rows show this in the form 
but the table shows NULL values.  If I click on it while in the form, it 
vanishes…

 

My settings:

BLANK

DELIMIT ,

LINEEND ^

SEMI;

QUOTES  '

PLUS+

SINGLE  _

MANY%

IDQUOTES`



 

From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com] 
Sent: Friday, May 25, 2018 7:35 AM
To: rbase-l@googlegroups.com  
Subject: Re: [RBASE-L] - Blank date value

 

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.

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

RE: [RBASE-L] - Announcement - R:BASE Technologies' 20th Anniversary Conference

[Paul C. Buckley]

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] - Announcement - R:BASE Technologies' 20th Anniversary 
Conference

Wednesday, May 16, 2018 (3:00 PM Eastern Time)

Dear R:BASE Community,

I am ecstatic to finally share this news!

For the 20th Anniversary of R:BASE Technologies, Inc., we are celebrating an 
R:BASE Conference in October 2018 in Las Vegas, Nevada!

And, on Saturday, October, 20, 2018, we will be officially unveiling the 
release of R:BASE X.5/X.5 Enterprise (Version 10.5)!

All are urged to "save the date" and join us in celebrating "the 20th on the 
20th!"

Festivities will be held for this landmark occasion at the remarkable South 
Point Hotel Casino and Spa: https://southpointcasino.com

The growth we've experienced over the years is because of a superior community 
of R:BASE users, who unwaveringly support us!

Please stay tuned for more details ...
http://www.rbase.com/conference

We hope to see you all in Las Vegas!

Razzak.

A. Razzak Memon
Founder, President & CEO
R:BASE Technologies, Inc.
http://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] - User defined search

[Paul C. Buckley]

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 with no experience up to 
advanced users.

Give it a try,
Paul Buckley

-Original Message-
From: rbase-l@googlegroups.com  On Behalf Of 
dkfowler6179
Sent: May 11, 2018 2:52 PM
To: RBASE-L 
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] - Sorting Question in a Form

[Paul C. Buckley]

Albert,

No date. I thought that IHASH may be the answer but alas, no. The value 'AA' 
converts to 2145 and 'AB' converts to 2049. I'm thinking I'll have to write a 
while loop that pulls the value apart and uses ICHAR to come up with an integer 
value.

Thanks,
Paul Buckley

-Original Message-
From: rbase-l@googlegroups.com <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 Apr 27, 2018, at 12:06 PM, Paul C. Buckley <p...@buckleyandassoc.com> 
> wrote:
> 
> 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 rev W, X, Y, AA & AB I 
> was hoping to be able to sort in a way that puts the newest, AB, either on 
> the top or bottom. If that's not possible, any suggestions on how to find the 
> "newest" revision?
> 
> 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.

[RBASE-L] - General Question about Views & SQL Databases

[Paul C. Buckley]

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 performance on using the 
final eighth view is getting very sluggish. I’m wondering if it’s worth the 
effort to create a single “super view” that contains all the tables & views and 
various where clauses.

 

Any thoughts or 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.

RE: [RBASE-L] - Enhanced DBGrid Refresh

[Paul C. Buckley]

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  On Behalf Of Claudine 
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, visit  
 
http://www.rbase.com/support/usersgroup_guidelines.php

---

You received this message because you are subscribed to the Google 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.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 

RE: [RBASE-L] - CHKFILE problem

[Paul C. Buckley]

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

IF vchkfile <> 1 THEN

  SET VAR vcommand TEXT = 'MKDIR C:\temp'

  

ENDIF

 

Always seems to work for me. I’m using the latest version of R:BASE X but this 
also worked this way in 9.5.

 

Good luck,

Paul Buckley

 

From: rbase-l@googlegroups.com  On Behalf Of Claudine 
Robbins
Sent: April 04, 2018 2:27 PM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - CHKFILE problem

 

SET VAR vlscandir = (SRPL((CVAL('CURRDIR')+ '\TRAIL\' ), '\\', '\',0))

SET VAR vsscandir = ('TRAIL\')

SET VAR vChkDir INTEGER = NULL

SET VAR vChkDir = (CHKFILE(.vLScanDir))

IF vChkDir <> 1 THEN

  MKDIR 

ENDIF

 

R>sho v vlscandir

C:\IEX_X\TRAIL\

 

This sequence fails. The directory exists but  vChkDir = 0 whereas it should be 
1 and MKDIR command fails with “-ERROR - Unable to Create Directory (2269)”

 

I cannot see what’s wrong here.  I even copied RRBYW19 code.

 

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.

RE: [RBASE-L] - Tip of the Day: DIALOG/PAUSE Accelerator Character Control

[Paul C. Buckley]

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 Accelerator Character Control

Tuesday, March 27, 2018

Tip of the Day: DIALOG/PAUSE Accelerator Character Control
Product...: R:BASE X and R:BASE X Enterprise (Version 10)
Build.: 10.0.3.20320 or higher
Section...: Commands
Keywords..: DIALOG, PAUSE, Accelerator Character, Message

Did you know a new parameter was added to the DIALOG and PAUSE commands to 
control the accelerator character display within the message?

When displaying a message string which contains an ampersand for the DIALOG and 
PAUSE commands, the ampersand is treated as an accelerator character and is 
displayed as an underline. When constructing a string by concatenating 
variables and text, it is possible to add an additional "&" to fix the display. 
But, if that string is a part of a variable and text, such as customer name 
that includes "&", it must be handled accordingly.

The new MESSAGE_SHOW_ACCELERATOR_CHAR easily controls the accelerator character 
display within the message. The default is ON.

-- Example (DIALOG with accelerator character OFF)
SET VAR vYesNo TEXT = 'Yes'
SET VAR vEndKey TEXT = NULL
SET VAR vCaption TEXT = 'New Sales Order'
CLS
DIALOG +
'You have selected to process new sales order for Fenwick & Sons 
Maintenance.' +
vYesNo vEndKey Yes +
CAPTION .vCaption ICON QUESTION +
OPTION WINDOW_BACK_COLOR WHITE +
|MESSAGE_BACK_COLOR WHITE +
|MESSAGE_FONT_NAME Tahoma +
|MESSAGE_FONT_COLOR NAVY +
|MESSAGE_FONT_SIZE 12 +
|BUTTON_YES_CAPTION  +
|BUTTON_YES_COLOR WHITE +
|BUTTON_YES_FONT_COLOR GREEN +
|BUTTON_NO_CAPTION  +
|BUTTON_NO_COLOR WHITE +
|BUTTON_NO_FONT_COLOR RED +
|MESSAGE_SHOW_ACCELERATOR_CHAR OFF
IF vYesNo = 'No' OR vEndKey = '[Esc]' THEN
GOTO Done
ENDIF
CLS
ENTER USING SalesOrder
LABEL Done
CLEAR VARIABLES vYesNo,vEndKey,vCaption
RETURN

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

-- Example (PAUSE with accelerator character OFF)
CLS
PAUSE 2 USING +
'New sales order for Fenwick & Sons Maintenance processed successfully!' +
CAPTION 'New Sales Order' ICON CONFIRM +
BUTTON 'Press any key to continue ...' +
OPTION BACK_COLOR WHITE +
|MESSAGE_FONT_NAME Tahoma +
|MESSAGE_FONT_COLOR GREEN +
|MESSAGE_FONT_SIZE 11 +
|BUTTON_COLOR WHITE +
|BUTTON_FONT_COLOR GREEN +
|MESSAGE_SHOW_ACCELERATOR_CHAR OFF
RETURN

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

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] - Tip of the Day: "Center In Work Area" Form Property Setting

[Paul C. Buckley]

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 of the Day: "Center In Work Area" Form Property Setting

Wednesday, March 21, 2018

Tip of the Day: "Center In Work Area" Form Property Setting
Product...: R:BASE X and R:BASE X Enterprise (Version 10)
Build.: 10.0.3.20320 or higher
Section...: Forms
Keywords..: Setting, Form Behavior, Center in Work Area

Did you know that you can specify that a form is centered in the desktop work 
area which is not covered by the task bar?

A new form "Center In Work Area" setting, within the "New Form Behavior" tab, 
has been introduced to specify a form is centered in the area not covered by 
the task bar. The functionality allows for forms to remain centered on 
non-standard desktops (e.g. large task bars or multiple task bar gadgets), 
which may be otherwise appear partially hidden.

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

With this feature, no longer will end user gadgets or a bloated task bar cover 
mission critical applications.

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] - Change Individual Row Colors in Enhanced DB Grid

[Paul C. Buckley]

Razzak & everyone else,

Thanks for the help. I was so focused on looking in R:DOCS for a property I 
missed this being available in the form. It's working great. This group makes 
me look better than I am to my bosses, thanks again.

Razzak - I will always agree with you when you proclaim R:BASE as "freaking 
awesome" - thanks again,

Paul

-Original Message-
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
A. Razzak Memon
Sent: February 21, 2018 11:22 AM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - Change Individual Row Colors in Enhanced DB Grid

Paul,

Here is another example of Enhanced DB Grid with customized "Row Color" as 
green when a project task is completed.

Notice the Enhanced DBGrid with Checkboxes for "Administrative Checklist" and 
"Job Flow Checklist".

Freaking awesome, 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 individual cell or row. Sorry to bug you but what am I 
>missing? I'm using the latest R:DOCS, I think, 10.0.3.20116.
>
>Thanks,
>Paul
>
>-Original Message-
>From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On 
>Behalf Of A. Razzak Memon
>Sent: December 22, 2017 4:47 PM
>To: rbase-l@googlegroups.com
>Subject: Re: [RBASE-L] - Change Individual Row Colors in Enhanced DB 
>Grid
>
>Paul,
>
>Within the Enhanced DB Grid's Column properties, the ability to alter 
>the Background Color, based upon the data within the cell, was 
>implemented some time ago.
>However, did you know
>that now the ability to alter the "Text Color" has been implemented as well?
>
>The Enhanced DB Grid control feature was previously named Background 
>Color Mapping, but is now appropriately designated as "Dynamic Colors", 
>with the support for both background and text colors for completely 
>dynamic color behaviors.
>
>The Dynamic Colors feature allows for the background and text colors to 
>change based upon the data values within the cell. Text values and 
>expressions can be defined to reflect the cell data. Form variables can 
>also be used to base dynamic colors.
>
>Examples:
>
>01: Highlight all negative values: <(0)
>02: Highlight dates that are later than today: >(.#DATE)
>03: Highlight all dollar amount greater than $100: >($100.00)
>04: Highlight all values that match a defined variable: =(.VarName)
>
>For the following screen shot examples, dynamic colors are defined to 
>highlight invoice total values that are greater than $10,000.00 and 
>less than $2,000.00.
>
>>($1.00) : Background Color as Green and Text Color as White
><($2000.00)  : Background Color as Red and Text Color as White
>
>http://www.razzak.com/tips/EnhancedDBGrid_DynamicColumnColors_01.png
>http://www.razzak.com/tips/EnhancedDBGrid_DynamicColumnColors_02.png
>
>The whole purpose of the implementation of this feature ...
>
>A very complex and intuitive application was recently deployed for one 
>of our major Manufacturing and Fabrication Services clients, to 
>dynamically display an unattended, auto-scroll, production schedule and 
>priorities based on live employee time throughout the shop on NEC E425 
>42" Full HD LED Commercial Large Format Display Monitors.
>These display monitors are similar to what is usually seen inside 
>airport terminals.
>
>RBGXE Deployed Project Name: Production Priorities Display System 
>(PPDS)
>
>Dynamic Colors in Enhanced DB Grids is just one more feature allowing 
>R:BASE users to let the data speak for itself!
>
>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] - Change Individual Row Colors in Enhanced DB Grid

[Paul C. Buckley]

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 
individual cell or row. Sorry to bug you but what am I missing? I'm using the 
latest R:DOCS, I think, 10.0.3.20116.

Thanks,
Paul

-Original Message-
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
A. Razzak Memon
Sent: December 22, 2017 4:47 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Change Individual Row Colors in Enhanced DB Grid

Paul,

Within the Enhanced DB Grid's Column properties, the ability to alter the 
Background Color, based upon the data within the cell, was implemented some 
time ago. 
However, did you know
that now the ability to alter the "Text Color" has been implemented as well?

The Enhanced DB Grid control feature was previously named Background Color 
Mapping, but is now appropriately designated as "Dynamic Colors", with the 
support for both background and text colors for completely dynamic color 
behaviors.

The Dynamic Colors feature allows for the background and text colors to change 
based upon the data values within the cell. Text values and expressions can be 
defined to reflect the cell data. Form variables can also be used to base 
dynamic colors.

Examples:

01: Highlight all negative values: <(0)
02: Highlight dates that are later than today: >(.#DATE)
03: Highlight all dollar amount greater than $100: >($100.00)
04: Highlight all values that match a defined variable: =(.VarName)

For the following screen shot examples, dynamic colors are defined to highlight 
invoice total values that are greater than $10,000.00 and less than $2,000.00.

   >($1.00) : Background Color as Green and Text Color as White
   <($2000.00)  : Background Color as Red and Text Color as White

http://www.razzak.com/tips/EnhancedDBGrid_DynamicColumnColors_01.png
http://www.razzak.com/tips/EnhancedDBGrid_DynamicColumnColors_02.png

The whole purpose of the implementation of this feature ...

A very complex and intuitive application was recently deployed for one of our 
major Manufacturing and Fabrication Services clients, to dynamically display an 
unattended, auto-scroll, production schedule and priorities based on live 
employee time throughout the shop on NEC E425 42" Full HD LED Commercial Large 
Format Display Monitors. These display monitors are similar to what is usually 
seen inside airport terminals.

RBGXE Deployed Project Name: Production Priorities Display System (PPDS)

Dynamic Colors in Enhanced DB Grids is just one more feature allowing R:BASE 
users 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'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?



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

[Paul C. Buckley]

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@googlegroups.com
Subject: Re: [RBASE-L] - File location and path

 

Well using SLOCP, SLEN and SGET I can get what I need but just thought there 
might be a shorter way.

 

  

-Original Message-
From: "jan johansen"  >
To: rbase-l@googlegroups.com  
Date: Thu, 15 Feb 2018 12:05:42 -0800
Subject: [RBASE-L] - File location and path
  

I'm looking for ideas.

 

I need BOTH the fullpath and the filename without the path.

I don't think there is an option using either of the loadfile plugins.

 

Thoughts?

 

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

[Paul C. Buckley]

Dan,

Thanks so much, works perfectly. Still looking at the sort suggestion.

Paul

-Original Message-
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Dan Goldberg
Sent: February 13, 2018 12:49 PM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - Position on a Specific Row in an Enhanced DB Grid

SET VAR vSearchString TEXT = NULL
SET VAR vSearchString = +
('PROPERTY TABLE Customer SEARCH->'+.vColumnName+'->'+.vSearchValue)


Dan Goldberg

-Original Message-
From: rbase-l@googlegroups.com [mailto: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 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.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google 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] - Position on a Specific Row in an Enhanced DB Grid

[Paul C. Buckley]

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.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google 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] - Multi-Column Sort in Enhanced DB Grid

[Paul C. Buckley]

Dan,

Thanks, that worked. Is there any way you know that I can create a new sort and 
resort off that without closing & reopening the form?

Thanks,
Paul Buckley

-Original Message-
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Dan Goldberg
Sent: February 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. Buckley
Sent: Friday, February 9, 2018 6:45 AM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - Multi-Column Sort in Enhanced DB Grid

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 & reopening the form.

Any suggestions?

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.

RE: [RBASE-L] - Autofill a form field

[Paul C. Buckley]

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-l@googlegroups.com] On Behalf Of 
dkfowler6179
Sent: January 31, 2018 5:29 PM
To: RBASE-L 
Subject: [RBASE-L] - Autofill a form field

R:Base X, newest version.  Looking for a way to autofill a field in a form with 
a value from an existing table based in characters typed in.  For example.  If 
we have a table that holds city names, I'd like to autofill a field for city in 
a form based on what is being typed, with the more characters being typed 
increasing the accuracy of the fill choice.  This value then needs to be saved 
when the row of data specific to a the job being entered is saved.  I've played 
with a DB Lookup List View and this acts similar to what I'm hoping for.  
However you have to type very quickly to keep it from switching the lookup back 
to the first letter of the street name.  I also don't need a long list, just a 
few choices as more characters are entered and narrow down the options to the 
correct choice.  
Any help is appreciated.  
Thanks,
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] - Autofill a form field

[Paul C. Buckley]

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
To: RBASE-L 
Subject: [RBASE-L] - Autofill a form field

R:Base X, newest version.  Looking for a way to autofill a field in a form with 
a value from an existing table based in characters typed in.  For example.  If 
we have a table that holds city names, I'd like to autofill a field for city in 
a form based on what is being typed, with the more characters being typed 
increasing the accuracy of the fill choice.  This value then needs to be saved 
when the row of data specific to a the job being entered is saved.  I've played 
with a DB Lookup List View and this acts similar to what I'm hoping for.  
However you have to type very quickly to keep it from switching the lookup back 
to the first letter of the street name.  I also don't need a long list, just a 
few choices as more characters are entered and narrow down the options to the 
correct choice.  
Any help is appreciated.  
Thanks,
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] - SHORTFILENAME vs. LONGFILENAME

[Paul C. Buckley]

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 browse the operating system. The LoadFileNamePlus plugin replaced the 
LoadFileName Plugin

with additional options to load a file name. It does not appear in the R:BASE 
for Windows Plugins Menu.

The LoadFileName is included with the purchase of R:BASE.

Syntax:

PLUGINS LoadFileName VarName|

Where:

VarName is the variable name to return the text value of the selected file

Parameters:

Parameter Value Description

FULLPATH ON/OFF Determines if the full path for the selected file is returned 
with

the file name

TITLE value Specifies the title caption

FILTER value Filters the display files (Example: Text Files (*.txt)#*.txt)

INITIAL_DIR value Specifies the initial directory when launched

NO_CHANGE_DIR ON/OFF Determines if the directory changes when the file is 
selected

MULTISELECT ON/OFF Determines if multiple files can be selected

SHOW_HIDDEN ON/OFF Determines if hidden files can be seen

NO_LONG_NAMES ON/OFF Determines if files not using the 8.3 naming convention are

displayed. This is only supported with the OLD_STYLE parameter.

NO_NETWORK_BUTTONON/OFF Determines if the network button is displayed. This is 
only

supported with the OLD_STYLE parameter.

HIDE_READ_ONLY ON/OFF Determines if the "Open as Read Only" check box is 
displayed

NO_DEREFERENCE_LIN

KS

ON/OFF Determines if shortcut links are valid or are de-referenced

DONT_ADD_TO_RECEN

T

ON/OFF Determines if file selection is added to recently opened

documents

ENABLE_SIZING ON/OFF Determines if the dialog window can be resized

OLD_STYLE ON/OFF Determines if the "old style" window is displayed

NO_VALIDATE ON/OFF Determines if validation for invalid characters is used

Notes:

Each option must be separated by pipe "|" character.

A value of '[Esc]' will be returned if the [Cancel] button or Close Window [x] 
button of the folder

selection dialog is selected.

Example:

PLUGIN LoadFileName vFileName+

|INITIAL_DIR C:\RBTI\ +

|TITLE 'Select file to load' +

|FULLPATH ON+

|NO_CHANGE_DIR ON+

|FILTER JPG Files (*.jpg)#*.jpg+

|HIDE_READ_ONLY ON+

|MULTISELECT ON+

|SHOW_HIDDEN OFF+

|ENABLE_SIZING ON

 

 

4.1.4 LoadFileNamePlus

The LoadFileNamePlus plugin is used to load a file name into a variable by 
displaying a dialog window for

the user to browse the operating system. The LoadFileNamePlus plugin was added 
with additional options

to load a file name. It does not appear in the R:BASE for Windows Plugins Menu. 
The LoadFileNamePlus is

included with the purchase of R:BASE.

Syntax:

PLUGINS LoadFileNamePlus VarName|

Where:

VarName is the variable name to return the text value of the selected file

Parameters:

Parameter Value Description

FULLPATH ON/OFF Determines if the full path for the selected file is returned 
with

the file name

TITLE value Specifies the title caption

FILTER value Filters the display files (Example: Text Files (*.txt)#*.txt)

INITIAL_DIR value Specifies the initial directory when launched

NO_CHANGE_DIR ON/OFF Determines if the directory changes when the file is 
selected

MULTISELECT ON/OFF Determines if multiple files can be selected

SHOW_HIDDEN ON/OFF Determines if hidden files can be seen

NO_LONG_NAMES ON/OFF Determines if files not using the 8.3 naming convention are

NO_NETWORK_BUTTONON/OFF Determines if the network button is displayed. This is 
only

supported with the OLD_STYLE parameter.

HIDE_READ_ONLY ON/OFF Determines if the "Open as Read Only" check box is 
displayed

NO_DEREFERENCE_LIN

KS

ON/OFF Determines if shortcut links are valid or are de-referenced

DONT_ADD_TO_RECEN

T

ON/OFF Determines if file selection is added to recently opened

documents

ENABLE_SIZING ON/OFF Determines if the dialog window can be resized

OLD_STYLE ON/OFF Determines if the "old style" window is displayed

NO_VALIDATE ON/OFF Determines if validation for invalid characters is used

VIEW_MODE THUMBNAI

LS

TILES

ICONS

(Default)

LIST

DETAILS

Determines the view mode for the dialog window

Notes:

Each option must be separated by pipe "|" character.

A value of '[Esc]' will be returned if the [Cancel] button or Close Window [x] 
button of the folder

selection dialog is selected.

Example:

PLUGIN LoadFileNamePlus vFileName+

|INITIAL_DIR C:\RBTI\ +

|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

 

 

 

 

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of MD
Sent: January 17, 2018 2:46 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - SHORTFILENAME vs. LONGFILENAME

 

Thank you Karen I guess I will have to parse out 

RE: [RBASE-L] - Change Individual Row Colors in Enhanced DB Grid

[Paul C. Buckley]

Dan,

 

Thanks I’ll give this a try.

 

Paul

 

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Dan Goldberg
Sent: December 22, 2017 3:20 PM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - Change Individual Row Colors in Enhanced DB Grid

 

You can use a 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@googlegroups.com <mailto:rbase-l@googlegroups.com> 
Subject: [RBASE-L] - Change Individual Row Colors in Enhanced DB Grid

 

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

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

[Paul C. Buckley]

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

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

[Paul C. Buckley]

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.

RE: [RBASE-L] - Suppressing main R:Base screen

[Paul C. Buckley]

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: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Suppressing main R:Base screen

Razzak,

Thank you for the quick answer.  What you suggest is what I have done.  The 
only difference is that the second for I open is also MDI.  If I open the 
second without it being MDI, I can't move back and forth between the two forms, 
I can only access the second form that is opened.  

Here's the code from the app that opens the forms.

CONNECT custmr
PROPERTY APPLICATION TITLE 'Dispatch'
EDIT USING dispatchedjobs WHERE status='d' SORTED BY jobdate tin operator + MDI 
AS dispatchwindow CAPTION 'DISPATCHED JOBS'
EDIT USING pendingjobs WHERE status='p' SORTED BY jobdate street + MDI AS 
pendingwindow CAPTION 'PENDING JOBS'
RETURN

Thanks for any other ideas.

David Fowler


> On December 18, 2017 at 10:12 AM "A. Razzak Memon"  wrote:
> 
> 
> David,
> 
> Here is a very simple approach ...
> 
> 01. Create a command file, such as, MyApplication.DAT, that include 
> all your database CONNECT statement and then EDIT USING formname , etc.
>  -- Example
>  -- MyApplication.DAT
>  CONNECT dbname
>  CLS
>  EDIT USING formname1 MDI
>  EDIT USING formname2
>  RETURN
> 
> 02. Create application shortcut as follows:
>  -- Example
>  Target: C:\RBTI\RBGX\RBGX.EXE MyApplication.DAT
>  Start in: C:\Databases\
> 
> 03. Double-clicking on the shortcut will launch RBGX.exe with all your 
> statements in the MyApplication.DAT file.
> 
> 04. You may also RUN MyApplication.DAT at the R> Prompt or from the 
> Database Explorer > Command Files as well.
> 
> That should provide you with the outcome you are looking for.
> 
> Hope that helps!
> 
> Very Best R:egards,
> 
> Razzak
> 
> 
> 
> At 09:41 AM 12/18/2017, dkfowler6179 wrote:
> 
> >I've got an app that opens two forms as MDI.  That part works, but 
> >after the forms open, the main R:Base screen (database explorer, 
> >editor, etc. Opens over top of the forms.  I can minimize that window 
> >and hide it behind the forms and use them but would like to suppress 
> >the window from opening at all.  I'm probably missing something easy, 
> >but haven't been able to figure it out.
> >
> >Thanks for any help.
> >
> >David Fowler
> >Roto-Rooter
> 
> --
> For group guidelines, visit 
> http://www.rbase.com/support/usersgroup_guidelines.php
> ---
> You received this message because you are subscribed to the Google 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] - Enhanced DB Grid Multi-Select Option

[Paul C. Buckley]

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

RE: [RBASE-L] - Correct Way to Save Changes Made in an Enhanced DB Grid

[Paul C. Buckley]

Razzak,

Thanks, I'll give this a try. I hope you, your family and everyone at RBTI has 
a very Merry Christmas.

Paul

-Original Message-
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
A. Razzak Memon
Sent: December 18, 2017 9:27 AM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - Correct Way to Save Changes Made in an Enhanced DB Grid

Here you go ...


Paul,

When using the Enhanced DB Grid, every editable "Cell" of the selected row can 
be customized.

However, to save changes, when user clicks on the "Save" button without 
clicking somewhere else in the DB Grid first, you may want to use the following 
command as "On Exit from DB Grid" EEP.

PROPERTY TABLE EnhancedDBGridTable 'POST'
PROPERTY TABLE EnhancedDBGridTable '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 on 12/14/17. Could you please repost 
>it or send it to me personally?
>
>Thanks,
>Paul
>
>-Original Message-
>From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On 
>Behalf Of A. Razzak Memon
>Sent: December 18, 2017 8:34 AM
>To: rbase-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'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 for the db grid having an On Row Exit. The problem is, if a 
> >user changes the value in a cell and clicks the "save"
> >button without clicking somewhere else in the grid first the changes 
> >are not saved.
> >
> >Any blues clues would be greatly appreciated.


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

[Paul C. Buckley]

Razzak,

I don't have a response from you on 12/14/17. Could you please repost it or 
send it to me personally?

Thanks,
Paul

-Original Message-
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
A. Razzak Memon
Sent: December 18, 2017 8:34 AM
To: rbase-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'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 
>for the db grid having an On Row Exit. The problem is, if a user 
>changes the value in a cell and clicks the "save"
>button without clicking somewhere else in the grid first the changes 
>are not saved.
>
>Any blues clues would be greatly appreciated.

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

[Paul C. Buckley]

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 for the db grid having an On Row 
Exit. The problem is, if a user changes the value in a cell and clicks the 
"save" button without clicking somewhere else in the grid first the changes are 
not saved.

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.

[RBASE-L] - Correct Way to Save Changes Made in an Enhanced DB Grid

[Paul C. Buckley]

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 for the db grid having an On Row 
Exit. The problem is, if a user changes the value in a cell and clicks the 
"save" button without clicking somewhere else in the grid first the changes are 
not saved.

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.

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

[Paul C. Buckley]

Razzak,

Well I thought that would be it. I've taken out all the saverow's and I still 
get prompted to save changes when I change cells in the Enhanced DB grid.

Any other suggestions?

Thanks,
Paul

-Original Message-
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.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.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
A. Razzak Memon
Sent: August 24, 2017 8:37 AM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - Another Enhanced DB Grid Question

Paul,

While in form designer, carefully review the [Code] section of the form and 
make sure that you are not using the SAVEROW option on each click of the DB 
Grid Column.

See attached screen shot for the exact location for [Code] option.

Hope that provides you with some 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,
>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: 
><mailto:rbase-l@googlegroups.com>rbase-l@googlegroups.com
>[mailto:rbase-l@googlegroups.com] On Behalf Of Paul C. Buckley
>Sent: Wednesday, August 23, 2017 3:14 PM
>To: <mailto:rbase-l@googlegroups.com>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.

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

[Paul C. Buckley]

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>  
[mailto:rbase-l@googlegroups.com] On Behalf Of Paul C. Buckley
Sent: Wednesday, August 23, 2017 3:14 PM
To: rbase-l@googlegroups.com <mailto: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 
<mailto: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 
<mailto: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

[Paul C. Buckley]

Karen,

 

Thank you SO MUCH. With your help and lots of caffeine I think I’ve got it.

 

Paul

 

From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com] 
Sent: August 23, 2017 9:16 AM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Determining Current Row in Enhanced DB Grid

 

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:  mailto:p...@buckleyandassoc.com> >
To: rbase-l <rbase-l@googlegroups.com <mailto: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 
<mailto:rbase-l@googlegroups.com?> ] 
Sent: August 22, 2017 5:34 PM
To: rbase-l@googlegroups.com <mailto: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 
<mailto:p...@buckleyandassoc.com> >
To: rbase-l <rbase-l@googlegroups.com <mailto: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 <mailto: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 
<mailto: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 
<mailto: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 
<mailto: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

[Paul C. Buckley]

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 
<mailto:p...@buckleyandassoc.com> >
To: rbase-l <rbase-l@googlegroups.com <mailto: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 <mailto: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 
<mailto: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] - Determining Current Row in Enhanced DB Grid

[Paul C. Buckley]

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.

RE: [RBASE-L] - Problem with a Select Distinct Statement

[Paul C. Buckley]

Buddy,

 

Bill’s suggestion of using the column number worked but if you could give me an 
example of what you are using that works that would be great too.

 

Thanks,

Paul

 

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

 

You can alias the table when you sattach especially if you’re not updating the 
table. When updating or adding records I had to have the ‘dbo’ so all I did was 
put IDQUOTES around the table name.

 

Buddy

 

 

From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com] 
Sent: Thursday, August 3, 2017 11:59 AM
To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 
Subject: Re: [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 <p...@buckleyandassoc.com 
<mailto:p...@buckleyandassoc.com> >
To: rbase-l <rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> >
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- <mailto:l...@googlegroups.com> l...@googlegroups.com [ 
<mailto:rbase-l@googlegroups.com?> mailto:rbase-l@googlegroups.com] On Behalf 
Of Buddy Walker
Sent: August 03, 2017 11:05 AM
To: rbase- <mailto:l...@googlegroups.com> 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:  <mailto:rbase-l@googlegroups.com> 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 10:41 AM
To:  <mailto:rbase-l@googlegroups.com> 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  <mailto:rbase-l+unsubscr...@googlegroups.com> 
rbase-l+unsubscr...@googlegroups.com.
For more options, visit  <https://groups.google.com/d/optout> 
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  <mailto:rbase-l+unsubscr...@googlegroups.com> 
rbase-l+unsubscr...@googlegroups.com.
For more options, visit  <https://groups.google.com/d/optout> 
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  <mailto:rbase-l+unsubscr...@googlegroups.com> 
rbase-l+unsubscr...@googlegroups.com.
For more options, visit  <https://groups.google.com/d/optout> 
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 
<mailto: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 
<mailto: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] - My sincere thanks

[Paul C. Buckley]

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:rbase-l@googlegroups.com] On Behalf Of 
A. Razzak Memon
Sent: August 03, 2017 9:05 AM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - My sincere thanks

To R:BASE Community:

I would like to extend my sincere thanks to all the R:BASE users and developers 
listed below who have been instrumental in testing the official release of 
R:BASE X and R:BASE X Enterprise, Update 2, Build: 10.0.2.20731.

. Dan Angcao
. Marcos Antonio
. Albert Berry
. Paul Buckley
. Silvio J. Castaldi Jr.
. Silvio Castaldi Sr.
. Dan Goldberg
. Philippe Gosselin
. Richard Hopkins
. Adrian Hüssy
. Tony IJntema
. Fritz Lüttgens
. Gerusa Machini
. Stephen Markson
. Rob McDivitt
. Antonio Nicolini
. Mike Ramsour
. Claudine Robbins
. Peter Ryan
. Mohammed Sattar
. Ajay Sanghvi
. Ken Shapiro
. Rogério Yukio Shioya
. Richard Siegler
. Howard Simon
. Frank Taylor
. Armin Thoma
. Steve Vellella

R:BASE Technologies is fortunate to have such loyal and caring customers who 
are part of our success. Thanks for believing in our vision and helping us to 
provide you with the best of R:BASE.

We will continue to do our best and live up to your highest expectations. We 
will care for those who care about us. We will support those who believe in us 
and have much invested in R:BASE and R:BASE Technologies, Inc.

Thank you again for all your hard work and dedication.

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

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

[Paul C. Buckley]

Karen,

 

The select * from dbo.sales_rep won’t work without the dbo. But I can’t get it 
working for the columns with or without it.

 

Thanks,

Paul

 

From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com] 
Sent: August 03, 2017 11:59 AM
To: rbase-l@googlegroups.com
Subject: Re: [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 <p...@buckleyandassoc.com 
<mailto:p...@buckleyandassoc.com> >
To: rbase-l <rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> >
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- <mailto:l...@googlegroups.com> l...@googlegroups.com [ 
<mailto:rbase-l@googlegroups.com?> mailto:rbase-l@googlegroups.com] On Behalf 
Of Buddy Walker
Sent: August 03, 2017 11:05 AM
To: rbase- <mailto:l...@googlegroups.com> 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:  <mailto:rbase-l@googlegroups.com> 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 10:41 AM
To:  <mailto:rbase-l@googlegroups.com> 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  <mailto:rbase-l+unsubscr...@googlegroups.com> 
rbase-l+unsubscr...@googlegroups.com.
For more options, visit  <https://groups.google.com/d/optout> 
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  <mailto:rbase-l+unsubscr...@googlegroups.com> 
rbase-l+unsubscr...@googlegroups.com.
For more options, visit  <https://groups.google.com/d/optout> 
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  <mailto:rbase-l+unsubscr...@googlegroups.com> 
rbase-l+unsubscr...@googlegroups.com.
For more options, visit  <https://groups.google.com/d/optout> 
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 
<mailto: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 a Select Distinct Statement

[Paul C. Buckley]

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>  
[mailto:rbase-l@googlegroups.com] On Behalf Of Paul C. Buckley
Sent: Thursday, August 3, 2017 10:41 AM
To: rbase-l@googlegroups.com <mailto: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 
<mailto: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 
<mailto: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 a Select Distinct Statement

[Paul C. Buckley]

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.

RE: [RBASE-L] - Update & LTRIM

[Paul C. Buckley]

Razzak & Albert,

I said in my email I was fading. My brain said leading spaces and I typed 
leading zeros and then when I read it before sending I read spaces.

Thanks for the SQL command Razzak, that's what I was looking for.

Paul 

-Original Message-
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
A. Razzak Memon
Sent: June 19, 2017 4:04 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Update & LTRIM

Paul,

FWIW ...

LTRIM is NOT going to clean up leading zeros.

If you need to TRIM leading an/or trailing "spaces", 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 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 zeros. I know I can create a Declare loop and go thru each 
>table and do an LTRIM on each column. I’m wondering if there is a 
>slick SQL Update command that would allow me to clean up the whole 
>table, even if I had to run it separately for each column?
>
>Thanks in advance,
>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 
><mailto:rbase-l+unsubscr...@googlegroups.com>rbase-l+unsubscr...@googlegroups.com.
>For more options, visit
><https://groups.google.com/d/optout>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] - Update & LTRIM

[Paul C. Buckley]

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 zeros. I know I can create a Declare loop 
and go thru each table and do an LTRIM on each column. I’m wondering if there 
is a slick SQL Update command that would allow me to clean up the whole table, 
even if I had to run it separately for each column?

 

Thanks in advance,

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.

RE: [RBASE-L] - Password error

[Paul C. Buckley]

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.

 

Enquiring minds wanted to know.

 

Paul Buckley

 

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Alastair Burr
Sent: June 15, 2017 10:34 AM
To: karentellef via RBASE-L 
Subject: Re: [RBASE-L] - Password error

 

I spent days editing the unload file(s); using SET USER and a few times I 
thought I had conquered it but eventually the need for NONE appeared again.

As far as I recollect (always dangerous) neither NONE nor PUBLIC ever used to 
appear in the unload file - only the owner password if one existed for the 
owner name. (Prior to that only the owner name.)

PUBLIC was implied by not having an owner or added via the GRANT system.
NONE just seems to have appeared but when I don't know. It can/should be used 
to remove a password according to help. Maybe R:Base is suddenly taking it 
literally and storing NONE as the password but that wouldn't explain why it 
suddenly decides to need it.

I presume AUTHOR is the SQL way of saying OWNER?

Regards,
Alastair.



On 15/06/2017 14:13, karentellef via RBASE-L wrote:

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 but it still comes back. I gave 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 folder 
as 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 

RE: [RBASE-L] - FTP

[Paul C. Buckley]

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 Behalf Of 
Stephen Markson
Sent: June 02, 2017 2:05 PM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - FTP

 

Does anyone have a simple way to automate FTP file transfer using R:Base?

 

 

Regards,

 

Stephen Markson

The Pharmacy Examining Board of Canada

416.979.2431 x251

 

-- 
You received this message because you are subscribed to the Google 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] - Enhanced DB Grid Question #2

[Paul C. Buckley]

Razzak,

 

Still no luck, I even switched to using a form in RRBYW19 that had an Enhanced 
DB Grid on it. 

 

Other ideas?

 

Thanks,

Paul Buckley

 



 

-Original Message-
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
A. Razzak Memon
Sent: May 19, 2017 1:10 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Enhanced DB Grid Question #2

 

Here's how ...

 

Un-Check the [ ] Theme Aware option under DB Grid Options to override custom 
colors, etc.

 

Enhanced DB Grid Control > Properties > DB Grid Options

 

That's all 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 Grid.

>I'm using the command: PROPERTY enhanceddbgrid1 'COLUMNS[13]->COLOR' 

>'red'. I'm seeing no change in the background color.

>Suggestions?

 

 

--

You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.

To unsubscribe from this group and stop receiving emails from it, send an email 
to  <mailto:rbase-l+unsubscr...@googlegroups.com> 
rbase-l+unsubscr...@googlegroups.com.

For more options, visit  <https://groups.google.com/d/optout> 
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] - Enhanced DB Grid Question #2

[Paul C. Buckley]

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,

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.

RE: [RBASE-L] - Modifying SQL Tables with R:BASE Using ODBC Connection

[Paul C. Buckley]

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 the data - that shouldn't 
be a problem the longest text/note in any column right now is 90 characters. I 
was able to do an SSQL update on the SQL table yesterday I just can't open the 
SQL table and modify columns interactively - no problem. What I'm probably 
going to do is right a custom front end and form to search for the data I need 
to modify and make changes to a projected R:BASE table then update the SQL 
table accordingly with SSQL code.

Thanks for the feedback,
Paul Buckley

-Original Message-
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
A. Razzak Memon
Sent: May 10, 2017 7:43 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Modifying SQL Tables with R:BASE Using ODBC Connection

Paul,

A few questions ...

01. That custom table created by your ERP vendor is the actual Table or a View?

02. Do you have full user privileges to update that custom table?

03. After successfully SATTACHing that custom table in R:BASE X Enterprise 
database, are you able to PROJECT to a real R:BASE Table (or Temporary Table)?

Hope that provides you with some blue's clues ...

Feel free to reach out to me if you need further assistance in making R:BASE X 
Enterprise a Front-End for your SQL ERP system.

Very Best R:egards,

Razzak


At 10:19 AM 5/10/2017, Paul Buckley wrote:

>I need to say I am not an MS SQL expert, I MUCH prefer R:BASE, however, 
>I have an ERP system using a SQL database and I’m trying to modify 
>some tables using an R:BASE front end. I have the latest version R:BASE 
>X Enterprise and I’m using SQL Server 2012. I had a custom table 
>created for me by the ERP vendor but they created all the columns with 
>datatype nvarchar(max). When I connect to the table I see no data. I 
>have modified a couple of columns  - one to nvarchar(50) and one to 
>char(50). When I open the connected table I can see the data but cannot 
>modify it (I get the error shown below).
>The columns are showing as text(50) in R:BASE but I cannot modify the 
>data. I have successfully connected to other tables in the SQL database 
>with nvarchar(50) datatypes and have no trouble editing and saving the 
>data.
>
>Any blues clues would be greatly appreciated.
>
>
>[]
>
>
>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.

RE: [RBASE-L] - refressing DB in the explorer

[Paul C. Buckley]

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-l@googlegroups.com] On Behalf Of 
Jim Belisle
Sent: May 10, 2017 10:08 AM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - refressing DB in the explorer

 

I had to reinstall my 9.5 RBASE on a new computer. Now When in the explorer 
mode, any changes I make (like comments on table) or form changes changing the 
version number, do not show until I get out then back into another session. I 
tried reading up on all the settings to figure which setting I need to change. 
What setting do I need to change for the changes to take immediately?

 

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] - RIP Bob Castanaro

[Paul C. Buckley]

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 friend,

Paul Buckley

 

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Bill Downall
Sent: 12 22, 2016 8:28 PM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - RIP Bob Castanaro

 

After a grueling battle with cancer, long-time R:BASE developer Bob Castanaro, 
from Barberton, OH, died this week. He chose to stop dialysis a little over a 
week ago, and, as he said, to say goodbye on his own terms.

 

I always enjoyed playful,  friendly, respectful political disagreements with 
Bob at Developers' Conferences, and he always had great ideas and experiences 
to share from his hospital administration database applications.

 

https://www.facebook.com/bobcastanaro

 

Bill


(sent from Moto Z)

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