请看以下代码:
Dim cnDBF As New ADODB.Connection
cnDBF.Open "Provider=MSDASQL.1;Persist Security Info=False;Data Source=dBASE Files;Initial Catalog=D:\"
strsql = "CREATE TABLE zf char(20)"
cnDBF.Execute strsql
可以执行通过
我想将字段 zf 定义为 日期型、数值型等 代码应分别如何写
Dim cnDBF As New ADODB.Connection
cnDBF.Open "Provider=MSDASQL.1;Persist Security Info=False;Data Source=dBASE Files;Initial Catalog=D:\"
strsql = "CREATE TABLE zf char(20)"
cnDBF.Execute strsql
可以执行通过
我想将字段 zf 定义为 日期型、数值型等 代码应分别如何写
解决方案 »
- 关于True DB Grid 8.0 和True DB DropDown 结合使用报错
- 为了使多个客户机存取访问服务器数据库不产生并发冲突问题,是否尽量少用或不用全局的记录集变量?就是避免使用以下象这样的Public变量对吗?
- dll文件调用不了该怎么办
- treeview控件中如何将fullpath属性转换为treeeview控件中的一个节点?
- 帮别人解决怎么样才能在VB中打印出文件
- 如何实现具有记忆功能的编辑框(就像IE的地址栏,能记住之前输入的文本,并在相匹配时再次显示)
- 怎么用API实现common dialog的功能?
- 为什么我多打开几个CSDN的网页就会死???
- CommonDialog中ShowPrinter怎么用。
- 如何在动态程序中设置DataReport的纸张类型?
- 怎样在一个文件夹下快速查找匹配的文件
- 一个简单问题:)
Mapping Data Types
In rowsets and as parameter values, ADO represents data in Microsoft® SQL Server™ 2000 by using the following data types. The ADO enumerated constant, DataTypeEnum, specifies the data type of the Field and Parameter objects.SQL Server Data Type ADO Data Type
bigint -adBigInt
binary -adBinary
bit -adBoolean
char -adChar
datetime -adDBTimeStamp
decimal -adNumeric
float -adDouble
image -adVarbinary
int -adInteger
money -adCurrency
nchar -adWChar
ntext -adWChar
numeric -adNumeric
nvarchar -adWChar
real -adSingle
smalldatetime -adTimeStamp
smallint -adSmallInt
smallmoney -adCurrency
sql_variant -adVariant
sysname -adWChar
text -adChar
timestamp -adBinary
tinyint -adVarbinary
uniqueidentifier -adGUID
varbinary -adVarbinary
varchar -adChar
ADO supports consumer-requested data conversions as shown in this illustration.
cnDBF.Execute strsql
提示: 字段定义语法错误
[SourID] [tinyint] NULL CONSTRAINT [DF__ColumnMap__SourI__6501FCD8] DEFAULT (0),
[SourAttribute] [tinyint] NULL CONSTRAINT [DF__ColumnMap__SourA__65F62111] DEFAULT (0),
[SourTable] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[SourColumn] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[SourDataType] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[DestTable] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[DestColumn] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[DestDataType] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[JoinCol] [tinyint] NULL CONSTRAINT [DF__ColumnMap__JoinC__66EA454A] DEFAULT (0),
[ConvertFun] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[State] [char] (1) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF__ColumnMap__State__67DE6983] DEFAULT ('Y'),
[ColDescription] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
CHECK ([State] = 'N' or [State] = 'Y')
) ON [PRIMARY]
GO
[RegionID] [int] NOT NULL ,
[RegionDescription] [nchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
CONSTRAINT [PK_Region] PRIMARY KEY NONCLUSTERED
(
[RegionID]
) ON [PRIMARY]
) ON [PRIMARY]
GO
我真没法了!!!!!!!!!!!