[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&utm_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&utm_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 

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&utm_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&utm_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&utm_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&utm_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 
&g

[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 &ContLName )=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 &ContLName )=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 
> &vCustomerList)  &vDirectoryFileName 
>
>  
>
> 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] - 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 
https://groups.google.com/d/msgid/rbase-l/882bb

[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&T num...@txt.att.net (SMS)
AT&T 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] - Hide form while repositioning

[Michael Byerley]

I think Karen's idea will work OK as long as you do not have other 
container components on it like Panels.  I have used the Alpha Blend for 
this purpose, but just for S & G, I tried it on a form with Panels, Tabs 
and those remain visible, so...


On Friday, February 7, 2020 at 1:42:49 PM UTC-5, Doug Hamilton wrote:
>
> Ding! Ding! Ding!  Karen wins!
>
> The idea is to have a Main Menu and then cascade subsequent forms down and 
> right as each one is opened.
> Your prize, such as it is, is the code:
> The Main Menu is an external form that is disconnected from the db.  When 
> an object is clicked a CFA runs that connects the db and gets the current 
> location of the MainMenu: 
> GETPROPERTY RBASE_FORM LEFT 'gFormLeft'
> GETPROPERTY RBASE_FORM TOP 'gFormTop'
>
> When a form is opened, this code runs in the OAS EEP that bumps the top 
> and left coordinates down and right and then positions the form; the form 
> has alphablend set to zero:
> SET VAR  +
>   gFormLeft = (CTXT((NINT(.gFormLeft)) + 20)), +
>   gFormTop = (CTXT((NINT(.gFormTop)) + 20))
> PROPERTY RBASE_FORM LEFT .gFormLeft
> PROPERTY RBASE_FORM TOP .gFormTop
>
> PROPERTY RBASE_FORM ALPHABLENDVALUE 255
>
> An On Close EEP in each form decrements the position:
> SET VAR  +
>   gFormLeft = (CTXT((NINT(.gFormLeft)) - 20)), +
>   gFormTop = (CTXT((NINT(.gFormTop)) - 20))
>
> Thanks Karen!
> Doug
> p.s. I use 'g' variables instead 'v' so I know they are global and not to 
> be cleared in a form.
>
> On 2/7/2020 11:54 AM, 'Karen Tellef' via RBASE-L wrote:
>
> Hey I know this one  I've actually never done this, but knew I had it 
> somewhere in my notes.
>
>
>
> To make a form invisible, check Alpha-Blend and set the value to 0.
> On form after start eep, do whatever, then PROPERTY RBASE_FORM 
> ALPHABLENDVALUE 255 
>
>
>
>
> Karen
>
>
> -Original Message-
> From: Doug Hamilton  
> To: R:Base List  
> Sent: Fri, Feb 7, 2020 11:45 am
> Subject: [RBASE-L] - Hide form while repositioning
>
> When a form is first opened, how do I hide it until it is in a desired 
> location?
>
> Forms normally open in the center of the screen.  I have an On After 
> Start EEP that uses PROPERTY RBASE_FORM LEFT 'nnn' and PROPERTY 
> RBASE_FORM TOP 'nnn' to locate the form elsewhere.  The form briefly 
> appears in the center of the screen and then locates to the assigned 
> position.
>
> What I want to do is have the equivalent of Hide-On-Startup for the 
> form, position it and then issue a PROPERTY RBASE_FORM VISIBLE 'TRUE'.
>
> I tried PROPERTY RBASE_FORM VISIBLE 'FALSE' as the first line in the 
> On-After-Start EEP but it was too late - the form was already visible.  
> PROPERTY RBASE_FORM VISIBLE 'FALSE' didn't work in the On Before Start 
> EEP cuz you can't hide something that isn't there yet :)
>
> I played around with Gravitation on New Form Behavior but couldn't get 
> what I wanted.
>
> BTW, the PROPERTY LEFT and TOP are in a RUN SELECT that is called in the 
> form's On After Start EEP; I run that in all my forms to set Captions, 
> some hints and generic form stuff.
>
> Ideas?
>
> TIA,
> Doug
> RB X.5E 20114
>
> -- 
> 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/aac71212-2ef0-234c-8532-ccea63a69453%40wi.rr.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/1427773212.974810.1581098060265%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/71b76fe1-c317-443d-bf6b-774bab752969%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 fo

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&utm_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&utm_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&T 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&utm_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] - 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: 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 https://groups.google.com/d/opt

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

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] - Re: Any way to have DIALOG pre-select the default text.

[Michael Byerley]

OR just use AUTOSELECT TRUE:)

The aforementioned solution I laid out works on a variety of edit boxes 
other than DIALOG but when I originally used that solution the form timer 
hadn't been implemented, so everything I mentioned applicable to the hidden 
form, would work in a form timer EEP since it runs in its own thread.




On Friday, January 12, 2018 at 10:08:44 AM UTC-5, larrylustig wrote:
>
> I'm starting a DIALOG command with a default value already in the variable 
> used by the DIALOG.
>
> The appearance is that the cursor is positioned at the beginning of the 
> value in the DIALOG's input edit.
>
> I would prefer the value to be already selected so that anything the user 
> enters *replaces* what's there already.  I cannot find anything in the 
> OPTIONS documentation to pre-select the value display.
>
> Anyone know if this is possible.
> --
> Larry
>

-- 
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: Any way to have DIALOG pre-select the default text.

[Michael Byerley]

The class of every edit box is not the same across all versions of RBASE so 
you will need a utility (usually one is within the installation of advanced 
language IDE) to obtain the classname of any edit box.  There is still a 
good one up on my site that was written years ago by Mike Sutton, a then 
frequent contributor to the VB newsgroups.

Direct LInk to the Zipper:
http://www.byerley.net/Download_A/WndInf13.zip

Or the Page:
http://www.byerley.net/Software.aspx

and scroll to the bottom.



On Friday, January 12, 2018 at 10:08:44 AM UTC-5, larrylustig wrote:
>
> I'm starting a DIALOG command with a default value already in the variable 
> used by the DIALOG.
>
> The appearance is that the cursor is positioned at the beginning of the 
> value in the DIALOG's input edit.
>
> I would prefer the value to be already selected so that anything the user 
> enters *replaces* what's there already.  I cannot find anything in the 
> OPTIONS documentation to pre-select the value display.
>
> Anyone know if this is possible.
> --
> Larry
>

-- 
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: Any way to have DIALOG pre-select the default text.

[Michael Byerley]

The only way to do this is pretty messy.

I have done similar for a different purpose, but here goes:

In whatever procedure (separate, not IN-Line, like a custom action, etc) 
that launches the dialog, you launch just before the dialog an MDI form 
that is hidden (Alpha Blend 0, AND OR Top Left somewhere off screen.  I 
used Alpha Blend) 

In that form, in the onAfter EEP start a while loop that keeps testing for 
the presence of 'TFormDialog.UnicodeClass' which is the class name of the 
current version of RBase Dialog Edit using the FindWindow and FindWindowEx 
functions to Retrieve its' HANDLE. Here is an Example using Delphi but I 
have had some success using these functions via the RBase DLCall command:

{Begin Delphi Code}
function GetMyWindow(): HWND;
var
GetWnd: HWND;
begin
  GetWnd := FindWindow('TApplication', 'R:BASE X Enterprise');
  if (GetWnd <> 0) then
begin
  GetWnd := FindWindowEx(GetWnd, 0, 'TFormDialog.UnicodeClass', 'Type 
Caption Here ...');
  if (GetWnd <> 0) then
begin
  GetWnd := FindWindowEx(GetWnd, 0, 'TTntEdit.UnicodeClass', nil);
  if (GetWnd <> 0) then GetMyWindow := GetWnd;
end
end
end;

{End Delphi Code}



If it is a single line Edit box, then you have to use Windows API 
'PostMessage' function to the window passing the EM_SETSEL constant along 
with a couple other pertinent parameters (start and end position of the 
selection) unique to the condidtion (you can find out using the MSDN 
library on line for the function parameters)

'SendMessage' must be used if it is a multi-line edit box.

At this juncture, the edit box text will be highlighted.

In the hidden form, once the edit box is found and the Message is sent to 
it, you can exit that loop and close the hidden form or send a CloseWindow 
command to it.


That's it.

Alternately, ask nicely of RBTI for an enhancement that you can pass a 
parameter to the DIALOG command to do this.






On Friday, January 12, 2018 at 10:08:44 AM UTC-5, larrylustig wrote:
>
> I'm starting a DIALOG command with a default value already in the variable 
> used by the DIALOG.
>
> The appearance is that the cursor is positioned at the beginning of the 
> value in the DIALOG's input edit.
>
> I would prefer the value to be already selected so that anything the user 
> enters *replaces* what's there already.  I cannot find anything in the 
> OPTIONS documentation to pre-select the value display.
>
> Anyone know if this is possible.
> --
> Larry
>

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

[Michael Byerley]

This might help...

http://bfy.tw/G0s4


On Thursday, January 4, 2018 at 4:45:05 PM UTC-5, jim wrote:
>
> We are looking into having our customers be able to order product directly 
> into RBASE from the web.
>
> They of course would fill out a form, create a user name and password and 
> be able to order.
>
> This would also give the ability for them to print certain reports showing 
> what they ordered.
>
> Anyone out there use a specific software that you have found helpful in 
> this case?
>
>  
>
> You can send directly to my email if you want.
>
>  
>
> 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 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: Training R:BASE Elite in Asia (September 2017)

[Michael Byerley]

 Razzak, You know I am not going to pronounce that right...  :)

On Saturday, September 16, 2017 at 8:12:21 PM UTC-4, A. Razzak Memon wrote:
>
> Having fun in Phuket, Thailand (Training R:BASE Elite in Asia (September 
> 2017) 
>
> http://www.razzak.com/training/001.jpg 
> http://www.razzak.com/training/002.jpg 
> http://www.razzak.com/training/003.jpg 
> http://www.razzak.com/training/004.jpg 
> http://www.razzak.com/training/005.jpg 
>
> http://www.facebook.com/rbase 
>
> Very Best R:egards, 
>
> Razzak 
>
>
>

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are 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.

[RBASE-L] - Re: Rbase

[Michael Byerley]

I've run A/R - A/P from RBase since 4.5.  Consolidated stuff goes to the 
CPA for taxes, etc.

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.

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

[Michael Byerley]

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: From The Edge: Optimizing R:BASE Cloud Applications

[Michael Byerley]

I would argue strongly against storing a comma separated list directly in a 
text (or any textual based) column.  

it wreaks havoc on import/exports.  

You should employ a conversion to something handy, like the # symbol or 
such before storing as it's not much of a trick to wind and unwind it in 
runtime

On Wednesday, December 21, 2016 at 10:00:01 AM UTC-5, A. Razzak Memon wrote:
>
> Wednesday, December 21, 2016 
>
>  From The Edge.: Optimizing R:BASE Cloud Applications 
> Product...: R:BASE X, R:BASE X Enterprise (Version 10) 
> Build.: 10.0.2.11130 or higher www.rupdates.com 
> Section ..: Multi-User Environment Considerations 
> Environment...: Microsoft Windows Server 2012R2 
>
> The ability to fine tune R:BASE itself is one of the many enhancements 
> added 
> over the years. Most often, R:BASE is able to make the right decisions 
> about 
> the best way to process commands. 
>
> Generally, you know your database and application code better than anyone 
> else. However, you should always take advantage of the latest enhancements 
> and syntax, and pick the most efficient method if given the opportunity. 
>
> Did you know that there are four settings that can improve performance in 
> a multi-user environment with Cloud applications? 
>
> . STATICDB 
> . ROWLOCKS 
> . FASTLOCK 
> . PAGELOCK 
>
> A technical document on Optimizing R:BASE Cloud Applications is now 
> available. 
>
>  From The Edge: http://www.razzak.com/fte 
>
> Article Title: Managing User Privileges in R:BASE X/XE (Version 10) 
>
> 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.

[RBASE-L] - Re: getdate function default date

[Michael Byerley]

I have an rbase form calendar that has a few options including the feature 
of setting a beginning date.  Its been around since 7.6 and doesn't eat up 
a lot of screen real estate:

Give it a shot:  http://www.byerley.net//Download_A/RbCalendar.zip




On Wednesday, December 14, 2016 at 2:56:25 PM UTC-5, dang wrote:
>
> Is there a way to default the starting date in the getdate function other 
> than today? I have looked around and cannot find it.
>
>  
>
> TIA
>
>  
>
> *Dan Goldberg*
>
>  
>
>  
>

-- 
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: Override field EEPs

[Michael Byerley]

wouldn't something as SIMPLE as an IF condition test at the beginning of 
the EEP do this and if the criteria is more than one, how about a SWITCH 
test?



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

[Michael Byerley]

Hey, I think anything that boots in under 30 seconds is pretty darn fast...

  My Texas instruments desktop professional, windows 2.1, 640k Ram, 4.77 
mhz processor with math co-processor, 20mb harddrive (it's 10mb predecessor 
was all I would ever need, so the salesman said), with Autocad 1.0 loaded, 
a screen regen of a huge 450k file took a couple of minutes.  
I bought that machine new in Nov '83 and I keep copy of invoice in my desk 
just for perspective (almost $8000.00), so everything is pretty zippy 
today, by any stretch of the imagination.

I am sure most folks would be satisfied with just about any middling 
equipped laptop that falls toward the top end as far as reliability is 
concerned.

Windows 10, I can't fault at all since "most" apps I use are launched from 
the taskbar of the desktop.  The more I use it, the more the niggling 
little things that were objectionable disappear in the rearview mirror.


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]

Javiar,

  FYI, 

  My HP envy I-7 16GB 500GB harddrive Win10,  starts from 0 to login screen 
in under 17 seconds.  It starts just as fast as my Surface 4 Pro with the 
same specs.



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

[Michael Byerley]

Glad you got it handled.  When there is a lengthy argument list and I am in 
control of the creation of the Win32 DLL, I usually pass ALL the arguments 
as text, then parse the string and massage the argument to its correct 
datatype inside the Win32 DLL.


On Saturday, August 6, 2016 at 8:45:44 PM UTC-4, Buddy Walker wrote:
>
> Can someone give me a hint as to what I should be looking for.
>
>  
>
> I’m trying to use a dll that requires 25 arguments from the database.
>
>  
>
> When I Execute the STDCALL FUNCTION ….. everything is ok
>
>  
>
> Now when I try sending the using the DLCALL
>
>  
>
> SET VAR v2 = (DLCALL(‘dllfilehere’,’function’ list of variables I receive 
> this error
>
>  
>
>  
>
> -ERROR- DLCALL(TEXT,DATE) is not valid. (2152)
>
>  
>
>  
>
> Thanks for any clues as to what I should be looking for.
>
>  
>
> Buddy
>
>  
>
>  
>

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

[Michael Byerley]

The question cannot be answered without knowing the original function 
declaration in the DLL, your STDCALL declaration and the datatypes of the 
variables you are passing.  STDCALL is simply a roadmap between the 
original function in the DLL and the endpoint DLCALL function and won't 
create an error unless you totally fritz the syntax.


On Saturday, August 6, 2016 at 8:45:44 PM UTC-4, Buddy Walker wrote:
>
> Can someone give me a hint as to what I should be looking for.
>
>  
>
> I’m trying to use a dll that requires 25 arguments from the database.
>
>  
>
> When I Execute the STDCALL FUNCTION ….. everything is ok
>
>  
>
> Now when I try sending the using the DLCALL
>
>  
>
> SET VAR v2 = (DLCALL(‘dllfilehere’,’function’ list of variables I receive 
> this error
>
>  
>
>  
>
> -ERROR- DLCALL(TEXT,DATE) is not valid. (2152)
>
>  
>
>  
>
> Thanks for any clues as to what I should be looking for.
>
>  
>
> Buddy
>
>  
>
>  
>

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

[RBASE-L] - Re: Monroeville SAT

[Michael Byerley]

Yeah Tom, I am speechless too! Ha

Seriously though, anyone that hasn't recycled "themselves" through a SAT in 
a while, should make a bee-line for the nearest one to you.  

There just isn't anyway on earth that you won't come away with nuggets and 
time-savers that will justify the meager amount it costs to get there for a 
couple days.. 

Really, you won't be disappointed.





On Friday, June 24, 2016 at 10:08:29 AM UTC-4, tom.frederick wrote:
>
>  
>
>  
>
> Tom Frederick
>
> President/CEO
>
> Elm City Center
>
> 1314 W Walnut
>
> Jacksonville, IL 62650
>
> O-217-245-9504
>
> F-217-245-2350
>
> tom.fr...@elmcity.org 
>
>  
>

-- 
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] - New GATEWAY EXPORT setting

[Michael Byerley]

Born within the braintrust of the current SAT in Monroeville PA, Gateway 
EXPORT has added the following Option:

GATEWAY EXPORT OPTION ONLY_TABLE TableName

This will restrict the ability for a user to select data for export that 
they shouldn't have access to.

It still allows the selection of the target format of the export.

This will be in the next update of RBX.

-- 
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] - Like/Contains Question

[Michael Byerley]

Edit All from customer where (sget(firstname,1,1)) = 'p'


On Wednesday, April 13, 2016 at 11:40:46 AM UTC-4, paul wrote:
>
> I’m using the latest 9.5(64) and having a brain freeze this morning. I’m 
> trying to do an edit using where all the values of a column begin with the 
> letter ‘P’. I’ve tried 
>
>  
>
> edit all from customer where firstname contains ‘P%’
>
> edit all from customer where firstname like  ‘P%’
>
>  
>
> Suggestions please.
>
>  
>
> Thanks, 
>
> Paul Buckley
>
>  
>

-- 
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: Did I lose a report setting in RBase X?

[Michael Byerley]

In Report Designer>Report, the icons next to the report section are 
"depressed or selected" to make the band appear in the report designer and 
reversed to do the opposite.


On Monday, April 4, 2016 at 10:09:28 AM UTC-4, karen...@cs.com wrote:
>
> This morning my report designer seems to have lost the grey "band" that 
> distinguishes where one section begins and end.  This is making it 
> difficult to distinguish what is where!  Is there an individual setting I 
> can change?  
>
> See the attached screen (love being able to send attachments!)
>
> [image: rb.png]
>
>
>
> 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.
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/68d22b2c-c20c-4112-90c2-25428c6b57bf%40googlegroups.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.