[firebird-support] Safe to clean out C:\ProgramData\firebird folder when FB offline?

2020-01-10 Thread Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support]
Hi, Is it safe to clean out the contents of the C:\ProgramData\firebird folder, i.e. wipe it, when the Firebird service (superserver) is not running? I understand that it contains lock tables etc. so should not be touched while FB is running. But it's not clear to me if it can be wiped

RE: [firebird-support] Database server Clock Incorrect

2020-01-10 Thread Hugo Eyng hugoe...@msn.com [firebird-support]
Thank you Dimitry. It was very usefull. Atenciosamente, + + Hugo Eyng + + De: firebird-support@yahoogroups.com em nome de Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] Enviado: sexta-feira, 10 de janeiro de 2020 14:13 Para: firebird-support@yaho

Re: [firebird-support] Recompile stored procedure

2020-01-10 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
10.01.2020 15:20, Marco Andreolli dra...@gmail.com [firebird-support] wrote: > Yes, I have the source of all the stored procedures. But I wanted to > understand if it was > possible recompile without external resources. No. > Sometimes I must recompile because other software made a change on

Re: [firebird-support] Recompile stored procedure

2020-01-10 Thread Marco Andreolli dra...@gmail.com [firebird-support]
Yes, I have the source of all the stored procedures. But I wanted to understand if it was possible recompile without external resources. Sometimes I must recompile because other software made a change on a function that has been used inside (a dependences). So it give an error like this "message l

Re: [firebird-support] Database server Clock Incorrect

2020-01-10 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
10.01.2020 14:07, Hugo Eyng hugoe...@msn.com [firebird-support] wrote: > Restarting FB server worked. Some users in others foruns reported the same > bug and the > same "solution", but do you know if this bug is restricted to what FB version > and if there > is something we can do to avoid this

Re: [firebird-support] Recompile stored procedure

2020-01-10 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
10.01.2020 13:34, Marco Andreolli dra...@gmail.com [firebird-support] wrote: > I had in mind something with system table but table RDB$PROCEDURES the field > RDB$PROCEDURE_SOURCE don't contain the entire procedure but only the body > without the > parameter. > I wouldn't make a more complex quer

RE: [firebird-support] Database server Clock Incorrect

2020-01-10 Thread Hugo Eyng hugoe...@msn.com [firebird-support]
Thank you Mark. Restarting FB server worked. Some users in others foruns reported the same bug and the same "solution", but do you know if this bug is restricted to what FB version and if there is something we can do to avoid this happen again? Atenciosamente, + + Hugo Eyng + +

Re: [firebird-support] Recompile stored procedure

2020-01-10 Thread Marco Andreolli dra...@gmail.com [firebird-support]
Sorry I don't understand, is It possible? I would like recompile a stored procedure within a single query or execute block. I had in mind something with system table but table RDB$PROCEDURES the field RDB$PROCEDURE_SOURCE don't contain the entire procedure but only the body without the parameter.

Re: [firebird-support] Recompile stored procedure

2020-01-10 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
10.01.2020 09:58, Marco Andreolli dra...@gmail.com [firebird-support] wrote: > What is the best way to recompile a stored procedure that has no dependence > on any another > and without making changes? Issue ALTER PROCEDURE statement in WAIT transaction. -- WBR, SD. --

[firebird-support] Recompile stored procedure

2020-01-10 Thread Marco Andreolli dra...@gmail.com [firebird-support]
Hi, What is the best way to recompile a stored procedure that has no dependence on any another and without making changes? Best regards, Marco

Re: [firebird-support] Database server Clock Incorrect

2020-01-10 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2020-01-09 23:42, Hugo Eyng hugoe...@msn.com [firebird-support] wrote: > Hello. > > Win10 64 and Win7 32 > > FB 2.5 32bits > > When I execute "select current_time from RDB$Database" FB returns 1 > (one) hour more then the current time. > > Did somebody faced this troble? Sounds like the F