Re: [Firebird-net-provider] Query Result

2008-02-28 Thread Kixzo Database Team
Hello, What is backward fetching? And how to implement this. Are your talking about threading? Ie. Fetching records from the database in background threads? Regards, Rakesh Singh -Original Message- From: Jiri Cincura [mailto:[EMAIL PROTECTED] Sent: Friday, February 29, 2008 2:49 AM To:

Re: [Firebird-net-provider] Why FbDataReader.HasRows returns always true?

2008-02-28 Thread Dean Harding
Oleg Deribas wrote: > Is it possible to mark HasRows with "obsolete" attribute? Then people > will get warnings when compiling code with newer versions of the provider... They won't get a warning if they're using it via the base class or the IDataReader interface (as I usually do). Dean.

Re: [Firebird-net-provider] Why FbDataReader.HasRows returns always true?

2008-02-28 Thread Oleg Deribas
Jiri Cincura wrote: >> reader.HasRows()". About the breaking change, do you really think is >> anybody relying on a method that always return true? And if it was the > > Not always. From some time it returns true only for selects. But it > cannot be changed in a second, no matter how it's now,

Re: [Firebird-net-provider] Why FbDataReader.HasRows returns always true?

2008-02-28 Thread Jiri Cincura
On 2/28/08, Mercea Paul <[EMAIL PROTECTED]> wrote: > I have read Firebird_v2.1.0.ReleaseNotes.pdf and on page 104 is describe a > rudimentary mode to cancel all statements from existing connection! That's I see on http://firebirdsql.org/devel/doc/rlsnotes/html/rlsnotes210.html#rnfb210-mon-cnclqr

Re: [Firebird-net-provider] Why FbDataReader.HasRows returns always true?

2008-02-28 Thread Mercea Paul
Hi Jiri > Cancelation of query in FirebirdClient makes sense only via API. And > for MON$xxx this must be done using another connection. And only on > FB2.1. > > In fact, you can easily extend your class to do this. I don't think, > this is issue of FirebirdClient until it's not in API. I have r

Re: [Firebird-net-provider] Why FbDataReader.HasRows returns always true?

2008-02-28 Thread Jiri Cincura
On 2/28/08, Aitor Gómez González <[EMAIL PROTECTED]> wrote: > I think it's a good idea but don't know if it's feasible (record size, > fetch caching, performance, etc.), reality is "we can live without I have roughly looked into code for some implementation. It shouldn't be huge change. We can tr

Re: [Firebird-net-provider] Why FbDataReader.HasRows returns always true?

2008-02-28 Thread Jiri Cincura
On 2/28/08, Mercea Paul <[EMAIL PROTECTED]> wrote: > For FB2.1 , FbCommand.Cancel can be attached to MON$ tables(to cancel > current command)? Cancelation of query in FirebirdClient makes sense only via API. And for MON$xxx this must be done using another connection. And only on FB2.1. In fact,

Re: [Firebird-net-provider] Query Result

2008-02-28 Thread Jiri Cincura
On 2/28/08, Kixzo Database Team <[EMAIL PROTECTED]> wrote: > What my concern is. I want results in Group of 100 records, like > The result will return first 100 records then next 100 and so on, until the > whole records are fetched. In ASP.NET or WinForms/WPF? Did you tryied background fetching

Re: [Firebird-net-provider] Umlauts in File Path

2008-02-28 Thread Jiri Cincura
On 2/28/08, Philipp Sumi <[EMAIL PROTECTED]> wrote: > It's strange that this hasn't been addressed by the FB team yet - having the It has been discussed many times. -- Jiri {x2} Cincura (CTO x2develop) http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com ---

Re: [Firebird-net-provider] Umlauts in File Path

2008-02-28 Thread pschlier
Hello, we did already report a similar problem: creating a database on a machine with non-english regional settings fails. We could reproduce this behaviour by using Turkish regional settings on a US English OS. The code to reproduce the error and the problem description are both available in

Re: [Firebird-net-provider] Firebird-net-provider Digest, Vol 22, Issue 17

2008-02-28 Thread Kixzo Database Team
Hello, I tried this "Select first n skip m" syntax where n is the number of records to select in one turn, and m + 1 is the record number to start with. But this is will only return 50 records, how to get rest of the data. Please help on this. Regards, Rakesh singh. -Original Message- F

Re: [Firebird-net-provider] Query Result

2008-02-28 Thread Kixzo Database Team
Hello, Thank you for your reply. I am fetching the record directly through a select Query. let me explain my table structure. I have one master table with User Information and "UserID" filed from this table is referenced in at most 25 tables and also the "UserID" Field is Indexed. And I am execu

Re: [Firebird-net-provider] Why FbDataReader.HasRows returns always true?

2008-02-28 Thread Mercea Paul
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf > Of Aitor Gómez González > Sent: Thursday, February 28, 2008 1:51 PM > To: For users and developers of the Firebird .NET providers > Subject: Re: [Firebird-net-provider] Why FbDataReader.HasRows returns

Re: [Firebird-net-provider] Umlauts in File Path

2008-02-28 Thread Philipp Sumi
>> Just wanted to let you know, as I didn't see this posted anywhere: I >> noticed >> that connecting to a database with a path that contains an "Umlaut" >> (ä, ö, >> ü) results in an exception (note the "Aufträge" in the file path): > Use 8.3 path or aliases. National characters are causing p

Re: [Firebird-net-provider] Why FbDataReader.HasRows returns always true?

2008-02-28 Thread Aitor Gómez González
I think it's a good idea but don't know if it's feasible (record size, fetch caching, performance, etc.), reality is "we can live without reader.HasRows()". About the breaking change, do you really think is anybody relying on a method that always return true? And if it was the case, it shoud be bet

Re: [Firebird-net-provider] Umlauts in File Path

2008-02-28 Thread Jiri Cincura
On 2/28/08, Philipp Sumi <[EMAIL PROTECTED]> wrote: > Just wanted to let you know, as I didn't see this posted anywhere: I noticed > that connecting to a database with a path that contains an "Umlaut" (ä, ö, > ü) results in an exception (note the "Aufträge" in the file path): Use 8.3 path or al

[Firebird-net-provider] Umlauts in File Path

2008-02-28 Thread Philipp Sumi
Hi there Just wanted to let you know, as I didn't see this posted anywhere: I noticed that connecting to a database with a path that contains an "Umlaut" (ä, ö, ü) results in an exception (note the "Aufträge" in the file path): Error message: FirebirdSql.Data.FirebirdClient.FbException: I/O erro

Re: [Firebird-net-provider] Query Result

2008-02-28 Thread André Knappstein , Controlling
Hello, if you want to implement some sort of paging, you could try "Select first n skip m" syntax where n is the number of records to select in one turn, and m + 1 is the record number to start with. -- Mit freundlichen Grüssen, André Knappstein, EDV und Controlling Verwaltungs- und Erl

Re: [Firebird-net-provider] Query Result

2008-02-28 Thread Jiri Cincura
On 2/28/08, Kixzo Database Team <[EMAIL PROTECTED]> wrote: > What my problem is I Querying database from some result, the result dataset > is about 5K rows, which I had to display in the Listview control in my C# > application. > > It is taking about 10 to 11 seconds to fetch the record from the da

[Firebird-net-provider] Query Result

2008-02-28 Thread Kixzo Database Team
Hello, I need some help, regarding the Query Result. I am not that much good at database side so I want some help. What my problem is I Querying database from some result, the result dataset is about 5K rows, which I had to display in the Listview control in my C# application. It is taking

Re: [Firebird-net-provider] Why FbDataReader.HasRows returns always true?

2008-02-28 Thread Jiri Cincura
On 2/28/08, Dean Harding <[EMAIL PROTECTED]> wrote: > Instead of just returning true, couldn't you just attempt to fetch the > first row? If there's no row, you can return false. If there's a row, > you'll fetch it (and you'll have to cache it so the first call to > MoveNext() works) and return