PDA

View Full Version : Database



Tara
12th April 2009, 23:08
Hi friends,
I am new to this tool. I have one doubt.could u help me anybody.The problem is i created different tables in my database,How to show the multiple tables in User interface and how to compare the Date In Sqlite database.

Lykurg
13th April 2009, 09:20
Hi friends,
I am new to this tool.
Then the forum "Newbie" would be probably better...

I have one doubt.
We all doubt sometimes ;)

could u help me anybody.The problem is i created different tables in my database,How to show the multiple tables in User interface
Use multiple QSqlTableModel with QTableView.

and how to compare the Date In Sqlite database.
Sqlite has no date field like MySQL. So the best is to store the date in the UNIX time format (seconds till 1970? I never know..) and then simply use integer comparison.