[Gambas-user] Database Results

[Ricardo Díaz Martín]

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 <tobiasboe1 at ...20...>

> 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 at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
>