in the IDE->menu->tools->softwarefarm-> then search
do you are female jessacandelearia ?
due then a female "+" in the gambas community
Lenz McKAY Gerardo (PICCORO)
http://qgqlochekone.blogspot.com
2017-08-23 1:10 GMT-04:00 Tobias Boege :
> On Wed, 23 Aug 2017, Jessa wrote:
> > Good day, how to
On Wed, 23 Aug 2017, Jessa wrote:
> Good day, how to create a simple database with picture in gambas?
>
Have you seen the example project called "PictureDatabase" on the
software farm?
--
"There's an old saying: Don't change anything... ever!" -- Mr. Monk
--
Good day, how to create a simple database with picture in gambas?
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
___
Hello to all,
every time I open my database in the IDE manager (File>Open file), Gambas
creates a new connection, as you can see from the locate command.[0]
Is this correct behavior? I do something wrong?
I attach SQLite test.
Regards
Gianluigi
[0] ~$ locate CiccioFormaggio
/home/gian/Scrivania/
Dear Benoît
Life is so easy, .. if you have the right answers.
Thanks a lot and have a nice weekend.
Regards,
Hubert
PS:
Thanks also to all 'Gambinos'. Great Job!
(I bow humbly before the Creation.)
Am 13.12.2013 19:15,schrieb Beno=EEt_Minisini:
> Le 13/12/2013 18:24, u...@gmx.ch a écrit :
>>
Le 13/12/2013 18:24, u...@gmx.ch a écrit :
> Dear cracks
>
> In Gambas2 I found the gambas-database-manager under tools,
> but nowhere in Gambas 3.5.1 anymore.
> Did I miss something at installation?
>
> Redoing an MSAccess-project, I'm using Gambas3, MariaDB and
> PhpMyAdmin. Missing is a visualiz
Dear cracks
In Gambas2 I found the gambas-database-manager under tools,
but nowhere in Gambas 3.5.1 anymore.
Did I miss something at installation?
Redoing an MSAccess-project, I'm using Gambas3, MariaDB and
PhpMyAdmin. Missing is a visualization-tool for the relational
links. Any recommendations
I've solved this. I was using the Exec method (invoking a select
statement) to obtain ResultSite: the documentation says that this is
therefore read-only i.e. as the run-time error says. So I've changed the
Exec to Edit with the appropriate changes to its parameters. It now
works OK.
I've just not
I would check the permissions on all your database tables. Also check and
make sure the table files are writable.
I know I've seen this kind of error on MySQL DBs when someone copies files
from one machine or user to another.
On Thu, Feb 2, 2012 at 4:01 AM, Shane Powell wrote:
> On 02/02/12 2
On 02/02/12 22:49, John Rose wrote:
> I think that I've narrowed down this problem on the attached Test
> project. The run time error on the starred line below is an error
> message stating "Update database site table record error"& "Error:
> Result is read-only":
> Public Sub ButtonSave_Click()
>
I think that I've narrowed down this problem on the attached Test
project. The run time error on the starred line below is an error
message stating "Update database site table record error" & "Error:
Result is read-only":
Public Sub ButtonSave_Click()
Dim latitude As Float
Inc Application.Busy
I'm using Gambas3.0. I have a database table Site with structure:
CREATE TABLE site(_id Integer Primary Key AutoIncrement, site Text Not
Null, latitude Float, longitude Float, image Blob, description Text,
locality_id Integer, Foreign Key(locality_id) References locality(_id)
On Delete Cascade On U
Le 20/01/2012 10:01, Andrea Bertini a écrit :
> During the table's editing if you try to delete all the fields from the
> last, program exit.
>
> Andrea Bertini
>
It should be fixed in revision #4415.
Regards,
--
Benoît Minisini
-
During the table's editing if you try to delete all the fields from the
last, program exit.
Andrea Bertini
--
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Micros
Thanks Caveat!
This little helped to me!
A good example is worthy a thousand words!
Csaba
2012/1/19, Caveat :
> As Benoit says...
>
>> SQL quoting is automatically done by the following methods of the
>> Connection class: Exec(), Find(), Edit(), Delete(), Subst(), provided
>> that:
>
>> - You use
As Benoit says...
> SQL quoting is automatically done by the following methods of the
> Connection class: Exec(), Find(), Edit(), Delete(), Subst(), provided
> that:
> - You use "&1", "&2"... inside the request string to tell where
> quoted arguments must be inserted.
> - You actually pass thes
Some more clarification of my problem:
I had two procedures to communicate with the sqlite database:
Public Sub Trans(be As String) As String
Dim atmen As String
atmen = Replace$(be, "$", ".")
atmen = Replace$(atmen, "€", "-")
atmen = Replace$(atmen, "_", " ")
atmen = Replace$(atmen, "£", "/")
atm
I'm sorry Benoit,
I would like to ask your help with this kind of insertions:
If I have a table called MyTable with creation:
CREATE TABLE CENTRAL(VName Text,FPath TEXT,FName TEXT,FSubs
INTEGER,FSize REAL,FChanged TEXT);
How could I ensure the failsafe insert query with following fields:
VName->
Yes, Benoit. I'll check the documentation, since I always used the
Myconnection.Exec("SELECT FROM table WHERE field='"& myvar & "';) form
of the querying, and now I would like to change it to a more
convenient way, since I always had to assure myvar is safe.
2012/1/18, Benoît Minisini :
> Le 18/01
Le 18/01/2012 14:17, M. Cs. a écrit :
> Hi!
> Is there any built in function in Gambas3 which can secure the
> database connection from the errors caused by special characters?
>
> I have written functions for replacing the dangerous characters like
> ', +, . and so on, but I'd like to know whether
users
Reply-To: mailing list for gambas users
Subject: Re: [Gambas-user] Database question
M. Cs. wrote:
> Hi!
> Is there any built in function in Gambas3 which can secure the
> database connection from the errors caused by special characters?
>
> I have written functions for rep
M. Cs. wrote:
> Hi!
> Is there any built in function in Gambas3 which can secure the
> database connection from the errors caused by special characters?
>
> I have written functions for replacing the dangerous characters like
> ', +, . and so on, but I'd like to know whether there is a way to make
Hi!
Is there any built in function in Gambas3 which can secure the
database connection from the errors caused by special characters?
I have written functions for replacing the dangerous characters like
', +, . and so on, but I'd like to know whether there is a way to make
queries secure from failu
On Sat, 2011-10-01 at 23:58 +0200, Benoît Minisini wrote:
> > On Tue, 2011-09-27 at 12:37 +0930, Bruce Bruen wrote:
> > > 1) In gambas2, I could get the database manager to "Make gambas code"
> > > which was very handy, I can't find this feature in gambas3. Is it
> > > removed?
>
> More exactly,
> On Tue, 2011-09-27 at 12:37 +0930, Bruce Bruen wrote:
> > 1) In gambas2, I could get the database manager to "Make gambas code"
> > which was very handy, I can't find this feature in gambas3. Is it
> > removed?
More exactly, I had never enough time to make it again. And as I don't use
it... Ma
On Tue, 2011-09-27 at 12:37 +0930, Bruce Bruen wrote:
> 1) In gambas2, I could get the database manager to "Make gambas code"
> which was very handy, I can't find this feature in gambas3. Is it
> removed?
> 2) In the gambas2 database manager I can expand the height of a row in
> the data view, I
1) In gambas2, I could get the database manager to "Make gambas code"
which was very handy, I can't find this feature in gambas3. Is it
removed?
2) In the gambas2 database manager I can expand the height of a row in
the data view, I can't seem to do this in the gambas3 version. Is this
intention
Thanks for the tip Fabien! It is indeed simpler... it still doesn't
work but it's definitely nicer-looking code which I'll bear in mind for
if, errrm of course I mean when, I get it working!
I just reported another segfault to Benoit, perhaps in fixing that
something will start to work...
Thank
While res.Available
res.MoveNext
Print "Field1: " & res["Field1"]
Wend
me i do that :
For each res
Print "Field1:" & res!Field1
next
It's more simple no ?
2011/7/1 Caveat :
> Hi,
>
> I'm trying to get database access to an ODBC datasource (have been
> trying for a few days now).
>
>
I swapped the order of the lines here:
While res.Available
res.MoveNext
Print "Field1: " & res["Field1"]
Wend
to do the Print then MoveNext, as it would have caused me to 'lose' my
first line of data. As I'm not getting any results at all, it doesn't
actually make a difference right now...(a
Hi,
I'm trying to get database access to an ODBC datasource (have been
trying for a few days now).
I have the simplest Access (.mdb) database in the world: one table
called people, with an id, a first name, a last name, and a phone
number. There is no password on the database. I can see data in
> I have been trying to get up to speed with Gambas by playing with the
> examples provided in the distribution. I noticed that the connect screen
> for the database example seems to have a problem selecting the first
> item from the drop down list. If I click on a item below the first item
> it wo
I have been trying to get up to speed with Gambas by playing with the
examples provided in the distribution. I noticed that the connect screen
for the database example seems to have a problem selecting the first
item from the drop down list. If I click on a item below the first item
it works. I can
El 16/10/10 19:07, Biro Zoltan escribió:
> Hi!
>
> I'm trying to write a small code using a database on a server (small
> home network).
>
> On the server machine I have installed: Ubuntu 10.10, Apache2,
> Mysql-server version 5.1.49. Here in my.cnf I deleted the row containing
> "bind-address=
Hi!
I'm trying to write a small code using a database on a server (small
home network).
On the server machine I have installed: Ubuntu 10.10, Apache2,
Mysql-server version 5.1.49. Here in my.cnf I deleted the row containing
"bind-address=127.0.0.1". This machine have the local IP address:
192.1
Hi Tobias
Fabien is correct in saying it's a kind of library.
For Gambas2 in my Ubuntu installation, the following libraries are
automatically installed along with Gambas2:
gambas2-gb-db
gambas2-gb-db-postgresql
gambas2-gb-db-firebird
gambas2-gb-db-mysql
gambas2-gb-db-form
gambas2-gb-db-odbc
gam
2010/9/12 tobias :
> hi,
>
>> It's a kind of lbrary ... you select gb.db in thecomponents.
>>
>>
>> then
>>
>> private hcon as new connection
>>
>>
>> Publc sub Main()
>>
>> hCon.type = "sqlite3"
>> hCon.Host=user.home &/ "dbpath"
>> hcon.Name = "mydatabase"
>> hcon.open
>>
>> end
>>
>
> ye
hi,
> It's a kind of lbrary ... you select gb.db in thecomponents.
>
>
> then
>
> private hcon as new connection
>
>
> Publc sub Main()
>
> hCon.type = "sqlite3"
> hCon.Host=user.home &/ "dbpath"
> hcon.Name = "mydatabase"
> hcon.open
>
> end
>
yeah, so this 'kind of library' it l
It's a kind of lbrary ... you select gb.db in thecomponents.
then
private hcon as new connection
Publc sub Main()
hCon.type = "sqlite3"
hCon.Host=user.home &/ "dbpath"
hcon.Name = "mydatabase"
hcon.open
end
2010/9/12 tobias :
> hi,
>
> another question about the databases and gambas
hi,
another question about the databases and gambas to the developers:
how do i have to imagine exactly the interaction between the (sqlite)
driver and my gambas program? what exactly is this 'driver'? is it just
a kind of library? (sorry, i'm not so good at this level and i never had
to do any
hi,
> The biggest help for him will be to read a sql book :)... it was for
> me the only way to quit the M$ ADO in the past. But gb.db and result
> is suffisely powerfull to manage most part of the db capabilities in a
> first time . Then he can learn sql do to more.
>
>
> All depend of the proj
Hi Benoît
> But I don't think I can change the interface anymore, it will break a lot
> of code. Unless someone finds an unexpected solution.
What about a property, which indicate how the result should be delivered. For
example in PHP Database Objects you can give a value that says how the data
> the next question.
> i got a result from a database with some records predefined (fields are
> id (serial) and name (string)):
>
> hResult = hConnection.Exec("select * from test")
>
> in a for loop i go through all the records by doing:
>
> FOR iCount = 0 TO hResult.Count - 1 STEP 1
> hResul
The biggest help for him will be to read a sql book :)... it was for
me the only way to quit the M$ ADO in the past. But gb.db and result
is suffisely powerfull to manage most part of the db capabilities in a
first time . Then he can learn sql do to more.
All depend of the project ... for a littl
Hi Tobias
I can understand your frustration, programming with databases is not so
simple in the beginning and there are some new concepts to get your head
around. I think the Result object is quite often misunderstood and
people often ask:
"Why can't the SQL stuff return something simple I can u
Hi Tobias,
If you are new to databases, you could choose to go to the best open source
database from the beginning - postgresql.
There are a wealth of postgresql books and tutorials around on the web. in
Linux, youve got the pgadmin graphical tool and if you also run windows or a
virtual mach
hResult = hConnection.Create("test")
hResult!Name = "Name01"
hResult = hConnection.Create("test")
hResult!Name = "Name02"
hResult = hConnection.Create("test")
hResult!Name = "Name03"
or
for i=0 to 2
hResult = hConnection.Create("test")
hResult!Name = "Name0" & i
next
with db.serial the id i
hi,
> For the first question I recomend to you use SQL sentence for insert. You
> can write a function where you past name of database table, name of fields
> and values and it returns the SQL INSERT sentence. I think it's all people
> do (me too!)
>
>
> SQL = "INSERT INTO test (id, name) VALUES (
For the first question I recomend to you use SQL sentence for insert. You
can write a function where you past name of database table, name of fields
and values and it returns the SQL INSERT sentence. I think it's all people
do (me too!)
SQL = "INSERT INTO test (id, name) VALUES ('1', 'name01')"
h
hi,
>like that ?
>
>For each hresult
>
> print hResult!MyField
>
>next
>
hmm, this works fine and looks like a pretty good solution! but there's no way
to handle a result the same way like an array? this FOR EACH construct is
especially for the result records? i need to understand this stuff f
like that ?
For each hresult
print hResult!MyField
next
2010/9/11 tobias :
> hello mailing list,
>
> i am absolutely new to databases in general and so to databases in
> gambas, too. i plan to use sqlite3 and in general i am understanding the
> related stuff part by part but it is very confus
hello mailing list,
i am absolutely new to databases in general and so to databases in
gambas, too. i plan to use sqlite3 and in general i am understanding the
related stuff part by part but it is very confusing with the different
classes and i think this complicates my learning process.
but to
charlesg wrote:
> Hi
>
> Why not something like:
> SHELL "mysql -u root stock < /home/charles/mySQLbackup/stockDump.sql" WAIT
> you could also specify a remote server.
> where stockDump.sql was created by mysqldump.
>
> rgds
>
>
If you want to input the sql password too (ie without any user
i
Hi
Why not something like:
SHELL "mysql -u root stock < /home/charles/mySQLbackup/stockDump.sql" WAIT
you could also specify a remote server.
where stockDump.sql was created by mysqldump.
rgds
--
View this message in context:
http://old.nabble.com/database-tp27723478p27724208.html
Sent from t
Because you are using MySQL database you can symply copy the database folder
to /var/lib/mysql. All the database table type must be use MyISAM engine and
the user must exist on detination server.
You can use shell comands to do this. It's recomended first stop mysql
service, then copy database fol
Hello List,
I am creating an application working with some databases.
I have no problem to create the empty database from code, but now I wish to
have a pre-filled database which creates itself when I install the
application or what I can create during the first run.
Is there an easy way to attac
Has anyone successfully used this sample in Gambas to retrieve data from a
MSSQL database in Fedora 12 or any other distro. I can get the connection
to open using odbc as the type and a dsn configured in odbc.ini &
odbcinst.ini using freetds as the driver however the application falls over
when t
> > Benoît Minisini a écrit :
> > ...
> >
> > > Apparently on other database systems, two index can have the same name
> > > provided they are on different tables.
> >
> > ? strange (and I'm not sure this fit in SQLs standards)
> >
> > However, in PG, you can't have a doublon, either it is from tab
> Benoît Minisini a écrit :
> ...
>
> > Apparently on other database systems, two index can have the same name
> > provided they are on different tables.
>
> ? strange (and I'm not sure this fit in SQLs standards)
>
> However, in PG, you can't have a doublon, either it is from tables,
> indexes
Benoît Minisini a écrit :
...
> Apparently on other database systems, two index can have the same name
> provided they are on different tables.
? strange (and I'm not sure this fit in SQLs standards)
However, in PG, you can't have a doublon, either it is from tables, indexes,
sequences (exceptio
Benoît Minisini wrote:
>> I m a new Gambas2 user, and I am not sure where "little things" like
>> this should be posted, so if it should be somewhere else, please let me
>> know.
>>
>> My system is Ubuntu Jaunty 9.04, Gambas2-2.15.2, Postgresql
>>
>> In the Database Manager, when I save changes to
> I m a new Gambas2 user, and I am not sure where "little things" like
> this should be posted, so if it should be somewhere else, please let me
> know.
>
> My system is Ubuntu Jaunty 9.04, Gambas2-2.15.2, Postgresql
>
> In the Database Manager, when I save changes to a table which has an
> index
Am Donnerstag, den 10.09.2009, 12:08 -0400 schrieb Richard Frost:
> I m a new Gambas2 user, and I am not sure where "little things" like
> this should be posted, so if it should be somewhere else, please let me
> know.
>
> My system is Ubuntu Jaunty 9.04, Gambas2-2.15.2, Postgresql
>
> In the D
I m a new Gambas2 user, and I am not sure where "little things" like
this should be posted, so if it should be somewhere else, please let me
know.
My system is Ubuntu Jaunty 9.04, Gambas2-2.15.2, Postgresql
In the Database Manager, when I save changes to a table which has an
index defined, I g
> Hi all
>
> I have installed Gambas on my PC at Xubuntu 8.04. All Gambas run ok, but...
> when I click at the menu to open Database Manager, it don't open. ¿Why?
>
> Thanks
>
> PD: Sorry, my english is very bad
Please provide all the details: Gambas version, how you did the install (from
sources
Hi all
I have installed Gambas on my PC at Xubuntu 8.04. All Gambas run ok, but...
when I click at the menu to open Database Manager, it don't open. ¿Why?
Thanks
PD: Sorry, my english is very bad
--
Let Crystal Reports h
Werner a écrit :
> Jean-Yves F. Barbier wrote:
>> Hi,
>>
>> Based on Database example, is there a possibility to send parms to another
>> Form? (i.e. table's name & fields' names)
>>
>> JY
>>
> If you want to access objects on a different form you need to set
> Menu Project-->Properties-->Option
Jean-Yves F. Barbier wrote:
> Hi,
>
> Based on Database example, is there a possibility to send parms to another
> Form? (i.e. table's name & fields' names)
>
> JY
>
If you want to access objects on a different form you need to set
Menu Project-->Properties-->Options "Form controls are public" t
Hi,
Based on Database example, is there a possibility to send parms to another
Form? (i.e. table's name & fields' names)
JY
--
Yes, but will I see the EASTER BUNNY in skintight leather at an IRON
MAIDEN concert?
--
Ente
Hi,
Based on Database example:
* I've noticed that column sorting is only ascending, not descending, is it
it normal (and if not, how can I recover the descending order?)
* I'd like to have a zone under the databrowser, tied to the sorting column,
where I could enter some characters and hav
Hi
Thank you Ron for that. A bit more messing around and I think I now
understand it.
Following on from richard terry's suggestion for simple examples, here it is
as simple as I can get it. There is nothing new here: it all comes from the
database example. Any corrections to the annotations welc
On Sunday 14 June 2009, charlesg wrote:
>
> Hi,
>
> I have extracted what I need from the database example. I can even get it to
> do exactly what I want. But, in truth, I do not understand how it works
> exactly.
> '===
> ' FMain.class
> PUBLIC $hC
Am Sonntag, den 14.06.2009, 05:57 -0700 schrieb charlesg:
> Hi,
>
> I have extracted what I need from the database example. I can even get it to
> do exactly what I want. But, in truth, I do not understand how it works
> exactly.
> '===
> ' FMain.cla
Hi,
I have extracted what I need from the database example. I can even get it to
do exactly what I want. But, in truth, I do not understand how it works
exactly.
'===
' FMain.class
PUBLIC $hConnLocl AS NEW Connection
PUBLIC $resData AS Result
'-
On Friday 13 March 2009 13:55:25 richard terry wrote:
>
> Some code would help.
>
richard,
That's the problem - there is no code. The update "just happens" when the row
in the databrowser changes, i.e. the user clicks on another row in the
gridview. I just can't seem to figure a way of trappi
On Fri, 13 Mar 2009 01:08:34 pm Bruce wrote:
> Hi guys,
>
> I am having a lot of trouble with this.
>
> I am trying to update a "temporary" table, say "tmp" in postgresql on a
> name matching basis using the gb.db.form databrowser control. Essentially
> I have a little app where the user opts to a
Hi guys,
I am having a lot of trouble with this.
I am trying to update a "temporary" table, say "tmp" in postgresql on a name
matching basis using the gb.db.form databrowser control. Essentially I have a
little app where the user opts to add a name or match a name. This app updates
"tmp" set
Further to this problem, now on Build 1532, I wonder if Benoit could point me
on where to proceed.
After my recent posts about difficulty saving images, I decided to give the
database manager another try, and it bugs out in just the same way, first
when clicking on ones database it comes up say
On Tue, 19 Aug 2008 08:17:17 pm Benoit Minisini wrote:
> On mardi 19 août 2008, richard terry wrote:
> > I don't use this ever, but decided to give it a try. It came up with
> > error that it couldn't find a table (which is there because I checked)
> > and then the second time I repeated the action
On mardi 19 août 2008, richard terry wrote:
> I don't use this ever, but decided to give it a try. It came up with error
> that it couldn't find a table (which is there because I checked) and then
> the second time I repeated the action (clicking on the database name in the
> tree control), it bugg
I don't use this ever, but decided to give it a try. It came up with error
that it couldn't find a table (which is there because I checked) and then the
second time I repeated the action (clicking on the database name in the tree
control), it bugged out with the error message below.
Regards
Ri
On jeudi 03 juillet 2008, richard terry wrote:
> I was using the database as a part of a wizard to create my database last
> night and noticed that if I type anything other than localhost (eg
> something nonsensicle like 'adlkfjldjaldkjf' as the host, then the example
> freezes up.
>
> Regards
>
>
I was using the database as a part of a wizard to create my database last
night and noticed that if I type anything other than localhost (eg something
nonsensicle like 'adlkfjldjaldkjf' as the host, then the example freezes up.
Regards
Richard
--
83 matches
Mail list logo
