Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    3

    Unanswered: Visual Fox Pro and mySQL

    Is it possible to delete in a mySQL table using Visual Fox Pro 7.0?
    i tryed:
    lha=SQLCONNECT('buhaha','user','pass')
    SQLEXEC(lha,"SELECT * FROM buhuhu","cbu")
    SQLEXEC(lha,"DELETE INTO cbu")

    No error, but it doesnt delete anything!

  2. #2
    Join Date
    Sep 2003
    Location
    New Zealand
    Posts
    6
    I haven't done this before but the syntax in vfp to delete would be

    "delete from mytable where name = 'smith'"

    http://www.universalthread.com/ is a dedicated vfp forum with free and "premium" options.

Posting Permissions

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