ksql问题

offnotree

delete from PE_Personinfo where PE_Personinfo.fID in ( select a.* from (select PE_PersonInfo.fXGXID from PE_PersonInfo  where PE_PersonInfo.fZBID='4406454572CB49399AE484DF510CD5F7') a)

如题,这句在sql数据库里可以运行, 改写成ksql就跑不了,请问ksql这句话怎么写?

jason2014

好像in不行的。可以用sql

offnotree

jason2014 发表于 2015-4-2 15:29
好像in不行的。可以用sql

提示: pe.fID找不到对应的关系映射 ,ksql如下
String ksql="delete from PE_PersonInfo pe where pe.fID in (select pe1.fXGXID from PE_PersonInfo pe1  where pe1.fZBID='"+key+"')";

lanware_smf

offnotree 发表于 2015-4-2 15:37
提示: pe.fID找不到对应的关系映射 ,ksql如下
String ksql="delete from PE_PersonInfo pe where pe.fID  ...

String ksql="delete from PE_PersonInfo pe where pe in (select pe1.fXGXID from PE_PersonInfo pe1  where pe1.fZBID='"+key+"')";
pe就代表概念，映射到数据库就是pe.fID，所以这边直接使用pe

offnotree

lanware_smf 发表于 2015-4-2 15:44
String ksql="delete from PE_PersonInfo pe where pe in (select pe1.fXGXID from PE_PersonInfo pe1  w ...

改了之后,ksql为
String ksql="delete from PE_PersonInfo pe where pe in (select #123.* from (select pe1.fXGXID from PE_PersonInfo pe1  where pe1.fZBID='"+key+"') #123)";

这个报错,不知道怎么解决
编码: JUSTEP154046; 提示: KSQL语法错误, pe in (select ^^#123.* from (se中未找到需要的元素, 位置49期望是以下元素之一：STRING, NUMBER, ONE_RELATION, IDENTIFER, VARIABLE

jishuang

offnotree 发表于 2015-4-2 15:57
改了之后,ksql为
String ksql="delete from PE_PersonInfo pe where pe in (select #123.* from (select  ...

别名最好不要用#等这些特殊字符开头

红楼居梦

楼主，能不能把你写的这个删除的action代码分享一下，看看怎么写的