Re: [Gambas-user] Result object, again

2010-11-26 Thread Benoît Minisini
> On Thu, 2010-11-25 at 20:06 +0100, tobias wrote: > > > A result object stores the entire query of the result in memory, > > > > because of > > > > > the stupidity of most SQL backends. > > Hmmm, I'd take that statement with a grain of salt. When working on > databases at work, I think we'd ha

Re: [Gambas-user] Result object, again

2010-11-26 Thread Caveat
On Thu, 2010-11-25 at 20:06 +0100, tobias wrote: > > A result object stores the entire query of the result in memory, > because of > > the stupidity of most SQL backends. Hmmm, I'd take that statement with a grain of salt. When working on databases at work, I think we'd have soon run into majo

Re: [Gambas-user] Result object, again

2010-11-25 Thread tobias
Benoît Minisini schrieb: >> good evening all, >> i have another question about my eternal punishment: the result object :-) >> >> caveat answered to a former question about results in general: >> >If you got into the habit of reading all the >> >records you've selected into memory (or even if the

Re: [Gambas-user] Result object, again

2010-11-25 Thread Benoît Minisini
> 2010/11/25 Benoît Minisini : > >> good evening all, > >> i have another question about my eternal punishment: the result object > >> :-) > >> > >> caveat answered to a former question about results in general: > >> >If you got into the habit of reading all the > >> >records you've selected int

Re: [Gambas-user] Result object, again

2010-11-24 Thread Ian Haywood
2010/11/25 Benoît Minisini : >> good evening all, >> i have another question about my eternal punishment: the result object :-) >> >> caveat answered to a former question about results in general: >>  >If you got into the habit of reading all the >>  >records you've selected into memory (or even if

Re: [Gambas-user] Result object, again

2010-11-24 Thread Benoît Minisini
> good evening all, > i have another question about my eternal punishment: the result object :-) > > caveat answered to a former question about results in general: > >If you got into the habit of reading all the > >records you've selected into memory (or even if the Result object > >worked > >

[Gambas-user] Result object, again

2010-11-24 Thread tobias
good evening all, i have another question about my eternal punishment: the result object :-) caveat answered to a former question about results in general: >If you got into the habit of reading all the >records you've selected into memory (or even if the Result object >worked >that way behind

Re: [Gambas-user] Result object

2010-11-17 Thread Fabien Bodard
hResult = db.Create("mytable") for i = 0 to 10 hResult["name"]="toto " & i hResult!Firstname = "titi " & i hResult.Update next 2010/11/17 Fabien Bodard : > no just create one time... and then ... just call update between each entry > > > > 2010/11/17 tobias : >> Benoît Minisini schrieb:

Re: [Gambas-user] Result object

2010-11-17 Thread Fabien Bodard
no just create one time... and then ... just call update between each entry 2010/11/17 tobias : > Benoît Minisini schrieb: >>> Charlie Reinl schrieb: Am Dienstag, den 16.11.2010, 21:44 +0100 schrieb tobias: > Charlie Reinl schrieb: >> Am Montag, den 15.11.2010, 19:56 +0100 schrieb t

Re: [Gambas-user] Result object

2010-11-17 Thread tobias
Benoît Minisini schrieb: >> Charlie Reinl schrieb: >>> Am Dienstag, den 16.11.2010, 21:44 +0100 schrieb tobias: Charlie Reinl schrieb: > Am Montag, den 15.11.2010, 19:56 +0100 schrieb tobias: >> hi, >> i have again another question about the result object... >> when i do: >

Re: [Gambas-user] Result object

2010-11-17 Thread Benoît Minisini
> Charlie Reinl schrieb: > > Am Dienstag, den 16.11.2010, 21:44 +0100 schrieb tobias: > >> Charlie Reinl schrieb: > >>> Am Montag, den 15.11.2010, 19:56 +0100 schrieb tobias: > hi, > i have again another question about the result object... > when i do: > hResult = hConnection.Ed

Re: [Gambas-user] Result object

2010-11-17 Thread tobias
Charlie Reinl schrieb: > Am Dienstag, den 16.11.2010, 21:44 +0100 schrieb tobias: >> Charlie Reinl schrieb: >>> Am Montag, den 15.11.2010, 19:56 +0100 schrieb tobias: hi, i have again another question about the result object... when i do: hResult = hConnection.Edit("table")

Re: [Gambas-user] Result object

2010-11-17 Thread tobias
Charlie Reinl schrieb: > Am Dienstag, den 16.11.2010, 21:44 +0100 schrieb tobias: >> Charlie Reinl schrieb: >>> Am Montag, den 15.11.2010, 19:56 +0100 schrieb tobias: hi, i have again another question about the result object... when i do: hResult = hConnection.Edit("table")

Re: [Gambas-user] Result object

2010-11-16 Thread Charlie Reinl
Am Dienstag, den 16.11.2010, 21:44 +0100 schrieb tobias: > Charlie Reinl schrieb: > > Am Montag, den 15.11.2010, 19:56 +0100 schrieb tobias: > >> hi, > >> i have again another question about the result object... > >> when i do: > >> hResult = hConnection.Edit("table") > >> > >> i get a read/write r

Re: [Gambas-user] Result object

2010-11-16 Thread tobias
Charlie Reinl schrieb: > Am Montag, den 15.11.2010, 19:56 +0100 schrieb tobias: >> hi, >> i have again another question about the result object... >> when i do: >> hResult = hConnection.Edit("table") >> >> i get a read/write result, i can move through the elements and edit >> their fields, e.g. >>

Re: [Gambas-user] Result object

2010-11-15 Thread Charlie Reinl
Am Montag, den 15.11.2010, 19:56 +0100 schrieb tobias: > hi, > i have again another question about the result object... > when i do: > hResult = hConnection.Edit("table") > > i get a read/write result, i can move through the elements and edit > their fields, e.g. > hResult.MoveTo(2) > hResult["id

[Gambas-user] Result object

2010-11-15 Thread tobias
hi, i have again another question about the result object... when i do: hResult = hConnection.Edit("table") i get a read/write result, i can move through the elements and edit their fields, e.g. hResult.MoveTo(2) hResult["id"] = 10 right? but where do i have to move to to add one (or more) new e