[RBASE-L] - Update: R:BASE Technologies 25th Anniversary Conference and Hotel Reservations

[A. Razzak Memon]

To all those planning on attending the R:BASE Technologies 25th 
Anniversary Conference and SAT:


All previously booked blocks of room at the negotiated rate are now 
reserved. The hotel management has been kind enough to provide some 
additional rooms for interested attendees.


Please be advised that the rooms are limited, and the rate will be 
honored on a first-come, first-served basis.


For the conference and hotel registrations, please use the URL as follows:

https://www.rbase.com/25thAnniversary

Very Best R:egards,

Razzak

A. Razzak Memon
Founder, President & CEO
R:BASE Technologies, Inc.
https://www.rbase.com
/*Celebrating the 25th Anniversary of R:BASE Technologies, Inc.*//*
*/

--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google 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/75544257-631e-3231-953a-333a2f199f1a%40rbase.com.

[RBASE-L] - Announcing the R:BASE 11 Beta

[A. Razzak Memon]

Monday, August 21, 2023 11:00 AM EST

Dear R:BASE Community,

We are pleased to announce that the R:BASE 11 Beta is available!

After years of work with modern development environments and components, 
R:BASE 11 is finally here.


R:BASE 11 is the new major release from R:BASE Technologies showcasing 
the latest advances for your databases and applications.


The R:BASE development team has meticulously honed R:BASE 11 to combine 
pure performance and high-tech features with a practical interface for 
users of all levels.


R:BASE 11 users can achieve peak productivity to overachieve, 
outperform, and over-deliver on data management goals.


https://www.rbase.com/rbg11

The R:BASE 11 Beta is a test, but stable version of the 
soon-to-be-released product, with 100% working features, ready for your 
daily use.


How do you get your hands on the beta? Well, it's waiting for you right 
now!


The R:BASE 11 Beta is available to all R:BASE X.5 users and R:BASE X.5 
Enterprise with active software support directly at the R:BASE Updates 
Web site.


https://www.rbaseupdates.com

The R:BASE 11 Beta is only available to R:BASE X.5/X.5 Enterprise 
(Version 10.5) users, as the beta release will temporarily accept your 
R:BASE Version 10.5 License Key.


We value your feedback and help in testing this early version of R:BASE. 
If you want to report anything you find or tell us what you think, 
please use the R:DCC Client from the Help option on the main menu bar.


For 41 years and counting, R:BASE has been advancing the standards it 
pioneered in the first place. And after 41 laps around the sun, we're 
not slowing down.


Razzak

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

/Celebrating the 25th Anniversary of R:BASE Technologies, Inc./

/
/

/
/

/
/

--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google 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/867f7341-95e8-e340-508b-aa5377087dfa%40rbase.com.

Re: [RBASE-L] - Getting out of an infinite loop

[A. Razzak Memon]

Philippe,

Also, be sure to have ESCAPE set to ON.

Syntax: SET ESCAPE ON/OFF

SET ESCAPE allows you to use [Ctrl]+[Break] to escape or abort command 
file processing or database file access.


Specify ON to enable users to abort processing in the middle of command 
files, WHILE loops, and database access.


Specify OFF to prevent users from prematurely aborting a command file or 
an application such as when R:BASE runs processes that create new tables 
(such as the relational commands) from within a command.


Very Best R:egards,

Razzak

https://www.rbase.com
/Celebrating the 25th Anniversary of R:BASE Technologies, Inc.


/
On 8/15/2023 10:29 PM, 'Philippe Gosselin' via RBASE-L wrote:


I found a way to disconnect users due to an end of task. You also have 
to terminate the processes in the background for R:Base.


Best regards,

*Philippe Gosselin*

General manager

p...@canl.nc 

BP 3899 - 98846 Noumea – New Calédonia

Tel : +687 27.62.23 / Mobile : +687 77.15.76

*De :* 'Karen Tellef' via RBASE-L 
*Envoyé :* mardi 15 août 2023 00:57
*À :* 'Philippe Gosselin' via RBASE-L 
*Objet :* Re: [RBASE-L] - Getting out of an infinite loop

If you cannot connect the database single-user as Razzak suggests, 
trying ending the RBase session and then restarting your computer or 
just logging off.  Often the computer shutdown sequence will clear the 
files that you have "open" even tho they really aren't


Karen

On Sunday, August 13, 2023 at 08:49:15 PM CDT, 'Philippe Gosselin' via 
RBASE-L  wrote:


Hi,

Can you tell me how to get out of an infinite loop or a process that’s 
taking too much time?


Right now, I end the task using windows. The problem is that when I 
re-enter R:Base, a new user is added. How do I reset the number of users?


Thanks,

*Philippe*

p...@canl.nc 

BP 3899 - 98846 Noumea – New Caledonia

Tel : +687 27.62.23 / Mobile : +687 77.15.76

--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php

---
You received this message because you are subscribed to the Google 
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/01d9ce51%241e700170%245b500450%24%40canl.nc 
.


--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php

---
You received this message because you are subscribed to the Google 
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/231217270.632271.1692021420430%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/001201d9cfe9%2477e55c70%2467b01550%24%40canl.nc 
.


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

Re: [RBASE-L] - Getting out of an infinite loop

[A. Razzak Memon]

Philippe,

There is no easy way to terminate an infinite WHILE .. ENDWHILE loop or 
a process that takes too much time. Ending the task using the Task 
Manager is the only way to end the session.


About resetting the number of users, without having the RBAdmin Tools, 
here is one approach.


1. Start RBGX5E
2. At the R> Prompt:
 * SET MULTI OFF
 * CONNECT dbname
 * LIST
 * Notice the ...
 o Number of users connected: 1.
 * DISCONNECT
 * EXIT

I hope it helps!

Very Best R:egards,

Razzak

https://www.rbase.com
/Celebrating the 25th Anniversary of R:BASE Technologies, Inc.//
/


On 8/13/2023 9:46 PM, 'Philippe Gosselin' via RBASE-L wrote:


Hi,

Can you tell me how to get out of an infinite loop or a process that’s 
taking too much time?


Right now, I end the task using windows. The problem is that when I 
re-enter R:Base, a new user is added. How do I reset the number of users?


Thanks,

*Philippe*

p...@canl.nc 

BP 3899 - 98846 Noumea – New Caledonia

Tel : +687 27.62.23 / Mobile : +687 77.15.76

--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php

---
You received this message because you are subscribed to the Google 
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/01d9ce51%241e700170%245b500450%24%40canl.nc 
.


--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google 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/0a930b04-09f4-fd73-30b5-d6a92b0855d6%40rbase.com.

[RBASE-L] - R:BASE Technologies 25th Anniversary Conference Registration

[A. Razzak Memon]

To R:BASE Community:

Join us in celebrating our monumental milestone!

R:BASE Technologies 25th Anniversary Conference Registration portal is 
now ready.


https://www.rbase.com/25thAnniversary/

We are celebrating our success and the relationships with our customers 
around the globe, without whom there wouldn’t even be a milestone to 
celebrate!


Very Best R:egards,

Razzak Memon

Founder, President & CEO
R:BASE Technologies, Inc.
http://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/187a6ddc-2777-66d9-612a-7b6bf8c421d8%40rbase.com.

[RBASE-L] - R:BASE Conference Topics: Embrace R:BASE Applications or your entire business on the cloud!

[A. Razzak Memon]

To R:BASE Community:

/*Embrace R:BASE Applications or your entire business on the cloud!*//*

*//When deploying R:BASE applications on the cloud, you must consider 
new delivery methods in infrastructure, such as virtualization, 
declarative/immutable containers, serverless computing, configuring 
remote S3 backups,  etc.//

/
That would be among the topics at the 25th Anniversary of R:BASE 
Technologies Conference on Wednesday, October 25, 2023, in Las Vegas!


Please stay tuned for conference registration and complete details.

Very Best R:egards,

Razzak

/*Celebrating 25th Anniversary of R:BASE Technologies*//*
*/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/66af05f9-6933-3947-6286-8262c11810f2%40rbase.com.

[RBASE-L] - Update: R:BASE Technologies 25th Anniversary Conference (Hotel Reservations)

[A. Razzak Memon]

To R:BASE Community:


Here is the URL to make your hotel reservations for R:BASE Technologies 
25th Anniversary Conference:



https://www.hilton.com/en/book/reservation/deeplink/?ctyhocn=LASESES=CES90Q=2023-10-24=2023-10-28=OM,WW,HILTONLINK,EN,DirectLink=HILTONLINKDIRECT 




We have reserved a block of rooms with a negotiated rate for the 
conference. Please be advised that the rooms are limited, and the rate 
will be honored on a first-come, first-served bases.



Please stay tuned for conference registration details.


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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/2e2dc576-402e-1254-b772-e0a4069551e9%40rbase.com.

[RBASE-L] - Tip of the Day: Redraw an Enhanced DB Grid Control

[A. Razzak Memon]

Tuesday, June 20, 2023

Tip of the Day: Redraw an Enhanced DB Grid Control
Product...: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5)
Build.: 10.5.5.20615 or higher
Sections..: Forms
Keywords..: Enhanced DB Grid, PROPERTY, Redraw

Did you know that you can redraw an Enhanced DB Grid after performing an 
update to the data records?


The new "REDRAWGRID" PROPERTY command parameter was introduced to redraw 
an Enhanced DB Grid control.


  PROPERTY EnhancedDBGrid1 REDRAWGRID ' '

The redraw would be performed after an update is made, without having to 
close the form!


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/b58f17d2-9971-959c-1e52-3409bf3538b7%40rbase.com.

[RBASE-L] - Tip of the Day: Specify the Root Node Path with JSON Imports

[A. Razzak Memon]

Monday, June 19, 2023

Tip of the Day: Specify the Root Node Path with JSON Imports
Product...: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5)
Build.: 10.5.5.20615 or higher
Sections..: File Gateway
Keywords..: Import, JSON, Root Node, NODE_PATH

Did you know that it is now possible to set the node path to the root 
for JSON imports?


When importing JSON format data, the NODE_PATH parameter may be used to 
set the node path to the root with a backslash character.


The change is applicable to JSON files where only the data row items are 
in the file.


  GATEWAY IMPORT JSON CustResponse.json +
  REPLACE CustResponse +
  OPTION NODE_PATH \

In the above command, the NODE_PATH parameter is set to a backslash, 
meaning the root.


If an unexpected format is detected, a "JSON To Data Packet" utility 
will be displayed. The valid node must be selected which contains the 
collection of rows. However, R:BASE will not prompt the user if the 
NODE_PATH parameter is used.


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/1c515ac4-c7e6-7056-6f4f-326ae8f360b6%40rbase.com.

[RBASE-L] - Tip of the Day: WHERE Clause Support for the SATTACH Command

[A. Razzak Memon]

Thursday, June 15, 2023

Tip of the Day: WHERE Clause Support for the SATTACH Command
Product...: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5)
Build.: 10.5.5.20615 or higher
Sections..: Commands
Keywords..: SATTACH, ODBC, WHERE Clause, Server, Table

Did you know that the SATTACH command was enhanced to allow a WHERE 
clause to be specified with the syntax?


You can now limit the rows of table data being attached from a SQL data 
source to a R:BASE database.


The following example attaches a SQL data source table, using an alias 
name for the table, and specifies a WHERE clause for limited results:


  SATTACH Artists AS tArtists WHERE ALastName = 'Ford'

It is also helpful to know how R:BASE and the foreign data source handle 
the data when a WHERE is specified with a SQL data source table.


When using the SATTACH command, the WHERE clause is sent to the 
SATTACHed database.


If an additional WHERE is used on that table, the processing of that 
additional WHERE is done in the R:BASE engine after the SATTACHed table 
has returned rows that only meet the original WHERE clause. The 
SATTACHed table does the original WHERE, and the R:BASE engine does the 
additional one.


Below, the SATTACH with "NY" in the WHERE clause is processed by the 
SATTACHed table. The SELECT with "Comp%" in the WHERE clause is 
processed by the R:BASE engine.


  SATTACH TEMPORARY Customer AS QBCustomer USING ONLY ListID, Name +
  ALIAS QBCustomerListID, QBCustomerName WHERE Name LIKE '% - NY'

  SELECT * FROM QBCustomer WHERE QBCustomerName LIKE 'Comp%'

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/23f63930-70de-377f-bcdb-cbc3b4610b21%40rbase.com.

[RBASE-L] - Released: Add-on Products for R:BASE X.5/X.5 Enterprise (Version 10.5)

[A. Razzak Memon]

Thursday, June 15, 2023

To All Users of R:BASE X.5 and R:BASE X.5 Enterprise Add-on Products:

Updates are now available for the following add-on products for R:BASE 
X.5 and R:BASE X.5 Enterprise (Version 10.5):


https://www.rbaseupdates.com

Build: 10.5.5.20615 - Update 5

. Oterro X.5 and Oterro X.5 Enterprise
. R:Scope X.5 and R:Scope X.5 Enterprise
. R:BASE Editor X.5
. R:Docs X.5

This is a FREE update for all registered users who are within one year 
of their purchase or are active R:SAP subscribers for their licensed 
product.


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/5c6f4d78-762e-bbfa-2507-90cb9fcd7448%40rbase.com.

[RBASE-L] - Released: R:BASE X.5/X.5 Enterprise (Version 10.5) - Update 5

[A. Razzak Memon]

Thursday, June 15, 2023

To All Users of R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5):

Official updates of R:BASE X.5/R:BASE X.5 Enterprise (Version 10.5) are 
now available.


https://www.rbaseupdates.com

Build: 10.5.5.20615 - Update 5

. R:BASE X.5 (Version 10.5)
. R:BASE X.5 (Version 10.5) - Corporate
. R:BASE X.5 (Version 10.5) - Compiler
. R:BASE X.5 (Version 10.5) - Runtime
. R:BASE X.5 Enterprise (Version 10.5)
. R:BASE X.5 Enterprise (Version 10.5) - Corporate
. R:BASE X.5 Enterprise (Version 10.5) - Compiler
. R:BASE X.5 Enterprise (Version 10.5) - Runtime

This Update 5, Build: 10.5.5.20615, includes a total of 19 enhancements 
and 86 reported bug fixes.


Refer to the WhatsNewInRBASE_X5_Update05.pdf document for complete details.

This is a FREE update for all registered users of R:BASE X5/X5E who are 
within one year of their purchase or are active R:SAP subscribers.


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/fec5ad7f-8418-f4c6-113d-674f1e6e5c76%40rbase.com.

Re: [RBASE-L] - Minimize button not showing

[A. Razzak Memon]

Dan,

What "Border Style" is assigned within the Form > Properties setting?

Try to use another value, such as Single.

Best regards,

Razzak

On 5/31/2023 1:10 PM, Dan Goldberg wrote:


I have a startup compiled exe that has my settings and then runs my 
external form file.


REFF lance_menu.rff

This works okay but I cannot get the minimize button to show. I have 
set it in the form properties.


**

**

*But when it runs they are not there.*

**

It looks like a theme is applied but it is turned off.

Any ideas on how to bring them back?

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/BY3PR19MB5027BB24A48447243C84ED1DD4489%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/8004a8c5-a355-50a8-47a9-b2c23473cfc5%40rbase.com.

RE: [RBASE-L] - Runtime error

[A. Razzak Memon]

Make sure that the engine .DLL is in the same folder with the database and the compiled exe. Hope that provides you with some blue's clues. RazzakOn Mar 25, 2023 6:06 PM, Javier Valencia  wrote:Is it a compiled application? Is the application and database on the local drive or a server?Javier Valencia, PESent from my T-Mobile 4G LTE Device Original message From: Tom Hart  Date: 3/25/23  6:41 PM  (GMT-06:00) To: rbase-l@googlegroups.com Subject: [RBASE-L] - Runtime error Have an application that runs fine on every computer except a new Dell, when I try to run the app I getRuntime error 216 at 00404DCAwhat's the deal?Tom Hart



-- 
For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/CABX9BNeZhQBk%3DbTvEnNSV%2BWSfTGGkqkO_50vzt4xRXbwbQzKgw%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+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/E1pgEpg-006HsQ-PG%40server126.web-hosting.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/a11b5e17-0f39-4f33-992f-28fdad5e4382%40email.android.com.

[RBASE-L] - Tip of the Day: Added Hot Key Support for Enhanced DB Grid Searches

[A. Razzak Memon]

Friday, March 10, 2023

Tip of the Day: Added Hot Key Support for Enhanced DB Grid Searches
Product...: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5)
Build.: 10.5.5.20309 or higher
Sections..: Forms
Keywords..: Enhanced DB Grid, Hot Key, Find, Find Previous, Find Next

Did you know that "Find Previous" hot key support has been implemented 
for Enhanced DB Grid searches?


Using the [Shift+F3] key combination, the "Find Previous" search will be 
performed.


The Enhanced DB Grid supports record search capabilities that can be 
launched while running the form.


To search for text within Enhanced DB Grids, the [Ctrl+F] key 
combination displays the "Record Search" dialog.


When matches are found, the [F3] key will perform the "Find Next" 
search. Then, the [Shift+F3] key combination will perform the "Find 
Previous" search.


A progress dialog will be displayed during the search process, so the 
user is informed that the search is working!


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/9d216b83-e9f1-9fc0-51b0-0625e74e5e0d%40rbase.com.

[RBASE-L] - Tip of the Day: Traversing Sub-Directories in the File List Box Control

[A. Razzak Memon]

Thursday, March 09, 2023

Tip of the Day: Traversing Sub-Directories in the File List Box Control
Product...: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5)
Build.: 10.5.5.20309 or higher
Sections..: Forms
Keywords..: File List Box, Sub-Directory, Files, Directory

Did you know that sub-directory support was added to the File List Box 
control?


It is now possible to view and traverse sub-directories when listing 
files in the File List Box. The control was also updated to provide a 
'..' entry within the list box, to move one directory up.


To specify that directories are listed within the control, select the 
File List Box on the form, then within the Object Inspector, alter the 
FileType.ftDirectory option to True.


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/8d60c126-9dab-e5ad-4017-aa10654bfffe%40rbase.com.

[RBASE-L] - Released: Add-on Products for R:BASE X.5/X.5 Enterprise (Version 10.5)

[A. Razzak Memon]

Thursday, March 09, 2023

To All Users of R:BASE X.5 and R:BASE X.5 Enterprise Add-on Products:

Updates are now available for the following add-on products for R:BASE 
X.5 and R:BASE X.5 Enterprise (Version 10.5):


https://www.rbaseupdates.com

Build: 10.5.5.20309 - Update 5

. Oterro X.5 and Oterro X.5 Enterprise
. R:Mail X.5
. R:Mail Editor X.5
. RBAdmin X.5 and RBAdmin X.5 Enterprise
. R:Twain2PDF X.5
. R:Dependency ViewerX.5 and R:Dependency ViewerX.5 Enterprise
. R:BASE Editor X.5
. R:Docs X.5

This is a FREE update for all registered users who are within one year 
of their purchase or are active R:SAP subscribers for their licensed 
product.


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/35d0d34c-fed0-013d-befa-58df928627ae%40rbase.com.

[RBASE-L] - Released: R:BASE X.5/X.5 Enterprise (Version 10.5) - Update 5

[A. Razzak Memon]

Thursday, March 09, 2023

To All Users of R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5):

Official updates of R:BASE X.5/R:BASE X.5 Enterprise (Version 10.5) are 
now available.


https://www.rbaseupdates.com

Build: 10.5.5.20309 - Update 5

. R:BASE X.5 (Version 10.5)
. R:BASE X.5 (Version 10.5) - Corporate
. R:BASE X.5 (Version 10.5) - Compiler
. R:BASE X.5 (Version 10.5) - Runtime
. R:BASE X.5 Enterprise (Version 10.5)
. R:BASE X.5 Enterprise (Version 10.5) - Corporate
. R:BASE X.5 Enterprise (Version 10.5) - Compiler
. R:BASE X.5 Enterprise (Version 10.5) - Runtime

This Update 5, Build: 10.5.5.20309, includes a total of 14 enhancements 
and 71 reported bug fixes.


Refer to the WhatsNewInRBASE_X5_Update05.pdf document for complete details.

This is a FREE update for all registered users of R:BASE X5/X5E who are 
within one year of their purchase or are active R:SAP subscribers.


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/af2012ab-24c7-fbd8-7c31-d1bb352e9ed4%40rbase.com.

Re: [RBASE-L] - Filename COPY, and the persistent date/time stamp

[A. Razzak Memon]

Bruce,

Change your Windows File Explorer View properties to see the Date 
created and Date modified columns to see the difference.



Very Best R:egards,

Razzak

On 2/13/2023 5:48 PM, Bruce Chitiea wrote:

All:

Consider a file displayed in the RGBX5E Command file listing:

*template.rmd | 02/12/2023 | 13:40*

On Monday, Feb 13, at 12:00, use the COPY command within an EEP to 
make a copy:


*COPY template.rmd showtime.rmd*

Now, in the file listing, see:

*template.rmd | 02/12/2023 | 13:40*
*showtime.rmd | 02/12/2023 | 13:40*

... the date/time stamp does not change.

Is there a native R:BASE command/function set which will update 
*showtime.rmd*'s date/time stamp? (Oh, I've been looking.) Or am I off 
to to LAUNCHing Windows' Powershell?


Thanks much, Bruce



--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google 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/6265a4bb-af01-0dc5-bbf4-bad38817fe16%40rbase.com.

Re: [RBASE-L] - Displaying SWF pictures

[A. Razzak Memon]

Javier,

Though IE is no longer supported and appears to be removed from the 
system, it is still there. The issue is whether the ActiveX control that 
is supposed to read the SWF file is installed. In RBASE, an IE session 
may be started in the browser control. The browser control has an option 
on whether to use IE or Edge as the engine.


Another approach is to import the SWF ActiveX control to RBASE as a 
control (if present in the system). Then load the SWF using that 
imported ActiveX control.


If the SWF reader is not present, then you can't do much about it. Adobe 
Flash is long gone.


Regarding a way to globally remove the design password from all forms, 
you may contact the support and services team at R:BASE Technologies for 
such special service.


Hope it helps!

Very Best R:egards,

Razzak

On 2/8/2023 11:28 PM, javier.valen...@vtgonline.com wrote:


I am working on an older application that uses SWF pictures generated 
by an external application that is run from line command. In the pasts 
I just placed a web browser in the form, and it displayed the SWF 
picture without any problem; I believe it used the MS Explorer.


Apparently, the new browser, Edge, no longer supports SWF files, nor 
do any of the other browsers as the format has been discontinued. I 
tried several format converters, but none seems to work with this 
flavor of SWF.


Is there anyway to display a SWF file in and R:Base form? I might be 
able to get the picture/graph as an Excel graph. Is there any way to 
display an Excel graph in a form.


The last option would be to get the graph as a data set and the use 
R:Charts to generate the graph. Since the graph is only used in one 
form, seems like R:Charts would be an overkill.


On a separate note, is there a way to globally remove the design 
password from all forms? I seem to remember there was a way to do it 
but not having used R:base for a while now, I am somewhat rusty. I 
have over 200 forms and I would prefer to do them all at once; I seem 
to remember adding the design password to all the forms globally…but I 
could be wrong.. ☹


Any ideas or suggestion will be appreciated.

Javier,

Javier Valencia, PE

913-915-3137




--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google 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/554f5862-c771-a904-a484-55de7a93dc75%40rbase.com.

Re: [RBASE-L] - GATEWAY IMPORT Fail

[A. Razzak Memon]

Bruce,

Are you able to complete the process using the manual GATEWAY IMPORT GUI 
interface?


If successful, you may create the "Import Specification (.rgw)" file to 
automate the entire process.


Hope that provides you with some blue's clues!

Very Best R:egards,

Razzak

On 1/11/2023 10:01 PM, Bruce Chitiea wrote:

RBG5XE current

I'll fill in the drywall forehead dents tomorrow, maybe.

Been all over every aspect of this. Exhaustively. Target table refuses 
to populate.


Can anyone see a reason why this import fails?

*GATEWAY TARGET TABLE*
  CREATE TEMP TABLE stage2_atomized_tt +
  ( stage1_filenameID TEXT (7) , +
    rbms         TEXT (4) , +
    soNum        TEXT (5) , +
    custCode_txt TEXT (8) , +
    docCode      TEXT (1) , +
    docDateRaw   TEXT (10) , +
    docNum       TEXT (16) , +
    docField08   TEXT (12) , +
    docField09   TEXT (20) , +
    docField10   TEXT (4) , +
    docField11   TEXT (4) , +
    docField12   TEXT (40) , +
    docField13   TEXT (4) , +
    stage2_column_count INT , +
    walkListID   INTEGER )

*IMPORT DATA SOURCE (sample set)*
  D:\stage1_list_prepared.txt

   stage1_fileName
 -
 11(rbms(22650(blkds...(1(2018-11-19(1353(na(0(s(.pdf
 12(rbms(23233(cpsb(1(2020-01-29(543199(stock(0(c(.pdf
 13(rbms(23238(gar.(1(2020-01-06(7274(na(0(c(.pdf
 14(rbms(23239(gar.(1(2020-01-16(7283(na(0(c(.pdf
 15(rbms(23240(gar.(1(2020-01-28(7288(na(0(c(.pdf

*GATEWAY IMPORT CODE*
   GATEWAY IMPORT CUS D:\stage1_list_prepared.txt +
   APPEND stage2_atomized_tt +
   OPTION FIRST_ROW 3 +
   |SEPARATOR ( +
   |ADD_MAPPING stage1_fileNameID = field1 +
   |ADD_MAPPING rbms         = field2 +
   |ADD_MAPPING soNum        = field3 +
   |ADD_MAPPING custCode_txt = field4 +
   |ADD_MAPPING docCode      = field5 +
   |ADD_MAPPING docDateRaw   = field6 +
   |ADD_MAPPING docNum       = field7 +
   |ADD_MAPPING docField08   = field8 +
   |ADD_MAPPING docField09   = field9 +
   |ADD_MAPPING docField10   = field10 +
   |ADD_MAPPING docField11   = field11 +
   |ADD_MAPPING docField12   = field12 +
   |ADD_MAPPING docField13   = Field13 +
   |ADD_MAPPING stage2_column_count = field14 +
   |ADD_MAPPING walkListID   = field15

I've tried SEPARATOR option value with and without single quotes: [ ( 
| '(' ]. No difference.


Any thoughts appreciated.

Warmest Regards, Bruce

Bruce A. Chitiea | SafeSectors, Inc.
112 Harvard Ave #272 | Claremont CA 91711-4716 | USA
+011 (909) 238-9012 m | /rby...@safesectors.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/em83b2b1f7-53a0-471e-a941-b9396eee10e5%40fe37ca4e.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/e13815b8-43c1-be23-f4ea-a4d8bfec3d5b%40rbase.com.

Re: [RBASE-L] - Search again in DB Grid?

[A. Razzak Memon]

You are welcome, Doug!

In reference to Shift + F3 (Find Previous), what version and build are 
you using?


I am using ...



You might have to wait until the next official update, to be released 
soon. :)


In the meantime, enjoy the answer to your your original question.

Very Best R:egards,

Razzak

On 1/8/2023 3:47 PM, Doug Hamilton wrote:

Thanks Razzak.
Yup, F3 finds next but Shift-F3 doesn't seem to do anything.
Tried F3 with left & right shift and with Alt-Shift, Ctrl-Shift, 
Ctrl-Alt-Shift... ran out of fingers :)


Doug



On 1/8/2023 1:07 PM, A. Razzak Memon wrote:

Here's how:

Find:                        Ctrl + F
Find Next:                F3
Find Previous:        Shift + F3

Have fun!

Very Best R:egards,

Razzak

On 1/8/2023 1:51 PM, Doug Hamilton wrote:

In an Enhanced DB Grid I can initiate a search with Ctrl-F.

How do I search again for subsequent values?

Ctrl-F7 & Ctrl-Shift-F7 don't do it and I couldn't find anything in 
the online help: How To > Forms > Hot Keys.


TIA,
Doug








--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google 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/83d4692d-ea4a-05d7-4a81-5a17170ec030%40rbase.com.

Re: [RBASE-L] - Search again in DB Grid?

[A. Razzak Memon]

Here's how:

Find:                        Ctrl + F
Find Next:                F3
Find Previous:        Shift + F3

Have fun!

Very Best R:egards,

Razzak

On 1/8/2023 1:51 PM, Doug Hamilton wrote:

In an Enhanced DB Grid I can initiate a search with Ctrl-F.

How do I search again for subsequent values?

Ctrl-F7 & Ctrl-Shift-F7 don't do it and I couldn't find anything in 
the online help: How To > Forms > Hot Keys.


TIA,
Doug



--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google 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/14dfcaf0-58eb-cd4c-a4c8-8dfc1a7f6f35%40rbase.com.

[RBASE-L] - From The Edge: Tip of the Day Digest (2022)

[A. Razzak Memon]

Friday, December 30, 2022

To R:BASE Community:

The updated end-of-the-year "Tip of the Day" Digest is now available!

The digest is an archive of all "Tip of the Day" threads posted on the 
R:BASE Users Group, consolidated into a single PDF document.


The posted topics primarily detail areas of R:BASE X.5/X.5 Enterprise 
(Version 10.5).


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

Article Title: Tip of the Day Digest (2022)
Date Posted..: December 30, 2022
File Format..: PDF
Total Pages..: 581
File Size: 48.3MB

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/e791830c-f0d2-ab91-c174-209f8af89659%40rbase.com.

Re: [RBASE-L] - where clause on sub tables/reports

[A. Razzak Memon]

Dan,

FWIW, in a report/form with Master and Slave Tables, the WHERE clause is 
only pertinent to the Master table.


Alternatively ...

1. Based on your application and the desired results, you could prepare 
the salve table(s) as *TEMPORARY tables/views *with the matching data 
you need, dynamically, and then use those slave tables/views in reports 
with your master table *WHERE clause*.


2. If appropriate, depending on the desired results, you could use the 
*Custom Table Relationships* to limit the data from Slave Table. See 
attached screenshot, for example. There are more complex examples to 
customize all kind of requests.




That's how I do it, in a situation like yours!

Razzak


On 12/29/2022 5:20 PM, Dan Goldberg wrote:


I have a command to run a report

PRINT reportname ARRANGE slavetable BY colmun  ASC  ARRANGE 
slavetable2 BY column2 ASC, column2 ASC where serial = 333631 ORDER BY 
serial OPTION SCREEN


I would like to use a where clause on stdequipvw in the report 
parameters which is a slave table. is there a way to do that or do I 
just use a temporary view to use as a slave table that has my where 
clause?


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/5ded4c6e-50ef-f258-a694-f0991f67d287%40rbase.com.

Re: [RBASE-L] - show system tables in db explorer

[A. Razzak Memon]

Dan,

Here's how ...

Alt+Ctrl+Shift+F8

Have fun!

Very Best R:egards,

Razzak


On 12/29/2022 2:05 PM, Dan Goldberg wrote:


I had to reset my settings on my pc and cannot remember the key 
sequence to show the system tables in db explorer…


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/BY3PR19MB50270F8F6DBB807B8D316D93D4F39%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/748059d7-2053-49fd-df32-2fa0118194c9%40rbase.com.

[RBASE-L] - Tip of the Day: Capturing Cell Information within DB Tree Grid Controls

[A. Razzak Memon]

Thursday, December 29, 2022

Tip of the Day: Capturing Cell Information within DB Tree Grid Controls
Product...: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5)
Build.: 10.5.5.11222 or higher
Sections..: Forms
Keywords..: DB Tree Grid, GETPROPERTY, Capture, Cell, Read-Only

Did you know that three new read-only properties were introduced for the 
DB Tree Grid control to capture cell information?


With the new GETPROPERTY command parameters for DB Tree Grid controls, 
the column index, row index, and field name may be captured for the 
selected cell.


 . SelectedColumn - returns the 0-based column index
 . SelectedRow - returns the 0-based row index
 . SelectedField - returns the field name associated with the selected 
field


The "On Cell Click", "On Cell Right Click", and "On Cell Double Click" 
EEP events are available for capturing the cell information.


Examples:

GETPROPERTY DBTreeGrid2 SELECTEDFIELD vActiveField

GETPROPERTY DBTreeGrid2 SELECTEDROW vActiveRow

GETPROPERTY DBTreeGrid2 SELECTEDCOLUMN vActiveColumn

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/44281191-aa81-4337-466b-45942eead7fc%40rbase.com.

[RBASE-L] - New EEP for Enhanced DB Grid/DB Tree Grid Controls

[A. Razzak Memon]

Wednesday, December 28, 2022

Tip of the Day: New EEP for Enhanced DB Grid/DB Tree Grid Controls
Product...: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5)
Build.: 10.5.5.11222 or higher
Sections..: Forms
Keywords..: Enhanced DB Grid, DB Tree Grid, EEP, Right Click

Did you know that a new Entry/Exit Procedure (EEP) was added to the 
Enhanced DB Grid and DB Tree Grid controls?


The new "On Cell Right Click" EEP was added to the Enhanced DB Grid and 
DB Tree Grid controls, where upon right clicking within a cell, the 
specified EEP will run.


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/e978270d-be93-c917-b362-7f26fbfc1de6%40rbase.com.

Re: [RBASE-L] - Bit Button On-Click EEP variable values 77, 99

[A. Razzak Memon]

Bruce,

Apparently, you are using and/or recycling Razzak's sample application 
forms in your own application, or at least trying to recycle. That's great!


However ...

The value assigned for the button [Continue]  vButton = 77, and value 
assigned for the button [Cancel]  vButton = 99, is the indicator as to 
how the form was closed. Then, based on the returned value you can 
continue or cancel the process as you see fit.


There is more to that logic in my complex applications.

Hope it helps!

Very Best R:egards,

Razzak


On 12/27/2022 1:26 PM, Bruce Chitiea wrote:
Of what significance are the specific variable values "77" and "99", 
often found within Bit Button On-Click EEPs, e.g.:


SET VAR vbitButton INTEGER = 77
SET VAR vbitButton INTEGER = 99

If these represent Virtual-Key Codes (FormsManual.pdf, Section 1.8.3.4 
p.1321), I'm not "getting" their correspondence to the mouse-clickery 
of the Button.


Thoughts? And thanks.

Warmest Regards, Bruce

Bruce A. Chitiea | SafeSectors, Inc.
112 Harvard Ave #272 | Claremont CA 91711-4716 | USA
+011 (909) 238-9012 m | /rby...@safesectors.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/c0bec84b-b981-6aa7-0864-56daa41e244b%40rbase.com.

[RBASE-L] - Tip of the Day: Control Fast Accelerator Character Use within Group Bar Controls

[A. Razzak Memon]

Tuesday, December 27, 2022

Tip of the Day: Control Fast Accelerator Character Use within Group Bar 
Controls

Product...: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5)
Build.: 10.5.5.11222 or higher
Sections..: Forms
Keywords..: Group Bar, Accelerator Character, Hot Key, PROPERTY

Did you know that a new PROPERTY command parameter was added to control 
"fast accelerator character" use within Group Bar controls?


The REQUIREALTONACCELCHAR property specifies whether pressing the one 
accelerator character is enough to activate that menu option, without 
having to press the [Alt] key first,

within Group Bar controls.

  PROPERTY GroupBar1 REQUIREALTONACCELCHAR 'TRUE'

The parameter is False by default, for backwards compatibility.

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/082f1671-4364-f824-34e3-3b7d7e04cab7%40rbase.com.

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

[A. Razzak Memon]

Jim,

Get everyone out of the database, and then use the RELOAD routine to 
reload the database, including all INDEXes.


Hope it helps!

Razzak

On 12/26/2022 1:54 PM, 'jim schmitt' via RBASE-L wrote:

Hello again to all:

Could 'out of dynamic space ' mean there is no more room on the server ?

Here are the server drives:  i believe 'P' is a copy of 'S', as it is 
exactly same sizes.


H dive                    S drive (production)        P drive
used 83.0 GB        USED 429 gb              USED 429 GB
FREE  362 gb    free    384GB             FREE 384 GB
TOTAL 446 gb    TOTAL 813 GB          TOTAL 813 GB

Could their server be only 1TB and out of room ?  Just guessing in the 
dark .


Jim
--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php

---
You received this message because you are subscribed to the Google 
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send 
an email to rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/591133800.4046390.1672080894289%40mail.yahoo.com 
.


--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups "RBASE-L" group.

To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/115ad1e1-1c88-dffb-9656-97f8c0db99e8%40rbase.com.

[RBASE-L] - Tip of the Day: Coordinate Hint When Resizing Form Objects

[A. Razzak Memon]

Friday, December 23, 2022

Tip of the Day: Coordinate Hint When Resizing Form Objects
Product...: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5)
Build.: 10.5.5.11222 or higher
Sections..: Forms
Keywords..: Coordinate, Resize, Handlebars, Object, Hint

Did you know that when resizing form objects, the width and/or height 
coordinates appear as a hint once a handlebar is selected, and change as 
the mouse is dragged?


When resizing objects, the width and/or height coordinates will appear 
as a hint once you select a handlebar. The blue dot handlebars appear on 
all four corners and all four sides.


The coordinates would change as you drag the mouse and change the size 
of the field.


This very helpful feature was implemented in prior versions, was missing 
in newer releases, and was added back!


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/a8110728-ba4d-0127-5dcc-62b6b79a6d10%40rbase.com.

[RBASE-L] - Released: Add-on Products for R:BASE X.5/X.5 Enterprise (Version 10.5)

[A. Razzak Memon]

Thursday, December 22, 2022

To All Users of R:BASE X.5 and R:BASE X.5 Enterprise Add-on Products:

Updates are now available for the following add-on products for R:BASE 
X.5 and R:BASE X.5 Enterprise (Version 10.5):


https://www.rbaseupdates.com

Build: 10.5.5.11222 - Update 5

. Oterro X.5 and Oterro X.5 Enterprise
. R:BASE Plugin Power Pack X.5
. R:BASE Editor X.5
. R:Docs X.5

This is a FREE update for all registered users who are within one year 
of their purchase or are active R:SAP subscribers for their licensed 
product.


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/21cbe17a-0e7a-7e1e-5527-c3e8509f0f4f%40rbase.com.

[RBASE-L] - Released: R:BASE X.5/X.5 Enterprise (Version 10.5) - Update 5

[A. Razzak Memon]

Thursday, December 22, 2022

To All Users of R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5):

Official updates of R:BASE X.5/R:BASE X.5 Enterprise (Version 10.5) are 
now available.


https://www.rbaseupdates.com

Build: 10.5.5.11222 - Update 5

. R:BASE X.5 (Version 10.5)
. R:BASE X.5 (Version 10.5) - Corporate
. R:BASE X.5 (Version 10.5) - Compiler
. R:BASE X.5 (Version 10.5) - Runtime
. R:BASE X.5 Enterprise (Version 10.5)
. R:BASE X.5 Enterprise (Version 10.5) - Corporate
. R:BASE X.5 Enterprise (Version 10.5) - Compiler
. R:BASE X.5 Enterprise (Version 10.5) - Runtime

This Update 5, Build: 10.5.5.11222, includes a total of 12 enhancements 
and 61 reported bug fixes.


Refer to the WhatsNewInRBASE_X5_Update05.pdf document for complete details.

This is a FREE update for all registered users of R:BASE X5/X5E who are 
within one year of their purchase or are active R:SAP subscribers.


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/a5bbc9ac-cf83-b1b2-edc5-79f686573a53%40rbase.com.

Re: [RBASE-L] - Enhanced DB Grid unselect multi select

[A. Razzak Memon]

Dan,

Based upon how the Enhanced DB Grid is initially displayed and sorted, 
the same sort may be initiated again, to clear the row selections.


Here's how ...

PROPERTY  SORTASC 'Value'

  -- To Dynamically Sort the first column in ascending order
  PROPERTY DBGrid_Customers SortAsc '0'

  -- To Dynamically Sort the Company column in ascending order
  PROPERTY DBGrid_Customers SortAsc 'Company'

The SORTDESC property is also available to sort the column in descending 
order.


PROPERTY  SORTDESC 'Value'

Very Best R:egards,

Razzak

On 12/14/2022 3:36 PM, Dan Goldberg wrote:


I have a button that updates and I want to clear the multi-selected 
rows but cannot find a property for it.


Any one have any clue on how to do that?

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/BY3PR19MB502792C0D9871F96406D09C6D4E09%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/77b7e009-4ae8-cd89-6daa-a38d1db0059b%40rbase.com.

Re: [RBASE-L] - Variable Lengths - X.5 Enterprise 10.5.5.11013

[A. Razzak Memon]

John,

As always, the pleasure is all mine!

Razzak

On 12/8/2022 1:28 PM, johnd...@gmail.com wrote:

Razzak,

Thank you very much. That was the issue - was 18, now 40.

I appreciate your help.

Regards
John Docherty

On Friday, December 9, 2022 at 4:18:17 AM UTC+13 A. Razzak Memon wrote:

John,

What is your *NAMEWIDTH *setting?

At the R> prompt: SHOW NAMEWIDTH

The default is 18 characters.

In my case, I have the NAMEWIDTH set to 40.

*SET NAMEWIDTH 40*

Hope it helps!

Very Best R:egards,

Razzak


On 12/8/2022 12:21 AM, johnd...@gmail.com wrote:

I have noticed that the variable lengths in one of my databases
are truncated at 18 characters, which I understood applied in X.5
and not the Enterprise version. I was just wondering if I am
doing something wrong or has something changed  ?  Any advice
would be appreciated. (These used to work with longer names - I
think.)

Thank you.
Regards
John Docherty
-- 
For group guidelines, visit

http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the
Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it,
send an email to rbase-l+u...@googlegroups.com.
To view this discussion on the web visit

https://groups.google.com/d/msgid/rbase-l/2df8a282-5f7a-4a76-81ee-0fea12041f30n%40googlegroups.com

<https://groups.google.com/d/msgid/rbase-l/2df8a282-5f7a-4a76-81ee-0fea12041f30n%40googlegroups.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/a5882a51-ce1f-4033-9fe1-0b93bb42a8aen%40googlegroups.com 
<https://groups.google.com/d/msgid/rbase-l/a5882a51-ce1f-4033-9fe1-0b93bb42a8aen%40googlegroups.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/ae5d474e-ccf6-6bc2-24a1-ebff8fe57da8%40rbase.com.

Re: [RBASE-L] - capture autonumber field value

[A. Razzak Memon]

Dan,

SET VAR vLastValue INTEGER = 0
SELECT colname INTO vLastValue INDIC iv1 FROM tablename WHERE COUNT = INSERT

Alternatively, you could also try:

SET VAR vLastValue INTEGER = 0
SELECT colname INTO vLastValue INDIC iv1 FROM tablename WHERE COUNT = LAST

Hope it helps!

Very Best R:egards,

Razzak

On 12/8/2022 10:34 AM, Dan Goldberg wrote:


I am trying to capture an autonumber field value in the after start 
eep but it keeps showing 0. So I put the variable field on the form so 
I can watch it(circled red). But when I step thru it I see the 
variable value in the form but not in the eep. Is there a better way 
after a form start and when a row is save to get the current 
autonumber value when those are triggered? 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/BY3PR19MB5027F39DE5DF0671E6E6873BD41D9%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/436f1de3-b28b-42e1-872d-4ba5fec406e8%40rbase.com.

Re: [RBASE-L] - Variable Lengths - X.5 Enterprise 10.5.5.11013

[A. Razzak Memon]

John,

What is your *NAMEWIDTH *setting?

At the R> prompt: SHOW NAMEWIDTH

The default is 18 characters.

In my case, I have the NAMEWIDTH set to 40.

*SET NAMEWIDTH 40*

Hope it helps!

Very Best R:egards,

Razzak

On 12/8/2022 12:21 AM, johnd...@gmail.com wrote:
I have noticed that the variable lengths in one of my databases are 
truncated at 18 characters, which I understood applied in X.5 and not 
the Enterprise version. I was just wondering if I am doing something 
wrong or has something changed  ?  Any advice would be appreciated. 
(These used to work with longer names - I think.)


Thank you.
Regards
John Docherty
--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php

---
You received this message because you are subscribed to the Google 
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/2df8a282-5f7a-4a76-81ee-0fea12041f30n%40googlegroups.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/8d15b317-f162-028c-6c12-ea42b5768799%40rbase.com.

Re: [RBASE-L] - De-activate

[A. Razzak Memon]

*Note:
*

*Before De-Activating from the original computer and Re-Activating to 
another computer, make sure that your Software Assurance Plan is Active 
and Up-To-Date!*


This privilege is provided to active R:SAP users as well as the product 
purchase withing the first year.


*The "End-of-Life" and "Legacy" R:BASE products are not eligible for 
such services available.**

*

Very Best R:egards,

Razzak

On 11/11/2022 1:01 PM, Doug Hamilton wrote:

DB Explorer | Help | Product Activation
There's a Deactivate button at the bottom of the window.
Make sure you select the desired product, there may more than one.

Doug

On 11/11/2022 11:50 AM, Dick Fey wrote:


Replacing 1 computer.  How do I deactivate 1 seat so I can install on 
new?


Dick Fey

Carpet Broker Inc.

--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php

---
You received this message because you are subscribed to the Google 
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/2022115020.SM36037%40MAIL-2019 
.





Avast logo   

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


<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php

---
You received this message because you are subscribed to the Google 
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/4faf9f7f-5eef-4b38-9a4e-5146a3951fb0%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/5ae8d8c0-3812-d463-5b83-8967bb9489dd%40rbase.com.

[RBASE-L] - Tip of the Day: Form Designer Productivity Tips

[A. Razzak Memon]

Thursday, November 10, 2022

Tip of the Day: Form Designer Productivity Tips
Product...: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5)
Build.: 10.5.5.11013 or higher
Sections..: Forms

Below are valuable tips to help get the most productivity out of the 
R:BASE Form Designer:


 . When the Form Designer is launched the main menu bar includes 
options specific to the designer: Form, Edit, View, Layout, Table, and 
Variables.


 . When initially designing the form, you should create and place the 
objects within a form so that is suitable for users with various screen 
resolutions, preferable starting at 1024x768, as you never know the end 
users' preferences.


 . After objects are placed, and then is selected, small blue circles 
appear around the four corners and four sides; called handlebars. When 
more than one object is selected, red square handlebars are displayed. 
The handlebars are extremely useful for editing the properties of more 
than one object or moving more than one object. Hovering your cursor 
over the handlebars for an individual object changes the pointer to a 
double arrow. Holding down the left mouse button with the double arrow 
lets you stretch or shrink the object.


 . Multiple objects can be selected with the mouse cursor by lassoing 
objects. The lasso appears as a dotted line while you drag the mouse 
cursor. It works by starting in one corner of the work space, holding 
down the left mouse button, and dragging the cursor to the opposite 
corner. The lasso only needs to be touching the object in order to 
select it for editing. When lassoing multiple objects that are contained 
within a parent object, such as a panel, press and hold the [Ctrl] key 
to lasso the objects.


 . Right clicking on an object will display the context menu options. 
The context menu will vary based upon the selected object.


 . The properties for all field objects can be edited by right clicking 
on the object and selecting "Object Property" from the context menu, or 
by selecting the object and pressing the [F11] key on the keyboard. Each 
object's properties vary depending on the type of control.


 . Use the [Shift+Right Arrow], [Shift+Left Arrow],[Shift+Up Arrow] or 
[Shift+Down Arrow] key combinations to increase width, decrease width, 
increase height or decrease height of any individual control or group of 
selected controls.


 . Use the [Ctrl+Right Arrow], [Ctrl+Left Arrow],[Ctrl+Up Arrow] or 
[Ctrl+Down Arrow] key combinations to accurately move any individual 
control or group of selected controls.


 . You can cut, copy and paste one or more form controls at a time, 
either in the same form or between different forms. It is important to 
note that when using copy and paste for form objects, the control being 
copied will retain the Top, Left, Height and Width coordinates. This 
logic is in place by design for the purpose of moving a control from one 
form to another, where the control will appear in the same location with 
the same size. This means when you copy an object that is is defined 
with 800 pixels as the Left value, and paste it into a small Panel with 
a 400 pixel width, the newly pasted object is another 400 pixels beyond 
the panel's border, and not visible. Pressing the [Ctrl+Left Arrow] keys 
will place the object where it is visible.


 . You can paste external content (text, rich text, images) directly 
into the Form Designer from the Windows clipboard.


 . When adding several of the same type of object, select the "Sticky 
Control" on the "Settings" toolbar. This will allow you to add the same 
type of control until the "Sticky Control" is un-selected, preventing 
several mouse click steps.


 . Tables can be added and removed from forms by selecting "Tables: 
Add/Remove Tables" from the main menu bar. Table relationships and 
settings may be altered in the area as well.


 . You can test how your form will look by running it right from the 
designer. From the menu bar, choose "Form: Run Form". Press the [Esc] 
key to return to the designer, as long [Esc] is not disabled within the 
form's properties.


 . The order in which you place objects on a form is the tab order in 
which the focus moves when pressing [Tab]/[Enter] when running the form. 
After making design changes to a form, check the tab order by choosing 
"Layout: Change Tab Order" on the menu bar. The "Tab Order Settings" 
dialog will appear with the objects on the form listed by "Control Type" 
and the field properties.


 . The Display Format window allows users to customize the Display 
Format Mask for Database (DB) Controls. To add/modify an object's 
display format, choose "Tables: Display Format..." from the menu bar.


 . The Default Values window allows users to specify a default value 
for the field when the form is used in the enter mode for Database (DB) 
Controls. The value #DUP can also be placed in the Current Default Value 
field to duplicate the value when entering 

[RBASE-L] - Tip of the Day: Report/Label Designer Productivity Tips

[A. Razzak Memon]

Wednesday, November 09, 2022

Tip of the Day: Report/Label Designer Productivity Tips
Product...: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5)
Build.: 10.5.5.11013 or higher
Sections..: Reports/Labels

Below are a valuable tips to help get the most productivity out of the 
R:BASE Report/Label Designer. The list starts with basic information, 
but the items become more involved further down.


If you wish, reply with "I did not know that..." for any interesting 
item! Personally, I did not know that the "Existing" tab of the Object 
List toolbar displays the "layer order" of the controls within each band!


Report/Label Designer Tips:

 . When the Report Designer is launched the main menu bar includes 
options specific to the designer: File, Edit, View, Report, and Variables.


 . Two tabs are located on the top left of the Report Designer; 
"Design" and "Preview", where users can toggle between the report's 
preview and design, before printing.


 . The properties for all report objects may be adjusted by using the 
right click context menu.


 . To resize a report band, use the mouse by positioning the cursor 
over the gray rectangular area (band) below the white space, press and 
hold the left mouse button, and drag.


 . You can cut, copy and paste one or more report controls at a time, 
either in the same report or between different reports.


 . You can paste external content (text, rich text, images) directly 
into the Report Designer from the Windows clipboard.


 . Use the "Format" toolbar options (Font Name, Font Size, Font Style, 
and Justification) to set the font, size, style, colors, and 
justification of objects.


 . Use the "Align or Space" toolbar options to position controls 
relative to one another and relative to the band in which they appear.


 . Use the "Size" toolbar options to adjust the width and height of 
controls.


 . Use the "Nudge" toolbar options to move the controls by one pixel.

. When added new text-based label objects, select a control to mimic 
before selecting the desired control. When placed, the new object will 
take on the style, font, and size of the selected object, which saves 
time when adding multiple objects.


 . Use the [Shift+Right Arrow], [Shift+Left Arrow],[Shift+Up Arrow] or 
[Shift+Down Arrow] key combinations to accurately increase width, 
decrease width, increase height or decrease height of any individual 
control or group of selected controls.


 . Use the [Ctrl+Right Arrow], [Ctrl+Left Arrow],[Ctrl+Up Arrow] or 
[Ctrl+Down Arrow] key combinations to accurately move any individual 
control or group of selected controls.


 . Set up the Page Size and Margins before placing any controls on 
report bands. Select "File: Page Setup..." from the menu bar.


 . The width of the page (white space) displayed in the Report Designer 
is the actual width, after taking the page margins into consideration.


 . To set the ruler units, use the "Report: Units" menu bar option or 
right click on the ruler and select the appropriate unit from the 
available context menu options. To hide the a ruler, right click on the 
ruler and select 'Hide' from the speed menu options. The ruler may be 
displayed again by selecting "View: Rulers" from the menu bar.


 . The status bar, across the bottom on the designer window, provides 
information about the select object such as the name, type, coordinates, 
and/or table, column and variable details.


 . You can position toolbars on any edge of the window and in any 
order. Whether the toolbars are docked or floating, you will see the 
hint for any toolbar button when the cursor is hovered over the button. 
The designer will remember the last docked/floating setting when closing 
the designer. From the menu bar, select the "View: Toolbars" option to 
hide or show any toolbar.


 . Use the Magnifying Glass utility to display a zoomed area of the 
R:BASE environment and monitor, which is useful when editing objects 
very close to each other. The Magnifying Glass can be launched by 
selecting the "Utilities: Magnifying Glass" menu bar option or using the 
[Ctrl+Alt+M] key combination.


 . The Preview tab displays only the first 100 records in the 
table/view. The record count can be decreased or increased in the 
Default Report/Label Settings. To view the Default Report/Label 
Settings, choose "Settings: Report/Label Designer: Default Settings" 
from the menu bar. A custom WHERE clause may be entered and applied to 
the preview results with the "Report: Preview WHERE Clause" menu option. 
The specified WHERE clause replaces the default (100 records) display 
limit for the preview results. The Preview WHERE Clause can be launched 
with the [Ctrl+Shift+P] key combination.


 . To assign object display formats, right click on a field to use the 
context menu to view the "Display Format" dialog. R:BASE will determine 
the data type assigned to the object and display several formats 
appropriate for that data 

[RBASE-L] - Tip of the Day: Manually Trigger Required Value Checks on Form Fields

[A. Razzak Memon]

Friday, October 14, 2022

Tip of the Day: Manually Trigger Required Value Checks on Form Fields
Product...: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5)
Build.: 10.5.5.11013 or higher
Sections..: Forms
Keywords..: Check Required Value, GETPROPERTY, Field, On Close

Did you know that, in addition to the right click context menu option, 
the GETPROPERTY command has been enhanced at the form level to trigger 
required value checks manually upon form fields?


The "Check Required Value" feature checks if a field has a value (not 
empty), and displays an error message or warning if the required value 
is not present. In the Form Designer, there are "required value" options 
that may be defined for database and variable controls within the right 
click context menu options. When enabled, a value for the field is 
checked when the form is closed.


. Check Required Value on Form Close - specifies the control is checked 
if it has a value in the form's "On Close" event
. Required Value Error Message - specifies the message if a value does 
not exist for the control


In the event that the field is left empty, and the form is closed, the 
defined error message will appear.


With the GETPROPERTY command, an EEP may be defined as below, to 
manually trigger the required value check on the field, and close the 
form if values are present:


GETPROPERTY RBASE_FORM CheckRequiredValues 'vState'
IF vState = 'OK' THEN
   SAVEROW
   CLOSEWINDOW
ENDIF

If the required value is intended to be a warning, and also for easier 
development of several fields within a form, the below application 
property was introduced to display a warning dialog, with an "Ignore" 
button.


PROPERTY APPLICATION STRICT_VALUE_REQUIREMENTS ON

The default value is ON. When ON, the error dialog displayed. When OFF, 
the warning dialog is displayed.


The following online help page provides additional details, as well as 
the list of supported controls:

https://www.rbase.com/support/rsyntax/rbgx5/value-required-for-controls.html

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/956fe69b-4920-8521-504c-49fa368851e1%40rbase.com.

Re: [RBASE-L] - Tip of the Day: Specify a Custom Font in PDF Output with Font Substitutions

[A. Razzak Memon]

Karen,

If you have a sample, please forward it to the RDCC for review.
mailto:r...@rbase.com

Best regards,

Razzak

On 10/13/2022 1:51 PM, 'Karen Tellef' via RBASE-L wrote:
I've been curious about something similar for quite a while (don't 
remember how long ago this started).


I have a report defined with a simple Times New Roman 12.  No bold, no 
effects.  But when I send it to a PDF it comes out different (no PDF 
options are specified). The attached shows a side by side.  Can I use 
this new command but somehow substitute it for TNR?


Or should I submit as an enhancement or fix?

Karen




-Original Message-
From: A. Razzak Memon 
To: RBASE-L Group 
Sent: Wed, Oct 12, 2022 11:12 pm
Subject: [RBASE-L] - Tip of the Day: Specify a Custom Font in PDF 
Output with Font Substitutions


Thursday, October 13, 2022

Tip of the Day: Specify a Custom Font in PDF Output with Font 
Substitutions

Product...: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5)
Build.: 10.5.5.11013 or higher
Sections..: Reports/Labels
Keywords..: PDF, PROPERTY, Font Substitution, TrueType, Device Font

Did you know that you can specify a replacement font for all 
reports/labels using the MS San Serif device font when printing to PDF 
output?


When printing to the PDF output, the MS Sans Serif device font is 
substituted with Helvetica (native PDF font), which is wider than MS 
Sans Serif, and may result in characters being truncated.


The substitution logic is true for all device fonts, which is 
indicated by a monitor icon in the font drop-down, within the Report 
Designer's Format toolbar. MS Sans Serif is in the Swiss font family 
which are recognized by variable stroke widths, which are proportional 
to the actual widths of the glyphs, and which do not have serifs.


R:BASE has been updated to optionally change the replacement font for 
all reports/labels using the MS San Serif device font, or any fonts in 
the Swiss font family, when printing to PDF output. Any TrueType font 
can be used for the substitution.


The following command may be used at the R:BASE startup to specify a 
replacement font:


PROPERTY REPORT PDF_SERIF_FONT_REPLACEMENT 'Arial'

To clear a substitution, use the following command to pass a space as 
the font name.


PROPERTY REPORT PDF_SERIF_FONT_REPLACEMENT ' '

Very Best R:egards,

Razzak.

R:BASE Technologies, Inc.
https://www.rbase.com <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/58318de7-abaf-5da3-92a1-4e6402db9c85%40rbase.com 
<https://groups.google.com/d/msgid/rbase-l/58318de7-abaf-5da3-92a1-4e6402db9c85%40rbase.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/820681693.1150422.1665683504286%40mail.yahoo.com 
<https://groups.google.com/d/msgid/rbase-l/820681693.1150422.1665683504286%40mail.yahoo.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/cf9c02b0-9848-1b99-b3e1-9ab7c78390dd%40rbase.com.

[RBASE-L] - Tip of the Day: Specify a Custom Font in PDF Output with Font Substitutions

[A. Razzak Memon]

Thursday, October 13, 2022

Tip of the Day: Specify a Custom Font in PDF Output with Font Substitutions
Product...: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5)
Build.: 10.5.5.11013 or higher
Sections..: Reports/Labels
Keywords..: PDF, PROPERTY, Font Substitution, TrueType, Device Font

Did you know that you can specify a replacement font for all 
reports/labels using the MS San Serif device font when printing to PDF 
output?


When printing to the PDF output, the MS Sans Serif device font is 
substituted with Helvetica (native PDF font), which is wider than MS 
Sans Serif, and may result in characters being truncated.


The substitution logic is true for all device fonts, which is indicated 
by a monitor icon in the font drop-down, within the Report Designer's 
Format toolbar. MS Sans Serif is in the Swiss font family which are 
recognized by variable stroke widths, which are proportional to the 
actual widths of the glyphs, and which do not have serifs.


R:BASE has been updated to optionally change the replacement font for 
all reports/labels using the MS San Serif device font, or any fonts in 
the Swiss font family, when printing to PDF output. Any TrueType font 
can be used for the substitution.


The following command may be used at the R:BASE startup to specify a 
replacement font:


PROPERTY REPORT PDF_SERIF_FONT_REPLACEMENT 'Arial'

To clear a substitution, use the following command to pass a space as 
the font name.


PROPERTY REPORT PDF_SERIF_FONT_REPLACEMENT ' '

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/58318de7-abaf-5da3-92a1-4e6402db9c85%40rbase.com.

[RBASE-L] - Released: Add-on Products for R:BASE X.5/X.5 Enterprise (Version 10.5)

[A. Razzak Memon]

Thursday, October 13, 2022

To All Users of R:BASE X.5 and R:BASE X.5 Enterprise Add-on Products:

Updates are now available for the following add-on products for R:BASE 
X.5 and R:BASE X.5 Enterprise (Version 10.5):


https://www.rbaseupdates.com

Build: 10.5.5.11013 - Update 4

. Oterro X.5 and Oterro X.5 Enterprise
. R:PDFWorks X.5
. R:BASE Editor X.5
. R:Docs X.5

This is a FREE update for all registered users who are within one year 
of their purchase or are active R:SAP subscribers for their licensed 
product.


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/b6768ca3-3a23-4efb-7a62-c53d5986f535%40rbase.com.

[RBASE-L] - Released: R:BASE X.5/X.5 Enterprise (Version 10.5) - Update 5

[A. Razzak Memon]

Thursday, October 13, 2022

To All Users of R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5):

Official updates of R:BASE X.5/R:BASE X.5 Enterprise (Version 10.5) are 
now available.


https://www.rbaseupdates.com

Build: 10.5.5.11013 - Update 5

. R:BASE X.5 (Version 10.5)
. R:BASE X.5 (Version 10.5) - Corporate
. R:BASE X.5 (Version 10.5) - Compiler
. R:BASE X.5 (Version 10.5) - Runtime
. R:BASE X.5 Enterprise (Version 10.5)
. R:BASE X.5 Enterprise (Version 10.5) - Corporate
. R:BASE X.5 Enterprise (Version 10.5) - Compiler
. R:BASE X.5 Enterprise (Version 10.5) - Runtime

This Update 5, Build: 10.5.5.11013, includes a total of 6 enhancements 
and 45 reported bug fixes.


Refer to the WhatsNewInRBASE_X5_Update05.pdf document for complete details.

This is a FREE update for all registered users of R:BASE X5/X5E who are 
within one year of their purchase or are active R:SAP subscribers.


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/2618bb87-aa08-6058-6ecc-33240b038bd9%40rbase.com.

Re: [RBASE-L] - Importing Data From Text File

[A. Razzak Memon]

Gary,

R:BASE is not freezing up, but is actually processing the 6 million row 
file, as you instructed it to.


When testing different import setting and OPTION parameters, try working 
with a limited data set. Once you have successfully imported the limited 
data set, perform the same on the actual file.


The text qualifier (' or ") and delimiter (|) appear to be custom and 
the file is not actually a CSV file. In the GATEWAY command, you may use 
the CUS import format to specify custom QUALIFIER and SEPARATOR values. 
If you are unsure what text qualifier is used, you may "peek" into the 
import file with R:BASE Editor by selecting "File" > "File Peek" from 
the main menu bar.


Please note the import process will take time, based upon your 
computer's memory and processor. You may have to leave R:BASE running 
for some time as all of the data is verified before it is loaded with 
the Gateway utility.


If you otherwise do "not" want the data verification, try using the LOAD 
command. LOAD will force the data with no verification, and takes less 
time as a result. With the LOAD command, remove the first row of column 
names. And, the DELIMIT character setting should be adjusted to the pipe 
character. "SET DELIMIT=|" Again, try working with a limited data set 
initially.


Very Best Regards,

Razzak

On 10/6/2022 11:53 PM, nwfoxfl...@gmail.com wrote:


Hello All,

I am trying to import data from a text file, but I can not make it 
work. The file is a Vertical Bar Delimited TXT file. The file is 
formatted into 35 columns of various lengths. There are approximately 
six million rows. I have tried using the Gateway utility and the 
Gateway Import command. The Gateway utility freezes when I select 
destination sources for each column. When I try importing using the 
command, It also freezes up. The only way out is for me to shut down 
RBase using the Task Manager. When RBase freezes up, I notice that the 
Task Manager shows that Rbase is active and is using 30% of the CPU 
and 800-900 MBs of memory.


The file I am trying to import is from the State of Washington. It’s a 
list of registered voters. The file format is the only format they 
offer this data in. I have tried converting the file using Excel, but 
it’s too large. The first row of data is the column names. I have 
pasted the first two rows to show what the data looks like. I have 
changed the identifying data, so the data below is not a real person 
or place.


StateVoterID|FName|MName|LName|NameSuffix|Birthdate|Gender|RegStNum|RegStFrac|RegStName|RegStType|RegUnitType|RegStPreDirection|RegStPostDirection|RegStUnitNum|RegCity|RegState|RegZipCode|CountyCode|PrecinctCode|PrecinctPart|LegislativeDistrict|CongressionalDistrict|Mail1|Mail2|Mail3|Mail4|MailCity|MailZip|MailState|MailCountry|Registrationdate|AbsenteeType|LastVoted|StatusCode

3593761|SUSIE||VOTER||1976-10-03|F|1233501||250TH|PL|#|NW||C108|KENT|WA|98030|KI|2403|2403.023|47|9|2004-05-17||2020-11-03|Active

I have tried importing into an existing table with the same column 
names, length, and data type as the data file, and I have tried 
importing using the create a new table. Unfortunately, nothing seems 
to work for me.


I am using RBase X.5 Enterprise Version 10.5.5.10818.

Thank you,

Gary Randall

--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php

---
You received this message because you are subscribed to the Google 
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/09e001d8da00%2451ccefb0%24f566cf10%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/9ba00d44-e554-3c73-fd65-41c7b0d58a28%40rbase.com.

[RBASE-L] - Hope and Support in the Hurricane Ian Aftermath

[A. Razzak Memon]

In the aftermath of what is one of the worst hurricanes to strike the
United States, we at R:BASE Technologies, express our deepest sympathy to
the residents of Fort Myers and surrounding area affected by Hurricane Ian
and to our members, colleagues, and friends who lost loved ones in the
vicinity.

We express our support to those who are still awaiting word on those in the
affected areas. We also wish to convey empathy with those who are
experiencing the effects of disruptions of social support and destruction
and loss of property. The grief associated with this disaster is universal,
and touches all of our lives.

It is with great hope that all may return to normalcy as quickly as
possible!

Should any member of the R:BASE Community in the affected area require any
software assistance, please do not hesitate to contact us at 1+724.733.0053
or mailto:servi...@rbase.com.

With deepest regards,

R:BASE Technologies, Inc. Staff and Development Team

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

[RBASE-L] - Released: Add-on Products for R:BASE X.5/X.5 Enterprise (Version 10.5)

[A. Razzak Memon]

Thursday, August 25, 2022

To All Users of R:BASE X.5 and R:BASE X.5 Enterprise Add-on Products:

Updates are now available for the following add-on products for R:BASE 
X.5 and R:BASE X.5 Enterprise (Version 10.5):


https://www.rbaseupdates.com

Build: 10.5.5.10825 - Update 5

 . R:Charts X.5 and R:Charts X.5 Enterprise
 . R:BASE Plugin Power Pack X.5
 . RBAdmin X.5 and RBAdmin X.5 Enterprise
 . R:Scope X.5 and R:Scope X.5 Enterprise
 . R:Documenter X.5
 . R:Biometric X.5
 . R:BiometricN X.5

This is a FREE update for all registered users who are within one year 
of their purchase or are active R:SAP subscribers for their licensed 
product.


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/e4f4e1e6-2e93-cf20-c54b-51ae91a03b39%40rbase.com.

Re: [RBASE-L] - refresh db grid on insert

[A. Razzak Memon]

Dan,Use the following command:PROPERTY TABLE tablename  POSTRETURNOn Aug 23, 2022 10:29 AM, Dan Goldberg  wrote:

I have a form that is in entry mode. I have an add button that will do some checking and insert a row.

 
After the row is inserted I want to refresh the db grid but when I do the command “property tablename refresh” it does not show. It works in edit mode but not in entry mode.
 
Does anyone have a way for it to show?
 
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+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0014F0CE271%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/b94029bc-d10e-4d3e-8c09-59ada4e3fb51%40email.android.com.

[RBASE-L] - Released: Oterro X.5/X.5 Enterprise (Version 10.5) - Update 5

[A. Razzak Memon]

Thursday, August 18, 2022

To All Users of Oterro X.5 and Oterro X.5 Enterprise (Version 10.5):

Official updates of Oterro X.5/Oterro X.5 Enterprise (Version 10.5) are 
now available.


https://www.rbaseupdates.com

Build: 10.5.5.10818 - Update 5

 . Oterro X.5/X.5 Enterprise - Single User
 . Oterro X.5/X.5 Enterprise - Five User
 . Oterro X.5/X.5 Enterprise - Ten User
 . Oterro X.5/X.5 Enterprise - Twenty-Five User
 . Oterro X.5/X.5 Enterprise - Single Site Unlimited
 . Oterro X.5/X.5 Enterprise - Single Application Unlimited
 . Oterro X.5/X.5 Enterprise - Multi Application Unlimited

This is a FREE update for all registered users of Oterro X5/X5E who are 
within one year of their purchase or are active R:SAP subscribers.


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/71646ac0-d859-c89e-6ae5-8502df395040%40rbase.com.

[RBASE-L] - Released: R:BASE X.5/X.5 Enterprise (Version 10.5) - Update 5

[A. Razzak Memon]

Thursday, August 18, 2022

To All Users of R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5):

Official updates of R:BASE X.5/R:BASE X.5 Enterprise (Version 10.5) are 
now available.


https://www.rbaseupdates.com

Build: 10.5.5.10818 - Update 5

. R:BASE X.5 (Version 10.5)
. R:BASE X.5 (Version 10.5) - Corporate
. R:BASE X.5 (Version 10.5) - Compiler
. R:BASE X.5 (Version 10.5) - Runtime
. R:BASE X.5 Enterprise (Version 10.5)
. R:BASE X.5 Enterprise (Version 10.5) - Corporate
. R:BASE X.5 Enterprise (Version 10.5) - Compiler
. R:BASE X.5 Enterprise (Version 10.5) - Runtime

This Update 5, Build: 10.5.5.10818, includes a total of 24 reported bug 
fixes and one enhancement.


Refer to WhatsNewInRBASE_X5_Update05.pdf for complete details.

This is a FREE update for all registered users of R:BASE X5/X5E who are 
within one year of their purchase or are active R:SAP subscribers.


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/df115b73-c84f-4639-fcfd-dfc59b532464%40rbase.com.

[RBASE-L] - Tip of the Day: Maintaining Efficiency with QualKeys in Foreign Data Sources

[A. Razzak Memon]

Thursday, August 4, 2022

Tip of the Day: Maintaining Efficiency with QualKeys in Foreign Data Sources
Product...: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5)
Build.: 10.5.4.20616 or higher
Sections..: ODBC
Keywords..: SATTACH, QualKey, QUALCOLS, DSN, Data Source

Adding foreign data sources to an R:BASE database allows applications 
to access tables from multiple databases simultaneously.


When you access other databases, you are working with the actual 
data, not a copy. Not only can you view information from other 
databases, but you can modify and add information, depending on the 
access rights provided.


The first steps in attaching foreign data sources include being 
connecting to the R:BASE database, establishing the data source, and 
then connecting that DSN (data source name). In doing so, multiple 
data sources may be connected to concurrently.


Attaching foreign data source tables may be done with the SATTACH 
command or selecting "Utilities > Attach SQL Database Tables" from 
the main menu bar. It is with the table attach/SATTACH where the 
method and R:BASE settings must be considered to maintain ideal 
performance with the foreign data source.


When tables are attached, a QualKey column definition is assigned for 
columns that uniquely identifies a row, similar to a primary key or 
unique key. The QualKey is assigned based upon the method the table 
is attached to the database, and is used by R:BASE to link server data.


There are three different methods in which QualKeys are specified 
when tables are attached, and are ordered below by efficiency:


01.
SATTACH TableName USING ColumnList - uses the specified column(s) to 
assigned the QualKey that uniquely identify the rows. The ColumnList 
is not limited to a single column, but the more columns that are 
specified, then those column values must also match in WHERE clause 
conditions. A primary key should be specified as the ColumnList value.


02.
SATTACH TableName - automatically inquires with the foreign data 
source to find the optimal primary key column defined for the table 
being attached. If the column inquiry fails or does not find a 
primary key column, then QualKeys are defined based on the value for 
the QUALOCOLS setting, starting with the first column of the table. 
The number of columns assigned a QualKey is limited by the QUALCOLS value.


03.
SATTACH TableName USING ALL - assigns all columns as QualKeys

When performing a direct UPDATE to the foreign table, the USING ALL 
approach is the slowest in processing, which means that to qualify a 
row for updating, all of the column values must match. Rather, if a 
primary key exists, specify the column with USING PrimaryKeyColName 
instead, as this way, only the primary key value must match (which is 
all that should be needed). When updating a row on the foreign table, 
R:BASE must count how many rows match that row, and there should only 
be one matching row.


The origin of the QUALCOLS setting came into being when R:BASE first 
started attaching foreign data sources. QUALCOLS specifies the number 
of QualKeys to assign to SQL attached tables.


If a primary key was not found for the SATTACHed table, and a USING 
ColumnList was not specified for what columns uniquely identify a 
row, then R:BASE assigns a set of columns to identify that row 
starting with the first column of the table. The number of columns 
used was limited by the value for QUALCOLS.  The word was derived by 
knowing that R:BASE could QUALify a row by using a set of COLumnS.


As noted, QUALCOLS is only used when 1) no primary key can be found 
for the table or 2) the attach process does not specify a USING 
clause in the SATTACH command.


As is it more likely for a primary key to be located at the beginning 
(first or second column) of a table structure, setting QUALCOLS to 2 
would assign QualKeys to the first two columns. The following command 
sets QUALCOLS to 2:


SET QUALCOLS 2

To determine what columns have been assigned a QualKey for foreign 
data sources, use the LIST TABLE command. QualKeys are defined in the 
column attributes.


R>LIST TABLE Albums

   Table: albums   No Lock(s)
   Descr: Server table - Albums BluzVan
   Last structure modification: 08/03/2022 11:39 AM

 No. Column NameAttributes
 --- -- -
   1 Album_ID   Type   : INTEGER  QualKey
   2 AlbumTitle Type   : TEXT 40
   3 ReleaseDateType   : DATE
   4 RecordLabelType   : TEXT 30
   5 Artist_ID  Type   : TEXT 10
   6 MusicType  Type   : TEXT 10
   7 Comments   Type   : NOTE 4092
   Current number of rows:SERVER

The Albums table was attached from a DSN assigned to the BluzVan 
sample database. The "SATTACH Albums" command was used, and R:BASE 
was able to determine the Album_ID column as the primary key, and 
assign the QualKey accordingly.


For additional 

Re: [RBASE-L] - Crosstabs

[A. Razzak Memon]

Claes-Robert,

What is your LINES setting?

The LINES setting assigns the number of lines per page when you use 
your CROSSTAB command, and will repeat the column header for each 
page. The default value is 20.


Setting LINES to zero displays lines as continuous output, with only 
one row of columns.


SET LINES 0

Very Best R:egards,

Razzak

At 07:46 AM 8/4/2022, Claes-Robert Julander wrote:


Dear R:base users,
I use the crosstab command to make a column to several columns while 
retaining an idnumber. Since I want to export the table I only want 
to get the column names once.  Now I get the top col names on every 
screen. I have tried various ways of getting rid of the column names 
in the table. The cross tab generates 4000 thousand rows. Looking 
forward to learning how to get a  clean cross tab table.

Sincerely
Claes-Robert Julander




--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google 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/0MMTgu-1oMLOx118o-008KVJ%40mrelay.perfora.net.

Re: [RBASE-L] - Sauvegarde de tables dans une nouvelle base

[A. Razzak Memon]

Hello Jean-Marc,

The UNLOAD command is able to create your database from the desired tables.

The "FOR DATABASE" and "NOSCHEMA" keywords in the 
UNLOAD syntax will allow you to unload the 
specific structure and data portions needed for just those tables.


Using the RRBYW20 sample database, the below 
moves the Customer and Contact tables, with 
structure and data, into a new database.


OUTPUT CreateDatabase.rmd
UNLOAD STRUCTURE FOR DATABASE
UNLOAD STRUCTURE FOR Customer NOSCHEMA
UNLOAD STRUCTURE FOR Contact NOSCHEMA
UNLOAD DATA FOR Customer NOSCHEMA
UNLOAD DATA FOR Contact NOSCHEMA
OUTPUT SCREEN

Your routine must also unload/create the tables 
in the order following the primary key and 
foreign key relationships, with primary key tables being unload/create first.


Very Best R:egards,

Razzak


At 05:22 AM 8/3/2022, Jean-Marc Massé wrote:


Bonjour à tous,

Pourriez vous m’indiquer un moyen pour 
sauvegarder seulement une sélection de tables 
d’une base de données dans une nouvelle base ?


Merci de votre aide

Bien amicalement,


--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google 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/0Ln94d-1nnHjs1Dxd-00hO7d%40mrelay.perfora.net.

[RBASE-L] - Tip of the Day: Archiving Table Data in R:BASE

[A. Razzak Memon]

Wednesday, July 27, 2022

Tip of the Day: Archiving Table Data in R:BASE
Product...: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5)
Build.: 10.5.4.20616 or higher
Sections..: Maintenance
Keywords..: Archive, Table, Data, Performance, ODBC

Archiving tables in R:BASE databases is an ideal strategy to move 
infrequently accessed records, but are still of historical importance.


Data growth will impact an application's performance over time. With 
each new transaction, inactive data grows putting more pressure on 
application performance and availability. Operations and compliance 
concerns may arise, and batch jobs, data replication, and disaster 
recovery all run slower making users wait longer. Extended downtime 
must also be planned to convert legacy data to new releases during 
upgrade cycles.


Only the tables with a large number of records would be archived. An 
archive point (specific date or column value) would be best 
determined by you and application users/staff where the archive data is moved.


Archive tables may be stored in the existing database, or moved to 
another database entirely, to be accessed via ODBC.


To create an archive table for an OrderHeader table within the 
current database, use the following steps:


PROJECT OrderHeader_Archived FROM OrderHeader USING * WHERE LIMIT = 0
APPEND OrderHeader TO OrderHeader_Archived WHERE OrderDate <= 12/31/2020
DELETE ROWS FROM OrderHeader WHERE OrderDate <= 12/31/2020

You can otherwise use an unique identifier value (OrderID) for the 
WHERE clause, to maintain primary key/foreign key relationships.


PROJECT OrderHeader_Archived FROM OrderHeader USING * WHERE LIMIT = 0
APPEND OrderHeader TO OrderHeader_Archived WHERE OrderID < 1002587
DELETE ROWS FROM OrderHeader WHERE OrderID < 1002587

PROJECT OrderDetails_Archived FROM OrderDetails USING * WHERE LIMIT = 0
APPEND OrderDetails TO OrderDetails_Archived WHERE OrderID < 1002587
DELETE ROWS FROM OrderDetails WHERE OrderID < 1002587

To use another database to stored archive records, the original 
database table structure can be unloaded, to build an empty 
repository. Then, the data may be unloaded using the desired WHERE 
clause for the specific archive point.


If you will use the archive table for searching prior records, the 
constraints should be added to maintain optimal performance. The 
constraints may be unloaded from the original tables (UNLOAD 
STRUCTURE...), and altered for use with the intended archive table. 
The archive table constraints would match the original table 
constraints, where the primary/foreign keys link the archive tables. 
Only constraints related to the intended use would need to be 
applied, as querying the records would still take place. However, 
rules may not be needed if new data will no longer be added on a 
row-by-row basis. The added indexes to the archive tables will not 
effect the overall database performance.


Once the archive tables and record transfer process has been 
completed, a PACK/RELOAD must be performed upon the database.


If there is a need to query both current and archive records, perhaps 
more records would be left in the current tables, and less would be 
archived. Or, based upon the intended use, the original and archive 
content may be inserted into a temporary table for specific reports 
and queries.


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/0MGkbP-1oC4qd0NSD-00DWD6%40mrelay.perfora.net.

Re: [RBASE-L] - Printer questiion

[A. Razzak Memon]

Dick,

Once the printer is installed and configured as 
"Default Printer" on each workstation, you don't need to do anything.


However, if you wish to show the current default 
(R:BASE Session Printer), you may define the "On 
Before Start EEP" with the following variable and 
place the variable somewhere on your main menu.


SET VAR vSessionPrinter TEXT = ('R:BASE Session 
Printer:'&(CVAL('CURRENTPRINTER')))

RETURN

Very Best R:egards,

Razzak


At 10:49 AM 7/15/2022, Dick Fey wrote:

We are going from a single printer in our sales 
office to one for each desk.  What is the easiest way

to assign a different default printer to each machne?

Thanks,

Dick Fey

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




--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups "RBASE-L" group.

To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/0MehbC-1nsf7317oe-00OEDQ%40mrelay.perfora.net.

Re: [RBASE-L] - note vs varchar

[A. Razzak Memon]

Dan,

There is no problem using NOTE data type.

As few of our very complex R:BASE CRM and R:BASE Manufacturing 
Systems running on Cloud, include heavy use of notes (NOTE) and 
formatted text (VARCHAR) data without a problem.


Very Best R:egards,

Razzak


At 10:29 AM 7/8/2022, Dan Goldberg wrote:

I am exploring using the data type varchar for a few fields vs note. 
Reason being is I have a few note fields in a table but it seems 
like it could be a cause why a table keeps getting corrupted.


I have the note fields at the end of the table but no help. So I am 
thinking maybe using varchar instead.


Anyone have any thoughts/ideas?

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/0MZSCx-1nrLJU3Bwj-00LGWx%40mrelay.perfora.net.

Re: [RBASE-L] - WAIT setting and table locks

[A. Razzak Memon]

Doug,

Yes. The inquiry was for small increment for the INTERVAL and WAIT settings.

Please reply with the structure for the SHPT 
table which is accepting the INSERT, to evaluate the computed columns.


At the Database Explorer, right click on the 
table and select "Unload > Structure" and specify 
the file name. Then copy/paste the table 
definition in your reply. Or, at the R> enter 
"UNLOAD STRUCTURE FOR SHPT" and place the output in your reply.


Very Best R:egards,

Razzak

At 10:27 PM 6/30/2022, Doug Hamilton wrote:


Thank you for the quick response Razzak.
There are no functions in the SELECT.
The tables have 8 computed columns each but they 
are not included in the INSERT/SELECT.


The INTERVAL has remained at 5; WAIT was at 4 
seconds, bumped it to 8 on June 9 and to 15 seconds today, June 30.

BY increasing in "small increments", do you mean a second or two?

The INSERT into table SHPT is a SELECT columns 
from the temp table, tSHPT, no functions.
Immediately after the INSERT command, I trap the 
SQL Code and # of rows inserted and write them 
and the Table Lock Type to a DBActivityLog table.
If the SQL Code is not zero or if the number of 
rows inserted is zero, then I display an error message alerting the user.


Here is the code:

INSERT INTO SHPT +
  (TransactionID,DepotNumber,ShipDate,OrderNumber, +
  OrderType,OrderDate,CustomerDealercode,FacingDepotNumber, +
  OrderLineNumber,Item,PackagingCode,UnitofMeasure,InventoryType, +
  OriginalOrderLineQuantity,QuantityShipped, +
  NestedContainerNumber,UnitWeight,SCACode, +
  RouteStopCode,BillofLading,ModeCode,SaleDistributionCode, +
  TaskBarcodeSHPT,CustomerOrderNumber,CountryofOrigin, +
  TaskCreatedDate,TaskPickedDate,TaskPackedDate,Picker, +
  Packer,Loader,TaskLoadedDate, +
  PalletQuantity,SHPTNum,HazMat,SHPTStatus,CrossdockDestination, +
  Route,ShipTransportCode,RouteStopCode,PartLabelsPrintedDTS,CartonID)  +
 SELECT +
   tTransactionID,tDepotNumber,tShipDate,tOrderNumber, +
   tOrderType,tOrderDate,tCustomerDealercode,tFacingDepotNumber, +
   tOrderLineNumber,tItem,tPackagingCode,tUnitOfMeasure,tInventoryType, +
   tOriginalOrderLineQuantity,tQuantityShipped, +
   tNestedContainerNumber,tUnitWeight,tSCACode, +
   tRouteStopCode,tBillofLading,tModeCode,tSaleDistributionCode, +
   tTaskBarcode,tCustomerOrderNumber,tCountryofOrigin, +
   tTaskCreatedDate,tTaskPickedDate,tTaskPackedDate,tPicker, +
   tPacker,tLoader,tTaskLoadedDate, +
   tPalletQuantity,tSHPTNum,tHazMat,tSHPTStatus,tCrossdockDestination, +
 
  tRoute,tShipTransportcode,tRouteStopCode,tPartLabelsPrintedDTS,tCartonID  +

  FROM tSHPT

SET VAR vSQLCode = .SQLCODE
SET VAR vRowCount INTEGER = .RBTI_RowsInserted

-- 02/19/20: Below added to track rows inserted into SHPT, missing orders?
--Track data activity in DBActivityLog
--04/08/22:DHH:Added Table Lock Type to debug errs inserting tSHPT to SHPT
SET VAR +
  vTableLockType = (GETVAL('GetLockType','SHPT')), +
  pDBLogTable = 'SHPT', +
  pDBLogColumn = '', +
  pDBLogError = ('SQL Code ' + (CTXT(.vSQLCode))), +
  pDBLogAction =  +
  ('INS' & (CTXT(.vRowCount)) & 'tSHPT>SHPT;SHPTLock=' + .vTableLockType), +
  pDBLogLocation = 'MoparPartLbls,PRINTER,1097', +
  pDBLogPrimaryID = (IFEQ(.vRowCount,0,'Error',''))
RUN SELECT CmdCode FROM InternalCode WHERE CmdName = 'DBActivityLog'

-- 06/25/21: Below added to display message for user
IF vSQLCode <> 0 OR vRowCount = 0 THEN
  --Orders won't be going to SHPT, show err msg, undo update
  SET VAR vMsg = +
    (' Error creating shipping orders for these labels.' + +
    (CHAR(009))+(CHAR(013))& +
    'Please note the item,' & .vItem + +
    ', and Order number and rerun them.' + +
    (CHAR(009))+(CHAR(013))& +
    'Let Steve know the item number and this is Line # 1097.')
  PAUSE 2 USING .vMsg  +
   CAPTION 'Error'  +
   ICON WARNING BUTTON 'Continue'  +
   OPTION BACK_COLOR YELLOW +
   |MESSAGE_COLOR YELLOW +
   |MESSAGE_FONT_NAME Tahoma +
   |MESSAGE_FONT_COLOR WINDOWTEXT +
   |MESSAGE_FONT_SIZE 10 +
   |MESSAGE_FONT_BOLD ON +
   |BUTTON_COLOR RED

  --Added 06/29/21
  --Undo update to PIKD that labels for this item have been printed
  UPDATE PIKD SET +
    PartLabelsPrintedDTS = NULL +
   WHERE +
    PIKD_ID IN +
    (SELECT PIKD_ID FROM tPendingOrders WHERE PIKDProcessFlag = 'U')
ENDIF

Here are the entries in the DBActivityLog 
table.  The first 4 are from earlier in the 
program, the last row, # 2108238, is generated by the above code.
I would think the DateTime of the last row 
should be about 8 seconds later, 07:49:03.

[]




On 6/30/2022 6:22 PM, A. Razzak Memon wrote:

Doug,

If there are functions embedded within the 
value list or SELECT statement, there would be 
added processing to each INSERT.


Are there functions defined?

Please share the INSERT command.

Also, have you tried increasing the INTERVAL 
and

Re: [RBASE-L] - WAIT setting and table locks

[A. Razzak Memon]

Doug,

If there are functions embedded within the value 
list or SELECT statement, there would be added processing to each INSERT.


Are there functions defined?

Please share the INSERT command.

Also, have you tried increasing the INTERVAL and 
WAIT settings in small increments?


Very Best R:egards,

Razzak.


At 05:39 PM 6/30/2022, Doug Hamilton wrote:


Hi List -

I have code that inserts a row from a temp table 
into a permanent table; it's run an average of 
160 times a day on three different machines.


Once a week or so, the INSERT fails because 
there is a legitimate remote table lock on the 
permanent table that causes an SQL error code 
2440, "You reached 100% of your lock wait time. 
You must re-execute the command."Â  This occurs 
every time there is a remote table lock on the permanent table.


My understanding is that INSERT will attempt to 
execute every 5 tenths of a second (INTERVAL = 
5) for approx 8 seconds (WAIT = 8) or until the 
lock is removed, whichever occurs first.


But evidence (log table entries) indicates that 
it is waiting only about 2 seconds before throwing the SQL error.


This happens on any of the three machines that run this program.
They all read a common CFG file so WAIT, 
INTERVAL and all other settings are identical.


Any clues for the blues?

TIA,
Doug




--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google 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/1N33hJ-1ndop53Cij-013JYW%40mrelay.perfora.net.

[RBASE-L] - Tip of the Day: Automatically Rotate Images from EXIF File Information

[A. Razzak Memon]

Wednesday, June 29, 2022

Tip of the Day: Automatically Rotate Images from EXIF File Information
Product...: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5)
Build.: 10.5.4.20616 or higher
Sections..: Reports/Labels, Commands
Keywords..: PROPERTY, Image, Rotate, EXIF

Did you know that you can specify whether or not to have images 
automatically rotate in reports and labels?


A new PROPERTY command parameter for reports and labels, was 
introduced to auto-rotate images based upon the EXIF file information.


PROPERTY APPLICATION AUTO_ROTATE_IMAGE ON|OFF

When ON, the AUTO_ROTATE_IMAGE property will auto-rotate images using 
EXIF information for DB Image and Variable Image controls. The 
default value is OFF.


EXIF is short for Exchangeable Image File, a format that is a 
standard for storing interchange information in digital photography 
image files using JPEG compression. The EXIF data may contain details 
to rotate the display by a certain degrees value, which can be 
interpreted by R:BASE!


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/1MnqT8-1nIg2Q2QQM-00pNJn%40mrelay.perfora.net.

[RBASE-L] - Tip of the Day: Enhanced Debug Details for Database Character Setting Corruption

[A. Razzak Memon]

Tuesday, June 28, 2022

Tip of the Day: Enhanced Debug Details for Database Character Setting 
Corruption

Product...: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5)
Build.: 10.5.4.20616 or higher
Sections..: Settings
Keywords..: Corruption, Character Setting, Debug

Did you know that enhancements were made to help detect how, when, 
and why the database character setting values may get corrupted?


Whenever the setting data is read from file 1 (i.e., .RX1, .RB1), the 
date sequence will be checked to make sure the numbers are valid 
numbers. If the values are not expected, the current command and a 
mini-dump of the setting data will be created in a debug.err file.


If another portion of file 1 is bad, it may lead to the creation of 
the .RX0 or .RB0 structure diagnostic file, which will match the 
database name (e.g., RRBYW20.RX0, RRBYW20.RB0).


If the files are created, review the file contents. Both of the files 
may be opened with any text editor.


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/1N33hJ-1nehLJ3r0n-013JZi%40mrelay.perfora.net.

[RBASE-L] - Tip of the Day: Adjusting the Default Font of the BLOB Editor's Text Tab

[A. Razzak Memon]

Monday, June 27, 2022

Tip of the Day: Adjusting the Default Font of the BLOB Editor's Text Tab
Product...: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5)
Build.: 10.5.4.20616 or higher
Sections..: Commands
Keywords..: BLOB Editor, Default, Text, Font

Did you know that you can adjust the default font of the BLOB 
Editor's "Text" tab?


Additional PROPERTY command parameters have been introduced to alter 
the default font for the Text tab page of the BLOB Editor:


PROPERTY BLOB_EDITOR DEFAULT_TEXT_FONT_NAME 'Value'
PROPERTY BLOB_EDITOR DEFAULT_TEXT_FONT_SIZE 'Value'
PROPERTY BLOB_EDITOR DEFAULT_TEXT_FONT_BOLD 
PROPERTY BLOB_EDITOR DEFAULT_TEXT_FONT_ITALIC 
PROPERTY BLOB_EDITOR DEFAULT_TEXT_FONT_UNDERLINE 
PROPERTY BLOB_EDITOR DEFAULT_TEXT_FONT_STRIKEOUT 
PROPERTY BLOB_EDITOR DEFAULT_TEXT_FONT_NORMAL ' '

The commands will update the default settings, so values passed are 
"saved" once the BLOB Editor is closed. The DEFAULT_TEXT_FONT_NORMAL 
parameter uses a normal font for the Text page, removing any bold, 
italic, underline, and strikeout style in place.


When opening the BLOB Editor using the RBBEDIT command, the PROPERTY 
commands must be executed first, before launching the BLOB Editor. 
When opening the Data Browser using the BROWSE/EDIT commands, the 
PROPERTY commands must be executed first, before launching the Data Browser.


Example:

PROPERTY BLOB_EDITOR DEFAULT_TEXT_FONT_NAME Verdana
PROPERTY BLOB_EDITOR DEFAULT_TEXT_FONT_SIZE 10
PROPERTY BLOB_EDITOR DEFAULT_TEXT_FONT_BOLD ON

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/0MTRrt-1oG4cb0Xn5-00SLS1%40mrelay.perfora.net.

[RBASE-L] - Tip of the Day: Performing UTF-8 File Encoding Without BOM (Byte-Order Mark)

[A. Razzak Memon]

Friday, June 24, 2022

Tip of the Day: Performing UTF-8 File Encoding Without BOM (Byte-Order Mark)
Product...: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5)
Build.: 10.5.4.20616 or higher
Sections..: Commands
Keywords..: FCONVERT, UTF-8, ANSI, File Encoding, BOM

Did you know that file encoding conversions to UTF-8 with BOM can now 
be performed?


The FCONVERT command has been enhanced to convert files to the UTF-8 
without BOM (Byte-Order Mark) file encoding.


To do so, add the NONE keyword at the end of the FCONVERT command to 
specify the UTF-8 only file encoding.


FCONVERT ANSI CloudLog.csv TO UTF8 CloudLog_UTF8.csv NONE

The FCONVERT command is used to perform file encoding conversions 
between ANSI, UTF-8, UTF-8 BOM, Unicode, and Base64 files.


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/0M0ORH-1nnljV12Fh-00ucX5%40mrelay.perfora.net.

Re: [RBASE-L] - Fusion de Fichiers PDF

[A. Razzak Memon]

Jean-Marc Mass,

Oui.

Jetez un œil au R:PDFWorks X.5 pour atteindre votre objectif et plus encore...

https://www.rbase.com/products/rpdfworks/intro.php

Yes.

Take a look at the R:PDFWorks X.5 to accomplish your goal and more ...

https://www.rbase.com/products/rpdfworks/intro.php

Very Best R:egards,

Razzak


At 06:17 AM 6/22/2022, Jean-Marc Massé wrote:


Hi there,

Can you tell me if there is a solution in Rbase to merge multiple PDF files?

Thank you for your reply


--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google 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/0MfFYy-1oIuDc3QKo-00OnNS%40mrelay.perfora.net.

[RBASE-L] - Tip of the Day: Assigning Fixed Columns to Enhanced DB Grids

[A. Razzak Memon]

Wednesday, June 22, 2022

Tip of the Day: Assigning Fixed Columns to Enhanced DB Grids
Product...: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5)
Build.: 10.5.4.20616 or higher
Sections..: Forms
Keywords..: Enhanced DB Grid, Column, Fixed, Lock, Options

Did you know that a menu option has been added for Enhanced DB Grids 
to specify the number of fixed columns?


The ability to assign fixed columns for Enhanced DB Grids has been 
supported through the PROPERTY command. However, there was no menu 
option, to easily assign a value.


The "Fixed Columns" menu option was added within the Enhanced DB Grid 
property editor, to specifies the number of columns on the left of 
the grid that are fixed, and cannot be scrolled. Fixed columns is 
similar to how "locked columns" behave in the Data Browser.


Below is an example of the PROPERTY command to specify that 2 columns 
on the left of the grid cannot be scrolled.


PROPERTY ContactDetails FIXEDCOLS '2'

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/1MDQFe-1nvmyP1Wi6-00AXZm%40mrelay.perfora.net.

[RBASE-L] - Tip of the Day: Specifying No Text Qualifier for GATEWAY Command Exports

[A. Razzak Memon]

Tuesday, June 21, 2022

Tip of the Day: Specifying No Text Qualifier for GATEWAY Command Exports
Product...: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5)
Build.: 10.5.4.20616 or higher
Sections..: Commands
Keywords..: GATEWAY, Export, QUALIFIER, NONE, CSV, TAB, SQL

Did you know that the GATEWAY EXPORT command was enhanced to specify 
NONE as a valid value for the QUALIFIER parameter?


In the Export Wizard, there has always been a menu option to select 
"None" as the text qualifier. However, when choosing to perform an 
export using the command syntax, there is not a NONE option for the 
QUALIFIER parameter.


Support is now added for the GATEWAY EXPORT command to specify NONE 
as a valid value for the QUALIFIER parameter, for CSV, TAB, and SQL 
file formats.


GATEWAY EXPORT CSV StorageUnits.csv +
SELECT * FROM SUnits +
OPTION BLANK_IF_ZERO OFF +
|SHOW_PROGRESS ON +
|QUALIFIER NONE

The QUALIFIER parameter specifies the text qualifier for fields in 
the target export file. The popular value is quotes ("), but you can 
define any custom character you wish. Use the keyword PIPE as the 
value if you wish to use the pipe character (|)as the qualifier. Use 
the keyword NONE if you wish to specify no text qualifier.


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/1MMX5X-1oMfTl18PX-00JZwH%40mrelay.perfora.net.

[RBASE-L] - Tip of the Day: Setting to Toggle Sending Deleted Files to the Recycle Bin

[A. Razzak Memon]

Monday, June 20, 2022

Tip of the Day: Setting to Toggle Sending Deleted Files to the Recycle Bin
Product...: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5)
Build.: 10.5.4.20616 or higher
Sections..: Settings
Keywords..: Database Explorer, Delete, Recycle Bin, Database Files

Have you ever accidentally deleted a database from Database Explorer? 
Ouch! Unfortunately, there was no way to restore the deleted database.


Thankfully, we have created an amazingly capable feature in the 
latest update of R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5).


A new setting is introduced where deleted database files are now sent 
to the Recycle Bin.


In the Database Explorer, a setting is added where users can toggle 
sending deleted files to the Recycle Bin. The default is enabled.


File-based objects (external form files (.rff), application files 
(.rba), and command files) are already sent to the Recycle Bin. 
However, with this new setting, database files are now also sent to 
the Recycle Bin. Prior to the update, deleted database file were 
permanently removed from the computer, and were not sent to Recycle Bin.


Select "Settings > Database Explorer > Move Deleted Files to Recycle 
Bin" from the main menu bar.


To recover deleted database files on your PC:

. Right click on the Recycle Bin icon on desktop.
. Select Open from the context menu to view files.
. Check the box and select files you want to recover.
. Right click on a selected file.
. Choose 'Restore' to recover the file to its original location.

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/1MAftU-1nwead1XNQ-00B601%40mrelay.perfora.net.

[RBASE-L] - Tip of the Day: Detecting the Type of Network Connection

[A. Razzak Memon]

Friday, June 17, 2022

Tip of the Day: Detecting the Type of Network Connection
Product...: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5)
Build.: 10.5.4.20616 or higher
Sections..: Commands
Keywords..: GETPROPERTY, Connection Type, Network, Adapter

Did you know that new GETPROPERTY command 
parameters were implemented to detect the network connection type?


NETWORKCONNECTIONTYPE and NETWORKCONNECTIONTYPEEX 
are new parameters for the GETPROPERTY command.


NetworkConnectionType returns network connection 
type, with possible values being: Ethernet, Wi-Fi, Bluetooth, Unknown.


NetworkConnectionTypeEx is an expanded 
implementation of the property which considers 
the network adapter's metrics and returns the 
network connection type and name of the adapter, 
with possible return values being: Ethernet, Wi-Fi, Bluetooth.


GETPROPERTY APPLICATION NetworkConnectionTypeEx vConType
SHOW VAR vConType
vConType = Ethernet, ASIX AX88179 USB 3.0 to Gigabit Ethernet Adapter 

The ability to detect the network connection type 
is an ideal feature, especially for reliable connections to the database.


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/0LjHGD-1nQe231SoB-00dW3k%40mrelay.perfora.net.

[RBASE-L] - Released: Add-on Products for R:BASE X.5/X.5 Enterprise (Version 10.5)

[A. Razzak Memon]

Thursday, June 16, 2022

To All Users of R:BASE X.5 and R:BASE X.5 Enterprise Add-on Products:

Updates are now available for the following add-on products for 
R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5):


https://www.rbaseupdates.com

Build: 10.5.4.20616 - Update 4

. Oterro X.5 and Oterro X.5 Enterprise
. R:Charts X.5 and R:Charts X.5 Enterprise
. R:PDFWorks X.5
. R:BASE Editor X.5
. R:Docs X.5

This is a FREE update for all registered users who are within one 
year of their purchase or are active R:SAP subscribers for their 
licensed product.


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/0LqjJ6-1nWDYT2rWE-00eMyR%40mrelay.perfora.net.

[RBASE-L] - Released: R:BASE X.5/X.5 Enterprise (Version 10.5) - Update 4

[A. Razzak Memon]

Thursday, June 16, 2022

To All Users of R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5):

Official updates of R:BASE X.5/R:BASE X.5 Enterprise (Version 10.5) 
are now available.


https://www.rbaseupdates.com

Build: 10.5.4.20616 - Update 4

. R:BASE X.5 (Version 10.5)
. R:BASE X.5 (Version 10.5) - Corporate
. R:BASE X.5 (Version 10.5) - Compiler
. R:BASE X.5 (Version 10.5) - Runtime
. R:BASE X.5 Enterprise (Version 10.5)
. R:BASE X.5 Enterprise (Version 10.5) - Corporate
. R:BASE X.5 Enterprise (Version 10.5) - Compiler
. R:BASE X.5 Enterprise (Version 10.5) - Runtime

This Update 4, Build: 10.5.4.20616, includes a total of 64 
enhancements and 108 reported bug fixes.


Refer to WhatsNewInRBASE_X5_Update04.pdf for complete details. Please 
note the new format for the PDF document, where the more current 
enhancements and fixes are now listed first, and are grouped by release build!


This is a FREE update for all registered users of R:BASE X5/X5E who 
are within one year of their purchase or are active R:SAP subscribers.


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/0MFeL5-1nyePL3YiT-00Egxo%40mrelay.perfora.net.

Re: [RBASE-L] - Help not Working

[A. Razzak Memon]

Hello John,

Are you able to launch the help from the Database 
Explorer menus, such as Database Explorer > 
Databases > Help, which launches the help for the Database Explorer module?


There are also help buttons within the Form 
Designer's Property Editors for each control, and 
elsewhere throughout menus and dialog boxes.


It would also be a good test to try and launch 
the R:BASE help from the C:\ drive, to see if there is a difference.


Very Best R:egards,

Razzak.

R:BASE Technologies, Inc.
https://www.rbase.com


At 08:05 PM 6/7/2022, johnd...@gmail.com wrote:


Hi Razzak,

I removed the two fonts in that folder and 
re-booted my laptop but still no luck with the 
first three items on the Help menu. The tutorial 
works though. Is there any difference in the 
'mechanism' for running the help files ?  (The 
chm files are exactly the same as the ones on the laptop where Help does work.)


Thank you.
John Docherty

On Wednesday, June 8, 2022 at 8:05:16 AM UTC+12 johnd...@gmail.com wrote:
Hi Razzak,

Thanks for your reply. RBase is on the D drive. 
(I have a C & D on this laptop.)


I did install a new font a while ago so I will 
try that later. (Just off out now - already 
late)Â  I will let you know if that solves the issue.Â


Thanks for your help.

Regards
John Docherty

On Wednesday, June 8, 2022 at 1:38:29 AM UTC+12 A. Razzak Memon wrote:
Hello John,

Is the R:BASE installation on the local C:\ drive, a secondary drive,
or perhaps a network shared drive?

Do you have custom fonts installed on the computer? Navigate to the
"C:\Users\\AppData\Local\Microsoft\Windows\Fonts\" location
and remove any custom fonts loaded in the folder.

Very Best R:egards,

Razzak.

R:BASE Technologies, Inc.
<https://www.rbase.com>https://www.rbase.com


At 01:32 AM 6/7/2022, johnd...@gmail.com wrote:

>I was wondering if anyone has any suggestions as to why Help does
>not work on one of my laptops. (It is fine with the same version on
>the other one I use, so not an R:Base issue.) Any suggestions as to
>what I should try would be much appreciated. (I have reinstalled the
>latest version of Help but nothing changed.)
>
>Thank you.
>Regards
>John Docherty




--
For group guidelines, visit 
<http://www.rbase.com/support/usersgroup_guidelines.php>http://www.rbase.com/support/usersgroup_guidelines.php

---
You received this message because you 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.
To view this discussion on the web visit 
<https://groups.google.com/d/msgid/rbase-l/02cafcd6-4f95-4ce6-bf05-024f91a497c7n%40googlegroups.com?utm_medium=email_source=footer>https://groups.google.com/d/msgid/rbase-l/02cafcd6-4f95-4ce6-bf05-024f91a497c7n%40googlegroups.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/0MQy1w-1oBYPh0WrO-00UKlu%40mrelay.perfora.net.

Re: [RBASE-L] - Help not Working

[A. Razzak Memon]

Hello John,

Is the R:BASE installation on the local C:\ drive, a secondary drive, 
or perhaps a network shared drive?


Do you have custom fonts installed on the computer? Navigate to the 
"C:\Users\\AppData\Local\Microsoft\Windows\Fonts\" location 
and remove any custom fonts loaded in the folder.


Very Best R:egards,

Razzak.

R:BASE Technologies, Inc.
https://www.rbase.com


At 01:32 AM 6/7/2022, johnd...@gmail.com wrote:

I was wondering if anyone has any suggestions as to why Help does 
not work on one of my laptops. (It is fine with the same version on 
the other one I use, so not an R:Base issue.)  Any suggestions as to 
what I should try would be much appreciated. (I have reinstalled the 
latest version of Help but nothing changed.)


Thank you.
Regards
John Docherty





--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google 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/0MXrmL-1oIahw3F5T-00Wo1t%40mrelay.perfora.net.

[RBASE-L] - Tip of the Day: Custom EEP Documentation Following the Control Tab Order

[A. Razzak Memon]

Thursday, May 12, 2022

Tip of the Day: Custom EEP Documentation Following the Control Tab Order
Product...: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5)
Build.: 10.5.4.20421 or higher
Sections..: Forms
Keywords..: EEP, Custom EEP, Document, Tab Order

Did you know that the "Document Custom EEPs" option in the 
Form/External Form Designer now loads the output to follow the Tab 
Order of the controls?


The Document Custom EEPs feature for Forms and External Forms now 
produces its report following the Tab Order of controls.


The new change will make review of the code easier for locating 
commands, following variable definition and progression, and is more 
similar to the report/label Custom EEP output.


When generating Custom EEP documentation, output options include the 
clipboard, printer, text file, PDF file, the R:BASE Editor, and to 
launch the EEP Map.


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/0MCszN-1nge6l0R2x-009kPH%40mrelay.perfora.net.

[RBASE-L] - Tip of the Day: New Rule Notification for Dropped Columns

[A. Razzak Memon]

Wednesday, May 11, 2022

Tip of the Day: New Rule Notification for Dropped Columns
Product...: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5)
Build.: 10.5.4.20421 or higher
Sections..: Data Designer
Keywords..: Rule, Column, Table, Warning

Did you know that a notification will now appear after a column is 
dropped from a table, where a rule is defined for that column?


After dropping a column, the rules are now checked. If a rule for the 
table becomes invalid, an error message about the now dropped column 
will be displayed, similar to the message when a table/view is 
dropped and a view is dependent on that dropped table/view.


A rule is a condition placed upon a column, which R:BASE checks 
during data entry to ensure that the data meets specific criteria.


Rules can be created with predefined options, or with custom rules. 
Rules can be set to work with data entry and data deletion. A data 
entry rule ensures that the data entered into a column meets the 
criteria you specify. A data deletion rule ensures that data deleted 
in a column also meets specified criteria.


When you enter/edit or delete data, R:BASE checks the data with the 
corresponding rules. If the conditions of a particular rule are not 
met, R:BASE displays the error message defined for that rule. Rules 
can even be set to fail to meet conditions, and otherwise, R:BASE 
displays the error message defined for that rule.


Rules may be turned ON and OFF on demand with the RULES setting.

Syntax.: SET RULES ON/OFF
Default: ON

SET RULES determines whether R:BASE checks data against all existing 
rules during data entry and modification when you use the EDIT, EDIT 
USING, ENTER, INSERT, LOAD, or UPDATE commands, or the import/export utility.


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/1Mc0dX-1oLtQl1V0R-00dURX%40mrelay.perfora.net.

[RBASE-L] - Tip of the Day: Added Condition for PROPERTY TABLE Command Searches

[A. Razzak Memon]

Tuesday, May 10, 2022

Tip of the Day: Added Condition for PROPERTY TABLE Command Searches
Product...: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5)
Build.: 10.5.4.20421 or higher
Sections..: Forms
Keywords..: Search, PROPERTY, Table, Equals, Contains

Did you know that form searches performed with 
the PROPERTY command may now use exact criteria?


By default, the search functionality uses 
CONTAINS as the condition. If a search is 
performed for the value "10", the result will 
return anything that has 10 in it, such as 710, A10, 100, 1010, etc.


Syntax:

PROPERTY TABLE FormTableName SEARCH->FormColumnName-> VarName

The added EQUAL condition allows searches to 
always retrieve the exact record desired.


To search using EQUALS (exact search), add a 
equal character and enclose the search criteria 
in double quotes; "=("  and ")" .


PROPERTY TABLE 'ContactCallNotes' 'SEARCH->CallNotes->=(SearchText)'

The EQUALS criteria also provides more efficient 
usage, where with proper indexing the retrieval is faster.


Notes:

. The parameter is supported for the PROPERTY command only.
. The search method uses CONTAINS (partial 
search) by default to locate any text, which matches the provided criteria.
. To search using EQUALS (exact search), add a 
equal character and enclose the search criteria 
in double quotes; "=("  and ")" .


Example 01:
--Where the following command is used within a "On DB Grid Cell Click" EEP
--and a Variable Edit field "contains" the search criteria.
--GETPROPERTY DBGrid_Customer CurrentColumnName vColumnName

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

RETURN

Example 02:
--Where the following command is used within a "On DB Grid Cell Click" EEP
--and a Variable Edit field "equals" the search criteria.
--GETPROPERTY DBGrid_Customer CurrentColumnName vColumnName

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

RETURN

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/0MEovc-1nYS7U3y9q-00G4bJ%40mrelay.perfora.net.

Re: [RBASE-L] - Zebra-stripe banding within Report Detail Band

[A. Razzak Memon]

Bruce:

Take a closer look at the sample "ZebraStyleReport" in RRBYW20 sample 
database for complete details and the implementation technique of 
custom zebra colors, etc.


Have fun!

Razzak


At 11:50 AM 5/5/2022, Bruce Chitiea wrote:


All:

Q: What's the recipe for alternate-color banding of detail rows 
within a report's detail band?


(1) I know the Report Wizard (and data browser) can set up zebra 
banding, but I have not found the capability in the Report Designer proper;


(2) I know the trick of placing a colored rectangle object behind a 
row of dbedit controls in the detail band ... but that lays down a 
color band behind every row.


How to alternate?

Thanks much, Bruce



--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google 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/0Levg9-1oAvbu24qd-00qmJQ%40mrelay.perfora.net.

[RBASE-L] - Tip of the Day: Unloading Database Structure with Temporary Tables/Views

[A. Razzak Memon]

Tuesday, May 3, 2022

Tip of the Day: Unloading Database Structure with Temporary Tables/Views
Product...: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5)
Build.: 10.5.4.20421 or higher
Sections..: Commands
Keywords..: UNLOAD, Temporary, Table, View, STRUCTURE, ALL

Did you know that if there are temporary tables/views in a database 
when an UNLOAD ALL or UNLOAD STRUCTURE is performed, the temporary 
table/view definitions will now be included in the output?


The change was implemented for the benefit of database structures 
which contain views based upon on temporary tables/views, which are 
defined initially, and then dynamically deleted and recreated with 
required data sets throughout an application.


With such structures in mind, when the database rebuild is performed 
from an UNLOAD ALL or UNLOAD STRUCTURE errors are encountered when 
rebuilding the views based upon on temporary views. Also, the order 
in which the views are unloaded and subsequently rebuilt are not in 
the order where those views dependent on other views are last.


Now, the following is implemented:

01.
If there are temporary tables/views in a database when an UNLOAD ALL 
or UNLOAD STRUCTURE is performed, the temporary table/view 
definitions will now be unloaded as well. Prior to this change, the 
only way to unload a temporary table definition was to specifically 
name the table in the UNLOAD command.


02.
If a table or view needed to define a view cannot be found, after the 
error message about the missing item, you will get another message to 
identify the view that R:BASE was trying to create.


Also, did you know that the database schema stores the internal order 
in which tables and views were defined?


When the database structure is unloaded, the internal order is used 
for primary key tables to be created before foreign key tables. Views 
are also stored in the order of creation, where views based on other 
views are unloaded after all the other views it is dependent upon.


If any view that another view it is dependent upon is deleted and 
redefined, a PACK SCHEMA should be performed. Then, the view with the 
dependencies should be deleted and recreated. This would place the 
view with the dependencies after all the other views it is dependent 
upon within the internal order.


The steps would ensure a database UNLOAD and rebuild is successful 
where views with the dependencies are created last!


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/1N2VjX-1nySo93rsV-013xhH%40mrelay.perfora.net.

[RBASE-L] - Tip of the Day: Added Visual Functionality for PDF Viewer Control - Updated

[A. Razzak Memon]

Monday, May 2, 2022

Tip of the Day: Added Visual Functionality for PDF Viewer Control
Product...: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5)
Build.: 10.5.4.20421 or higher
Sections..: Forms
Keywords..: PDF Viewer, Display, Mouse, Drag

Did you know that the PDF Viewer control received an added visual 
functionality, to drag the document display in all directions with the mouse?


It is helpful for viewing all areas of PDF files by being able to 
move the PDF display around with the mouse within the control window.


To explore the properties available with the PDF Viewer control, run 
the PDFViewerControl form within the RRBYW20 sample database, which 
demonstrate the use of the control.


The following properties are used in the form sample:

 . CLEAR
 . FILENAME
 . GOTOFIRSTPAGE
 . GOTOLASTPAGE
 . GOTONEXTPAGE
 . GOTOPREVPAGE
 . PAGECOUNT
 . PAGELABEL
 . PAGENUMBER
 . PAGEROTATION
 . PRINT
 . PRINTFIT
 . PRINTPAGERANGE
 . ZOOM

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/0LgrcO-1oEYn53Mta-00oJcm%40mrelay.perfora.net.

[RBASE-L] - Tip of the Day: Enhanced PACK PASSWORD Command

[A. Razzak Memon]

Friday, April 29, 2022

Tip of the Day: Enhanced PACK PASSWORD Command
Product...: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5)
Build.: 10.5.4.20421 or higher
Sections..: Commands
Keywords..: PACK, PASSWORD, User Privileges, Maintenance

Did you know that the PACK PASSWORD command was enhanced to better 
clear out bogus rows?


When using the PACK PASSWORD command, the underlying logic will now 
perform a "PACK TABLE SYS_PASSWORDS" routine to internally remove 
deleted rows.


The PACK operation will also set the system table row count to match 
the actual row count after performing the PACK.


The PACK PASSWORD command is supported in multi-user sessions. The 
database must be connected in order to use the PACK PASSWORD command.


Performance boosting improvements have also been made when connecting 
to password protected databases, and when identifying permissions for 
USER accounts!


For users interested in implementing password protection for their 
databases, the "Managing User Privileges" technical document is available.


From The Edge: http://www.razzak.com/fte
Article Title: Managing User Privileges in R:BASE X.5 and R:BASE X.5 
Enterprise (Version 10.5)


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/0LvlsI-1nwLhH2SZY-017Tpl%40mrelay.perfora.net.

[RBASE-L] - Released: Add-on Products for R:BASE X.5/X.5 Enterprise (Version 10.5)

[A. Razzak Memon]

Wednesday, April 27, 2022

To All Users of R:BASE X.5 and R:BASE X.5 Enterprise Add-on Products:

Updates are now available for the following add-on products for 
R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5):


https://www.rbaseupdates.com

Build: 10.5.4.20426 - Update 4

. Oterro X.5 and Oterro X.5 Enterprise

This is a FREE update for all registered users who are within one 
year of their purchase or are active R:SAP subscribers for their 
licensed product.


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/0MVNfs-1nNJLU1iWM-00YhxF%40mrelay.perfora.net.

[RBASE-L] - Tip of the Day: Control the Folder Location for Data Browser Exports

[A. Razzak Memon]

Tuesday, April 26, 2022

Tip of the Day: Control the Folder Location for Data Browser Exports
Product...: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5)
Build.: 10.5.4.20421 or higher
Sections..: Data Browser
Keywords..: Export, System Variable, Folder, Default

Did you know that you can control the folder location for Data Browser exports?

A new RBTI_EXPORT_FOLDER system variable is available to define a 
default drive and folder path for Data Browser exports to prompt initially.


SET VAR RBTI_EXPORT_FOLDER TEXT = 'D:\UserExports'

When the Data Browser "Export Results to" menu option is selected for 
the current query, the dialog will initially start in the specified folder.


If the variable does not exist or contains a non-valid folder path, 
all export dialogs will launch within the current folder.


The new system variable is similar to the existing RBTI_IMG_FOLDER 
system variable, which is available for defining the default image load folder.


The default export location when exporting data from the Data Browser 
is helpful for database administrators to pass a different folder 
than the database folder, to prevent users from cluttering up the 
database folder.


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/0LjYVi-1oKbpD2KLo-00bbvW%40mrelay.perfora.net.

[RBASE-L] - Tip of the Day: Capturing the Windows Operating System Name

[A. Razzak Memon]

Friday, April 22, 2022

Tip of the Day: Capturing the Windows Operating System Details
Product...: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5)
Build.: 10.5.4.20421 or higher
Sections..: Commands/Functions
Keywords..: GETPROPERTY, CVAL, APPLICATION, Platform, Operation System

Did you know that you can capture the Windows operating system name 
with R:BASE commands and functions?


A new APPLICATION parameter for the GETPROPERTY command was 
introduced to return the operating system name.


GETPROPERTY APPLICATION PLATFORM vPlatformName
SHOW VAR vPlatformName
Windows 10 (64 bit) Professional

Also, the (CVAL('PLATFORM')) function was recently updated to return 
the operating system, architecture, and build.


SET VAR vPlatform TEXT = (CVAL('PLATFORM'))
SHOW VAR vPlatform
WIN64 OS=Windows 10 Enterprise Build=19043

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/1MY6bJ-1nPNBH1dvR-00YUmC%40mrelay.perfora.net.

[RBASE-L] - Tip of the Day: Automatic Scrolling Text in Memo/Rich Edit Controls

[A. Razzak Memon]

Thursday, April 21, 2022

Tip of the Day: Automatic Scrolling Text in Memo/Rich Edit Controls
Product...: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5)
Build.: 10.5.4.20421 or higher
Sections..: Forms
Keywords..: Scroll, Automatic, Interval, Memo, Rich Edit

Did you know that you can configure memo and rich edit controls to 
automatically scroll the text contents?


Two new form properties, AutoScrollInterval and AutoScrollContent, 
were added to allow automatic scrolling in all memos and rich edit controls.


The "Auto-Scroll Interval" property can only be defined within the 
Form Designer. The interval value specifies the length of time, in 
milliseconds, for the scrolling text to advance.


The AutoScrollContent property specifies to "begin scrolling" for the 
content of the form control, which can only be assigned (TRUE/FALSE) 
at runtime with the PROPERTY command.


PROPERTY OrderNotes AUTOSCROLLCONTENT 'TRUE'

The text within the object will automatically scroll, and when 
reaching the end of the text, resets to the top and continues scrolling.


The DB Memo, Variable Memo, Advanced DB Rich Edit, Advanced Variable 
Rich Edit, DB Rich Edit, Variable Rich Edit, DB Unicode Memo, and 
Variable Unicode Memo controls allow automatic scrolling.


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/0MGCMz-1nevtN3sUp-00FFpU%40mrelay.perfora.net.

[RBASE-L] - Released: Add-on Products for R:BASE X.5/X.5 Enterprise (Version 10.5)

[A. Razzak Memon]

Thursday, April 21, 2022

To All Users of R:BASE X.5 and R:BASE X.5 Enterprise Add-on Products:

Updates are now available for the following add-on products for 
R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5):


https://www.rbaseupdates.com

Build: 10.5.4.20421 - Update 4

. Oterro X.5 and Oterro X.5 Enterprise
. R:BASE Editor X.5
. R:Docs X.5

This is a FREE update for all registered users who are within one 
year of their purchase or are active R:SAP subscribers for their 
licensed product.


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/1MFKjN-1nfUFp1WNl-00FjQm%40mrelay.perfora.net.

[RBASE-L] - Released: R:BASE X.5/X.5 Enterprise (Version 10.5) - Update 4

[A. Razzak Memon]

Thursday, April 21, 2022

To All Users of R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5):

Official updates of R:BASE X.5/R:BASE X.5 Enterprise (Version 10.5) 
are now available.


https://www.rbaseupdates.com

Build: 10.5.4.20421 - Update 4

. R:BASE X.5 (Version 10.5)
. R:BASE X.5 (Version 10.5) - Corporate
. R:BASE X.5 (Version 10.5) - Compiler
. R:BASE X.5 (Version 10.5) - Runtime
. R:BASE X.5 Enterprise (Version 10.5)
. R:BASE X.5 Enterprise (Version 10.5) - Corporate
. R:BASE X.5 Enterprise (Version 10.5) - Compiler
. R:BASE X.5 Enterprise (Version 10.5) - Runtime

This Update 4, Build: 10.5.4.20421, includes a total of 53 
enhancements and 79 reported bug fixes.


Refer to WhatsNewInRBASE_X5_Update04.pdf for complete details.

This is a FREE update for all registered users of R:BASE X5/X5E who 
are within one year of their purchase or are active R:SAP subscribers.


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/1Mtg2t-1o2uDN1fsV-00v9sg%40mrelay.perfora.net.

[RBASE-L] - Tip of the Day: Scrapbooking in R:BASE

[A. Razzak Memon]

Thursday, March 03, 2022

Tip of the Day: Scrapbooking in R:BASE
Product...: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5)
Build.: 10.5.4.20222 or higher
Sections..: Forms/Reports/Labels
Keywords..: Scrapbook, Object, Control, Utility

Did you know that a Scrapbook utility is available within the Form 
and Report/Label Designers which acts as repository for created and 
commonly used objects?


In the Form/Report/Label designers, for any control, or group of 
controls, can be right clicked, where the "Add to Scrapbook" menu 
option is available. A name is then specified to assign the scrapbook entry.


Then, from any other form/report/label the Scrapbook can be launched, 
where scrapbook entries can be added for reuse. As a MDI window, the 
Scrapbook stays visible while the appropriate area is focused for 
object placement!


Scrapbook items may include commonly used objects, button panels, 
report regions, radio groups, grids, controls that have been tweaked 
to perfection, etc. The Form Designer and Report/Label Designer each 
have their own scrapbook repository.


The [Ctrl+Alt+B] key combination may be used within the designers to 
easily launch the Scrapbook utility.


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/1N4965-1o7voq2qwL-0105Ul%40mrelay.perfora.net.

[RBASE-L] - Tip of the Day: Enhanced Pop-up Menu Behavior for Default Selection

[A. Razzak Memon]

Wednesday, March 02, 2022

Tip of the Day: Enhanced Pop-up Menu Behavior for Default Selection
Product...: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5)
Build.: 10.5.4.20222 or higher
Sections..: Forms
Keywords..: Pop-up Menu, Default, Selection, Value

Did you notice the enhanced behavior for pop-up menus, where the 
current value is now automatically assigned the default selection?


When a pop-up menu is displayed for DB Edit, DB Memo, Variable Edit, 
Variable Memo, and Variable Unicode Memo form controls, the current 
value will now be assigned as the default selection for the pop-up 
menu. The feature allows for users to quickly select what is already 
assigned as the default.


Over the years, pop-up menus have advanced with many features to 
offer a custom-designed menu to return lookup values from other tables/views:


. Four Pop-up Types (Single Column, Multi Column, Expression, 
Expression with Column)

. Specify a dynamic WHERE Clause
. Display of distinct values
. Automatic pop-up menu display
. Custom menu Caption value
. Custom Title background color and font
. Automatic focus shift to the next object
. Custom menu Title value
. Custom List background color and font
. Specify the number of menu value lines
. Display of lines between the values
. Specify a maximum line width
. Specify if one mouse click is accepted to select an item

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/0MMko5-1nGrd82c2R-008b5d%40mrelay.perfora.net.

[RBASE-L] - Tip of the Day: Display a Hour Glass Cursor when Filtering Enhanced DB Grids

[A. Razzak Memon]

Tuesday, March 01, 2022

Tip of the Day: Display a Hour Glass Cursor when Filtering Enhanced DB Grids
Product...: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5)
Build.: 10.5.4.20222 or higher
Sections..: Forms
Keywords..: Enhanced DB Grid, Filter, Cursor, Hour Glass

Did you know that a hour glass may be assigned to the mouse cursor 
when filtering records for Enhanced DB Grid controls?


A new "Hour Glass Cursor On Filter" setting is now available for the 
Enhanced DB Grid control, where the cursor icon will change when 
filtering records.


The PROPERTY command may also be used to enable the setting:

PROPERTY EmpGrid WAITCURSORONFILTER 'TRUE'

The setting is helpful in that end users are aware that R:BASE is 
still processing in the background. The cursor change should prevent 
users from closing the application prematurely when thinking the 
program is not responding.


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/0MEXsd-1nRVw21iEj-00FmTi%40mrelay.perfora.net.

Re: [RBASE-L] - Suspend message

[A. Razzak Memon]

TRACE it (line-by-line), and you will see exactly what line and/or 
sequence is the cause.


At 09:13 AM 2/25/2022, jan johansen wrote:


Well, I'm the only one logged in using a temporary table.
I'm really trying to figure out at what point the message is being generated.



From: "A. Razzak Memon" 
To: rbase-l@googlegroups.com
Date: Fri, 25 Feb 2022 09:06:59 -0500
Subject: Re: [RBASE-L] - Suspend message

Jan,

Instead of suppressing that message, I suggest to closely review and
change your EEP and/or sequence that is generating that message.

As a developer, it would be the right thing to do, IMHO.

Razzak

At 09:00 AM 2/25/2022, jan johansen wrote:

>All,
>
>I'm interested in silencing this message;
>
>Data Has Been Changed by Another User Since Last Refresh. Do You
>Want to Save The Changes?

--
For group guidelines, visit 
<http://www.rbase.com/support/usersgroup_guidelines.php>http://www.rbase.com/support/usersgroup_guidelines.php

---
You received this message because you 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%2Bunsubscribe%40googlegroups.com>rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
<https://groups.google.com/d/msgid/rbase-l/0M07SM-1oD6RH1dLY-00uGLk%40mrelay.perfora.net>https://groups.google.com/d/msgid/rbase-l/0M07SM-1oD6RH1dLY-00uGLk%40mrelay.perfora.net.


--
For group guidelines, visit 
<http://www.rbase.com/support/usersgroup_guidelines.php>http://www.rbase.com/support/usersgroup_guidelines.php

---
You received this message because you 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.
To view this discussion on the web visit 
<https://groups.google.com/d/msgid/rbase-l/WC20220225141350.890045%40jjcalibrations.com?utm_medium=email_source=footer>https://groups.google.com/d/msgid/rbase-l/WC20220225141350.890045%40jjcalibrations.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/0MU0Mp-1noAhy355l-00Qjut%40mrelay.perfora.net.

Re: [RBASE-L] - Suspend message

[A. Razzak Memon]

Jan,

Instead of suppressing that message, I suggest to closely review and 
change your EEP and/or sequence that is generating that message.


As a developer, it would be the right thing to do, IMHO.

Razzak

At 09:00 AM 2/25/2022, jan johansen wrote:


All,

I'm interested in silencing this message;

Data Has Been Changed by Another User Since Last Refresh. Do You 
Want to Save The Changes?


--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google 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/0M07SM-1oD6RH1dLY-00uGLk%40mrelay.perfora.net.

[RBASE-L] - Tip of the Day: Perform Silent/Hidden Camera Captures

[A. Razzak Memon]

Friday, February 25, 2022

Tip of the Day: Perform Silent/Hidden Camera Captures
Product...: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5)
Build.: 10.5.4.20222 or higher
Sections..: Forms
Keywords..: Image, Capture, PROPERTY, Camera, Timeout, Hide

Did you know that the "capture from video" functionality has been 
enhanced to support silent/hidden camera snap shots?


With the enhanced CaptureFromVideoEx PROPERTY command parameter, an 
image may be captured from the dialog window without having to press 
the OK button.


As the CaptureFromVideoEx dialog may take a second or two to focus 
when initialized, the silent mode can be set to pause for a defined 
millisecond prior to the image capture.


Two extra parameters were added to the CaptureFromVideoEx parameter 
for the DB Image and Variable Image controls.


: auto-click wait time (milliseconds). Default = 0
: shows/hides the camera. Default = SHOW_CAMERA

Syntax (last two are new):

PROPERTY  CaptureFromVideoEx '   
 '


The fifth parameter (to show/hide the camera) is only interpreted if 
 is not zero.


Example:

-- Captures a JPG image after two seconds, without displaying the dialog,
-- using a maximum width and height dimensions of 320x240 pixels:
PROPERTY EmployeePhoto CaptureFromVideoEx 'JPG 320 240 2000 HIDE_CAMERA'

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/0LaVlh-1o5BOl3qb1-00mNdn%40mrelay.perfora.net.

[RBASE-L] - Tip of the Day: Simulate Mouse Double Click and Right Click in Forms

[A. Razzak Memon]

Thursday, February 24, 2022

Tip of the Day: Simulate Mouse Double Click and Right Click in Forms
Product...: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5)
Build.: 10.5.4.20222 or higher
Sections..: Forms
Keywords..: PROPERTY, Double Click, Right Click, EEP, Pup-up Menu

Did you know that you can simulate a mouse double click and a mouse 
right click in forms?


New PROPERTY command parameters were implemented to simulate a mouse 
double click and a mouse right click for form controls.


The syntax may be used to fire the control' appropriate EEP (On 
Double Click/On Right Click), as well as to display pop-up menu items 
in List View controls.


-- Simulates a double click for the Customer Name field
   PROPERTY CustomerName MAKEDBLCLICK ' '

-- Simulates a right click for the Customer List View
  PROPERTY CustomerList MAKERIGHTCLICK ' '

The last parameter will accept any value for the PROPERTY command.

The MAKEDBLCLICK and MAKERIGHTCLICK properties are similar to the 
MAKECLICK property, which specifies to fire the "On Click" EEP for 
button controls, simulating a mouse click.


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/1M9FOt-1nGvJX2sDf-006OAD%40mrelay.perfora.net.

[RBASE-L] - Released: Add-on Products for R:BASE X.5/X.5 Enterprise (Version 10.5)

[A. Razzak Memon]

Tuesday, February 22, 2022

To All Users of R:BASE X.5 and R:BASE X.5 Enterprise Add-on Products:

Updates are now available for the following add-on products for 
R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5):


https://www.rbaseupdates.com

Build: 10.5.4.20222 - Update 4

. Oterro X.5 and Oterro X.5 Enterprise
. RBAdmin X.5 and RBAdmin X.5 Enterprise
. R:Mail X.5
. R:Scope X.5 and R:Scope X.5 Enterprise
. R:BASE Editor X.5
. R:Docs X.5

This is a FREE update for all registered users who are within one 
year of their purchase or are active R:SAP subscribers for their 
licensed product.


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/0MKpCY-1nMNMF2G7U-00061G%40mrelay.perfora.net.

[RBASE-L] - Released: R:BASE X.5/X.5 Enterprise (Version 10.5) - Update 4

[A. Razzak Memon]

Tuesday, February 22, 2022

To All Users of R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5):

Official updates of R:BASE X.5/R:BASE X.5 Enterprise (Version 10.5) 
are now available.


https://www.rbaseupdates.com

Build: 10.5.4.20222 - Update 4

. R:BASE X.5 (Version 10.5)
. R:BASE X.5 (Version 10.5) - Corporate
. R:BASE X.5 (Version 10.5) - Compiler
. R:BASE X.5 (Version 10.5) - Runtime
. R:BASE X.5 Enterprise (Version 10.5)
. R:BASE X.5 Enterprise (Version 10.5) - Corporate
. R:BASE X.5 Enterprise (Version 10.5) - Compiler
. R:BASE X.5 Enterprise (Version 10.5) - Runtime

This Update 4, Build: 10.5.4.20222, includes a total of 37 
enhancements and 60 reported bug fixes.


Refer to WhatsNewInRBASE_X5_Update04.pdf for complete details.

This is a FREE update for all registered users of R:BASE X5/X5E who 
are within one year of their purchase or are active R:SAP subscribers.


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/1MyKcC-1o9wYi1BFM-00ylPr%40mrelay.perfora.net.

Re: [RBASE-L] - Introducing Loyalty Points Calculator (Powered by R: BASE® )

[A. Razzak Memon]

Bruce,

Brilliant!

As you all know, I don't ration my passion, I share it!

I have been an elite member of US Airways and now 
American Airlines for over 30 years. This is 
something very close to my heart, that I have 
been wanting to do since the introduction of new 
AAdvantage Loyalty Points by American Airlines! 
And the idea that this tool could potentially help other elite members.


And, to introduce R:BASE and its unlimited 
capabilities to a whole new audience (in 
millions) outside the current R:BASE world!


For R:BASE community and developers, this is an 
example of developing and deploying R:BASE and 
Java applications on MS Windows Desktop and secure Cloud environment, like AWS.


Thank you!

Razzak

At 12:40 PM 2/5/2022, Bruce Chitiea wrote:


Razzak:

What you need now is a guerilla marketing 
campaign to get this in front of every executive 
who flies American Airlines, make it easy for 
their assistants and secretaries to get and use 
it; then make every other airline jealous to have it for their customers.


**BOOM**Â The entire business planet is now 
aware of, and intrigued, as to what RBTI and 
R:BASE developers might be able to do for them.


And why stop there? Why, heck, even my local 
sandwich shop has a loyalty program.


Just sayin'.

Congrats, Bruce

Bruce A. Chitiea |Â SafeSectors, Inc.
112 Harvard Ave #272 |Â Claremont CA 91711-4716 |Â USA
rby...@safesectors.com | +011 (909) 238-9012 c | +011 (909) 912-8678 f

-- Original Message --
From: "A. Razzak Memon" <<mailto:raz...@rbase.com>raz...@rbase.com>
To: <mailto:rbase-l@googlegroups.com>rbase-l@googlegroups.com
Sent: 2/5/2022 6:53:20 AM
Subject: [RBASE-L] - Introducing Loyalty Points 
Calculator (Powered by R: BASE® )



To R:BASE Community:
Â
If you are a member of AAdvantage® (American 
Airlines' frequent flyer program), you may enjoy this post.

Â
Introducing Loyalty Points Calculator (Powered by R:BASE®)
Â
Since the announcement of the new AAdvantage® 
(American Airlines' frequent flyer program) on 
October 26, 2021, I have been fascinated by 
Loyalty Points and the ways one can earn those 
points by flying on American Airlines and oneworld partners.

Â
Being passionate about American Airlines, it 
was a challenge, and a brainchild was born 
during the holidays, thus the development of 
Loyalty Points Calculator, both desktop and web 
versions. Managing the technology business for 
over 30 years and working in the database 
world, made it easy to conceptualize and turn the challenge into reality.

Â
Powered by R:BASE® (Robust SQL Engine), there 
are two versions of Loyalty Points Calculator:

Â
MS Windows Desktop Version
<https://rbase.com/lpcalculator/>https://rbase.com/lpcalculator/
Â
Features:
. Multi-Segment Partner Flight and Multi-Fare Codes Calculations
. Built-in mileage calculator engine
. Built-in feature to export saved itineraries as XLS spreadsheet
. Built-in feature to print saved itineraries as PDF file
. Fully compatible with all Microsoft Operating Systems
Â
Online Web Portal
<https://lpcalculator.com>https://lpcalculator.com
Â
Features:
. Built-in mileage calculator engine
. Multi-Segment Partner Flight and Multi-Fare 
Codes Calculations (under development)
. Built-in feature to export saved itineraries 
as XLS spreadsheet (under development)

. Built-in feature to print saved itineraries as PDF file (under development)
. Fully compatible and responsive with all 
modern web browsers, including iOS and Android devices.

Â
I hope you all find this tool helpful when 
calculating estimated Loyalty Points on 
American Airlines and oneworld Partners.

Â
Very Best R:egards,
Â
Razzak
<https://www.rbase.com>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/0Levg9-1mQMIk1lXD-00qlrb%40mrelay.perfora.net.

[RBASE-L] - Introducing Loyalty Points Calculator (Powered by R: BASE® )

[A. Razzak Memon]

To R:BASE Community:

If you are a member of AAdvantage® (American 
Airlines' frequent flyer program), you may enjoy this post.


Introducing Loyalty Points Calculator (Powered by R:BASE®)

Since the announcement of the new AAdvantage® 
(American Airlines' frequent flyer program) on 
October 26, 2021, I have been fascinated by 
Loyalty Points and the ways one can earn those 
points by flying on American Airlines and oneworld partners.


Being passionate about American Airlines, it was 
a challenge, and a brainchild was born during the 
holidays, thus the development of Loyalty Points 
Calculator, both desktop and web versions. 
Managing the technology business for over 30 
years and working in the database world, made it 
easy to conceptualize and turn the challenge into reality.


Powered by R:BASE® (Robust SQL Engine), there are 
two versions of Loyalty Points Calculator:


MS Windows Desktop Version
https://rbase.com/lpcalculator/

Features:
. Multi-Segment Partner Flight and Multi-Fare Codes Calculations
. Built-in mileage calculator engine
. Built-in feature to export saved itineraries as XLS spreadsheet
. Built-in feature to print saved itineraries as PDF file
. Fully compatible with all Microsoft Operating Systems

Online Web Portal
https://lpcalculator.com

Features:
. Built-in mileage calculator engine
. Multi-Segment Partner Flight and Multi-Fare 
Codes Calculations (under development)
. Built-in feature to export saved itineraries as 
XLS spreadsheet (under development)

. Built-in feature to print saved itineraries as PDF file (under development)
. Fully compatible and responsive with all modern 
web browsers, including iOS and Android devices.


I hope you all find this tool helpful when 
calculating estimated Loyalty Points on American 
Airlines and oneworld Partners.


Very Best R:egards,

Razzak
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/1MMX5X-1mxRqQ2e75-00JdgK%40mrelay.perfora.net.

Re: [RBASE-L] - PRINT

[A. Razzak Memon]

Jan,

Here's how ...

Use the RBTI_PRNDEFFILE system variable to define the default file 
name for the "Print to File" print dialog, before the dialog is launched.


SET VAR RBTI_PRNDEFFILE TEXT = 'InventoryReport.pdf'

The below report-based RBTI system variables are also available:

RBTI_PRNDEFDIR - defines the default directory for the "Print to 
File" print dialog, before the dialog is launched


SET VAR RBTI_PRNDEFDIR TEXT = 'C:\Temp\'

RBTI_PRNDEFFILET - defines the default output type for the "Print to 
File" print dialog, before the dialog is launched


SET VAR RBTI_PRNDEFFILET TEXT = 'Adobe PDF File'

Have fun!

Very Best R:egards,

Razzak.

R:BASE Technologies, Inc.
https://www.rbase.com


At 07:12 AM 2/4/2022, jan johansen wrote:


All,

I thought I'd seen this before but I'm not sure.

Most of the time printing a report to SCREEN is the preferred option.
However, when I want to "Print to a file" from the SCREEN, the file name
shows as the called report i.e. PRINT MyReport shows up as MyReport in the
print to file area.

Is there a way to pre-define what that filename will be?

I'm not interested in printing as PDF and launching.

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/0MLNQq-1nGYVZ0MRW-000e2M%40mrelay.perfora.net.

Re: [RBASE-L] - Formatting

[A. Razzak Memon]

Here's how ...

SET VAR vMakeDir TEXT = (FORMAT(.#DATE,'_MM'))

That's all there is to it!

Very Best R:egards,

Razzak

At 07:18 AM 1/12/2022, jan johansen wrote:


Group,

Desired end result: 2022_01

I want RBase to create a directory named "2022_01"
I can use this
SET VAR vMakeDir TEXT = ( (CTXT(IYR4,.#DATE))+'_'+(CTXT(IMON,.#DATE)) )
but that results in 2022_1

How can I format the "month" to be 2 characters?

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/0MVen3-1mqpSP0Lk7-00Z0yW%40mrelay.perfora.net.

Re: [RBASE-L] - Launch command

[A. Razzak Memon]

Dick,

Here's how ...

You can use the pipe character to specify a parameter:

LAUNCH 'C:\Program Files\Mozilla Firefox\Firefox.exe|https://www.rbase.com/'

Very Best R:egards,

Razzak.

R:BASE Technologies, Inc.
https://www.rbase.com


At 05:57 PM 1/11/2022, Dick Fey wrote:


Some places we use the LAUNCH command to open a browser.

ie:Â  Launch 'C:\Program Files\Mozilla Firefox\Firefox.exe'

Is there a way to direct it to a specific website?

Thanks,

Dick Fey




--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google 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/0Mbf87-1mp4VT3Ebl-00J6b6%40mrelay.perfora.net.