RE: [EXTERNAL] [RBASE-L] - Having Trouble with the SQL in a Project Statement

the WHERE clause to “part_id = 'P7035826608102' thereby eliminating the need to join the two SQL tables/views in R:BASE: SELECT (columnA, column B … etc) FROM (SQL-joined-table/views) WHERE part_id = 'P7035826608102' Steve Sweeney From: 'Dan Goldberg' via RBASE-L Sent: Tuesday, May 21, 2024 2

RE: [RBASE-L] - CVAL CONNECTIONS

are connected, and need to exit. Thanks and regards. On Tuesday, April 2, 2024 at 06:05:50 PM EDT, Steve Sweeney mailto:steve_swee...@addesigns.com>> wrote: I always: DISCONNECT SET MULTI OFF CONNECT {dbname} If there are NO errors (if

RE: [RBASE-L] - CVAL CONNECTIONS

I always: DISCONNECT SET MULTI OFF CONNECT {dbname} If there are NO errors (if I CAN connect) then we are good to go with a backup. Also, I stop any web services connecting through Oterro – this seems to have a persistent connection, as well.

RE: Re[2]: [EXTERNAL] [RBASE-L] - RE: variable gauges

uot; mailto:rbase-l@googlegroups.com>> Date 3/21/2024 12:15:24 PM Subject RE: [EXTERNAL] [RBASE-L] - RE: variable gauges Hmm I guess we can make flying RVs LOL Dan Goldberg From: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com> mailto:rbase-l@googlegroups.com>> On Beh

[RBASE-L] - RE: variable gauges

Dan – is that for manifold pressure in a piston driven airplane?  Steve From: 'Dan Goldberg' via RBASE-L Sent: Thursday, March 21, 2024 6:46 AM To: rbase-l@googlegroups.com Subject: [RBASE-L] - variable gauges Hi I am playing with variable gauges for the first time and they are pretty cool.

RE: [RBASE-L] - Tip of the Day Digest (2023)

Outstanding! Such a great tool Thank you, Razzak! Steve From: rbase-l@googlegroups.com On Behalf Of Razzak Memon Sent: Wednesday, January 3, 2024 7:21 AM To: rbase-l@googlegroups.com Subject: [RBASE-L] - Tip of the Day Digest (2023) Wednesday, January 03, 2024 To R:BASE Community: The

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

Myron, I think the solution would be to do what R:BASE is doing under the surface when it performs “concurrency control” when saving the date. If I’m not mistaken, R:BASE makes a copy of the “original” data and stores it before bringing a second copy of the same data into the screen form.

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

SET V v3 REAL = .#PI SHOW V v3 3.141593 SET V v3 = (ROUND(.v3,3)) SHOW V v3 3.142 From: rbase-l@googlegroups.com On Behalf Of Lin MacDonald Sent: Tuesday, November 7, 2023 5:54 PM To: rbase-l@googlegroups.com Subject: [RBASE-L] - Where do I set my Vars? This will sound silly, but

RE: Re[2]: [RBASE-L] - creating text file with blank spaces in tact

ASCII 255 is another option for a hard space. Steve From: rbase-l@googlegroups.com On Behalf Of Bruce Chitiea Sent: Saturday, November 4, 2023 9:39 AM To: rbase-l@googlegroups.com Subject: Re[2]: [RBASE-L] - creating text file with blank spaces in tact James: In broader context, I cannot

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

Another option would be to INSERT INTO tablename (TEXT_columnname) VALUES (‘obscure_reference_code’) to establish the primary key (PK) first. Then SELECT pk_columnname INTO variable_name FROM tablename WHERE TEXT_columnname = ‘obscure_reference_code’ Then you can “EDIT USING formname WHERE

RE: [RBASE-L] - Manuals for older R:Base versions

I would love the 35 issues of R:BASE Exchange. Please email me directly so we can coordinate the shipment – steve_swee...@addesigns.com<mailto:steve_swee...@addesigns.com> Thanks very much! Steve Sweeney From: 'R Hopkins' via RBASE-L Sent: Wednesday, April 7, 2021 2:49 PM To: r

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

i 2(2²) Σ π From: rbase-l@googlegroups.com On Behalf Of baue...@gmail.com Sent: Tuesday, February 9, 2021 5:29 AM To: RBASE-L Subject: Re: [RBASE-L] - Command syntax in forms My memory isn't what it used to be, but I still manage to get by: When you have 4 mins to ponder.

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

Is it a signed copy?  From: 'Karen Tellef' via RBASE-L Sent: Thursday, January 21, 2021 1:55 PM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - Re: SQL book Yikes Okay, I'll sell my limited edition Downall / Blocker tome for only $99.99 Karen -Original Message- From:

RE: [RBASE-L] - The Power of R:Base Forms

Rolf, Thank you so much! I really love Sudoku – just downloaded it – will give it a try. Happy New Year! Steve Sweeney From: 'U56.S11+G43' via RBASE-L Sent: Friday, January 1, 2021 9:14 AM To: RBASE-L Subject: [RBASE-L] - The Power of R:Base Forms Dear R:Base community, Best wishes

RE: [RBASE-L] - (CVAL('ComputerName'))

You might try writing a small batch file to call from System V – if calling a batch file is possible? SET COMPUTERNAME > ComputerNameBatchFile.txt Then, read the TXT file Steve From: 'Karen Tellef' via RBASE-L Sent: Wednesday, August 19, 2020 12:42 PM To: rbase-l@googlegroups.com Subject: