Low-Level Functions for DBF - QA Interface

[Otto]

Hello friends,

Working on my own interface for DBF with the help of ChatGPT has been really fun.
The interface is being developed specifically for access from a web server, so many features
that are standard on the desktop are not necessary here.

The main functions are already working very well. I am now considering whether to use terminology
that aligns more with SQL or dBase.

SQL terminology seems more modern and likely more familiar to users, so I will likely choose that path.

[Silvio.Falconi]

don't trust ChatGPT /gemini .... I've tried many artificial intelligences but none of them know the fwh / harbour language thoroughly, they often change commands and functions, I've wasted a lot of time with these artificial intelligences, I still haven't found any that work well

[nageswaragunupudi]

ROLLBACK:

Code: Select all  Expand view

  USE CUSTOMER NEW VIA "DBFCDX"
   GOTO 5
   USE STATES   NEW VIA "DBFCDX"
   GOTO 10
   ? CUSTOMER->CITY, STATES->NAME // -> "Tarzana,Minnisota"
   //
   REPLACE CUSTOMER->CITY WITH UPPER(CUSTOMER->CITY)
   REPLACE STATES->NAME WITH UPPER(STATES->NAME)
   ? CUSTOMER->CITY, STATES->NAME // -> "TARZANA,MINNISOTA"
   //
   DBROLLBACKALL()
   ? CUSTOMER->CITY, STATES->NAME // -> "Tarzana,Minnisota"

   CLOSE DATA
 

HI knows what AI does not know.

[Otto]

Dear Mr. Rao,
I think you learn a lot when you deal directly with the basics.

DBROLLBACKALL() is simply an analogy created by ChatGPT. This command does not actually exist.
You need to ask further questions.
For example. "A suggestion?"
Instead of backing up each record individually, you can employ a temporary backup database or use a shadow file mechanism.

An interesting solution seems to be a batch file for backup and restore.
I once tried it with three large files that are included in a transaction in my program.
It is surprisingly fast—30 to 70 ms for the backup!

In any case, I’m sticking with it.

Best regards,
Otto

[nageswaragunupudi]

DBROLLBACKALL() is simply an analogy created by ChatGPT.

This has nothing to do with ChatGPT. I see from your above table, that ChatGPT said there is no equivalent to ROLLBACK in DBF

This is an FWH function.
DBROLLBACK() and DBROLLBACKALL()

[karinha]

https://forums.fivetechsupport.com/~fivetec1/forums/viewtopic.php?f=3&t=42174&start=0

Regards, saludos.

[Otto]

Dear Mr. Rao,

I am sorry. I misunderstood your response.
I will take a look at and study these two functions right away.
Thank you very much.

I am facing so much opposition here that I am already becoming paranoid.

Best regards from Sillian.
Best regards,
Otto

[richard-service]

Dear Mr. Rao,

I am sorry. I misunderstood your response.
I will take a look at and study these two functions right away.
Thank you very much.

I am facing so much opposition here that I am already becoming paranoid.

Best regards from Sillian.
Best regards,
Otto

Dear Otto,

Take a easy.

[Otto]

Dear Richard,

Thank you.
But now is not the time.
Everything is changing, and if you want to stay in business—I mean, if you plan for your software to continue being used by users—it requires great effort.

New web applications appear daily, trying to take market share.
Without a proper web application, I think it will be hopeless to survive.

That's why I'm stressed. It's a lot of work to transform an application that has been developed over 30 years.
Help would certainly be advantageous here.

But now I see that in our group, many different priorities are being set.
Yet, there is practically little interest in the web.

Still, I have to figure out how best—and most economically—to transform the application.
But I've already come a long way with it. Really far.

Best regards,
Otto