Bindings?

Bindings?

Postby TimTaylor » Wed 22 Nov 2017 14:16

Hi there,

how will standard bindings like this work?

Code: Select all
select *
from ht_symbo
where  SYMBOLISCHERNAME like UPPER('%&symb_name%')
and datenbank = 'VVT'
TimTaylor
 
Posts: 3
Joined: Wed 22 Nov 2017 14:10

Re: Bindings?

Postby .jp » Wed 22 Nov 2017 14:27

Hello,

Thanks for the post.
Could you please tell us what product you are using and its version.
Also please provide a server version.

Best Regards.
.jp
Devart Team
 
Posts: 303
Joined: Wed 09 Sep 2009 06:55
Location: devart

Re: Bindings?

Postby TimTaylor » Wed 22 Nov 2017 14:46

I just tried dbforge studio 3.10.12 with oarcle 12

Toad and SQL Navigator are showing popup windows for an entry for this, dbforge studio just complains about no binding.
TimTaylor
 
Posts: 3
Joined: Wed 22 Nov 2017 14:10

Re: Bindings?

Postby YuriP » Mon 27 Nov 2017 09:43

Hello,

dbForge Studio for Oracle uses symbol colon for parameters binding:

Code: Select all
select *
from ht_symbo
where  SYMBOLISCHERNAME like UPPER(:var)
and datenbank = 'VVT'


Best regards,
YuriP
 
Posts: 11
Joined: Fri 27 May 2016 12:49
Location: Devart

Re: Bindings?

Postby TimTaylor » Wed 29 Nov 2017 06:37

Oh ok strange, why dont use the standard here?
TimTaylor
 
Posts: 3
Joined: Wed 22 Nov 2017 14:10

Re: Bindings?

Postby alexa » Wed 29 Nov 2017 19:05

You can add a suggestion on our UserVoice forum where other users can vote for it https://devart.uservoice.com/forums/132897-dbforge-studio-for-oracle

We collect and analyze the information from this forum in order to make a proper roadmap for the future product releases.
alexa
Devart Team
 
Posts: 2170
Joined: Fri 24 Jun 2011 14:17


Return to dbForge for Oracle