|
1 | | -CREATETABLEpga_queries (querynamevarchar(64), querytypechar(1), querycommandtext); |
2 | | -CREATETABLEpga_forms (formnamevarchar(64), formsourcetext); |
3 | | -CREATETABLEpga_scripts (scriptnamevarchar(64), scriptsourcetext); |
4 | | -CREATETABLEpga_reports (reportnamevarchar(64), reportsourcetext,reportbodytext,reportprocstext,reportoptionstext); |
5 | | -CREATETABLEphonebook (namevarchar(32), phone_nrvarchar(16), cityvarchar(32), companybool,continent char16); |
6 | | -CREATETABLEpga_layout (tablenamevarchar(64), nrcolsint2,colnamestext,colwidthtext); |
7 | | -COPY pga_queriesFROM stdin; |
| 1 | +CREATETABLE"pga_queries" ("queryname"varchar(64),"querytype"char(1),"querycommand""text"); |
| 2 | +CREATETABLE"pga_forms" ("formname"varchar(64),"formsource""text"); |
| 3 | +CREATETABLE"pga_scripts" ("scriptname"varchar(64),"scriptsource""text"); |
| 4 | +CREATETABLE"pga_reports" ("reportname"varchar(64),"reportsource""text","reportbody""text","reportprocs""text","reportoptions""text"); |
| 5 | +CREATETABLE"phonebook" ("name"varchar(32),"phone_nr"varchar(16),"city"varchar(32),"company""bool","continent"char(16)); |
| 6 | +CREATETABLE"pga_layout" ("tablename"varchar(64),"nrcols""int2","colnames""text","colwidth""text"); |
| 7 | +COPY"pga_queries"FROM stdin; |
8 | 8 | Query that can be savedas viewSselect*from phonebookwhere continent='usa' |
9 | 9 | \. |
10 | | -COPY pga_formsFROM stdin; |
| 10 | +COPY"pga_forms"FROM stdin; |
11 | 11 | A simple demo formasdf 14 {1 2 3 4 5 6 7 8 9 10 11 12 13 14} 377x315+170+155 {label label1 {15 36 99 57} {} {Selected color} {}} {entry entry2 {111 36 225 54} {} entry2 color} {radio red {249 21 342 36} {} {Red as cherry} color} {radio green {249 45 342 60} {} {Green as a melon} color} {radio blue {249 69 342 84} {} {Blue as the sky} color} {button button6 {45 69 198 99} {set color spooky} {Set a weird color} {}} {label label7 {24 129 138 147} {} {The checkbox's value} {}} {entry entry8 {162 129 172 147} {} entry8 cbvalue} {checkbox checkbox9 {180 126 279 150} {} {Check me :-)} cbvalue} {button button10 {219 273 366 303} {destroy .asdf} {Close that simple form} {}} {button button11 {219 237 366 267} {open_form "Phone book"} {Open my phone book} {}} {listbox lb {12 192 162 267} {} listbox12 {}} {button button13 {12 156 162 186} {.asdf.lb insert end red green blue cyan white navy black purple maroon violet} {Add some information} {}} {button button14 {12 273 162 303} {.asdf.lb delete 0 end} {Clear this listbox} {}} |
12 | 12 | Phone bookpb26 {1234567891011121314151617181920212223242526} 444x310+284+246 {label label1 {33126330} {} Name {}} {entry name_entry {87921730} {} entry2 pbqs(name)} {label label3 {33397354} {} Phone {}} {entry entry4 {873619557} {} entry4 pbqs(phone_nr)} {label label5 {33667884} {} City {}} {entry entry6 {876319584} {} entry6 pbqs(city)} {query qs {363333} {} query7 {}} {button button8 {126177198203} {.pb.qs:setsql"select oid,* from phonebook where name ~* '$what' order by name"\ |
13 | 13 | .pb.qs:open\ |
@@ -56,32 +56,32 @@ tk_messageBox -title Information -message "A new record has been added!"\ |
56 | 56 | set pbqs(company) f\ |
57 | 57 | focus .pb.name_entry} New {}} {listbox allnames {246 12 432 240} {} listbox26 {}} |
58 | 58 | \. |
59 | | -COPY pga_scripts FROM stdin; |
| 59 | +COPY"pga_scripts" FROM stdin; |
60 | 60 | How are forms keeped inside ?open_table pga_forms\ |
61 | 61 | \ |
62 | 62 |
|
63 | 63 | \. |
64 | | -COPY pga_reports FROM stdin; |
| 64 | +COPY"pga_reports" FROM stdin; |
65 | 65 | \. |
66 | | -COPY phonebook FROM stdin; |
67 | | -IBM623346234\Ntusa |
68 | | -John Doe+44 35 2993825Washingtonfusa |
69 | | -Bill Clinton+44 35 9283845New Yorkfusa |
70 | | -Monica Levintchi+44 38 5234526Dallasfusa |
71 | | -Bill Gates+42 64 4523454Los Angelesfusa |
72 | | -COMPAQ623462345\Ntusa |
73 | | -SUN784563253\Ntusa |
74 | | -DIGITAL922644516\Ntusa |
75 | | -FIAT623463445\Nteurope |
76 | | -MUGADUMBU+92 534662634\Ntafrica |
77 | | -Frank Zappa6734567Montrealfusa |
78 | | -Jimmy Page66323452feurope |
79 | | -Constantin Teodorescu+40 39 611820Brailafeurope |
80 | | -Ngbendu Wazabanga34577345fafrica |
81 | | -Victor Ciorbea634567Bucurestifeurope |
82 | | -Mugabe Kandalam7635745fafrica |
| 66 | +COPY"phonebook" FROM stdin; |
| 67 | +IBM623346234\Ntusa |
| 68 | +John Doe+44 35 2993825Washingtonfusa |
| 69 | +Bill Clinton+44 35 9283845New Yorkfusa |
| 70 | +Monica Levintchi+44 38 5234526Dallasfusa |
| 71 | +Bill Gates+42 64 4523454Los Angelesfusa |
| 72 | +COMPAQ623462345\Ntusa |
| 73 | +SUN784563253\Ntusa |
| 74 | +DIGITAL922644516\Ntusa |
| 75 | +FIAT623463445\Nteurope |
| 76 | +MUGADUMBU+92 534662634\Ntafrica |
| 77 | +Frank Zappa6734567Montrealfusa |
| 78 | +Jimmy Page66323452feurope |
| 79 | +Constantin Teodorescu+40 39 611820Brailafeurope |
| 80 | +Ngbendu Wazabanga34577345fafrica |
| 81 | +Victor Ciorbea634567Bucurestifeurope |
| 82 | +Mugabe Kandalam7635745fafrica |
83 | 83 | \. |
84 | | -COPY pga_layout FROM stdin; |
| 84 | +COPY"pga_layout" FROM stdin; |
85 | 85 | pga_forms2formname formsource82 713 |
86 | 86 | phonebook5name phone_nr city company continent150 105 80 66 85 |
87 | 87 | Usaisti5name phone_nr city company continent150 150 150 150 150 |
|