Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2004
    Posts
    14

    Unanswered: solved:delete the record i want by using seek

    hi

    i am using vb6 and access. i have a form in which there is a adodc, a datalist OR a datagrid to view the contents of a table in an access file. i want to delete a particular record by selecting the row (in a datagrid) OR selecting the record in a datalist. how do i achieve this? pl help

    onil
    Last edited by ONIL; 05-26-04 at 11:42. Reason: solved

  2. #2
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    Have the on_click action call a stored procedure to delete the record. Just pass the record id to the stored procedure and let it do the delete. You'll then want to refresh the dataset and control.
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

  3. #3
    Join Date
    Feb 2004
    Posts
    14

    on_click action call

    hi

    i tried but it always deletes (in both cases -datagrid and datalist) the first record BUT NOT the record i click on

    onil

  4. #4
    Join Date
    Nov 2002
    Posts
    272
    ONIL,
    you may want to post your question in the Delphi, Visual Basic, C etc forum. It looks like your problem is VB related, not SQL. What you want to know is how to find out which line of the datagrid was clicked.

  5. #5
    Join Date
    Feb 2004
    Posts
    14

    issue resolved

    hi

    thanks for the interest. i have solved the issue using the seek command

    onil

Posting Permissions

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