Re: [Gambas-user] Database Results

2010-09-11 Thread richard terry
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

[Gambas-user] Testing DEVELOPMENT ENVIRONMENT in Gambas3

2010-09-11 Thread craf
[ DEVELOPMENT ENVIRONMENT] Testing in Gambas3 Rev 3206 SO: Ubuntu 9.10 i386 * When you save a project with the name of another existing project. Not indicated by a message that the project already exists as gambas2. Regards. Cristian Abarzua F -

[Gambas-user] Testing component GB.INFO

2010-09-11 Thread craf
[GB.INFO] Testing in Gambas3 Rev 3206 and Gambas 2.21. SO: Ubuntu 9.10 i386 * Create proyect GTK. * Add Control Listview * Add three controls Button. * Add Class Class1 * Add two forms. * Code in Button1: Dim x As Byte For x = 0 To Info.Classes.Count - 1 ListView1.Add(x, Info.Classe

Re: [Gambas-user] Database Results

2010-09-11 Thread Fabien Bodard
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

Re: [Gambas-user] Database Results

2010-09-11 Thread tobias
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 (

Re: [Gambas-user] Database Results

2010-09-11 Thread Ricardo Díaz Martín
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

Re: [Gambas-user] Database Results

2010-09-11 Thread Tobias Boege
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

Re: [Gambas-user] Database Results

2010-09-11 Thread Fabien Bodard
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

[Gambas-user] Database Results

2010-09-11 Thread 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 confusing with the different classes and i think this complicates my learning process. but to