如何对表进行连续查询？(100分)

G

gq_gq

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-03-13

• #1

 

W

wangjerry

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-03-13

• #2

什么意思？

 

H

htw

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-03-13

• #3

用几个for 循环
或者手工做

 

G

gq_gq

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-03-13

• #4

通过一个查询条件后，如何在得到记录集合中再进行下一次查询。

 

Z

zhj_nc

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-03-13

• #5

你可以用SElECT的嵌套

 

D

doud

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-03-13

• #6

1.先在Query或Table的Filter写入查询条件。无须设Filtered=true;
2.执行Query.FindNext;
3.完成

 

L

liu_liu

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-03-13

• #7

1.执行数据库端：Select
2.对Query的Filter写入过滤条件，或使用Locate

 

Z

zhangkan

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-03-13

• #8

动态查询？！

 

S

sportsman

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-03-13

• #9

可以在源记录集中加条件再查呀。
说穿了，就是动态查询

 

L

Langrisser

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-03-13

• #10

select *
from table1
where 条件1 and 字段1 in (select 字段1 from table1 where 条件2)

 

Y

yaya8163

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-04-17

• #11

liu_liu想法跟我相同

 

萧

萧月禾

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-04-17

• #12

可以先把数据读到数据集，再用filter

或使用子查询嵌套之

 

Z

zqmagic

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-04-19

• #13

try union,标准sql

 

D

delphi_lsl

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-09-11

• #14

what mean?

 

D

deyan

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-03-27

• #15

0

 

Y

Yumpar

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-03-27

• #16

？

 

Z

zxb200

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-03-30

• #17

可參考：
select * from table1 from
(select * from table1 where 條件) as tablename
where 條件