Re: [Gambas-user] too many operands

2009-09-07 Thread Doriano Blengino
MSulchan Darmawan ha scritto: > Pada Mon, 07 Sep 2009 13:19:32 +0200 > Doriano Blengino menulis: > > >>res = db.Create("refpos") ' append record in table named >> refpos for i = 1 to 31 >> res["Res" & i] = ... >>next >> > > Does this means the field name is Re

Re: [Gambas-user] too many operands

2009-09-07 Thread MSulchan Darmawan
Pada Mon, 07 Sep 2009 13:19:32 +0200 Doriano Blengino menulis: >res = db.Create("refpos") ' append record in table named > refpos for i = 1 to 31 > res["Res" & i] = ... >next Does this means the field name is Res1, Res2, ..., Res31 ??? If so, wow this is great, I di

[Gambas-user] simple postgres create user question

2009-09-07 Thread richard terry
Something simple - I can do the equivalent of this this in a pgadmin window: CREATE USER "FRED"' PASSWORD 'password' in ROLE whatever; and it keeps the caps of FRED I alwasy end up with lower case letters for the user name when I pass the query to postgres even if the logon_name here is "F

Re: [Gambas-user] tableview edit

2009-09-07 Thread Benoît Minisini
> The project is incomplete. It's a shop management project built in > Microsoft Office (Windows) and we're trying to make it in Linux(gambas) > and > Postgresql. We don't know much about gambas. > It's a form called 'pendentes' whith a tableview called 'subventas' apart > more controls (textbox,

Re: [Gambas-user] tableview edit

2009-09-07 Thread Tomas Costa rivas
The project is incomplete. It's a shop management project built in Microsoft Office (Windows) and we're trying to make it in Linux(gambas) and Postgresql. We don't know much about gambas. It's a form called 'pendentes' whith a tableview called 'subventas' apart more controls (textbox, buttons, ...)

Re: [Gambas-user] Balloon

2009-09-07 Thread Benoît Minisini
> Hi! > > >Balloon popup is little buggy (sometimes). > >Screenshot tells it all. > > For me (Gambas 2.15) the delay is not actuated: > > Balloon.Delay = 2 > > shows for a small second > > Pino > It works there... I think the problem comes from the window manager: which one do you

Re: [Gambas-user] tableview edit

2009-09-07 Thread Benoît Minisini
> No. > Error.code=13 > Error.text="Null object" > All error message have a class name and a line number (in Error.Where). Please send your full project. -- Benoît -- Let Crystal Reports handle the reporting - Free Cr

Re: [Gambas-user] tableview edit

2009-09-07 Thread Tomas Costa rivas
No. Error.code=13 Error.text="Null object" 2009/9/7 Benoît Minisini > > Ok I change the sentence, like this: > > > > PUBLIC SUB mitabla_Change() > > DIM xArray AS String[] > > xArray = ["Proba1", "proba2", "proba3"] > > IF mitabla.Column = 0 THEN > > mitabla.Edit(xArray, TRUE) > > ENDIF > > END

Re: [Gambas-user] tableview edit

2009-09-07 Thread Benoît Minisini
> Ok I change the sentence, like this: > > PUBLIC SUB mitabla_Change() > DIM xArray AS String[] > xArray = ["Proba1", "proba2", "proba3"] > IF mitabla.Column = 0 THEN > mitabla.Edit(xArray, TRUE) > ENDIF > END > And the error is the same: "Null object". > (It's the full error message) > > Thanks

Re: [Gambas-user] tableview edit

2009-09-07 Thread Tomas Costa rivas
Ok I change the sentence, like this: PUBLIC SUB mitabla_Change() DIM xArray AS String[] xArray = ["Proba1", "proba2", "proba3"] IF mitabla.Column = 0 THEN mitabla.Edit(xArray, TRUE) ENDIF END And the error is the same: "Null object". (It's the full error message) Thanks for your help Tomas 2009/

Re: [Gambas-user] Array decalarion

2009-09-07 Thread Ron
Benoît Minisini wrote: >> Benoît Minisini wrote: >> Hi, Why is method 1 of defining an array not allowed? Method 2 is the only one working, but looks clumsy when you have a lot of bytes. 1) DIM b AS Byte[] = [&HF0, &H30, &HF0, &H30] The error

Re: [Gambas-user] Array decalarion

2009-09-07 Thread Benoît Minisini
> Benoît Minisini wrote: > >> Hi, > >> > >> Why is method 1 of defining an array not allowed? > >> Method 2 is the only one working, but looks clumsy when you have a lot > >> of bytes. > >> > >> 1) > >> DIM b AS Byte[] = [&HF0, &H30, &HF0, &H30] > >> > >> The error is "Type mismatch: wanted Byte[

Re: [Gambas-user] Array decalarion

2009-09-07 Thread Ron
Benoît Minisini wrote: >> Hi, >> >> Why is method 1 of defining an array not allowed? >> Method 2 is the only one working, but looks clumsy when you have a lot >> of bytes. >> >> 1) >> DIM b AS Byte[] = [&HF0, &H30, &HF0, &H30] >> >> The error is "Type mismatch: wanted Byte[], got Integer[] inste

Re: [Gambas-user] Array decalarion

2009-09-07 Thread Benoît Minisini
> Hi, > > Why is method 1 of defining an array not allowed? > Method 2 is the only one working, but looks clumsy when you have a lot > of bytes. > > 1) > DIM b AS Byte[] = [&HF0, &H30, &HF0, &H30] > > The error is "Type mismatch: wanted Byte[], got Integer[] instead" > &HF0 is not a Byte, it

Re: [Gambas-user] tableview edit

2009-09-07 Thread Benoît Minisini
> I have a problem in a tableview > > I try to edit a cell in a tableview as a comboview. > I write: > > Public sub mitabla_change() > DIM xArray AS NEW String[3] As you assign xArray a new array, you don't have to initialize it with a void one. Just do: DIM xArray AS String[] > xArray = ["pru

[Gambas-user] Array decalarion

2009-09-07 Thread Ron
Hi, Why is method 1 of defining an array not allowed? Method 2 is the only one working, but looks clumsy when you have a lot of bytes. 1) DIM b AS Byte[] = [&HF0, &H30, &HF0, &H30] The error is "Type mismatch: wanted Byte[], got Integer[] instead" 2) DIM b AS Byte[4] b[0] = &HF0 b[1] = &H30

[Gambas-user] Balloon

2009-09-07 Thread Pino Zollo
Hi! >Balloon popup is little buggy (sometimes). >Screenshot tells it all. For me (Gambas 2.15) the delay is not actuated: Balloon.Delay = 2 shows for a small second Pino -- Key ID: 0xF6768208 Key fingerprint = B16D 0A7C 5B29 A334 CE6A 71F6 EAF8 3D88 F676 8208 Key server: hkp://wwwke

[Gambas-user] Fwd: Re: Help DataSource, DataBrowse

2009-09-07 Thread Pino Zollo
-- Messaggio inoltrato -- Subject: Re: [Gambas-user] Help DataSource, DataBrowse Date: 11:16, domenica 6 settembre 2009 From: Pino Zollo To: Benoît Minisini Alle 08:21, domenica 6 settembre 2009, hai scritto: > > Hi , > > Please an helpI am practising with DataSorce usin

Re: [Gambas-user] ReturnValue

2009-09-07 Thread Doriano Blengino
Dimitris Anogiatis ha scritto: > Laurent, > > How can someone detect the return value from an application that's > terminating, > (either in gambas or bash) > It depends on what we are talking about. Under Unix (and Dos, and winslow) any program can return an integer value. The process sets th

Re: [Gambas-user] too many operands

2009-09-07 Thread Doriano Blengino
MSulchan Darmawan ha scritto: > Dear all, > > Any suggestion to simplify this code ? I had "Expression too complex, > too many operands" warning :D > I have 36 fields data to insert. > > sSql = "INSERT INTO refpos (id, idpos, year, month, day, " & > "r1, r2, r3, r4, r5, r6, r

Re: [Gambas-user] too many operands

2009-09-07 Thread Doriano Blengino
MSulchan Darmawan ha scritto: > Dear all, > > Any suggestion to simplify this code ? I had "Expression too complex, > too many operands" warning :D > I have 36 fields data to insert. > > sSql = "INSERT INTO refpos (id, idpos, year, month, day, " & > "r1, r2, r3, r4, r5, r6, r

[Gambas-user] tableview edit

2009-09-07 Thread Tomas Costa rivas
I have a problem in a tableview I try to edit a cell in a tableview as a comboview. I write: Public sub mitabla_change() DIM xArray AS NEW String[3] xArray = ["prueba1", "prueba2", "prueba3"] IF mitabla.Column = 0 THEN subventas.Edit(xArray, TRUE) ' here is the problem ENDIF END I get a error ("

Re: [Gambas-user] How to get listbox selection?

2009-09-07 Thread Dimitris Anogiatis
Demostheni, An katalava kala thes na vlepeis oles tis epiloges pou exeis kanei sto listbox se multiple mode, etsi? Exo ftiaxei mia synartisi pou kanei akrivos afto to pragma. ' PUBLIC FUNCTION

[Gambas-user] How to get listbox selection?

2009-09-07 Thread Demosthenes Koptsis
Hi to all, how can we get the selection of a multiple mode listbox? return an array of selected items or something? -- Γεια χαρα σε όλους!!! Regards, Demosthenes Koptsis -- Let Crystal Reports handle the reporting -

Re: [Gambas-user] too many operands

2009-09-07 Thread Dimitris Anogiatis
I'm glad it worked MSulchan, That's why I love gambas cause it makes things so much easier :) even more than VB6 ever would :) Keep up the good work Regards, Dimitris On Mon, Sep 7, 2009 at 3:54 AM, MSulchan Darmawan wrote: > Pada Mon, 7 Sep 2009 03:41:35 -0600 > Dimitris Anogiatis menulis: >

Re: [Gambas-user] too many operands

2009-09-07 Thread MSulchan Darmawan
Pada Mon, 7 Sep 2009 03:41:35 -0600 Dimitris Anogiatis menulis: > Where is this coming from? Gambas or mysql? Gambas. > if mysql doesn't return an error and accepts the insert command then > you might want to break the sql string like this Thanks Dimitris, it work ! Well, at least it pass the

Re: [Gambas-user] ReturnValue

2009-09-07 Thread Dimitris Anogiatis
Laurent, How can someone detect the return value from an application that's terminating, (either in gambas or bash) Thank you in advance Regards, Dimitris On Mon, Sep 7, 2009 at 3:13 AM, Laurent Carlier wrote: > Le lundi 07 septembre 2009 10:19:40 Charlie Reinl, vous avez écrit : > > Am Sonnta

Re: [Gambas-user] too many operands

2009-09-07 Thread Dimitris Anogiatis
MSulchan, Where is this coming from? Gambas or mysql? can you try and do this insert in mysql in a terminal window? if mysql doesn't return an error and accepts the insert command then you might want to break the sql string like this sSql = "INSERT INTO refPos(id,idpos,year,month,day, " sSql &=

[Gambas-user] too many operands

2009-09-07 Thread MSulchan Darmawan
Dear all, Any suggestion to simplify this code ? I had "Expression too complex, too many operands" warning :D I have 36 fields data to insert. sSql = "INSERT INTO refpos (id, idpos, year, month, day, " & "r1, r2, r3, r4, r5, r6, r7, r8, r9, r10, " & "r11,

Re: [Gambas-user] ReturnValue

2009-09-07 Thread Laurent Carlier
Le lundi 07 septembre 2009 10:19:40 Charlie Reinl, vous avez écrit : > Am Sonntag, den 06.09.2009, 16:10 -0600 schrieb Dimitris Anogiatis: > > hey charlie, > > > > Are you talking about return values on a console-type? > > I think all you have to do is use Print. > > > > It will also work on a gui

Re: [Gambas-user] ReturnValue

2009-09-07 Thread Charlie Reinl
Am Sonntag, den 06.09.2009, 16:10 -0600 schrieb Dimitris Anogiatis: > hey charlie, > > Are you talking about return values on a console-type? > I think all you have to do is use Print. > > It will also work on a gui-program if you run it through a terminal. > > I hope it helps (unless I missed