File: select.sql

package info (click to toggle)
pilot-qof 0.1.1-3
  • links: PTS
  • area: main
  • in suites: etch, etch-m68k
  • size: 2,576 kB
  • ctags: 473
  • sloc: sh: 8,987; ansic: 4,589; xml: 666; makefile: 176; perl: 72; sql: 8
file content (10 lines) | stat: -rw-r--r-- 704 bytes parent folder | download | duplicates (3) 
1
2
3
4
5
6
7
8
9
10
 
-- test SQL queries for pilot-qof 0.1.x series

SELECT * from pilot_address where entryState = 'Anyshire' and category = 'Business';
SELECT * from pilot_address where entryCity = 'Sometown';
SELECT * from pilot_address where category = 'Friends' or category = 'Linux';
SELECT * from pilot_expenses where expense_city = 'ANYTOWN';
SELECT * from pilot_expenses where expense_vendor = 'Megga Park';
SELECT * from pilot_datebook where category = 'Personal' and repeat_type = 'repeatNone';
SELECT * from pilot_datebook where description = 'Sometown' and use_alarm = 'FALSE' and repeat_frequency = 0 and transient_repeat = 'FALSE';
SELECT * from pilot_todo where todo_description = 'qof' or todo_priority > 2;