Re: [Gambas-user] Gambas2 components?
Hi Garth, got the version listed on the website shown below and able to follow it BUT i don't use mysql but postgres but it's interesting to see what you've done by walking thorough your code as far as i can. Been thinking here and please you or anyone else correct me but couldn't this be done? 1. using the DB demo form and code. import that into your project enter connection strings to enable a valid connection to a RDBMS. having the form hidden at run-time so it's available to use but not visible to the user. 2. using the Rrequest form code as an object (thus allowing multiple table connections) and having the recordset be returned back to the user code for further actions. that could reduce a lot of repeatitive coding for every project. eg. for every DB Control in a programmers project you would either share the recordset (thus a move in 1 control would be the same move in the others) object OR create/have new recordsets for each DB Control. 3. control of writting data into the tables could also be managed via the code within the Frequest code. from my observations it looks doable and with my limited coding knowledge of Gambas be easily incorporated into the next build cycle. * snipped * The closest thing you're going to get for the moment is GridEditor. http://gambasrad.org/software/gambas-grideditor * snipped * Get the world#39;s best email - http://nz.mail.yahoo.com/ -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] Gambas2 components?
Mmm, Maybe it's me, but I'm not seeing anything it doesn't already do ... ??? All objects / returned data etc are available to the user .. true it's via method and property calls, but this is the way it should be in an OOP system .. we don't expose raw data(!) Gareth. - Original Message - From: dave L dg...@yahoo.com To: mailing list for gambas users gambas-user@lists.sourceforge.net Sent: Wednesday, 14 January, 2009 8:32:10 AM GMT +00:00 GMT Britain, Ireland, Portugal Subject: Re: [Gambas-user] Gambas2 components? Hi Garth, got the version listed on the website shown below and able to follow it BUT i don't use mysql but postgres but it's interesting to see what you've done by walking thorough your code as far as i can. Been thinking here and please you or anyone else correct me but couldn't this be done? 1. using the DB demo form and code. import that into your project enter connection strings to enable a valid connection to a RDBMS. having the form hidden at run-time so it's available to use but not visible to the user. 2. using the Rrequest form code as an object (thus allowing multiple table connections) and having the recordset be returned back to the user code for further actions. that could reduce a lot of repeatitive coding for every project. eg. for every DB Control in a programmers project you would either share the recordset (thus a move in 1 control would be the same move in the others) object OR create/have new recordsets for each DB Control. 3. control of writting data into the tables could also be managed via the code within the Frequest code. from my observations it looks doable and with my limited coding knowledge of Gambas be easily incorporated into the next build cycle. * snipped * The closest thing you're going to get for the moment is GridEditor. http://gambasrad.org/software/gambas-grideditor * snipped * Get the world#39;s best email - http://nz.mail.yahoo.com/ -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user -- Managing Director, Encryptec Limited Tel: 0845 5082719, Mob: 0785 3305393 Email: gar...@encryptec.net Statements made are at all times subject to Encryptec's Terms and Conditions of Business, which are available upon request. -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] Gambas2 components?
rom: Gareth Bult gar...@encryptec.net To: mailing list for gambas users gambas-user@lists.sourceforge.net Sent: Wednesday, 14 January, 2009 9:53:09 PM Subject: Re: [Gambas-user] Gambas2 components? Mmm, Maybe it's me, but I'm not seeing anything it doesn't already do ... ??? Agreed except that I couldn't get your app running due to me not having mysql - bummer!!! so i couldn't actually get the project running that i downloaded from the url you gave me. All objects / returned data etc are available to the user .. true it's via method and property calls, but this is the way it should be in an OOP system .. we don't expose raw data(!) what i was suggesting was perhaps an intermediate step until you get your program working right. But i tried it as a sample by making the visible property to false and - got to form_open statement and died!!! So that idea without refinement is dead! another thing with your editor is that it's filled with mysql specific statements (my ignorance is showing here) or do mysql postgres share similar properties? dave. Gareth. - Original Message - From: dave L dg...@yahoo.com To: mailing list for gambas users gambas-user@lists.sourceforge.net Sent: Wednesday, 14 January, 2009 8:32:10 AM GMT +00:00 GMT Britain, Ireland, Portugal Subject: Re: [Gambas-user] Gambas2 components? Hi Garth, got the version listed on the website shown below and able to follow it BUT i don't use mysql but postgres but it's interesting to see what you've done by walking thorough your code as far as i can. Been thinking here and please you or anyone else correct me but couldn't this be done? 1. using the DB demo form and code. import that into your project enter connection strings to enable a valid connection to a RDBMS. having the form hidden at run-time so it's available to use but not visible to the user. 2. using the Rrequest form code as an object (thus allowing multiple table connections) and having the recordset be returned back to the user code for further actions. that could reduce a lot of repeatitive coding for every project. eg. for every DB Control in a programmers project you would either share the recordset (thus a move in 1 control would be the same move in the others) object OR create/have new recordsets for each DB Control. 3. control of writting data into the tables could also be managed via the code within the Frequest code. from my observations it looks doable and with my limited coding knowledge of Gambas be easily incorporated into the next build cycle. * snipped * The closest thing you're going to get for the moment is GridEditor. http://gambasrad.org/software/gambas-grideditor * snipped * Get the world's best email - http://nz.mail.yahoo.com/ -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user -- Managing Director, Encryptec Limited Tel: 0845 5082719, Mob: 0785 3305393 Email: gar...@encryptec.net Statements made are at all times subject to Encryptec's Terms and Conditions of Business, which are available upon request. -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user Easy recipes for Christmas entertaining on Yahoo!Xtra Lifestyle- http://nz.lifestyle.yahoo.com/food-recipes -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] Two minor bugs
I find the default 'autostretch mode' now very nice and handy, if there comes a flag I prefer to have this default on/enabled. Regards, Ron_2nd. On Wednesday 14 January 2009, Rolf-Werner Eilert wrote: Thinking it over, I still feel that it should be the programmer's choice what width the last column should have. Implementing it as an option (Property: LastColumnStretch or so) would be nice, although it would add to featurism of course. I agree with this. A property to enable/disable the auto fill last column would be very nice But nobody else here seems to be interested in this topic, and nobody commented on my screenshots (or didn't the pictures get through?). So I don't want to overstress this. I found the screenshot explaining it just the right way. On the other hand, imagine what this looks like when you start input within such a table: a column only a single letter wide or a few, and the input line reaches out so far to the right... That IS ugly, isn't it? Rolf Best regards, Ron_1st -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] Gambas2 components?
Erm, what i was suggesting was perhaps an intermediate step until you get your program working right. It's been working right for quite a long time .. my business relies on it working right .. (!) another thing with your editor is that it's filled with mysql specific statements For example? Do yourself a favour - try MySQL! Gareth. - Original Message - From: dave L dg...@yahoo.com To: mailing list for gambas users gambas-user@lists.sourceforge.net Sent: Wednesday, 14 January, 2009 9:38:50 AM GMT +00:00 GMT Britain, Ireland, Portugal Subject: Re: [Gambas-user] Gambas2 components? rom: Gareth Bult gar...@encryptec.net To: mailing list for gambas users gambas-user@lists.sourceforge.net Sent: Wednesday, 14 January, 2009 9:53:09 PM Subject: Re: [Gambas-user] Gambas2 components? Mmm, Maybe it's me, but I'm not seeing anything it doesn't already do ... ??? Agreed except that I couldn't get your app running due to me not having mysql - bummer!!! so i couldn't actually get the project running that i downloaded from the url you gave me. All objects / returned data etc are available to the user .. true it's via method and property calls, but this is the way it should be in an OOP system .. we don't expose raw data(!) what i was suggesting was perhaps an intermediate step until you get your program working right. But i tried it as a sample by making the visible property to false and - got to form_open statement and died!!! So that idea without refinement is dead! another thing with your editor is that it's filled with mysql specific statements (my ignorance is showing here) or do mysql postgres share similar properties? dave. Gareth. - Original Message - From: dave L dg...@yahoo.com To: mailing list for gambas users gambas-user@lists.sourceforge.net Sent: Wednesday, 14 January, 2009 8:32:10 AM GMT +00:00 GMT Britain, Ireland, Portugal Subject: Re: [Gambas-user] Gambas2 components? Hi Garth, got the version listed on the website shown below and able to follow it BUT i don't use mysql but postgres but it's interesting to see what you've done by walking thorough your code as far as i can. Been thinking here and please you or anyone else correct me but couldn't this be done? 1. using the DB demo form and code. import that into your project enter connection strings to enable a valid connection to a RDBMS. having the form hidden at run-time so it's available to use but not visible to the user. 2. using the Rrequest form code as an object (thus allowing multiple table connections) and having the recordset be returned back to the user code for further actions. that could reduce a lot of repeatitive coding for every project. eg. for every DB Control in a programmers project you would either share the recordset (thus a move in 1 control would be the same move in the others) object OR create/have new recordsets for each DB Control. 3. control of writting data into the tables could also be managed via the code within the Frequest code. from my observations it looks doable and with my limited coding knowledge of Gambas be easily incorporated into the next build cycle. * snipped * The closest thing you're going to get for the moment is GridEditor. http://gambasrad.org/software/gambas-grideditor * snipped * Get the world's best email - http://nz.mail.yahoo.com/ -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user -- Managing Director, Encryptec Limited Tel: 0845 5082719, Mob: 0785 3305393 Email: gar...@encryptec.net Statements made are at all times subject to Encryptec's Terms and Conditions of Business, which are available upon request. -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user Easy recipes for Christmas entertaining on Yahoo!Xtra Lifestyle- http://nz.lifestyle.yahoo.com/food-recipes -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user -- Managing Director, Encryptec Limited Tel: 0845 5082719, Mob: 0785 3305393 Email:
Re: [Gambas-user] Two minor bugs
On Wednesday 14 January 2009, Rolf-Werner Eilert wrote: Thinking it over, I still feel that it should be the programmer's choice what width the last column should have. Implementing it as an option (Property: LastColumnStretch or so) would be nice, although it would add to featurism of course. I agree with this. A property to enable/disable the auto fill last column would be very nice But nobody else here seems to be interested in this topic, and nobody commented on my screenshots (or didn't the pictures get through?). So I don't want to overstress this. I found the screenshot explaining it just the right way. On the other hand, imagine what this looks like when you start input within such a table: a column only a single letter wide or a few, and the input line reaches out so far to the right... That IS ugly, isn't it? Rolf Best regards, Ron_1st -- -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] Error creating install package with Autotools
Maybe you should try the latest version, or at least a more recent one?-- Benoit Minisini I have installed gambas 2.8.2-1, but same error occur: - Creating package for Autotools. Making build directory. Creating package... aclocal autoconf automake -a configure.ac: installing `./install-sh' configure.ac: installing `./missing' Makefile.am: installing `./INSTALL' ./configure checking for a BSD-compatible install... /usr/bin/install -c checking whether build environment is sane... yes checking for gawk... no checking for mawk... mawk checking whether make sets $(MAKE)... yes configure: error: Cannot find .project file for coba3 ! make dist make: *** No rule to make target `dist'. Stop. The package build has failed. Package.MakeAutotoolsPackage.1190: Out of bounds - I used automake version 1.9, 1.8, 1.7. Autoconf 2.61-4. Ubuntu 8.04 -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
[Gambas-user] Open GL help needed
Hi I've written a litte program wich uses Open GL. I draw the triangle. I discovered some strange behaviour. Nothing is drawn, unless I set the focus on something else, and then on the GlArea. Which is strange, i think. However. That is not my MAIN problem. I dont understand how to use the Gl.Rotatef function. The button 'rotate' switches this function on and off. When it's Off, the triangle is correctly draw. When the value in TRUE, something starts moving, but it is to close: a huge green area, and after a little while it moves left, and then comes back... It looks like a rotation but to close. I hope my description is clear, and someone is able to help me. I use Gambas 2.7, Ubuntu 8.10 And the GambasGears demo is working properly (After I put the gb.sdl.info and gb.sdl.list in /usr/share/gambas2/info. Ubuntu package error). Jaap _ Nieuw: nu ook chatten op je mobiel! http://www.overaljevriendenbijje.nl/#superdeal OpenGLTest-0.0.1.tar.gz Description: GNU Zip compressed data -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
[Gambas-user] Open GL help needed
Hi! I've written a litte program wich uses Open GL. I draw the triangle. I discovered some strange behaviour. Nothing is drawn, unless I set the focus on something else, and then on the GlArea. Which is strange, i think. However. That is not my MAIN problem. I dont understand how to use the Gl.Rotatef function. The button 'rotate' switches this function on and off. When it's Off, the triangle is correctly draw. When the value in TRUE, something starts moving, but it is to close: a huge green area, and after a little while it moves left, and then comes back... It looks like a rotation but to close. I hope my description is clear, and someone is able to help me. I use Gambas 2.7, Ubuntu 8.10 And the GambasGears demo is working properly (After I put the gb.sdl.info and gb.sdl.list in /usr/share/gambas2/info. Ubuntu package error). Jaap _ Download de nieuwste emoticons voor in je Messenger http://www.msnmessengerexperience.nl/chuck/ OpenGLTest-0.0.1.tar.gz Description: GNU Zip compressed data -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] Gambas2 components?
On mardi 13 janvier 2009, dave L wrote: Hi Charles, Yes i've had a look at the code that is in the database example. by the time i went to be i had in my sample app created a link to the DB from cut i cout pasted into my app from the sample DB. I suppose you have modules you call in that you pass parameters to and it passes back the connection and then other routines you call to fill you form controls with data as shown in the sample refresh form (or whatever it's called). anyways i will have another look at how the table connection is made and recordsets are done. It's the lack of these properties for those actions i was surprised about initially. ps thanks for your reply. dave. Do you really look at the Database example? The standard database-bound controls of Gambas are located in the gb.db.form component. They are somewhat sparse, but here is a quick description: 1) A DataSource container. You specifiy your request there (usually a table), and all data controls inserted in the container will use it. 2) If you put a DataSource A inside another DataSource B, then the DataSource A is filtered by the primary key of the DataSource B. 3) You have a DataControl control, that allows to edit a field by using a control that depends on the field datatype. 4) You have a DataCombo control, that is a ComboBox that displays an integer field by using it as a primary key on another tabl. 5) You have a DataView, that allows to show the contents of a DataSource in a GridView. 6) You have a DataBrowser, that allows to browse its parent DataSource by using a DataView and some buttons. 7) There is a DataComboMulti too in Gambas 3, but I didn't write nor tested it. 8) Theses controls are database neutral. They work with mysql, postgresql, sqlite, firebird... 9) The DataSource is intelligent. It only request the records from the database by small packets. This way, you can put Internet between your application and the database, and things are perfectly usuable. Some caveats: 10) All table must have a primary key. 11) All DataSource use the current opened connection. Having some sort of Connection property to have two DataSource controls on different connection is planned. 12) I think that Gareth could have made his control database neutral. But it is his code, so he is the boss. Regards, -- Benoit Minisini -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] Gambas2 components?
On mercredi 14 janvier 2009, Benoit Minisini wrote: On mardi 13 janvier 2009, dave L wrote: Hi Charles, Yes i've had a look at the code that is in the database example. by the time i went to be i had in my sample app created a link to the DB from cut i cout pasted into my app from the sample DB. I suppose you have modules you call in that you pass parameters to and it passes back the connection and then other routines you call to fill you form controls with data as shown in the sample refresh form (or whatever it's called). anyways i will have another look at how the table connection is made and recordsets are done. It's the lack of these properties for those actions i was surprised about initially. ps thanks for your reply. dave. Do you really look at the Database example? The standard database-bound controls of Gambas are located in the gb.db.form component. They are somewhat sparse, but here is a quick description: 1) A DataSource container. You specifiy your request there (usually a table), and all data controls inserted in the container will use it. 2) If you put a DataSource A inside another DataSource B, then the DataSource A is filtered by the primary key of the DataSource B. 3) You have a DataControl control, that allows to edit a field by using a control that depends on the field datatype. 4) You have a DataCombo control, that is a ComboBox that displays an integer field by using it as a primary key on another tabl. 5) You have a DataView, that allows to show the contents of a DataSource in a GridView. 6) You have a DataBrowser, that allows to browse its parent DataSource by using a DataView and some buttons. 7) There is a DataComboMulti too in Gambas 3, but I didn't write nor tested it. 8) Theses controls are database neutral. They work with mysql, postgresql, sqlite, firebird... 9) The DataSource is intelligent. It only request the records from the database by small packets. This way, you can put Internet between your application and the database, and things are perfectly usuable. Some caveats: 10) All table must have a primary key. 11) All DataSource use the current opened connection. Having some sort of Connection property to have two DataSource controls on different connection is planned. 12) I think that Gareth could have made his control database neutral. But it is his code, so he is the boss. Regards, Mmm. Sorry for the language mistakes... :-( -- Benoit Minisini -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] Datepicker bug
On mardi 13 janvier 2009, Diego Fernández wrote: Ehh, Well, just finished compiling and testing, and, i have to report that in old projects i just hit the update all forms and everything works as expected, but if i create a new project and insert a datepicker when i trying to run it, it doesnt run and shows a signal 11 error. I attach a debug file follwing the instructions in section reporting a problem on gambas.sf.net Hope that helps. Thanks. It should be fixed in revision #1800. Regards, -- Benoit Minisini -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] Datepicker bug
On mercredi 14 janvier 2009, Diego Fernández wrote: Hi, the signal 11 segmentation is no more, BUT, now when creating a new project, then i insert a datepicker, when running it and try to pick a date, the dialog appears in the upper left corner of the screen no matter where the form is, i am ataching a screenshot so you can check. tell me if i am doing something wrong. thanks. Do you have the same behaviour without compiz? -- Benoit Minisini -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] Datepicker bug
Turning Off the Desktop effects, shows the datepicker in the center of the container (form, frame,etc) Benoit Minisini escribió: On mercredi 14 janvier 2009, Diego Fernández wrote: Hi, the signal 11 segmentation is no more, BUT, now when creating a new project, then i insert a datepicker, when running it and try to pick a date, the dialog appears in the upper left corner of the screen no matter where the form is, i am ataching a screenshot so you can check. tell me if i am doing something wrong. thanks. Do you have the same behaviour without compiz? inline: datepicker.png-- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] Gambas2 components?
12) I think that Gareth could have made his control database neutral. But it is his code, so he is the boss. Gareth subclasses standard Gambas components, so it *is* neutral. I can only think he was confused because he saw a SELECT statement and assumed this particular to MySQL (!) It is possible I've inadvertently done something Postgres can't handle, but this wasn't intentional and isn't something I'm aware of. I would love *not* to have to use SELECT's in the code, however at the time of writing I was unaware of any way to achieve the same effect, although I will review this when I come back to the code ... (the SELECT's etc are pretty generic (!)) Gareth. - Original Message - From: Benoit Minisini gam...@users.sourceforge.net To: dg...@yahoo.com, mailing list for gambas users gambas-user@lists.sourceforge.net Sent: Wednesday, 14 January, 2009 1:55:36 PM GMT +00:00 GMT Britain, Ireland, Portugal Subject: Re: [Gambas-user] Gambas2 components? On mardi 13 janvier 2009, dave L wrote: Hi Charles, Yes i've had a look at the code that is in the database example. by the time i went to be i had in my sample app created a link to the DB from cut i cout pasted into my app from the sample DB. I suppose you have modules you call in that you pass parameters to and it passes back the connection and then other routines you call to fill you form controls with data as shown in the sample refresh form (or whatever it's called). anyways i will have another look at how the table connection is made and recordsets are done. It's the lack of these properties for those actions i was surprised about initially. ps thanks for your reply. dave. Do you really look at the Database example? The standard database-bound controls of Gambas are located in the gb.db.form component. They are somewhat sparse, but here is a quick description: 1) A DataSource container. You specifiy your request there (usually a table), and all data controls inserted in the container will use it. 2) If you put a DataSource A inside another DataSource B, then the DataSource A is filtered by the primary key of the DataSource B. 3) You have a DataControl control, that allows to edit a field by using a control that depends on the field datatype. 4) You have a DataCombo control, that is a ComboBox that displays an integer field by using it as a primary key on another tabl. 5) You have a DataView, that allows to show the contents of a DataSource in a GridView. 6) You have a DataBrowser, that allows to browse its parent DataSource by using a DataView and some buttons. 7) There is a DataComboMulti too in Gambas 3, but I didn't write nor tested it. 8) Theses controls are database neutral. They work with mysql, postgresql, sqlite, firebird... 9) The DataSource is intelligent. It only request the records from the database by small packets. This way, you can put Internet between your application and the database, and things are perfectly usuable. Some caveats: 10) All table must have a primary key. 11) All DataSource use the current opened connection. Having some sort of Connection property to have two DataSource controls on different connection is planned. 12) I think that Gareth could have made his control database neutral. But it is his code, so he is the boss. Regards, -- Benoit Minisini -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user -- Managing Director, Encryptec Limited Tel: 0845 5082719, Mob: 0785 3305393 Email: gar...@encryptec.net Statements made are at all times subject to Encryptec's Terms and Conditions of Business, which are available upon request. -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] Gambas2 components?
On Wednesday 14 January 2009 10:00, Gareth Bult wrote: 12) I think that Gareth could have made his control database neutral. But it is his code, so he is the boss. Gareth subclasses standard Gambas components, so it *is* neutral. I can only think he was confused because he saw a SELECT statement and assumed this particular to MySQL (!) Actually, it's LAST_INSERT_ID() that isn't standard SQL. Rob -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] Gambas2 components?
Ok, This function would be required regardless of the underlying DB .. so what't the PG equivalent ? Gareth. - Original Message - From: Rob sourceforge-raind...@kudla.org To: gambas-user@lists.sourceforge.net Sent: Wednesday, 14 January, 2009 3:22:57 PM GMT +00:00 GMT Britain, Ireland, Portugal Subject: Re: [Gambas-user] Gambas2 components? On Wednesday 14 January 2009 10:00, Gareth Bult wrote: 12) I think that Gareth could have made his control database neutral. But it is his code, so he is the boss. Gareth subclasses standard Gambas components, so it *is* neutral. I can only think he was confused because he saw a SELECT statement and assumed this particular to MySQL (!) Actually, it's LAST_INSERT_ID() that isn't standard SQL. Rob -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user -- Managing Director, Encryptec Limited Tel: 0845 5082719, Mob: 0785 3305393 Email: gar...@encryptec.net Statements made are at all times subject to Encryptec's Terms and Conditions of Business, which are available upon request. -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] Gambas2 components?
On mercredi 14 janvier 2009, Gareth Bult wrote: Ok, This function would be required regardless of the underlying DB .. so what't the PG equivalent ? Gareth. If I remember, not all databases have this feature. If people can tell me how to do the same thing in postgresql, sqlite, odbc and firebird, or at least in postgresql sqlite, I will add it to the gb.db component. Regards, -- Benoit Minisini -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] Gambas2 components?
At which point I'll remove it from GridEdit and it will become DB neutral .. ;-) - Original Message - From: Benoit Minisini gam...@users.sourceforge.net To: mailing list for gambas users gambas-user@lists.sourceforge.net Sent: Wednesday, 14 January, 2009 5:16:44 PM GMT +00:00 GMT Britain, Ireland, Portugal Subject: Re: [Gambas-user] Gambas2 components? On mercredi 14 janvier 2009, Gareth Bult wrote: Ok, This function would be required regardless of the underlying DB .. so what't the PG equivalent ? Gareth. If I remember, not all databases have this feature. If people can tell me how to do the same thing in postgresql, sqlite, odbc and firebird, or at least in postgresql sqlite, I will add it to the gb.db component. Regards, -- Benoit Minisini -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user -- Managing Director, Encryptec Limited Tel: 0845 5082719, Mob: 0785 3305393 Email: gar...@encryptec.net Statements made are at all times subject to Encryptec's Terms and Conditions of Business, which are available upon request. -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] Gambas2 components?
I have been using Gambas 2.8.2 from azores.linex.org repository to write some educational applications for the blind using Ubuntu 8.04 with no problems. However I have been unable to install this on Intrepid even after downgrading libtool as recommended. Will the gambas .deb packages I create on 8.04 still work on 8.10 even though I cannot install Gambas, or does this mean that the apps will only work on 8.04? I suppose if I download the source file myself and install it manually etc it would then work, or will this not work either? If anyone has gambas2 working on Intrepid I would love to know how you did it. drbongo -Original Message- From: Benoit Minisini [mailto:gam...@users.sourceforge.net] Sent: Wed 14/01/2009 17:16 To: mailing list for gambas users Subject: Re: [Gambas-user] Gambas2 components? On mercredi 14 janvier 2009, Gareth Bult wrote: Ok, This function would be required regardless of the underlying DB .. so what't the PG equivalent ? Gareth. If I remember, not all databases have this feature. If people can tell me how to do the same thing in postgresql, sqlite, odbc and firebird, or at least in postgresql sqlite, I will add it to the gb.db component. Regards, -- Benoit Minisini - - This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user Confidentiality: This e-mail and its attachments are intended for the above named only and may be confidential. If they have come to you in error you must take no action based on them, nor must you copy or show them to anyone: please reply to this e-mail and highlight the error to the sender. Security Warning: Please note that e-mail has been created in the knowledge that the Internet e-mail is not a 100% secure communication medium. We advise that you understand and observe this lack of security when e-mailing us. Viruses: Although we have taken steps to ensure that this e-mail and attachments are free from any virus, we advised that in keeping with good computing practice the recipient should ensure they are actually virus free. Confidentiality: This e-mail and its attachments are intended for the above named only and may be confidential. If they have come to you in error you must take no action based on them, nor must you copy or show them to anyone: please reply to this e-mail and highlight the error to the sender. Security Warning: Please note that e-mail has been created in the knowledge that the Internet e-mail is not a 100% secure communication medium. We advise that you understand and observe this lack of security when e-mailing us. Viruses: Although we have taken steps to ensure that this e-mail and attachments are free from any virus, we advised that in keeping with good computing practice the recipient should ensure they are actually virus free. winmail.dat-- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] Gambas2 components?
Fair enough! only reason i picked postgresql over mysql was the old enie menine miney mo. Catch a ... by the tail choice and i end up pointing at postgres :) might not have been the most intellegient choice but i thought i'd give db access a try sooner rather than later. will you be looking at having it more DB nutural in later releases? --- On Wed, 14/1/09, Gareth Bult gar...@encryptec.net wrote: From: Gareth Bult gar...@encryptec.net Subject: Re: [Gambas-user] Gambas2 components? To: mailing list for gambas users gambas-user@lists.sourceforge.net Received: Wednesday, 14 January, 2009, 11:13 PM Erm, what i was suggesting was perhaps an intermediate step until you get your program working right. It's been working right for quite a long time .. my business relies on it working right .. (!) another thing with your editor is that it's filled with mysql specific statements For example? Do yourself a favour - try MySQL! Gareth. - Original Message - From: dave L dg...@yahoo.com To: mailing list for gambas users gambas-user@lists.sourceforge.net Sent: Wednesday, 14 January, 2009 9:38:50 AM GMT +00:00 GMT Britain, Ireland, Portugal Subject: Re: [Gambas-user] Gambas2 components? rom: Gareth Bult gar...@encryptec.net To: mailing list for gambas users gambas-user@lists.sourceforge.net Sent: Wednesday, 14 January, 2009 9:53:09 PM Subject: Re: [Gambas-user] Gambas2 components? Mmm, Maybe it's me, but I'm not seeing anything it doesn't already do ... ??? Agreed except that I couldn't get your app running due to me not having mysql - bummer!!! so i couldn't actually get the project running that i downloaded from the url you gave me. All objects / returned data etc are available to the user .. true it's via method and property calls, but this is the way it should be in an OOP system .. we don't expose raw data(!) what i was suggesting was perhaps an intermediate step until you get your program working right. But i tried it as a sample by making the visible property to false and - got to form_open statement and died!!! So that idea without refinement is dead! another thing with your editor is that it's filled with mysql specific statements (my ignorance is showing here) or do mysql postgres share similar properties? dave. Gareth. - Original Message - From: dave L dg...@yahoo.com To: mailing list for gambas users gambas-user@lists.sourceforge.net Sent: Wednesday, 14 January, 2009 8:32:10 AM GMT +00:00 GMT Britain, Ireland, Portugal Subject: Re: [Gambas-user] Gambas2 components? Hi Garth, got the version listed on the website shown below and able to follow it BUT i don't use mysql but postgres but it's interesting to see what you've done by walking thorough your code as far as i can. Been thinking here and please you or anyone else correct me but couldn't this be done? 1. using the DB demo form and code. import that into your project enter connection strings to enable a valid connection to a RDBMS. having the form hidden at run-time so it's available to use but not visible to the user. 2. using the Rrequest form code as an object (thus allowing multiple table connections) and having the recordset be returned back to the user code for further actions. that could reduce a lot of repeatitive coding for every project. eg. for every DB Control in a programmers project you would either share the recordset (thus a move in 1 control would be the same move in the others) object OR create/have new recordsets for each DB Control. 3. control of writting data into the tables could also be managed via the code within the Frequest code. from my observations it looks doable and with my limited coding knowledge of Gambas be easily incorporated into the next build cycle. * snipped * The closest thing you're going to get for the moment is GridEditor. http://gambasrad.org/software/gambas-grideditor * snipped * Get the world's best email - http://nz.mail.yahoo.com/ -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user -- Managing Director, Encryptec Limited Tel: 0845 5082719, Mob: 0785 3305393 Email: gar...@encryptec.net Statements made are at all times subject to Encryptec's Terms and Conditions of Business, which are available upon request. -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword
Re: [Gambas-user] Gambas2 components?
to dr bongo I think you should create a new topic for this question. I hope benoit won't be angry I answer this way ;) I use the 2.7 Gambas version from a standard ubuntu 8.10 repository, without any downgrading of libtool. You could also use deb http://xoomer.alice.it/pixel intrepid gambas hope this helps Jaap Date: Wed, 14 Jan 2009 17:57:48 + From: tony.sa...@rncb.ac.uk To: gambas-user@lists.sourceforge.net Subject: RE: [Gambas-user] Gambas2 components? I have been using Gambas 2.8.2 from azores.linex.org repository to write some educational applications for the blind using Ubuntu 8.04 with no problems. However I have been unable to install this on Intrepid even after downgrading libtool as recommended. Will the gambas .deb packages I create on 8.04 still work on 8.10 even though I cannot install Gambas, or does this mean that the apps will only work on 8.04? I suppose if I download the source file myself and install it manually etc it would then work, or will this not work either? If anyone has gambas2 working on Intrepid I would love to know how you did it. drbongo -Original Message- From: Benoit Minisini [mailto:gam...@users.sourceforge.net] Sent: Wed 14/01/2009 17:16 To: mailing list for gambas users Subject: Re: [Gambas-user] Gambas2 components? On mercredi 14 janvier 2009, Gareth Bult wrote: Ok, This function would be required regardless of the underlying DB .. so what't the PG equivalent ? Gareth. If I remember, not all databases have this feature. If people can tell me how to do the same thing in postgresql, sqlite, odbc and firebird, or at least in postgresql sqlite, I will add it to the gb.db component. Regards, -- Benoit Minisini -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user Confidentiality: This e-mail and its attachments are intended for the above named only and may be confidential. If they have come to you in error you must take no action based on them, nor must you copy or show them to anyone: please reply to this e-mail and highlight the error to the sender. Security Warning: Please note that e-mail has been created in the knowledge that the Internet e-mail is not a 100% secure communication medium. We advise that you understand and observe this lack of security when e-mailing us. Viruses: Although we have taken steps to ensure that this e-mail and attachments are free from any virus, we advised that in keeping with good computing practice the recipient should ensure they are actually virus free. _ Download de nieuwste emoticons voor in je Messenger http://www.msnmessengerexperience.nl/chuck/ -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
[Gambas-user] Gambas on Intrepid
Sorry, my mistake I forgot to change the subject and then it was too late! My apologies. Last time I looked at the Ubuntu repository it was only 2.0.1 or something like that, and I have been using 8.04 for development and 8.10 for testing and experimenting etc. As long as it is 2.5 or above it has all the features I need. Thanks for the swift response I will install it immediately! :) drbongo -Original Message- From: Jaap Cramer [mailto:jaap_cra...@hotmail.com] Sent: Wed 14/01/2009 18:48 To: gambas-user Subject: Re: [Gambas-user] Gambas2 components? to dr bongo I think you should create a new topic for this question. I hope benoit won't be angry I answer this way ;) I use the 2.7 Gambas version from a standard ubuntu 8.10 repository, without any downgrading of libtool. You could also use deb http://xoomer.alice.it/pixel intrepid gambas hope this helps Jaap Date: Wed, 14 Jan 2009 17:57:48 + From: tony.sa...@rncb.ac.uk To: gambas-user@lists.sourceforge.net Subject: RE: [Gambas-user] Gambas2 components? I have been using Gambas 2.8.2 from azores.linex.org repository to write some educational applications for the blind using Ubuntu 8.04 with no problems. However I have been unable to install this on Intrepid even after downgrading libtool as recommended. Will the gambas .deb packages I create on 8.04 still work on 8.10 even though I cannot install Gambas, or does this mean that the apps will only work on 8.04? I suppose if I download the source file myself and install it manually etc it would then work, or will this not work either? If anyone has gambas2 working on Intrepid I would love to know how you did it. drbongo -Original Message- From: Benoit Minisini [mailto:gam...@users.sourceforge.net] Sent: Wed 14/01/2009 17:16 To: mailing list for gambas users Subject: Re: [Gambas-user] Gambas2 components? On mercredi 14 janvier 2009, Gareth Bult wrote: Ok, This function would be required regardless of the underlying DB .. so what't the PG equivalent ? Gareth. If I remember, not all databases have this feature. If people can tell me how to do the same thing in postgresql, sqlite, odbc and firebird, or at least in postgresql sqlite, I will add it to the gb.db component. Regards, -- Benoit Minisini - - This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user Confidentiality: This e-mail and its attachments are intended for the above named only and may be confidential. If they have come to you in error you must take no action based on them, nor must you copy or show them to anyone: please reply to this e-mail and highlight the error to the sender. Security Warning: Please note that e-mail has been created in the knowledge that the Internet e-mail is not a 100% secure communication medium. We advise that you understand and observe this lack of security when e-mailing us. Viruses: Although we have taken steps to ensure that this e-mail and attachments are free from any virus, we advised that in keeping with good computing practice the recipient should ensure they are actually virus free. _ Download de nieuwste emoticons voor in je Messenger http://www.msnmessengerexperience.nl/chuck/ - - This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user Confidentiality: This e-mail and its attachments are intended for the above named only and may be confidential. If they have come to you in error you must take no action based on them, nor must you copy or show them to anyone: please reply to this e-mail and highlight the error to the sender. Security Warning: Please note that e-mail has been created in the knowledge that the Internet e-mail is not a 100% secure communication medium. We advise that you understand and observe this lack of security when e-mailing us. Viruses: Although we have taken steps to ensure that this e-mail and attachments are free from any virus, we advised that in keeping with good computing practice the recipient should ensure they are actually virus free. Confidentiality: This e-mail and its attachments are intended for the above named only and may be confidential. If they have come to you in error you must take no action based on them, nor must you copy or show them to anyone: please reply to this e-mail and
Re: [Gambas-user] Badly Overridden form (Solved)
On Sun, 11 Jan 2009 09:08:18 am Benoit Minisini wrote: On mercredi 7 janvier 2009, richard terry wrote: Mm Last couple of upgrades one of my forms won't load - despite being structurally similar to all the others, I get the error message in the picture. Any ideas appreciated. Version 1790 and a few below. Regards Richard Did you read my answer about your post More odd IDE problems? The explanation is inside. :-) Benoit, Not quite so simple for my pea brain. I didn't realise that form.X actually referred to a real 'x', albeit a lower case one on my form! I found the source of the problem. I think I'd left this declaration at the top of my form eons ago, whereas I'd usually declare this type of integer only in a subroutine Public x as integer Badly overidden form, whereas Public aw and y z or Private x as integer, dosn't, so persumably x when declared public x means something to gambas. However, the upshot is I can now order requests again Regards richard attachment: overridden_form_this_will_do_it.png-- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
[Gambas-user] Request.Header and Base64Decode for a CGI
Hi, I'm programming a CGI using Gambas2 and I want to implement basic http authentication into it, but I have two problems to get it done: I Don't know how to get Request HTTP Headers (I couldn't find something like Request.Header[]). The other problem is that I haven't been able to find a decoding Base64 function in Gambas. Is there one? Here is a sample code of how I wanted to implement it: PRIVATE SUB Authorize() DIM Validated AS Boolean = FALSE DIM User AS String = user DIM SecretPassword AS String = secret IF Request.Header[Authorization] THEN '--- Request.Header IS AN INVETION IF base64_decode(Request.Header[Authorization]) == (User + SecretPassword) THEN Validated = TRUE '- base64_decode IS AN INVETION TOO ENDIF IF (NOT Validated) THEN Response.AddHeader(WWW-Authenticate, Basic realm=\AgendaXML-WEB\) Response.AddHeader(status, 401 Unauthorized) Response.Begin Response.End QUIT END IF END Regards, Toni PS: I guess I could use the web server authentication mechanisms but I just wondered whether I could control it from within my CGI -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] Request.Header and Base64Decode for a CGI
Thanks for such a quick answer! Toni En/na Benoit Minisini ha escrit: On mercredi 14 janvier 2009, Toni wrote: Hi, I'm programming a CGI using Gambas2 and I want to implement basic http authentication into it, but I have two problems to get it done: I Don't know how to get Request HTTP Headers (I couldn't find something like Request.Header[]). The other problem is that I haven't been able to find a decoding Base64 function in Gambas. Is there one? Here is a sample code of how I wanted to implement it: PRIVATE SUB Authorize() DIM Validated AS Boolean = FALSE DIM User AS String = user DIM SecretPassword AS String = secret IF Request.Header[Authorization] THEN '--- Request.Header IS AN INVETION IF base64_decode(Request.Header[Authorization]) == (User + SecretPassword) THEN Validated = TRUE '- base64_decode IS AN INVETION TOO ENDIF IF (NOT Validated) THEN Response.AddHeader(WWW-Authenticate, Basic realm=\AgendaXML-WEB\) Response.AddHeader(status, 401 Unauthorized) Response.Begin Response.End QUIT END IF END Regards, Toni PS: I guess I could use the web server authentication mechanisms but I just wondered whether I could control it from within my CGI You can't control HTTP authentification from the CGI script. The server must handle it, and you will get the result in the CGI[AUTH_TYPE] and CGI[REMOTE_USER] environmental variables. Regards, -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
[Gambas-user] PB avec un ToolPanel
Bonsoir Benoit, Continuant toujours le développement de mon application, je créer a la volée dans un ToolPanel (fixe) d'un formulaire des TreeView. J'obtiens donc une collection contenant l'adresse Objet de chaque TreeView. Je place chaque TreeView sur des ToolBar différent (Ex: 3 Treeview donc ToolPanel1.count = 3) Par la suite, je veux pouvoir detruire tous les TreeView crées précédemment, ramener le ToolPanel1.count = 1 et recréer de nouveau TreeView. Or je n'arrive pas à detruire les TreeView. Voila ce que j'ai codé pour détruire le TreeView: DIM ToolPanelChildrenIndex AS integer PRINT ToolPanel1.Children.Count = ToolPanel1.Children.Count IF ToolPanel1.Children.Count 0 THEN FOR ToolPanelChildrenIndex = 0 TO (ToolPanel1.Children.count - 1) PRINT ToolPanel1.Children[ToolPanelChildrenIndex] = Str(ToolPanel1.Children[ToolPanelChildrenIndex]) Object.Detach(ToolPanel1.Children[ToolPanelChildrenIndex]) ToolPanel1.Children[ToolPanelChildrenIndex].Delete NEXT END IF ToolPanel1.Count = 1 Merci d'avance pour votre réponse. Olivier Cruilles Mail: linu...@club-internet.fr -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] qt going lgpl
On mercredi 14 janvier 2009, Frank Cox wrote: It appears that qt is to be licensed as lgpl: http://www.qtsoftware.com/about/licensing/frequently-asked-questions Does this meant that commercial closed-source applications can now be developed with Gambas using QT? (I think you could do that using GTK before now.) I don't think so, as the licence is changed only from the QT 4.5 version AFAIK. The QT4 component in the /trunk is experimental and has many problems: color management has changed in QT4, so colors are incorrect ; some things do not display correctly yet ; and on my NVIDIA, QT4 is far slower than QT3, even if double-buffering is disabled. For example, moving the side panels in the IDE becomes slow as hell. By disabling double-buffering, I noticed a lot of useless drawing made by QT 4.4. Maybe these things will be better with QT 4.5 ? The latest beta driver of NVIDIA fixes some problems, but introduce new bugs according to their forum, and I'm not sure that it's NVIDIA fault there as the IDE keeps being slow (more than with GTK+ if you can imagine) even if XRENDER is disabled. -- Benoit Minisini -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] Gambas2 components?
Mmm,
I wouldn't know how to do what GridEditor does without autoinc fields and
last_id .. if other DB's make this difficult or don't provide the
functionality, that sort of reinforces my suggestion that one should choose
MySQL.
Just turning it around for a second, is there any reason why one should *not*
use MySQL?
As a 10yr+ MySQL user, my views may be biased, however to the best of my
knowledge;
a. MySQL is faster than the competition, certainly the likes of Postgres (by a
lot!)
b. MySQL does not crash - so it's reliability is not question
c. Current versions support all the stuff (triggers, stored proc's etc) that
people used to insist was their excuse for Postgres
d. MySQL does loads of back end replication stuff other DB's don't do
e. MySQL runs on more Platforms than any other DB
f. It has bindings for every language I can think of, and then some
g. It has loads of nice GUI tools and designers (commercial and free)
.. etc .. etc .. etc ...
yes I do have the T-shirt, but no they're not paying me.
Bottom line, I have no reason why GridEditor should not support other DB's ,
just so long as they can actually do the job .. so as soon as people with the
relevant expertise provide Gambas with autoinc / lastid support, I'll see if I
can use it in place of a raw SELECT statement .. how's that ? :-)
Gareth.
- Original Message -
From: Rob sourceforge-raind...@kudla.org
To: gambas-user@lists.sourceforge.net
Sent: Wednesday, 14 January, 2009 7:42:27 PM GMT +00:00 GMT Britain, Ireland,
Portugal
Subject: Re: [Gambas-user] Gambas2 components?
On Wednesday 14 January 2009 10:29, Gareth Bult wrote:
This function would be required regardless of the underlying DB .. so
what't the PG equivalent ?
By looking at the sqlite docs, I'm guessing last_insert_rowid() is their
equivalent, but I only have MySQL installed so I can't test it.
But some DB engines don't even have auto-incrementing fields, let alone a
function to return the last inserted ID. Google tells me
CURRVAL(pg_get_serial_sequence('my_tbl_name','id_col_name'))
is the Postgres equivalent, but if it uses sequences, I think that's
different than what we know as autoincrement fields. With Firebird, you
can approximate the functionality with generators, like this:
-- before inserting any rows into table
CREATE GENERATOR generator_id;
-- then, as part of each insert statement
INSERT INTO tablename (keycolumn, ...) VALUES
(gen_id(generator_id, 1), ...);
-- after all that, here's the LAST_INSERT_ID() equivalent
SELECT gen_id(generator_id, 0);
I have no idea whether this is safe to use with multiple connections (like
MySQL's is) or anything like that. I also don't think there's any
standard ODBC mechanism to do this.
Rob
--
This SF.net email is sponsored by:
SourcForge Community
SourceForge wants to tell your story.
http://p.sf.net/sfu/sf-spreadtheword
___
Gambas-user mailing list
Gambas-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gambas-user
--
Managing Director, Encryptec Limited
Tel: 0845 5082719, Mob: 0785 3305393
Email: gar...@encryptec.net
Statements made are at all times subject to Encryptec's Terms and Conditions of
Business, which are available upon request.
--
This SF.net email is sponsored by:
SourcForge Community
SourceForge wants to tell your story.
http://p.sf.net/sfu/sf-spreadtheword
___
Gambas-user mailing list
Gambas-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] Error on gb.db.mysql: Commands out of sync; you can't run this command now
On lundi 12 janvier 2009, David Villalobos Cambronero wrote: Not sure... but what I know for sure is that is not in my Gambas part. Attached is an example using only gb.db I try to take a look in the C part, but I couldn't find anything. Attached is the entire script for my database, and an example. I you connect directly to mysql and execute the last tow statements they work, so I think it is a bug in the C part. MySQL says: If you get Commands out of sync; you can't run this command now in your client code, you are calling client functions in the wrong order. This can happen, for example, if you are using mysql_use_result() and try to execute a new query before you have called mysql_free_result(). It can also happen if you try to execute two queries that return data without calling mysql_use_result() or mysql_store_result() in between. Best Regards -- David Can you make the dump of all mysql requests sent by using DB.Debug = TRUE ? -- Benoit Minisini -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] Gambas2 components?
On jeudi 15 janvier 2009, Gareth Bult wrote: Mmm, I wouldn't know how to do what GridEditor does without autoinc fields and last_id .. if other DB's make this difficult or don't provide the functionality, that sort of reinforces my suggestion that one should choose MySQL. Just turning it around for a second, is there any reason why one should *not* use MySQL? As a 10yr+ MySQL user, my views may be biased, however to the best of my knowledge; a. MySQL is faster than the competition, certainly the likes of Postgres (by a lot!) b. MySQL does not crash - so it's reliability is not question c. Current versions support all the stuff (triggers, stored proc's etc) that people used to insist was their excuse for Postgres d. MySQL does loads of back end replication stuff other DB's don't do e. MySQL runs on more Platforms than any other DB f. It has bindings for every language I can think of, and then some g. It has loads of nice GUI tools and designers (commercial and free) .. etc .. etc .. etc ... yes I do have the T-shirt, but no they're not paying me. Bottom line, I have no reason why GridEditor should not support other DB's , just so long as they can actually do the job .. so as soon as people with the relevant expertise provide Gambas with autoinc / lastid support, I'll see if I can use it in place of a raw SELECT statement .. how's that ? :-) Gareth. 1) How can you know that we should use MySQL if you have used MySQL only? 2) The MySQL C API is, hem... strange. Let be politically correct there. 3) Why did they change their timestamp format suddenly? 4) There is no difference between a BLOB and a large TEXT field. 5) MySQL only get features recently that PostgreSQL had for years. 6) David Villalobos Cambronero got an error message from mysql. I have no idea at all where it comes from. Maybe it is gb.db.mysql fault there, but it makes me angry. :-) Not that PostgreSQL is perfect, far from that. The only clean database API I know is the SQLite one. The funny thing in Gambas is that the gb.db.sqlite component (sorry Niggel!) has used a crappy C++ layer on top! And I don't talk about sticking the word standard with SQL... -- Benoit Minisini -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] Gambas2 components?
1) How can you know that we should use MySQL if you have used MySQL only?
I couldn't, I have however tried (over the years) the other DB's mentioned, PG
in particular.
I just choose not to use any of them commercially given the availability of
MySQL.
Once upon a time I was an Ingres user .. 6 users on a VAX 780 .. memories of
SELECTING 1 record from a small 20 record table taking minutes ... ;-) [pg
being an evolution if Ingress.. ;-) ]
More recently I've used PG with TinyERP .. not a smooth ride.
2) The MySQL C API is, hem... strange. Let be politically correct there.
I tend to access from Python (or Gambas), hence don't find that a problem .. ;-)
3) Why did they change their timestamp format suddenly?
Mmm, don't know. Not something that I've noticed .. but then I don't do a vast
amount with timestamps ...
4) There is no difference between a BLOB and a large TEXT field.
Urm, really?
I was under the impression that Blobs were binary strings and Text's were
character set based?
(i.e. TEXT's support collation and BLOB's don't)
[or is this a bug you're aware of ?]
5) MySQL only get features recently that PostgreSQL had for years.
Not strictly true, version 5.0 has been around for a LONG time, GA was back in
2005 (!)
(and it was available long before that!)
.. before you say but it was 'beta' before that ... in those days MySQL beta's
could wipe the floor with PG releases in terms of reliability (!) .. ;-)
6) David Villalobos Cambronero got an error message from mysql. I have no idea
at all where it comes from. Maybe it is gb.db.mysql fault there, but it makes
me angry. :-)
Is this the commands out of order error?
If it is, might be worth checking his setup before your code .. unless it's
code you've been changing.
I *think* I remember seeing this problem quite some time ago as a result of
communications problem .. I'm sort of guessing at the actual issue (as it was a
while ago) but I think we were playing with IP failover at the time and the IP
of the SQL server was flipping to an alternative SQL server mid-query. From
memory it was a pig to trace as once it had flipped (and we'd not noticed) the
same query would then run fine .. until we experienced another flip mid-query
.. but I might be mixing up incidents ... point being if that could cause it,
other environmental / comms issues might also cause the problem.
Anyway, I know what you mean, but such it the nature of client - server
programming (!)
And I don't talk about sticking the word standard with SQL...
Well .. a lot of it is standard .. it's just all the bits that people found
they needed after they issued ANSI SQL92 ;-)
That said, 6.x is supposed to be fully ANSI once you turn on all the --ansi
flags ... not sure whether that disables MySQL specific extensions like
last_insert_id() tho'...
Apparently in postgres you need to have a field of type serial (or big serial)
[rather than int] and the following code;
SELECT CURRVAL(pg_get_serial_sequence('table','column'));
[where column is the column of type 'serial']
Shouldn't be 'too' hard to implement (?) .. but using a different data type is
a bit of a nuisance ..
Gareth.
- Original Message -
From: Benoit Minisini gam...@users.sourceforge.net
To: mailing list for gambas users gambas-user@lists.sourceforge.net
Sent: Wednesday, 14 January, 2009 11:44:22 PM GMT +00:00 GMT Britain, Ireland,
Portugal
Subject: Re: [Gambas-user] Gambas2 components?
On jeudi 15 janvier 2009, Gareth Bult wrote:
Mmm,
I wouldn't know how to do what GridEditor does without autoinc fields and
last_id .. if other DB's make this difficult or don't provide the
functionality, that sort of reinforces my suggestion that one should choose
MySQL.
Just turning it around for a second, is there any reason why one should
*not* use MySQL?
As a 10yr+ MySQL user, my views may be biased, however to the best of my
knowledge; a. MySQL is faster than the competition, certainly the likes of
Postgres (by a lot!) b. MySQL does not crash - so it's reliability is not
question
c. Current versions support all the stuff (triggers, stored proc's etc)
that people used to insist was their excuse for Postgres d. MySQL does
loads of back end replication stuff other DB's don't do e. MySQL runs on
more Platforms than any other DB
f. It has bindings for every language I can think of, and then some
g. It has loads of nice GUI tools and designers (commercial and free)
.. etc .. etc .. etc ...
yes I do have the T-shirt, but no they're not paying me.
Bottom line, I have no reason why GridEditor should not support other DB's
, just so long as they can actually do the job .. so as soon as people with
the relevant expertise provide Gambas with autoinc / lastid support, I'll
see if I can use it in place of a raw SELECT statement .. how's that ?
:-)
Gareth.
1) How can you know that we should use MySQL if you have used MySQL only?
2) The MySQL C API is, hem... strange. Let be
Re: [Gambas-user] Open GL help needed
Hi Sorry I had send my question twice. I recently enabled the mailing list and thought my message did not get through... I solved my rotation-problem. I had to enable the depth with the line Gl.Enable(Gl.GL_DEPTH_TEST) All rotations (x,y and z, work now properly) Remains the 2 little odd things: * set focus behaviour * gb.sdl.info and gb.sdl.list have to be contained in next ubuntu packages thanks! Jaap Original message: Hi! I've written a litte program wich uses Open GL. I draw the triangle. I discovered some strange behaviour. Nothing is drawn, unless I set the focus on something else, and then on the GlArea. Which is strange, i think. However. That is not my MAIN problem. I dont understand how to use the Gl.Rotatef function. The button 'rotate' switches this function on and off. When it's Off, the triangle is correctly draw. When the value in TRUE, something starts moving, but it is to close: a huge green area, and after a little while it moves left, and then comes back... It looks like a rotation but to close. I hope my description is clear, and someone is able to help me. I use Gambas 2.7, Ubuntu 8.10 And the GambasGears demo is working properly (After I put the gb.sdl.info and gb.sdl.list in /usr/share/gambas2/info. Ubuntu package error). Jaap _ Blijf altijd op de hoogte van wat jouw vrienden doen http://home.live.com -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
[Gambas-user] New bugs in OpenGl
Hi I discovered a new bug in the OpenGl module. I use gl.Color4f(0, 1, 0, iTriangleAlpha) to color a object. The variable iTriangleAlpha does not change the opacity but the size. (see attachment, use slider) Is openGl still being worked on? Jaap _ Download de nieuwste emoticons voor in je Messenger http://www.msnmessengerexperience.nl/chuck/ OpenGLTest-0.0.2.tar.gz Description: GNU Zip compressed data -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
[Gambas-user] Component Web Browser
It seems to me some differences in images rendering , comparing with same html page in Firefox. It dipends from different backend (Gecko and Kde)? Do u think to improve this component? Thankyou Andrea Bertini -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
