[Gambas-user] create tables

[PaquitoSoft]

Thanks a lot Nigel
It seems your advice solved my problem






El mié, 22-06-2005 a las 11:37 +0200, nigel at ...38...
escribió:
> Instead of using the line
>   .Host = location &/ "Paquito"
> 
> change it to
>   .Name = "Paquito"
> 
> Regards
> 
> Nigel
> 
> > Message date : Jun 21 2005, 11:06 PM
> > From : "PaquitoSoft" <cloroetilo at ...626...>
> > To : gambas-user at lists.sourceforge.net
> > Copy to : 
> > Subject : Re: [Gambas-user] create tables
> > 
> > I had done so. I forgot to paste that line.
> > I actually create an instance of Connection. In fact, it woludn't be
> > possible to create the database without it.
> > 
> > 
> > El mié, 22-06-2005 a las 01:23 +0800, Werner escribió:
> > > PaquitoSoft wrote:
> > > 
> > > >Hi all!
> > > >
> > > >I'm using Gambas 1.9.8 under Debian/GNU Linux
> > > >
> > > >I want my application to create a database the first time it is run.
> > > >So I check if it already exists and I create it if not.
> > > >Until here everything is ok, but the problem arraives when i try to
> > > >create the tables for the database.
> > > >This is how I'm trying:
> > > >
> > > >DIM conexion as Connection
> > > >DIM tabla as Table
> > > >DIM location as String
> > > >
> > > >WITH conexion
> > > >    .Type = "sqlite"
> > > >    .Host = location
> > > >    .Open()
> > > >	
> > > >    IF .Databases.Exist("Paquito") THEN
> > > >      PRINT "Database already exists"
> > > >    ELSE
> > > >      .Databases.Add("Paquito")
> > > >      PRINT "New Database created"
> > > >    END IF
> > > >
> > > >    .Close()
> > > >    .Host = location &/ "Paquito"
> > > >    .Open()
> > > >
> > > >    tabla = .Tables.Add("preferencias")
> > > >    tabla.Fields.Add("idioma", GB.String, 5)
> > > >    tabla.Fields.Add("interfaz", GB.String, 5)
> > > >    tabla.Fields.Add("maxUp", GB.Integer)
> > > >    tabla.Fields.Add("maxDown", GB.Integer)
> > > >    tabla.Update()
> > > >    .Close()
> > > >END WITH
> > > >
> > > >location is a String containing the directory where I will store the
> > > >database.
> > > >After I run this code I get a new Database in that folder with the name
> > > >I put and, of course, is a sqlite sigle-fil database.
> > > >The problem is that no table is created within the database, so...
> > > >What am I doing wrong??
> > > >
> > > >Thank you all guys! this mailing list is great
> > > >
> > > >  
> > > >
> > > You migth want to try
> > > 
> > > DIM conexion as NEW Connection 'to create an instance
> > > 
> > > Werner
> > > 
> > > 
> > > 
> > > -------------------------------------------------------
> > > SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
> > > from IBM. Find simple to follow Roadmaps, straightforward articles,
> > > informative Webcasts and more! Get everything you need to get up to
> > > speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
> > > _______________________________________________
> > > Gambas-user mailing list
> > > Gambas-user at lists.sourceforge.net
> > > https://lists.sourceforge.net/lists/listinfo/gambas-user
> > -- 
> > El tiempo es un gran profesor. Desafortunadamente, mata a todos sus
> > alumnos.
> > 
> > 
> > 
> > -------------------------------------------------------
> > SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
> > from IBM. Find simple to follow Roadmaps, straightforward articles,
> > informative Webcasts and more! Get everything you need to get up to
> > speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
> > _______________________________________________
> > Gambas-user mailing list
> > Gambas-user at lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/gambas-user
> > 
> > 
> 
> -- 
> 
> Whatever you Wanadoo:
> http://www.wanadoo.co.uk/time/
> 
> This email has been checked for most known viruses - find out more at: http://www.wanadoo.co.uk/help/id/7098.htm
> 
> 
> 
> -------------------------------------------------------
> SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
> from IBM. Find simple to follow Roadmaps, straightforward articles,
> informative Webcasts and more! Get everything you need to get up to
> speed, fast. http://ads.osdn.com/?ad_idt77&alloc_id492&op=click
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
-- 
El tiempo es un gran profesor. Desafortunadamente, mata a todos sus
alumnos.