On Wed, Aug 8, 2012 at 2:59 PM, Fabien Bodard wrote:
> Le 8 août 2012 04:49, "Adam Ant" a écrit :
>> The answer is:
>>
> It's create
>> rTable=$hConn.create("Inventory",> want to update>)
>> IF rTable.Available then
>> rTable!name=txtName.Text
>> rTable.Update
>> END IF
>>
>
> Don't open/ clo
No no and no
You need to use &1 To limit the quoting problems
Le 8 août 2012 07:32, "Ivan Kern" a écrit :
> Hi,
> Try
> $hConn.Exec("INSERT INTO 'inventory' (your Column) VALUES ('" &
> txtName.Text & "')
>
> Ivan
>
> -Ursprüngliche Nachricht-
> Von: rocko [mailto:sunblast...@gm
Hi,
Try
$hConn.Exec("INSERT INTO 'inventory' (your Column) VALUES ('" &
txtName.Text & "')
Ivan
-Ursprüngliche Nachricht-
Von: rocko [mailto:sunblast...@gmail.com]
Gesendet: Mittwoch, 8. August 2012 05:14
An: mailing list for gambas users
Betreff: Re: [Gambas-user] Adding values to
Le 8 août 2012 04:49, "Adam Ant" a écrit :
>
> On Wed, Aug 8, 2012 at 4:48 AM, rocko wrote:
> 8<
>
> > PUBLIC SUB btnAdd_Click()
> >
> > DIM $hConn AS NEW Connection
> > DIM rTable AS Result
> >
> > $hConn.Open
> >
> > TRY $hConn.Open
> > IF ERROR THEN PRINT "Database cannot be opened.
So should rTable be set as String not Result??
I've tried both and I still can't get the DB to update.
$hConn.Begin
rTable = $hConn.Edit("inventory")
IF rTable.Available THEN
rTable!name = txtName.Text
rTable.Update
ENDIF
$hConn.Commit
FINALLY
$hConn.Close
On We
On Wed, Aug 8, 2012 at 4:48 AM, rocko wrote:
8<
> PUBLIC SUB btnAdd_Click()
>
> DIM $hConn AS NEW Connection
> DIM rTable AS Result
>
> $hConn.Open
>
> TRY $hConn.Open
> IF ERROR THEN PRINT "Database cannot be opened. Error = ", Error.Text
>
> INC Application.Busy
>
>
> $hConn.Begin
On Wed, Aug 8, 2012 at 11:30 AM, Stephen Bungay wrote:
>
>So nothing on this then? It just is what it is?
>
> On 08/04/2012 12:58 PM, Stephen Bungay wrote:
> > Fedora 13
> > Gambas 3.2.90
> > Gnome 2
> >
> > Four input boxes are arranged on a tab, lets call them TextBox1,
> > TextBox2, Tex
So nothing on this then? It just is what it is?
On 08/04/2012 12:58 PM, Stephen Bungay wrote:
> Fedora 13
> Gambas 3.2.90
> Gnome 2
>
> Four input boxes are arranged on a tab, lets call them TextBox1,
> TextBox2, TextBox3 and TextBox4, and this this is the order in which
> they appear in th
No, that doesn't work either:
$hConn.Exec("INSERT INTO inventory VALUES(id, name)", 1, txtName.Text)
On Wed, 2012-08-08 at 01:08 +0200, Emil Lenngren wrote:
> Then you have to specify what column you want to insert to.
> Syntax: http://www.w3schools.com/sql/sql_insert.asp
>
> The &1, &2 ... syst
Then you have to specify what column you want to insert to.
Syntax: http://www.w3schools.com/sql/sql_insert.asp
The &1, &2 ... system used by gambas is to provide correct escaping and to
prevent sql injections.
2012/8/8 rocko
> No, there are several.
> I justed wanted to test it with the first
Oh yes '&' not '$', that was a typo.
In my code it's '&'.
Still can't get this to work.
Here is my full code:
PUBLIC SUB btnConnect_Click()
'DIM sName AS String
DIM $hConn AS NEW Connection
WITH $hConn
.Type = "sqlite"
.Host = "/home/rocko/DataBases"
.Name = "plant_trax"
Hello,
> Tried your suggestion:
> $hConn.Exec("INSERT INTO inventory VALUES($1)", txtName.Text)
I think it's wrong because you write this one: VALUES($1) and it's
VALUES(&1)
Cordialement,
Olivier Cruilles
Mail: linu...@club-internet.fr
Le 8 août 2012 à 00:46, rocko a écrit :
> No, the
No, there are several.
I justed wanted to test it with the first column to see if it works,
which it doesn't.
Tried your suggestion:
$hConn.Exec("INSERT INTO inventory VALUES($1)", txtName.Text)
Values are still not inserting.
On Wed, 2012-08-08 at 00:31 +0200, Emil Lenngren wrote:
> Try
>
>
Try
$hConn.Begin
$hConn.Exec("INSERT INTO inventory VALUES(&1)", txtName.Text)
$hConn.Commit
Do you only have one column in that table?
2012/8/8 rocko
> Ok I tried this:
> $hConn.Begin
> $hConn.Exec("INSERT INTO inventory VALUES(name)", txtName.Text)
> $hConn.Commit
>
> Without suc
Ok I tried this:
$hConn.Begin
$hConn.Exec("INSERT INTO inventory VALUES(name)", txtName.Text)
$hConn.Commit
Without success.
On Tue, 2012-08-07 at 23:09 +0200, M. Cs. wrote:
> I use to add fields like this:
> $hConn.Begin
> $hConn.Exec("INSERT INTO mytable VALUES(&1,&2,..&N)",var1,var2,...v
I use to add fields like this:
$hConn.Begin
$hConn.Exec("INSERT INTO mytable VALUES(&1,&2,..&N)",var1,var2,...varN)
$hConn.Commit
And I use Begin and Commit only for the large amount of insertions.
Csaba
2012/8/7 rocko
> Having a bit of trouble with trying to get Ganbas to add a value to a
> fi
Updates:
Status: WontFix
Comment #1 on issue 295 by benoit.m...@gmail.com: Problem on inheritance
http://code.google.com/p/gambas/issues/detail?id=295
Yep. Actually you should not be able to re-implement a class that has been
already used as a parent for another class.
I will add an er
On Tue, Aug 7, 2012 at 5:00 PM, Tobias Boege
wrote:
> On Tue, 07 Aug 2012, Emil Lenngren wrote:
>> I tried to install
>> http://tomv.home.xs4all.nl/raspberry/gambas3_3.1.1-1_armel.deb on Raspbian
>> but I got "package architecture (armel) does not match system (armhf)".
>> When I tried with "--for
On Tue, 07 Aug 2012, Emil Lenngren wrote:
> I tried to install
> http://tomv.home.xs4all.nl/raspberry/gambas3_3.1.1-1_armel.deb on Raspbian
> but I got "package architecture (armel) does not match system (armhf)".
> When I tried with "--force-architecture", I got a lot of dependency errors,
> but t
Having a bit of trouble with trying to get Ganbas to add a value to a
field in a table.
I have a sqlite DB with a table named 'inventory' with field names like:
'name', 'start_date', 'end_date' and so on.
I'm trying to add values to the fields using a interface, I have a text
box to add a name to
Hmm. I don't have gb2 on my machine anymore, so I can't tell why it isn't
centered.
Btw: you should update to gb3, it's much better!
Example code for a ShowModal window:
Create a form FMain with just two buttons (btnCancel and btnInput).
Then create a form FInput with the Text "What's your name?
I tried to install
http://tomv.home.xs4all.nl/raspberry/gambas3_3.1.1-1_armel.deb on Raspbian
but I got "package architecture (armel) does not match system (armhf)".
When I tried with "--force-architecture", I got a lot of dependency errors,
but the files were installed.
Running "gambas3" prints:
"
Updates:
Status: Fixed
Comment #2 on issue 294 by benoit.m...@gmail.com: Sidpanels jump inside a
tabstrip
http://code.google.com/p/gambas/issues/detail?id=294
Fixed in revision #5016.
--
Live Security Virtual
Thanks for the reply Matti-4.
I am using Gambas 2.23, Ubuntu 12.04, Gnome 3.
Can you give me any example code of the 'xyz.ShowModal'?
Thanks for any help.
Matti-4 wrote:
>
> What is your Gambas version and your environment?
> Here (Gambas 3, OpenSuse 12.1, KDE), the InputBox is correctly ce
Le 7 août 2012 à 13:00, Patrik Karlsson a écrit :
> I have read about getting Gambas running on OS X and while browsing the svn
> log of Gambas I found the lines below.
>
> * NEW: Add support for the MacPorts distribution.
> * NEW: it is now available for Mac OS X 10.8
> * BUG: Fix detection of
Christoher,
i installed simly with apt-get and seems to work.
gbr3 -V , gbr3 --help behave as expected.
> If your project doesn't uses any other Gambas3 components all you
> need is the gb3-runtime installed.
Ok, here i was not sure at all. I think all components activatet and used
during devel
I have read about getting Gambas running on OS X and while browsing the svn
log of Gambas I found the lines below.
* NEW: Add support for the MacPorts distribution.
* NEW: it is now available for Mac OS X 10.8
* BUG: Fix detection of X11 for the control DrawingArea on Mac OS X 10.8.
* BUG: Fix com
> -Original Message-
> From: Tobias Boege [mailto:tobiasboeg...@googlemail.com]
> Sent: Monday, August 06, 2012 4:36 PM
> To: mailing list for gambas users
> Subject: Re: [Gambas-user] Declaring external C libraries
>
>
> On Mon, 06 Aug 2012, Christer Johansson wrote:
> >
> >
> > > --
> What minimum do i need to run a Gambas3 project, developed on
> OpenSuse /Gambas 3-IDE on a Raspberry-Dbian system ?
>
> So far i installed gb3-runtime on the debian system and tried
> to run a project.gambas executable using gbr3 ./project.gambas,
> but this does not work. "No project file i
29 matches
Mail list logo
