File: res_texj

package info (click to toggle)
libdbd-excel-perl 0.06-4
  • links: PTS
  • area: main
  • in suites: etch, etch-m68k
  • size: 192 kB
  • ctags: 45
  • sloc: perl: 1,009; makefile: 44
file content (60 lines) | stat: -rw-r--r-- 2,511 bytes parent folder | download | duplicates (7)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
#--------------------------------------------------------------
# 1. SELECT(with no params)
DATA:1,Kawai,Takanori,OpenDept.,37,GCD00051@nifty.ne.jp
DATA:2,Kabaya-Two thousand,Hippo2000 and Co.,2001,
DATA:3,Hippo2000,Hippo2000 and Co.,37,kawait@nippon-rad.co.jp
#--------------------------------------------------------------
# 2. SELECT(with params)
DATA:3,Hippo2000,Hippo2000 and Co.,37,kawait@nippon-rad.co.jp
#--------------------------------------------------------------
# 3. INSERT(with params)
#--------------------------------------------------------------
# 4. DELETE(with params)
#--------------------------------------------------------------
# 5. UPDATE(with params)
#--------------------------------------------------------------
# 6. SELECT(again)
DATA:2,Kabaya-Two thousand,Hippo2000 and Co.,2001,Mail Upd
DATA:4,Newman 4,New Dept,30,newman4@hippo2000.net
DATA:5,Newman 5,New Dept,32,newman5@hippo2000.net
#--------------------------------------------------------------
# 7. CREATE TABLE, DROP TABLE
#--------------------------------------------------------------
# 1. SELECT(with no params): VTBL
DATA:1,Kawai,Takanori,OpenDept.,37
DATA:2,Kabaya-Two thousand,Hippo2000 and Co.,2001
DATA:3,Hippo2000,Hippo2000 and Co.,37
#--------------------------------------------------------------
# 2. SELECT(with params)
DATA:2,Kabaya-Two thousand,Hippo2000 and Co.,2001
DATA:3,Hippo2000,Hippo2000 and Co.,37
#--------------------------------------------------------------
# 3. UPDATE(with params)
#--------------------------------------------------------------
# 4. DELETE(with params)
#--------------------------------------------------------------
# 5. INSERT(with params)
#--------------------------------------------------------------
# 6. SELECT(again)
DATA:1,Kawai,Takanori,OpenDept.,37
DATA:3,Hippo2000,Hippo2000 and Co.,50
DATA:4,Newman 4,New Dept,30
DATA:5,Newman 5,New Dept,32
#--------------------------------------------------------------
# 7. List tables, data sources
TABLE: TEST
TABLE: TEST_JAPAN
TABLE: NEW_TBL
TABLE: DEL_TEST
TABLE: TEST_V
TABLE: TESTV
DSN: DBI:Excel:file=./dbdtest.xls
DSN: DBI:Excel:file=./newxl.xls
DSN: DBI:Excel:file=./testj.xls
#--------------------------------------------------------------
# 8. Japanese test
DATA:1,繧ŵ,ץ󥷥ƥ,37,GCD00051@nifty.ne.jp
DATA:2,ϲǯƲ,ϲǯƲ,2001,
DATA:3,Hippo2000,ϲǯƲ,37,kawait@nippon-rad.co.jp
#--------------------------------------------------------------
# 9. Save this Excel file