Insert Statment not working

I know this is a sin in dbforums to jump forums to ask other forum questions, but I just had to do it....

it's actually related to foxpro dbf tables. Here is the case:

I am opening this existing DBF file in Microsoft Visual Fox Pro 6.0 .

In the command window, select, update and even including delete statements works .

What is getting on my nerves is the "insert" statement. It always prompts "syntax error". But the @.#$@.#$ error message just didn't help much.

The funny thing is, if I use the "Append Mode" and add data directly via the GUI, it works!.

Here is the insert statement, just a very simple one:

<code> INSERT INTO ASSET (ACCNO) values '2000/141'</code>

You can reply me here , or go to the real thread to reply me if you can help out..thanks

http://www.dbforums.com/t1058508.htmlINSERT INTO ASSET (ACCNO) values ('2000/141') ?|||Thanks! that work!!!......