程序:
strcondb = "Provider=MSDASQL.1;Driver=Microsoft_
Visual Foxpro Driver;SourceDB=" & strPath & ";SourceType=DBF;"
strcreat="insert into base01 values( 'B1310102008','1','_
上海老饭店','1','20001001','20001001','13241261-3'_
,'1','1','1','1','万国和','福佑路242_
号','200010','310101','63111777','63550314'_
,'1','1','160','1','20001010','3','1','1','0','0','1')"
condb.Execute Sqlcreat
问题:
为什么我生成的文件不在strpath目录下面?
高手救我!!!!!!!!!我快不行了!!!
strcondb = "Provider=MSDASQL.1;Driver=Microsoft_
Visual Foxpro Driver;SourceDB=" & strPath & ";SourceType=DBF;"
strcreat="insert into base01 values( 'B1310102008','1','_
上海老饭店','1','20001001','20001001','13241261-3'_
,'1','1','1','1','万国和','福佑路242_
号','200010','310101','63111777','63550314'_
,'1','1','160','1','20001010','3','1','1','0','0','1')"
condb.Execute Sqlcreat
问题:
为什么我生成的文件不在strpath目录下面?
高手救我!!!!!!!!!我快不行了!!!
strcreat="create table base01 ( code char(11),password_
char(40) NOT NULL,unitname char(100),valid char(1),_
tabledate date NOT NULL,filldate date NOT NULL,jud char(20)_
NOT NULL,unitmaster char(20),unit char(20) NOT NULL,filler _
char(20) NOT NULL,fillertel char(20) NOT NULL,delegate char(20),_
adress char(100) NOT NULL,postcode char(6),regio char(6),tel_
char(20),fax char(30),website char(50) NOT NULL,email char(50) _
NOT NULL,regist char(1),unittype char(1),opendate date(4),accommo_
char(1) NOT NULL,travelag char(1) NOT NULL,scenes char(1)_
NOT NULL,rooms int NOT NULL,beds int NOT NULL,level char(1))"