用ado做一个添加列函数，请问高手如何处理CreateField（）中的参数呀？？ [问题点数：0分]
-
本版专家分：10结帖率 100% -
回复次数1楼主可以具体给一个例子么？？
void f(string s,....)
{
CDaoTableDef td(&db); //db为数据库参数不用传。
td.CreateField（s,....）;
}问题点数：0分
-
本版专家分：82
-
#1 得分：0函数原型：
void CreateField( LPCTSTR lpszName,short nType,long lSize,long lAttributes=0 );
或void CreateField( CDaoFieldInfo& fieldinfo );
lpszName：是列名；
nType ：数据类型；
lSize ：数据长度；
Type Size (bytes) Description
dbBoolean 1byte BOOL
dbByte 1 BYTE
dbInteger 2 int
dbLong 4 long
dbCurrency 8 Currency (COleCurrency)
dbSingle 4 float
dbDouble 8 double
dbDate 8 Date/Time (COleDateTime)
dbText 1–255 Text (CString)
dbLongBinary 0 Long Binary (OLE Object),CLongBinary or CByteArray
dbMemo 0 Memo (CString)
你参照这个表，找自己需要的信息就可；
建议你去查msdn，上面很详细的
- 其他相关推荐
- C++使用ADO2数据库类查询、添加、修改、删除操作
- 在工程中添加ado2.h、ado2.cpp两个文件 如果项目之前在XP在编译，在换到WINDOWS7编译时可能会出错，这是因为msado15.dll和MSJRO.DLL版本的问题。 XP SP3下msado15.dll：2.81.3014.0 MSJRO.DLL：2.81.3012.0 此文件在：C:\Program Files\Common Files\System\ado目录
- ADO连接oracle数据库，并调用带参数的存储过程
- 这两天要写一个与oracle存储过程相关的测试程序，可恨自己对着一无所知，探索两天终于出来了，记录之，备以后留用。啦啦啦啦~~~~ first：连接oracle数据库。 工具：oracle 11g 环境：我的数据库存在于虚拟机的远程主机上，所以要进行远程连接。需要在自己的电脑上装备上 Oracle 的客户端。设置数据源。 设置数据源步骤：1，安装好oracle client 11g 后，打
- ADO教程（执行带参数存储过程）
- 由于最近项目上要使用ADO访问数据库，而网上又没有非常完整的帖子，干脆摸着石头过河来总结一个ADO的使用；首先不得不说ADO的使用率并不是很高 1.ADO是微软提供的访问各种数据库的统一接口，是对底层的COM技术OLE DB的封装；它的主要优点是易于使用,高速度,低内存开销,和一个小磁盘占用，缺点：开发效率相对不高； ADO 是一个面向对象的 COM 组件库，用 ADO 访问
- i.MX53系列wince7.0 BSP
- ATHEROS The Licensed Software includes software developed by Atheros Communications, Inc. (“Atheros”). You must separately obtain rights beyond evaluation and demonstration in connection with the Licensed Software from Atheros. ARM The Licensed Software may include software developed by ARM, Ltd. The software may only be used with an ARM microprocessor, which includes the Freescale i.MX and MXC product lines. CODEC STANDARDS This software includes codec standards for encoding and decoding audio and visual content. You are not licensed for any implementation or distribution of the technology in any commercial product or service such as runtime images that you develop using this software. You are responsible for determining and securing these license rights. CSR The Licensed Software includes software and hardware developed by Cambridge Silicon Radio, Inc. (“CSR”). You must separately obtain rights beyond evaluation and demonstration in connection with the Licensed Software from CSR. AVC/H.264 VISUAL STANDARD. This software may include AVC/H.264 video decoding technology, MPEG LA, L.L.C. requires this notice: THIS PRODUCT IS LICENSED UNDER THE AVC/H.264 PATENT PORTFOLIO LICENSES FOR THE PERSONAL AND NON-COMMERCIAL USE OF A CONSUMER TO (A) ENCODE VIDEO IN COMPLIANCE WITH THE AVC/H.264 STANDARD (“AVC/H.264 VIDEO”) OR (B) DECODE AVC/H.264 VIDEO THAT WAS ENCODED BY A CONSUMER ENGAGED IN A PERSONAL AND NON-COMMERCIAL ACTIVITY AND/OR WAS OBTAINED FROM A VIDEO PROVIDER LICENSED TO PROVIDE AVC/H.264 VIDEO. NO LICENSE IS GRANTED OR WILL BE IMPLIED FOR ANY OTHER USE. If you have questions about the AVC/H.264 visual standard, please contact MPEG LA, L.L.C., 250 Steele Street, Suite 300, Denver, Colorado 80206; www.mpegla.com. MPEG-2 VISUAL STANDARD. This software includes MPEG-2 visual decoding technology. MPEG LA, L.L.C. requires this notice: USE OF THIS PRODUCT IN ANY MANNER THAT COMPLIES WITH THE MPEG 2 VISUAL STANDARD IS PROHIBITED, EXCEPT FOR USE DIRECTLY RELATED TO (A) DATA OR INFORMATION (i) GENERATED BY AND OBTAINED WITHOUT CHARGE FROM A CONSUMER NOT THEREBY ENGAGED IN A BUSINESS ENTERPRISE, AND (ii) FOR PERSONAL USE ONLY; AND (B) OTHER USES SPECIFICALLY AND SEPARATELY LICENSED BY MPEG LA, L.L.C. If you have questions about the MPEG-2 visual standard, please contact MPEG LA, L.L.C., 250 Steele Street, Suite 300, Denver, Colorado 80206; www.mpegla.com. MPEG-4 VISUAL STANDARD This software includes MPEG-4 visual decoding technology. This technology is a format for data compression of video information. MPEG LA, L.L.C. requires this notice: USE OF THIS PRODUCT IN ANY MANNER THAT COMPLIES WITH THE MPEG 4 VISUAL STANDARD IS PROHIBITED, EXCEPT FOR USE DIRECTLY RELATED TO (A) DATA OR INFORMATION (i) GENERATED BY AND OBTAINED WITHOUT CHARGE FROM A CONSUMER NOT THEREBY ENGAGED IN A BUSINESS ENTERPRISE, AND (ii) FOR PERSONAL USE ONLY; AND (B) OTHER USES SPECIFICALLY AND SEPARATELY LICENSED BY MPEG LA, L.L.C. If you have questions about the MPEG-4 visual standard, please contact MPEG LA, L.L.C., 250 Steele Street, Suite 300, Denver, Colorado 80206; www.mpegla.com. VC-1 VISUAL STANDARD. This software may include VC-1 visual decoding technology. MPEG LA, L.L.C. requires this notice: THIS PRODUCT IS LICENSED UNDER THE VC-1 PATENT PORTFOLIO LICENSES FOR THE PERSONAL AND NON-COMMERCIAL USE OF A CONSUMER TO (A) ENCODE VIDEO IN COMPLIANCE WITH THE VC-1 STANDARD (“VC-1 VIDEO”) OR (B) DECODE VC-1 VIDEO THAT WAS ENCODED BY A CONSUMER ENGAGED IN A PERSONAL AND NON-COMMERCIAL ACTIVITY AND/OR WAS OBTAINED FROM A VIDEO PROVIDER LICENSED TO PROVIDE VC-1 VIDEO. NO LICENSE IS GRANTED OR SHALL BE IMPLIED FOR ANY OTHER USE.
- 学习总结---ADO编程中_ConnectionPtr的open函数连接字符串
- 先直接看代码： m_pConnection.CreateInstance("ADODB.Connection"); _bstr_t ConnectStr = "Provider=SQLOLEDB.1;\ Integrated Security=SSPI;\ Persist Security Info=False;\ Initial Catalog=AdventureWorksDW2012;\
- 如何在VB中引用ADO?
- 在VB6.0中引用ADO： 通过选择“工程”菜单中的“引用...”来为 ADO 对象库添加一个引用，然后在“引用...”对话框中选择 Microsoft ActiveX Data Objects 2.0 Library 点上图确定。工程就引用了ADO。 运行代码示例： Private Sub Command1_Click() Dim c
- ADO开发中如何得到表格字段名
- [ 原创文档 本文适合初级读者 已阅读5887次 ]ADO开发中如何得到表格字段名作者：杨桂文下载本文示例源代码在数据库的开发过程中，常用的操作不仅有添加、修改、删除记录，还有对字段的操作，而获得字段名就是其中的一种。获得字段名之前必须先与数据库建立连接，再打开相应的表，再得到表的字段集，下面以一程序为例，说明如何得到字段名。 • 新建一 VC MFC
- 成为excel高手必须掌握的54个函数
- 帮大家整理了一下Excel函数，学习Excel函数本身并不难，难的是函数和函数的嵌套。一些平时被大家忽略的小函数，如果灵活应用也可以有大用途，特别是在用Excel设计分析模板的时候。一共列出了六大类共54个函数，其中红色的是必须优先掌握的。日期函数day，month，year，date，today，weekday，weeknum日期函数是只做分析模板的必备神器，可以用日期函数来控制数据的展示。比如下
- VBA中使用ADO来处理Excel数据之现状
- VBA中使用ADO来处理Excel数据之现状 Excel工作表中的行和列与数据库中的行和列非常相似。ADO 让我们可以将 Excel 工作簿看做和数据库一样,用ADO的好处是可以不通过OPEN的方式访问工作簿,如此可以绕过不使用宏即关闭工作簿等陷井,也可以建立sql查询语句,快速搜索相关符合要求的记录,但EXCEL毕竟不是关系数据库,当我们努力想把ADO的访问技术发挥到