[RBASE-L] - Thanks to the DreamTeam

because of a new data type they created. There is no place on the planet to get response and service like this. My heartfelt thanks the DreamTeam and Razzak for putting them together and making us look good. I can't wait to see everyone in Las Vegas. Thanks, Paul Buckley -- For group guidelines

RE: [RBASE-L] - Determining operating condition -- Standalone vs. Scripted

Razzak, You sneaky dog, this is very cool. I will start using this right away. Thanks, Paul Buckley -Original Message- From: rbase-l@googlegroups.com On Behalf Of A. Razzak Memon Sent: August 17, 2018 11:12 AM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - Determining operating

RE: [RBASE-L] - Setting the Stage for the R:BASE X.5 Official Unveiling

Razzak, It looks great. I can't wait to see you and everyone else this weekend. I'm bringing extra socks too.  Paul Buckley -Original Message- From: rbase-l@googlegroups.com On Behalf Of A. Razzak Memon Sent: October 15, 2018 1:20 AM To: rbase-l@googlegroups.com Subject

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

to the user. Best I got right now, Paul From: rbase-l@googlegroups.com On Behalf Of Doug Hamilton Sent: October 31, 2018 4:30 PM To: R:Base List Subject: [RBASE-L] - After-Printing EEP Hi All - I have a one-page worksheet report that I want to have update a datetime column after

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

Bill, Thanks for the heads-up on these system variables, I had forgotten all about them. I just tested this though and if the initial print command sends the report to the screen and the user prints from the menu, RBTI_RSTAT_DEV is set to Screen. Wanted you & Doug to know.

RE: [RBASE-L] - Released: R:BASE X.5/X.5 Enterprise (Version 10.5) - Add-on Products

Razzak & the Dream Team, Thanks for the updates & THANK YOU for the enhancement to Enhanced DB Grid control so I can turn off the vertical scroll bar. I've already modified my primary database with that need and rolled it out to users. You guys are the best, Paul Buckley -

RE: [RBASE-L] - Enhanced DB Grid Question - Version 10X

Bill, One word – R:DOCS. It pays for itself the first time you use it. By the 500th time you’ve gotten your money’ worth a 1000 times over. Paul From: rbase-l@googlegroups.com On Behalf Of Bill Eyring Sent: December 17, 2018 4:13 PM To: rbase-l@googlegroups.com Subject: RE: [RBASE-L

RE: [RBASE-L] - Enhanced DB Grid Question - Version 10X

Bill, Have you looked at the property SELECTEDINDEX for Enhanced DB Grid? That may do what you need. Good luck, Paul Buckley From: rbase-l@googlegroups.com On Behalf Of Bill Eyring Sent: December 17, 2018 2:10 PM To: rbase-l@googlegroups.com Subject: RE: [RBASE-L] - Enhanced DB

RE: [RBASE-L] - Enhanced DB Grid Question - Version 10X

Bill, I should have said, it’s ONLY $49 a year. Need I say more. Paul From: rbase-l@googlegroups.com On Behalf Of Bill Eyring Sent: December 17, 2018 4:13 PM To: rbase-l@googlegroups.com Subject: RE: [RBASE-L] - Enhanced DB Grid Question - Version 10X Paul Works as I need

[RBASE-L] - More Praise for RBTI

nday morning rant. But once again my heart felt thanks to Razzak & the Dream Team for making my life easier and making me look better than I am. Thanks, Paul Buckley -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message bec

RE: [RBASE-L] - SQL Help - OT

Dan, It will always be the previous row. I would sort on the ID1 column so it would always be the previous row. Thanks, Paul From: rbase-l@googlegroups.com On Behalf Of Dan Goldberg Sent: November 27, 2018 10:09 AM To: rbase-l@googlegroups.com Subject: RE: [RBASE-L] - SQL Help - OT

RE: [RBASE-L] - SQL Help - OT

Dan, Thanks but it’s only coincidental that the sample I created I needed the “odd” rowid’s. My guess is it will be 50/50 odd or even. What I need is to check ID1 & ID2 and if the ID1 from the next row equals the ID2 from the previous row I don’t select that row. Thanks anyway,

RE: [RBASE-L] - SQL Help - OT

' and T1.PART_ID = T2.PART_ID and T2.ROWID = (T1.ROWID + 1) and T1.ID = T2.APROPERTY_4 Thanks again for everyone’s help, Paul Buckley From: rbase-l@googlegroups.com On Behalf Of Doug Hamilton Sent: November 27, 2018 2:55 PM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - SQL Help - OT

[RBASE-L] - SQL Help - OT

-00112 8 PV216365006R -00112 -00111 I know how I’d do this in a Declare statement in R:BASE but as I said, it has to be done with a SQL select command. Any blues clues would be greatly appreciated. TIA, Paul Buckley

RE: [RBASE-L] - Capturing a signature

Dan & Jan, They still do, it’s on their website. Paul Buckley From: rbase-l@googlegroups.com On Behalf Of jan johansen Sent: January 09, 2019 12:11 PM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - Capturing a signature R:Base had a product back in V8 days ca

RE: [RBASE-L] - Tip of the Day: Enhanced Search Filters for the Database Versions Utility

Thanks, very nice. Paul Buckley -Original Message- From: rbase-l@googlegroups.com On Behalf Of A. Razzak Memon Sent: February 15, 2019 12:30 AM To: rbase-l@googlegroups.com Subject: [RBASE-L] - Tip of the Day: Enhanced Search Filters for the Database Versions Utility Friday, February

RE: [RBASE-L] - Tip of the Day: Multi-View Command File Support in R:BASE Editor

Razzak, The Dream Team frightens me. You need to get out of my head and quite implementing ideas before I express them. I will use this right away. Thank you all, -Original Message- From: rbase-l@googlegroups.com On Behalf Of A. Razzak Memon Sent: February 05, 2019 11:03 AM To:

[RBASE-L] - Confirm Delete Using DELROW Command

. Then the DELROW command also asks for confirmation to delete the row. I can’t find a parameter to get the DELROW command to not confirm. Any blues clues would be very useful. Thanks, Paul Buckley -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You

RE: [RBASE-L] - Confirm Delete Using DELROW Command

Thanks Dan & Karen, Brain freeze. The delete rows from table doesn’t prompt you if you run it in an EEP. Thanks again, Paul From: rbase-l@googlegroups.com On Behalf Of Dan Goldberg Sent: December 12, 2019 11:14 AM To: rbase-l@googlegroups.com Subject: RE: [RBASE-L] - Confirm De

RE: [RBASE-L] - Confirm Delete Using DELROW Command

Also, can I turn off the confirm with ‘Delete Rows from table XYZ’? Thanks, Paul From: rbase-l@googlegroups.com On Behalf Of p...@buckleyandassoc.com Sent: December 12, 2019 9:48 AM To: rbase-l@googlegroups.com Subject: [RBASE-L] - Confirm Delete Using DELROW Command Good morning

[RBASE-L] - Find the 8 Digit Color Number

Good afternoon, I’m using the latest build of R:BASE X.5 Enterprise. I know Razzak showed us an easy way to get the 8 digit color number of a color and I can’t find any notes or figure out how to do it. Anyone else out there remember? Thanks, Paul Buckley -- For group guidelines

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

Doug, Attached is spreadsheet that is more current than Buddy’s. We can chat offline about how I’m doing this. Thanks, Paul From: rbase-l@googlegroups.com On Behalf Of Doug Hamilton Sent: February 25, 2020 7:16 AM To: R:Base List Subject: [RBASE-L] - Sending text messages

RE: [RBASE-L] - My first day in the Home Office (No, not in the British sense!)

of them are R:BASE friends. But it warms my heart to read this and be vividly reminded of a good friend in Emmitt. Take care everyone in this community as we all navigate uncharted waters. Stay safe and be healthy. Thanks again Razzak, Paul Buckley -Original Message- From: rbase-l

[RBASE-L] - Crystal Reports & R:BASE Extreme X.5

because of COVID-19 I’m wondering if I can print them from my application. TIA, Paul Buckley -- 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 u

RE: [RBASE-L] - Crystal Reports & R:BASE Extreme X.5

Javier, I forgot to mention that the reports from Crystal are based on a SQL database and not R:BASE. Thanks, Paul From: rbase-l@googlegroups.com On Behalf Of javier.valen...@vtgonline.com Sent: October 01, 2020 4:05 PM To: rbase-l@googlegroups.com Subject: RE: [RBASE-L] - Crystal

RE: [RBASE-L] - Claudine Robbins

Karen, Thanks for the update. This is such sad news. Claudine was such a “nice lady”. I always enjoyed talking to her at RBASE functions. Coming from the south myself I would describe her as a real lady. My prayers go out to her family and friends. Paul From: 'Karen Tellef' via

RE: [RBASE-L] - scheduling jobs

cents worth, anyway, Good Luck, Paul Buckley From: rbase-l@googlegroups.com On Behalf Of Kayza Kleinman Sent: December 23, 2020 1:37 AM To: rbase-l@googlegroups.com Subject: RE: [RBASE-L] - scheduling jobs Choice #1 makes a lot more sense for what I am doing. Thanks! <ht

[RBASE-L] - Check for Internet Connection

Good morning everyone, I seem to remember there is a function to check to see if you have an Internet connection. I can’t remember what it is or how to use it. Any Monday morning blues clues? I am using the latest build of R:BASE X.5Enterprise. Thanks in advance, Paul Buckley

RE: [RBASE-L] - Check for Internet Connection

Razzak, As ALWAYS, you are the best. I knew it was there and I just couldn't remember where. Thanks, Paul -Original Message- From: rbase-l@googlegroups.com On Behalf Of A. Razzak Memon Sent: November 16, 2020 9:21 AM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - Check

RE: [RBASE-L] - Re: SQL book

Better still, the one on Amazon is used and is $112.91. What a bargain. Paul From: rbase-l@googlegroups.com On Behalf Of anthonydluck Sent: January 21, 2021 3:20 PM To: RBASE-L Subject: [RBASE-L] - Re: SQL book Well this is a trip down memory lane, while this isn't the same book you

RE: [RBASE-L] - FORM development | Test Mode

play when I run an application and obviously don’t work on compiled apps either. I can definitely see the advantage and help with the fields you are displaying also – I may steal this idea.  Thanks for sharing Paul Buckley From: rbase-l@googlegroups.com On Be

[RBASE-L] - Compiled Application Question

” in the RBASE EXE shortcut and interrogate them inside and pass them appropriately. Anyone have any experience passes command line parameters when starting up an RBASE EXE? Thanks in advance, Paul Buckley RBASE X.5 Enterprise Version 10.5.3.20517 RBASE X.5 Compiler Version

RE: [RBASE-L] - Loadfilenameplus with initial directory

Karen, I use the below code in one of my applications. Don’t know if this is what you’re looking for. Paul SET VAR vweekday = (TDWK(.#DATE)) SET VAR vfullpath = ('C:\BAO\' + .vweekday + '\') CLS SET VAR vcommand = ('PLUGINS loadfilenameplusplus.rbl vFileName |FULLPATH OFF

RE: [RBASE-L] - Suggestions on Using AutoCHK in a Command File

Doug, Thanks for the code, I’ll look it over along with the rest. I’m sure glad I never remove autonum columns and forget to put them back. Cough!!! Have a great weekend, Paul From: rbase-l@googlegroups.com On Behalf Of Doug Hamilton Sent: April 23, 2021 1:47 AM To: rbase-l

[RBASE-L] - Suggestions on Using AutoCHK in a Command File

 Thanks, Paul Buckley -- 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

RE: [RBASE-L] - Suggestions on Using AutoCHK in a Command File

Karen, WOW – thanks. I’ll give this a look over. I appreciate this.  Paul Buckley From: 'Karen Tellef' via RBASE-L Sent: April 22, 2021 10:19 AM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - Suggestions on Using AutoCHK in a Command File Ready for a big chunk of code

RE: [RBASE-L] - Enhanced Grid Question

view_working_sri_po_custom 'OPEN' PROPERTY TABLE view_working_sri_po_custom 'RestoreOrderBy' RETURN That’s my 2 cents worth, Paul Buckley R:BASE X.5 Enterprise Version 10.5.3.20119 From: rbase-l@googlegroups.com On Behalf Of javier.valen...@vtgonline.com Sent: January 26

RE: [RBASE-L] - Capture a file Name possible

INTEGER vFileName = OK TEXT Worth a look in my opinion. Good luck, Paul Buckley From: rbase-l@googlegroups.com On Behalf Of Tony IJntema Sent: July 26, 2021 2:50 AM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - Capture a file Name possible

RE: [RBASE-L] - Like/Contains Question

Thanks, I knew it was simple, what I have to do was create a variable vcommand and execute that. Thanks again, Paul -Original Message- From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of A. Razzak Memon Sent: Wednesday, April 13, 2016 12:08 PM To: rbase-l

[RBASE-L] - SQL Update Question

After the update command is issued: Table1 Number1 Name1 111 Tom 111 Tom 222 Steve 333 Bob 333 Bob I hope this makes sense. TIA, Paul Buckley

[RBASE-L] - RBFileOperations Question

st with a single quote around each filename and the second without. Any blues clues? TIA 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

[RBASE-L] - RE: Setting the Stage for R:BASE X.5 Official Unveiling

Let me add my heart felt thanks also. As Steve said, X.5 did not disappoint and I’m equally ready to install it and once again have R:BASE make me look good. Can’t wait until the 25 year celebration. Thanks again, Paul Buckley Sent from my iPad On Oct 21, 2018, at 12:32 PM, Steve Vellella

RE: [RBASE-L] - CPU Usage 100%, RBXE5 on Win 7

s. I downloaded today's updates but haven't gotten them loaded yet. Sorry, Paul Buckley -Original Message- From: rbase-l@googlegroups.com On Behalf Of Doug Hamilton Sent: March 26, 2019 1:26 PM To: R:Base List Subject: [RBASE-L] - CPU Usage 100%, RBXE5 on Win 7 Whenever I browse a table of

RE: [RBASE-L] - Tip of the Day: Easily Enable "Find Text" in all Print Preview Screens

Razzak, As always, VERY NICE. This will come in handy. Paul Buckley -Original Message- From: rbase-l@googlegroups.com On Behalf Of A. Razzak Memon Sent: June 07, 2019 6:42 AM To: rbase-l@googlegroups.com Subject: [RBASE-L] - Tip of the Day: Easily Enable "Find Text" in

RE: [RBASE-L] - SCONNECT and SATTACH

) and have some time in the evenings. BTW, what version of R:BASE will you be using? Good luck, Paul Buckley From: rbase-l@googlegroups.com On Behalf Of jan johansen Sent: May 09, 2019 5:57 PM To: rbase-l@googlegroups.com Subject: [RBASE-L] - SCONNECT and SATTACH Group, I haven't

RE: [RBASE-L] - Rbase_form Print options?

Karen, I have a fairly large form and a Bit Button with the code below in the On Click EEP. May be this will work for you. PRNSETUP PRNSETUP LANDSCAPE PROPERTY RBASE_FORM PRINT 'FITTOPAGE' RETURN Good luck, Paul Buckley From: 'Karen Tellef' via RBASE-L Sent: April 20, 2019 9

RE: [RBASE-L] - RBTI is the best

Stephen, I can echo you praise. RBTI has helped me so many times over the years and as you say they go above & beyond when most other software companies would walk away. I always say, they make me look good. Thanks, Paul Buckley From: rbase-l@googlegroups.com On Be

[RBASE-L] - "Auto-Close" the RBASE EXE

n the main menu to find when 60 minutes has elapsed but not sure what to do then. Does someone have anything they're willing to share for this? Thanks in advance, Paul C. Buckley -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message b

RE: [RBASE-L] - "Auto-Close" the RBASE EXE

Thanks Karen, Dan & Tom, Yes, I do want to use the timeout command, I just forgot what it was called. Thanks for reminding me. I sure hope this is Friday, it's been a long week. Have a great weekend everyone, thanks again, Paul -Original Message- From: rbase-l@googlegroups

[RBASE-L] - Off Topic - Best Thermal Label Printer

at this point. Thanks in advance for your feedback, Paul Buckley Technology Coordinator Alpha Q, Inc. 87 Upton Road Colchester, CT 06415 PH: 860-537-4681 x160 Fax: 860-537-4332 Cell: 860-771-3937 DISCLAIMER: The information contained in this e-mail and any files transmitted with it are for the exclusive

RE: [RBASE-L] - RIP Bob Castanaro

peace my friend, Paul Buckley From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of Bill Downall Sent: 12 22, 2016 8:28 PM To: rbase-l@googlegroups.com Subject: [RBASE-L] - RIP Bob Castanaro After a grueling battle with cancer, long-time R:BASE developer Bob Castanar

RE: [RBASE-L] - Problem with a Select Distinct Statement

Buddy, That didn’t work either, I still get the “Database dbo not connected” error. Paul From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of Buddy Walker Sent: August 03, 2017 11:05 AM To: rbase-l@googlegroups.com Subject: RE: [RBASE-L] - Problem

[RBASE-L] - Problem with a Select Distinct Statement

p.id AS rep_id, sales_rep.NAME-ALIAS from dbo.SALES_REP Error is: SELECT DISTINCT sales_rep.id AS rep_id from dbo.SALES_REP Error is: But this works without error: SELECT * from dbo.SALES_REP Any blues clues? Thanks, Paul Buckley -- You received this mes

RE: [RBASE-L] - Problem with a Select Distinct Statement

Karen, The select * from dbo.sales_rep won’t work without the dbo. But I can’t get it working for the columns with or without it. Thanks, Paul From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com] Sent: August 03, 2017 11:59 AM To: rbase-l@googlegroups.com Subject: Re

RE: [RBASE-L] - My sincere thanks

Razzak, I agree with Albert & Claudine. I contribute so much less than what I get out of R:BASE. I only wish more software companies were as responsive to their users as you are. My sincere thanks to you and the Dream Team, Paul -Original Message- From: rbase-l@googlegroups

RE: [RBASE-L] - Problem with a Select Distinct Statement

Buddy, Bill’s suggestion of using the column number worked but if you could give me an example of what you are using that works that would be great too. Thanks, Paul From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of Buddy Walker Sent: August 03, 2017 1:50

[RBASE-L] - Determining Current Row in Enhanced DB Grid

rrent cursor" option in Declare Cursor. Any suggestions would be greatly appreciated. Thanks, Paul Buckley -- 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" g

RE: [RBASE-L] - Determining Current Row in Enhanced DB Grid

for that row. If they change anything in the row the dirty flag is set and I can update my tables accordingly. Thanks in advance for any assistance, Paul Buckley From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com] Sent: August 22, 2017 5:34 PM To: rbase-l@googlegroups.com Subject

RE: [RBASE-L] - Determining Current Row in Enhanced DB Grid

Karen, Thank you SO MUCH. With your help and lots of caffeine I think I’ve got it. Paul From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com] Sent: August 23, 2017 9:16 AM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - Determining Current Row in Enhanced DB Grid

RE: [RBASE-L] - Modifying SQL Tables with R:BASE Using ODBC Connection

end and form to search for the data I need to modify and make changes to a projected R:BASE table then update the SQL table accordingly with SSQL code. Thanks for the feedback, Paul Buckley -Original Message- From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf

RE: [RBASE-L] - refressing DB in the explorer

Jim, Have you tried running RBG95_64_Default_Settings.exe from the R:BASE program folder? This should resolve it but be warned it will reset EVERYTHING to its defaults so if you’ve customized other settings they will disappear. Paul Buckley From: rbase-l@googlegroups.com

RE: [RBASE-L] - FTP

Stephen, Sorry for the delay in responding, I’ve been buried with projects. I have a couple of projects I have integrated R:FTP & R:FTPS and it works flawlessly. Worth looking into in my opinion. Thanks, Paul Buckley From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups

RE: [RBASE-L] - Update & LTRIM

Razzak & Albert, I said in my email I was fading. My brain said leading spaces and I typed leading zeros and then when I read it before sending I read spaces. Thanks for the SQL command Razzak, that's what I was looking for. Paul -Original Message- From: rbase-l@googlegroups

[RBASE-L] - Update & LTRIM

zeros. I know I can create a Declare loop and go thru each table and do an LTRIM on each column. I’m wondering if there is a slick SQL Update command that would allow me to clean up the whole table, even if I had to run it separately for each column? Thanks in advance, Paul Buckley -- You

[RBASE-L] - Enhanced DB Grid Question #2

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

RE: [RBASE-L] - Enhanced DB Grid Question #2

Razzak, Still no luck, I even switched to using a form in RRBYW19 that had an Enhanced DB Grid on it. Other ideas? Thanks, Paul Buckley -Original Message- From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of A. Razzak Memon Sent: May 19

RE: [RBASE-L] - Password error

. Enquiring minds wanted to know. Paul Buckley From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of Alastair Burr Sent: June 15, 2017 10:34 AM To: karentellef via RBASE-L <rbase-l@googlegroups.com> Subject: Re: [RBASE-L] - Password error I spent days e

RE: [RBASE-L] - Another Enhanced DB Grid Question

Claudine, That was the first thing I tried. This isn’t happening closing the form it happens going from one field to the next in the Enhanced DB grid. Thanks, Paul From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of Claudine Robbins Sent: August 23, 2017 5

RE: [RBASE-L] - Another Enhanced DB Grid Question

Razzak, Well I thought that would be it. I've taken out all the saverow's and I still get prompted to save changes when I change cells in the Enhanced DB grid. Any other suggestions? Thanks, Paul -Original Message- From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com

[RBASE-L] - Correct Way to Save Changes Made in an Enhanced DB Grid

e settings for the db grid having an On Row Exit. The problem is, if a user changes the value in a cell and clicks the "save" button without clicking somewhere else in the grid first the changes are not saved. Any blues clues would be greatly appreciated. Thanks, Paul Buckley --

RE: [RBASE-L] - Correct Way to Save Changes Made in an Enhanced DB Grid

Razzak, I don't have a response from you on 12/14/17. Could you please repost it or send it to me personally? Thanks, Paul -Original Message- From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of A. Razzak Memon Sent: December 18, 2017 8:34 AM To: rbase-l

[RBASE-L] - Correct Way to Save Changes Made in an Enhanced DB Grid

e settings for the db grid having an On Row Exit. The problem is, if a user changes the value in a cell and clicks the "save" button without clicking somewhere else in the grid first the changes are not saved. Any blues clues would be greatly appreciated. Thanks, Paul Buckley --

RE: [RBASE-L] - Correct Way to Save Changes Made in an Enhanced DB Grid

Razzak, Thanks, I'll give this a try. I hope you, your family and everyone at RBTI has a very Merry Christmas. Paul -Original Message- From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of A. Razzak Memon Sent: December 18, 2017 9:27 AM To: rbase-l

[RBASE-L] - Enhanced DB Grid Multi-Select Option

gridID 'SELECTEDVALUES[columnname]' 'vmultiselect' ' but the variable vmultiselect is null. Any blues clues would be greatly appreciated. Thanks, Paul Buckley -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you

RE: [RBASE-L] - Suppressing main R:Base screen

David, Try moving the second Edit Using pendingjobs ... into the first form, dispatchjobs as an On After Start EEP. Good luck, Paul Buckley -Original Message- From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of DAVID FOWLER Sent: December 18, 2017 12:14 PM

[RBASE-L] - Enhanced DB Grid Multi-Select Option

Multiselect and I am able to select multiple rows. I can't find the variable that stores those selections? I've tried 'GETPROPERTY gridID 'SELECTEDVALUES[columnname]' 'vmultiselect' ' but the variable vmultiselect is null. Any blues clues would be greatly appreciated. Thanks, Paul Buckley

RE: [RBASE-L] - Sorting Question in a Form

Albert, No date. I thought that IHASH may be the answer but alas, no. The value 'AA' converts to 2145 and 'AB' converts to 2049. I'm thinking I'll have to write a while loop that pulls the value apart and uses ICHAR to come up with an integer value. Thanks, Paul Buckley -Original Message

RE: [RBASE-L] - User defined search

oc queries for users with no experience up to advanced users. Give it a try, Paul Buckley -Original Message- From: rbase-l@googlegroups.com <rbase-l@googlegroups.com> On Behalf Of dkfowler6179 Sent: May 11, 2018 2:52 PM To: RBASE-L <rbase-l@googlegroups.com> Subject: [RBASE

RE: [RBASE-L] - Blank date value

defined but all the fields and anything on the screen will be copied. Try the new form and see what happens. Just a thought. Good luck, Paul Buckley From: rbase-l@googlegroups.com <rbase-l@googlegroups.com> On Behalf Of Claudine Robbins Sent: May 25, 2018 1:05 PM To: r

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

Razzak, Congratulations on 20 years and whoopee for a user's conference again. I am so excited about both. Thanks, Paul Buckley -Original Message- From: rbase-l@googlegroups.com <rbase-l@googlegroups.com> On Behalf Of A. Razzak Memon Sent: May 16, 2018 3:00 PM To: r

RE: [RBASE-L] - SHORTFILENAME vs. LONGFILENAME

Manuel, Look at LoadFileName & LoadFileNamePlus plugins that are included with R:BASE and see if they give you what you need. Good luck, Paul Buckley 4.1.3 LoadFileName The LoadFileName plugin is used to load a file name into a variable by displaying a dialog window for the

RE: [RBASE-L] - Autofill a form field

David, A little more on lookup combo boxes, I don't think the table needs to be the table the form is based on. I've done many variable forms and variable lookup combo boxes where you choose the table to lookup from. Paul -Original Message- From: rbase-l@googlegroups.com [mailto:rbase

RE: [RBASE-L] - Autofill a form field

David, You can do this with a lookup combo box on the form as long as the form with the cities is part of the form. Hope this helps, Paul Buckley -Original Message- From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of dkfowler6179 Sent: January 31, 2018 5:29

[RBASE-L] - Position on a Specific Row in an Enhanced DB Grid

Good morning group, I'm using the latest R:BASE Extreme Enterprise and I'd like to reposition the cursor on the row I was "on" after resorting the table the DB Grid is based on. I have a row id value I can use. Any suggestions? Thanks, Paul Buckley -- For group guidelines, v

RE: [RBASE-L] - Multi-Column Sort in Enhanced DB Grid

Dan, Thanks, that worked. Is there any way you know that I can create a new sort and resort off that without closing & reopening the form? Thanks, Paul Buckley -Original Message- From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of Dan Goldberg Sent: Febr

RE: [RBASE-L] - Position on a Specific Row in an Enhanced DB Grid

Dan, Thanks so much, works perfectly. Still looking at the sort suggestion. Paul -Original Message- From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of Dan Goldberg Sent: February 13, 2018 12:49 PM To: rbase-l@googlegroups.com Subject: RE: [RBASE-L] - Position

RE: [RBASE-L] - File location and path

Jan, Look at LoadFileName Plus Plus. Below is a partial screen snip and it shows both path only & filename. I use this all the time Paul Buckley From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of jan johansen Sent: February 15, 2018 3:23 PM To: rba

RE: [RBASE-L] - Change Individual Row Colors in Enhanced DB Grid

BASE as "freaking awesome" - thanks again, Paul -Original Message- From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of A. Razzak Memon Sent: February 21, 2018 11:22 AM To: rbase-l@googlegroups.com Subject: RE: [RBASE-L] - Change Individual Row Colors

RE: [RBASE-L] - Change Individual Row Colors in Enhanced DB Grid

Razzak, I'm sorry it has taken me so long to get back to this but I've read thru your email and looked again in R:DOCS and can't see how to change the color on an individual cell or row. Sorry to bug you but what am I missing? I'm using the latest R:DOCS, I think, 10.0.3.20116. Thanks, Paul

RE: [RBASE-L] - Change Individual Row Colors in Enhanced DB Grid

Dan, Thanks I’ll give this a try. Paul From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of Dan Goldberg Sent: December 22, 2017 3:20 PM To: rbase-l@googlegroups.com Subject: RE: [RBASE-L] - Change Individual Row Colors in Enhanced DB Grid You can use

[RBASE-L] - Change Individual Row Colors in Enhanced DB Grid

Good afternoon, I’m using the latest version of R:BASE X Enterprise and I’m looking for a way to individually change the colors of rows in an Enhanced DB Grid. I’m not seeing anything in R:DOCS or the help file. Am I missing something or can this not be done? Thanks, Paul Buckley

RE: [RBASE-L] - CHKFILE problem

)) IF vchkfile <> 1 THEN SET VAR vcommand TEXT = 'MKDIR C:\temp' ENDIF Always seems to work for me. I’m using the latest version of R:BASE X but this also worked this way in 9.5. Good luck, Paul Buckley From: rbase-l@googlegroups.com <rbase-l@googlegroups.com&g

RE: [RBASE-L] - Enhanced DBGrid Refresh

, Paul Buckley From: rbase-l@googlegroups.com <rbase-l@googlegroups.com> On Behalf Of Claudine Robbins Sent: April 10, 2018 7:04 PM To: rbase-l@googlegroups.com Subject: RE: [RBASE-L] - Enhanced DBGrid Refresh Actually, I think I’ll use closing and reopening the form as a work around fo

RE: [RBASE-L] - Tip of the Day: DIALOG/PAUSE Accelerator Character Control

Razzak, Once again, you guys add something really cool and very useful for me. Thanks, Paul Buckley -Original Message- From: rbase-l@googlegroups.com <rbase-l@googlegroups.com> On Behalf Of A. Razzak Memon Sent: March 27, 2018 8:17 AM To: rbase-l@googlegroups.com Subject: [R

RE: [RBASE-L] - Tip of the Day: "Center In Work Area" Form Property Setting

Razzak & the Dream Team, Thank you all so much. This is very useful and convenient. Looking for more socks ... Paul Buckley -Original Message- From: rbase-l@googlegroups.com <rbase-l@googlegroups.com> On Behalf Of A. Razzak Memon Sent: March 21, 2018 8:15 AM T

[RBASE-L] - General Question about Views & SQL Databases

. The performance on using the final eighth view is getting very sluggish. I’m wondering if it’s worth the effort to create a single “super view” that contains all the tables & views and various where clauses. Any thoughts or suggestions would be greatly appreciated. Thanks, Paul Buc

RE: [RBASE-L] - 25th Anniversary Conference: Schedule of Events

under the circumstances. Congrats to you and what you’ve done with R:BASE. I look forward to getting the official version 11 and my conference “goody pack”. Have a great time and let everyone know I am thinking of them. Thanks, Paul Buckley From: rbase-l@googlegroups.com On Behalf Of Razzak