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

Reply via email to