Guest User

Untitled

a guest
Jan 22nd, 2019
173
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.12 KB | None | 0 0
  1. con=kinterbasdb.create_database("create database 'D:/ThirdTask/test.db' user 'sysdba' password 'masterkey'")
  2. conn=kinterbasdb.connect(host='localhost',database='D:/ThirdTask/test.db', user='sysdba', password='masterkey')
  3. cur=con.cursor()
  4. s="""
  5. create table CLIENTS
  6. (
  7. ID FMTBCD PRIMARY KEY,
  8. COMPANY CHAR(50),
  9. LAST NAME CHAR(50),
  10. FIRST NAME CHAR(50),
  11. E-MAIL ADDRESS CHAR(50),
  12. JOB TITLE CHAR(50),
  13. BUSINESS PHONE CHAR(25),
  14. HOME PHONE CHAR(25),
  15. MOBILE PHONE CHAR(25),
  16. FAX NUMBER CHAR(25),
  17. ADDRESS MEMO,
  18. CITY CHAR(50),
  19. STATE/PROVINCE CHAR(50),
  20. ZIP/POSTAL CODE CHAR(15),
  21. COUNTRY/REGION CHAR(50),
  22. WEB-SITE CHAR(25),
  23. NOTES MEMO,
  24. INCLUDING BLOB
  25. )"""
  26. print s
  27. cur.execute(s)
  28. con.close()
  29. conn.close()
  30.  
  31. create table CLIENTS
  32. (
  33. ID FMTBCD PRIMARY KEY,
  34. COMPANY CHAR(50),
  35. LAST NAME CHAR(50),
  36. FIRST NAME CHAR(50),
  37. E-MAIL ADDRESS CHAR(50),
  38. JOB TITLE CHAR(50),
  39. BUSINESS PHONE CHAR(25),
  40. HOME PHONE CHAR(25),
  41. MOBILE PHONE CHAR(25),
  42. FAX NUMBER CHAR(25),
  43. ADDRESS MEMO,
  44. CITY CHAR(50),
  45. STATE/PROVINCE CHAR(50),
  46. ZIP/POSTAL CODE CHAR(15),
  47. COUNTRY/REGION CHAR(50),
  48. WEB-SITE CHAR(25),
  49. NOTES MEMO,
  50. INCLUDING BLOB
  51. )
  52.  
  53. Traceback (most recent call last):
  54. File "D:ThirdTaskconnect.py", line 119, in <module>
  55. cur.execute(s)
  56. ProgrammingError: (-104, 'isc_dsql_prepare: n Dynamic SQL Errorn SQL error code = -104n Token unknown - line 6, column 16n CHAR')
  57.  
  58. s="""
  59. create table CLIENTS
  60. (
  61. ID FMTBCD PRIMARY KEY,
  62. COMPANY CHAR(50),
  63. "LAST NAME" CHAR(50),
  64. "FIRST NAME" CHAR(50),
  65. "E-MAIL ADDRESS" CHAR(50),
  66. "JOB TITLE" CHAR(50),
  67. "BUSINESS PHONE" CHAR(25),
  68. "HOME PHONE" CHAR(25),
  69. "MOBILE PHONE" CHAR(25),
  70. "FAX NUMBER" CHAR(25),
  71. ADDRESS MEMO,
  72. CITY CHAR(50),
  73. "STATE/PROVINCE" CHAR(50),
  74. "ZIP/POSTAL CODE" CHAR(15),
  75. "COUNTRY/REGION" CHAR(50),
  76. "WEB-SITE" CHAR(25),
  77. NOTES MEMO,
  78. INCLUDING BLOB
  79. )"""
Add Comment
Please, Sign In to add comment