Devart Forums

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

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\'.

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

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

In the output windows I see the general log with the message

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 cannot switch to the SQL-Log as the error popup is modal.
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

SELECT 3 FROM UAL
*
Error at line 1
ORA-00942: table or view does not exist

So I immediately know what wrong in my script and can decide if I want to ignore or continue.

Is there a way to get similar information with devart ?

Best regards
Yann

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.

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.

Thank you for the reply.

We will fix this in future product versions.

Thank you