[Gambas-user] Database Results

[Fabien Bodard]

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



-- 
Fabien Bodard