Re: [Gambas-user] Database not working to select records, but fields/tables identified

2011-07-01 Thread Caveat
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

Re: [Gambas-user] Database not working to select records, but fields/tables identified

2011-07-01 Thread Fabien Bodard
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). > >

Re: [Gambas-user] Database not working to select records, but fields/tables identified (small correction)

2011-06-30 Thread Caveat
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

[Gambas-user] Database not working to select records, but fields/tables identified

2011-06-30 Thread Caveat
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