| 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 |