[RBASE-L] - DBGrids vs. Scrolling Regions

Sitting here watching the French Open on a Sunday.. and thinking about something that I've always struggled with in RBase. Scrolling regions have been there for decades, used to be the ONLY way for us to display multi-row data! When DBGrids were introduced in 7.x, IMO they've always looked

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

That's what I do, exactly as Razzak suggests. When you get it to work "manually", then do a PRNSETUP INFO and you'll get a list of exactly how to reference the name, the tray, etc. Just copy and paste the info into your command! Karen -Original Message- From: A. Razzak Memon

Re: [RBASE-L] - Putting RBase shortcut on taskbar

it. Javier, Javier Valencia, PE O: 913-829-0888 H: 913-397-9605 C: 913-915-3137 From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com] Sent: Wednesday, May 25, 2016 5:12 PM To: rbase-l@googlegroups.com Subject: [RBASE-L] - Putting RBase shortcut on taskbar Computers are Windows 7

Re: [RBASE-L] - R prompt editing

I miss the DOS days when you could do a "edit buildingcost=50 from" Karen -Original Message- From: Bill Downall To: rbase-l Sent: Tue, Jun 14, 2016 8:34 am Subject: Re: [RBASE-L] - R prompt editing David, I don't think

Re: [RBASE-L] - R prompt editing

SWEET Karen -Original Message- From: A. Razzak Memon To: rbase-l Sent: Tue, Jun 14, 2016 9:01 am Subject: Re: [RBASE-L] - R prompt editing At 09:04 AM 6/14/2016, Fitts, David A. wrote: >Greetings everyone, > >When I use a

Re: [RBASE-L] - DBGrids vs. Scrolling Regions

them running in production. If you need an example, let me know. Dan Goldberg From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com] Sent: Sunday, June 5, 2016 9:14 AM To: rbase-l@googlegroups.com Subject: [RBASE-L] - DBGrids vs. Scrolling Regions Sitting here watching the French Open

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

Dan is right. If you have vDate predefined, then RBase just has to do one thing: Is this row > 6/3/15? But in your first command it has to do two things as it goes thru each row: what is the value of (.#date - 365), then is this row > that value? Karen -Original

Re: [RBASE-L] - plus sign for multiple rows in detail section

I can't think of a control to do it. I can only think of a kludgey workaround. You can display the single row by making it from a view with a "where limit = 1". Then when the form starts, count how many detail rows there actually are. If there's >1 then display a button that has a + sign

Re: [RBASE-L] - Putting RBase shortcut on taskbar

RE: [RBASE-L] - Putting RBase shortcut on taskbar Karen, My response was in reply to your reference to Win 7 Pro… Can’t speak to Win 8. Brad From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com] Sent: Thursday, May 26, 2016 8:24 AM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - P

Re: [RBASE-L] - Putting RBase shortcut on taskbar

hin the post. Javier, Javier Valencia, PE O: 913-829-0888 H: 913-397-9605 C: 913-915-3137 From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com] Sent: Thursday, May 26, 2016 6:45 AM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - Putting RBase shortcut on taskbar Yep, we checked agai

Re: [RBASE-L] - Putting RBase shortcut on taskbar

operties appropriately, then pin to the taskbar, I then follow my prior steps to further adjust the properties as desired. Hope this helps, Brad From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com] Sent: Thursday, May 26, 2016 8:31 AM To: rbase-l@googlegroups.com Subject: Re: [RB

Re: [RBASE-L] - I need to redefine a function key.

Action. Jim Bentley, American Celiac Society 1-504-305-2968 From: karentellef via RBASE-L <rbase-l@googlegroups.com> To: rbase-l@googlegroups.com Sent: Wednesday, June 1, 2016 9:44 AM Subject: Re: [RBASE-L] - I need to redefine a function key. Yep I understand! I'

Re: [RBASE-L] - I need to redefine a function key.

Dennis: Are you talking about being in a form or being in the data browser? If in a form, you can take the delete button out of any navigator control you have located and instead have a button for delete; there you can delete the row and do a "nextrow". You would also probably set a keymap

Re: [RBASE-L] - I need to redefine a function key.

sender, delete this message, and do not use, disseminate, or copy its contents. From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com] Sent: Wednesday, June 01, 2016 10:15 AM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - I need to redefine a function key. Dennis: Are you talk

Re: [RBASE-L] - popup menu

I've never tried using a "browse using formname" and then made a field editable. What I do is "edit using formname", and then on the "after start eep" I would do a: property table readonly 'true'. Then I individually set columns to "readonly false" like what you have. Karen

Re: [RBASE-L] - speed in form coming up

Frank out in Boston is on 9.5 64-bit (upgrading to X soon). There we run compiled, with the exe on the network, and we do not embed forms or reports. Speed doesn't seem to be an issue, and this is on a very busy database with lots of users, Oterro connections, etc.. Wish I was a

Re: [RBASE-L] - Test

I see your email. Do you see mine? If so, that's all you have to do! Karen -Original Message- From: Phillip Cecil To: rbase-l Sent: Tue, Mar 22, 2016 1:25 pm Subject: [RBASE-L] - Test Will I be emails from this group? How

[RBASE-L] - Did I lose a report setting in RBase X?

This morning my report designer seems to have lost the grey "band" that distinguishes where one section begins and end. This is making it difficult to distinguish what is where! Is there an individual setting I can change? See the attached screen (love being able to send attachments!)

Re: [RBASE-L] - body contains information

Jim: We discussed this not too long ago on the list. Unless you know html to construct the code to write a detailed RMail email body, there isn't a "simple" way to get a nice designed RBase report to appear as the body of an email (if that is what you're asking). I mentioned that what I

Re: [RBASE-L] - auto emails using the mapimail plugin

What's your email client? Is it Outlook, and is the version of Outlook different on the new computer? I never used mapimail, but I know I have saved all kinds of notes about tweaks you have to make depending on the version of outlook you have. Karen -Original Message- From:

Re: [RBASE-L] - copy variable value to clipboard

SET CLIPBOARD .vetracknum Karen -Original Message- From: Dan Goldberg To: rbase-l Sent: Wed, Jul 27, 2016 1:01 pm Subject: [RBASE-L] - copy variable value to clipboard I have a form that I want to place a button. When they

Re: [RBASE-L] - ERROR 2038 Referencing Existing Table(s)

I just tried it in RBGX (not enterprise) and like Dan got the "too many rows returned" but it did populate my variable correctly. Karen -Original Message- From: Dan Goldberg To: rbase-l Sent: Tue, Jun 28, 2016 3:25 pm Subject:

Re: Re[4]: [RBASE-L] - ERROR 2038 Referencing Existing Table(s)

5 PM Subject: Re: Re[2]: [RBASE-L] - ERROR 2038 Referencing Existing Table(s) From: "karentellef via RBASE-L" <rbase-l@googlegroups.com> To: rbase-l@googlegroups.com Cc: Okay, let's see... So I just now tested your second select command on my RBGX database and it worke

Re: [RBASE-L] - on before generate EEP

Question: are your variables defined within the report itself, or outside of the report in the while loop? If the latter, make sure your whileopt is off. Karen -Original Message- From: Jim Belisle To: rbase-l Sent: Fri, Jul 8, 2016

Re: [RBASE-L] - on before generate EEP

If the variables are calculated in PF, but the eep is in the "before generate" of the PF, then the variables haven't been calculated yet, right? Karen -Original Message- From: Jim Belisle To: rbase-l Sent: Fri, Jul 8, 2016 4:53 pm

Re: [RBASE-L] - date question

This is what I use to get last day of the month: SET VAR vEndDate DATE = ((ADDMON(.vStartDate,1))-1) Are you using DOS? If you aren't, I'd suggest getting away from using the "fillin" command. That's an old holdover from DOS days, I wouldn't be surprised if at some point it becomes an

Re: [RBASE-L] - anti virus for business

I'll tell ya what I can't recommend. Back when I used anti-virus, I used Symantec Webroot and loved it. But you could NOT exclude any files, so you couldn't exclude an RBase database... Karen -Original Message- From: Dan Goldberg To: rbase-l

Re: [RBASE-L] - Tip of the Day: Speeding Up the CONNECT Time

I have a question on this document. If you're running a compiled app, is there a property to set this "slave table display" off? Or is it a moot point because there is no "database explorer" when running RBase thru a compiler? If you have a bunch of workstations on a network running a full

[RBASE-L] - Re: ERROR- Insufficient space to process INSERT command ( 235)

First thing I would try -- does the insert work without the variable? If you substitute a literal value in the insert, or leave it out altogether, does that work? Karen -Original Message- From: gary.wend To: rbase-l Sent:

Re: [RBASE-L] - RE: Scrolling Region problem

Alastair: What version was the database when you converted to version 10? One conversion note that I have, and that I've run into, is when I converted databases from windows 6.5 to either 9.5 or 10. If any field on a 6.5 form had "wrap" selected rather than "keep on one line" (which you

Re: [RBASE-L] - MDI syntax help

ormname MDI AS alias SETFOCUS alias 2017-02-10 9:56 GMT-05:00 karentellef via RBASE-L <rbase-l@googlegroups.com>: I'm using syntax that's from the X SAT that I attended, and there's something I'm obviously not getting correct. I bring up a form (non-MDI, form name AllBLs) and click

Re: [RBASE-L] - MDI syntax help

the form(AllBLs) needs to be mdi as well in order to set focus to it. Dan Goldberg From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com] Sent: Friday, February 10, 2017 6:56 AM To: rbase-l@googlegroups.com Subject: [RBASE-L] - MDI syntax help I'm using syntax that's from the X SAT that I

[RBASE-L] - MDI syntax help

I'm using syntax that's from the X SAT that I attended, and there's something I'm obviously not getting correct. I bring up a form (non-MDI, form name AllBLs) and clicking into a row brings up an MDI form based on that row. However, after bringing up that MDI form, I want to transfer focus

Re: [RBASE-L] - DECLARE CURSOR Source Data Array

Can you do a while loop with a ssub? SET VAR vLoop INT = 1 SET VAR vList = (1,2,3,4,5) WHILE 1 = 1 THEN SET VAR vText = (SSUB(.vList,.vLoop)) IF vText IS NULL BREAK ENDIF -- Do something SET VAR vLoop = (.vLoop + 1) ENDWHILE Karen -Original Message- From: Bruce

Re: [RBASE-L] - Strange temporary views make form slow to close.

Just FYI that I've never seen that error message before. I never even knew there was a "systmp_views" table! Karen -Original Message- From: 'Lawrence Lustig' via RBASE-L To: rbase-l Sent: Mon, Jan 16, 2017 1:22 pm Subject:

Re: [RBASE-L] - Number formatting on variable listview?

permanent column with the conversion you need? Regards, Alastair. On 19/08/2016 20:29, karentellef via RBASE-L wrote: Yeah, buthow would I display a variable in a list view? And I can't really define a form variable because the table

Re: [RBASE-L] - Number formatting on variable listview?

(.V9,'999.00'))) In the form designer mode (add variables) V8 = (CTXT(FORMAT(YourColNameHere,'999.00'))) V8 would be datatype text Buddy From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com] Sent: Friday, August 19, 2016 1:30 PM To: rbase-l@googlegroups.com Subject: [RBASE

Re: [RBASE-L] - Screen display

e <j...@kaypark.com> wrote: Karen and Javier, Though we do not use smaller screens in the shop yet, that helpful hint will be something I will remember when we go to smaller screens. Nice to know. James Belisle Making Information Systems People Friendly Since 1990

Re: [RBASE-L] - select in problem

n the number of items. Dan Goldberg From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com] Sent: Friday, September 2, 2016 6:52 AM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - select in problem I never use that syntax. Too many times it has not evaluated the "(.vList)

Re: [RBASE-L] - select in problem

I never use that syntax. Too many times it has not evaluated the "(.vList)" type of syntax. Not sure if this fixes your particular issue, but my code would be: set var vList = ( '(' + .vlist + ')' ) select ... cust_zip in Karen -Original Message- From: Dan Goldberg

Re: [RBASE-L] - RE: select in problem

What Jeff means (and it's a great idea) is to create a temp table with one row for every value. So it would be a multi-row temp table So something like: create temp table tmpzip (zipcode text 10) insert into tmpzip select zipcode from where Then use Jeff's syntax Karen

Re: [RBASE-L] - Printing to an XLS 97/2003 file format

I just tested this in my version 10, substituting one of my report names. I have Excel 2003 SP2 on my laptop. When the spreadsheet comes up in 2003, it looks fine with no warning messages. Are you getting some kind of message when it comes up in Excel? Karen -Original

Re: [RBASE-L] - Re: Can I capture sorting? - found it!

.com> Sent: Mon, Aug 29, 2016 2:45 pm Subject: RE: [RBASE-L] - Re: Can I capture sorting? - found it! It doesn’t show up in the rdocs drop down for variable list view. Dan Goldberg From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com] Sent: Monday, August 29, 2016 12:43 PM To: rba

Re: [RBASE-L] - "unload all for views"

Sent: Wed, Sep 7, 2016 10:34 am Subject: Re: [RBASE-L] - "unload all for views" At 11:17 AM 9/7/2016, karentellef via RBASE-L wrote: >According to my cheat-sheet notes document, in version 9 an "unload >all for views" was >introduced to give all view definitions. I c

Re: [RBASE-L] - Screen display

I always ask "what is the smallest resolution you have anywhere". Generally it's 1024 x 768, and I sigh You can do so much more with a bigger screen. When you design a new form, change the settings right away to those pixels and you know what you have to work with. As I think Javier

Re: [RBASE-L] - My solution to awkward parishioner name searches

Wow, I haven't used "sounds" in a gazillion years, back to the DOS days. Think I might play with it again! But something you said interests me. You say that "contactlookupname" is a computed column concatenating all 4 names. Now THAT is something I never thought of doing! If someone wanted

Re: [RBASE-L] - Printing distines from a table - Rbase X

Can you set up a "break" for that column, and then just locate what you need in the Break Footer section? You could use DB Calc controls to sum or count values for that break. Karen -Original Message- From: Bill Niehaus To: rbase-l

Re: [RBASE-L] - 9.5 SMTP on compiled application

Is the "userid" your userid or the userid of the email server? The last time I had to do this, this was the issue we had. It isn't the userid of the person sending the email, but rather an administrative-type of userid (and pw) for the server itself. If I got that right... Karen

Re: [RBASE-L] - new computer

Yep, it was a GOOD thread, wasn't it? I make it a habit of replacing my laptop (my main computer) every 5 years, and will get whatever is the current OS. Sometimes I adjust the timing to make sure the current OS has been around for a little while, I don't want to beta test windows!And I keep

Re: Re[2]: [RBASE-L] - OT - new laptop - last question

aptop - last question Rule #1 of Windows Operating Systems: ALWAYS get the Pro/Ultimate Bruce -- Original Message -- Sent: 9/22/2016 10:28:31 AM Subject: Re: [RBASE-L] - OT - new laptop - last question From: "karentellef via RBASE-L" <rbase-l@googlegroups.com> To:

[RBASE-L] - Using Rich Text report controls

I'm wondering if I can make the Advanced Rich Text report control work for what I need. In this legal document, I need to locate about a dozen variable-length fields on the left, followed by a closing parens and some text to the right. Obviously, the closing parents all need to line up.

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

Also, one other question. I see alot of windows 8 Toshibas on EBay and they are "new - open box". I don't want to go thru all this software trouble just to get a "used" laptop, so are these usually okay to purchase? Karen -Original Message----- From: kar

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

it; 3. Had one, sure glad I did; 3. Didn't have one, sure wish I did. Applies to trucks and RVs, too. Bruce -- Original Message -- Sent: 9/22/2016 10:07:15 AM Subject: Re: Re[2]: [RBASE-L] - OT - new laptop From: "karentellef via RBASE-L" <rbase-l@googlegroups.com>

Re: [RBASE-L] - Form mystery

Are you in Version 10? One of the handliest new developer functions is to click on the "Code" tab at the bottom of the designer screen Karen -Original Message- From: Bruce Chitiea To: rbase-l Sent: Mon, Aug 29, 2016 11:28

Re: [RBASE-L] - How to drop a foreign key in a table using SQL

This is tricky, I always have to look it up in my notes: SET VAR vTableID = sys_table_id from sys_tables where sys_table_name = ' .. ' SET VAR vIndexName = sys_index_name from sys_indexes where sys_table_id = .vTableID and sys_column_name = ' ' ALTER TABLE DROP CONSTRAINT Karen

Re: [RBASE-L] - How to drop a foreign key in a table using SQL

had to reset my laptop to get it running again. A On 2016-09-27 8:33 AM, karentellef via RBASE-L wrote: This is tricky, I always have to look it up in my notes: SET

Re: [RBASE-L] - How to drop a foreign key in a table using SQL

Yes, whoever created that code in the first place did not include anything to test if a column is involved in >1 index in that table. I don't think I've ever myself used a column as both an individual index and also involved as part of a multi-column index. Karen -Original

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

$8000. crazy isn't it? I know when I first got into computers and hardware, nothing useful was under $5000. Since I went on my own, I believe that every computer I have ever bought cost less than the one before, and was multitudes more powerful. Factor in inflation, and the

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

Oh, and for everyone who so nicely responded to my questions about this topic... my new Dell laptop arrived a couple days ago and I'm happily putting it together. It came with Win 10 Pro, with free Microsoft Office (since I will have to get the new version anyway, I've been using it for a

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

Yeah, the only copy of office I have is 2003, and I read that 2007 is the first version that can run under windows 10 Karen -Original Message- From: Michael Byerley To: RBASE-L Cc: karentellef Sent: Sat, Oct

Re: [RBASE-L] - Printing opinions?

they would pay you for. But I'd rather have them begrudging the pennies they spend on you than begrudging the pennies they spend on the hardware. Bill On Tue, Nov 8, 2016 at 8:57 AM, karentellef via RBASE-L <rbase-l@googlegroups.com> wrote: Situation: RBase X database, upgraded f

Re: [RBASE-L] - Printing opinions?

From: Dan Goldberg <d...@lancecamper.com> To: karentellef via RBASE-L <rbase-l@googlegroups.com> Sent: Tue, Nov 8, 2016 8:47 am Subject: Re: [RBASE-L] - Printing opinions? You could always do both... Dan Goldberg Lance Camper On Tue, Nov 8, 2016 at 6:44 AM -0800, "karent

Re: [RBASE-L] - Printing opinions?

font size. If it was re-done or even it wasn’t then print by Last name Instead of sending 500 individual print statements try changing/add the WHERE clause PRINT …. WHERE LastName BETWEEN ‘a’ and ‘c’ PRINT …. WHERE LastName BETWEEN ‘d’ and ‘f’ and so on. Buddy

Re: [RBASE-L] - Can't export any data

Whew, that's some "where" clause!!! Have you tried copy/paste of that where clause and run it from the R> prompt as a "browse"? Do you get all your data up that way? Karen -Original Message- From: 'Patti Jakusz' via RBASE-L To: rbase-l

Re: [RBASE-L] - Print all column names of all tables in database

Would a simple LIST ALL to a filename do what you want? Karen -Original Message- From: Kaleb Wade To: RBASE-L Sent: Wed, Oct 12, 2016 2:06 pm Subject: [RBASE-L] - Print all column names of all tables in database I'm looking

Re: [RBASE-L] - File Gateway Not Reading Source File

Just in case the size is an issue, have you tried paring the file down to just a couple rows as a test? Karen -Original Message- From: Gary Randall To: rbase-l Sent: Sun, Oct 23, 2016 3:23 pm Subject: RE: [RBASE-L] - File

Re: [RBASE-L] - RE: RBASE in the start menu

I'll jump in, but you would call the RBase exe passing in a program to run, can't remember the exact syntax, but something like: c:\rbti\RBGXE.exe RBase.dat Karen -Original Message- From: Jim Belisle To: rbase-l Sent: Wed, Nov 23,

Re: [RBASE-L] - Capturing images - what works and what didn't

ue' PROPERTY TABLE tablename 'refresh' Setting the focus to one of the fields should change to that table. Dan Goldberg From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com] Sent: Wednesday, November 16, 2016 11:05 AM To: rbase-l@googlegroups.com Subject: [RBASE-L] - Capt

[RBASE-L] - Capturing images - what works and what didn't

This is what works great: We have a table that has a Long Varbit column. On the form for that table, we have a DBImage column located that displays a photo from that column. We have a "take picture" button that basically does a PROPERTY photo CaptureFromVideo 'true' PROPERTY TABLE

Re: [RBASE-L] - DBGrids

DBGrids At 11:45 AM 10/12/2016, karentellef via RBASE-L wrote: >I don't have RDocs, but I did look at the Form Controls & Properties PDF >file that you have online, and looked thru the pages and pages of properties >available for "Enhanced DBGrid". Unless I've missed some

[RBASE-L] - DBGrids

I'm going to try like heck to replace all my old 7.6-era scrolling regions with DBGrids, so I need to find out the best way to do those easy scrolling region things within a DBGrid. The one I'm having trouble with would be doing the equivalent of "PROPERTY componentID TEXTVALUE

Re: [RBASE-L] - DBGrids

To: rbase-l <rbase-l@googlegroups.com> Sent: Wed, Oct 12, 2016 10:37 am Subject: Re: [RBASE-L] - DBGrids At 10:11 AM 10/12/2016, karentellef via RBASE-L wrote: >I'm going to try like heck to replace all my old 7.6-era scrolling >regions with DBGrids, >so I need to find out the best way to do t

Re: [RBASE-L] - Property command

But if the view has >1 table, then the view would not be editable. So this would work only if the DBGrid was read-only, right? Karen -Original Message- From: A. Razzak Memon To: rbase-l Sent: Thu, Dec 8, 2016 3:30 pm Subject: Re:

[RBASE-L] - How I resolved my envelope printing issue

Remember about a month ago I asked for suggestions on this. The company was printing around 500 envelopes at a time to an old laserjet (as one 500-page print, not 500 1-page prints) and sporadically we were getting blank envelopes, garbage characters, incomplete data, etc. "Hiccuping" as I

Re: [RBASE-L] - On Keypress EEP not working

We don't use "lastkey". We use this to trap each key as it is pressed, and here's some examples of the code that would follow: GETPROPERTY keyword TEXTVALUE vkeyword IF vkeyword = ' ' OR vkeyword IS NULL OR vkeyword = (CHAR(32)) OR vkeyword = (CHAR(255)) THEN RETURN ENDIF IF vkeyword = '*'

Re: [RBASE-L] - Wild Card troubles

Albert: what RBase version/build are you using? Karen -Original Message- From: Albert Berry To: rbase-l Sent: Sun, Dec 4, 2016 1:14 pm Subject: Re: [RBASE-L] - Wild Card troubles All the character settings are correct. The

[RBASE-L] - Keymaps

First time I've tried to define a keymap of the [Enter] key, and I'm getting an error message that it isn't allowed. I was hoping to keymap it to a [Tab]. I'm trying to replace a scrolling region with an enhanced DBGrid. Just one field is editable, they type in an amount. On exit from

Re: [RBASE-L] - Designing and Deploying an R:BASE Keyboard for Touch-Screen Tablet PCs

Razzak: Your code is identical, isn't it? Karen -Original Message- From: A. Razzak Memon To: rbase-l Sent: Wed, Jan 4, 2017 10:53 am Subject: RE: [RBASE-L] - Designing and Deploying an R:BASE Keyboard for Touch-Screen Tablet PCs

Re: [RBASE-L] - Explain this table structure for me?

d to not need, but assumed * so that (percent(intpay+actamt)) is equivalent to (percent*(intpay+actamt)) Albert On Dec 21, 2016, at 11:53 AM, karentellef via RBASE-L <rbase-l@googlegroups.com> wrote: You'd think after all my decades doing this, that I would have seen this type of c

Re: [RBASE-L] - Re: From The Edge: Optimizing R:BASE Cloud Applications

I agree, Stephen. I have lots of situations of column data that contains a comma, such as descriptions of items or full names that might contain a comma (like Smith, Jr). RBase behaves nicely in that it always encloses text fields with quotations on export.Now, Excel doesn't behave as

Re: [RBASE-L] - Store comma seperated

Variable Lookup List Box and List View both have the "multi-select" option on the properties page. However, DB controls do not offer that option. You could make an argument that DB controls should offer the ability, as there could be times you would want to store a comma separated list into a

Re: [RBASE-L] - enhanced DB grid

I'm away from my notes so can't answer the focus question. But the [enter] key cannot be used to advance the cursor in version 9.5. That option was added in Version X Karen -Original Message- From: Jim Belisle To: rbase-l Sent: Wed,

[RBASE-L] - The new -BASE parameter

In going thru the What's New for the 4/11/17 build, I notice the new -BASE command line parameter that we can use when calling up RBase from our desktop icons. The description makes it sound like it's geared towards a developer, who wants a streamlined quicker version of the database (turning

Re: [RBASE-L] - Typed versus Scanned

I'm guessing he's using one of those "keyboard wedge" (?) kind of scanners, no button is needed to launch. The cursor is in a field, you run a scanner and it puts it right in the field, so nothing needs to be initiated. I don't use the keyboard scanners, just batch-type of scanners. In that

Re: [RBASE-L] - Thoughts on speeding up a cursor?

oon is easier than figuring out insurance stuff. :) D On 4/24/2017 11:37 AM, karentellef via RBASE-L wrote: Here's the thing -- believe it or not, there is NOT A SINGLE PLACE in that 600 lines of cursor where I amupdating a record. Never, not once. It does a whole bunch of selects, from a

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

Is the "dbo" required? I'm starting a project connecting to SQL Server, and we're not doing that Karen -Original Message- From: Paul C. Buckley To: rbase-l Sent: Thu, Aug 3, 2017 10:55 am Subject: RE: [RBASE-L] - Problem

Re: [RBASE-L] - Default to FILL for UNLOAD DATA

I think what I'd do is project a temporary table, do the "unload all / noschema" on the temp table, run the file in the new database, and then append to the permanent table Karen -Original Message- From: Buddy Walker To: rbase-l

Re: [RBASE-L] - Lookup List view and scroll bars

quickly. Double Click works just as well, but forces you to pause slightly which can be a good thing. That leaves me with Option B depending on what the users do/say/request. Thanks for the heads up. Tom From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com] Sent: Tuesday, July 11,

Re: [RBASE-L] - Lookup List view and scroll bars

Tom: One thing to test: sometimes moving thru a list of things with the cursor (up/down arrows) will execute a single-click eep. So test that in your situation. If you think the user will move around with the keyboard, and you don't want a single-click eep to execute for each row they move

Re: Re[2]: [RBASE-L] - Lookup List view and ... speed

inal Message -- Sent: 7/14/2017 6:09:49 AM Subject: Re: [RBASE-L] - Lookup List view and scroll bars From: "karentellef via RBASE-L" <rbase-l@googlegroups.com> To: rbase-l@googlegroups.com Cc: I swear, I think 90% of "problems" would be solved if users weren't so damn fast

Re: [RBASE-L] - Easily creating multiple R:BASE ODBC registry entries

Do you have an example of the code? This is a simple statement to connect to another RBase database. SCONNECT ';driver=Oterro X Enterprise Database Driver (*.RX1);dbq=x:\freight' The last example I had of an Acce$$ command was this, but it's old: SCONNECT';driver=Microsoft Access Driver

Re: [RBASE-L] - DB corruption

Great news, Jim! When you have time, would you mind giving us more details just so we know the kinds of things to look for? Like, were they patching when users had the database connected, was the server rebooting, etc. Just some details as to why their patches were affecting your database.

Re: [RBASE-L] - Thoughts on speeding up a cursor?

be valid for the newer versions. Here is the link: http://www.razzak.com/fte/pdf/OptimizingApplicationPerformance95.pdf Javier, Javier Valencia, PE O: 913-829-0888 H: 913-397-9605 C: 913-915-3137 From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com] Sent: Monday, April 24, 2017 3:5

Re: [RBASE-L] - Thoughts on speeding up a cursor?

ancy you can make the variable name contain the number of the iteration and write to an external file at the end of the iteration and clear the older variables and then load the file with all the times to a spreadsheet for easy analysis. Javier, Javier Valencia, PE O: 913-829-0888 H: 913-397-9605 C: 91

Re: [RBASE-L] - Thoughts on speeding up a cursor?

vier Valencia, PE O: 913-829-0888 H: 913-397-9605 C: 913-915-3137 From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com] Sent: Tuesday, April 25, 2017 12:44 PM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - Thoughts on speeding up a cursor? No, I'm the only one using RD, everyone e

Re: [RBASE-L] - From The Edge: R:BASE Cursors Explained

number of data rows. Karen -Original Message- From: jan johansen <j...@jjcalibrations.com> To: karentellef via RBASE-L <rbase-l@googlegroups.com> Sent: Fri, Apr 28, 2017 1:37 pm Subject: Re: [RBASE-L] - From The Edge: R:BASE Cursors Explained Karen, I have not us

Re: [RBASE-L] - From The Edge: R:BASE Cursors Explained

Cool, read the whole document!! Unfortunately not alot of it applies to my specific situation since there are no nested cursors and it's never updating any tables. The original writer of the program also did a nice job of writing the initial "declare" command to pull in as much data as needed,

Re: [RBASE-L] - From The Edge: R:BASE Cursors Explained

that will take away the "goto startloop" altogether! Karen -Original Message- From: jan johansen <j...@jjcalibrations.com> To: karentellef via RBASE-L <rbase-l@googlegroups.com> Sent: Fri, Apr 28, 2017 11:43 am Subject: Re: [RBASE-L] - From The Edge: R:BASE Cursors E

[RBASE-L] - Compute vs Select

Just an FYI I did a comparison of "compute" vs "select" in Version X (works the same as 9.5). See the print-screen below. I tested with a where clause that will fail, I tested both a SUM and a COUNT: With zero ON (my default) SUM "compute" returns a null "select" returns a

Re: [RBASE-L] - Compute vs Select

: Dan Goldberg <d...@lancecamper.com> To: rbase-l <rbase-l@googlegroups.com> Sent: Fri, Apr 28, 2017 3:47 pm Subject: Re: [RBASE-L] - Compute vs Select Have u tried indexing the temp tables? Dan Goldberg Lance Camper On Fri, Apr 28, 2017 at 1:07 PM -0700, "karentellef via

  1   2   3   >