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 ------------------------------------------------------------------------------ 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