Thread: SQLite3 Help

    #1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2013
    Posts
    2
    Rep Power
    0

    SQLite3 Help


    Hi,
    I'm familiar with the SQLite2.
    I have a code that can List, Edit, Delete, Add, etc.
    Recently I started to switch to SQLite3.
    I do have a code that can list, but I need help to delete
    selected line.
    Can you please show me the code lines for this execution.
    Thank you in advance
    elistein
  2. #2
  3. No Profile Picture
    Grumpier old Moderator
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2003
    Posts
    14,445
    Rep Power
    4539
    Is your question somehow related to visual basic?
    ======
    Doug G
    ======
    Bartender to Rene Descartes "have another beer?" Descartes: "I think not" and he vanished.
    --Alfred Bester
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2013
    Posts
    2
    Rep Power
    0
    Hi Doug G

    Sorry didn't point it out specifically, hoped its obvious.

    Anyway, I succeeded to delete one entry by the following command:

    Set Rs = Cnn.OpenRecordset("DELETE FROM customers WHERE FirstName='John' ")

    I want to exchange the exact name 'John' with a selected variant i.e 'SelDelete' that I choose from a list.
    How to implement it in the above line command
    Thanks
  6. #4
  7. No Profile Picture
    Grumpier old Moderator
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2003
    Posts
    14,445
    Rep Power
    4539
    Try
    Code:
    Set Rs = Cnn.OpenRecordset("DELETE FROM customers WHERE FirstName='" & SelDelete & "' ")
    ======
    Doug G
    ======
    Bartender to Rene Descartes "have another beer?" Descartes: "I think not" and he vanished.
    --Alfred Bester

IMN logo majestic logo threadwatch logo seochat tools logo