Results 1 to 5 of 5

Thread: Delete Error

  1. Feb 27th, 2000, 04:50 PM #1
    FirstKnight
    FirstKnight is offline

    Thread Starter
    Lively Member FirstKnight's Avatar
    Join Date
    Jul 1999
    Location
    Johannesburg, South Africa
    Posts
    95

    Post

    Just when I thought I knew everything there was to know about Database Programming, I came across this problem. On a form I have a DataGrid and Several Text boxes. The Datagrid and the textboxes are all linked to the same Data Control. The text boxes are used for Data Input and the Grid is used to display the records in the table to wich the Text boxes are linked. Now, it works fine when I add a new record, but when I try to delete a record it generate's an error stating 'A given HROW referred to a hard- or soft-deleted row.'

    Can someone please tell me why it does this and how I can get around it.

    Thanks.
    Today is yesterday's tomorrow
    Reply With Quote Reply With Quote
  2. Jun 7th, 2001, 08:41 PM #2
    allergy
    allergy is offline
    New Member
    Join Date
    Apr 2001
    Location
    Melbourne , Australia
    Posts
    10

    Same problem

    G'day,
    I'm having the same problem. Any guru advise would be much appreciated. I've narrowed it down to a particular text box that is connected to my datbase but is updated by the computer, ie, selections by the user from other combo boxes updates this particular text box. If I disconnect the text box from the database the error goes away. Very annoying.
    Reply With Quote Reply With Quote
  3. Jun 7th, 2001, 10:01 PM #3
    Negative0
    Negative0 is offline
    PowerPoster 2.0 Negative0's Avatar
    Join Date
    Jun 2000
    Location
    Southeastern MI
    Posts
    4,367
    I have an idea, why not avoid using data controls. They are bulky and slow. Use pure SQL, it is fast and efficient, plus you have all of the control of the data and are not limited by the data controls.
    Negative 0

    Blog | RegEx | Encrypting UN/PW in Web.Config | Enabling ASP.Net on IIS 6 | Port Numbers | Creating GUIDs | Start->Run | Modifying the default class



    Reply With Quote Reply With Quote
  4. Jun 7th, 2001, 10:25 PM #4
    allergy
    allergy is offline
    New Member
    Join Date
    Apr 2001
    Location
    Melbourne , Australia
    Posts
    10

    hmmmm

    I've been writing this program for over a year now. And I'm not full bottle on SQL. Wouldnt it take forever to change it all over from data controls to SQL? Whats involved in changing it over. Can you help?
    Reply With Quote Reply With Quote
  6. Jun 7th, 2001, 10:26 PM #5
    allergy
    allergy is offline
    New Member
    Join Date
    Apr 2001
    Location
    Melbourne , Australia
    Posts
    10
    Although I must agree straight off that's it's probably a good idea. I've noticed that my program has become very slow to load, which is actually a nightmare when your trying to debug and code
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width