Relational Database example

[aklisiewicz]

I'm looking for some relational database example where there are Parent/Child records displayed or edited. Invoice or Order like would probably be the best.
Normally when I create such App on a desktop or web I can display a document like Order or Invoice with 3 diferent sections.
1.Header (InvoiceID, Customer, Date)
2.Body (which lists the invoice item,price,quantuty)
3. Footer (showing the invoice totals, tax, discounts etc.)

Since some devices have pretty small screen I would eventually consider placing each section on separate Tab, so the Tabs will be probably linked through some global Var to hold InvoiceID.

Would something like that be possible on android device (with SQLite) ?

Is is possible to do the same with 3-rd level relation (Parent->Child->Grandchild) ?


Are there any examples ?

Arthur

 

[Erel]

Check the example in DBUtils module. It includes a one to many relationship between the students table and the grades table.

SQLite is a powerful SQL engine. You can create many complicated relationships.

 

[aklisiewicz]

Erel, thank you for your timely response.
This is very nice example, and I will study it. In the meantime I have one question.

I would need something like that but instead of using Spiner in place of selecting a student ID I would like to have some other method which will allow me to do searches (along with the selection). Another words I want my lookup procedure little more advanced (searching, possibly sorting).

What would you suggest be the method of doing it?

Arthur

 

[Erel]

Try SearchView class.