[firebird-support] Getting database creation date programatically

2012-06-15 Thread Josef Kokeš
Hi! I need to find the date of last database restore. GSTAT -h can print this information as Creation date. Does anyone know how can I get this information programatically? Thanks, Pepak ++

Re: [firebird-support] Getting database creation date programatically

2012-06-15 Thread Thomas Steinmaurer
I need to find the date of last database restore. GSTAT -h can print this information as Creation date. Does anyone know how can I get this information programatically? If monitoring tables are available, it might be easier to query MON$DATABASE with e.g.: select mon$creation_date from

Re: [firebird-support] Getting database creation date programatically

2012-06-15 Thread Josef Kokeš
On 15.6.2012 9:19, Thomas Steinmaurer wrote: I need to find the date of last database restore. GSTAT -h can print this information as Creation date. Does anyone know how can I get this information programatically? If monitoring tables are available, it might be easier to query MON$DATABASE

Re: [firebird-support] Getting database creation date programatically

2012-06-15 Thread Thomas Steinmaurer
On 15.6.2012 9:19, Thomas Steinmaurer wrote: I need to find the date of last database restore. GSTAT -h can print this information as Creation date. Does anyone know how can I get this information programatically? If monitoring tables are available, it might be easier to query MON$DATABASE

Re: [firebird-support] Getting database creation date programatically

2012-06-15 Thread Josef Kokeš
I need to find the date of last database restore. GSTAT -h can print this information as Creation date. Does anyone know how can I get this information programatically? If monitoring tables are available, it might be easier to query MON$DATABASE with e.g.: select mon$creation_date from

[firebird-support] External files

2012-06-15 Thread lobizoom1
Hello, I downloaded the worldcities list in .txt format and created two identical tables where one is referencing this external file. When I launch the insert with a select from external table, all goes fine. The problem is the data received in the real table do not match and number of rows is