Re: [Gambas-user] DataBrowser Out of Bounds error
On Mon, Oct 22, 2018 at 1:17 AM Benoît Minisini wrote: > > Le 22/10/2018 à 00:43, Markus Schatten a écrit : > > Dear all, > > > > I'm having a weird "Out of bounds" error in the DataBrowser. I'm using > > the DataBrowser with a PostgreSQL database to edit tables. The error > > occurs only if I add a new row (with a click on the empty row), enter > > data for a few columns, then go back to edit some previous column and > > then press enter to store the whole row. > > > > For example if I have the following table: > > > > table | Col A | Col B | Col C > > -- > > > > And enter data in a new row, say: > > > > > > table | Col A | Col B | Col C > > -- > > Val 1 | Val 2 | Val 3 > > > > Then (before storing the row) go back to edit say Col A: > > > > table | Col A | Col B | Col C > > -- > > Val 4 | Val 2 | Val 3 > > > > An then move to Col C and press enter to store the row I get an Out of > > Bounds Error. Weirdly, the row gets stored in the table, but the app > > crashes... > > > > What am I doing wrong? > > [...] > > Can you send a dump of your database? Not all the contents, but at least > the table definition. > Sorry for the delay. It happens with any table I use, regardless of definition if it has more than two editable columns. It actually happened on multiple occasions in a class of students where each student had his/her own database with different table definitions. Here is an example where it happens: CREATE TABLE person ( email TEXT PRIMARY KEY, first TEXT NOT NULL, last TEXT NOT NULL, country TEXT, city TEXT, sex VARCHAR( 6 ) ); All the best, M. ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] DataBrowser Out of Bounds error
Le 22/10/2018 à 00:43, Markus Schatten a écrit : Dear all, I'm having a weird "Out of bounds" error in the DataBrowser. I'm using the DataBrowser with a PostgreSQL database to edit tables. The error occurs only if I add a new row (with a click on the empty row), enter data for a few columns, then go back to edit some previous column and then press enter to store the whole row. For example if I have the following table: table | Col A | Col B | Col C -- And enter data in a new row, say: table | Col A | Col B | Col C -- Val 1 | Val 2 | Val 3 Then (before storing the row) go back to edit say Col A: table | Col A | Col B | Col C -- Val 4 | Val 2 | Val 3 An then move to Col C and press enter to store the row I get an Out of Bounds Error. Weirdly, the row gets stored in the table, but the app crashes... What am I doing wrong? [...] Can you send a dump of your database? Not all the contents, but at least the table definition. Thanks. -- Benoît Minisini ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
[Gambas-user] DataBrowser Out of Bounds error
Dear all, I'm having a weird "Out of bounds" error in the DataBrowser. I'm using the DataBrowser with a PostgreSQL database to edit tables. The error occurs only if I add a new row (with a click on the empty row), enter data for a few columns, then go back to edit some previous column and then press enter to store the whole row. For example if I have the following table: table | Col A | Col B | Col C -- And enter data in a new row, say: table | Col A | Col B | Col C -- Val 1 | Val 2 | Val 3 Then (before storing the row) go back to edit say Col A: table | Col A | Col B | Col C -- Val 4 | Val 2 | Val 3 An then move to Col C and press enter to store the row I get an Out of Bounds Error. Weirdly, the row gets stored in the table, but the app crashes... What am I doing wrong? A MWE is here: https://www.dropbox.com/s/wrvtxfysstop1rh/ DataBrowserBug.zip?dl=1 Sys info is below: [System] Gambas=3.11.2 OperatingSystem=Linux Kernel=4.13.0-46-generic Architecture=x86_64 Distribution=Ubuntu 17.10 Desktop=UBUNTU:GNOME Theme=Gtk Language=en_US.UTF-8 Memory=7776M [Libraries] Cairo=libcairo.so.2.11400.10 Curl=libcurl.so.4.4.0 DBus=libdbus-1.so.3.14.13 GStreamer=libgstreamer-1.0.so.0.1203.0 GTK+2=libgtk-x11-2.0.so.0.2400.31 GTK+3=libgtk-3.so.0.2200.25 OpenGL=libGL.so.1.2.0 Poppler=libpoppler.so.68.0.0 QT4=libQtCore.so.4.8.7 QT5=libQt5Core.so.5.9.1 SDL=libSDL-1.2.so.0.11.4 SQLite=libsqlite3.so.0.8.6 [Environment] CLUTTER_IM_MODULE=xim COLORTERM=truecolor DBUS_SESSION_BUS_ADDRESS=unix:path=/run/user/1000/bus DESKTOP_AUTOSTART_ID=10c3cd5ab16d17385815397173682738830026530008 DESKTOP_SESSION=ubuntu DISPLAY=:0 GB_GUI=gb.qt4 GDMSESSION=ubuntu GNOME_DESKTOP_SESSION_ID=this-is-deprecated GNOME_SHELL_SESSION_MODE=ubuntu GTK_IM_MODULE=ibus HOME= IM_CONFIG_PHASE=2 JOURNAL_STREAM=9:34675 LANG=en_US.UTF-8 LC_ADDRESS=hr_HR.UTF-8 LC_IDENTIFICATION=hr_HR.UTF-8 LC_MEASUREMENT=hr_HR.UTF-8 LC_MONETARY=hr_HR.UTF-8 LC_NAME=hr_HR.UTF-8 LC_NUMERIC=hr_HR.UTF-8 LC_PAPER=hr_HR.UTF-8 LC_TELEPHONE=hr_HR.UTF-8 LC_TIME=hr_HR.UTF-8 LESSCLOSE=/usr/bin/lesspipe %s %s LESSOPEN=| /usr/bin/lesspipe %s LOGNAME= LS_COLORS=rs=0:di=01;34:ln=01;36:mh=00:pi=40;33:so=01;35:do= 01;35:bd=40;33;01:cd=40;33;01:or=40;31;01:mi=00:su=37;41:sg= 30;43:ca=30;41:tw=30;42:ow=34;42:st=37;44:ex=01;32:*.tar=01; 31:*.tgz=01;31:*.arc=01;31:*.arj=01;31:*.taz=01;31:*.lha= 01;31:*.lz4=01;31:*.lzh=01;31:*.lzma=01;31:*.tlz=01;31:*. txz=01;31:*.tzo=01;31:*.t7z=01;31:*.zip=01;31:*.z=01;31:*. Z=01;31:*.dz=01;31:*.gz=01;31:*.lrz=01;31:*.lz=01;31:*.lzo= 01;31:*.xz=01;31:*.zst=01;31:*.tzst=01;31:*.bz2=01;31:*.bz= 01;31:*.tbz=01;31:*.tbz2=01;31:*.tz=01;31:*.deb=01;31:*. rpm=01;31:*.jar=01;31:*.war=01;31:*.ear=01;31:*.sar=01;31: *.rar=01;31:*.alz=01;31:*.ace=01;31:*.zoo=01;31:*.cpio=01; 31:*.7z=01;31:*.rz=01;31:*.cab=01;31:*.jpg=01;35:*.jpeg= 01;35:*.mjpg=01;35:*.mjpeg=01;35:*.gif=01;35:*.bmp=01;35:*. pbm=01;35:*.pgm=01;35:*.ppm=01;35:*.tga=01;35:*.xbm=01;35: *.xpm=01;35:*.tif=01;35:*.tiff=01;35:*.png=01;35:*.svg= 01;35:*.svgz=01;35:*.mng=01;35:*.pcx=01;35:*.mov=01;35:*. mpg=01;35:*.mpeg=01;35:*.m2v=01;35:*.mkv=01;35:*.webm=01; 35:*.ogm=01;35:*.mp4=01;35:*.m4v=01;35:*.mp4v=01;35:*.vob= 01;35:*.qt=01;35:*.nuv=01;35:*.wmv=01;35:*.asf=01;35:*.rm= 01;35:*.rmvb=01;35:*.flc=01;35:*.avi=01;35:*.fli=01;35:*. flv=01;35:*.gl=01;35:*.dl=01;35:*.xcf=01;35:*.xwd=01;35:*. yuv=01;35:*.cgm=01;35:*.emf=01;35:*.ogv=01;35:*.ogx=01;35: *.aac=00;36:*.au=00;36:*.flac=00;36:*.m4a=00;36:*.mid=00;36: *.midi=00;36:*.mka=00;36:*.mp3=00;36:*.mpc=00;36:*.ogg= 00;36:*.ra=00;36:*.wav=00;36:*.oga=00;36:*.opus=00;36:*.spx= 00;36:*.xspf=00;36: NO_PROXY=localhost,127.0.0.0/8,::1 OLDPWD= PATH=/bin:/bin:/usr/local/sbin:/usr/local/bin: /usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games:/ snap/bin:/Downloads/Flora-2/XSB/bin/:/Downloads/Flora-2/flora2/ PWD=/the-baze QT4_IM_MODULE=xim QT_IM_MODULE=ibus SESSION_MANAGER=local/:@/tmp/.ICE-unix/2653,unix/:/tmp/. ICE-unix/2653 SHELL=/bin/bash SHLVL=2 SSH_AUTH_SOCK=/run/user/1000/keyring/ssh S_COLORS=auto TERM=xterm-256color TEXTDOMAIN=im-config TEXTDOMAINDIR=/usr/share/locale/ TZ=:/etc/localtime USER= USERNAME= VTE_VERSION=4804 WAYLAND_DISPLAY=wayland-0 XDG_CONFIG_DIRS=/etc/xdg/xdg-ubuntu:/etc/xdg XDG_CURRENT_DESKTOP=ubuntu:GNOME XDG_DATA_DIRS=/usr/share/ubuntu:/usr/local/share:/usr/ share:/var/lib/snapd/desktop XDG_MENU_PREFIX=gnome- XDG_RUNTIME_DIR=/run/user/1000 XDG_SEAT=seat0 XDG_SESSION_DESKTOP=ubuntu XDG_SESSION_ID=6 XDG_SESSION_TYPE=wayland XDG_VTNR=2 XMODIFIERS=@im=ibus _=/usr/bin/gambas3 no_proxy=localhost,127.0.0.0/8,::1 All the best, M. -- Markus Schatten, PhD Associate professor and head of Artificial Intelligence Lab University of Zagreb Faculty of Organization and Informatics Pavlinska 2, 42000 Varazdin, Croatia http://www.foi.hr/nastavnici/schatten.markus/index.html http://www.researchgate.net/profile/Markus_Schatten1 http://ai.foi.
Re: [Gambas-user] DataBrowser Help Again
Le 16/12/2014 13:59, Fabien Bodard a écrit : > I have problems on setting the database connection property on > databrowser too. when the cell lose the focus the connection name > desapear. > > so then i can't choose table name ! > It should be fixed in revision #6761. Regards, -- Benoît Minisini -- Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration & more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] DataBrowser Help Again
Hi Fabien, The Datasource connection problem is happening here too... The same as you. But I solved that declaring the conenction by code. Public ConnectionName As Connection = New Connection ConnectionName.Host = Application.Path ConnectionName.name = "Yourdatabase.sqlite" Connectionname.type = "sqlite3" DataSourceX.Connection = ConnectionName Best regards, Christian 2014-12-16 12:55 GMT-02:00, gambas-user-requ...@lists.sourceforge.net : > Send Gambas-user mailing list submissions to > gambas-user@lists.sourceforge.net > > To subscribe or unsubscribe via the World Wide Web, visit > https://lists.sourceforge.net/lists/listinfo/gambas-user > or, via email, send a message with subject or body 'help' to > gambas-user-requ...@lists.sourceforge.net > > You can reach the person managing the list at > gambas-user-ow...@lists.sourceforge.net > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of Gambas-user digest..." > > > Today's Topics: > >1. Re: Where are the examples? (Ron) >2. Re: Where are the examples? (rolf) >3. Re: DataBrowser Help Again (Fabien Bodard) >4. Re: Where are the examples? (Jussi Lahtinen) >5. Re: Where are the examples? (Beno?t Minisini) >6. SerialPort: RS232 DTR problem (Tobias Boege) > > > -- > > Message: 1 > Date: Tue, 16 Dec 2014 13:33:02 +0100 > From: Ron > Subject: Re: [Gambas-user] Where are the examples? > To: mailing list for gambas users > Message-ID: > > Content-Type: text/plain; charset=UTF-8 > > Benoit, > Watch out getting to close to the visualbasic way of thinking. > Please keep things simple and logical... > Examples are the first thing new users will look for.. Don't make them hard > to find. ;P > > Regards, > Ron > Op 16 dec. 2014 12:51 schreef "Beno?t Minisini" < > gam...@users.sourceforge.net>: > >> Le 16/12/2014 12:31, rolf a ?crit : >> >>> Hello Beno?t >>> >>> yesterday evening I compiled Gambas from trunk and no examples have >>> been >>>>> installed. >>>>> >>>>> Also the menue entry "open example" has gone. >>>>> >>>>> Working with the Software Farm makes me crazy. After an installation >>>>> I >>>>> do not find the program and the source code either. Where will the >>>>> programs be installed? >>>>> >>>> >>> There is a new bookmark "installed programs" in the project open >>> dialog. >>>> This is where installed programs... are installed. >>>> >>> >>> But the entry is empty?? after install of a program from the software >>> farm >>> (see attached screenshots) >>> >> >> There... >> >> -- >> Beno?t Minisini >> >> >> -- >> Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server >> from Actuate! Instantly Supercharge Your Business Reports and Dashboards >> with Interactivity, Sharing, Native Excel Exports, App Integration & more >> Get technology previously reserved for billion-dollar corporations, FREE >> >> http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk >> ___ >> Gambas-user mailing list >> Gambas-user@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/gambas-user >> >> > > > -- > > Message: 2 > Date: Tue, 16 Dec 2014 13:48:45 +0100 > From: rolf > Subject: Re: [Gambas-user] Where are the examples? > To: mailing list for gambas users > Message-ID: <201412161348.46352.rolf.fr...@t-online.de> > Content-Type: Text/Plain; charset="utf-8" > > Hello Beno?t > >> >>> yesterday evening I compiled Gambas from trunk and no examples have >> >>> been installed. >> >>> >> >>> Also the menue entry "open example" has gone. >> >>> >> >>> Working with the Software Farm makes me crazy. After an installation >> >>> I >> >>> do not find the program and the source code either. Where will the >> >>> programs be installed? >> >> >> >> There is a new bookmark "installed programs" in the project open >> >> dialog. >> >> This is w
Re: [Gambas-user] DataBrowser Help Again
I have problems on setting the database connection property on databrowser too. when the cell lose the focus the connection name desapear. so then i can't choose table name ! 2014-12-15 22:23 GMT+01:00 T Lee Davidson : > Hello Christian, > > I did not have any success getting the IDE to give me any options for the > Connection property. (The list was always blank.) So, I set it > programmatically. > > With your app, on the form, make sure the DataSource control is the parent > of the DataBrowser. > > Sample project attached. > > > -- > Lee > __ > > "Artificial Intelligence is no match for natural stupidity." > > > > On 12/14/2014 03:31 PM, Christian e Ana Luiza Britto wrote: >> >> Hi Benoît Minisini and everybody >> >> Yes, I've tried to follow the Database example. If I run it it works, >> but my app still doesn't work. I'm using Gambas version 3.6.90. >> >> When I try to inform the Datasource connection name property via IDE >> the database connection I inform is not maintained, when I click in >> other place the name I just typed before just disappear... :( >> >> Please, can you send me a very simple code sample for me to try to follow? >> There's something very obvious that I'm not understanding... >> >> Christian >> >> >> Le 14/12/2014 13:34, Christian e Ana Luiza Britto a écrit : >>> >>> Hi, >>> I'm trying to make a form with a DataBrowser to edit fields in a >>> SqLite 3 table. I've tryed everything... I made a connection, put the >>> datasource container in a form with the Databrowser within with the >>> columns and labels names but nothing happen. It doesn't work. >>> >>> Please, someone can share with me the correct coding to make the >>> connection, create the DataSource and make the Databrowser to work? >>> I'm trying for a few days now... :( >>> Best regards from Brazil, >>> Chrisian De Britto >>> >> >> Did you look at the 'Database' example? >> > > -- > Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server > from Actuate! Instantly Supercharge Your Business Reports and Dashboards > with Interactivity, Sharing, Native Excel Exports, App Integration & more > Get technology previously reserved for billion-dollar corporations, FREE > http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk > ___ > Gambas-user mailing list > Gambas-user@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/gambas-user > -- Fabien Bodard -- Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration & more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] DataBrowser Help Again
Hello Christian, I did not have any success getting the IDE to give me any options for the Connection property. (The list was always blank.) So, I set it programmatically. With your app, on the form, make sure the DataSource control is the parent of the DataBrowser. Sample project attached. -- Lee __ "Artificial Intelligence is no match for natural stupidity." On 12/14/2014 03:31 PM, Christian e Ana Luiza Britto wrote: Hi Benoît Minisini and everybody Yes, I've tried to follow the Database example. If I run it it works, but my app still doesn't work. I'm using Gambas version 3.6.90. When I try to inform the Datasource connection name property via IDE the database connection I inform is not maintained, when I click in other place the name I just typed before just disappear... :( Please, can you send me a very simple code sample for me to try to follow? There's something very obvious that I'm not understanding... Christian Le 14/12/2014 13:34, Christian e Ana Luiza Britto a écrit : Hi, I'm trying to make a form with a DataBrowser to edit fields in a SqLite 3 table. I've tryed everything... I made a connection, put the datasource container in a form with the Databrowser within with the columns and labels names but nothing happen. It doesn't work. Please, someone can share with me the correct coding to make the connection, create the DataSource and make the Databrowser to work? I'm trying for a few days now... :( Best regards from Brazil, Chrisian De Britto Did you look at the 'Database' example? DatabaseSample-1.0.1.tar.gz Description: GNU Zip compressed data -- Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration & more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
[Gambas-user] DataBrowser Help Again
Hi Benoît Minisini and everybody Yes, I've tried to follow the Database example. If I run it it works, but my app still doesn't work. I'm using Gambas version 3.6.90. When I try to inform the Datasource connection name property via IDE the database connection I inform is not maintained, when I click in other place the name I just typed before just disappear... :( Please, can you send me a very simple code sample for me to try to follow? There's something very obvious that I'm not understanding... Christian Le 14/12/2014 13:34, Christian e Ana Luiza Britto a écrit : > Hi, > I'm trying to make a form with a DataBrowser to edit fields in a > SqLite 3 table. I've tryed everything... I made a connection, put the > datasource container in a form with the Databrowser within with the > columns and labels names but nothing happen. It doesn't work. > > Please, someone can share with me the correct coding to make the > connection, create the DataSource and make the Databrowser to work? > I'm trying for a few days now... :( > Best regards from Brazil, > Chrisian De Britto > Did you look at the 'Database' example? -- Benoît Minisini -- Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration & more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] DataBrowser Help
Le 14/12/2014 13:34, Christian e Ana Luiza Britto a écrit : > Hi, > I'm trying to make a form with a DataBrowser to edit fields in a > SqLite 3 table. I've tryed everything... I made a connection, put the > datasource container in a form with the Databrowser within with the > columns and labels names but nothing happen. It doesn't work. > > Please, someone can share with me the correct coding to make the > connection, create the DataSource and make the Databrowser to work? > I'm trying for a few days now... :( > Best regards from Brazil, > Chrisian De Britto > Did you look at the 'Database' example? -- Benoît Minisini -- Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration & more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
[Gambas-user] DataBrowser Help
Hi, I'm trying to make a form with a DataBrowser to edit fields in a SqLite 3 table. I've tryed everything... I made a connection, put the datasource container in a form with the Databrowser within with the columns and labels names but nothing happen. It doesn't work. Please, someone can share with me the correct coding to make the connection, create the DataSource and make the Databrowser to work? I'm trying for a few days now... :( Best regards from Brazil, Chrisian De Britto -- Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration & more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] DataBrowser bugs
> gb 2.17 Debian sid > qt > SQL requests are written, not using intrinsic > postgresql 8.4.1 > table test( > id serial primary key, > label varchar(8) not null, > date_cre timestamp default now(), > date_mod timestamp default NULL, > mri_users_cre integer default 1, > mri_users_mod integer default NULL, > front boolean default true > ); > == > Hi, > > Former state: > rows 1-7 have values, > rows 8-10 have been deleted > DataBrowser have all table fields but only display: label & front => > WITH datbro_Civ.GridView > ' La colonne 'id' est là pour retourner une réf, pas pour être vue > .Columns[0].Width = 0 > .Columns[0].Resizable = FALSE > .Columns[1].Text = "Civilités" > .Columns[1].Width = 175 > .Columns[1].Resizable = FALSE > ' Y'a ptêt une autre manière pour avoir accès à ces champs > ' que de les cacher, mais je ne sais pas comment (?) > .Columns[2].Width = 0 > .Columns[2].Resizable = FALSE > .Columns[3].Width = 0 > .Columns[3].Resizable = FALSE > .Columns[4].Width = 0 > .Columns[4].Resizable = FALSE > .Columns[5].Width = 0 > .Columns[5].Resizable = FALSE > ' La dernière colonne est tjrs visible même à largeur 0 :( (bug? => > oui) ' donc comme on en a que 2 à afficher sur 6, il faut que la 2nde > soit la dernière (évangile selon St-Gridview) ' ET ne pas oublier de > changer l'ordre des champs dans le DataBrowser .Columns[6].Text = "Devant > ?" > .Columns[6].Width = -1 > .Columns[6].Resizable = FALSE > END WITH > > INSERT into table => Refresh of DataBrowser shows new row ONLY when > it is ascending sorted on 'label' > (descendant order don't show it AND is totally false - even in an ASCII > way!) > > Sort by 'front' => New row doesn't appear anymore AND descending order > is totally false (shows: True, False, F..., False, True) > > Making the primary key column visible don't change anything. > > Well, after a small test, any descending order is *always* false :( > > ie ascending: > Co. > GmBH > Inc. > SA > SARL > sarl2 > sarl3 > SAS > sro > > descending: > SARL > SA > sro > GmBH > Inc. > Co. > SAS > sarl2 > sarl2 > > as a matter of fact is seems to be superseded by primary key ascending > order. so it is truly unusable at all. > > JY > I don't see at all what you are talking about. Please provide a full project and the SQL data needed to run it. If you prefer, explain what you are trying to achieve on the french mailing-list. Regards, -- Benoît Minisini -- Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
[Gambas-user] DataBrowser bugs
gb 2.17 Debian sid qt SQL requests are written, not using intrinsic postgresql 8.4.1 table test( id serial primary key, label varchar(8) not null, date_cre timestamp default now(), date_mod timestamp default NULL, mri_users_cre integer default 1, mri_users_mod integer default NULL, front boolean default true ); == Hi, Former state: rows 1-7 have values, rows 8-10 have been deleted DataBrowser have all table fields but only display: label & front => WITH datbro_Civ.GridView ' La colonne 'id' est là pour retourner une réf, pas pour être vue .Columns[0].Width = 0 .Columns[0].Resizable = FALSE .Columns[1].Text = "Civilités" .Columns[1].Width = 175 .Columns[1].Resizable = FALSE ' Y'a ptêt une autre manière pour avoir accès à ces champs ' que de les cacher, mais je ne sais pas comment (?) .Columns[2].Width = 0 .Columns[2].Resizable = FALSE .Columns[3].Width = 0 .Columns[3].Resizable = FALSE .Columns[4].Width = 0 .Columns[4].Resizable = FALSE .Columns[5].Width = 0 .Columns[5].Resizable = FALSE ' La dernière colonne est tjrs visible même à largeur 0 :( (bug? => oui) ' donc comme on en a que 2 à afficher sur 6, il faut que la 2nde soit la dernière (évangile selon St-Gridview) ' ET ne pas oublier de changer l'ordre des champs dans le DataBrowser .Columns[6].Text = "Devant ?" .Columns[6].Width = -1 .Columns[6].Resizable = FALSE END WITH INSERT into table => Refresh of DataBrowser shows new row ONLY when it is ascending sorted on 'label' (descendant order don't show it AND is totally false - even in an ASCII way!) Sort by 'front' => New row doesn't appear anymore AND descending order is totally false (shows: True, False, F..., False, True) Making the primary key column visible don't change anything. Well, after a small test, any descending order is *always* false :( ie ascending: Co. GmBH Inc. SA SARL sarl2 sarl3 SAS sro descending: SARL SA sro GmBH Inc. Co. SAS sarl2 sarl2 as a matter of fact is seems to be superseded by primary key ascending order. so it is truly unusable at all. JY -- No group of professionals meets except to conspire against the public at large. -- Mark Twain -- Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] DataBrowser question
On Wed, 2009-10-14 at 16:16 +0200, Ricardo Díaz Martín wrote: > If someone needs it I can put here . I'd like to see it. > Note the component is in spanish ;-) I'm sure the code will speak for itself :) -- Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] DataBrowser question
On Wed, 2009-10-14 at 18:08 +0200, Matti wrote: > DataSource1.ReadOnly = TRUE > and the buttons are gone. Ah! Absolutely brilliant. Thank you. It's not exactly clear in the documentation, and I searched everywhere before asking. I've sent an email to "gam...@users.sourceforge.net" to request signup to work on the documentation so I clarify these things as I go. It's the least I can do. > nospam.nospam.nos...@gmail.com schrieb: > > Is there a way to selectively disable the buttons on the navigation > > panel shown on a DataBrowser? I want to allow users to move forward and > > back through the data but not add, delete or save changes. > > > > Thanks for your assistance. > > -- > Come build with us! The BlackBerry(R) Developer Conference in SF, CA > is the only developer event you need to attend this year. Jumpstart your > developing skills, take BlackBerry mobile applications to market and stay > ahead of the curve. Join us from November 9 - 12, 2009. Register now! > http://p.sf.net/sfu/devconference > ___ > Gambas-user mailing list > Gambas-user@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/gambas-user -- Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] DataBrowser question
Gracias colega. Regards 2009/10/14 Ricardo Díaz Martín > Jorge, > > You got it. There are more subs/functions you need but I hope you can > extract you want. Please note there is a class TipoString that is only used > to pass a string by reference (I'm using gambas2) > > Regards, > Ricardo > > El 14 de octubre de 2009 17:56, Jorge Carrión escribió: > > > Ricardo: > > I'm interested in your component. I have done something like this, and I > > like to compare. > > Thanks > > > > > > 2009/10/14 Ricardo Díaz Martín > > > > > I use for do this no contol box. I got a form with a grid view with two > > > columns (first length = 0) and I got a funtion that open the form fill > > the > > > gridvied with available values (at fist row the key and at the second > the > > > visible value for the user) and send to the form the value you choice. > In > > > the form a put a textbox and a find button in order the user can find > > > values > > > at the list. The grid can be filled from a SQL or a coma-separated > > string. > > > > > > I use this component in all my apps. > > > > > > If someone needs it I can put here . Note the component is in spanish > ;-) > > > > > > Regards, > > > Ricardo > > > > > > 2009/10/14 nospam.nospam.nos...@gmail.com < > > nospam.nospam.nos...@gmail.com> > > > > > > > Is there a way to selectively disable the buttons on the navigation > > > > panel shown on a DataBrowser? I want to allow users to move forward > and > > > > back through the data but not add, delete or save changes. > > > > > > > > Thanks for your assistance. > > > > > > > > > > > > > > > > > > > > > > -- > > > > Come build with us! The BlackBerry(R) Developer Conference in SF, CA > > > > is the only developer event you need to attend this year. Jumpstart > > your > > > > developing skills, take BlackBerry mobile applications to market and > > stay > > > > ahead of the curve. Join us from November 9 - 12, 2009. Register now! > > > > http://p.sf.net/sfu/devconference > > > > ___ > > > > Gambas-user mailing list > > > > Gambas-user@lists.sourceforge.net > > > > https://lists.sourceforge.net/lists/listinfo/gambas-user > > > > > > > > > > > > > -- > > > Come build with us! The BlackBerry(R) Developer Conference in SF, CA > > > is the only developer event you need to attend this year. Jumpstart > your > > > developing skills, take BlackBerry mobile applications to market and > stay > > > ahead of the curve. Join us from November 9 - 12, 2009. Register now! > > > http://p.sf.net/sfu/devconference > > > ___ > > > Gambas-user mailing list > > > Gambas-user@lists.sourceforge.net > > > https://lists.sourceforge.net/lists/listinfo/gambas-user > > > > > > > > -- > > Come build with us! The BlackBerry(R) Developer Conference in SF, CA > > is the only developer event you need to attend this year. Jumpstart your > > developing skills, take BlackBerry mobile applications to market and stay > > ahead of the curve. Join us from November 9 - 12, 2009. Register now! > > http://p.sf.net/sfu/devconference > > ___ > > Gambas-user mailing list > > Gambas-user@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/gambas-user > > > > > -- > Come build with us! The BlackBerry(R) Developer Conference in SF, CA > is the only developer event you need to attend this year. Jumpstart your > developing skills, take BlackBerry mobile applications to market and stay > ahead of the curve. Join us from November 9 - 12, 2009. Register now! > http://p.sf.net/sfu/devconference > ___ > Gambas-user mailing list > Gambas-user@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/gambas-user > > -- Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] DataBrowser question
Jorge, You got it. There are more subs/functions you need but I hope you can extract you want. Please note there is a class TipoString that is only used to pass a string by reference (I'm using gambas2) Regards, Ricardo El 14 de octubre de 2009 17:56, Jorge Carrión escribió: > Ricardo: > I'm interested in your component. I have done something like this, and I > like to compare. > Thanks > > > 2009/10/14 Ricardo Díaz Martín > > > I use for do this no contol box. I got a form with a grid view with two > > columns (first length = 0) and I got a funtion that open the form fill > the > > gridvied with available values (at fist row the key and at the second the > > visible value for the user) and send to the form the value you choice. In > > the form a put a textbox and a find button in order the user can find > > values > > at the list. The grid can be filled from a SQL or a coma-separated > string. > > > > I use this component in all my apps. > > > > If someone needs it I can put here . Note the component is in spanish ;-) > > > > Regards, > > Ricardo > > > > 2009/10/14 nospam.nospam.nos...@gmail.com < > nospam.nospam.nos...@gmail.com> > > > > > Is there a way to selectively disable the buttons on the navigation > > > panel shown on a DataBrowser? I want to allow users to move forward and > > > back through the data but not add, delete or save changes. > > > > > > Thanks for your assistance. > > > > > > > > > > > > > > > -- > > > Come build with us! The BlackBerry(R) Developer Conference in SF, CA > > > is the only developer event you need to attend this year. Jumpstart > your > > > developing skills, take BlackBerry mobile applications to market and > stay > > > ahead of the curve. Join us from November 9 - 12, 2009. Register now! > > > http://p.sf.net/sfu/devconference > > > ___ > > > Gambas-user mailing list > > > Gambas-user@lists.sourceforge.net > > > https://lists.sourceforge.net/lists/listinfo/gambas-user > > > > > > > > -- > > Come build with us! The BlackBerry(R) Developer Conference in SF, CA > > is the only developer event you need to attend this year. Jumpstart your > > developing skills, take BlackBerry mobile applications to market and stay > > ahead of the curve. Join us from November 9 - 12, 2009. Register now! > > http://p.sf.net/sfu/devconference > > ___ > > Gambas-user mailing list > > Gambas-user@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/gambas-user > > > > -- > Come build with us! The BlackBerry(R) Developer Conference in SF, CA > is the only developer event you need to attend this year. Jumpstart your > developing skills, take BlackBerry mobile applications to market and stay > ahead of the curve. Join us from November 9 - 12, 2009. Register now! > http://p.sf.net/sfu/devconference > ___ > Gambas-user mailing list > Gambas-user@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/gambas-user > gambas.tar.gz Description: GNU Zip compressed data -- Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] DataBrowser question
DataSource1.ReadOnly = TRUE and the buttons are gone. nospam.nospam.nos...@gmail.com schrieb: > Is there a way to selectively disable the buttons on the navigation > panel shown on a DataBrowser? I want to allow users to move forward and > back through the data but not add, delete or save changes. > > Thanks for your assistance. -- Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] DataBrowser question
Ricardo: I'm interested in your component. I have done something like this, and I like to compare. Thanks 2009/10/14 Ricardo Díaz Martín > I use for do this no contol box. I got a form with a grid view with two > columns (first length = 0) and I got a funtion that open the form fill the > gridvied with available values (at fist row the key and at the second the > visible value for the user) and send to the form the value you choice. In > the form a put a textbox and a find button in order the user can find > values > at the list. The grid can be filled from a SQL or a coma-separated string. > > I use this component in all my apps. > > If someone needs it I can put here . Note the component is in spanish ;-) > > Regards, > Ricardo > > 2009/10/14 nospam.nospam.nos...@gmail.com > > > Is there a way to selectively disable the buttons on the navigation > > panel shown on a DataBrowser? I want to allow users to move forward and > > back through the data but not add, delete or save changes. > > > > Thanks for your assistance. > > > > > > > > > -- > > Come build with us! The BlackBerry(R) Developer Conference in SF, CA > > is the only developer event you need to attend this year. Jumpstart your > > developing skills, take BlackBerry mobile applications to market and stay > > ahead of the curve. Join us from November 9 - 12, 2009. Register now! > > http://p.sf.net/sfu/devconference > > ___ > > Gambas-user mailing list > > Gambas-user@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/gambas-user > > > > -- > Come build with us! The BlackBerry(R) Developer Conference in SF, CA > is the only developer event you need to attend this year. Jumpstart your > developing skills, take BlackBerry mobile applications to market and stay > ahead of the curve. Join us from November 9 - 12, 2009. Register now! > http://p.sf.net/sfu/devconference > ___ > Gambas-user mailing list > Gambas-user@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/gambas-user > -- Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] DataBrowser question
I use for do this no contol box. I got a form with a grid view with two columns (first length = 0) and I got a funtion that open the form fill the gridvied with available values (at fist row the key and at the second the visible value for the user) and send to the form the value you choice. In the form a put a textbox and a find button in order the user can find values at the list. The grid can be filled from a SQL or a coma-separated string. I use this component in all my apps. If someone needs it I can put here . Note the component is in spanish ;-) Regards, Ricardo 2009/10/14 nospam.nospam.nos...@gmail.com > Is there a way to selectively disable the buttons on the navigation > panel shown on a DataBrowser? I want to allow users to move forward and > back through the data but not add, delete or save changes. > > Thanks for your assistance. > > > > -- > Come build with us! The BlackBerry(R) Developer Conference in SF, CA > is the only developer event you need to attend this year. Jumpstart your > developing skills, take BlackBerry mobile applications to market and stay > ahead of the curve. Join us from November 9 - 12, 2009. Register now! > http://p.sf.net/sfu/devconference > ___ > Gambas-user mailing list > Gambas-user@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/gambas-user > -- Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
[Gambas-user] DataBrowser question
Is there a way to selectively disable the buttons on the navigation panel shown on a DataBrowser? I want to allow users to move forward and back through the data but not add, delete or save changes. Thanks for your assistance. -- Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] DataBrowser
Yes, I remember the old days in VB. It was very simple, when you used the result of a SQL query as DataSource. I will install Gambas3. Thanks. Benoît Minisini schrieb: >>> No, Charlie, >>> I didn't mean the headers. I know how to rename them. >>> >>> What I meant is: >>> In my DataSource table I have a field "ProducerID". >>> That points to another table "Producers" with the key field "id" and the >>> field "Name". Now I would like to have the Column "Producers.Name" in the >>> list instead of "ProducerID". I mean the field values of the records, not >>> the headers. >> In Gambas 3, the Table property of a DataSource can be any SQL request. >> >> In Gambas 2, I'm afraid there is no simple solution. But try this: use your >> own DataView control, and create an Observer on the GridView of the >> DataView control - you get it with the DataView.GridView property. Then >> catch the Data event with the Observer: by using the Row property, you will > . > /|\ > | > Read 'Column' instead ---' > >> know if you are in the ProducerID column, and then you can replace the >> displayed data with the name of the producer by setting the >> GridView.Data.Text property. >> >> Regards, > > > -- Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] Databrowser/Gridview events?
Jean-Yves F. Barbier wrote: > Ron a écrit : > >> Is it possible to catch events from a DataBrowser object? >> >> Lets say >> PUBLIC SUB DataBrowser1_MouseUp() >> ... >> END >> PUBLIC SUB DataBrowser1_DblClick() >> ... >> END >> >> The docs say those are valid but I cannot get it to work, they dont seem >> to get called, anyone use these? >> >> Gambas 2.15.2, qt. >> > > Wild guess: they're preempted by the sorting command it applies to a column > when you click on its header. > > JY > Ok, found it out myself just now. I wanted to catch a click on a row of a DataBrowsers GridView so I can display an image alongside with the name of the text in column 0 of the row clicked. So I implemented an Observer to peek at the DataBrowser.GridView events, and it worked! Something like this: PRIVATE hObserver AS Observer PUBLIC SUB Form_Open() hObserver = NEW Observer(DataBrowser1.GridView) AS "GridObserver" END PUBLIC SUB GridObserver_Click() DisplayProduct(DataBrowser1.GridView[DataBrowser1.GridView.Row, 0].Text) END I love this language! Regards, Ron_2nd. -- Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] DataBrowser
> > No, Charlie, > > I didn't mean the headers. I know how to rename them. > > > > What I meant is: > > In my DataSource table I have a field "ProducerID". > > That points to another table "Producers" with the key field "id" and the > > field "Name". Now I would like to have the Column "Producers.Name" in the > > list instead of "ProducerID". I mean the field values of the records, not > > the headers. > > In Gambas 3, the Table property of a DataSource can be any SQL request. > > In Gambas 2, I'm afraid there is no simple solution. But try this: use your > own DataView control, and create an Observer on the GridView of the > DataView control - you get it with the DataView.GridView property. Then > catch the Data event with the Observer: by using the Row property, you will . /|\ | Read 'Column' instead ---' > know if you are in the ProducerID column, and then you can replace the > displayed data with the name of the producer by setting the > GridView.Data.Text property. > > Regards, -- Benoît -- Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] DataBrowser
> No, Charlie, > I didn't mean the headers. I know how to rename them. > > What I meant is: > In my DataSource table I have a field "ProducerID". > That points to another table "Producers" with the key field "id" and the > field "Name". Now I would like to have the Column "Producers.Name" in the > list instead of "ProducerID". I mean the field values of the records, not > the headers. > In Gambas 3, the Table property of a DataSource can be any SQL request. In Gambas 2, I'm afraid there is no simple solution. But try this: use your own DataView control, and create an Observer on the GridView of the DataView control - you get it with the DataView.GridView property. Then catch the Data event with the Observer: by using the Row property, you will know if you are in the ProducerID column, and then you can replace the displayed data with the name of the producer by setting the GridView.Data.Text property. Regards, -- Benoît -- Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] DataBrowser
Mathias Ebermann a écrit : > No, Charlie, > I didn't mean the headers. I know how to rename them. > > What I meant is: > In my DataSource table I have a field "ProducerID". > That points to another table "Producers" with the key field "id" and the > field "Name". > Now I would like to have the Column "Producers.Name" in the list instead of > "ProducerID". > I mean the field values of the records, not the headers. I'm afraid you have to use a view, Mathias; but if there's another solution I'm interested in too. JY -- -- Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] DataBrowser
No, Charlie, I didn't mean the headers. I know how to rename them. What I meant is: In my DataSource table I have a field "ProducerID". That points to another table "Producers" with the key field "id" and the field "Name". Now I would like to have the Column "Producers.Name" in the list instead of "ProducerID". I mean the field values of the records, not the headers. Charlie Reinl schrieb: > Am Montag, den 31.08.2009, 21:52 +0200 schrieb Mathias Ebermann: >> Hi, >> >> DataBrowser is a really great tool.You don't need any code for displaying >> the fields of records, depending on what the user >> clicks in the GridView.. >> >> But since DataBrowser uses only ONE table (set in DataSource), I can't find >> a way to display for example "Producer.Name" in >> the GridView instead of "ProducerID". >> >> Is there any possibility to show a reference to another table in the >> DataBrowser.GridView? >> >> Thannks for help >> Matti > > Salut Mathias, > > this is out of examples/Database/FTest if you mean the headers text > > PUBLIC SUB Form_Open() > > WITH DataBrowser2.GridView > .Columns[0].Text = "Color" > END WITH > > WITH DataBrowser1.GridView > .Columns[0].Text = "Id" > .Columns[0].Width = 48 > .Columns[1].Text = "Active" > .Columns[2].Text = "Name" > .Columns[3].Text = "Firstname" > .Columns[4].Text = "Birthday" > END WITH > > END > > -- Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] DataBrowser
Am Montag, den 31.08.2009, 21:52 +0200 schrieb Mathias Ebermann: > Hi, > > DataBrowser is a really great tool.You don't need any code for displaying the > fields of records, depending on what the user > clicks in the GridView.. > > But since DataBrowser uses only ONE table (set in DataSource), I can't find a > way to display for example "Producer.Name" in > the GridView instead of "ProducerID". > > Is there any possibility to show a reference to another table in the > DataBrowser.GridView? > > Thannks for help > Matti Salut Mathias, this is out of examples/Database/FTest if you mean the headers text PUBLIC SUB Form_Open() WITH DataBrowser2.GridView .Columns[0].Text = "Color" END WITH WITH DataBrowser1.GridView .Columns[0].Text = "Id" .Columns[0].Width = 48 .Columns[1].Text = "Active" .Columns[2].Text = "Name" .Columns[3].Text = "Firstname" .Columns[4].Text = "Birthday" END WITH END -- Amicalment Charlie -- Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
[Gambas-user] DataBrowser
Hi, DataBrowser is a really great tool.You don't need any code for displaying the fields of records, depending on what the user clicks in the GridView.. But since DataBrowser uses only ONE table (set in DataSource), I can't find a way to display for example "Producer.Name" in the GridView instead of "ProducerID". Is there any possibility to show a reference to another table in the DataBrowser.GridView? Thannks for help Matti -- Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
[Gambas-user] Databrowser/Gridview events?
Is it possible to catch events from a DataBrowser object? Lets say PUBLIC SUB DataBrowser1_MouseUp() ... END PUBLIC SUB DataBrowser1_DblClick() ... END The docs say those are valid but I cannot get it to work, they dont seem to get called, anyone use these? Gambas 2.15.2, qt. Regards, Ron_2nd. -- Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] Databrowser/Gridview events?
Ron a écrit : > Is it possible to catch events from a DataBrowser object? > > Lets say > PUBLIC SUB DataBrowser1_MouseUp() > ... > END > PUBLIC SUB DataBrowser1_DblClick() > ... > END > > The docs say those are valid but I cannot get it to work, they dont seem > to get called, anyone use these? > > Gambas 2.15.2, qt. Wild guess: they're preempted by the sorting command it applies to a column when you click on its header. JY -- You are here: *** *** * *** * *** * But you're not all there. -- Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
[Gambas-user] DataBrowser toolbar
Hi, How can I access the buttons of a DataBrowser ToolBar in order to forbid/modify some actions? JY -- -- Enter the BlackBerry Developer Challenge This is your chance to win up to $100,000 in prizes! For a limited time, vendors submitting new applications to BlackBerry App World(TM) will have the opportunity to enter the BlackBerry Developer Challenge. See full prize details at: http://p.sf.net/sfu/Challenge ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
[Gambas-user] Databrowser
When I insert a databrowser into my project I sometime do not see all the control icons and currently on some when all are there the "new" does seem to work Anyone help Thanks Rodney Rundstrom -- Stay on top of everything new and different, both inside and around Java (TM) technology - register by April 22, and save $200 on the JavaOne (SM) conference, June 2-5, 2009, San Francisco. 300 plus technical and hands-on sessions. Register today. Use priority code J9JMT32. http://p.sf.net/sfu/p ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] databrowser toolbar - delete
Hi Nando I don't know exactly if this behavior could be changed, but, why don't you use a tableview or gridview instead? I think it may be not so difficult to implement the same functionality in a custom toolbar. Regards Jesús nando escribió: > hi, > is there a way when i press the del button in the toolbar not to delete > the register in the database but modify the register to set it as > inactive? > Thank you > > > > -- > Stay on top of everything new and different, both inside and > around Java (TM) technology - register by April 22, and save > $200 on the JavaOne (SM) conference, June 2-5, 2009, San Francisco. > 300 plus technical and hands-on sessions. Register today. > Use priority code J9JMT32. http://p.sf.net/sfu/p > ___ > Gambas-user mailing list > Gambas-user@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/gambas-user > -- Stay on top of everything new and different, both inside and around Java (TM) technology - register by April 22, and save $200 on the JavaOne (SM) conference, June 2-5, 2009, San Francisco. 300 plus technical and hands-on sessions. Register today. Use priority code J9JMT32. http://p.sf.net/sfu/p ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
[Gambas-user] databrowser toolbar - delete
hi, is there a way when i press the del button in the toolbar not to delete the register in the database but modify the register to set it as inactive? Thank you -- Stay on top of everything new and different, both inside and around Java (TM) technology - register by April 22, and save $200 on the JavaOne (SM) conference, June 2-5, 2009, San Francisco. 300 plus technical and hands-on sessions. Register today. Use priority code J9JMT32. http://p.sf.net/sfu/p ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user