small lesson in using database wanted

[Luis]

Hiya,

If you want to learn whilst having fun, try GalaxQL: 
http://sol.gfxile.net/galaxql.html

Cheers,

Luis.


Brent Anderson wrote:
> Hello.
> 
> Although there are many database functions provided with Revolution, I 
> prefer opening a connection and making SQL calls using revDataFromQuery. 
> A full tutorial on SQL can be found at www.w3schools.com/sql/ that goes 
> over everything you need to know to work with any SQL database.
> 
> Thanks,
> Brent Anderson
> CMSEC
> 
> 
> On Jan 18, 2007, at 5:32 PM, Reinhold Venzl-Schubert wrote:
> 
>> Hi,
>>
>> I need a small lesson in using database:
>>
>> 1. I created a db (using SQLite3) with several fields. One of them is 
>> a boolean field. It is corresponding to a checkbox button in the card 
>> of my stack. Only one record of the database is displayed on the card.
>>
>> 2. I built a query that selects some of the records of my db and sorts 
>> them by some fields.
>>
>> 3. With a forward and backward button >revdb_movenext(recordSetID)< 
>> and >revdb_moveprev(recordSetID)< I navigate through the records of 
>> the recordSet.
>>
>> 4. With a script >set the hilite of btn "checkbox" to 
>> revdb_columnbynumber(recordSetID,5)< I display the database fields of 
>> the actual record in the fields of my card.
>>
>> 5. Then I wrote a script for the checkbox button 
>> >revdb_execute(recordSetID,tSQL)< with tSQL like: >UPDATE my_db SET 
>> checkbox = "true" .... < and so on. I tested it with the SQLite 
>> Database Browser: the changes have been saved.
>>
>> 6. When I use my forward and backward button, to switch to the next 
>> record and then back to the changed record I do not see the change in 
>> my field or in my special case, the checkbox is not hilited.
>>
>> 7. When I close the current cursor (recordSet) and make a new query 
>> the checkbox is hilited.
>>
>> I learned that the UPDATE-script changes the database but it do not 
>> change the cursor (recordSet).
>> But the forward/backward button do not display the content of the 
>> database but the content of the current cursor (recordSet).
>>
>> - How can I get the content of the database?
>> - Do I have to make a new query after every change of fields?
>> - Or is it better to use the revdb_query funktion only to get a sorted 
>> list of primary keys of the wanted records and to use the 
>> revdb_querylist funktion to display the content of the db fields on 
>> the card?
>>
>> I am rather confused.
>>
>> Reinhold
>> _______________________________________________
>> use-revolution mailing list
>> use-revolution at lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your 
>> subscription preferences:
>> http://lists.runrev.com/mailman/listinfo/use-revolution
> 
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your 
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution
> 
>