一个关于pb中sql语句的问题

[zy2lnj]

请问大家一个简单的问题,在pb中带条件的insert语句正确的写法应该是怎么写?
我写的是:insert into "表名" ("列名1","列名2","列名3",……) values("值1","值2","值3",……) where("表名"."列名"=变量)

这样写系统总是说语法错误,请问正确的写法应该是什么?

[liuxhrabbit]

Insert语句在主SQL语句中不能带where条件！
我想你说的可能是嵌套SQL语句中的从语句，如下
insert into table1(col1,col2,col3....) (select aa,bb,cc.... from table2 where table2.列名=变量)

[softdear]

Insert语句干嘛还要带条件呢？不存在这种可能性啊

[fly7801]

可以啊
如下：
ls_sql += " insert blb00000 SELECT b.name,'c',"+ls_sql1+" as quantity,0,0,0,0,'"+is_month+"','"+is_reportid+"' from babh0000 r,bach0000 a,aaa00000 b "
ls_sql += " where r.warehousecode = a.warehousecode and r.vouchertype = a.vouchertype and "
ls_sql += " r.vouchernumber = a.vouchernumber and r.checkoutmonth = a.checkoutmonth and "
ls_sql += " a.itemcode = b.code and a.checkoutmonth ="+ is_month+" and "
ls_sql += " ( a.warehousecode = '0153' ) GROUP BY b.name ORDER BY b.name ASC "

[fly7801]

liuxhrabbit观点正确，刚才没看

[arich]

Insert语句在主SQL语句中不能带where条件！
我想你说的可能是嵌套SQL语句中的从语句，如下
insert into table1(col1,col2,col3....) (select aa,bb,cc.... from table2 where table2.列名=变量)

[zzxxdd]

对呀，insert不能where
用update吧

[zxthello]

insert 不能使用where吧，update 可以！

[Jekson]

Insert Into Table_name ( Name_1,Name_2) Values ('值1','值2')
Where ( Name_1 = :变量1 ) ;

[Jekson]

Oh!,Sorry! ..
Insert Into Table_name ( Name_1,Name_2) Values ('值1','值2') ;

[klbt]

INSERT INTO tablename ( Name_1,Name_2) Values ('值1','值2') ；

[junes8250]

Insert Into Table_name
( 字段1，字段2)
Values
(:变量1,:变量2)
Where 字段X= :变量1 ;

[jdsnhan]

大家说的很清楚了，揭贴吧！