I resolved the problem.
The problem is the carriage return and new line character: "\r\n" and "\n"
I have modified the source like this:
string sqlcommand = String.Empty;
foreach (string cmd in fbs.Results)
{
sqlcommand = cmd.Replace("\r\n", " ").Replace("\r", "
").Replace("\n", " ");
fbe.SqlStatements.Add(sqlcommand);
}
fbe.Execute(true);
It works ok...All I have to do is to manage the quoted fields and
domains...generate errors to!
Could be improved Results method to replace "\r" and "\n" with spaces or
this is the application job?
Best regards,
Paul
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf
> Of Jiri Cincura
> Sent: Wednesday, March 05, 2008 11:20 AM
> To: For users and developers of the Firebird .NET providers
> Subject: Re: [Firebird-net-provider] I get error using FbScript and
> FbBatchExecution
>
> On 3/5/08, Mercea Paul <[EMAIL PROTECTED]> wrote:
> > And application works ok now, the test one, with FB1.5,FB2.1!
> > How can I make this work on real database? I can't make new database
> on
> > every DDL update on database!
>
> You don't need. Just call DDL statement you want and that's it. No
> matter whether you use FbCommand directly or Isql namespace classes.
>
> 1. Connect to database.
> 2. Run command.
> 3. Disconnect or whatever...
>
> --
> Jiri {x2} Cincura (CTO x2develop)
> http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
>
> -----------------------------------------------------------------------
> --
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> Firebird-net-provider mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
