The "spinner" in GdsConnection::NextOperation() doesn't seem to be any
good idea, it causes the application to lock up in random situations.
The root cause is "return this.innerStream.Read(buffer, offset, count)"
in XdrStream::Read, which block if no data is available.
A hotfix is to add the foll
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Carlos
Sent: Friday, December 14, 2007 9:00 AM
To: For users and developers of the Firebird .NET providers
Subject: Re: [Firebird-net-provider] Faulty GdsConnection::NextOperation
Hello:
The "spinner" in GdsConnection::Next
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Carlos
Sent: Friday, December 14, 2007 12:24 PM
To: For users and developers of the Firebird .NET providers
Subject: Re: [Firebird-net-provider] Faulty GdsConnection::NextOperation
Hello:
Nah, not a complete one. The fault
> my question is: whether i can count on that select procedure will
> return
> order of rows in order, that they were created (if there is none
> index)?
>
No you can't. SQL doesn't give any such "promises".
Create an index on the column and use order by and where,
skip/first/last depending on y