UsersList表有三个字段,其中的StudyName是空的,只是用来临时显示 StudysList表查询统计出来的条数“count(Study_key)”,这个统计数字不需要写入 表UsersList中的 StudyName字段。 ADOQuery1.SQL.ADD('(select User_UID,User_Name ,StudyName from UsersList, (select count(Study_key) from StudysList where User_UID like''%'+trim(edit1.Text)+'%'') as StudyNum '
+' where User_UID like''%'+trim(edit1.Text)+'%'' ') ;
+' where User_UID like''%'+trim(edit1.Text)+'%'' ') ;
解决方案 »
- 请问谁有delphi关于isapi的教程及资料,找了很久都没有找到相当全面的!
- 应届毕业生求delphi工作
- 请教各位高手一个超难问题,解决立即结贴!
- 没有test.dcu文件,如何建?
- 哪里有地方下载IIS?我没盘!
- delphi+access可以做c/s模式的应用程序吗?
- 在改报表中控件TQRExpr.Expression的值时,我选择不了别的窗体里的数据集控件,为啥?
- 声讨万网,我现在被万网气得吐血
- TreeView Problem?
- 问一个极菜的问题:怎么才能删除Form?
- parameter BegDate not found
- SQL Server 2008 支持 Delphi 7 吗
+' where User_UID like''%'+trim(edit1.Text)+'%'' ') ;
adoquery1.sql.add('select User_UID,User_Name,count(Study_key) as StudyName from UsersList group by User_UID where User_UID like''%'+trim(edit1.Text)+'%''');
ADOQuery1.SQL.ADD('
(select User_UID,User_Name ,count(StudysList.Study_key) as StudyName
from UsersList,StudysList
where User_UID like''%'+trim(edit1.Text)+'%'' and StudysList.User_UID =UsersList.User_UID') ;
(select User_UID,User_Name ,count(StudysList.Study_key) as StudyName
from UsersList,StudysList
where User_UID like''%'+trim(edit1.Text)+'%'' and StudysList.User_UID =UsersList.User_UID'
group by User_UID,User_Name ) ;
采用 lgx0914 兄6楼的方法后,这次错误提示是:该特定字段“User_UID"可以参考 SQL 语句中 FROM 子句列表中的多个表?
盼复。。
(select UsersList.User_UID,User_Name ,count(StudysList.Study_key) as StudyName
from UsersList,StudysList
where User_UID like''%'+trim(edit1.Text)+'%'' and StudysList.User_UID =UsersList.User_UID'
group by User_UID,User_Name ) ;
(select UsersList.User_UID,User_Name ,count(StudysList.Study_key) as StudyName
from UsersList,StudysList
where UsersList.User_UID like''%'+trim(edit1.Text)+'%'' and StudysList.User_UID =UsersList.User_UID'
group by User_UID,User_Name ) 还是那个问题 提示是:该特定字段“User_UID"可以参考 SQL 语句中 FR…
[/Quote]
ADOQuery1.SQL.ADD(' select UsersList.User_UID,User_Name ,count(StudysList.Study_key) as StudyName from UsersList,StudysList '
+' where UsersList.User_UID like''%'+trim(edit1.Text)+'%'' '
+ ' and StudysList.User_UID = UsersList.User_UID group by User_UID,User_Name' ) ;