[RBASE-L] - Re: After-Printing EEP

2018-11-01 Thread A. Razzak Memon
Doug, What you can do is enhance the menus to provide separate "Print to Screen" and "Print to Printer" options. And, to protect users from printing the report from the Print Preview screen, disable the display of the Printer button. PRINT Invoice WHERE TransID = 1002 + OPTION

RE: [RBASE-L] - NOT RESPONDING

2018-10-04 Thread A. Razzak Memon
ine -Original Message- From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of A. Razzak Memon Sent: Wednesday, October 03, 2018 9:11 PM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - NOT RESPONDING Hi Claudine, That is a very common symptom when performing l

Re: [RBASE-L] - NOT RESPONDING

2018-10-03 Thread A. Razzak Memon
Hi Claudine, That is a very common symptom when performing long running time-consuming routines. There are a few techniques to improve such performance. 01. Use of PROCESSMESSAGE command in WHILE ... ENDWHILE loop. While process a time-consuming routine and displaying the PAUSE 3 message

Re: [RBASE-L] - Moving RBASE XE License from One computer to Another Computer

2018-09-24 Thread A. Razzak Memon
John, That pretty much sums it up. Feel free to reach out to the support team at mailto:supp...@rbase.com if you need further assistance. Very Best R:egards, Razzak At 07:14 PM 9/24/2018, John Murnane wrote: We are using R:BASE X Enterprise for Windows (version 10.0.4.10913) - Single

[RBASE-L] - Tip of the Day: Fire Tree View Node's EEP Outside of the Control

2018-09-12 Thread A. Razzak Memon
Wednesday, September 12, 2018 Tip of the Day: Fire Tree View Node's EEP Outside of the Control Product...: R:BASE X and R:BASE X Enterprise (Version 10) Build.: 10.0.4.10912 or higher Sections..: Forms, Commands Keywords..: Tree View, Node, EEP, MAKECLICK Did you know you

[RBASE-L] - Released: R:BASE X/XE (Version 10) - Add-on Products

2018-09-11 Thread A. Razzak Memon
Wednesday, September 12, 2018 To All Users of R:BASE X and R:BASE X Enterprise Add-on Products: Updates are now available for the following add-on products for R:BASE X and R:BASE X Enterprise (Version 10): https://www.rbaseupdates.com Build: 10.0.4.10912 - Update 4 . Oterro X and Oterro X

[RBASE-L] - Released: R:BASE X/XE (Version 10) - Update 4

2018-09-11 Thread A. Razzak Memon
Wednesday, September 12, 2018 To All Users of R:BASE X and R:BASE X Enterprise (Version 10): Official updates of R:BASE X/R:BASE X Enterprise (Version 10) are now available. This Update 4, Build: 10.0.4.10912, includes a total of 7 enhancements and 22 reported bug fixes.

Re: [RBASE-L] - Reset User Count

2018-08-29 Thread A. Razzak Memon
Stephen, See attached screenshot that illustrates it all. Since this a very critical operation, it must be performed manually. At this time, there is no command to execute such critical function. Very Best R:egards, Razzak At 11:08 AM 8/29/2018, Stephen Markson wrote: Hello, Does anyone

Re: [RBASE-L] - Multiple Data Browser Windows

2018-08-25 Thread A. Razzak Memon
ren -Original Message- From: A. Razzak Memon To: rbase-l Sent: Sat, Aug 25, 2018 12:19 am Subject: Re: [RBASE-L] - Multiple Data Browser Windows D'day Clive, There are three approaches to accomplish the desired results ... 01. While opening the table, make sure to check the option f

Re: [RBASE-L] - Multiple Data Browser Windows

2018-08-24 Thread A. Razzak Memon
D'day Clive, There are three approaches to accomplish the desired results ... 01. While opening the table, make sure to check the option for MDI. Database Explorer > Database Explorer > Tables > Open Make sure to check the box for [x] MDI See attached screen shot for complete

Re: [RBASE-L] - _history folder

2018-08-24 Thread A. Razzak Memon
Stephen, It keeps track of all your EEP (edits/revisions/versions). This is part of the Default Form Settings. Very Best R:egards, Razzak At 03:05 PM 8/24/2018, Stephen Markson wrote: Does anyone know what the _history folder is that sometimes appears in my database folders? Regards,

Re: [RBASE-L] - Get form name via key combo

2018-08-23 Thread A. Razzak Memon
Jim, Ctrl+Alt+I Have fun! Razzak At 02:18 PM 8/23/2018, jroberts wrote: Hi All, Can anyone tell me what the key combo is to display the name of the currently active form? Razzak showed this to us at the San Diego SAT class but I can't remember what it was. Thanks, Jim -- For group

Re: [RBASE-L] - EnhancedVarCalendar with Show Days off

2018-08-21 Thread A. Razzak Memon
Lena, FWIW, what you are seeing is the customized display format, the DATE FORMAT/SEQ is still maintained behind the scenes. If you need to capture the same format as displayed on the calendar, you may use the technique as follows: -- Example SET VAR vDate DATE = 7/1/2018 SET VAR v1

[RBASE-L] - Tip of the Day: Capture Highlighted Field Name in the Data Browser

2018-08-21 Thread A. Razzak Memon
Tuesday, August 21, 2018 Tip of the Day: Capture Highlighted Field Name in the Data Browser Product...: R:BASE X and R:BASE X Enterprise (Version 10) Build.: 10.0.4.10808 or higher Sections..: Data Browser Keywords..: Field Name, Column, Capture Did you know a new hot key

Re: [RBASE-L] - Determining operating condition -- Standalone vs. Scripted

2018-08-17 Thread A. Razzak Memon
Mike, You may also use the "-Txxx" executable option to add an additional text label to an R:BASE instance, where xxx is a custom text (e.g. Development) or "RandomID". The label will allow you to identify the running the instance in the Task Manager, which is useful in your case with

Re: [RBASE-L] - Determining operating condition -- Standalone vs. Scripted

2018-08-17 Thread A. Razzak Memon
Mike, Would (CVAL('CONNECTIONS')) help? (CVAL('CONNECTIONS')) Returns the number of users currently connected to the current database or 0 if not connected. In the event of a non-graceful disconnect R:BASE will not be able to decrement the connections count. This can occur if the network

Re: [RBASE-L] - Tip of the Day: Scrutinize Security Software with R:BASE X/X Enterprise

2018-08-10 Thread A. Razzak Memon
Works Quality Department Phone: 740-829-4340 Cell: 740-502-1659 From:"A. Razzak Memon" To:rbase-l@googlegroups.com, Date:07/26/2018 11:21 AM Subject:[RBASE-L] - Tip of the Day: Scrutinize Security Software with R:BASE X/X Enterprise Sent by:

[RBASE-L] - Tip of the Day: Mouse Click Sensitivity for Radio Group Items

2018-08-10 Thread A. Razzak Memon
Friday, August 10, 2018 Tip of the Day: Mouse Click Sensitivity for Radio Group Items Product...: R:BASE X and R:BASE X Enterprise (Version 10) Build.: 10.0.4.10808 or higher Sections..: Forms Keywords..: Radio Button Group, Mouse Click, Click in Items Did you know the

[RBASE-L] - Tip of the Day: Selection Mask for Database Explorer Command Files

2018-08-09 Thread A. Razzak Memon
Thursday, August 09, 2018 Tip of the Day: Selection Mask for Database Explorer Command Files Product...: R:BASE X and R:BASE X Enterprise (Version 10) Build.: 10.0.4.10808 or higher Sections..: Database Explorer Keywords..: Command Files, File Selection, Mask, Expand, Shrink

Re: [RBASE-L] - Arrange by

2018-08-08 Thread A. Razzak Memon
Here's how ... Based on sample RRBYW19 database ... EDIT USING SalesTransactions + ARRANGE InvoiceHeader BY TransID, + ARRANGE InvoiceDetail BY DetailNum, + ARRANGE Employee BY EmpLName,EmpFName + ARRANGE Contact BY ContLName,ContFName + ORDER BY Company WHERE CustState = 'PA' RETURN Hope it

Re: [RBASE-L] - Tip of the Day: Enhanced Case Sensitive and Whole Word Search Options

2018-08-08 Thread A. Razzak Memon
LNo" in these 2 examples I typed into a custom eep: CREATE TEMP TABLE tmpBL (BLNo Int ..) SELECT blno, bdate INTO .. Good job! Karen -Original Message----- From: A. Razzak Memon To: rbase-l Sent: Wed, Aug 8, 2018 7:08 am Subject: [RBASE-L] - Tip of the Day: Enhanced Case Sensi

[RBASE-L] - Tip of the Day: Enhanced Case Sensitive and Whole Word Search Options

2018-08-08 Thread A. Razzak Memon
Wednesday, August 08, 2018 Tip of the Day: Enhanced Case Sensitive and Whole Word Search Options Product...: R:BASE X and R:BASE X Enterprise (Version 10) Build.: 10.0.4.10808 or higher Sections..: Database Explorer, Forms, Reports, Labels, External Forms Keywords..: Search,

[RBASE-L] - Released: R:BASE X/XE (Version 10) - Add-on Products

2018-08-07 Thread A. Razzak Memon
Wednesday, August 8, 2018 To All Users of R:BASE X and R:BASE X Enterprise Add-on Products: Updates are now available for the following add-on products for R:BASE X and R:BASE X Enterprise (Version 10): https://www.rbaseupdates.com Build: 10.0.4.10808 - Update 4 . Oterro X and Oterro X

[RBASE-L] - Released: R:BASE X/XE (Version 10) - Update 4

2018-08-07 Thread A. Razzak Memon
Wednesday, August 8, 2018 To All Users of R:BASE X and R:BASE X Enterprise (Version 10): Official updates of R:BASE X/R:BASE X Enterprise (Version 10) are now available. This Update 4, Build: 10.0.4.10808, includes a total of 5 enhancements and 11 reported bug fixes since the last Update 3

Re: [RBASE-L] - Temp Table: Delete Rows or Drop Table?

2018-05-26 Thread A. Razzak Memon
Hi Mohammed, Your assessment is correct. As explained in my mini-tutorial to Bruce Chitiea on May 20th, I suggested the technique as follows: SET ERROR MESSAGE 2038 OFF DROP TABLE tablename SET ERROR MESSAGE 2038 ON CREATE TEMPORARY TABLE tablename ... or PROJECT TEMPORARY tablename FROM

Re[2]: [RBASE-L] - Temp Table: Delete Rows or Drop Table?

2018-05-20 Thread A. Razzak Memon
Bruce: To DELETE ROWS, the temp TABLE must exist first. otherwise you will run into another -ERROR- message as follows: -ERROR- tablename is an undefined table. (2038) In that case, you have to first check the existence of TEMPORARY table and then use the DELETE ROWS from that TEMP table.

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

2018-05-16 Thread A. Razzak Memon
il: <mailto:ftay...@fjohara.com>ftay...@fjohara.com -Original Message- From: <mailto:rbase-l@googlegroups.com>rbase-l@googlegroups.com <<mailto:rbase-l@googlegroups.com>rbase-l@googlegroups.com> On Behalf Of A. Razzak Memon Sent: Wednesday, May 16, 2018 3:00 PM To:

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

2018-05-16 Thread A. Razzak Memon
asino and Spa: https://southpointcasino.com The growth we've experienced over the years is because of a superior community of R:BASE users, who unwaveringly support us! Please stay tuned for more details ... http://www.rbase.com/conference We hope to see you all in Las Vegas! Razzak. A. Razzak Memon Founder, Pr

RE: [RBASE-L] - R:BASE Technologies, Inc. - Special Announcement

2018-05-15 Thread A. Razzak Memon
t 3:15 PM, Claudine Robbins <crobb...@iexgroup.com> wrote: Like a kid waiting for Santa... Did I miss it or was there no TipoftheDayDigest_2017.pdf? Claudine :-) -Original Message- From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of A. Razzak Me

[RBASE-L] - Working with R:BASE XE, Oterro XE, and Java

2018-05-15 Thread A. Razzak Memon
To All Users of R:BASE X Enterprise and Oterro X Enterprise (Version 10): If you are designing, developing, and deploying high-end business web applications using R:BASE X Enterprise and Oterro X Enterprise (Version 10) with Java, you may download and install the current versions and updates

[RBASE-L] - Released: R:BASE X/XE (Version 10) - Update 3

2018-05-14 Thread A. Razzak Memon
Tuesday, May 15, 2018 To All Users of R:BASE X and R:BASE X Enterprise (Version 10): Official updates of R:BASE X/R:BASE X Enterprise (Version 10) are now available. This Update 3, Build: 10.0.3.20515, includes a total of 54 enhancements and 100 reported bug fixes.

[RBASE-L] - R:BASE Technologies, Inc. - Special Announcement

2018-05-11 Thread A. Razzak Memon
Saturday, May 12, 2018 To R:BASE Community: Stay tuned for a special announcement from R:BASE Technologies, Inc., on Wednesday, May 16, 2018 at 3:00 PM (EST). Very Best R:egards, Razzak A. Razzak Memon Founder, President & CEO R:BASE Technologies, Inc. http://www.rbase.com

[RBASE-L] - Tip of the Day: Managing Folders and File Names

2018-05-10 Thread A. Razzak Memon
Thursday, May 10, 2018 Tip of the Day: Managing Folders and File Names Product...: R:BASE X and R:BASE X Enterprise (Version 10) Build.: 10.0.3.20320 or higher Section...: Managing Folders and Files Keywords..: COPY,CURRDIR,CURRDRV,DBPATH,DELETE,DIR,ERASE,LAUNCH,MKDIR,RENAME

Re: [RBASE-L] - Is there a way of password locking a single column in a table?

2018-05-09 Thread A. Razzak Memon
Stephen, If you are using R:BASE X Enterprise (Version 10.0 or 10.5), let me know and I'll show you a technique to accomplish your goal. https://join.me/RazzakMemon Very Best R:egards, Razzak At 10:25 PM 5/9/2018, Stephen Breen wrote: I never thought about this but, Is there a way of

[RBASE-L] - R:BASE Training in San Diego Pics

2018-05-05 Thread A. Razzak Memon
R:BASE X Enterprise Super Advanced Training in San Diego, CA pics are posted on Facebook. https://www.facebook.com/RBASE/ Very Best R:egards, Razzak -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are

Re: AW: [RBASE-L] - Gateway XLS

2018-05-03 Thread A. Razzak Memon
t- Von: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] Im Auftrag von A. Razzak Memon Gesendet: Donnerstag, 3. Mai 2018 15:06 An: rbase-l@googlegroups.com Betreff: Re: [RBASE-L] - Gateway XLS Stepfan, Use may use the "AS" option to define names when creat

Re: [RBASE-L] - Gateway XLS

2018-05-03 Thread A. Razzak Memon
Stepfan, Use may use the "AS" option to define names when creating XLS. Here's how ... -- GATEWAY_EXPORT_XLS.RMD -- Start here CONNECT RRBYW19 SET ERROR MESSAGE 2077 OFF DELETE InvoiceHeader.xls SET ERROR MESSAGE 2077 ON GATEWAY EXPORT XLS InvoiceHeader.xls + SELECT TransID

RE: [RBASE-L] - date picker cutting off

2018-05-02 Thread A. Razzak Memon
something in my settings lol Dan Goldberg -Original Message- From: rbase-l@googlegroups.com <rbase-l@googlegroups.com> On Behalf Of A. Razzak Memon Sent: Wednesday, May 2, 2018 2:44 PM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - date picker cutting off Dan, Here's what I ge

Re: [RBASE-L] - date picker cutting off

2018-05-02 Thread A. Razzak Memon
Dan, Here's what I get when using the San Diego SAT Edition of R:BASE X Enterprise. SET VAR vDate DATE = NULL SET VAR vDate = (GETDATE('Select Date')) See attached screenshots. Very Best R:egards, Razzak At 05:32 PM 5/2/2018, Dan Goldberg wrote: My date picker is cutting off. Not sure

[RBASE-L] - R:BASE SAT in San Diego, CA - Course Outline

2018-05-02 Thread A. Razzak Memon
Wednesday, May 2, 2018 To All Attendees of 2018 R:BASE X Enterprise SAT in San Diego, CA (May 4-5, 2018). Updated R:BASE X Enterprise (Version 10) SAT Course Outline is now available. http://www.rbaseuniversity.com What is not included in the course outline is the ... P _ _ _ _ _ w o _

Re: [RBASE-L] - Does Table exist?

2018-05-01 Thread A. Razzak Memon
Doug: Here's how to check the existence of a TEMPORARY table. -- Check to see if the temporary table exist SET VAR vRows INTEGER = 0 SELECT COUNT(*) INTO vRows INDIC iv1 FROM SYS_TABLES + WHERE SYS_TABLE_NAME = 'temptablename' AND SYS_TABLE_TYPE = 'TABLE' AND SYS_TEMPORARY = 1

Re: [RBASE-L] - EN DBNAVIGATOR

2018-04-30 Thread A. Razzak Memon
Hi Claudine, Based on the nature, features, and by design, the Enhanced DB Navigator does not support the option for Vertical orientation. FYI, the good old plain DB Navigator can be found among the "Legacy Controls". Hope that helps! Very Best R:egards, Razzak At 10:49 PM 4/30/2018,

RE: [RBASE-L] - 2 page report in Rbase X

2018-04-26 Thread A. Razzak Memon
d, Inc www.jccgci.org www.nphd.org -Original Message- From: rbase-l@googlegroups.com <rbase-l@googlegroups.com> On Behalf Of A. Razzak Memon Sent: Wednesday, April 25, 2018 11:11 AM To: rbase-l@googlegroups.com Subject: RE: [RBASE-L] - 2 page report in Rbase X You will

RE: [RBASE-L] - 2 page report in Rbase X

2018-04-25 Thread A. Razzak Memon
ish Community Council of Greater Coney Island, Inc www.jccgci.org www.nphd.org -Original Message- From: rbase-l@googlegroups.com <rbase-l@googlegroups.com> On Behalf Of A. Razzak Memon Sent: Wednesday, April 18, 2018 8:38 AM To: rbase-l@googlegroups.com Subject: RE: [RBASE-L] - 2 page report

Re: [RBASE-L] - RBase 101

2018-04-21 Thread A. Razzak Memon
Hi Claudine, A question and a few suggestions ... Is i_companies a table or a view? If i_companies is an actual table, then, how about ... 01. PACK INDEX FOR i_companies OR 02. Re-building the database using UNLOAD ALL routine, and NOT the RELOAD approach. CONNECT dbname OUTPUT

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

2018-04-20 Thread A. Razzak Memon
If your connected database QUOTES settings are single quotes, and you cannot run the sample DIALOG command below, there is something else going on. -- Dialog with Popup as Date CLEAR VAR vDate,vEndKey SET VAR vDate DATE = NULL DIALOG 'Enter Date (mm/dd/) or Double-Click for

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

2018-04-19 Thread A. Razzak Memon
Island, Inc www.jccgci.org www.nphd.org -Original Message- From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of A. Razzak Memon Sent: Wednesday, April 18, 2018 11:43 PM To: rbase-l@googlegroups.com Subject: RE: RE: [RBASE-L] - Date Chooser Dialog? Match the example

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

2018-04-18 Thread A. Razzak Memon
Match the example QUOTE settings to yours. If you are using double quotes, correct the example QUOTE settings accordingly. Razzak At 11:36 PM 4/18/2018, Ken Shapiro wrote: Paste the command into an empty rbase editor window. Add return at the end, and then use r:style to check the syntax.

RE: [RBASE-L] - 2 page report in Rbase X

2018-04-18 Thread A. Razzak Memon
At 12:24 AM 4/18/2018, Kayza Kleinman wrote: What I can't figure out is if I can have both pages print as one report. Kayza, Here's how ... 01. Create a sub-report and place the Sub Report object on Report Page Footer section. 02. Place all necessary and/or relevant columns/fields on

RE: [RBASE-L] - Enhanced DBGrid Refresh

2018-04-11 Thread A. Razzak Memon
appreciate all the gracious and professional help you and your team provide. Claudine -Original Message- From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of A. Razzak Memon Sent: Wednesday, April 11, 2018 3:22 PM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L

Re: [RBASE-L] - Enhanced DBGrid Refresh

2018-04-11 Thread A. Razzak Memon
mmediately at a picture, and kind of ignores the text "please note" that's written right under it!! Karen -Original Message- From: A. Razzak Memon <raz...@rbase.com> To: rbase-l <rbase-l@googlegroups.com> Sent: Wed, Apr 11, 2018 2:01 pm Subject: Re: [RBASE-L] - Enhanced

Re: [RBASE-L] - Enhanced DBGrid Refresh

2018-04-11 Thread A. Razzak Memon
FWIW ... It was the R:BASE Development Team who provided you with the insight as well as the correct syntax to use that technique of using Lookup Expressions in DB Grid control. Very Best R:egards, Razzak At 08:48 AM 4/11/2018, karentellef via RBASE-L wrote: Claudine: Just yesterday (in

Re: [RBASE-L] - gateway export to xlsx

2018-04-05 Thread A. Razzak Memon
Dan, Here's how ... Try the example below using the sample RRBYW19 database. -- Example -- Create XLSX file with Header, Footer, Style and Tab Name -- Author: A. Razzak Memon -- Date Created: April 5, 2018 -- Last Updated: IF (CVAL('DATABASE')) <> 'RRBYW19' OR (CVAL('DATABASE')) I

Re: [RBASE-L] - CHKFILE problem

2018-04-04 Thread A. Razzak Memon
Claudine, Without knowing all details about your network, folders, mapped drives, etc ... Try the following test and see what you get. -- Example 01 IF (CHKFILE('C:\ScanFolder')) <> 1 THEN MD C:\ScanFolder ENDIF -- Example 02: SET VAR vScanFolder TEXT = 'C:\ScanFolder' IF

[RBASE-L] - Tip of the Day: COPY File Overwrite Confirmation

2018-04-03 Thread A. Razzak Memon
Tuesday, April 3, 2018 Tip of the Day: COPY File Overwrite Confirmation Product...: R:BASE X and R:BASE X Enterprise (Version 10) Build.: 10.0.3.20320 or higher Section...: R> Prompt Keywords..: Commands, COPY, Overwrite, Confirm Did you know the COPY command file operations

Re: [RBASE-L] - Enhanced DBGrid Refresh

2018-04-02 Thread A. Razzak Memon
Claudine, Please try the following and see what you get ... -- Start PROPERTY TABLE endbgridtablename 'CLOSE' PROPERTY TABLE endbgridtablename 'OPEN' RETURN -- End Very Best R:egards, Razzak At 01:53 PM 4/2/2018, Claudine Robbins wrote: I don't know how to refresh an Enhanced DBGrid. I

[RBASE-L] - Tip of the Day: Property Editor Placement with Multiple Monitors

2018-04-02 Thread A. Razzak Memon
Monday, April 2, 2018 Tip of the Day: Property Editor Placement with Multiple Monitors Product...: R:BASE X and R:BASE X Enterprise (Version 10) Build.: 10.0.3.20320 or higher Section...: Settings Keywords..: Multi-Monitor, Multi-Session, Center, Editors Did you know a new

[RBASE-L] - Tip of the Day: Enhanced Control Property Searches in Forms

2018-03-30 Thread A. Razzak Memon
Friday, March 30, 2018 Tip of the Day: Enhanced Control Property Searches in Forms Product...: R:BASE X and R:BASE X Enterprise (Version 10) Build.: 10.0.3.20320 or higher Section...: Database Explorer, Form Designer Keywords..: Find in, Search, Control Properties Did you

[RBASE-L] - Tip of the Day: ANSIOUTPUT Setting for ANSI Default Encoding

2018-03-29 Thread A. Razzak Memon
Thursday, March 29, 2018 Tip of the Day: ANSIOUTPUT Setting for ANSI Default Encoding Product...: R:BASE X and R:BASE X Enterprise (Version 10) Build.: 10.0.3.20320 or higher Section...: Settings Keywords..: ANSIOUTPUT, OUTPUT, ANSI, Operating Condition Did you know that a

[RBASE-L] - Tip of the Day: Table Recognition in Data Browser Export Process

2018-03-28 Thread A. Razzak Memon
Wednesday, March 28, 2018 Tip of the Day: Table Recognition in Data Browser Export Process Product...: R:BASE X and R:BASE X Enterprise (Version 10) Build.: 10.0.3.20320 or higher Section...: Data Browser Keywords..: Export Results, File Name, Save As, Default Did you know

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

2018-03-27 Thread A. Razzak Memon
<rbase-l@googlegroups.com> On Behalf Of A. Razzak Memon Sent: March 27, 2018 8:17 AM To: rbase-l@googlegroups.com Subject: [RBASE-L] - Tip of the Day: DIALOG/PAUSE Accelerator Character Control Tuesday, March 27, 2018 Tip of the Day: DIALOG/PAUSE Accelerator Character Control P

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

2018-03-27 Thread A. Razzak Memon
Tuesday, March 27, 2018 Tip of the Day: DIALOG/PAUSE Accelerator Character Control Product...: R:BASE X and R:BASE X Enterprise (Version 10) Build.: 10.0.3.20320 or higher Section...: Commands Keywords..: DIALOG, PAUSE, Accelerator Character, Message Did you know a new

[RBASE-L] - Tip of the Day: NULL Interpretations for DB Grid Dynamic Colors

2018-03-26 Thread A. Razzak Memon
Monday, March 26, 2018 Tip of the Day: NULL Interpretations for DB Grid Dynamic Colors Product...: R:BASE X and R:BASE X Enterprise (Version 10) Build.: 10.0.3.20320 or higher Section...: Forms Keywords..: Enhanced DB Grid, Background Color, Font Color, Dynamic, Columns

Re: [RBASE-L] - RBase shuts down unexpectedly

2018-03-24 Thread A. Razzak Memon
David, A few suggestions ... 01. Make sure to include the entire folder or C:\RBTI\RBGX\RBGX.exe to the exclusion list of anti-virus or Windows Defender. 02. Check the TIMEOUT setting in RBENGINEX.CFG or your application startup file. Hope that helps! Very Best R:egards, Razzak At

[RBASE-L] - Tip of the Day: Multiple Modifier Support for the OUTPUT Command

2018-03-23 Thread A. Razzak Memon
Friday, March 23, 2018 Tip of the Day: Multiple Modifier Support for the OUTPUT Command Product...: R:BASE X and R:BASE X Enterprise (Version 10) Build.: 10.0.3.20320 or higher Section...: Commands Keywords..: OUTPUT, ANSI, UTF8, APPEND, CHECK Did you know that you can

[RBASE-L] - Tip of the Day: Multi-Line Editor in Form Property Editors

2018-03-22 Thread A. Razzak Memon
Thursday, March 22, 2018 Tip of the Day: Multi-Line Editor in Form Property Editors Product...: R:BASE X and R:BASE X Enterprise (Version 10) Build.: 10.0.3.20320 or higher Section...: Forms Keywords..: Multi-Line Editor, Captions, Hints, Fields Did you know that you can now

[RBASE-L] - Tip of the Day: "Center In Work Area" Form Property Setting

2018-03-21 Thread A. Razzak Memon
Wednesday, March 21, 2018 Tip of the Day: "Center In Work Area" Form Property Setting Product...: R:BASE X and R:BASE X Enterprise (Version 10) Build.: 10.0.3.20320 or higher Section...: Forms Keywords..: Setting, Form Behavior, Center in Work Area Did you know that you can

[RBASE-L] - Tip of the Day: Recognition of Remote Desktop R:BASE Session

2018-03-20 Thread A. Razzak Memon
Tuesday, March 20, 2018 Tip of the Day: Recognition of Remote Desktop R:BASE Session Product...: R:BASE X and R:BASE X Enterprise (Version 10) Build.: 10.0.3.20320 or higher Section...: Commands Keywords..: GETPROPERTY, Session, Remote Desktop Did you know that you can

[RBASE-L] - Released: R:BASE X/XE (Version 10) - Add-on Products

2018-03-19 Thread A. Razzak Memon
Tuesday, March 20, 2018 To All Users of R:BASE X and R:BASE X Enterprise Add-on Products: Updates are now available for the following add-on products for R:BASE X and R:BASE X Enterprise (Version 10): http://www.rbaseupdates.com Build: 10.0.3.20320 - Update 3 . Oterro X and Oterro X

[RBASE-L] - Released: R:BASE X/XE (Version 10) - Update 3

2018-03-19 Thread A. Razzak Memon
Tuesday, March 20, 2018 To All Users of R:BASE X and R:BASE X Enterprise (Version 10): Official updates of R:BASE X/R:BASE X Enterprise (Version 10) are now available. This Update 3, Build: 10.0.3.20320, includes a total of 52 enhancements and 78 reported bug fixes.

[RBASE-L] - Data Bridge Between R:BASE X Enterprise and QuickBooks Enterprise 18.0

2018-03-16 Thread A. Razzak Memon
Friday, March 16, 2018 To R:BASE Community: It is my pleasure to announce the availability of "R:BASE/QuickBooks Integration" as one of the highly rated services available from R:BASE Technologies. http://www.rbase.com/services/ Using R:BASE X Enterprise (Version 10.0/10.5) and Intuit

[RBASE-L] - R:BASE Online Resources

2018-03-15 Thread A. Razzak Memon
Thursday, March 15, 2018 To all our new and young users who have recently joined this R:BASE List: Welcome to R:BASE List! Here's a comprehensive list of R:BASE Online Resources which you may find helpful. R:BASE Sample Applications: http://www.razzak.com/sampleapplications R:BASE

Re: [RBASE-L] - cannot type in field when clicked on

2018-03-14 Thread A. Razzak Memon
Dan, Revisit your form and verify the following: 01. Tab Sequence 02. On-click EEP for Variable ListView control 03. Pre-defined variable edit data type 04. CLEAR VAR statements 05. SET_FOCUS statements 06. Closing and exiting out of any Lookup Combo-Boxes Hope that provides you with some

RE: [RBASE-L] - Table Settings drop settings

2018-03-05 Thread A. Razzak Memon
all forms. No previous issues until now. The property command worked great. Looked in RDocs X and Properties PDF but could not find it. Tom Frederick -Original Message- From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of A. Razzak Memon Sent: Monday, March 05

Re: [RBASE-L] - speed up when using date calculation

2018-02-26 Thread A. Razzak Memon
Dan, What happens when you use the syntax with WHERE clause as follows: -- Example 01 SELECT ID,Cust_State,Unit_Type,InquiryDate + FROM Inquiry + WHERE InquiryDate > (ADDDAY(.#DATE,-15)) RETURN -- Example 02 SET VAR vDate DATE = (ADDDAY(.#DATE,-15)) SELECT

Re: [RBASE-L] - Formatting OUTPUT

2018-02-24 Thread A. Razzak Memon
-- SFIL_And_SPUT_Commands_To_Create_Fixed_Field_Text_File.rmd -- Author: A. Razzak Memon -- Date Created: February 19, 2018 -- Last Updated: -- Check Database Connection IF (CVAL('DATABASE')) <> 'RRBYW19' OR (CVAL('DATABASE')) IS NULL THEN CONNECT RRBYW19 IDENTIFIED BY NONE ENDIF -- Pre-Define All Variables S

Re: [RBASE-L] - Radio group

2018-02-22 Thread A. Razzak Memon
Jan, Using all supported PROPERTY commands, you can do almost anything. See attached. In addition, you can make any item of the Radio Group ... VISIBLE 'TRUE/FALSE' or ENABLED 'TRUE/FALSE', if you wish. Enjoy the presentation! Very Best R:egards, Razzak At 12:53 PM 2/22/2018, jan

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

2018-02-21 Thread A. Razzak Memon
I'm using the latest R:DOCS, I think, 10.0.3.20116. Thanks, Paul -Original Message- From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of A. Razzak Memon Sent: December 22, 2017 4:47 PM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - Change Individual Row Co

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

2018-02-20 Thread A. Razzak Memon
ng blank spaces" for R:BASE text strings. Very Best R:egards, Razzak At 02:37 PM 2/20/2018, James W. Kim, CPA, MBA wrote: Razzak, Just tried a test upload with over thousand entries. CHAR(00) worked like a charm. You R:ock! Thanks, James On 2/20/2018 1:39 PM, A. Razzak Memon wrote: Jam

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

2018-02-20 Thread A. Razzak Memon
James, When I saw your request for help, I knew exactly what you were looking for, thus my response with all details along with a sample text file. Yes, my R:Crystal Ball was working . Have fun, and feel free to reach out to me if you have any questions. Very Best R:egards, Razzak At

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

2018-02-19 Thread A. Razzak Memon
James, Funny you should ask ... One of my financial and tax collection agency clients was required to submit the delinquent tax collection file for their GL package that required pretty much the same file format that you are required to use on your end. In addition to using the SFIL and

RE: [RBASE-L] - CHOOSE command

2018-02-12 Thread A. Razzak Memon
other than the intended recipient is prohibited. If you received this in error, please contact the sender and destroy any copies of this information. -Original Message- From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of A. Razzak Memon Sent: Friday, February

Re: [RBASE-L] - CHOOSE command

2018-02-09 Thread A. Razzak Memon
FWIW ... The INITVAL option for CHOOSE command was implemented on August 10, 2016, R:BASE X and R:BASE X Enterprise (Version 10), Build: 10.0.1.20909. Very Best R:egards, Razzak At 05:20 PM 2/9/2018, Albert Berry wrote: I just checked 9.5_64 WIN and INITVAL is not in the help search.

[RBASE-L] - Re: Sending Secure E-Mails (was: Command History buttons)

2018-01-29 Thread A. Razzak Memon
Gary, Are we becoming too old to use the correct Subject: when sending an e-mail to this list ? All internet providers are now subject to use SSL (Secure Sockets Layer) via their SMTP. You will need to look into R:Mail to accomplish your goal of sending secure e-mails through your service

Re: [RBASE-L] - Speed Difference - Same APP Different Laptops & AV Software

2018-01-29 Thread A. Razzak Memon
? -Original Message- From: "A. Razzak Memon" <raz...@rbase.com> To: rbase-l@googlegroups.com Date: Mon, 29 Jan 2018 08:54:15 -0500 Subject: Re: [RBASE-L] - Speed Difference - Same APP Different Laptops & AV Software John, Make sure to configure the AV software with the e

Re: [RBASE-L] - Speed Difference - Same APP Different Laptops & AV Software

2018-01-29 Thread A. Razzak Memon
John, Make sure to configure the AV software with the exclusions as follows: . \RBTI\RBGXE\*.* . RBENGINE*.dll . RBGX*.dll . RStyleX.dll . OterroX*.dll -- if applicable . RBENGINE*.cfg . OterroX*.cfg -- if applicable . RSyleX.cfg . Compiledappname.exe . *.dat . *.eep . *.rbc . *.rbm . *.rgw .

Re: [RBASE-L] - EnhancedDBGrid control

2018-01-25 Thread A. Razzak Memon
John, Here's how ... 01. While in Form Designer ... Main Menu > Tables > Display Format > Click on the appropriate table associated with Enhanced DB Grid 02. Select the Enhanced DB Grid Column Notice the available options for Display Format Mask You may select the one from

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

2018-01-17 Thread A. Razzak Memon
ected file. That should take care of your desired goal. Have fun! Very Best R:egards, Razzak At 11:50 PM 1/17/2018, MD wrote: Thank you Razzak -Original Message- From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of A. Razzak Memon Sent: Wednesday, January 17, 201

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

2018-01-17 Thread A. Razzak Memon
I simply could not resist letting this thread go with such an answer ... Using the FileListBox control, the SHORTFILENAME has everything to do what Manuel is trying to accomplish. Using the FileListBox form control in R:BASE X and R:BASE Enterprise has a lot to do with the GETPROPERTY

[RBASE-L] - Released: R:BASE X/XE (Version 10) - Update 3

2018-01-15 Thread A. Razzak Memon
Tuesday, January 16, 2018 To All Users of R:BASE X and R:BASE X Enterprise (Version 10): As we celebrate the 20th Anniversary of R:BASE Technologies, Inc., we are pleased to announce the official release of R:BASE X and R:BASE X Enterprise (Version 10), Update 3. This Update 3, Build:

[RBASE-L] - Released: R:BASE X/XE (Version 10) - Update 3

2018-01-15 Thread A. Razzak Memon
Tuesday, January 15, 2018 To All Users of R:BASE X and R:BASE X Enterprise (Version 10): As we celebrate the 20th Anniversary of R:BASE Technologies, Inc., we are pleased to announce the official release of R:BASE X and R:BASE X Enterprise (Version 10), Update 3. This Update 3, Build:

Re: [RBASE-L] - Any way to have DIALOG pre-select the default text.

2018-01-12 Thread A. Razzak Memon
Yes, Everything is possible in R:BASE! As you asked, the key is the "pre-select" the default text. So, here's how ... -- Using AUTOSELECT in DIALOG Command -- Author: A. Razzak Memon -- Date Created: January 12, 2018 -- Last Updated: CLS SET VAR vTest TEXT = 'Yes You Can!'

Re: [RBASE-L] - delete from child tables

2018-01-09 Thread A. Razzak Memon
And, here is an example of implementing CASCADE option for table(s) with PRIMARY Keys. See attached screen shot for your viewing pleasure ... Cascade - Maintains primary/foreign key relationships automatically. A CASCADE can be applied to UPDATE, DELETE, or BOTH data set changes for primary

Re: [RBASE-L] - delete from child tables

2018-01-09 Thread A. Razzak Memon
Dan, Your situation is a perfect scenario for the implementation of "CASCADE" option for all tables with PRIMARY Key. Know how? If not, just ask. HELP CASCADE Table Designer ... Very Best R:egards, Razzak At 05:35 PM 1/9/2018, Dan Goldberg wrote: I need to run a command to delete rows

Re: [RBASE-L] - One last question, if possible

2017-12-31 Thread A. Razzak Memon
Jan, Since Cathy Grimes is using 9.5 (32), it would be .RB1, .RB2, .RB3, and .RB4. Very Best R:egards, Razzak At 08:23 PM 12/31/2017, jan johansen wrote: ... except version 9.5 should be *.RX? -Original Message- From: Larry Wilson To:

RE: [RBASE-L] - Would Really Appreciate Any Help with R:Base Problem

2017-12-31 Thread A. Razzak Memon
. Hope you - and all you other R:Base developers - a very happy and successful New Year. Cathy -Original Message- From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of A. Razzak Memon Sent: Sunday, December 31, 2017 7:34 AM To: rbase-l@googlegroups.com Subject

RE: [RBASE-L] - Would Really Appreciate Any Help with R:Base Problem

2017-12-31 Thread A. Razzak Memon
lines? Some of my details take up 10+ lines I don't want to print more than 4). Cathy Grimes -Original Message- From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of A. Razzak Memon Sent: Sunday, December 31, 2017 6:19 AM To: rbase-l@googlegroups.com Subject: R

RE: [RBASE-L] - Would Really Appreciate Any Help with R:Base Problem

2017-12-31 Thread A. Razzak Memon
up 10+ lines I don't want to print more than 4). Cathy Grimes -Original Message- From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of A. Razzak Memon Sent: Sunday, December 31, 2017 6:19 AM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - Would Really

Re: [RBASE-L] - Would Really Appreciate Any Help with R:Base Problem

2017-12-31 Thread A. Razzak Memon
Cathy, Make the control as small in Height as much as to show only one line and then use the Stretch property to stretch the height when applicable. The Stretch property determines whether the Height of the memo automatically stretches to allow the entire contents of the memo to be printed.

Re: [RBASE-L] - Append Question

2017-12-28 Thread A. Razzak Memon
Anne, Here's how ... APPEND tablename1 TO tablename2 WHERE SoNum IN (SELECT SoNum FROM anytable WHERE ...) You may also select columns using the INSERT command as follows: INSERT INTO tablename2 + (column1, columns2, columns3) + SELECT column1, columns2, columns3 + FROM table1 WHERE SoNum

<    1   2   3   4   5   6   7   8   9   10   >