Print Thread
SQL Window: How to get old behaviour?
#42385 10/04/11 07:42 AM
Joined: Mar 2007
Posts: 147
Zagreb, Croatia
DoDo Offline OP
Member
OP Offline
Member
Joined: Mar 2007
Posts: 147
Zagreb, Croatia
Recently, I began to prepare a new working environment, because I want to replace the old PC. After installing PLD, SqlWindow in QBE places :var1, instead, as formerly, the entered value. How to restore the old behavior? On the old PC it is working normally, but on it, the PLD was upgraded. I guess it's a setting, but I have not managed to find it.

Please help me, because this behavior with :var1 ... is not pleasant to work with.


DoDo
--------------------------------------------
Be happy, tomorrow it can become only worse. If not, even better!
Re: SQL Window: How to get old behaviour?
DoDo #42387 10/04/11 08:49 AM
Joined: Aug 1999
Posts: 22,216
Member
Offline
Member
Joined: Aug 1999
Posts: 22,216
This indicates that you are connected to a Unicode database, and that your Oracle Client uses a non-Unicode character set. There are 2 solutions:

1. Switch the Oracle Client to Unicode character set UTF8
2. Disable Unicode support through the preferences (Tools > Preferences > Oracle / Options)


Marco Kalter
Allround Automations
Re: SQL Window: How to get old behaviour?
Marco Kalter #46677 04/02/13 10:04 AM
Joined: Mar 2007
Posts: 147
Zagreb, Croatia
DoDo Offline OP
Member
OP Offline
Member
Joined: Mar 2007
Posts: 147
Zagreb, Croatia
Here we go again...

Once more, I've upgraded from 9 to 10 and again this problem appears, but this time solution nr. 2 does not work. Why, why, why???

I just want to upgrade without this prloblem again, please.
Tried to set other OCI but it ignores any of my setting, again...

This is to much for me today, and I ask myself should I switch to another product.

Preferences
Session mode: Multi
OCI Library: C:\orant\des\BIN
Use OCI7: False
Allow Multiple Connections: True

Using
Home: OraOdac11g_home1
DLL: C:\app\ddukic\product\11.1.0\client_1\oci.dll
OCI: version 11.1
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0

Character Sets
Character size: 1 byte(s)
CharSetID: 0
NCharSetID: 1
Unicode Support: False
NLS_LANG: CROATIAN_CROATIA.EE8MSWIN1250
NLS_CHARACTERSET: EE8ISO8859P2
NLS_NCHAR_CHARACTERSET: AL16UTF16


DoDo
--------------------------------------------
Be happy, tomorrow it can become only worse. If not, even better!
Re: SQL Window: How to get old behaviour?
DoDo #46681 04/02/13 10:36 AM
Joined: Aug 1999
Posts: 22,216
Member
Offline
Member
Joined: Aug 1999
Posts: 22,216
Nothing should have changed. Can you send me an example by e-mail with some screenshots?


Marco Kalter
Allround Automations
Re: SQL Window: How to get old behaviour?
Marco Kalter #46684 04/02/13 12:43 PM
Joined: Mar 2007
Posts: 147
Zagreb, Croatia
DoDo Offline OP
Member
OP Offline
Member
Joined: Mar 2007
Posts: 147
Zagreb, Croatia
I've sent you an e-mail.


DoDo
--------------------------------------------
Be happy, tomorrow it can become only worse. If not, even better!
Re: SQL Window: How to get old behaviour?
DoDo #46697 04/03/13 10:29 AM
Joined: Mar 2007
Posts: 147
Zagreb, Croatia
DoDo Offline OP
Member
OP Offline
Member
Joined: Mar 2007
Posts: 147
Zagreb, Croatia
Please, add an option to disable child window query with new "Auto refresh child window" feature on child window itself (with conversion m_ variable to value passed from parent window), and also please add preference to set default option on this.

Thanks.


DoDo
--------------------------------------------
Be happy, tomorrow it can become only worse. If not, even better!
Re: SQL Window: How to get old behaviour?
DoDo #46701 04/03/13 10:52 AM
Joined: Aug 1999
Posts: 22,216
Member
Offline
Member
Joined: Aug 1999
Posts: 22,216
I have added this to the list of enhancement requests.


Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.029s Queries: 14 (0.011s) Memory: 2.5252 MB (Peak: 3.0420 MB) Data Comp: Off Server Time: 2024-05-12 21:39:06 UTC
Valid HTML 5 and Valid CSS