From: Kixzo D. T. <ki...@4c...> - 2008-02-28 14:21:13
|
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----- From: fir...@li... [mailto:fir...@li...] On Behalf Of fir...@li... Sent: Thursday, February 28, 2008 6:34 PM To: fir...@li... Subject: Firebird-net-provider Digest, Vol 22, Issue 17 Send Firebird-net-provider mailing list submissions to fir...@li... To subscribe or unsubscribe via the World Wide Web, visit https://lists.sourceforge.net/lists/listinfo/firebird-net-provider or, via email, send a message with subject or body 'help' to fir...@li... You can reach the person managing the list at fir...@li... When replying, please edit your Subject line so it is more specific than "Re: Contents of Firebird-net-provider digest..." Today's Topics: 1. Query Result (Kixzo Database Team) 2. Re: Query Result (Jiri Cincura) 3. Re: Query Result (Andr?) 4. Umlauts in File Path (Philipp Sumi) 5. Re: Umlauts in File Path (Jiri Cincura) 6. Re: Why FbDataReader.HasRows returns always true? ( Aitor G?mez Gonz?lez ) 7. Re: Umlauts in File Path (Philipp Sumi) 8. Re: Why FbDataReader.HasRows returns always true? (Mercea Paul) ---------------------------------------------------------------------- Message: 1 Date: Thu, 28 Feb 2008 14:12:43 +0530 From: "Kixzo Database Team" <ki...@4c...> Subject: [Firebird-net-provider] Query Result To: <fir...@li...> Message-ID: <47c...@mx...> Content-Type: text/plain; charset="us-ascii" 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 about 10 to 11 seconds to fetch the record from the database and same to populate the ListView control. Populating the list view control Is not a problem. That can be managed. What I want to ask is that, is there any way to get the results in counters so that I can get results in group of 100 records, so that I can display the data in Group of 100. So that the user does not have to wait for all the records to get populated. Please help me this. Regards, Rakesh Singh. -------------- next part -------------- An HTML attachment was scrubbed... ------------------------------ Message: 2 Date: Thu, 28 Feb 2008 09:55:30 +0100 From: "Jiri Cincura" <di...@ci...> Subject: Re: [Firebird-net-provider] Query Result To: ki...@4c..., "For users and developers of the Firebird .NET providers" <fir...@li...> Message-ID: <d2f...@ma...> Content-Type: text/plain; charset=ISO-8859-1 On 2/28/08, Kixzo Database Team <ki...@4c...> 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 database > and same to populate the ListView control. Populating the list view control > Is not a problem. That can be managed. 10 seconds is a really long time. If I will not count execution time and suppose you're not oon slow line, then fetching these records and showing in ListView shouldn't take more than, say, 5 seconds max. What's the way how you fetching records and adding to LV? > What I want to ask is that, is there any way to get the results in counters > so that I can get results in group of 100 records, so that I can display the > data in Group of 100. What do you mean with "results in counters"? -- Jiri {x2} Cincura (CTO x2develop) http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com ------------------------------ Message: 3 Date: Thu, 28 Feb 2008 10:26:03 +0100 From: Andr? Knappstein, Controlling <Kna...@be...> Subject: Re: [Firebird-net-provider] Query Result To: fir...@li... Message-ID: <111...@be...> Content-Type: text/plain; charset=ISO-8859-15 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 Erlebniszentrum Marina R?nthe beta Eigenheim GmbH Hafenweg 4 59192 Bergkamen-R?nthe Durchwahl: +49 2389 9240 140 ~~~Ihre Nachricht~~~ KDT> Hello, KDT> I need some help, regarding the Query Result. I am not that much good at KDT> database side so I want some help. KDT> What my problem is I Querying database from some result, the result dataset KDT> is about 5K rows, which I had to display in the Listview control in my C# KDT> application. KDT> It is taking about 10 to 11 seconds to fetch the record from the database KDT> and same to populate the ListView control. Populating the list view control KDT> Is not a problem. That can be managed. KDT> What I want to ask is that, is there any way to get the results in counters KDT> so that I can get results in group of 100 records, so that I can display the KDT> data in Group of 100. KDT> So that the user does not have to wait for all the records to get populated. KDT> Please help me this. KDT> Regards, KDT> Rakesh Singh. ------------------------------ Message: 4 Date: Thu, 28 Feb 2008 10:28:45 +0100 From: "Philipp Sumi" <su...@fr...> Subject: [Firebird-net-provider] Umlauts in File Path To: <Fir...@li...> Message-ID: <001801c879ec$52fa7e90$f8ef7bb0$@ch> Content-Type: text/plain; charset="iso-8859-1" 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 error for file CreateFile (open) "M:\Eigene Dateien\Auftr?ge\test.fdb" Error while trying to open file ---> FirebirdSql.Data.Common.IscException: Eine Ausnahme vom Typ FirebirdSql.Data.Common.IscException wurde ausgel?st. bei FirebirdSql.Data.Client.Gds.GdsConnection.ReadStatusVector() bei FirebirdSql.Data.Client.Gds.GdsConnection.ReadResponse() bei FirebirdSql.Data.Client.Gds.GdsDatabase.ReadResponse() bei FirebirdSql.Data.Client.Gds.GdsDatabase.Attach(DatabaseParameterBuffer dpb, String dataSource, Int32 port, String database) bei FirebirdSql.Data.FirebirdClient.FbConnectionInternal.Connect() --- Ende der internen Ausnahmestapel?berwachung --- bei CT.ManagementStudio.Util.ProjectUtil.CreateEntityProvider(String fileName) bei CT.ManagementStudio.ViewModel.ProjectController.OpenProject(String fileName) bei CT.ManagementStudio.UI.Common.OpenProjectDialog.LoadFile(String fileName) Cheers, Philipp ------------------------------ Message: 5 Date: Thu, 28 Feb 2008 10:39:00 +0100 From: "Jiri Cincura" <di...@ci...> Subject: Re: [Firebird-net-provider] Umlauts in File Path To: "For users and developers of the Firebird .NET providers" <fir...@li...> Message-ID: <d2f...@ma...> Content-Type: text/plain; charset=ISO-8859-1 On 2/28/08, Philipp Sumi <su...@fr...> 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 aliases. National characters are causing problems for FB API. -- Jiri {x2} Cincura (CTO x2develop) http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com ------------------------------ Message: 6 Date: Thu, 28 Feb 2008 12:51:14 +0100 From: " Aitor G?mez Gonz?lez " <ait...@gm...> Subject: Re: [Firebird-net-provider] Why FbDataReader.HasRows returns always true? To: "For users and developers of the Firebird .NET providers" <fir...@li...> Message-ID: <32c...@ma...> Content-Type: text/plain; charset=ISO-8859-1 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 better (my opinion) declaring the method as not supported and forcing people to clean (fix) their current code. By the way, FbCommand.Cancel is a similar case, a NotSupportedException is thrown instead of leaving the method empty. 2008/2/28, Jiri Cincura <di...@ci...>: > On 2/28/08, Dean Harding <dea...@dl...> 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 true. > > > Yes. This is one of possibilities. It's better than exception. Please > add this to tracker, I'll look at it and add it if possible. > > I hope during weekend releasing next Alpha version of provider and other stuff. ------------------------------ Message: 7 Date: Thu, 28 Feb 2008 12:55:17 +0100 From: "Philipp Sumi" <su...@fr...> Subject: Re: [Firebird-net-provider] Umlauts in File Path To: "'For users and developers of the Firebird .NET providers'" <fir...@li...> Message-ID: <002201c87a00$cb462660$61d27320$@ch> Content-Type: text/plain; charset="iso-8859-1" >> 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 problems for > FB API. It's strange that this hasn't been addressed by the FB team yet - having the freedom to choose my file paths to my liking is something I really take for granted nowadays. And unfortunately, it appears that my customers do as well (they have the possibility to create databases on the fly). Having to tell them that they have to comply to MS-DOS compatible file paths doesn't look too next-gen ;) Cheers, Philipp ------------------------------ Message: 8 Date: Thu, 28 Feb 2008 15:03:34 +0200 From: "Mercea Paul" <pau...@al...> Subject: Re: [Firebird-net-provider] Why FbDataReader.HasRows returns always true? To: "'For users and developers of the Firebird .NET providers'" <fir...@li...> Message-ID: <!&!AAAAAAAAAAAYAAAAAAAAACOM/cOGjJ1HlJWkT080kT/CgAAAEAAAALySiIHqiZZJrGwY9iOF WRABAAAAAA==@almexa.ro> Content-Type: text/plain; charset="iso-8859-1" > -----Original Message----- > From: fir...@li... > [mailto:fir...@li...] 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 > always true? > > 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 better (my opinion) declaring the method as not > supported and forcing people to clean (fix) their current code. By > the way, FbCommand.Cancel is a similar case, a NotSupportedException > is thrown instead of leaving the method empty. For FB2.1 , FbCommand.Cancel can be attached to MON$ tables(to cancel current command)? Regards, Paul ------------------------------ ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ ------------------------------ _______________________________________________ Firebird-net-provider mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-net-provider End of Firebird-net-provider Digest, Vol 22, Issue 17 ***************************************************** |