Re: [RBASE-L] - Variable Radio Group button doesn't fill in for NULL values

2023-11-29 Thread Tony Luck
Morning Richard, I have a form that contains a variable radio group that sets filters similar to what you're doing. Using the on Click I use the following IF vfilter = 'all' THEN PROPERTY fflist LOOKUPWHERECLAUSE 'where pond_id is not null' GOTO cleanup ENDIF In your case I would think the

Re: Re[2]: [RBASE-L] - SET ZERO

2023-11-08 Thread Tony Luck
thing > ENDIF > > How's your springtime? Bruce > > Bruce A. Chitiea > SafeSectors, Inc. > 1142 S Diamond Bar Blvd # 442 > Diamond Bar CA 91765-2203 > > rby...@safesectors.com > (909) 238-9012 m > > > -- Original Message -- > From "Tony Luck&q

Re: [RBASE-L] - SET ZERO

2023-11-08 Thread Tony Luck
Morning Bruce, Interesting question over the morning cuppa. In general I consider that the "IF varname > 0" is a comparison statement and setting zero on or off doesn't affect the outcome, in saying that however should there be a calculation i.e. set var vresult = (.v1 + .v2 + .v3) prior to the

Re: [RBASE-L] - find row in a table that does not exist in another

2023-10-09 Thread Tony Luck
Morning Dan, browse all from ponds where ((ctxt(pond_id))&(ctxt(farm_section))) not in (select ((ctxt(pond_id))&(ctxt(farm_section))) from feeds) substitute the column and table names for your ones. Note because the two columns I'm comparing are integers you need to translate them to text. Hope

Re: [RBASE-L] - Copy of files suddenly stops working

2023-06-26 Thread Tony Luck
I have a rename and copy routine that stores a csv file once processed. It creates a unique name then stores it to the appropriate direct. Code pasted below, hope it helps. Note there are no spaces in the date as it won't work if there is. -- Rename CSV to appropriate file SET VAR vrandom =

Re: [RBASE-L] - GATEWAY IMPORT Fail

2023-01-11 Thread Tony Luck
Hey Bruce, Happy New Year mate. Sorry I've been absent on line for abit rolling out the version 2 of the new aquaculture system. Anyway to your issue, I have to import external data from numerous devices, CSV base but in different column orders. The primary data needs to be stored in a set

Re: [RBASE-L] - Help not Working

2022-06-07 Thread Tony Luck
>From memory this has something to do with the path, I maybe wrong but it's a start to check out On Tue, 7 Jun 2022, 3:32 pm johnd...@gmail.com, wrote: > I was wondering if anyone has any suggestions as to why Help does not work > on one of my laptops. (It is fine with the same version on the

Re: [RBASE-L] - Refreshing a Form

2022-05-12 Thread Tony Luck
I sometimes use the SAVEROW command in the eep after an eep update statement in certain cases to reflect immediate changes on a form especially when using enhanced dbgrids. On Fri, May 13, 2022 at 9:02 AM James Burroughs wrote: > I have a form through which users may enter values into a table.

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

2022-02-11 Thread Tony Luck
That's a relief, thought I was losing it, thinking I'm sure I've read this lol On Sat, 12 Feb 2022, 3:35 am , wrote: > Me too. I had upgraded to Win 11 but the upgrade did not go as expected > and Outlook 365 and data files did not convert, so I had to set it back to > Win 10. I was thinking

Re: [RBASE-L] - Property commands

2022-02-08 Thread Tony Luck
This is from one of my earlier post Dick, think its what your after I had a request to have a clickable form showing the algal bloom colours (yes we spell color colour) for a pond across the month. When the cell is clicked it calls a form showing the details of the test results for the day in

Re: [RBASE-L] - PRINT

2022-02-07 Thread Tony Luck
On Mon, 7 Feb 2022, 7:33 pm Tony Luck, wrote: > Some over the overlooked variables are the system ones, I use them > constantly with great results > > > On Sun, 6 Feb 2022, 9:38 pm jan johansen, wrote: > >> Thank you Razzak! >> >> >> >

Re: [RBASE-L] - PRINT

2022-02-07 Thread Tony Luck
Some over the overlooked variables are the system ones, I use them constantly with great results On Sun, 6 Feb 2022, 9:38 pm jan johansen, wrote: > Thank you Razzak! > > > > > From: "A. Razzak Memon" > To: rbase-l@googlegroups.com > Date: Fri, 04 Feb 2022 10:30:29 -0500 > Subject: Re:

Re: [RBASE-L] - Tip of the Day: Using the Scratch Pad Utility

2022-01-06 Thread Tony Luck
Now thats handy. Thanks On Fri, Jan 7, 2022 at 6:29 AM A. Razzak Memon wrote: > Thursday, January 06, 2022 > > Tip of the Day: Using the Scratch Pad Utility > Product...: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5) > Build.: 10.5.4.11222 or higher > Sections..:

Re: [RBASE-L] - From The Edge: Tip of the Day Digest (2021)

2021-12-30 Thread Tony Luck
I second that Bruce. I'll see you all in 2022 On Fri, 31 Dec 2021, 10:44 am Bruce Chitiea, wrote: > Razzak: > > It has been a great year for enhancements and tips. Grateful, thank you. > > Here's to a better 2022! > > Bruce A. Chitiea | SafeSectors, Inc. > 112 Harvard Ave #272 | Claremont CA

Re: [RBASE-L] - Handy GETPROPERTY

2021-12-14 Thread Tony Luck
progressing? > Bruce > > -- Original Message -- > From: "Tony Luck" > To: rbase-l@googlegroups.com > Sent: 12/14/2021 6:22:44 PM > Subject: [RBASE-L] - Handy GETPROPERTY > > I had a request to have a clickable form showing the algal bloom > colours (yes

[RBASE-L] - Handy GETPROPERTY

2021-12-14 Thread Tony Luck
I had a request to have a clickable form showing the algal bloom colours (yes we spell color colour) for a pond across the month. When the cell is clicked it calls a form showing the details of the test results for the day in that month. So using an Enhanced DBGrid I've manipulated the data into

Re: [RBASE-L] - Tip of the Day: Setting for Plugins to Return a Safe File/Folder String

2021-12-01 Thread Tony Luck
Razzak if I can use Australian language , your a bloody legend mate On Wed, 1 Dec 2021, 11:54 am A. Razzak Memon, wrote: > Tuesday, November 30, 2021 > > Tip of the Day: Setting for Plugins to Return a Safe File/Folder String > Product...: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5)

[RBASE-L] - The new Speak feature

2021-11-17 Thread Tony Luck
Now this one I have already started to implement for auditable alerts from the system to the user. I created a table of responses to things like low pH values, Low dissolved oxygen levels etcetera. Works really well and with a bit of phonetically spelt sentences i.e DO level becomes dee oh so it

Re: [RBASE-L] - Tip of the Day: New Speak Functionality

2021-11-17 Thread Tony Luck
I'm already into this, what a feature. I can think of a thousand ways to use this. Thank you On Thu, 18 Nov 2021, 3:30 pm A. Razzak Memon, wrote: > Thursday, November 18, 2021 > > Tip of the Day: New Speak Functionality > Product...: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5) >

Re: [RBASE-L] - Comparing R:Base Tables

2021-11-06 Thread Tony Luck
Hey Jim, do you mean what primarys exist in one table verses don't exist in another ? On Sun, 7 Nov 2021, 11:28 am James Burroughs, wrote: > Does anyone know of an R:Base utility to compare two tables (something > along the lines of "proc compare" in SAS)? > > Thanks, > > Jim > > -- > For

Re: [RBASE-L] - Database Columns Report

2021-09-04 Thread Tony Luck
Morning Gary, out printer list columns out screen will do it or put a file name if you want to save it to a file On Sun, Sep 5, 2021 at 7:23 AM Gary Randall wrote: > Hello All, > > Is there a way to print out all the columns in a table? I am looking for a > way to print out the database

Re: [RBASE-L] - R:BASE Flagship Solutions: Unattended Auto-Scrolling and Auto-Refreshing Dashboards

2021-08-24 Thread Tony Luck
This feature is one I have implemented extensively in this project to reflect on a map of the aquaculture farm showing conditions and critical water quality ranges and alerts via colour coded buttons. Visuals are on an update timer that fire every 3 seconds. Works like a dream. On Wed, 25 Aug

Re: [RBASE-L] - PROPERTY for On Exit from DB Grid Column EEP

2021-08-16 Thread Tony Luck
PROPERTY 'COLUMNS[n]->FIELDNAME' 'Value' GETPROPERTY 'COLUMNS[n]->FIELDNAME' vVarValue The value for "n" is the column order in the grid from left to right starting with 0. Morning Bruce I believe this might be what your looking for On Tue, Aug 17, 2021 at 7:54 AM Bruce Chitiea wrote: >

Re: [RBASE-L] - Tip of the Day: Gauge and Meter Options Added to PAUSE Builder

2021-08-12 Thread Tony Luck
This has got a million uses, plus makes life easy to implement thank you On Fri, 13 Aug. 2021, 2:00 pm A. Razzak Memon, wrote: > Friday, August 13, 2021 > > Tip of the Day: Gauge and Meter Options Added to PAUSE Builder > Product...: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5) >

Re: [RBASE-L] - R:Mail question

2021-07-29 Thread Tony Luck
t; > *Making Information Systems People Friendly Since 1990* > > > > *From:* rbase-l@googlegroups.com *On Behalf Of > *Tony Luck > *Sent:* Tuesday, July 27, 2021 7:49 PM > *To:* rbase-l@googlegroups.com > *Subject:* Re: [RBASE-L] - R:Mail question > > > >

Re: [RBASE-L] - R:Mail question

2021-07-27 Thread Tony Luck
This is our settings with Office 365 if it helps. I had issues with the earlier version but since the update I no longer have any issues. On Wed, Jul 28, 2021 at 10:11 AM Bruce Chitiea wrote: > David: > > After consultation with Support, these values worked for me: > > {system core} >SET

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

2021-07-25 Thread Tony Luck
There's a few ways to achieve that, here's one I use to capture the file name of a file we import twice daily using a CHOOSE statement that popups up the files for the operator. CHOOSE vfile FROM #LFILES IN TITLE 'Press ESC to Exit' + CAPTION 'Am Data Import File' OPTION LIST_FONT_SIZE 12 +

Re: Re[2]: [RBASE-L] - PROPERTY 'cid_variableControl' ENABLED [ 'TRUE' | 'FALSE' ] fail

2021-07-17 Thread Tony Luck
lues have been INSERTed into tables - not connected > directly to the form - via a custom form action, prior to this attempt to > re-enable the control in question. > > Best, Bruce > > -- Original Message -- > From: "Tony Luck" > To: rbase-l@googlegroups.com

Re: [RBASE-L] - PROPERTY 'cid_variableControl' ENABLED [ 'TRUE' | 'FALSE' ] fail

2021-07-17 Thread Tony Luck
Morning Bruce, Just having the morning cuppa and if the brain has kicked into gear you might need the do a table refresh after the save and next. Can't be sure but I'd be looking in that area Regards Tony On Sun, 18 Jul 2021, 4:42 am Bruce Chitiea, wrote: > RBGX5E ... 0624 > > (1) A Variable

Re: [RBASE-L] - Importing Data

2021-06-29 Thread Tony Luck
Here's what I did when I have CSV files that I DIDN'T know what positions the header columns were in. My issue was that the sensors in the probes that supply the data could be in different orders to other handsets. I knew the first 5 column headers were constant but the other 5 could be in any

Re: [RBASE-L] - Tip of the Day: TRACE Command and Open File Prompt

2021-06-27 Thread Tony Luck
This is a tool I use daily and the open file prompt makes I even a more powerful tool. I run just about ever app and eep through the tracer to make sure it's solid and the amount of minor loopholes I find are amazing even if the routines end results are correct. On Mon, 28 Jun 2021, 2:00 pm A.

Re: [RBASE-L] - IFF Function Quandry

2021-06-16 Thread Tony Luck
I tried a simple nesting of the IFF as I have nested IFEQ IFLT ect before. This worked SET VAR v1 INTEGER = 1 SET VAR v2 INTEGER = 2 SET VAR v3 INTEGER = 3 SET VAR v4 = (IFF('.v1>.v2','1',(IFF('.v3<.v1','2','3' RETURN I've yet to try with an IN statement though On Thu, Jun 17, 2021 at 6:18

Re: [RBASE-L] - Re: Variable digital gauge property

2021-06-15 Thread Tony Luck
BYW20 sample database, and select the "Start the Motor" button. > > Notice the form display when 90 RPM are exceeded. > > Hope it helps! > > Very Best R:egards, > > Razzak > > > At 04:24 PM 6/15/2021, Tony Luck wrote: > > >Morning my friend, I'm

[RBASE-L] - Variable digital gauge property

2021-06-14 Thread Tony Luck
I'm using a series for variable digital gauges to show the current state of the pond.. Oxygen level pH Salinity and so on. When one of these values falls outside set parameters I want the gauge to show the result in red. Simple enough there is a property command to do this .. PROPERTY

Re: [RBASE-L] - Rows Inserted feedback

2021-06-07 Thread Tony Luck
If you're driving this from a form there is the GETPROPERTY TABLE 'Customer->RECORDCOUNT' vRecordCount. I use it when we import a large csv file each morning and I want to know how many reads are imported. A bit button on the form fires the import command A variable placed on the form then

Re: [RBASE-L] - Web Based Project

2021-05-27 Thread Tony Luck
The guys at RBase do have a web solution and the list of tools you'll need to accomplish the job. I'm sure if you contact them via support they'll be only too happy to ablige. You will need ottero the odbc connector. We use RBase with Android tablets via a wifi network with great success. Have

Re: Re[2]: [RBASE-L] - Forms | Highlight Variable Control upon receiving focus

2021-05-22 Thread Tony Luck
| +011 (909) 912-8678 f > > > -- Original Message -- > From: "Tony Luck" > To: rbase-l@googlegroups.com > Sent: 5/22/2021 2:22:34 PM > Subject: Re: [RBASE-L] - Forms | Highlight Variable Control upon receiving > focus > > I'll be home in a couple o

Re: [RBASE-L] - Forms | Highlight Variable Control upon receiving focus

2021-05-22 Thread Tony Luck
I'll be home in a couple of hours Bruce and have a look. Am I right in thinking that when you tab to the next object you are wanting to get property for hat object and then change the objects property based on certain criteria ? On Sun, 23 May 2021, 5:46 am Bruce Chitiea, wrote: > RBGX5E

Re: [RBASE-L] - change date to datetime

2021-05-21 Thread Tony Luck
Or create another column as datetime, update that column with the original data , drop the date column and rename the new one to the original . It's early in the morning just a passing thought. On Sat, 22 May 2021, 4:29 am Ken Shapiro, wrote: > Along the same lines. > > set var x datetime =

Re: [RBASE-L] - Tip of the Day: Synchronize Selection and Check Boxes in List View Controls

2021-05-20 Thread Tony Luck
Definitely have to have a play with this especially in a multi user environment. On Thu, 20 May 2021, 4:21 pm A. Razzak Memon, wrote: > Thursday, May 20, 2021 > > Tip of the Day: Synchronize Selection and Check Boxes in List View Controls > Product...: R:BASE X.5 and R:BASE X.5 Enterprise

Re: [RBASE-L] - Tip of the Day: User-Defined Paths to Individual R:Style Files

2021-05-14 Thread Tony Luck
I was just having a look myself Doug, and as we would say down under, bloody marvelous. On Sat, 15 May 2021, 3:14 am Doug Hamilton, wrote: > Great feature! > I R:Style all the time - it catches mismatched/errant punctuation, > mistyped variables, tables, columns, etc and provides consistent and

Re: [RBASE-L] - Tip of the Day: Enhanced UNLOAD Parameters for Partial Database Rebuilds

2021-05-12 Thread Tony Luck
That is going to be excellent for scheduled maintenance On Thu, 13 May 2021, 2:30 pm A. Razzak Memon, wrote: > Thursday, May 13, 2021 > > Tip of the Day: Enhanced UNLOAD Parameters for Partial Database Rebuilds > Product...: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5) >

Re: [RBASE-L] - Cannot launch a JPG

2021-04-28 Thread Tony Luck
Morning Karen, Quick question if I may. What does the windows property "open with" property say for the JPG ? On Thu, Apr 29, 2021 at 5:34 AM 'Karen Tellef' via RBASE-L < rbase-l@googlegroups.com> wrote: > Thanks Jan!!! I didn't think of using RBBE and that works just fine! > Gives them the

Re: [RBASE-L] - Rbase ticket system

2021-04-15 Thread Tony Luck
> > Very Best R:egards, > > Razzak > > At 04:44 AM 4/15/2021, Tony Luck wrote: > > >Did I miss something? RBase 11 > > > >On Thu, 15 Apr 2021, 4:27 am A. Razzak Memon, > ><<mailto:raz...@rbase.com>raz...@rbase.com> wrote: > >If you are

Re: [RBASE-L] - Rbase ticket system

2021-04-15 Thread Tony Luck
Did I miss something? RBase 11 On Thu, 15 Apr 2021, 4:27 am A. Razzak Memon, wrote: > If you are interested in designing a cloud-based mobile > Support/Ticketing System using R:BASE X.5 Enterprise, R:BASE 11 > Enterprise, Oterro X.5 Enterprise, Oterro 11 Enterprise, and Java > Version 8, you

Re: [RBASE-L] - Formatting a Phone Number in an Enhanced DB Grid

2021-04-06 Thread Tony Luck
Myron, Open your form in the form designed. From the top menu bar select tables (the main menu bar not the form designer one. Select display format apply the format to your column the format will apply to the column in the grid when you display data On Wed, Apr 7, 2021 at 10:43 AM Bruce Chitiea

Re: [RBASE-L] - Series visible true or false in RCharts

2021-03-30 Thread Tony Luck
ft Text" > settings to give an enhanced appearance to your charts. > > Here is an example: > > > https://www.razzak.com/fte/pdf/UsingEnhancedAppearanceOptionsInRCharts_X5.pdf > > Good Luck! > > Very Best R:egards, > > Razzak > > At 10:39 PM 3/30/2021, Tony

[RBASE-L] - Series visible true or false in RCharts

2021-03-30 Thread Tony Luck
I know I can change the X and Y columns but I would like to toggle certain series on and off according to what a user wants to overlay on a chart. Ive been looking about in RCharts but can't seem to find what I am looking for. Maybe one of you have had the same need and can guide me in the right

Re: [RBASE-L] - Tip of the Day: Utilize Read Only ODBC Connections

2021-03-12 Thread Tony Luck
That is going to be very handy for us in the near future, will save a lot of accessibility issues. On Fri, 12 Mar 2021, 10:15 pm A. Razzak Memon, wrote: > Friday, March 12, 2021 > > Tip of the Day: Utilize Read Only ODBC Connections > Product...: Oterro X.5 and Oterro X.5 Enterprise

Re: [RBASE-L] - Print to email

2021-03-10 Thread Tony Luck
ave more options as well as flexibility of > handling your specific task using R:Mail X.5. > > https://www.rbase.com/products/rmail/ > > Very Best R:egards, > > Razzak > > > At 02:32 AM 3/10/2021, Tony Luck wrote: > > > >Would you recommend RMail for our sol

Re: [RBASE-L] - Print to email

2021-03-09 Thread Tony Luck
WHITE + > |BUTTON_YES_FONT_COLOR GREEN + > |BUTTON_NO_CAPTION + > |BUTTON_NO_COLOR WHITE + > |BUTTON_NO_FONT_COLOR RED > IF vYesNo = 'No' THEN > BREAK > ENDIF > ENDIF > -- more code here to continue the rest of appl

[RBASE-L] - Print to email

2021-03-09 Thread Tony Luck
I have setup under settings for reports to use the Imap email via (for development purposes only) gmail. The SMTP server test gets the success message and SMTP.GMAIL.COM at your service. I create a hazard report that needs to be sent and all looks good in the display as I have preview set on, but

Re: [RBASE-L] - edit table using aliases

2021-03-05 Thread Tony Luck
I'm away on a trip so no laptop, I have a a similar function with alias column names and from memory I included option nochg off, can't remember but give it ago On Fri, 5 Mar 2021, 12:53 am 'Jim Belisle' via RBASE-L, < rbase-l@googlegroups.com> wrote: > I do not see pagenumber as a reserved word

Re: [RBASE-L] - Ghosted text when editing a table

2021-02-23 Thread Tony Luck
Generally I've found these events are caused by outside issues, I had a similar thing in a region object awhile back and it was due to a computer cache issue. Hope your issue is resolved. On Tue, 23 Feb 2021, 8:28 pm randyp ctags.com, wrote: > I used the R:editor to review the data.unl file.

Re: [RBASE-L] - Extracting a COMPID value assigned to an object.

2021-02-11 Thread Tony Luck
Custom Form Action. > . Each button executes the same form action. > . In the action, there are IFs to check the value if RBTI_FORM_CLICKED. > . Now you can run your application your way! > > Have fun implementing these cool approaches in your application! > > Very Best R:egard

[RBASE-L] - Extracting a COMPID value assigned to an object.

2021-02-11 Thread Tony Luck
Anyone know how to get the value of a componentID dynamically. Its listed in the Object inspector as CompID and has the value. I've looked in the GETPROPERTY list and can't see how to extract the value. I want to use the componentID in a universal routine as the mouse hovers over a group of bit

Re: [RBASE-L] - Passing a variable URL to the Web Browser

2021-02-10 Thread Tony Luck
This is one I use on a bit button to change web sites on a form SET VAR vurl = 'http://www.bom.gov.au/' PROPERTY webbrowser1 GOURL RETURN Hope its what your looking for On Thu, Feb 11, 2021 at 7:00 AM Doug Hamilton wrote: > How do I pass a variable URL to the Web Browser control in a form? >

Re: [RBASE-L] - #DUP in grids?

2021-02-09 Thread Tony Luck
One last thought, does it have to be a grid ?, because it would be so much easier on a scrolling region where you could place the bit button as the last entity on the row to fire the duplicate row. On Wed, Feb 10, 2021 at 2:19 AM 'Karen Tellef' via RBASE-L < rbase-l@googlegroups.com> wrote: >

Re: [RBASE-L] - #DUP in grids?

2021-02-09 Thread Tony Luck
A possible option would be to have the entry row above into dbedit columns with the grid below showing the input and use a bit button as the last object in the tab order so it would be just another key press and assign duplicate row from predefined eeps. That would allow the user to do continuous

Re: [RBASE-L] - Command syntax in forms

2021-02-09 Thread Tony Luck
ier Valencia, PE > > javier.valen...@vtgonline.com > > O: 913-829-0888 > > C: 913-915-3137 > > > > > > > > *From:* rbase-l@googlegroups.com *On Behalf Of > *Tony Luck > *Sent:* Monday, February 8, 2021 9:11 PM > *To:* rbase-l@googlegroups.com >

Re: [RBASE-L] - Command syntax in forms

2021-02-08 Thread Tony Luck
The other one is code templates depicted by the magic wand over a document in the icon select on the editor. On Tue., 9 Feb. 2021, 12:43 pm , wrote: > When I am working on an EEP in a form I would like to be able to insert > the syntax for a command so I can just modify it with my own data. > >

Re: [RBASE-L] - Command syntax in forms

2021-02-08 Thread Tony Luck
Do you mean type the command than press F5 and RBase inserts the syntax ? On Tue., 9 Feb. 2021, 12:43 pm , wrote: > When I am working on an EEP in a form I would like to be able to insert > the syntax for a command so I can just modify it with my own data. > > I seem to remember being able to

[RBASE-L] - Dynamic table creation from a CSV file

2021-02-02 Thread Tony Luck
Had an issue during testing today, when people have to use different handset that has a different arrangement of probe sensors. Each of these sensors may be arranged in a different way so the export CSV file will be different. There goes gateway mapping to certain cells to columns in the import

Re: Re[2]: [RBASE-L] - Prelims to the tools used

2021-01-30 Thread Tony Luck
; "Chai-chee-er" in Redneck English > > SafeSectors, Inc. > > ------ Original Message -- > From: "Tony Luck" > To: rbase-l@googlegroups.com > Sent: 1/30/2021 1:33:40 PM > Subject: Re: [RBASE-L] - Prelims to the tools used > > Thanks for correcting

Re: [RBASE-L] - Prelims to the tools used

2021-01-30 Thread Tony Luck
January 30, 2021 5:36:28 AM > *To:* rbase-l@googlegroups.com > *Subject:* Re: [RBASE-L] - Prelims to the tools used > > Well, I nominate Tony as having the first virtual seminar! I'd pay to be > able to watch him demonstrate the code and the use of all these tools!!! > > > Karen &

[RBASE-L] - Prelims to the tools used

2021-01-30 Thread Tony Luck
Before I get into the technices I'd like to share the tools used and why. Obviously RBase Enterprise, Oterro, RCharts, and RSynchronizer. There are two other Third party tools Menable and DBDriod from Syware. RBase because it's only limitations is your imagination, RCharts visual data

Re: [RBASE-L] - convert text to time data type

2021-01-29 Thread Tony Luck
I would suggest the time format is set not to include am pm thus a simple text to time conversion. On Fri., 29 Jan. 2021, 8:03 pm Alastair Burr, wrote: > Try the function: (CTXT(arg)) > > Regards, Alastair > On 29/01/2021 05꞉41, 'R Hopkins' via RBASE-L wrote: > > > Dan, > Here is another

[RBASE-L] - Short demo Visual Interface

2021-01-27 Thread Tony Luck
I have created a short demo of the visual interface I am developing. There is a link to the demo below. The purpose is to show the interface in action so when I'm explaining how I manipulate the components of the forms, people will better understand the actions and controls. These forms are

Re: [RBASE-L] - Tip of the Day: Using the R:BASE Engine Debug Setting

2021-01-27 Thread Tony Luck
That is going to be very useful, thanks for the heads up On Thu, Jan 28, 2021, 6:53 AM A. Razzak Memon wrote: > Wednesday, January 27, 2021 > > Tip of the Day: Using the R:BASE Engine Debug Setting > Product...: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5) > Build.:

Re: [RBASE-L] - Mobile data collection without reliable internet or Wi-Fi

2021-01-26 Thread Tony Luck
Javier Valencia, PE > > javier.valen...@vtgonline.com > > O: 913-829-0888 > > C: 913-915-3137 > > > > > > > > *From:* rbase-l@googlegroups.com *On Behalf Of > *Tony Luck > *Sent:* Monday, January 25, 2021 2:40 PM > *To:* rbase-l@googlegroups.com &

Re: [RBASE-L] - Question of Group By and Having Clause

2021-01-25 Thread Tony Luck
to > define the count variable as needed. I frequently use temp tables, but > thanks for the reminder. > > > > Thanks so much, hope you could take advantage of Australia Day. > > > > Steve J > > > > *From:* rbase-l@googlegroups.com [mailto:rbase-l@googleg

Re: [RBASE-L] - Question of Group By and Having Clause

2021-01-25 Thread Tony Luck
No worries, don't forget to drop the temp table after you print your report so it can recreate the table next time you run your querry, you could also have a variable to filter the number of scan instances to make it even more flexible. On Tue, Jan 26, 2021, 6:40 AM Steve Johnson wrote: >

Re: [RBASE-L] - Mobile data collection without reliable internet or Wi-Fi

2021-01-25 Thread Tony Luck
com > > O: 913-829-0888 > > C: 913-915-3137 > > > > > > > > *From:* rbase-l@googlegroups.com *On Behalf Of > *Tony Luck > *Sent:* Saturday, January 23, 2021 10:53 PM > *To:* rbase-l@googlegroups.com > *Subject:* [RBASE-L] - Mobile data collection witho

Re: [RBASE-L] - Question of Group By and Having Clause

2021-01-24 Thread Tony Luck
Project temporary scantable from mainscantable using all Sorry forgot to include the from statement Steve my bad. On Mon, Jan 25, 2021, 1:18 PM Steve Johnson wrote: > Is there a means to take the statement below and extract the data from the > driving table to either create a temporary

Re: [RBASE-L] - Question of Group By and Having Clause

2021-01-24 Thread Tony Luck
I'm on my mobile so I'll be brief. You could use project, than remove unwanted rows. Project temporary scantable using all The above statement can also contain a where clause to limit by a date for instance next remove unwanted from temp table DELETE ROWS FROM scantable WHERE SCANID IN (SELECT

[RBASE-L] - Mobile data collection without reliable internet or Wi-Fi

2021-01-23 Thread Tony Luck
As the title suggests I would like to share a part of a new project I'm currently building for those who maybe interested. Currently I am working in a aquaculture site that produces Black Tiger Prawn's. About 30 million dollars worth a season. It's located at Ayr, North Queensland right on the

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

2021-01-23 Thread Tony Luck
live now.. On Sat, Jan 23, 2021, 6:14 PM Tony Luck wrote: > God, I had a version of clout, it was quite forward for it's time. > Basically you set key words to mimmic commands. I must admit I still have > my original System V version of RBase the one in the hard blue case. Boy we >

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

2021-01-23 Thread Tony Luck
God, I had a version of clout, it was quite forward for it's time. Basically you set key words to mimmic commands. I must admit I still have my original System V version of RBase the one in the hard blue case. Boy we are getting on  On Sat, Jan 23, 2021, 5:40 PM wrote: > I just found a

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

2021-01-21 Thread Tony Luck
Still got my Mircorim cuff links and tie pin in my draw at home...however geographically unable to participate in this bidding ha ha. On Fri, Jan 22, 2021 at 9:32 AM 'Karen Tellef' via RBASE-L < rbase-l@googlegroups.com> wrote: > Ahhh you have to do better than that. I have my Microrim

Re: [RBASE-L] - Form Controls: SET NULL '' confusion

2021-01-19 Thread Tony Luck
Off the top of my head what effect does setting EQNULL on in the settings have in a case like this ? On Wed, Jan 20, 2021 at 12:26 PM Bruce Chitiea wrote: > All: > > *SET NULL ' '* (ASCII 032) is often used within On Before Design > and On After Start form EEPs to suppress display of the

Re: [RBASE-L] - new to drag and drop

2021-01-18 Thread Tony Luck
on many components but this is one simple one. On Tue, Jan 19, 2021 at 10:47 AM Tony Luck wrote: > It'll do that until you drag over to the drop area, then will change to a > small rectangle. I'll put together a more detailed example for you today > (its 11 am Tuesday) > > On Tue, Jan

Re: [RBASE-L] - new to drag and drop

2021-01-18 Thread Tony Luck
tems People Friendly Since 1990* > > > > *From:* rbase-l@googlegroups.com *On Behalf Of > *Tony Luck > *Sent:* Monday, January 18, 2021 6:10 PM > *To:* rbase-l@googlegroups.com > *Subject:* Re: [RBASE-L] - new to drag and drop > > > > On the DRAG eep the GET

Re: [RBASE-L] - new to drag and drop

2021-01-18 Thread Tony Luck
On the DRAG eep the GETPROPERTY will get the unique value and store it to Vvariable (ensuring your first column is the unique ID for the row) GETPROPERTY grid1 TEXTVALUE Vvariable RETURN In the DROP eep process the row based on the unique ID i.e. APPEND tablerow TO newtable where uniqueID =

[RBASE-L] - Delete all in the data browser

2021-01-13 Thread Tony Luck
Does anyone know if there is a way to disable the new prompt when you select delete all rows in the data browser. It asks you to confirm by type the word delete at the prompt. Had a look in settings under the data browser and didn't see anything. Maybe there isn't just asking. -- Regards Tony

Re: [RBASE-L] - convert text to time data type

2021-01-13 Thread Tony Luck
IF your using the value to calculate in a variable SET VAR vtime TIME If your time formatting is without ap/pm it will automatically drop the AM or PM So 10:00 AM will become 10:00:00 as a time data type On Thu, Jan 14, 2021 at 1:26 AM Dan Goldberg wrote: > Thx guys. I think this gives me an

Re: [RBASE-L] - VAR LOOKUP LISTVIEW

2021-01-05 Thread Tony Luck
Below is a snippet of code I use with the checkbox to allow the user to select multiple ponds then process them either as a collective or you could process them individually The GETPROPERTY componentid CHECKEDITEMS variable will contain the checked items. The use of the ampersand variable is a

Re: [RBASE-L] - Set var

2020-12-20 Thread Tony Luck
vrun) -- Create the file name SET VAR vrenfile = (.vdate+.vrunname) RENAME kordss*.csv The result is a file named '12/12/2020AMrun.csv' Hope that's the sort of thing your looking for.. On Mon, Dec 21, 2020 at 10:11 AM Tony Luck wrote: > Tom, > > Set var vfile = 'myfile.

Re: [RBASE-L] - Set var

2020-12-20 Thread Tony Luck
Tom, Set var vfile = 'myfile.txt' to use the file name place and '&' in front of your variable i.e type ( would type the contents to screen at the r>) On Mon, Dec 21, 2020 at 9:54 AM Tom Hart wrote: > how do you set a var to a text file > I have tried set var var1 text =

Re: [RBASE-L] - proper code

2020-12-14 Thread Tony Luck
A view might get the results your after with a procedure to update your inventory levels . As you mentioned nested cursors will achieve what your after and their performance if correctly used is lightning fast. On Tue, 15 Dec 2020, 8:13 am 'Jim Belisle' via RBASE-L, < rbase-l@googlegroups.com>

[RBASE-L] - Maybe a Hello zoom would be nice

2020-12-12 Thread Tony Luck
Just an idea, perhaps a general giday (hello) in other languages, would be good for everyone to introduce themselves. Share some of our Rbase experience and generally start the ball rolling. Then we could define training verse sharing of techniques and schedule appropriate online timelines for

Re: [RBASE-L] - Developing and Deploying R:BASE Mobile Handheld Applications

2020-12-10 Thread Tony Luck
Agreed, people from all over the globe could attend. I am currently on a project on a large aquaculture farm and using android tablets for field data collection back to an Rbase event driven management system. We are now looking at some sections of that application to move onto the cloud for

Re: [RBASE-L] - Expanding and Contracting a DB LOOKUP COMBO BOX

2020-12-07 Thread Tony Luck
Found it, DROPDOWNWIDTH property. Knew Razzack and the Dream team would have it in there somewhere. Just getting my head around so many new options. On Tue, Dec 8, 2020 at 12:07 PM Tony Luck wrote: > I’m attempting to have a DB COMBO LOOKUP Box expand so the user can see >

[RBASE-L] - Expanding and Contracting a DB LOOKUP COMBO BOX

2020-12-07 Thread Tony Luck
I’m attempting to have a DB COMBO LOOKUP Box expand so the user can see the ID and description for selection, it then does a variable lookup on the description to display on the form but only stores the ID. Simple enough via an On Mouse ENTER EEP using the property command below PROPERTY locate1

[RBASE-L] - Moving data between grids

2020-12-04 Thread Tony Luck
Very insightful, nicely done. I'm sure I'll find a use for this style of processing. Thanks Javier.. -- 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