Re: [fpc-pascal] TSQLQuery and buffering.

2017-03-25 Thread Martin Schreiber
On Saturday 25 March 2017 10:28:37 Michael Van Canneyt wrote: > On Sat, 25 Mar 2017, Martin Schreiber wrote: > > On Saturday 25 March 2017 09:32:33 Gary Doades wrote: > >> I Understand about the "normal" use of TSQLQuery and data sets and I > >> also use this for small result set that need the data

Re: [fpc-pascal] TSQLQuery and buffering.

2017-03-25 Thread Gary Doades
>> I had read about UniDirectional and I have indeed tried this. It doesn't >> seem to make any significant difference. Looking through the source code for >> TBufDataset it looks like UniDirectional just turns off building various >> indexes/structures etc. and fetches the result set all in one

Re: [fpc-pascal] TSQLQuery and buffering.

2017-03-25 Thread Gary Doades
> > MSEgui has TSQLResult for that purpose without the TDataset overhead. > https://gitlab.com/mseide-msegui/mseide-msegui/blob/master/lib/common/db/msesqlresult.pas Thanks. Although it looks interesting I'd rather not get into another set of classes etc. at this point. I may come back to it la

Re: [fpc-pascal] Delphi for Linux is out

2017-03-25 Thread Michael Schnell
On 23.03.2017 13:26, Graeme Geldenhuys wrote: * - place with whatever name suites you. Anders Hejlsberg :) -Michael ___ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal

Re: [fpc-pascal] TSQLQuery and buffering.

2017-03-25 Thread Michael Van Canneyt
On Sat, 25 Mar 2017, Gary Doades wrote: On Fri, 24 Mar 2017, Gary Doades wrote: Really, the question is simple: Is there ANY way of TSQLQuery NOT reading the entire result set into memory? Set Unidirectional to True, and it will keep only 1 row in memory. When you are simply scanning th

Re: [fpc-pascal] TSQLQuery and buffering.

2017-03-25 Thread Michael Van Canneyt
On Sat, 25 Mar 2017, Martin Schreiber wrote: On Saturday 25 March 2017 09:32:33 Gary Doades wrote: I Understand about the "normal" use of TSQLQuery and data sets and I also use this for small result set that need the data changing some way and writing back to the DB. What I need now is an eq

Re: [fpc-pascal] TSQLQuery and buffering.

2017-03-25 Thread Martin Schreiber
On Saturday 25 March 2017 09:32:33 Gary Doades wrote: > > I Understand about the "normal" use of TSQLQuery and data sets and I also > use this for small result set that need the data changing some way and > writing back to the DB. What I need now is an equally convenient and > powerful way of proce

Re: [fpc-pascal] Delphi RTTI vs Free Pascal RTTI

2017-03-25 Thread Sven Barth via fpc-pascal
Am 24.03.2017 19:55 schrieb "Michael Van Canneyt" : > > > > On Fri, 24 Mar 2017, African Wild Dog wrote: > >> Hello, >> >> I need to write a code compatilble with both free pascal and delphi using >> the old style RTTI. >> What are the diferences between delphi's and free pascal's approach/types? >

Re: [fpc-pascal] TSQLQuery and buffering.

2017-03-25 Thread Gary Doades
On Fri, 24 Mar 2017, Gary Doades wrote: > >> Really, the question is simple: Is there ANY way of TSQLQuery NOT >> reading the entire result set into memory? > Set Unidirectional to True, and it will keep only 1 row in memory. > When you are simply scanning through the result set, this is all you

Re: [fpc-pascal] TSQLQuery and buffering.

2017-03-25 Thread Michael Van Canneyt
On Fri, 24 Mar 2017, Gary Doades wrote: Hi everyone, Firstly, I realise this is an old subject, but I still can't find any easy answer. Really, the question is simple: Is there ANY way of TSQLQuery NOT reading the entire result set into memory? Set Unidirectional to True, and it will kee

[fpc-pascal] TSQLQuery and buffering.

2017-03-25 Thread Gary Doades
Hi everyone, Firstly, I realise this is an old subject, but I still can't find any easy answer. Really, the question is simple: Is there ANY way of TSQLQuery NOT reading the entire result set into memory? This is really killing me. I've got quite a lot of web code using sqldb and it wor