Recent content by Nelson Ng

Hi, We found that "export query result" in V7 is different from previous version. In previous version, once the SQL is input and press the "export query result" button, it can export the SQL result directly. However, in V7, "Execute" the SQL once is required before pressing the "export query...

Thanks for your workaround, Would 'SET COLSEP' can be supported in future release ? Regards, Nelson.

Hi Marco, I understand that the feature is not supported. Is there any workaround ? Regards, Nelson.

Hi, Do anyone know how can I use "set colsep ," in the command window ? I've some SQLplus scripts which generate formatted output and now cannot be run in the command window, please help. Regards, Nelson.

my NLS_LANG is AMERICAN_AMERICA.ZHT16BIG5 How to fix it if I wish to store 2000 chars in addition to some #D#A (line feed) ? Will it exceed the max. length of the SQL string ? Regards, Nelson.

To further explain, Currently, it can save upto 1300 English characters + 13 #D#A for a field of varchar2(2000) Regards, Nelson.

Hi, I also have the same problem and the session already set bcAutoDetect. I found it is not related to the length of the field as I increase the length of the field in database from 2000 to 2300 say, the same error occurs. Any help ? Current version 3.4.6.1 with D5 Chinese OS but the data...

We also have same problem. We tried to use the non-union SQL to define the TField and change it to union SQL at runtime but still failed. Is there any workaround without changing TOracleDataSet ? Regards, Nelson.

Still waiting for reply, any idea or any additional information I can check ? BTW, in registry, under ORACLE\ALL_HOMES\ there are ID0, ID1, ... while under ORACLE\ there are HOME0, HOME1, ... All of them have NLS_LANG parameters, but some are "NA", some are standard NLS_LANG format. If, say...

I've done exactly what you said but still fail. FYI, there are 2 Oracle Home : one is 8.1.7, one is 8.0.6 The installation (not by me) history is : 1. 8.0.6 Oracle form 2. 8.1.7 client (by renaming the 8.0.6 directory and clear registry first and install again) server is 8.1.7 I've checked...

Hi, I got access to the registry and find there is multiple home and the default one is now pointing to the one SQLplus works. However, if I run the DOA program, the same error still occurs. Do you have any idea ? Regards, Nelson.

It is from a different home (not the default) but I've set it as the default database using Home Selector. Since I cannot modify the registry, is there any command to change and check the default home

I have an program that access an Oracle 8i database using DOA 3.4. In some PCs, when run the program, an error occured : ORA-12154 TNS: Could not resolve service name We tried other Oracle tools e.g. SQLPlus, Net Assistant and tngping. They connect fine. Does anybody has any ideas? Please...

Hi, I've similar problem but I don't use ini file. If I used TNSPing/sqlplus, it works fine. Please help. Regards, Nelson.

Hi, My problem has now been fixed in the coming release. Support said it is due to insufficient buffer size allocated. You may ask for a prerelease version to test if it works for you. Good luck, Nelson.