PB9.0创建表为何不成功？
string mysql
mysql="Create Table 成员表"&
+"(成员ID char(5) not null,"&
+"姓名 char(20) not null,"&
+"职务 char(8),"&
+"性别 char(2),"&
+"年龄 integer,"&
+"住址char(20),"&
+"迁入日期 data,"&
+"primary key(ID,name))"
execute immediate:mysql USING SQLCA;
使用的是PB自带的数据库 不能创建表
[解决办法]
mysql中的sql语句语法好像有问题，请查检
[解决办法]
string mysql
mysql= "Create Table 成员表 "&
+ "(成员ID char(5) not null, "&
+ "姓名 char(20) not null, "&
+ "职务 char(8), "&
+ "性别 char(2), "&
+ "年龄 integer, "&
+ "住址 char(20), "&
+ "迁入日期 data, "&
+ "primary key(ID,name)) "
execute immediate:mysql USING SQLCA;
[解决办法]
string mysql
mysql= "Create Table 成员表 "&
+ "(成员ID char(5) not null, "&
+ "姓名 char(20) not null, "&
+ "职务 char(8), "&
+ "性别 char(2), "&
+ "年龄 integer, "&
+ "住址 char(20), "&
+ "迁入日期 date, "&
+ "primary key(成员ID,姓名)) "
execute immediate:mysql USING SQLCA;
