|
SQL Window: How to get old behaviour?
|
Joined: Mar 2007
Posts: 147 Zagreb, Croatia
Member
|
OP
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?
|
Joined: Aug 1999
Posts: 22,216
Member
|
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?
|
Joined: Mar 2007
Posts: 147 Zagreb, Croatia
Member
|
OP
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?
|
Joined: Aug 1999
Posts: 22,216
Member
|
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?
|
Joined: Mar 2007
Posts: 147 Zagreb, Croatia
Member
|
OP
Member
Joined: Mar 2007
Posts: 147 Zagreb, Croatia |
DoDo -------------------------------------------- Be happy, tomorrow it can become only worse. If not, even better!
|
|
|
Re: SQL Window: How to get old behaviour?
|
Joined: Mar 2007
Posts: 147 Zagreb, Croatia
Member
|
OP
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?
|
Joined: Aug 1999
Posts: 22,216
Member
|
Member
Joined: Aug 1999
Posts: 22,216 |
I have added this to the list of enhancement requests.
Marco Kalter Allround Automations
|
|
|
|
|
|