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

You might create a view combining the related tables. Then simply project from the view. The view might remain rather than being generated for each instance. No additional SQL statements would be required. All the best, Randy Peterson From: rbase-l@googlegrou

Re: Re[2]: [RBASE-L] - Calculating Age in Years, Months | PRIVATE

If you are doing this for every row in your database, you might create a view rather than calculate row by row. You could add the Y & M as part of your report fields. You could limit your view to "WHERE DeathDateTime IS NOT NULL" , or "WHERE DeathDateTime EXISTS." Might something like this wor

Re: [RBASE-L] - I want to use a CHOOSE command to list options from a subdirectory rather than from inside a connected database.

Dear Karen, I found CHOOSE in help but didn't recognize the usage for its #Lfiles option. My RMD files are located in this subdirectory: C:\RBTI\RBGX5E\Samples\ CHOOSE vaRbase FROM #LFILES IN c:\rbti\rbgx5e\samples\*.rmd RUN .vaRbase This CHOOSE generates a lovely, alphabetical listing of ava

Re: [RBASE-L] - Database CHOOSER

Dear Bruce, Your solution appears more comprehensive and elegant than I envisioned. My suggestion was more along the line of an R:Base feature included with the program. Please share how you do this, as it also suggests some strategies for organization, and sub-directory management. All the b

[RBASE-L] - I want to use a CHOOSE command to list options from a subdirectory rather than from inside a connected database.

I have multiple RMD files in the same subdirectory that basically say: Change directory to the directory where my desired database is located. OPEN this database. I would like a choose command that lists all my files ending in .RMD. That way I can select the RMD file, and use: RUN name.RMD whi

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

Why create a variable vspc rather than using the (char(160)) value in your SFIL? I understand it is easier to test various values. Is there any other reason? Randy Peterson. PS. It's nice to know there is a (CHAR(160)) hard space. The result is similar to using a font that is not proportional

Re: [RBASE-L] - Norton Anti-Virus and the R:Documenter Plugin

When I updated to the most recent R:Base version the program seemed to update correctly but when I tried to access a database, I received the same message from Norton 360. The popup had a link [View Details] which I selected to exclude RBGX5E.EXE. R:Base Services from R:Base Technologies provid

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

Dear Razzak, Family & Associates, Your dedicated and creative efforts provide daily benefit for developers, clients and all our families. Blessings to all for accomplishments and prospects. Best R:egards, Randy Peterson mba, cpa, cma Blue Springs, Missouri Get Outlook for iOS

Re: [RBASE-L] - out of dynamic space

Try disconnecting and reconnecting the database. A reload may help. If not, close programs and reboot. Sometimes temporary memory is not released as expected. Randy Peterson Get Outlook for iOS From: 'jim schmitt' via RBASE-L Sent: Monday

Re: [RBASE-L] - Importing Data From Text File

1. Your data should not have opening or closing parenthesis. 2&3. GATEWAY is defining WaVoters as a new CSV table. It may be helpful to remove file names from your first row. It can confuse the datatyping. You know the order and can write File1, File2, and so forth under StateVoterID

Re: [RBASE-L] - Importing Data From Text File

Dear Gary, Try proceeding in consecutive steps: SHOW This will reveal your present settings. Delimit will be , SET DELIMIT=| You can use the SHOW command to see that it was changed GATEWAY IMPORT CSV WaRegVoters.TXT CREATE WaVoters This should import your file [WaRegVoters.TXT] as CSV using |

Re: [RBASE-L] - X.5E Upgrade woes

Dear Patti, All good reasons. Karen Tellef provided excellent code to ensure that you get what you need from input and can format it as it is stored: In all the DBs I have that have a SSN, it's stored as a 9 digit Text with no dashes. That is my PK or index column. On some, I was smart enough

Re: [RBASE-L] - Conversion

UPDATE [TABLE] SET Refnum = (INT(FLOAT(TRefNo))) You could also define this as a computed column using (INT(FLOAT(tRefno))) Or you could create a view that would. Do any operations using the view rather than the table. If you use a view, it will utilize less space because your table will have

Re: [RBASE-L] - How to make three columns into one?

The same result can be accomplished with a view rather than using computed columns in a table. That reduces the file size. Your report is based on the view, not a table. Randy From: rbase-l@googlegroups.com on behalf of Bo Franzén Sent: Thursday, June 3, 202

Re: [RBASE-L] - Tip of the Day: Human Readable Support for Two-Dimensional Bar Codes

Dear R:azzak, You have a nice system of software and hardware for scanning, labeling , documenting and analyzing inventory. I noted that you capture the name of the person performing the scan. That is useful for accountability, and also if there are questions about any items. We went to manuf

Re: [RBASE-L] - Tip of the Day: Human Readable Support for Two-Dimensional Bar Codes

Dear R:azzak, It's great to hear from you and to see the system you have developed. I like your graphical description of the inventory process. We were able to use a Symbol Technologies handheld, as well as a Palm Pilot to scan labels. One additional field you might want to include, particular

Re: [RBASE-L] - Tip of the Day: Human Readable Support for Two-Dimensional Bar Codes

Are there specific brands, and machine models that are best for printing these labels? What label material have users been pleased with? Continental Tax Corporation used Swedot and UBI printers with custom label material we specified. Our printers had a carbon that was melted onto the label f

Re: Re[2]: [EXT] Re: [RBASE-L] - Importing XML data into R:BASE

Mike, I have converted data strings of a variety of computer outputs. If you get a continuous string, you need to determine where each file begins and ends. There is some type of marker in the string. If it is a carriage return/line feed it will be easier. If not, you can search and replace,

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

Everything seems to be working reliably and well, as I have always expected and found to be true. From: rbase-l@googlegroups.com on behalf of Tony Luck Sent: Tuesday, February 23, 2021 4:43 AM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - Ghosted text w

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

I used the R:editor to review the data.unl file. There were a few peculiarities I addressed. I ran the check within the editor. I was not able to replicate the anomaly previously experienced. I reloaded and also unloaded my original database, and after connecting and running, the databases w

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

Here is a 15;55 minute description of generating a map where hovering shows the underlying data. It may suggest data sources and ways of merging that may be useful. https://www.facebook.com/asistenacademy/videos/2815343168713619 [https://scontent-sea1-1.xx.fbcdn.net/v/t15.5256-10/s320x320/121950