Hi,

I get a syntax error when executing this statement:

UPDATE AdmNmbr.DBF
SET NUMBER = 3
WHERE NMBRID = '000205'


this works fine:
SELECT NUMBER FROM AdmNmbr.DBF
WHERE NMBRID = '000205'

what is wrong with the update statement?