Re: [RBASE-L] - Including Forms in Compiled app

So it's personal preference. If you have 20 users all in the same building and have access to all of them, place the compiled version on each each computer. If you users are spread out over buildings and states, run it from the server. Jan -Original Message- From: Dawn Hast

RE: [RBASE-L] - Including Forms in Compiled app

Login script good. I haven't done that in a while. -Original Message- From: Dan Goldberg To: "rbase-l@googlegroups.com" Date: Tue, 30 May 2017 19:56:41 + Subject: RE: [RBASE-L] - Including Forms in Compiled app Thx jan. I have a lot

Re: [RBASE-L] - Pagelock (corrected text)

Thanks, Dan. I'd have to say that this particular app usually does not update "a row at a time", other than when the user is in an edit form. I'd say almost all of the routines would be updating multiple rows based on some kind of "where" clause. Can't say whether it would be updating 10

[RBASE-L] - Pagelock

I'm wrestling with the decision of whether to use PAGELOCK OFF in one of my bigger X Enterprise databases. Looking at all the "help" documents it seems like the only reason you would want pagelock On (the default) is if you are updating all the rows in a table, with no "where" clause. As in this

RE: [RBASE-L] - Pagelock (corrected text)

I run with both pagelock and rowlock on. I tried turning off pagelock once and my users complained it was slow on updating data. I haven’t got time to do the switching per commands. My commands mostly has many update and deletes many rows at a time. Now you can turn it on or off at any time.

Re: [RBASE-L] - Pagelock (corrected text)

Ooops, got one word wrong I'm wrestling with the decision of whether to use PAGELOCK OFF in one of my bigger X Enterprise databases. Looking at all the "help" documents it seems like the only reason you would want pagelock On (the default) is if you are updating all the rows in a

RE: [RBASE-L] - Including Forms in Compiled app

Thx jan. I have a lot of users. I guess I can create a login script when they login to their pcs to copy the compiled app each time. Dan From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of jan johansen Sent: Tuesday, May 30, 2017 12:52 PM To: rbase-l@googlegroups.com

Re: [RBASE-L] - Including Forms in Compiled app

Dan - that's kind of where I was going with that. I've always run it on the server - but I was thinking that if the forms were local to the PC and it just had to retrieve data, then it might be faster in those situations where the network speed was less than optimal. But that introduces the

RE: [RBASE-L] - Including Forms in Compiled app

For me the server is the best. I run a gigabit network so a 10 meg compiled app runs very fast. If I do an updated compiled app they run it the next time the click on the shortcut. I only update the compiled app when rbase pushes out an update. My compiled app just calls the external form

Re: [RBASE-L] - Including Forms in Compiled app

Hi Dawn, Welcome back to R:BASE World! It is so good to see you back. Yes, can you believe that R:BASE Technologies will be celebrating its 20th Anniversary next year? All those pundits thought that R:BASE Technologies would not survive more than a year. Where are those folks today? If

[RBASE-L] - Tip of the Day: New GETPROPERTY Function

Wednesday, May 31, 2017 Tip of the Day: New GETPROPERTY Function Product...: R:BASE X/X Enterprise (Version 10) Build.: 10.0.2.20530 or higher Section...: Functions Keywords..: GETPROPERTY, Functions Did you know that GETPROPERTY is now a function, as well as a command? A

[RBASE-L] - Syntax, Load command

Trying to load a price file from a vendor. Have it ins CSV format. Unable to figure out how to limit the number of rows. Tried all the syntax in the Load help, but nothing seems to work. It is loading thousands, but there is only 400 lines of data. Dick Fey -- Carpet Broker Inc P: 913-894-9211

RE: [RBASE-L] - Syntax, Load command

Dick Have you tried to open the csv file in Excel or RBedit. This may tell you if there are actually a lot of blank rows. Buddy -Original Message- From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of Carpet Broker, Dick Fey Sent: Tuesday, May 30, 2017 11:29

Re: [RBASE-L] - Syntax, Load command

Many, many years ago when I was working at the local coal mine, they bought a pit system that would not talk to any other system. The system they bought scheduled loaders, dozers, shovels, drills and other mine equipment and also the trucking from the load point to the various stockpiles and

[RBASE-L] - Including Forms in Compiled app

After an extended leave, I'm back having fun with RBase, even if only part time! It's nice to see all the familiar names in the group :-) I don't have a ton of history using the compiler and have a couple questions. How much of an improvement (in speed) could one expect by including the forms

Re: [RBASE-L] - Including Forms in Compiled app

Dawn, Welcome. 1. How much of an improvement (in speed) could one expect by including the forms in the compiled application vs just keeping them in the db? It will depend on your network but you should see slight improvement. Forms really aren't all that big. 2. Checking current compiled

Re: [RBASE-L] - Including Forms in Compiled app

Thanks Jan, Yes, I was thinking check the version, inform the user and exit the program. Not allowing them to use the old version will force the issue. On Tue, May 30, 2017 at 2:59 PM jan johansen wrote: > Dawn, > > Welcome. > > 1. How much of an improvement (in

Re: [RBASE-L] - Including Forms in Compiled app

Dawn, Then you should be able to place this in an ON AFTER START eep in a form. SET VAR vCurrentVersion TEXT = '2017.04.30.001' SET VAR vWhatVersionAmI TEXT = NULL GETPROPERTY APPLICATION FileVersion vWhatVersionAmI IF vWhatVersionAmI <> .vCurrentVersion THEN PAUSE USING ... CLOSEWINDOW EXIT