So, earlier this week I got a request to produce a report(or more specifically
an Excel file) - for someone here at work to review a whole bunch of Work
Orders/Jobs - based upon the criteria of parts being manufactured had a
particular process completed and the processing occurred on or after a day in
August of last year.
Suffice it to say - the database systems are VERY Complicated here - and there
are actually 2 huge systems - that also have a lot of interactions between
them. And, all the data relations are ALSO Very complicated.
The deal is, each part being manufactured has a Routing process, where the part
is routed to different areas in the manufacturing facility here, to have
different processes completed to create the final part. And, there is a Routing
report that is printed. So, I was pointed to a VFP program that was used to
print the Routing report, a program that was updated to allow the program code
to run independently, outside of the whole system/project.
So, the idea was to review the program - and create a new program to gather up
the data being requested. But, again - even that program is a bit rough to go
thru, and may not have all the pieces. I was struggling a bit to try and get
this done, and yet I knew it had to be done quickly.
Well, yesterday morning on the way to work I came up with the game plan. The
obvious answer was to have Claude create the program. So, I gave it the
reporting program, as well as the criteria - and after resolving some of the
hallucinations - I WAS Able to get a viable program running and produce the
needed Excel files!!! Which I was really thrilled about.
Now, just to give folks an idea of some of the hallucinations from Claude, I
will include some of them here.
My Fav one is that Claude created a Cursor, then later in the code it did a
Seek on the Cursor - but, the cursor had NO Index! Then, another one was in the
Summary message it was printing to the screen. At one point it had this:
? "="*60
Which is simply not valid. And, yet, a couple lines down it did it correctly
with this line:
? REPLICATE("-", 80)
I find it Ironic that it would do an incorrect AND a correct version of similar
code in the same program. Just kind of weird. Also, there was code involved in
regards to building this kind of Job#. In the reporting program there were
actually TWO Chunks of code related to building the Job# - but, in the program
produced by Claude - he failed to implement the one chunk. I told Claude about
this, and said it was related to a specific variable being used - then he
correctly rectified the problem.
So, all in all - it was a Fantastic Success. And, the idea of giving a
Difficult problem to Claude and let him take a Whack at it - turned out to be a
good decision.
Anyway...
For those that are interested, and have not tried Claude AI yet - you can use
this link:
https://claude.ai/referral/_eI4SiLd2A
Have a GREAT Holiday Weekend folks (at least those of you in the ol' US of A!)
-Kurt
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message:
https://leafe.com/archives/byMID/by5pr13mb3843d41d393c4b1c519f4ac9c3...@by5pr13mb3843.namprd13.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
