Re: [firebird-support] Table information

2014-03-12 Thread Hugo Eyng

Hi.

It will be usefull. Thanks.

Hugo Eyng


Em 11/03/2014 19:38, liviusliv...@poczta.onet.pl escreveu:


Hi,

look at my FAQ about last table modification time
there is described another solution for this problem
it work on generators - use it if you like it
http://itstop.pl/en-en/Porady/Firebird/FAQ1/TABLE-MODIFICATION-TIMESTAMP

regards,
Karol Bieniaszewski

From: Hugo Eyng
Sent: Tuesday, March 11, 2014 1:10 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Table information

Hello.

Is there a way to get information like last time the table was
updated/changed, the size in bytes of the table, how much records are
save in the table?

--

Atenciosamente,

Hugo Eyng

---
Ta wiadomość e-mail jest wolna od wirusów i złośliwego oprogramowania, 
ponieważ ochrona avast! Antivirus jest aktywna.

http://www.avast.com

[Non-text portions of this message have been removed]




--


Atenciosamente,

Hugo Eyng



Re: [firebird-support] Table information

2014-03-12 Thread W O
Interesting solution. I had wrote an article on my blog about this:

http://firebird21.wordpress.com/2014/03/12/obteniendo-el-timestamp-de-la-ultima-actualizacion-a-una-tabla/

Greetings.

Walter.



On Tue, Mar 11, 2014 at 6:38 PM,  wrote:

>
>
> Hi,
>
> look at my FAQ about last table modification time
> there is described another solution for this problem
> it work on generators - use it if you like it
> http://itstop.pl/en-en/Porady/Firebird/FAQ1/TABLE-MODIFICATION-TIMESTAMP
>
> regards,
> Karol Bieniaszewski
>
> From: Hugo Eyng
> Sent: Tuesday, March 11, 2014 1:10 AM
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] Table information
>
>
> Hello.
>
> Is there a way to get information like last time the table was
> updated/changed, the size in bytes of the table, how much records are
> save in the table?
>
> --
>
> Atenciosamente,
>
> Hugo Eyng
>
> ---
> Ta wiadomość e-mail jest wolna od wirusów i złośliwego oprogramowania,
> ponieważ ochrona avast! Antivirus jest aktywna.
> http://www.avast.com
>
> [Non-text portions of this message have been removed]
>
>  
>


[firebird-support] Re: how debug a memory corruption exception

2014-03-12 Thread korkless
this it's not an hardware problem but related to software (fb embedded), 
there's same invalid pointer into one of the fb embedded dlls so i want know 
how retrieve same info to help to debug the problem.
from microsoft docs:
"An access violation occurs in unmanaged or unsafe code when the code attempts 
to read or write to memory that has not been allocated, or to which it does not 
have access. This usually occurs because a pointer has a bad value. Not all 
reads or writes through bad pointers lead to access violations, so an access 
violation usually indicates that several reads or writes have occurred through 
bad pointers, and that memory might be corrupted"

RES: [firebird-support] how debug a memory corruption exception

2014-03-12 Thread Fabiano - Desenvolvimento SCI
Try ran Windows 7 memory test (press F8 while booting). If it detects your 
memory is corrupted the only thing to do is replace your physical memory.

 

De: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] 
Em nome de korkl...@yahoo.it
Enviada em: quarta-feira, 12 de março de 2014 11:09
Para: firebird-support@yahoogroups.com
Assunto: [firebird-support] how debug a memory corruption exception

 

  

hi, i'm using the .net provider with the last embedded fb version on a x64 
windows 7 machine.
i have an application always active that abaout every minute will connect to 
the db, 1/2 times a day it crashes when it tries to open the connection, this 
is the relevant stack trace of the exception:
System.AccessViolationException: Attempted to read or write protected memory. 
This is often an indication that other memory is corrupt.
   at FB_1236665269_Class.isc_attach_database(IntPtr[] statusVector, Int16 
dbNameLength, Byte[] dbName, Int32& dbHandle, Int16 parmBufferLength, Byte[] 
parmBuffer)

i see in an old fb thread in the forum the suggestion to download the Debug Kit 
to give you same useful informations to find the bug that cause this kind of 
exception but the link with the description of how use the debug kit was broken.
now i'm using the debug kit files in my app so i want know what i must do the 
next time that my app will crash to s end you same info (i'm a .NET developer 
and i don't know how debug a native application)





[firebird-support] how debug a memory corruption exception

2014-03-12 Thread korkless
hi, i'm using the .net provider with the last embedded fb version on a x64 
windows 7 machine.
i have an application always active that abaout every minute will connect to 
the db, 1/2 times a day it crashes when it tries to open the connection, this 
is the relevant stack trace of the exception:
System.AccessViolationException: Attempted to read or write protected memory. 
This is often an indication that other memory is corrupt.
   at FB_1236665269_Class.isc_attach_database(IntPtr[] statusVector, Int16 
dbNameLength, Byte[] dbName, Int32& dbHandle, Int16 parmBufferLength, Byte[] 
parmBuffer)

i see in an old fb thread in the forum the suggestion to download the Debug Kit 
to give you same useful informations to find the bug that cause this kind of 
exception but the link with the description of how use the debug kit was broken.
now i'm using the debug kit files in my app so i want know what i must do the 
next time that my app will crash to send you same info (i'm a .NET developer 
and i don't know how debug a native application)

[firebird-support] FireDAC with NBackup

2014-03-12 Thread PGore
I am starting to use FireDAC to connect to Firebird Databases. FireDAC has a 
built in Backup/Restore component that makes use of NBackup services interface.
 The backups work fine but I do not get OnProgress events firing during the 
backup.  The FireDAC architect has posed the following question regarding my 
FireDAC support request.
 

 does isc_service_query return anything for isc_action_svc_nbak service action?

 

 regards
 Peter