Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

FbScript Exception [DNET746] #688

Closed
firebird-automations opened this issue Mar 24, 2017 · 4 comments
Closed

FbScript Exception [DNET746] #688

firebird-automations opened this issue Mar 24, 2017 · 4 comments

Comments

@firebird-automations
Copy link

Submitted by: Marcos R. Weimer (marcosweimer)

- 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\(\);

}

@firebird-automations
Copy link
Author

Commented by: @mrotteveel

Please include the exception stacktrace.

@firebird-automations
Copy link
Author

Commented by: Marcos R. Weimer (marcosweimer)

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.

@firebird-automations
Copy link
Author

Commented by: @cincuranet

The message is pretty clear, I think.

@firebird-automations
Copy link
Author

Modified by: @cincuranet

status: Open [ 1 ] => Closed [ 6 ]

resolution: Won't Fix [ 2 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants