Apps issue in controlling SQL query execution

[realmilan]

Hi there,

I hope to fine my solution here..

I am developing an app that retrieve data from SQL Server.
I have to execute 2 queries together to come out with result. The problem is the first query is a Stored Procedure that contain (INSERT INTO... EXEC sp_....), this query is shows error in server side but it is executed well, then the second query will read from the inserted result into it sue the first query.

The problem is, when the fist query execute, it make the App goes to Exception part witch not allow the second query to be executed.
Is there any way to make Android Studio ignore the error and execute the second query?

 

[Deleted User]

Difficult to answer this from the information you've given. Please show the following:-

1. Stack trace from the Logcat
2. The relevant parts of code from your app

 

[realmilan]

https://stackoverflow.com/questions/45647456/java-query-execution-android-studio

 

[Deleted User]

So what is the exception?
As I said previously, we need to see the stack trace from your Logcat.
This block of code will effectively stop you seeing the actual exception, so you should remove it, or re-throw the exception.

catch (Exception ex)
           {
               message = "Error";
           }

 

[realmilan]

Dear I request from you to chat, so I can clearly let you know my issue.
Please, How can we chat?

Regards,

 

[Deleted User]

I can get a clear understanding of the issue if you post the stack trace.

 

[realmilan]

I can get a clear understanding of the issue if you post the stack trace.

I did not get (stack trace)

Show me an exaple of it, please

 

[Deleted User]

You're not seeing a stack trace because you catch the exception and do nothing with it. As stated above, remove the catch block from your code.

 

[realmilan]

I shows erroe without the cash block. show me an example of a connection without cash block

You're not seeing a stack trace because you catch the exception and do nothing with it. As stated above, remove the catch block from your code.[/QUOTE

 

[realmilan]

You're not seeing a stack trace because you catch the exception and do nothing with it. As stated above, remove the catch block from your code.

Dear, Please help me .. I really need for this :'(