DBF Edit if exist.

[Petrus Vorster]

Hi all.

The next step I need to master using a TDBF is the following:
(normal DBF Database)

Check if a record exists, Edit it with some new info if it does, or create a new Record if it doesnt.

For instance, I have a record of Tracking Number, ReceiveDate, Client Details etc.
The tracking info can be scanned in before or added manually later.

So i need to check if that Tracking number is in the database, and If so, add the new client details, and If not then create a new record.

I assume it has to be a combination of most of the commands you showed me, but I would rather  ask before I mess up.

Regards,

Peter

[Zvoni]

Locate-Function of TDataset, since it returns a Boolean Found Yes/no

[Handoko]

When working with TDBF I use this documentation, very useful:
https://sourceforge.net/projects/tdbf/files/TDbf%20documentation/TDbf%20documentation%201.1/

And if I am working with SQL-based databases, I use this:
https://www.w3schools.com/sql/

[Petrus Vorster]

Your documentaries, help files and assistance is great.
This function now works perfectly.

Now, just for rounding off the application, and my first Pascal app will be fully functional.

Thanks a million

-Peter