RE: [firebird-support] substract just some minutes from a timestamp?

2012-09-21 Thread Svein Erling Tysvær
Select Current_TimeStamp - Cast('00:20:00' as Time) From rdb$database; Select Current_TimeStamp - Cast('00:20:00' as TimeStamp) From rdb$database; Dynamic SQL Error expression evaluation not supported unknown ISC error 336397244 TimeStamp - TimeStamp = Duration in days TimeStamp - Duration in

Re: [firebird-support] How to capture a POST_EVENT in a client application?

2012-09-21 Thread Mark Rotteveel
On Thu, 20 Sep 2012 23:32:55 -0400, W O sistemas2000profesio...@gmail.com wrote: How to capture an event in an application programmed with Visual Basic 6, Visual FoxPro, C, C++ or Java but without using components? I know that there are Delphi's components for that but ... how can I capture

Re: [firebird-support] How to capture a POST_EVENT in a client application?

2012-09-21 Thread Andrea Raimondi
Oh I can answer that :-) A component in Delphi terms is a self contained class that can be placed on a form and that is not necessarily visible at run time :-) Visible components, in Delphi, are called controls :-) On Sep 21, 2012 8:14 AM, Mark Rotteveel m...@lawinegevaar.nl wrote: On Thu, 20

Re: [firebird-support] How to capture a POST_EVENT in a client application?

2012-09-21 Thread Mark Rotteveel
On Fri, 21 Sep 2012 08:21:54 +0100, Andrea Raimondi andrea.raimo...@gmail.com wrote: Oh I can answer that :-) A component in Delphi terms is a self contained class that can be placed on a form and that is not necessarily visible at run time :-) Visible components, in Delphi, are called controls

Re: [firebird-support] How to capture a POST_EVENT in a client application?

2012-09-21 Thread Andrea Raimondi
On Fri, Sep 21, 2012 at 8:32 AM, Mark Rotteveel m...@lawinegevaar.nl wrote: Thanks, so my guess was right that it is a UI element, but then not-visible ;) It's not so easy actually: in Delphi we have data modules which are essentially invisible forms where to group those components, which may

Re: [firebird-support] How to capture a POST_EVENT in a client application?

2012-09-21 Thread Helen Borrie
Mark, At 07:32 PM 21/09/2012, Mark Rotteveel wrote: On Fri, 21 Sep 2012 08:21:54 +0100, Andrea Raimondi andrea.raimo...@gmail.com wrote: Oh I can answer that :-) A component in Delphi terms is a self contained class that can be placed on a form and that is not necessarily visible at run time

Re: [firebird-support] Delphi XE3 and gd32 problem

2012-09-21 Thread Nando Dessena
Maya, Thanks for the heads up, Interbase seems to be getting more popular again. I found have IB services running on my PC, and I have no idea what software put it there! RAD Studio XE3 does that, AFAICS. -- Nando Dessena

RE: [firebird-support] Delphi XE3 and gd32 problem

2012-09-21 Thread Maya Opperman
Thanks for the heads up, Interbase seems to be getting more popular again. I found have IB services running on my PC, and I have no idea what software put it there! RAD Studio XE3 does that, AFAICS. Thanks, but this is on my laptop, which doesn't have Delphi on it. It doesn't have much

[firebird-support] Create a role that has all rights for a database

2012-09-21 Thread Josef Kokeš
Hi! I have a database which was never intended to be used by more than one user, so it never concerned itself with access rights - basically, all objects were always created by that one user, who thus had a full access to them. Now I find myself in need of using another user (because I need

Re: [firebird-support] Periodic database slowdown - troubleshooting steps?

2012-09-21 Thread Ann Harrison
On Mon, Sep 17, 2012 at 10:17 PM, Bob Murdoch mailgro...@murdochfl.comwrote: That has been a problem for a very long time. Right now, a full backup/restore cycle is taking more than 24 hours, and at best we only have a 12 hour window at best on a Sunday. Hence the May 2009 creation date of

[firebird-support] How to make queries to a temporary result set

2012-09-21 Thread HECTOR RIOS
Hi, I´m trying to save some sql parsing in a Delphi application by using temporary result sets. Is there such thing in Firebird? For example: some user makes a query with some filters and then wants to make another query over results from previous query. It would be easy if added the filters

RES: [firebird-support] How to make queries to a temporary result set

2012-09-21 Thread Fabiano
Maybe: Select * from ( select * from table where field1 = 1 ) as FILTER Where FILTER.field2 = 2 Fabiano. [Non-text portions of this message have been removed]

Re: RES: [firebird-support] How to make queries to a temporary result set

2012-09-21 Thread HECTOR RIOS
Hi Fabiano,   I was thinking more like this:   1. User wants bills from client x and program makes a   select * from clients where name= x   2. Program displays x bills in some grid.   3. Later on, user wants x bills from march and I would like to make a query in program like this   select *