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

2019-08-22 Thread 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

[RBASE-L] - RE: Email with attachment

2019-04-16 Thread Lena Dammstrom
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 Len

[RBASE-L] - RE: Email with attachment

2019-04-16 Thread Lena Dammstrom
HOW_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:rbas

[RBASE-L] - Email with attachment

2019-04-16 Thread 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 &vbiEReportName + |SHOW_CAN

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

2018-09-06 Thread 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 Gol

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

2018-08-21 Thread Lena Dammstrom
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 a

[RBASE-L] - EnhancedVarCalendar with Show Days off

2018-08-21 Thread 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 th

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

2018-05-24 Thread 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

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

2018-05-03 Thread Lena Dammstrom
les/views created by user Lena will NOT be seen by another user, or even a separate session of R:BASE started by Lena. Hope that helps! Very Best R:egards, Razzak At 05:31 PM 5/3/2018, Lena Dammstrom wrote: >Someone can correct me if I am wrong, but I have it in my head that >Temp tabl

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

2018-05-03 Thread Lena Dammstrom
lName ……… Buddy From: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com> <mailto:rbase-l@googlegroups.com> On Behalf Of Lena Dammstrom Sent: Tuesday, May 1, 2018 11:41 AM To: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com> Subject: RE: [RBASE-L] - Does Table exist?

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

2018-05-01 Thread 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 H

RE: [RBASE-L] - CHOOSE command

2018-02-12 Thread Lena Dammstrom
rning 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

RE: [RBASE-L] - CHOOSE command

2018-02-12 Thread 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

[RBASE-L] - CHOOSE command

2018-02-09 Thread 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...@qmiu

RE: [RBASE-L] - SubReports

2018-01-18 Thread Lena Dammstrom
EFORE 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 mailto:ldammst...@qmiusa.com>> To: "rbase-l@

RE: [RBASE-L] - SubReports

2018-01-17 Thread Lena Dammstrom
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 Damm

[RBASE-L] - SubReports

2018-01-17 Thread Lena Dammstrom
. 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.qmi

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

2017-10-12 Thread 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.qmiu

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

2017-10-12 Thread 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:

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

2017-10-12 Thread Lena Dammstrom
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

[RBASE-L] - My RStyle - acting strange

2017-10-11 Thread Lena Dammstrom
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-71

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

2017-08-24 Thread 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

[RBASE-L] - RE: Suppressing Error 1577

2017-08-18 Thread Lena Dammstrom
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

RE: [RBASE-L] - Suppressing Error 1577

2017-08-18 Thread Lena Dammstrom
the same name as another column but with a different specification. On Aug 17, 2017, at 3:31 PM, Lena Dammstrom 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 so

RE: [RBASE-L] - Suppressing Error 1577

2017-08-18 Thread 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

[RBASE-L] - Suppressing Error 1577

2017-08-17 Thread Lena Dammstrom
hank 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 Extensio

RE: [RBASE-L] - clicking too often

2017-07-18 Thread 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

RE: [RBASE-L] - Bar Codes

2017-04-27 Thread Lena Dammstrom
ere Karen -Original Message----- From: Lena Dammstrom mailto:ldammst...@qmiusa.com>> To: rbase-l 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

[RBASE-L] - Bar Codes

2017-04-27 Thread Lena Dammstrom
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-71

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

2017-04-20 Thread 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 tha

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

2017-04-20 Thread 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...@qm

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

2016-12-16 Thread Lena Dammstrom
. 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 6

[RBASE-L] - RE: Override field EEPs

2016-12-14 Thread 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...@qm

RE: [RBASE-L] - New topic: My retirement

2016-10-18 Thread Lena Dammstrom
ore options, visit https://groups.google.com/d/optout. [cid:image649c60.JPG@5ddd8c3c.449f3769]<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-

[RBASE-L] - Columns Data Type of NOTE

2016-07-28 Thread Lena Dammstrom
\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

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

2016-06-29 Thread 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 Internationa

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

2016-06-29 Thread 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

RE: [RBASE-L] - Fw: RMailx Plugin: Apostrophe Anomaly

2016-05-02 Thread Lena Dammstrom
Lena [cid:image9a21c3.JPG@943e0e2f.4d829356]<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:/