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

2024-05-21 Thread 'Dan Goldberg' via RBASE-L
It could be that it does not support project command in external sql. Not sure which type of database you are connecting to, You can do the same like project by creating a temp table with the columns and then do an insert. --Create tablename (column definitions) Then do Insert into tablename

RE: [EXTERNAL] Re: [RBASE-L] - Checking Variables

2024-04-25 Thread 'Dan Goldberg' via RBASE-L
That way, without any -ERROR-message, etc., if the variable in question exists, nothing happens; if it doesn't exist, it creates one with a NULL value. Very Best R:egards, Razzak On 04/24/2024 1:26 PM EDT 'Dan Goldberg' via RBASE-L mailto:rbase-l@googlegroups.com>> wrote: That was easy.

RE: [EXTERNAL] Re: [RBASE-L] - Checking Variables

2024-04-24 Thread 'Dan Goldberg' via RBASE-L
. The function returns an integer value of 1 if the variable name exists or declared, and 0 if it is not found or declared. -- Original Message -- >From "'Dan Goldberg' via RBASE-L" >mailto:rbase-l@googlegroups.com>> To "rbase-l@googlegroups.com<mailto:rbase-l@goog

[RBASE-L] - Checking Variables

2024-04-24 Thread 'Dan Goldberg' via RBASE-L
I am looking for a way to check to see if a variable has been created. Does anyone know a way to see if a variable has been created? Dan Goldberg -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to

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

2024-03-21 Thread 'Dan Goldberg' via RBASE-L
<mailto:steve_swee...@addesigns.com>. Learn why this is important<https://aka.ms/LearnAboutSenderIdentification> Dan – is that for manifold pressure in a piston driven airplane?  Steve From: 'Dan Goldberg' via RBASE-L mailto:rbase-l@googlegroups.com>> Sent: Thursday, Marc

[RBASE-L] - variable gauges

2024-03-21 Thread 'Dan Goldberg' via RBASE-L
Hi I am playing with variable gauges for the first time and they are pretty cool. The only thing I have not figured out is how to only have the major tick labels to be integers. In this example I have 31 as the max and 0 as the min. as you can see the middle one is 15.5

RE: Re[2]: [EXTERNAL] Re: [RBASE-L] - variable gauge set max value

2024-03-20 Thread 'Dan Goldberg' via RBASE-L
datatype, any rounding not shown.) Hope that helps, Bruce Bruce A. Chitiea SafeSectors, Inc. 1142 S Diamond Bar Blvd # 442 Diamond Bar CA 91765-2203 rby...@safesectors.com<mailto:rby...@safesectors.com> (909) 238-9012 m ------ Original Message -- >From "'Dan Goldberg' via

RE: [EXTERNAL] Re: [RBASE-L] - variable gauge set max value

2024-03-19 Thread 'Dan Goldberg' via RBASE-L
Thx but the quote idea did not work. Dan Goldberg From: rbase-l@googlegroups.com On Behalf Of jan johansen Sent: Monday, March 18, 2024 9:57 AM To: 'Dan Goldberg' via RBASE-L Subject: [EXTERNAL] Re: [RBASE-L] - variable gauge set max value Dan, Just guessing here but the syntax guide shows

[RBASE-L] - variable gauge set max value

2024-03-18 Thread 'Dan Goldberg' via RBASE-L
Using 10.5 latest I have a variable gauge that the max value will need to be set dynamically. I think I found the correct rdocs reference: PROPERTY 'SCALES[n]->OPTIONSVIEW->MAXVALUE' 'n.nn' So I have my command PROPERTY cvgshipped 'SCALES[1]->OPTIONSVIEW->MAXVALUE' .veshipnum Which does not

RE: [EXTERNAL] Re: [RBASE-L] - mystery character

2024-01-18 Thread 'Dan Goldberg' via RBASE-L
-in-phishing-email> A few weeks ago, Bank of America included a similar write up in one of their weekly emails to customers. Javier, Javier Valencia, PE 14315 S Twilight Ln Olathe, KS 66062 913-915-3137 From: 'Dan Goldberg' via RBASE-L mailto:rbase-l@googlegroups.com>> Sent: Wednesday,

RE: [EXTERNAL] Re: [RBASE-L] - mystery character

2024-01-17 Thread 'Dan Goldberg' via RBASE-L
ter (e.g. a " - ") in its place, and see what happens? Best, Bruce Bruce A. Chitiea SafeSectors, Inc. 1142 S Diamond Bar Blvd # 442 Diamond Bar CA 91765-2203 rby...@safesectors.com<mailto:rby...@safesectors.com> (909) 238-9012 m -- Original Message -- >

[RBASE-L] - mystery character

2024-01-17 Thread 'Dan Goldberg' via RBASE-L
I have a character that looks ok in db edits but not in enhanced db grids. I have played with the fonts thinking the font does not like the character but no help. Anyone ran across this before? [cid:image001.png@01DA4917.03940A40] TIA Dan Goldberg -- For group guidelines, visit

RE: [EXTERNAL] Re: [RBASE-L] - logging database value changes in a form

2023-12-21 Thread 'Dan Goldberg' via RBASE-L
rbti_% Now to data in separate table(s). There is an update performed – as I previous mentioned but not on a test for a data change in a row of data in the table. Still working on it. Yes, I didn’t answer your question per se but just wanted to let you know it is still being worked on. Myron From:

[RBASE-L] - R:Web Reports Order by

2023-12-21 Thread 'Dan Goldberg' via RBASE-L
I am working on a new R:web report and do not see an option to add a order by or arrange tablename by collist Has anyone been able to add it in? TIA Dan Goldberg -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you

[RBASE-L] - logging database value changes in a form

2023-12-20 Thread 'Dan Goldberg' via RBASE-L
I have a requirement to keep a log(in a separate table) when someone changed the data in a row in a form. This will include the old values and new values as well as user/datetime stamp. Has anyone done this before and can give me some pointers? Happy Holidays Dan Goldberg -- For group