Page 1 of 1

UPDATE statement on table results in error message

PostPosted: Wed Apr 05, 2017 10:33 am
by pal
Hello,

I'm running DBF Commander Pro (Version 4.1, Build 80) and I'm trying to update rows in a DBF table.
However I always get an error message -> Function is not implemented when I try to execute for example the following statements:

Code: Select all
UPDATE "H:\test\inmast.dbf"
SET inmast.fonhand=999.0
WHERE inmast.fonhand=0.0

UPDATE "H:\test\inmast.dbf"
SET fdescript = 'Test'
WHERE fpartno = 'CP2020'


I'm running out of ideas, do you have any?

Thank you in advance.

Re: UPDATE statement on table results in error message

PostPosted: Wed Apr 05, 2017 11:06 am
by Admin
Hi,
I've just tried similar query on a DBF file, and it works fine. Please ensure that:

1. File 'H:\test\inmast.dbf' exists.
2. The file contains all the fields participated in your SQL.

If you'll still be unable to discover the reason, please attach a sample DBF file.

Re: UPDATE statement on table results in error message

PostPosted: Wed Apr 05, 2017 2:55 pm
by pal
Hi, thanks for your quick response.

Yes I'm sure I've got those 2 things right, because I can provoke the corresponding error messages when I change the path or field names:
-> SQL: Column 'FONHAND1234' is not found and -> File 'inmast9876.dbf' does not exist

I have attached a test database excerpt.

Re: UPDATE statement on table results in error message

PostPosted: Wed Apr 05, 2017 3:03 pm
by Admin
This DBF table belongs to a DBC database. So that, the UPDATE cannot be executed. Please copy the 'inmast.dbf' along with its Memo-file 'inmast.fpt' to another directory and try again.

Re: UPDATE statement on table results in error message

PostPosted: Fri Apr 07, 2017 4:01 pm
by pal
You're right, it works when I "cut" the link between DBF table and DBC database.

As I'm not too familiar with DBC databases and DBF tables, I might have to look for another way of updating tables (but select works fine and that's my main concern) as I don't dare to cut the link between DBF/DBC.

Thank you for your support!