Re: [Gambas-user] any way to convert Result to Collection more faster than copy?

2017-07-01 Thread adamn...@gmail.com
On Fri, 30 Jun 2017 08:41:49 -0400 PICCORO McKAY Lenz wrote: > i get more than 30 minutes, due i must parse to a low end machine, not to > your 4 cores, 16Gb ram super power machine.. i'm taking about a 1G ram and > single core 1,6GHz atom cpu > > i need to convert from Result/cursor to other d

Re: [Gambas-user] any way to convert Result to Collection more faster than copy?

2017-07-01 Thread PICCORO McKAY Lenz
thanks in advance adamnt42, i need to convert the result due missing odbc important features... 2017-07-01 3:06 GMT-04:30 adamn...@gmail.com : > Well, 30 minutes does sound very excessive. Are you certain that it's the > "unmarshalling" that is taking the time and not the execution of the query >

[Gambas-user] how to determine if array its empty

2017-07-01 Thread PICCORO McKAY Lenz
i have Dim ar As New Variant[] so how can i determine if the array its empty, i mean does not added any element.. due that piece of code fails: If value.dim > 0 Then If value.count > 0 Then with a index out of bound exception Lenz McKAY Gerardo (PICCORO) http://qgqlochekone.blogspot.com

Re: [Gambas-user] any way to convert Result to Collection more faster than copy?

2017-07-01 Thread Christof Thalhofer
Am 30.06.2017 um 00:57 schrieb PICCORO McKAY Lenz: > i'm taking about 200.000 rows in a result... the problem its that the odbc > db object support only cursor with forward only.. Show us your query. For what do you need 200.000 rows? That's way too much if you want to visialize anything. Alles

Re: [Gambas-user] how to determine if array its empty

2017-07-01 Thread Gianluigi
Dim myArray As String[] If IsNull(myArray) Then Print "Empty" Regards Gianluigi 2017-07-01 11:33 GMT+02:00 PICCORO McKAY Lenz : > i have > > Dim ar As New Variant[] > > so how can i determine if the array its empty, i mean does not added any > element.. due that piece of code fails: > > If v

Re: [Gambas-user] how to determine if array its empty

2017-07-01 Thread Gianluigi
or If IsNull(myArray) Or If myArray.Count = 0 Then Print "Empty" Regards Gianluigi 2017-07-01 12:09 GMT+02:00 Gianluigi : > Dim myArray As String[] > > If IsNull(myArray) Then Print "Empty" > > Regards > Gianluigi > > 2017-07-01 11:33 GMT+02:00 PICCORO McKAY Lenz : > >> i have >> >> Dim ar As

Re: [Gambas-user] any way to convert Result to Collection more faster than copy?

2017-07-01 Thread PICCORO McKAY Lenz
hi cristof, the query its just "select * from table" but where "table" its a "cube" of the datawarehouse.. so i want to made a something similar to BussinesObject.. so get 200.000 rows its not a surprise in desktop.. the other problem to force me to get so many rows its the lack of features/connec

Re: [Gambas-user] any way to convert Result to Collection more faster than copy?

2017-07-01 Thread Fernando Cabral
2017-07-01 6:30 GMT-03:00 PICCORO McKAY Lenz : > all of those question are not relevant, the real problem its the lack of > gambas to handle many DB features due the ODBC connection.. > I think you should be more specific. Instead of saying "the real problem is the lack of gambas to handle many D

[Gambas-user] SELECT CASE can evaluate multiple "CASE"? at same time

2017-07-01 Thread PICCORO McKAY Lenz
SELECT CASE can evaluate multiple "CASE"? i mean *Select* *Case* w *Case* *1 or 2* print "evaluatin multiple cases at same time" *Case* *Else* *Print* "This is impossible!" *End* *Select* Lenz McKAY Gerardo (PICCORO) http://qgqlochekone.blogspot.com ---

Re: [Gambas-user] any way to convert Result to Collection more faster than copy?

2017-07-01 Thread PICCORO McKAY Lenz
2017-07-01 6:38 GMT-04:30 Fernando Cabral : > I think you should be more specific. Instead of saying "the real problem is > the lack of > gambas to handle many DB features", let us know which those [lacking] > features are. > yet explainet and bug filet to gambasbugtraker .. you read the mail with

Re: [Gambas-user] how to determine if array its empty

2017-07-01 Thread Cristiano Guadagnino
Hi Gianluigi! On Sat, Jul 1, 2017 at 12:13 PM, Gianluigi wrote: > or > If IsNull(myArray) Or If myArray.Count = 0 Then Print "Empty" > I have not tried, but I don't think this will work. In an "or" expression you have to evaluate both members, so if myArray is null the "myArray.Count = 0" part

[Gambas-user] Eliminating duplicates real fast... but adding text do textarea works in a snail pace

2017-07-01 Thread Fernando Cabral
I want to share with you what seems to be my final solution for the problem concerning breaking a text into words, counting them all and eliminating duplicates. I was in for a surprise. Maybe you are too. First, to eliminate duplicates and count occurrences. Here is the code. Very simple, very tim

Re: [Gambas-user] how to determine if array its empty

2017-07-01 Thread Gianluigi
Hi Cristiano, Or If is only evaluated if *not* IsNull. Regards Gianluigi 2017-07-01 14:08 GMT+02:00 Cristiano Guadagnino : > Hi Gianluigi! > > On Sat, Jul 1, 2017 at 12:13 PM, Gianluigi wrote: > > > or > > If IsNull(myArray) Or If myArray.Count = 0 Then Print "Empty" > > > > I have not tried,

Re: [Gambas-user] how to determine if array its empty

2017-07-01 Thread PICCORO McKAY Lenz
2017-07-01 8:08 GMT-04:00 Cristiano Guadagnino : > Hi Gianluigi! > > On Sat, Jul 1, 2017 at 12:13 PM, Gianluigi wrote: > > > or > > If IsNull(myArray) Or If myArray.Count = 0 Then Print "Empty" > > > > I have not tried, but I don't think this will work. In an "or" expression > you have to evaluat

Re: [Gambas-user] how to determine if array its empty

2017-07-01 Thread Hans Lehmann
Hallo, my idea: Dim myArray As New String[] ' Existiert das Array und ist die Anzahl der Elemente gleich Null, dann ist das Array leer If Not IsNull(myArray) And If myArray.Count = 0 Then Print "Array is empty" Hans ---

Re: [Gambas-user] SELECT CASE can evaluate multiple "CASE"? at same time

2017-07-01 Thread Jussi Lahtinen
"Case 1, 2" will do the job. Jussi On Sat, Jul 1, 2017 at 2:12 PM, PICCORO McKAY Lenz wrote: > SELECT CASE can evaluate multiple "CASE"? i mean > > *Select* *Case* w *Case* *1 or 2* > print "evaluatin multiple cases at same time" *Case* *Else* *Print* "This > is impossible!" *End* *Select* >

Re: [Gambas-user] how to determine if array its empty

2017-07-01 Thread Jussi Lahtinen
If you add the extra "if", then Gambas will do short-circuit evaluation. https://en.wikipedia.org/wiki/Short-circuit_evaluation Jussi On Sat, Jul 1, 2017 at 3:08 PM, Cristiano Guadagnino wrote: > Hi Gianluigi! > > On Sat, Jul 1, 2017 at 12:13 PM, Gianluigi wrote: > > > or > > If IsNull(myAr

Re: [Gambas-user] Eliminating duplicates real fast... but adding text do textarea works in a snail pace

2017-07-01 Thread Jussi Lahtinen
Gambas have built in profiler. You might want to get familiar with it. Jussi On Sat, Jul 1, 2017 at 3:26 PM, Fernando Cabral < fernandojosecab...@gmail.com> wrote: > I want to share with you what seems to be my final solution for the problem > concerning breaking a text into words, counting the

Re: [Gambas-user] how to determine if array its empty

2017-07-01 Thread Hans Lehmann
Correct? If (Not IsNull(myArray) And myArray.Count = 0) Then Print "Array is empty" Hans -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot ___

Re: [Gambas-user] how to determine if array its empty

2017-07-01 Thread Gianluigi
Hi Hans, If the array is not instantiated or does not work (first example) or does error. Regards Gianluigi 2017-07-01 15:36 GMT+02:00 Hans Lehmann : > Correct? > > If (Not IsNull(myArray) And myArray.Count = 0) Then Print "Array is empty" > > Hans > > ---

Re: [Gambas-user] how to determine if array its empty

2017-07-01 Thread Hans Lehmann
Case 1: Dim myArray As String[] --> Array not exist. Case 2: Dim myArray As New String[] --> Array ist empty. Case 3: Dim myArray As New String[] --> Array is not empty! myArray.Add("Value") If Not IsNull(myArray) Then If myArray.Count = 0 Then Print "Array ist empty."

Re: [Gambas-user] how to determine if array its empty

2017-07-01 Thread Gianluigi
Ok, very precise, depends on what you need. I think at work, if you have to read the array, an: If IsNull (myArray) Or If myArray.Count = 0 Then Return It is more practice Gianluigi 2017-07-01 16:15 GMT+02:00 Hans Lehmann : > > Case 1: > Dim myArray As String[] --> Array not exist. > > Case

Re: [Gambas-user] any way to convert Result to Collection more faster than copy?

2017-07-01 Thread Christof Thalhofer
Am 01.07.2017 um 12:35 schrieb PICCORO McKAY Lenz: > hi cristof, the query its just "select * from table" but where > "table" its a "cube" of the datawarehouse.. so i want to made a > something similar to BussinesObject.. so get 200.000 rows its not a > surprise in desktop.. For a datawarehouse 20

[Gambas-user] Problem to be examined by those who must use UTF8 with Gambas

2017-07-01 Thread Fernando Cabral
I've been testing my new toy with every large and small text I can put my hands on. The fact is, I have had surprise after surprise. I've just found that when I read a text that contains "À" (that's an A with a grave accent (`A) -- or a backward acute accent for those who are not familiar with dia

Re: [Gambas-user] how to determine if array its empty

2017-07-01 Thread Cristiano Guadagnino
Thank you Jussi, that's a nice trick I didn't know of! Actually, I didn't even notice there was an extra "if" in Gianluigi's example. Cris On Sat, Jul 1, 2017 at 3:28 PM, Jussi Lahtinen wrote: > If you add the extra "if", then Gambas will do short-circuit evaluation. > https://en.wikipedia.org/

Re: [Gambas-user] Problem to be examined by those who must use UTF8 with Gambas

2017-07-01 Thread Jussi Lahtinen
I don't quite get your description of the problem. It seems self contradictory. I mean this part: *'So, "`A" (coded as "\xC3\x80") will prevent the displaying of any string. Nevertheless, if I just try to display "Some text plus À and some text more" it will work.'* So, what exactly does not

[Gambas-user] Fwd: Problem to be examined by those who must use UTF8 with Gambas

2017-07-01 Thread Jussi Lahtinen
-- Forwarded message -- From: Benoît Minisini Date: Sun, Jul 2, 2017 at 1:14 AM Subject: Re: [Gambas-user] Problem to be examined by those who must use UTF8 with Gambas To: Jussi Lahtinen , ferna...@fcabral.com.br Please send that to the mailing-list. Regards, Le 02/07/2017 à 0

[Gambas-user] Fwd: Problem to be examined by those who must use UTF8 with Gambas

2017-07-01 Thread Fernando Cabral
-- Forwarded message -- From: Fernando Cabral Date: 2017-07-01 17:34 GMT-03:00 Subject: Re: [Gambas-user] Problem to be examined by those who must use UTF8 with Gambas To: Jussi Lahtinen 2017-07-01 16:15 GMT-03:00 Jussi Lahtinen : > I don't quite get your description of the pro

Re: [Gambas-user] I need a hint on how to deleted duplicate items in a array

2017-07-01 Thread nando_f
there are much faster ways...just a little more intricate. Nando -- Open WebMail Project (http://openwebmail.org) -- Original Message --- From: Fernando Cabral To: mailing list for gambas users Sent: Sat, 1 Jul 2017 00:18:42 -0300 Subject: Re: [Gambas-user] I need a hint on h

Re: [Gambas-user] any way to convert Result to Collection more faster than copy?

2017-07-01 Thread PICCORO McKAY Lenz
2017-07-01 10:59 GMT-04:30 Christof Thalhofer : > From what database do you query "select * from table" with ODBC? > sybase and Oracle, a propietary odbc module does all the job very good, but i need to use open source,, and freetds have in combination with gambas lack of a good cursor.. the curso