hResult = hConnection.Create("test") hResult!Name = "Name01" hResult = hConnection.Create("test") hResult!Name = "Name02" hResult = hConnection.Create("test") hResult!Name = "Name03"
or for i=0 to 2 hResult = hConnection.Create("test") hResult!Name = "Name0" & i next with db.serial the id is auto incremented 2010/9/11 tobias <tobiasb...@web.de>: > hi, > >> For the first question I recomend to you use SQL sentence for insert. You >> can write a function where you past name of database table, name of fields >> and values and it returns the SQL INSERT sentence. I think it's all people >> do (me too!) >> >> >> SQL = "INSERT INTO test (id, name) VALUES ('1', 'name01')" >> hConnection.Exec(SQL) >> >> Regards, >> Ricardo Díaz >> >> >> >> 2010/9/11 Tobias Boege <tobiasb...@web.de> >> >> >>> hi, >>> >>> >>>> like that ? >>>> >>>> For each hresult >>>> >>>> print hResult!MyField >>>> >>>> next >>>> >>>> >>> hmm, this works fine and looks like a pretty good solution! but there's no >>> way to handle a result the same way like an array? this FOR EACH construct >>> is especially for the result records? i need to understand this stuff for a >>> skilled labour completely, for this reason understanding the structure of >>> the Result-Object is neccessary. it seems to be the most complicated thing >>> in gambas :) >>> >>> and can you tell me something about my first problem? this also shouldn't >>> be so defficult, i think? >>> >>> regards, tobi >>> ___________________________________________________________ >>> WEB.DE DSL SOMMER-SPECIAL: Surf & Phone Flat 16.000 für >>> nur 19,99 €/mtl.!* http://produkte.web.de/go/DSL-Doppel-Flatrate/2 >>> >>> >>> ------------------------------------------------------------------------------ >>> Start uncovering the many advantages of virtual appliances >>> and start using them to simplify application deployment and >>> accelerate your shift to cloud computing >>> http://p.sf.net/sfu/novell-sfdev2dev >>> _______________________________________________ >>> Gambas-user mailing list >>> Gambas-user@lists.sourceforge.net >>> https://lists.sourceforge.net/lists/listinfo/gambas-user >>> >>> >> ------------------------------------------------------------------------------ >> Start uncovering the many advantages of virtual appliances >> and start using them to simplify application deployment and >> accelerate your shift to cloud computing >> http://p.sf.net/sfu/novell-sfdev2dev >> _______________________________________________ >> Gambas-user mailing list >> Gambas-user@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/gambas-user >> > okay, i'll do so too ;) in the picture database example there's a separate > function, too, in which the table is opened for create and the one record > created. this seems more > backend independent, but there's no need of it because i have to write about > gamabs + sqlite3. > > hmm, i hope anybody could tell me about the Result-Object structure, for the > reason that i don't understand it, it would be very interesting in the > skilled labour :) > > thank you very much, > tobi > > > ------------------------------------------------------------------------------ > Start uncovering the many advantages of virtual appliances > and start using them to simplify application deployment and > accelerate your shift to cloud computing > http://p.sf.net/sfu/novell-sfdev2dev > _______________________________________________ > Gambas-user mailing list > Gambas-user@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/gambas-user > -- Fabien Bodard ------------------------------------------------------------------------------ Start uncovering the many advantages of virtual appliances and start using them to simplify application deployment and accelerate your shift to cloud computing http://p.sf.net/sfu/novell-sfdev2dev _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user