> > > Hi all, > > > > > > I'm trying to read the f-spot database to add some tools to this > > > program. > > > > I > > > > > write few lines in gambas and everything worked fine but no the access > > > to > > > > > >> string fields. this is a part of the code: > > >> > > >> Con.Close() > > >> Con.Type = "sqlite" > > >> Con.Host = "/home/rsalas/.gnome2/f-spot/" > > >> Con.Name = "photos.db" > > >> TRY Con.Open() > > >> IF ERROR THEN > > >> Message.Error("Error al conectar a la base de datos.") > > >> Con = NULL > > >> ELSE > > >> TRY TablaFicheros = Con.Exec("SELECT photos. *, tags. * FROM (photos > > >> INNER JOIN photo_tags ON photos.Id = photo_tags.photo_id)INNER JOIN > > >> tags > > > > ON > > > > >> photo_tags.tag_id = tags.Id ") > > >> IF ERROR THEN > > >> Message.Error("Error al abrir hacer SELECT base de datos.") > > >> ELSE > > >> TablaFicheros.Movefirst() > > >> sFichero = TablaFicheros["uri"] > > >> txtFichero.text = sFichero > > >> ENDIF > > >> > > >> The line "sFichero = TablaFicheros["uri"]" gives the value "f" to > > > > sFichero > > > > >> but not the rest of the string. This doesn't happend with text fields. > > > > Can > > > > >> anyone help me on this? > > >> > > >> Thanks > > >> > > >> PS: Using gambas 2.8 on linux ubuntu 9.04 > > > > > >Can you get the real sqlite datatype of this field? > > > > > >-- > > >Beno?t > > > > sqlite> .schema photos > > CREATE TABLE photos ( id INTEGER PRIMARY KEY > > AUTOINCREMENT NOT NULL, time INTEGER NOT NULL, > > uri STRING NOT NULL, description TEXT > > NOT NULL, roll_id INTEGER NOT NULL, > > default_version_id INTEGER NOT NULL, rating > > INTEGER NULL, md5_sum TEXT NULL > > ); CREATE INDEX idx_photos_roll_id ON photos(roll_id); > > sqlite> > > > > > > uri is a string with the path name of the file > > I can read the uri correctly with Gambas 3. I will check with Gambas 2... > >I can read it with Gambas 2, so I think the bug has been fixed since. Try to >upgrade to the latest release! > >Regards,
Beno?t, thanks for your help 2.14 works 100% for that. Regards ------------------------------------------------------------------------------ Enter the BlackBerry Developer Challenge This is your chance to win up to $100,000 in prizes! For a limited time, vendors submitting new applications to BlackBerry App World(TM) will have the opportunity to enter the BlackBerry Developer Challenge. See full prize details at: http://p.sf.net/sfu/Challenge _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user