📄 5045.html
字号:
<html>
<head>
<title>Re: DBcombol的问题</title>
</head>
<body bgcolor="#FFFFFF" vlink="#808080">
<center>
<h1>Re: DBcombol的问题</h1>
</center>
<hr size=7 width=75%>
<hr size=7 width=75%><p>
Posted by <a href="mailto:mxf@atom.im.uec.ac.jp">XF</a> on August 25, 1998 at 17:16:08:<p>
In Reply to: <a href="5042.html">DBcombol的问题</a> posted by yeong huann on August 25, 1998 at 16:45:01:<p>
: 我在表单上安排了一个DBcombol物件,它连结至DATA2这个物件<br>: 当我按下DBcombo1物件时执行下面这一段SQL指令<br>: Form2.Data2.RecordSource = "SELECT DISTINCT ( " & comtext & " ) FROM 产品清单"<br>: ps: comtext 是指使用者选择的栏位名称<br>: 但实际上我希望DATA2每次筛选的资料是源至DATA1筛选之后的结果 <br>: ps:DATA1会在DATA2筛选之前先行筛选,且DATA1与DATA2各另有它<br>: 用,不可互相影响.<br>: 请问各位先进,我上述的SQL指令中的 "FROM 产品清单" 要如何修改才会<br>: 达到我的需求,或另有其它方法.......谢谢<p>I thank there are two method to solve your problem<p>first is use sub SQL query, like this<br>"SELECT * FROM Pub WHERE TARGET IN (SELECT TARGET FROM Books WHERE Master = 'Red')"<br>it is mean that data2.RecordSource is a branch from Data1.RrcordSource .<p>secondly , I don't understand that many person tend to use data control, in my experience,<br>I recommand you to use DAO Object directly, and make program all by hand, so you will find <br>there are a lot of method can be use than data control. Data control is not for professional<br>program development, it is just for samll scale problem or simple problem, if you use it for <br>a large scale problem, you could be meet many problems that you must be recovered.<br>if you use DAO to make your program, it is not a problem that you asked.<p>If you've kown those already, I will be sorry.<br>Good luck!<p>
<br>
<br><hr size=7 width=75%><p>
<a name="followups">Follow Ups:</a><br>
<ul><!--insert: 5045-->
<!--top: 5046--><li><a href="5046.html">谢谢XF赐教</a> <b>yeong huann</b> <i>19:26:16 8/25/98</i>
(<!--responses: 5046-->0)
<ul><!--insert: 5046-->
</ul><!--end: 5046-->
</ul><!--end: 5045-->
<br><hr size=7 width=75%><p>
</body></html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -