I've written an app that is usually used over a network by several people.
There's the problem whereby when U post on a machine over the network, the
changes are saved for only a certain time then later, like the next day, the
changes are not there.
What could be the problem?

Andrew M.

----- Original Message -----
From: <ib-support@yahoogroups.com>
To: <ib-support@yahoogroups.com>
Sent: 27 January, 2003 11:52 AM
Subject: [ib-support] Digest Number 1256


> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
> ------------------------------------------------------------------------
>
> There are 25 messages in this issue.
>
> Topics in this digest:
>
> 1. FB 1 Cache Limit
> From: Nils Boedeker <info@...>
> 2. Re: Metadata SP order extraction problem
> From: "Marco Menardi <mmenaz@...>"
<mmenaz@...>
> 3. RE: Firebird Workbench, number formats, retrieving data with
API
> From: "Henrik Sitter" <henrik.sitter@...>
> 4. Re: Comparison between Firebird and Postgres
> From: "dbougo <dbougo@...>" <dbougo@...>
> 5. Information on serious issues with different ODBC drivers
> From: "mgastde <michael.gast@...>" <michael.gast@...>
> 6. Re: Re: Comparison between Firebird and Postgres
> From: "Ann W. Harrison" <aharrison@...>
> 7. RE: FB 1 Cache Limit
> From: "Leyne, Sean" <sleyne@...>
> 8. RE: Re: Comparison between Firebird and Postgres
> From: "Leyne, Sean" <sleyne@...>
> 9. Re: Information on serious issues with different ODBC drivers
> From: Aage Johansen <aagjohan@...>
> 10. Re: Re: Metadata SP order extraction problem
> From: "Tomislav Avramovic" <tom@...>
> 11. Float Precision set
> From: "Jed Nicolau Filho" <jed@...>
> 12. Re: Float Precision set
> From: Kubanychbek Tajmamat uloo <kubanych@...>
> 13. Re: Float Precision set
> From: "Jed Nicolau Filho" <jed@...>
> 14. RE: Float Precision set
> From: "Leyne, Sean" <sleyne@...>
> 15. Re: Float Precision set
> From: "Jed Nicolau Filho" <jed@...>
> 16. Re: Float Precision set
> From: Kubanychbek Tajmamat uloo <kubanych@...>
> 17. Re: Float Precision set
> From: "Jed Nicolau Filho" <jed@...>
> 18. RE: Float Precision set
> From: "Leyne, Sean" <sleyne@...>
> 19. Re: Float Precision set
> From: "Jed Nicolau Filho" <jed@...>
> 20. Re: Float Precision set
> From: "Jed Nicolau Filho" <jed@...>
> 21. Test
> From: "Jed Nicolau Filho" <jed@...>
> 22. Re: Float Precision set
> From: Raymond Kennington <progsol@...>
> 23. PROCEDURE_ID of RDB$PROCEDURES
> From: KIMURA Meiji <Meiji_Kimura@...>
> 24. RE: Information on serious issues with different ODBC drivers
> From: "Alan McDonald" <alan@...>
> 25. Re: Information on serious issues with different ODBC drivers
> From: Zakir Mahomedy <zmahomedy@...>
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 1
> Date: Sun, 26 Jan 2003 12:13:15 +0100
> From: Nils Boedeker <info@...>
> Subject: FB 1 Cache Limit
>
> Hi,
>
> in IB 6 there are perfomance restriction to you cache with more thank
> 10000 pages. Is this problem removed in FB 1?
>
> Nils
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 2
> Date: Sun, 26 Jan 2003 11:12:51 -0000
> From: "Marco Menardi <mmenaz@...>" <mmenaz@...>
> Subject: Re: Metadata SP order extraction problem
>
> I don't think so. The problem is that when you extract the metadata,
> they are extracted in a "wrong" order, an order wrong for rebuild.
> So if I will use Database Comparer with the (wrong) master as source
> and empty as destination, the result should be the exact copy of
> (wrong) master.
> But if you tell me that Database Comparer does a "dependency" check
> before building the diff metadata, I'm wrong.
> Could you please give me a link to that tool?
> thanks a lot
> Marco Menardi
>
>
> --- In ib-support@yahoogroups.com, "Tomislav Avramovic" <tom@h...> wrote:
> > Hi,
> > > Hi, it works but does not solve the problem (nor without "DESCENDING"
> > > order).
> > > So things seems to be more complicate :( The only simple solution is
> > > the one suggested by Lele Gaifax, AFAIK.
> > > thanks a lot anyway
> > > Marco Menardi
> >
> > Please try excellent Free tool GDB Database Comparer by Boris Loboda
> > This tool compare two extracted scripts from two databases and
> create Result
> > script to sinhronize target database.
> > If you put your script for Master and empty script for Target then your
> > Result script will be Master script in correct order ;-)
> >
> > Tomislav Avramovic
>
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 3
> Date: Sun, 26 Jan 2003 14:51:38 +0100
> From: "Henrik Sitter" <henrik.sitter@...>
> Subject: RE: Firebird Workbench, number formats, retrieving data with
API
>
> Hi, Ann.
>
> Well, I figured it out :) I've never dealt with double precision before
> so I didn't know the coding. It turned out that I misunderstood the
> fraction part of the formula.
>
> For IEEE the formula to convert back to a decimal number is:
>
> Decimal number = (-1)^(signbit)*2^(exponentbits-1023)*1.fractionbits.
>
> Pretty straight forward, but as I said I misunderstood the last part of
> the equation. If the decimal representation of the fractionbits equaled
> 19992000... (or something) I thought the formula read:
>
> Decimal number = (-1)^(signbit)*2^(exponentbits-1023)*1.19992000...
>
> But this is the wrong interpretation. For those interested I'll provide
> an example on how it's done:
>
> Let's say you have stored 201 as double (8 bytes), and have the
> following code (C/C++ code):
>
> double Test = 201;
> char* TestAdr = (char*) &Test; // Store the address of byte 1 of Test
>
> If you now look in your memory (your machine's), and assuming your
> machine use IEEE floating point coding, you will see this:
>
> *(TestAdr + 0) = 0 (= 00000000 in binary) (bits 7 to 0)
> *(TestAdr + 1) = 0 (= 00000000 in binary) (bits 15 to 8)
> *(TestAdr + 2) = 0 (= 00000000 in binary) (bits 23 to 16)
> *(TestAdr + 3) = 0 (= 00000000 in binary) (bits 31 to 24)
> *(TestAdr + 4) = 0 (= 00000000 in binary) (bits 39 to 32)
> *(TestAdr + 5) = 32 (= 00100000 in binary) (bits 47 to 40)
> *(TestAdr + 6) = 105 (= 01101001 in binary) (bits 55 to 48)
> *(TestAdr + 7) = 64 (= 01000000 in binary) (bits 63 to 56)
>
> 1) Signbit: bit 63 = 0 (the leftmost bit in the last line above)
> 2) Exponent: bits 62 to 52 (eleven bits) = 10000000110 = 1030 in decimal
> representation.
> 3) Fraction/mantissa: bits 51 to 0 = 100100100...0000 (the leftmost bit
> here is bit 51).
>
> How should one interpret these fraction/mantissa bits. If a bit = 1, it
> is assigned a value, if the bit = 0 it's assigned the value 0.
>
> Bit51 = 1 -> assign the value 0.5
> Bit50 = 1 -> assign the value 0.5/2 = 0.25
> Bit49 = 1 -> assign the value 0.25/2 = 0.125
> Bit48 = 1 -> assign the value 0.125/2 = 0.0625
> Bit47 = 1 -> assign the value 0.0625/2 = 0.03125
> Bit46 = 1 -> assign the value 0.03125/2 = 0.015625
> Bit45 = 1 -> assign the value 0.015625/2= 0.0078125
> .
> .
> and so on.
>
> In our fraction/mantissa bit51, bit48 and bit45 is lit. So our fraction
> becomes: 0.5 + 0.0625 +0.0078125 = 0.5703125
>
> What we get using the decoding formula
> "Decimal number = (-1)^(signbit)*2^(exponentbits-1023)*1.fractionbits"
> is:
>
> Decimal number = (-1)^0*2^(1030-1023)*1.5702125 = 201 (fantastic...)
>
> Well, this was a long post about something easy, but just in case
> somebody wondered about those fraction bits, I hope this explains it a
> bit.
>
> Henrik
>
>
>
>
>
>
> -----Original Message-----
> From: Ann W. Harrison [mailto:aharrison@...]
> Sent: Sunday, January 26, 2003 12:18 AM
> To: ib-support@yahoogroups.com; ib-support@yahoogroups.com
> Subject: RE: [ib-support] Firebird Workbench, number formats, retrieving
> data with API
>
> At 11:54 PM 1/25/2003 +0100, Henrik Sitter wrote:
>
> >Thanks for your reply. I'm trying to decode the binary representation
> of
> >a float (using firebird v.1.0.0). Do you know if "IEEE 754 floating
> >point", "D_FLOAT floating point" or "G_FLOAT floating point" is used?
>
> Ah! That's easy. IEEE. Except on VAXes.
>
> >What about big endian or little endian?
>
> Depends on your client architecture. Firebird returns values
> in the appropriate format for the client. The data is sent
> over the wire in XDR (basically the native Sun format of
> 1985) and translated at either end to the native format of
> the server (at one end) or client (at the other).
>
>
>
> >So far I have not been able to decode correctly (trying all three (or
> >six) encodings), but I have done some testing and I'm pretty sure that
> >my database returns the correct binary representation. Here are some
> >examples:
> >
> >If I store 201 (as float/double precision), it returns:
> >Byte 7: 64
> >Byte 6: 105
> >Byte 5: 32
> >Byte 4 to byte 0: 0
> >
> >If I store 202 (as float/double precision), it returns:
> >Byte 7: 64
> >Byte 6: 105
> >Byte 5: 64 (+32 compared to storing 201)
> >Byte 4 to byte 0: 0
> >
> >If I store 203 (as float/double precision), it returns:
> >Byte 7: 64
> >Byte 6: 105
> >Byte 5: 96 (+32 compared to storing 202)
> >Byte 4 to byte 0: 0
>
>
> Errr... If I remember correctly, the sign, mantissa, and
> exponent of a floating point number don't align neatly
> on byte boundaries, which may explain this confusion. Being
> a slothful person, I haven't looked hard at your code, but
> if you're writing in C, have you tried a printf of the
> value returned? Or declaring an appropriate variable,
> assigning values to it and comparing those, bytewise, with
> what you're seeing?
>
>
> Regards,
>
> Ann
> www.ibphoenix.com
> We have answers.
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
>
>
>
>
>
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 4
> Date: Sun, 26 Jan 2003 18:34:00 -0000
> From: "dbougo <dbougo@...>" <dbougo@...>
> Subject: Re: Comparison between Firebird and Postgres
>
> --- In ib-support@yahoogroups.com, Paul Schmidt <pschmidt@i...>
> wrote:
> > On January 24, 2003 07:00 am, you wrote:
> > > I need comparison between firebird and postgres. I work with
> Firebird,
> > > but i need prove with my colleague, the excellence of the
> Firebird.
> > >
> >
> > FB has several advantages over PSQL:
> >
> > 1) PSQL is not Windows friendly at the server, it depends on
> having a running
> > MinGW (at least) environment, and uses a lot of command line tools
> to perform
> > maintenance.
> >
>
> It seems that the win32 port of firebird 1.5 has switched to MinGW,
> too
>
> Best Regards,
>
> Dimitri Bougoulias
>
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 5
> Date: Sun, 26 Jan 2003 18:46:45 -0000
> From: "mgastde <michael.gast@...>" <michael.gast@...>
> Subject: Information on serious issues with different ODBC drivers
>
> Hi,
>
> I've examined different serious problems with different ODBC drivers
> available for Firebird.
>
> Environment on the server:
> Suse Linux 7.1
> Firebird 1.00 and 1.02
>
> Environment on the client:
> Windows NT 4.0 SP5 or SP6 or Windows 2000 SP 2 or Windows XP
> gds32.dll as delivered with the respective Firebird package for
> Windows.
>
> 1. Easysoft ODBC driver:
> Easysoft ODBC driver in different versions with and without support
> for unicode. I've tested version 1.1.63 and the most recent versions
> of the driver downloaded two weeks ago.
> This driver has the following issue:
> After rolling back a transaction with a select operation in it, the
> counter for the OIT does not rise any more. A few weeks later, the
> database starts to slow down and to produce irregular error messages.
> The difference between OIT and the actual transaction number (OT) is
> in this point of time roundabout 700000 (sweep is disabled due to
> problems with a corrupted database when the server shuts down while
> the sweep runs).
> I've reported the error to Easysoft and they could confirm this error
> running the driver against a Firebird database (and using a small test
> database i've created). They state that the error does not occur with
> the open source version of Interbase. I've not checked this.
> But unfortunately Easysoft adds:
> 1. We are the only customer with this problem.
> 2. They classify this issue as a minor bug and they probably (!) will
> fix it in one of the future releases.
> That don't help us, as we use Firebird in a productive environment and
> me must find a solution in the near future.
>
> 2. XTG ODBC driver:
> This driver has exactly the same issue as the Easysoft driver.
>
> 3. IB-Phoenix open source ODBC driver:
> This driver does not have the issue I've noticed with the Easysoft or
> the XTG drivers. But I did not find a possibility to set the correct
> character set. In addition, i cannot update or insert any data in my
> test database (i did not check delete) using AQUERYX from XTG as
> frontend and one of the snapshots builds as ODBC driver. Using the
> release version of Juli 2001 i can modify my data, but i cannot set
> the proper character set. So this driver actually is not usefull for
> our german environment.
>
> 4. Gemini ODBC driver for Interbase and Firebird:
> This driver does not have the described issue and it works fine with
> different character sets. After doing a lot of testing, it seems for
> me, that the Gemini ODBC driver is the only one working correctly. But
> the last build available is version 2.1 dated to January 2001 and it
> is not approved to work with Firebird 1.0.0 and Firebird 1.0.2.
>
> There are still some questions:
> * Are we really the only one with this problem?
> * Does anyone use the Gemini driver in a productive environment? Are
> there any problems?
> * Is it planned to add character set support to the open source
> driver?
> * Does anyone else have the problem with writing operations using the
> open source driver?
>
> Best regards
> Michael Gast
>
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 6
> Date: Sun, 26 Jan 2003 14:01:27 -0500
> From: "Ann W. Harrison" <aharrison@...>
> Subject: Re: Re: Comparison between Firebird and Postgres
>
> At 06:34 PM 1/26/2003 +0000, dbougo <dbougo@...> wrote:
>
> >It seems that the win32 port of firebird 1.5 has switched to MinGW,
> >too
>
> Perhaps to build it from source, but not for application use..
>
>
>
> Regards,
>
> Ann
> www.ibphoenix.com
> We have answers.
>
>
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 7
> Date: Sun, 26 Jan 2003 14:20:32 -0500
> From: "Leyne, Sean" <sleyne@...>
> Subject: RE: FB 1 Cache Limit
>
> Nils,
>
>
> > in IB 6 there are perfomance restriction to you cache with more thank
> > 10000 pages. Is this problem removed in FB 1?
>
> In truth, while this is acknowledged as a limitation of IB 5.x, the
> 'reality' of this in regards to FB 1.0 has never really been reported
> and/or reproduced.
>
>
> Sean
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 8
> Date: Sun, 26 Jan 2003 14:24:54 -0500
> From: "Leyne, Sean" <sleyne@...>
> Subject: RE: Re: Comparison between Firebird and Postgres
>
> Dimitri,
>
> > It seems that the win32 port of firebird 1.5 has switched to MinGW,
> > too
>
> This is not the reality of the situation.
>
> The ability to compile the sources with an open-source compiler (i.e.
> MinGW) under Win32 is now supported by the v1.5 build enviroment. It is
> not a requirement -- builds can also be made with MS VC 6 and MS VC 7.
>
> Further, once compiled the binaries can be installed without the MinGW
> environment running on the target servers.
>
>
> --
> Sean Leyne
>
> Support Firebird, join FirebirdSQL Foundation today!
> http://www.FirebirdSQL.org/foundation
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 9
> Date: Sun, 26 Jan 2003 21:43:41 +0100
> From: Aage Johansen <aagjohan@...>
> Subject: Re: Information on serious issues with different ODBC drivers
>
> Michael G. wrote:
> <<
> ...
> 4. Gemini ODBC driver for Interbase and Firebird:
> ...
> There are still some questions:
> ...
> * Does anyone use the Gemini driver in a productive environment? Are
> there any problems?
> ...
> >>
>
> I believe that Craig Stuntz (or rather/maybe Vertex Systems Corp.) use the
> Gemini driver for Interbase.
> And it seems the latest version is dated 2002-01-20.
> And it also says "Support for Firebird server RC2".
>
>
> Regards,
> Aage J.
>
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 10
> Date: Mon, 27 Jan 2003 01:48:57 +0100
> From: "Tomislav Avramovic" <tom@...>
> Subject: Re: Re: Metadata SP order extraction problem
>
> Yes the order is the same, but Result script first create all procedures
and
> triggers without body
> and after that alter them with body.
> I always use this tool to sinhronize development and production databases
> without problems.
> This is the link.
> http://www.ibase.ru/download/ibcmpexe.zip
>
> > I don't think so. The problem is that when you extract the metadata,
> > they are extracted in a "wrong" order, an order wrong for rebuild.
> > So if I will use Database Comparer with the (wrong) master as source
> > and empty as destination, the result should be the exact copy of
> > (wrong) master.
> > But if you tell me that Database Comparer does a "dependency" check
> > before building the diff metadata, I'm wrong.
> > Could you please give me a link to that tool?
> > thanks a lot
> > Marco Menardi
> >
> >
> > --- In ib-support@yahoogroups.com, "Tomislav Avramovic" <tom@h...>
wrote:
> > > Hi,
> > > > Hi, it works but does not solve the problem (nor without
"DESCENDING"
> > > > order).
> > > > So things seems to be more complicate :( The only simple solution is
> > > > the one suggested by Lele Gaifax, AFAIK.
> > > > thanks a lot anyway
> > > > Marco Menardi
> > >
> > > Please try excellent Free tool GDB Database Comparer by Boris Loboda
> > > This tool compare two extracted scripts from two databases and
> > create Result
> > > script to sinhronize target database.
> > > If you put your script for Master and empty script for Target then
your
> > > Result script will be Master script in correct order ;-)
> > >
> > > Tomislav Avramovic
> >
> >
> > To unsubscribe from this group, send an email to:
> > ib-support-unsubscribe@egroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
> >
> >
> >
>
>
> ---
> Outgoing mail is certified Virus Free .
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.445 / Virus Database: 250 - Release Date: 21.01.2003
>
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 11
> Date: Mon, 27 Jan 2003 01:25:19 -0300
> From: "Jed Nicolau Filho" <jed@...>
> Subject: Float Precision set
>
> Hello Friends
>
> Is it possible to set IB/FB float precision for all tables in all
databases
> using any environment variable or command ?
>
> TIA
>
> Jed
>
>
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 12
> Date: Mon, 27 Jan 2003 08:26:45 +0500
> From: Kubanychbek Tajmamat uloo <kubanych@...>
> Subject: Re: Float Precision set
>
> in trigger
> new.summa=cast(new.summa as numeric(10,2));
>
> >Is it possible to set IB/FB float precision for all tables in all
databases
> >using any environment variable or command ?
> >
> Regards, Kubanychbek.
>
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 13
> Date: Mon, 27 Jan 2003 01:34:28 -0300
> From: "Jed Nicolau Filho" <jed@...>
> Subject: Re: Float Precision set
>
> Thanks Kuba
>
> But for 700 tables in database I will die !
>
> Regards
>
> Jed
>
> "Kubanychbek Tajmamat uloo" <kubanych@...> escreveu na mensagem
> news:3E34A6F5.7040802@......
> > in trigger
> > new.summa=cast(new.summa as numeric(10,2));
> >
> > >Is it possible to set IB/FB float precision for all tables in all
> databases
> > >using any environment variable or command ?
> > >
> > Regards, Kubanychbek.
> >
> >
> > To unsubscribe from this group, send an email to:
> > ib-support-unsubscribe@egroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
> >
> >
> >
>
>
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 14
> Date: Sun, 26 Jan 2003 22:33:42 -0500
> From: "Leyne, Sean" <sleyne@...>
> Subject: RE: Float Precision set
>
> Jed,
>
> > Is it possible to set IB/FB float precision for all tables in
> > all databases using any environment variable or command ?
>
> Your question is ambiguous.
>
> Why do you need to set the precision?
>
>
> Sean
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 15
> Date: Mon, 27 Jan 2003 01:46:11 -0300
> From: "Jed Nicolau Filho" <jed@...>
> Subject: Re: Float Precision set
>
> Dear sean
>
> I need to use float for all numeric datatype. But I need only 6 decimal
> digits.
> Is it Possible ?
>
> TIA
>
> Jed
>
> ""Leyne, Sean"" <sleyne@...> escreveu na mensagem
> news:66187D861C1747499BE1365B74E0369110B727@......
> > Jed,
> >
> > > Is it possible to set IB/FB float precision for all tables in
> > > all databases using any environment variable or command ?
> >
> > Your question is ambiguous.
> >
> > Why do you need to set the precision?
> >
> >
> > Sean
> >
> > To unsubscribe from this group, send an email to:
> > ib-support-unsubscribe@egroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
> >
> >
> >
>
>
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 16
> Date: Mon, 27 Jan 2003 08:45:03 +0500
> From: Kubanychbek Tajmamat uloo <kubanych@...>
> Subject: Re: Float Precision set
>
> Hello, Jed.
>
> >Thanks Kuba
> >
> >But for 700 tables in database I will die !
> >
> >
> >
> I can try to help you. Please reply to kubanych@...
> Regards, Kubanychbek.
>
>
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 17
> Date: Mon, 27 Jan 2003 01:52:26 -0300
> From: "Jed Nicolau Filho" <jed@...>
> Subject: Re: Float Precision set
>
> Dear Friends
>
> I can't see my sent messages to newsgroup in my Outlook Express !
> But message sent for all is visible for me !
>
> How to solve this problem ?
>
> TIA
>
> Jed
>
> ""Leyne, Sean"" <sleyne@...> escreveu na mensagem
> news:66187D861C1747499BE1365B74E0369110B727@......
> > Jed,
> >
> > > Is it possible to set IB/FB float precision for all tables in
> > > all databases using any environment variable or command ?
> >
> > Your question is ambiguous.
> >
> > Why do you need to set the precision?
> >
> >
> > Sean
> >
> > To unsubscribe from this group, send an email to:
> > ib-support-unsubscribe@egroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
> >
> >
> >
>
>
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 18
> Date: Sun, 26 Jan 2003 22:48:12 -0500
> From: "Leyne, Sean" <sleyne@...>
> Subject: RE: Float Precision set
>
> Jed,
>
> > I need to use float for all numeric datatype. But I need only
> > 6 decimal digits.
>
> But then it sounds like you want a exact precision/numeric data type,
> like DECIMAL(18,6)
>
>
> Sean
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 19
> Date: Mon, 27 Jan 2003 02:01:14 -0300
> From: "Jed Nicolau Filho" <jed@...>
> Subject: Re: Float Precision set
>
> Thanks Sean
>
> My problem is that I need only 6 decimal digits for numeric datatype that
> are all set as FLOAT !
>
> I need float for compatibility !
>
> I am using Delphi 5/6 and when I set a number like 2,50 into a Double
> variable and send it to IB
> database store 2,499999999999999999999999999999999999999999....as
possible.
>
> I need that the IB store 2,50 or at least 2,4999999 !
>
> I need to use FLOAT for compatibility !
> I try to truncate it in application but there is no effect !
>
> Thanks in advance
>
> Best Regards
>
> Jed
>
> ""Leyne, Sean"" <sleyne@...> escreveu na mensagem
> news:66187D861C1747499BE1365B74E0369120CBA8@......
> > Jed,
> >
> > > I need to use float for all numeric datatype. But I need only
> > > 6 decimal digits.
> >
> > But then it sounds like you want a exact precision/numeric data type,
> > like DECIMAL(18,6)
> >
> >
> > Sean
> >
> > To unsubscribe from this group, send an email to:
> > ib-support-unsubscribe@egroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
> >
> >
> >
>
>
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 20
> Date: Mon, 27 Jan 2003 02:33:11 -0300
> From: "Jed Nicolau Filho" <jed@...>
> Subject: Re: Float Precision set
>
> Test !
>
> ""Leyne, Sean"" <sleyne@...> escreveu na mensagem
> news:66187D861C1747499BE1365B74E0369120CBA8@......
> > Jed,
> >
> > > I need to use float for all numeric datatype. But I need only
> > > 6 decimal digits.
> >
> > But then it sounds like you want a exact precision/numeric data type,
> > like DECIMAL(18,6)
> >
> >
> > Sean
> >
> > To unsubscribe from this group, send an email to:
> > ib-support-unsubscribe@egroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
> >
> >
> >
>
>
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 21
> Date: Mon, 27 Jan 2003 02:38:42 -0300
> From: "Jed Nicolau Filho" <jed@...>
> Subject: Test
>
> I can't see this message n my OutLook Express !
>
>
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 22
> Date: Mon, 27 Jan 2003 17:20:51 +1030
> From: Raymond Kennington <progsol@...>
> Subject: Re: Float Precision set
>
> Jed Nicolau Filho wrote:
> >
> > Thanks Sean
> >
> > My problem is that I need only 6 decimal digits for numeric datatype
that
> > are all set as FLOAT !
> >
> > I need float for compatibility !
>
> No you don't want float compatibility!! You need precise arithmetic for a
fixed
> number of decimals.
>
> Delphi uses floats and this will give you the inaccuracies you show below.
>
> IB/FB can use precise numerics and FB 1.5 (at least) can use float as
well. You
> must be careful how you write the Delphi floats to the database.
>
> Perhaps you should use Delphi BCD, but I don't know how to do that and
save to
> IB/FB.
>
> Saving to NUMERIC(18,6) should automatically round for you, but when you
read
> them into Delphi or other language, they will become floats again!
>
> Use a DOMAIN to specify the type and then convert the types of the current
> fields to use this DOMAIN.
>
>
>
> >
> > I am using Delphi 5/6 and when I set a number like 2,50 into a Double
> > variable and send it to IB
> > database store 2,499999999999999999999999999999999999999999....as
possible.
> >
> > I need that the IB store 2,50 or at least 2,4999999 !
> >
> > I need to use FLOAT for compatibility !
> > I try to truncate it in application but there is no effect !
> >
> > Thanks in advance
> >
> > Best Regards
> >
> > Jed
> >
> > ""Leyne, Sean"" <sleyne@...> escreveu na mensagem
> > news:66187D861C1747499BE1365B74E0369120CBA8@......
> > > Jed,
> > >
> > > > I need to use float for all numeric datatype. But I need only
> > > > 6 decimal digits.
> > >
> > > But then it sounds like you want a exact precision/numeric data type,
> > > like DECIMAL(18,6)
> > >
> > >
> > > Sean
>
> --
> Raymond Kennington
> Programming Solutions
> W2W Team B
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 23
> Date: Mon, 27 Jan 2003 17:18:27 +0900
> From: KIMURA Meiji <Meiji_Kimura@...>
> Subject: PROCEDURE_ID of RDB$PROCEDURES
>
> Hi, All.
>
> I create/delete stored procedure at frequent intervals.
> PROCEDURE_ID of RDB$PROCEDURES is incremented when creating stored
> procedure, but if it delete, the ID will be reused.
>
> When PROCEDURE_ID exceed its limit(== 2^15), I cannot create a new
> stored procedure.
>
> Is there any idea to avoid this situation ?
>
> Regards,
>
>
> --
> KIMURA Meiji mailto:Meiji_Kimura@...
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 24
> Date: Mon, 27 Jan 2003 19:19:23 +1100
> From: "Alan McDonald" <alan@...>
> Subject: RE: Information on serious issues with different ODBC drivers
>
> As Aage says, the Gemini driver does say that it is for Firebird. Don't
know
> where you got your info.
>
> On the other hand, I too have found that the gemini driver is the one
which
> gives me least problems but I do not as yet use it in production. I still
> use the Intersolv driver for dialect 1 databases. I have recently written
to
> gemini to ask a few questions. I only want to use it for connection with
ASP
> web pages. I don't know any other way to connect using ASP than with an
ODBC
> driver, if there is another I would love to know.
>
> What are you using the ODBC driver for - I mean to connect what client?
>
> Alan
>
> -----Original Message-----
> From: mgastde <michael.gast@...> [mailto:michael.gast@...]
> Sent: Monday, 27 January 2003 5:47 AM
> To: ib-support@yahoogroups.com
> Subject: [ib-support] Information on serious issues with different ODBC
> drivers
>
>
> Hi,
>
> I've examined different serious problems with different ODBC drivers
> available for Firebird.
>
> Environment on the server:
> Suse Linux 7.1
> Firebird 1.00 and 1.02
>
> Environment on the client:
> Windows NT 4.0 SP5 or SP6 or Windows 2000 SP 2 or Windows XP
> gds32.dll as delivered with the respective Firebird package for
> Windows.
>
> 1. Easysoft ODBC driver:
> Easysoft ODBC driver in different versions with and without support
> for unicode. I've tested version 1.1.63 and the most recent versions
> of the driver downloaded two weeks ago.
> This driver has the following issue:
> After rolling back a transaction with a select operation in it, the
> counter for the OIT does not rise any more. A few weeks later, the
> database starts to slow down and to produce irregular error messages.
> The difference between OIT and the actual transaction number (OT) is
> in this point of time roundabout 700000 (sweep is disabled due to
> problems with a corrupted database when the server shuts down while
> the sweep runs).
> I've reported the error to Easysoft and they could confirm this error
> running the driver against a Firebird database (and using a small test
> database i've created). They state that the error does not occur with
> the open source version of Interbase. I've not checked this.
> But unfortunately Easysoft adds:
> 1. We are the only customer with this problem.
> 2. They classify this issue as a minor bug and they probably (!) will
> fix it in one of the future releases.
> That don't help us, as we use Firebird in a productive environment and
> me must find a solution in the near future.
>
> 2. XTG ODBC driver:
> This driver has exactly the same issue as the Easysoft driver.
>
> 3. IB-Phoenix open source ODBC driver:
> This driver does not have the issue I've noticed with the Easysoft or
> the XTG drivers. But I did not find a possibility to set the correct
> character set. In addition, i cannot update or insert any data in my
> test database (i did not check delete) using AQUERYX from XTG as
> frontend and one of the snapshots builds as ODBC driver. Using the
> release version of Juli 2001 i can modify my data, but i cannot set
> the proper character set. So this driver actually is not usefull for
> our german environment.
>
> 4. Gemini ODBC driver for Interbase and Firebird:
> This driver does not have the described issue and it works fine with
> different character sets. After doing a lot of testing, it seems for
> me, that the Gemini ODBC driver is the only one working correctly. But
> the last build available is version 2.1 dated to January 2001 and it
> is not approved to work with Firebird 1.0.0 and Firebird 1.0.2.
>
> There are still some questions:
> * Are we really the only one with this problem?
> * Does anyone use the Gemini driver in a productive environment? Are
> there any problems?
> * Is it planned to add character set support to the open source
> driver?
> * Does anyone else have the problem with writing operations using the
> open source driver?
>
> Best regards
> Michael Gast
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 25
> Date: Mon, 27 Jan 2003 00:52:04 -0800 (PST)
> From: Zakir Mahomedy <zmahomedy@...>
> Subject: Re: Information on serious issues with different ODBC drivers
>
>
> I also have looked at alot of odbc drivers for firebird for my product. I
found the open source drivers to be incomplete.
> The Gemini driver works well with firebird. The only problem i found thus
far was when using the TCP/IP setting in a conection string, it would not
return any odbc errors to the client.
> I sent the bug report to Gemini and they rectified the problem.
> "mgastde <michael.gast@...>" <michael.gast@...> wrote:Hi,
>
> I've examined different serious problems with different ODBC drivers
> available for Firebird.
>
> Environment on the server:
> Suse Linux 7.1
> Firebird 1.00 and 1.02
>
> Environment on the client:
> Windows NT 4.0 SP5 or SP6 or Windows 2000 SP 2 or Windows XP
> gds32.dll as delivered with the respective Firebird package for
> Windows.
>
> 1. Easysoft ODBC driver:
> Easysoft ODBC driver in different versions with and without support
> for unicode. I've tested version 1.1.63 and the most recent versions
> of the driver downloaded two weeks ago.
> This driver has the following issue:
> After rolling back a transaction with a select operation in it, the
> counter for the OIT does not rise any more. A few weeks later, the
> database starts to slow down and to produce irregular error messages.
> The difference between OIT and the actual transaction number (OT) is
> in this point of time roundabout 700000 (sweep is disabled due to
> problems with a corrupted database when the server shuts down while
> the sweep runs).
> I've reported the error to Easysoft and they could confirm this error
> running the driver against a Firebird database (and using a small test
> database i've created). They state that the error does not occur with
> the open source version of Interbase. I've not checked this.
> But unfortunately Easysoft adds:
> 1. We are the only customer with this problem.
> 2. They classify this issue as a minor bug and they probably (!) will
> fix it in one of the future releases.
> That don't help us, as we use Firebird in a productive environment and
> me must find a solution in the near future.
>
> 2. XTG ODBC driver:
> This driver has exactly the same issue as the Easysoft driver.
>
> 3. IB-Phoenix open source ODBC driver:
> This driver does not have the issue I've noticed with the Easysoft or
> the XTG drivers. But I did not find a possibility to set the correct
> character set. In addition, i cannot update or insert any data in my
> test database (i did not check delete) using AQUERYX from XTG as
> frontend and one of the snapshots builds as ODBC driver. Using the
> release version of Juli 2001 i can modify my data, but i cannot set
> the proper character set. So this driver actually is not usefull for
> our german environment.
>
> 4. Gemini ODBC driver for Interbase and Firebird:
> This driver does not have the described issue and it works fine with
> different character sets. After doing a lot of testing, it seems for
> me, that the Gemini ODBC driver is the only one working correctly. But
> the last build available is version 2.1 dated to January 2001 and it
> is not approved to work with Firebird 1.0.0 and Firebird 1.0.2.
>
> There are still some questions:
> * Are we really the only one with this problem?
> * Does anyone use the Gemini driver in a productive environment? Are
> there any problems?
> * Is it planned to add character set support to the open source
> driver?
> * Does anyone else have the problem with writing operations using the
> open source driver?
>
> Best regards
> Michael Gast
>
>
> Yahoo! Groups SponsorADVERTISEMENT
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
>
> |
>
>
> ---------------------------------
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up now
>
> [Non-text portions of this message have been removed]
>
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>