I'm
not sure - but the locking mechanism of SQL-Server ( as opposed to
Oracle ) is such that a Query against all data in a table will lock
all updates to the table when run & vice versa.
so
if other users are busy updating when the report starts somebody will have
to wait .... This will *maybe* change in SQL-Server 2003???
-----Original Message-----
From: Cenk Ince [mailto:[EMAIL PROTECTED]
Sent: 12. februar 2004 16:13
To: [EMAIL PROTECTED]
Subject: [development-axapta] Sql Server locks AxaptaHi all.
When i run a custom report for all data in the database, it lockes the application, but when i run it for less data (describing range, for a spesific customer..) it works well. When i debug it it stops in fetch mothod at the line:
localQuery = new QueryRun(this);
if(LOCALQuery.next()) // stops here.
About 10 minutes later lock is broken and report works.
How can i solve this problem.
Thanks in advance.
Yahoo! Groups Sponsor
ADVERTISEMENT
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
