🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.interbase.sql
Article #8

SQL error -104 and double precission fields

#8
From: Rabatscher Michael
Date: Wed, 21 May 2008 07:18
13 lines
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
Technical Details
Message-ID: <4833cd44@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!nx02.iad01.newshosting.com!newshosting.com!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!news.isoc.lu!newsgroups.borland.com!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Thread: 114a0e,3e3c5fd1eef62ed0,start
X-Google-Attributes: gid114a0e,domainid0,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
Date: Wed, 21 May 2008 09:18:07 +0200
From: Rabatscher Michael <m.rabatscher@tom-medical.com>
User-Agent: Thunderbird 2.0.0.14 (Windows/20080421)
MIME-Version: 1.0
Newsgroups: borland.public.interbase.sql
Subject: SQL error -104 and double precission fields
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 81.223.122.27
Message-ID: <4833cd44@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1211354436 81.223.122.27 (21 May 2008 00:20:36 -0700)
Lines: 13
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!nx02.iad01.newshosting.com!newshosting.com!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!news.isoc.lu!newsgroups.borland.com!not-for-mail