RE: [EXTERNAL] Re: [RBASE-L] - Rbase office

['Ramsour, Michael A' via RBASE-L]

Greetings!

I too am a bit surprised/concerned.  Our most recent communication was on July 
7th.

Sure hope everything is OK.

Best regards.


[cid:image001.jpg@01D9B4C9.9FDD58D0]

MIKE RAMSOUR
Senior Quality Engineer
p 740.829.4340   m 740.502.1659
mike.rams...@clevelandcliffs.com

CLEVELAND-CLIFFS INC.
Coshocton Works
17400 State Route 16, Coshocton, OH 43812
p 740.829.3000   clevelandcliffs.com

From: rbase-l@googlegroups.com  On Behalf Of Bruce 
Chitiea
Sent: Wednesday, July 12, 2023 2:00 PM
To: rbase-l@googlegroups.com
Subject: [EXTERNAL] Re: [RBASE-L] - Rbase office

If that silence is of more than a few days duration, no answer. Comms 
nationally are taking a beating this week, what with storms, heat and solar 
activity. Here in SoCal we're having Spectrum and Verizon issues. Guess we'll 
find out. Bruce A. 
ZjQcmQRYFpfptBannerStart
This Message Is From an External Sender
This message came from outside your organization. Stop, Think, and use caution 
before clicking on links or opening attachments.
Report Suspicious  

   ‌
ZjQcmQRYFpfptBannerEnd
If that silence is of more than a few days duration, no answer.

Comms nationally are taking a beating this week, what with storms, heat and 
solar activity. Here in SoCal we're having Spectrum and Verizon issues.

Guess we'll find out.

Bruce A. Chitiea | SafeSectors, Inc.
112 Harvard Ave #272 | Claremont CA 91711-4716 | USA
+011 (909) 238-9012 m | rby...@safesectors.com

-- Original Message --
>From "Rich" mailto:r...@ogdengroup.com>>
To rbase-l@googlegroups.com
Date 7/12/2023 10:46:37 AM
Subject [RBASE-L] - Rbase office


Has anyone had contact with them? Sales does not respond to emails and the 
phone always goes to VM.

Rich Jasinski
Sent from my iPhone

--
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/69024667-1798-48FB-9A25-C7D669067E87%40ogdengroup.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/em5de1f14e-1aaa-4e23-98c4-5c85efb802d1%40cd0f.com.

__
This electronic message and any attachments included with this message are for 
the exclusive use of the individual or entity to which it is intended to be 
addressed. This message may contain information that is privileged or 
confidential and thereby exempt and protected from unauthorized disclosure 
under applicable law. If the reader of this message is not the intended 
recipient, or an employee or agent responsible for delivering the message to 
the intended recipient, be aware that any disclosure, dissemination, 
distribution or copying of this communication, or the use of its contents, is 
not authorized and is strictly prohibited. If you have received this 
communication and are not the intended recipient, please notify the sender 
immediately and permanently delete the original message from your e-mail system.
__

-- 
For group guidelines, visit 

RE: [EXTERNAL] [RBASE-L] - Date

['Ramsour, Michael A' via RBASE-L]

Hi, Jan:

Check out the ADDMON and ADDYR functions.  You can use negative values for the 
second argument.

Here's an example:

set var vdate = (ADDMON(.#DATE,-2))
SHOW VAR VDATE
11/12/2022

Or going forward in time:

set var vdate = (ADDMON(.#DATE,2))
show var vdate
03/12/2023

Hope that helps.





[cid:image001.jpg@01D9268A.9A126760]

MIKE RAMSOUR
Senior Quality Engineer
p 740.829.4340   m 740.502.1659
mike.rams...@clevelandcliffs.com

CLEVELAND-CLIFFS INC.
Coshocton Works
17400 State Route 16, Coshocton, OH 43812
p 740.829.3000   clevelandcliffs.com

From: rbase-l@googlegroups.com  On Behalf Of jan 
johansen
Sent: Thursday, January 12, 2023 1:28 PM
To: rbase-l@googlegroups.com
Subject: [EXTERNAL] [RBASE-L] - Date

All,

I'm having a brain cramp. My code doesn't handle crossing years apparently.
I need to set a start date that is the first of the 2 months ago based on today 
i.e. 11/1/2022

Thanks


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

__
This electronic message and any attachments included with this message are for 
the exclusive use of the individual or entity to which it is intended to be 
addressed. This message may contain information that is privileged or 
confidential and thereby exempt and protected from unauthorized disclosure 
under applicable law. If the reader of this message is not the intended 
recipient, or an employee or agent responsible for delivering the message to 
the intended recipient, be aware that any disclosure, dissemination, 
distribution or copying of this communication, or the use of its contents, is 
not authorized and is strictly prohibited. If you have received this 
communication and are not the intended recipient, please notify the sender 
immediately and permanently delete the original message from your e-mail system.
__

-- 
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/DM6PR04MB54365F500D41064522E5639D9FFD9%40DM6PR04MB5436.namprd04.prod.outlook.com.

[RBASE-L] - Re: (CVAL('ComputerName'))

[Michael Byerley]

copy to a file ending with .VBS like:

CompName.VBS

these lines:

Dim WshNetwork
Set WshNetwork = CreateObject("WScript.Network")
ComputerName = WshNetwork.ComputerName
msgbox(computername)

just double click the filename to run it.  VBScript is STILL runable on any 
windows box



On Wednesday, August 19, 2020 at 3:41:35 PM UTC-4, Karen Tellef wrote:
>
> I need to do some security based on   (CVAL('ComputerName')) for an app 
> I'm converting from System V.
>
> I want to have my programming done up front, and obviously with System V I 
> cannot have them look up the "ComputerName" of their computers for me 
> (don't have 10.5 installed on all workstations yet)
>
>
> So is there another way I can tell them to "find" the ComputerName, which 
> would return the same value that the RBase function would return?
>
>
> Karen
>
>

-- 
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/d945ffca-a4b0-4810-ad24-546e03200625o%40googlegroups.com.

[RBASE-L] - Re: Best practices?

[Michael Byerley]

  I do #2 as a matter of routine, so a choice can be made based on the 
current desire.

On Monday, August 3, 2020 at 4:40:31 PM UTC-4, Karen Tellef wrote:
>
> Hard to believe in my decades of programming that this is the first time 
> this has happened.  Just wondering if other programmers have tips on this 
> situation for the future.  And I'm kinda bored this afternoon so thought I 
> would post.
>
> History:  I work on this company's stuff with another programmer.  We work 
> independently, each of us handling different "areas" of the business.  The 
> company's contact himself also does a bit of programming.  So 3 of us 
> writing programs.
>
> I write a new program today, works great for me, he keeps claiming it 
> doesn't work for him, giving him my "no data to report" message.  He exits 
> and comes back in, never works.  I finally ask him exactly the process 
> he's going thru, and I find out that he will run another program 
> immediately before running this program.  Aha, a clue.
>
> Guess what.  In that other program (written by the other programmer), he 
> creates a temp table (and doesn't drop it) using the same column name that 
> I have in my temp table, but as a different datatype!  So my temp table 
> was never created because of the structure error, and it reports no data!
>
> So what's the best way to prevent this?  I was thinking of things like:
>
> 1.  Each of us using temp column names using our initials (like: ktQty 
> INT).  But even with that, there's no guarantee that I'll remember I used a 
> "ktQty" as a Double once, and as an Integer another time.  
>
> 2.  I could search program code for occurrences of each "new" temp column 
> name I want to use to see if any other program uses that name.
>
> 3.  I could only use permanent column names, altho using the permanent 
> name "Qty" is not as descriptive as a temp column name like:  
> tmpQtyToShipByMonthend
>
>
> But in reality there's 3 "easy" things I could do:
>
> 1.  We could drop our temp tables at the end of our programs.  None of us 
> do this. I like leaving them around in case I run something from the menu 
> and want to get to the R> prompt to see temp table data.  Do you all drop 
> temp tables?
>
> 2.  After every "create temp table" do a "select ... from sys_tables" to 
> see if the temp table exists.   Seems the easiest, doesn't it?   Again, do 
> any of you routinely do this?
>
> 3.  Or.. I can figure that since this has happened once in the >20 yrs 
> that I've worked on that account, figure that it's most likely not going to 
> happen again so don't worry about it.
>
>
> Just some Monday musings..
>
>
> Karen
>
>
>
>
>
>

-- 
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/29634058-c9c6-468b-968b-fdaff81eccd9o%40googlegroups.com.

[RBASE-L] - Re: scaling dialog box

[Michael Byerley]

  As Razzak said, customized form works nicely.  You can pass values to the 
form in the EDIT or ENTER USING command by using the CAPTION element.  You 
can put a string there to be parsed in the ON BEFORE portion of the opening 
sequence with whatever separator you wish to use.  

For Example, you might do:   EDIT USING frmSomeForm Where SomeWhereClause 
CAPTION 'CAPTION=This is my Custom Dialog Form#ReturnVarName=vRetSomeText'

using the # as the first separator and the '=' sign as to what to do to the 
other elements.



On Friday, July 17, 2020 at 10:42:57 AM UTC-4, dang wrote:
>
> I am playing with the command for forms which is working great.
>
>  
>
> PROPERTY RBASE_FORM SCALEBY 'FILL_SCREEN'
>
>  
>
> As I have handhelds now with different resolutions it works very good. 
>
>  
>
> So now I want to scale or enlarge the dialog and pause boxes because they 
> are still small.  I can do the options to increase the font size manually 
> but do not know how to increase the size of the buttons.
>
>  
>
> TIA
>
>  
>
>  
>
> Dan Goldberg
>

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

Re: [RBASE-L] - Re: Running C++ code withe R:Base

[Michael Byerley]

  That is exactly hard to say, but if the application structure 
collects/queries the Access DB, then passes that to an internal function to 
be returned to the real world (screen/printer, ect), then I would say, IF 
the internal functions were EXPORTED, then maybe you could collect the data 
from RBase directly and pass it to the EXPORTED function for action.  It's 
just hard to hypothesize, not knowing exactly what is going on.



On Wednesday, July 15, 2020 at 1:12:35 PM UTC-4, javier.valencia wrote:
>
> Thank you, this is valuable information.
>
> I believe I experimented with that many moons ago but I always went back 
> to pure R:Base code because invariably, by the time I was close to 
> implementing an external solution R:Base would introduce a 
> command/utility/construct that would made the external utility moot.
>
> This is a complete application written in C++ with menus and calls to the 
> MS Access database. Would the solution be to convert any command in the C++ 
> application that calls for database query/access to a DLL call to the 
> R:Base database?
>
>  
>
> Javier,
>
>  
>
> Javier Valencia, PE
>
> 14315 S. Twilight Ln.
>
> Olathe, KS 66062
>
> Office: 913-829-0888
>
> Cell: 913-915-3137
>
>  
>
> *From:* rba...@googlegroups.com  [mailto:
> rba...@googlegroups.com ] *On Behalf Of *Michael Byerley
> *Sent:* Wednesday, July 15, 2020 10:50 AM
> *To:* RBASE-L
> *Subject:* [RBASE-L] - Re: Running C++ code withe R:Base
>
>  
>
>  
>
> javier,  C, C++, or for that matter, any language capable of creating a 
> Win32 DLL, Most EXPORTED functions are callable within RBase, excluding 
> ones that require integers that are full 32 bit or 64 bit.
>
>  
>
> That was the purpose of DLCall.  When the foreign DLL is introduced into 
> the address space of the RBase session, the EXPORTED functions are just a 
> functional as the native RBase functions.
>
>  
>
>  
>
>  
>
>
>
> On Tuesday, July 14, 2020 at 6:53:59 PM UTC-4, javier.valencia wrote:
>
> *This post is neither an advertisement or endorsement of any product other 
> than R:Base nor an offer or request for work.*
>
>  
>
> I have been working with an application developed by a colleague that 
> performs advance analysis that I want to incorporate into my own R:Base 
> application for a client which could potentially lead to other clients 
> looking for a similar solution.  
>
> The application was written in C++ and accesses a MS Access database. Most 
> of the primary tables in that application are based on/copied from tables 
> in my own application so they have the same table structure
>
> My solution to date is to SConnect to the MS Access database, SAttach the 
> required tables and synchronize data in both databases, run the analysis 
> and then transfer results to the R:Base database. While this approach works 
> relatively well it is probably far from optimal particularly when we scale 
> up to a much larger data set; I would much rather use only the R:Base 
> database and use the existing C++ code to access data and stored results 
> directly and od away with MS Access database altogether.
>
> My questions are: what does it take to make the C++ code access data in 
> the R:Base database? Can I access it directly or do I need to go through 
> Oterro?
>
> The potential client has looked at the various options and his IT 
> department has ruled out using Oterro.
>
> The options at this point are :
>
> 1 - Make the C++ code work with the R:Base database without using Oterro – 
> Preferred
>
> 2 - Rewrite the C++ code in R:Base which would require a large amount of 
> effort since a lot of the constructs in C++ are not readily available in 
> R:Base and vice versa - Probably not practical
>
> 3 - Move the entire application to a different database that is accessible 
> directly from R:Base and from C++ code and use R:Base as a front end for 
> menus, forms and report – I understand others have done this but I have not 
> done it myself so I am not sure on what is involved and how well it works.
>
> 4. Pass on the project and retire once and for all…perhaps the best option?
>
> Having used it for over 35 years, I would prefer to stay within the R:Base 
> environment because I am most familiar with it. Before R:Base I spent 6 
> years writing C code to access databases in the Unix environment, so, while 
> my C programming skills are dated, I can probably come up to speed fairly 
> quickly. Any information or insights you can offer will be greatly 
> appreciated. 
>
>  
>
> Javier,
>
>  
>
> Javier Valencia, PE
>
> 14315 S. Twilight Ln.
>
> Olathe, KS 66062
>

[RBASE-L] - Re: Running C++ code withe R:Base

[Michael Byerley]

javier,  C, C++, or for that matter, any language capable of creating a 
Win32 DLL, Most EXPORTED functions are callable within RBase, excluding 
ones that require integers that are full 32 bit or 64 bit.

That was the purpose of DLCall.  When the foreign DLL is introduced into 
the address space of the RBase session, the EXPORTED functions are just a 
functional as the native RBase functions.





On Tuesday, July 14, 2020 at 6:53:59 PM UTC-4, javier.valencia wrote:
>
> *This post is neither an advertisement or endorsement of any product other 
> than R:Base nor an offer or request for work.*
>
>  
>
> I have been working with an application developed by a colleague that 
> performs advance analysis that I want to incorporate into my own R:Base 
> application for a client which could potentially lead to other clients 
> looking for a similar solution.  
>
> The application was written in C++ and accesses a MS Access database. Most 
> of the primary tables in that application are based on/copied from tables 
> in my own application so they have the same table structure
>
> My solution to date is to SConnect to the MS Access database, SAttach the 
> required tables and synchronize data in both databases, run the analysis 
> and then transfer results to the R:Base database. While this approach works 
> relatively well it is probably far from optimal particularly when we scale 
> up to a much larger data set; I would much rather use only the R:Base 
> database and use the existing C++ code to access data and stored results 
> directly and od away with MS Access database altogether.
>
> My questions are: what does it take to make the C++ code access data in 
> the R:Base database? Can I access it directly or do I need to go through 
> Oterro?
>
> The potential client has looked at the various options and his IT 
> department has ruled out using Oterro.
>
> The options at this point are :
>
> 1 - Make the C++ code work with the R:Base database without using Oterro – 
> Preferred
>
> 2 - Rewrite the C++ code in R:Base which would require a large amount of 
> effort since a lot of the constructs in C++ are not readily available in 
> R:Base and vice versa - Probably not practical
>
> 3 - Move the entire application to a different database that is accessible 
> directly from R:Base and from C++ code and use R:Base as a front end for 
> menus, forms and report – I understand others have done this but I have not 
> done it myself so I am not sure on what is involved and how well it works.
>
> 4. Pass on the project and retire once and for all…perhaps the best option?
>
> Having used it for over 35 years, I would prefer to stay within the R:Base 
> environment because I am most familiar with it. Before R:Base I spent 6 
> years writing C code to access databases in the Unix environment, so, while 
> my C programming skills are dated, I can probably come up to speed fairly 
> quickly. Any information or insights you can offer will be greatly 
> appreciated. 
>
>  
>
> Javier,
>
>  
>
> Javier Valencia, PE
>
> 14315 S. Twilight Ln.
>
> Olathe, KS 66062
>
> Office: 913-829-0888
>
> Cell: 913-915-3137
>
>  
>

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

Re: [RBASE-L] - Forms

[Michael Byerley]

  


On Saturday, July 4, 2020 at 10:57:11 AM UTC-4, Buddy Walker wrote:
>
> Thanks another option forgot about that one 
>
>  
>
> Buddy
>
>  
>
> *From:* rba...@googlegroups.com   > *On Behalf Of *Michael Byerley
> *Sent:* Saturday, July 4, 2020 10:31 AM
> *To:* RBASE-L >
> *Subject:* Re: [RBASE-L] - Forms
>
>  
>
>  
>
> RHIDE
>
>
>
> On Saturday, July 4, 2020 at 10:15:02 AM UTC-4, Buddy Walker wrote:
>
> Karen
>
>   Thanks, I’ll see what I can come up with 
>
>  
>
> Buddy
>
>  
>
>  
>
> *From:* 'Karen Tellef' via RBASE-L  
> *Sent:* Saturday, July 4, 2020 8:52 AM
> *To:* rba...@googlegroups.com
> *Subject:* Re: [RBASE-L] - Forms
>
>  
>
> You should find another way of doing this.  There should never be another 
> action after a "closewindow", other than following it with a "return".  
> Makes sense if you think of it, it wouldn't be able to do the next line of 
> code ("edit using myreportsmenu") if the form had actually closed upon your 
> closewindow command.
>
>  
>
> Karen
>
>  
>
>  
>
>  
>
> -Original Message-
> From: Buddy Walker 
> To: rba...@googlegroups.com
> Sent: Sat, Jul 4, 2020 7:36 am
> Subject: [RBASE-L] - Forms
>
> Maybe I'm missing something but forms are not closing when I use 
> CLOSEWINDOW 
>
>  
>
> This happens on RBase forms and External Forms
>
>  
>
> Windows 10 pro
>
> R:Base XE (current version)
>
>  
>
> I'm using a Speed Button on the forms and on click EEP
>
>  
>
> FORMS 
>
>   myMainMenu or myMainMenu.RFF
>
> form has various speedbuttons and the one I started with is call 
> Reports
>
>   myReportsMenu or myReportsMenu.RFF
>
>  
>
> EDIT USI myMainMenu
>
>   Click on Reports speed button
>
>   OnClick EEP
>
>   CLOSEWINDOW (which I would assume closes myMainMenu form
>
>   EDIT USI myReportsMenu
>
> Everything seems to except myMainMenu stays open behind myReportsMenu 
>
> myReportsMenu is the only one active but you can still see the other forms
>
>  
>
>  
>
> This happens on external form as well
>
> HAPPY 4th and be safe.
>
>  
>
> Buddy
>
>   
>
>  
>
> -- 
>
> 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+unsub...@googlegroups.com.
>
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/rbase-l/000401d651ff%24b848fdf0%2428daf9d0%24%40comcast.net
> .
>
> -- 
> 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 rba...@googlegroups.com.
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/rbase-l/996704197.1934509.1593867097139%40mail.yahoo.com
>  
> <https://groups.google.com/d/msgid/rbase-l/996704197.1934509.1593867097139%40mail.yahoo.com?utm_medium=email_source=footer>
> .
>
> -- 
> For group guidelines, visit 
> http://www.rbase.com/support/usersgroup_guidelines.php
> --- 
> You received this message because you are subscribed to the Google Groups 
> "RBASE-L" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to rba...@googlegroups.com .
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/rbase-l/dc6a1267-0044-4188-bc8a-182aa43b66efo%40googlegroups.com
>  
> <https://groups.google.com/d/msgid/rbase-l/dc6a1267-0044-4188-bc8a-182aa43b66efo%40googlegroups.com?utm_medium=email_source=footer>
> .
>

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

[RBASE-L] - Re: Forms

[Michael Byerley]

OK, so long as myMainMenu has a component ID, just for the example 
"frmMainMenu", then in the onAfter eep of  myReportsMenu you can execute 
Property frmMainMenu VISIBLE 'FALSE'

The myMainMenu and the myReportsMenu both have to be opened MDI and you can 
muck around with the Property frmBlahBlah SET_FOCUS to move between as 
needed, but anyway, in the OnClose event (EEP) of the myReportsMenu, set 
the VISIBLE property back to "TRUE" if you want to return to that form.

I had a running example of this interaction with a timer form, but it is 
more complex than this example, but you can execute code on a second form, 
push buttons, whatever by using this method.

I'm sure you can get it going.


On Saturday, July 4, 2020 at 8:36:21 AM UTC-4, Buddy Walker wrote:
>
> Maybe I'm missing something but forms are not closing when I use 
> CLOSEWINDOW 
>
> This happens on RBase forms and External Forms 
>
>  Windows 10 pro 
>  R:Base XE (current version) 
>
>  I'm using a Speed Button on the forms and on click EEP 
>
>  FORMS 
>   myMainMenu or myMainMenu.RFF 
>  form has various speedbuttons and the one I started with is call 
> Reports 
>   myReportsMenu or myReportsMenu.RFF 
>
>  EDIT USI myMainMenu 
>Click on Reports speed button 
>   OnClick EEP 
>   CLOSEWINDOW (which I would assume closes myMainMenu form 
>   EDIT USI myReportsMenu 
> Everything seems to except myMainMenu stays open behind myReportsMenu 
> myReportsMenu is the only one active but you can still see the other forms 
>
>
> This happens on external form as well 
> HAPPY 4th and be safe. 
>
> Buddy 
>   
>
>

-- 
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/54312c76-9618-4786-bb36-200d4fbddbaeo%40googlegroups.com.

Re: [RBASE-L] - Forms

[Michael Byerley]

RHIDE


On Saturday, July 4, 2020 at 10:15:02 AM UTC-4, Buddy Walker wrote:
>
> Karen
>
>   Thanks, I’ll see what I can come up with 
>
>  
>
> Buddy
>
>  
>
>  
>
> *From:* 'Karen Tellef' via RBASE-L > 
>
> *Sent:* Saturday, July 4, 2020 8:52 AM
> *To:* rba...@googlegroups.com 
> *Subject:* Re: [RBASE-L] - Forms
>
>  
>
> You should find another way of doing this.  There should never be another 
> action after a "closewindow", other than following it with a "return".  
> Makes sense if you think of it, it wouldn't be able to do the next line of 
> code ("edit using myreportsmenu") if the form had actually closed upon your 
> closewindow command.
>
>  
>
> Karen
>
>  
>
>  
>
>  
>
> -Original Message-
> From: Buddy Walker >
> To: rba...@googlegroups.com 
> Sent: Sat, Jul 4, 2020 7:36 am
> Subject: [RBASE-L] - Forms
>
> Maybe I'm missing something but forms are not closing when I use 
> CLOSEWINDOW 
>
>  
>
> This happens on RBase forms and External Forms
>
>  
>
> Windows 10 pro
>
> R:Base XE (current version)
>
>  
>
> I'm using a Speed Button on the forms and on click EEP
>
>  
>
> FORMS 
>
>   myMainMenu or myMainMenu.RFF
>
> form has various speedbuttons and the one I started with is call 
> Reports
>
>   myReportsMenu or myReportsMenu.RFF
>
>  
>
> EDIT USI myMainMenu
>
>   Click on Reports speed button
>
>   OnClick EEP
>
>   CLOSEWINDOW (which I would assume closes myMainMenu form
>
>   EDIT USI myReportsMenu
>
> Everything seems to except myMainMenu stays open behind myReportsMenu 
>
> myReportsMenu is the only one active but you can still see the other forms
>
>  
>
>  
>
> This happens on external form as well
>
> HAPPY 4th and be safe.
>
>  
>
> Buddy
>
>   
>
>  
>
> -- 
>
> 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+unsub...@googlegroups.com. 
>
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/rbase-l/000401d651ff%24b848fdf0%2428daf9d0%24%40comcast.net
> .
>
> -- 
> 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 rba...@googlegroups.com .
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/rbase-l/996704197.1934509.1593867097139%40mail.yahoo.com
>  
> 
> .
>

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

Re: [RBASE-L] - Need help with an Enhanced DB Grid

[Michael Byerley]

  When I use a View for this, it is a TEMPORARY SINGLE TABLE VIEW.

  The sequence is after the initial data is constructed and the Form is 
opened:

  1 If the data is changed then

  PROPERTY TABLE tvwSomeTempView 'CLOSE'
DROP VIEW tvwSomeTempView
CREATE TEMP VIEWtvwSomeTempView AS SELECT WhatEverColumns FROM 
SomeBaseTableForTheVIEW +
WHERE SomeWhereClauseIfAny
PROPERTY TABLE tvwSomeTempView 'OPEN'

  This is All I do.  You could add REFRESH I guess, but I do not.



  

On Thursday, June 25, 2020 at 10:58:42 AM UTC-4, Stuart Hellman wrote:
>
> Karen and Michael,
>
>  
>
> To begin, no Where clauses being used; neither the from working or the one 
> not displaying data.  Tried using a view for the DB grid, but still no data 
> being displayed.
>
>  
>
> Thanks for the suggestions.
>
>  
>
> Stu
>
>  
>
> <https://www.qmiusa.com/>
> Stuart Hellman​
> Software Designer
> Email: *shell...@qmiusa.com* 
>   
> Toll Free: 800‑446‑2500
> International:  01 630‑529‑7111
>   
> Extension:  1029
>   
>   
> *www.qmiusa.com* <https://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:* rba...@googlegroups.com   > *On Behalf Of *Michael Byerley
> *Sent:* Thursday, June 25, 2020 8:22 AM
> *To:* RBASE-L >
> *Subject:* Re: [RBASE-L] - Need help with an Enhanced DB Grid
>
>  
>
>  
>
>   The reason escapes me, but several years back, the single table view 
> became the pathway I used without fail.
>
>
>
> On Wednesday, June 24, 2020 at 1:19:01 PM UTC-4, Karen Tellef wrote:
>
> Just a stab at this.  Does the original "edit using" command have a Where 
> clause on it?  After doing your work on the data, does that Where clause 
> still evaluate correctly?
>
>  
>
> I always do the  PROPERTY TABLE tablename 'REFRESH'  first
>
> 99% of the time that works for me.  When it doesn't then I do the CLOSE 
> followed by the OPEN
>
>  
>
> There shouldn't be any reason for this to happen, but the last thing you 
> can try is constructing a one-table view and basing the grid on that and 
> refreshing it
>
>  
>
> Karen
>
>  
>
>  
>
> -Original Message-
> From: Stuart Hellman 
> To: 'rba...@googlegroups.com' 
> Sent: Wed, Jun 24, 2020 11:47 am
> Subject: [RBASE-L] - Need help with an Enhanced DB Grid
>
> The application is building a Bill of Materials on the fly. Make a 
> selection, delete all rows in the table (in case a previous selection was 
> changed), rebuild the B.O.M., adding new parts. When this is done, display 
> the temp table in a DB Grid.
>
>  
>
> The problem is that the data won’t display. The table is getting built. I 
> can see the control flicker on the form when something is updating the 
> table. I’ve tried different combinations of  table properties, like 
> POST/REFRESH and CLOSE/OPEN, but to no avail. Made a quick and dirty form 
> of just the DB Grid and opening this form, the data displays as soon as it 
> opens. I have another form that displays existing data in a grid with no 
> problems.
>
>  
>
> Would like to know if the setting for the DB grid (took the default 
> options, selected the columns to be displayed) are incorrect  or the 
> refreshing of the table is not being done correctly.
>
>  
>
> Thanks in advance for  your help.
>
>  
>
>  
>
> Stu Hellman
>
>  
>
> [image: Image removed by sender.] <https://www.qmiusa.com/>
>
> *Stuart Hellman**​*
>
> *Software Designer*
>
> Email:
>
> *shell...@qmiusa.com*
>
>  
>
> Toll Free:
>
> 800‑446‑2500
>
> International: 
>
> 01 630‑529‑7111
>
>  
>
> Extension: 
>
> 1029
>
>  
>
>  
>
> *www.qmiusa.com* <https://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 unsub

Re: [RBASE-L] - Need help with an Enhanced DB Grid

[Michael Byerley]

  The reason escapes me, but several years back, the single table view 
became the pathway I used without fail.


On Wednesday, June 24, 2020 at 1:19:01 PM UTC-4, Karen Tellef wrote:
>
> Just a stab at this.  Does the original "edit using" command have a Where 
> clause on it?  After doing your work on the data, does that Where clause 
> still evaluate correctly?
>
> I always do the  PROPERTY TABLE tablename 'REFRESH'  first
> 99% of the time that works for me.  When it doesn't then I do the CLOSE 
> followed by the OPEN
>
> There shouldn't be any reason for this to happen, but the last thing you 
> can try is constructing a one-table view and basing the grid on that and 
> refreshing it
>
> Karen
>
>
> -Original Message-
> From: Stuart Hellman >
> To: 'rba...@googlegroups.com '  >
> Sent: Wed, Jun 24, 2020 11:47 am
> Subject: [RBASE-L] - Need help with an Enhanced DB Grid
>
> The application is building a Bill of Materials on the fly. Make a 
> selection, delete all rows in the table (in case a previous selection was 
> changed), rebuild the B.O.M., adding new parts. When this is done, display 
> the temp table in a DB Grid.
>  
> The problem is that the data won’t display. The table is getting built. I 
> can see the control flicker on the form when something is updating the 
> table. I’ve tried different combinations of  table properties, like 
> POST/REFRESH and CLOSE/OPEN, but to no avail. Made a quick and dirty form 
> of just the DB Grid and opening this form, the data displays as soon as it 
> opens. I have another form that displays existing data in a grid with no 
> problems.
>  
> Would like to know if the setting for the DB grid (took the default 
> options, selected the columns to be displayed) are incorrect  or the 
> refreshing of the table is not being done correctly.
>  
> Thanks in advance for  your help.
>  
>  
> Stu Hellman
>  
>  
> Stuart Hellman​ 
> Software Designer 
> Email: *shell...@qmiusa.com*  
>   
> Toll Free: 800‑446‑2500 
> International:  01 630‑529‑7111 
>   
> Extension:  1029 
>   
>   
> *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 rba...@googlegroups.com .
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/rbase-l/DM5PR16MB183619BDF0D559901FA6C076BB950%40DM5PR16MB1836.namprd16.prod.outlook.com
>  
> 
> .
>

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

[RBASE-L] - Re: Claudine Robbins

[Michael Byerley]

  Thanks for the update  Karen.  Sad to hear of course.  I think most folks 
here knew she was fending off cancer for some time now.

  

On Tuesday, June 16, 2020 at 10:56:14 AM UTC-4, Karen Tellef wrote:
>
> Sadly I am informing you all that Claudine Robbins has passed away.  She 
> had been ill for quite a while, and passed away quietly under hospice care 
> a few days ago in Texas.  Her daughter and son are now carrying on her 
> business.  Of course I was lucky enough to meet her a few times at 
> conferences, one of the few other female programmers in the early days so 
> we had a bit in common.  I always thought of her as being 'Texan' through 
> and through.
>
> Karen
>
>

-- 
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/254bb95d-fd86-4b2e-ba93-769bcab29599o%40googlegroups.com.

Re: Re[2]: [RBASE-L] - Re: Line Feed/Carriage Returns in Report BLOB Fields

[Michael Byerley]

wait till you're my age.  At least everyone expects it now.


On Sunday, June 7, 2020 at 10:57:26 AM UTC-4, rbytes wrote:
>
> my capacity for self-embarrassment is bottomless ...
> B
>
> -- Original Message --
> From: "Michael Byerley" >
> To: "RBASE-L" >
> Sent: 6/7/2020 6:02:12 AM
> Subject: Re: [RBASE-L] - Re: Line Feed/Carriage Returns in Report BLOB 
> Fields
>
>
>
>   Bruce, actually the standard is CR first then LF.  :)
>
>
> On Saturday, June 6, 2020 at 4:35:01 PM UTC-4, rbytes wrote:
>>
>> Michael & Karen:
>>
>> Thank you very much. I ran a SRPL update of the existing line end 
>> characters with ( char(010) + char(013) ), which solved the immediate issue.
>>
>> I will be experimenting with the '^' substitution this weekend and will 
>> advise.
>>
>> Much appreciated, Bruce
>>
>> Bruce A. Chitiea
>> SafeSectors, Inc.
>> 112 Harvard Ave #272
>> Claremont CA 91711-4716
>> *rby...@safesectors.com*
>> +011 (909) 238-9012 c
>> +011 (909) 912-8678 f
>>
>>
>> -- Original Message --
>> From: "Michael Byerley" 
>> To: "RBASE-L" 
>> Sent: 6/5/2020 6:52:25 AM
>> Subject: [RBASE-L] - Re: Line Feed/Carriage Returns in Report BLOB Fields
>>
>>
>>
>>   Well from the Helpfile: 
>>
>> Special Character
>>
>>  
>>
>> Syntax: SET LINEEND = value 
>>
>>  
>>
>> DOS Default: þ [Alt]+[0254]
>>
>>  
>>
>> Windows Default: ^  
>>
>>  For all text that I want to display on multiple lines I use 0D0A.  
>>
>> At the beginning of each session I: SET VAR vCRLF = ((char(013)) + 
>> (Char(010)))
>>
>> That is used everywhere in my data.
>>
>> So SETTINGS>CONFIGURATION SETTINGS>LINEEND and see which character is 
>> there.  Maybe you have a DOS holdover, which if so, a simple change to a 
>> carat might give you some relief.
>>
>>
>> On Thursday, June 4, 2020 at 9:14:54 PM UTC-4, rbytes wrote:
>>>
>>> Question:
>>>
>>> This is representative of the text formatting entered into, and visible 
>>> in a field of file type NOTE or VARCHAR within the BLOB Editor:
>>>
>>> SET SCREWS
>>> |1/4-20 x 3/8in
>>> |Qty 3 per set
>>>
>>> In BROWSE MODE, or in a Report, the data appears formatted as:
>>>
>>> SET SCREWS*þ*|1/4-20 x 3/8in*þ*|Qty 3 per set
>>>
>>> ...  where (*þ = 0AFE*).
>>>
>>> What codes need I enter at the end of each text line such that a [line 
>>> feed|carriage return] formats the text correctly within a report printout?
>>>
>>> Thanks much, Bruce
>>>
>>> Bruce A. Chitiea
>>> SafeSectors, Inc.
>>> 112 Harvard Ave #272
>>> Claremont CA 91711-4716
>>> *rby...@safesectors.com*
>>> +011 (909) 238-9012 c
>>> +011 (909) 912-8678 f
>>>
>>> -- 
>> 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 rba...@googlegroups.com.
>> To view this discussion on the web visit 
>> https://groups.google.com/d/msgid/rbase-l/77dfb6a2-1433-4a79-b18c-607f40b7e0f1o%40googlegroups.com
>>  
>> <https://groups.google.com/d/msgid/rbase-l/77dfb6a2-1433-4a79-b18c-607f40b7e0f1o%40googlegroups.com?utm_medium=email_source=footer>
>> .
>>
>> -- 
> For group guidelines, visit 
> http://www.rbase.com/support/usersgroup_guidelines.php
> --- 
> You received this message because you are subscribed to the Google Groups 
> "RBASE-L" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to rba...@googlegroups.com .
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/rbase-l/e5527f28-9e81-47fb-884d-9d72d3f0074eo%40googlegroups.com
>  
> <https://groups.google.com/d/msgid/rbase-l/e5527f28-9e81-47fb-884d-9d72d3f0074eo%40googlegroups.com?utm_medium=email_source=footer>
> .
>
>

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

Re: [RBASE-L] - Re: Line Feed/Carriage Returns in Report BLOB Fields

[Michael Byerley]

  Bruce, actually the standard is CR first then LF.  :)


On Saturday, June 6, 2020 at 4:35:01 PM UTC-4, rbytes wrote:
>
> Michael & Karen:
>
> Thank you very much. I ran a SRPL update of the existing line end 
> characters with ( char(010) + char(013) ), which solved the immediate issue.
>
> I will be experimenting with the '^' substitution this weekend and will 
> advise.
>
> Much appreciated, Bruce
>
> Bruce A. Chitiea
> SafeSectors, Inc.
> 112 Harvard Ave #272
> Claremont CA 91711-4716
> *rby...@safesectors.com *
> +011 (909) 238-9012 c
> +011 (909) 912-8678 f
>
>
> -- Original Message --
> From: "Michael Byerley" >
> To: "RBASE-L" >
> Sent: 6/5/2020 6:52:25 AM
> Subject: [RBASE-L] - Re: Line Feed/Carriage Returns in Report BLOB Fields
>
>
>
>   Well from the Helpfile: 
>
> Special Character
>
>  
>
> Syntax: SET LINEEND = value 
>
>  
>
> DOS Default: þ [Alt]+[0254]
>
>  
>
> Windows Default: ^  
>
>  For all text that I want to display on multiple lines I use 0D0A.  
>
> At the beginning of each session I: SET VAR vCRLF = ((char(013)) + 
> (Char(010)))
>
> That is used everywhere in my data.
>
> So SETTINGS>CONFIGURATION SETTINGS>LINEEND and see which character is 
> there.  Maybe you have a DOS holdover, which if so, a simple change to a 
> carat might give you some relief.
>
>
> On Thursday, June 4, 2020 at 9:14:54 PM UTC-4, rbytes wrote:
>>
>> Question:
>>
>> This is representative of the text formatting entered into, and visible 
>> in a field of file type NOTE or VARCHAR within the BLOB Editor:
>>
>> SET SCREWS
>> |1/4-20 x 3/8in
>> |Qty 3 per set
>>
>> In BROWSE MODE, or in a Report, the data appears formatted as:
>>
>> SET SCREWS*þ*|1/4-20 x 3/8in*þ*|Qty 3 per set
>>
>> ...  where (*þ = 0AFE*).
>>
>> What codes need I enter at the end of each text line such that a [line 
>> feed|carriage return] formats the text correctly within a report printout?
>>
>> Thanks much, Bruce
>>
>> Bruce A. Chitiea
>> SafeSectors, Inc.
>> 112 Harvard Ave #272
>> Claremont CA 91711-4716
>> *rby...@safesectors.com*
>> +011 (909) 238-9012 c
>> +011 (909) 912-8678 f
>>
>> -- 
> 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 rba...@googlegroups.com .
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/rbase-l/77dfb6a2-1433-4a79-b18c-607f40b7e0f1o%40googlegroups.com
>  
> <https://groups.google.com/d/msgid/rbase-l/77dfb6a2-1433-4a79-b18c-607f40b7e0f1o%40googlegroups.com?utm_medium=email_source=footer>
> .
>
>

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

[RBASE-L] - Re: Line Feed/Carriage Returns in Report BLOB Fields

[Michael Byerley]

  Well from the Helpfile: 

Special Character

 

Syntax: SET LINEEND = value 

 

DOS Default: þ [Alt]+[0254]

 

Windows Default: ^  

 For all text that I want to display on multiple lines I use 0D0A.  

At the beginning of each session I: SET VAR vCRLF = ((char(013)) + 
(Char(010)))

That is used everywhere in my data.

So SETTINGS>CONFIGURATION SETTINGS>LINEEND and see which character is 
there.  Maybe you have a DOS holdover, which if so, a simple change to a 
carat might give you some relief.


On Thursday, June 4, 2020 at 9:14:54 PM UTC-4, rbytes wrote:
>
> Question:
>
> This is representative of the text formatting entered into, and visible in 
> a field of file type NOTE or VARCHAR within the BLOB Editor:
>
> SET SCREWS
> |1/4-20 x 3/8in
> |Qty 3 per set
>
> In BROWSE MODE, or in a Report, the data appears formatted as:
>
> SET SCREWS*þ*|1/4-20 x 3/8in*þ*|Qty 3 per set
>
> ...  where (*þ = 0AFE*).
>
> What codes need I enter at the end of each text line such that a [line 
> feed|carriage return] formats the text correctly within a report printout?
>
> Thanks much, Bruce
>
> Bruce A. Chitiea
> SafeSectors, Inc.
> 112 Harvard Ave #272
> Claremont CA 91711-4716
> *rby...@safesectors.com *
> +011 (909) 238-9012 c
> +011 (909) 912-8678 f
>
>

-- 
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/77dfb6a2-1433-4a79-b18c-607f40b7e0f1o%40googlegroups.com.

Re: [RBASE-L] - Re: Varchar

[Michael Byerley]

Glad I could help.


On Wednesday, May 27, 2020 at 10:11:24 AM UTC-4, jmmasse wrote:
>
> Bonjour Mike,
>
>  
>
> Vraiment tous mes remerciements pour votre aide très précieuse, c’est 
> super cela fonctionne !
>
>  
>
> Bien Amicalement
>
>  
>
> Traduction Google :
>
>  
>
> Hello Mike,
>
>  
>
> Really all my thanks for your very precious help, it's great it works!
>
>  
>
> Sincerely
>
>  
>
> JM
>
>  
>
> *De :* rba...@googlegroups.com  [mailto:
> rba...@googlegroups.com ] *De la part de* Michael Byerley
> *Envoyé :* mardi 26 mai 2020 21:22
> *À :* RBASE-L
> *Objet :* [RBASE-L] - Re: Varchar
>
>  
>
>
>   Sorry. Copy and Paste error on my part.  The math would've been wrong on 
> the amount of data extracted from the OBSTECH table.  
>
> On Wednesday, May 20, 2020 at 2:21:09 AM UTC-4, jmmasse wrote:
>
>  
>
> Bonjour à tous,
>
>  
>
> Utilisateur de Rbase depuis de très nombreuses années, je suis avec 
> beaucoup d’attention tout ce qui se dit sur le forum.
>
> John MINYO m’a inscrit récemment et je voudrais formuler une demande 
> concernant un champ  « VARCHAR ».
>
> Dans une table j’ai un champ Historique de type « VARCHAR » qui concerne 
> des opérations de maintenance.
>
> Je voudrais enrichir cet historique en y rajoutant des données elles aussi 
> de type « VARCHAR » issues d’une autre table
>
> qui recense des opérations ponctuelles de façon à obtenir un historique 
> complet.
>
> Je me heurte à un message d’erreur qui m’indique que cela n’est pas 
> possible !
>
> Auriez-vous une approche qui me permette d’obtenir ce résultat ?
>
>  
>
>  
>
> Good morning all,
>
>  
>
> As a Rbase user for many years, I follow with great attention everything 
> that is said on the forum.
>
> John MINYO signed me up recently and I would like to make a request 
> regarding a « VARCHAR » field.
>
> In a table I have a History field of type "VARCHAR" which relates to 
> maintenance operations.
>
> I would like to enrich this history by adding data also of type "VARCHAR" 
> from another table
>
> which identifies specific operations in order to obtain a complete history.
>
> I run into an error message which tells me that this is not possible!
>
> Do you have an approach that allows me to achieve this result?
>
>  
>
> Regards,
>
>  
> --
>
> *Jean-Marc Massé *(mobile : 06.08.82.80.86)
>
> Directeur
>
> Sté MCS 
>
>  19, rue de la Mine
>
> 85510 ROCHETREJOUX (France)
> --
>
>  
>
>  
>
>  
>
> -- 
> 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 rba...@googlegroups.com .
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/rbase-l/763b5109-1693-4e65-9986-760f9fdab9d7%40googlegroups.com
>  
> <https://groups.google.com/d/msgid/rbase-l/763b5109-1693-4e65-9986-760f9fdab9d7%40googlegroups.com?utm_medium=email_source=footer>
> .
>

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

[RBASE-L] - Re: Varchar

[Michael Byerley]

Also, From the R> or from the Explorer menu, open the LANCQUEST table and 
double click on the OBSDET column.  This will open the data in the RBase 
BLOB Editor(which is slightly different from the one displayed when you 
double click varchar data in a form).  

If you would please Toggle between the TEXT tab and the RICH TEXT tab at 
the top, you will see the data, both with and without the formatting codes.

All those strange characters you were seeing was as the result of my error 
causing some of the formatting codes to display in the form, which with the 
correction I sent you should be OK now.

All that is required to make Rich Text is to be certain that a FILE has a 
minimum number of components to make it a file.  This would be the HEADER, 
DOCUMENT and that these are described correctly, with the appropriate 
balanced curly braces, which is what I accomplished in the example I sent, 
which was based on the data you provided.  If you create RTF from another 
source other than RBase, then I cannot guarantee the same results, but so 
long as you are working within RBase, everything should be OK.

On Wednesday, May 20, 2020 at 2:21:09 AM UTC-4, jmmasse wrote:
>
>  
>
> Bonjour à tous,
>
>  
>
> Utilisateur de Rbase depuis de très nombreuses années, je suis avec 
> beaucoup d’attention tout ce qui se dit sur le forum.
>
> John MINYO m’a inscrit récemment et je voudrais formuler une demande 
> concernant un champ  « VARCHAR ».
>
> Dans une table j’ai un champ Historique de type « VARCHAR » qui concerne 
> des opérations de maintenance.
>
> Je voudrais enrichir cet historique en y rajoutant des données elles aussi 
> de type « VARCHAR » issues d’une autre table
>
> qui recense des opérations ponctuelles de façon à obtenir un historique 
> complet.
>
> Je me heurte à un message d’erreur qui m’indique que cela n’est pas 
> possible !
>
> Auriez-vous une approche qui me permette d’obtenir ce résultat ?
>
>  
>
>  
>
> Good morning all,
>
>  
>
> As a Rbase user for many years, I follow with great attention everything 
> that is said on the forum.
>
> John MINYO signed me up recently and I would like to make a request 
> regarding a « VARCHAR » field.
>
> In a table I have a History field of type "VARCHAR" which relates to 
> maintenance operations.
>
> I would like to enrich this history by adding data also of type "VARCHAR" 
> from another table
>
> which identifies specific operations in order to obtain a complete history.
>
> I run into an error message which tells me that this is not possible!
>
> Do you have an approach that allows me to achieve this result?
>
>  
>
> Regards,
>
>  
> --
>
> *Jean-Marc Massé *(mobile : 06.08.82.80.86)
>
> Directeur
>
> Sté MCS 
>
>  19, rue de la Mine
>
> 85510 ROCHETREJOUX (France)
> --
>
>  
>
>  
>
>  
>

-- 
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/2133e649-d3e5-48b0-a1ac-74e1e9ed89b1%40googlegroups.com.

[RBASE-L] - Re: Varchar

[Michael Byerley]

  Sorry. Copy and Paste error on my part.  The math would've been wrong on 
the amount of data extracted from the OBSTECH table.  

On Wednesday, May 20, 2020 at 2:21:09 AM UTC-4, jmmasse wrote:
>
>  
>
> Bonjour à tous,
>
>  
>
> Utilisateur de Rbase depuis de très nombreuses années, je suis avec 
> beaucoup d’attention tout ce qui se dit sur le forum.
>
> John MINYO m’a inscrit récemment et je voudrais formuler une demande 
> concernant un champ  « VARCHAR ».
>
> Dans une table j’ai un champ Historique de type « VARCHAR » qui concerne 
> des opérations de maintenance.
>
> Je voudrais enrichir cet historique en y rajoutant des données elles aussi 
> de type « VARCHAR » issues d’une autre table
>
> qui recense des opérations ponctuelles de façon à obtenir un historique 
> complet.
>
> Je me heurte à un message d’erreur qui m’indique que cela n’est pas 
> possible !
>
> Auriez-vous une approche qui me permette d’obtenir ce résultat ?
>
>  
>
>  
>
> Good morning all,
>
>  
>
> As a Rbase user for many years, I follow with great attention everything 
> that is said on the forum.
>
> John MINYO signed me up recently and I would like to make a request 
> regarding a « VARCHAR » field.
>
> In a table I have a History field of type "VARCHAR" which relates to 
> maintenance operations.
>
> I would like to enrich this history by adding data also of type "VARCHAR" 
> from another table
>
> which identifies specific operations in order to obtain a complete history.
>
> I run into an error message which tells me that this is not possible!
>
> Do you have an approach that allows me to achieve this result?
>
>  
>
> Regards,
>
>  
> --
>
> *Jean-Marc Massé *(mobile : 06.08.82.80.86)
>
> Directeur
>
> Sté MCS 
>
>  19, rue de la Mine
>
> 85510 ROCHETREJOUX (France)
> --
>
>  
>
>  
>
>  
>

-- 
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/763b5109-1693-4e65-9986-760f9fdab9d7%40googlegroups.com.
<>

[RBASE-L] - Re: Varchar

[Michael Byerley]

Also, the example that I sent did use a CURSOR but as you likely have 
deduced that if it is ONLY a single update, you can use parts of the code 
to simply employ SELECT to populate your variables.


On Wednesday, May 20, 2020 at 2:21:09 AM UTC-4, jmmasse wrote:
>
>  
>
> Bonjour à tous,
>
>  
>
> Utilisateur de Rbase depuis de très nombreuses années, je suis avec 
> beaucoup d’attention tout ce qui se dit sur le forum.
>
> John MINYO m’a inscrit récemment et je voudrais formuler une demande 
> concernant un champ  « VARCHAR ».
>
> Dans une table j’ai un champ Historique de type « VARCHAR » qui concerne 
> des opérations de maintenance.
>
> Je voudrais enrichir cet historique en y rajoutant des données elles aussi 
> de type « VARCHAR » issues d’une autre table
>
> qui recense des opérations ponctuelles de façon à obtenir un historique 
> complet.
>
> Je me heurte à un message d’erreur qui m’indique que cela n’est pas 
> possible !
>
> Auriez-vous une approche qui me permette d’obtenir ce résultat ?
>
>  
>
>  
>
> Good morning all,
>
>  
>
> As a Rbase user for many years, I follow with great attention everything 
> that is said on the forum.
>
> John MINYO signed me up recently and I would like to make a request 
> regarding a « VARCHAR » field.
>
> In a table I have a History field of type "VARCHAR" which relates to 
> maintenance operations.
>
> I would like to enrich this history by adding data also of type "VARCHAR" 
> from another table
>
> which identifies specific operations in order to obtain a complete history.
>
> I run into an error message which tells me that this is not possible!
>
> Do you have an approach that allows me to achieve this result?
>
>  
>
> Regards,
>
>  
> --
>
> *Jean-Marc Massé *(mobile : 06.08.82.80.86)
>
> Directeur
>
> Sté MCS 
>
>  19, rue de la Mine
>
> 85510 ROCHETREJOUX (France)
> --
>
>  
>
>  
>
>  
>

-- 
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/27046a7e-0ec5-4474-892c-fca36bd48b84%40googlegroups.com.

[RBASE-L] - Re: Varchar

[Michael Byerley]

  Well RTF is NOT TEXT.  The problem you are having is combining (or trying 
to) TWO complete RTF files together, which you cannot do.  Every RTF file 
has its' own HEADER, BODY, etc, so when you try to combine the TEXTUAL 
DESCRIPTION of the two files, you get an embedded HEADER from the second 
file, which will not show up correctly.

I have written something here which is working based on the data you 
provided, and which I also deduced was data that has been created within 
the RBase environment as there are a couple things in the HEADER that I 
don't see in something you might create in WORD or some other 
wordprocesser.  That is no concern as long as you continue to do it the way 
you currently do.

If you change to combining something from an extraneous source, then you 
will have to modify the program to fit the new or different parameters.

Also in the zip file is a link to a web page that shows you the file 
structure of RTF 1.0 to RTF 1.5.

Hope this helps.
Mike


On Wednesday, May 20, 2020 at 2:21:09 AM UTC-4, jmmasse wrote:
>
>  
>
> Bonjour à tous,
>
>  
>
> Utilisateur de Rbase depuis de très nombreuses années, je suis avec 
> beaucoup d’attention tout ce qui se dit sur le forum.
>
> John MINYO m’a inscrit récemment et je voudrais formuler une demande 
> concernant un champ  « VARCHAR ».
>
> Dans une table j’ai un champ Historique de type « VARCHAR » qui concerne 
> des opérations de maintenance.
>
> Je voudrais enrichir cet historique en y rajoutant des données elles aussi 
> de type « VARCHAR » issues d’une autre table
>
> qui recense des opérations ponctuelles de façon à obtenir un historique 
> complet.
>
> Je me heurte à un message d’erreur qui m’indique que cela n’est pas 
> possible !
>
> Auriez-vous une approche qui me permette d’obtenir ce résultat ?
>
>  
>
>  
>
> Good morning all,
>
>  
>
> As a Rbase user for many years, I follow with great attention everything 
> that is said on the forum.
>
> John MINYO signed me up recently and I would like to make a request 
> regarding a « VARCHAR » field.
>
> In a table I have a History field of type "VARCHAR" which relates to 
> maintenance operations.
>
> I would like to enrich this history by adding data also of type "VARCHAR" 
> from another table
>
> which identifies specific operations in order to obtain a complete history.
>
> I run into an error message which tells me that this is not possible!
>
> Do you have an approach that allows me to achieve this result?
>
>  
>
> Regards,
>
>  
> --
>
> *Jean-Marc Massé *(mobile : 06.08.82.80.86)
>
> Directeur
>
> Sté MCS 
>
>  19, rue de la Mine
>
> 85510 ROCHETREJOUX (France)
> --
>
>  
>
>  
>
>  
>

-- 
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/9dd14a9c-4c74-494e-b615-fbc680d81f38%40googlegroups.com.
<>

Re: [RBASE-L] - Re: Varchar

[Michael Byerley]

I cannot see all that you have done, but the following works for me.

*( Begin TEST CODE)

SET VAR vIdx INTEGER
SET VAR vc1 VARCHAR
SET VAR vc2 VARCHAR
SET VAR vc3 VARCHAR
SET VAR votherdata VARCHAR
-- I always use a variable to hold CARRIABE RETURN + NEW LINE instead of 
Literal character when combining text.
SET VAR vCrLf TEXT = ((CHAR(031)) + (CHAR(010)))

DROP CUR c1

DECLARE c1 CURSOR FOR SELECT idx, colvc1 colvc2 FROM testvarchar +
WHERE idx = 2

OPEN c1
FETCH c1 INTO vIdx IND vIn0, vc1 IND vIn0, vc2 IND vIn0
SELECT cmddata INTO votherdata IND vIn0 FROM testcontvc WHERE cmdname = 
'Startup'

WHILE SQLCODE = 0 THEN

  SET VAR vc3 = (.vc1 + .vcrlf + .vc2 + .vcrlf + .votherdata )
  UPDATE testvarchar SET colvc1 = .vc3 WHERE CURRENT OF c1
  --UPDATE testvarchar SET colvc1 = NULL WHERE CURRENT OF c1
  FETCH c1 INTO vIdx IND vIn0, vc1 IND vIn0, vc2 IND vIn0

ENDWHILE
DROP CUR c1

RETURN
*(End Test Code)

*( Explanation )
*( Table TestContVC contains VarChar Column containing value:
Startup
startup
SELECT

 Table TestVarChar has 4 columns:
  IDX Integer, ColVC1 VarChar, ColVC2 VarChar, ColVC3 VarChar

 Cursor row IDX = 2
  ColVC1 = Jean-Marc Massé
  ColVC2 = 85510 ROCHETREJOUX
  ColVC3 = null

  *It is IMPORTANT to declare ALL variables used BEFORE use in code.  DO NOT
  rely on RBASE to do type conversion for you for greatest reliability.

  )

On Friday, May 22, 2020 at 4:46:30 AM UTC-4, jmmasse wrote:
>
> Merci Michael pour tous ces conseils, mais c’est la variable combinée qui 
> ne marche pas !
>
>  
>
> SET VAR VNEWOBSTECH VARCHAR = (.VOBSTECH1+"þ"+.VDETREP)
>
>  
>
> Elle ne produit aucun résultat, auriez-vous une idée ?
>
>  
>
>  
>
> Thanks Michael for all of this advice, but it's the combined variable that 
> doesn't work!
>
>  
>
> SET VAR VNEWOBSTECH VARCHAR = (.VOBSTECH1 + "þ" +. VDETREP)
>
>  
>
> It produces no results, do you have an idea?
>
>  
>
>  
>
>  
>
> Cordialement,
>
>  
>
> JM
>
>  
>
> *De :* rba...@googlegroups.com  [mailto:
> rba...@googlegroups.com ] *De la part de* Michael Byerley
> *Envoyé :* jeudi 21 mai 2020 15:37
> *À :* RBASE-L
> *Objet :* [RBASE-L] - Re: Varchar
>
>  
>
>
> OK, Excepting that your statement would work, but not consistent with 
> current structure:
>
>  
>
> SET VAR VDETREP VARCHAR = DETREP IN LANCQUEST WHERE NUMQUEST = .VNUMQUEST
>
>  
>
> Would be best restated as a SELECT clause like;
>
>  
>
> Set var vDetRep VarChar = null
>
>  
>
> Select DetRep into vDetRep ind Vin0 from LancQuest where NumQuest = 
> .vNumQuest
>
>  
>
> Using Select gives the opportunity throughout your system, of additional 
> checks for null when required, by checking the INDICATOR variable value.
>
>  
>
>  
>
> On Wednesday, May 20, 2020 at 2:21:09 AM UTC-4, jmmasse wrote:
>
>  
>
> Bonjour à tous,
>
>  
>
> Utilisateur de Rbase depuis de très nombreuses années, je suis avec 
> beaucoup d’attention tout ce qui se dit sur le forum.
>
> John MINYO m’a inscrit récemment et je voudrais formuler une demande 
> concernant un champ  « VARCHAR ».
>
> Dans une table j’ai un champ Historique de type « VARCHAR » qui concerne 
> des opérations de maintenance.
>
> Je voudrais enrichir cet historique en y rajoutant des données elles aussi 
> de type « VARCHAR » issues d’une autre table
>
> qui recense des opérations ponctuelles de façon à obtenir un historique 
> complet.
>
> Je me heurte à un message d’erreur qui m’indique que cela n’est pas 
> possible !
>
> Auriez-vous une approche qui me permette d’obtenir ce résultat ?
>
>  
>
>  
>
> Good morning all,
>
>  
>
> As a Rbase user for many years, I follow with great attention everything 
> that is said on the forum.
>
> John MINYO signed me up recently and I would like to make a request 
> regarding a « VARCHAR » field.
>
> In a table I have a History field of type "VARCHAR" which relates to 
> maintenance operations.
>
> I would like to enrich this history by adding data also of type "VARCHAR" 
> from another table
>
> which identifies specific operations in order to obtain a complete history.
>
> I run into an error message which tells me that this is not possible!
>
> Do you have an approach that allows me to achieve this result?
>
>  
>
> Regards,
>
>  
> --
>
> *Jean-Marc Massé *(mobile : 06.08.82.80.86)
>
> Directeur
>
> Sté MCS 
>
>  19, rue de la Mine
>
> 85510 ROCHETREJOUX (France)
> --
>
>  
>
>  
>
>  
>
> -- 
> For group guidelines, visit 
> http://www.

[RBASE-L] - Re: Varchar

[Michael Byerley]

On Wednesday, May 20, 2020 at 2:21:09 AM UTC-4, jmmasse wrote:
>
>  
>
> Bonjour à tous,
>
>  
>
> Utilisateur de Rbase depuis de très nombreuses années, je suis avec 
> beaucoup d’attention tout ce qui se dit sur le forum.
>
> John MINYO m’a inscrit récemment et je voudrais formuler une demande 
> concernant un champ  « VARCHAR ».
>
> Dans une table j’ai un champ Historique de type « VARCHAR » qui concerne 
> des opérations de maintenance.
>
> Je voudrais enrichir cet historique en y rajoutant des données elles aussi 
> de type « VARCHAR » issues d’une autre table
>
> qui recense des opérations ponctuelles de façon à obtenir un historique 
> complet.
>
> Je me heurte à un message d’erreur qui m’indique que cela n’est pas 
> possible !
>
> Auriez-vous une approche qui me permette d’obtenir ce résultat ?
>
>  
>
>  
>
> Good morning all,
>
>  
>
> As a Rbase user for many years, I follow with great attention everything 
> that is said on the forum.
>
> John MINYO signed me up recently and I would like to make a request 
> regarding a « VARCHAR » field.
>
> In a table I have a History field of type "VARCHAR" which relates to 
> maintenance operations.
>
> I would like to enrich this history by adding data also of type "VARCHAR" 
> from another table
>
> which identifies specific operations in order to obtain a complete history.
>
> I run into an error message which tells me that this is not possible!
>
> Do you have an approach that allows me to achieve this result?
>
>  
>
> Regards,
>
>  
> --
>
> *Jean-Marc Massé *(mobile : 06.08.82.80.86)
>
> Directeur
>
> Sté MCS 
>
>  19, rue de la Mine
>
> 85510 ROCHETREJOUX (France)
> --
>
>  
>
>  
>
>  
>

-- 
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/f32a351c-fa9b-4cae-a672-1f11eaebd713%40googlegroups.com.

[RBASE-L] - Re: Varchar

[Michael Byerley]

OK, Excepting that your statement would work, but not consistent with 
current structure:

SET VAR VDETREP VARCHAR = DETREP IN LANCQUEST WHERE NUMQUEST = .VNUMQUEST

Would be best restated as a SELECT clause like;

Set var vDetRep VarChar = null

Select DetRep into vDetRep ind Vin0 from LancQuest where NumQuest = 
.vNumQuest

Using Select gives the opportunity throughout your system, of additional 
checks for null when required, by checking the INDICATOR variable value.


On Wednesday, May 20, 2020 at 2:21:09 AM UTC-4, jmmasse wrote:
>
>  
>
> Bonjour à tous,
>
>  
>
> Utilisateur de Rbase depuis de très nombreuses années, je suis avec 
> beaucoup d’attention tout ce qui se dit sur le forum.
>
> John MINYO m’a inscrit récemment et je voudrais formuler une demande 
> concernant un champ  « VARCHAR ».
>
> Dans une table j’ai un champ Historique de type « VARCHAR » qui concerne 
> des opérations de maintenance.
>
> Je voudrais enrichir cet historique en y rajoutant des données elles aussi 
> de type « VARCHAR » issues d’une autre table
>
> qui recense des opérations ponctuelles de façon à obtenir un historique 
> complet.
>
> Je me heurte à un message d’erreur qui m’indique que cela n’est pas 
> possible !
>
> Auriez-vous une approche qui me permette d’obtenir ce résultat ?
>
>  
>
>  
>
> Good morning all,
>
>  
>
> As a Rbase user for many years, I follow with great attention everything 
> that is said on the forum.
>
> John MINYO signed me up recently and I would like to make a request 
> regarding a « VARCHAR » field.
>
> In a table I have a History field of type "VARCHAR" which relates to 
> maintenance operations.
>
> I would like to enrich this history by adding data also of type "VARCHAR" 
> from another table
>
> which identifies specific operations in order to obtain a complete history.
>
> I run into an error message which tells me that this is not possible!
>
> Do you have an approach that allows me to achieve this result?
>
>  
>
> Regards,
>
>  
> --
>
> *Jean-Marc Massé *(mobile : 06.08.82.80.86)
>
> Directeur
>
> Sté MCS 
>
>  19, rue de la Mine
>
> 85510 ROCHETREJOUX (France)
> --
>
>  
>
>  
>
>  
>

-- 
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/f60916cb-fb6e-4683-90b5-e5b411fc4b25%40googlegroups.com.

[RBASE-L] - Re: Varchar

[Michael Byerley]

 You can't grammatically add to a varchar data, but you can select the the 
value from the primary table into a variable, then select the value to be 
added into another variable, combine the two variables, then update the 
primary table with the combined data.

So, if you had more than one instance of this to perform, you would have to 
do it using a CURSOR, as an UPDATE using a SELECT combining two sources 
will not work.
 

On Wednesday, May 20, 2020 at 2:21:09 AM UTC-4, jmmasse wrote:
>
>  
>
> Bonjour à tous,
>
>  
>
> Utilisateur de Rbase depuis de très nombreuses années, je suis avec 
> beaucoup d’attention tout ce qui se dit sur le forum.
>
> John MINYO m’a inscrit récemment et je voudrais formuler une demande 
> concernant un champ  « VARCHAR ».
>
> Dans une table j’ai un champ Historique de type « VARCHAR » qui concerne 
> des opérations de maintenance.
>
> Je voudrais enrichir cet historique en y rajoutant des données elles aussi 
> de type « VARCHAR » issues d’une autre table
>
> qui recense des opérations ponctuelles de façon à obtenir un historique 
> complet.
>
> Je me heurte à un message d’erreur qui m’indique que cela n’est pas 
> possible !
>
> Auriez-vous une approche qui me permette d’obtenir ce résultat ?
>
>  
>
>  
>
> Good morning all,
>
>  
>
> As a Rbase user for many years, I follow with great attention everything 
> that is said on the forum.
>
> John MINYO signed me up recently and I would like to make a request 
> regarding a « VARCHAR » field.
>
> In a table I have a History field of type "VARCHAR" which relates to 
> maintenance operations.
>
> I would like to enrich this history by adding data also of type "VARCHAR" 
> from another table
>
> which identifies specific operations in order to obtain a complete history.
>
> I run into an error message which tells me that this is not possible!
>
> Do you have an approach that allows me to achieve this result?
>
>  
>
> Regards,
>
>  
> --
>
> *Jean-Marc Massé *(mobile : 06.08.82.80.86)
>
> Directeur
>
> Sté MCS 
>
>  19, rue de la Mine
>
> 85510 ROCHETREJOUX (France)
> --
>
>  
>
>  
>
>  
>

-- 
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/5b6527b5-5cb0-46ef-bc4d-525e9f03fe1d%40googlegroups.com.

[RBASE-L] - Re: Bill Eyring

[Michael Byerley]

  I only knew Bill from the RBase Conferences, but from the many kind words 
expressed by others here, I am certain his family would be pleased to know 
that Bill's mortality did not end with his passing, but lives on in the 
memories of his R:Base friends and acquaintances that were occasioned by 
him over these many years.

  

On Saturday, May 9, 2020 at 11:31:24 AM UTC-4, Doug Hamilton wrote:
>
> R:Base List - A few years ago you may remember that I was looking for an 
> R:Base developer to help with a large project.  Several of you 
> responded, for which I am grateful.  We (client and I) chose to have 
> Bill Eyring help develop our new order processing database. Our division 
> of labor just sort of fell into place - Bill in New York handled 
> receiving and sending the data via EDI and the shipping end of the order 
> processing.  From Wisconsin, I did the front end processing of the data, 
> order preparation and building the output files. 
>
> Over the course of many phone calls, Bill and I commiserated in our 
> frustrations, rejoiced in our progress, solved world problems and 
> ultimately developed a working system.  A large part of the success is 
> due to our client's guidance and patience. 
>
> With great sadness, I'm writing on behalf of Bill's wife JoAnn to say 
> Bill passed away several weeks ago due to complications from the corona 
> virus. 
>
> This leaves another void in the R:Base community that is needing to be 
> filled.  Prudent business practice is to have a backup, an issue for 
> subsequent posts. 
>
> Doug Hamilton 
>
> -- 
> 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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/2735773c-d736-43f3-bb52-4cf7ec23aa69%40googlegroups.com.

[RBASE-L] - Re: COPY command using SELECT?

[Michael Byerley]

You can indeed combine select output with literal text on the same line.  
>From RRBYW20:

select   (ContFName  )=40 ,'This is some literal text'=50 from 
contact where limit = 10
shows:
Jill Baileys This is some literal text
 Shelley WattsThis is some literal text
 Andy ChinThis is some literal text
 Bill Jones   This is some literal text
 Betty Jones  This is some literal text
 Sharon Brady This is some literal text
 Anna Adams   This is some literal text
 Nancy Allen  This is some literal text
 Dennis BergerThis is some literal text
 George Clifton   This is some literal text

WhereAs:
select 'This is some literal text'=50,  (ContFName  )=40 from 
contact where limit = 10
shows:
This is some literal text  Jill Baileys
 This is some literal text  Shelley Watts
 This is some literal text  Andy Chin
 This is some literal text  Bill Jones
 This is some literal text  Betty Jones
 This is some literal text  Sharon Brady
 This is some literal text  Anna Adams
 This is some literal text  Nancy Allen
 This is some literal text  Dennis Berger
 This is some literal text  George Clifton

On Friday, May 1, 2020 at 4:50:29 PM UTC-4, Jim McPherson wrote:
>
> All,
>
>  
>
> We keep a list of files in our database and I am looking to copy a select 
> few to a different location as part of the programming.  I’ve sorted out 
> the SELECT statement.  Can that be used as a source file location?  If so, 
> what’s the syntax?
>
>  
>
> Here’s what I’m trying:
>
> COPY (SELECT FileNameLocation FROM Table WHERE CustomerID IN 
> )   
>
>  
>
> I’m also open to any other ways to accomplish the task.
>
>  
>
> Thanks,
>
>  
>
> Jim
>
>  
>

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

Re: [RBASE-L] - Copy files based on a where clause

[Michael Brookes]

Karen,
Thank you for the reply and the suggestion.
Will try that for sure.

Michael Brookes
Maxima Enterprises
37 NE 29th Street
Oklahoma City, OK. 73105
405-525-8899
405-525-5329 Fax
WWW.MaximaOnline.com

On 3/24/2020 8:31 AM, 'Karen Tellef' via RBASE-L wrote:
That's a toughybut I actually did that once.  I don't have the code 
with me, but it was something like this.  I don't think there's any 
X.5 enhancements that would help.


In my case, the files were named with the unique ID field, so I first 
created a temp table with the IDs of the files I wanted moved, and 
create a computed column to show the filename.  So in your case:

    insert into temptable (id) select id from table where status = 'ma'
and there would be a computed column, let's call it filename:    
(ctxt(id) + '.pdf')


Then I did something like this:
set headings off
output myfile.txt
select 'copy', filename, ' c:\temp' from temptable
output screen
run myfile.txt


Karen




-Original Message-
From: Michael Brookes 
To: rbase-l 
Sent: Mon, Mar 23, 2020 11:47 pm
Subject: [RBASE-L] - Copy files based on a where clause

Hello Group...
Is there a way to copy a file from one directory to another directory 
based on the results of a where clause using an EEP or CMD or ??? 
within R:base Enterprise X.5


I want to copy only certain pictures from one directory on my hard 
drive to another directory on the same hard drive where the "status" 
of a record in my "inventory" table = "MA"


Thank you in advance
--
Michael Brookes
Maxima Enterprises
37 NE 29th Street
Oklahoma City, OK. 73105
405-525-8899
405-525-5329 Fax
WWW.MaximaOnline.com  <http://www.maximaonline.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 
<mailto:rbase-l+unsubscr...@googlegroups.com>.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/b156d188-8289-e0d1-de18-d52b9013469d%40MaximaOnline.com 
<https://groups.google.com/d/msgid/rbase-l/b156d188-8289-e0d1-de18-d52b9013469d%40MaximaOnline.com?utm_medium=email_source=footer>.

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

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


<http://www.avg.com/email-signature?utm_medium=email_source=link_campaign=sig-email_content=emailclient> 
	Virus-free. www.avg.com 
<http://www.avg.com/email-signature?utm_medium=email_source=link_campaign=sig-email_content=emailclient> 



<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>


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

To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/bb73e6ce-b677-6525-98f1-3ed1602bb736%40MaximaOnline.com.

[RBASE-L] - Copy files based on a where clause

[Michael Brookes]

Hello Group...
Is there a way to copy a file from one directory to another directory 
based on the results of a where clause using an EEP or CMD or ??? within 
R:base Enterprise X.5


I want to copy only certain pictures from one directory on my hard drive 
to another directory on the same hard drive where the "status" of a 
record in my "inventory" table = "MA"


Thank you in advance

--
Michael Brookes
Maxima Enterprises
37 NE 29th Street
Oklahoma City, OK. 73105
405-525-8899
405-525-5329 Fax
WWW.MaximaOnline.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/b156d188-8289-e0d1-de18-d52b9013469d%40MaximaOnline.com.

Re: [RBASE-L] - capture just the decimal

[Michael Byerley]

Actually Buddy's way WILL do everything you want. 

just add CTXT  because even if it is already textual, it won't matter and 
If the number is greater than zero, it has a decimal.

SET VAR vText TEXT = '3.14159'
SET VAR vrestxt = NULL

SET VAR vloc INTEGER = NULL


SET VAR vloc = (SLOC((CTXT(.vText)), '.'))

SET VAR vrestxt = ('decimal is at pos' & (CTXT(.vloc)))
PAUSE 2 USING  .vrestxt

RETURN

--And if it is a number already it will test the same:
set var vNum Numeric (10,5) = 3.14159

SET VAR vrestxt = NULL

SET VAR vloc INTEGER = NULL

SET VAR vloc = (SLOC((CTXT(.vText)), '.'))

SET VAR vrestxt = ('decimal is at pos' & (CTXT(.vloc)))
PAUSE 2 USING  .vrestxt

RETURN

On Tuesday, March 17, 2020 at 11:22:55 AM UTC-4, Karen Tellef wrote:
>
> Jim:  That's a nice combination of my and Doug's code!  There's two 
> things that I use the MOD function for.  One is for this, to see if there's 
> decimals.
>
> The other time I use it is during declare cursors when I want to show a 
> Pause of the process including information but don't want to show the pause 
> for every row or use the Meter function.  If I want to display a pause 
> every 20 records, I would do this:
>
>
> SELECT COUNT(DISTINCT wk_wip) INTO vTotCount FROM tmpJobs
>
> -- within the cursor:
>   SET VAR vLoop = (.vLoop + 1)
>   SET VAR vMod  = (MOD(.vLoop,20))
>   IF vLoop = 1 OR vMod = 0 THEN
> SET VAR vText = ('Calculating mid 50%:' & CTXT(.vLoop) & 'of' & CTXT(.
> vTotCount))
> PAUSE 4 USING .vText
>   ENDIF
>
>
> Karen
>
>
>
>
> -Original Message-
> From: Jim Belisle >
> To: rba...@googlegroups.com   >
> Sent: Tue, Mar 17, 2020 10:07 am
> Subject: RE: [RBASE-L] - capture just the decimal
>
> Thanks for the guidance. I believe this will work. I tested it using a 
> variety of numbers and came up with the information I need.
> This cares for whole numbers, numbers greater than one with a decimal and 
> those with just a decimal. That is exactly what I needed.
> I knew it was something that needed a combination of functions.  
>  
> NOTE: The vtcpc is the text number received from a DIALOG 
>  
> SET VAR vcpc NUMERIC(9,2) = .vtcpc
> IF vcpc > 1 THEN
>   SET VAR vmcpc DOUBLE = (MOD(.vcpc,1))
>   IF vmcpc = 0 THEN
> SET VAR vrcpc REAL = .vcpc
>   ELSE
> SET VAR vrcpc REAL = (.vcpc - (AINT(.vcpc)))
>   ENDIF
> ELSE
>   SET VAR vrcpc REAL = .vcpc
> ENDIF
> RETURN
>  
> Karen. I had never seen the MOD function. Thanks.
>  
> James Belisle
>  
> *Making Information Systems People Friendly Since 1990*
> [image: cid:image001.jpg@01CD8CE2.FB048F50]
>  
> *From:* rba...@googlegroups.com  [mailto:
> rba...@googlegroups.com ] *On Behalf Of *Doug Hamilton
> *Sent:* Tuesday, March 17, 2020 9:41 AM
> *To:* R:Base List
> *Subject:* Re: [RBASE-L] - capture just the decimal
>  
> SET VAR vNumReal REAL = 3.14159
>
> SET VAR vNumDecimal REAL = (.vNumReal - (AINT(.vNumReal)))
>
> SHOW VAR vNum%
>
> RETURN
>
> Doug
> On 3/17/2020 9:03 AM, Jim Belisle wrote:
>
> What is the function or combination of functions that will give me just to 
> decimal portion of a numeric number?
> I want to use the decimal portion to determine my next action.
>  
> James Belisle
>  
> *Making Information Systems People Friendly Since 1990*
> [image: cid:image001.jpg@01CD8CE2.FB048F50]
>  
> -- 
> 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 rba...@googlegroups.com .
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/rbase-l/CH2PR02MB7047ED5091A4C04CE8BE2AF4A0F60%40CH2PR02MB7047.namprd02.prod.outlook.com
>  
> 
> .
>
>
>
> -- 
> For group guidelines, visit 
> http://www.rbase.com/support/usersgroup_guidelines.php
> --- 
> You received this message because you are subscribed to the Google Groups 
> "RBASE-L" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to rba...@googlegroups.com .
> To view this discussion on the web visit 
>
> https://groups.google.com/d/msgid/rbase-l/CH2PR02MB70472D1CA4EBF3FC05684EC3A0F60%40CH2PR02MB7047.namprd02.prod.outlook.com
>  
> 
>  
> .
>

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

[RBASE-L] - Re: Just Wondering: A Persistent Data Dictionary Window?

[Michael Byerley]

Just needs to be MDI


On Monday, March 2, 2020 at 12:43:53 PM UTC-5, rbytes wrote:
>
> All:
>
> Is there any way the Data Dictionary can be opened, and left open, for the 
> duration of a coding session; say, on a second display?
>
> Maybe an enhancement request.
>
> Best, Bruce
>
> Bruce A. Chitiea
> SafeSectors, Inc.
> 112 Harvard Ave #272
> Claremont CA 91711-4716
> *rby...@safesectors.com *
> (909) 238-9012 c
>
>

-- 
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/a1d2293b-4750-416f-9837-ed180da0d2f4%40googlegroups.com.

[RBASE-L] - Re: Sending text messages?

[Michael Byerley]

AT num...@txt.att.net (SMS)
AT num...@mms.att.net (MMS)
T-Mobile num...@tmomail.net (SMS)
T-Mobile num...@tmomail.net (MMS)
Verizon num...@vtext.com (SMS)
Verizon num...@vzwpix.com (MMS)
Sprint num...@messaging.sprintpcs.com (SMS)
Sprint num...@pm.sprint.com (MMS)
XFinity num...@vtext.com (SMS)
XFinity num...@mypixmessages.com (MMS)
Virgin num...@vmobl.com (SMS)
Virgin num...@vmpix.com (MMS)
Tracfone num...@mmst5.tracfone.com (MMS)
Metro PCS num...@mymetropcs.com (SMS)
Metro PCS num...@mymetropcs.com (MMS)
Boost num...@sms.myboostmobile.com (SMS)
Boost num...@myboostmobile.com (MMS)
Cricket num...@sms.cricketwireless.net (SMS)
Cricket num...@mms.cricketwireless.net (MMS)
Republic num...@text.republicwireless.com(SMS)
Google Fi num...@msg.fi.google.com (SMS)
Google Fi num...@msg.fi.google.com (MMS)
U.S. Cellular num...@email.uscc.net (SMS)
U.S. Cellular num...@mms.uscc.net (MMS)
Ting num...@message.ting.com (SMS)
Consumer Cellular num...@mailmymobile.net (SMS)
C-Spire num...@cspire1.com (SMS)
Page Plus num...@vtext.com (SMS)

On Tuesday, February 25, 2020 at 7:16:19 AM UTC-5, Doug Hamilton wrote:
>
> Is there a way How do I send text messages to a cell phone?
>
> I run a few automatic integrity checks as users process data and want to 
> send an alert if there are errors.
>
> Thanks,
> Doug
> RBX.5E
>

-- 
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/795190fd-9a61-4530-991e-5ba922c3ebee%40googlegroups.com.

Re: [RBASE-L] - Re: QB help? - SOLUTION!

[Michael Byerley]

  You might first try changing the Quote setting just to check if it's QB 
inflexibility between double and single quotes, which would be a very easy 
fix.


On Thursday, January 23, 2020 at 10:25:30 AM UTC-5, Karen Tellef wrote:
>
> As I mentioned, my developer buddy (SJ) was looking at my files and he had 
> a few suggestions for me to try -- ONE OF WHICH WORKED
>
> Believe it or not, the problem was RBase putting quotation marks around 
> the text values!   Manually removing the quotations marks and importing 
> worked perfectly!   So something changed in the 2020 QB version.  This 
> should be easy to fix!
>
> Karen
>
>   
>
>
> -Original Message-
> From: Karen Tellef >
> To: rbase-l >
> Sent: Wed, Jan 22, 2020 12:29 pm
> Subject: Re: [RBASE-L] - Re: QB help?
>
> Yeah interesting!  Looks like SDK is the way to go.  Their explanation of 
> the new "validation" process is accurate, their error file is very 
> descriptive.  With the old version there was no feedback at all, however 
> our IIF files never once failed.  And it's funny how even Intuit themselves 
> is recommending the "import it for me and I'll fix it later".  I just can't 
> imagine users being happy that they have to go in and manually make 
> corrections to maybe hundreds of imported rows, one at a time.  
>
> I'm crossing my fingers... a developer buddy of mine says he uses Excel to 
> bring RBase data into QB, but he uses the Online version which I guess is 
> quite different from the Desktop version that we are using and he doesn't 
> import the type of transactions that I am.  But he's taking a look at the 
> Excel file that I used (and failed).   So I'm hoping he'll spot something!
>
> Karen
>
>
>
> -Original Message-
> From: Michael Byerley >
> To: RBASE-L >
> Sent: Wed, Jan 22, 2020 11:16 am
> Subject: Re: [RBASE-L] - Re: QB help?
>
>
> Here's a link that may add substance to your argument about using ODBC 
> instead.  It is not a long read. 
>
> https://www.exigobusiness.com/post/quickbooks-desktop-2019-enhanced-iif-import
>
>
> On Monday, January 20, 2020 at 6:54:36 PM UTC-5, Karen Tellef wrote:
>
> An FYI for anyone who might be interested.  I spoke with RBTI's support.  
> This is not an RBase product, but is a third-party software.  It is 
> basically a QB ODBC driver, and RBase can be connected via this driver 
> using SQL commands to communicate.  I'm going to ask my user if they want 
> me to investigate further.
>
> https://qodbc.com/what-is- qodbc/ <https://qodbc.com/what-is-qodbc/>
>
>
> Karen
>
>
>
> -Original Message-
> From: Bruce Chitiea 
> To: rbase-l 
> Sent: Sat, Jan 18, 2020 1:19 pm
> Subject: Re: [RBASE-L] - Re: QB help?
>
> Karen: 
>
> At last year's Conference, Razzak unveiled the new R:BASE <> QBooks 
> interface. You will likely find your solution there.
>
> Bruce
> SafeSectors, Inc.
>
> -- Original Message --
> From: "Michael Byerley" 
> To: "RBASE-L" 
> Sent: 1/18/2020 8:15:01 AM
> Subject: [RBASE-L] - Re: QB help?
>
>
>
> On Saturday, January 18, 2020 at 9:54:40 AM UTC-5, Michael Byerley wrote:
>
> Did you look at this first? 
>
> https://quickbooks.intuit.com/ learn-support/en-us/manage- 
> lists/iif-overview-import-kit- sample-files-and-headers/00/ 201577 
> <https://quickbooks.intuit.com/learn-support/en-us/manage-lists/iif-overview-import-kit-sample-files-and-headers/00/201577>
>
> I can see since the first row of the IIF contains the description of the 
> data, it couldn't be directly imported or at least the first row would 
> not.  But just a quick scan of the information on the page and all of the 
> samples, seems like you should be able to get to a conclusion.
>
>
> Well you can probably ignore my info.  A shallow dive into the QB forum on 
> IIF header formats shows that those samples are more than a decade old and 
> one frustrated user says he cannot even import an IIF file that was 
> Exported from QB.  The culprit in his example is that the column 
> description character length is inaccurate so the import fails, further on 
> that example site, QB states they won't provide any support help for the 
> import or export of said IIF files.
>
>   
>
>
>
>
> On Friday, January 17, 2020 at 4:30:05 PM UTC-5, Karen Tellef wrote:
>
> Going out on a limb here  A client upgraded their Quickbooks software, 
> so the IIF file that we've used for literally decades to import RBase data 
> no longer works.  I've exhausted their phone tech support and online forums 
> (both of which pointedly say they no longer support importing IIF fi

Re: [RBASE-L] - Re: QB help?

[Michael Byerley]

Here's a link that may add substance to your argument about using ODBC 
instead.  It is not a long read.
https://www.exigobusiness.com/post/quickbooks-desktop-2019-enhanced-iif-import


On Monday, January 20, 2020 at 6:54:36 PM UTC-5, Karen Tellef wrote:
>
> An FYI for anyone who might be interested.  I spoke with RBTI's support.  
> This is not an RBase product, but is a third-party software.  It is 
> basically a QB ODBC driver, and RBase can be connected via this driver 
> using SQL commands to communicate.  I'm going to ask my user if they want 
> me to investigate further.
>
> https://qodbc.com/what-is-qodbc/
>
>
> Karen
>
>
>
> -Original Message-
> From: Bruce Chitiea >
> To: rbase-l >
> Sent: Sat, Jan 18, 2020 1:19 pm
> Subject: Re: [RBASE-L] - Re: QB help?
>
> Karen: 
>
> At last year's Conference, Razzak unveiled the new R:BASE <> QBooks 
> interface. You will likely find your solution there.
>
> Bruce
> SafeSectors, Inc.
>
> -- Original Message --
> From: "Michael Byerley" >
> To: "RBASE-L" >
> Sent: 1/18/2020 8:15:01 AM
> Subject: [RBASE-L] - Re: QB help?
>
>
>
> On Saturday, January 18, 2020 at 9:54:40 AM UTC-5, Michael Byerley wrote:
>
> Did you look at this first? 
>
> https://quickbooks.intuit.com/ learn-support/en-us/manage- 
> lists/iif-overview-import-kit- sample-files-and-headers/00/ 201577 
> <https://quickbooks.intuit.com/learn-support/en-us/manage-lists/iif-overview-import-kit-sample-files-and-headers/00/201577>
>
> I can see since the first row of the IIF contains the description of the 
> data, it couldn't be directly imported or at least the first row would 
> not.  But just a quick scan of the information on the page and all of the 
> samples, seems like you should be able to get to a conclusion.
>
>
> Well you can probably ignore my info.  A shallow dive into the QB forum on 
> IIF header formats shows that those samples are more than a decade old and 
> one frustrated user says he cannot even import an IIF file that was 
> Exported from QB.  The culprit in his example is that the column 
> description character length is inaccurate so the import fails, further on 
> that example site, QB states they won't provide any support help for the 
> import or export of said IIF files.
>
>   
>
>
>
>
> On Friday, January 17, 2020 at 4:30:05 PM UTC-5, Karen Tellef wrote:
>
> Going out on a limb here  A client upgraded their Quickbooks software, 
> so the IIF file that we've used for literally decades to import RBase data 
> no longer works.  I've exhausted their phone tech support and online forums 
> (both of which pointedly say they no longer support importing IIF files).  
> I've tried their 2 methods of importing Excel spreadsheets and I can't get 
> either of those to work.   The only data we bring in is an "Item List"
>
> Is anyone on here fluent in bringing in either IIF files or spreadsheets 
> -- with the 2019/later version?  We would have you dial into their system, 
> and I would show you the IIF file that has the data to bring in. Obviously 
> pay for the time.
>
> Any QB peeps out there?
>
>
> Karen
>
> -- 
> 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 rba...@googlegroups.com .
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/rbase-l/5159009e-6f71-4c3c-8d44-dc88f9a03dcd%40googlegroups.com
>  
> <https://groups.google.com/d/msgid/rbase-l/5159009e-6f71-4c3c-8d44-dc88f9a03dcd%40googlegroups.com?utm_medium=email_source=footer>
> .
>
> -- 
> For group guidelines, visit 
> http://www.rbase.com/support/usersgroup_guidelines.php
> --- 
> You received this message because you are subscribed to the Google Groups 
> "RBASE-L" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to rba...@googlegroups.com .
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/rbase-l/em26bac62a-ce71-46c7-9d26-23f83b093b39%40pathfinder
>  
> <https://groups.google.com/d/msgid/rbase-l/em26bac62a-ce71-46c7-9d26-23f83b093b39%40pathfinder?utm_medium=email_source=footer>
> .
>

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

Re: [RBASE-L] - Re: QB help?

[Michael Byerley]

>From the user forum comments, I concluded Intuit is the AT of software 
houses..

So I'm wondering how effective a read/write odbc driver might be to satisfy 
your issue:

https://www.cdata.com/drivers/quickbooks/odbc/?gclid=Cj0KCQiAmZDxBRDIARIsABnkbYQ7AzOI18ZV2R6nCspydJUxslVsseLhVbDPs4gLWtXPAkGCp0W6MQwaAjoJEALw_wcB


On Sunday, January 19, 2020 at 9:55:09 AM UTC-5, Karen Tellef wrote:
>
> Sorry, should've read this email too.  Yep -- the "example" is dated 
> 2008   
>
> One thing that other link says is that there is a new option after 
> attempting and failing to import to "import the data anyway and I'll fix it 
> later".  What that does is that QB makes a guess to correct the errors and 
> then you to go in and manually fix any wrong guesses row by row.  I tried 
> that, and the one thing it guesses on (the "item type", which I need to be 
> "inventory" so it can be sold) is assigned a different value and you are 
> unable to change it!   Not that my user would be happy manually changing 
> hundreds of rows anyway.
>
> One user responded to my question with a link to a consultant's blog which 
> blasts Intuit for breaking the import of data from outside programs.  He 
> says you HAVE to "import and fix later" and have your users manually fix 
> the rows.  Again, they guess incorrectly on a piece of data that is not 
> changeable.
>
> What's funny is that my user is so used to me having the ability to 
> directly contact RBTI with issues and get immediate fixes, that they don't 
> understand why I can't get that from Intuit!  
>
> Karen
>
>
>
> -Original Message-
> From: Michael Byerley >
> To: RBASE-L >
> Sent: Sat, Jan 18, 2020 10:15 am
> Subject: [RBASE-L] - Re: QB help?
>
>
>
> On Saturday, January 18, 2020 at 9:54:40 AM UTC-5, Michael Byerley wrote:
>
> Did you look at this first? 
>
> https://quickbooks.intuit.com/ learn-support/en-us/manage- 
> lists/iif-overview-import-kit- sample-files-and-headers/00/ 201577 
> <https://quickbooks.intuit.com/learn-support/en-us/manage-lists/iif-overview-import-kit-sample-files-and-headers/00/201577>
>
> I can see since the first row of the IIF contains the description of the 
> data, it couldn't be directly imported or at least the first row would 
> not.  But just a quick scan of the information on the page and all of the 
> samples, seems like you should be able to get to a conclusion.
>
>
> Well you can probably ignore my info.  A shallow dive into the QB forum on 
> IIF header formats shows that those samples are more than a decade old and 
> one frustrated user says he cannot even import an IIF file that was 
> Exported from QB.  The culprit in his example is that the column 
> description character length is inaccurate so the import fails, further on 
> that example site, QB states they won't provide any support help for the 
> import or export of said IIF files.
>
>   
>
>
>
>
> On Friday, January 17, 2020 at 4:30:05 PM UTC-5, Karen Tellef wrote:
>
> Going out on a limb here  A client upgraded their Quickbooks software, 
> so the IIF file that we've used for literally decades to import RBase data 
> no longer works.  I've exhausted their phone tech support and online forums 
> (both of which pointedly say they no longer support importing IIF files).  
> I've tried their 2 methods of importing Excel spreadsheets and I can't get 
> either of those to work.   The only data we bring in is an "Item List"
>
> Is anyone on here fluent in bringing in either IIF files or spreadsheets 
> -- with the 2019/later version?  We would have you dial into their system, 
> and I would show you the IIF file that has the data to bring in. Obviously 
> pay for the time.
>
> Any QB peeps out there?
>
>
> Karen
>
> -- 
> 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 rba...@googlegroups.com .
> To view this discussion on the web visit 
>
> https://groups.google.com/d/msgid/rbase-l/5159009e-6f71-4c3c-8d44-dc88f9a03dcd%40googlegroups.com
>  
> <https://groups.google.com/d/msgid/rbase-l/5159009e-6f71-4c3c-8d44-dc88f9a03dcd%40googlegroups.com?utm_medium=email_source=footer>
>  
> .
>

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

[RBASE-L] - Re: QB help?

[Michael Byerley]

On Saturday, January 18, 2020 at 9:54:40 AM UTC-5, Michael Byerley wrote:
>
> Did you look at this first?
>
>
> https://quickbooks.intuit.com/learn-support/en-us/manage-lists/iif-overview-import-kit-sample-files-and-headers/00/201577
>
> I can see since the first row of the IIF contains the description of the 
> data, it couldn't be directly imported or at least the first row would 
> not.  But just a quick scan of the information on the page and all of the 
> samples, seems like you should be able to get to a conclusion.
>

Well you can probably ignore my info.  A shallow dive into the QB forum on 
IIF header formats shows that those samples are more than a decade old and 
one frustrated user says he cannot even import an IIF file that was 
Exported from QB.  The culprit in his example is that the column 
description character length is inaccurate so the import fails, further on 
that example site, QB states they won't provide any support help for the 
import or export of said IIF files.

  

>
>
>
> On Friday, January 17, 2020 at 4:30:05 PM UTC-5, Karen Tellef wrote:
>>
>> Going out on a limb here  A client upgraded their Quickbooks 
>> software, so the IIF file that we've used for literally decades to import 
>> RBase data no longer works.  I've exhausted their phone tech support and 
>> online forums (both of which pointedly say they no longer support importing 
>> IIF files).  I've tried their 2 methods of importing Excel spreadsheets and 
>> I can't get either of those to work.   The only data we bring in is an 
>> "Item List"
>>
>> Is anyone on here fluent in bringing in either IIF files or spreadsheets 
>> -- with the 2019/later version?  We would have you dial into their system, 
>> and I would show you the IIF file that has the data to bring in. Obviously 
>> pay for the time.
>>
>> Any QB peeps out there?
>>
>>
>> Karen
>>
>

-- 
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/5159009e-6f71-4c3c-8d44-dc88f9a03dcd%40googlegroups.com.

[RBASE-L] - Re: QB help?

[Michael Byerley]

Did you look at this first?

https://quickbooks.intuit.com/learn-support/en-us/manage-lists/iif-overview-import-kit-sample-files-and-headers/00/201577

I can see since the first row of the IIF contains the description of the 
data, it couldn't be directly imported or at least the first row would 
not.  But just a quick scan of the information on the page and all of the 
samples, seems like you should be able to get to a conclusion.



On Friday, January 17, 2020 at 4:30:05 PM UTC-5, Karen Tellef wrote:
>
> Going out on a limb here  A client upgraded their Quickbooks software, 
> so the IIF file that we've used for literally decades to import RBase data 
> no longer works.  I've exhausted their phone tech support and online forums 
> (both of which pointedly say they no longer support importing IIF files).  
> I've tried their 2 methods of importing Excel spreadsheets and I can't get 
> either of those to work.   The only data we bring in is an "Item List"
>
> Is anyone on here fluent in bringing in either IIF files or spreadsheets 
> -- with the 2019/later version?  We would have you dial into their system, 
> and I would show you the IIF file that has the data to bring in. Obviously 
> pay for the time.
>
> Any QB peeps out there?
>
>
> Karen
>

-- 
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/e21c1fed-83bd-40fe-a2a8-2285e9c69e3a%40googlegroups.com.

[RBASE-L] - More than one character in the Lookup Combo Box

[Michael Brookes]

I have looked and looked, and I can not find a way to be able to use 
more than the first character to find something in a "Lookup Combo Box" 
in a form.


I have over 3500 Manufacturers in my database that pulls up in a "Lookup 
Combo Box" and the first letter doesn't narrow it down enough.
I still to scroll down quite a bit even when the list shows 45 lines in 
the open box.

2 characters would be a big help, but 3 or more would be great.

--
Michael Brookes
Maxima Enterprises
37 NE 29th Street
Oklahoma City, OK. 73105
405-525-8899
405-525-5329 Fax
WWW.MaximaOnline.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/98f0afaa-f50e-bfa0-a932-e9ff721d074b%40MaximaOnline.com.

[RBASE-L] - Editable PDF output

[Michael Brookes]

Is there any way to output to a PDF file where the data fields are 
already editable by the recipient after it is emailed to them?
I am trying to send out a PDF report that has all of the fields of 
customer information listed in my DB, where the fields can be updated 
and emailed back to me without them having to print it, cross things 
out, hand write corrections and new information, scan it, and them email 
it back to me.


Or would they have to have a option on there end to make the PDF 
"Editable"? Not too many people have the PDF edit option, and that would 
make ALL text on the PDF able to be editable, not just the data fields.


I was hoping that only the data fields could be editable.

--
Michael Brookes
Maxima Enterprises
37 NE 29th Street
Oklahoma City, OK. 73105
405-525-8899
405-525-5329 Fax
WWW.MaximaOnline.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/c3d02f89-3b54-c52a-b36b-8c88e4edc2c5%40MaximaOnline.com.

[RBASE-L] - Re: FW: RBase error

[Michael Byerley]

Ajay,

  Dlls should always be in the normal windows DLL search path.  

  
https://docs.microsoft.com/en-us/windows/win32/dlls/dynamic-link-library-search-order


On Thursday, January 17, 2019 at 10:57:29 AM UTC-5, asanghvi wrote:
>
> Good Morning 
>
>  
>
> I have a compiled App that when run on a Win 10 Machine runs without an 
> error but the same compiled app on a Win 7 gives the following error. 
>
> What am I missing?
>
>  
>
> [image: image.png]
>
>  
>
>  
>
> *AJAY SANGHVI*
> Vice President
>
> *700 Blair Road*
> *Carteret, New Jersey  07008 U.S.A.*
>
> T (973) 748 8980 
> F (973) 680 9618
> E asan...@berjeinc.com 
>
> [image: cid:image001.png@01CCE665.DADDB4F0] 
>
>  
>
>  
>
> *Berjé Inc. *- an SQF Level 3 Quality Certified Supplier No. 7751 and 
> Certified by WQS. 
> *** Markets are moving rapidly, please note all prices and volume offers 
> are kindly to be considered subject final confirmation, including any 
> pending tariff changes, unless otherwise stated. ** *

-- 
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/da05eaf6-fc78-4a13-97ad-c2858dd35933%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [RBASE-L] - multiple sorting of db grid

[Michael Byerley]

  Again, you can use a single table temp editable view for the dbgrid.  
while the form displayed, whatever mechanism you use to change your order 
by or select criteria, you

  Example code from one of my forms;

SELECT COUNT (*) INTO vcount IND vin0 FROM sys_tables WHERE +
sys_table_name = 'tvwApChecks'
IF vcount > 0 THEN
  PROPERTY table tvwapchecks 'CLOSE'
  DROP VIEW tvwapchecks
  CREATE TEMP VIEW tvwapchecks AS SELECT rcheckno,cono,cid, +
  transdate,amt,reconciled,dupecheck,refno  FROM agcheckreg +
  WHERE cono = .vcono AND cid = .vcid ORDER BY rcheckno
  PROPERTY table tvwapchecks 'OPEN'
  PROPERTY table tvwapchecks 'REFRESH'
ENDIF

  

On Monday, July 1, 2019 at 3:24:51 PM UTC-4, Jim Belisle wrote:
>
> Thank Jan for pointing me to the PROPERTY commands. I had looked at that 
> one but did not realize it would bring up the box.
>
> Did the trick.
>
>  
>
> James Belisle
>
>  
>
> *Making Information Systems People Friendly Since 1990*
>
> [image: cid:image001.jpg@01CD8CE2.FB048F50]
>
>  
>
> *From:* rba...@googlegroups.com  [mailto:
> rba...@googlegroups.com ] *On Behalf Of *jan johansen
> *Sent:* Monday, July 1, 2019 11:25 AM
> *To:* rba...@googlegroups.com 
> *Subject:* Re: [RBASE-L] - multiple sorting of db grid
>
>  
>
> Jim,
>
>  
>
> I don't use DB grids all often but should be able to use an "order by" 
> before bringing up the form.
>
> Also there appears to be a PROPERTY command to bring up a sort called 
> SHOWSORTDIALOG
>
>  
>
> Jan
>
>  
>
>  
>
>   
>
> From: Jim Belisle >
> To: "rba...@googlegroups.com "  >
> Date: Thu, 27 Jun 2019 15:09:47 +
> Subject: [RBASE-L] - multiple sorting of db grid
>   
>
> Is there a way to have multiple sorting of an enhanced DB grid form? 
>
>  
>
> James Belisle
>
>  
>
> *Making Information Systems People Friendly Since 1990*
>
> [image: cid:image001.jpg@01CD8CE2.FB048F50]
>
>  
>
>  
>
> --
> 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 rba...@googlegroups.com .
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/rbase-l/DM6PR02MB453930DF5ACF2DA9BE45D064A0FD0%40DM6PR02MB4539.namprd02.prod.outlook.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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/f8ee3b6b-3ab8-4664-9831-a4fa2a2e12d9%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [RBASE-L] - Filtering Enhanced DB Grid rows with PROPERTY commands

[Michael Byerley]

Single table (editable) view - Close table, drop table, change where clause 
for view (your filter requirement) Open table - refresh dbgrid.

On Wednesday, June 12, 2019 at 10:13:05 AM UTC-4, Karen Tellef wrote:
>
> I was going to say the same thing, I think you have to click the property 
> to enable the filter bar
>
> There's other ways of doing it.  One easy way is to make a 2-table form, 
> with the states on the left and the table data on the right.  Assuming that 
> the name "State" is the only common column between the 2 tables, scrolling 
> thru the list of states on the left will automatically update the grid on 
> the right.
>
> Karen
>
>
>
>
> -Original Message-
> From: Dan Goldberg >
> To: rba...@googlegroups.com   >
> Sent: Wed, Jun 12, 2019 8:40 am
> Subject: RE: [RBASE-L] - Filtering Enhanced DB Grid rows with PROPERTY 
> commands
>
> I think you need to have the filter bar enabled for it to work. your code 
> looks good.
>  
> Dan
>  
> *From:* 'R Hopkins' via RBASE-L > 
> *Sent:* Tuesday, June 11, 2019 4:18 PM
> *To:* rba...@googlegroups.com 
> *Subject:* [RBASE-L] - Filtering Enhanced DB Grid rows with PROPERTY 
> commands
>  
> I have been trying to learn how to use the PROPERTY EnhDBGrid FILTER 
> commands by trial and error, but without success.  I am hoping someone can 
> fill in the blanks for me.  I am 
> confident someone has done something similar to this before.  One other 
> note; I am using
> R:BaseX, not R:BaseX.5
>
> SITUATION  (not using my real data to keep it simple):
>   I have a 3 column table named Contacts  with 40 rows
>  City  TEXT 32
>  StateTEXT 2
>  ZipcodeINTEGER
>
> I have a form containing:
>An Enhanded DB Grid Property,Component ID:  Places   Table: Contacts
>   I didn't click any property boxes related to filtering within this 
> Property.
>A Variable Radio Group Property, Component ID:  StateGroups 
>   that loads variable fState with one of 3 selectable values  'CA' or 
> 'CT' or 'WA'
>
> WHAT I WANT TO DO
>   I want to use the value loaded in variable fState to filter which rows 
> are displayed in 
>   the Enhanced DB Grid.  Every time a different Radio Button is selected, 
> reloading the
>   value of variable fState, have the rows displayed in the Enhanced DB 
> Grid change to display
>   only those in column State that match the value in variable fState.
>   I don't want a filter bar displayed within the Enhanced DB Grid 
> Property, as it will
> compete with the Radio Group for user's attention (and State is the 
> only column to
> be filtered on).
>   I want all filtering to occur behind the scenes using the PROPERTY 
> commands.
>
> WHAT I HAVE TRIED
>To get this filter working, I have tried placing the following commands 
> in
>the forms ON AFTER START EEP - just to see how they work - or not work. 
>  
>My expectation being that when the forms starts, it will display only 
> rows 
>  WHERE state = 'CA' (my default for initial display).
>
>Attempt #1  = No rows filtered out, all 40 rows displayed
>  PROPERTY Places FILTERS->COLUMN_NAME->state 'CA'
>Attempt #2  = No rows filtered out, all 40 rows displayed
>  PROPERTY Places FILTERS->COLUMN_NAME->state->ADD_ITEM 'CA'
>Attempt #3  = Error message, "No rows exist or satisfy the specified 
> clause"
>  PROPERTY Places FILTERTYPE 'EQUAL'
>  PROPERTY Places FILTERS->COLUMN_NAME->state 'CA'
>But none of these commands caused that to happen.  Including the 
> FILTERTYPE command
>results in No rows being found.  I suspect there are additional 
> commands required that I 
>have not been able to identify.  
>  
>Note that I haven't introduced the variable fState into the commands 
> yet to make my 
>learning curve simpler.  But once I can make the value 'CA' work, I 
> should be able to 
>replace it with .fState and use the PROPERTY commands within the ON 
> CLICK EEP 
>for the Variable Radio Group Property.
>   
>The RBASE documentation is pretty good at describing what different 
> commands do.  
>This is an exercise for me to learn how to put all the commands 
> together needed to 
>implement a capability.
>  
> I will be very thankful to anyone who can provide me the complete set of 
> commands (and/or Enhanced DB Grid property item clicks) needed to make this 
> work.
>  
> NOTE
>   I normally do this type of filtering using a Variable Lookup List View 
> Property instead 
>   of an Enhanced DB Grid Property because it has a WHERE clause 
> capability.  But the 
>   Enhanced DB Grid Property had some features I want to use, like the 
> footer for summing 
>   and the ability to center the header names within each column, etc.  It 
> also forces me 
>   to learn how to use the Enhanced DB Grid Property's filter capabilities.
> R Hopkins
>  
> -- 
> For group guidelines, visit 
> http://www.rbase.com/support/usersgroup_guidelines.php
> --- 
> You 

Re: Re[2]: [RBASE-L] - Aggressive String Manipulation Language

[Michael Byerley]

Wel IF you are already familiar with JavaScript/JScript, which has 
a plethora of its functions carrying nomenclature from C, it would not be a 
huge leap to become familiar with the language behing the GUI of RBase, 
Delphi (pascal), which supports, i think, nearly all of C's functions.

The main difference to the casual observer is that Delphi/pascal has its' 
code blocks demarked by "begin" / "end' keywords at the loctions you would 
find curly braces in C or JavaScript/JScript.

It is not rocket science to create your library of string manipulation 
routines in a Delphi DLL which is directly callable from within RBase using 
the DLCall function.  When using an external DLL in this fashion, it is 
introduced into the same address space as RBase and behaves the same as an 
internal RBase function.

I don't think the underlying language in which Windows itself is written 
(C++, C) is going to go the way of the dinosaurs anytime soon.  If you are 
going to need string manipulation in a web environment, then this approach 
is probably less favorable, but in Windows, it is a good fit.


On Wednesday, May 15, 2019 at 12:59:54 PM UTC-4, rbytes wrote:
>
> A truly excellent starting-point article. Thank you, Javier.
>
> The GUI and the bulk of the processing to be performed are pure R:BASE, 
> and may be entirely R:BASE; but I'm exploring the possibility that I may 
> have to call specialized routines to expose that one needle buried within a 
> universe of haystacks.
>
> Best, Bruce
>
> -- Original Message --
> From: javier@vtgonline.com 
> To: rba...@googlegroups.com 
> Sent: 5/15/2019 9:22:56 AM
> Subject: RE: [RBASE-L] - Aggressive String Manipulation Language
>
> Most newer programming languages provide string manipulation capabilities. 
> Here is a good comparison:
>
>
> https://en.wikipedia.org/wiki/Comparison_of_programming_languages_(string_functions)
>
> From what I have read PERL and Python seem to be good at string 
> manipulation but the general consensus seems to be to use a language with 
> which you are already familiar and also one that  will make it easier to 
> build the GUI which is a lot more complicated, if you are building the GUI 
> as well. Also, consider which programming language will be around in the 
> future; many become really popular and then they are replaced and it is 
> back to square one.
>
>  
>
> Javier,
>
>  
>
> Javier Valencia, PE
>
> O: 913-829-0888
>
> C: 913-915-3137
>
>  
>
> *From:* rba...@googlegroups.com  [mailto:
> rba...@googlegroups.com ] *On Behalf Of *
> rby...@safesectors.com 
> *Sent:* Tuesday, May 14, 2019 12:04 PM
> *To:* rba...@googlegroups.com 
> *Subject:* [RBASE-L] - Aggressive String Manipulation Language
>
>  
>
> All:
>
> Any recommendation for a do-anything string manipulation language (*e.g.* 
> Perl6, PHP), adept at slicing/dicing html/text constructions? Experience? 
> Preference?
>
> Bruce Chitiea
> SafeSectors, Inc.
> (909) 238-9012 c
>
> -- 
> 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 rba...@googlegroups.com .
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/rbase-l/22852f35f9b95801eafad949f14f3f03%40safesectors.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 rba...@googlegroups.com .
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/rbase-l/!%26!AAAYAO1ueGVb5zRMiwo7hebUe7jCgAAAEP%2B05LdXJXRCinUP6FnGZRIBAA%3D%3D%40vtgonline.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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/c59ba6b0-3d7b-468e-831e-56cdee399720%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[RBASE-L] - Re: Aggressive String Manipulation Language

[Michael Byerley]

jscript or javascript


On Tuesday, May 14, 2019 at 1:03:44 PM UTC-4, rbytes wrote:
>
> All:
>
> Any recommendation for a do-anything string manipulation language (*e.g.* 
> Perl6, PHP), adept at slicing/dicing html/text constructions? Experience? 
> Preference?
>
> Bruce Chitiea
> SafeSectors, Inc.
> (909) 238-9012 c
>

-- 
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/293134d2-3c25-4fd5-91ab-6c5d94123b7c%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [RBASE-L] - Problem with a summary report

[Michael Byerley]

SET POINTER anyone?


On Wednesday, February 13, 2019 at 1:34:06 PM UTC-5, javier.valencia wrote:
>
> R:Base has been really good about supporting Legacy commands when new ones 
> were introduced. I remember going over code when the DECLARE CURSOR 
> replaced the old construct and updating lots of code, In fact, I have now 
> done away with a lot of old code that used cursors and switched to using 
> SQL commands to do it with one line of code where it took many before.
>
> I have mostly done away with the “SUM OF…” construct and replaced it with 
> DB Calc, like you did. I am sure I have some old reports that still have 
> the old construct and whenever I run into one I try to immediately replace 
> it with the newer commands.
>
>  
>
> Javier,
>
>  
>
> Javier Valencia, PE
>
> O: 913-829-0888
>
> C: 913-915-3137
>
>  
>
>  
>
>  
>
> *From:* rba...@googlegroups.com  [mailto:
> rba...@googlegroups.com ] *On Behalf Of *Stephen Markson
> *Sent:* Wednesday, February 13, 2019 10:48 AM
> *To:* 'rba...@googlegroups.com '
> *Subject:* RE: [RBASE-L] - Problem with a summary report
>
>  
>
> Hi,
>
>  
>
> I wrote
>
>  
>
> *I’m not sure if “sum of” is supported any longer*
>
>  
>
> because if I search for “sum of” in RBase help, nothing comes up about 
> using *sum of *in reports.
>
>  
>
> I too have tons of old reports with *sum of*, but I’m not using that 
> construct in new reports. If I just need the sum (count, min, max or 
> average), I use a *DB Calc *object. If I need to use the value from the 
> calculation, I create my own sum, count, min, max or average variables.
>
>  
>
>  
>
> Regards,
>
>  
>
> Stephen Markson
>
> The Pharmacy Examining Board of Canada
>
> 416.979.2431 x251
>
>  
>
> *From:* rba...@googlegroups.com   > *On Behalf Of *Jim Belisle
> *Sent:* February 11, 2019 4:24 PM
> *To:* rba...@googlegroups.com 
> *Subject:* RE: [RBASE-L] - Problem with a summary report
>
>  
>
> Stephen. I still have reports where I use SUM OF and I am using the 
> RBASEXE. 
>
> However I will look into your code to see if that is a better way.
>
>  
>
> James Belisle
>
>  
>
> *Making Information Systems People Friendly Since 1990*
>
> [image: cid:image001.jpg@01CD8CE2.FB048F50]
>
>  
>
> *From:* rba...@googlegroups.com  [mailto:...@googlegroups.com 
> ] *On Behalf Of *Stephen Markson
> *Sent:* Monday, February 11, 2019 3:20 PM
> *To:* 'rba...@googlegroups.com '
> *Subject:* RE: [RBASE-L] - Problem with a summary report
>
>  
>
> Hello Patti,
>
>  
>
> I believe your variable setup is incorrect. I’m not sure if “sum of” is 
> supported any longer. I have been using the following successfully for a 
> long time:
>
>  
>
> 1.Make sure vSubTot is initialized to zero prior to running the 
> report.
>
> 2.vSubTot=(.vSubTot+1)   - calculated on *D*etail, reset on *F0 
> *(break footer 0)
>
> 3.vPercentage=what you had- calculated on *F0*
>
> 4.You don’t need *vcount*
>
>  
>
>  
>
> Regards,
>
>  
>
> Stephen Markson
>
> The Pharmacy Examining Board of Canada
>
> 416.979.2431 x251
>
>  
>
> *From:* 'Patti Jakusz' via RBASE-L > 
>
> *Sent:* February 11, 2019 12:45 PM
> *To:* rba...@googlegroups.com   >; RBASE-L >; RBASE-L <
> rbase-l...@googlegroups.com >
> *Subject:* [RBASE-L] - Problem with a summary report
>
>  
>
> Hello,
>
>  
>
> Can someone help me?
>
>  
>
> I can't imagine what my problem is.  I have many reports that do this sort 
> of thing and I have examined them and can't see what I must be missing.  
>
>  
>
> This is a report that prints no detail, but just a summary line on the 
> break footer.  I calculate the grand total (vtotal) ahead of time in the 
> command file, so I can print a percentage along with the subtotal on each 
> break footer.  
>
>  
>
> But the subtotal only shows up on the first break footer, and not the 
> subsequent ones.
>
>  
>
> I took a screen shot of the variable definitions, the report layout, the 
> report break definition and stuck them all on one page of a word doc.
>
> I took a screen shot of the report results.
>
>  
>
> In my command file:
>
>  
>
> set v vcount INT = 0
>
> set v vsubtot INT = 0
>
> print DemogActiv order by AgeCatM
>
>  
>
> Thank you for your time.
>
> Patti
>
>  
>
>  
>
>  
>
> -- 
> For group guidelines, visit 
> http://www.rbase.com/support/usersgroup_guidelines.php
> --- 
> You received this message because you are subscribed to the Google Groups 
> "RBASE-L" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to rbase-l+u...@googlegroups.com .
> 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+u...@googlegroups.com .
> For more options, visit 

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

[Michael Byerley]

When you are printing from the window dialog, there isn't an RBase event 
occurring.


On Wednesday, October 31, 2018 at 4:30:32 PM UTC-4, Doug Hamilton wrote:
>
> Hi All - 
> I have a one-page worksheet report that I want to have update a datetime 
> column after it is *printed*.
> If user just looks at it and closes, without printing, no update.
>
> An UPDATE command in both After Generate and AfterPreview EEPs runs after 
> the report is displayed, regardless of whether it is printed or not, so (I 
> don't think) those EEPs aren't going to work.
>
> I could put the UPDATE after the PRINT command, but that runs whether they 
> print or just view.
>
> I could add a dialog could ask the question, but I'd like the update to be 
> transparent to the user.
>
> Ideas?  Is there an R:Base system variable that indicates print status?  
>
> TIA, 
> Doug
>
>
> 
>  Virus-free. 
> www.avast.com 
> 
>  
> <#8e307184-3216-7df9-04da-ce894ce24...@wi.rr.com_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>

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

Re: [RBASE-L] - LISTOF question 10.0.4.10913

[Michael Byerley]

  One limitation though is from testing, the CAPTION string in RBase forms 
is limited to 1023 characters.  Windows forms can hold more than a 100K.  
  1023 Chars is still a fair amount, but If one were to desire to pass 
more, it would likely have to be via a write to disk and subsequent 
retrieval and execution.  I guess I am kind of writing and thinking in 
terms of passing "actual" object names, Propertes and values at runtime, 
which if lengthy could consume a fair patch of 1K.



On Tuesday, October 30, 2018 at 3:46:24 PM UTC-4, crobbins wrote:
>
> Thanks Mike. I can’t wait to tear into it!  You’ve totally awoken my 
> curiosity.  
>
> Claudine 
>
> Sent from my iPhone
>
> On Oct 29, 2018, at 9:56 PM, Michael Byerley  > wrote:
>
>
>
> Go ahead and download the RBase Calendar from Here: 
>
> http://byerley.net/(S(syqysn45jp2uc3quom5gtl2t))/Download_A/RbCalendar.zip
>
> 1.  Load the calendar into a non production database.  You may find it 
> useful :)
> 2.  Read the comments in the CalDemo.rmd file to see the valuelist that is 
> passed in the Caption String.
> 3.  Look at the OnAfterStart EEP to see how the string is parsed, 
> utilizing the values passed.
>
> Now taking a cue from that process, you could take a step further and make 
> each element of the string and instead of passing just a value to be used, 
> you could put Name / Value pairs in the following fashion:
>
> EDIT USING rbcalendar CAPTION 
> 'FormWidth=180,FormHeight=500,FormColor=red,ReturnVarName=,vRetDate,'
>
> Then modify slightly the parsing method I used to a Switch/Endsw that 
> could track to the NAME half of the name value pairs passed, with the VALUE 
> half being consumed appropriately by PROPERTY, GETPROPERTY, or direct usage 
> as a var.
>
>  
>
> On Monday, October 29, 2018 at 1:10:55 PM UTC-4, crobbins wrote: 
>>
>> Thank you Mike.  I’ve already included your form in an SP and understand 
>> the passing of parameters.  I also understand property commands located 
>> immediately after calling the SP.  However, using the CAPTION string for 
>> anything more than cosmetics escapes me.
>>
>>  
>>
>> Claudine
>>
>>  
>>
>> *From:* rba...@googlegroups.com [mailto:rba...@googlegroups.com] *On 
>> Behalf Of *Michael Byerley
>> *Sent:* Sunday, October 28, 2018 12:47 PM
>> *To:* RBASE-L
>> *Subject:* Re: [RBASE-L] - LISTOF question 10.0.4.10913
>>
>>  
>>
>>  
>>
>>  
>>
>>   One further comment on this.  You can blackbox the form solution in a 
>> couple of ways, one being to put the form inside of a stored procedure so 
>> you can call it from there,
>>
>> then using property commands to change the table name and colum spec for 
>> the listbox, or simply utilize the CAPTION string that is the argument of 
>> Edit Using or Enter Using to contain an argument of the elements you want 
>> to change in the onAfter start of the form.
>>
>>  
>>
>>   If you have ever used my RBase form based Calendar, you will see its' 
>> procedure there.
>>
>>  
>>
>>   So by doing that, you could change the properties of the pseudo Choose 
>> box on the fly, and reuse it anytime the need arises in lieu of having a 
>> separate form for each problem.
>>
>>  
>>
>>   Over the course of time since the humble 7.0, RBase has provided many 
>> pathways to problem solution and when there is none apparent, there is 
>> always a reasonably willing RDCC..  :)
>>
>>  
>>
>>
>>
>> On Saturday, October 27, 2018 at 10:53:57 PM UTC-4, javier.valencia wrote:
>>
>> Claudine,
>>
>>  
>>
>> Try the following:
>>
>>  
>>
>> SELECT LISTOF( +  your column + ) into xxx from your_table WHERE …
>>
>>  
>>
>> All the items should have single quotes and the comma should be inside 
>> the quotes.
>>
>>  
>>
>> Javier,
>>
>>  
>>
>> Javier Valencia, PE
>>
>> O: 913-829-0888
>>
>> H: 913-397-9605
>>
>> C: 913-915-3137
>>
>>  
>>
>> *From:* rba...@googlegroups.com [mailto:rba...@googlegroups.com] *On 
>> Behalf Of *Claudine Robbins
>> *Sent:* Friday, October 26, 2018 3:08 PM
>> *To:* rba...@googlegroups.com
>> *Subject:* [RBASE-L] - LISTOF question 10.0.4.10913
>>
>>  
>>
>> Hello all,
>>
>>  
>>
>> My experience with LISTOF is that it automatically puts quotes around 
>> fields that contain commas but I’m running into a situation where it 

Re: [RBASE-L] - LISTOF question 10.0.4.10913

[Michael Byerley]

Go ahead and download the RBase Calendar from Here:

http://byerley.net/(S(syqysn45jp2uc3quom5gtl2t))/Download_A/RbCalendar.zip

1.  Load the calendar into a non production database.  You may find it 
useful :)
2.  Read the comments in the CalDemo.rmd file to see the valuelist that is 
passed in the Caption String.
3.  Look at the OnAfterStart EEP to see how the string is parsed, utilizing 
the values passed.

Now taking a cue from that process, you could take a step further and make 
each element of the string and instead of passing just a value to be used, 
you could put Name / Value pairs in the following fashion:

EDIT USING rbcalendar CAPTION 
'FormWidth=180,FormHeight=500,FormColor=red,ReturnVarName=,vRetDate,'

Then modify slightly the parsing method I used to a Switch/Endsw that could 
track to the NAME half of the name value pairs passed, with the VALUE half 
being consumed appropriately by PROPERTY, GETPROPERTY, or direct usage as a 
var.

 

On Monday, October 29, 2018 at 1:10:55 PM UTC-4, crobbins wrote:
>
> Thank you Mike.  I’ve already included your form in an SP and understand 
> the passing of parameters.  I also understand property commands located 
> immediately after calling the SP.  However, using the CAPTION string for 
> anything more than cosmetics escapes me.
>
>  
>
> Claudine
>
>  
>
> *From:* rba...@googlegroups.com  [mailto:
> rba...@googlegroups.com ] *On Behalf Of *Michael Byerley
> *Sent:* Sunday, October 28, 2018 12:47 PM
> *To:* RBASE-L
> *Subject:* Re: [RBASE-L] - LISTOF question 10.0.4.10913
>
>  
>
>  
>
>  
>
>   One further comment on this.  You can blackbox the form solution in a 
> couple of ways, one being to put the form inside of a stored procedure so 
> you can call it from there,
>
> then using property commands to change the table name and colum spec for 
> the listbox, or simply utilize the CAPTION string that is the argument of 
> Edit Using or Enter Using to contain an argument of the elements you want 
> to change in the onAfter start of the form.
>
>  
>
>   If you have ever used my RBase form based Calendar, you will see its' 
> procedure there.
>
>  
>
>   So by doing that, you could change the properties of the pseudo Choose 
> box on the fly, and reuse it anytime the need arises in lieu of having a 
> separate form for each problem.
>
>  
>
>   Over the course of time since the humble 7.0, RBase has provided many 
> pathways to problem solution and when there is none apparent, there is 
> always a reasonably willing RDCC..  :)
>
>  
>
>
>
> On Saturday, October 27, 2018 at 10:53:57 PM UTC-4, javier.valencia wrote:
>
> Claudine,
>
>  
>
> Try the following:
>
>  
>
> SELECT LISTOF( +  your column + ) into xxx from your_table WHERE …
>
>  
>
> All the items should have single quotes and the comma should be inside the 
> quotes.
>
>  
>
> Javier,
>
>  
>
> Javier Valencia, PE
>
> O: 913-829-0888
>
> H: 913-397-9605
>
> C: 913-915-3137
>
>  
>
> *From:* rba...@googlegroups.com [mailto:rba...@googlegroups.com] *On 
> Behalf Of *Claudine Robbins
> *Sent:* Friday, October 26, 2018 3:08 PM
> *To:* rba...@googlegroups.com
> *Subject:* [RBASE-L] - LISTOF question 10.0.4.10913
>
>  
>
> Hello all,
>
>  
>
> My experience with LISTOF is that it automatically puts quotes around 
> fields that contain commas but I’m running into a situation where it does 
> not.
>
>  
>
> One of the fields is YELLOW JACKET CONSTRUCTION, INC., LISTOF returns the 
> space plus INC. as a separate value.  
>
>  
>
> However, it correctly returns 3 for the ITEMCNT variable.
>
>  
>
> What am I overlooking?
>
>  
>
> R>sho v vValueList
>
> YELLOW JACKET CONSTRUCTION, 
>
> INC.,YELLOW JACKET 
>
> OILFIELD,YELLOWHOUSE 
>
> MACHINERY CO.
>
>  
>
> [image: cid:image002.png@01D46D3C.007A56F0]
>
> -- 
> For group guidelines, visit 
> http://www.rbase.com/support/usersgroup_guidelines.php
> --- 
> You received this message because you are subscribed to the Google Groups 
> "RBASE-L" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to rbase-l+u...@googlegroups.com.
> 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+u...@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] - LISTOF question 10.0.4.10913

[Michael Byerley]

  One further comment on this.  You can blackbox the form solution in a 
couple of ways, one being to put the form inside of a stored procedure so 
you can call it from there,
then using property commands to change the table name and colum spec for 
the listbox, or simply utilize the CAPTION string that is the argument of 
Edit Using or Enter Using to contain an argument of the elements you want 
to change in the onAfter start of the form.

  If you have ever used my RBase form based Calendar, you will see its' 
procedure there.

  So by doing that, you could change the properties of the pseudo Choose 
box on the fly, and reuse it anytime the need arises in lieu of having a 
separate form for each problem.

  Over the course of time since the humble 7.0, RBase has provided many 
pathways to problem solution and when there is none apparent, there is 
always a reasonably willing RDCC..  :)



On Saturday, October 27, 2018 at 10:53:57 PM UTC-4, javier.valencia wrote:
>
> Claudine,
>
>  
>
> Try the following:
>
>  
>
> SELECT LISTOF( +  your column + ) into xxx from your_table WHERE …
>
>  
>
> All the items should have single quotes and the comma should be inside the 
> quotes.
>
>  
>
> Javier,
>
>  
>
> Javier Valencia, PE
>
> O: 913-829-0888
>
> H: 913-397-9605
>
> C: 913-915-3137
>
>  
>
> *From:* rba...@googlegroups.com  [mailto:
> rba...@googlegroups.com ] *On Behalf Of *Claudine Robbins
> *Sent:* Friday, October 26, 2018 3:08 PM
> *To:* rba...@googlegroups.com 
> *Subject:* [RBASE-L] - LISTOF question 10.0.4.10913
>
>  
>
> Hello all,
>
>  
>
> My experience with LISTOF is that it automatically puts quotes around 
> fields that contain commas but I’m running into a situation where it does 
> not.
>
>  
>
> One of the fields is YELLOW JACKET CONSTRUCTION, INC., LISTOF returns the 
> space plus INC. as a separate value.  
>
>  
>
> However, it correctly returns 3 for the ITEMCNT variable.
>
>  
>
> What am I overlooking?
>
>  
>
> R>sho v vValueList
>
> YELLOW JACKET CONSTRUCTION, 
>
> INC.,YELLOW JACKET 
>
> OILFIELD,YELLOWHOUSE 
>
> MACHINERY CO.
>
>  
>
> [image: cid:image002.png@01D46D3C.007A56F0]
>
> -- 
> For group guidelines, visit 
> http://www.rbase.com/support/usersgroup_guidelines.php
> --- 
> You received this message because you are subscribed to the Google Groups 
> "RBASE-L" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to rbase-l+u...@googlegroups.com .
> 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] - LISTOF question 10.0.4.10913

[Michael Byerley]

  Good Call Javier...  

On Saturday, October 27, 2018 at 10:53:57 PM UTC-4, javier.valencia wrote:
>
> Claudine,
>
>  
>
> Try the following:
>
>  
>
> SELECT LISTOF( +  your column + ) into xxx from your_table WHERE …
>
>  
>
> All the items should have single quotes and the comma should be inside the 
> quotes.
>
>  
>
> Javier,
>
>  
>
> Javier Valencia, PE
>
> O: 913-829-0888
>
> H: 913-397-9605
>
> C: 913-915-3137
>
>  
>
> *From:* rba...@googlegroups.com  [mailto:
> rba...@googlegroups.com ] *On Behalf Of *Claudine Robbins
> *Sent:* Friday, October 26, 2018 3:08 PM
> *To:* rba...@googlegroups.com 
> *Subject:* [RBASE-L] - LISTOF question 10.0.4.10913
>
>  
>
> Hello all,
>
>  
>
> My experience with LISTOF is that it automatically puts quotes around 
> fields that contain commas but I’m running into a situation where it does 
> not.
>
>  
>
> One of the fields is YELLOW JACKET CONSTRUCTION, INC., LISTOF returns the 
> space plus INC. as a separate value.  
>
>  
>
> However, it correctly returns 3 for the ITEMCNT variable.
>
>  
>
> What am I overlooking?
>
>  
>
> R>sho v vValueList
>
> YELLOW JACKET CONSTRUCTION, 
>
> INC.,YELLOW JACKET 
>
> OILFIELD,YELLOWHOUSE 
>
> MACHINERY CO.
>
>  
>
> [image: cid:image002.png@01D46D3C.007A56F0]
>
> -- 
> For group guidelines, visit 
> http://www.rbase.com/support/usersgroup_guidelines.php
> --- 
> You received this message because you are subscribed to the Google Groups 
> "RBASE-L" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to rbase-l+u...@googlegroups.com .
> 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] - Re: LISTOF question 10.0.4.10913

[Michael Byerley]

We aim to please

On Saturday, October 27, 2018 at 6:10:41 PM UTC-4, crobbins wrote:
>
> Love it!  Works as advertised.  Thanks Mike!
>
>  
>
> *From:* rba...@googlegroups.com  [mailto:
> rba...@googlegroups.com ] *On Behalf Of *Michael Byerley
> *Sent:* Saturday, October 27, 2018 2:37 PM
> *To:* RBASE-L
> *Subject:* Re: [RBASE-L] - Re: LISTOF question 10.0.4.10913
>
>  
>
>
>   OK.  
>
>  
>
>   Here's  a workaround then.  In this Zipfile is an Rbase Form with a 
> UserDefinedListBox that behaves like a Choose.  You will have to change the 
> table, Expression values, and Where clause to suit your needs.  There's a 
> brief remark in the onAfter start EEP.
>
>  
>
>   guaranteed to work..  :)
>
>  
>
> http://www.byerley.net/zipwork/frmCho.zip
>
>  
>
>
>
>
> On Saturday, October 27, 2018 at 12:16:37 PM UTC-4, crobbins wrote:
>
> Thanks Mike, that works fine for the LISTOF command.  
>
>  
>
> However; the name picked in the subsequent CHOOSE command using the 
> vValueList now contains the company name *without the comma* (YELLOW 
> JACKET CONSTRUCTION INC.) so EDI USI COMPANIES WHERE COMPANY_NAME = 
> .VCHOOSE command fails the field match.  
>
>  
>
> I need for YELLOW JACKET CONSTRUCTION, INC. and other names containing 
> commas to be within quotes, like an AS CSV unload, i.e.:
>
>  
>
> SET NULL -0-
>
> OUTPUT test.csv
>
> UNLOAD DATA FOR i_companies USING company_name AS CSV WHERE company_name 
> CONTAINS 'YELLOW'
>
> OUTPUT SCREEN
>
> SET NULL ' '
>
> RBEDIT test.csv
>
> RETURN
>
>  
>
> 'YELLOW JACKET CONSTRUCTION, INC.'
>
> YELLOW JACKET OILFIELD
>
> YELLOWHOUSE MACHINERY CO.
>
>  
>
> Claudine
>
>  
>
> *From:* rba...@googlegroups.com [mailto:rba...@googlegroups.com] *On 
> Behalf Of *Michael Byerley
> *Sent:* Saturday, October 27, 2018 8:57 AM
> *To:* RBASE-L
> *Subject:* [RBASE-L] - Re: LISTOF question 10.0.4.10913
>
>  
>
>  
>
>  
>
> It doesn't.
>
>  
>
> Try this instead:
>
>  
>
>   (listof((srpl(ColumnWithEmbeddedComma,',','',0
>
>  
>
>
>
> On Friday, October 26, 2018 at 4:07:52 PM UTC-4, crobbins wrote:
>
> Hello all,
>
>  
>
> My experience with LISTOF is that it automatically puts quotes around 
> fields that contain commas but I’m running into a situation where it does 
> not.
>
>  
>
> One of the fields is YELLOW JACKET CONSTRUCTION, INC., LISTOF returns the 
> space plus INC. as a separate value.  
>
>  
>
> However, it correctly returns 3 for the ITEMCNT variable.
>
>  
>
> What am I overlooking?
>
>  
>
> R>sho v vValueList
>
> YELLOW JACKET CONSTRUCTION, 
>
> INC.,YELLOW JACKET 
>
> OILFIELD,YELLOWHOUSE 
>
> MACHINERY CO.
>
>  
>
> [image: cid:image002.png@01D46D3C.007A56F0]
>
> -- 
> For group guidelines, visit 
> http://www.rbase.com/support/usersgroup_guidelines.php
> --- 
> You received this message because you are subscribed to the Google Groups 
> "RBASE-L" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to rbase-l+u...@googlegroups.com.
> 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+u...@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] - Re: LISTOF question 10.0.4.10913

[Michael Byerley]

  OK.  
 
  Here's  a workaround then.  In this Zipfile is an Rbase Form with a 
UserDefinedListBox that behaves like a Choose.  You will have to change the 
table, Expression values, and Where clause to suit your needs.  There's a 
brief remark in the onAfter start EEP.

  guaranteed to work..  :)

http://www.byerley.net/zipwork/frmCho.zip




On Saturday, October 27, 2018 at 12:16:37 PM UTC-4, crobbins wrote:
>
> Thanks Mike, that works fine for the LISTOF command.  
>
>  
>
> However; the name picked in the subsequent CHOOSE command using the 
> vValueList now contains the company name *without the comma* (YELLOW 
> JACKET CONSTRUCTION INC.) so EDI USI COMPANIES WHERE COMPANY_NAME = 
> .VCHOOSE command fails the field match.  
>
>  
>
> I need for YELLOW JACKET CONSTRUCTION, INC. and other names containing 
> commas to be within quotes, like an AS CSV unload, i.e.:
>
>  
>
> SET NULL -0-
>
> OUTPUT test.csv
>
> UNLOAD DATA FOR i_companies USING company_name AS CSV WHERE company_name 
> CONTAINS 'YELLOW'
>
> OUTPUT SCREEN
>
> SET NULL ' '
>
> RBEDIT test.csv
>
> RETURN
>
>  
>
> 'YELLOW JACKET CONSTRUCTION, INC.'
>
> YELLOW JACKET OILFIELD
>
> YELLOWHOUSE MACHINERY CO.
>
>  
>
> Claudine
>
>  
>
> *From:* rba...@googlegroups.com  [mailto:
> rba...@googlegroups.com ] *On Behalf Of *Michael Byerley
> *Sent:* Saturday, October 27, 2018 8:57 AM
> *To:* RBASE-L
> *Subject:* [RBASE-L] - Re: LISTOF question 10.0.4.10913
>
>  
>
>  
>
>  
>
> It doesn't.
>
>  
>
> Try this instead:
>
>  
>
>   (listof((srpl(ColumnWithEmbeddedComma,',','',0
>
>  
>
>
>
> On Friday, October 26, 2018 at 4:07:52 PM UTC-4, crobbins wrote:
>
> Hello all,
>
>  
>
> My experience with LISTOF is that it automatically puts quotes around 
> fields that contain commas but I’m running into a situation where it does 
> not.
>
>  
>
> One of the fields is YELLOW JACKET CONSTRUCTION, INC., LISTOF returns the 
> space plus INC. as a separate value.  
>
>  
>
> However, it correctly returns 3 for the ITEMCNT variable.
>
>  
>
> What am I overlooking?
>
>  
>
> R>sho v vValueList
>
> YELLOW JACKET CONSTRUCTION, 
>
> INC.,YELLOW JACKET 
>
> OILFIELD,YELLOWHOUSE 
>
> MACHINERY CO.
>
>  
>
> [image: cid:image002.png@01D46D3C.007A56F0]
>
> -- 
> For group guidelines, visit 
> http://www.rbase.com/support/usersgroup_guidelines.php
> --- 
> You received this message because you are subscribed to the Google Groups 
> "RBASE-L" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to rbase-l+u...@googlegroups.com .
> 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: LISTOF question 10.0.4.10913

[Michael Byerley]

It doesn't.

Try this instead:

  (listof((srpl(ColumnWithEmbeddedComma,',','',0



On Friday, October 26, 2018 at 4:07:52 PM UTC-4, crobbins wrote:
>
> Hello all,
>
>  
>
> My experience with LISTOF is that it automatically puts quotes around 
> fields that contain commas but I’m running into a situation where it does 
> not.
>
>  
>
> One of the fields is YELLOW JACKET CONSTRUCTION, INC., LISTOF returns the 
> space plus INC. as a separate value.  
>
>  
>
> However, it correctly returns 3 for the ITEMCNT variable.
>
>  
>
> What am I overlooking?
>
>  
>
> R>sho v vValueList
>
> YELLOW JACKET CONSTRUCTION, 
>
> INC.,YELLOW JACKET 
>
> OILFIELD,YELLOWHOUSE 
>
> MACHINERY CO.
>
>  
>
> [image: cid:image002.png@01D46D3C.007A56F0]
>

-- 
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] - Re: Convert PDF to JPG

[Michael Byerley]

RBase has many features, absent to one degree or another (at least in the 
perspective of relative ease of access), from many other databases.  

This example is just one of many such features.


On Saturday, September 15, 2018 at 12:55:27 AM UTC-4, rbytes wrote:
>
> Pace, Arthur C. Clarke: "Any technology, sufficiently advanced, is 
> indistinguishable from magic." Wow, Mike. 
>
> Bruce Chitiea 
> Safesectors, Inc. 
>
>
> On 2018-09-14 19:53, Michael Byerley wrote: 
> > Oh, and the same would go for the main exe of the program.  Both can 
> > be stored in the database and written to the db folder and executed 
> > from there.  Windows will search the folder from which an EXE is 
> > 'runned'.. 
> > 
> > On Friday, September 14, 2018 at 5:20:27 PM UTC-4, karen...@cs.com 
> > wrote: 
> > 
> >> I had asked about this over a year ago, but the project was dropped. 
> >> Now it's back on. 
> >> 
> >> I had asked for recommendations of utilities (hopefully free, but 
> >> doesn't have to be) that will convert a 1-page PDF to a JPG.  I need 
> >> it to be a command-line type of thing that will be run from within 
> >> RBase to temporarily copy a PDF to a JPG so that it can be 
> >> incorporated inside an RBase report. 
> >> 
> >> At the time, 2 programs were recommended, ImageMagick and IrfanView. 
> >> However, both of these (with more modern OSs) both need DLLs and 
> >> other programs like GhostScript installed before they'll work.  The 
> >> company doesn't want to have to do this on every workstation, nor do 
> >> they want me installing these other DLLs on their server. 
> >> 
> >> So I'm back to asking if there's other recommendations for an 
> >> all-in-one utility that won't make me install other things, can be 
> >> installed just on the server, and run from a command line.  I have a 
> >> consultant friend whose programmers can probably write a .net 
> >> program for me to do it, but thought I would check here just one 
> >> more time! 
> >> 
> >> Thanks!  Have a great weekend 
> >> 
> >> Karen 
> > 
> >  -- 
> > For group guidelines, visit 
> > http://www.rbase.com/support/usersgroup_guidelines.php 
> > --- 
> > You received this message because you are subscribed to the Google 
> > Groups "RBASE-L" group. 
> > To unsubscribe from this group and stop receiving emails from it, send 
> > an email to rbase-l+u...@googlegroups.com . 
> > 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: Convert PDF to JPG

[Michael Byerley]

Oh, and the same would go for the main exe of the program.  Both can be 
stored in the database and written to the db folder and executed from 
there.  Windows will search the folder from which an EXE is 'runned'..



On Friday, September 14, 2018 at 5:20:27 PM UTC-4, karen...@cs.com wrote:
>
> I had asked about this over a year ago, but the project was dropped.  Now 
> it's back on.
>
> I had asked for recommendations of utilities (hopefully free, but doesn't 
> have to be) that will convert a 1-page PDF to a JPG.  I need it to be a 
> command-line type of thing that will be run from within RBase to 
> temporarily copy a PDF to a JPG so that it can be incorporated inside an 
> RBase report.
>
> At the time, 2 programs were recommended, ImageMagick and IrfanView.  
> However, both of these (with more modern OSs) both need DLLs and other 
> programs like GhostScript installed before they'll work.  The company 
> doesn't want to have to do this on every workstation, nor do they want me 
> installing these other DLLs on their server.
>
> So I'm back to asking if there's other recommendations for an all-in-one 
> utility that won't make me install other things, can be installed just on 
> the server, and run from a command line.  I have a consultant friend whose 
> programmers can probably write a .net program for me to do it, but thought 
> I would check here just one more time!
>
> Thanks!  Have a great weekend
>
> Karen
>
>

-- 
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: Convert PDF to JPG

[Michael Byerley]

Karen,
  You can store the DLL as a varbit in RBase and unfurl it to the database 
directory or the directory in which your program operates, which will put 
it in the normal windows search path.  Doesn't have to be installed to each 
local machine.



On Friday, September 14, 2018 at 5:20:27 PM UTC-4, karen...@cs.com wrote:
>
> I had asked about this over a year ago, but the project was dropped.  Now 
> it's back on.
>
> I had asked for recommendations of utilities (hopefully free, but doesn't 
> have to be) that will convert a 1-page PDF to a JPG.  I need it to be a 
> command-line type of thing that will be run from within RBase to 
> temporarily copy a PDF to a JPG so that it can be incorporated inside an 
> RBase report.
>
> At the time, 2 programs were recommended, ImageMagick and IrfanView.  
> However, both of these (with more modern OSs) both need DLLs and other 
> programs like GhostScript installed before they'll work.  The company 
> doesn't want to have to do this on every workstation, nor do they want me 
> installing these other DLLs on their server.
>
> So I'm back to asking if there's other recommendations for an all-in-one 
> utility that won't make me install other things, can be installed just on 
> the server, and run from a command line.  I have a consultant friend whose 
> programmers can probably write a .net program for me to do it, but thought 
> I would check here just one more time!
>
> Thanks!  Have a great weekend
>
> Karen
>
>

-- 
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: RBase on Linux

[Michael Byerley]

If you remember, Opportunistic record locking was an issue back in the days 
of Windows NT and required changing (in some cases adding) a registry 
setting to disable it. One  Microsoft support article that shows how to 
disable it or to tune it to a particular need:

https://support.microsoft.com/en-us/help/296264/configuring-opportunistic-locking-in-windows



On Wednesday, May 16, 2018 at 8:49:08 PM UTC-4, karen...@cs.com wrote:
>
> I am posting for a friend who is not active on this list.
>
> Has anyone here run RBase X/XE on a Linux server?  Specifically locating 
> the database there, perhaps also the RBase executables.  They are willing 
> to pay someone for their time if setting up such an arrangement is 
> possible.   If you like, you may contact me off-list to discuss specifics.
>
> Thanks!!!(PS: might not be on the list much Thursday, so be patient if 
> I don't respond)
>
> Karen
>
>

-- 
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: Announcement - R:BASE Technologies' 20th Anniversary Conference

[Michael Byerley]

Looking forward to seeing friends, Old and New.. 

On Wednesday, May 16, 2018 at 3:00:06 PM UTC-4, A. Razzak Memon wrote:
>
> Wednesday, May 16, 2018 (3:00 PM Eastern Time) 
>
> Dear R:BASE Community, 
>
> I am ecstatic to finally share this news! 
>
> For the 20th Anniversary of R:BASE Technologies, Inc., we are 
> celebrating an R:BASE 
> Conference in October 2018 in Las Vegas, Nevada! 
>
> And, on Saturday, October, 20, 2018, we will be officially unveiling 
> the release 
> of R:BASE X.5/X.5 Enterprise (Version 10.5)! 
>
> All are urged to "save the date" and join us in celebrating "the 20th 
> on the 20th!" 
>
> Festivities will be held for this landmark occasion at the remarkable 
> South Point 
> Hotel Casino and Spa: https://southpointcasino.com 
>
> The growth we've experienced over the years is because of a superior 
> community of 
> R:BASE users, who unwaveringly support us! 
>
> Please stay tuned for more details ... 
> http://www.rbase.com/conference 
>
> We hope to see you all in Las Vegas! 
>
> Razzak. 
>
> A. Razzak Memon 
> Founder, President & CEO 
> R:BASE Technologies, Inc. 
> http://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.
For more options, visit https://groups.google.com/d/optout.

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

[Michael Byerley]

  or you could use this that is an RBase Form that I wrote many years ago 
and is still working reliably today.  It allows for the Seeding of  
Caption, Return Variable Name, and the Date for the initial display. This 
is the Calling EEP:

*( Display calendar with:
  [Manditory]Caption = "Pick A Date"
  [Manditory]vRetDate = "NameOfReturnVariable"
  [Optional] 01/06/2002 = "TheSeedDateForInitialDisplay"
 When Seed Date is ommitted, the Current Date is Defaulted
  Note: 1. The return value is of type text, but you can edit the onExit EEP
   of the form to change the return type as Date if you wish
 )
EDIT USING rbcalendar CAPTION 'Pick A Date,vRetDate,06/15/2005'
SET VAR vmsg = ('You Picked' & .vretdate)
PAUSE 2 USING .vmsg
CLEAR VAR vmsg
RETURN


 Link: 
http://byerley.net/(S(icmtnu55gv5e0345l3hfhrio))/Download_A/RbCalendar.zip


On Tuesday, April 17, 2018 at 1:20:46 AM UTC-4, kkleinman wrote:
>
> I often need to get dates from users before I run a report or form. Is 
> there a way to build a dialog that gives a date chooser similar to what you 
> can do in a form, without  having to create a form for it?
>
> Thanks!
>
>  
>
>  
>
> Kayza Kleinman
>
> Director of the Nonprofit Helpdesk 
>
> CIO
>
> *Jewish Community Council of Greater Coney Island, Inc*
>
> 3001 West 37th Street
>
> Brooklyn NY 11224
>
> 718 449-5000 x 2266
>
> fax 347-946-6390 
>
> www.jccgci.org
>
> www.nphd.org
>
>  
>
>  
>

-- 
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] - Developer Needed for DOS 7.5/9.5 Conversion to RBase X

[Michael]

I am in need of an experienced developer to convert or recreate about a 
dozen key DOS 7.5/9.5 forms & reports to Rbase X, followed by occasional 
tutoring on RB Windows techniques. If interested, please contact me 
directly at f00f4...@opayq.com (valid but masked email). Our need is 
immediate tho completion can occur in 2018.

Michael Dean, Fine Games, North Bend OR

-- 
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: previous

[Michael Byerley]

Sorry, I meant to include that for your instance it would be:

CHOOSE vDB FROM #DATABASE

On Sunday, October 8, 2017 at 1:56:33 PM UTC-4, alb969 wrote:
>
> I owe the DUH fund at least $5 
>
> CHOOSE FROM #LFILES IN *.rx1 …… 
>
> Albert

-- 
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: previous

[Michael Byerley]

Hi Albert,
  Remember All of these Oldies:

*(   In R:BASE 3.1, you can choose a file from a list of files when you
  )
*(  want to execute a disk function. By using the undocumented feature  
 )
*(   described in this article, you can add this functionality to your  
 )
*(   applications. All you need to do is use a special keyword option such  
 )
*(   as #DRIVES, #DIR, or #LFILES in a pop-up or check box menu file.  
  )
*(  
 )
*(   The special options, referred to as pound puppies, make the menu  
  )
*(   dynamic--they pull current information from the computer or from the  
  )
*(   currently open database as appropriate. Use the following commands in  
 )
*(   your application to create the dynamic menu, replacing #PUPPY with 
the  )
*(   actual option you want to use.
  )

 OUTPUT filename.$$$
 WRITE 'Title'
 WRITE 'POPUP |Choose from this list.|'
 WRITE '#puppy'
 OUTPUT SCREEN

*(   After creating the menu, use the CHOOSE command to prompt the user to  
 )
*(   choose from the list. For example, you might use this CHOOSE:  
 )
*(  
 )
 CHOOSE vfile FROM filename.$$$ AT 5,10 CLEAR  
 
*(  
 )
*(   If you prefer, you can also create check box menus by changing POPUP  
  )
*(   on the third line to CHKBOX
 )
*(  
 )
*(  
 )
*(   Examples  
  )
*(     
  )
*(   This example uses #LFILES to list the files in the current directory:  
 )
*(  
 )
 OUTPUT f.$$$
 WRITE 'Title'
 WRITE 'POPUP |Choose a file.|'
 WRITE '#LFILES'
 OUTPUT SCREEN
 CHOOSE vfile FROM f.$$$ AT 5,10 CLEAR

*(   To list files with a specific extension such as .TXT, include the  
 )
*(   extension following #LFILES, as in this example:  
  )
*(  
 )
 OUTPUT f.$$$
 WRITE 'Title'
 WRITE 'POPUP |Choose a file.|'
 WRITE '#LFILES TXT'
 OUTPUT SCREEN
 CHOOSE vfile FROM f.$$$ AT 5,10 CLEAR
*(  
 )
*(   Include only the extension, not the period (TXT not .TXT). The file
 )
*(   names show up in the menu without the extension (MYDOC not 
MYDOC.TXT).  )
*(  
 )
*(   To enable the user to choose multiple files at the same time, use a
 )
*(   check box menu instead of a pop-up menu, as in this example:  
  )
*(  
 )
 OUTPUT f.$$$
 WRITE 'Title'
 WRITE 'CHKBOX |Choose several files.|'
 WRITE '#LFILES'
 OUTPUT SCREEN
 CHOOSE vfile FROM f.$$$ AT 5,10 CLEAR
*(  
 )
*(  
 )
*(   All the Puppies
 )
*(   """
 )
*(   Here's a complete list of all the pound puppies you can use in pop-up  
 )
*(   and check box menu files.  
 )
*(  
 )
*( []  #LFILES--List all the files in the current directory.
 )
*( []  #LFILES ext--List just the file names (not the extensions) of
 )
*( the files in the current directory that have the extension  
  )
*( specified.  
  )
*( []  #DRIVES--List all accessible drives on the computer including
 )
*( network drives. The current drive is included in the list but
 )
*( it's gray to prevent the user from choosing it.  
 )
*( []  #DIR--List all the subdirectories in the current directory and  
  )
*( includes an option for Parent Directory if there is one. The
  )
*( current directory is included in the list but it's gray to  
  )
*( prevent the user from choosing it.  
  )
*( []  #TABLES--List all the tables in the currently open database.
  )
*( []  #RBASE--List all the R:BASE tables in the currently open
  

[RBASE-L] - Re: Trying to figure out IFF command

[Michael Byerley]

If nulls are to be evaluated in your expressions, you need to set ZERO ON:

Syntax: SET ZERO ON/OFF

 

Default: OFF

 

SET ZERO allows a null to be treated as a zero in a mathematical expression 
involving INTEGER, NUMERIC, REAL, DOUBLE, CURRENCY, DATE, DATETIME, or TIME 
data types. With ZERO set on, R:BASE returns a negative number when you 
subtract an integer from a null. With ZERO set off, the same computation 
results in a null. R:BASE stores the setting with the database.

Otherwise your expression will fail unless you are evaluating for a NULL 
condition as in using IFNULL.

 


On Monday, September 25, 2017 at 2:58:21 PM UTC-4, Patti Jakusz wrote:
>
> Hello,
>
>
>
> I'm using Rbase X and creating a new report.
>
> I have a field in my database, that can have a value of 0,1,2,3,4,5,7 or 
> 8.  If it has a value of 3,4 or 5, I want a checkbox to be checked.  So I'm 
> trying to use this new (new to me) command IFF.
>
> I set a report variable (var1) = to the field in the database.  (I tried 
> using just the field name, and that didn't work either.)
> Then another variable var2 = (iff(('.var1>2 and .var1<6'),1,0))
>
>
> The definition of IFF says you can use "and", but then Rbase doesn't like 
> it.
>
> *(IFF((condition),arg1,arg2))*
>
> *The condition must list a set of conditions that combine to form a 
> statement that is either true or false. Conditions can be combined with the 
> connecting operators AND, OR, AND NOT, and OR NOT.  *
>
> but then it further states:
> *It is important to note that the condition needs to be a single item, 
> which is why quotes are used in the examples below. *
>
> *???*
>
> I get the following errors:
> Constant cannot be followed by a column/variable
>
> If I add more quotation marks '.var1>2' and '.var1<6'
> then I get the following error: Nulls cannot be used in comparisons other 
> than NE or EQ
>
> What am I doing wrong?
> Thank you,
> Patti
>
>
>

-- 
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: Trying to figure out IFF command

[Michael Byerley]

Sorry. Explain: Enclose each comparison in its own parentheses so it 
evaluates properly.  Order precedence.  Then the two expressions evaluate 
within their own parentheses within the quotations.

On Monday, September 25, 2017 at 2:58:21 PM UTC-4, Patti Jakusz wrote:
>
> Hello,
>
>
>
> I'm using Rbase X and creating a new report.
>
> I have a field in my database, that can have a value of 0,1,2,3,4,5,7 or 
> 8.  If it has a value of 3,4 or 5, I want a checkbox to be checked.  So I'm 
> trying to use this new (new to me) command IFF.
>
> I set a report variable (var1) = to the field in the database.  (I tried 
> using just the field name, and that didn't work either.)
> Then another variable var2 = (iff(('.var1>2 and .var1<6'),1,0))
>
>
> The definition of IFF says you can use "and", but then Rbase doesn't like 
> it.
>
> *(IFF((condition),arg1,arg2))*
>
> *The condition must list a set of conditions that combine to form a 
> statement that is either true or false. Conditions can be combined with the 
> connecting operators AND, OR, AND NOT, and OR NOT.  *
>
> but then it further states:
> *It is important to note that the condition needs to be a single item, 
> which is why quotes are used in the examples below. *
>
> *???*
>
> I get the following errors:
> Constant cannot be followed by a column/variable
>
> If I add more quotation marks '.var1>2' and '.var1<6'
> then I get the following error: Nulls cannot be used in comparisons other 
> than NE or EQ
>
> What am I doing wrong?
> Thank you,
> Patti
>
>
>

-- 
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: Trying to figure out IFF command

[Michael Byerley]

(iff( '((.var1>2) and (.var1>6))',1,0))

On Monday, September 25, 2017 at 2:58:21 PM UTC-4, Patti Jakusz wrote:
>
> Hello,
>
>
>
> I'm using Rbase X and creating a new report.
>
> I have a field in my database, that can have a value of 0,1,2,3,4,5,7 or 
> 8.  If it has a value of 3,4 or 5, I want a checkbox to be checked.  So I'm 
> trying to use this new (new to me) command IFF.
>
> I set a report variable (var1) = to the field in the database.  (I tried 
> using just the field name, and that didn't work either.)
> Then another variable var2 = (iff(('.var1>2 and .var1<6'),1,0))
>
>
> The definition of IFF says you can use "and", but then Rbase doesn't like 
> it.
>
> *(IFF((condition),arg1,arg2))*
>
> *The condition must list a set of conditions that combine to form a 
> statement that is either true or false. Conditions can be combined with the 
> connecting operators AND, OR, AND NOT, and OR NOT.  *
>
> but then it further states:
> *It is important to note that the condition needs to be a single item, 
> which is why quotes are used in the examples below. *
>
> *???*
>
> I get the following errors:
> Constant cannot be followed by a column/variable
>
> If I add more quotation marks '.var1>2' and '.var1<6'
> then I get the following error: Nulls cannot be used in comparisons other 
> than NE or EQ
>
> What am I doing wrong?
> Thank you,
> Patti
>
>
>

-- 
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: send keystroke

[Michael Byerley]

Razzak,

  RBase DOS PlayBack function had more than one use, as I recall  :)

On Tuesday, August 22, 2017 at 6:01:20 PM UTC-4, dang wrote:
>
> I need to send a keystroke to the pc but forgot how to do it.
>
>  
>
> I need to send a ctrl-F12 to the pc.
>
>  
>
> TIA
>
>  
>
> Dan Goldberg
>
>  
>

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

[RBASE-L] - Re: send keystroke

[Michael Byerley]

There is a hook procedure running in the other program.  I expect you are 
going to have to use windows SendMessage function to produce the Ctrl[F12] 
sequence. Since it's a hook procedure, I suppose it's not going to be fussy 
about the target since it's evaluating all keystrokes looking for the 
Ctrl[F12].

I would begin by getting the handle of the window in which the text is 
highlighted and use that as the target of the sendmessage function.

This would of course require the use of DLCall to enable such action.



On Tuesday, August 22, 2017 at 6:01:20 PM UTC-4, dang wrote:
>
> I need to send a keystroke to the pc but forgot how to do it.
>
>  
>
> I need to send a ctrl-F12 to the pc.
>
>  
>
> TIA
>
>  
>
> Dan Goldberg
>
>  
>

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

[RBASE-L] - Re: send keystroke

[Michael Byerley]

Dan,

  It is anything but clear where or what the target is.  

On Tuesday, August 22, 2017 at 6:01:20 PM UTC-4, dang wrote:
>
> I need to send a keystroke to the pc but forgot how to do it.
>
>  
>
> I need to send a ctrl-F12 to the pc.
>
>  
>
> TIA
>
>  
>
> Dan Goldberg
>
>  
>

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

[RBASE-L] - Re: Tip of the Day: Multiple Object Editing for Object Inspector Toolbar

[Michael Byerley]

That is a very helpful addition.. Not that any others were lacking.  :)


On Wednesday, August 23, 2017 at 8:22:02 AM UTC-4, A. Razzak Memon wrote:
>
> Wednesday, August 23, 2017 
>
> Tip of the Day: Multiple Object Editing for Object Inspector Toolbar 
> Product...: R:BASE X and R:BASE X Enterprise (Version 10) 
> Build.: 10.0.2.20731 or higher 
> Section...: Forms 
> Keywords..: Object Inspector, Form Designer, Properties 
>
> Did you know the Object Inspector can be used to alter the common 
> properties 
> for multiple selected controls? 
>
> The Object Inspector has been enhanced with multi-select support, where 
> when 
> multiple objects are selected, the common properties can be altered in the 
> Object Inspector. The new property value applied will be set for all 
> selected 
> controls. 
>
> The Object Inspector toolbar is a dynamic display utility for any selected 
> control. It provides easier direct access to all properties and Entry/Exit 
> Procedures (EEPs) for the particular selected control(s) within the Form 
> Designer. 
>
> http://www.razzak.com/tips/TB_ObjectInspector.jpg 
>
> http://www.razzak.com/tips/TB_ObjectInspector_EEPs.jpg 
>
> One of the most important aspects in business growth is your company's 
> data, 
> and no one else has more invested in your success than R:BASE 
> Technologies. 
> Invest forward with R:BASE! 
>
> Very Best R:egards, 
>
> Razzak. 
>
> www.rbase.com 
> 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.
For more options, visit https://groups.google.com/d/optout.

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

[Michael Byerley]

Probably just dumb luck Claudine.. :)


On Thursday, August 17, 2017 at 10:01:32 AM UTC-4, dbg wrote:
>
> Simple problem. Old fashioned. This just calculates a 10% tax except when 
> less is levied or sometimes zero. Simple but doesn’t work anymore. Nothing 
> happens. Gst is not updated. How should I re-write it?
>
>  
>
>  
>
> EEP
>
> *(calc_gst)
>
> *(Y = 10% gst, N = 0 gst, X = manual gst entry)
>
>  
>
> SET VAR vgst1 = .CGST
>
> SET VAR vcamt = .CAmt
>
> SET VAR vynx = .GstYN
>
> SET VAR vgst = 0
>
> SWITCH (.vynx)
>
>   CASE 'Y'
>
> SET VAR vgst = (.vcamt/11)
>
> BREAK
>
>   CASE 'N'
>
> SET VAR vgst = 0
>
> BREAK
>
>   CASE 'X'
>
> SET VAR vgst = .vgst1
>
> BREAK
>
> ENDSW
>
>  
>
> INSERT INTO Costs (CGst) VALUES (.vgst)
>
>  
>
> RECALC VARIABLES
>
> RETURN
>
>  
>
> *Drake-Brockman Geoinfo Pty Ltd*
>
>
>
>
> * 404 Great Eastern Highway Woodbridge, Perth, WA, Australia, 6056Tel +61 
> 8 9274 5477 Mob +61427 525952 Email d...@dbgeoinfo.net.au *
>
> *Web www. dbgeoinfo.net.au *
>
> *Dropbox URL:  https://www.hightail.com/u/DBGEOINFO 
> *
>
>  
>

-- 
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: This worked previously as a on click eep but not now under version X

[Michael Byerley]

 

INSERT does not use a Where clause UNLESS there is a qualifying SELECT 
[which would base criteria on an entirely different table or condition to 
limit whether the insert is to be done or not]

INSERT does just one thing by itself. it adds a row of data.




On Thursday, August 17, 2017 at 10:01:32 AM UTC-4, dbg wrote:
>
> Simple problem. Old fashioned. This just calculates a 10% tax except when 
> less is levied or sometimes zero. Simple but doesn’t work anymore. Nothing 
> happens. Gst is not updated. How should I re-write it?
>
>  
>
>  
>
> EEP
>
> *(calc_gst)
>
> *(Y = 10% gst, N = 0 gst, X = manual gst entry)
>
>  
>
> SET VAR vgst1 = .CGST
>
> SET VAR vcamt = .CAmt
>
> SET VAR vynx = .GstYN
>
> SET VAR vgst = 0
>
> SWITCH (.vynx)
>
>   CASE 'Y'
>
> SET VAR vgst = (.vcamt/11)
>
> BREAK
>
>   CASE 'N'
>
> SET VAR vgst = 0
>
> BREAK
>
>   CASE 'X'
>
> SET VAR vgst = .vgst1
>
> BREAK
>
> ENDSW
>
>  
>
> INSERT INTO Costs (CGst) VALUES (.vgst)
>
>  
>
> RECALC VARIABLES
>
> RETURN
>
>  
>
> *Drake-Brockman Geoinfo Pty Ltd*
>
>
>
>
> * 404 Great Eastern Highway Woodbridge, Perth, WA, Australia, 6056Tel +61 
> 8 9274 5477 Mob +61427 525952 Email d...@dbgeoinfo.net.au *
>
> *Web www. dbgeoinfo.net.au *
>
> *Dropbox URL:  https://www.hightail.com/u/DBGEOINFO 
> *
>
>  
>

-- 
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: Embedding PDF in a report

[Michael Byerley]

In Irfanview helpfile:
/convert=filename -save/convert input image(s)/file(s) to 
"filename" and CLOSE IrfanView 

  (see Pattern page for additional filename options)


So it appears you could automate conversion.  Irfanview has been in the 
wild for a very long time and is a free download: http://www.irfanview.com/

On Thursday, June 15, 2017 at 1:48:44 PM UTC-4, karen...@cs.com wrote:
>
> Unless something has changed lately, I know you cannot place a
> PDF inside an RBase report, like you can a JPG.  (I don't want a link,
> I want the actual one-page PDF)
>
> My notes say that the solution is to convert the PDF to a JPG, but
> I have no examples or recommendations of programs. Has anyone
> used a free, easy to install program to convert a PDF to a JPG?
> I am going to want to have RBase do the conversion "on the fly"
> when a report is requested with no intervention from the user.  
>
> I am going to design a report with data info on the 1st page and the 
> PDF file printed as the second page, *duplexed*.  That's why I can't just
> print the PDF directly, following the report.
>
> Everyone has a full version of Adobe on their computers, so if there's
> a way to automatically launch Adobe with a conversion parameter
> that'd be great.
>
> Thanks for any help!
>
> 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.
For more options, visit https://groups.google.com/d/optout.

[RBASE-L] - Re: Embedding PDF in a report

[Michael Byerley]

ahh... I have been using Irfanview for my Image viewer for so long, I just 
assumed the graphic (which is what a basic PDF is, along with control codes 
for the embedded fonts, etc) displayed the same in any viewer.  Apparently 
Irfanview figures out the graphic portion and displays it.  I renamed a 
dozen different pdf that are on my desktop with the same results, the ALL 
open as a graphic in Irfanview.



On Thursday, June 15, 2017 at 1:48:44 PM UTC-4, karen...@cs.com wrote:
>
> Unless something has changed lately, I know you cannot place a
> PDF inside an RBase report, like you can a JPG.  (I don't want a link,
> I want the actual one-page PDF)
>
> My notes say that the solution is to convert the PDF to a JPG, but
> I have no examples or recommendations of programs. Has anyone
> used a free, easy to install program to convert a PDF to a JPG?
> I am going to want to have RBase do the conversion "on the fly"
> when a report is requested with no intervention from the user.  
>
> I am going to design a report with data info on the 1st page and the 
> PDF file printed as the second page, *duplexed*.  That's why I can't just
> print the PDF directly, following the report.
>
> Everyone has a full version of Adobe on their computers, so if there's
> a way to automatically launch Adobe with a conversion parameter
> that'd be great.
>
> Thanks for any help!
>
> 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.
For more options, visit https://groups.google.com/d/optout.

[RBASE-L] - Re: Embedding PDF in a report

[Michael Byerley]

Hey Karen,

  Try renaming a PDF file to Filename.jpg and see what you get... :)


On Thursday, June 15, 2017 at 1:48:44 PM UTC-4, karen...@cs.com wrote:
>
> Unless something has changed lately, I know you cannot place a
> PDF inside an RBase report, like you can a JPG.  (I don't want a link,
> I want the actual one-page PDF)
>
> My notes say that the solution is to convert the PDF to a JPG, but
> I have no examples or recommendations of programs. Has anyone
> used a free, easy to install program to convert a PDF to a JPG?
> I am going to want to have RBase do the conversion "on the fly"
> when a report is requested with no intervention from the user.  
>
> I am going to design a report with data info on the 1st page and the 
> PDF file printed as the second page, *duplexed*.  That's why I can't just
> print the PDF directly, following the report.
>
> Everyone has a full version of Adobe on their computers, so if there's
> a way to automatically launch Adobe with a conversion parameter
> that'd be great.
>
> Thanks for any help!
>
> 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.
For more options, visit https://groups.google.com/d/optout.

[RBASE-L] - Re: Rbase

[Michael Byerley]

Of course, we had the RBase structured "In The Black" that was around for a 
short period.  

Anyone remember the Developer Password for the database?  :)   

Yeah, just another useless piece of info that occupies precious remaining 
space in my head.



On Thursday, May 11, 2017 at 12:48:18 PM UTC-4, dick wrote:
>
> It might take a little more work up front, but for 30 years we have been 
> running our multi-million dollar business totally from R:base. 
> No peachtree, No Quickbooks.   We do everything in R:Base. Accounting, 
> Payroll, Sales, everything.  Even print customers Fax checks. 
> No outside problems to deal with. 
>
> Dick Fey 
>
> -- 
> Carpet Broker Inc 
> P: 913-894-9211 
> F: 913-894-0138 
>
>
>

-- 
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] - Can not connect to database "ERROR"

[michael]

It was a network issue. Windows 10 updates caused an issue with "Write 
Permissions"

Thank you Dan, and thank you Razzak for the help. 

On Wednesday, May 10, 2017 at 6:40:09 PM UTC-5, michael wrote:
>
> Are you talking about users of the network, or users and passwords in 
> Rbase?
>
> Michael Brookes
> Maxima Enterprises
> 37 NE 29th Street
> Oklahoma City, OK. 73105
> 405-525-8899
> 405-525-5329 Faxwww.maximaonline.com
>
> On 5/10/2017 6:35 PM, A. Razzak Memon wrote:
>
> Michael, 
>
> Check the user access and privileges of all users using those computers on 
> the network. 
>
> They all need full access (Read/Write) to the folder with R:BASE database, 
> etc. 
>
> Hope that provides you with some blue's clues ... 
>
> Very Best R:egards, 
>
> Razzak 
>
>
> At 07:18 PM 5/10/2017, michael wrote: 
>
> I have a single seat, and a 5 seat addon, and as of today, when I try to 
> access the database from any computer in the network other than the 
> computer that the database resides on, I get the following message. 
>
> "The database is currently unavailable- It is probably open with MULTI set 
> OFF" 
>
> I have not changed any setting from when it was working properly for Many 
> years and continued up updating, and I am currently using Rbase X, and have 
> been for over a year. I do not have the most current update. My 1 year ran 
> out 2 days before the last update. 
>
> I disconnected all databases, and I "Set Multi On" several times. Even set 
> it off and back on a number of times. 
>
> Its not a network problem, because I can see all of the directories and 
> the files on the server computer. but the database will not connect. After 
> the error, the application loads, but no data. 
>
> Please help... My employees will not be able to work tomorrow morning 
> without the database running. 
>
> -- 
> 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>rbase-l+unsubscr...@googlegroups.com
> .
> For more options, visit <https://groups.google.com/d/optout> 
> <https://groups.google.com/d/optout>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] - Can not connect to database "ERROR"

[Michael Brookes]

I have never had any users listed. This just started today. I don't even 
have a user set for myself on the server computer. "Which is just a 
computer that is networked with all the others".. Not Workgroup, but 
networked.


Michael Brookes
Maxima Enterprises
37 NE 29th Street
Oklahoma City, OK. 73105
405-525-8899
405-525-5329 Fax
www.maximaonline.com

On 5/10/2017 6:35 PM, A. Razzak Memon wrote:

Michael,

Check the user access and privileges of all users using those 
computers on the network.


They all need full access (Read/Write) to the folder with R:BASE 
database, etc.


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

Very Best R:egards,

Razzak


At 07:18 PM 5/10/2017, michael wrote:

I have a single seat, and a 5 seat addon, and as of today, when I try 
to access the database from any computer in the network other than 
the computer that the database resides on, I get the following message.


"The database is currently unavailable- It is probably open with 
MULTI set OFF"


I have not changed any setting from when it was working properly for 
Many years and continued up updating, and I am currently using Rbase 
X, and have been for over a year. I do not have the most current 
update. My 1 year ran out 2 days before the last update.


I disconnected all databases, and I "Set Multi On" several times. 
Even set it off and back on a number of times.


Its not a network problem, because I can see all of the directories 
and the files on the server computer. but the database will not 
connect. After the error, the application loads, but no data.


Please help... My employees will not be able to work tomorrow morning 
without the database running.


--
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.




--
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] - Can not connect to database "ERROR"

[Michael Brookes]

Yes I can...


Michael Brookes
Maxima Enterprises
37 NE 29th Street
Oklahoma City, OK. 73105
405-525-8899
405-525-5329 Fax
www.maximaonline.com

On 5/10/2017 6:23 PM, Dan Goldberg wrote:


Can you open two rbase sessions to the same database on the computer 
that has the database?


Dan

*From:* rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] *On 
Behalf Of *michael

*Sent:* Wednesday, May 10, 2017 4:19 PM
*To:* RBASE-L <rbase-l@googlegroups.com>
*Subject:* [RBASE-L] - Can not connect to database "ERROR"

I have a single seat, and a 5 seat addon, and as of today, when I try 
to access the database from any computer in the network other than the 
computer that the database resides on, I get the following message.


"The database is currently unavailable- It is probably open with MULTI 
set OFF"


I have not changed any setting from when it was working properly for 
Many years and continued up updating, and I am currently using Rbase 
X, and have been for over a year. I do not have the most current 
update. My 1 year ran out 2 days before the last update.


I disconnected all databases, and I "Set Multi On" several times. Even 
set it off and back on a number of times.


Its not a network problem, because I can see all of the directories 
and the files on the server computer. but the database will not 
connect. After the error, the application loads, but no data.


Please help... My employees will not be able to work tomorrow morning 
without the database running.


--
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.




AVG logo <http://www.avg.com/internet-security>   

This email has been checked for viruses by AVG antivirus software.
www.avg.com <http://www.avg.com/internet-security>


<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
--
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] - Can not connect to database "ERROR"

[michael]

I have a single seat, and a 5 seat addon, and as of today, when I try to 
access the database from any computer in the network other than the 
computer that the database resides on, I get the following message.

"The database is currently unavailable- It is probably open with MULTI set 
OFF"

I have not changed any setting from when it was working properly for Many 
years and continued up updating, and I am currently using Rbase X, and have 
been for over a year. I do not have the most current update. My 1 year ran 
out 2 days before the last update. 

I disconnected all databases, and I "Set Multi On" several times. Even set 
it off and back on a number of times.

Its not a network problem, because I can see all of the directories and the 
files on the server computer. but the database will not connect. After the 
error, the application loads, but no data.

Please help... My employees will not be able to work tomorrow morning 
without the database running.

-- 
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: Quickbooks

[Michael Byerley]

I didn't look at the under the cover nuances of this ODBC driver for 
Quickbooks, but maybe it's something..

  http://qodbc.com/



On Thursday, May 4, 2017 at 1:17:10 PM UTC-4, karen...@cs.com wrote:
>
> It's been decades since I've had to deal with Quickbooks, and it wasn't 
> exactly a joy back then...
>
> Someone just asked me about sending stuff from RBase into Quickbooks (they 
> do not own QB yet, so it would be a new version of the software).
>
> Has anyone here used a new version of QB and let me know if it's easier 
> nowadays to send data to QB?  For example, what kind of formats does it 
> accept as an import?  Any gotchas?   We'd probably be sending over lists of 
> "members" (name, address, etc), and different kinds of revenues received 
> (member fees, special fees, event fees)
>
> Thanks for any insight!
>
> 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.
For more options, visit https://groups.google.com/d/optout.

[RBASE-L] - Re: From The Edge: Converting R:BASE for DOS to R:BASE X/XE for Windows

[Michael Byerley]

As an aid in converting legacy code that is still in *.APP form, I have a 
stand alone EXE that I wrote many years ago that will open the *.APP file 
and allow you to save One or All the command blocks to individual disk 
files.

I wrote an RBL version that worked from within RBase, but it no longer 
works with the current versions and I am insufficiently motivated to fix 
it..   :)

I know John has used this app for many years and it is a time saver during 
the conversion process. 

Here's the Zipper with the app and the helpfile: 
www.byerley.net/Download_B/RAppSplit.zip


On Friday, May 5, 2017 at 12:05:42 AM UTC-4, A. Razzak Memon wrote:
>
> Friday, May 5, 2017 
>
>  From the Edge: Converting R:BASE for DOS to R:BASE X/XE for Windows 
> Version: R:BASE X and R:BASE X Enterprise (Version 10) 
> Section: Upgrading from R:BASE for DOS to R:BASE for Windows 
>
> As you all know, DOS applications are being phased out and are no longer 
> supported on the latest Microsoft operating systems. 
>
> If you are still using R:BASE for DOS, and if you don't have a plan in 
> place 
> for yourself, your employer, your clients who are paying your bills to 
> help 
> you make a good living using R:BASE, now is the time to take the 
> initiative 
> and convert/migrate to 100% R:BASE for Windows applications. 
>
> With the built-in tools and automated conversion capabilities of R:BASE X 
> and R:BASE X Enterprise (Version 10), many users are migrating their 
> legacy 
> DOS databases and applications. 
>
> To help you all understand all necessary steps and techniques, an updated 
> "DOS to Windows Database Conversion Guide (R:BASE X and R:BASE X 
> Enterprise)" 
> has been made available to streamline the entire process of conversion. 
>
> Topics in the document cover the conversion of database files, forms, 
> reports, labels, command syntax, and the applications. 
>
>  From The Edge: http://www.razzak.com/fte/ 
> Article Title: 
> DOS to Windows Database Conversion Guide (R:BASE X and R:BASE X 
> Enterprise) 
>
> Have fun! 
>
> Very Best R:egards, 
>
> Razzak. 
> www.rbase.com 
> www.facebook.com/rbase 
> -- 
> 34 years of continuous innovation! 
> 19 Years of R:BASE Technologies, Inc. making R:BASE what it is today! 
> -- 
>
>

-- 
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: Tip of the Day: Running Highlighted Code in R:BASE Editor

[Michael Byerley]

That's darn handy... :)

On Monday, April 17, 2017 at 12:01:38 AM UTC-4, A. Razzak Memon wrote:
>
> Monday, April 17, 2017 
>
> Tip of the Day: Running Highlighted Code in R:BASE Editor 
> Product...: R:BASE X/X Enterprise (Version 10) 
> Build.: 10.0.2.20411 or higher 
> Section...: R:BASE Editor 
> Keywords..: Coding, Programming, Run, Command 
>
> Did you know that you can run a highlighted/selected block of code in 
> the R:BASE Editor? 
>
> The new functionality is extremely helpful, especially if the 
> specific code is in the 
> middle (or end) of a command file and you don't want to run the 
> entire routine from the 
> beginning. Just, highlight the code, right click and choose "Run 
> Selection" 
>
> http://www.razzak.com/tips/RBEdit_RunSelection_01.png 
> http://www.razzak.com/tips/RBEdit_RunSelection_02.png 
>
> The "Run Selection" option is available from the right click > popup 
> menu, within the 
> editor "Run" button, and the [Ctrl+F8] key combination. 
>
> Both single line or multi-line code blocks can be highlighted and 
> executed, to quickly 
> test programming code. 
>
> The Run Selection functionality is ideal for: 
>
>   . Previewing PAUSE and DIALOG commands 
>   . Defining variables 
>   . Creating temporary tables 
>   . Testing a block of code in a large command file 
>   . And more... 
>
> One of the most important aspects in business growth is your company 
> data, and no one else 
> has more invested in your success than R:BASE Technologies. Invest 
> forward with R:BASE! 
>
> Very Best R:egards, 
>
> Razzak. 
>
> www.rbase.com 
> www.facebook.com/rbase 
> -- 
> 34 years of continuous innovation! 
> 19 Years of R:BASE Technologies, Inc. making R:BASE what it is today! 
> -- 
>

-- 
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: Date Picker

[Michael Byerley]

The RBase form calendar that I put the link was the evolution of many 
different on screen calendars that I have done dating from RBase DOS days 
and definitely way before we had a handy Object date picker available.
  
 The iteration that I posted was simply a date picker with a simple 
enhancement to be provided a SEED date by the user, which makes it 
palatable to call it twice in succession to get a date range and also to 
call it anywhere else where a date picker would be handy.

  Clearly there are many different avenues available for RBase users to 
pursue thanks to the continued enhancement to the base product. 

On Wednesday, April 5, 2017 at 10:57:46 AM UTC-4, dick wrote:
>
> Have a form with an start date and a end date. 
> Using a dbdatepicker, how can I make the end date calender open with the 
> same month as the start date, when the 
> user picks a month later than the current one? 
>
> Dick Fey 
>
> -- 
> Carpet Broker Inc 
> P: 913-894-9211 
> F: 913-894-0138 
>
>
>

-- 
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: Date Picker

[Michael Byerley]

Dick,

  You can download this RBase form based date picker, complete with example 
RMD, which will allow you to open it with a Seed date and a couple other 
features explained in the RMD file.

http://www.byerley.net/Download_A/RbCalendar.zip



On Wednesday, April 5, 2017 at 10:57:46 AM UTC-4, dick wrote:
>
> Have a form with an start date and a end date. 
> Using a dbdatepicker, how can I make the end date calender open with the 
> same month as the start date, when the 
> user picks a month later than the current one? 
>
> Dick Fey 
>
> -- 
> Carpet Broker Inc 
> P: 913-894-9211 
> F: 913-894-0138 
>
>
>

-- 
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: Compiler: How to read command line arguments.

[Michael Byerley]

The significant difference is that you MUST know the position of the string 
you are relating to in the startup string.  

Getting the whole string and parsing it yourself affords you the luxury of 
adding to or deleting from the string with only having to deal with a 
conditional statement to accommodate the change.

If the conditional statement would be encapsulated within a stored 
procedure, there would likely only be one place that would require 
maintenance other than the particular place the conditional statement was 
directed.

RBase certainly gives you the ability to choose what suits you best though.



On Sunday, March 12, 2017 at 12:57:44 PM UTC-4, Michael Byerley wrote:
>
> This was started by Larry Lustig in the previous thread.
>
> This code segment could be placed anywhere relative to its purpose.
> Function declarations ONLY need to be done ONCE in an RBase session.
> Once declared, the DLCall rbase function can be used anywhere, anytime in 
> an RBase session.
>
> {Begin Code}
>
>
> { Original Win32 Function Declaration: LPTSTR WINAPI GetCommandLine(void);}
>
> -- How to declare function in RBase:
>
>
> IF (CHKFUNC('GetCommandLine')) = 0 THEN
>   STDCALL FUNCTION 'GetCommandLineA' alias 'GetCommandLine' () : TEXT
> ENDIF
>
>
> SET VAR vText TEXT = NULL
>
> SET VAR vText = (DLCALL('Kernel32', 'GetCommandLine'))
>
> PAUSE 2 USING .vText
>
> RETURN
>
> {End Code}
>

-- 
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: Sample Applications: Designing & Deploying MDI Applications

[Michael Byerley]

Easy Peasy:

{Begin Code}

IF (CHKFUNC('GetCommandLine')) = 0 THEN
  STDCALL FUNCTION 'GetCommandLineA' alias 'GetCommandLine' () : TEXT
ENDIF


SET VAR vText TEXT = NULL

SET VAR vText = (DLCALL('Kernel32', 'GetCommandLine'))

PAUSE 2 USING .vText

RETURN


{End Code}


On Friday, March 3, 2017 at 8:32:55 PM UTC-5, A. Razzak Memon wrote:
>
> Friday, March 3, 2017 
>
> A sample application to illustrate the use of MDI Forms and managing MDI 
> Forms 
> in a Multi-Monitor environment is now available. 
>
> This application illustrates specific use of PROPERTY and GETPROPERTY 
> commands 
> related to MDI Forms and managing MDI Forms in a Multi-Monitor 
> environment. 
>
> R:BASE Sample Applications: http://www.Razzak.com/SampleApplications/ 
>
> Application Title: Designing & Deploying MDI Applications 
> Supported Version: R:BASE X Enterprise (Version 10) 
>
> For your viewing pleasure ... 
>
> http://www.razzak.com/tips/MDI_Forms_01.png 
> http://www.razzak.com/tips/MDI_Forms_02.png 
> http://www.razzak.com/tips/MDI_Forms_03.png 
> http://www.razzak.com/tips/MDI_Forms_04.png 
> http://www.razzak.com/tips/MDI_Forms_05.png 
> http://www.razzak.com/tips/MDI_Forms_06.png 
> http://www.razzak.com/tips/MDI_Forms_07.png 
> http://www.razzak.com/tips/MDI_Forms_08.png 
>
> Please Note: 
>
> . There are no pre-requisites to install and run this sample application. 
>
> . There is no need to have any version of R:BASE installed on your 
> computer. 
>
> . This application is designed to illustrate the use of MDI Forms and 
> managing 
>MDI Forms in a Multi-Monitor environment using R:BASE X Enterprise 
> (Version 10). 
>
>In addition ... 
>
> . This compiled and fully secured database and self-running application is 
>provided to demonstrate the use of R:Compiler for R:BASE X Enterprise 
>(Version 10) and the suggested method to design, develop, and 
> distribute 
>your compiled applications for mobile devices, such as Tablet PCs. 
>
> . This complied application also demonstrates the speed of loading your 
>project using R:Compiler for R:BASE X Enterprise (Version 10). 
>
> . You may install this application in a network and MS Cloud environment 
>to really see the performance and capabilities of R:BASE X Enterprise. 
>
> . Mobile PC and/or Touch Screen users may also enjoy the new interface. 
>
> Enjoy the presentation and make sure to have fun! 
>
> Very Best R:egards, 
>
> Razzak. 
>
> P.S. Some users may find this application too overwhelming! 
>

-- 
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

[Michael Byerley]

Well I saw from Jim's post that he had maybe a litany of possible 
directions to go within the scope of the eep, but custom form actions I 
usually reserve for activities that would be used multiples of times 
elsewhere, but that's maybe just me, but

to address the idea of a managers override, I would have "such a button" on 
the form that would launch a non modal form for the manager to enter their 
"override password" within the context of that form, then the manager would 
reenter the field to be overridden, wherein the IF condition would test for 
the "override password" which would a: change whatever the criteria for the 
field would allow direct entry therein and b: skip over all the manditory 
choices, then having completed that, manager would close the non modal form 
with the OnClose eep of the non modal form clearing the "override 
password", but that is just how I would do it.



On Tuesday, December 13, 2016 at 12:14:03 PM UTC-5, jim wrote:
>
> 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*
>
> [image: cid:image001.jpg@01CD8CE2.FB048F50]
>
>  
>

-- 
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: OT - new laptop

[Michael Byerley]

Thanks to a 3rd party patch, I was able to install AutoCad 2000 (yes 16 
year old software) on Win 10.:)

At my age, I will use this old version as long as I can.  I'm not ready to 
shell out 5K for new software for something I use a couple times a year.




On Thursday, September 22, 2016 at 12:26:34 PM UTC-4, karen...@cs.com wrote:
>
> Admin: feel free to delete if this is not appropriate.
>
> My laptop (my only computer) just died, rats.  It was a 2012 Toshiba 
> Satellite with windows 8.  Boy I am scared to get windows 10.  I always 
> bought at Best Buy, but they no longer carry Toshiba, and until now 
> Toshibas have been so reliable for me.  They do carry Dell, Lenova, Acer.
>
> So my question is, knowing that RBase is my primary concern, am I okay 
> buying windows 10?  And comment on brands?
>
> 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.
For more options, visit https://groups.google.com/d/optout.

[RBASE-L] - Re: OT - new laptop

[Michael Byerley]

FYI, Office 2007 is working just fine on my Win10 Laptop and Surface 4 pro.



On Thursday, September 22, 2016 at 12:26:34 PM UTC-4, karen...@cs.com wrote:
>
> Admin: feel free to delete if this is not appropriate.
>
> My laptop (my only computer) just died, rats.  It was a 2012 Toshiba 
> Satellite with windows 8.  Boy I am scared to get windows 10.  I always 
> bought at Best Buy, but they no longer carry Toshiba, and until now 
> Toshibas have been so reliable for me.  They do carry Dell, Lenova, Acer.
>
> So my question is, knowing that RBase is my primary concern, am I okay 
> buying windows 10?  And comment on brands?
>
> 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.
For more options, visit https://groups.google.com/d/optout.

[RBASE-L] - Editing a table in Rbase 9.5 vs Rbase X, 32 bit

[Michael J. Sinclair]

Hi All,
In rbase 9.5 if I try to edit a table using this
EDIT refflag FROM scripts0 WHERE patnumbr = 9363 
and I hit the letter "X", and then hit the ESC key and click on save, the field 
changes the value to "X"
BUT
If I do the same thing in Rbase X, the change is not saved UNLESS I leave the 
field before I hit the ESC key.
Am I doing something wrong?Is there a setting which controls this behavior?
Thanks
Mike#yiv2570075289 
#yiv2570075289AOLMsgPart_2_1d65c2f9-e09a-4289-bac6-dfba55a626f2 
td{color:black;} _filtered #yiv2570075289 {font-family:Calibri;panose-1:2 15 5 
2 2 2 4 3 2 4;} _filtered #yiv2570075289 {font-family:Tahoma;panose-1:2 11 6 4 
3 5 4 4 2 4;}#yiv2570075289 .yiv2570075289aolReplacedBody 
p.yiv2570075289MsoNormal, #yiv2570075289 .yiv2570075289aolReplacedBody 
li.yiv2570075289MsoNormal, #yiv2570075289 .yiv2570075289aolReplacedBody 
div.yiv2570075289MsoNormal 
{margin:0in;margin-bottom:.0001pt;font-size:11.0pt;}#yiv2570075289 
.yiv2570075289aolReplacedBody a:link, #yiv2570075289 
.yiv2570075289aolReplacedBody span.yiv2570075289MsoHyperlink 
{color:#0563C1;text-decoration:underline;}#yiv2570075289 
.yiv2570075289aolReplacedBody a:visited, #yiv2570075289 
.yiv2570075289aolReplacedBody span.yiv2570075289MsoHyperlinkFollowed 
{color:#954F72;text-decoration:underline;}#yiv2570075289 
.yiv2570075289aolReplacedBody p 
{margin-right:0in;margin-left:0in;font-size:12.0pt;}#yiv2570075289 
.yiv2570075289aolReplacedBody p.yiv2570075289MsoAcetate, #yiv2570075289 
.yiv2570075289aolReplacedBody li.yiv2570075289MsoAcetate, #yiv2570075289 
.yiv2570075289aolReplacedBody div.yiv2570075289MsoAcetate 
{margin:0in;margin-bottom:.0001pt;font-size:8.0pt;}#yiv2570075289 
.yiv2570075289aolReplacedBody p.yiv2570075289msonormal0, #yiv2570075289 
.yiv2570075289aolReplacedBody li.yiv2570075289msonormal0, #yiv2570075289 
.yiv2570075289aolReplacedBody div.yiv2570075289msonormal0 
{margin-right:0in;margin-left:0in;font-size:12.0pt;}#yiv2570075289 
.yiv2570075289aolReplacedBody span.yiv2570075289EmailStyle19 
{color:windowtext;}#yiv2570075289 .yiv2570075289aolReplacedBody 
span.yiv2570075289EmailStyle20 {color:#1F497D;}#yiv2570075289 
.yiv2570075289aolReplacedBody span.yiv2570075289EmailStyle21 
{color:windowtext;}#yiv2570075289 .yiv2570075289aolReplacedBody 
span.yiv2570075289EmailStyle22 {color:#1F497D;}#yiv2570075289 
.yiv2570075289aolReplacedBody span.yiv2570075289BalloonTextChar 
{}#yiv2570075289 .yiv2570075289aolReplacedBody .yiv2570075289MsoChpDefault 
{font-size:10.0pt;} _filtered #yiv2570075289 {margin:1.0in 1.0in 1.0in 
1.0in;}#yiv2570075289 .yiv2570075289aolReplacedBody 
div.yiv2570075289WordSection1 {}

-- 
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: Tip of the Day: RECALCulating Specific Variable(s)

[Michael Byerley]

Javier,

  Prior to the official release of the enhanced RECALC VARIABLES command, 
all the other syntaxes used simply RECALCed ALL variables, not just the 
ones enumerated in the command.



On Wednesday, July 27, 2016 at 11:00:45 AM UTC-4, A. Razzak Memon wrote:
>
> Wednesday, July 27, 2016 
>
> Tip of the Day: RECALCulating Specific Variable(s) 
> Product...: R:BASE/Runtime/R:Compiler - X/X Enterprise (Version 10) 
> Build.: 10.0.1.10727 or higher 
> Section...: EEPs 
> Keywords..: RECALC VARIABLES 
>
> Traditionally, using the RECALC VARIABLES command recalculates all 
> variables. 
>
> Did you know that now you can recalculate a specific variable or a 
> list of variables? 
>
> The RECALC VARIABLES command has been enhanced to include an optional 
> variable list, 
> to perform a recalculation on a target variable or set of specified 
> variables. 
>
> -- Example 01: 
> RECALC VARIABLES vTargetPrice 
> RETURN 
>
> -- Example 02: 
> RECALC VARIABLES vTargetPrice,vShippedQuantity,vDiscountedRate 
> RETURN 
>
> Have fun! 
>
> Very Best R:egards, 
>
> Razzak. 
>
> www.rbase.com 
> www.facebook.com/rbase 
> -- 
> 33 years of continuous innovation! 
> 18 Years of R:BASE Technologies, Inc. making R:BASE what it is today! 
> -- 
>
>

-- 
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] - problem with printers in Windows 10

[Michael J. Sinclair]

After a number of tests, it appears that printer names have changed from 
Windows 7 to Windows 10, nothing to do with Rbase. I don't understand why my 
old printer names are still working, ie \\servername\printername is working 
after I upgraded from Windows 7 to Windows 10, but any new printer names that 
are added after the upgrade, appear to have to be 
\\servername\domain.com\printername
Hope that helps somebody in Rbase community who is upgrading from Windows 7 to 
Windows 10
Mike

  From: Michael J. Sinclair <mj...@bellsouth.net>
 To: "rbase-l@googlegroups.com" <rbase-l@googlegroups.com> 
 Sent: Thursday, June 9, 2016 6:36 PM
 Subject: Re: [RBASE-L] - problem with printers in Windows 10
   
Success!Ok...but here is what I foundBefore I could name the printer as 
follows:\\Zeus\pos4printa
Now I have the new name must be...\\Zeus.MJSMD.COM\pos4printa
All of my other network printers are still working and they have names similar 
to \\zeus\printer_nameSince I upgraded to Windows 10, new printers have to have 
the domain name, ie \\Zeus.MJSMD.COM\printer_name.
Is that because of Windows 10 or because of Rbase X?
Mike

  From: karentellef via RBASE-L <rbase-l@googlegroups.com>
 To: rbase-l@googlegroups.com 
 Sent: Thursday, June 9, 2016 9:21 AM
 Subject: Re: [RBASE-L] - problem with printers in Windows 10
  
That's what I do, exactly as Razzak suggests.

When you get it to work "manually", then do a PRNSETUP INFO
and you'll get a list of exactly how to reference the name, the tray, etc.
Just copy and paste the info into your command!

Karen
 
 
 
-Original Message-
From: A. Razzak Memon <raz...@rbase.com>
To: rbase-l <rbase-l@googlegroups.com>
Sent: Thu, Jun 9, 2016 1:58 am
Subject: Re: [RBASE-L] - problem with printers in Windows 10

At 11:49 PM 6/8/2016, Michael J. Sinclair wrote:

>Hi all,
>
>This code seems to work fine on Windows 7 machines...
>
>LBLPRINT scripts4x4 WHERE patnumbr = .vpnum AND refflag ='L' AND +
>PRINTER = 1 +
>OPTION PRINTER +
>|SHOW_CANCEL_DIALOG OFF +
>|PRINTER_NAME \\zeus\pos4printa
>
>When I upgraded to Windows 10, it still worked.
>
>BUT, when I tried to change the printer name, it fails. The code
>seems to run, but I don't get anything on the printer.
>
>Is there some magic setting in Windows 10 that I can change regarding
>printers? Is my syntax wrong?


For testing purpose, try the manual method and see what you get ...

-- Select the appropriate printer first
PRNSETUP
-- Now print label
LBLPRINT scripts4x4 WHERE patnumbr = .vpnum AND refflag ='L' AND +
PRINTER = 1 OPTION PRINTER |SHOW_CANCEL_DIALOG OFF
RETURN

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

Very Best R:egards,

Razzak



-- 
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.
-- 
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.


   -- 
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.


   

-- 
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] - problem with printers in Windows 10

[Michael J. Sinclair]

Success!Ok...but here is what I foundBefore I could name the printer as 
follows:\\Zeus\pos4printa
Now I have the new name must be...\\Zeus.MJSMD.COM\pos4printa
All of my other network printers are still working and they have names similar 
to \\zeus\printer_nameSince I upgraded to Windows 10, new printers have to have 
the domain name, ie \\Zeus.MJSMD.COM\printer_name.
Is that because of Windows 10 or because of Rbase X?
Mike

  From: karentellef via RBASE-L <rbase-l@googlegroups.com>
 To: rbase-l@googlegroups.com 
 Sent: Thursday, June 9, 2016 9:21 AM
 Subject: Re: [RBASE-L] - problem with printers in Windows 10
   
That's what I do, exactly as Razzak suggests.

When you get it to work "manually", then do a PRNSETUP INFO
and you'll get a list of exactly how to reference the name, the tray, etc.
Just copy and paste the info into your command!

Karen
 
 
 
-Original Message-
From: A. Razzak Memon <raz...@rbase.com>
To: rbase-l <rbase-l@googlegroups.com>
Sent: Thu, Jun 9, 2016 1:58 am
Subject: Re: [RBASE-L] - problem with printers in Windows 10

At 11:49 PM 6/8/2016, Michael J. Sinclair wrote:

>Hi all,
>
>This code seems to work fine on Windows 7 machines...
>
>LBLPRINT scripts4x4 WHERE patnumbr = .vpnum AND refflag ='L' AND +
>PRINTER = 1 +
>OPTION PRINTER +
>|SHOW_CANCEL_DIALOG OFF +
>|PRINTER_NAME \\zeus\pos4printa
>
>When I upgraded to Windows 10, it still worked.
>
>BUT, when I tried to change the printer name, it fails. The code
>seems to run, but I don't get anything on the printer.
>
>Is there some magic setting in Windows 10 that I can change regarding
>printers? Is my syntax wrong?


For testing purpose, try the manual method and see what you get ...

-- Select the appropriate printer first
PRNSETUP
-- Now print label
LBLPRINT scripts4x4 WHERE patnumbr = .vpnum AND refflag ='L' AND +
PRINTER = 1 OPTION PRINTER |SHOW_CANCEL_DIALOG OFF
RETURN

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

Very Best R:egards,

Razzak



-- 
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.
-- 
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.


   

-- 
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] - problem with printers in Windows 10

[Michael J. Sinclair]

Hi all,
This code seems to work fine on Windows 7 machines...
LBLPRINT scripts4x4 WHERE patnumbr = .vpnum AND refflag ='L' AND +
PRINTER = 1 +
OPTION PRINTER +
|SHOW_CANCEL_DIALOG OFF +
|PRINTER_NAME \\zeus\pos4printa

When I upgraded to Windows 10, it still worked.
BUT, when I tried to change the printer name, it fails. The code seems to run, 
but I don't get anything on the printer.
Is there some magic setting in Windows 10 that I can change regarding 
printers?Is my syntax wrong?

Mike 

-- 
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] - speeding up searches in a view

[Michael J. Sinclair]

Hi all,
I was doing a search of a two table view with about 1 million rows.The column I 
am using has an index. This search was very slow.
BROWSE ALL FROM viewname WHERE columname > (.#date - 365)
This search was almost instant
SET VAR vdate = (.#date - 365)BROWSE ALL FROM viewname WHERE columname > .vdate


Why is there such a big difference?
Mike

-- 
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: Running Rbase for Dos in Windows 10

[Michael]

Odd error. Are you getting this within a DOS window under Win 10 32bit?

Worst case, you could run the DOS 4.5 version under Win 7 or earlier 
(perhaps even XP) under Microsoft's Virtual PC (renamed/enhanced in Win 
10). Whichever OS you last used successfully. You can also run it within 
DosBox (with a good deal of effort in eliminating full paths in command 
files).
MD


On Sunday, March 27, 2016 at 6:06:29 PM UTC-7, mjsmd wrote:
>
>  
> Does anybody know if it is possible to run Rbase for DOS in Windows 10 32 
> bit? I get errors regarding the file netapi32.dll.
> Changing the compatibility mode did not help.
> The error message is
>
>
> The procedure entry point RtlConvertUiListToApiList could no be
> located in the dynamic link library G:\rb45conv\netapi32.dll
>
> Mike
>
>

-- 
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: Output console

[Michael]

Do you mean that the output console shows the most recent commands at the 
top rather than bottom?

If so, I quite agree.




On Sunday, March 27, 2016 at 7:25:55 PM UTC-7, Michel Séguin wrote:
>
> Hello group,
>
> Is there a way to change the up to down reading order for r:BaseX  in the 
> outout cosole at R>.
>
> Thanks,
>
> Michel Seguin
>

-- 
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 to Use Lookup value from a DIALOG Command

[Michael]

Thank you again for replying, Rehan.

Yes, vResponse is the assigned variable...but in the code given it produces 
a null. It does NOT contain the CustID of the record selected in the lookup 
listing.

Bear in mind that I am using the documentation's example for the DIALOG 
LOOKUP command. And that this extended code does more than merely collect a 
text string. First, it asks for a text string. If the user instead 
double-clicks, it then shows a list of possible choices -- an actual popup. 
Select one, and you return to the first box asking for a text string. ONLY 
IF TEXT IS ENTERED HERE does vResponse contain a value. So...what value is 
a lookup then? Or, how to make use of it.


dbl click & get this


In selecting a customer or a part or any of a mass of possible items, 
you're most likely going to need to select from a list than type in the 
full, exact text or number. So, how to get this lookup LIST *and* return a 
valid value?

How can the list be make to appear without the usually unnecessary step of 
the text box & double-clicking? How can the two methods be made work 
together (as the poorly documented example intended)?  The code below 
following the example works fine but doesn't return a value from a 
selection if the popup is activated.

DIALOG 'Enter Contact to Edit' vResponse=26 vEndKey 1 CAPTION 'Contact 
Info' ICON APP OPTION DIALOG_EDIT_HINT 'Double-Click for a List of 
Contacts' |POPUP_ENABLED TRUE |POPUP_DIALOG_TYPE LOOKUP 
|POPUP_TITLE_FONT_NAME VERDANA |POPUP_TITLE_FONT_SIZE 10 
|POPUP_TITLE_FONT_BOLD TRUE |POPUP_TITLE_FONT_COLOR GREEN 
|POPUP_TITLE_BACK_COLOR WHITE |POPUP_TITLE_TEXT 'Select Contact to Edit' 
|POPUP_LIST_FONT_COLOR GREEN |POPUP_LIST_BACK_COLOR WHITE |POPUP_CAPTION 
'List of Contacts' |POPUP_TABLE Citizens |POPUP_SELECT Name_F,Name_L, 
Addr1, Addr2, Email  |POPUP_RETURN_COLUMN CitizenID |POPUP_WHERE WHERE 
Name_L CONTAINS .vResponse OR Name_F CONTAINS .vResponse OR Addr1 CONTAINS 
.vResponse OR Addr2 CONTAINS .vResponse OR Email CONTAINS .vResponse ORDER 
BY Name_L, Name_F |POPUP_SHOW_LINES TRUE |POPUP_RETURN_TYPE COLUMN 
|POPUP_LINES 20 |POPUP_DISTINCT TRUE


On Friday, April 29, 2016 at 12:02:48 AM UTC-7, rehan_wyne wrote:
>
> Michael,
>
> vResponse is the variable which will hold the returned value
>
> Rehan Wyne
>
>
>
> On Friday, April 29, 2016 10:59 AM, Michael <finega...@gmail.com 
> > wrote:
>
>
> The DIALOG Lookup command appears to do what I would like it to do -- but 
> the documentation ends without any explanation of how to access the value 
> selected in a lookup. I see no new variable, or any that appear to hold the 
> resulting value. It appears to me that the value selected simply disappears 
> into a black hole.
>
> I copied the example from the manual/help screen, changed my table & 
> column names, and it works on screen...just doesn't produce any resulting 
> value I can find or access. As an example, I'd like the user to examine a 
> list of customers, select one, and return the primary key value (CustID).
>
> Using a POPUP_RETURN_COLUMN CustID | POPUP_RETURN_TYPE VALUE, where is the 
> value of CustID to be found?
>
> If I instead use POPUP_RETURN_TYPE COLUMN, what info is actually returned? 
> And where is it to be found?
>
>
> DIALOG 'Enter search string to look for in database' vResponse=25 vEndKey 
> 1 +   CAPTION 'Search' ICON INFO +   OPTION 
> DIALOG_EDIT_HINT 'Double-Click for a List of Contacts' +   
> |POPUP_ENABLED TRUE +   |POPUP_DIALOG_TYPE LOOKUP 
> +   |POPUP_TITLE_FONT_NAME VERDANA +   
> |POPUP_TITLE_FONT_SIZE 10 +   |POPUP_TITLE_FONT_BOLD TRUE 
> +   |POPUP_TITLE_FONT_COLOR GREEN +   
> |POPUP_TITLE_BACK_COLOR WHITE +   |POPUP_TITLE_TEXT 'Select 
> Contact to Edit' +   |POPUP_LIST_FONT_COLOR GREEN 
> +   |POPUP_LIST_BACK_COLOR WHITE +   |POPUP_CAPTION 
> 'List of Citizens' +   |POPUP_TABLE Citizens +   
> |POPUP_SELECT Name_F,Name_L, Addr1, Addr2, Email +   
> |POPUP_RETURN_COLUMN CitizenID +   |POPUP_WHERE ORDER BY 
> Name_L, Name_F +   |POPUP_SHOW_LINES TRUE +   
> |POPUP_RETURN_TYPE COLUMN +   |POPUP_LINES 20 +   
> |POPUP_DISTINCT TRUE
> (manual's example adapted to my data).
>
> Thanks for any guidance. 
> -- 
> You received this message because you are subscribed to the Google Groups 
> "RBASE-L" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to rbase-l+u...@googlegroups.com .
> 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: Re[2]: [RBASE-L] - Pasting a Multi-line command at the R>

[Michael]

Rehan & Bruce,
Thanks for your reply, which reminded me of the new feature of Copy Command 
(i.e. copy without continuation characters). However, both your answers 
miss the mark and I am left without a solution to the basic problem: a 
properly constructed, multiline statement fails to work at the R> (tho it 
works fine run within a command file). 

By my estimation, that lack of functionality itself and alone would more 
than double development/proofing time on everything. For conversion of a 
large working database, that means I'm more likely to just retire than 
finish converting my main database. Or do my testing where possible back in 
DOS, where such things work.

It also means that lengthy code must be converted in format in order to 
test it at the R>, with all the problems of proofing after the fact given 
differences in formatting. Seems to me that a "Paste Command" that strips 
out continuation characters (as a workaround to RBase's apparent failure 
here) would be more appropriate than a Copy Command that works only in 
RBEdit.

So, again: why does a properly structured, multiline command fail with a 
spurious syntax error at the R>? That is the core issue.

I'm hearing that "it just doesn't work, period." And in that I'm seeing a 
huge lack of functionality. So, Bruce, someday I hope to have greater 
confidence in RB Windows. Thus far, I've mostly seen key functionality such 
as this disappear, making progress to the point of harnessing the program's 
great power very tedious & slow -- and possibly not even cost-effective.

Mike


On Friday, April 29, 2016 at 7:30:02 AM UTC-7, rbytes wrote:
>
> Michael:
>  
> There's a keyboard shortcut for that:
>  
> 1. Highlight your multi-line command in the editor;
>  
> 2. Use [Ctrl-Shift-Alt-C] instead of [Ctrl-C];
>  
> 3. Paste at the R> Prompt with [Ctrl-V].
>  
> You will NOT be disappointed with the functionality of R:BASE in Windows.
>  
> Bruce Chitiea
> SafeSectors, Inc.
> 909.238.9012 mobile
>  
> -- Original Message --
> Sent: 4/28/2016 11:46:30 PM
> Subject: Re: [RBASE-L] - Pasting a Multi-line command at the R>
> From: "'rehan wyne' via RBASE-L" <rba...@googlegroups.com >
> To: "rba...@googlegroups.com " <rba...@googlegroups.com 
> >
> Cc: 
>  
> Micheal,
>
> Type your multi line command in R> prompt and let it warp itself, do not 
> use '+' sign to tell the interpreter / compiler that it is a multi line 
> command, just press 'enter' at the end of command to execute it.
>
> Secondly, eliminate '+' sign from ur multi line command in R> prompt, 
> pasted from a command file, it will work.
>
> Rehan Wyne
>
>
>
> On Friday, April 29, 2016 10:59 AM, Michael <finega...@gmail.com 
> > wrote:
>
>
> My first post to this group. Newbie to Rbase X 32bit from the cozy DOS 
> world, but I have a question about the most basic functionality (or lack).
>
> How does one cut & paste a multi-line command to the R> prompt to test the 
> command (or execute it one-off)? I can paste the command, but every command 
> I've tried throws an error. And then command history corrupts the 
> formatting of the  pasted command on recall. 
>
> I first found this copying some help screen examples. But even using 
> something a simple as
>
> Show  +
> Variables
>
> results in a spurious error (sometimes Invalid parameter, usually syntax 
> error).
>
> And this type of mess when recalled from history: Show  +Variables
>
> I've seen that syntax executed in a command file works fine, but when the 
> identical syntax is pasted, it does not work with the errors noted above.
>
> Testing at the R> is an essential function. But does it work? How?
>
> Thanks for any help.
> -- 
> You received this message because you are subscribed to the Google Groups 
> "RBASE-L" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to rbase-l+u...@googlegroups.com .
> 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+u...@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: Document table

[Michael Byerley]

Use VarChar for RTF or any Textual content that contains formatting. 
 VarBit is for binary data.

On Monday, April 4, 2016 at 6:27:40 AM UTC-7, Tom Hart wrote:
>
> I am creating a simple database (Rbase X) to store various document files, 
> docname and documentcontent.  I have made documentcontent a note type and 
> in a form it is RTF.  When I open up the blob and a rtf file to save or try 
> and copy and paste a rtf I get all those funny little characters.  Should I 
> use a different type and or form field?
>

-- 
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 post to this group, send email to rbase-l@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/dcb21caa-ca8f-4647-b70e-b470d94fd2d5%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.