Re: Re[2]: [RBASE-L] - Pasting a Multi-line command at the R>

2016-05-05 Thread Michael
f harnessing the program's great power very tedious & slow -- and possibly not even cost-effective. Mike On Friday, April 29, 2016 at 7:30:02 AM UTC-7, rbytes wrote: > > Michael: > > There's a keyboard shortcut for that: > > 1. Highlight your multi-line command in the edi

Re: [RBASE-L] - How to Use Lookup value from a DIALOG Command

2016-05-05 Thread Michael
E COLUMN |POPUP_LINES 20 |POPUP_DISTINCT TRUE On Friday, April 29, 2016 at 12:02:48 AM UTC-7, rehan_wyne wrote: > > Michael, > > vResponse is the variable which will hold the returned value > > Rehan Wyne > > > > On Friday, April 29, 2016 10:59 AM, Michael <finega.

[RBASE-L] - Re: Running Rbase for Dos in Windows 10

2016-05-05 Thread Michael
Odd error. Are you getting this within a DOS window under Win 10 32bit? Worst case, you could run the DOS 4.5 version under Win 7 or earlier (perhaps even XP) under Microsoft's Virtual PC (renamed/enhanced in Win 10). Whichever OS you last used successfully. You can also run it within DosBox

[RBASE-L] - Re: Output console

2016-05-05 Thread Michael
Do you mean that the output console shows the most recent commands at the top rather than bottom? If so, I quite agree. On Sunday, March 27, 2016 at 7:25:55 PM UTC-7, Michel Séguin wrote: > > Hello group, > > Is there a way to change the up to down reading order for r:BaseX in the > outout

[RBASE-L] - Can not connect to database "ERROR"

2017-05-10 Thread michael
I have a single seat, and a 5 seat addon, and as of today, when I try to access the database from any computer in the network other than the computer that the database resides on, I get the following message. "The database is currently unavailable- It is probably open with MULTI set OFF" I

Re: [RBASE-L] - Can not connect to database "ERROR"

2017-05-10 Thread michael
It was a network issue. Windows 10 updates caused an issue with "Write Permissions" Thank you Dan, and thank you Razzak for the help. On Wednesday, May 10, 2017 at 6:40:09 PM UTC-5, michael wrote: > > Are you talking about users of the network, or users and passwords in >

[RBASE-L] - Developer Needed for DOS 7.5/9.5 Conversion to RBase X

2017-11-12 Thread Michael
iate tho completion can occur in 2018. Michael Dean, Fine Games, North Bend OR -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this

[RBASE-L] - Re: Document table

2016-04-04 Thread 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

[RBASE-L] - Re: Tip of the Day: RECALCulating Specific Variable(s)

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

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

2016-10-01 Thread 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 >

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

2016-10-01 Thread 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

[RBASE-L] - Re: Override field EEPs

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

[RBASE-L] - Re: Tip of the Day: Running Highlighted Code in R:BASE Editor

2017-04-17 Thread 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 >

[RBASE-L] - Re: Sample Applications: Designing & Deploying MDI Applications

2017-03-11 Thread 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

[RBASE-L] - Re: Compiler: How to read command line arguments.

2017-03-12 Thread Michael Byerley
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 a

[RBASE-L] - Re: Date Picker

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

[RBASE-L] - Re: Date Picker

2017-04-06 Thread 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,

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

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

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

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

Re: [RBASE-L] - Can not connect to database "ERROR"

2017-05-10 Thread Michael Brookes
Yes I can... Michael Brookes Maxima Enterprises 37 NE 29th Street Oklahoma City, OK. 73105 405-525-8899 405-525-5329 Fax www.maximaonline.com On 5/10/2017 6:23 PM, Dan Goldberg wrote: Can you open two rbase sessions to the same database on the computer that has the database? Dan *From

Re: [RBASE-L] - Can not connect to database "ERROR"

2017-05-10 Thread Michael Brookes
I have never had any users listed. This just started today. I don't even have a user set for myself on the server computer. "Which is just a computer that is networked with all the others".. Not Workgroup, but networked. Michael Brookes Maxima Enterprises 37 NE 29th Street Oklahom

[RBASE-L] - Re: Quickbooks

2017-05-09 Thread 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

[RBASE-L] - Re: Rbase

2017-05-12 Thread 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

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

2017-06-15 Thread 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

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

2017-06-15 Thread 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

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

2017-06-15 Thread 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

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

2017-05-05 Thread 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

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

2017-09-25 Thread 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

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

2017-09-25 Thread 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

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

2017-09-25 Thread 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-L] - Re: Tip of the Day: Multiple Object Editing for Object Inspector Toolbar

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

[RBASE-L] - Re: send keystroke

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

[RBASE-L] - Re: send keystroke

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

[RBASE-L] - Re: send keystroke

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

[RBASE-L] - Re: previous

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

[RBASE-L] - Re: previous

2017-10-08 Thread 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 ) *(

[RBASE-L] - Re: RBase on Linux

2018-05-17 Thread 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:

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

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

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

2018-04-17 Thread 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 =

Re: [RBASE-L] - LISTOF question 10.0.4.10913

2018-10-28 Thread 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

Re: [RBASE-L] - LISTOF question 10.0.4.10913

2018-10-28 Thread 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

Re: [RBASE-L] - LISTOF question 10.0.4.10913

2018-10-29 Thread Michael Byerley
s 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:* Sund

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

2018-11-01 Thread 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

Re: [RBASE-L] - LISTOF question 10.0.4.10913

2018-10-30 Thread Michael Byerley
n’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(syqysn4

[RBASE-L] - Re: LISTOF question 10.0.4.10913

2018-10-27 Thread 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

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

2018-10-27 Thread 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,

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

2018-10-27 Thread Michael Byerley
t; > > '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,

[RBASE-L] - Re: Convert PDF to JPG

2018-09-14 Thread 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

[RBASE-L] - Re: Convert PDF to JPG

2018-09-14 Thread 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

Re: [RBASE-L] - Re: Convert PDF to JPG

2018-09-17 Thread Michael Byerley
: "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

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

2019-02-13 Thread 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

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

2019-05-16 Thread 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.

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

2019-06-12 Thread 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

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

2019-05-14 Thread 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,

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

2019-07-13 Thread 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

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

2019-07-01 Thread 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 =

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

2019-09-03 Thread Michael Brookes
ow it down enough. I still to scroll down quite a bit even when the list shows 45 lines in the open box. 2 characters would be a big help, but 3 or more would be great. -- Michael Brookes Maxima Enterprises 37 NE 29th Street Oklahoma City, OK. 73105 405-525-8899 405-525-5329 Fax WWW.MaximaOnli

[RBASE-L] - Editable PDF output

2019-09-03 Thread Michael Brookes
on the PDF able to be editable, not just the data fields. I was hoping that only the data fields could be editable. -- Michael Brookes Maxima Enterprises 37 NE 29th Street Oklahoma City, OK. 73105 405-525-8899 405-525-5329 Fax WWW.MaximaOnline.com -- For group guidelines, visit http://www.rbase.c

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

2020-03-04 Thread 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.

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

2020-02-25 Thread Michael Byerley
AT num...@txt.att.net (SMS) AT num...@mms.att.net (MMS) T-Mobile num...@tmomail.net (SMS) T-Mobile num...@tmomail.net (MMS) Verizon num...@vtext.com (SMS) Verizon num...@vzwpix.com (MMS) Sprint num...@messaging.sprintpcs.com (SMS) Sprint num...@pm.sprint.com (MMS) XFinity num...@vtext.com (SMS)

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

2020-01-23 Thread Michael Byerley
ses 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 ho

[RBASE-L] - Re: QB help?

2020-01-18 Thread 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

[RBASE-L] - Re: QB help?

2020-01-18 Thread 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 ro

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

2020-01-19 Thread Michael Byerley
nny 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: R

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

2020-01-22 Thread Michael Byerley
nce, 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

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

2020-05-06 Thread Michael Byerley
You can indeed combine select output with literal text on the same line. >From RRBYW20: select (ContFName )=40 ,'This is some literal text'=50 from contact where limit = 10 shows: Jill Baileys This is some literal text Shelley Watts

[RBASE-L] - Re: Bill Eyring

2020-05-10 Thread 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

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

2020-03-17 Thread 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 =

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

2020-03-23 Thread Michael Brookes
drive where the "status" of a record in my "inventory" table = "MA" Thank you in advance -- Michael Brookes Maxima Enterprises 37 NE 29th Street Oklahoma City, OK. 73105 405-525-8899 405-525-5329 Fax WWW.MaximaOnline.com -- For group guidelines, visit

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

2020-03-24 Thread Michael Brookes
Karen, Thank you for the reply and the suggestion. Will try that for sure. Michael Brookes Maxima Enterprises 37 NE 29th Street Oklahoma City, OK. 73105 405-525-8899 405-525-5329 Fax WWW.MaximaOnline.com On 3/24/2020 8:31 AM, 'Karen Tellef' via RBASE-L wrote: That's a toughybut I actually did

[RBASE-L] - Re: Varchar

2020-05-20 Thread 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

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

2020-08-19 Thread 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,

[RBASE-L] - Re: Varchar

2020-05-27 Thread 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

[RBASE-L] - Re: Varchar

2020-05-26 Thread 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, > > >

Re: [RBASE-L] - Re: Varchar

2020-05-27 Thread Michael Byerley
> 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

[RBASE-L] - Re: Varchar

2020-05-25 Thread 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

[RBASE-L] - Re: Varchar

2020-05-26 Thread 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

[RBASE-L] - Re: Varchar

2020-05-22 Thread 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

Re: [RBASE-L] - Re: Varchar

2020-05-22 Thread Michael Byerley
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 va

[RBASE-L] - Re: Varchar

2020-05-21 Thread 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

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

2020-07-15 Thread Michael Byerley
t; > 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 &g

[RBASE-L] - Re: Best practices?

2020-08-04 Thread 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

Re: [RBASE-L] - Forms

2020-07-04 Thread 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:

Re: [RBASE-L] - Forms

2020-07-06 Thread 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

[RBASE-L] - Re: Forms

2020-07-06 Thread 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

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

2020-07-15 Thread 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

[RBASE-L] - Re: Claudine Robbins

2020-06-17 Thread 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

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

2020-06-25 Thread Michael Byerley
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 M

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

2020-06-25 Thread 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

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

2020-06-07 Thread 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: "

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

2020-06-07 Thread 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 imm

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

2020-06-05 Thread 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)))

[RBASE-L] - Re: scaling dialog box

2020-07-17 Thread 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,

[RBASE-L] - speeding up searches in a view

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

Re: [RBASE-L] - problem with printers in Windows 10

2016-06-09 Thread Michael J. Sinclair
Original Message- From: A. Razzak Memon <raz...@rbase.com> To: rbase-l <rbase-l@googlegroups.com> Sent: Thu, Jun 9, 2016 1:58 am Subject: Re: [RBASE-L] - problem with printers in Windows 10 At 11:49 PM 6/8/2016, Michael J. Sinclair wrote: >Hi all, > >This code see

Re: [RBASE-L] - problem with printers in Windows 10

2016-06-09 Thread Michael J. Sinclair
names that are added after the upgrade, appear to have to be \\servername\domain.com\printername Hope that helps somebody in Rbase community who is upgrading from Windows 7 to Windows 10 Mike From: Michael J. Sinclair <mj...@bellsouth.net> To: "rbase-l@googlegroups.co

[RBASE-L] - problem with printers in Windows 10

2016-06-08 Thread Michael J. Sinclair
Hi all, This code seems to work fine on Windows 7 machines... LBLPRINT scripts4x4 WHERE patnumbr = .vpnum AND refflag ='L' AND + PRINTER = 1 + OPTION PRINTER + |SHOW_CANCEL_DIALOG OFF + |PRINTER_NAME \\zeus\pos4printa When I upgraded to Windows 10, it still worked. BUT, when I tried to change the

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

2016-09-04 Thread Michael J. Sinclair
Hi All, In rbase 9.5 if I try to edit a table using this EDIT refflag FROM scripts0 WHERE patnumbr = 9363  and I hit the letter "X", and then hit the ESC key and click on save, the field changes the value to "X" BUT If I do the same thing in Rbase X, the change is not saved UNLESS I leave the

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

2023-01-12 Thread 'Ramsour, Michael A' via RBASE-L
Hi, Jan: Check out the ADDMON and ADDYR functions. You can use negative values for the second argument. Here's an example: set var vdate = (ADDMON(.#DATE,-2)) SHOW VAR VDATE 11/12/2022 Or going forward in time: set var vdate = (ADDMON(.#DATE,2)) show var vdate 03/12/2023 Hope that helps.

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

2023-07-12 Thread 'Ramsour, Michael A' via RBASE-L
Greetings! I too am a bit surprised/concerned. Our most recent communication was on July 7th. Sure hope everything is OK. Best regards. [cid:image001.jpg@01D9B4C9.9FDD58D0] MIKE RAMSOUR Senior Quality Engineer p 740.829.4340 m 740.502.1659

  1   2   >