Page 1 of 1
Can't delete Records in MSSQL 2005
Posted: Tue 01 Jul 2008 16:45
by Lolo
Has someone the same problem?
I delete several records in a MSSQL table, and as long as I keep the application open, the records are really gone. But when I close the application and resart it again, ALL deleted records are here again.
What do I do wrong?
Posted: Wed 02 Jul 2008 10:56
by Antaeus
Please answer some questions about the problem:
Are you using transactions, locking, or CachedUpdates mode in your application?
Does the problem appear for update/insert operations, or only for delete?
Is the problem reproduced with some of UniDAC demos?
Also supply the following information:
- the exact version of UniDAC. You can see it in the About sheet of TUniConnection Editor;
- the exact version of your IDE;
- the exact version of SQL server and client. You can see it in the Info sheet of TUniConnection Editor.
Posted: Mon 07 Jul 2008 12:58
by Lolo
Sorry, I didn't think so far.
The Versions are:
UniDAC: 1.00.0.6
Turbo Delphi 2006: V10.0.2288.42451 Update 2
SQL-Server:Server version: Microsoft SQL Server 09.00.3042
Client version: 08.00.1132
I am using all UniDAC components with standard settings, so as far as I know without transactions. But the error seems to be a canceled transaction.
It happens only at deletion, not on updates.
On the SQL-server I'm using user sa which has ALL rights.
If you need the project or the test database please let me know.
regards
Lolo
Posted: Tue 08 Jul 2008 08:58
by Antaeus
Thank you for information. We have fixed this problem. This fix will be included in the next build of UniDAC.
Posted: Tue 08 Jul 2008 14:58
by Lolo
Thank you.
It's nice that I was helpful to you. There is only one problem: I need a solution to this problem VERY quick, so is it possible to get an early beta of the new release?
It would help me solve a problem.
Thank you!
Regards
Lolo