Toad World® Forums

Code Snippets have disappeared

Hi,

I’m using TOAD for Oracle 12.7 DBA Suite

The Code Snippets Categories are visible but the code for the categories is not visible.

I have not upgraded recently or made changes.

This is an original install so there are no previous user settings to install.

There is a CodeSnippets.err file dated Jan 9 2017.

Text as follows:

TPF0

TCodeSnippets_1Categories.StringsCursor AttributesData Conversion FunctionsDate Format OptionsDate FunctionsDefined ExceptionsGroup FunctionsNumber Format OptionsOracle Pseudo ColumnsOther Misc. FunctionsRegular ExpressionsSingle Row Character FunctionsSingle Row Number FunctionsSql Optimizer hintsUser provided Function List Items

What do I need to do?

Thanks.

Unfortunately the file has become corrupt and any changes you had made to Code Snippets in 12.7 are lost.

To restore snippets…

  1. Close Toad

  2. If you have made customizations to your Code Snippets in a prior version of Toad and you still have the User Files lying around for it you can copy CodeSnippets.dat from the its user files folder to your 12.7 user files folder. The User Files folder will be located here by default… %APPDATA%\Quest\Toad for Oracle<TOAD_VERSION>\User Files. If you did not have customizations made then just delete CodeSnippets.dat from your 12.7 User Files folder and start Toad. The default set will be restored.

Michael

Hi Michael,

Thanks for the prompt reply.

I found a backup and restored it successfully.

I also tried the method of deleting the CodeSnippets.dat file (no customizations) and that was successful as well.

Thank you for your help.

Best regards,

Moses

Hi Michael,

I tried to post the text below into the forum in response to your the forum post.

I just sat and spun and never updated.

I wanted to make sure you got a response from me and that your suggestion resolved the problem

Thanks for your help.

Best regards,

Moses

Hi Michael,

Thanks for the prompt reply.

I found a backup and restored it successfully.

I also tried the method of deleting the CodeSnippets.dat file (no customizations) and that was successful as well.

Thank you for your help.

Best regards,

Moses

Moses Schilling, CTR SAIC

AMK-212D

Enterprise Business Office

Enterprise Services Center (ESC) | 6500 S. MacArthur Blvd. Oklahoma City, OK 73169

Phone: 405.954.4792

moses.ctr.schilling@faa.gov

When your only tool is a hammer, pretty soon all your problems look like nails.

From: Michael Staszewski [mailto:bounce-mstaszew@toadworld.com]

Sent: Thursday, January 19, 2017 9:01 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Code Snippets have disappeared

RE: Code Snippets have disappeared

Reply by Michael Staszewski

Unfortunately the file has become corrupt and any changes you had made to Code Snippets in 12.7 are lost.

To restore snippets…

  1. Close Toad

  2. If you have made customizations to your Code Snippets in a prior version of Toad and you still have the User Files lying around for it you can copy CodeSnippets.dat from the its user files folder to your 12.7 user files folder. The User Files folder will be located here by default… %APPDATA%\Quest\Toad for Oracle<TOAD_VERSION>\User Files. If you did not have customizations made then just delete CodeSnippets.dat from your 12.7 User Files folder and start Toad. The default set will be restored.

Michael

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle Forum
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.