eating variables

From: "HIDING" <hiding(at)freemail(dot)hu>
To: "Org Pgsql-Odbc(at)Postgresql(dot)" <pgsql-odbc(at)postgresql(dot)org>
Subject: eating variables
Date: 2003-10-13 16:35:47
Message-ID: AFECLHMEFAKPEHDLCBPGCEMKCLAA.hiding@freemail.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hello!

first: Thanks to Hiroshi Inoue for the interest and help

Sorry for the slow answer. Here is an example from the

Cygwin window:

ERROR: Function to_fck(numeric) does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
LOG: statement: SELECT
to_fck(gcpf_topics.topic_hidden),gcpf_topics.topic_name,
gcpf_topics.topic_no_messages ,
gcpf_topics.topic_start_date,
gcpf_topics.topic_id,gcp_users.user_nick
as user_name
FROM gcpf_topics,gcp_users
where gcpf_topics.user_id=gcp_users.user_id
order by topic_start_date desc

to_fck() is a non-existing function - a fantasy name :)
Using latest postgresql ODBC from Smalltalk, I got a cursor with NO ERROR
(!)
and no rows in it. So I've got an empty result_table but no error
message at all. My application this way believes that everything is fine and
there are no rows in the reply.

Running the same from PGADMIN III the result is error, which is the right
behavior.

ERROR: Function to_fck(numeric) does not exist
Unable to identify a function that satisfies the given argument types
You may need to add explicit typecasts

Smalltalk uses ODBC3 interface.
ODBC subsystem details:
OS: XP Hungarian, SP1
App. dev tool: IBM VisualAge Smalltalk 5.5.2 using built in ODBC connector
(ODBC3 compliant)
Win XP ODBC manager: many components with different versions.
odbccp32.dll 3.520.9030.0
odbcint.dll 3.520.7713.0
odbc32.dll 3.520.9030.0
odbccr32.dll 3.520.9030.0
odbccu32.dll 3.520.9030.0
odbccp32.dll 3.520.7713.0
odbcad32.exe 3.520.9030.0
thanks
Robert

Browse pgsql-odbc by date

  From Date Subject
Next Message Hiroshi Inoue 2003-10-13 23:57:10 Re: ODBC Bug. Bad numeric input format ?
Previous Message George A.J 2003-10-13 03:56:47 ODBC Bug. Bad numeric input format ?