| Subject | Re: Firebird function to test if a database connection is not disconnected? |
|---|---|
| Author | jeff_j_dunlap |
| Post date | 2009-05-14T17:46:21Z |
--- In firebird-support@yahoogroups.com, Dimitry Sibiryakov <sd@...> > > SELECT 1 FROM RDB$DATABASE is absolutely perfect!
Can you tell me what is the easiest way to call the function and also if possible tell me the the different ways that the function can be called (such as through UDFs, procedures, etc)?
Thank you!
>The API function seems to be the way to go then! There is a lot that I need to learn about SQL and Firebird and I just cannot figure out how to call this function from my application.
> Actually, not at all. Depending on server version and implementation
> it can take up to 9 round trips to server. Too much overhead for my taste.
> I use isc_database_info() call which always takes exactly one round trip.
>
> SY, SD.
Can you tell me what is the easiest way to call the function and also if possible tell me the the different ways that the function can be called (such as through UDFs, procedures, etc)?
Thank you!