insert into 的用法？(100分)

N

nb121212

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-07

• #1

有mydata.mdb数据库，下有xj1,xj2数据结构一样的两表，xj1有数据，xj2为空
现adoquery1根据条件将数据从xj1中查询出，再写入xj2中：
ADOquery1.close;
ADOquery1.sql.clear;
ADOquery1.sql.add('select * from xj1 where 天数>7');
ADOquery1.open;
insert into xj2 from ... //怎么写才可以把adoquery1中的数据放到xj2中？

 

H

hbezwwl

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-07

• #2

INSERT INTO xj2 (SELECT * FROM xj1 WHERE 天数>7)

 

X

xdf_hubei

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-07

• #3

晚了一步，本来想挣点银子花花的：（
[][][]

 

完

完颜康

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-07

• #4

100就这么跑了：（

 

N

nb121212

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-07

• #5

INSERT INTO xj2 (SELECT * FROM xj1 WHERE 天数>7)是直接写吗？
还是要ADOquery1.sql.add(‘INSERT INTO xj2 (SELECT * FROM xj1 WHERE 天数>7)’);

 

H

hbezwwl

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-07

• #6

当然是在aodquery1.sql.add('...')这样了。

 

N

nb121212

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-07

• #7

但是编译通不过！！！

 

N

nb121212

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-07

• #8

data1.ADOQuery1.Close;
data1.ADOQuery1.SQL.Clear;
data1.ADOquery1.sql.add('insert into xj2(SELECT * FROM xj1)‘);
data1.ADOQuery1.Open;
但是编译通不过！！！执行出错！！

 

天

天真

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-07

• #9

ADOquery1.close;
ADOquery1.sql.clear;
ADOquery1.sql.add(' insert into xj2 select * from xj1 where 天数>7');
ADOquery1.execsql;

 

完

完颜康

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-07

• #10

不会的
要不你这样
sql :string
sql :='INSERT INTO xj2 (SELECT * FROM xj1 WHERE 天数>7)';
adoquery.sql.text:=sql;
你出错的信息也铁出来

 

N

nb121212

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-07

• #11

”insert into 语句语法错误“

 

H

hbezwwl

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-07

• #12

insert语句只能用execsql的，不能用adoquery.open,
只能adoquery.execsql;

 

昱

昱昱

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-07

• #13

来晚了，连五分都得不到了

 

N

nb121212

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-07

• #14

用adoquery.execsql也是
”insert into 语句语法错误“

 

N

nb121212

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-07

• #15

mysql:='insert into xj2 (SELECT * FROM xj1 where 天数>3)';
data1.ADOQuery1.Close;
data1.ADOQuery1.SQL.Clear;
data1.ADOquery1.sql.add(mysql);
data1.ADOQuery1.ExecSQL;
还是提示“insert into 语句语法错误”

 

N

nb121212

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-07

• #16

天真的OK！

 

完

完颜康

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-07

• #17

mysql := ' insert into xj2 select * from xj1 where 天数>3 ';
......
试试

 

T

tlihui

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-07

• #18

来晚了啊，100分溜了啊