Javier: When you mentioned CLOUT, you got me to thinking, and being on R:Base aficionado, i went to my R:Base collection, and found a copy of CLOUT in a slip case, with a copyright of 1984.On the outside of the case, the verbiage advertised "with CLOUT, you ask questions of your data in your own words.聽 There are no commands or computerese to learn".Your are right, RB was ahead of it's time. Ohio Software ServicesJim1-614-361-3942
On Thursday, April 3, 2025 at 04:03:42 AM EDT, Tony Luck <[email protected]> wrote: I used clout back in the eighties, coupled with 2.11 from memory. Once clout understood the schema of your data base you could type in a basic sentence and it would respond with your requested data. Simple but very clever at the time.So AI not really because imagination is the key. That's the tool we have to expand the mind and thinking. Not limited to existing information at hand and predictable outcomes.聽To me AI is lazy thinkers.Anyway I am still here and working on some unique stuff in my retirement. All the best thinkers On Thu, 3 Apr 2025, 5:55鈥痯m , <[email protected]> wrote: R:Base had a primitive AI application in the late 80s (?) called Clout. I guess there was not much interest on it since its development stopped. It did basic things but nothing that you could not easily do from the R> prompt using simple language. Perhaps it was aimed at non-tech users , but non-tech users did not use databases much back then. In many ways, R:Base was ahead of its time. 馃槉 聽 Javier, 聽 Javier Valencia, PE 14315 S Twilight Ln Olathe, KS 66062 913-915-3137 聽 聽 聽 From: [email protected] <[email protected]> On Behalf Of rdiaz kcnyenterprises.com Sent: Tuesday, April 1, 2025 11:24 AM To: RBASE-L <[email protected]> Subject: [RBASE-L] - Re: Grok 3 AI generated R:Base code from a simple prompt: Can you write code for R:Base version 11 database? 聽 I need to start to learn about this.聽 Would love to be able to make an Ad Hoc Query for a client to be able to ask AI questions about his data.聽 At first it would only be for owners and users that can have access to all the data.聽 Eventually train the AI to have different levels for different users. 聽 Maybe its a product for Rbase to create, an AI Plug-in for USERS of the databases we create as developers. 聽 From:聽[email protected] <[email protected]> on behalf of Peter Ryan <[email protected]> Sent:聽Tuesday, April 1, 2025 9:56 AM To:聽RBASE-L <[email protected]> Subject:聽[RBASE-L] - Re: Grok 3 AI generated R:Base code from a simple prompt: Can you write code for R:Base version 11 database? 聽 For fun , wrote and started training a R-GPT聽 for private use with Open AI AIPRM prompt.聽 When asked "to improve" the code I am impressed with the results and the added documentation COMMENTS to add to the snip of code. 聽 Training to specify RBase and ignore R or other code options can narrow or refine the results.聽聽 聽 Dreaming more about聽 RBase:AI聽 solutions someday聽 ... 聽 聽 聽 From:聽[email protected] on behalf of randyp ctags.com Sent:聽Tuesday, April 1, 2025 9:25 AM To:聽RBASE-L Subject:聽[RBASE-L] - Grok 3 AI generated R:Base code from a simple prompt: Can you write code for R:Base version 11 database? 聽 Grok 3. 聽Can you write code for R:Base version 11 database?Yes, I can help you write code for R:BASE Version 11, a relational database management system (RDBMS) that uses its own command syntax for managingand querying databases. R:BASE has a unique programming environment with commands like CREATE, INSERT, SELECT, and RUN, often executed via its command-line interface or stored in script files (e.g., .RMD聽files). Below, I鈥檒l provide an example of R:BASE code tailored to a simple use case, followed by explanations. Since you haven鈥檛 specified a particular task, I鈥檒l assume you鈥檇 like a basic example鈥攕uch as creating a table for tracking Holyweek events (tying into your earlier question), inserting data, and querying it. If you have a specific requirement, feel free to clarify!Example R:BASE CodeThis code creates a table for Holy Week events, inserts data based on John P. Pratt鈥檚 33 AD timeline, and retrieves it.聽 聽[A previous question I asked, but did not specify for Grok's example.聽What are the dates and days of events during Holy Week according to John Pratt? ]rbase/* Clear the screen and set up environment */聽CLS聽SET ECHO ON聽/* Create a database if it doesn鈥檛 exist */聽CREATE DATABASE HolyWeekDB聽/* Connect to the database */聽 CONNECT HolyWeekDB聽/* Create a table for Holy Week events */聽CREATE TABLE HolyWeekEvents (聽聽 EventID INTEGER PRIMARY KEY,聽聽 EventName VARCHAR(50),聽聽 EventDate DATE, EventDay VARCHAR(20),聽聽 Description VARCHAR(255) )聽/* Insert data for Holy Week 33 AD per John Pratt */聽INSERT INTO HolyWeekEvents VALUES (聽聽 1,聽'Triumphal Entry',聽'03/27/0033',聽'Sunday',聽'Jesus enters Jerusalem on a donkey, greeted with palms.'聽)聽聽INSERT INTO HolyWeekEvents VALUES (聽2,聽 'Cleansing of Temple',聽'03/28/0033',聽'Monday',聽'Jesus overturns tables in the Temple.'聽)聽聽INSERT INTO HolyWeekEvents VALUES (聽聽3,聽'Last Supper',聽 '03/31/0033',聽'Thursday',聽'Jesus shares Passover meal and institutes Eucharist.'聽)聽聽INSERT INTO HolyWeekEvents VALUES (聽4,聽'Crucifixion',聽 '04/01/0033',聽'Friday',聽'Jesus is crucified and dies at 3 PM.'聽)聽聽INSERT INTO HolyWeekEvents VALUES (聽5,聽'Resurrection',聽'04/03/0033',聽'Sunday',聽'Jesus rises from the dead early morning.'聽)聽/* Query the table to display all events */聽 SELECT EventName, EventDate, EventDay, Description聽FROM HolyWeekEvents聽ORDER BY EventDate聽/* Save the output to a file */聽OUTPUT HolyWeekReport.txt聽LIST ALL聽 OUTPUT SCREEN聽/* Disconnect and clean up */聽DISCONNECT聽SET ECHO OFF[NOTE:聽 I would put this in the R:Base Editor and check it.聽 But it seems quitecomplete for a simple request, and 3 minute wait.聽 Lists need a "+" after each comma."Explanation of the Code1.聽聽 Environment Setup:o聽聽 CLS: Clears the screen for a clean display.o聽聽 SET ECHO ON: Shows commands as they execute (useful for debugging).2.聽聽 Database Management:o聽聽 CREATE DATABASE HolyWeekDB: Creates a new database. If it already exists, you鈥檇 use CONNECT聽directly.o聽聽 CONNECT HolyWeekDB: Opens the database for operations.3.聽聽 Table Creation:o聽聽 CREATE TABLE HolyWeekEvents: Defines a table with columns:搂聽 EventID聽(INTEGER PRIMARY KEY): Unique identifier.搂聽 EventName聽(VARCHAR(50)): Name of the event.搂聽 EventDate聽(DATE): Date in MM/DD/YYYY format.搂聽 EventDay聽(VARCHAR(20)): Day of the week.搂聽 Description聽(VARCHAR(255)): Brief description.4.聽聽 Data Insertion:o聽 聽 INSERT INTO HolyWeekEvents VALUES: Adds rows with Pratt鈥檚 33 AD dates. Note that R:BASE expects dates as strings in MM/DD/YYYY format (e.g., '03/27/0033').5.聽聽 Querying:o聽聽 SELECT ... FROM HolyWeekEvents: Retrieves and sorts events by date. R:BASE鈥檚 SQL-like syntax is straightforward here.6.聽聽 Output:o聽聽 OUTPUT HolyWeekReport.txt: Redirects query results to a text file.o聽聽 LIST ALL: Displays all table contents (an alternative to SELECT *).o聽聽 OUTPUT SCREEN: Returns output to the screen.7.聽聽 Cleanup:o聽聽 DISCONNECT: Closes the database connection.o聽聽 SET ECHO OFF: Stops echoing commands.Running the Code路聽聽 聽聽聽聽聽 Interactive Mode: Type this into the R:BASE 11 command prompt line by line.路聽聽聽聽聽聽聽 Script File: Save it as HolyWeek.rbd聽(or similar), then run it with:RUN HolyWeek.rbdfrom the R:BASE prompt.Notes for R:BASE 11路聽聽聽聽聽聽聽 Version Compatibility: This syntax aligns with R:BASE 11鈥檚 capabilities (released circa 2019), which supports enhanced SQL features and GUI tools, but the example uses classic command-line style for simplicity.路聽聽聽聽聽聽聽 Date Handling: R:BASE stores dates internally but accepts them as MM/DD/YYYY strings in commands.路聽聽聽聽聽聽聽 Error Handling: Add IF ERROR THEN ...聽blocks for robustness in production code (e.g., IF ERROR THEN PRINT 'Table creation failed').If you need a more complex example鈥攍ike joins, stored procedures (DEFINE PROCEDURE), or integration with forms鈥攍et me know what you鈥檙e aiming for! -- 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 from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion visit https://groups.google.com/d/msgid/rbase-l/PH0PR11MB51122C660E0BC53E2A38C129C7AC2%40PH0PR11MB5112.namprd11.prod.outlook.com. -- 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 from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion visit https://groups.google.com/d/msgid/rbase-l/SJ2PR17MB713831CEEAC8DB603B29C057C9AC2%40SJ2PR17MB7138.namprd17.prod.outlook.com. -- 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 from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion visit https://groups.google.com/d/msgid/rbase-l/SA1PR19MB51820FB5232D1143401D4C45A8AC2%40SA1PR19MB5182.namprd19.prod.outlook.com. -- 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 from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion visit https://groups.google.com/d/msgid/rbase-l/000001dba46d%24bc08de90%24341a9bb0%24%40vtgonline.com. -- 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 from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion visit https://groups.google.com/d/msgid/rbase-l/CABnhDASsax7_eGHnDVGjgfJyHxW9rNYuF0C-bvHXhDv8gFtAWQ%40mail.gmail.com. -- 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 from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion visit https://groups.google.com/d/msgid/rbase-l/1644571114.1412507.1743705732289%40mail.yahoo.com.
