RE: [RBASE-L] - Tip of the Day: Using the New FSTATUS Function

[Lena Dammstrom]

I see this FSTATUS as being very useful!
Thanks
Regards
Lena


Lena Dammstrom
Software Developer
Email:ldammst...@qmiusa.com
Toll Free:800-446-2500
International: 01 630-529-7111
Extension: 1037
www.qmiusa.com
This email may contain material that is confidential, privileged and/or 
attorney work product for the sole use of the intended recipient. Any review, 
reliance or distribution by others or forwarding without express permission is 
strictly prohibited. If you are not the intended recipient, please contact the 
sender and delete all copies
-Original Message-
From: rbase-l@googlegroups.com  On Behalf Of A. 
Razzak Memon
Sent: Thursday, August 22, 2019 8:05 AM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - Tip of the Day: Using the New FSTATUS Function

Thursday, August 22, 2019

Tip of the Day: Using the New FSTATUS Function
Product...: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5)
Build.: 10.5.1.30822 or higher
Sections..: Functions
Keywords..: File, Folder, Hidden, Read Only, Open

Did you know you can check to see if a file exists, and also the file status?

The new FSTATUS function has been implemented to check if a file or folder 
exists, and also returns the status for the file. The read only, opened, 
available, and hidden file status can be retrieved.

If no path is specified, the function checks for the file or folder name in the 
current directory. Otherwise, the function checks for the file or folder name 
in the specified location. The function returns following possible values:

0 = file/folder does not exist
1 = file/folder exists, but cannot be read or written to. Folders will
 return this value, as well as file name searches with wild cards.
2 = file is marked as a read only file
3 = file is not marked as read only, but can only read it at this time
 (the file is opened by another program)
4 = file can be read and written to
 If the file is marked as hidden, the return value will be incremented by 
10;
 12 = read only and hidden, 14 = can read and write and hidden

Example (The brates.xlsx file exists, is marked hidden, and is opened):

SET VAR vFileStatus INTEGER = (FSTATUS('brates.xlsx')) SHOW VAR vFileStatus
13

In many applications, the ability to know if a file is open is quite important.
For example, when using the GATEWAY command and verifying a spreadsheet is not 
already open is very beneficial.

Very Best R:egards,

Razzak.

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


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

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

[RBASE-L] - RE: Email with attachment

[Lena Dammstrom]

Dan,
Thank you, thank you, thank you.

This did indeed resolve my issue

Regards
Lena

From: rbase-l@googlegroups.com  On Behalf Of Dan 
Goldberg
Sent: Tuesday, April 16, 2019 10:10 AM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - RE: Email with attachment

You might play with the JPEG_QUALITY in the options. It should shrink the 
picture sizes. Start with 80 and see how they look.

PRINT BreakInsRpt WHERE CustomerBreakinsID = .vbiBreakInID +
  OPTION PDF +
  |FILENAME  +
  |SHOW_CANCEL_DIALOG OFF +
  |EMAIL ON +
  |EMAIL_HOST .vbiESrvHost +
  |EMAIL_USERID .vbiESrvUser +
  |EMAIL_PASSWORD .vbiESrvPass +
  |EMAIL_ATTACHMENTS ' ' +
  |EMAIL_FROM_ADDRESS .vbiEFromAddress +
  |EMAIL_FROM_NAME .vbiEFromName +
  |EMAIL_TO_LIST .vbiEToList +
  |EMAIL_BCC_LIST .vbiEBCCList +
  |EMAIL_SUBJECT .vbiESubject +
  |EMAIL_BODY .vbiEBody +
  |EMAIL_DELETE_AFTER_SEND OFF +
  |EMAIL_SHOW_DIALOG OFF +
  |USE_COMPRESSION ON  +
 |COMPRESSION_METHOD MAXCOMPRESS +
|INCLUDE_IMAGES ON +
|IMAGE_FORMAT JPG +
|PIXELFORMAT 32 +
|JPEG_QUALITY 80




From: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com> 
mailto:rbase-l@googlegroups.com>> On Behalf Of Lena 
Dammstrom
Sent: Tuesday, April 16, 2019 8:01 AM
To: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>
Subject: [RBASE-L] - RE: Email with attachment

Dan,
Thanks for the suggestion.  I tried the compression, and did not help my 
situation.
Probably not compressing enough, due to pictures are being inserted/embedded 
onto the PDF.
Probably why I originally put a link to the pictures instead of the actual 
pictures.
Now they want the actual pictures, so they can print the pdf (with pictures)…

Regards
Lena

From: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com> 
mailto:rbase-l@googlegroups.com>> On Behalf Of Dan 
Goldberg
Sent: Tuesday, April 16, 2019 9:22 AM
To: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>
Subject: [RBASE-L] - RE: Email with attachment

Usually there is a limit of the email size set by the email provider.

You can compress the pdfs to make them smaller.

PRINT BreakInsRpt WHERE CustomerBreakinsID = .vbiBreakInID +
  OPTION PDF +
  |FILENAME  +
  |SHOW_CANCEL_DIALOG OFF +
  |EMAIL ON +
  |EMAIL_HOST .vbiESrvHost +
  |EMAIL_USERID .vbiESrvUser +
  |EMAIL_PASSWORD .vbiESrvPass +
  |EMAIL_ATTACHMENTS ' ' +
  |EMAIL_FROM_ADDRESS .vbiEFromAddress +
  |EMAIL_FROM_NAME .vbiEFromName +
  |EMAIL_TO_LIST .vbiEToList +
  |EMAIL_BCC_LIST .vbiEBCCList +
  |EMAIL_SUBJECT .vbiESubject +
  |EMAIL_BODY .vbiEBody +
  |EMAIL_DELETE_AFTER_SEND OFF +
  |EMAIL_SHOW_DIALOG OFF +
  |USE_COMPRESSION ON  +
 |COMPRESSION_METHOD MAXCOMPRESS |

Dan Goldberg

From: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com> 
mailto:rbase-l@googlegroups.com>> On Behalf Of Lena 
Dammstrom
Sent: Tuesday, April 16, 2019 7:13 AM
To: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>
Subject: [RBASE-L] - Email with attachment

Hi all,
Is there a size limitation in RBaseX version 10.0.4.3 for attachments?
If the PDF size is 3,317KB I receive the email
If the PDF size is 10,091KB I do not get the email

PRINT BreakInsRpt WHERE CustomerBreakinsID = .vbiBreakInID +
  OPTION PDF +
  |FILENAME  +
  |SHOW_CANCEL_DIALOG OFF +
  |EMAIL ON +
  |EMAIL_HOST .vbiESrvHost +
  |EMAIL_USERID .vbiESrvUser +
  |EMAIL_PASSWORD .vbiESrvPass +
  |EMAIL_ATTACHMENTS ' ' +
  |EMAIL_FROM_ADDRESS .vbiEFromAddress +
  |EMAIL_FROM_NAME .vbiEFromName +
  |EMAIL_TO_LIST .vbiEToList +
  |EMAIL_BCC_LIST .vbiEBCCList +
  |EMAIL_SUBJECT .vbiESubject +
  |EMAIL_BODY .vbiEBody +
  |EMAIL_DELETE_AFTER_SEND OFF +
  |EMAIL_SHOW_DIALOG OFF

Any clues would be most appreciated.
Thank you in advance for your time and consideration.

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

[RBASE-L] - RE: Email with attachment

[Lena Dammstrom]

Dan,
Thanks for the suggestion.  I tried the compression, and did not help my 
situation.
Probably not compressing enough, due to pictures are being inserted/embedded 
onto the PDF.
Probably why I originally put a link to the pictures instead of the actual 
pictures.
Now they want the actual pictures, so they can print the pdf (with pictures)…

Regards
Lena

From: rbase-l@googlegroups.com  On Behalf Of Dan 
Goldberg
Sent: Tuesday, April 16, 2019 9:22 AM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - RE: Email with attachment

Usually there is a limit of the email size set by the email provider.

You can compress the pdfs to make them smaller.

PRINT BreakInsRpt WHERE CustomerBreakinsID = .vbiBreakInID +
  OPTION PDF +
  |FILENAME  +
  |SHOW_CANCEL_DIALOG OFF +
  |EMAIL ON +
  |EMAIL_HOST .vbiESrvHost +
  |EMAIL_USERID .vbiESrvUser +
  |EMAIL_PASSWORD .vbiESrvPass +
  |EMAIL_ATTACHMENTS ' ' +
  |EMAIL_FROM_ADDRESS .vbiEFromAddress +
  |EMAIL_FROM_NAME .vbiEFromName +
  |EMAIL_TO_LIST .vbiEToList +
  |EMAIL_BCC_LIST .vbiEBCCList +
  |EMAIL_SUBJECT .vbiESubject +
  |EMAIL_BODY .vbiEBody +
  |EMAIL_DELETE_AFTER_SEND OFF +
  |EMAIL_SHOW_DIALOG OFF +
  |USE_COMPRESSION ON  +
 |COMPRESSION_METHOD MAXCOMPRESS |

Dan Goldberg

From: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com> 
mailto:rbase-l@googlegroups.com>> On Behalf Of Lena 
Dammstrom
Sent: Tuesday, April 16, 2019 7:13 AM
To: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>
Subject: [RBASE-L] - Email with attachment

Hi all,
Is there a size limitation in RBaseX version 10.0.4.3 for attachments?
If the PDF size is 3,317KB I receive the email
If the PDF size is 10,091KB I do not get the email

PRINT BreakInsRpt WHERE CustomerBreakinsID = .vbiBreakInID +
  OPTION PDF +
  |FILENAME  +
  |SHOW_CANCEL_DIALOG OFF +
  |EMAIL ON +
  |EMAIL_HOST .vbiESrvHost +
  |EMAIL_USERID .vbiESrvUser +
  |EMAIL_PASSWORD .vbiESrvPass +
  |EMAIL_ATTACHMENTS ' ' +
  |EMAIL_FROM_ADDRESS .vbiEFromAddress +
  |EMAIL_FROM_NAME .vbiEFromName +
  |EMAIL_TO_LIST .vbiEToList +
  |EMAIL_BCC_LIST .vbiEBCCList +
  |EMAIL_SUBJECT .vbiESubject +
  |EMAIL_BODY .vbiEBody +
  |EMAIL_DELETE_AFTER_SEND OFF +
  |EMAIL_SHOW_DIALOG OFF

Any clues would be most appreciated.
Thank you in advance for your time and consideration.

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

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

[RBASE-L] - Email with attachment

[Lena Dammstrom]

Hi all,
Is there a size limitation in RBaseX version 10.0.4.3 for attachments?
If the PDF size is 3,317KB I receive the email
If the PDF size is 10,091KB I do not get the email

PRINT BreakInsRpt WHERE CustomerBreakinsID = .vbiBreakInID +
  OPTION PDF +
  |FILENAME  +
  |SHOW_CANCEL_DIALOG OFF +
  |EMAIL ON +
  |EMAIL_HOST .vbiESrvHost +
  |EMAIL_USERID .vbiESrvUser +
  |EMAIL_PASSWORD .vbiESrvPass +
  |EMAIL_ATTACHMENTS ' ' +
  |EMAIL_FROM_ADDRESS .vbiEFromAddress +
  |EMAIL_FROM_NAME .vbiEFromName +
  |EMAIL_TO_LIST .vbiEToList +
  |EMAIL_BCC_LIST .vbiEBCCList +
  |EMAIL_SUBJECT .vbiESubject +
  |EMAIL_BODY .vbiEBody +
  |EMAIL_DELETE_AFTER_SEND OFF +
  |EMAIL_SHOW_DIALOG OFF

Any clues would be most appreciated.
Thank you in advance for your time and consideration.

Regards
Lena

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

[RBASE-L] - RE: refresh date/time picker

[Lena Dammstrom]

I wouldn't do the Clear Var vRangeStart  (that clears the variable from memory)


Set Var vRangeStart Date = null
Recalc variables

That is assuming your date/time picker is set to variable vRangeStart

Regards
Lena

-Original Message-
From: rbase-l@googlegroups.com  On Behalf Of Chaya 
Goldberg
Sent: Thursday, September 06, 2018 11:45 AM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - refresh date/time picker

Hi Everyone,

How do I refresh a variable date/time picker to the original (null) value?  
Attempting the following does not work - the date/time picker still shows the 
previously selected date.  

CLEAR VAR vrangestart
SET VAR vrangestart DATE = NULL
PROPERTY cirangestart REFRESHLIST 'true'

I must have the property name wrong.  Can anyone advise what I can use instead?

TIA!
Chaya

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

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

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

[Lena Dammstrom]

Razzak - thank you for the Formatting tip.

However, I cannot figure out how to capture that the month/year was changed 
from July 2018 (original value) to June 2018 (user changed to); when Show Days 
are off in the calendar.
The TextValue of the control appears to always stays the same as the original 
value July 2018.
Is calendar with Show Days off to be used for display purposes only?  Or am I 
missing a setting to allow for capturing changes?

Regards
Lena


-Original Message-
From: rbase-l@googlegroups.com  On Behalf Of A. 
Razzak Memon
Sent: Tuesday, August 21, 2018 1:39 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - EnhancedVarCalendar with Show Days off

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 TEXT = (FORMAT(.vDate,'MMM+ '))
SHOW VAR v1

Hope that provides you with some blue's clues!

Very Best R:egards,

Razzak

At 02:16 PM 8/21/2018, Lena Dammstrom wrote:


>Greetings all,
>Using RBase X latest version
>
>I cannot seem to capture the Month/Year selected by user.
>Coming into the form the date is set to 7/1/2018, but is changed to 
>June 2018.  Yet the TextValue remains at 7/1/2018.
>Neither the ON Change nor the ON Click  not trigger, only the On Exit 
>Yet the TextValue remains 7/1/2018 even though the month year has been 
>changed to June 2018.
>
>How do I capture the change when Show Days are off?
>
>Any clues would be greatly appreciated.
>Best Regards
>Lena
>
>EnhancedVarCalendar
>Var Name:  vgdmMonthOne  (date)
>ComponentID:  dtOneMonth
>Show Days (unchecked)
>Calendar Elements (checked) Year, Month and Arrow
>
>[]
>
>
>ON EXIT EPP
>Set Trace ON
>SET VAR vTmp TEXT = NULL
>GETPROPERTY dtOneMonth TEXTVALUE vTmp
>PAUSE 1 USING .vTmp
>SET VAR vgdmMonthOne = .vTmp
>RECALC VARIABLES
>PROCESSMESSAGE
>
>--
>For group guidelines, visit
><http://www.rbase.com/support/usersgroup_guidelines.php>http://www.rbas
>e.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.
>For more options, visit
><https://groups.google.com/d/optout>https://groups.google.com/d/optout.
>

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

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

[RBASE-L] - EnhancedVarCalendar with Show Days off

[Lena Dammstrom]

Greetings all,
Using RBase X latest version

I cannot seem to capture the Month/Year selected by user.
Coming into the form the date is set to 7/1/2018, but is changed to June 2018.  
Yet the TextValue remains at 7/1/2018.
Neither the ON Change nor the ON Click  not trigger, only the On Exit
Yet the TextValue remains 7/1/2018 even though the month year has been changed 
to June 2018.

How do I capture the change when Show Days are off?

Any clues would be greatly appreciated.
Best Regards
Lena

EnhancedVarCalendar
Var Name:  vgdmMonthOne  (date)
ComponentID:  dtOneMonth
Show Days (unchecked)
Calendar Elements (checked) Year, Month and Arrow

[cid:image001.png@01D4394D.BA98D430]

ON EXIT EPP
Set Trace ON
SET VAR vTmp TEXT = NULL
GETPROPERTY dtOneMonth TEXTVALUE vTmp
PAUSE 1 USING .vTmp
SET VAR vgdmMonthOne = .vTmp
RECALC VARIABLES
PROCESSMESSAGE

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

[RBASE-L] - Trying to download X updates from 20180515

[Lena Dammstrom]

Not sure what I may be doing wrong, but I keep getting either Codes Do Not 
Match, or cannot download

Any clues would be appreciated.
Thanks
Regards
Lena Dammstrom


[cid:image001.png@01D3F36A.92C31DE0]

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

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

[Lena Dammstrom]

Doug, I be interested in a more elegant way of checking for the existence of a 
table too!

I use the count method:
SET VAR vCount = 0
SELECT COUNT(*) INTO vCount FROM Sys_Tables +
  WHERE Sys_Table_Name = 'TableName' AND LIMIT = 1


Regards
Lena
From: rbase-l@googlegroups.com  On Behalf Of Doug 
Hamilton
Sent: Tuesday, May 01, 2018 10:33 AM
To: R:Base List 
Subject: [RBASE-L] - Does Table exist?

I'm drawing a blank - is there a command/function (in 9.5) to check for the 
existence of a table?
I want to see if a temp table exists before I try to recreate it.

I could try to count rows and check for error messages if the table isn't there 
but I suspect there's a more elegant method.
'Course, recreating an existing table would also give an error message...

TIA,
Doug
Now to get more coffee

[Image removed by 
sender.]

Virus-free. 
www.avast.com

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

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

RE: [RBASE-L] - CHOOSE command

[Lena Dammstrom]

I cannot dispute "life would be easier"!!!


-Original Message-
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
A. Razzak Memon
Sent: Monday, February 12, 2018 7:42 AM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - CHOOSE command

Good Morning Lena,

How about taking the leap and migrating all legacy DOS stuff to "XE", Olympic 
style? Life will be much easier and productive!

I know that is very easy for me to say :)

Very Best R:egards,

Razzak


At 08:35 AM 2/12/2018, Lena Dammstrom wrote:

>Razzak
>Thank you for the confirmation
>Also Albert thank you for your response
>
>Regards
>Lena
>
>Lena Dammstrom
>Software Developer
>
>Email:ldammst...@qmiusa.com
>Toll Free: 800-446-2500
>International: 01 630-529-7111
>Extension: 1037
>
>www.qmiusa.com
>
>--
>The information transmitted, including attachments, is intended only 
>for the person(s) or entity to which it is addressed and may contain 
>confidential and/or privileged material.  Any review, retransmission, 
>dissemination or other use of, or taking of any action in reliance upon 
>this information by persons or entities 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 09, 2018 5:54 PM
>To: rbase-l@googlegroups.com
>Subject: Re: [RBASE-L] - CHOOSE command
>
>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. 
> >Maybe it was added in RBGX
> >
> >>On Feb 9, 2018, at 3:00 PM, Lena Dammstrom <ldammst...@qmiusa.com> wrote:
> >>
> >>Hi all.
> >>
> >>I am wondering/trying to confirm…
> >> >
> >>Is the OPTION INITVAL available for CHOOSE command in RBase for DOS?
> >>
> >>My gut is telling windows only.
> >>
> >>Regards
> >>Lena


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

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

RE: [RBASE-L] - CHOOSE command

[Lena Dammstrom]

Razzak
Thank you for the confirmation
Also Albert thank you for your response

Regards
Lena



Lena Dammstrom
Software Developer

Email:ldammst...@qmiusa.com
Toll Free: 800-446-2500
International: 01 630-529-7111
Extension: 1037

www.qmiusa.com

--
The information transmitted, including attachments, is intended only for the 
person(s) or entity to which it is addressed and may contain confidential 
and/or privileged material.  Any review, retransmission, dissemination or other 
use of, or taking of any action in reliance upon this information by persons or 
entities 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 09, 2018 5:54 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - CHOOSE command

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. Maybe
>it was added in RBGX
>
>>On Feb 9, 2018, at 3:00 PM, Lena Dammstrom <ldammst...@qmiusa.com> wrote:
>>
>>Hi all.
>>
>>I am wondering/trying to confirm…
>> >
>>Is the OPTION INITVAL available for CHOOSE command in RBase for DOS?
>>
>>My gut is telling windows only.
>>
>>Regards
>>Lena


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

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

[RBASE-L] - CHOOSE command

[Lena Dammstrom]

Hi all.

I am wondering/trying to confirm…
Is the OPTION INITVAL available for CHOOSE command in RBase for DOS?

My gut is telling windows only.

Regards
Lena



[cid:image8f16b4.JPG@07d0382d.419922a0]<http://www.qmiusa.com/>

Lena Dammstrom
Software Developer
Email:ldammst...@qmiusa.com<mailto:ldammst...@qmiusa.com>
Toll Free:800-446-2500
International:01 630-529-7111
Extension:1037

www.qmiusa.com<http://www.qmiusa.com>




.

This email may contain material that is confidential, privileged and/or 
attorney work product for the sole use of the intended recipient. Any review, 
reliance or distribution by others or forwarding without express permission is 
strictly prohibited. If you are not the intended recipient, please contact the 
sender and delete all copies

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

RE: [RBASE-L] - SubReports

[Lena Dammstrom]

Jan,
I got my report/sub reports to work properly.

Thank you for all your help and insights!

Regards
Lena


From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
jan johansen
Sent: Wednesday, January 17, 2018 1:05 PM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - SubReports

Lena,

I am away from the office and I know that I have several reports where I turn 
off the displays of certain sections.
So it's possible I may get this wrong.

Place your sub-report in a section (something that gives you a componentid)
Test for your condition in the report ON BEFORE START eep.
In the report ON AFTER START eep do the

IF displayconditionyes THEN
  PROPERTY componentid VISIBLE TRUE
ELSE
  PROPERTY componentid VISIBLE FALSE
ENDIF

Something like that.

Jan

-Original Message-
From: Lena Dammstrom <ldammst...@qmiusa.com<mailto:ldammst...@qmiusa.com>>
To: "rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>" 
<rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>>
Date: Wed, 17 Jan 2018 12:45:03 -0600
Subject: RE: [RBASE-L] - SubReports

Jan,
I am trying to update an existing report which is working just fine, by adding 
an additional Sub report.
Was SR1, SR2, SR3, SR4 and SR5…  now SR1, SR2, SR3(was SR2), SR4(was SR3), 
SR5(was SR4) and SR6(was SR5).  I’ve changed the component IDs

When you say After start, I am thinking you are talking about the After 
Generate Custom eep in the Main
Currently everything is being done in the Before generate and nothing in the 
After generate.

With that being said, I am still confused….

Regards
Lena



From: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com> 
[mailto:rbase-l@googlegroups.com] On Behalf Of jan johansen
Sent: Wednesday, January 17, 2018 12:23 PM
To: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>
Subject: Re: [RBASE-L] - SubReports

Lena,

Don't know if this will fix your issue but in general
ALL and I mean ALL property must be used in the AFTER start section.

Jan


-Original Message-
From: Lena Dammstrom <ldammst...@qmiusa.com<mailto:ldammst...@qmiusa.com>>
To: "rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>" 
<rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>>
Date: Wed, 17 Jan 2018 12:14:46 -0600
Subject: [RBASE-L] - SubReports

Using RBase 9.5 (32) version 9.5.5.30128

I have a report with 6 sub reports  (ComponentID SR1 – SR6)
Main: tmpReportControls  with the six Object Sub Reports in the BreakHeader 0, 
breaking on the RptControlID (in tmpReportControls)

Sometimes I do not want SR2 to print

So I thought setting PROPERTY SR2 VISIBLE ‘FALSE’ in the Main: Before Generate 
would do the trick.
It does suppress the information from showing on the page, yet it does print a 
blank page between SR1 and SR3

Am I missing a setting, or am I trying to do something that cannot be done?

Any suggestions would be appreciated.
Regards
Lena




[cid:image001.jpg@01D39039.77902F70]<http://www.qmiusa.com/>

Lena Dammstrom

Software Developer

Email:

  ldammst...@qmiusa.com<mailto:ldammst...@qmiusa.com>

Toll Free:

  800-446-2500

International:

  01 630-529-7111

Extension:

  1037


www.qmiusa.com<http://www.qmiusa.com>




.


This email may contain material that is confidential, privileged and/or 
attorney work product for the sole use of the intended recipient. Any review, 
reliance or distribution by others or forwarding without express permission is 
strictly prohibited. If you are not the intended recipient, please contact the 
sender and delete all copies


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

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

RE: [RBASE-L] - SubReports

[Lena Dammstrom]

Jan,
I am trying to update an existing report which is working just fine, by adding 
an additional Sub report.
Was SR1, SR2, SR3, SR4 and SR5…  now SR1, SR2, SR3(was SR2), SR4(was SR3), 
SR5(was SR4) and SR6(was SR5).  I’ve changed the component IDs

When you say After start, I am thinking you are talking about the After 
Generate Custom eep in the Main
Currently everything is being done in the Before generate and nothing in the 
After generate.

With that being said, I am still confused….

Regards
Lena



From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
jan johansen
Sent: Wednesday, January 17, 2018 12:23 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - SubReports

Lena,

Don't know if this will fix your issue but in general
ALL and I mean ALL property must be used in the AFTER start section.

Jan


-Original Message-
From: Lena Dammstrom <ldammst...@qmiusa.com<mailto:ldammst...@qmiusa.com>>
To: "rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>" 
<rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>>
Date: Wed, 17 Jan 2018 12:14:46 -0600
Subject: [RBASE-L] - SubReports

Using RBase 9.5 (32) version 9.5.5.30128

I have a report with 6 sub reports  (ComponentID SR1 – SR6)
Main: tmpReportControls  with the six Object Sub Reports in the BreakHeader 0, 
breaking on the RptControlID (in tmpReportControls)

Sometimes I do not want SR2 to print

So I thought setting PROPERTY SR2 VISIBLE ‘FALSE’ in the Main: Before Generate 
would do the trick.
It does suppress the information from showing on the page, yet it does print a 
blank page between SR1 and SR3

Am I missing a setting, or am I trying to do something that cannot be done?

Any suggestions would be appreciated.
Regards
Lena




[cid:image001.jpg@01D38F90.D4766D70]<http://www.qmiusa.com/>

Lena Dammstrom

Software Developer

Email:

  ldammst...@qmiusa.com<mailto:ldammst...@qmiusa.com>

Toll Free:

  800-446-2500

International:

  01 630-529-7111

Extension:

  1037


www.qmiusa.com<http://www.qmiusa.com>




.


This email may contain material that is confidential, privileged and/or 
attorney work product for the sole use of the intended recipient. Any review, 
reliance or distribution by others or forwarding without express permission is 
strictly prohibited. If you are not the intended recipient, please contact the 
sender and delete all copies


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

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

[RBASE-L] - SubReports

[Lena Dammstrom]

Using RBase 9.5 (32) version 9.5.5.30128

I have a report with 6 sub reports  (ComponentID SR1 – SR6)
Main: tmpReportControls  with the six Object Sub Reports in the BreakHeader 0, 
breaking on the RptControlID (in tmpReportControls)

Sometimes I do not want SR2 to print

So I thought setting PROPERTY SR2 VISIBLE ‘FALSE’ in the Main: Before Generate 
would do the trick.
It does suppress the information from showing on the page, yet it does print a 
blank page between SR1 and SR3

Am I missing a setting, or am I trying to do something that cannot be done?

Any suggestions would be appreciated.
Regards
Lena





[cid:imagefcf8a9.JPG@412960c1.49a891c6]<http://www.qmiusa.com/>

Lena Dammstrom
Software Developer
Email:ldammst...@qmiusa.com<mailto:ldammst...@qmiusa.com>
Toll Free:800-446-2500
International:01 630-529-7111
Extension:1037

www.qmiusa.com<http://www.qmiusa.com>




.

This email may contain material that is confidential, privileged and/or 
attorney work product for the sole use of the intended recipient. Any review, 
reliance or distribution by others or forwarding without express permission is 
strictly prohibited. If you are not the intended recipient, please contact the 
sender and delete all copies

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

RE: [RBASE-L] - My RStyle - acting strange

[Lena Dammstrom]

Thanks Razzak.
In the meantime I now have a work around (use Database Explorer > Command Files 
> Edit Files(s) ...)

Regards
Lena


Lena Dammstrom
Software Developer

Email:ldammst...@qmiusa.com
Toll Free: 800-446-2500
International: 01 630-529-7111
Extension: 1037

www.qmiusa.com

--
The information transmitted, including attachments, is intended only for the 
person(s) or entity to which it is addressed and may contain confidential 
and/or privileged material.  Any review, retransmission, dissemination or other 
use of, or taking of any action in reliance upon this information by persons or 
entities 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: Thursday, October 12, 2017 8:57 AM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - My RStyle - acting strange

Lena,

You have found a boo-boo. This will be handled accordingly.

Thank you for your feedback!

Very Best R:egards,

Razzak


At 09:51 AM 10/12/2017, Lena Dammstrom wrote:

>Razzak
>I can get to it using the Edit Files
>[]
>
>
>
>Regards
>Lena
>
>
><http://www.qmiusa.com/>
>[]
>
>Lena Dammstrom
>Software Developer
>Email:   <mailto:ldammst...@qmiusa.com>ldammst...@qmiusa.com
>Toll Free:   800-446-2500
>International:   01 630-529-7111
>Extension:   1037
><http://www.qmiusa.com>www.qmiusa.com
>
>
>.
>
>--
>This email may contain material that is confidential, privileged and/or
>attorney work product for the sole use of the intended recipient. Any
>review, reliance or distribution by others or forwarding without
>express permission is strictly prohibited. If you are not the intended
>recipient, please contact the sender and delete all copies
>-Original Message-
>From: rbase-l@googlegroups.com
>[mailto:rbase-l@googlegroups.com] On Behalf Of A. Razzak Memon
>Sent: Thursday, October 12, 2017 8:27 AM
>To: rbase-l@googlegroups.com
>Subject: RE: [RBASE-L] - My RStyle - acting strange
>
>Lena,
>
>Thanks for confirming your version and build of RStyleX.dll.
>
>Just curious 
>
>What happens when updating the code/command file using the regular
>editor (not the EEP editor)?
>
>Database Explorer > Command Files > Edit Files(s) ...
>
>Using the internal editor you should be able to access/edit the Local
>Setup (.cfg) file ...
>
>Very Best R:egards,
>
>Razzak
>
>
>At 08:56 AM 10/12/2017, Lena Dammstrom wrote:
>
> >Thank you Razzak.
> >
> >Testing RBase X(32) Under VM - C:\Windows\system32\ My RStyleX.dll is
> >the correct version, looks exactly like snapshot provided.  (except
> >I also have a Digital Signature tab!) Permissions for VM: Users are
> >like my local workstation RStyle95.dll: Allow- Read and Read
> >
> >So I am still scratching my head!
> >
> >Regards
> >Lena
> >
> >Lena Dammstrom
> >Software Developer
> >
> >Email:ldammst...@qmiusa.com
> >Toll Free: 800-446-2500
> >International: 01 630-529-7111
> >Extension: 1037
> >
> ><http://www.qmiusa.com>www.qmiusa.com
> >
> >--
> >The information transmitted, including attachments, is intended only
> >for the person(s) or entity to which it is addressed and may contain
> >confidential and/or privileged material.  Any review,
> >retransmission, dissemination or other use of, or taking of any
> >action in reliance upon this information by persons or entities 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: <mailto:rbase-l@googlegroups.com>rbase-l@googlegroups.com
> >[mailto:rbase-l@googlegroups.com] On Behalf Of A. Razzak Memon
> >Sent: Wednesday, October 11, 2017 11:53 PM
> >To: <mailto:rbase-l@googlegroups.com>rbase-l@googlegroups.com
> >Subject: Re: [RBASE-L] - My RStyle - acting strange
> >
> >Lena:
> >
> >Make sure that you have the updated version and build of RStyleX.dll
> >installed on your local workstation.
> >
> >Depending on the Windows Operating System (32 or 64), with a typical
> >RBGX/RBGXE installation or update, the RStyleX.dll is typically
> >installed under c:\Windows\System32\ or c:\Windows\SysWOW64\ folder.
> >
> >Find the RStyleX.dll and then right-click to check the properties.
> >Click on the [

RE: [RBASE-L] - My RStyle - acting strange

[Lena Dammstrom]

Razzak

I can get to it using the Edit Files

[cid:image001.png@01D34337.3A3795E0]





Regards

Lena



[cid:image5dd48e.JPG@d0a1f35d.47b84fc6]<http://www.qmiusa.com/>

Lena Dammstrom
Software Developer
Email:ldammst...@qmiusa.com<mailto:ldammst...@qmiusa.com>
Toll Free:800-446-2500
International:01 630-529-7111
Extension:1037

www.qmiusa.com<http://www.qmiusa.com>




.

This email may contain material that is confidential, privileged and/or 
attorney work product for the sole use of the intended recipient. Any review, 
reliance or distribution by others or forwarding without express permission is 
strictly prohibited. If you are not the intended recipient, please contact the 
sender and delete all copies

-Original Message-
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
A. Razzak Memon
Sent: Thursday, October 12, 2017 8:27 AM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - My RStyle - acting strange



Lena,



Thanks for confirming your version and build of RStyleX.dll.



Just curious 



What happens when updating the code/command file using the regular editor (not 
the EEP editor)?



Database Explorer > Command Files > Edit Files(s) ...



Using the internal editor you should be able to access/edit the Local Setup 
(.cfg) file ...



Very Best R:egards,



Razzak





At 08:56 AM 10/12/2017, Lena Dammstrom wrote:



>Thank you Razzak.

>

>Testing RBase X(32) Under VM - C:\Windows\system32\ My RStyleX.dll is

>the correct version, looks exactly like snapshot provided.  (except I

>also have a Digital Signature tab!) Permissions for VM: Users are like

>my local workstation RStyle95.dll: Allow- Read and Read

>

>So I am still scratching my head!

>

>Regards

>Lena

>

>Lena Dammstrom

>Software Developer

>

>Email:ldammst...@qmiusa.com

>Toll Free: 800-446-2500

>International: 01 630-529-7111

>Extension: 1037

>

>www.qmiusa.com<http://www.qmiusa.com>

>

>--

>The information transmitted, including attachments, is intended only

>for the person(s) or entity to which it is addressed and may contain

>confidential and/or privileged material.  Any review, retransmission,

>dissemination or other use of, or taking of any action in reliance upon

>this information by persons or entities 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>

>[mailto:rbase-l@googlegroups.com] On Behalf Of A. Razzak Memon

>Sent: Wednesday, October 11, 2017 11:53 PM

>To: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>

>Subject: Re: [RBASE-L] - My RStyle - acting strange

>

>Lena:

>

>Make sure that you have the updated version and build of RStyleX.dll

>installed on your local workstation.

>

>Depending on the Windows Operating System (32 or 64), with a typical

>RBGX/RBGXE installation or update, the RStyleX.dll is typically

>installed under c:\Windows\System32\ or c:\Windows\SysWOW64\ folder.

>

>Find the RStyleX.dll and then right-click to check the properties.

>Click on the [Details] to check the exact File Version.

>

>See attached screen shot for the RStyleX.dll included with the latest

>updates of R:BASE X and R:BASE X Enterprise (Version 10).

>

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

>

>Very Best R:egards,

>

>Razzak

>

>

>At 04:54 PM 10/11/2017, Lena Dammstrom wrote:

>

> >Using RBase X 10.0.3.11010

> >

> >I cannot seem to get RStyle to work properly, and I am wondering if I

> >am missing a setting.

> >

> >Deleted all the RStyle.new and RStyleX.cfg files I could find on my C:

> >Drive

> >

> >1.   Opened form and ran RStyle against some code.

> >· This created in my working directory a

> >RStyle.new file   (which now contains a lot of entries)

> >· This created a RStyleX.cfg in my default installation directory

> >2.   Went to the Hammer and Wrench Icon and selected R:Style Local Setup

> >cid:image001.png@01D342A8.051F9090

> >

> >· This created in my working directory a RStyleX.cfg file

> >· But the window just blinks ­ never

> >opens the R:Style X Setup (local) so I can move New to other

> >tabs/files

> >

> >3.   Went to the Hammer and Wrench Icon

> and selected R:\Style Global Setup

> >· This open up the R:Style X Setup

> (Global) so I can change Settings

> >· There is nothing

RE: [RBASE-L] - My RStyle - acting strange

[Lena Dammstrom]

Thank you Razzak.

Testing RBase X(32) Under VM - C:\Windows\system32\
My RStyleX.dll is the correct version, looks exactly like snapshot provided.  
(except I also have a Digital Signature tab!)
Permissions for VM: Users are like my local workstation RStyle95.dll: Allow- 
Read and Read

So I am still scratching my head!

Regards
Lena



Lena Dammstrom
Software Developer

Email:ldammst...@qmiusa.com
Toll Free: 800-446-2500
International: 01 630-529-7111
Extension: 1037

www.qmiusa.com

--
The information transmitted, including attachments, is intended only for the 
person(s) or entity to which it is addressed and may contain confidential 
and/or privileged material.  Any review, retransmission, dissemination or other 
use of, or taking of any action in reliance upon this information by persons or 
entities 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: Wednesday, October 11, 2017 11:53 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - My RStyle - acting strange

Lena:

Make sure that you have the updated version and build of RStyleX.dll installed 
on your local workstation.

Depending on the Windows Operating System (32 or 64), with a typical RBGX/RBGXE 
installation or update, the RStyleX.dll is typically installed under 
c:\Windows\System32\ or c:\Windows\SysWOW64\ folder.

Find the RStyleX.dll and then right-click to check the properties. Click on the 
[Details] to check the exact File Version.

See attached screen shot for the RStyleX.dll included with the latest updates 
of R:BASE X and R:BASE X Enterprise (Version 10).

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

Very Best R:egards,

Razzak


At 04:54 PM 10/11/2017, Lena Dammstrom wrote:

>Using RBase X 10.0.3.11010
>
>I cannot seem to get RStyle to work properly, and I am wondering if I
>am missing a setting.
>
>Deleted all the RStyle.new and RStyleX.cfg files I could find on my C:
>Drive
>
>1.   Opened form and ran RStyle against some code.
>· This created in my working directory a
>RStyle.new file   (which now contains a lot of entries)
>· This created a RStyleX.cfg in my default installation directory
>2.   Went to the Hammer and Wrench Icon and selected R:Style Local Setup
>cid:image001.png@01D342A8.051F9090
>
>· This created in my working directory a RStyleX.cfg file
>· But the window just blinks – never
>opens the R:Style X Setup (local) so I can move New to other tabs/files
>
>3.   Went to the Hammer and Wrench Icon and selected R:\Style Global Setup
>· This open up the R:Style X Setup (Global) so I can change Settings
>· There is nothing in the RStyle.new
>(which points to default installation directory)
>
>I cannot get the Local Hammer and Wrench to open up so I can move
>things from New to Var file.  Every time I RStyle is puts into local
>file.
>
>Any suggestions would be appreciated.
>Thank you in advance for your time and consideration.

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

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

[RBASE-L] - My RStyle - acting strange

[Lena Dammstrom]

Using RBase X 10.0.3.11010

I cannot seem to get RStyle to work properly, and I am wondering if I am 
missing a setting.

Deleted all the RStyle.new and RStyleX.cfg files I could find on my C: Drive


1.   Opened form and ran RStyle against some code.

· This created in my working directory a RStyle.new file   (which now 
contains a lot of entries)

· This created a RStyleX.cfg in my default installation directory


2.   Went to the Hammer and Wrench Icon and selected R:Style Local Setup  
[cid:image001.png@01D342A9.2CC5E7B0]

· This created in my working directory a RStyleX.cfg file

· But the window just blinks – never opens the R:Style X Setup (local) 
so I can move New to other tabs/files


3.   Went to the Hammer and Wrench Icon and selected R:\Style Global Setup

· This open up the R:Style X Setup (Global) so I can change Settings

· There is nothing in the RStyle.new (which points to default 
installation directory)


I cannot get the Local Hammer and Wrench to open up so I can move things from 
New to Var file.  Every time I RStyle is puts into local file.

Any suggestions would be appreciated.
Thank you in advance for your time and consideration.

Regards
Lena




[cid:image3c96e8.JPG@6b1dea94.429b79a8]<http://www.qmiusa.com/>

Lena Dammstrom
Software Developer
Email:ldammst...@qmiusa.com<mailto:ldammst...@qmiusa.com>
Toll Free:800-446-2500
International:01 630-529-7111
Extension:1037

www.qmiusa.com<http://www.qmiusa.com>




.

This email may contain material that is confidential, privileged and/or 
attorney work product for the sole use of the intended recipient. Any review, 
reliance or distribution by others or forwarding without express permission is 
strictly prohibited. If you are not the intended recipient, please contact the 
sender and delete all copies

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

RE: [RBASE-L] - Crystal Reports ODBC Error 08004

[Lena Dammstrom]

Shot in the dark.
Is the Oterro95_32.cfg on the server setting STATICDB OFF?

Regards
Lena



Lena Dammstrom
Software Developer

Email:ldammst...@qmiusa.com
Toll Free: 800-446-2500
International: 01 630-529-7111
Extension: 1037

www.qmiusa.com

--
The information transmitted, including attachments, is intended only for the 
person(s) or entity to which it is addressed and may contain confidential 
and/or privileged material.  Any review, retransmission, dissemination or other 
use of, or taking of any action in reliance upon this information by persons or 
entities 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 
Doug Hamilton
Sent: Thursday, August 24, 2017 4:31 PM
To: R:Base List
Subject: [RBASE-L] - Crystal Reports ODBC Error 08004

Trying to make an ODBC connection from Crystal Reports to R:Base 9.5.
Works ok on local copy of db, but when trying to connect to production R:Base 
db on server, get DB Connection error: '08004:[RBTI][R:Base 9.5 ODBC Driver] 
...unavailable - it is open with STATICDB set ON.'

True, STATICDB is ON for all users, but we we're only reading data.
I'm obviously missing something.
Any clues for the blues?

Thanks,
Doug

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

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

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

[RBASE-L] - RE: Suppressing Error 1577

[Lena Dammstrom]

Thanks Dan.
Razzak’s answer supplied the portion of the view that was offending.
In table Onhand = Real, and the view was OnHand as Select Sum(OnHand).

Regards
Lena

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Dan Goldberg
Sent: Thursday, August 17, 2017 5:25 PM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - RE: Suppressing Error 1577

Can u post the code to create the view?

Dan Goldberg

From: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com> 
[mailto:rbase-l@googlegroups.com] On Behalf Of Lena Dammstrom
Sent: Thursday, August 17, 2017 2:32 PM
To: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>
Subject: [RBASE-L] - Suppressing Error 1577

Preparing to convert from 9.5 to RBaseX ver 10.0.2.20731
Doing some testing to make sure we don’t run into conversion issues.

Running some old code that creates views
COLCHECK is OFF
When running the code in RB9.5, it creates the views, and does not display any 
errors messages/warnings


When running the same code in RBase X  I get error messages/warnings like:

 The data type for column OnHand is not compatible with other uses of 
that column name (1577)

So I figured I would just SET ERROR MESSAGE 1577 OFF
Yet I still keep getting these warnings.

I confirmed that 1577 was off (before running a create view, and after view was 
created)

R>set var vlcd2 text = (GETVAL('CheckMessageStatus','1577'))

Value of vlcd2 is OFF



I even SET ERROR MESSAGES OFF – but still get the warnings.

Any clues as to what setting I am missing to suppress the warning message?

Thank you in advance for your time.
Regards
Lena

[cid:image001.jpg@01D317F6.45967BC0]<http://www.qmiusa.com/>

Lena Dammstrom

Software Developer

Email:

  ldammst...@qmiusa.com<mailto:ldammst...@qmiusa.com>

Toll Free:

  800-446-2500

International:

  01 630-529-7111

Extension:

  1037


www.qmiusa.com<http://www.qmiusa.com>




.


This email may contain material that is confidential, privileged and/or 
attorney work product for the sole use of the intended recipient. Any review, 
reliance or distribution by others or forwarding without express permission is 
strictly prohibited. If you are not the intended recipient, please contact the 
sender and delete all copies

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

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

RE: [RBASE-L] - Suppressing Error 1577

[Lena Dammstrom]

Thanks Albert

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Albert Berry
Sent: Thursday, August 17, 2017 8:10 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Suppressing Error 1577

R:Base uses an enforced data dictionary. You cannot create a column with the 
same name as another column but with a different specification.



On Aug 17, 2017, at 3:31 PM, Lena Dammstrom 
<ldammst...@qmiusa.com<mailto:ldammst...@qmiusa.com>> wrote:

Preparing to convert from 9.5 to RBaseX ver 10.0.2.20731
Doing some testing to make sure we don’t run into conversion issues.

Running some old code that creates views
COLCHECK is OFF
When running the code in RB9.5, it creates the views, and does not display any 
errors messages/warnings

When running the same code in RBase X  I get error messages/warnings like:
 The data type for column OnHand is not compatible with other uses of 
that column name (1577)

So I figured I would just SET ERROR MESSAGE 1577 OFF
Yet I still keep getting these warnings.

I confirmed that 1577 was off (before running a create view, and after view was 
created)
R>set var vlcd2 text = (GETVAL('CheckMessageStatus','1577'))
Value of vlcd2 is OFF

I even SET ERROR MESSAGES OFF – but still get the warnings.

Any clues as to what setting I am missing to suppress the warning message?

Thank you in advance for your time.
Regards
Lena


<http://www.qmiusa.com/>

Lena Dammstrom

Software Developer

Email:

  ldammst...@qmiusa.com<mailto:ldammst...@qmiusa.com>

Toll Free:

  800-446-2500

International:

  01 630-529-7111

Extension:

  1037


www.qmiusa.com<http://www.qmiusa.com/>




.


This email may contain material that is confidential, privileged and/or 
attorney work product for the sole use of the intended recipient. Any review, 
reliance or distribution by others or forwarding without express permission is 
strictly prohibited. If you are not the intended recipient, please contact the 
sender and delete all copies


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

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

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

RE: [RBASE-L] - Suppressing Error 1577

[Lena Dammstrom]

Thank you Razzak.
I had a feeling it had something to do with the Sum(OnHand).
The table OnHand is defined as Real and it looks like view Sum(OnHand) comes 
out as double.

Again many thanks for your insight into my situation.

Regards
Lena



Lena Dammstrom
Software Developer

Email:ldammst...@qmiusa.com
Toll Free: 800-446-2500
International: 01 630-529-7111
Extension: 1037

www.qmiusa.com

--
The information transmitted, including attachments, is intended only for the 
person(s) or entity to which it is addressed and may contain confidential 
and/or privileged material.  Any review, retransmission, dissemination or other 
use of, or taking of any action in reliance upon this information by persons or 
entities 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: Thursday, August 17, 2017 8:15 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Suppressing Error 1577

Lena,

I would not suppress that exact error message nor any -ERROR- messages when 
converting and/or upgrading a database from a LEGACY DOS/WIN version to R:BASE 
X or R:BASE X Enterprise (Version 10).

A few suggestions ...

01. Find all instances of "OnHand" column in your database

 LIST COLUMN OnHand

 This will provide you with a list of all tables with "OnHand" including 
any DEFAULT values or Expressions.

02. Now compare the definition of OnHand column with the same column name when 
defining VIEW.

In your case, for example, the column OnHand in InventoryLocations table might 
have an expression like this:

OnHand REAL = (BegInvCount+InventoryAdded-InventoryUsed)

If that is not the same expression defined for "OnHand" column when defining a 
VIEW, you will get that -ERROR- message, which will result in not creating that 
particular view.

If in fact that is the case, you cannot define the same column OnHand in VIEW 
as (SUM(OnHand)), etc. Basically, that would be considered as "incompatible" 
when the same column is used in the original table with a different expression 
as explained above. In this specific case, you may consider using a different 
column (alias) name when defining view.

FYI, column definitions along with column integrity rules may not be suppressed 
in R:BASE X and R:BASE X Enterprise (Version 10 and Version 10.5).

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

Very Best R:egards,

Razzak


At 05:31 PM 8/17/2017, Lena Dammstrom wrote:

>Preparing to convert from 9.5 to RBaseX ver 10.0.2.20731 Doing some
>testing to make sure we don’t run into conversion issues.
>
>Running some old code that creates views COLCHECK is OFF When running
>the code in RB9.5, it creates the views, and does not display any
>errors messages/warnings
>
>When running the same code in RBase X  I get error messages/warnings like:
> The data type for column OnHand is not compatible with other
>uses of that column name (1577)
>
>So I figured I would just SET ERROR MESSAGE 1577 OFF Yet I still keep
>getting these warnings.
>
>I confirmed that 1577 was off (before running a create view, and after
>view was created)
>R>set var vlcd2 text = (GETVAL('CheckMessageStatus','1577'))
>Value of vlcd2 is OFF
>
>I even SET ERROR MESSAGES OFF – but still get the warnings.
>
>Any clues as to what setting I am missing to suppress the warning message?
>
>Thank you in advance for your time.
>Regards
>Lena
>
>
><http://www.qmiusa.com/>
>[]
>
>Lena Dammstrom
>Software Developer
>Email:   <mailto:ldammst...@qmiusa.com>ldammst...@qmiusa.com
>Toll Free:   800-446-2500
>International:   01 630-529-7111
>Extension:   1037
><http://www.qmiusa.com>www.qmiusa.com
>
>
>.
>
>--
>This email may contain material that is confidential, privileged and/or
>attorney work product for the sole use of the intended recipient. Any
>review, reliance or distribution by others or forwarding without
>express permission is strictly prohibited. If you are not the intended
>recipient, please contact the sender and delete all copies
>
>--
>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.
>For more options, visit
><https://groups.google.com/d/optout>https://groups.google.c

[RBASE-L] - Suppressing Error 1577

[Lena Dammstrom]

Preparing to convert from 9.5 to RBaseX ver 10.0.2.20731
Doing some testing to make sure we don’t run into conversion issues.

Running some old code that creates views
COLCHECK is OFF
When running the code in RB9.5, it creates the views, and does not display any 
errors messages/warnings


When running the same code in RBase X  I get error messages/warnings like:

 The data type for column OnHand is not compatible with other uses of 
that column name (1577)

So I figured I would just SET ERROR MESSAGE 1577 OFF
Yet I still keep getting these warnings.

I confirmed that 1577 was off (before running a create view, and after view was 
created)

R>set var vlcd2 text = (GETVAL('CheckMessageStatus','1577'))

Value of vlcd2 is OFF



I even SET ERROR MESSAGES OFF – but still get the warnings.

Any clues as to what setting I am missing to suppress the warning message?

Thank you in advance for your time.
Regards
Lena



[cid:image238151.JPG@2cdd4505.4b9f565a]<http://www.qmiusa.com/>

Lena Dammstrom
Software Developer
Email:ldammst...@qmiusa.com<mailto:ldammst...@qmiusa.com>
Toll Free:800-446-2500
International:01 630-529-7111
Extension:1037

www.qmiusa.com<http://www.qmiusa.com>




.

This email may contain material that is confidential, privileged and/or 
attorney work product for the sole use of the intended recipient. Any review, 
reliance or distribution by others or forwarding without express permission is 
strictly prohibited. If you are not the intended recipient, please contact the 
sender and delete all copies

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

RE: [RBASE-L] - clicking too often

[Lena Dammstrom]

I usually follow my disabling with a ProcessMessage (command to process 
messages that are currently in the windows message queue)

Property componentID ENABLED ‘FALSE’
ProcessMessage






[cid:image9b4e0f.JPG@7c4fed3d.4dba12b2]<http://www.qmiusa.com/>

Lena Dammstrom
Software Developer
Email:ldammst...@qmiusa.com<mailto:ldammst...@qmiusa.com>
Toll Free:800-446-2500
International:01 630-529-7111
Extension:1037

www.qmiusa.com<http://www.qmiusa.com>




.

This email may contain material that is confidential, privileged and/or 
attorney work product for the sole use of the intended recipient. Any review, 
reliance or distribution by others or forwarding without express permission is 
strictly prohibited. If you are not the intended recipient, please contact the 
sender and delete all copies
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Albert Berry
Sent: Tuesday, July 18, 2017 2:45 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - clicking too often

Temporary tables are not within the database, they are .$$$ files on the drive. 
I always drop and never delete from temporary tables with no problems. The 
problems here appear from the posts to be that a second (double) click is 
sending a second request to the system.

There is one post in here that suggests that the first click can be used to 
disable the component so that R:Base doesn’t see the second click. I have not 
tried that myself, but it certainly sounds like a reasonable idea.


On Jul 18, 2017, at 1:06 PM, Tony IJntema 
<t.ijnt...@cio-bv.nl<mailto:t.ijnt...@cio-bv.nl>> wrote:

James,

Maybe a silly question, but why dropping the table instead of emptying  the 
table.
It looks a less vulnerable operation to me, but I could be wrong.

Tony

Van: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com> 
[mailto:rbase-l@googlegroups.com] Namens Jim Belisle
Verzonden: dinsdag 18 juli 2017 18:18
Aan: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>
Onderwerp: RE: [RBASE-L] - clicking too often

Dan,

That may explain what has been happening. A particular employee, twice now, has 
corrupted the DB.
Each time he gets an error that the temp table is not available.
If he is double clicking, could it be the second click is so fast it is running 
the deleting of the temp table (I delete temp tables at the start per training)?
Then the computer is confused? Not sure but so far it is only the one employee.
I am not on site until next week so I am not sure if this is the case.
But it is strange that it is the same employee each time. SO he must be doing 
something and as the programmer I need to stop him.

James Belisle

Making Information Systems People Friendly Since 1990


From: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com> 
[mailto:rbase-l@googlegroups.com] On Behalf Of Dan Goldberg
Sent: Tuesday, July 18, 2017 11:13 AM
To: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>
Subject: RE: [RBASE-L] - clicking too often

That is correct jim
Dan Goldberg
Lance Camper


On Tue, Jul 18, 2017 at 9:09 AM -0700, "Jim Belisle" 
<j...@kaypark.com<mailto:j...@kaypark.com>> wrote:
Dan and Jan,

So this is a bit button.
It creates a temp table then has code verifying the employee information prior 
to bringing up  another form.
You are saying I should put the property command at the start of the code.
Then if the employee double clicks instead of clicking, this will prevent the 
code from repeating.
Then Enable to form bit button at the end of the code. Is this correct?

James Belisle

Making Information Systems People Friendly Since 1990


From: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com> 
[mailto:rbase-l@googlegroups.com] On Behalf Of jan johansen
Sent: Tuesday, July 18, 2017 10:55 AM
To: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>
Subject: Re: [RBASE-L] - clicking too often

One thing you can do is "disable" the object in the on-click eep.,
Like
PROPERTY VariableListViewObject ENABLE FALSE

-Original Message-
From: Jim Belisle <j...@kaypark.com<mailto:j...@kaypark.com>>
To: "rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>" 
<rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>>
Date: Tue, 18 Jul 2017 15:50:14 +
Subject: [RBASE-L] - clicking too often

In the past there was a thread about preventing more than one click because of 
users being so used to “double clicking”.
I have looked in my saved lists and cannot seem to find it.
Can anyone give me an idea of how to prevent this?

We just installed my shop management system out in the shop and am concerned 
the employees will do the double clicking.
I want my code to be a “security blanket” against corruption due to too many 
clicks.

James Belisle

Making Information Systems People Friendly Since 1990

RE: [RBASE-L] - Bar Codes

[Lena Dammstrom]

Thank you, I see them now!

From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com]
Sent: Thursday, April 27, 2017 10:22 AM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Bar Codes

Right-click on your located DB barcode and pick "configure".  The choices are 
there

Karen



-Original Message-----
From: Lena Dammstrom <ldammst...@qmiusa.com<mailto:ldammst...@qmiusa.com>>
To: rbase-l <rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>>
Sent: Thu, Apr 27, 2017 10:18 am
Subject: [RBASE-L] - Bar Codes
Hi All,
Using RBase 9.5(32)  v9.5.5.30128  (no barcode plugin – if there is such a 
thing!)

I dropped  a DB Bar Code on a report.
However, the Bar Code reader on a phone in the office; does not seem to 
recognize it.
I changed the font to Bar Code, but still no success.

Reading “Understanding Bar Codes”   it lists 12 different bar codes, but I 
cannot figure out how to set the report bar code to one of these types.
I want either Code 39 (remember to open and close the barcode with asterisks.  
I assume the field being barcoded would be stored like *Lena*, for which I’ve 
done)
Or Code 128

Any assistance would be greatly appreciated.
Regards
Lena



[cid:image001.jpg@01D2BF40.9DCC9BD0]<http://www.qmiusa.com/>

Lena Dammstrom

Software Developer

Email:

  ldammst...@qmiusa.com<mailto:ldammst...@qmiusa.com>

Toll Free:

  800-446-2500

International:

  01 630-529-7111

Extension:

  1037


www.qmiusa.com<http://www.qmiusa.com>




.


This email may contain material that is confidential, privileged and/or 
attorney work product for the sole use of the intended recipient. Any review, 
reliance or distribution by others or forwarding without express permission is 
strictly prohibited. If you are not the intended recipient, please contact the 
sender and delete all copies

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

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

[RBASE-L] - Bar Codes

[Lena Dammstrom]

Hi All,
Using RBase 9.5(32)  v9.5.5.30128  (no barcode plugin – if there is such a 
thing!)

I dropped  a DB Bar Code on a report.
However, the Bar Code reader on a phone in the office; does not seem to 
recognize it.
I changed the font to Bar Code, but still no success.

Reading “Understanding Bar Codes”   it lists 12 different bar codes, but I 
cannot figure out how to set the report bar code to one of these types.
I want either Code 39 (remember to open and close the barcode with asterisks.  
I assume the field being barcoded would be stored like *Lena*, for which I’ve 
done)
Or Code 128

Any assistance would be greatly appreciated.
Regards
Lena





[cid:image393c91.JPG@904d3dd5.478a29f5]<http://www.qmiusa.com/>

Lena Dammstrom
Software Developer
Email:ldammst...@qmiusa.com<mailto:ldammst...@qmiusa.com>
Toll Free:800-446-2500
International:01 630-529-7111
Extension:1037

www.qmiusa.com<http://www.qmiusa.com>




.

This email may contain material that is confidential, privileged and/or 
attorney work product for the sole use of the intended recipient. Any review, 
reliance or distribution by others or forwarding without express permission is 
strictly prohibited. If you are not the intended recipient, please contact the 
sender and delete all copies

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

[RBASE-L] - RE: GetProperty "resistance" to being got!

[Lena Dammstrom]

Also no _ between GetProperty and ComponentID

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Lena Dammstrom
Sent: Thursday, April 20, 2017 3:19 PM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - RE: GetProperty "resistance" to being got!

Other than I single quoted my variable

SET VAR vPDF TEXT = NULL
GETPROPERTY FileBox1 SHORTFILENAME 'vPDF'

Regards
Lena


[cid:image001.jpg@01D2B9E9.C8C8FF60]<http://www.qmiusa.com/>

Lena Dammstrom

Software Developer

Email:

  ldammst...@qmiusa.com<mailto:ldammst...@qmiusa.com>

Toll Free:

  800-446-2500

International:

  01 630-529-7111

Extension:

  1037


www.qmiusa.com<http://www.qmiusa.com>




.


This email may contain material that is confidential, privileged and/or 
attorney work product for the sole use of the intended recipient. Any review, 
reliance or distribution by others or forwarding without express permission is 
strictly prohibited. If you are not the intended recipient, please contact the 
sender and delete all copies

From: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com> 
[mailto:rbase-l@googlegroups.com] On Behalf Of Alastair Burr
Sent: Thursday, April 20, 2017 1:16 PM
To: R:Base Listserver 2016
Subject: [RBASE-L] - GetProperty "resistance" to being got!

Can anybody see anything wrong with this:

SET VAR vFilePathName TEXT = NULL
GETPROPERTY ID_FileName SHORTFILENAME vFilePathName

File List Box On Click custom EEP
Ver: 10.0.2.20307

Both that and LongFileName both resolutely stay null through tracing.

Equivalent code for Directory in Directory Tree control works fine:

GETPROPERTY ID_DirName DIRECTORY vDirectory
PROPERTY ID_FileName DEFAULTDIRECTORY vDirectory

and files displayed correctly in File List Box - I just cannot seem to obtain 
the filename for some reason.

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

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

[RBASE-L] - RE: GetProperty "resistance" to being got!

[Lena Dammstrom]

Other than I single quoted my variable

SET VAR vPDF TEXT = NULL
GETPROPERTY FileBox1 SHORTFILENAME 'vPDF'

Regards
Lena




[cid:image92674e.JPG@c193035d.4eafe532]<http://www.qmiusa.com/>

Lena Dammstrom
Software Developer
Email:ldammst...@qmiusa.com<mailto:ldammst...@qmiusa.com>
Toll Free:800-446-2500
International:01 630-529-7111
Extension:1037

www.qmiusa.com<http://www.qmiusa.com>




.

This email may contain material that is confidential, privileged and/or 
attorney work product for the sole use of the intended recipient. Any review, 
reliance or distribution by others or forwarding without express permission is 
strictly prohibited. If you are not the intended recipient, please contact the 
sender and delete all copies
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Alastair Burr
Sent: Thursday, April 20, 2017 1:16 PM
To: R:Base Listserver 2016
Subject: [RBASE-L] - GetProperty "resistance" to being got!

Can anybody see anything wrong with this:

SET VAR vFilePathName TEXT = NULL
GETPROPERTY ID_FileName SHORTFILENAME vFilePathName

File List Box On Click custom EEP
Ver: 10.0.2.20307

Both that and LongFileName both resolutely stay null through tracing.

Equivalent code for Directory in Directory Tree control works fine:

GETPROPERTY ID_DirName DIRECTORY vDirectory
PROPERTY ID_FileName DEFAULTDIRECTORY vDirectory

and files displayed correctly in File List Box - I just cannot seem to obtain 
the filename for some reason.

Thanks in advance for any help,
Regards,
Alastair.

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

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

RE: [RBASE-L] - How I resolved my envelope printing issue

[Lena Dammstrom]

Thanks for telling us your final solution that resolved the issue.

Lena

From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com]
Sent: Friday, December 16, 2016 1:27 PM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - How I resolved my envelope printing issue

Remember about a month ago I asked for suggestions on this.  The company was 
printing around 500 envelopes at a time to an old laserjet (as one 500-page 
print, not 500 1-page prints) and sporadically we were getting blank envelopes, 
garbage characters, incomplete data, etc.   "Hiccuping" as I like to call it.  
Totally blaming it on the old laserjet, which I'm sure had little native memory.

Here's what we ended up doing, and it has worked flawlessly ever since.

I put up a choose box giving them these options.
Caption: Choose Last Names to Print
A - F
G - O
P - S
T - Z

I build a where clause based on what they pick, such as
SET VAR vWhere = (LastName BETWEEN 'A' AND 'Fz')
PRINT envelope WHERE  ORDER BY lastname OPTION PRINTER

Works like a charm!  The user is told not to print another set of envelopes 
until the previous set has completed.


Karen

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



[cid:image093b5d.JPG@c18d0998.4f94d1e6]<http://www.qmiusa.com/>

Lena Dammstrom
Software Developer
Email:ldammst...@qmiusa.com<mailto:ldammst...@qmiusa.com>
Toll Free:800-446-2500
International:01 630-529-7111
Extension:1037

www.qmiusa.com<http://www.qmiusa.com>




.

This email may contain material that is confidential, privileged and/or 
attorney work product for the sole use of the intended recipient. Any review, 
reliance or distribution by others or forwarding without express permission is 
strictly prohibited. If you are not the intended recipient, please contact the 
sender and delete all copies

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

[RBASE-L] - RE: Override field EEPs

[Lena Dammstrom]

The password at the end makes it *** as they are typing.

DIALOG 'HR Password' vTmp=8 vKey PASSWORD

Regards
Lena




[cid:image3fdd2b.JPG@d151d66e.4099479d]<http://www.qmiusa.com/>

Lena Dammstrom
Software Developer
Email:ldammst...@qmiusa.com<mailto:ldammst...@qmiusa.com>
Toll Free:800-446-2500
International:01 630-529-7111
Extension:1037

www.qmiusa.com<http://www.qmiusa.com>




.

This email may contain material that is confidential, privileged and/or 
attorney work product for the sole use of the intended recipient. Any review, 
reliance or distribution by others or forwarding without express permission is 
strictly prohibited. If you are not the intended recipient, please contact the 
sender and delete all copies
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Jim Belisle
Sent: Wednesday, December 14, 2016 5:49 AM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - RE: Override field EEPs

Dan,

I added the command to a custom form action.
If I use a speed button (not entering info into a field) so the manager can 
change the variable, how do I make it so his entry shows * instead of the 
actual text?
I see I can use property commands based on component IDs associated with 
fields. But how do I make a dialog box show just the * rather than the text?
I do not see where I can give a dialog box a component ID.
We do not use passwords at the present time either.

James Belisle

Making Information Systems People Friendly Since 1990
[cid:image004.jpg@01D255DB.A09565F0]

From: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com> 
[mailto:rbase-l@googlegroups.com] On Behalf Of Dan Goldberg
Sent: Tuesday, December 13, 2016 12:00 PM
To: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>
Subject: [RBASE-L] - RE: Override field EEPs

Here is one way.

Make the eeps call custom form actions instead of eeps.

Create a variable parameter to pass maybe called ‘user’

Then  you can put a button with an eep to change the variable parameter to 
‘manager’

When the custom form action runs it will look at the variable and run if it is 
‘user’. If not, do not run.

The button eep can have a password so only the manager can disable them.

Hope that makes sense.

Dan Goldberg





From: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com> 
[mailto:rbase-l@googlegroups.com] On Behalf Of Jim Belisle
Sent: Tuesday, December 13, 2016 9:14 AM
To: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>
Subject: [RBASE-L] - Override field EEPs

We use 9.5.
We want to control entries  in specific fields based on a certain criteria.
However in certain situations out in the shop I want the manager to be able to 
override those field EEPs.
Is there a property command that can do this?

James Belisle

Making Information Systems People Friendly Since 1990
[cid:image004.jpg@01D255DB.A09565F0]

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

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

[RBASE-L] - Columns Data Type of NOTE

[Lena Dammstrom]

Hi all,

Using RBASE 9.5 (32) 9.5.5.30128

My predecessor,  mentioned more than once;  when you have tables with Column(s) 
as Data Type NOTE; you should try to keep the NOTE column(s) at the end of the 
table structure.
For table OldTable, NOTE column is at end of table, even thou many fields have 
been added since the Note column was created.

So now I want to add another column NewColumn Currency to table OldTable.
When I write a command ALTER TABLE OldTable ADD Column NewColumn CURRENCY
It places the column at the end of table, after the OldNote NOTE column.

OldTable is an very wide table (currently 105 columns) with over 320,000 
records.
OldTable is one of the main tables in the database, so it is highly 
critical/used table.

Does keeping NOTE columns at the end table structure have any advantages?

Is there a way to ADD a column between 2 existing columns?

1)  GUI Tables\Design Table\Modify Existing Table – should work – any 
issues with this method on a large table?

2)  UNLOAD Structure A.Str, Unload Data, drop table, modify A.str to add 
new column.  Run A.str then reload data


Any insight/clues would be greatly appreciated.

Regards
Lena Dammstrom








[cid:image461138.JPG@7cf72b78.44a5fb0a]<http://www.qmiusa.com/>

Lena Dammstrom
Software Developer
Email:ldammst...@qmiusa.com<mailto:ldammst...@qmiusa.com>
Toll Free:800-446-2500
International:01 630-529-7111
Extension:1037

www.qmiusa.com<http://www.qmiusa.com>




.

This email may contain material that is confidential, privileged and/or 
attorney work product for the sole use of the intended recipient. Any review, 
reliance or distribution by others or forwarding without express permission is 
strictly prohibited. If you are not the intended recipient, please contact the 
sender and delete all copies

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

RE: Re[6]: [RBASE-L] - ERROR 2038 Referencing Existing Table(s)

[Lena Dammstrom]

Could it be because variable vLOJoin_Column_LIST
Is 19 characters long?

Lena




[cid:imageebbdb0.JPG@f8fbd514.4799007d]<http://www.qmiusa.com/>

Lena Dammstrom
Software Developer
Email:ldammst...@qmiusa.com<mailto:ldammst...@qmiusa.com>
Toll Free:800-446-2500
International:01 630-529-7111
Extension:1037

www.qmiusa.com<http://www.qmiusa.com>




.

This email may contain material that is confidential, privileged and/or 
attorney work product for the sole use of the intended recipient. Any review, 
reliance or distribution by others or forwarding without express permission is 
strictly prohibited. If you are not the intended recipient, please contact the 
sender and delete all copies
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Bruce Chitiea
Sent: Tuesday, June 28, 2016 4:43 PM
To: rbase-l@googlegroups.com
Subject: Re[6]: [RBASE-L] - ERROR 2038 Referencing Existing Table(s)

Why, yes, Ms. Tellef; yes it did.

That's disturbing. Let's see if it stays that way now.

Bruce



-- Original Message --
Sent: 6/28/2016 2:35:39 PM
Subject: Re: Re[4]: [RBASE-L] - ERROR 2038 Referencing Existing Table(s)
From: "karentellef via RBASE-L" 
<rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>>
To: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>
Cc:

Just for giggles, did you try replacing the variable name with my much shorter 
name to see if the error message goes away?   Otherwise, yeah, I wouldn't worry 
about it, set 2038 off...

Karen



-Original Message-
From: Bruce Chitiea <rby...@safesectors.com<mailto:rby...@safesectors.com>>
To: rbase-l <rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>>
Sent: Tue, Jun 28, 2016 4:31 pm
Subject: Re[4]: [RBASE-L] - ERROR 2038 Referencing Existing Table(s)
Karen:

Thanks. In mine, the variable vLOJoin_Column_LIST is consistently and correctly 
populated (with the three column names in the referenced table); after which 
the 2038 Unidentified Table ERROR is thrown.

There's the mystery.

Since I'm getting what I want, should I take a walk on the wild side and wrap 
the block with SET ERROR MESSAGE 2038 OFF/ON and simply hope that my luck holds 
up?

B



-- Original Message --
Sent: 6/28/2016 2:20:35 PM
Subject: Re: Re[2]: [RBASE-L] - ERROR 2038 Referencing Existing Table(s)
From: "karentellef via RBASE-L" 
<rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>>
To: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>
Cc:

Okay, let's see...  So I just now tested your second select command on my RBGX 
database and it worked fine.

Here's the syntax that worked for me:
SELECT (LISTOF(#1)) INTO vText iv1 FROM Sys_Columns t1, Sys_Tables t2   WHERE 
t1.Sys_Table_ID =
t2.Sys_Table_ID AND t2.Sys_Table_Name = "whycol"

This did NOT work (got "syntax is incorrect for select"):
SELECT (LISTOF(#1)) INTO vLOJoin_Column_LIST IND iv1 FROM Sys_Columns t1, 
Sys_Tables t2   WHERE t1.Sys_Table_ID =
t2.Sys_Table_ID AND t2.Sys_Table_Name = "whycol"


Only difference is the variable name...

Karen

-Original Message-
From: Bruce Chitiea <rby...@safesectors.com<mailto:rby...@safesectors.com>>
To: rbase-l <rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>>
Sent: Tue, Jun 28, 2016 3:55 pm
Subject: Re[2]: [RBASE-L] - ERROR 2038 Referencing Existing Table(s)
Dan/Karen:

Hmm, indeed.

Adding "AND LIMIT = 1" to the first block solves the problem for that block:

--JOINER Column Name
  SELECT #1 INTO vWalk_JLINK_COLUMN INDICATOR iv1 +
FROM Sys_Columns t1 ,  +
 Sys_Tables t2 +
   WHERE t1.Sys_Table_ID = t2.Sys_Table_ID +
 AND t2.Sys_Table_Name = .vWalk_JLINK_TABLE +
 AND LIMIT = 1

That is NOT the solution for the second block, as I need a list of column names 
returned:

--Capture Column Names for LOJoin_ColumnSET Assembly
  SELECT (LISTOF(#1)) +
INTO vLOJoin_Column_LIST INDICATOR iv1 +
FROM Sys_Columns t1, +
 Sys_Tables t2 +
   WHERE t1.Sys_Table_ID = t2.Sys_Table_ID +
 AND t2.Sys_Table_Name = .vLoop101_TABLE

... adding "AND LIMIT = 1" returns only the first column name. Do I first need 
to do a column count and then set the limit to that? Or is this not the way to 
snag a list of column names for a table?

Thanks for helping.

Bruce



-- Original Message --
Sent: 6/28/2016 1:25:49 PM
Subject: RE: [RBASE-L] - ERROR 2038 Referencing Existing Table(s)
From: "Dan Goldberg" <d...@lancecamper.com<mailto:d...@lancecamper.com>>
To: "rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>" 
<rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>>
Cc:

Hmm when I run it in 9.5 it says “too many rows returned”, which would make 
sense since most tables have more than one row

RE: Re[6]: [RBASE-L] - ERROR 2038 Referencing Existing Table(s)

[Lena Dammstrom]

Whoops  missed the other string of emails that mentioned the length of the 
variable!!!


From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Lena Dammstrom
Sent: Wednesday, June 29, 2016 1:10 PM
To: rbase-l@googlegroups.com
Subject: RE: Re[6]: [RBASE-L] - ERROR 2038 Referencing Existing Table(s)

Could it be because variable vLOJoin_Column_LIST
Is 19 characters long?

Lena


[cid:image001.jpg@01D1D208.1B699290]<http://www.qmiusa.com/>

Lena Dammstrom

Software Developer

Email:

  ldammst...@qmiusa.com<mailto:ldammst...@qmiusa.com>

Toll Free:

  800-446-2500

International:

  01 630-529-7111

Extension:

  1037


www.qmiusa.com<http://www.qmiusa.com>




.


This email may contain material that is confidential, privileged and/or 
attorney work product for the sole use of the intended recipient. Any review, 
reliance or distribution by others or forwarding without express permission is 
strictly prohibited. If you are not the intended recipient, please contact the 
sender and delete all copies

From: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com> 
[mailto:rbase-l@googlegroups.com] On Behalf Of Bruce Chitiea
Sent: Tuesday, June 28, 2016 4:43 PM
To: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>
Subject: Re[6]: [RBASE-L] - ERROR 2038 Referencing Existing Table(s)

Why, yes, Ms. Tellef; yes it did.

That's disturbing. Let's see if it stays that way now.

Bruce



-- Original Message --
Sent: 6/28/2016 2:35:39 PM
Subject: Re: Re[4]: [RBASE-L] - ERROR 2038 Referencing Existing Table(s)
From: "karentellef via RBASE-L" 
<rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>>
To: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>
Cc:

Just for giggles, did you try replacing the variable name with my much shorter 
name to see if the error message goes away?   Otherwise, yeah, I wouldn't worry 
about it, set 2038 off...

Karen



-Original Message-
From: Bruce Chitiea <rby...@safesectors.com<mailto:rby...@safesectors.com>>
To: rbase-l <rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>>
Sent: Tue, Jun 28, 2016 4:31 pm
Subject: Re[4]: [RBASE-L] - ERROR 2038 Referencing Existing Table(s)
Karen:

Thanks. In mine, the variable vLOJoin_Column_LIST is consistently and correctly 
populated (with the three column names in the referenced table); after which 
the 2038 Unidentified Table ERROR is thrown.

There's the mystery.

Since I'm getting what I want, should I take a walk on the wild side and wrap 
the block with SET ERROR MESSAGE 2038 OFF/ON and simply hope that my luck holds 
up?

B



-- Original Message --
Sent: 6/28/2016 2:20:35 PM
Subject: Re: Re[2]: [RBASE-L] - ERROR 2038 Referencing Existing Table(s)
From: "karentellef via RBASE-L" 
<rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>>
To: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>
Cc:

Okay, let's see...  So I just now tested your second select command on my RBGX 
database and it worked fine.

Here's the syntax that worked for me:
SELECT (LISTOF(#1)) INTO vText iv1 FROM Sys_Columns t1, Sys_Tables t2   WHERE 
t1.Sys_Table_ID =
t2.Sys_Table_ID AND t2.Sys_Table_Name = "whycol"

This did NOT work (got "syntax is incorrect for select"):
SELECT (LISTOF(#1)) INTO vLOJoin_Column_LIST IND iv1 FROM Sys_Columns t1, 
Sys_Tables t2   WHERE t1.Sys_Table_ID =
t2.Sys_Table_ID AND t2.Sys_Table_Name = "whycol"


Only difference is the variable name...

Karen
-Original Message-
From: Bruce Chitiea <rby...@safesectors.com<mailto:rby...@safesectors.com>>
To: rbase-l <rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>>
Sent: Tue, Jun 28, 2016 3:55 pm
Subject: Re[2]: [RBASE-L] - ERROR 2038 Referencing Existing Table(s)
Dan/Karen:

Hmm, indeed.

Adding "AND LIMIT = 1" to the first block solves the problem for that block:

--JOINER Column Name
  SELECT #1 INTO vWalk_JLINK_COLUMN INDICATOR iv1 +
FROM Sys_Columns t1 ,  +
 Sys_Tables t2 +
   WHERE t1.Sys_Table_ID = t2.Sys_Table_ID +
 AND t2.Sys_Table_Name = .vWalk_JLINK_TABLE +
 AND LIMIT = 1

That is NOT the solution for the second block, as I need a list of column names 
returned:

--Capture Column Names for LOJoin_ColumnSET Assembly
  SELECT (LISTOF(#1)) +
INTO vLOJoin_Column_LIST INDICATOR iv1 +
FROM Sys_Columns t1, +
 Sys_Tables t2 +
   WHERE t1.Sys_Table_ID = t2.Sys_Table_ID +
 AND t2.Sys_Table_Name = .vLoop101_TABLE

... adding "AND LIMIT = 1" returns only the first column name. Do I first need 
to do a column count and then set the limit to that? Or is this not the way to 
snag a list of column names for a table?

Thanks for helping.

Bruce



-- Original Message --
Sent: 6/28/2016 1:25:49 PM
Subject: RE: [RBASE-L] - ERROR 2038 Referenci