U++ framework: U++ SQL » MSSQL strange problem and ugly workaround patch...

Home » U++ Library support » U++ SQL » MSSQL strange problem and ugly workaround patch...

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: MSSQL strange problem and ugly workaround patch... [message #19306 is a reply to message #19294]

Tue, 25 November 2008 11:25

mirek
Messages: 14291
Registered: November 2005

Ultimate Member

unodgs wrote on Mon, 24 November 2008 13:08

Or try: select SCOPE_IDENTITY.

Tried. The same problem as with @@IDENTITY.

BTW, this is really so weird that I would like somebody else to check and try.

AFAIK, the critical moment is when 'outer' select loop has more rows than can be prefetched in single step. In that case, @@IDENTITY (and SCOPE_IDENTITY) does not work until the last prefetch is performed.

That OTOH means that unless you do inserts in large fetch loop, the bug is hidden.

Of course, still possible something is wrong in OleDB.

Mirek

Report message to a moderator

[Message index]

		MSSQL strange problem and ugly workaround patch... By: mirek on Mon, 24 November 2008 18:47
		Re: MSSQL strange problem and ugly workaround patch... By: unodgs on Mon, 24 November 2008 19:08
		Re: MSSQL strange problem and ugly workaround patch... By: mirek on Tue, 25 November 2008 11:25
		Re: MSSQL strange problem and ugly workaround patch... By: unodgs on Tue, 25 November 2008 16:04
		Re: MSSQL strange problem and ugly workaround patch... By: mirek on Fri, 27 February 2009 13:26

Previous Topic:	PostgreSQL string insert fix [with patch]
Next Topic:	SqlArray/SqlCtrl/Select problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sun Jun 21 00:22:04 GMT+2 2026

Total time taken to generate the page: 0.02124 seconds