On 21.10.2014 20:48, 'Edward Mendez' emendez...@nc.rr.com
[firebird-support] wrote:
>
>
> Josef,
>
> Not sure if this will be efficient depending on number of rows, but this is
> another way without using a TEMP_TABLE.
>
> SELECT gen_data.id, gen_data.name, gen_data.dateandtime, gen_data.value
Hi!
I tried this approach before, but it violates my "only run GET_DATA
once" requirement :-(
Josef
On 21.10.2014 21:15, Svein Erling Tysvær
svein.erling.tysv...@kreftregisteret.no [firebird-support] wrote:
>
>
> What about
>
> FOR WITH TMP(MyDateTime, MySum) as
> (SELECT MIN(dateandtime), S
>Hi!
>
> I tried this approach before, but it violates my "only run GET_DATA
>once" requirement :-(
Well, with EXECUTE BLOCK and ORDER BY it may be possible to satisfy your MIN
requirement, but I can't logically understand how it even theoretically wold be
possible to know the SUM before having
On 27.10.2014 10:35, Svein Erling Tysvær
svein.erling.tysv...@kreftregisteret.no [firebird-support] wrote:
>
>
>>Hi!
>>
>> I tried this approach before, but it violates my "only run GET_DATA
>>once" requirement :-(
>
> Well, with EXECUTE BLOCK and ORDER BY it may be possible to satisfy your
> M
Hello firebird-support@yahoogroups.com!
I have one customer having this error message very often when he
starts software after he boots up his computer which is as server as
well
"no permission for read-write accesstodatabase
C:\DATA\CUSTOMERS.FDB"
He runs the sof
> I have one customer having this error message very often when he
> starts software after he boots up his computer which is as server as
> well
>
> "no permission for read-write accesstodatabase
> C:\DATA\CUSTOMERS.FDB"
>
> He runs the software on Windows 8.1 Profes
I did some reconfiguration on a database yesterday, so I`m monitoring the
logs for any issues and I noticed something strange :
Mon Oct 27 16:54:25 2014
Sweep is started by SYSDBA
Database "orbis-aton"
OIT 21080, OAT 21081, OST 20456, Next 44177
(yes, I know it`s a b
I find it interesting you say "very often" instead of "always"... Can you
please expand on that?
On Oct 27, 2014 1:43 PM, "Roland Turcan k...@rotursoft.sk
[firebird-support]" wrote:
> Hello firebird-support@yahoogroups.com!
>
> I have one customer having this error message very often when h
> I did some reconfiguration on a database yesterday, so I`m monitoring
> the logs for any issues and I noticed something strange :
>
>Mon Oct 27 16:54:25 2014
> Sweep is started by SYSDBA
> Database "orbis-aton"
> OIT 21080, OAT 21081, OST 20456, Next 44177
>
> (
I`m not sure if running a 24/7 trace is a good idea (database is under
relatively heavy load). Anything else I could do to help?
btw I am noticing that the unexpected sweep is about 27000-3
transactions after the scheduled one. I could send a log if that helps in
any way. I set the interval to
> I`m not sure if running a 24/7 trace is a good idea (database is under
> relatively heavy load). Anything else I could do to help?
It might be ok with a proper include filter at service level from a
Trace API POV.
The following trace configuration should be fully dedicated to sweeping
only:
>I've not been able to find any topic that comes close to addressing my
>question, and it seems so basic, I'm guessing that I'm missing something
>fundamental.
>
>I have queries that specify for ranges in varchar fields and return those and
>populate my VirtualStrings in a standard alphabetical
Hi--
I've got a problem.
I've got a FB 2.5.2 64-bit install. i believe it's installed as 'super
server' (it's using \Firebird_2_5\bin\fbserver.exe' running as a service)
there are always several instances of my application running, connected to the
same DB using that FB.
every n
13 matches
Mail list logo