[Gambas-user] Enumerating values in sqllite3 database tables

2008-09-17 Thread MaxVK
Hi there. I am making a personal program to catalog a large collection of photographs and rather than install MySQL just for this purpose I would like to use sqlite3. Using the example program I am able to create the database and the tables within it, and I am (apparently) able to add data to

Re: [Gambas-user] Enumerating values in sqllite3 database tables

2008-09-17 Thread Fabien Bodard
2008/9/17 MaxVK [EMAIL PROTECTED]: Hi there. I am making a personal program to catalog a large collection of photographs and rather than install MySQL just for this purpose I would like to use sqlite3. Using the example program I am able to create the database and the tables within it, and

Re: [Gambas-user] Enumerating values in sqllite3 database tables

2008-09-17 Thread MaxVK
charlesg wrote: Hi, something like: '-- Private res As Result lstSupplier.Clear res = $hConn.Exec(select * from supp order by s_code) For Each res lstSupplier.Add(res!s_code , res!s_name , res!s_closedate , res!s_dayscredit , res!s_datedue) Next

Re: [Gambas-user] Enumerating values in sqllite3 database tables

2008-09-17 Thread charlesg
Hi, I don't know how 'standard' any sql gets:confused: You can certainly use sql update and delete commands the same way. rgds -- View this message in context: http://www.nabble.com/Enumerating-values-in-sqllite3-database-tables-tp19529262p19532988.html Sent from the gambas-user mailing list

Re: [Gambas-user] Enumerating values in sqllite3 database tables

2008-09-17 Thread MaxVK
charlesg wrote: Hi, I don't know how 'standard' any sql gets:confused: You can certainly use sql update and delete commands the same way. rgds :-D Yeah, thats pretty much what I meant. I don't know much SQL (yet), so I was only wondering if sqlite3 used the same commands or its

Re: [Gambas-user] Listview (simple?) problem

2008-09-17 Thread Gianni Piccini
On 15/09/2008 Doriano Blengino wrote: Look with great attention at the help page for Listview, inside gb.qt. Mmmh, certainly it's not a problem of docs, but a fault of mine trying to understand how Gambas works, I can't find it. I was thinking that this should be a property like

[Gambas-user] learning gb.report

2008-09-17 Thread Kari Laine
Hi, I am learning gb.report and in it there is following in the report-class. PUBLIC SUB _New() object.Attach(ME, ME, Report) how come there is ME twice in it? Gambas-help gives following STATIC SUB Attach ( Object AS Object, Parent AS Object, Name AS String ) In my understanding there

Re: [Gambas-user] Listview (simple?) problem

2008-09-17 Thread Doriano Blengino
Gianni Piccini ha scritto: On 15/09/2008 Doriano Blengino wrote: Look with great attention at the help page for Listview, inside gb.qt. Mmmh, certainly it's not a problem of docs, but a fault of mine trying to understand how Gambas works, I can't find it. I was thinking that

[Gambas-user] Format padding with spaces?

2008-09-17 Thread Ron
Hi, I was a bit suprised to find out that Format$ doesn't support space padding like it does with zero's So: PRINT Format$(72.06, .##) PRINT Format$(2.05,.##) Prints: 72.06 2.05 Any technical reason for this? Regards, Ron_2nd

Re: [Gambas-user] Listview (simple?) problem

2008-09-17 Thread Gianni Piccini
On 17/09/2008 Doriano Blengino wrote: I am not really the right person to answer to you; Thanks. My error was to want to use same VB syntax, now I load all items in an array and then I can work with it. - This SF.Net

[Gambas-user] Events

2008-09-17 Thread Kari Laine
Hi, could someone please post a little example how these events work? Or refer me to a example in Gambas where their are used. Best Regards Kari Laine - This SF.Net email is sponsored by the Moblin Your Move Developer's

[Gambas-user] How to lock a file

2008-09-17 Thread Almanova Sistemi
Hi, is the first time that I write to list, but i have a problem. I am writing an application in gambas (2.7.0-2.1) on opensuse 10.3 - 11.0 and I need to lock a file when I open it. My code: ... hfile = OPEN /usr/far/alman/NOMEFARM.DAT FOR INPUT OUTPUT TRY LOCK hfile IF ERROR then ...

[Gambas-user] Good news

2008-09-17 Thread Fabien Bodard
Now you can download on the GambasForge site ... it work ! http://www.gambasforge.net Currently i'm working to reimplement users part, the you will be able to connect to the site and add new sources. You have any ideas of what you want to the biggest communautary site ... tell me , or join us,

Re: [Gambas-user] learning gb.report

2008-09-17 Thread Fabien Bodard
some time there is the need to attach an object to himself (for event handler). form is doing that too. i don'tt remember why i has done that lol i need to look at that better ... what did you manage to do about that component ... i've not finish it yet... i'm waiting for Benoit and the

Re: [Gambas-user] Listview (simple?) problem

2008-09-17 Thread Fabien Bodard
For delete the current ListView.Remove(ListView.Item.key) ListView.MovePrevious To add after the current selected Listview.add(key, text, picture, ListView.Item.key) Easy no ? but you need to store the value of the deleted row for the move. LOL it's an idea ... a swap function will be great.

Re: [Gambas-user] Events

2008-09-17 Thread Fabien Bodard
in what case ? to write you own class ? 'class MyTest EVENT MyEvent Public test() RAISE MyEvent End 'Main Module Private hTest as Mytest Public sub Main() hTest = New MyTest as MyTest htest.Test end Public Sub MyTest_MyEvent() Print Event Raised End Fabien 2008/9/17 Kari

Re: [Gambas-user] How to lock a file

2008-09-17 Thread Fabien Bodard
# If the READ or WRITE keyword are specified, then the input-output are not buffered. # If the INPUT or OUTPUT keyword are specified, then the input-output are buffered. Maybe for that ? 2008/9/17 Almanova Sistemi [EMAIL PROTECTED]: Hi, is the first time that I write to list, but i have a

Re: [Gambas-user] Format padding with spaces?

2008-09-17 Thread Benoit Minisini
On mercredi 17 septembre 2008, Ron wrote: Hi, I was a bit suprised to find out that Format$ doesn't support space padding like it does with zero's So: PRINT Format$(72.06, .##) PRINT Format$(2.05,.##) Prints: 72.06 2.05 Any technical reason for this? Regards, Ron_2nd I