update statement

[HenkR]

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?
I don't know much about DBase...

 

[1oldfoxman]

First guess is the field NUMBER is character as opposed to numeric, so the 3 needs to be in parens:

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

It would be helpful to post the verbage of the error. If I'm correct with the above , the error should be "Data Type Mismatch" (or close to that).

hth

 

[HenkR]

I tried it but NUMBER IS numeric

The error is syntax error on update statement

 

[1oldfoxman]

What version of dBase are you running? Not all had SQL capabilities. If it's an earlier version, you'll need to use xBase commands instead, like:

USE AdmNmbr.DBF
REPLACE ALL NUMBER WITH 3 FOR NMBRID = '000205'

 

[dbMark]

In dBase 5 for DOS the UPDATE command is nothing like what you're using. Most likely you're mixing languages. I agree with 1oldfoxman on using REPLACE instead.