使用逗号的 sybase dbeaver 与 sybase Interactive SQL
我在 Interactive SQL 中进行此选择时遇到问题
select "set rowcount 0 exec up_gen_vyroci_inner_bal", "'", dateadd( dd, - pocet_dni_pred_vyrocim , a.dat_vyroci ) "',", a.c_poj_sml,",",0,",'" , a.dat_vyroci,"',",13,",",1,",",0
from d_poj_bal as a
inner join d_poj_bal as b on a.c_poj_sml = b.c_poj_sml
inner join c_balicek_bal as c on b.c_balicek = c.c_balicek
where a.c_poj_sml in ( 6142953209) and a.rezim_ps = 1
and not exists ( select 1 from d_fronta_bal as f where a.c_poj_sml = f.c_poj_sml and a.c_dodatku = f.c_dodatku and f.c_typ_transakce = 7 )
,得到结果:
set rowcount 0 exec up_gen_vyroci_inner_bal ' 2013-06-06 00:00:00.0 ', 6142953209 , 0 ,' 2013-08-15 00:00:00.0 ', 13 , 1 , 0
其中我我稍后可以用来执行我的程序。
但是当我在 Dbeaver 中尝试相同的精确选择时,我收到错误 Dbeaver 错误
我已经尝试重写逗号但没有运气 我认为主要问题在于 IDE 以及两个程序中逗号的不同使用,但我不确定如何修复它以在这两个程序中工作。
预先感谢您的任何帮助
i have a problem with this select
select "set rowcount 0 exec up_gen_vyroci_inner_bal", "'", dateadd( dd, - pocet_dni_pred_vyrocim , a.dat_vyroci ) "',", a.c_poj_sml,",",0,",'" , a.dat_vyroci,"',",13,",",1,",",0
from d_poj_bal as a
inner join d_poj_bal as b on a.c_poj_sml = b.c_poj_sml
inner join c_balicek_bal as c on b.c_balicek = c.c_balicek
where a.c_poj_sml in ( 6142953209) and a.rezim_ps = 1
and not exists ( select 1 from d_fronta_bal as f where a.c_poj_sml = f.c_poj_sml and a.c_dodatku = f.c_dodatku and f.c_typ_transakce = 7 )
in Interactive SQL i get the result:
set rowcount 0 exec up_gen_vyroci_inner_bal ' 2013-06-06 00:00:00.0 ', 6142953209 , 0 ,' 2013-08-15 00:00:00.0 ', 13 , 1 , 0
which i am able to use later for executing my procedure.
but when i try the same exact select in Dbeaver i get the error
Dbeaver error
I already tried to rewrite the commas but with no luck
I think the main problem is with IDE and different use of commas in both programs, but I am not sure of how to repair it to work in both.
Thanks in advance for any help
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论