[firebird-support] Firebird database comparison tool.

2011-10-15 Thread Thomas Clarke
Hello to all on the list. I am in the process of writing an application to update a program I have written that is coming out on the market shortly. The update will be delivered via the Internet. It is broken down into two major parts, i) update the exe file based on version numbers and ii)

[firebird-support] Firebird database comparison tool.

2011-10-15 Thread Thomas Clarke
Hello to all on the list. I am in the process of writing an application to update a program I have written that is coming out on the market shortly. The update will be delivered via the Internet. It is broken down into two major parts, i) update the exe file based on version numbers and ii)

[firebird-support] Why do I recompile all the stored procedure after drop a irrelevant field?

2011-10-15 Thread william_yuwei
HI, All Using Firebird 2.1.3, I have a table, called, Order, which have a not null field POSTED with default source 'N'. Later, I removed this field, but all my stored procedures that having UPDATE ORDER SET , need to be recomple again, even though there is NO POSTED field involved in the

Re: [firebird-support] Why do I recompile all the stored procedure after drop a irrelevant field?

2011-10-15 Thread Helen Borrie
At 11:13 AM 16/10/2011, william_yuwei wrote: HI, All Using Firebird 2.1.3, I have a table, called, Order, which have a not null field POSTED with default source 'N'. Later, I removed this field, but all my stored procedures that having UPDATE ORDER SET , need to be recomple again, even