Unanswered: Syntax error trying to UPDATE dbf file
I have the following code which is supposed to connect to a .dbf file and then update (i'm using test values) - first I got the error that the Jet engine couldn't find the table "WV_region.dbf", so after searching, thought it might be something to do with the long filename. So i've now included code to get the DOS 8.3 file name, but I'm gettin the error "Syntax error in UPDATE statement."
I'm about to throw the PC out of the window, so if anyone could help before I do that, I would be most grateful
So i've now included code
Again - no code is shown
Without seeing the code, I have to ask - what are you using to try to execute the code?
* Foxpro/Visual Foxpro?
long filenames or at least Long Path names are indeed a problem if you are using an OLD version of Foxpro, but that can be resolved with
* Or something else?
Give us more information and we will be better able to assist you.
The error message: "Syntax error in UPDATE statement." is not an indication of a problem with the data table - thereby negating the need for "update indexes" or for using a tool like: Recovery Toolbox for DBF for 'fixing' of the data table.
Instead that error message, as indicated, suggests a problem with the code you have written in your UPDATE code.
Note that the SQL UPDATE code must use the syntax of the 'backend' data table, not necessarily the same syntax for the language of the program. They MIGHT be the same, but they might be different.
If you would post the SQL UPDATE code, then we could look it over to see what might be wrong.