jiangsheng(蒋晟.Net[MVP]) :
谢谢先,我之前在SQL SERVER2000里用的是
IF not EXISTS (SELECT name FROM sysobjects WHERE name = 'mytable1')
CREATE table mytable1 (MoudleNo int NULL, Para11 int NULL)
就可以实现了
ACCESS里面可以用
SELECT MSysObjects.Name FROM MsysObjects WHERE MSysObjects.Name = 'mytable'
查到是否存在目标表格
但是用
IF not EXISTS (SELECT MSysObjects.Name FROM MsysObjects WHERE MSysObjects.Name = 'mytable')
CREATE table mytable1 (MoudleNo int NULL, Para11 int NULL)
会提示出错,不知在ACCESS里面要怎么改呢??
int nFieldCount = Rs1->Fields->GetCount();
VARIANT varValue;
csTemp.Empty();
while (VARIANT_TRUE != Rs1->GetadoEOF())
{
// Traversing through the Fields collection to get the values.
if(!csTemp.IsEmpty())
csTemp += " ; ";