Can't delete Records in MSSQL 2005

Lolo · Post by **Lolo** » Tue 01 Jul 2008 16:45

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?

Antaeus · Post by **Antaeus** » Wed 02 Jul 2008 10:56

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.

Lolo · Post by **Lolo** » Mon 07 Jul 2008 12:58

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

Antaeus · Post by **Antaeus** » Tue 08 Jul 2008 08:58

Thank you for information. We have fixed this problem. This fix will be included in the next build of UniDAC.

Lolo · Post by **Lolo** » Tue 08 Jul 2008 14:58

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