Toad World® Forums

SQL Navigator 4.4 SQL trace ?


#1

iun the SQL Navigator 4.4 where can i found record of sql which user run


#2

Are you talking about the SQL History (or SQL Statement Recall)? If so, there’s a button on the SQL Editor toolbar which opens it. Or you can use Ctrl+Alt+R. It only saves statements which have been executed successfully.

Gwen


#3

yes i want get the SQL History
but i have other question

 which directory the SQL History Saved in ? how can i found it ?

#4

C:\Documents and Settings\user\Application Data\Quest Software\SQL Navigator 4.4\Unified Editor\history

Hope it helps,
Gwen


#5

Sorry, if you are talking about v4.4 then the file is located in the application directory, under the name SQLEditor.hst.

Hope this helps,
Roman


#6

after i come in C:\Documents and Settings\user\Application Data\Quest Software\SQL Navigator 4.4
i can’t found directory of Unified Editor ???


#7

after i install SQL Navigator 5.5 xpert edition ,also can’t found history

C:\Documents and Settings\sam.ma\Application Data\Quest Software\SQL Navigator 5.5.2

2010/01/11 上午 11:46 .
2010/01/11 上午 11:46 …
2010/01/11 上午 11:46 34 QSAuthorize12.key
2010/01/11 上午 11:46 66 fmtOptions.opt
2010/01/11 上午 11:47 18 Project1.WSF
2006/10/20 下午 04:21 49,400 DND.CAC
2001/10/10 上午 08:34 240,609 apior.bin
2001/10/10 上午 08:34 2,081 CODECAT.CAC
2001/10/10 上午 08:34 902 SQLCAT.CAC
2001/10/10 上午 08:34 334 RVLNETP.CAC
2002/05/28 下午 02:27 225,563 RVLNETL.CAC
2001/10/10 上午 08:34 582,330 apipr.bin
2010/01/11 下午 01:36 2,081 CODECAT.~CA
2010/01/11 下午 01:36 902 SQLCAT.~CA
2010/01/11 下午 01:36 242,829 WS.~CA
2010/01/11 下午 01:36 49,400 DND.~CA
2010/01/11 下午 01:36 225,563 RVLNETL.~CA
2010/01/11 下午 01:36 595,722 RVLNETP.~CA
2010/01/11 上午 11:46 Template
2010/01/11 下午 01:35 500 SQLEditor.hst

C:\Documents and Settings\sam.ma\Application Data\Quest Software\SQL Navigator 5.5.2>

when i open SQLEditor.hst , only include portion history of user run

Message was edited by: sam.ma


#8

view----preferences----SQL Editor----previous Limit
set 1000


#9

Hi,

What Roman said meant the SQLEditor.hst in SQLNav install folder, e.g., C:\Program Files\Quest Software\SQL Navigator 4.4. While in 5.5, it locates at C:\Documents and Settings\user\Application Data\Quest Software\SQL Navigator 5.5.x.

You would need to close SQL Navigator to have the executed sqls saved into the SQLEditor.hst file.

Thanks,
Vincent