Re: [Gambas-user] DataSource & DataBrowser problem

2012-03-15 Thread John Rose
I'm not posting any more to this mailing list about this issue. It's documented in issue 221 of Gambas Issues: https://code.google.com/p/gambas/issues/detail?can=2&start=0&num=100&q=&colspec=ID%20Opened%20Version%20Type%20Status%20Priority%20Summary%20GUI%20Desktop%20Arch%20Dist%20OpSys%20Reporter&

[Gambas-user] DataSource & DataBrowser problem

2012-03-08 Thread John Rose
I just downloaded kendek's latest pre-release version of Gambas3 (3.0.90 +svn20120308+r4538~lucid1) Lucid and it still gave the same issues as below. I have attached a Test project to this message. There are still problems: When the DataBrowser control is initialised, the left hand side of it po

Re: [Gambas-user] DataSource & DataBrowser problem

2012-03-05 Thread John Rose
issues as below. -- Regards, John +44 1902 331266 +44 7894 211434 Forwarded Message From: John Rose To: GambasUsers MailingLists Subject: Re: [Gambas-user] DataSource & DataBrowser problem Date: Fri, 02 Mar 2012 12:38:00 + Benoit, I have attached a Test project to this message

Re: [Gambas-user] DataSource & DataBrowser problem

2012-03-02 Thread John Rose
Benoit, I have attached a Test project to this message. Sometimes I still get the display of a popup stating "Cannot modify record: SQL error or missing database". As I said previously, there are now new problems: When the DataBrowser control is initialised, the left hand side of it points to t

Re: [Gambas-user] DataSource & DataBrowser problem

2012-03-01 Thread Benoît Minisini
Le 01/03/2012 08:49, John Rose a écrit : > Re question on whether I use gb.gtk or gb.qt4: I specified gb.gui only > i.e. neither gb.gtk nor gb.qt4. Since I'm using Ubuntu, I understand > that this results in gb.gtk being used. > I cannot reproduce with gb.gtk what you are talking about. It behaves

[Gambas-user] DataSource & DataBrowser problem

2012-02-29 Thread John Rose
Re question on whether I use gb.gtk or gb.qt4: I specified gb.gui only i.e. neither gb.gtk nor gb.qt4. Since I'm using Ubuntu, I understand that this results in gb.gtk being used. Le 29/02/2012 10:10, John Rose a écrit : > I just installed all Gambas3 packages from kendek's launchpad

Re: [Gambas-user] DataSource & DataBrowser problem

2012-02-29 Thread Benoît Minisini
Le 29/02/2012 10:10, John Rose a écrit : > I just installed all Gambas3 packages from kendek's launchpad ppa for > Gambas pre-release: he created them yesterday evening after using > subversion. How do I find out the version number of Gambas3 that he used > apart from asking him? Ask him : or find

[Gambas-user] DataSource & DataBrowser problem

2012-02-29 Thread John Rose
I just installed all Gambas3 packages from kendek's launchpad ppa for Gambas pre-release: he created them yesterday evening after using subversion. How do I find out the version number of Gambas3 that he used apart from asking him? The previous problem is fixed when I try to add a new row to a SQL

Re: [Gambas-user] DataSource & DataBrowser problem

2012-02-27 Thread Benoît Minisini
Le 27/02/2012 17:18, John Rose a écrit : > Benoit, > > I'm now using kendek's launchpad ppa for Gambas pre-release: he created > latest version on 25 February 2012. I don't know the version number of > Gambas3 that he used and I don't know how to find out (apart from asking > him). I'm reluctant to

[Gambas-user] DataSource & DataBrowser problem

2012-02-27 Thread John Rose
Benoit, I'm now using kendek's launchpad ppa for Gambas pre-release: he created latest version on 25 February 2012. I don't know the version number of Gambas3 that he used and I don't know how to find out (apart from asking him). I'm reluctant to install Gambas3 using subversion & compiling it as

Re: [Gambas-user] DataSource & DataBrowser problem

2012-02-25 Thread Benoît Minisini
Le 07/02/2012 16:25, John Rose a écrit : > Thanks, Benoit, for your explanation. Now that I've deleted the > DataBrowserCountry control& created it again inside the > DataSourceCountry control, I now see the countries (i.e. France& Great > Britain) in the DataBrowserCountry control. > Hi, I hav

Re: [Gambas-user] DataSource & DataBrowser problem

2012-02-10 Thread Беспалов Алексей
My DataBrowser control saved automatic, you can not press save. 10.02.2012, 16:44, "John Rose" : > As I previously said, when I add a new row (by first clicking the New > button in  my DataBrowser control) / change data displayed in my > DataBrowser control and then click the save button (in my Da

[Gambas-user] DataSource & DataBrowser problem

2012-02-10 Thread John Rose
As I previously said, when I add a new row (by first clicking the New button in my DataBrowser control) / change data displayed in my DataBrowser control and then click the save button (in my DataBrowser control), it comes up with a dialog box saying 'Connection not opened' with OK button only (an

[Gambas-user] DataSource & DataBrowser problem

2012-02-07 Thread John Rose
Thanks, Benoit, for your explanation. Now that I've deleted the DataBrowserCountry control & created it again inside the DataSourceCountry control, I now see the countries (i.e. France & Great Britain) in the DataBrowserCountry control. However, when I try to add a new country (e.g. Fz), it moves

Re: [Gambas-user] DataSource & DataBrowser problem

2012-02-06 Thread Benoît Minisini
Le 03/02/2012 20:51, John Rose a écrit : > I've looked at the Database example and I still don't understand how to > use the DataSource& DataBrowser controls. > > My DataSourceCountry control has its Table property set to country (one > of the tables in the Test.db SQLite3 database in the Data dir

[Gambas-user] DataSource & DataBrowser problem

2012-02-06 Thread John Rose
I thought I'd found the solution (when I looked at the documentation again), namely to use the Update & Refresh methods on the controls as per the code below: FMain.ValueBoxLatitude.Value = MDatabase.ResultSite!latitude FMain.DataSourceCountry.Connection = MDatabase.DatabaseConnection FMain.D

[Gambas-user] DataSource & DataBrowser problem

2012-02-05 Thread John Rose
To try & clarify this problem, my code for the button (in my FMain form) click that opens the form which contains the DataSourceCountry & DataBrowserCountry controls is shown below. When the project runs, the FCountryMaintence form is displayed OK except that the DataSourceCountry control is empty

[Gambas-user] DataSource & DataBrowser problem

2012-02-05 Thread John Rose
I found a message from 16 December 2011 re this problem. The author's solution (author is michael) is: "keep all Db access in a separate class called "data" which handles all communication with the database. I then start my apps with a "Main" module not a form. The Main module will load resources

[Gambas-user] DataSource & DataBrowser problem

2012-02-03 Thread John Rose
I've looked at the Database example and I still don't understand how to use the DataSource & DataBrowser controls. My DataSourceCountry control has its Table property set to country (one of the tables in the Test.db SQLite3 database in the Data directory of the attached Test project. In the Form_