I Don't Even Code at All Anymore.

[Thales750]

I'm using GPT 40
We are building a system for moving robots around a factory floor. The human interface is made in Access.
And, the GPT is writing the Code.

 

[The_Doc_Man]

Not to disparage ANYONE on this, but just be careful. ANYTHING based on the LLM is giving statistically-chosen answers. Chatty has written code before and that code turned out to not be viable due to conflation of VBA and other VB family tools including VB Scripting. I wish you luck in that project but just would advise care. What's that old military rule? Trust - but verify first.

 

[Thales750]

Not to disparage ANYONE on this, but just be careful. ANYTHING based on the LLM is giving statistically-chosen answers. Chatty has written code before and that code turned out to not be viable due to conflation of VBA and other VB family tools including VB Scripting. I wish you luck in that project but just would advise care. What's that old military rule? Trust - but verify first.

Things have changed in the last year. I'm pretty good at debugging. We (GPT and I) set up development incrementally so test is in quarantine. So far it has been more expensive then me coding but we are passing that threshold.

 

[AccessBlaster]

If you think about it, all code is ultimately human code. Whether it's AI generating content from data it was trained on or a person posting on this forum, the origin is still human. That means you still need to verify the information regardless of the source.

 

[GPGeorge]

If you think about it, all code is ultimately human code. Whether it's AI generating content from data it was trained on or a person posting on this forum, the origin is still human. That means you still need to verify the information regardless of the source.

I have come to consider this an iterative process, not a one-off question and answer process.

Over the past month and a half I've been working on a project to create a PowerApps version of the Northwind Developer Edition template. For reasons, I'm writing most of the CRUD data operations and data validation in SQL Server Stored Procedures. I rely on Claude AI to review, validate and offer alternatives for those stored procs. It's valuable in a couple of ways. First, my errors in syntax and logic are identified for me. Second, I often get information back explaining my errors. Third, when I get to a working result, I can expect a summary evaluation of the process. Granted, there's still the final step of "try it and see what happens" that I have to do for myself.

Ultimately, though, once I've gone through that process as little as two or three times, and sometimes a half dozen times, I have a result that I can then test and validate against my test data in the development version of the application. If it works, I can demonstrate it. And that's what matters.

Yes, it's a process of verification. In both directions as it turns out.

 

[GPGeorge]

I'm using GPT 40
We are building a system for moving robots around a factory floor. The human interface is made in Access.
And, the GPT is writing the Code.

What I'm trying to do with the PowerApps version of Northwind Developer Edition is create the business logic in the back end (SQL Server) so that both an Access interface and a PowerApps interface, and theoretically any other interface, can connect to the database via Stored Procedures and exploit that common data logic with a minimum of coding in the interface, mostly for interface management related tasks. I hope to have a working demo in the next couple of months. I also switched from ChatGPT to Claude AI because I found the LLM's "personality" for lack of a better term more compatible with my working style.

 

[AccessBlaster]

While working for the school district, I wanted to develop a hybrid inventory system an app for tracking and auditing assets. It needed to be mobile and accessible within a 20-mile radius. However, I lacked the necessary knowledge and expertise and, quite frankly, the time required to learn it.

Now that I’m retired, I posed the question not to a forum, but to the free version of ChatGPT. Within a day or so, I had a working model. One of the suggestions was to use Flask with SQL. It was rough, as expected, but fundamentally, it worked.

 

[Thales750]

What I'm trying to do with the PowerApps version of Northwind Developer Edition is create the business logic in the back end (SQL Server) so that both an Access interface and a PowerApps interface, and theoretically any other interface, can connect to the database via Stored Procedures and exploit that common data logic with a minimum of coding in the interface, mostly for interface management related tasks. I hope to have a working demo in the next couple of months. I also switched from ChatGPT to Claude AI because I found the LLM's "personality" for lack of a better term more compatible with my working style.

Sounds interesting. One of the beauties of SQL, universal containers. I've had to train the GPT to have the right personality. It has annoying quirks, but also some fun aspects.