Debian Codegraph @

sample/res_tex

raw
1 #--------------------------------------------------------------
2 # 1. SELECT(with no params)
3 DATA:1,Kawai,Takanori,OpenDept.,37,[email protected]
4 DATA:2,Kabaya-Two thousand,Hippo2000 and Co.,2001,
5 DATA:3,Hippo2000,Hippo2000 and Co.,37,[email protected]
6 #--------------------------------------------------------------
7 # 2. SELECT(with params)
8 DATA:3,Hippo2000,Hippo2000 and Co.,37,[email protected]
9 #--------------------------------------------------------------
10 # 3. INSERT(with params)
11 #--------------------------------------------------------------
12 # 4. DELETE(with params)
13 #--------------------------------------------------------------
14 # 5. UPDATE(with params)
15 #--------------------------------------------------------------
16 # 6. SELECT(again)
17 DATA:2,Kabaya-Two thousand,Hippo2000 and Co.,2001,Mail Upd
18 DATA:4,Newman 4,New Dept,30,[email protected]
19 DATA:5,Newman 5,New Dept,32,[email protected]
20 #--------------------------------------------------------------
21 # 7. CREATE TABLE, DROP TABLE
22 #--------------------------------------------------------------
23 # 1. SELECT(with no params): VTBL
24 DATA:1,Kawai,Takanori,OpenDept.,37
25 DATA:2,Kabaya-Two thousand,Hippo2000 and Co.,2001
26 DATA:3,Hippo2000,Hippo2000 and Co.,37
27 #--------------------------------------------------------------
28 # 2. SELECT(with params)
29 DATA:2,Kabaya-Two thousand,Hippo2000 and Co.,2001
30 DATA:3,Hippo2000,Hippo2000 and Co.,37
31 #--------------------------------------------------------------
32 # 3. UPDATE(with params)
33 #--------------------------------------------------------------
34 # 4. DELETE(with params)
35 #--------------------------------------------------------------
36 # 5. INSERT(with params)
37 #--------------------------------------------------------------
38 # 6. SELECT(again)
39 DATA:1,Kawai,Takanori,OpenDept.,37
40 DATA:3,Hippo2000,Hippo2000 and Co.,50
41 DATA:4,Newman 4,New Dept,30
42 DATA:5,Newman 5,New Dept,32
43 #--------------------------------------------------------------
44 # 7. List tables, data sources
45 TABLE: TEST
46 TABLE: TEST_JAPAN
47 TABLE: NEW_TBL
48 TABLE: DEL_TEST
49 TABLE: TEST_V
50 TABLE: TESTV
51 DSN: DBI:Excel:file=./dbdtest.xls
52 DSN: DBI:Excel:file=./newxl.xls
53 DSN: DBI:Excel:file=./newxlj.xls
54 DSN: DBI:Excel:file=./testj.xls
55 #--------------------------------------------------------------
56 # 8. Save this Excel file