insert mytable(prikey,description select 123,description from someview
呵呵,楼上我们都少写了一个")" insert into mytable(prikey,description) select 123,description from someview where ... --如果有多条记录也会插入,prikey可能是primary key,这样就违反约束,可以在where 后加入条件,这个select 也是一个查询
用数据窗口或者是游码从someview中取出数据至s,然后在 INTO MyTable (PriKey, Description) VALUES (123, :s);
这样试试 INSERT INTO MyTable (PriKey, Description) SELECT '123', Description FROM SomeView where ......... 但是 PriKey 不能是主键!!
呵呵 我也是初学的 当时 也是这样写的 INSERT INTO MyTable (PriKey, Description) VALUES (123, SELECT Description FROM SomeView) 慢慢 就知道了 好运
select 123,description from someview
insert into mytable(prikey,description)
select 123,description from someview where ... --如果有多条记录也会插入,prikey可能是primary key,这样就违反约束,可以在where 后加入条件,这个select 也是一个查询
INTO MyTable (PriKey, Description)
VALUES (123, :s);
INSERT INTO MyTable (PriKey, Description)
SELECT '123', Description
FROM SomeView where .........
但是 PriKey 不能是主键!!
呵呵 我也是初学的 当时 也是这样写的
INSERT INTO MyTable (PriKey, Description)
VALUES (123, SELECT Description
FROM SomeView)
慢慢 就知道了
好运