On Sat, Aug 2, 2014 at 3:11 PM, tobias_subscri...@tgtools.com
[firebird-support] wrote:
> Wow, many thanks! I can't believe it ... and there is not a trace of this
in IBO? Very strange ... so I need to grab IBO's DLL handle and get the
function address myself, OK ... I can do it ... but I am still
On Wed, Jul 31, 2013 at 9:31 AM, Olaf Kluge wrote:
> **
> Hello,
>
>
> in a view, the following expression is possible :
> .(a.eingangsdatum+coalesce(c.zahldauer,0)) as FAE,.
>
> But how can I take the current date in relation? For example:
>
> cast((current_date - (a.eingangsdatum+coalesce(c.zah
On Fri, Jul 26, 2013 at 12:26 PM, Alan J Davies <
alan.dav...@aldis-systems.co.uk> wrote:
> **
>
>
> Thanks Mark, it appears that what I want to do is not possible. i.e.
> have the table name as a replaceable parameter. Using your example I
> would still have 3 separate statements (as now) but in
On Thu, Jul 25, 2013 at 8:46 PM, Piotr Olszewski <
piotr.olszew...@eskrzynka.pl> wrote:
> **
>
> I need to get list of number (f.e 1,2,3,4,5) as rows but using only SQL
> query (without extra table or view).
>
Hi there,
looks like Sean answered faster than me.
Here's the documentation for what
On Tue, Jul 23, 2013 at 3:40 PM, Olaf Kluge wrote:
> **
>
> I have created a stroed procedure to find the records. There are some with
> the mm² (²) (pow) and I get the error messeage with ibexpert. But I was
> wondering, our Java (jaybird) application displays me all records, also the
> problema
On Wed, Jul 17, 2013 at 1:55 PM, Softtech Support wrote:
> **
>
>
> Greetings All,
>
> v1.5.3
>
> I need to know how many tables, indicies, functions, stored procedures,
> etc are in my Firebird database.
>
> Is there a quick way to determine this?
>
See here, this should provide you with enough
On Wed, Apr 3, 2013 at 5:25 PM, Ann Harrison wrote:
> **
> I think what you want is :
>
> CHAR[1] Character Set Octets
>
> Don't use VARCHAR[1] - that will make each one three bytes long. And be
> careful of the layout of your records. For example, if you sandwich your
> CHAR[1] between two intege
On Wed, Sep 28, 2011 at 18:48, Alexey Kovyazin wrote:
>> 1) Full hard disk: IIRC in this case Firebird will overwrite the file
>> from the beginning. Not good, but checking for free space on every
>> write would slow down writes too much. Just make sure you have enough
>> space.
>>
>
> This is far
On Wed, Sep 28, 2011 at 15:58, Rohit Coder
wrote:
> 2. What is the table and data file max-size for version 2.5?
http://www.firebirdfaq.org/faq61/
> 3. What are the common scenarios of a Firebird data file getting corrupt? In
> case of a single-file structure, I guess no other files need to be
On Tue, Sep 20, 2011 at 13:14, majstor wrote:
> Hi Firebird Masters,
>
> Does anybody know an ideal tool for transfering data from Firebird database
> ver 2.1.x UNICODE_FSS to 2.5 UTF8, I'll try a lot of free or demo tools but
> same error with malware string are there. I just don't know how to
On Fri, Sep 16, 2011 at 12:42, Si Carter wrote:
> Hi,
>
> I am trying to pass a where clause to a stored procedure to be used in
> a for..select statement, something like:
You're looking for EXECUTE STATEMENT.
See here:
http://www.firebirdsql.org/refdocs/langrefupd15-psql-execstat.html
Example f
On Wed, Sep 14, 2011 at 18:52, Olaf Kluge wrote:
> We select some records in some tables and joins. In one Table, there are two
> records with different values. So I have by grouping this two records every
> time.
>
> It is possible?
>
> Select a.field, b.field, (c.field record 1 and c.field reco
On Mon, Sep 12, 2011 at 10:30, Olaf Kluge wrote:
> I would like to send all 30 seconds an event to the connected client to
> confirm the connection. How can I realize that? There are different clients
> connected, for each I need this function.
Howdy,
AFAIK there is no functionality to do this f
On Fri, Sep 2, 2011 at 19:21, Vander Clock Stephane
wrote:
> unfortunatly
>
> If you override the default NULLs placement, no index will be used for
> sorting. In Firebird 1.5,
> that is the case with NULLS FIRST. In 2.0 and higher, with NULLS LAST on
> ascending and
> NULLS FIRST on descending so
On Fri, Sep 2, 2011 at 21:08, samcarleton wrote:
> Are there any OSX GUI's for Firefox?
FlameRobin is a cross-platform GUI administration tool for Firebird:
http://www.flamerobin.org/
On Tue, Aug 30, 2011 at 10:20, Vander Clock Stephane
wrote:
> Hello,
>
> how to put the num value at the end of the result (and not at the
> beginning) when we are doing
>
> select xxx order by xxx ASC
Howdy,
maybe this helps:
select xxx from tbl order by xxx asc NULLS FIRST
Bye,
Markus
On Tue, Aug 23, 2011 at 13:33, ck1625 wrote:
> My problem is still there. It's only with FB 2.5; with FB 1.5 it is not that
> slow.
>
> I thought, the solution is this:
> DELETE FROM
> SELECT * FROM
>
> But it looks like it doesn't work. It is still "random" when time is lost to
> do the clean
On Sun, Aug 7, 2011 at 19:44, diegodelafuente
wrote:
> I have migrated some of my dbs to firebird 2.5 superserver from firebird 1.5
> classic server.
>
> In the classic server, each connection open a new process using the inet
> linuz daemon.
> I could see how many connections I had to the DB us
18 matches
Mail list logo