Re: [Firebird-net-provider] Cannot execute sql statement to recalculate indexes

2010-01-21 Thread Jiri Cincura
2010/1/21 Γιάννης Μπουρκέλης : > Should I also execute "COMMIT" at the end? No. -- Jiri {x2} Cincura (CTO x2develop.com) http://blog.cincura.net/ | http://www.ID3renamer.com -- Throughout its 18-year history, RSA Confer

Re: [Firebird-net-provider] Cannot execute sql statement to recalculate indexes

2010-01-21 Thread Γιάννης Μπουρκέλης
Thanks Jiri, I removed the "set term" lines and works fine. Should I also execute "COMMIT" at the end? 2010/1/21 Jiri Cincura > You don't need to use set term, as with FbCommand you can sent only one > query. > > -- > Jiri {x2} Cincura (CTO x2develop.com) > http://blog.cincura.net/ | http://ww

Re: [Firebird-net-provider] Cannot execute sql statement to recalculate indexes

2010-01-21 Thread Jiri Cincura
You don't need to use set term, as with FbCommand you can sent only one query. -- Jiri {x2} Cincura (CTO x2develop.com) http://blog.cincura.net/ | http://www.ID3renamer.com -- Throughout its 18-year history, RSA Conferen

Re: [Firebird-net-provider] Cannot execute sql statement to recalculate indexes

2010-01-21 Thread Jiri Cincura
On Thu, Jan 21, 2010 at 09:16, Jiri Cincura wrote: > can sent only one query. ^send -- Jiri {x2} Cincura (CTO x2develop.com) http://blog.cincura.net/ | http://www.ID3renamer.com -- Throughout its 18-year hist

[Firebird-net-provider] Cannot execute sql statement to recalculate indexes

2010-01-20 Thread Γιάννης Μπουρκέλης
I am trying to execute this statement from http://www.firebirdfaq.org/faq167/ but without success: === set term !! ; EXECUTE BLOCK AS declare variable index_name VARCHAR(31); BEGIN for select RDB$INDEX_NAME from RDB$INDICES into :index_name do execute statement 'SET statistics INDEX '