Hi, I have been using SQL nav 4 for about a year now running the same script. About two weeks ago, it started acting wired. Whenever, I run a script to pull records from my table, if the “fetch all” button is not on, no record will be display and if I turn that on the first record does not display. Record always starts from the 2nd row in my table but sees that as the first row.
The only thing I recall was that I did install Oracle Lite - Oracle 8 Navigator for other purpose about two weeks ago and that’s about the same time I started experience this malfunction of SQL Navigator.
I just noticed in HKEY_LOCAL_MACHINE ->ORACLE the ORACLE_HOME is c:/orant and ORACLE_HOME_NAME is DEFAULT_HOME
The c:/orant is the directory of the oracle lite. I am not sure if I change it to c:/program files/sql navigator 4 as its in the HKEY_LOCAL_MACHINE ->QUEST SOFTWARE it will solve it or not.