#define SQL_EDU_VIEW "select af_edu.Ord as Ord,af_edu_title.Name as Name,\
af_edu.start_Date as start_Date,af_edu.position as position,af_edu.end_date as end_date,\
af_edu.branch as branch,af_edu.emcee as emcee,af_edu.object as object,\
af_edu.amount as amount,af_edu.method as method,af_edu.content as content, \
af_edu.title,af_edu_title.Ord \
from af_edu,af_edu_title where af_edu_title.Ord=af_edu.title"这句话运行时总出异常,可是在access里面用这个语句做一个视图就可以用,而且同一个库里面的其他表也都正常
af_edu.start_Date as start_Date,af_edu.position as position,af_edu.end_date as end_date,\
af_edu.branch as branch,af_edu.emcee as emcee,af_edu.object as object,\
af_edu.amount as amount,af_edu.method as method,af_edu.content as content, \
af_edu.title,af_edu_title.Ord \
from af_edu,af_edu_title where af_edu_title.Ord=af_edu.title"这句话运行时总出异常,可是在access里面用这个语句做一个视图就可以用,而且同一个库里面的其他表也都正常
解决方案 »
- cspinbuttonctrl问题
- 请教,如何实现在软件里设置软件的背景图片
- document/view architecture support
- 怎样对CTreeCtrl 进行自动排序
- 请goodboyws(深夜不眠者) 进来接分(请板主保留一天谢谢)
- 急!!关于xml的问题,在线等!
- 各位大虾: 如何实时显示数据库中的纪录?
- 【100分,不够再加!!!】内存释放的问题
- 关于CJLibrary的一个问题,大虾请进!!!
- 有谁知道WM_MENUSELECT,或者OnMenuSelect()怎么用??
- 请教高手:类对象之间的交叉使用时,在各自头文件中包含了对方,但为什么调试却有错误呢?
- 怎么样检测去对方的机器是否通过代理服务器上网(同一局域网,不在对方机器安装任何代理软件)
str="select af_edu.Ord as Ord,af_edu_title.Name as Name,
af_edu.start_Date as start_Date,af_edu.position as position,af_edu.end_date as end_date,
af_edu.branch as branch,af_edu.emcee as emcee,af_edu.object as object,
af_edu.amount as amount,af_edu.method as method,af_edu.content as content,
af_edu.title,af_edu_title.Ord from af_edu,af_edu_title where af_edu_title.Ord=af_edu.title";
recordset.ExecuteSQL(str);
试试看,判断SQL_EDU_VIEW对不对