Thread View: borland.public.interbase.sql
5 messages
5 total messages
Started by Rabatscher Michael
Wed, 21 May 2008 07:18
SQL error -104 and double precission fields
Author: Rabatscher Michael
Date: Wed, 21 May 2008 07:18
Date: Wed, 21 May 2008 07:18
13 lines
1414 bytes
1414 bytes
Hello! I'm using the TIBSQL component to execute queries on a firebird database (server is currently 2.0). On one table I have to "DOUBLE PRECISION" fields containing an start and endpoint in seconds. Every time I want to query something from this table using the TIBSQL component I always get the exception with code error -104. TIBQuery does not fire this exception. Has anyone experienced this error too? kind regards Mike
Re: SQL error -104 and double precission fields
Author: Rabatscher Michael
Date: Wed, 21 May 2008 08:10
Date: Wed, 21 May 2008 08:10
8 lines
1150 bytes
1150 bytes
The exact wording of the exception (EIBInterbaseError) is: Dynamic SQL Error SQL error code = -104 as approximate floating-point values in SQL dialect 1, but as 64-bit. kind Regards Mike
Re: SQL error -104 and double precission fields
Author: Karol Bieniaszewski
Date: Wed, 21 May 2008 08:35
Date: Wed, 21 May 2008 08:35
19 lines
1535 bytes
1535 bytes
Uzytkownik "Rabatscher Michael" <m.rabatscher@tom-medical.com> napisal w wiadomosci news:4833d985$1@newsgroups.borland.com... > The exact wording of the exception (EIBInterbaseError) is: > > > Dynamic SQL Error SQL error code = -104 as approximate floating-point > values in SQL dialect 1, but as 64-bit. > > kind Regards > Mike First this is a Interbase not Firebird group secont TIBQuery as you can see have IB in name and can not work with new Firebird 2.0 also may be - problem is with Firebird 2.0 now is Firebird 2.1 - try this version Karol Bieniaszewski
Re: SQL error -104 and double precission fields
Author: Karol Bieniaszewski
Date: Wed, 21 May 2008 10:57
Date: Wed, 21 May 2008 10:57
15 lines
1383 bytes
1383 bytes
Uzytkownik "Rabatscher Michael" <m.rabatscher@tom-medical.com> napisal w wiadomosci news:4833d985$1@newsgroups.borland.com... > The exact wording of the exception (EIBInterbaseError) is: > > > Dynamic SQL Error SQL error code = -104 as approximate floating-point > values in SQL dialect 1, but as 64-bit. > > kind Regards > Mike why you use dialect 1 not 3?? Karol Bieniaszewski
Re: SQL error -104 and double precission fields
Author: Rabatscher Michael
Date: Fri, 23 May 2008 09:01
Date: Fri, 23 May 2008 09:01
7 lines
1213 bytes
1213 bytes
> > why you use dialect 1 not 3?? I use dialect 3 (at tried to set this propert explicitly) but the error is still the same. kind regards Mike
Thread Navigation
This is a paginated view of messages in the thread with full content displayed inline.
Messages are displayed in chronological order, with the original post highlighted in green.
Use pagination controls to navigate through all messages in large threads.
Back to All Threads