Re: Re[4]: [RBASE-L] - Disappearing RStyle error list

rsions, that toggles the Error Messages window at the bottom of the screen on/off. Is that it? b -- Original Message --From "'Karen Tellef' via RBASE-L" To "rbase-l@googlegroups.com" Date 5/15/2024 2:45:04 PMSubject Re: Re[2]: [RBASE-L] - Disappearing RStyle error list

Re: Re[2]: [RBASE-L] - Disappearing RStyle error list

which doesn't pop? B -- Original Message --From "'Karen Tellef' via RBASE-L" To "rbase-l@googlegroups.com" Date 5/15/2024 2:27:39 PMSubject Re: [RBASE-L] - Disappearing RStyle error list Version 10.5, noticed it on several builds of it, up to the most recent Kar

Re: [RBASE-L] - Disappearing RStyle error list

rby...@safesectors.com (909) 238-9012 m -- Original Message --From "'Karen Tellef' via RBASE-L" To "RBase List" Date 5/15/2024 1:08:06 PMSubject [RBASE-L] - Disappearing RStyle error list This happens to me on and off.  I RStyle something, it'll report the errors, but

[RBASE-L] - Disappearing RStyle error list

This happens to me on and off.  I RStyle something, it'll report the errors, but I don't get the box that explains what each error is.  I do get the highlighted rows, so I can sorta see where the errors are, but I need the explanation sometimes. I've looked and can't find a setting to turn this

Re: [RBASE-L] - Version 11

Yes, assign a ComponentID to the List view.  Then in your button where you add a new member to the list, add this command at the end, substituting your componentID: PROPERTY [componendID] REFRESHLIST 'TRUE' Karen On Friday, May 3, 2024 at 12:04:20 PM CDT, wrote: I have a DB

Re: [RBASE-L] - rbase on win10

I also have windows version 6.5 running nicely on a windows 10 machine. You don’t say, but are you talking Rbase windows or DOS 6.5? None of my clients are on 6.5 anymore but I was recently running it a lot for a conversion project. You shouldn’t have a problem Karen Sent from my iPhone >

Re: Re[2]: [RBASE-L] - Disappearing text | An Old-School consideration

fornia, where electrical chaos is the order of the day. Best, Bruce Bruce A. ChitieaSafeSectors, Inc.1142 S Diamond Bar Blvd # 442Diamond Bar CA 91765-2203 rby...@safesectors.com (909) 238-9012 m -- Original Message --From "'Karen Tellef' via RBASE-L" To "rbase-l@googlegroups.com&qu

Re: [RBASE-L] - Disappearing text - an interesting discovery

geness over networks to question it.Currently on my network there is a large slowdown that occurs at random that I haven't been able to pinpoint.  Maybe Mike Byerly can shed some light on network vagaries, like random polling and such. Jan    From: "'Karen Tellef' via RBASE-L" To: "rbase

Re: [RBASE-L] - Disappearing text

'   RECALC VARIABLES    RETURN Jim On Monday, April 22, 2024 at 10:39:09 AM EDT, 'Karen Tellef' via RBASE-L wrote: Jim:  funny you should ask that.  When I edit the form from the R> prompt, it never happens (which is why I didn't pick it up when I was designing/testing).  I should

Re: [RBASE-L] - Disappearing text

On Monday, April 22, 2024 at 09:37:26 AM CDT, jan johansen wrote: Karen, Along the line of Jim's question, does the form exhibit this behavior running on your development environment i.e. not running across a network? Jan     From: "'jim schmitt' via RBASE-L" To: 'Karen Tellef' via R

Re: [RBASE-L] - Disappearing text

wrote: Karen: do you get the error if you do the 'edit using' from an R: prompt ? or is the form in question being called by another form ? JIm On Monday, April 22, 2024 at 09:03:46 AM EDT, 'Karen Tellef' via RBASE-L wrote: Javier: I think you're getting close.  Yep, I'm aware

Re: [RBASE-L] - Disappearing text

ginal message From: 'jim schmitt' via RBASE-L Date: 4/21/24 6:16 PM (GMT-06:00) To: 'KAREN TELLEF' via RBASE-L Subject: Re: [RBASE-L] - Disappearing text Karen: Another thought..If you are using just variables on a form, the last variable field will need to have another '

Re: [RBASE-L] - Disappearing text

les? > Bruce > > > -- Original Message -- > From "'Karen Tellef' via RBASE-L" > To "RBase List" > Date 4/21/2024 1:15:36 PM > Subject [RBASE-L] - Disappearing text > >> Version 10.5. Client says this happens in a couple forms, but was sporadic. >

[RBASE-L] - Disappearing text

Version 10.5.  Client says this happens in a couple forms, but was sporadic.  Finally there's a form where the issue is easy to replicate so I have something to work on. Issue: if you type something in a variable edit field and are just sitting in that field, if you wait about 30 seconds the

Re: [RBASE-L] - CVAL CONNECTIONS

What I've noticed (within my non-network-understanding limits) is that the connections don't necessarily decrease when they exit RBase, but rather when they log out of the network.  It seems the network thinks they have RBase connections still open, but not RBase itself. Karen On

Re: Re[4]: [RBASE-L] - Forms | Accessing a DBcontrol value BEFORE it is saved. | Fail

Your syntax for 'SET VAR vtest_func_textvalue' is incorrect.  That will never work.  You don't use "set var" with a "getproperty" I use the getproperty often and don't have an issue.  Brought up one of my apps and I see that I've done it a couple different ways and apparently both of them

Re: Re[2]: [RBASE-L] - Forms | Accessing a DBcontrol value BEFORE it is saved.

Your syntax is wrong.  It would be something like this: GETPROPERTY Sum1BalCurr VALUE vTBalCurr The "vTBalCurr" would be the variable that gets the value of the cell with that componentID. Karen On Saturday, March 23, 2024 at 12:19:59 PM CDT, Bruce Chitiea wrote: Thank you,

Re: [EXTERNAL] Re: [RBASE-L] - mystery character

it is some strange apostrophe that is not on my keyboard. Gunna see if I can just remove it from the fields.   Dan Goldberg   From: 'Karen Tellef' via RBASE-L Sent: Wednesday, January 17, 2024 10:46 AM To: rbase-l@googlegroups.com Subject: [EXTERNAL] Re: [RBASE-L] - mystery character  

Re: [RBASE-L] - mystery character

Dan:  I remember having to do this once.   Bring one of the records up on the edit form, where you see the "real" character".  Carefully copy just the one character. Then do a SRPL on that column.  For the first value, paste in what you copied, and replace it with a normal apostrophe Karen

Re: [RBASE-L] - Know when data has been changed in a row of data in a table.

I would use the table's "on save eep".  If the EEP is triggered, then you know the user made some kind of change.  In the EEP you would then write the name/date to the columns. Karen On Sunday, December 3, 2023 at 09:25:44 AM CST, wrote: Subject: Know when data has been changed in

Re: [RBASE-L] - email novice problems

Here's a copy of code that runs fine every day (all data is sent in by variables).  Perhaps compare to your code and see what the differences are?  It's been a long time since I've messed with this code; we embedded the host/port/authentication within the print itself for some reason rather

Re: [RBASE-L] - Where do I set my Vars?

Welcome to the not-so-wonderful world of the "REAL" datatype.  Long ago in DOS days that was the only datatype (other than currency) that allowed decimals.  Unfortunately it isn't real accurate IMO (pun intended).  Most of us switched all those Real numbers to the DOUBLE datatype.  With

Re: [RBASE-L] - I want to use a CHOOSE command to list options from a subdirectory rather than from inside a connected database.

\rbgx5e\samples\varbase.cmd The combination of the STARTUP RBase.DAT file which shows a choose box is perfect—so easy.   In order to work, all these related files must be in the same   c:\rbti\rbgx5e\samples subdirectory. Thank you for all your valuable suggestions. RandyFrom: 'Karen Tellef' via

Re: [RBASE-L] - I want to use a CHOOSE command to list options from a subdirectory rather than from inside a connected database.

Are you looking for the syntax for a choose command?  If so:choose vchoice from #Lfiles in *.rmd For clients that have multiple databases, there's typically separate desktop icons that open that database's startup file Karen On Sunday, November 5, 2023 at 01:36:32 AM CST, randyp

Re: [RBASE-L] - Looking for developers to convert old dos based application to current R:Base - Windows.

You should take this conversation private! Karen Sent from my iPhone > On Oct 22, 2023, at 11:34 AM, fjfis...@fishercg.com wrote: > >  > Thank you for your reply. I'm interested in chatting further with you, and > would be happy to supply you with what I have. Are you amenable to signing a

Re: [RBASE-L] - Getting out of an infinite loop

If you cannot connect the database single-user as Razzak suggests, trying ending the RBase session and then restarting your computer or just logging off.  Often the computer shutdown sequence will clear the files that you have "open" even tho they really aren't Karen On Sunday, August

Re: [RBASE-L] - Report Header Bands | Failure to collapse for NULL data

Try replacing your DBText fields with DBMemos and mark each memo "stretch".  I have notes that at one time I had to do that to suppress the blank space Karen On Wednesday, August 2, 2023 at 02:11:35 PM CDT, Bruce Chitiea wrote: All: While generating a five-digit Chart of Accounts

Re: SV: [RBASE-L] - Second ORDER BY parameter?

, it worked, it was as simple as that. Many thanks.Bo Franzén Från: 'Karen Tellef' via RBASE-L Skickat: den 22 juni 2023 17:53:43 Till: rbase-l@googlegroups.com Ämne: Re: [RBASE-L] - Second ORDER BY parameter? Sorry Bo, I'm probably not understanding.  Are you asking if you can sort by two columns?  Like

Re: [RBASE-L] - Second ORDER BY parameter?

Sorry Bo, I'm probably not understanding.  Are you asking if you can sort by two columns?  Like:  ORDER BY commodity ASC, tran_id ASC Karen -Original Message- From: 'Bo Franzén' via RBASE-L To: R:BASE Sent: Thu, Jun 22, 2023 10:47 am Subject: [RBASE-L] - Second ORDER BY

Re: [RBASE-L] - Building Ampersanded PROPERTY-Set Variables

I’m gonna guess that your Activate is the issue. I wouldn’t think that you could do multiple commands using a CR between in an ampersand command. Maybe if you put semicolons rather than CR? Karen Sent from my iPhone > On May 31, 2023, at 5:02 PM, Bruce Chitiea wrote: > >  > All: > > I'm

Re: [RBASE-L] - CREATE TEMPORARY TABLE fails sometimes

So from your code I'm assuming it is the CREATE that isn't working, not the drop.  I've seen that error message when trying to drop a table and there is a "declare cursor" still defined on a temp table that was never dropped.  There's only one thing I can think of with the Create, and that's

Re: [RBASE-L] - Scaling a form that is large to fit on a laptop display

As far as I know, the "fill_screen" property only works to scale something UP, not down.  We played around with using that at a client who had all different resolutions, so I designed a form for the smallest resolution then did a "fill_screen" on all the other computers, but we didn't like the

Re: [RBASE-L] - Enhanced DB Grid Popup Menu on Column

The first thing I’d try is leaving out the order by. Start with it as simple as possible? Karen Sent from my iPhone > On Apr 7, 2023, at 10:01 AM, BILL MILYARD wrote: > >  > I have a form with a popup menu on a column in an Enhanced DB Grid that > doesn't popup. Each row of the column has

Re: Re[4]: [RBASE-L] - Printing spreadsheets - got it to work!

------From "'Karen Tellef' via RBASE-L" To "rbase-l@googlegroups.com" Date 3/16/2023 1:14:31 PMSubject Re: Re[2]: [RBASE-L] - Printing spreadsheets I guess I needed to be more clear.  This is a random existing spreadsheet, has nothing to do with RBase at all Karen -Or

Re: Re[2]: [RBASE-L] - Printing spreadsheets

of tab in the workbook)   This overwrites the info in the tab you are pointing to. I use this to add info to multiple tabs in one Excel book.   James Belisle   Making Information Systems People Friendly Since 1990   From: 'Karen Tellef' via RBASE-L Sent: Thursday, March 16, 2023 1:18 PM

[RBASE-L] - Re: Printing spreadsheets

I asked a buddy of mine at the same time, and he pointed me to this: https://stackoverflow.com/questions/46901160/how-to-print-excel-by-command-line There's an example of a Powershell command, so I'm going to mess around with this  (print-screen attached) Karen  -Original Message-

Re: Re[2]: [RBASE-L] - Printing spreadsheets

-4716 | USA+011 (909) 238-9012 m | rby...@safesectors.com   -- Original Message --From "'Karen Tellef' via RBASE-L" To "rbase-l@googlegroups.com" Date 3/16/2023 11:11:51 AMSubject Re: [RBASE-L] - Printing spreadsheets This will be a "batch" operation so we wo

Re: [RBASE-L] - Printing spreadsheets

er possible source:www.windows-commandline.com/run-command-for-excel/ In the end PowerShell may be the solution. Bruce Bruce A. Chitiea | SafeSectors, Inc.112 Harvard Ave #272 | Claremont CA 91711-4716 | USA+011 (909) 238-9012 m | rby...@safesectors.com   -- Original Message --From "'Kare

[RBASE-L] - Printing spreadsheets

I've never been asked to do this before, and I have nothing in my voluminous notes Can you print an Excel spreadsheet (xlsx) from within your RBase app? Karen -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you

Re: [EXTERNAL] [RBASE-L] - OT: laptop batteries?

Subject: Re: [EXTERNAL] [RBASE-L] - OT: laptop batteries? Amazon is the way to go. There is dell batteries and others. I usually look at the ratings to determine which one i will purchase.  Dan GoldbergIT ManagerLance CamperFrom: 'Karen Tellef' via RBASE-L Sent: Monday, February 20, 2023 8:24:39 AM

[RBASE-L] - OT: laptop batteries?

Hope you all don't mind a hardware question. Need to replace my Dell laptop battery.  Seems I've heard warnings about not getting "cheap" batteries.  Battery for the Latitude 3560 is not even available on Dell's website.  Search shows everything from $23 from Secure-Battery.com to $90 from

Re: [RBASE-L] - Using Alias for column names - solution!

13, 2023 11:24 am Subject: Re: [RBASE-L] - Using Alias for column names I take it that you're using the [ " ] as your quote character. SET VAR vmonth1 TEXT = ("`Jan-23`")   Bruce -- Original Message --From "'Karen Tellef' via RBASE-L" To "rbase-l@googlegroups.com&

Re: [RBASE-L] - Using Alias for column names

TEXT = ("`Jan-23`")   Bruce -- Original Message ------From "'Karen Tellef' via RBASE-L" To "rbase-l@googlegroups.com" Date 2/13/2023 9:06:17 AMSubject [RBASE-L] - Using Alias for column names I could have SWORN I've done this before, but nothing is working.

[RBASE-L] - Using Alias for column names

I could have SWORN I've done this before, but nothing is working. I have a table with columns  Month1, Month2  Month12 I have a bunch of variables that represent the displayed months:   vMonth1 = "Jan-23", vMonth2 = "Feb-23" Trying to do an Excel Gateway export including:   Month1 AS

Re: [RBASE-L] - leading zeros and excel gateway file

I looked in my notes.  I see you're exporting to a CSV.  If you don't need a CSV, my notes say that exporting to a worksheet (XLS) rather than a work book (XLSW) retains leading zeros Karen -Original Message- From: 'jim schmitt' via RBASE-L To: rbase group Sent: Mon, Feb 6, 2023

Re: [RBASE-L] - VAR Lookup List Box PROPERTY LOOKUPWHERECLAUSE

'Karen Tellef' via RBASE-L wrote: Manuel:  When I'm constructing variables like you are, I NEVER embed the actual value in the where clause.  Too difficult to deal with quotation marks, etc.  I find that if you just do something like this:    SET VAR vWhere = 'Company CONTAINS .vSearchValue

Re: [RBASE-L] - VAR Lookup List Box PROPERTY LOOKUPWHERECLAUSE

Manuel:  When I'm constructing variables like you are, I NEVER embed the actual value in the where clause.  Too difficult to deal with quotation marks, etc.  I find that if you just do something like this:    SET VAR vWhere = 'Company CONTAINS .vSearchValue' you don't have to worry about that

Re: [RBASE-L] - weird form situations

If I'm correct, temporary tables will use whatever your SCRATCH setting is within RBase.  What do you have that set to in your app?  I would check to make sure that that setting is still accurate Karen -Original Message- From: 'Jim Belisle' via RBASE-L To: RBase Maillist Sent:

Re: [RBASE-L] - out of dynamic space epilog

"he claimed he didn't do anything".  I believe that!  Come on, how many times does a client tell you that a program doesn't work, you dial in, press the same button and it magically works??? Happy New Year everyone! Karen -Original Message- From: 'jim schmitt' via RBASE-L To:

Re: [RBASE-L] - out of dynamic space II

.   The other time was when there was a limit to the size of a drive-mapped partition, and that partition alone had run out of room Karen -Original Message- From: 'jim schmitt' via RBASE-L To: 'Karen Tellef' via RBASE-L Sent: Mon, Dec 26, 2022 1:29 pm Subject: Re: [RBASE-L] - out of dynamic

Re: [RBASE-L] - out of dynamic space II

I was gonna say that I've seen that message in two instances.  Either out of hard drive space (either server or local temp directory if you use local temp) or an issue with local memory Karen -Original Message- From: 'jim schmitt' via RBASE-L To: rbase group Sent: Mon, Dec 26,

Re: [RBASE-L] - capture autonumber field value

Are you doing an "enter using" form?  I think the autonumber doesn't get "set" until you save the record.  My experience has been that when you exit the form, your variable would then be populated and can be referenced in code after the form is exited.  But if you need it while still in the

Re: [RBASE-L] - A "null" variable image

k picture that should not take much space.I am not sure how your data is structured in you application and hopefully, the above is of help.  Javier,  Javier Valencia, PE913-915-3137   From: 'Karen Tellef' via RBASE-L Sent: Thursday, November 10, 2022 1:46 PM To: rbase-l@googlegroups.com Subject: Re:

Re: [RBASE-L] - A "null" variable image

nice option. However if you are wanting to collapse the print space when both image 3 & 4 are null, this would not help. And as you stated, the make invisible code would work as well. Robert ThompsonTTC Inc.219-363-7441 ---- Original message From: 'Karen Tellef' via RBASE-L Dat

Re: [RBASE-L] - A "null" variable image

Management 002E Pearson Hall, 125 Academy St, Newark DE 19716-4399 University of Delaware 302-831-3127 |  fax:302-831-6903 jjkra...@udel.edu |     From: 'Karen Tellef' via RBASE-L Sent: Thursday, November 10, 2022 1:53 PM To: rbase-l@googlegroups.com Subject: [RBASE-L] - A "null&

Re: [RBASE-L] - Outlook meetings?

? Karen, Please review the product page and details for R:OutLink: https://www.rbase.com/products/routlink/ Best regards, John Minyo II R:BASE Technologies, Inc. https://www.rbase.com On 10/14/2022 11:00 AM, 'Karen Tellef' via RBASE-L wrote: Someone asked me if RBase can create

Re: [RBASE-L] - Outlook meetings?

tions from another program and this article shows a way to do it. I cannot imagine why I don't think this looks like a walk in the park. Maybe someone knows of a simpler way. Good luck! Nicky On 10/14/2022 8:00 AM, 'Karen Tellef' via RBASE-L wrote: Someone asked me if RBase

Re: [RBASE-L] - Outlook meetings?

template and attach it via switch from the command line.You can Google “how to create Outlook meeting from command line” and you should get some information that will get you started.  Javier,  Javier Valencia, PE913-915-3137    From: 'Karen Tellef' via RBASE-L Sent: Friday, October 14, 2022 10:00

[RBASE-L] - Outlook meetings?

Someone asked me if RBase can create an Outlook meeting.  If anyone has done this, let me know either on or off the list (obviously we'd be willing to pay for your time) Karen -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this

Re: [RBASE-L] - Tip of the Day: Specify a Custom Font in PDF Output with Font Substitutions

I've been curious about something similar for quite a while (don't remember how long ago this started).  I have a report defined with a simple Times New Roman 12.  No bold, no effects.  But when I send it to a PDF it comes out different (no PDF options are specified).  The attached shows a

Re: [RBASE-L] - Finding Duplicates

Select col1, col2 from table group by col1, col2 having count(*) > 1 Karen Sent from my iPhone > On Sep 19, 2022, at 3:50 AM, johnd...@gmail.com wrote: > > Hi, > > I am not sure if I am missing something that already exists but I was > wondering if there is a quick way of identifying

Re: [RBASE-L] - Using Multiselect in dialog lookup

DER BY full_name ASC | POPUP_LIST_MULTISELECT 'TRUE' | +POPUP_RETURN_COLUMN emailadd |POPUP_SHOW_LINES TRUE |POPUP_RETURN_TYPE +COLUMN | POPUP_LINES 20 Dan Goldberg  From: 'Karen Tellef' via RBASE-L Sent: Monday, August 22, 2022 7:20 AM To: rbase-l@googlegroups.com Subject: Re: Re[2]: [RBASE-L] - Using Multisel

Re: [RBASE-L] - Using Multiselect in dialog lookup

DER BY full_name ASC | POPUP_LIST_MULTISELECT 'TRUE' | + POPUP_RETURN_COLUMN emailadd |POPUP_SHOW_LINES TRUE |POPUP_RETURN_TYPE + COLUMN | POPUP_LINES 20   Dan Goldberg     From: 'Karen Tellef' via RBASE-L Sent: Monday, August 22, 2022 7:20 AM To: rbase-l@googlegroups.com Subject: Re: Re[2]: [RBASE-L]

Re: Re[2]: [RBASE-L] - Using Multiselect in dialog lookup

]: [RBASE-L] - Using Multiselect in dialog lookup Karen: Your code:|POPUP_WHERE ORDER BY Company + Dan's code:| POPUP_WHERE WHERE full_name IS NOT NULL + Bruce -- Original Message --From "'Karen Tellef' via RBASE-L" To "rbase-l@googlegroups.com" Date 8/22/2022 6:46:39 AM

Re: [RBASE-L] - Using Multiselect in dialog lookup

Bruce: your code looks identical to what I use, but with one exception.  In none of the rows do I have quotation marks.  Not sure I see any other differences (mine also has a bunch of font settings I left out here).  Here's an example of a live one that works for me: DIALOG 'Enter Customer

Re: [RBASE-L] - Sending a HTML email with rmail

I had some free time, decided to test this. Right now, I send out RMail with HTML in the body, but I am inserting data into a table and then using "select... as html".  I had never used a report yet so I decided to try it. I printed my report with OPTION HTML as you did.  Right away, I noticed

Re: [RBASE-L] - using column name in report variables

I don't think I've ever tried that, but I'm not surprised it doesn't work. If it was me, I would create 2 variables (I'm winging this, so syntax might not be exactly right): VpartlocA = partnum2 in mastervendors where part# = part# and PriSupplerL = 'Y'VpartlocB = partnum2 in mastervendors

Re: [RBASE-L] - Detecting Row With Focus In Scrolling Region

Just create a form variable to the unique ID of the row (no need to use an EEP).  So focus will evaluate all the variables Karen -Original Message- From: James Burroughs To: rbase-l@googlegroups.com Sent: Thu, Jun 23, 2022 10:09 pm Subject: [RBASE-L] - Detecting Row With Focus In

Re: [RBASE-L] - Help not Working

John:  If you go into explorer, right-click on a CHM file and select "open with", what does it show?  Attached is a pic of what my windows 10 computer shows Karen -Original Message- From: johnd...@gmail.com To: RBASE-L Sent: Tue, Jun 7, 2022 7:05 pm Subject: Re: [RBASE-L] - Help

Re: [RBASE-L] - Put together two rows of data from one table

Myron: Here's a thought.  Can you use "LISTOF"?  If you had a table with a FullName column, you can do a SELECT (LISTOF(fullname)) INTO variable WHERE householdid = You could create a view or temp table with the results of LISTOF with a GROUP BY parameter.  If you want a separator other

Re: [RBASE-L] - eMail table structure

Jan: I have one application with this ability.  The structure was started by another programmer, so I don't take full credit.  It isn't perfect, as we added features over the years and would've done it differently if I had designed it today. Here's the structure of the table (not all the

Re: [RBASE-L] - Delete Trigger mystery?

of the archive table should be updated. Jim Bentley, American Celiac Society 1-504-305-2968 On Friday, March 11, 2022, 06:01:51 PM CST, 'Karen Tellef' via RBASE-L wrote: B Why I needed the before-delete trigger:  no one should ever be deleting data from this table.  And althonug

Re: [RBASE-L] - DOS command line prompt

, I can then load the values into a table for further processing.Works like a charm.   I owe you a lunch at the next R:Gathering...Thanks again Jim On Tuesday, March 22, 2022, 03:10:04 PM EDT, 'Karen Tellef' via RBASE-L wrote: Absolutely!  What you want to do is create a batch file

Re: [RBASE-L] - DOS command line prompt

Absolutely!  What you want to do is create a batch file (.BAT) that has your DIR command and you "LAUNCH" the .BAT file from within RBase.  Either have the batch file permanently there or you can create the batch file on the fly if you want it dynamic Karen -Original Message-

Re: [RBASE-L] - Delete Trigger mystery?

User:' + (CVAL('USER')) ), +   pDBLogLocation = ('IP Addr:' & (GETVAL('GetIPAddress','1')) ) Maybe one of those will help you track the errant deleter. Doug On 3/15/2022 11:48 AM, 'Karen Tellef' via RBASE-L wrote: Yes I'm set on the archive table holding the records that were deleted, easy to

Re: [RBASE-L] - Delete Trigger mystery?

are/were effectively deleted or do you have NULL entries even though nothing was deleted?BR, Adrian  Von: 'Karen Tellef' via RBASE-L [mailto:rba...@googlegroups.com] Gesendet: Samstag, 12. März 2022 01:02 An: rba...@googlegroups.com Betreff: [RBASE-L] - Delete Trigger mystery?    Why I needed the before

Re: [RBASE-L] - Delete Trigger mystery?

ou feel that records are/were effectively deleted or do you have NULL entries even though nothing was deleted?BR, Adrian  Von: 'Karen Tellef' via RBASE-L [mailto:rba...@googlegroups.com] Gesendet: Samstag, 12. März 2022 01:02 An: rba...@googlegroups.com Betreff: [RBASE-L] - Delete Trigger my

Re: [RBASE-L] - Delete Trigger mystery?

- From: Adrian Huessy To: rba...@googlegroups.com Sent: Sat, Mar 12, 2022 11:14 am Subject: RE: [RBASE-L] - Delete Trigger mystery? Karen,Quick question: do you feel that records are/were effectively deleted or do you have NULL entries even though nothing was deleted?BR, Adrian  Von:

Re: [RBASE-L] - Delete Trigger mystery?

ry? Karen,Quick question: do you feel that records are/were effectively deleted or do you have NULL entries even though nothing was deleted?BR, Adrian  Von: 'Karen Tellef' via RBASE-L [mailto:rba...@googlegroups.com] Gesendet: Samstag, 12. März 2022 01:02 An: rba...@googlegroups.com Betreff: [RBASE-L]

Re: [RBASE-L] - Delete Trigger mystery?

om Sent: Sat, Mar 12, 2022 11:14 am Subject: RE: [RBASE-L] - Delete Trigger mystery? Karen,Quick question: do you feel that records are/were effectively deleted or do you have NULL entries even though nothing was deleted?BR, Adrian  Von: 'Karen Tellef' via RBASE-L [mailto:rba...@googlegroups.com

Re: [RBASE-L] - Delete Trigger mystery?

O DELETE" RETURN I'm going to ask them if they want to try this, thanks! Karen -----Original Message- From: Robert Thompson To: 'Karen Tellef' via RBASE-L Sent: Sun, Mar 13, 2022 12:21 pm Subject: Re: [RBASE-L] - Delete Trigger mystery? Karen,  I have never done this (I think) and am

Re: [RBASE-L] - Delete Trigger mystery?

And possibly RMD files, maybe even reports? Doug On 3/13/2022 9:03 AM, 'Karen Tellef' via RBASE-L wrote: Adrian:  That's what I'm thinking some kind of "system" user without a name.  Nope, database is not accessed by any other program (client is very small, simple, very

Re: [RBASE-L] - Delete Trigger mystery?

contiguous or scattered during the day?AdrianVon: 'Karen Tellef' via RBASE-L [mailto:rbase-l@googlegroups.com] Gesendet: Samstag, 12. März 2022 20:45 An: rbase-l@googlegroups.com Betreff: Re: [RBASE-L] - Delete Trigger mystery?  Adrian:  I am assuming they were actually deleted.  Since the trigger

Re: [RBASE-L] - Delete Trigger mystery?

aren,Quick question: do you feel that records are/were effectively deleted or do you have NULL entries even though nothing was deleted?BR, Adrian  Von: 'Karen Tellef' via RBASE-L [mailto:rbase-l@googlegroups.com] Gesendet: Samstag, 12. März 2022 01:02 An: rbase-l@googlegroups.com Betreff: [RBASE-L

Re: [RBASE-L] - Delete Trigger mystery?

hat you are using double quotes?      Yes, using double quotes My help states the cval syntax is 'Computer' instead of 'ComputerName' ?     My test shows that cval "computer" and "computername" return the same result Karen -Original Message----- From: Robert Thompso

Re: [RBASE-L] - Delete Trigger mystery?

] - Delete Trigger mystery? Karen   My first thought was primary and foreign keys with cascade. So when you delete row with primary key system deletes foreign key Buddy Sent from my iPhone On Mar 11, 2022, at 7:01 PM, 'Karen Tellef' via RBASE-L wrote:  Why I needed the before-delete trigger

[RBASE-L] - Delete Trigger mystery?

Why I needed the before-delete trigger:  no one should ever be deleting data from this table.  And although they have the full version of RBase, no one knows how to "get to the R> prompt".  There is a monthend routine that the senior user runs that will delete a batch of data, but that's all

Re: [RBASE-L] - add week

When I have to "add weeks", I just add the number of days, so 56 days for 8 weeks Karen -Original Message- From: Dan Goldberg To: rbase-l@googlegroups.com Sent: Thu, Mar 10, 2022 9:19 am Subject: [RBASE-L] - add week I have a need to add 8 weeks to a date variable. I looked

Re: [RBASE-L] - Refresh an External Form

Was wondering if it was only me.  I got it once a day for 4 days straight so far, as if it's on some kind of automatic repeat once a day at the same time maybe? Karen -Original Message- From: Bruce Chitiea To: rbase-l@googlegroups.com Sent: Wed, Feb 9, 2022 6:09 pm Subject: Re:

Re: [RBASE-L] - WHERE

Can't you use a good old-fashioned form variable?  Just define a form variableequal to the PK or some other identifier of the row the user has just clicked on?You can use a "getproperty" in the grid eep, but form variables are very easy Karen -Original Message- From: Dick Fey To:

Re: [RBASE-L] - Multi-User commands Best Practices

Go ahead and flame me on this one, but I've had the same modus operandi ever since I think version 9.0 I don't use CFG files.  Ever.  Anywhere.  I have no clue where/if they are installed, nor where they are.  And to this day it has never presented a problem in any of my installations.  To me

Re: [RBASE-L] - Extraction de données / Data Extraction

Doug:  once you know the trick of replacing spaces with commas and doing an "item count", isn't it crazy how many uses that has?  I just had to use this technique again this week. Karen -Original Message- From: Doug Hamilton To: rbase-l@googlegroups.com Sent: Fri, Jan 28, 2022

Re: [RBASE-L] - How to navigate to a specific table row and display it on a form

I've only been able to do this one way.  I don't have the app in front of me, so just going by memory. Create a single-table view of the table using a variable, such as:   set var vID INT   create view vTable as select * from Table where id = (.vID) After you select the dropdown search

Re: [RBASE-L] - Export to a specific sheet in Excel

Jim:  You use these 2 options in the gateway export command:     SHEET_NAME Detail | SHEET_INDEX 0 The sheet index changed at some point from starting at 1 to starting at 0.  I think it's 0 right now.  I haven't tested it recently but at one point it saved it with the last tab being the one in

Re: [RBASE-L] - Resettable Cursor

Hi Bruce!  I'm unclear what you mean by "resettable cursor".  Do you mean using the  OPEN c1 RESET   command within a DECLARE CURSOR loop? If so, quickly I'll mention that I use the RESET all the time if I am embedding a second cursor within the first cursor, but that's the only time I use it. 

Re: Re[2]: [RBASE-L] - Windows 11?

912-8678 f -- Original Message ------From: "'Karen Tellef' via RBASE-L" To: "rbase-l@googlegroups.com" Sent: 12/17/2021 7:24:29 AMSubject: Re: [RBASE-L] - Windows 11? Cool, I'll send them that print-screen.  And good to have Myron's first-hand experience too Karen

Re: [RBASE-L] - Windows 11?

At 09:51 AM 12/17/2021, 'Karen Tellef' via RBASE-L wrote: >I was just asked if RBase is well behaved with Windows 11.  I don't >know anyone who has Win11 yet, so I'm curious if anyone on this list >is using it.  They are on X.5, so no old versions to worry about. > >Karen -- For g

Re: [RBASE-L] - Windows 11?

no problems. Our organization app runs as it did on Windows 10.And, I’m finding Windows 11 to be a nice upgrade even this early in the life cycle.  Myron Finegold  From: 'Karen Tellef' via RBASE-L Sent: December 17, 2021 7:52 AM To: rbase-l@googlegroups.com Subject: [RBASE-L] - Windows 11?  I

[RBASE-L] - Windows 11?

I was just asked if RBase is well behaved with Windows 11.  I don't know anyone who has Win11 yet, so I'm curious if anyone on this list is using it.  They are on X.5, so no old versions to worry about. Karen -- For group guidelines, visit

Re: [RBASE-L] - Announcement: R:BASE "Community" Facebook Group

Yeah the writing was on the wall, wasn't it?  Yahoo groups gone, now I think Google groups are on the way out too.  Of the dozen groups I was a member of at one time, RBase, RStreet and one horse-related group are the only ones left. I work for my village's government, and whether you like

  1   2   3   4   >