Hello,
I am using devart fusion from VS 2013.
When I run a script with many sql statements that have errors I get a popup to ask me if I want to stop, continue or ignore all. This is fine.
But the popup only show me the Oracle error. I cannot see what line of code generates the error. So it is difficult to choose if I want stop or continue.
I tried to add the execution detail in the “SqlLog” output. But as the output window automatically switch to the general log when executing a script it doen’t help.
I there a way to see what is executing when I get an error?
Best regards
Yann
Error popup
Re: Error popup
Please perform the following:
1. Select 'Tools -> Options' from the main menu. The 'Options' window opens.
2. Navigate to the 'Devart dbForge Fusion -> Output' branch.
3. Select the 'Write queries sent by the program to the SQL Log' and 'Log application errors' options.
4. Unselect the 'Delete application log after closing' option. Click 'OK'.
5. Restart Visual Studio.
To open Devart SQL Log, select 'View -> Output' from the main menu and select 'Devart - SQLLog' from the drop-down menu in the 'Output' tool window.
Also, the generated log file is placed in the directory '%SystemDrive%\Users\%UserName%\AppData\Roaming\Devart\dbForge Fusion\'.
1. Select 'Tools -> Options' from the main menu. The 'Options' window opens.
2. Navigate to the 'Devart dbForge Fusion -> Output' branch.
3. Select the 'Write queries sent by the program to the SQL Log' and 'Log application errors' options.
4. Unselect the 'Delete application log after closing' option. Click 'OK'.
5. Restart Visual Studio.
To open Devart SQL Log, select 'View -> Output' from the main menu and select 'Devart - SQLLog' from the drop-down menu in the 'Output' tool window.
Also, the generated log file is placed in the directory '%SystemDrive%\Users\%UserName%\AppData\Roaming\Devart\dbForge Fusion\'.
-
- Posts: 8
- Joined: Mon 14 Apr 2014 11:21
Re: Error popup
Hello,
Thank you for your reply but as explain in the previous post this not solve my issue.
Here is an example:
I write the following code in a sql windows.
When I run it I get a message box saying
I have no way to know that the line causing problem is “SELECT 3 FROM UAL;”
As I have sometimes scripts with many lines and as I do not know what code makes the problem I do not know if I have to stop the script or just continue when I get an error.
Other tools, like Toad also give a message box in such case with text
Is there a way to get similar information with devart ?
Best regards
Yann
Thank you for your reply but as explain in the previous post this not solve my issue.
Here is an example:
I write the following code in a sql windows.
Code: Select all
SELECT 1 FROM DUAL;
SELECT 2 FROM DUAL;
SELECT 3 FROM UAL;
SELECT 4 FROM DUAL;
In the output windows I see the general log with the messageAn error occurred in C:\Users\yaugustin\AppData\Local\Temp\{67dea28a-a47f-4305-be80-2cd64c180740}\SQL1.sql.
Additional information: ORA-00942: table or view does not exist
Do you want to stop batch execution or ignore the error and continue?
I cannot switch to the SQL-Log as the error popup is modal.Query opened in 0,004s [0,004s exec, < 0,001s fetch]
Query opened in 0,003s [0,003s exec, < 0,001s fetch]
Error (3,15): ORA-00942: table or view does not exist
I have no way to know that the line causing problem is “SELECT 3 FROM UAL;”
As I have sometimes scripts with many lines and as I do not know what code makes the problem I do not know if I have to stop the script or just continue when I get an error.
Other tools, like Toad also give a message box in such case with text
So I immediately know what wrong in my script and can decide if I want to ignore or continue.SELECT 3 FROM UAL
*
Error at line 1
ORA-00942: table or view does not exist
Is there a way to get similar information with devart ?
Best regards
Yann
Re: Error popup
Please also try invoking the 'Output' tool window by selecting 'View -> Output' from the main menu and then selecting 'Devart - SQLLog' from the drop-down menu in the 'Output' tool window prior to executing the query so when you execute the query, Devart SQLLog should open.
-
- Posts: 8
- Joined: Mon 14 Apr 2014 11:21
Re: Error popup
Sorry, it doesn’t work.
I automatically switch to the general log as soon as you start execution.
For me, the best way would be to show the statement that causes the error in the popup window.
I automatically switch to the general log as soon as you start execution.
For me, the best way would be to show the statement that causes the error in the popup window.