Re: [RBASE-L] - ERASE filespec

Claudine, You can try this (untested). SET VAR vQuotes = (CVAL('QUOTES')) SET VAR vfilename1 TEXT = NULL SET VAR vfilename2 TEXT = NULL SET VAR vDeleteFileCommand TEXT = ('DELETE ' + .vQuotes +.vfilename2 + .vQuotes) SET VAR vCopyFileCommand TEXT = ('COPY ' + .vQuotes + .vfilename1 + .vQuotes

Re: [RBASE-L] - Form size

Do you have a backup of the form? -Original Message- From: "Carpet Broker, Dick Fey" To: RBase Maillist Date: Fri, 24 Feb 2017 12:47:09 -0600 Subject: [RBASE-L] - Form size OK, so this is really weird. If I examine the form in form

RE: [RBASE-L] - Still stumped

7 11:08 AM To: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] Subject: Re: [RBASE-L] - Still stumped Yes it works fine in uncompiled Tom On Feb 9, 2017 11:06 AM, "jan johansen" <j...@jjcalibrations.com [mailto:j...@jjcalibrations.com]> wrote: Does the RFF work in an uncompiled

RE: [RBASE-L] - problem with null values

Patti, Buddy beat me to it but sometimes when we are using an older database, we actually saved a space for a null so you may need to check to see if you actually have nulls. Jan -Original Message- From: "Buddy Walker" To: Date:

Re: [RBASE-L] - Still stumped

Does the RFF work in an uncompiled state? -Original Message- From: Tom Hart To: rbase-l@googlegroups.com Date: Wed, 8 Feb 2017 21:45:31 -0600 Subject: [RBASE-L] - Still stumped I am going to post this again because I am totally stumped. Very simply I am trying to

RE: [RBASE-L] - my first go around with staticdb on

Dan, I think it's a focus issue. Let me explain our scenario. We have a main menu that calls other things as I'm sure we all use. However in many cases, the called form is smaller than the menu form. So the client is in the smaller form and goes to check email. Tries to come back to the app

Re: [RBASE-L] - Odd Report Action

Tom, I moved to separate NOTE tables. If I remember correctly, NOTE can be 4096. However it is limited by the other fields in the row. Just a thought. Jan -Original Message- From: "Tom Frederick" To: Date: Sun, 15 Jan 2017 15:55:00 -0600

Re: [RBASE-L] - Print all

com> To: rbase-l@googlegroups.com Date: Tue, 6 Sep 2016 15:11:40 -0400 Subject: Re: [RBASE-L] - Print all That's what I do.Set a cursor, construct a unique PDF name, print individual files Karen -Original Message- From: jan johansen <j...@jjcalibrations.com> To: rbas

RE: [RBASE-L] - triggers?

correct -Original Message- From: Jim Belisle To: "rbase-l@googlegroups.com" Date: Tue, 15 Nov 2016 21:00:28 + Subject: RE: [RBASE-L] - triggers? Jan, If the other forms run off of a main form, then as long as the application is up, that

Re: [RBASE-L] - variable lookup list mult select groups

There is a way. You have to enable "multi-select" in the list view. Be aware that you will to change the variable that you use to capture the "multi". Not in front of R:Base right now and can't tell you where it is, but I have done it before and it works great! -Original Message- From:

RE: [RBASE-L] - variable lookup list mult select groups

Dan, I set up 2 variables in the on before start eep SET VAR vCodeList NOTE = NULL SET VAR vCodeListTXT NOTE = NULL The info I'm trying to capture are TEXT variables The variable for the var list view is vCodeList In my dbl clk eep in the var list view SET VAR vQuotes = (CVAL('QUOTES')) SET

RE: [RBASE-L] - variable lookup list mult select groups

Hmmm. Let me fire up the program and look at my settings. -Original Message- From: Dan Goldberg To: "rbase-l@googlegroups.com" Date: Thu, 17 Nov 2016 23:55:06 + Subject: RE: [RBASE-L] - variable lookup list mult select groups Thx

Re: [RBASE-L] - triggers?

Jim, Do you use a Form as your main menu? If so, you could try creating a custom form action to do want you want. Call the form action every 1-2 minutes using the form timer. Jan -Original Message- From: Jim Belisle To: "rbase-l@googlegroups.com"

Re: [RBASE-L] - Property command

Tom, I believe in a scrolling region you will only be able to change the color based on the current 'row' if that makes a difference to you. Otherwise a DB grid or variable list will show all 'T' as green. Jan -Original Message- From: Tom Hart To:

Re: [RBASE-L] - R:BASE X Enterprise - SAT (Additional Application)

Does this apply to alumni of the 2016 SAT? -Original Message- From: "A. Razzak Memon" To: rbase-l@googlegroups.com Date: Tue, 06 Dec 2016 10:30:10 -0500 Subject: [RBASE-L] - R:BASE X Enterprise - SAT (Additional Application) Tuesday, December 6, 2016 All attendees of

RE: [RBASE-L] - RIP Bob Castanaro

Hmmm. He has been active telling the stories of his struggles on Facebook here https://www.facebook.com/bobcastanaro Jan -Original Message- From: "Javier Valencia" To: Date: Fri, 23 Dec 2016 14:19:46 -0600 Subject: RE:

Re: [RBASE-L] - Convert

Tom, I believe so. Let's just say that I was trouble shooting a compiled app and was working with a backup copy. I attempted to connect to a 9.5 database and was asked "do you want to convert". Jan -Original Message- From: Tom Hart To: rbase-l@googlegroups.com

Re: [RBASE-L] - Store comma seperated

trate the use of such cool feature in R:BASE X Enterprise. Very Best R:egards, Razzak At 08:12 PM 12/21/2016, jan johansen wrote: Having a sugar induced brain cramp. I want to store a comma separated list in a table. Basically want to save either a list of job functions by individual or assign in

[RBASE-L] - Store comma seperated

Group, Having a sugar induced brain cramp. I want to store a comma separated list in a table. Basically want to save either a list of job functions by individual or assign individuals to job functions. So a person can have more than one job function or job functions can have several people.

[RBASE-L] - ENTER

Using latest X (1130) I have a very simple (a db edit and navigator). Using ENTER mode. Yesterday if I pressed ENTER in the DB edit, the form inserted a row, cleared the db edit and was ready for the next input. Today, Enter inserts the row but doesn't clear the DB edit. What am I missing?

Re: [RBASE-L] - Scrolling Region question

Frank, I'm not sure you can do what you want with a scrolling region as you only display different colors when you enter the row (I believe). So if you have your tier color as GRAY and you want your row color to be RED when un-available, it will only do that on that specific row when you enter

Re: [RBASE-L] - Released: R:BASE X/XE (Version 10) - Add-on Products

port%40rbase.com] for the appropriate link(s) to download your add-on product(s). Razzak At 12:10 PM 8/2/2017, jan johansen wrote: >Razzak, > >I know I am sight impaired, but I can't find the Ottero download. > >Jan > >-Original Message- >From: "A. R

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

Tom, If I'm reading correctly you can use the TOPITEM property. Place something like this in your listview ONCLICK eep CLEAR VARIABLE vTopItem SET VAR vTopItem TEXT = NULL GETPROPERTY YOURLISTVIEWPROPERTYID TOPITEM vTopItem PROPERTY YOURLISTVIEWPROPERTYID TOPITEM .vTopItem Jan

Re: [RBASE-L] - clicking too often

One thing you can do is "disable" the object in the on-click eep., Like PROPERTY VariableListViewObject ENABLE FALSE -Original Message- From: Jim Belisle To: "rbase-l@googlegroups.com" Date: Tue, 18 Jul 2017 15:50:14 + Subject: [RBASE-L] -

Re: [RBASE-L] - get the minimum and store it

INSERT INTO + mytable + SELECT distance, dlrnum, loczipcode, dlrzipcode + FROM myview -Original Message- From: Dan Goldberg To: "rbase-l@googlegroups.com" Date: Wed, 19 Jul 2017 21:38:16 + Subject: [RBASE-L] - get the minimum and store

RE: [RBASE-L] - get the minimum and store it

...have you tried SELECT (MIN(distance))? -Original Message- From: Dan Goldberg To: "rbase-l@googlegroups.com" Date: Wed, 19 Jul 2017 21:52:27 + Subject: RE: [RBASE-L] - get the minimum and store it Thx. I need to get the minimum

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

backward that random 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

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

Karen, This is an excellent article. A couple of things for you. 1. Since you are dealing with an OLD cursor, make sure you SET all the needed VARIABLE datatypes and values to NULL completely outside the CURSOR. You can set the values inside the CURSOR but you can't (shouldn't) really define

Re: [RBASE-L] - Compute vs Select

If they only run this code once a month, why don't you put the code in a bat file and run it on the server off hours and send the results to someone? -Original Message- From: karentellef via RBASE-L To: rbase-l@googlegroups.com Date: Fri, 28 Apr 2017 17:21:29

Re: [RBASE-L] - Released: R:BASE X/XE (Version 10) - Add-on Products

Razzak, I know I am sight impaired, but I can't find the Ottero download. Jan -Original Message- From: "A. Razzak Memon" To: rbase-l@googlegroups.com Date: Mon, 31 Jul 2017 00:05:00 -0400 Subject: [RBASE-L] - Released: R:BASE X/XE (Version 10) - Add-on Products

Re: [RBASE-L] - Rbase

I will admit that we did our accounting in RBase 4.5 and it did everything as well. RBaseX still handles billing and accounts receivable. At the end of the day we print a report with to enter about 6 numbers into Quickbooks. Quickbooks handles accounts payable. -Original Message- From:

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

ups.com [mailto:rbase-l@googlegroups.com] Date: Tue, 30 May 2017 19:08:57 + Subject: 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,

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

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 <j...@jjcalibrations.com [mailto:j...@jjcalibrations.com]> wrote: Dawn, Welcome. 1. How much of an improvement (in

Re: [RBASE-L] - Tip of the Day: Modern Appearance Styles for Digital Clock

Razzak, Just a quick question. These formats can be used without a theme? Jan -Original Message- From: "A. Razzak Memon" To: rbase-l@googlegroups.com Date: Fri, 02 Jun 2017 00:05:38 -0400 Subject: [RBASE-L] - Tip of the Day: Modern Appearance Styles for Digital Clock

Re: [RBASE-L] - Strange printing problem

That's handy! Thx Karen. -Original Message- From: karentellef via RBASE-L To: rbase-l@googlegroups.com Date: Wed, 14 Jun 2017 15:43:35 -0400 Subject: Re: [RBASE-L] - Strange printing problem Jim: I saved this syntax to send PDFs to the printer, so you could

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

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 <j...@jjcalibrations.com [mailto:j...@jjcalibrations.com]> wrote: Dawn, Welcome. 1. How much of an improvement (in speed) could one expect by including the for

Re: [RBASE-L] - Tip of the Day: Group Font/Color Changes for List View Headers and Columns

Very nice! -Original Message- From: "A. Razzak Memon" To: rbase-l@googlegroups.com Date: Mon, 18 Sep 2017 09:00:10 -0400 Subject: [RBASE-L] - Tip of the Day: Group Font/Color Changes for List View Headers and Columns Monday, September 18, 2017 Tip of the Day: Group

RE: [RBASE-L] - Help with DBGrid search command - correction

Karen, Why are you using a DB-Grid? Seems you can you do want with Variable List View that you can keep the focus on the row. Jan -Original Message- From: Dan Goldberg To: "rbase-l@googlegroups.com" Date: Fri, 25 Aug 2017 16:57:35 +

Re: [RBASE-L] - copying images

Karen, As a pilot, I can tell you that flying a plane is easy. It's landing that takes all the training! :) Jan -Original Message- From: karentellef via RBASE-L To: rbase-l@googlegroups.com Date: Thu, 14 Dec 2017 12:40:23 -0500 Subject: Re: [RBASE-L] - copying

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

David, I believe you are going to need to choose the form you want to land on. Something like CONNECT custmr PROPERTY APPLICATION TITLE 'Dispatch' EDIT USING dispatchedjobs WHERE status='d' SORTED BY jobdate tin operator MDI AS dispatchwindow CAPTION 'DISPATCHED JOBS' EDIT USING pendingjobs

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

David, I know what want to do is possible. I do know that for a client I created what you are trying to do. But I also believe I made copies of the 2 forms I wanted to use as I needed to make some changes to the MDI calls that would not be applicable if calling either of the original forms

RE: [RBASE-L] - Form Compression

I no longer use form compression but used to. I don't know for sure and I thought I heard this from Razzak. Windows MAY see the process of un-compressing a form as something malevolent. -Original Message- From: "Richardson, Jeff" To: "rbase-l@googlegroups.com"

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

-Original Message- From: "jan johansen" <j...@jjcalibrations.com> To: rbase-l@googlegroups.com Date: Tue, 19 Dec 2017 08:54:43 -0800 Subject: RE: [RBASE-L] - Suppressing main R:Base screen David, I know what want to do is possible. I do know that for a client I c

[RBASE-L] - PAUSE

Group, I believe this has been asked before and I think the answer is NO. Can the CLOSE (X) be disabled on a PAUSE? I think it's no because it's a windows thing. I'm finding weirdnesses in my system because I think users are closing the PAUSE before I issue the CLS. Thank you, Jan -- For

RE: [RBASE-L] - query

That works well. -Original Message- From: Stephen Markson To: "rbase-l@googlegroups.com" Date: Thu, 7 Dec 2017 20:46:36 + Subject: RE: [RBASE-L] - query How about: …WHERE Amount<>INT(Amount)? Regards, Stephen Markson The Pharmacy

[RBASE-L] - query

Group, I need to query a table looking for non-whole dollars i.e. $71.25 $102.50 etc TIA, Jan -- 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

Re: [RBASE-L] - Compiler Question

Bill, I may be incorrect but I believe that a cfg will be created if your exe doesn't find the mapped drive. Jan -Original Message- From: To: rbase-l@googlegroups.com Date: Wed, 09 May 2018 14:39:24 -0700 Subject: [RBASE-L] - Compiler Question Using

Re: [RBASE-L] - Tip of the Day: Managing Folders and File Names

Razzak, Thanks for this timely information. I know that file management has changed over the years, particularly due to Windows changing. In the past, we used to be able to have "\\" before the filename which told the OS that this file was located in a sub-directory. Jan -Original

Re: Re[2]: [RBASE-L] - RBase on Linux

Steve, EXE has to be on the workstation? Does that mean that the EXE can't be in the shared folder and run from the workstation? Jan -Original Message- From: "Bruce A. Chitiea" To: rbase-l@googlegroups.com Date: Thu, 17 May 2018 17:44:53 + Subject: Re[2]:

RE: [RBASE-L] - One last question, if possible

Are you using Windows 10? You may need to change the file attributes that you wish to see in the folder. There are several dates available. -Original Message- From: "Cathy Grimes" To: Date: Sun, 31 Dec 2017 09:52:49 -0800 Subject: RE:

RE: [RBASE-L] - One last question, if possible

Open the folder and check thusly -Original Message- From: "jan johansen" <j...@jjcalibrations.com> To: rbase-l@googlegroups.com Date: Sun, 31 Dec 2017 11:18:16 -0800 Subject: RE: [RBASE-L] - One last question, if possible Are you using Windows 10? You may need to

Re: [RBASE-L] - One last question, if possible

... except version 9.5 should be *.RX? -Original Message- From: Larry Wilson To: rbase-l@googlegroups.com Date: Sun, 31 Dec 2017 17:06:24 -0500 Subject: Re: [RBASE-L] - One last question, if possible Cathy, IF you really want to confirm date, time and file size

Re: [RBASE-L] - [Business Web Applications using Java]

All, If you are interested in looking at a Java site that works with Oterro into our RBaseX database, goto www.jjcalibrations.com/equipmgr/ Use the following to login; guest jjguest We had Raffee convert our PHP application. Hope this helps. Jan -Original Message- From: "A. Razzak

RE: [RBASE-L] - [Business Web Applications using Java]

Believe it or not, this is just a continuation of what we were allowing our customers to do in the early 90's using Rbase 4.1 I believe. Using a 300 baud modem! The good old days. You just need to identify what would be helpful to your customers and provide an easy way to access it. We query

RE: [RBASE-L] - SubReports

Lena, I am away from the office and I know that I have several reports where I turn off the displays of certain sections. So it's possible I may get this wrong. Place your sub-report in a section (something that gives you a componentid) Test for your condition in the report ON BEFORE START eep.

RE: [RBASE-L] - SubReports

Glad I could help. -Original Message- From: Lena Dammstrom To: "rbase-l@googlegroups.com" Date: Thu, 18 Jan 2018 08:51:01 -0600 Subject: RE: [RBASE-L] - SubReports Jan, I got my report/sub reports to work properly. Thank you for all

Re: [RBASE-L] - Stay_On_Top

All property call's must be in an AFTER START eep -Original Message- From: karentellef via RBASE-L To: rbase-l@googlegroups.com Date: Thu, 18 Jan 2018 14:06:39 -0500 Subject: [RBASE-L] - Stay_On_Top If I am using PROPERTY RBASE_FORM STAY_ON_TOP 'ON' where

Re: [RBASE-L] - Licensing question

The customer needs both Rbase and Rcompiler. You can’t develop in Rcompiler. -Original Message- From: dkfowler6179 To: RBASE-L Date: Fri, 12 Jan 2018 18:32:51 -0800 (PST) Subject: Re: [RBASE-L] - Licensing question > Tom, > Yes,

Re: [RBASE-L] - Speed Difference - Same APP Different Laptops & AV Software

different folder(s). However, if everything is in one folder, such as compiled applications and projects as in your case, excluding the folder should take care of all files underneath that folder. Very Best R:egards, Razzak At 12:07 PM 1/29/2018, jan johansen wrote: >Ok, so this bring

RE: [RBASE-L] - File location

Thanks Dan. -Original Message- From: Dan Goldberg To: "rbase-l@googlegroups.com" Date: Thu, 1 Feb 2018 18:44:24 + Subject: RE: [RBASE-L] - File location Do you use rbase to link the files to the database? Here is a snippet of what I

[RBASE-L] - File location

My turn! I need to make sure external documents are placed in the proper directory. On the surface it's pretty easy. However I have been running into some obstacles. 1. UNC/Mapped drive - machines on the network either use a UNC connection or a mapped drive make it difficult to figure out the

RE: [RBASE-L] - File location

Good advice Brad -Original Message- From: Brad Davidson To: "rbase-l@googlegroups.com" Date: Thu, 1 Feb 2018 18:54:15 + Subject: RE: [RBASE-L] - File location Jan, May be a bit tangential to your request, but, having

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

David, FYI. A "very large list" will turn into a "very slow form". Lookup Combo Box and the like require the loading of all the data before it can display the result. Jan -Original Message- From: dkfowler6179 To: RBASE-L Date: Thu,

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

David, You can indeed use the ON KEYPRESS eep. However you may want to explore your WALKMENU time interval setting. Default is 1500 ms. Try something like 3000 ms. Jan -Original Message- From: Albert Berry To: "rbase-l@googlegroups.com"

Re: [RBASE-L] - Speed Difference - Same APP Different Laptops & AV Software

Ok, so this brings up a further question. In the old days we could just exclude the working directory. So ... now we need exclude the extensions? -Original Message- From: "A. Razzak Memon" To: rbase-l@googlegroups.com Date: Mon, 29 Jan 2018 08:54:15 -0500 Subject: Re:

RE: [RBASE-L] - DB problem

I have not used it since 7.1. I did a complete unload from 6.5++, normalized the database, and wrote a specific routine to load the new db at that time. No troubles since. -Original Message- From: Jim Belisle To: "rbase-l@googlegroups.com"

RE: [RBASE-L] - Radio group

half Ofjan johansen Sent: Thursday, February 22, 2018 11:54 AM To: rbase-l@googlegroups.com; jan johansen Subject: [RBASE-L] - Radio group Group, I am currently using a radio group for a search and it has worked well. I've been looking to see if there is a way to disable/hide part of a radio gr

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

Karen -Original Message- From: jan johansen <j...@jjcalibrations.com> To: rbase-l <rbase-l@googlegroups.com> Sent: Thu, Feb 15, 2018 2:05 pm Subject: [RBASE-L] - File location and path I'm looking for ideas. I need BOTH the fullpath and the filename without the p

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

f Ofjan johansen Sent: February 15, 2018 3:23 PM To: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] Subject: Re: [RBASE-L] - File location and path Well using SLOCP, SLEN and SGET I can get what I need but just thought there might be a shorter way. -Original Message- From: &q

[RBASE-L] - File location and path

I'm looking for ideas. I need BOTH the fullpath and the filename without the path. I don't think there is an option using either of the loadfile plugins. Thoughts? -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you

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

Well that works too. More than one way to skin a cat. -Original Message- From: Dan Goldberg To: "rbase-l@googlegroups.com" Date: Thu, 15 Feb 2018 20:23:58 + Subject: RE: [RBASE-L] - File location and path You would need to strip it

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

Well using SLOCP, SLEN and SGET I can get what I need but just thought there might be a shorter way. -Original Message- From: "jan johansen" <j...@jjcalibrations.com> To: rbase-l@googlegroups.com Date: Thu, 15 Feb 2018 12:05:42 -0800 Subject: [RBASE-L] - File locatio

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

ject: Re: [RBASE-L] - File location and path Well using SLOCP, SLEN and SGET I can get what I need but just thought there might be a shorter way. -Original Message- From: "jan johansen" <j...@jjcalibrations.com [mailto:j...@jjcalibrations.com]> To: rbase-l@googlegroups.com [

RE: [RBASE-L] - table with dates and date calculations

Chaya, You can use SELECT INTO from your driving table and it will populate your TEMP table without a cursor. Jan -Original Message- From: Chaya Goldberg To: "rbase-l@googlegroups.com" Date: Fri, 22 Dec 2017 18:14:29 + Subject:

[RBASE-L] - form timing

Group, I'm trying to track down some general annoyances. I am well aware of componentid's and when to call a component. However, I have users that occasionally will open a form and get the message 'component not found in current form'. When I check the forms, the componentid exists. This

Re: [RBASE-L] - form timing

evaluating the component id's and have asked the users to let me know if they are still seeing the errors. Jan -Original Message- From: "jan johansen" <j...@jjcalibrations.com> To: rbase-l@googlegroups.com Date: Thu, 12 Apr 2018 11:08:06 -0700 Subject: [RBASE-L] - form timi

[RBASE-L] - DIRTYVAR

Group, I want to check RBTI_FORM_DIRTYVAR for 1 before exit to ask to save changes. However if there haven't been any changes, the dirty var wouldn't be set. Do I initialize it? Jan -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this

Re: [RBASE-L] - Form Timer

Doug, 1. I believe timer starts over 2. I believe timer restarts when interval expires Jan -Original Message- From: Doug Hamilton To: "R:Base List" Date: Tue, 23 Oct 2018 16:51:14 -0500 Subject: [RBASE-L] - Form Timer > When enabling a form timer after > PROPERTY RBASE_FORM

[RBASE-L] - GATEWAY

All, While using GATEWAY IMPORT to a new table from a CSV file, is there an option to use first row as table Column Names? Jan -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups

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

John, Is it just Saturday? Jan -Original Message- From: John Minyo II To: rbase-l@googlegroups.com Date: Fri, 28 Sep 2018 13:40:13 -0400 Subject: [RBASE-L] - Registration Deadline - R:BASE Technologies' 20th Anniversary Conference Friday, September 28, 2018 Dear R:BASE Community,

[RBASE-L] - Code update

All, I've been tasked with going through all old code looking for areas to improve. One area is evaluating and updating cursors. Old code ran a cursor and took 63 seconds. New code runs temporary tables and select update and now takes 2 seconds. It's a win. Jan -- For group guidelines,

Re: [RBASE-L] - Happy Holidays from R:BASE Technologies

Merry Christmas to all of you! -Original Message- From: "A. Razzak Memon" To: rbase-l@googlegroups.com Date: Mon, 24 Dec 2018 10:21:36 -0500 Subject: [RBASE-L] - Happy Holidays from R:BASE Technologies > Monday, December 24, 2018 > > Dear R:BASE Community, > > He's making a database.

Re: [RBASE-L] - DBLookupComboBox

Claudine, Try tracing the code for option 1. I'm not sure if the REFRESHLIST is messing you up. Jan -Original Message- From: Claudine Robbins To: "rbase-l@googlegroups.com" Date: Thu, 29 Nov 2018 17:59:09 + Subject: [RBASE-L] - DBLookupComboBox Hello all, I have a

Re: [RBASE-L] - Capturing a signature

R:Base had a product back in V8 days called R:Scribbler From: "Dan Angcao" To: Date: Wed, 9 Jan 2019 08:39:01 -0800 Subject: [RBASE-L] - Capturing a signature Is there a control type for a form that someone can sign their name in. I need users to be able to sign their name in a form. Dan

Re: [RBASE-L] - MIssing object

All, Never mind. I found a workaround. Jan From: "jan johansen" To: rbase-l@googlegroups.com Date: Tue, 19 Mar 2019 11:20:44 -0700 Subject: [RBASE-L] - MIssing object Group, Somewhere along the way, I've made an object in a form not visible. When I run the form,

[RBASE-L] - MIssing object

Group, Somewhere along the way, I've made an object in a form not visible. When I run the form, the object appears. However when I try to design the form, the object is not visible. I've tried using the object inspector, but I'm not finding it. Suggestions? Jan -- For group

Re: [RBASE-L] - simple question

Jim, I think I remember that you are running compiled. Did you include Steel Blue as an additional resource in your compiler? As an aside, it may be beneficial to move from themes in database. They are overhead and slow it down. Jan From: Jim Belisle To:

Re: [RBASE-L] - SQL tutorial

need to know about defining and handling ERROR variables. Razzak At 12:08 PM 2/7/2019, jan johansen wrote: >Group, > >Part of this didn't get answered, maybe obliquely. > >In the OLD code >IF Hold = 0 >Does that mean success or failure? -- For group guidelines, v

Re: [RBASE-L] - SQL tutorial

Group, Part of this didn't get answered, maybe obliquely. In the OLD code IF Hold = 0 Does that mean success or failure? Jan From: "jan johansen" To: rbase-l@googlegroups.com Date: Tue, 05 Feb 2019 15:41:06 -0800 Subject: [RBASE-L] - SQL tutorial All, I think I need a SQL re

Re: [RBASE-L] - SQL tutorial

ren -Original Message- From: jan johansen To: rbase-l Sent: Thu, Feb 7, 2019 11:09 am Subject: Re: [RBASE-L] - SQL tutorial Group, Part of this didn't get answered, maybe obliquely. In the OLD code IF Hold = 0 Does that mean success or failure? Jan From: "jan johansen"

RE: [RBASE-L] - SQL tutorial

iptStatus = 'P' LABEL Done CLEAR VARIABLES iv%,vRows RETURN Hope it helps! Razzak At 06:41 PM 2/5/2019, jan johansen wrote: >All, > >I think I need a SQL refresher. >I need to update old code that looks like this. > >SET ERROR VAR hold >SET VAR vchk =

Re: [RBASE-L] - SQL tutorial

NDIF -- Do what you have to do here ... -- Example CLS EDIT USING ReceiptStatus WHERE PO_ID = .vPOID AND ReceiptStatus = 'P' LABEL Done CLEAR VARIABLES iv%,vRows RETURN Hope it helps! Razzak At 06:41 PM 2/5/2019, jan johansen wrote: >All, > >I think I need a SQL refresh

RE: [RBASE-L] - SQL tutorial

Dan, Thank you. I actually had used this info as well. I think I was just tired last night. Somehow a result of zero meaning success was just seeming totally wrong. Thx again, Jan From: Dan Goldberg To: "rbase-l@googlegroups.com" Date: Wed, 6 Feb 2019 00:06:11 + Subject: RE: [RBASE-L] -

[RBASE-L] - SQL tutorial

All, I think I need a SQL refresher. I need to update old code that looks like this. SET ERROR VAR hold SET VAR vchk = ReceiptStatus IN PODetail WHERE PO_ID = .vPOID AND ReceiptStatus = 'P' IF hold = 0 THEN So is IF hold = 0 the same as IF SQLCODE = 0? Sorry such a dumb question. Jan --

Re: [RBASE-L] - Form search

Albert, Ding, ding, ding! That work's really well. Jan From: Albert Berry To: rbase-l@googlegroups.com Date: Wed, 17 Apr 2019 11:21:20 -0600 Subject: Re: [RBASE-L] - Form search DB Explorer Forms Highlight All [Ctrl-F] Control Properties On Apr 17, 2019, at 10:13 AM, jan

[RBASE-L] - Form search

Group, I'm sure that hasn't to anyone else. The client changed their mind on form sizes. Is there a way to search form sizes without bringing up each individual form? Jan -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this

[RBASE-L] - Ghost form

Group, Somehow I ended up with 2 forms with the same name. I can remove one but not the other. Suggestions? I seem remember a way to do this by going into SYS_FORMS but wanted to check in here first. Jan -- For group guidelines, visit

Re: [RBASE-L] - Ghost form

need based on SYS_FORM_MOD_TS and SYS_FORM_VERSION 03. Press [F9] key to delete the row Have fun! Razzak At 09:40 AM 5/9/2019, jan johansen wrote: >Group, > >Somehow I ended up with 2 forms with the same name. >I can remove one but not the other. > >Suggestions? I seem rememb

[RBASE-L] - SCONNECT and SATTACH

Group, I haven't really had the need to utilize these commands until now. I need to connect to an Access DB (mdb). I can SCONNECT to it no problem. However how to SATTACH to the internal tables if you have no idea what the Access structure is or what the table names are? Jan -- For

  1   2   >