SQL Navigator 4.4 SQL trace ?

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

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

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

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

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

Hope it helps,
Gwen

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

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 ???

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

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

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