Issue Details (XML | Word | Printable)

Key: DNET-746
Type: Bug Bug
Status: Closed Closed
Resolution: Won't Fix
Priority: Major Major
Assignee: Jiri Cincura
Reporter: Marcos R. Weimer
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
.NET Data provider

FbScript Exception

Created: 24/Mar/17 08:23 PM   Updated: 27/Mar/17 12:52 PM
Component/s: ADO.NET Provider
Affects Version/s: 5.8.0.0
Fix Version/s: None

Environment: Visual Studio 2015 / target .Net Framework 4.0


 Description  « Hide
- Read script file and execute:
- Multiple lines with comments
- null except in execute this specific line: "delete from custo_reposicao_atual; -- deletar tudo pq na 514 teve alteracoes e pode estar errado o custo"

Example:

ExecuteScript("delete from custo_reposicao_atual; -- deletar tudo pq na 514 teve alteracoes e pode estar errado o custo")

public void ExecuteScript(string ASQL)
{
            FbScript sc = new FbScript(ASql);

            sc.Parse(); ---> exception here
            FbBatchExecution fbe = new FbBatchExecution(FConexao);
            fbe.AppendSqlStatements(sc);
            fbe.Execute();
}


 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Mark Rotteveel added a comment - 24/Mar/17 09:18 PM
Please include the exception stacktrace.

Marcos R. Weimer added a comment - 27/Mar/17 12:47 PM
Exception message:

The type of the SQL statement could not be determined. See also UnknownStatement event.
Statement: -- deletar tudo pq na 514 teve alteracoes e pode estar errado o custo.

Exception.StackTrace:

   em FirebirdSql.Data.Isql.FbScript.Parse()
   em UltraBanco.Banco.ExecuteScript(String ASql) na C:\ultra\UltraBanco\UltraBanco\UltraBanco.cs:linha 475


Comment with / * * / also throws exception.

Jiri Cincura added a comment - 27/Mar/17 12:52 PM
The message is pretty clear, I think.