[RBASE-L] - RE: expanding note field

2019-03-25 Thread Claudine Robbins
I should have added: “In a DBGrid. I’m assuming it’s the same for a scrolling region.” From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of Jim Belisle Sent: Monday, March 25, 2019 7:15 PM To: rbase-l@googlegroups.com Subject: [RBASE-L] - expanding note field I am

[RBASE-L] - RE: expanding note field

2019-03-25 Thread Claudine Robbins
James, DBL-CLKing on the field will automatically open the Blob Editor. Claudine From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of Jim Belisle Sent: Monday, March 25, 2019 7:15 PM To: rbase-l@googlegroups.com Subject: [RBASE-L] - expanding note field I am using a

RE: [RBASE-L] - SUB REPORTS

2019-01-18 Thread Claudine Robbins
[cid:image001.png@01D4AF2C.0A7D9090] Claudine From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of Albert Berry Sent: Friday, January 18, 2019 11:44 AM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - SUB REPORTS Which report? I’ll have a look Albert On Jan 18,

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

2018-12-31 Thread Claudine Robbins
Thank you Razzak! HAPPY NEW YEAR! Claudine :-) -Original Message- From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of A. Razzak Memon Sent: Monday, December 31, 2018 4:54 PM To: rbase-l@googlegroups.com Subject: [RBASE-L] - From The Edge: Tip of the Day Digest

RE: [RBASE-L] - Version and Build in R:Compiler

2018-12-28 Thread Claudine Robbins
at the Executable; properties tab details Tony Van: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] Namens Claudine Robbins Verzonden: vrijdag 28 december 2018 2:15 Aan: rbase-l@googlegroups.com Onderwerp: [RBASE-L] - Version and Build in R:Compiler Hello, Besides the [cid:image001.png@01D49E9C

[RBASE-L] - Version and Build in R:Compiler

2018-12-27 Thread Claudine Robbins
Hello, Besides the [cid:image001.png@01D49E17.C3940080] in R:Compiler (and I don't see where that's displayed once the app is launched), is there a way to keep track of the Compiler version and build and to display it in the compiled app? The (CVAL('BUILD')); (CVAL('VERSION')); and

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

2018-12-24 Thread Claudine Robbins
Best wishes for health and family joy to all on this wonderful list! Claudine -Original Message- From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of A. Razzak Memon Sent: Monday, December 24, 2018 9:22 AM To: rbase-l@googlegroups.com Subject: [RBASE-L] - Happy

RE: [RBASE-L] - DBLookupComboBox

2018-11-29 Thread Claudine Robbins
hould sync up Karen -Original Message- From: Claudine Robbins To: rbase-l@googlegroups.com Sent: Thu, Nov 29, 2018 1:08 pm Subject: RE: [RBASE-L] - DBLookupComboBox Hi Dan, I’m not sure I understand your workaround but I really need to make it work with the DBLookupComboBox. Cla

RE: [RBASE-L] - DBLookupComboBox

2018-11-29 Thread Claudine Robbins
: RE: [RBASE-L] - DBLookupComboBox Maybe create a dbedit field and try the textvalue line on that field. If it works you can hide it. Dan Goldberg From: rbase-l@googlegroups.com On Behalf Of Claudine Robbins Sent: Thursday, November 29, 2018 10:39 AM To: rbase-l@googlegroups.com Subject: RE

RE: [RBASE-L] - DBLookupComboBox

2018-11-29 Thread Claudine Robbins
Thanks Jan, I rem’d out the REFRESHLIST, no better. Try tracing the code for option 1. I'm not sure if the REFRESHLIST is messing you up. Jan -Original Message- From: Claudine Robbins To: "rbase-l@googlegroups.com" Date: Thu, 29 Nov 2018 17:59:09 + Subject

RE: [RBASE-L] - RE: LISTOF question 10.0.4.10913 F I X E D !

2018-11-15 Thread Claudine Robbins
:02 PM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - RE: LISTOF question 10.0.4.10913 F I X E D ! Aren’t they just great? The slightest problem, no matter how insignificant, is fixed as if the whole program was failing. Albert On Nov 15, 2018, at 11:36 AM, Claudine Robbins mailto:crobb

RE: [RBASE-L] - Stored Procedures

2018-11-15 Thread Claudine Robbins
: Claudine Robbins To: rbase-l@googlegroups.com Sent: Thu, Nov 15, 2018 12:52 pm Subject: [RBASE-L] - Stored Procedures I have a new issue with a stored procedure routine which goes like this: I call the SP NewCompanies(1) to pass a value of 1 to the SP STEP 1 I use the DIALOG to get the user’s input

[RBASE-L] - Stored Procedures

2018-11-15 Thread Claudine Robbins
I have a new issue with a stored procedure routine which goes like this: I call the SP NewCompanies(1) to pass a value of 1 to the SP STEP 1 I use the DIALOG to get the user's input on the company name they want to add. STEP 2 I then EDIT USING FORMCHOOSE MDI AS 'PICKONE' which takes the user

RE: [RBASE-L] - LISTOF question 10.0.4.10913

2018-11-15 Thread Claudine Robbins
m [mailto:rba...@googlegroups.com] On Behalf Of Claudine Robbins Sent: Friday, October 26, 2018 3:08 PM To: rba...@googlegroups.com Subject: [RBASE-L] - LISTOF question 10.0.4.10913 Hello all, My experience with LISTOF is that it automatically puts quotes around fields that contain commas bu

[RBASE-L] - RE: LISTOF question 10.0.4.10913 F I X E D !

2018-11-15 Thread Claudine Robbins
This issue is fixed in the next update. Thank you R:DCC and staff at RBTI! Claudine From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of Claudine Robbins Sent: Friday, October 26, 2018 3:08 PM To: rbase-l@googlegroups.com Subject: [RBASE-L] - LISTOF question

Re: [RBASE-L] - LISTOF question 10.0.4.10913

2018-10-30 Thread Claudine Robbins
to:rba...@googlegroups.com] On Behalf Of Claudine Robbins Sent: Friday, October 26, 2018 3:08 PM To: rba...@googlegroups.com Subject: [RBASE-L] - LISTOF question 10.0.4.10913 Hello all, My experience with LISTOF is that it automatically puts quotes around fields that contain commas but I’m r

RE: [RBASE-L] - LISTOF question 10.0.4.10913

2018-10-29 Thread Claudine Robbins
] On Behalf Of Claudine Robbins Sent: Friday, October 26, 2018 3:08 PM To: rba...@googlegroups.com Subject: [RBASE-L] - LISTOF question 10.0.4.10913 Hello all, My experience with LISTOF is that it automatically puts quotes around fields that contain commas but I’m running into a situation where it does

RE: [RBASE-L] - LISTOF question 10.0.4.10913

2018-10-28 Thread Claudine Robbins
13-915-3137 From: rba...@googlegroups.com [mailto:rba...@googlegroups.com] On Behalf Of Claudine Robbins Sent: Friday, October 26, 2018 3:08 PM To: rba...@googlegroups.com Subject: [RBASE-L] - LISTOF question 10.0.4.10913 Hello all, My experience with LISTOF is that it automatically puts quotes

RE: [RBASE-L] - Re: LISTOF question 10.0.4.10913

2018-10-27 Thread Claudine Robbins
Love it! Works as advertised. Thanks Mike! From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of Michael Byerley Sent: Saturday, October 27, 2018 2:37 PM To: RBASE-L Subject: Re: [RBASE-L] - Re: LISTOF question 10.0.4.10913 OK. Here's a workaround then. In this

RE: [RBASE-L] - Re: LISTOF question 10.0.4.10913

2018-10-27 Thread Claudine Robbins
Thanks Mike, that works fine for the LISTOF command. However; the name picked in the subsequent CHOOSE command using the vValueList now contains the company name without the comma (YELLOW JACKET CONSTRUCTION INC.) so EDI USI COMPANIES WHERE COMPANY_NAME = .VCHOOSE command fails the field

RE: [RBASE-L] - LISTOF question 10.0.4.10913

2018-10-26 Thread Claudine Robbins
I’m getting the same result with other datasets. I’ll report it to RDCC. From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of Claudine Robbins Sent: Friday, October 26, 2018 6:49 PM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - LISTOF question 10.0.4.10913 Good

Re: [RBASE-L] - LISTOF question 10.0.4.10913

2018-10-26 Thread Claudine Robbins
to:alb...@albertberry.com>> wrote: Wild guess. Try increasing 32 to 40. I have absolutely no idea if this would make any difference, but it’s a cheap try. On Oct 26, 2018, at 2:07 PM, Claudine Robbins mailto:crobb...@iexgroup.com>> wrote: Hello all, My experience with LISTOF is that it automat

Re: [RBASE-L] - LISTOF question 10.0.4.10913

2018-10-26 Thread Claudine Robbins
d back in RBG95 days, before you went RBG95_64 and/or RBGXE Albert On Oct 26, 2018, at 3:30 PM, Claudine Robbins mailto:crobb...@iexgroup.com>> wrote: Albert, Setting namewidth to 40 didn’t work but it brings an interesting question I’ve never asked myself before because I “assumed” that all se

[RBASE-L] - LISTOF question 10.0.4.10913

2018-10-26 Thread Claudine Robbins
Hello all, My experience with LISTOF is that it automatically puts quotes around fields that contain commas but I'm running into a situation where it does not. One of the fields is YELLOW JACKET CONSTRUCTION, INC., LISTOF returns the space plus INC. as a separate value. However, it correctly

RE: [RBASE-L] - NOT RESPONDING

2018-10-04 Thread Claudine Robbins
ept of the entire process. Please feel free to reach out to me if you have any questions. Very Best R:egards, Razzak At 12:50 AM 10/4/2018, Claudine Robbins wrote: >Hello Razzak, > >Thanks for the primer on PROCESSMESSAGE. Your explanation should be >added to the R:BASE X help

RE: [RBASE-L] - NOT RESPONDING

2018-10-03 Thread Claudine Robbins
t 09:39 PM 10/3/2018, Claudine Robbins wrote: >I've meant to ask about this for quite some time. When there is a >somewhat lengthy process, "Not Responding" will occasionally pop up >at the top of the screen. Users often click on the x to exit the >screen but the proces

[RBASE-L] - NOT RESPONDING

2018-10-03 Thread Claudine Robbins
I've meant to ask about this for quite some time. When there is a somewhat lengthy process, "Not Responding" will occasionally pop up at the top of the screen. Users often click on the x to exit the screen but the process is really still working and just waiting will let it complete. What

RE: [RBASE-L] - Reports - force a page feed?

2018-09-11 Thread Claudine Robbins
I’ve never used report bands (Report Controls, Report Band), could that help? PROPERTY NEWPAGE 'TRUE' Might be simpler just to create a new break. Claudine From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com] Sent: Tuesday, September 11, 2018 10:01 AM To: rbase-l@googlegroups.com

[RBASE-L] - RE: _history folder

2018-08-24 Thread Claudine Robbins
Open it and find out ☺ From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of Stephen Markson Sent: Friday, August 24, 2018 2:05 PM To: rbase-l@googlegroups.com Subject: [RBASE-L] - _history folder Does anyone know what the _history folder is that sometimes appears in my

RE: [RBASE-L] - Picking and Renaming Windows Files

2018-08-01 Thread Claudine Robbins
! Karen -Original Message- From: Claudine Robbins To: rbase-l Sent: Wed, Aug 1, 2018 2:45 pm Subject: RE: [RBASE-L] - Picking and Renaming Windows Files Like a charm. Thank you Karen! [cid:image001.png@01D429AB.23348D20] From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com

RE: [RBASE-L] - Picking and Renaming Windows Files

2018-08-01 Thread Claudine Robbins
vloop int = 1 while 1 = 1 then set var vtext = (ssub(.vfilename,.vloop)) if vtext is null then break endif insert into tfilename (filen) values (.vtext) set var vloop = (.vloop + 1) endwhile Karen -Original Message- From: Claudine Robbins To: rbase-l Sent: Wed, Aug 1

RE: [RBASE-L] - Picking and Renaming Windows Files

2018-08-01 Thread Claudine Robbins
contain spaces. set var vloop int = 1 while 1 = 1 then set var vtext = (ssub(.vfilename,.vloop)) if vtext is null then break endif insert into tfilename (filen) values (.vtext) set var vloop = (.vloop + 1) endwhile Karen -Original Message- From: Claudine Robbins To: rbase-l

RE: [RBASE-L] - Picking and Renaming Windows Files

2018-08-01 Thread Claudine Robbins
;> On Behalf Of Claudine Robbins Sent: Wednesday, August 1, 2018 1:21 PM To: rbase-l@googlegroups.com<mailto:l...@googlegroups.com> Subject: [RBASE-L] - Picking and Renaming Windows Files Hi all, I’m trying to capture multiple file names to rename them. The following code gives

RE: [RBASE-L] - Picking and Renaming Windows Files

2018-08-01 Thread Claudine Robbins
PM To: rbase-l@googlegroups.com Subject: RE: [RBASE-L] - Picking and Renaming Windows Files Claudine Since you have commas in the file I would think you have to load the table instead of insert. Buddy From: rbase-l@googlegroups.com On Behalf Of Claudine Robbins Sent: Wednesday, August 1, 2

Re: [RBASE-L] - Picking and Renaming Windows Files

2018-08-01 Thread Claudine Robbins
o load the table instead of insert. Buddy From: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com> mailto:rbase-l@googlegroups.com>> On Behalf Of Claudine Robbins Sent: Wednesday, August 1, 2018 1:21 PM To: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com> Subj

[RBASE-L] - Picking and Renaming Windows Files

2018-08-01 Thread Claudine Robbins
Hi all, I'm trying to capture multiple file names to rename them. The following code gives me the error: "ERROR-Incorrect number of values for this table (118)". It appears I may need quotes around each value. Any easy way to do this? TIA, Claudine PLUGINS LoadFileNamePlus vFileName +

RE: [RBASE-L] - Blank date value

2018-05-25 Thread Claudine Robbins
your WHERE clause more complicated, and do this more than once. SELECT datecolumn FROM tablename WHERE datecolumn <= '01/01/1900' UPDATE tablename SET datecolumn = + (RDATE(imon(datecolumn), iday(datecolumn), (iyr4(datecolumn) + 100 )) + WHERE datecolumn <= '01/01/1900' Bill On Thu, May 24,

RE: [RBASE-L] - Blank date value

2018-05-25 Thread Claudine Robbins
the form settings and any variables you may have defined but all the fields and anything on the screen will be copied. Try the new form and see what happens. Just a thought. Good luck, Paul Buckley From: rbase-l@googlegroups.com <rbase-l@googlegroups.com> On Behalf Of Claudine Robbins Sent:

RE: [RBASE-L] - Blank date value

2018-05-25 Thread Claudine Robbins
@googlegroups.com] On Behalf Of Claudine Robbins Sent: Friday, May 25, 2018 12:05 PM To: rbase-l@googlegroups.com Subject: RE: [RBASE-L] - Blank date value Furthermore, I recreated the DBEdit field on the form with no change. However, I created a test form based on the same table and that date

RE: [RBASE-L] - Blank date value

2018-05-25 Thread Claudine Robbins
wrong… Claudine From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of Claudine Robbins Sent: Friday, May 25, 2018 11:37 AM To: rbase-l@googlegroups.com Subject: RE: [RBASE-L] - Blank date value Yes Karen. This is a phantom value. All the NULL rows show this in the form

RE: [RBASE-L] - Blank date value

2018-05-25 Thread Claudine Robbins
lename WHERE datecolumn <= '01/01/1900' UPDATE tablename SET datecolumn = + (RDATE(imon(datecolumn), iday(datecolumn), (iyr4(datecolumn) + 100 )) + WHERE datecolumn <= '01/01/1900' Bill On Thu, May 24, 2018 at 9:50 PM, Claudine Robbins <crobb...@iexgroup.com<mailto:crobb...@iexgroup.com&

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

2018-05-16 Thread Claudine Robbins
Wow! 20 years is a long time and worthy of celebration. Claudine -Original Message- From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of A. Razzak Memon Sent: Wednesday, May 16, 2018 2:00 PM To: rbase-l@googlegroups.com Subject: [RBASE-L] - Announcement -

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

2018-05-15 Thread Claudine Robbins
Claudine, While you anxiously wait for the announcement tomorrow, you may find the Tip of the Day Digest (2017) at: From the Edge: http://www.razzak.com/fte/ Hope that keeps you busy until tomorrow. Good reading! Very Best R:egards, Razzak At 05:45 PM 5/15/2018, Claudine Robbins wrote: >

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

2018-05-15 Thread Claudine Robbins
PM, Claudine Robbins <crobb...@iexgroup.com<mailto: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>

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

2018-05-15 Thread Claudine Robbins
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 Memon Sent: Saturday, May 12, 2018 12:24 AM To: rbase-l@googlegroups.com

RE: [RBASE-L] - EN DBNAVIGATOR

2018-05-01 Thread Claudine Robbins
4/30/2018, Claudine Robbins wrote: >Hi, >I missed the lesson or my meds are playing tricks on me. The >Enhanced DBNavigator >cannot be positioned vertically and the plain DBNavigator is no >longer available. >Help! >TIA, >Claudine -- For group guidelines, v

[RBASE-L] - EN DBNAVIGATOR

2018-04-30 Thread Claudine Robbins
Hi, I missed the lesson or my meds are playing tricks on me. The Enhanced DBNavigator cannot be positioned vertically and the plain DBNavigator is no longer available. Help! TIA, Claudine -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received

RE: [RBASE-L] - RBase 101

2018-04-21 Thread Claudine Robbins
Claudine It could be index corruption. Any time that has happened to me a reload or pack would fix it. If company_name is indexed you could just try packing the indexes. Buddy From: rbase-l@googlegroups.com <rbase-l@googlegroups.com> On Behalf Of Claudine Robbins Sent: Saturday, Ap

RE: [RBASE-L] - RBase 101

2018-04-21 Thread Claudine Robbins
1:53 PM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - RBase 101 That is interesting, indeed. I have no idea why the where clause in the second fails. I’m such a log of help! Albert On Apr 21, 2018, at 12:45 PM, Claudine Robbins <crobb...@iexgroup.com<mailto:crobb...@iexgroup.com&g

[RBASE-L] - RBase 101

2018-04-21 Thread Claudine Robbins
I'm stumped and probably because I fail to remember some basic rule in RBase. Why does: sel count(*) fro i_companies whe company_name is null count (*) -- 2 But: R>sel * fro i_companies whe company_name is null No rows exist or satisfy the specified clause. (2059) Can

RE: [RBASE-L] - form timing

2018-04-15 Thread Claudine Robbins
Did you all note Jean-Marc’s comment that replacing a DBNavigator object by an Enhanced DBNavigator object cured the problem in one of his forms? Claudine From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of MD Sent: Sunday, April 15, 2018 12:53 AM To:

RE: [RBASE-L] - Enhanced DBGrid Refresh

2018-04-11 Thread Claudine Robbins
do! However, my reply was intended for Karen Tellef who never mentioned nor acknowledged the help and support from the Development Team of R:BASE Technologies. Very Best R:egards, Razzak At 05:05 PM 4/11/2018, Claudine Robbins wrote: >Duly noted. And I do appreciate all the graci

RE: [RBASE-L] - Enhanced DBGrid Refresh

2018-04-11 Thread Claudine Robbins
Duly noted. And I do 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:

RE: [RBASE-L] - Enhanced DBGrid Refresh

2018-04-11 Thread Claudine Robbins
in <> ? That trips me up all the time. It helps with refreshing the lookup when you leave the row, so perhaps it also makes this dynamic? I mean: actname IN accounts WHERE acctno = Karen -Original Message- From: Claudine Robbins <crobb...@iexgroup.com> To: rbas

RE: [RBASE-L] - Enhanced DBGrid Refresh

2018-04-10 Thread Claudine Robbins
Actually, I think I’ll use closing and reopening the form as a work around for now. Claudine From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of Claudine Robbins Sent: Tuesday, April 10, 2018 3:31 PM To: rbase-l@googlegroups.com Subject: RE: [RBASE-L] - Enhanced

RE: [RBASE-L] - Enhanced DBGrid Refresh

2018-04-10 Thread Claudine Robbins
e-l@googlegroups.com> <rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>> im Auftrag von Claudine Robbins <crobb...@iexgroup.com<mailto:crobb...@iexgroup.com>> Gesendet: Montag, 2. April 2018 20:33 An: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com&g

RE: [RBASE-L] - CHKFILE problem

2018-04-04 Thread Claudine Robbins
Folder TEXT = 'C:\ScanFolder' IF (CHKFILE(.vScanFolder)) <> 1 THEN MD ENDIF Feel free to recycle and adjust the logic as you see fit. Very Best R:egards, Razzak At 02:26 PM 4/4/2018, Claudine Robbins wrote: >SET VAR vlscandir = (SRPL((CVAL('CURRDIR')+ '\TRAIL\' ), '\\', '\',0)) >

[RBASE-L] - CHKFILE problem

2018-04-04 Thread Claudine Robbins
SET VAR vlscandir = (SRPL((CVAL('CURRDIR')+ '\TRAIL\' ), '\\', '\',0)) SET VAR vsscandir = ('TRAIL\') SET VAR vChkDir INTEGER = NULL SET VAR vChkDir = (CHKFILE(.vLScanDir)) IF vChkDir <> 1 THEN MKDIR ENDIF R>sho v vlscandir C:\IEX_X\TRAIL\ This sequence fails. The directory exists but

RE: [RBASE-L] - Enhanced DBGrid Refresh

2018-04-02 Thread Claudine Robbins
get ... -- Start PROPERTY TABLE endbgridtablename 'CLOSE' PROPERTY TABLE endbgridtablename 'OPEN' RETURN -- End Very Best R:egards, Razzak At 01:53 PM 4/2/2018, Claudine Robbins wrote: >I don't know how to refresh an Enhanced DBGrid. I have an expression >lookup on a

[RBASE-L] - Enhanced DBGrid Refresh

2018-04-02 Thread Claudine Robbins
Hello all, I don't know how to refresh an Enhanced DBGrid. I have an expression lookup on a DBGrid column (dropdown) and a button on the form to edit its underlying table but changes are not reflected when I use PROPERTY TABLE tablename 'POST' and PROPERTY TABLE tablename 'REFRESH' after

[RBASE-L] - Test

2018-03-10 Thread Claudine Robbins
Crossing fingers, again... -- 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] - RE: Test

2018-03-08 Thread Claudine Robbins
May take 24 hours to propagate settings, maybe? From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of Claudine Robbins Sent: Thursday, March 08, 2018 2:10 PM To: rbase-l@googlegroups.com Subject: [RBASE-L] - Test This sender failed our fraud detection checks and may

[RBASE-L] - Test

2018-03-08 Thread Claudine Robbins
Apparently SPF not setup for office365... Crossing fingers... Claudine -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop

[RBASE-L] - RE: Test

2018-03-07 Thread Claudine Robbins
Didn’t work… I’ll keep looking. From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of Claudine Robbins Sent: Wednesday, March 07, 2018 2:54 PM To: rbase-l@googlegroups.com Subject: [RBASE-L] - Test This sender failed our fraud detection checks and may not be who

RE: [RBASE-L] - RE: Test

2018-02-28 Thread Claudine Robbins
As you can see below, the pesky message returned so no joy yet. Thank you for the suggestion. It’s a good thing to change passwords from time to time anyway. Claudine From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of Claudine Robbins Sent: Wednesday, February 28

RE: [RBASE-L] - RE: Test

2018-02-28 Thread Claudine Robbins
com> [mailto:rbase-l@googlegroups.com] On Behalf Of Claudine Robbins Sent: Monday, February 26, 2018 6:32 PM To: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com> Subject: [RBASE-L] - RE: Test Thank you Stephen. I’m still looking to find the exact place where this is occurrin

[RBASE-L] - RE: Test

2018-02-26 Thread Claudine Robbins
<mailto:rbase-l@googlegroups.com> [mailto:rbase-l@googlegroups.com] On Behalf Of Claudine Robbins Sent: February-23-18 10:58 PM To: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com> Subject: [RBASE-L] - Test My messages are being flagged as coming from a spoofed address. Claudine

RE: [RBASE-L] - Formatting OUTPUT

2018-02-25 Thread Claudine Robbins
Of Claudine Robbins Sent: Saturday, February 24, 2018 8:01 PM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - Formatting OUTPUT I can’t wait to try it tomorrow! Thank you very much. Claudine Sent from my iPhone On Feb 24, 2018, at 4:59 PM, A. Razzak Memon <raz...@rbase.

Re: [RBASE-L] - Formatting OUTPUT

2018-02-24 Thread Claudine Robbins
edit RETURN -- Start here At 10:54 PM 2/23/2018, Claudine Robbins wrote: > Either I output as ASCII or CSV and I still get those extra quotes and return. > > Any idea how I can suppress those? -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.ph

Re: [RBASE-L] - Formatting OUTPUT

2018-02-24 Thread Claudine Robbins
e: Claudine Are you leaving the output file open? Buddy From: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com> [mailto:rbase-l@googlegroups.com] On Behalf Of Claudine Robbins Sent: Saturday, February 24, 2018 4:50 PM To: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com&g

RE: [RBASE-L] - Formatting OUTPUT

2018-02-24 Thread Claudine Robbins
] On Behalf Of Claudine Robbins Sent: Saturday, February 24, 2018 2:29 PM To: rbase-l@googlegroups.com Subject: RE: [RBASE-L] - Formatting OUTPUT This sender failed our fraud detection checks and may not be who they appear to be. Learn about spoofing<http://aka.ms/LearnAboutSpoofing> Feedbac

RE: [RBASE-L] - Formatting OUTPUT

2018-02-24 Thread Claudine Robbins
OUTPUT Claudine I think you are going to have to loop through the table. See attached file. I didn’t test it but I think it may give you a start. Buddy From: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com> [mailto:rbase-l@googlegroups.com] On Behalf Of Claudine Robbin

RE: [RBASE-L] - Formatting OUTPUT

2018-02-24 Thread Claudine Robbins
tput either ASCII or CSV or both. The Buddy From: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com> [mailto:rbase-l@googlegroups.com] On Behalf Of Claudine Robbins Sent: Friday, February 23, 2018 10:55 PM To: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com> Subject:

[RBASE-L] - Test

2018-02-23 Thread Claudine Robbins
My messages are being flagged as coming from a spoofed address. Claudine -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and

[RBASE-L] - Formatting OUTPUT

2018-02-23 Thread Claudine Robbins
Either I output as ASCII or CSV and I still get those extra quotes and return. Any idea how I can suppress those? TIA, Claudine [cid:image001.png@01D3ACF0.F38D2B40] -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because

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

2018-02-19 Thread Claudine Robbins
I'm intrigued. I use something similar to create a notepad text file which I write to the user's desktop for them to use as a virtual "sticker" to keep up with a list of items to check off. I have trouble making it look good, the spacing is all over the place... 'COX--020118120001

RE: [RBASE-L] - EnhancedDBGrid control

2018-01-26 Thread Claudine Robbins
Wow! I knew I was missing something! That's very cool Razzak! Claudine -Original Message- From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of A. Razzak Memon Sent: Thursday, January 25, 2018 10:03 PM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] -

[RBASE-L] - RE: EnhancedDBGrid control

2018-01-25 Thread Claudine Robbins
Maybe not but you can format your field in the select statement that creates the view or table underlying your grid. Claudine From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of John Murnane Sent: Thursday, January 25, 2018 8:03 PM To: rbase-l@googlegroups.com

RE: Re[8]: [RBASE-L] - Disaster Avoidance

2018-01-19 Thread Claudine Robbins
-- Sent: 1/15/2018 11:06:44 AM Subject: RE: Re[6]: [RBASE-L] - Disaster Avoidance: SRPL Syntax Question: From: "Claudine Robbins" <crobb...@iexgroup.com<mailto:crobb...@iexgroup.com>> To: "rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>" &l

[RBASE-L] - RE: Error using View to create new table

2018-01-16 Thread Claudine Robbins
ORDER comes after GROUP maybe… [cid:image001.png@01D38ECB.AB9C5150] From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of John Murnane Sent: Tuesday, January 16, 2018 1:06 PM To: rbase-l@googlegroups.com Subject: [RBASE-L] - Error using View to create new table Hi All:

RE: Re[6]: [RBASE-L] - Disaster Avoidance: SRPL Syntax Question:

2018-01-15 Thread Claudine Robbins
Just my 2-cents worth as I have disaster experience, run command on copy of database or add AND LIMIT = 1 to see the effect of the UPDATE command on the first row before committing the whole table… Happy New Year everybody! Claudine From: rbase-l@googlegroups.com

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

2017-12-19 Thread Claudine Robbins
: [RBASE-L - Suppressing main R:Base screen Claudine, Yes, indeed! http://www.razzak.com/sampleapplications Designing & Deploying MDI Applications - R:BASE X Enterprise (Version 10) Enjoy the presentation! Very Best R:egards, Razzak At 07:50 PM 12/18/2017, Claudine Robbins w

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

2017-12-18 Thread Claudine Robbins
There is a sample form made up of MDI forms which open in turn and all close together. I've been looking for that sample form name all day but can't seem to find it. It's either a 7.5 or 9.1 sample. I used it successfully to build a screen made up of 8 different small forms and it functioned

RE: [RBASE-L] - Truncated Field Message on Reload

2017-10-04 Thread Claudine Robbins
Of Claudine Robbins Sent: Monday, September 25, 2017 9:29 AM To: rbase-l@googlegroups.com Subject: RE: [RBASE-L] - Truncated Field Message on Reload Thank you Razzak. I don't have a single computed column so that was a very short list. I must be doing something wrong. I'll retrace all my steps

RE: [RBASE-L] - DELETE syntax

2017-09-29 Thread Claudine Robbins
Jan, Have you tried: Set var vfiletodelete = ‘\\myuncdrive\deletethisfile.pdf’ Delete .vfiletodelete Claudine From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of jan johansen Sent: Friday, September 29, 2017 4:33 PM To: rbase-l@googlegroups.com Subject: Re:

RE: [RBASE-L] - Truncated Field Message on Reload

2017-09-25 Thread Claudine Robbins
ted columns with defined attributes. Then, compare the length of those computed TEXT expressions versus the actual length of TEXT column. Hope that helps! Very Best R:egards, Razzak At 10:36 PM 9/24/2017, Claudine Robbins wrote: >Razzak, > >I remember you recently said something about this

RE: [RBASE-L] - Truncated Field Message on Reload

2017-09-24 Thread Claudine Robbins
gth of those default values versus the actual column length. Hope that provides you with some blue's clues ... Very Best R:egards, Razzak. At 06:34 PM 9/24/2017, Claudine Robbins wrote: >I have a conundrum. On several fields with varying TEXT lengths >defined in tables, I get

[RBASE-L] - Truncated Field Message on Reload

2017-09-24 Thread Claudine Robbins
Hello all, I have a conundrum. On several fields with varying TEXT lengths defined in tables, I get a "FIELD WILL BE TRUNCATED" when I run my backup file. However, when in the forms where these fields are created, it is not possible to enter more characters than are defined for the field...

RE: [RBASE-L] - Slow weekend, so here's an RBase pic

2017-09-16 Thread Claudine Robbins
I have one of those too! Good time to ask, what to do with shelf full of old R:BASE books and drawers full of old CDs? Claudine From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com] Sent: Saturday, September 16, 2017 6:00 PM To: rbase-l@googlegroups.com Subject: [RBASE-L] - Slow

RE: [RBASE-L] - Tip of the Day: Extended Filter Bar Criteria for Enhanced DB Grids

2017-09-12 Thread Claudine Robbins
Great addition! ~Claudine -Original Message- From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of A. Razzak Memon Sent: Monday, September 11, 2017 11:00 PM To: rbase-l@googlegroups.com Subject: [RBASE-L] - Tip of the Day: Extended Filter Bar Criteria for Enhanced

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

2017-08-23 Thread Claudine Robbins
Check the “Don’t Show Save Dialog” in the FORM PROPERTIES Attributes From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of Paul C. Buckley Sent: Wednesday, August 23, 2017 3:14 PM To: rbase-l@googlegroups.com Subject: [RBASE-L] - Another Enhanced DB Grid Question Good

RE: [RBASE-L] - Re: This worked previously as a on click eep but not now under version X

2017-08-18 Thread Claudine Robbins
Mike is absolutely right! I was thinking of UPDATE… Lots of grey matter lost these past years. How do you stay so sharp Mike? From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of Michael Byerley Sent: Friday, August 18, 2017 9:02 AM To: RBASE-L Subject: [RBASE-L] -

RE: [RBASE-L] - This worked previously as a on click eep but not now under version X

2017-08-17 Thread Claudine Robbins
as a on click eep but not now under version X Claudine, if vcamt includes 10% GST it is 110% of the invoice, so the GST is vacamt/11 = 10% Albert On Aug 17, 2017, at 12:20 PM, Claudine Robbins <crobb...@iexgroup.com<mailto:crobb...@iexgroup.com>> wrote: Only thing I see is missing DEFAU

RE: [RBASE-L] - This worked previously as a on click eep but not now under version X

2017-08-17 Thread Claudine Robbins
Only thing I see is missing DEFAULT and BREAK before ENDSW. But I don’t understand SET VAR vgst = (.vcamt/11) as calculating 10%... And clearly your INSERT needs a WHERE clause. Claudine From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of DB GEOINFO Sent: Thursday,

RE: [RBASE-L] - Tip of the Day: Object Rotation Support for Report/Label Controls

2017-08-14 Thread Claudine Robbins
Love those rotating labels in forms and reports... ~Claudine -Original Message- From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of A. Razzak Memon Sent: Monday, August 14, 2017 5:32 AM To: rbase-l@googlegroups.com Subject: [RBASE-L] - Tip of the Day: Object

RE: [RBASE-L] - Version 10 - dotted vs. ampersand variables

2017-08-07 Thread Claudine Robbins
(' + ('.Vlading' +(CTXT(.VCOUNT)))+’)’ ) I think I have the it added in (RED) the right spot Buddy From: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com> [mailto:rbase-l@googlegroups.com] On Behalf Of Claudine Robbins Sent: Monday, August 7, 2017 8:03 PM To: rbase-l@googlegrou

RE: [RBASE-L] - Version 10 - dotted vs. ampersand variables

2017-08-07 Thread Claudine Robbins
10 - dotted vs. ampersand variables Claudine, In addition to Buddy's observation, you may pre-define the vValue as NOTE or VARCHAR data type. Very Best R:egards, Razzak At 08:02 PM 8/7/2017, Claudine Robbins wrote: >Trying to figure this out on my own. I tried one field at a time and &

RE: [RBASE-L] - Version 10 - dotted vs. ampersand variables

2017-08-07 Thread Claudine Robbins
ssage- From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of Claudine Robbins Sent: Sunday, August 06, 2017 10:39 PM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - Version 10 - dotted vs. ampersand variables Razzak, Well I can't wait to try it tomorrow! I act

Re: [RBASE-L] - Version 10 - dotted vs. ampersand variables

2017-08-06 Thread Claudine Robbins
ternal_File_Name, + External_File_Extension, + External_File_DateTime, + External_File_Size, + External_File_Original_Path) + VALUES + ENDWHILE RETURN Hope that helps! Very Best R:egards, Razzak At 09:05 PM 8/6/2017, Claudine Robbins wrote: > SET VAR VCOUNT = 1 > SET VAR yylading TEXT

[RBASE-L] - Version 10 - dotted vs. ampersand variables

2017-08-06 Thread Claudine Robbins
SET VAR VCOUNT = 1 SET VAR yylading TEXT = ('Vlad'+(CTXT(.VCOUNT)))vlad1 SET VAR TEXT = NULL-same as vlad1 = NULL SELECT LADING INTO INDICATOR ivlad FROM orders WHERE (dtg+split) = .ventry R>sho v vlad1 LOAD FROM SEABOARD-CORPUS: [1] 5-1/8" X 15 MANUAL VALVE, BOLTS, RING GASKETS ***

  1   2   >