Watch, Follow, &
Connect with Us

QualityCentral

Public Report
Report From: Delphi-BCB/Database/DBExpress/TSimpleDataset    [ Add a report in this area ]  
Report #:  9753   Status: Closed
In DBExpress delete record errorr dbexpmss.dll ver. 7.1.1523.17956
Project:  Delphi Build #:  8.1
Version:    10.0 Submitted By:   Karol Bieniaszewski
Report Type:  Basic functionality failure Date Reported:  12/4/2004 7:55:14 AM
Severity:    Serious / Highly visible problem Last Updated: 3/20/2012 2:24:39 AM
Platform:    All versions Internal Tracking #:   227748
Resolution: Fixed (Resolution Comments) Resolved in Build: : 10.0.2032.7776
Duplicate of:  None
Voting and Rating
Overall Rating: No Ratings Yet
0.00 out of 5
Total Votes: None
Description
In DBExpress i can not delete record. I use TSimpleDataSet and i connect to MSSQL Server 2000 using dbexpmss.dll ver. 7.1.1523.17956
This situation occure when tables are related to a table. Even if currently no record is related. I use cascade clause in foreign key.
I must use stored procedures to delete record and then all is ok - why
Steps to Reproduce:
1. Create db with 3 tables.
2. Create relation between table1 and table2 (table1 <- table2)
3. Add record to table1
4. add record to table3
4. try delete record from table1 using SimpleDataSet - you get error "Record not found or changed by
another userr"
5. try delete record from table1 using TSQLStoredProc (you must define it) - record was succesfully deleted
6. try delete record form table3 using TSimpleDataSet - you can delete it. What is wrong.


I can delete record only if - to my table other tables are not related,
even if currently no records exists in e.g. table2 related to table 1.
Workarounds
None
Attachment
None
Comments

None

Server Response from: ETNACODE01

Copyright© 1994 - 2013 Embarcadero Technologies, Inc. All rights reserved.