Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2003
    Location
    Penang, Malaysia
    Posts
    212

    Unanswered: 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.html
    Patrick Chua
    LBMS ( Learn By My Self) NPQ ( No paper Qualification )

  2. #2
    Join Date
    Feb 2004
    Posts
    492
    INSERT INTO ASSET (ACCNO) values ('2000/141') ?

  3. #3
    Join Date
    Jul 2003
    Location
    Penang, Malaysia
    Posts
    212
    Thanks! that work!!!........
    Patrick Chua
    LBMS ( Learn By My Self) NPQ ( No paper Qualification )

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •