Re: [RBASE-L] - logging database value changes in a form

[Ken Shapiro]

Myron,

I think you can use triggers to capture when data changes. You can use an
on before update trigger which can be set in the table definition.

A stored procedure has to be created first. With the store procedure is
created a trigger can be created on the table. There are virtual tables
sys_old and sys_new than can be referenced within the trigger:

select list_of_db_columns into INTO list_of_variables
FROM table WHERE CURRENT OF SYS_OLD

SELECT list of db columns INTO list of variables
FROM table WHERE CURRENT OF SYS_NEW

IF some old var <> some new var
UPDATE another table SET t_c = .#DATE WHERE 'where clause'
ENDIF

Ken

On Thu, Dec 21, 2023 at 9:56 AM  wrote:

> Dan,
>
> Based on the post under this one we are still working on making the
> determination as to when *data in a row has been changed*. Once there we
> will make the changes accordingly and will keep everyone posted..
>
>
>
> *Thought you might want to see how our application starts.*
>
> Our organization currently starts with tracking the user when they log
> onto the production application. This is the code in the .dat file.
>
> CONNECT posse_scw IDENTIFIED BY ***
>
> SET NULL ' '
>
> SET VAR vversion TEXT = (CVAL('VERSION BUILD'))
>
> SET VAR vvconnections TEXT = (CVAL('CONNECTIONS'))
>
> SET VAR vcomputer TEXT = 22
>
> SET VAR vpossenme TEXT = 40
>
> SET VAR vpossenme TEXT = 'The Posses of Sun City West'
>
> SET VAR vguserid TEXT=NULL
>
> SET VAR vggroupid INTEGER=NULL
>
> SET VAR vcancel INTEGER=NULL
>
> SET VAR vloginid TEXT = (CVAL('netuser'))
>
> SET VAR vcomputer TEXT= (CVAL('COMPUTER'))
>
> SET VAR vdateloggedin DATE = .#DATE
>
> SET VAR vpassword TEXT = NULL
>
> REFF eff_login_6.rff  * password>*
>
> IF vcancel = 1 THEN
>
>   EXIT
>
> ENDIF
>
> ---
>
> CLS
>
> SET TIMEOUT 60
>
> REFF posse_desktop.rff   * passing the password check.>*
>
> ---Who is logged on
>
> SET VAR vpk INTEGER = NULL, vdatetime DATETIME = NULL
>
> SELECT pk INTO vpk FROM whoisloggedon WHERE +
>
> lusedid = .vloginid AND ccomputer = .vcomputer AND +
>
> logdate = (SELECT MAX(logdate) FROM whoisloggedon WHERE +
>
> lusedid=.vloginid AND ccomputer=.vcomputer)
>
> ---
>
> UPDATE whoisloggedon SET logoffdate = .#now +  * to track who has logged on using what computer>*
>
> WHERE pk=.vpk
>
> LABEL done
>
> CLEAR VARIABLES iv%,rbti_%
>
>
>
> *Now to data in separate table(s).*
>
> There is an update performed – as I previous mentioned but not on a test
> for a data change in a row of data in the table. Still working on it.
>
>
>
> Yes, I didn’t answer your question per se but just wanted to let you know
> it is still being worked on.
>
>
>
> Myron
>
>
>
> *From:* 'Dan Goldberg' via RBASE-L 
> *Sent:* December 20, 2023 9:03 AM
> *To:* rbase-l@googlegroups.com
> *Subject:* [RBASE-L] - logging database value changes in a form
>
>
>
> I have a requirement to keep a log(in a separate table) when someone
> changed the data in a row in a form. This will include the old values and
> new values as well as user/datetime stamp.
>
>
>
> Has anyone done this before and can give me some pointers?
>
>
>
> Happy Holidays
>
>
>
> Dan Goldberg
>
>
>
> --
> For group guidelines, visit
> http://www.rbase.com/support/usersgroup_guidelines.php
> ---
> You received this message because you are subscribed to the Google Groups
> "RBASE-L" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to rbase-l+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/rbase-l/BY3PR19MB5027EAF7EB79AAB93281A649D496A%40BY3PR19MB5027.namprd19.prod.outlook.com
> 
> .
>
> --
> For group guidelines, visit
> http://www.rbase.com/support/usersgroup_guidelines.php
> ---
> You received this message because you are subscribed to the Google Groups
> "RBASE-L" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to rbase-l+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/rbase-l/018c01da341d%24e933c130%24bb9b4390%24%40gmail.com
> 
> .
>

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/CADeqk-5coV6kCKEB3jYENbOOqTkumrUgTr2ZfC56L6n6MttS%2Bw%40mail.gmail.com.

RE: [RBASE-L] - Date

[Ken Shapiro]

Alternatively – accomplishes the same thing.

 

SET VAR vdate DATE =(.#DATE)

SET VAR vprevious_date date= (ADDMON (RDATE(IMON(.vdate),1,IYR4(.vdate)),-2))

 

Regards, Ken

 

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Doug Hamilton
Sent: Thursday, January 12, 2023 2:12 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Date

 

Jan, try this:

--vDate is a test date, try different values; change to .#Date in the 
expression after testing
SET VAR vdate DATE = '2/28/2023'

SET VAR vStartDate DATE =  +
(RDATE( (IMON( ADDMON(.vdate,-2))),1,(IYR(ADDMON(.vdate,-2)))  ))

SHOW VAR vstartdate
RETURN

Doug

On 1/12/2023 12:27 PM, jan johansen wrote:

All,

 

I'm having a brain cramp. My code doesn't handle crossing years apparently.

I need to set a start date that is the first of the 2 months ago based on today 
i.e. 11/1/2022

 

Thanks

 

 

Jan

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com 
 .
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/WC20230112182746.3000D7%40jjcalibrations.com
 

 .

 

 

  _  


  

This email has been checked for viruses by Avast antivirus software. 
www.avast.com   





-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com 
 .
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/5967bf96-15ae-6114-3a01-83e4aa986d07%40wi.rr.com
 

 .

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/000501d926ed%24f845f820%24e8d1e860%24%40optonline.net.

Re: [RBASE-L] - using column name in report variables

[Ken Shapiro]

How about something like this.

--defined in on start eep for report
SET VAR vcolumn TEXT, vpartnum2 TEXT

--before generate custom eep for detail section
IF vpltaccess2 = 'L' THEN
  SET VAR vcolumn = 'prisupplerl'
ELSE
  SET VAR vcolumn = 'prisupplierd'
ENDIF

SELECT partnum2 INTO vpartnum2 FROM mastervendors WHERE part#=part# AND
='Y'

RETURN

On Mon, Jul 25, 2022 at 4:19 PM Dan Goldberg  wrote:

> Yea that is what I did as a workaround but the report would be quicker if
> it only had to do one lookup.
>
>
>
> Dan Goldberg
>
>
>
> *From:* 'Karen Tellef' via RBASE-L 
> *Sent:* Monday, July 25, 2022 1:12 PM
> *To:* rbase-l@googlegroups.com
> *Subject:* Re: [RBASE-L] - using column name in report variables
>
>
>
> I don't think I've ever tried that, but I'm not surprised it doesn't work.
>
>
>
> If it was me, I would create 2 variables (I'm winging this, so syntax
> might not be exactly right):
>
>
>
> VpartlocA = partnum2 in mastervendors where part# = part# and PriSupplerL
> = 'Y'
>
> VpartlocB = partnum2 in mastervendors where part# = part# and PriSupplerD
> = 'Y'
>
>
>
> Vpartnum2 = (ifeq(vpltaccess2,'L', .vpartlocA, .vpartlocB))
>
>
>
>
>
> Karen
>
>
>
>
>
> -Original Message-
> From: Dan Goldberg 
> To: rbase-l@googlegroups.com 
> Sent: Mon, Jul 25, 2022 3:06 pm
> Subject: [RBASE-L] - using column name in report variables
>
> I have a few variables in a report.
>
>
>
> Vpartloc = (ifeq(vpltaccess2,'L','PriSupplerL','PriSupplerD'))
>
>
>
> I want to create a lookup based on that column name in vpartloc
>
>
>
> Vpartnum2 = partnum2 in mastervendors where part# = part# and  =
> 'Y'
>
>
>
> I usually use the & symbol to substitute for the column name but it gives
> me an error when I try to save the variable.
>
>
>
> Any ideas why it does not work?
>
>
>
> TIA
>
>
>
> Dan Goldberg
>
>
>
> --
> For group guidelines, visit
> http://www.rbase.com/support/usersgroup_guidelines.php
> ---
> You received this message because you are subscribed to the Google Groups
> "RBASE-L" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to rbase-l+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0014F0903AC%40EXCHANGE10
> 
> .
>
> --
> For group guidelines, visit
> http://www.rbase.com/support/usersgroup_guidelines.php
> ---
> You received this message because you are subscribed to the Google Groups
> "RBASE-L" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to rbase-l+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/rbase-l/1042612017.1545249.1658779907686%40mail.yahoo.com
> 
> .
>
> --
> For group guidelines, visit
> http://www.rbase.com/support/usersgroup_guidelines.php
> ---
> You received this message because you are subscribed to the Google Groups
> "RBASE-L" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to rbase-l+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0014F09041B%40EXCHANGE10
> 
> .
>

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/CADeqk-5aBQGcSgQ_fcBbuQ-ErCxAwkvSuVpkBRDBqjDaKuS4jA%40mail.gmail.com.

Re: [RBASE-L] - Put together two rows of data from one table

[Ken Shapiro]

I’ll send you some code, I’ll look at this tonight. Is this from the house
detail?

On Thu, May 5, 2022 at 8:17 PM  wrote:

> Goal: To creating an address label that has two separate names
> concatenated – for a mailing label. For example: Myron Finegold and Susan
> Shapiro. (The street information and the city and state are easy)
>
> The data: We have a table that tracks the owners of a house. (we have
> about 17,000 houses and 30,000 rows of data) So, if there are two owners
> there will be two rows of data identified by a unique number. Party 1 –
> first name and last name and other information; Party 2 first name and last
> name and other information.
>
> I’ve never done this and I’m not sure where to start. What is the best way
> to pragmatically do this?
>
> Thanks in advance. Myron Finegold / Sheriff’s Posse of Sun City West
>
>
>
> --
> For group guidelines, visit
> http://www.rbase.com/support/usersgroup_guidelines.php
> ---
> You received this message because you are subscribed to the Google Groups
> "RBASE-L" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to rbase-l+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/rbase-l/000401d860de%24b480dd60%241d829820%24%40gmail.com
> 
> .
>
-- 
Sent from Gmail Mobile

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/CADeqk-4O9g%2BXLPY5Afn4xVvhz2OP5crc3_NehjM9KCEiWzkOhQ%40mail.gmail.com.

Re: [RBASE-L] - Tip of the Day: Assign NULL Values as Blank in Exports

[Ken Shapiro]

Hello Razzak,

Great enhancement. Thank you!

Regards, Ken

On Mon, Nov 22, 2021 at 4:07 PM A. Razzak Memon  wrote:

> Monday, November 22, 2021
>
> Tip of the Day: Assign NULL Values as Blank in Exports
> Product...: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5)
> Build.: 10.5.4.8 or higher
> Sections..: File Gateway
> Keywords..: Export, NULL, GATEWAY, BLANK_IF_NULL, Blank
>
> Did you know that NULL values may be displayed as blanks in
> table exports?
>
> A new "NULL Values Export as Blanks" option was implemented
> within the File Gateway Export menu, so your NULL value
> (e.g. -0-, NULL, etc.) is not displayed.
>
> The new option is different from the now "Zero Values Export as
> Blank" option, which is specific to zero values being assigned
> as a blank. The Export Wizard also includes a new "Blank if Null"
> option for the desired output.
>
> A new EXPORT parameter, BLANK_IF_NULL, has also been added to
> the GATEWAY command to assign NULL values as a blank.
>
> GATEWAY EXPORT XLSW C:\Temp\CustomerContacts.xlsx +
> SELECT ALL FROM CustomerContacts +
> OPTION COL_NAMES ON +
> |SHOW_PROGRESS ON +
> |BLANK_IF_NULL ON
>
> The Data Browser settings also includes the new "Blank if NULL"
> setting for exports performed at the table level.
>
> Very Best R:egards,
>
> Razzak.
>
> R:BASE Technologies, Inc.
> https://www.rbase.com
>
> --
> For group guidelines, visit
> http://www.rbase.com/support/usersgroup_guidelines.php
> ---
> You received this message because you are subscribed to the Google Groups
> "RBASE-L" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to rbase-l+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/rbase-l/0LoWaK-1mABD537VK-00gYbU%40mrelay.perfora.net
> .
>

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/CADeqk-7qRKc8%3DWeAQxAiWo8jDuLyD6TWxdEX8OAr%3DLfXd4nDug%40mail.gmail.com.

Re: [RBASE-L] - change date to datetime

[Ken Shapiro]

Along the same lines.

set var x datetime = (datetime( rdate(...), rtime(...))

On Fri, May 21, 2021 at 2:07 PM Dan Goldberg  wrote:

> Thx I will give that a try.
>
>
>
> Dan Goldberg
>
>
>
>
>
> *From:* rbase-l@googlegroups.com  *On Behalf Of
> *Tony IJntema
> *Sent:* Friday, May 21, 2021 10:52 AM
> *To:* rbase-l@googlegroups.com
> *Subject:* Re: [RBASE-L] - change date to datetime
>
>
>
>
>
> Dan,
>
>
>
> Try this:
>
> Create a new column like  date_time_field DATETIME in the table
>
> Then perform the next statement (where datefield is the original date
> column)
>
>
>
> UPDATE Testdate SET date_time_field  = (DATETIME(datefield,00:00))
>
>
>
> Tony
>
>
>
>
>
> Op 21-05-2021 om 19:18 schreef Dan Goldberg:
>
> I am trying to change a date column to datetime and it is giving me this
> error.
>
>
>
>
>
> How do I change it? Do I have to do a unload/change it/load?
>
>
>
> TIA
>
>
>
> Dan Goldberg
>
> --
> For group guidelines, visit
> http://www.rbase.com/support/usersgroup_guidelines.php
> ---
> You received this message because you are subscribed to the Google Groups
> "RBASE-L" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to rbase-l+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0014E8CAE33%40EXCHANGE10
> 
> .
>
> --
> For group guidelines, visit
> http://www.rbase.com/support/usersgroup_guidelines.php
> ---
> You received this message because you are subscribed to the Google Groups
> "RBASE-L" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to rbase-l+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/rbase-l/223ad65e-2368-e241-81e4-4452e7220448%40cio-bv.nl
> 
> .
>
> --
> For group guidelines, visit
> http://www.rbase.com/support/usersgroup_guidelines.php
> ---
> You received this message because you are subscribed to the Google Groups
> "RBASE-L" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to rbase-l+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0014E8CB0F5%40EXCHANGE10
> 
> .
>

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/CADeqk-5Ldq-7NzBwGdmiV06-g1qbmfY2cFN4R6QaG%2B5g0my-4g%40mail.gmail.com.

Re: [RBASE-L] - Form Controls: SET NULL '' confusion

[Ken Shapiro]

Try this:

set var vspace text = (' ')
set null .vspace
SET VAR vtext = 'a bc'
IF (SLOC(.vtext,' ')) <> 0 THEN
  SET VAR vtext = (SRPL(.vtext,' ','-',0))
ELSE
  PAUSE 1 USING 'nope - no space here'
ENDIF
RETURN

Regards, Ken

On Tue, Jan 19, 2021 at 9:31 PM Tony Luck  wrote:

> Off the top of my head what effect does setting EQNULL on in the settings
> have in a case like this ?
>
> On Wed, Jan 20, 2021 at 12:26 PM Bruce Chitiea 
> wrote:
>
>> All:
>>
>> *SET NULL ' '*  (ASCII 032) is often used within On Before Design
>> and On After Start form EEPs to suppress display of the default NULL
>> construction *'-0-'* within form controls.
>>
>> This presents a conflict when a  is entrained within the user's
>> input, and an On Exit EEP attempts to replace it:
>>
>> *IF vdim_input CONTAINS '' THEN
>> ; (SRPL(.vdim_input,'','-',0)) ; ENDIF*
>>
>> ... produces the error:
>>
>> *-ERROR- NULLs cannot be used in comparisons other than NE or EQ. (2315)*
>>
>> An attempt to use a "hard" space *[alt 255]* in place of the NULL
>> ** character displays an extended ASCII character in all VARIABLE
>> LABEL controls containing NULLs; Calibri font, in the example:
>>
>>
>>
>> Is there any ASCII code which will reliably suppress display of NULLs
>> without creating a conflict for routines dealing with ASCII *s*
>> in user input? I have not tested for other controls yet.
>>
>> Thanks!
>>
>> Bruce A. Chitiea
>> SafeSectors, Inc.
>> ---
>> 112 Harvard Ave #272
>> Claremont CA 91711-4716
>> ---
>> *rby...@safesectors.com *
>> *---*
>> +011 (909) 238-9012 c
>> +011 (909) 912-8678 f
>>
>>
>>
>> --
>> For group guidelines, visit
>> http://www.rbase.com/support/usersgroup_guidelines.php
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "RBASE-L" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to rbase-l+unsubscr...@googlegroups.com.
>> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/rbase-l/embdd74890-7f66-4128-836c-71991e072fc1%40pathfinder
>> 
>> .
>>
>
>
> --
> Regards
> Tony
>
> --
> For group guidelines, visit
> http://www.rbase.com/support/usersgroup_guidelines.php
> ---
> You received this message because you are subscribed to the Google Groups
> "RBASE-L" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to rbase-l+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/rbase-l/CABnhDARa9M1xxOHrV7p7pY6WhvSdc%3DKcZqggjLrET6wiifwxpA%40mail.gmail.com
> 
> .
>

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/CADeqk-4xG%3DdQUhsfLbj8%2BQPGoZ7FOXUOaFz3MQqUPQYrkF9-DQ%40mail.gmail.com.

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

[Ken Shapiro]

Happy Holidays to all.

Thank you Razzak for having R:BASE not miss a beat during this dreadful
year.

Regards, Ken

On Tue, Dec 29, 2020 at 6:36 PM Hannaway, Lance 
wrote:

> Thanks Razvan, to you and your family and the entire Rbase community,
> happy holidays and a healthy and prosperous New Year!
>
>
>
> Sent from my Verizon, Samsung Galaxy smartphone
>
>
>
>  Original message 
> From: "A. Razzak Memon" 
> Date: 12/29/20 5:28 PM (GMT-05:00)
> To: rbase-l@googlegroups.com
> Subject: [RBASE-L] - Happy Holidays from R:BASE Technologies
>
> CAUTION: This Email is sent from outside our organization. Please DO NOT
> Click on any links or open any attachments unless you recognize the sender.
> Please forward any Suspicious Email "as an attachment" to
> mis...@bronxcare.org
>
>
>
> Tuesday, December 29, 2020
>
> Dear R:BASE Community,
>
> I hope you are as well as can be expected during this time of
> unprecedented change and uncertainty.
>
> Even during a pandemic, we continue to serve our customers with
> extraordinary support and services.
>
> Based on our business model of 22 years, it's been business as usual
> at R:BASE Technologies, Inc.
> Our phones are being answered, Emails are being replied to, all
> reported bugs are being squashed,
> submitted enhancement requests are being implemented, and our
> Government, Corporate VIP, and
> customers with vested interest in R:BASE are being provided with
> exceptional support as always,
> including remote support, private updates, etc.
>
> As you may know, we have been very busy with our innovations and
> providing R:BASE Flagship Solutions,
> including the techniques to provide Android and Java Solutions for
> Mobile and Hand held devices.
>
> The team at R:BASE Technologies would like to extend our sincere
> thanks and appreciation for your
> business, partnership, and friendship!
>
> In celebrating our 22nd anniversary, we are grateful for your role in
> our achievements, and look
> forward to providing new opportunities to help you reach your goals
> for growth and prosperity.
>
> We're honored that a uniquely warm-spirited community has let us be a
> part of your business, and
> we are overwhelmingly proud to have been able to deliver products and
> support that have helped
> achieve your database objectives!
>
> However you celebrate, we wish you the very best for this holiday
> season and a happy,healthy, and
> prosperous 2021!
>
> My very best R:egards,
>
> Razzak
>
> --
> For group guidelines, visit
> https://nam04.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.rbase.com%2Fsupport%2Fusersgroup_guidelines.phpdata=04%7C01%7Clhannaw%40bronxleb.org%7Cc44d1f3be415476675ae08d8ac491747%7C4298a6c031114e0cb60c030ea7ab66ee%7C0%7C0%7C637448777216222865%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000sdata=8kZyCZs234tA2%2BcGyXuPTXIs3nHz9uILGY7DHfA0rzM%3Dreserved=0
> ---
> You received this message because you are subscribed to the Google Groups
> "RBASE-L" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to rbase-l+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgroups.google.com%2Fd%2Fmsgid%2Frbase-l%2F1MFKjN-1knTbB2IbB-00Fi85%2540mrelay.perfora.netdata=04%7C01%7Clhannaw%40bronxleb.org%7Cc44d1f3be415476675ae08d8ac491747%7C4298a6c031114e0cb60c030ea7ab66ee%7C0%7C0%7C637448777216222865%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000sdata=gG7KWG4RYscwbjXpCTHijyswgPlbCeM79NW0FNMAurU%3Dreserved=0
> .
> CONFIDENTIALITY NOTICE: This communication and any attachments may
> contain confidential and/or privileged information for the use of the
> designated recipients named above. If you are not the intended recipient,
> you are hereby notified that you have received this communication in error
> and that any review, disclosure, dissemination, distribution or copying of
> it or its contents is prohibited. If you have received this communication
> in error, please notify the sender immediately by email or telephone and
> destroy all copies of this communication and any attachments.
>
> --
> For group guidelines, visit
> http://www.rbase.com/support/usersgroup_guidelines.php
> ---
> You received this message because you are subscribed to the Google Groups
> "RBASE-L" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to rbase-l+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/rbase-l/MN2PR11MB39013CF769621645654E2078DFD80%40MN2PR11MB3901.namprd11.prod.outlook.com
> 
> .
>

-- 
For group guidelines, visit 

Re: [RBASE-L] - Tip of the Day: Jumping to a Specific Line in the Trace Debugger

[Ken Shapiro]

I can see this feature being extremely useful.

Regards, Ken

On Thu, Jul 16, 2020 at 8:07 AM A. Razzak Memon  wrote:

> Thursday, July 16, 2020
>
> Tip of the Day: Jumping to a Specific Line in the Trace Debugger
> Product...: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5)
> Build.: 10.5.2.20716 or higher
> Sections..: Trace Debugger
> Keywords..: Jump to Line, Debug, Skip, Coding
>
> Did you know there is added functionality to jump to a specific line
> in the debugger?
>
> The added "Jump to Line" option allows users to jump to a specific
> line when single-stepping through code.
>
> Select "Run" > "Jump to Line" from the menu bar, or press the [F11]
> hot key to open the "Jump to Line" dialog. The entered line number
> will move the trace cursor position to that line.
>
> Moving forward in a command file, the feature can be used to start
> debugging at a specific point, and to also skip over commands.
>
> Moving backward in a command file, Jump to Line can be used to repeat
> commands as needed.
>
> Whether you're moving forward or backward with the "Jump to Line"
> enhancement, you're always moving forward with R:BASE X.5!
>
> Very Best R:egards,
>
> Razzak.
>
> https://www.rbase.com
> http://www.facebook.com/rbase/
>
> --
> For group guidelines, visit
> http://www.rbase.com/support/usersgroup_guidelines.php
> ---
> You received this message because you are subscribed to the Google Groups
> "RBASE-L" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to rbase-l+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/rbase-l/0LzuTN-1ksBJS2AzL-015453%40mrelay.perfora.net
> .
>

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/CADeqk-7GpYd2-0oWVz2i2Nt%3D0J0tcVxZhucHUyx9sUV5ai2HoQ%40mail.gmail.com.

Re: [RBASE-L] - My first day in the Home Office (No, not in the British sense!)

[Ken Shapiro]

Fond memories.

On Wed, Mar 25, 2020 at 12:13 PM Bruce Chitiea 
wrote:

> My cat now looks at homebound-me and asks "traffic? What, am I traffic to
> you now?"
>
> Emmitt help me greatly in my early yeaR:s on the list; your posting a
> reminder of the generosity of his soul.
>
> Bruce Chitiea
>
> -- Original Message --
> From: "A. Razzak Memon" 
> To: rbase-l@googlegroups.com
> Sent: 3/25/2020 6:55:03 AM
> Subject: [RBASE-L] - My first day in the Home Office (No, not in the
> British sense!)
>
> To all:
>
> This message is an off topic post from a gone but not forgotten friend to
> the R:BASE Community Emmitt Dove on July 5th, 2006, when working from home
> was more optional than the current environment.
>
> Enjoy this blast from the past!
>
> Razzak
>
> ---
>
> You may not know that today was my first day in my new home office. Being
> the opportunist I am, events at work transpired to make this possible, and
> I jumped at the chance. For those of you who think a home office is a bed
> of roses, consider:
>
> The Awakening
>
> I have one of those "atomic" alarm clocks that set themselves to the Naval
> Observatory and also display the indoor temperature and humidity. For the
> past several years my alarm has been set to 5:45 am. That allows time to
> negotiate two bridges under construction and still make it to work at a
> reasonable hour. So I decided I could take some of that time back.
>
> Well, this clock has four buttons on the back - mode, mem, up arrow and
> down arrow. Intuitive, right? No amount of fidgeting with the blasted thing
> could get me to the set alarm time mode. The reasonable alternative would
> have been to consult the documentation. Oh, but where in blazes is the doc?
> Nowhere I can find it. So I did the logical thing and hopped online, went
> to the manufacturer's website, hit the clock section, went to the
> documentation download page. Now, where is my model? Not there. They have
> online doc for every other clock made in the history of Mankind, but not
> mine.
>
> By this time it is getting late, so I decide to go ahead and hit the sack
> and deal with the clock another time. So could I get to sleep? No, I was to
> busy steaming over a piece of plastic and electronics that had failed to
> yield to my superior efforts. Turn the light back on ... fidget some more
> ... no luck. Light off. Light back on. Off. On. Finally, somewhere after
> midnight, I inadvertently hit some unidentified combination of buttons that
> put me into alarm set mode! For joy!
>
> At 6:15 AM this morning the clock faithfully sprang to life and emitted
> its annoying chirping to wake me up. Off to a good start. After all,
> tonight I can make up the hours of sleep I missed last night fidgeting with
> the blooming clock. Note to self: just plan on awakening at 6:15 for a good
> long time.
>
> Now to get going and get ready ...
>
> The Brief Commute
>
> No, not that kind of brief - I meant quick! I did run into some cat
> traffic between the food dish entrance ramp and the litter box exit.
> However, that was offset by the fact that there was no wife traffic (she's
> up in Newfoundland for a few days). The lack of wife traffic was fortunate,
> since there is only one "rest stop" along the way, and it can get jammed
> with wife traffic. The facility, such as it is, is a one-holer. (Note to
> Southerners: this one-holer is indoor, and has plumbing!) Naturally, wife
> traffic has the right-of-way. I'll have to schedule future commutes around
> this potential log jam.
>
> The weather was nice - incandescent light with a background of filtered
> overcast. Even though it was raining steadily, the road was dry and I
> didn't need my wipers. The temperature was a comfortable 74.3 degrees and
> 61% humidity, according to the aforementioned undocumented electronic clock
> device. A gentle, cool breeze emanated from the east, courtesy of the
> Friedrich Corporation. Indeed, the trip was almost idyllic.
>
> There was no wait at the breakfast place, but the selection was very
> limited. Strangely enough, there was cat traffic here, too. Note to self:
> put groceries on the to-do list.
>
> The coffee joint had just the blend I like, all hot and loaded into an
> insulated mug. Things were looking up, except for the cat traffic.
>
> Even getting up half an hour later and taking the cat congestion into
> account, I still made it to work well ahead of my previous arrivals. As
> before, I arrived before anyone else and had to turn on the lights. But I'm
> accustomed to being first-in, and I really enjoy having some quiet time
> with my coffee, Doonesbury and RBG7-L before the others start showing up.
>
> [later]
>
> Hmmm. Was today a holiday? Where is everyone?
>
> Lunchtime
>
> After a morning of the usual emails and phone calls, noon rolled around.
> So I moseyed over to the local sandwich shop. Again, no wait, but an
> extremely limited selection. Note to self: I really must get to the 

Re: [EXT] Re: [RBASE-L] - Removing embedded spaces from a text string

[Ken Shapiro]

Here is another way:

SET VAR loopcount INTEGER = 0
SET VAR vcount INTEGER = 0
WHILE loopcount <  1000 THEN
  SET VAR loopcount = (.loopcount+1)
  SELECT COUNT(*) INTO vcount FROM sometable +
  WHERE (SLOC(somecolumn,'  '))<>0--two spaces
  IF vcount <> 0 THEN
UPDATE sometable SET somecolumn = (SRPL(somecolumn,'  ',' ',0))
  ELSE
BREAK
  ENDIF
ENDWHILE

On Thu, Jan 16, 2020 at 4:56 PM 'Karen Tellef' via RBASE-L <
rbase-l@googlegroups.com> wrote:

> At one time, the ''  didn't work with SRPL.  I remember that whenever it
> was introduced I knew immediately that I could use that!
>
> Karen
>
>
>
> -Original Message-
> From: mike.ramsour 
> To: rbase-l 
> Sent: Thu, Jan 16, 2020 3:34 pm
> Subject: Re: [EXT] Re: [RBASE-L] - Removing embedded spaces from a text
> string
>
> Just a follow-up to the previous.
>
> I tried the suggested approach and it worked very well.  I did one pass
> through the data looking for 5 spaces and then did one more pass looking
> for 2 spaces.
>
> Command example:  UPDATE TEST_TABLE SET NEW_COMMENTS = (SRPL(COMMENTS,'
>   ','',0)) WHERE COMMENTS LIKE '% %'
>
> Problem solved.
>
> Thank you so much.
>
>
> Mike Ramsour
> AK Steel Coshocton Works
> Quality Department
> Phone:  740-829-4340
> Cell:  740-502-1659
>
>
>
> From:"'Karen Tellef' via RBASE-L" 
> To:rbase-l@googlegroups.com
> Date:01/16/2020 04:16 PM
> Subject:[EXT] Re: [RBASE-L] - Removing embedded spaces from a
> text string
> --
>
>
>
> You can't get SRPL to work? This is what I would do:
>
> set var vtext2 = (SRPL(.vtext, ' ', '', 0))
>
> What that is:  the first part in the quotes I just spaced 5 times.  The
> second part is just two single quotes together with nothing between.
>
> I've done this before with an UPDATE command.  Create another column to
> hold the result and do repeated UPDATEs until there's no more values with
> the extra spaces.  Of course you'd have to have an idea of how many UPDATEs
> you would need to take care of the extra spaces.
>
>
> Karen
>
>
>
>
> -Original Message-
> From: mike.ramsour 
> To: rbase-l 
> Sent: Thu, Jan 16, 2020 1:03 pm
> Subject: [RBASE-L] - Removing embedded spaces from a text string
>
> Good afternoon:
>
> What's the best way to remove embedded spaces from text strings?
>
> I have a column named COMMENTS that contains text prose similar to this:
>
> 'COLD MILL CHATTERVERY LITE'
>
> I want to remove any occurrence of 2 or more spaces in a row so that I end
> up with a value like this:
>
> 'COLD MILL CHATTER VERY LITE'
>
> I have experimented with the various TRIM functions as well as SRPL but
> have not had any success yet.
>
> I'm looking for the same functionality as the TRIM () function in Excel.
>
> Any help is greatly appreciated.
>
> Best regards.
>
> Mike Ramsour
> AK Steel Coshocton Works
> Quality Department
> Phone:  740-829-4340
> Cell:  740-502-1659
> Confidentiality Notice
> This message is intended exclusively for the individual or entity to which
> it is addressed and may contain privileged, proprietary, or otherwise
> private information.
> If you are not the named addressee, you are not authorized to read, print,
> retain, copy or disseminate this message or any part of it. If you have
> received this message in error, please notify the sender immediately by
> e-mail and delete all copies of the message.
> --
> For group guidelines, visit
> *http://www.rbase.com/support/usersgroup_guidelines.php*
> 
> ---
> You received this message because you are subscribed to the Google Groups
> "RBASE-L" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to *rbase-l+unsubscr...@googlegroups.com*
> .
> To view this discussion on the web visit
> *https://groups.google.com/d/msgid/rbase-l/OF633DC4EF.8B6FCEE6-ON852584F1.0067DC43-852584F1.0068B53F%40aksteel.com*
> 
> .
> --
> For group guidelines, visit
> *http://www.rbase.com/support/usersgroup_guidelines.php*
> 
> ---
> You received this message because you are subscribed to the Google Groups
> "RBASE-L" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to *rbase-l+unsubscr...@googlegroups.com*
> .
> To view this discussion on the web visit
> *https://groups.google.com/d/msgid/rbase-l/372186748.14679710.1579209383931%40mail.yahoo.com*
> 
> .
>
> 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 

RE: [RBASE-L] - Tip of the Day: Duplicate a Column Definition with ALTER/CREATE TABLE Commands

[Ken Shapiro]

Andto add to this, the codelock 6 enhancement and fix for a large amount of 
text within the codelocked file.

Regards, Ken

-Original Message-
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Ken Shapiro
Sent: Monday, November 11, 2019 7:49 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Tip of the Day: Duplicate a Column Definition with 
ALTER/CREATE TABLE Commands

Razzak,

Thank you for implementing this R:BASE enhancement from my original suggestion. 
It is a very useful and cool enhancement added to the "arsenal" of great tools 
available in R:BASE.

Best regards,

Ken

On Mon, Nov 11, 2019 at 11:20 AM A. Razzak Memon  wrote:


Monday, November 11, 2019

Tip of the Day: Duplicate a Column Definition with ALTER/CREATE TABLE 
Commands
Product...: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5)
Build.: 10.5.2.1 or higher
Sections..: Commands
Keywords..: ALTER TABLE, CREATE TABLE, DUPLICATE, Column, Definition

Did you know the ALTER TABLE and CREATE TABLE commands were enhanced
to duplicate the definition of a column that already exists in another
table?

The implemented ability will "duplicate" the definition of a column that
already exists in the database in another table. The enhanced syntax 
uses
"DUPLICATE" as a keyword followed by the table and column name, for 
which
the column definition is to be duplicated.

The DUPLICATE keyword will copy the data type, length, any default 
value,
and the NOT NULL flag, if any. It will not support computed columns. It
will also not duplicate any description for the column.

-- ALTER TABLE Example:

ALTER TABLE TSALES_ORDERS +
ADD COLUMN CUST_DESC +
DUPLICATE CUSTOMERS.CUST_DESC

-- CREATE TABLE Example:

CREATE TEMPORARY TABLE Temp1 +
(tEmpID INTEGER, +
  tEmpWebAddr DUPLICATE EMPLOYEE.WEBADDRESS, +
  tEmpStartDate DATE)

The above will create the column tEmpWebAddr with the same type and 
default
value as WEBADDRESS in the EMPLOYEE table.

The enhancement is helpful in ALTER TABLE ... ADD COLUMN situations, to 
be
able to add a column dynamically by creating the column definition from 
the
attributes of a column in another table.

Very Best R:egards,

Razzak.

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

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google 
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send 
an email to rbase-l+unsubscr...@googlegroups.com 
<mailto:rbase-l%2bunsubscr...@googlegroups.com> .
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/20191620.xABGK2pg025893%40atl4mhob25.registeredsite.com.


-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/CADeqk-7gfdO52NAvuyCt%3DsVm5ovUztoHEaNM%3DAO9N1o%2BOQPf5A%40mail.gmail.com
 
<https://groups.google.com/d/msgid/rbase-l/CADeqk-7gfdO52NAvuyCt%3DsVm5ovUztoHEaNM%3DAO9N1o%2BOQPf5A%40mail.gmail.com?utm_medium=email_source=footer>
 .


-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/001b01d598f5%24bd275a60%2437760f20%24%40optonline.net.

Re: [RBASE-L] - Tip of the Day: Duplicate a Column Definition with ALTER/CREATE TABLE Commands

[Ken Shapiro]

Razzak,

Thank you for implementing this R:BASE enhancement from my original
suggestion. It is a very useful and cool enhancement added to the "arsenal"
of great tools available in R:BASE.

Best regards,

Ken

On Mon, Nov 11, 2019 at 11:20 AM A. Razzak Memon  wrote:

> Monday, November 11, 2019
>
> Tip of the Day: Duplicate a Column Definition with ALTER/CREATE TABLE
> Commands
> Product...: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5)
> Build.: 10.5.2.1 or higher
> Sections..: Commands
> Keywords..: ALTER TABLE, CREATE TABLE, DUPLICATE, Column, Definition
>
> Did you know the ALTER TABLE and CREATE TABLE commands were enhanced
> to duplicate the definition of a column that already exists in another
> table?
>
> The implemented ability will "duplicate" the definition of a column that
> already exists in the database in another table. The enhanced syntax uses
> "DUPLICATE" as a keyword followed by the table and column name, for which
> the column definition is to be duplicated.
>
> The DUPLICATE keyword will copy the data type, length, any default value,
> and the NOT NULL flag, if any. It will not support computed columns. It
> will also not duplicate any description for the column.
>
> -- ALTER TABLE Example:
>
> ALTER TABLE TSALES_ORDERS +
> ADD COLUMN CUST_DESC +
> DUPLICATE CUSTOMERS.CUST_DESC
>
> -- CREATE TABLE Example:
>
> CREATE TEMPORARY TABLE Temp1 +
> (tEmpID INTEGER, +
>   tEmpWebAddr DUPLICATE EMPLOYEE.WEBADDRESS, +
>   tEmpStartDate DATE)
>
> The above will create the column tEmpWebAddr with the same type and default
> value as WEBADDRESS in the EMPLOYEE table.
>
> The enhancement is helpful in ALTER TABLE ... ADD COLUMN situations, to be
> able to add a column dynamically by creating the column definition from the
> attributes of a column in another table.
>
> Very Best R:egards,
>
> Razzak.
>
> https://www.rbase.com
> http://www.facebook.com/rbase/
>
> --
> For group guidelines, visit
> http://www.rbase.com/support/usersgroup_guidelines.php
> ---
> You received this message because you are subscribed to the Google Groups
> "RBASE-L" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to rbase-l+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/rbase-l/20191620.xABGK2pg025893%40atl4mhob25.registeredsite.com
> .
>

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/CADeqk-7gfdO52NAvuyCt%3DsVm5ovUztoHEaNM%3DAO9N1o%2BOQPf5A%40mail.gmail.com.

Re: [RBASE-L] - Tip of the Day: New LAG and LEAD Analytic Functions for SELECT Commands

[Ken Shapiro]

Razzak,

Cool stuff on the two analytical functions. They enable a class of problem
solving in sql that’s otherwise more difficult.

On Thu, Feb 14, 2019 at 8:04 AM A. Razzak Memon  wrote:

> Thursday, February 14, 2019
>
> Tip of the Day: New LAG and LEAD Analytic Functions for SELECT Commands
> Product...: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5)
> Build.: 10.5.1.30214 or higher
> Sections..: Functions
> Keywords..: SELECT, LAG, LEAD, Analytic
>
> Did you know two analytical functions, LAG and LEAD, have been implemented
> for SELECT statements?
>
> The LAG and LEAD analytical functions can be use to specify more than one
> row in a table at a time without having to join the table to itself.
>
> LAG accesses data from a previous row in the same result set. LAG provides
> access to a row at a given physical offset that comes before the current
> row. Use this analytic function in a SELECT statement to compare values in
> the current row with values in a previous row.
>
> LEAD accesses data from a next row in the same result set. LEAD provides
> access to a row at a given physical offset that comes after the current
> row. Use this analytic function in a SELECT statement to compare values
> in the current row with values in a next row.
>
> Example 01:
> The following example uses the LAG function to compare prior sales between
> California companies. The PARTITION BY clause is specified to divide the
> rows in the result set by company. The ORDER BY clause in the OVER clause
> orders the rows in each partition. Notice that because there is no lag
> value available for the first row, and where a single purchases exists,
> the default of zero ($0.00) is returned.
>
> SELECT BillToCompany, TransDate,  NetAmount, +
>LAG(NetAmount,1,0) AS PrevAmount +
>OVER (PARTITION BY BillToCompany ORDER BY TransDate) +
>FROM InvoiceHeader WHERE BillToState = 'CA'
>
>   BillToCompanyTransDate  NetAmount PrevAmount
>    -- ---
> ---
>   Compumasters Computer
> Supply 01/17/2018   $7,775.00   $0.00
>   Compumasters Computer
> Supply 03/01/2018   $3,080.00   $7,775.00
>   Compumasters Computer
> Supply 06/12/2018   $8,955.00   $3,080.00
>   Compumasters Computer
> Supply 10/12/2018   $4,308.00   $8,955.00
>   Compumasters Computer
> Supply 11/13/2018   $3,512.00   $4,308.00
>   Compumasters Computer
> Supply 12/01/2018   $1,615.50   $3,512.00
>   Compumasters Computer
> Supply 12/22/2018  $20,852.50   $1,615.50
>   Industrial Concepts
> Inc. 05/01/2018   $4,477.50   $0.00
>   Johnson
> Technologies 05/02/2018   $1,881.00   $0.00
>   Open Systems
> I/O 07/06/2018   $2,390.00   $0.00
>   PC Consultation And
> Design   07/07/2018   $9,450.00   $0.00
>   PC Consultation And
> Design   07/15/2018   $2,772.00   $9,450.00
>
> Example 02:
> The following example uses the LEAD function to compare employee sales
> variations for the first quarter. The ORDER BY clause in the OVER clause
> orders the last names in each date partition.
>
> SELECT TransDate,(EmpFName)=20,NetAmount, +
>LEAD(NetAmount,1,0) AS NextAmount +
>OVER (PARTITION BY TransDate ORDER BY EmpLName) +
>FROM SalesByEmployee WHERE (IMON(TransDate)) < 4
>
>   TransDate  (EmpFName)  NetAmount   NextAmount
>   --  --- ---
>   01/05/2018 Peter Coffin  $17,560.00  $13,941.00
>   01/05/2018 Ernest Hernandez  $13,941.00 $895.50
>   01/06/2018 John Chow$895.50  $13,572.00
>   01/14/2018 Ernest Hernandez  $13,572.00  $19,755.00
>   01/15/2018 Joe Donohoe   $19,755.00   $7,775.00
>   01/17/2018 Peter Coffin   $7,775.00   $4,508.75
>   01/22/2018 Joe Donohoe$4,508.75   $1,975.50
>   01/22/2018 Ernest Hernandez   $1,975.50   $8,616.00
>   01/23/2018 Sam Donald $8,616.00  $15,551.00
>   01/23/2018 Ernest Hernandez  $15,551.00   $4,972.50
>   01/23/2018 John Smith $4,972.50   $1,672.00
>   02/01/2018 Peter Coffin   $1,672.00  $16,155.00
>   02/01/2018 Sam Donald$16,155.00   $3,231.00
>   02/26/2018 Peter Coffin   $3,231.00   $3,080.00
>   03/01/2018 Sam Donald $3,080.00   $7,024.00
>   03/01/2018 John Smith $7,024.00   $7,182.00
>   03/09/2018 Joe Donohoe$7,182.00   $2,772.00
>   03/10/2018 John Smith $2,772.00   $4,158.00
>   03/20/2018 Mary Simpson   $4,158.00   $7,392.00
>  

RE: RE: [RBASE-L] - Date Chooser Dialog?

[Ken Shapiro]

Paste the command into an empty rbase editor window. Add ‘return’ at the end, 
and then use r:style to check the syntax.

 

Ken

 

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Kayza Kleinman
Sent: Wednesday, April 18, 2018 11:28 PM
To: rbase-l@googlegroups.com
Subject: RE: RE: [RBASE-L] - Date Chooser Dialog?

 

It looks great, but I keep on getting “syntax error”. I have RDocs, and tried 
using the template that it gave me and I’m still getting a syntax error. That’s 
the whole message.

 

 

Kayza Kleinman

Director of the Nonprofit Helpdesk 

CIO

Jewish Community Council of Greater Coney Island, Inc

www.jccgci.org  

www.nphd.org  

 

From: 'James Bentley' via RBASE-L [mailto:rbase-l@googlegroups.com] 
Sent: Wednesday, April 18, 2018 10:18 AM
To: rbase-l@googlegroups.com
Subject: Re: RE: [RBASE-L] - Date Chooser Dialog?

 

Also, consider the use of DIALOG command. Here is example from RBase help.

DIALOG 'Enter Date to Browse:' vBrowseDate=26 vEndKey 1 +

CAPTION 'Enter Date' +

ICON APP +

OPTION DIALOG_EDIT_HINT 'Double-Click for Calendar' +

|POPUP_ENABLED TRUE +

|POPUP_DIALOG_TYPE DATE +

|POPUP_CALENDAR_BACK_COLOR SILVER +

|POPUP_CALENDAR_DAYS_COLOR RED +

|POPUP_CALENDAR_FILLDAYS_COLOR NAVY +

|POPUP_CALENDAR_DAYSOFWEEK_COLOR  +

|POPUP_CALENDAR_LINES_COLOR BLACK +

|POPUP_CALENDAR_SELBACK_COLOR NAVY +

|POPUP_CALENDAR_SELFORE_COLOR WHITE +

|POPUP_CALENDAR_TODAYFRAME_COLOR RED

 

 

 

Jim Bentley, American Celiac Society 1-504-305-2968

 

 

On Tuesday, April 17, 2018, 11:19:09 PM CDT, Kayza Kleinman 
 wrote: 

 

 

Thanks!

 

This is perfect.

 

 

Kayza Kleinman

Director of the Nonprofit Helpdesk 

CIO

Jewish Community Council of Greater Coney Island, Inc

www.jccgci.org  

www.nphd.org  

 

From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com] 
Sent: Tuesday, April 17, 2018 9:34 AM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Date Chooser Dialog?

 

If you want a calendar, do this:

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

Karen

 

 

 

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

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

Thanks!

 

 

Kayza Kleinman

Director of the Nonprofit Helpdesk 

CIO

Jewish Community Council of Greater Coney Island, Inc

3001 West 37th Street

Brooklyn NY 11224

718 449-5000 x 2266

fax 347-946-6390 

  www.jccgci.org

  www.nphd.org

 

 

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

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

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

RE: [RBASE-L] - Tip of the Day: Full Feature Magnifying Glass Utility

[Ken Shapiro]

Razzak,

I have to say the magnifying glass has turned into a cool, useful feature.

Thank you!

-Original Message-
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
A. Razzak Memon
Sent: Wednesday, November 15, 2017 7:08 AM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - Tip of the Day: Full Feature Magnifying Glass Utility

Wednesday, November 15, 2017

Tip of the Day: Full Feature Magnifying Glass Utility
Product...: R:BASE X and R:BASE X Enterprise (Version 10)
Build.: 10.0.3.4 or higher
Section...: Utilities
Keywords..: Magnifying Glass, Zoom, Magnification

Did you know that the Magnifying Glass utility has been improved with easier 
zoom, increased magnifier size support, and mouse cursor tracking?

The Magnifying Glass utility displays a magnifier lens that produces an 
enhanced display of any area on the monitor. To launch the Magnifying Glass, 
select the option under "Utilities"
on the main Menu Bar. It can also be launched using the [Ctrl+Alt+M] hot key 
combination.

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

It is now easier to increase/decrease the magnification of areas with the 
magnifying glass using the [Ctrl]+ combination.

The Magnifying Glass also includes a "Follow Mouse Cursor" option when right 
clicking upon the magnifier. When checked, the magnifier will magnify the area 
around the mouse, wherever the mouse is. The magnifier can be placed in the 
bottom left so it is out of the work area and not interfere with the designer. 
This is useful when editing forms/reports with controls very close to each 
other.

The utility has an increased maximum height and width, along with persistent 
position and size.

The Magnifying Glass makes it easier for users to meticulously review all 
aspects of form and report design.

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] - Training R:BASE Elite in Asia (September 2017)

[Ken Shapiro]

Looked like an informative blast.
-Original Message-
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
A. Razzak Memon
Sent: Saturday, September 16, 2017 8:11 PM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - Training R:BASE Elite in Asia (September 2017)

Having fun in Phuket, Thailand (Training R:BASE Elite in Asia (September 2017)

http://www.razzak.com/training/001.jpg
http://www.razzak.com/training/002.jpg
http://www.razzak.com/training/003.jpg
http://www.razzak.com/training/004.jpg
http://www.razzak.com/training/005.jpg

http://www.facebook.com/rbase

Very Best R:egards,

Razzak


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

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

Re: [RBASE-L] - count updates, save excel file

[Ken Shapiro]

HI Chaya,

Welcome. :)

Ken

On Thu, May 25, 2017 at 5:02 PM, Chaya Goldberg 
wrote:

> Thanks, Karen and Bill!  I will try the suggestions.
>
>
>
> *From:* bdown...@downallconsulting.com [mailto:bdownall@
> downallconsulting.com] *On Behalf Of *Bill Downall
> *Sent:* Thursday, May 25, 2017 4:22 PM
> *To:* rbase-l@googlegroups.com
> *Subject:* Re: [RBASE-L] - count updates, save excel file
>
>
>
> Chaya,
>
>
>
> Welcome.
>
>
>
> For #1:
>
>
>
> SET VAR vUpdatesCounted INTEGER = NULL
>
> SET FEEDBACK ON
>
> UPDATE tablename 
>
> SET VAR vUpdatesCounted = .RBTI_RowsUpdated
>
>
>
>
>
> Bill
>
>
>
> On Thu, May 25, 2017 at 4:12 PM, Chaya Goldberg 
> wrote:
>
> Hi, thanks for this list.  It’s my first time writing in.
>
> I have two questions:
>
> 1.  Is there a way to get a count of updated records?  I have a SQL
> UPDATE statement and would like to display a message with the count of
> updates.  Right now I’m counting the fields in a temporary table – which
> works, but is not 100% accurate, in that it’s counting pending updates and
> not actual updates.  Is there a way to directly count the updates?
>
> 2.  I’m doing a gateway export into excel.  Is there a way to
> automatically save the generated excel document in a predetermined location?
>
> Thanks,
> Chaya
>
>
> Chaya Goldberg
> Omni Childhood Center
> (718) 998-1415 ext. 103 <%28718%29%20998-1415%20%20ext.%20103>
> cgoldb...@omnirehab.com
> ___
> Confidentiality Notice: This e-mail communication and any attachments may
> contain confidential and privileged information for the use of the
> designated recipients named above. If you are not the intended recipient,
> you are hereby notified that you have received this communication in error
> and that any review, disclosure, dissemination, distribution or copying of
> it or its contents is prohibited. If you have received this communication
> in error, please notify me immediately by replying to this message and
> deleting it from your computer.
>
> --
> You received this message because you are subscribed to the Google Groups
> "RBASE-L" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to rbase-l+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>
>
>
> --
> You received this message because you are subscribed to the Google Groups
> "RBASE-L" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to rbase-l+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>
> --
> You received this message because you are subscribed to the Google Groups
> "RBASE-L" group.
> To unsubscribe from this group and 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] - Unique or NULL

[Ken Shapiro]

There might be another way without creating another table.

 

Create an autonum column on said table, call this column “pk”.

 

Create a computed column with a unique index with the following calculation:

 

Ifnull(column to be tested, pk, column to be tested)

 

If column to be tested is a date or other non-numeric data type:

 

Ifnull(ctxt(column to be tested), ctxt(pk), ctxt(column to be tested))

 

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Stephen Markson
Sent: Friday, May 06, 2016 11:48 AM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - Unique or NULL

 

Thanks, Larry. Very helpful.

 

I avoid R:Base RULEs completely, but, you're right, choice #2 is correct!

 

 

Regards,

 

Stephen Markson

The Pharmacy Examining Board of Canada

416.979.2431 x251

 

From: 'Lawrence Lustig' via RBASE-L [mailto:rbase-l@googlegroups.com] 
Sent: May-06-16 10:51 AM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Unique or NULL

 

What is the best way to implement a column that can be null, but if not null, 
must be unique?

 

 

This cannot be accomplished through the standard SQL constraint mechanism.  
UNIQUE columns cannot be NULL.

 

You have two choices:

 

1. Use a RULE.  This is R:Base specific and not foolproof since RULEs can be 
turned ON or OFF.  This may be an advantage or a disadvantage in your 
situation.  This is probably the easiest solution (especially if the column 
already exists) as long as you're okay with running with RULES ON most of the 
time.

 

2. Move the unique-if-not-NULL column to a separate table, linked back to the 
main table by a PK/FK relationship.  Create a UNIQUE index on the column in the 
new table.  This uses only standard SQL features and, if properly setup, cannot 
be worked-around.  If there is additional data associated with the 
unique-if-not-NULL identifier (dates, scores, etc) then this is definitely the 
"correct" solution.

 

--

Larry

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

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

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